Jockey rides today

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.

This entry was posted on Saturday, August 6th, 2011 at 10:22 am. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.