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.

Välj årVisa alla resultat20212020201920182017201620152014201320122011

2021

select DISTINCT sweevents2w.Eventname AS Eventswe, CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearwsweall.Eventname AS Eventeng, events.TF, yearwsweall.iid as IID, yearwsweall.*, alltwat82757.multi, alltwat82757.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.womenpbestSWEDEN.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN '' ELSE `2010`.womensbestSWEDEN.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womenpbestSWEDEN.Best = 0 AND `2010`.womenpbestSWEDEN.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`.womenpbestSWEDEN.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.womensbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womensbestSWEDEN.Best = 0 AND `2010`.womensbestSWEDEN.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.womenwl.BB IS NOT NULL THEN CASE WHEN `2010`.womenwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.womenwl.BB AS WL, CASE WHEN MONTH(yearwsweall.Date)>9 AND yearwsweall.Ind=1 THEN 2021-1 ELSE 2021 END AS Yeari, CONCAT(DAY(yearwsweall.DATE),'.',MONTH(yearwsweall.DATE),'.',SUBSTRING(YEAR(yearwsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltwat82757 inner join world.yearwsweall ON alltwat82757.IID=yearwsweall.IID INNER JOIN `2010`.events on yearwsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearwsweall.irr != 'MX' then yearwsweall.irr else '' END left join `2010`.womenpbestSWEDEN on `2010`.womenpbestSWEDEN.iid = yearwsweall.IID left join `2010`.womensbestSWEDEN on `2010`.womensbestSWEDEN.iid = yearwsweall.IID left join `2010`.womenwl on `2010`.womenwl.iid = yearwsweall.IID LEFT JOIN `2010`.sweevents2w ON yearwsweall.ENumber=sweevents2w.ENumber LEFT JOIN results.comp ON yearwsweall.CID=comp.CID LEFT JOIN world.coursew ON alltwat82757.IID=coursew.IID WHERE yearwsweall.Year = 2021 AND yearwsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal

2020

select DISTINCT sweevents2w.Eventname AS Eventswe, CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearwsweall.Eventname AS Eventeng, events.TF, yearwsweall.iid as IID, yearwsweall.*, alltwat82757.multi, alltwat82757.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.womenpbestSWEDEN.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN '' ELSE `2010`.womensbestSWEDEN.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womenpbestSWEDEN.Best = 0 AND `2010`.womenpbestSWEDEN.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`.womenpbestSWEDEN.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.womensbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womensbestSWEDEN.Best = 0 AND `2010`.womensbestSWEDEN.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.womenwl.BB IS NOT NULL THEN CASE WHEN `2010`.womenwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.womenwl.BB AS WL, CASE WHEN MONTH(yearwsweall.Date)>9 AND yearwsweall.Ind=1 THEN 2020-1 ELSE 2020 END AS Yeari, CONCAT(DAY(yearwsweall.DATE),'.',MONTH(yearwsweall.DATE),'.',SUBSTRING(YEAR(yearwsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltwat82757 inner join world.yearwsweall ON alltwat82757.IID=yearwsweall.IID INNER JOIN `2010`.events on yearwsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearwsweall.irr != 'MX' then yearwsweall.irr else '' END left join `2010`.womenpbestSWEDEN on `2010`.womenpbestSWEDEN.iid = yearwsweall.IID left join `2010`.womensbestSWEDEN on `2010`.womensbestSWEDEN.iid = yearwsweall.IID left join `2010`.womenwl on `2010`.womenwl.iid = yearwsweall.IID LEFT JOIN `2010`.sweevents2w ON yearwsweall.ENumber=sweevents2w.ENumber LEFT JOIN results.comp ON yearwsweall.CID=comp.CID LEFT JOIN world.coursew ON alltwat82757.IID=coursew.IID WHERE yearwsweall.Year = 2020 AND yearwsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal

2019

select DISTINCT sweevents2w.Eventname AS Eventswe, CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearwsweall.Eventname AS Eventeng, events.TF, yearwsweall.iid as IID, yearwsweall.*, alltwat82757.multi, alltwat82757.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.womenpbestSWEDEN.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN '' ELSE `2010`.womensbestSWEDEN.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womenpbestSWEDEN.Best = 0 AND `2010`.womenpbestSWEDEN.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`.womenpbestSWEDEN.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.womensbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womensbestSWEDEN.Best = 0 AND `2010`.womensbestSWEDEN.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.womenwl.BB IS NOT NULL THEN CASE WHEN `2010`.womenwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.womenwl.BB AS WL, CASE WHEN MONTH(yearwsweall.Date)>9 AND yearwsweall.Ind=1 THEN 2019-1 ELSE 2019 END AS Yeari, CONCAT(DAY(yearwsweall.DATE),'.',MONTH(yearwsweall.DATE),'.',SUBSTRING(YEAR(yearwsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltwat82757 inner join world.yearwsweall ON alltwat82757.IID=yearwsweall.IID INNER JOIN `2010`.events on yearwsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearwsweall.irr != 'MX' then yearwsweall.irr else '' END left join `2010`.womenpbestSWEDEN on `2010`.womenpbestSWEDEN.iid = yearwsweall.IID left join `2010`.womensbestSWEDEN on `2010`.womensbestSWEDEN.iid = yearwsweall.IID left join `2010`.womenwl on `2010`.womenwl.iid = yearwsweall.IID LEFT JOIN `2010`.sweevents2w ON yearwsweall.ENumber=sweevents2w.ENumber LEFT JOIN results.comp ON yearwsweall.CID=comp.CID LEFT JOIN world.coursew ON alltwat82757.IID=coursew.IID WHERE yearwsweall.Year = 2019 AND yearwsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal

2018

select DISTINCT sweevents2w.Eventname AS Eventswe, CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearwsweall.Eventname AS Eventeng, events.TF, yearwsweall.iid as IID, yearwsweall.*, alltwat82757.multi, alltwat82757.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.womenpbestSWEDEN.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN '' ELSE `2010`.womensbestSWEDEN.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womenpbestSWEDEN.Best = 0 AND `2010`.womenpbestSWEDEN.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`.womenpbestSWEDEN.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.womensbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womensbestSWEDEN.Best = 0 AND `2010`.womensbestSWEDEN.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.womenwl.BB IS NOT NULL THEN CASE WHEN `2010`.womenwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.womenwl.BB AS WL, CASE WHEN MONTH(yearwsweall.Date)>9 AND yearwsweall.Ind=1 THEN 2018-1 ELSE 2018 END AS Yeari, CONCAT(DAY(yearwsweall.DATE),'.',MONTH(yearwsweall.DATE),'.',SUBSTRING(YEAR(yearwsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltwat82757 inner join world.yearwsweall ON alltwat82757.IID=yearwsweall.IID INNER JOIN `2010`.events on yearwsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearwsweall.irr != 'MX' then yearwsweall.irr else '' END left join `2010`.womenpbestSWEDEN on `2010`.womenpbestSWEDEN.iid = yearwsweall.IID left join `2010`.womensbestSWEDEN on `2010`.womensbestSWEDEN.iid = yearwsweall.IID left join `2010`.womenwl on `2010`.womenwl.iid = yearwsweall.IID LEFT JOIN `2010`.sweevents2w ON yearwsweall.ENumber=sweevents2w.ENumber LEFT JOIN results.comp ON yearwsweall.CID=comp.CID LEFT JOIN world.coursew ON alltwat82757.IID=coursew.IID WHERE yearwsweall.Year = 2018 AND yearwsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal

2017

select DISTINCT sweevents2w.Eventname AS Eventswe, CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearwsweall.Eventname AS Eventeng, events.TF, yearwsweall.iid as IID, yearwsweall.*, alltwat82757.multi, alltwat82757.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.womenpbestSWEDEN.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN '' ELSE `2010`.womensbestSWEDEN.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womenpbestSWEDEN.Best = 0 AND `2010`.womenpbestSWEDEN.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`.womenpbestSWEDEN.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.womensbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womensbestSWEDEN.Best = 0 AND `2010`.womensbestSWEDEN.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.womenwl.BB IS NOT NULL THEN CASE WHEN `2010`.womenwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.womenwl.BB AS WL, CASE WHEN MONTH(yearwsweall.Date)>9 AND yearwsweall.Ind=1 THEN 2017-1 ELSE 2017 END AS Yeari, CONCAT(DAY(yearwsweall.DATE),'.',MONTH(yearwsweall.DATE),'.',SUBSTRING(YEAR(yearwsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltwat82757 inner join world.yearwsweall ON alltwat82757.IID=yearwsweall.IID INNER JOIN `2010`.events on yearwsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearwsweall.irr != 'MX' then yearwsweall.irr else '' END left join `2010`.womenpbestSWEDEN on `2010`.womenpbestSWEDEN.iid = yearwsweall.IID left join `2010`.womensbestSWEDEN on `2010`.womensbestSWEDEN.iid = yearwsweall.IID left join `2010`.womenwl on `2010`.womenwl.iid = yearwsweall.IID LEFT JOIN `2010`.sweevents2w ON yearwsweall.ENumber=sweevents2w.ENumber LEFT JOIN results.comp ON yearwsweall.CID=comp.CID LEFT JOIN world.coursew ON alltwat82757.IID=coursew.IID WHERE yearwsweall.Year = 2017 AND yearwsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal

2016

select DISTINCT sweevents2w.Eventname AS Eventswe, CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearwsweall.Eventname AS Eventeng, events.TF, yearwsweall.iid as IID, yearwsweall.*, alltwat82757.multi, alltwat82757.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.womenpbestSWEDEN.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN '' ELSE `2010`.womensbestSWEDEN.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womenpbestSWEDEN.Best = 0 AND `2010`.womenpbestSWEDEN.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`.womenpbestSWEDEN.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.womensbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womensbestSWEDEN.Best = 0 AND `2010`.womensbestSWEDEN.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.womenwl.BB IS NOT NULL THEN CASE WHEN `2010`.womenwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.womenwl.BB AS WL, CASE WHEN MONTH(yearwsweall.Date)>9 AND yearwsweall.Ind=1 THEN 2016-1 ELSE 2016 END AS Yeari, CONCAT(DAY(yearwsweall.DATE),'.',MONTH(yearwsweall.DATE),'.',SUBSTRING(YEAR(yearwsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltwat82757 inner join world.yearwsweall ON alltwat82757.IID=yearwsweall.IID INNER JOIN `2010`.events on yearwsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearwsweall.irr != 'MX' then yearwsweall.irr else '' END left join `2010`.womenpbestSWEDEN on `2010`.womenpbestSWEDEN.iid = yearwsweall.IID left join `2010`.womensbestSWEDEN on `2010`.womensbestSWEDEN.iid = yearwsweall.IID left join `2010`.womenwl on `2010`.womenwl.iid = yearwsweall.IID LEFT JOIN `2010`.sweevents2w ON yearwsweall.ENumber=sweevents2w.ENumber LEFT JOIN results.comp ON yearwsweall.CID=comp.CID LEFT JOIN world.coursew ON alltwat82757.IID=coursew.IID WHERE yearwsweall.Year = 2016 AND yearwsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal

2015

select DISTINCT sweevents2w.Eventname AS Eventswe, CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearwsweall.Eventname AS Eventeng, events.TF, yearwsweall.iid as IID, yearwsweall.*, alltwat82757.multi, alltwat82757.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.womenpbestSWEDEN.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN '' ELSE `2010`.womensbestSWEDEN.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womenpbestSWEDEN.Best = 0 AND `2010`.womenpbestSWEDEN.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`.womenpbestSWEDEN.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.womensbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womensbestSWEDEN.Best = 0 AND `2010`.womensbestSWEDEN.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.womenwl.BB IS NOT NULL THEN CASE WHEN `2010`.womenwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.womenwl.BB AS WL, CASE WHEN MONTH(yearwsweall.Date)>9 AND yearwsweall.Ind=1 THEN 2015-1 ELSE 2015 END AS Yeari, CONCAT(DAY(yearwsweall.DATE),'.',MONTH(yearwsweall.DATE),'.',SUBSTRING(YEAR(yearwsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltwat82757 inner join world.yearwsweall ON alltwat82757.IID=yearwsweall.IID INNER JOIN `2010`.events on yearwsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearwsweall.irr != 'MX' then yearwsweall.irr else '' END left join `2010`.womenpbestSWEDEN on `2010`.womenpbestSWEDEN.iid = yearwsweall.IID left join `2010`.womensbestSWEDEN on `2010`.womensbestSWEDEN.iid = yearwsweall.IID left join `2010`.womenwl on `2010`.womenwl.iid = yearwsweall.IID LEFT JOIN `2010`.sweevents2w ON yearwsweall.ENumber=sweevents2w.ENumber LEFT JOIN results.comp ON yearwsweall.CID=comp.CID LEFT JOIN world.coursew ON alltwat82757.IID=coursew.IID WHERE yearwsweall.Year = 2015 AND yearwsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal

2014

select DISTINCT sweevents2w.Eventname AS Eventswe, CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearwsweall.Eventname AS Eventeng, events.TF, yearwsweall.iid as IID, yearwsweall.*, alltwat82757.multi, alltwat82757.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.womenpbestSWEDEN.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN '' ELSE `2010`.womensbestSWEDEN.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womenpbestSWEDEN.Best = 0 AND `2010`.womenpbestSWEDEN.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`.womenpbestSWEDEN.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.womensbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womensbestSWEDEN.Best = 0 AND `2010`.womensbestSWEDEN.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.womenwl.BB IS NOT NULL THEN CASE WHEN `2010`.womenwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.womenwl.BB AS WL, CASE WHEN MONTH(yearwsweall.Date)>9 AND yearwsweall.Ind=1 THEN 2014-1 ELSE 2014 END AS Yeari, CONCAT(DAY(yearwsweall.DATE),'.',MONTH(yearwsweall.DATE),'.',SUBSTRING(YEAR(yearwsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltwat82757 inner join world.yearwsweall ON alltwat82757.IID=yearwsweall.IID INNER JOIN `2010`.events on yearwsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearwsweall.irr != 'MX' then yearwsweall.irr else '' END left join `2010`.womenpbestSWEDEN on `2010`.womenpbestSWEDEN.iid = yearwsweall.IID left join `2010`.womensbestSWEDEN on `2010`.womensbestSWEDEN.iid = yearwsweall.IID left join `2010`.womenwl on `2010`.womenwl.iid = yearwsweall.IID LEFT JOIN `2010`.sweevents2w ON yearwsweall.ENumber=sweevents2w.ENumber LEFT JOIN results.comp ON yearwsweall.CID=comp.CID LEFT JOIN world.coursew ON alltwat82757.IID=coursew.IID WHERE yearwsweall.Year = 2014 AND yearwsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal

2013

select DISTINCT sweevents2w.Eventname AS Eventswe, CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearwsweall.Eventname AS Eventeng, events.TF, yearwsweall.iid as IID, yearwsweall.*, alltwat82757.multi, alltwat82757.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.womenpbestSWEDEN.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN '' ELSE `2010`.womensbestSWEDEN.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womenpbestSWEDEN.Best = 0 AND `2010`.womenpbestSWEDEN.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`.womenpbestSWEDEN.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.womensbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womensbestSWEDEN.Best = 0 AND `2010`.womensbestSWEDEN.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.womenwl.BB IS NOT NULL THEN CASE WHEN `2010`.womenwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.womenwl.BB AS WL, CASE WHEN MONTH(yearwsweall.Date)>9 AND yearwsweall.Ind=1 THEN 2013-1 ELSE 2013 END AS Yeari, CONCAT(DAY(yearwsweall.DATE),'.',MONTH(yearwsweall.DATE),'.',SUBSTRING(YEAR(yearwsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltwat82757 inner join world.yearwsweall ON alltwat82757.IID=yearwsweall.IID INNER JOIN `2010`.events on yearwsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearwsweall.irr != 'MX' then yearwsweall.irr else '' END left join `2010`.womenpbestSWEDEN on `2010`.womenpbestSWEDEN.iid = yearwsweall.IID left join `2010`.womensbestSWEDEN on `2010`.womensbestSWEDEN.iid = yearwsweall.IID left join `2010`.womenwl on `2010`.womenwl.iid = yearwsweall.IID LEFT JOIN `2010`.sweevents2w ON yearwsweall.ENumber=sweevents2w.ENumber LEFT JOIN results.comp ON yearwsweall.CID=comp.CID LEFT JOIN world.coursew ON alltwat82757.IID=coursew.IID WHERE yearwsweall.Year = 2013 AND yearwsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal

2012

select DISTINCT sweevents2w.Eventname AS Eventswe, CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearwsweall.Eventname AS Eventeng, events.TF, yearwsweall.iid as IID, yearwsweall.*, alltwat82757.multi, alltwat82757.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.womenpbestSWEDEN.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN '' ELSE `2010`.womensbestSWEDEN.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womenpbestSWEDEN.Best = 0 AND `2010`.womenpbestSWEDEN.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`.womenpbestSWEDEN.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.womensbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womensbestSWEDEN.Best = 0 AND `2010`.womensbestSWEDEN.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.womenwl.BB IS NOT NULL THEN CASE WHEN `2010`.womenwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.womenwl.BB AS WL, CASE WHEN MONTH(yearwsweall.Date)>9 AND yearwsweall.Ind=1 THEN 2012-1 ELSE 2012 END AS Yeari, CONCAT(DAY(yearwsweall.DATE),'.',MONTH(yearwsweall.DATE),'.',SUBSTRING(YEAR(yearwsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltwat82757 inner join world.yearwsweall ON alltwat82757.IID=yearwsweall.IID INNER JOIN `2010`.events on yearwsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearwsweall.irr != 'MX' then yearwsweall.irr else '' END left join `2010`.womenpbestSWEDEN on `2010`.womenpbestSWEDEN.iid = yearwsweall.IID left join `2010`.womensbestSWEDEN on `2010`.womensbestSWEDEN.iid = yearwsweall.IID left join `2010`.womenwl on `2010`.womenwl.iid = yearwsweall.IID LEFT JOIN `2010`.sweevents2w ON yearwsweall.ENumber=sweevents2w.ENumber LEFT JOIN results.comp ON yearwsweall.CID=comp.CID LEFT JOIN world.coursew ON alltwat82757.IID=coursew.IID WHERE yearwsweall.Year = 2012 AND yearwsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal

2011

select DISTINCT sweevents2w.Eventname AS Eventswe, CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END AS ENumb, yearwsweall.Eventname AS Eventeng, events.TF, yearwsweall.iid as IID, yearwsweall.*, alltwat82757.multi, alltwat82757.tiimi, irrelagularities.*, CASE WHEN Windlegal = 2 THEN '' ELSE `2010`.womenpbestSWEDEN.BB END AS BPB, CASE WHEN Windlegal = 2 THEN '' ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN '' ELSE `2010`.womensbestSWEDEN.BB END END AS BSB, CASE WHEN Windlegal = 2 THEN 1 ELSE CASE WHEN `2010`.womenpbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womenpbestSWEDEN.Best = 0 AND `2010`.womenpbestSWEDEN.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`.womenpbestSWEDEN.BB IS NOT NULL THEN 1 ELSE CASE WHEN `2010`.womensbestSWEDEN.BB IS NOT NULL THEN CASE WHEN `2010`.womensbestSWEDEN.Best = 0 AND `2010`.womensbestSWEDEN.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END END END AS BSBe, CASE WHEN `2010`.womenwl.BB IS NOT NULL THEN CASE WHEN `2010`.womenwl.Roundi IS NOT NULL THEN 0 ELSE 1 END ELSE 1 END AS WLe, `2010`.womenwl.BB AS WL, CASE WHEN MONTH(yearwsweall.Date)>9 AND yearwsweall.Ind=1 THEN 2011-1 ELSE 2011 END AS Yeari, CONCAT(DAY(yearwsweall.DATE),'.',MONTH(yearwsweall.DATE),'.',SUBSTRING(YEAR(yearwsweall.DATE),-2)) AS Datu, courselength from tempdb2.alltwat82757 inner join world.yearwsweall ON alltwat82757.IID=yearwsweall.IID INNER JOIN `2010`.events on yearwsweall.ENumber=events.`Order` left join `2010`.irrelagularities on irrelagularities.irr = case when yearwsweall.irr != 'MX' then yearwsweall.irr else '' END left join `2010`.womenpbestSWEDEN on `2010`.womenpbestSWEDEN.iid = yearwsweall.IID left join `2010`.womensbestSWEDEN on `2010`.womensbestSWEDEN.iid = yearwsweall.IID left join `2010`.womenwl on `2010`.womenwl.iid = yearwsweall.IID LEFT JOIN `2010`.sweevents2w ON yearwsweall.ENumber=sweevents2w.ENumber LEFT JOIN results.comp ON yearwsweall.CID=comp.CID LEFT JOIN world.coursew ON alltwat82757.IID=coursew.IID WHERE yearwsweall.Year = 2011 AND yearwsweall.Event NOT LIKE '%TEAM%' HAVING BPBe = 1 AND BSBe = 1 AND WLe = 1 ORDER BY CASE WHEN yearwsweall.Event LIKE 'CC%' THEN 694 ELSE Ord END ASC,Date ASC, OrderPos ASC, Windlegal