2016 Interligue 420 Trebeurden

From 19 Mar 2016 to 20 Mar 2016

France ----
France
Ecole de Voile de Trebeurden

2016 Spanish 420 National Championships

From 20 Mar 2016 to 26 Mar 2016

Spain ----
Spain
Club Nautico El Balis

2016 420 South American Championships

From 23 Mar 2016 to 27 Mar 2016

Chile ----
Chile
Club de Yates de Algarrobo

2016 Izola Spring Cup

From 24 Mar 2016 to 27 Mar 2016

Slovenia ----
Slovenia
Yacht Club Burja Izola

2015/2016 Southern Charter Grand Slam Series Final

From 25 Mar 2016 to 28 Mar 2016

South Africa ----
South Africa
Vogelvlei Yacht Club

2016 Italian National Ranking Event 2

From 25 Mar 2016 to 28 Mar 2016

Italy ----
Italy
Yacht Club Cagliari
Portugal ----
Portugal
Clube Naútico da Figueira da Foz
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-4-1' AND puntual_date >= '2016-3-1') AND (published = 'YES') ORDER BY puntual_date,R.id