2013 Kereked-Egis Kupa

From 31 May 2013 to 02 Jun 2013

Hungary ----
Hungary
Kereked Vitorlas Klub

420er EM / WMA Finale 2013

From 30 May 2013 to 02 Jun 2013

Germany ----
Germany
Lübecker Yacht Club

2013 Indian 420 Coastal National Championships

From 04 Jun 2013 to 11 Jun 2013

India ----
India
Royal Madras Yacht Club

United 4 (1)

From 04 Jun 2013 to 04 Jul 2013

Netherlands ----
Netherlands
International Sailing Centre Medemblik

2013 Summer Regatta

From 09 Jun 2013 to 10 Jun 2013

Netherlands ----
Netherlands
Braassemermeer Watersport Vereniging

2013 Singapore National 420 Championships

From 19 Jun 2013 to 23 Jun 2013

Singapore ----
Singapore
Singapore National Sailing Centre

2013 Diakolimpia

From 21 Jun 2013 to 23 Jun 2013

Hungary ----
Hungary
Zanka Uj Nemzedek Kozpont

2013 Kieler Woche

From 27 Jun 2013 to 30 Jun 2013

Germany ----
Germany
Kieler Yacht Club

2013 Nieuwpoortweek Regatta

From 29 Jun 2013 to 03 Jul 2013

Belgium ----
Belgium
Koninklijke Yacht Club Nieuwpoort

2013 Sail Mooloolaba

From 29 Jun 2013 to 30 Jun 2013

Australia ----
Australia
Mooloolaba Yacht Club
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 < '2013-7-1' AND puntual_date >= '2013-6-1') AND (published = 'YES') ORDER BY puntual_date,R.id