Slovenian Sailing Federation
SLO
From 28 Sep 2018 to 29 Sep 2018
From 13 Apr 2018 to 15 Apr 2018
Slovenia
J K Olimpic Izola
From 29 Mar 2018 to 02 Apr 2018
Slovenia
Yacht Club Burja Izola
From 13 Apr 2017 to 16 Apr 2017
Slovenia
Yacht Club Burja Izola
From 24 Mar 2016 to 27 Mar 2016
Slovenia
Yacht Club Burja Izola
From 20 Jun 2014 to 22 Jun 2014
Slovenia
J K Olimpic Izola
From 17 Apr 2014 to 21 Apr 2014
Slovenia
Yacht Club Burja Izola
From 28 Mar 2013 to 01 Apr 2013
Slovenia
Yacht Club Burja Izola
From 05 Apr 2012 to 09 Apr 2012
Slovenia
Yacht Club Burja Izola
From 19 Mar 2008 to 24 Mar 2008
Slovenia
Yacht Club Burja Izola
From 04 Apr 2007 to 09 Apr 2007
Slovenia
Yacht Club Burja Izola
PODIUM 1,2,3 TO GERMANY AT IZOLA SPRING CUP
420 General Event News
Read more
CROATIA HOSTS INTERNATIONAL 420 FLEET AT ZADAR OPEN
420 General Event News
Read more
59 TEAMS FACE OFF AT IZOLA SPRING CUP
420 General Event News
Read more
German Siblings Win at Izola Spring Cup in Slovenia
420 General Event News
Read more
107 Teams Tackle Italian National Regatta Trieste
420 General Event News
Read more
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 (571,387,247)) AND (published = 'YES') AND (end_date >= '2018-06-24T06:56:00+02:00' OR puntual_date >= '2018-06-24T06:56:00+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 (571,387,247)) AND (published = 'YES') AND (end_date <= '2018-06-24T06:56:00+02:00' )
ORDER BY puntual_date DESC,R.id
