4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Donau Linz
TEMPORADA 2021/2022
CUARTA AUSTRIA GRUPO 6
Equipo PJ GF GC Puntos
1 Weißkirchen / Allhaming Weißkirchen 30 76 35 71
2 Oedt Oedt 30 76 33 66
3 St. Martin im Muhlreis Martin 30 77 38 63
4 St. Valentin Valentin 30 58 56 48
5 SV Wallern SV Wallern 30 68 53 46
6 Union Mondsee Union 30 57 50 46
7 Union Perg Union Perg 30 51 53 44
8 Union Edelweiß Union 30 50 53 39
9 SV Friedburg Friedburg 30 57 62 38
10 Kornspitz Pregarten Kornspitz 30 43 43 38
11 Grün-Weiß Micheldorf Grün-Weiß 30 45 47 36
12 Zebau Bad Ischl Zebau Ischl 30 63 70 35
13 Pöttinger Grieskirchen Pöttinger 30 49 70 34
14 Union St. Florian Union 30 44 60 32
15 Donau Linz Donau Linz 30 26 77 19
16 Bad Schallerbach Schallerbach 30 40 80 18
TEMPORADA 2020/2021
CUARTA AUSTRIA GRUPO 4
Equipo PJ GF GC Puntos
TEMPORADA 2019/2020
CUARTA AUSTRIA GRUPO 5
Equipo PJ GF GC Puntos
1 SV Wallern SV Wallern 16 38 17 35
2 Weißkirchen / Allhaming Weißkirchen 16 34 16 35
3 Oedt Oedt 16 30 22 31
4 Bad Schallerbach Schallerbach 16 26 20 27
5 Kornspitz Pregarten Kornspitz 16 24 23 24
6 St. Valentin Valentin 16 24 22 23
7 Zebau Bad Ischl Zebau Ischl 16 30 29 22
8 St. Martin im Muhlreis Martin 16 22 21 22
9 SV Friedburg Friedburg 16 33 33 22
10 Union Edelweiß Union 16 27 28 19
11 Union St. Florian Union 16 13 18 18
12 Pöttinger Grieskirchen Pöttinger 16 16 28 18
13 Grün-Weiß Micheldorf Grün-Weiß 16 20 34 17
14 Donau Linz Donau Linz 16 27 33 15
15 Union Mondsee Union 16 14 27 14
16 Union Perg Union Perg 16 17 24 11
TEMPORADA 2018/2019
CUARTA AUSTRIA GRUPO 6
Equipo PJ GF GC Puntos
1 Oedt Oedt 30 77 26 66
2 SV Ried II SV Ried II 30 59 26 63
3 Union Weißkirchen Union 30 52 38 57
4 SV Wallern SV Wallern 30 58 46 48
5 Donau Linz Donau Linz 30 53 46 47
6 St. Valentin Valentin 30 51 45 43
7 Union Edelweiß Union 30 45 30 41
8 Union St. Florian Union 30 39 33 40
9 Pöttinger Grieskirchen Pöttinger 30 39 51 40
10 Kornspitz Pregarten Kornspitz 30 43 49 39
11 Zebau Bad Ischl Zebau Ischl 30 42 60 37
12 Grün-Weiß Micheldorf Grün-Weiß 30 32 44 33
13 Union Perg Union Perg 30 38 49 32
14 St. Martin im Muhlreis Martin 30 30 50 27
15 Gmunden Gmunden 30 32 59 26
16 Marchtrenk Marchtrenk 30 33 71 23
TEMPORADA 2017/2018
CUARTA AUSTRIA GRUPO 7
Equipo PJ GF GC Puntos
1 Oedt Oedt 30 89 30 72
2 Hertha Wels Hertha Wels 30 89 42 63
3 SV Wallern SV Wallern 30 67 38 61
4 Wels Wels 30 61 45 54
5 Union Edelweiß Union 30 54 53 41
6 Union Perg Union Perg 30 30 36 40
7 Donau Linz Donau Linz 30 39 46 39
8 Union Weißkirchen Union 30 43 42 38
9 Gmunden Gmunden 30 41 43 37
10 Bad Ischl Bad Ischl 30 51 58 37
11 St. Valentin Valentin 30 41 57 36
12 Grün-Weiß Micheldorf Grün-Weiß 30 36 56 34
13 Grieskirchen Grieskirchen 30 29 50 33
14 SV Ried II SV Ried II 30 38 56 32
15 St. Marienkirchen Marienkirche 30 40 61 32
16 Andorf Andorf 30 37 72 22
TEMPORADA 2016/2017
CUARTA AUSTRIA GRUPO 4
Equipo PJ GF GC Puntos
1 Vöcklamarkt Vöcklamarkt 30 79 22 77
2 Oedt Oedt 30 65 40 58
3 Gmunden Gmunden 30 40 31 48
4 Wels Wels 30 49 43 47
5 USC Wallern USC Wallern 30 45 37 45
6 Donau Linz Donau Linz 30 52 43 44
7 Union Edelweiß Union 30 47 42 42
8 Grün-Weiß Micheldorf Grün-Weiß 30 51 59 42
9 Hertha Wels Hertha Wels 30 43 54 41
10 Union Weißkirchen Union 30 46 48 36
11 Bad Ischl Bad Ischl 30 37 43 36
12 Neuhofen / Ried Neuhofen 30 48 52 35
13 Union Perg Union Perg 30 43 56 35
14 St. Marienkirchen Marienkirche 30 37 63 33
15 Bad Schallerbach Schallerbach 30 40 56 29
16 St. Martin St. Martin 30 34 67 14
TEMPORADA 2015/2016
CUARTA AUSTRIA GRUPO 7
Equipo PJ GF GC Puntos
1 Grieskirchen Grieskirchen 30 68 24 67
2 Vöcklamarkt Vöcklamarkt 30 62 24 64
3 Union Weißkirchen Union 30 50 41 50
4 Union Edelweiß Union 30 55 47 50
5 St. Martin St. Martin 30 55 44 48
6 Grün-Weiß Micheldorf Grün-Weiß 30 55 50 47
7 Union Perg Union Perg 30 46 43 43
8 Donau Linz Donau Linz 30 46 44 42
9 Neuhofen / Ried Neuhofen 30 43 49 37
10 Bad Ischl Bad Ischl 30 38 49 37
11 St. Marienkirchen Marienkirche 30 54 72 36
12 Wels Wels 30 41 47 35
13 Gmunden Gmunden 30 47 55 33
14 Bad Schallerbach Schallerbach 30 45 67 30
15 Marchtrenk Marchtrenk 30 45 57 25
16 Sierning Sierning 30 28 65 21
TEMPORADA 2014/2015
CUARTA AUSTRIA GRUPO 7
Equipo PJ GF GC Puntos
1 Stadl-Paura Stadl-Paura 30 63 24 68
2 Grieskirchen Grieskirchen 30 74 40 56
3 Marchtrenk Marchtrenk 30 50 34 52
4 Gmunden Gmunden 30 49 40 51
5 Bad Ischl Bad Ischl 30 47 39 49
6 Union Weißkirchen Union 30 50 46 47
7 Union Edelweiß Union 30 49 40 46
8 Wels Wels 30 44 43 46
9 Donau Linz Donau Linz 30 58 57 41
10 Sierning Sierning 30 47 48 38
11 SV Ried II SV Ried II 30 36 43 37
12 Grün-Weiß Micheldorf Grün-Weiß 30 36 45 37
13 Bad Schallerbach Schallerbach 30 42 55 37
14 St. Martin im Muhlreis Martin 30 47 61 33
15 Eferding Eferding 30 33 54 26
16 Bad Goisern Bad Goisern 30 21 77 10
TEMPORADA 2013/2014
CUARTA AUSTRIA GRUPO 7
Equipo PJ GF GC Puntos
1 Gurten Gurten 30 53 29 56
2 Bad Goisern Bad Goisern 30 48 43 50
3 Wels Wels 30 43 27 49
4 Union Edelweiß Union 30 57 43 49
5 Grün-Weiß Micheldorf Grün-Weiß 30 60 48 48
6 Grieskirchen Grieskirchen 30 55 42 46
7 Donau Linz Donau Linz 30 38 29 46
8 Eferding Eferding 30 36 46 45
9 Bad Ischl Bad Ischl 30 54 53 41
10 SV Ried II SV Ried II 30 38 44 40
11 St. Martin im Muhlreis Martin 30 41 44 39
12 Bad Schallerbach Schallerbach 30 53 52 36
13 Sierning Sierning 30 44 46 36
14 Marchtrenk Marchtrenk 30 39 64 33
15 Gmunden Gmunden 30 37 62 32
16 Freistadt Freistadt 30 33 57 26
TEMPORADA 2012/2013
CUARTA AUSTRIA GRUPO 8
Equipo PJ GF GC Puntos
1 Vorwarts Steyr Vorwarts 26 51 33 56
2 Donau Linz Donau Linz 26 51 31 51
3 Wels Wels 26 49 29 47
4 Union Edelweiß Union 26 42 35 41
5 SV Ried II SV Ried II 26 56 37 40
6 Grieskirchen Grieskirchen 26 48 36 38
7 Grün-Weiß Micheldorf Grün-Weiß 26 53 46 37
8 Gmunden Gmunden 26 32 47 36
9 Freistadt Freistadt 26 37 41 35
10 Bad Ischl Bad Ischl 26 45 53 35
11 Bad Schallerbach Schallerbach 26 37 42 31
12 Eferding Eferding 26 28 43 26
13 Sierning Sierning 26 25 46 24
14 USV Dietach USV Dietach 26 27 62 16
TEMPORADA 2011/2012
CUARTA AUSTRIA GRUPO 8
Equipo PJ GF GC Puntos
1 SV Wallern SV Wallern 26 60 28 60
2 Grieskirchen Grieskirchen 26 70 32 51
3 Donau Linz Donau Linz 26 63 30 43
4 Union Edelweiß Union 26 60 38 42
5 Grün-Weiß Micheldorf Grün-Weiß 26 48 29 42
6 SV Ried II SV Ried II 26 43 35 40
7 Gmunden Gmunden 26 53 45 39
8 Sierning Sierning 26 47 36 38
9 Bad Schallerbach Schallerbach 26 41 43 35
10 USV Dietach USV Dietach 26 39 54 29
11 Eferding Eferding 26 39 62 29
12 Union Weißkirchen Union 26 32 71 25
13 Sattledt Sattledt 26 34 54 21
14 Traun Traun 26 20 92 11
TEMPORADA 2010/2011
CUARTA AUSTRIA GRUPO 8
Equipo PJ GF GC Puntos
1 Vorwarts Steyr Vorwarts 26 56 21 55
2 Grieskirchen Grieskirchen 26 62 30 48
3 Sierning Sierning 26 42 27 43
4 SV Ried II SV Ried II 26 45 30 42
5 Bad Schallerbach Schallerbach 26 54 45 42
6 Donau Linz Donau Linz 26 40 34 40
7 Grün-Weiß Micheldorf Grün-Weiß 26 44 36 35
8 Gmunden Gmunden 26 35 35 35
9 Sattledt Sattledt 26 32 35 33
10 Union Weißkirchen Union 26 34 43 31
11 Traun Traun 26 30 51 29
12 Eferding Eferding 26 26 49 28
13 USV Dietach USV Dietach 26 29 47 23
14 Bad Ischl Bad Ischl 26 26 72 14
TEMPORADA 2009/2010
CUARTA AUSTRIA GRUPO 7
Equipo PJ GF GC Puntos
1 Vöcklamarkt Vöcklamarkt 26 64 31 53
2 LASK Schwanenstadt LASK 26 61 30 48
3 Sierning Sierning 26 44 26 46
4 SV Ried II SV Ried II 26 44 24 44
5 Vorwarts Steyr Vorwarts 26 50 34 42
6 Grieskirchen Grieskirchen 26 51 43 38
7 Bad Schallerbach Schallerbach 26 63 52 34
8 Grün-Weiß Micheldorf Grün-Weiß 26 43 49 34
9 Donau Linz Donau Linz 26 29 38 30
10 Gmunden Gmunden 26 33 61 30
11 Union Weißkirchen Union 26 28 51 29
12 Traun Traun 26 25 44 22
13 Sattledt Sattledt 26 26 52 21
14 Union Mondsee Union 26 18 44 19
TEMPORADA 2008/2009
CUARTA AUSTRIA GRUPO 7
Equipo PJ GF GC Puntos
1 SV Pasching SV Pasching 26 76 17 65
2 Vöcklamarkt Vöcklamarkt 26 61 35 59
3 LASK Schwanenstadt LASK 26 47 36 42
4 Gmunden Gmunden 26 48 31 39
5 Sierning Sierning 26 33 30 36
6 Grieskirchen Grieskirchen 26 42 47 34
7 Grün-Weiß Micheldorf Grün-Weiß 26 32 39 34
8 Sattledt Sattledt 26 34 44 33
9 Bad Schallerbach Schallerbach 26 37 50 32
10 Donau Linz Donau Linz 26 49 59 29
11 Traun Traun 26 27 39 29
12 Union Mondsee Union 26 28 47 26
13 Union Weißkirchen Union 26 31 51 25
14 Union Rohrbach Berg Union 26 31 51 22
TEMPORADA 2001/2002
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Kapfenberger SV Kapfenberger 30 79 29 66
2 Blau-Weiß Linz Blau-Weiß 30 62 34 61
3 TSV Hartberg Hartberg 30 54 26 59
4 Gratkorn Gratkorn 30 48 27 55
5 Spittal Spittal 30 49 30 53
6 SC Schwanenstadt Schwanenstad 30 47 35 49
7 Zeltweg Zeltweg 30 44 47 48
8 Voitsberg Voitsberg 30 42 41 41
9 Köflach Köflach 30 33 41 39
10 Eintracht Wels Eintracht 30 31 36 38
11 Union St. Florian Union 30 53 58 37
12 FC Kärnten II Kärnten 30 40 45 35
13 Bleiburg Bleiburg 30 26 34 33
14 Sankt Veit Sankt Veit 30 28 57 18
15 ATSV Wolfsberg ATSV 30 23 57 18
16 Donau Linz Donau Linz 30 27 89 8
TEMPORADA 2000/2001
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 SV Pasching SV Pasching 30 61 27 56
2 Kapfenberger SV Kapfenberger 30 50 34 51
3 TSV Hartberg Hartberg 30 47 30 48
4 BSV Juniors BSV Juniors 30 52 39 48
5 Gratkorn Gratkorn 30 44 35 45
6 Donau Linz Donau Linz 30 33 30 45
7 Blau-Weiß Linz Blau-Weiß 30 48 41 42
8 Alpe Adria Alpe Adria 30 38 44 41
9 Zeltweg Zeltweg 30 42 39 40
10 Spittal Spittal 30 47 51 39
11 Wels Wels 30 40 51 38
12 Voitsberg Voitsberg 30 40 48 37
13 Wolfsberger AC Wolfsberger 30 37 49 34
14 Union St. Florian Union 30 34 56 32
15 Lendorf Lendorf 30 24 45 31
16 SAK Klagenfurt Klagenfurt 30 29 47 26

  USO DE MEMORIA  
6,516,112 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5779
Total Execution Time  0.5792
  CADENA URL  
/historico/Donau-Linz
  GET DATOS  
$_GET['/historico/Donau-Linz']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0308  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 = 63695
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19393 AND type_rel = 2
0.0149  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 = '19393' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0150  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 = '19393' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148  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 = 63695 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150  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=19393 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0147  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 (67320,63695) 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.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 63695 AND teamId = 19393
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 19393
0.0149  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 63695 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0148  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 events2022 e ON e.player_id = p.id AND e.league_id = 63695 WHERE rp.league_id = 63695 AND rp.teamId = 19393 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.0146  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 events2022 e ON e.player_id = p.id AND e.league_id = 63695 WHERE rp.league_id = 63695 AND rp.teamId = 19393 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146  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 events2022 e ON e.player_id = p.id AND e.league_id = 63695 WHERE rp.league_id = 63695 AND rp.teamId = 19393 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149  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 = 19393 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0149  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 = 63695 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.0146  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 = 57780 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.0150  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 = 50451 AND t.round = 16 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 44310 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 38913 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0159  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 = 33430 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160  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 = 15770 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157  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 = 3941 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 27178 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 27182 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 27216 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 27235 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 27245 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 27269 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables2002` 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 = 27565 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables2001` 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 = 27556 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC