2017 Applecross Cup

From 18 Mar 2017 to 19 Mar 2017

Australia ----
Australia
South of Perth Yacht Club

2017 British 420 Inland Championships

From 18 Mar 2017 to 19 Mar 2017

Great Britain ----
Great Britain
Rutland Sailing Club

420 Training Camp - Lake Garda

From 19 Mar 2017 to 22 Mar 2017

Italy ----
Italy
Fraglia Vela Riva
Italy ----
Italy
Fraglia Vela Riva

2017 Regata Nazionale Classe 420 - Event 1

From 23 Mar 2017 to 26 Mar 2017

Italy ----
Italy
Fraglia Vela Riva

Campeonata San Isidro Labrador 2017

From 24 Mar 2017 to 02 Apr 2017

Argentina ----
Argentina
Club Nautico San Isidro

2017 Interligue 1 Atlantique - YC Crozon

From 25 Mar 2017 to 26 Mar 2017

France ----
France
Centre Nautique Crozon Morgat

2017 Interligue 1 Sud - Marseille

From 25 Mar 2017 to 26 Mar 2017

France ----
France
Cercle de Voile de Marseillan

2017 Interligue 1 Nord - Moisson Lavacourt

From 25 Mar 2017 to 26 Mar 2017

France ----
France
Cercle de Voile de Moisson-Lavacourt
New Zealand ----
New Zealand
Queen Charlotte 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 < '2017-4-1' AND puntual_date >= '2017-3-1') AND (published = 'YES') ORDER BY puntual_date,R.id