All India 420 Class Championship 2017

From 24 May 2017 to 28 May 2017

India ----
India
Indian Naval Watermanship Training Centre (Mumbai)

2017 German Final Qualification Event

From 25 May 2017 to 28 May 2017

Germany ----
Germany
Yachtclub Warnow

2017 Campione Univela Trophy - 420 Four Nations Cup

From 26 May 2017 to 28 May 2017

Italy ----
Italy
Campione Univela

2017 RNSYS Spring Dinghy Regatta

From 27 May 2017 to 28 May 2017

Canada ----
Canada
Royal Nova Scotia Yacht Squadron
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 < '2017-6-1' AND puntual_date >= '2017-5-1') AND (published = 'YES') ORDER BY puntual_date,R.id