Inom parentes efter årsbästa: topp-100-placeringen på världsbästalistan. Grön parentes: topp-100-placering på världsbästalistan i 19-årsklassen. Orange parentes: topp-100-placering på världsbästalistan i 17-årsklassen.
2021
select DISTINCT sweevents2.Eventname AS Eventswe, CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearsweall.Eventname AS Eventeng, events.TF, yearsweall.iid as IID, yearsweall.*, alltat109877.multi, alltat109877.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.menpbest.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN '' ELSE `2010`.mensbest.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN CASE WHEN `2010`.menpbest.Best = 0 AND `2010`.menpbest.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END AS BPBe, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.mensbest.BB IS NOT NULL THEN CASE WHEN `2010`.mensbest.Best = 0 AND `2010`.mensbest.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.menwl.BB IS NOT NULL THEN CASE WHEN `2010`.menwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.menwl.BB AS WL, CASE WHEN MONTH(yearsweall.Date)>9 AND yearsweall.Ind=1 THEN 2021-1 ELSE 2021 END AS Yeari, CONCAT(DAY(yearsweall.DATE),'.',MONTH(yearsweall.DATE),'.',SUBSTRING(YEAR(yearsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltat109877 inner join world.yearsweall ON alltat109877.IID=yearsweall.IID INNER JOIN `2010`.events on yearsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearsweall.irr != 'MX' then yearsweall.irr else '' END left join `2010`.menpbest on `2010`.menpbest.iid = yearsweall.IID left join `2010`.mensbest on `2010`.mensbest.iid = yearsweall.IID left join `2010`.menwl on `2010`.menwl.iid = yearsweall.IID LEFT JOIN `2010`.sweevents2 ON yearsweall.ENumber=sweevents2.ENumber LEFT JOIN results.comp ON yearsweall.CID=comp.CID LEFT JOIN world.course ON alltat109877.IID=course.IID WHERE yearsweall.Year = 2021 AND yearsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal
Inga resultat 2021. Senaste resultatet är från 2020.
2020
select DISTINCT sweevents2.Eventname AS Eventswe, CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearsweall.Eventname AS Eventeng, events.TF, yearsweall.iid as IID, yearsweall.*, alltat109877.multi, alltat109877.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.menpbest.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN '' ELSE `2010`.mensbest.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN CASE WHEN `2010`.menpbest.Best = 0 AND `2010`.menpbest.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END AS BPBe, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.mensbest.BB IS NOT NULL THEN CASE WHEN `2010`.mensbest.Best = 0 AND `2010`.mensbest.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.menwl.BB IS NOT NULL THEN CASE WHEN `2010`.menwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.menwl.BB AS WL, CASE WHEN MONTH(yearsweall.Date)>9 AND yearsweall.Ind=1 THEN 2020-1 ELSE 2020 END AS Yeari, CONCAT(DAY(yearsweall.DATE),'.',MONTH(yearsweall.DATE),'.',SUBSTRING(YEAR(yearsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltat109877 inner join world.yearsweall ON alltat109877.IID=yearsweall.IID INNER JOIN `2010`.events on yearsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearsweall.irr != 'MX' then yearsweall.irr else '' END left join `2010`.menpbest on `2010`.menpbest.iid = yearsweall.IID left join `2010`.mensbest on `2010`.mensbest.iid = yearsweall.IID left join `2010`.menwl on `2010`.menwl.iid = yearsweall.IID LEFT JOIN `2010`.sweevents2 ON yearsweall.ENumber=sweevents2.ENumber LEFT JOIN results.comp ON yearsweall.CID=comp.CID LEFT JOIN world.course ON alltat109877.IID=course.IID WHERE yearsweall.Year = 2020 AND yearsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal
select DISTINCT sweevents2.Eventname AS Eventswe, CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearsweall.Eventname AS Eventeng, events.TF, yearsweall.iid as IID, yearsweall.*, alltat109877.multi, alltat109877.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.menpbest.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN '' ELSE `2010`.mensbest.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN CASE WHEN `2010`.menpbest.Best = 0 AND `2010`.menpbest.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END AS BPBe, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.mensbest.BB IS NOT NULL THEN CASE WHEN `2010`.mensbest.Best = 0 AND `2010`.mensbest.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.menwl.BB IS NOT NULL THEN CASE WHEN `2010`.menwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.menwl.BB AS WL, CASE WHEN MONTH(yearsweall.Date)>9 AND yearsweall.Ind=1 THEN 2019-1 ELSE 2019 END AS Yeari, CONCAT(DAY(yearsweall.DATE),'.',MONTH(yearsweall.DATE),'.',SUBSTRING(YEAR(yearsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltat109877 inner join world.yearsweall ON alltat109877.IID=yearsweall.IID INNER JOIN `2010`.events on yearsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearsweall.irr != 'MX' then yearsweall.irr else '' END left join `2010`.menpbest on `2010`.menpbest.iid = yearsweall.IID left join `2010`.mensbest on `2010`.mensbest.iid = yearsweall.IID left join `2010`.menwl on `2010`.menwl.iid = yearsweall.IID LEFT JOIN `2010`.sweevents2 ON yearsweall.ENumber=sweevents2.ENumber LEFT JOIN results.comp ON yearsweall.CID=comp.CID LEFT JOIN world.course ON alltat109877.IID=course.IID WHERE yearsweall.Year = 2019 AND yearsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal
select DISTINCT sweevents2.Eventname AS Eventswe, CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearsweall.Eventname AS Eventeng, events.TF, yearsweall.iid as IID, yearsweall.*, alltat109877.multi, alltat109877.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.menpbest.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN '' ELSE `2010`.mensbest.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN CASE WHEN `2010`.menpbest.Best = 0 AND `2010`.menpbest.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END AS BPBe, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.mensbest.BB IS NOT NULL THEN CASE WHEN `2010`.mensbest.Best = 0 AND `2010`.mensbest.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.menwl.BB IS NOT NULL THEN CASE WHEN `2010`.menwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.menwl.BB AS WL, CASE WHEN MONTH(yearsweall.Date)>9 AND yearsweall.Ind=1 THEN 2018-1 ELSE 2018 END AS Yeari, CONCAT(DAY(yearsweall.DATE),'.',MONTH(yearsweall.DATE),'.',SUBSTRING(YEAR(yearsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltat109877 inner join world.yearsweall ON alltat109877.IID=yearsweall.IID INNER JOIN `2010`.events on yearsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearsweall.irr != 'MX' then yearsweall.irr else '' END left join `2010`.menpbest on `2010`.menpbest.iid = yearsweall.IID left join `2010`.mensbest on `2010`.mensbest.iid = yearsweall.IID left join `2010`.menwl on `2010`.menwl.iid = yearsweall.IID LEFT JOIN `2010`.sweevents2 ON yearsweall.ENumber=sweevents2.ENumber LEFT JOIN results.comp ON yearsweall.CID=comp.CID LEFT JOIN world.course ON alltat109877.IID=course.IID WHERE yearsweall.Year = 2018 AND yearsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal
select DISTINCT sweevents2.Eventname AS Eventswe, CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearsweall.Eventname AS Eventeng, events.TF, yearsweall.iid as IID, yearsweall.*, alltat109877.multi, alltat109877.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.menpbest.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN '' ELSE `2010`.mensbest.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN CASE WHEN `2010`.menpbest.Best = 0 AND `2010`.menpbest.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END AS BPBe, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.mensbest.BB IS NOT NULL THEN CASE WHEN `2010`.mensbest.Best = 0 AND `2010`.mensbest.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.menwl.BB IS NOT NULL THEN CASE WHEN `2010`.menwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.menwl.BB AS WL, CASE WHEN MONTH(yearsweall.Date)>9 AND yearsweall.Ind=1 THEN 2017-1 ELSE 2017 END AS Yeari, CONCAT(DAY(yearsweall.DATE),'.',MONTH(yearsweall.DATE),'.',SUBSTRING(YEAR(yearsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltat109877 inner join world.yearsweall ON alltat109877.IID=yearsweall.IID INNER JOIN `2010`.events on yearsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearsweall.irr != 'MX' then yearsweall.irr else '' END left join `2010`.menpbest on `2010`.menpbest.iid = yearsweall.IID left join `2010`.mensbest on `2010`.mensbest.iid = yearsweall.IID left join `2010`.menwl on `2010`.menwl.iid = yearsweall.IID LEFT JOIN `2010`.sweevents2 ON yearsweall.ENumber=sweevents2.ENumber LEFT JOIN results.comp ON yearsweall.CID=comp.CID LEFT JOIN world.course ON alltat109877.IID=course.IID WHERE yearsweall.Year = 2017 AND yearsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal
select DISTINCT sweevents2.Eventname AS Eventswe, CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearsweall.Eventname AS Eventeng, events.TF, yearsweall.iid as IID, yearsweall.*, alltat109877.multi, alltat109877.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.menpbest.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN '' ELSE `2010`.mensbest.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN CASE WHEN `2010`.menpbest.Best = 0 AND `2010`.menpbest.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END AS BPBe, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.mensbest.BB IS NOT NULL THEN CASE WHEN `2010`.mensbest.Best = 0 AND `2010`.mensbest.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.menwl.BB IS NOT NULL THEN CASE WHEN `2010`.menwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.menwl.BB AS WL, CASE WHEN MONTH(yearsweall.Date)>9 AND yearsweall.Ind=1 THEN 2016-1 ELSE 2016 END AS Yeari, CONCAT(DAY(yearsweall.DATE),'.',MONTH(yearsweall.DATE),'.',SUBSTRING(YEAR(yearsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltat109877 inner join world.yearsweall ON alltat109877.IID=yearsweall.IID INNER JOIN `2010`.events on yearsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearsweall.irr != 'MX' then yearsweall.irr else '' END left join `2010`.menpbest on `2010`.menpbest.iid = yearsweall.IID left join `2010`.mensbest on `2010`.mensbest.iid = yearsweall.IID left join `2010`.menwl on `2010`.menwl.iid = yearsweall.IID LEFT JOIN `2010`.sweevents2 ON yearsweall.ENumber=sweevents2.ENumber LEFT JOIN results.comp ON yearsweall.CID=comp.CID LEFT JOIN world.course ON alltat109877.IID=course.IID WHERE yearsweall.Year = 2016 AND yearsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal
select DISTINCT sweevents2.Eventname AS Eventswe, CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearsweall.Eventname AS Eventeng, events.TF, yearsweall.iid as IID, yearsweall.*, alltat109877.multi, alltat109877.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.menpbest.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN '' ELSE `2010`.mensbest.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN CASE WHEN `2010`.menpbest.Best = 0 AND `2010`.menpbest.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END AS BPBe, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.mensbest.BB IS NOT NULL THEN CASE WHEN `2010`.mensbest.Best = 0 AND `2010`.mensbest.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.menwl.BB IS NOT NULL THEN CASE WHEN `2010`.menwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.menwl.BB AS WL, CASE WHEN MONTH(yearsweall.Date)>9 AND yearsweall.Ind=1 THEN 2015-1 ELSE 2015 END AS Yeari, CONCAT(DAY(yearsweall.DATE),'.',MONTH(yearsweall.DATE),'.',SUBSTRING(YEAR(yearsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltat109877 inner join world.yearsweall ON alltat109877.IID=yearsweall.IID INNER JOIN `2010`.events on yearsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearsweall.irr != 'MX' then yearsweall.irr else '' END left join `2010`.menpbest on `2010`.menpbest.iid = yearsweall.IID left join `2010`.mensbest on `2010`.mensbest.iid = yearsweall.IID left join `2010`.menwl on `2010`.menwl.iid = yearsweall.IID LEFT JOIN `2010`.sweevents2 ON yearsweall.ENumber=sweevents2.ENumber LEFT JOIN results.comp ON yearsweall.CID=comp.CID LEFT JOIN world.course ON alltat109877.IID=course.IID WHERE yearsweall.Year = 2015 AND yearsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal
select DISTINCT sweevents2.Eventname AS Eventswe, CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearsweall.Eventname AS Eventeng, events.TF, yearsweall.iid as IID, yearsweall.*, alltat109877.multi, alltat109877.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.menpbest.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN '' ELSE `2010`.mensbest.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN CASE WHEN `2010`.menpbest.Best = 0 AND `2010`.menpbest.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END AS BPBe, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.mensbest.BB IS NOT NULL THEN CASE WHEN `2010`.mensbest.Best = 0 AND `2010`.mensbest.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.menwl.BB IS NOT NULL THEN CASE WHEN `2010`.menwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.menwl.BB AS WL, CASE WHEN MONTH(yearsweall.Date)>9 AND yearsweall.Ind=1 THEN 2014-1 ELSE 2014 END AS Yeari, CONCAT(DAY(yearsweall.DATE),'.',MONTH(yearsweall.DATE),'.',SUBSTRING(YEAR(yearsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltat109877 inner join world.yearsweall ON alltat109877.IID=yearsweall.IID INNER JOIN `2010`.events on yearsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearsweall.irr != 'MX' then yearsweall.irr else '' END left join `2010`.menpbest on `2010`.menpbest.iid = yearsweall.IID left join `2010`.mensbest on `2010`.mensbest.iid = yearsweall.IID left join `2010`.menwl on `2010`.menwl.iid = yearsweall.IID LEFT JOIN `2010`.sweevents2 ON yearsweall.ENumber=sweevents2.ENumber LEFT JOIN results.comp ON yearsweall.CID=comp.CID LEFT JOIN world.course ON alltat109877.IID=course.IID WHERE yearsweall.Year = 2014 AND yearsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal
select DISTINCT sweevents2.Eventname AS Eventswe, CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearsweall.Eventname AS Eventeng, events.TF, yearsweall.iid as IID, yearsweall.*, alltat109877.multi, alltat109877.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.menpbest.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN '' ELSE `2010`.mensbest.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN CASE WHEN `2010`.menpbest.Best = 0 AND `2010`.menpbest.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END AS BPBe, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.mensbest.BB IS NOT NULL THEN CASE WHEN `2010`.mensbest.Best = 0 AND `2010`.mensbest.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.menwl.BB IS NOT NULL THEN CASE WHEN `2010`.menwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.menwl.BB AS WL, CASE WHEN MONTH(yearsweall.Date)>9 AND yearsweall.Ind=1 THEN 2013-1 ELSE 2013 END AS Yeari, CONCAT(DAY(yearsweall.DATE),'.',MONTH(yearsweall.DATE),'.',SUBSTRING(YEAR(yearsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltat109877 inner join world.yearsweall ON alltat109877.IID=yearsweall.IID INNER JOIN `2010`.events on yearsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearsweall.irr != 'MX' then yearsweall.irr else '' END left join `2010`.menpbest on `2010`.menpbest.iid = yearsweall.IID left join `2010`.mensbest on `2010`.mensbest.iid = yearsweall.IID left join `2010`.menwl on `2010`.menwl.iid = yearsweall.IID LEFT JOIN `2010`.sweevents2 ON yearsweall.ENumber=sweevents2.ENumber LEFT JOIN results.comp ON yearsweall.CID=comp.CID LEFT JOIN world.course ON alltat109877.IID=course.IID WHERE yearsweall.Year = 2013 AND yearsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal
select DISTINCT sweevents2.Eventname AS Eventswe, CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearsweall.Eventname AS Eventeng, events.TF, yearsweall.iid as IID, yearsweall.*, alltat109877.multi, alltat109877.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.menpbest.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN '' ELSE `2010`.mensbest.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN CASE WHEN `2010`.menpbest.Best = 0 AND `2010`.menpbest.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END AS BPBe, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.mensbest.BB IS NOT NULL THEN CASE WHEN `2010`.mensbest.Best = 0 AND `2010`.mensbest.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.menwl.BB IS NOT NULL THEN CASE WHEN `2010`.menwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.menwl.BB AS WL, CASE WHEN MONTH(yearsweall.Date)>9 AND yearsweall.Ind=1 THEN 2012-1 ELSE 2012 END AS Yeari, CONCAT(DAY(yearsweall.DATE),'.',MONTH(yearsweall.DATE),'.',SUBSTRING(YEAR(yearsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltat109877 inner join world.yearsweall ON alltat109877.IID=yearsweall.IID INNER JOIN `2010`.events on yearsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearsweall.irr != 'MX' then yearsweall.irr else '' END left join `2010`.menpbest on `2010`.menpbest.iid = yearsweall.IID left join `2010`.mensbest on `2010`.mensbest.iid = yearsweall.IID left join `2010`.menwl on `2010`.menwl.iid = yearsweall.IID LEFT JOIN `2010`.sweevents2 ON yearsweall.ENumber=sweevents2.ENumber LEFT JOIN results.comp ON yearsweall.CID=comp.CID LEFT JOIN world.course ON alltat109877.IID=course.IID WHERE yearsweall.Year = 2012 AND yearsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal
select DISTINCT sweevents2.Eventname AS Eventswe, CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearsweall.Eventname AS Eventeng, events.TF, yearsweall.iid as IID, yearsweall.*, alltat109877.multi, alltat109877.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.menpbest.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN '' ELSE `2010`.mensbest.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN CASE WHEN `2010`.menpbest.Best = 0 AND `2010`.menpbest.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END AS BPBe, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.mensbest.BB IS NOT NULL THEN CASE WHEN `2010`.mensbest.Best = 0 AND `2010`.mensbest.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.menwl.BB IS NOT NULL THEN CASE WHEN `2010`.menwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.menwl.BB AS WL, CASE WHEN MONTH(yearsweall.Date)>9 AND yearsweall.Ind=1 THEN 2011-1 ELSE 2011 END AS Yeari, CONCAT(DAY(yearsweall.DATE),'.',MONTH(yearsweall.DATE),'.',SUBSTRING(YEAR(yearsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltat109877 inner join world.yearsweall ON alltat109877.IID=yearsweall.IID INNER JOIN `2010`.events on yearsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearsweall.irr != 'MX' then yearsweall.irr else '' END left join `2010`.menpbest on `2010`.menpbest.iid = yearsweall.IID left join `2010`.mensbest on `2010`.mensbest.iid = yearsweall.IID left join `2010`.menwl on `2010`.menwl.iid = yearsweall.IID LEFT JOIN `2010`.sweevents2 ON yearsweall.ENumber=sweevents2.ENumber LEFT JOIN results.comp ON yearsweall.CID=comp.CID LEFT JOIN world.course ON alltat109877.IID=course.IID WHERE yearsweall.Year = 2011 AND yearsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal
select DISTINCT sweevents2.Eventname AS Eventswe, CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearsweall.Eventname AS Eventeng, events.TF, yearsweall.iid as IID, yearsweall.*, alltat109877.multi, alltat109877.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.menpbest.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN '' ELSE `2010`.mensbest.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN CASE WHEN `2010`.menpbest.Best = 0 AND `2010`.menpbest.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END AS BPBe, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.mensbest.BB IS NOT NULL THEN CASE WHEN `2010`.mensbest.Best = 0 AND `2010`.mensbest.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.menwl.BB IS NOT NULL THEN CASE WHEN `2010`.menwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.menwl.BB AS WL, CASE WHEN MONTH(yearsweall.Date)>9 AND yearsweall.Ind=1 THEN 2010-1 ELSE 2010 END AS Yeari, CONCAT(DAY(yearsweall.DATE),'.',MONTH(yearsweall.DATE),'.',SUBSTRING(YEAR(yearsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltat109877 inner join world.yearsweall ON alltat109877.IID=yearsweall.IID INNER JOIN `2010`.events on yearsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearsweall.irr != 'MX' then yearsweall.irr else '' END left join `2010`.menpbest on `2010`.menpbest.iid = yearsweall.IID left join `2010`.mensbest on `2010`.mensbest.iid = yearsweall.IID left join `2010`.menwl on `2010`.menwl.iid = yearsweall.IID LEFT JOIN `2010`.sweevents2 ON yearsweall.ENumber=sweevents2.ENumber LEFT JOIN results.comp ON yearsweall.CID=comp.CID LEFT JOIN world.course ON alltat109877.IID=course.IID WHERE yearsweall.Year = 2010 AND yearsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal
select DISTINCT sweevents2.Eventname AS Eventswe, CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearsweall.Eventname AS Eventeng, events.TF, yearsweall.iid as IID, yearsweall.*, alltat109877.multi, alltat109877.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.menpbest.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN '' ELSE `2010`.mensbest.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN CASE WHEN `2010`.menpbest.Best = 0 AND `2010`.menpbest.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END AS BPBe, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.mensbest.BB IS NOT NULL THEN CASE WHEN `2010`.mensbest.Best = 0 AND `2010`.mensbest.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.menwl.BB IS NOT NULL THEN CASE WHEN `2010`.menwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.menwl.BB AS WL, CASE WHEN MONTH(yearsweall.Date)>9 AND yearsweall.Ind=1 THEN 2009-1 ELSE 2009 END AS Yeari, CONCAT(DAY(yearsweall.DATE),'.',MONTH(yearsweall.DATE),'.',SUBSTRING(YEAR(yearsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltat109877 inner join world.yearsweall ON alltat109877.IID=yearsweall.IID INNER JOIN `2010`.events on yearsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearsweall.irr != 'MX' then yearsweall.irr else '' END left join `2010`.menpbest on `2010`.menpbest.iid = yearsweall.IID left join `2010`.mensbest on `2010`.mensbest.iid = yearsweall.IID left join `2010`.menwl on `2010`.menwl.iid = yearsweall.IID LEFT JOIN `2010`.sweevents2 ON yearsweall.ENumber=sweevents2.ENumber LEFT JOIN results.comp ON yearsweall.CID=comp.CID LEFT JOIN world.course ON alltat109877.IID=course.IID WHERE yearsweall.Year = 2009 AND yearsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal
select DISTINCT sweevents2.Eventname AS Eventswe, CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearsweall.Eventname AS Eventeng, events.TF, yearsweall.iid as IID, yearsweall.*, alltat109877.multi, alltat109877.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.menpbest.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN '' ELSE `2010`.mensbest.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN CASE WHEN `2010`.menpbest.Best = 0 AND `2010`.menpbest.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END AS BPBe, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.mensbest.BB IS NOT NULL THEN CASE WHEN `2010`.mensbest.Best = 0 AND `2010`.mensbest.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.menwl.BB IS NOT NULL THEN CASE WHEN `2010`.menwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.menwl.BB AS WL, CASE WHEN MONTH(yearsweall.Date)>9 AND yearsweall.Ind=1 THEN 2008-1 ELSE 2008 END AS Yeari, CONCAT(DAY(yearsweall.DATE),'.',MONTH(yearsweall.DATE),'.',SUBSTRING(YEAR(yearsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltat109877 inner join world.yearsweall ON alltat109877.IID=yearsweall.IID INNER JOIN `2010`.events on yearsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearsweall.irr != 'MX' then yearsweall.irr else '' END left join `2010`.menpbest on `2010`.menpbest.iid = yearsweall.IID left join `2010`.mensbest on `2010`.mensbest.iid = yearsweall.IID left join `2010`.menwl on `2010`.menwl.iid = yearsweall.IID LEFT JOIN `2010`.sweevents2 ON yearsweall.ENumber=sweevents2.ENumber LEFT JOIN results.comp ON yearsweall.CID=comp.CID LEFT JOIN world.course ON alltat109877.IID=course.IID WHERE yearsweall.Year = 2008 AND yearsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal
select DISTINCT sweevents2.Eventname AS Eventswe, CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearsweall.Eventname AS Eventeng, events.TF, yearsweall.iid as IID, yearsweall.*, alltat109877.multi, alltat109877.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.menpbest.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN '' ELSE `2010`.mensbest.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN CASE WHEN `2010`.menpbest.Best = 0 AND `2010`.menpbest.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END AS BPBe, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.mensbest.BB IS NOT NULL THEN CASE WHEN `2010`.mensbest.Best = 0 AND `2010`.mensbest.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.menwl.BB IS NOT NULL THEN CASE WHEN `2010`.menwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.menwl.BB AS WL, CASE WHEN MONTH(yearsweall.Date)>9 AND yearsweall.Ind=1 THEN 2007-1 ELSE 2007 END AS Yeari, CONCAT(DAY(yearsweall.DATE),'.',MONTH(yearsweall.DATE),'.',SUBSTRING(YEAR(yearsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltat109877 inner join world.yearsweall ON alltat109877.IID=yearsweall.IID INNER JOIN `2010`.events on yearsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearsweall.irr != 'MX' then yearsweall.irr else '' END left join `2010`.menpbest on `2010`.menpbest.iid = yearsweall.IID left join `2010`.mensbest on `2010`.mensbest.iid = yearsweall.IID left join `2010`.menwl on `2010`.menwl.iid = yearsweall.IID LEFT JOIN `2010`.sweevents2 ON yearsweall.ENumber=sweevents2.ENumber LEFT JOIN results.comp ON yearsweall.CID=comp.CID LEFT JOIN world.course ON alltat109877.IID=course.IID WHERE yearsweall.Year = 2007 AND yearsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal
select DISTINCT sweevents2.Eventname AS Eventswe, CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearsweall.Eventname AS Eventeng, events.TF, yearsweall.iid as IID, yearsweall.*, alltat109877.multi, alltat109877.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.menpbest.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN '' ELSE `2010`.mensbest.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN CASE WHEN `2010`.menpbest.Best = 0 AND `2010`.menpbest.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END AS BPBe, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.mensbest.BB IS NOT NULL THEN CASE WHEN `2010`.mensbest.Best = 0 AND `2010`.mensbest.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.menwl.BB IS NOT NULL THEN CASE WHEN `2010`.menwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.menwl.BB AS WL, CASE WHEN MONTH(yearsweall.Date)>9 AND yearsweall.Ind=1 THEN 2006-1 ELSE 2006 END AS Yeari, CONCAT(DAY(yearsweall.DATE),'.',MONTH(yearsweall.DATE),'.',SUBSTRING(YEAR(yearsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltat109877 inner join world.yearsweall ON alltat109877.IID=yearsweall.IID INNER JOIN `2010`.events on yearsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearsweall.irr != 'MX' then yearsweall.irr else '' END left join `2010`.menpbest on `2010`.menpbest.iid = yearsweall.IID left join `2010`.mensbest on `2010`.mensbest.iid = yearsweall.IID left join `2010`.menwl on `2010`.menwl.iid = yearsweall.IID LEFT JOIN `2010`.sweevents2 ON yearsweall.ENumber=sweevents2.ENumber LEFT JOIN results.comp ON yearsweall.CID=comp.CID LEFT JOIN world.course ON alltat109877.IID=course.IID WHERE yearsweall.Year = 2006 AND yearsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal
select DISTINCT sweevents2.Eventname AS Eventswe, CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearsweall.Eventname AS Eventeng, events.TF, yearsweall.iid as IID, yearsweall.*, alltat109877.multi, alltat109877.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.menpbest.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN '' ELSE `2010`.mensbest.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN CASE WHEN `2010`.menpbest.Best = 0 AND `2010`.menpbest.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END AS BPBe, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.mensbest.BB IS NOT NULL THEN CASE WHEN `2010`.mensbest.Best = 0 AND `2010`.mensbest.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.menwl.BB IS NOT NULL THEN CASE WHEN `2010`.menwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.menwl.BB AS WL, CASE WHEN MONTH(yearsweall.Date)>9 AND yearsweall.Ind=1 THEN 2005-1 ELSE 2005 END AS Yeari, CONCAT(DAY(yearsweall.DATE),'.',MONTH(yearsweall.DATE),'.',SUBSTRING(YEAR(yearsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltat109877 inner join world.yearsweall ON alltat109877.IID=yearsweall.IID INNER JOIN `2010`.events on yearsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearsweall.irr != 'MX' then yearsweall.irr else '' END left join `2010`.menpbest on `2010`.menpbest.iid = yearsweall.IID left join `2010`.mensbest on `2010`.mensbest.iid = yearsweall.IID left join `2010`.menwl on `2010`.menwl.iid = yearsweall.IID LEFT JOIN `2010`.sweevents2 ON yearsweall.ENumber=sweevents2.ENumber LEFT JOIN results.comp ON yearsweall.CID=comp.CID LEFT JOIN world.course ON alltat109877.IID=course.IID WHERE yearsweall.Year = 2005 AND yearsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal
select DISTINCT sweevents2.Eventname AS Eventswe, CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearsweall.Eventname AS Eventeng, events.TF, yearsweall.iid as IID, yearsweall.*, alltat109877.multi, alltat109877.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.menpbest.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN '' ELSE `2010`.mensbest.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN CASE WHEN `2010`.menpbest.Best = 0 AND `2010`.menpbest.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END AS BPBe, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.menpbest.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.mensbest.BB IS NOT NULL THEN CASE WHEN `2010`.mensbest.Best = 0 AND `2010`.mensbest.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.menwl.BB IS NOT NULL THEN CASE WHEN `2010`.menwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.menwl.BB AS WL, CASE WHEN MONTH(yearsweall.Date)>9 AND yearsweall.Ind=1 THEN 2004-1 ELSE 2004 END AS Yeari, CONCAT(DAY(yearsweall.DATE),'.',MONTH(yearsweall.DATE),'.',SUBSTRING(YEAR(yearsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltat109877 inner join world.yearsweall ON alltat109877.IID=yearsweall.IID INNER JOIN `2010`.events on yearsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearsweall.irr != 'MX' then yearsweall.irr else '' END left join `2010`.menpbest on `2010`.menpbest.iid = yearsweall.IID left join `2010`.mensbest on `2010`.mensbest.iid = yearsweall.IID left join `2010`.menwl on `2010`.menwl.iid = yearsweall.IID LEFT JOIN `2010`.sweevents2 ON yearsweall.ENumber=sweevents2.ENumber LEFT JOIN results.comp ON yearsweall.CID=comp.CID LEFT JOIN world.course ON alltat109877.IID=course.IID WHERE yearsweall.Year = 2004 AND yearsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal