2013 Campeonato San Isidro Labrador (2)

From 01 May 2013 to 05 May 2013

Argentina ----
Argentina
Club Nautico San Isidro

2013 Bourgas Sailing Week

From 01 May 2013 to 05 May 2013

Bulgaria ----
Bulgaria
Yacht Club Port Bourgas

2013 420 Leinster Championship

From 04 May 2013 to 05 May 2013

Ireland ----
Ireland
Malahide Yacht Club

2013 Dutch Youth Regatta

From 09 May 2013 to 12 May 2013

Netherlands ----
Netherlands
Workum

2013 Pavlovska Regatta

From 11 May 2013 to 12 May 2013

Czech Republic ----
Czech Republic
Yacht Club Dyje Breclav

2013 Mediterranean Sailing Meeting

From 11 May 2013 to 12 May 2013

Spain ----
Spain
Club Nautico El Balis

2013 Audi Cup Summer Season Opener

From 11 May 2013 to 12 May 2013

2013 Austrian Championships

From 18 May 2013 to 20 May 2013

Austria ----
Austria
Union Yacht Club Neusiedlersee

2013 Young Europeans Sailing - Pfingstbusch

From 18 May 2013 to 20 May 2013

Germany ----
Germany
Kieler Yacht Club

2013 420 Sauerland Cup

From 25 May 2013 to 26 May 2013

Germany ----
Germany
Kanu Segel Club Hemer
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 < '2013-6-1' AND puntual_date >= '2013-5-1') AND (published = 'YES') ORDER BY puntual_date,R.id