2014 British 420 Winter Championships

From 08 Mar 2014 to 09 Mar 2014

Great Britain ----
Great Britain
Pwllheli Sailing Club

2014 Adelaide International Regatta

From 08 Mar 2014 to 10 Mar 2014

Australia ----
Australia
Adelaide Sailing Club

2014 New Zealand National Championships

From 13 Mar 2014 to 16 Mar 2014

New Zealand ----
New Zealand
Evans Bay Yacht Club and Motor Club

Regata Nazionale 420 - Event 1

From 14 Mar 2014 to 16 Mar 2014

Italy ----
Italy
Circolo ASD Pescatori Sportivi Santa Marinella

2014 Athens Eurolymp Week

From 14 Mar 2014 to 20 Mar 2014

Greece ----
Greece
Olympic Sailing Centre - Marina Delta Falirou
Singapore ----
Singapore
Singapore National Sailing Centre

2014 British 420 Spring Championships

From 29 Mar 2014 to 30 Mar 2014

Great Britain ----
Great Britain
Hayling Island 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 < '2014-4-1' AND puntual_date >= '2014-3-1') AND (published = 'YES') ORDER BY puntual_date,R.id