Betwise Blog
Betwise news, analysis and automatic betting info

Jockey rides today

By colin on Saturday, August 6th, 2011

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.

Leave a comment