Posts Tagged ‘Shamardal’

Shamardal at Ascot day 2

Sunday, July 24th, 2011

So not much luck for Shamardal’s progeny yesterday – neither of his runners were placed.

Let’s see if the overall impressive strike rate of this sire shows through today, running the same query as previously in Smartform in order to find any qualifying runners.  This time we’ll add in Smartform’s forecast price field.

mysql> select forecast_price, name, course, scheduled_time from daily_races join daily_runners using (race_id) where meeting_date=CURDATE() and sire_name = “Shamardal”;
+—————–+————–+——–+————————–+
| forecast_price | name           | course | scheduled_time           |
+—————–+————–+——–+————————–+
| 5/2                    | Burj Nahar  | Ascot  | 2011-07-24 15:25:00   |
+—————–+————–+——–+————————–+
1 row in set (0.88 sec)

So it’s just Burj Nahar in the 3.25 – apparently fancied a bit more by the market than yesterday’s contenders.

Shamardal at Ascot

Saturday, July 23rd, 2011

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.