4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
BUNDESLIGA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Salzburg Salzburg 27 57 19 35
2 Sturm Graz Sturm Graz 27 46 17 35
3 LASK LASK 27 31 23 24
4 Rapid Wien Rapid Wien 27 43 24 22
5 TSV Hartberg Hartberg 27 40 42 21
6 Austria Klagenfurt Austria 27 34 39 19
TEMPORADA 2022/2023
BUNDESLIGA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Wolfsberger AC Wolfsberger 32 51 51 31
2 Austria Lustenau Austria 32 50 54 29
3 WSG Tirol WSG Tirol 32 44 53 24
4 TSV Hartberg Hartberg 32 39 56 24
5 SCR Altach SCR Altach 32 29 53 19
6 SV Ried SV Ried 32 27 50 14
TEMPORADA 2021/2022
BUNDESLIGA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 WSG Tirol WSG Tirol 10 16 16 28
2 LASK LASK 10 16 13 26
3 SCR Altach SCR Altach 10 14 11 22
4 TSV Hartberg Hartberg 10 14 12 22
5 SV Ried SV Ried 10 9 13 22
6 Admira Admira 10 11 15 21
TEMPORADA 2020/2021
BUNDESLIGA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 TSV Hartberg Hartberg 32 38 48 32
2 Austria Wien Austria Wien 32 47 43 29
3 SV Ried SV Ried 32 34 57 25
4 SCR Altach SCR Altach 32 33 55 23
5 Admira Admira 32 27 58 19
6 SKN St. Polten Polten 32 39 57 13
TEMPORADA 2019/2020
BUNDESLIGA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Salzburg Salzburg 10 36 8 50
2 Rapid Wien Rapid Wien 10 17 17 38
3 Wolfsberger AC Wolfsberger 10 19 16 35
4 LASK LASK 10 17 17 33
5 TSV Hartberg Hartberg 10 16 24 27
6 Sturm Graz Sturm Graz 10 9 32 19
TEMPORADA 2018/2019
BUNDESLIGA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Rapid Wien Rapid Wien 10 22 15 32
2 SCR Altach SCR Altach 10 18 12 28
3 Mattersburg Mattersburg 10 13 12 28
4 Admira Admira 10 16 20 22
5 TSV Hartberg Hartberg 10 13 21 22
6 Wacker Innsbruck Wacker 10 15 17 20
TEMPORADA 2017/2018
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 Wacker Innsbruck Wacker 36 60 31 71
2 TSV Hartberg Hartberg 36 63 34 68
3 Wiener Neustadt Wiener 36 53 37 62
4 SV Ried SV Ried 36 68 41 61
5 Liefering Liefering 36 58 44 55
6 Austria Lustenau Austria 36 48 52 45
7 WSG Tirol WSG Tirol 36 45 56 40
8 Kapfenberger SV Kapfenberger 36 40 68 35
9 FAC Wien FAC Wien 36 37 75 30
10 Blau-Weiß Linz Blau-Weiß 36 35 69 26
TEMPORADA 2016/2017
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 TSV Hartberg Hartberg 30 74 38 62
2 SV Lafnitz SV Lafnitz 30 54 27 60
3 Gleisdorf Gleisdorf 30 53 35 59
4 Stadl-Paura Stadl-Paura 30 75 53 51
5 Deutschlandsberger Deutschlands 30 65 45 46
6 Vorwarts Steyr Vorwarts 30 56 49 44
7 Kalsdorf Kalsdorf 30 38 35 44
8 Gurten Gurten 30 39 43 42
9 Union St. Florian Union 30 36 46 39
10 Sturm Graz II Sturm Graz 30 42 51 38
11 Weiz Weiz 30 40 52 38
12 Austria Klagenfurt Austria 30 43 61 35
13 Allerheiligen Allerheilige 30 46 60 33
14 SV Pasching SV Pasching 30 43 49 31
15 Grieskirchen Grieskirchen 30 44 64 23
16 ATSV Wolfsberg ATSV 30 25 65 19
TEMPORADA 2015/2016
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Blau-Weiß Linz Blau-Weiß 30 89 25 70
2 TSV Hartberg Hartberg 30 64 38 60
3 Union St. Florian Union 30 53 35 52
4 Kalsdorf Kalsdorf 30 56 43 51
5 SV Pasching SV Pasching 30 59 46 50
6 SV Lafnitz SV Lafnitz 30 62 52 49
7 Stadl-Paura Stadl-Paura 30 58 49 48
8 Allerheiligen Allerheilige 30 50 43 48
9 Deutschlandsberger Deutschlands 30 49 43 43
10 Gurten Gurten 30 51 44 40
11 Sturm Graz II Sturm Graz 30 48 48 38
12 Vorwarts Steyr Vorwarts 30 36 49 34
13 Weiz Weiz 30 33 66 26
14 Wolfsberger AC II Wolfsberger 30 34 64 23
15 SV Wallern SV Wallern 30 35 70 22
16 Annabichler Austria Annabichler 30 24 86 19
TEMPORADA 2014/2015
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 Mattersburg Mattersburg 36 69 36 71
2 Liefering Liefering 36 70 55 65
3 LASK LASK 36 45 36 56
4 Kapfenberger SV Kapfenberger 36 52 45 49
5 SKN St. Polten Polten 36 39 41 49
6 Wacker Innsbruck Wacker 36 32 43 43
7 Austria Lustenau Austria 36 49 56 42
8 FAC Wien FAC Wien 36 40 49 41
9 Horn Horn 36 34 50 38
10 TSV Hartberg Hartberg 36 46 65 38
TEMPORADA 2013/2014
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 SCR Altach SCR Altach 36 79 41 73
2 Austria Lustenau Austria 36 57 36 59
3 Liefering Liefering 36 72 48 57
4 SKN St. Polten Polten 36 52 48 53
5 Kapfenberger SV Kapfenberger 36 55 48 52
6 Mattersburg Mattersburg 36 53 67 44
7 Horn Horn 36 52 70 44
8 TSV Hartberg Hartberg 36 41 60 44
9 Parndorf Parndorf 36 41 59 39
10 First Vienna First Vienna 36 36 61 20
TEMPORADA 2012/2013
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 Grödig Grödig 36 71 30 75
2 SCR Altach SCR Altach 36 57 39 65
3 Austria Lustenau Austria 36 60 39 61
4 SKN St. Polten Polten 36 65 60 54
5 Kapfenberger SV Kapfenberger 36 56 50 53
6 Horn Horn 36 50 55 46
7 First Vienna First Vienna 36 48 64 46
8 FC Lustenau FC Lustenau 36 44 66 38
9 TSV Hartberg Hartberg 36 35 54 33
10 Blau-Weiß Linz Blau-Weiß 36 38 67 26
TEMPORADA 2011/2012
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 WAC Sankt Andrä Sankt Andrä 36 71 49 68
2 SCR Altach SCR Altach 36 62 39 62
3 LASK LASK 36 55 40 61
4 Austria Lustenau Austria 36 59 47 58
5 SKN St. Polten Polten 36 45 45 51
6 Blau-Weiß Linz Blau-Weiß 36 49 52 49
7 Grödig Grödig 36 46 52 42
8 First Vienna First Vienna 36 44 56 37
9 FC Lustenau FC Lustenau 36 51 66 37
10 TSV Hartberg Hartberg 36 38 74 27
TEMPORADA 2010/2011
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 Admira Admira 36 85 45 75
2 SCR Altach SCR Altach 36 76 37 74
3 Austria Lustenau Austria 36 55 51 54
4 WAC Sankt Andrä Sankt Andrä 36 56 50 52
5 SKN St. Polten Polten 36 55 55 51
6 Grödig Grödig 36 51 60 46
7 FC Lustenau FC Lustenau 36 51 60 42
8 TSV Hartberg Hartberg 36 44 60 39
9 First Vienna First Vienna 36 47 67 34
10 Gratkorn Gratkorn 36 47 82 33

  USO DE MEMORIA  
6,079,256 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1474
Total Execution Time  0.1486
  CADENA URL  
/historico/Hartberg
  GET DATOS  
$_GET['/historico/Hartberg']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (49)  
0.0030  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 = 'Hartberg' 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.0018  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=12367 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=12367 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=12367 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=12367 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=12367 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0039  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 75596
0.0023  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 72330
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12367 AND type_rel = 2
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 12367 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (523342,887653,887837,1076481,1181602) ORDER BY n.cover_points DESC, update_date DESC
0.0043  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 = '12367' ORDER BY l.year DESC,cat.coefficient DESC
0.0027  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 = '12367' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '12367' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 72085 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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.0025  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=12367 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (75596,72330,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.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 75596 AND teamId = 12367
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 72330 AND teamId = 12367
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 12367
0.0020  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 75596 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '12367' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '12367' and rp.type = 4
0.0021  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '12367' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0031  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 = 75596 WHERE rp.league_id = 75596 AND rp.teamId = 12367 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.0029  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 = 75596 WHERE rp.league_id = 75596 AND rp.teamId = 12367 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 75596 WHERE rp.league_id = 75596 AND rp.teamId = 12367 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 = 12367 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0021  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 = 75596 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 67768 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.0022  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 = 71333 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.0027  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 = 63138 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.0021  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 = 66906 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.0022  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 = 58504 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.0022  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 = 61919 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.0021  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 = 50148 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.0021  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 = 55611 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.0021  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 `tables2019` 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 = 43673 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2019` 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 = 49412 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 38776 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 33372 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 15759 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 3909 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 2764 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 8928 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 8927 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 8926 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 75596 ORDER BY nameShow LIMIT 100