2008 National d'automne

From 29 Oct 2008 to 02 Nov 2008

France ----
France
Cercle de la Voile de Bordeaux

2008 Campeonato Argentino

From 01 Nov 2008 to 01 Nov 2008

Argentina ----
Argentina
Club Náutico Olivos

2008 XX Gran Premi Principat d'Andorra GrandValira

From 08 Nov 2008 to 09 Nov 2008

Spain ----
Spain
Club Nautic El Masnou

2008 1st Asia and Oceania Coaches Clinic

From 21 Nov 2008 to 24 Nov 2008

Singapore ----
Singapore
Singapore National Sailing Centre

2008 Chilean National Championships

From 22 Nov 2008 to 23 Nov 2008

Chile ----
Chile
Club de Yates de Algarrobo
SELECT DISTINCT R.id FROM gerace R INNER JOIN genericelements GE ON GE.id = R.id_genericelement INNER JOIN racecalendar RC ON RC.id_gerace = R.id LEFT JOIN sailclass2gerace SC2GER ON SC2GER.id_gerace = R.id WHERE (puntual_date < '2008-12-1' AND puntual_date >= '2008-11-1') AND (published = 'YES') ORDER BY puntual_date,R.id