2009 New Zealand National Championships

From 19 Feb 2009 to 25 Feb 2009

New Zealand ----
New Zealand
Napier Sailing Club

2009 Regata Nazionale, Pietra Bianca

From 22 Feb 2009 to 24 Feb 2009

Italy ----
Italy
Circolo Velico Pietrabianca
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 < '2009-3-1' AND puntual_date >= '2009-2-1') AND (published = 'YES') ORDER BY puntual_date,R.id