2014 Campeonato San Isidro Labrador

From 01 May 2014 to 04 May 2014

Argentina ----
Argentina
Club Nautico San Isidro

KFC Tunku Laxamana / NSC Open Regatta

From 02 May 2014 to 04 May 2014

Malaysia ----
Malaysia
Negri Sembilan

United 4 (2)

From 17 May 2014 to 18 May 2014

Netherlands ----
Netherlands
Workum

2014 Mediterranean Sailing Meeting

From 17 May 2014 to 18 May 2014

Spain ----
Spain
Club Nautico El Balis

2014 Canadian Olympic Classes Regatta

From 17 May 2014 to 18 May 2014

Canada ----
Canada
Toronto Sailing and Canoe Club

Polish Yachting Association Trophy

From 22 May 2014 to 25 May 2014

Sukma XVII Perlis 2014

From 24 May 2014 to 04 Jun 2014

Malaysia ----
Malaysia
Perlis

2014 Dutch Youth Regatta

From 29 May 2014 to 01 Jun 2014

Netherlands ----
Netherlands
Workum

Harvest Festival Open Regatta

From 31 May 2014 to 01 Jun 2014

Malaysia ----
Malaysia
Kinabalu 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 < '2014-6-1' AND puntual_date >= '2014-5-1') AND (published = 'YES') ORDER BY puntual_date,R.id