OZmium Sports Betting and Horse Racing Forums - track conditions

OZmium Sports Betting and Horse Racing Forums (http://forums.ozmium.com.au/index.php)

- Horse Race Betting Systems (http://forums.ozmium.com.au/forumdisplay.php?f=10)

- - track conditions - records (http://forums.ozmium.com.au/showthread.php?t=21437)

track conditions - records

hoping someone may be able to save me a bit of time - I have a bit of a problem regarding the recording of venue track conditions over the last year or so - I record by Unitab venue codes (BR, CR etc) & also by track name.

If anyone with the relevant records would be able to provide a list of 'venue - track conditions' for the last 12 months it would be most appreciated.

Sure, do you want every day or just Saturdays, Metro only or the lot?

Like this? (example for last monday)

(format can be anyway you want, it's a simple SQL query)

Code:


 rcdate     raceno track            state going
 ========== ====== ================ ===== =====
 2011-04-18      1 GRAFTON          NSW   H
 2011-04-18      2 GRAFTON          NSW   H
 2011-04-18      3 GRAFTON          NSW   H
 2011-04-18      4 GRAFTON          NSW   H
 2011-04-18      5 GRAFTON          NSW   H
 2011-04-18      6 GRAFTON          NSW   H
 2011-04-18      7 GRAFTON          NSW   H
 2011-04-18      8 GRAFTON          NSW   H
 2011-04-18      1 KILMORE          Vic   D
 2011-04-18      2 KILMORE          Vic   D
 2011-04-18      3 KILMORE          Vic   D
 2011-04-18      4 KILMORE          Vic   D
 2011-04-18      5 KILMORE          Vic   D
 2011-04-18      6 KILMORE          Vic   D
 2011-04-18      7 KILMORE          Vic   D
 2011-04-18      8 KILMORE          Vic   D
 2011-04-18      9 KILMORE          Vic   D
 2011-04-18      1 NARROMINE        NSW   D
 2011-04-18      2 NARROMINE        NSW   D
 2011-04-18      3 NARROMINE        NSW   D
 2011-04-18      4 NARROMINE        NSW   D
 2011-04-18      5 NARROMINE        NSW   D
 2011-04-18      6 NARROMINE        NSW   D
 2011-04-18      7 NARROMINE        NSW   (NULL)

Hi Jazzy, I am after every day every meet for the last 12 months & that format would be great

many thanks