4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Weiz
TEMPORADA 2023/2024
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Voitsberg Voitsberg 25 68 21 58
2 Hertha Wels Hertha Wels 25 51 25 46
3 Gurten Gurten 25 36 19 44
4 SV Wallern SV Wallern 26 55 41 44
5 FC Juniors OÖ Juniors 24 50 31 37
6 Vorwarts Steyr Vorwarts 25 28 31 35
7 Weindorf  St. Anna Weindorf 25 32 47 35
8 Weiz Weiz 25 43 49 34
9 Deutschlandsberger Deutschlands 25 43 35 33
10 Gleisdorf Gleisdorf 25 37 34 33
11 ASK Kla­gen­furt Kla­gen­fu 25 41 49 31
12 Vöcklamarkt Vöcklamarkt 25 28 48 28
13 Allerheiligen Allerheilige 25 39 56 27
14 TUS Bad Gleichenberg Gleichenberg 25 39 60 26
15 Wolfsberger AC II Wolfsberger 25 36 56 25
16 SV Ried II SV Ried II 25 42 66 24
TEMPORADA 2022/2023
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Leoben Leoben 30 76 22 72
2 FC Juniors OÖ Juniors 30 84 30 69
3 Hertha Wels Hertha Wels 30 63 35 63
4 Gurten Gurten 30 44 29 55
5 TUS Bad Gleichenberg Gleichenberg 30 65 56 49
6 Deutschlandsberger Deutschlands 30 53 46 47
7 SV Ried II SV Ried II 30 47 47 47
8 Weindorf  St. Anna Weindorf 30 48 53 39
9 Wolfsberger AC II Wolfsberger 30 49 48 36
10 Gleisdorf Gleisdorf 30 49 50 36
11 Vöcklamarkt Vöcklamarkt 30 29 44 33
12 Weiz Weiz 30 45 64 31
13 Allerheiligen Allerheilige 30 35 56 28
14 Treibach Treibach 30 37 65 25
15 Kalsdorf Kalsdorf 30 30 70 23
16 SAK Klagenfurt Klagenfurt 30 29 68 14
TEMPORADA 2021/2022
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Sturm Graz II Sturm Graz 32 105 29 72
2 Deutschlandsberger Deutschlands 32 62 26 63
3 Gurten Gurten 32 63 31 62
4 Hertha Wels Hertha Wels 32 64 34 56
5 WAC Sankt Andrä II Sankt Andrä 32 71 50 56
6 Vöcklamarkt Vöcklamarkt 32 46 41 52
7 TUS Bad Gleichenberg Gleichenberg 32 56 47 51
8 Allerheiligen Allerheilige 32 52 48 47
9 Weindorf  St. Anna Weindorf 32 61 54 44
10 Gleisdorf Gleisdorf 32 50 53 44
11 Weiz Weiz 32 47 56 43
12 SV Ried II SV Ried II 32 50 63 36
13 Kalsdorf Kalsdorf 32 46 54 35
14 Treibach Treibach 32 56 73 35
15 Wels Wels 32 47 71 33
16 Spittal Spittal 32 25 60 18
17 Stadl-Paura Stadl-Paura 32 18 129 6
TEMPORADA 2020/2021
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Gleisdorf Gleisdorf 13 26 17 27
2 Weindorf  St. Anna Weindorf 12 33 15 26
3 TUS Bad Gleichenberg Gleichenberg 13 31 18 26
4 Gurten Gurten 13 22 13 26
5 Hertha Wels Hertha Wels 14 34 23 25
6 Sturm Graz II Sturm Graz 13 23 17 23
7 Kalsdorf Kalsdorf 13 20 19 22
8 Wolfsberger AC II Wolfsberger 13 21 18 18
9 Weiz Weiz 13 24 20 16
10 Deutschlandsberger Deutschlands 13 29 27 16
11 Allerheiligen Allerheilige 11 26 24 13
12 SV Ried II SV Ried II 12 20 28 12
13 Stadl-Paura Stadl-Paura 13 20 32 11
14 Spittal Spittal 12 10 25 9
15 Vöcklamarkt Vöcklamarkt 13 11 28 8
16 Wels Wels 13 14 40 7
TEMPORADA 2019/2020
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Sturm Graz II Sturm Graz 17 39 20 34
2 Allerheiligen Allerheilige 17 35 23 33
3 Hertha Wels Hertha Wels 17 42 26 32
4 Gurten Gurten 17 35 19 31
5 TUS Bad Gleichenberg Gleichenberg 17 44 33 29
6 Wolfsberger AC II Wolfsberger 17 39 30 29
7 Vöcklamarkt Vöcklamarkt 17 41 34 29
8 Weindorf  St. Anna Weindorf 17 29 20 28
9 Weiz Weiz 17 37 29 27
10 Gleisdorf Gleisdorf 17 34 26 27
11 Deutschlandsberger Deutschlands 17 31 24 22
12 Kalsdorf Kalsdorf 17 18 28 20
13 SV Ried II SV Ried II 17 25 32 15
14 ATSV Wolfsberg ATSV 17 26 36 14
15 Stadl-Paura Stadl-Paura 17 15 72 7
16 Wels Wels 17 13 51 6
TEMPORADA 2018/2019
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Grazer AK Grazer AK 30 70 28 68
2 Gleisdorf Gleisdorf 30 62 37 54
3 TUS Bad Gleichenberg Gleichenberg 30 70 51 51
4 Vöcklamarkt Vöcklamarkt 30 61 48 51
5 Stadl-Paura Stadl-Paura 30 56 51 51
6 Allerheiligen Allerheilige 30 53 37 48
7 Sturm Graz II Sturm Graz 30 60 46 47
8 Wolfsberger AC II Wolfsberger 30 61 48 46
9 Weiz Weiz 30 65 54 45
10 Deutschlandsberger Deutschlands 30 57 52 44
11 Gurten Gurten 30 41 41 39
12 Hertha Wels Hertha Wels 30 56 64 38
13 Kalsdorf Kalsdorf 30 43 56 35
14 Völkermarkt Völkermarkt 30 31 73 20
15 Lendorf Lendorf 30 32 77 20
16 Wels Wels 30 30 85 16
TEMPORADA 2017/2018
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 SV Lafnitz SV Lafnitz 30 70 16 67
2 Gleisdorf Gleisdorf 30 60 33 57
3 Vorwarts Steyr Vorwarts 30 70 38 55
4 FC Juniors OÖ Juniors 30 54 46 52
5 Austria Klagenfurt Austria 30 57 48 48
6 Allerheiligen Allerheilige 30 59 41 47
7 Vöcklamarkt Vöcklamarkt 30 52 43 47
8 Deutschlandsberger Deutschlands 30 50 43 47
9 Sturm Graz II Sturm Graz 30 45 48 42
10 TUS Bad Gleichenberg Gleichenberg 30 44 54 39
11 Gurten Gurten 30 45 46 37
12 Wolfsberger AC II Wolfsberger 30 41 63 33
13 Weiz Weiz 30 43 58 32
14 Kalsdorf Kalsdorf 30 36 52 29
15 Stadl-Paura Stadl-Paura 30 32 67 27
16 Union St. Florian Union 30 14 76 13
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
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Austria Klagenfurt Austria 29 66 24 64
2 Vorwarts Steyr Vorwarts 29 43 29 56
3 Weiz Weiz 29 55 39 53
4 SV Lafnitz SV Lafnitz 29 54 27 52
5 Blau-Weiß Linz Blau-Weiß 29 49 34 51
6 Allerheiligen Allerheilige 29 52 42 48
7 Sturm Graz II Sturm Graz 29 50 41 43
8 Kalsdorf Kalsdorf 29 51 49 40
9 Wolfsberger AC II Wolfsberger 29 39 42 40
10 SV Pasching SV Pasching 29 45 49 40
11 Gurten Gurten 29 36 45 37
12 SV Wallern SV Wallern 29 35 46 34
13 Union St. Florian Union 29 32 54 30
14 SAK Klagenfurt Klagenfurt 29 29 61 24
15 Vöcklamarkt Vöcklamarkt 29 25 44 21
16 ATSV Wolfsberg ATSV 29 21 56 16
TEMPORADA 2013/2014
CUARTA AUSTRIA GRUPO 5
Equipo PJ GF GC Puntos
1 Weiz Weiz 30 71 19 72
2 Gleisdorf Gleisdorf 30 70 39 61
3 Deutschlandsberger Deutschlands 30 72 42 59
4 SV Gleinstätten Gleinstätte 30 56 43 53
5 SV Union Gnas Union Gnas 30 43 34 46
6 TUS Heiligenkreuz Heiligenkreu 30 65 59 45
7 Frohnleiten Frohnleiten 30 53 49 42
8 Voitsberg Voitsberg 30 47 45 41
9 Leoben Leoben 30 40 44 39
10 SC Fürstenfeld Fürstenfeld 30 45 45 37
11 Gratkorn Gratkorn 30 41 55 32
12 SV ADA Anger Anger 30 35 47 31
13 Liezen Liezen 30 38 55 31
14 Wildon Wildon 30 38 59 30
15 Grossklein Grossklein 30 27 65 20
16 Irdning Irdning 30 32 73 18
TEMPORADA 2012/2013
CUARTA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 SV Lafnitz SV Lafnitz 30 80 36 63
2 Weiz Weiz 30 60 33 60
3 SV Gleinstätten Gleinstätte 30 61 41 53
4 Deutschlandsberger Deutschlands 30 58 49 51
5 Gleisdorf Gleisdorf 30 63 44 47
6 Frohnleiten Frohnleiten 30 47 48 47
7 SC Fürstenfeld Fürstenfeld 30 52 44 45
8 Voitsberg Voitsberg 30 50 39 42
9 Liezen Liezen 30 44 42 40
10 Wildon Wildon 30 43 62 38
11 TUS Heiligenkreuz Heiligenkreu 30 45 59 35
12 SV ADA Anger Anger 30 38 52 34
13 SV Pachern SV Pachern 30 50 60 32
14 Gratkorn II Gratkorn II 30 37 65 30
15 SVA Kindberg Kindberg 30 29 55 29
16 Zeltweg Zeltweg 30 33 61 25
TEMPORADA 2011/2012
CUARTA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Kalsdorf Kalsdorf 30 74 38 64
2 Weiz Weiz 30 67 36 55
3 Liezen Liezen 30 57 33 54
4 Gleisdorf Gleisdorf 30 62 32 51
5 Voitsberg Voitsberg 30 57 42 46
6 SC Fürstenfeld Fürstenfeld 30 51 54 46
7 SV Lafnitz SV Lafnitz 30 64 59 44
8 SVA Kindberg Kindberg 30 50 47 43
9 SV ADA Anger Anger 30 60 56 42
10 Frohnleiten Frohnleiten 30 41 44 39
11 SV Pachern SV Pachern 30 43 65 35
12 Wildon Wildon 30 56 62 34
13 Gratkorn II Gratkorn II 30 42 73 33
14 Irdning Irdning 30 32 69 28
15 Grossklein Grossklein 30 49 68 26
16 Mürzhofen/Allerheiligen Mürzhofen/A 30 36 63 26
TEMPORADA 2010/2011
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 LASK Juniors LASK Juniors 30 55 37 58
2 Blau-Weiß Linz Blau-Weiß 30 55 27 57
3 Grazer AK Grazer AK 30 59 37 54
4 Allerheiligen Allerheilige 30 45 29 52
5 Union St. Florian Union 30 43 37 45
6 SV Pasching SV Pasching 30 38 33 45
7 Austria Klagenfurt Austria 30 42 37 43
8 SV Gleinstätten Gleinstätte 30 49 49 41
9 Vöcklamarkt Vöcklamarkt 30 45 45 38
10 SAK Klagenfurt Klagenfurt 30 38 40 38
11 Leoben Leoben 30 47 51 37
12 Sturm Graz II Sturm Graz 30 48 61 34
13 Wels Wels 30 21 42 33
14 Feldkirchen Feldkirchen 30 36 55 27
15 Weiz Weiz 30 34 53 26
16 Voitsberg Voitsberg 30 30 52 21
TEMPORADA 2009/2010
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 SV Pasching SV Pasching 30 77 24 63
2 WAC Sankt Andrä Sankt Andrä 30 66 32 61
3 Blau-Weiß Linz Blau-Weiß 30 49 31 55
4 St. Stefan St. Stefan 30 51 37 51
5 Grazer AK Grazer AK 30 57 40 50
6 Union St. Florian Union 30 58 38 47
7 Allerheiligen Allerheilige 30 57 49 46
8 Weiz Weiz 30 54 48 45
9 Voitsberg Voitsberg 30 48 44 45
10 Leoben Leoben 30 46 46 42
11 SAK Klagenfurt Klagenfurt 30 40 50 39
12 Wels Wels 30 44 50 37
13 Sturm Graz II Sturm Graz 30 50 50 35
14 SVL Flavia Solva Flavia Solva 30 46 59 27
15 St. Veit Glan Veit Glan 30 36 76 25
16 Bad Aussee Bad Aussee 30 14 119 5
TEMPORADA 2008/2009
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 TSV Hartberg Hartberg 30 63 25 64
2 Grazer AK Grazer AK 30 68 32 64
3 Sturm Graz II Sturm Graz 30 52 32 56
4 Voitsberg Voitsberg 30 65 37 54
5 WAC Sankt Andrä Sankt Andrä 30 41 30 54
6 Wels Wels 30 62 51 47
7 Blau-Weiß Linz Blau-Weiß 30 50 35 43
8 Union St. Florian Union 30 49 41 40
9 SAK Klagenfurt Klagenfurt 30 46 46 38
10 Allerheiligen Allerheilige 30 38 38 38
11 Weiz Weiz 30 48 52 34
12 St. Veit Glan Veit Glan 30 43 62 30
13 Bad Aussee Bad Aussee 30 29 66 28
14 Feldkirchen Feldkirchen 30 39 66 27
15 FC Kärnten FC Kärnten 30 22 70 23
16 Spittal Spittal 30 31 63 19
TEMPORADA 2007/2008
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Vöcklabruck Vöcklabruck 30 70 23 68
2 Feldkirchen Feldkirchen 30 66 45 52
3 Grazer AK Grazer AK 30 57 37 52
4 WAC Sankt Andrä Sankt Andrä 30 41 26 52
5 Sturm Graz II Sturm Graz 30 52 40 52
6 Allerheiligen Allerheilige 30 40 35 52
7 TSV Hartberg Hartberg 30 45 38 44
8 Wels Wels 30 57 46 43
9 SAK Klagenfurt Klagenfurt 30 44 43 41
10 Union St. Florian Union 30 44 45 38
11 Austria Kärnten II Austria 30 40 52 38
12 Weiz Weiz 30 45 47 35
13 Spittal Spittal 30 34 42 30
14 Gmunden Gmunden 30 33 69 26
15 Grieskirchen Grieskirchen 30 30 55 22
16 Bleiburg Bleiburg 30 19 74 10

  USO DE MEMORIA  
7,308,688 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1203
Total Execution Time  0.1216
  CADENA URL  
/historico/Weiz
  GET DATOS  
$_GET['/historico/Weiz']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0064  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 = 72354
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19088 AND type_rel = 2
0.0028  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 = '19088' ORDER BY l.year DESC,cat.coefficient DESC
0.0026  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 = '19088' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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 = 72354 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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=19088 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 (72354,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.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 72354 AND teamId = 19088
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 72330 AND teamId = 19088
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 19088
0.0021  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 = '19088' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '19088' and rp.type = 4
0.0022  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 = '19088' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0041  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 = 72354 WHERE rp.league_id = 72354 AND rp.teamId = 19088 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.0041  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 = 72354 WHERE rp.league_id = 72354 AND rp.teamId = 19088 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 = 72354 WHERE rp.league_id = 72354 AND rp.teamId = 19088 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 19088 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0025  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 = 72354 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 68176 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 63402 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 57019 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 50223 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 44211 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 38883 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 27166 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 27164 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 27202 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036  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 = 24541 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC