2016 RYA Youth National Championships

From 02 Apr 2016 to 08 Apr 2016

Great Britain ----
Great Britain
Pwllheli Sailing Club

2016 Western Australia 420 State Championships

From 02 Apr 2016 to 03 Apr 2016

Australia ----
Australia
Fremantle Sailing Club

2015-2016 ASAF Youth Sailing Cup 4/Final

From 05 Apr 2016 to 12 Apr 2016

United Arab Emirates ----
United Arab Emirates
Abu Dhabi Sailing and Yacht Club
Australia ----
Australia
Mornington Yacht Club

2016 Internationale SP Bodensee

From 09 Apr 2016 to 10 Apr 2016

Austria ----
Austria
Yacht Club Rheindelta

2016 Majthenyi Memorial Regatta

From 15 Apr 2016 to 17 Apr 2016

Hungary ----
Hungary
Yacht Club Agard

Campeonata San Isidro Labrador 2016

From 16 Apr 2016 to 24 Apr 2016

Argentina ----
Argentina
Club Nautico San Isidro
France ----
France
Cercle de Voile de Marseillan
Portugal ----
Portugal
Clube de Vela Atlântico

2016 Italian National Ranking Event

From 23 Apr 2016 to 25 Apr 2016

Italy ----
Italy
Marina degli Aregai
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-5-1' AND puntual_date >= '2016-4-1') AND (published = 'YES') ORDER BY puntual_date,R.id