2017 420 South American Championship

From 09 Apr 2017 to 15 Apr 2017

Uruguay ----
Uruguay
Yacht Club Uruguayo

2017 Campeonato de Espana Clase 420

From 09 Apr 2017 to 15 Apr 2017

Spain ----
Spain
Real Club Nautico de Vigo

2017 Izola Spring Cup

From 13 Apr 2017 to 16 Apr 2017

Slovenia ----
Slovenia
Yacht Club Burja Izola

2017 Regata Nazionale Classe 420 - Event 2

From 14 Apr 2017 to 17 Apr 2017

Italy ----
Italy
Yacht Club Cagliari

420 Class @ Easter Optimist Meeting

From 14 Apr 2017 to 15 Apr 2017

Italy ----
Italy
Fraglia Vela Riva

2017 Easter Regatta

From 15 Apr 2017 to 16 Apr 2017

Australia ----
Australia
Mandurah Offshore Fishing and Sailing Club
France ----
France
Yacht Club des Sablettes

2017 Greek 420 National Championship

From 18 Apr 2017 to 22 Apr 2017

Greece ----
Greece
Paros Nautical Club

2017 ISA Youth Pathway National Championships

From 20 Apr 2017 to 23 Apr 2017

Great Britain ----
Great Britain
Ballyholme Yacht Club

420 Class Coaches and Sailor Clinic - Bulgaria

From 21 Apr 2017 to 25 Apr 2017

Bulgaria ----
Bulgaria
Yacht Club Port Bourgas
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-5-1' AND puntual_date >= '2017-4-1') AND (published = 'YES') ORDER BY puntual_date,R.id