2008 Athens 420 Training Camp

From 02 Feb 2008 to 10 Feb 2008

Greece ----
Greece
Olympic Sailing Centre - Marina Delta Falirou

2008 Semana de Mar del Plata

From 03 Feb 2008 to 10 Feb 2008

Argentina ----
Argentina
Yacht Club Argentino

2008 Sail Auckland

From 16 Feb 2008 to 19 Feb 2008

New Zealand ----
New Zealand
Kohimarama Yacht Club
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-3-1' AND puntual_date >= '2008-2-1') AND (published = 'YES') ORDER BY puntual_date,R.id