Denmark ----
Denmark
DEN
+45 20748884
No events found

2009 1st Scandinavian Coaches Clinic

From 21 May 2009 to 24 May 2009

Denmark
Roskilde Sailing Club

2008 VOLVO Youth Sailing ISAF World Championship

From 10 Jul 2008 to 19 Jul 2008

Denmark
Aarhus
Søren Kjaer
Position: Chairman
+45 20 74 88 84
Photo
Charlotte Friis
Position: Chairman
Photo
Position: Treasurer
Photo
Position: International Team Co-ordinator.
Photo
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 left JOIN gerelations GER ON R.id_genericelement = GER.id_ge_1 left JOIN geclub C ON C.id_genericelement = GER.id_ge_2 WHERE (C.id IN (325,175,2)) AND (published = 'YES') AND (end_date >= '2018-05-20T21:58:22+02:00' OR puntual_date >= '2018-05-20T21:58:22+02:00') ORDER BY puntual_date ASC,R.id
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 left JOIN gerelations GER ON R.id_genericelement = GER.id_ge_1 left JOIN geclub C ON C.id_genericelement = GER.id_ge_2 WHERE (C.id IN (325,175,2)) AND (published = 'YES') AND (end_date <= '2018-05-20T21:58:22+02:00' ) ORDER BY puntual_date DESC,R.id