2016 Italian National Ranking Event

From 02 Jun 2016 to 05 Jun 2016

Italy ----
Italy
Circolo Velico Ravennate

2016 Italian 420 National Championships

From 02 Jun 2016 to 05 Jun 2016

Italy ----
Italy
Circolo Velico Ravennate

2016 Aon National Youth Clinic 1

From 03 Jun 2016 to 04 Jun 2016

New Zealand ----
New Zealand
Murrays Bay Sailing Club

2016 Grand Prix CSCN

From 04 Jun 2016 to 05 Jun 2016

Czech Republic ----
Czech Republic
Yacht Club Cere

2016 420 Oceania Regatta

From 05 Jun 2016 to 06 Jun 2016

New Zealand ----
New Zealand
Murrays Bay Sailing Club

2016 International Youth Cup - Event 1

From 08 Jun 2016 to 12 Jun 2016

Russia ----
Russia
Yacht Club Strelna

2016 Singapore National Sailing Championship

From 09 Jun 2016 to 12 Jun 2016

Singapore ----
Singapore
Singapore National Sailing Centre

2016 Wickford Regatta

From 11 Jun 2016 to 12 Jun 2016

USA ----
USA
Wickford Yacht Club

2016 SP and Tyrolean 420 Youth Championship

From 11 Jun 2016 to 12 Jun 2016

Austria ----
Austria
Segelclub TWV Achensee

2016 Csoki Cup

From 17 Jun 2016 to 19 Jun 2016

Hungary ----
Hungary
Spartacus Sailing 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 < '2016-7-1' AND puntual_date >= '2016-6-1') AND (published = 'YES') ORDER BY puntual_date,R.id