2011 Weymouth and Portland International Regatta

From 31 Jul 2011 to 13 Aug 2011

Great Britain ----
Great Britain
Weymouth and Portland National Sailing Academy

International German 420 Youth Championship 2011

From 30 Jul 2011 to 05 Aug 2011

2011 Intervela

From 02 Aug 2011 to 05 Aug 2011

Italy ----
Italy
Fraglia Vela Riva

2011 420 Junior European Championships

From 07 Aug 2011 to 15 Aug 2011

Belgium ----
Belgium
Koninklijke Yacht Club Nieuwpoort

2011 IBI British National 420 Championships

From 20 Aug 2011 to 27 Aug 2011

Great Britain ----
Great Britain
Pwllheli Sailing Club

2011 Italian 420 National Championships

From 21 Aug 2011 to 22 Aug 2011

Italy ----
Italy
Circolo Velico Ravennate
Austria ----
Austria
Segelzentrum - Der Neusiedler See
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 < '2011-9-1' AND puntual_date >= '2011-8-1') AND (published = 'YES') ORDER BY puntual_date,R.id