2009 420 and 470 Junior International Regatta

From 30 Jul 2009 to 04 Aug 2009

2009 420 World Championships

From 27 Jul 2009 to 05 Aug 2009

Italy ----
Italy
Riva Del Garda

2009 420 Junior European Championships

From 08 Aug 2009 to 16 Aug 2009

Hungary ----
Hungary
Lake Balaton

2009 GBR National Championships

From 23 Aug 2009 to 28 Aug 2009

----
Mount Batten Centre
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-9-1' AND puntual_date >= '2009-8-1') AND (published = 'YES') ORDER BY puntual_date,R.id