Shamardal is of course at stud, but his progeny have a decent strike rate, as such some decently priced winners can be thrown up when they are racing under the right conditions.

How to find progeny of Shamardal racing at Ascot today, where their sire won the St James Palace stakes (well, it was run at York that year, to be exact)…?

It’s a simple query in Smartform, as follows:

>select name, course, scheduled_time from daily_races join daily_runners using (race_id) where meeting_date=CURDATE() and sire_name = “Shamardal”;

The results, returned in less than a second, are:

Alnashmy | Ascot     | 2011-07-23 15:15:00
Below Zero | Ascot     | 2011-07-23 15:50:00

Both are decent prices, both racing over 1 mile and 7 furlongs respectively (good trips for their sire), so good luck to them.