KFC - Tunku Laxaman / NSC Open Regatta

From 01 Jun 2012 to 03 Jun 2012

2012 Buzios Sailing Week

From 07 Jun 2012 to 10 Jun 2012

2012 Austrian 420 National Championship

From 07 Jun 2012 to 10 Jun 2012

2012 Intervela

From 09 Jun 2012 to 10 Jun 2012

Italy ----
Italy
Fraglia Vela Riva

KFC - Putrajaya Sailing Regatta

From 15 Jun 2012 to 17 Jun 2012

2012 Kieler Woche

From 21 Jun 2012 to 24 Jun 2012

Germany ----
Germany
Kieler Yacht Club

KFC - Pahang Open Regatta

From 21 Jun 2012 to 24 Jun 2012

5th European 420 Coaches Seminar

From 25 Jun 2012 to 28 Jun 2012

Russia ----
Russia
Yacht Club Khimik

2012 Nieuwpoortweek Regatta

From 30 Jun 2012 to 04 Jul 2012

Belgium ----
Belgium
Koninklijke Yacht Club Nieuwpoort
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 < '2012-7-1' AND puntual_date >= '2012-6-1') AND (published = 'YES') ORDER BY puntual_date,R.id