For those who like analysing jockeys by meeting or playing spreads on jockey rides, Smartform is a great place to start your analysis.
The following query gives us all declared rides ordered by jockey with the number of mounts from highest to lowest:
>select distinct jockey_name, count(jockey_name) AS ‘rides’ from daily_runners join daily_races using (race_id) where meeting_date=CURDATE() group by jockey_name order by count(jockey_name) DESC;
For today’s racing that gives us:
+——————–+————-+
| jockey_name | rides |
+——————–+————-+
| T P Queally | 10 |
| Jim Crowley | 10 |
| S Sanders | 8 |
| K Fallon | 7 |
| J P Spencer | 7 |
| B McHugh | 7 |
| D Nolan | 7 |
| G Baker | 7 |
Now we can drill on in on the mounts of any jockey we are interested in with an individual, one-line jockey query, using any combination of over 100 variables to analyse.