Class info Lithuania 420 Class Association

Back
Lithuania ----
Lithuania 420 Class Association
LTU
No events found

2018 420 Class Eastern Europe Championship

From 12 Sep 2018 to 16 Sep 2018

Lithuania
Kauno Žalgirio Jachtklubas

A brand new combined event, the 420/470 Eastern Europe Championship, is taking place in Lithuania from 12-16 September.

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 (139,103,68)) AND (published = 'YES') AND (end_date >= '2018-09-25T23:12:06+02:00' OR puntual_date >= '2018-09-25T23:12:06+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 (139,103,68)) AND (published = 'YES') AND (end_date <= '2018-09-25T23:12:06+02:00' ) ORDER BY puntual_date DESC,R.id