Class info Finnish 420 Class

Back
Finland ----
Finnish 420 Class
FIN
No events found
No events found
07
Oct 2015

Finland announces 420 Teams heading to ISAF Youth Worlds

WS Youth

Read more
No contacts found
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 (86)) AND (published = 'YES') AND (end_date >= '2018-07-17T08:06:42+02:00' OR puntual_date >= '2018-07-17T08:06:42+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 (86)) AND (published = 'YES') AND (end_date <= '2018-07-17T08:06:42+02:00' ) ORDER BY puntual_date DESC,R.id