KAUDEN KÄRKITULOKSET

▼ KAUDEN KÄRKITULOKSET

SUOMEN ENNÄTYKSET

17-VUOTIAAT
MIEHET

select index2.*, SE17, ENOT, CASE WHEN rec.ENumber>550 THEN 0 ELSE rec.Korkeus END AS Kork, CASE WHEN rec.RealCountry='FIN' THEN 0 ELSE 1 END AS viesti, rec.ID AS Indeksi, rec.ENumber AS Orderi, rec.Wind AS Tuuli, rec.Year AS Vuosi, rec.*, fevents.Laji AS Laji FROM rec, index2, fevents, seeventsmen WHERE rec.ID = index2.ID AND Field1=0 AND rec.ENumber = fevents.Orderi AND rec.ENumber = seeventsmen.ENumber AND rec.Massa = seeventsmen.Massa AND rec.Korkeus = seeventsmen.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 seeventsmen.ENOT, viesti, Kork, Massa, Seconds, RealMetres desc, Date

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