Trainers with runners at Sandown
By colin on Saturday, April 28th, 2012Sandown today represents one of the more unusual meetings on the racing calendar, with its combination of top class jump racing mixed with top class flat racing. As such, we see Flat training giants of the like of Henry Cecil rubbing shoulders with their jumps equivalents, such as Paul Nicholls.
Using Smartform we can identify exactly which trainers have runners at Sandown and produce various statistics off the back of this. This sort of query is often a useful prerequisite to working out the relative strike rate of each trainer with runners, for example.
Here, however, we will get the trainer names and show a simple count of the number of runners for each by using the group function. We’re interested in a count from those trainers fielding the largest team to those trainers fielding only one runner.
This can be done as follows:
mysql> select count(trainer_id) AS ‘#Runners’, trainer_name AS “Trainer” from daily_runners join daily_races using (race_id) where meeting_date=CURDATE() and course=”Sandown” group by trainer_name order by count(trainer_id) DESC;
| #Runners | Trainer |
|---|---|
| 6 | P F Nicholls |
| 5 | N J Henderson |
| 5 | D Pipe |
| 4 | P J Hobbs |
| 3 | J H M Gosden |
| 3 | Sir H R A Cecil |
| 3 | S bin Suroor |
| 3 | Miss V Williams |
| 2 | W Greatrex |
| 2 | D T Hughes |
| 2 | N A Twiston-Davies |
| 2 | A M Balding |
| 2 | M J Attwater |
| 2 | G L Moore |
| 2 | D McCain Jnr |
| 2 | Evan Williams |
| 1 | C G Cox |
| 1 | N Quinlan |
| 1 | Ian Williams |
| 1 | R C Guest |
| 1 | S Gollings |
| 1 | John Berry |
| 1 | M H Tompkins |
| 1 | B G Powell |
| 1 | C J Mann |
| 1 | T T Clement |
| 1 | A W Carroll |
| 1 | R Hannon |
| 1 | W S Kittow |
| 1 | Simon Earle |
| 1 | E F Vaughan |
| 1 | Miss H C Knight |
| 1 | D K Ivory |
| 1 | A King |
| 1 | M Keighley |
| 1 | Mrs L Wadham |
| 1 | J P Ferguson |
| 1 | Dr R D P Newland |
| 1 | E J Alston |
| 1 | Nick Williams |
| 1 | George Baker |
| 1 | R Lee |
| 1 | S Kirk |
| 1 | N J Gifford |
| 1 | M Appleby |
| 1 | A P O’Brien |
| 1 | W Jarvis |
| 1 | J W Mullins |
| 1 | P Phelan |
| 1 | Jamie Snowden |
| 1 | Dr J D Scargill |
| 1 | Mrs Mary Hambro |
| 1 | Jonjo O’Neill |
| 1 | R Varian |
| 1 | B Ellison |
| 1 | R Charlton |
| 1 | J R Jenkins |
| 1 | G McPherson |
| 1 | E De Giles |
| 1 | M Scudamore |
| 1 | Miss E C Lavelle |
| 1 | M R Hoad |
| 1 | R H Buckler |
63 rows in set (0.09 sec)
So no surprise that the top stables in both flat and jumps are best represented today, and some testament to what a classy day’s racing Whitbread day is (though now appears to be bet365 day?).
As for the trainers mentioned, on the Flat Henry Cecil weighs in with an impressive 14 day strike rate (according to Smartform calculations) of 24%, whilst John Gosden and Saeed Bin Suroor are languishing on 8% and 7% respectively.
Over the jumps, Paul Nicholls’ strike rate is 18% in the last 14 days and Nicky Henderson’s is an impressive 26% from 38 runners.