Class info Swedish 420 Class Association

Back
Sweden ----
Swedish 420 Class Association
SWE
No events found

2013 KSSS Olympic Regatta

From 04 Oct 2013 to 06 Oct 2013

Sweden
Royal Swedish Yacht Club

2012 KSS Olympic Regatta

From 05 Oct 2012 to 07 Oct 2012

Sweden
Royal Swedish Yacht Club

2007 Swedish JSM

From 01 Jun 2007 to 03 Jun 2007

Sweden
Royal Gothenburg Yacht Club
Bo Johannisson
Position: President
Photo
Ann Holmgren
Position: Treasurer
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 (187,177,79)) AND (published = 'YES') AND (end_date >= '2018-08-20T18:58:55+02:00' OR puntual_date >= '2018-08-20T18:58:55+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 (187,177,79)) AND (published = 'YES') AND (end_date <= '2018-08-20T18:58:55+02:00' ) ORDER BY puntual_date DESC,R.id