Majthenyi Zsombor Emlekverseny 2018

From 29 Apr 2018 to 01 May 2018

Hungary ----
Hungary
Yacht Club Agard

2018 Thailand Youth Championship

From 02 May 2018 to 06 May 2018

Thailand ----
Thailand
Royal Varuna Yacht Club
Bulgaria ----
Bulgaria
Yacht Club Port Bourgas

Championnat Juniors ACVL centralisé 2018

From 05 May 2018 to 06 May 2018

Switzerland ----
Switzerland
Cercle de la Voile de Vidy

2018 Irish Leinster Regional Championships

From 05 May 2018 to 06 May 2018

Ireland ----
Ireland
Royal St George Yacht Club

Portugal - 3rd National Qualifying Regatta 2018

From 05 May 2018 to 06 May 2018

Portugal ----
Portugal
Clube Naval de Leça

2018 Champoinnat de Suisse 420

From 10 May 2018 to 13 May 2018

Switzerland ----
Switzerland
Club Nautique Morgien
Italy ----
Italy
Campione Univela

4th Portuguese Qualifying Regatta 2018

From 19 May 2018 to 20 May 2018

Portugal ----
Portugal
Clube Naval de Sesimbra

2018 Interligue 2 Sud - CNV Aix Les Bains

From 19 May 2018 to 21 May 2018

France ----
France
CNV Aix Les Bains
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 < '2018-6-1' AND puntual_date >= '2018-5-1') AND (published = 'YES') ORDER BY puntual_date,R.id