2009 25 Year Sailing for Ostend

From 01 May 2009 to 03 May 2009

Belgium ----
Belgium
Royal North Sea Yacht Club

2009 1st Scandinavian Coaches Clinic

From 21 May 2009 to 24 May 2009

Denmark ----
Denmark
Roskilde Sailing Club

2009 Dutch Youth Regatta

From 21 May 2009 to 23 May 2009

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