SELECT a.HIPPODROME, b.PRIX_LONG, a.PERMALIEN, b.PERMALIEN AS PERMALIEN_COURSE, CAST(b.HORAIRE AS NVARCHAR(5)) AS HORAIRE, b.DISTANCE, b.GAIN, b.AGE, b.POIDS, b.SEXE, b.CATEGORIE, b.CONDITIONS FROM T_REUNION a INNER JOIN T_COURSE b ON a.ID_REUNION = b.ID_REUNION AND b.PUBLIER = 1 AND b.SUPPR = 0 WHERE a.PERMALIEN = 'VICHY' AND DATE_REUNION >= '15/08/2021' AND DATE_REUNION < '16/08/2021'AND a.PUBLIER = 1 AND a.ARCHIVER = 0 AND a.SUPPR = 0 ORDER BY b.HORAIRE;

AFAC France > Race

15 August 2021 - VICHY

Schedule

Run

Age

Weight

Sex

Distance

Gain

Category

Details

17:17

PRIX DE L'IFAHR - ROYAL CAVALRY OF OMAN (TS, 3 ans)
COURSE A CONDITIONS


3 ans


58kg


TS

1400


16000

COURSE A CONDITIONS

Distance : 1400
Horaire : 17:17

Plus d'information

18:25

PRIX DE L'ACA (TS, 4 ans et plus)
COURSE A CONDITIONS


4 ans et +


56kg


TS

2000


14000

COURSE A CONDITIONS

Distance : 2000
Horaire : 18:25

Plus d'information


GO BACK