2009 59th Intervela

From 01 Jul 2009 to 04 Jul 2009

Italy ----
Italy
Fraglia Vela Riva

2009 Flanders Youth Regatta

From 04 Jul 2009 to 08 Jul 2009

Belgium ----
Belgium
Nieuwpoort

2009 ISAF Youth World Championships

From 09 Jul 2009 to 18 Jul 2009

2009 Coupe Nationale

From 14 Jul 2009 to 18 Jul 2009

France ----
France
Club Nautique de Port Blanc

2009 420 World Championships

From 27 Jul 2009 to 05 Aug 2009

Italy ----
Italy
Riva Del Garda

2009 420 and 470 Junior International Regatta

From 30 Jul 2009 to 04 Aug 2009

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