KAUDEN KÄRKITULOKSET

▼ KAUDEN KÄRKITULOKSET

SUOMEN ENNÄTYKSET

17-VUOTIAAT
MIEHET

NAISET

select index2w.*, SE17, ENOT, CASE WHEN alltw.enumber>550 THEN 0 ELSE alltw.Korkeus END AS Kork, CASE WHEN alltw.RealCountry='FIN' THEN 0 ELSE 1 END AS viesti, alltw.ID AS Indeksi, alltw.enumber AS Orderi, alltw.Wind AS Tuuli, alltw.Year AS Vuosi, alltw.*, fevents.Laji AS Laji FROM alltw, index2w, fevents, seeventswomen WHERE alltw.ID = index2w.ID AND Field1=0 AND alltw.enumber = fevents.Orderi AND alltw.enumber = seeventswomen.enumber AND alltw.Massa = seeventswomen.Massa AND alltw.Korkeus = seeventswomen.Korkeus AND Rec Is Not Null AND Rec Like '%SE17%' AND (CASE WHEN 0=1 THEN Ind=1 WHEN 0=0 AND Year<2016 THEN Ind=0 ELSE Ind=0 OR Ind=1 END) AND Irr is NULL ORDER BY seeventswomen.ENOT, viesti, Kork, Massa, Seconds, RealMetres desc, Date