4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 Grazer AK Grazer AK 24 43 22 55
2 SV Ried SV Ried 25 56 20 47
3 Leoben Leoben 25 42 26 44
4 Admira Admira 24 37 25 40
5 FAC Wien FAC Wien 24 36 25 40
6 Liefering Liefering 24 39 33 36
7 First Vienna First Vienna 24 38 34 36
8 Horn Horn 25 34 40 36
9 SKN St. Polten Polten 24 39 40 35
10 SV Lafnitz SV Lafnitz 25 39 44 33
11 SW Bregenz SW Bregenz 24 35 35 32
12 Kapfenberger SV Kapfenberger 25 30 40 29
13 Stripfing Stripfing 24 31 47 27
14 Dornbirn Dornbirn 24 22 42 23
15 Sturm Graz II Sturm Graz 24 32 53 20
16 SKU Amstetten Amstetten 25 22 49 11
TEMPORADA 2022/2023
TERCERA AUSTRIA GRUPO 8
Equipo PJ GF GC Puntos
1 SW Bregenz SW Bregenz 10 16 7 21
2 Bischofshofen Bischofshofe 10 22 15 17
3 Hohenems Hohenems 10 21 19 17
4 Kufstein Kufstein 10 22 22 12
5 Pinzgau Saalfelden Pinzgau 10 13 16 9
6 Reichenau Reichenau 10 13 28 5
TEMPORADA 2021/2022
TERCERA AUSTRIA GRUPO 10
Equipo PJ GF GC Puntos
1 Rotenberg Rotenberg 8 11 6 30
2 Röthis Röthis 8 13 11 30
3 SW Bregenz SW Bregenz 8 20 7 29
4 Lauterach Lauterach 8 18 10 27
5 Wolfurt Wolfurt 8 14 15 27
6 Rot-Weiß Rankweil Rot-Weiß 8 12 15 23
7 Egg Egg 8 22 24 18
8 Dornbirner SV Dornbirner 8 10 18 18
9 Austria Lustenau II Austria 8 9 23 8
TEMPORADA 2020/2021
TERCERA AUSTRIA GRUPO 6
Equipo PJ GF GC Puntos
1 Austria Lustenau II Austria 0 0 0 0
2 SW Bregenz SW Bregenz 0 0 0 0
3 Dornbirner SV Dornbirner 0 0 0 0
4 Rot-Weiß Rankweil Rot-Weiß 0 0 0 0
5 Rotenberg Rotenberg 0 0 0 0
6 Röthis Röthis 0 0 0 0
7 Wolfurt Wolfurt 0 0 0 0
TEMPORADA 2019/2020
TERCERA AUSTRIA GRUPO 7
Equipo PJ GF GC Puntos
1 SW Bregenz SW Bregenz 0 0 0 15
2 SC Rheindorf Altach II Rheindorf 0 0 0 14
3 Langenegg Langenegg 0 0 0 14
4 Röthis Röthis 0 0 0 10
5 Wolfurt Wolfurt 0 0 0 10
6 Lauterach Lauterach 0 0 0 9
7 Austria Lustenau II Austria 0 0 0 8
8 Rot-Weiß Rankweil Rot-Weiß 0 0 0 6
TEMPORADA 2017/2018
CUARTA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Langenegg Langenegg 30 72 41 62
2 Röthis Röthis 30 71 44 54
3 Dornbirner SV Dornbirner 30 78 50 51
4 FC Höchst FC Höchst 30 58 40 51
5 Egg Egg 30 67 50 51
6 SW Bregenz SW Bregenz 30 59 50 51
7 Lauterach Lauterach 30 70 62 48
8 Wolfurt Wolfurt 30 54 62 46
9 Andelsbuch Andelsbuch 30 65 60 41
10 Rot-Weiß Rankweil Rot-Weiß 30 61 58 40
11 Nenzing Nenzing 30 61 57 39
12 Austria Lustenau II Austria 30 58 61 39
13 Admira Dornbirn Admira 30 63 60 37
14 Fussach Fussach 30 48 66 31
15 Blau-Weiß Feldkirch Blau-Weiß 30 45 77 21
16 Schwarzach Schwarzach 30 22 114 5
TEMPORADA 2016/2017
CUARTA AUSTRIA GRUPO 8
Equipo PJ GF GC Puntos
1 Langenegg Langenegg 30 79 39 60
2 Alberschwende Alberschwend 30 56 47 50
3 Dornbirner SV Dornbirner 30 79 73 46
4 Andelsbuch Andelsbuch 30 44 40 45
5 Admira Dornbirn Admira 30 53 57 44
6 Austria Lustenau II Austria 30 56 48 43
7 SW Bregenz SW Bregenz 30 72 73 42
8 Rot-Weiß Rankweil Rot-Weiß 30 63 57 41
9 Wolfurt Wolfurt 30 55 49 41
10 FC Höchst FC Höchst 30 47 45 41
11 Röthis Röthis 30 60 61 40
12 Lauterach Lauterach 30 51 52 40
13 Egg Egg 30 63 71 38
14 Nenzing Nenzing 30 57 70 33
15 Bizau Bizau 30 53 74 31
16 Kennelbach Kennelbach 30 40 72 29
TEMPORADA 2015/2016
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 WSG Tirol WSG Tirol 30 81 18 75
2 USK Anif USK Anif 30 76 46 57
3 St. Johann St. Johann 30 59 32 55
4 Dornbirn Dornbirn 30 58 39 50
5 Schwaz Schwaz 30 44 40 46
6 USC Eugendorf Eugendorf 30 56 63 43
7 FC Wacker Innsbruck II Wacker 30 54 45 42
8 Pinzgau Saalfelden Pinzgau 30 51 59 39
9 Seekirchen Seekirchen 30 50 58 39
10 SC Rheindorf Altach II Rheindorf 30 33 48 38
11 Kufstein Kufstein 30 43 45 37
12 Hard Hard 30 35 42 36
13 TSV Neumarkt Neumarkt 30 43 61 36
14 SW Bregenz SW Bregenz 30 42 63 33
15 Kitzbühel Kitzbühel 30 53 59 32
16 Reichenau Reichenau 30 28 88 13
TEMPORADA 2014/2015
CUARTA AUSTRIA GRUPO 9
Equipo PJ GF GC Puntos
1 SW Bregenz SW Bregenz 26 52 34 49
2 Hohenems Hohenems 26 59 47 44
3 Röthis Röthis 26 53 41 44
4 Egg Egg 26 43 30 43
5 Andelsbuch Andelsbuch 26 39 40 43
6 Meiningen Meiningen 26 34 30 37
7 Austria Lustenau II Austria 26 60 50 36
8 Alberschwende Alberschwend 26 41 39 36
9 Wolfurt Wolfurt 26 38 37 34
10 Admira Dornbirn Admira 26 34 47 33
11 Rot-Weiß Rankweil Rot-Weiß 26 33 45 32
12 Lauterach Lauterach 26 37 43 29
13 Nenzing Nenzing 26 34 50 26
14 Blau-Weiß Feldkirch Blau-Weiß 26 24 48 21
TEMPORADA 2013/2014
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Austria Salzburg Austria 30 96 15 79
2 WSG Tirol WSG Tirol 30 88 36 70
3 TSV Neumarkt Neumarkt 30 67 41 53
4 St. Johann St. Johann 30 59 57 47
5 SC Rheindorf Altach II Rheindorf 30 51 51 46
6 Schwaz Schwaz 30 45 42 45
7 FC Wacker Innsbruck II Wacker 30 51 61 40
8 Kufstein Kufstein 30 49 58 36
9 Dornbirn Dornbirn 30 50 51 34
10 Seekirchen Seekirchen 30 44 48 34
11 Hard Hard 30 38 65 34
12 FC Höchst FC Höchst 30 35 51 33
13 USC Eugendorf Eugendorf 30 44 69 33
14 USK Anif USK Anif 30 43 56 31
15 SW Bregenz SW Bregenz 30 50 75 29
16 Wals-Grünau Wals-Grünau 30 36 70 27
TEMPORADA 2012/2013
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Liefering Liefering 30 94 23 74
2 Austria Salzburg Austria 30 77 21 68
3 WSG Tirol WSG Tirol 30 73 49 59
4 Kufstein Kufstein 30 70 41 54
5 SW Bregenz SW Bregenz 30 57 43 48
6 USK Anif USK Anif 30 50 43 47
7 Seekirchen Seekirchen 30 43 44 43
8 Dornbirn Dornbirn 30 48 51 41
9 FC Wacker Innsbruck II Wacker 30 60 60 40
10 St. Johann St. Johann 30 39 44 37
11 SC Rheindorf Altach II Rheindorf 30 41 49 36
12 TSV Neumarkt Neumarkt 30 47 69 34
13 Hard Hard 30 36 64 32
14 Wals-Grünau Wals-Grünau 30 37 69 23
15 Andelsbuch Andelsbuch 30 32 75 23
16 Pinzgau Saalfelden Pinzgau 30 27 86 13
TEMPORADA 2011/2012
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 WSG Tirol WSG Tirol 30 67 14 76
2 USK Anif USK Anif 30 82 38 70
3 Dornbirn Dornbirn 30 72 30 64
4 RB Juniors Salzburg Juniors 30 72 48 52
5 Kufstein Kufstein 30 58 44 46
6 FC Wacker Innsbruck II Wacker 30 58 53 45
7 SC Rheindorf Altach II Rheindorf 30 50 44 40
8 Austria Salzburg Austria 30 54 54 40
9 St. Johann St. Johann 30 43 48 39
10 SW Bregenz SW Bregenz 30 47 45 38
11 Pinzgau Saalfelden Pinzgau 30 50 55 38
12 Hard Hard 30 39 66 32
13 TSV Neumarkt Neumarkt 30 44 71 31
14 Union Innsbruck Union 30 35 87 24
15 Seekirchen Seekirchen 30 33 65 20
16 SV Hall SV Hall 30 27 69 18
TEMPORADA 2010/2011
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 RB Juniors Salzburg Juniors 30 78 23 68
2 WSG Tirol WSG Tirol 30 64 40 59
3 USK Anif USK Anif 30 66 37 55
4 Kufstein Kufstein 30 67 45 55
5 Austria Salzburg Austria 30 61 37 54
6 Dornbirn Dornbirn 30 62 35 53
7 SW Bregenz SW Bregenz 30 58 51 43
8 FC Wacker Innsbruck II Wacker 30 56 60 40
9 St. Johann St. Johann 30 39 41 39
10 Hard Hard 30 49 57 38
11 SC Rheindorf Altach II Rheindorf 30 49 62 37
12 TSV Neumarkt Neumarkt 30 34 61 33
13 Union Innsbruck Union 30 39 74 29
14 Seekirchen Seekirchen 30 48 75 28
15 Reichenau Reichenau 30 52 82 23
16 FC Höchst FC Höchst 30 35 77 15
TEMPORADA 2009/2010
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Grödig Grödig 30 100 23 76
2 WSG Tirol WSG Tirol 30 78 39 61
3 USK Anif USK Anif 30 82 47 59
4 FC Wacker Innsbruck II Wacker 30 64 46 53
5 Kufstein Kufstein 30 69 51 51
6 Seekirchen Seekirchen 30 70 54 51
7 SW Bregenz SW Bregenz 30 76 44 50
8 Hard Hard 30 82 53 49
9 St. Johann St. Johann 30 66 64 42
10 TSV Neumarkt Neumarkt 30 48 57 40
11 Reichenau / Union Reichenau 30 73 75 36
12 SC Rheindorf Altach II Rheindorf 30 43 62 36
13 Schwaz Schwaz 30 37 64 33
14 Blau-Weiß Feldkirch Blau-Weiß 30 50 78 28
15 Axams / Götzens Axams 30 54 98 14
16 Hohenems Hohenems 30 19 156 1
TEMPORADA 2008/2009
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Dornbirn Dornbirn 30 62 25 63
2 WSG Tirol WSG Tirol 30 85 39 58
3 USK Anif USK Anif 30 52 29 58
4 Hard Hard 30 77 35 56
5 SW Bregenz SW Bregenz 30 77 46 53
6 Kufstein Kufstein 30 66 46 49
7 Reichenau / Union Reichenau 30 63 55 44
8 Axams / Götzens Axams 30 62 61 43
9 St. Johann St. Johann 30 43 41 41
10 Hohenems Hohenems 30 48 48 41
11 Seekirchen Seekirchen 30 49 53 37
12 Schwaz Schwaz 30 42 50 37
13 Blau-Weiß Feldkirch Blau-Weiß 30 36 56 33
14 SV Hall SV Hall 30 36 60 32
15 FC Höchst FC Höchst 30 34 59 31
16 Rot-Weiß Rankweil Rot-Weiß 30 13 142 0
TEMPORADA 2007/2008
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Grödig Grödig 30 72 25 68
2 Kufstein Kufstein 30 73 49 54
3 Hard Hard 30 53 38 54
4 SV Hall SV Hall 30 47 41 49
5 WSG Tirol WSG Tirol 30 54 42 47
6 Blau-Weiß Feldkirch Blau-Weiß 30 56 42 44
7 Seekirchen Seekirchen 30 51 43 43
8 Axams / Götzens Axams 30 54 47 42
9 USK Anif USK Anif 30 45 45 40
10 Dornbirn Dornbirn 30 48 50 40
11 FC Höchst FC Höchst 30 54 52 39
12 SW Bregenz SW Bregenz 30 61 66 37
13 Reichenau / Union Reichenau 30 49 62 37
14 Rot-Weiß Rankweil Rot-Weiß 30 36 53 36
15 Kundl Kundl 30 45 64 28
16 Innsbrucker AC Innsbrucker 30 39 118 8

  USO DE MEMORIA  
6,915,192 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6066
Total Execution Time  0.6078
  CADENA URL  
/historico/Schwarz-Weis-Bregenz
  GET DATOS  
$_GET['/historico/Schwarz-Weis-Bregenz']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0138  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Schwarz-Weis-Bregenz' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62246 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62246 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62246 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=62246 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=62246 AND type_rel = 2
0.0131  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '62246' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0131  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '62246' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72330 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=62246 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (72330,72086,71436,71432) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 72086 AND teamId = 62246
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 71436 AND teamId = 62246
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 72330 AND teamId = 62246
0.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 62246
0.0138  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72086 WHERE rp.league_id = 72086 AND rp.teamId = 62246 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72086 WHERE rp.league_id = 72086 AND rp.teamId = 62246 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72086 WHERE rp.league_id = 72086 AND rp.teamId = 62246 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 62246 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 72086 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 68179 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 71436 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 63401 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 67323 AND t.round = 9 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2021` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 57022 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2021` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 62251 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 50650 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 51817 AND t.round = 2 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2018` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 38909 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2017` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 38905 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2016` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 15760 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2015` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 3943 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2014` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 2768 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2013` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 24525 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2012` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 24528 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2011` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 24531 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2010` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 24534 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2009` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 24537 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2008` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 24540 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC