4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Donau
TEMPORADA 2023/2024
CUARTA AUSTRIA GRUPO 9
Equipo PJ GF GC Puntos
1 Sportunion Mauer Sportunion 23 63 8 62
2 Dinamo Helfort 15 Dinamo 23 57 19 56
3 Slovan HAC Slovan HAC 23 57 44 41
4 1980 Wien 1980 Wien 23 47 31 40
5 Stadlau Stadlau 23 36 27 39
6 Red Star Penzing Star Penzing 23 46 38 36
7 Donau Donau 23 47 34 35
8 Mannswörth Mannswörth 23 28 42 31
9 Gerasdorf Stammersdorf Gerasdorf 23 25 36 28
10 Schwechat Schwechat 23 36 47 26
11 Vorwärts Brigittenau Vorwärts 23 33 43 25
12 Wienerberg Wienerberg 23 30 40 25
13 Austria XIII Austria XIII 23 30 40 24
14 Simmeringer SC Simmeringer 23 26 46 20
15 Kagran Kagran 23 33 59 18
16 ASV 13 ASV 13 23 22 62 13
TEMPORADA 2022/2023
CUARTA AUSTRIA GRUPO 8
Equipo PJ GF GC Puntos
1 Favoritner AC Favoritner 30 82 46 69
2 Sportunion Mauer Sportunion 30 81 28 68
3 Schwechat Schwechat 30 64 33 58
4 Donau Donau 29 54 31 51
5 Dinamo Helfort 15 Dinamo 30 58 43 50
6 Stadlau Stadlau 30 54 41 45
7 Slovan HAC Slovan HAC 30 64 50 44
8 Simmeringer SC Simmeringer 30 45 47 39
9 Austria XIII Austria XIII 30 54 65 39
10 1980 Wien 1980 Wien 30 50 68 35
11 Wienerberg Wienerberg 30 51 61 32
12 Gerasdorf Stammersdorf Gerasdorf 30 47 55 31
13 ASV 13 ASV 13 30 45 75 31
14 Mannswörth Mannswörth 30 37 64 27
15 Vorwärts Brigittenau Vorwärts 30 40 76 27
16 Post Post 29 36 79 17
TEMPORADA 2021/2022
CUARTA AUSTRIA GRUPO 9
Equipo PJ GF GC Puntos
1 Donaufeld Donaufeld 30 97 28 77
2 Donau Donau 30 54 28 59
3 Sportunion Mauer Sportunion 30 53 26 58
4 Schwechat Schwechat 30 62 31 51
5 Dinamo Helfort 15 Dinamo 30 53 35 48
6 Austria XIII Austria XIII 30 53 50 46
7 Stadlau Stadlau 30 43 37 44
8 Slovan HAC Slovan HAC 30 71 70 43
9 Vorwärts Brigittenau Vorwärts 30 48 54 35
10 Post Post 30 48 56 34
11 Wienerberg Wienerberg 30 37 46 33
12 Gerasdorf Stammersdorf Gerasdorf 30 32 54 29
13 Favoritner AC Favoritner 30 39 67 29
14 ASV 13 ASV 13 30 38 84 26
15 Ostbahn XI Ostbahn XI 30 40 68 25
16 Mannswörth Mannswörth 30 30 64 25
TEMPORADA 2020/2021
CUARTA AUSTRIA GRUPO 8
Equipo PJ GF GC Puntos
1 First Vienna First Vienna 15 58 9 42
2 Wienerberg Wienerberg 15 35 14 34
3 Sportunion Mauer Sportunion 15 32 16 31
4 Elektra Elektra 15 37 19 28
5 Donaufeld Donaufeld 15 30 18 28
6 Austria XIII Austria XIII 15 26 14 28
7 Stadlau Stadlau 15 31 24 27
8 Schwechat Schwechat 15 26 19 27
9 Favoritner AC Favoritner 15 22 28 17
10 Vorwärts Brigittenau Vorwärts 15 27 36 14
11 Mannswörth Mannswörth 15 21 35 13
12 Donau Donau 15 10 21 12
13 Slovan HAC Slovan HAC 15 16 41 12
14 ASV 13 ASV 13 15 13 34 9
15 Gerasdorf Stammersdorf Gerasdorf 15 18 40 6
16 Post Post 15 5 39 5
TEMPORADA 2019/2020
CUARTA AUSTRIA GRUPO 9
Equipo PJ GF GC Puntos
1 First Vienna First Vienna 17 47 11 43
2 Austria XIII Austria XIII 17 47 17 37
3 Elektra Elektra 17 38 16 32
4 Slovan HAC Slovan HAC 17 23 18 27
5 Donau Donau 17 25 25 26
6 Gerasdorf Stammersdorf Gerasdorf 17 29 31 25
7 Donaufeld Donaufeld 17 30 27 23
8 Schwechat Schwechat 17 20 17 22
9 ASV 13 ASV 13 17 26 45 21
10 Mannswörth Mannswörth 17 27 31 20
11 Sportunion Mauer Sportunion 17 22 31 18
12 Vorwärts Brigittenau Vorwärts 16 29 31 15
13 Favoritner AC Favoritner 16 22 30 15
14 Stadlau Stadlau 17 24 34 14
15 Wienerberg Wienerberg 17 25 46 14
16 Post Post 17 16 40 14
TEMPORADA 2018/2019
CUARTA AUSTRIA GRUPO 8
Equipo PJ GF GC Puntos
1 SC Wiener Viktoria Wiener 30 78 33 72
2 Elektra Elektra 30 67 21 71
3 Wienerberg Wienerberg 30 58 44 52
4 Austria XIII Austria XIII 30 63 38 51
5 Mannswörth Mannswörth 30 60 44 47
6 Favoritner AC Favoritner 30 45 45 46
7 Gerasdorf Stammersdorf Gerasdorf 30 54 42 41
8 Slovan HAC Slovan HAC 30 53 52 41
9 Donaufeld Donaufeld 30 44 49 41
10 Vorwärts Brigittenau Vorwärts 30 53 57 39
11 Donau Donau 30 46 56 33
12 Sportunion Mauer Sportunion 30 46 59 31
13 Post Post 30 34 55 31
14 ASV 13 ASV 13 30 37 56 29
15 Ostbahn XI Ostbahn XI 30 34 60 23
16 Mauerwerk Mauerwerk 30 28 89 21
TEMPORADA 2017/2018
CUARTA AUSTRIA GRUPO 9
Equipo PJ GF GC Puntos
1 Team Wiener Linien Team Wiener 30 89 38 62
2 Elektra Elektra 30 57 28 59
3 Favoritner AC Favoritner 30 65 42 56
4 Donaufeld Donaufeld 30 70 42 54
5 Technopool Admira Technopool 30 45 55 47
6 Wienerberg Wienerberg 30 67 54 46
7 Gerasdorf Stammersdorf Gerasdorf 30 59 56 44
8 Slovan HAC Slovan HAC 30 50 48 44
9 Austria XIII Austria XIII 30 56 50 39
10 SC Wiener Viktoria Wiener 30 66 61 39
11 Mannswörth Mannswörth 30 50 60 36
12 Post Post 30 41 59 32
13 Sportunion Mauer Sportunion 30 46 70 28
14 Donau Donau 30 36 63 27
15 Ostbahn XI Ostbahn XI 30 36 68 25
16 Gersthofer SV Gersthofer 30 42 81 21
TEMPORADA 2014/2015
CUARTA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Stadlau Stadlau 30 70 23 69
2 Admira Landhaus Admira 30 56 40 56
3 Mannswörth Mannswörth 30 48 31 49
4 Austria XIII Austria XIII 30 49 31 47
5 Wienerberg Wienerberg 30 46 45 47
6 Team Wiener Linien Team Wiener 30 52 44 46
7 Elektra Elektra 30 49 46 46
8 Gerasdorf Stammersdorf Gerasdorf 30 46 40 44
9 Gersthofer SV Gersthofer 30 37 41 42
10 Ostbahn XI Ostbahn XI 30 44 44 40
11 Simmeringer SC Simmeringer 30 44 51 33
12 SC Wiener Viktoria Wiener 30 27 44 32
13 Favoritner AC Favoritner 30 35 49 31
14 ASV 13 ASV 13 30 34 56 29
15 Post Post 30 27 50 28
16 Donau Donau 30 28 57 18
TEMPORADA 2013/2014
CUARTA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Donaufeld Donaufeld 29 74 30 69
2 Stadlau Stadlau 29 58 18 57
3 Team Wiener Linien Team Wiener 29 71 43 52
4 Admira Landhaus Admira 29 49 37 52
5 Ostbahn XI Ostbahn XI 29 62 38 51
6 Gerasdorf Stammersdorf Gerasdorf 29 49 34 48
7 Austria XIII Austria XIII 29 38 29 45
8 Favoritner AC Favoritner 29 40 42 45
9 Post Post 29 59 53 44
10 Mannswörth Mannswörth 29 46 56 40
11 Donau Donau 29 37 34 37
12 Wienerberg Wienerberg 29 40 40 37
13 First Vienna II First Vienna 29 45 58 29
14 Gersthofer SV Gersthofer 29 33 48 27
15 Simmeringer SC Simmeringer 29 21 81 10
16 NAC NAC 29 15 96 7
TEMPORADA 2012/2013
CUARTA AUSTRIA GRUPO 9
Equipo PJ GF GC Puntos
1 SC Wiener Viktoria Wiener 30 84 28 68
2 Post Post 30 59 33 60
3 Stadlau Stadlau 30 60 27 59
4 Donaufeld Donaufeld 30 65 40 54
5 Team Wiener Linien Team Wiener 30 57 35 51
6 Favoritner AC Favoritner 30 57 50 50
7 Donau Donau 30 47 41 49
8 NAC NAC 30 68 49 47
9 Admira Landhaus Admira 30 51 44 43
10 Austria XIII Austria XIII 30 52 51 39
11 Gersthofer SV Gersthofer 30 32 48 32
12 Gerasdorf Stammersdorf Gerasdorf 30 43 63 31
13 First Vienna II First Vienna 30 37 61 30
14 Fortuna 05 Fortuna 05 30 35 72 25
15 Slovan-Hütteldorfer Slovan-Hütt 30 37 78 20
16 Columbia Floridsdorf Columbia 30 25 89 11
TEMPORADA 2011/2012
CUARTA AUSTRIA GRUPO 9
Equipo PJ GF GC Puntos
1 Ostbahn XI Ostbahn XI 30 71 38 63
2 NAC NAC 30 68 33 59
3 Stadlau Stadlau 30 48 22 54
4 Team Wiener Linien Team Wiener 30 41 31 52
5 Post Post 30 54 38 51
6 Austria XIII Austria XIII 30 56 45 49
7 Donaufeld Donaufeld 30 54 44 47
8 Gerasdorf Stammersdorf Gerasdorf 30 54 48 42
9 Donau Donau 30 31 37 41
10 Gersthofer SV Gersthofer 30 31 35 40
11 Admira Landhaus Admira 30 46 40 37
12 Fortuna 05 Fortuna 05 30 50 55 37
13 Favoritner AC Favoritner 30 40 50 37
14 Slovan HAC Slovan HAC 30 31 68 25
15 Wienerberg Wienerberg 30 30 61 18
16 LAC-IC LAC-IC 30 24 84 14
TEMPORADA 2008/2009
CUARTA AUSTRIA GRUPO 9
Equipo PJ GF GC Puntos
1 Schwechat Schwechat 30 72 13 72
2 Stadlau Stadlau 30 73 28 62
3 Post Post 30 59 27 54
4 Favoriten Favoriten 30 63 45 54
5 Admira Landhaus Admira 30 57 41 50
6 Fortuna 05 Fortuna 05 30 59 50 47
7 Columbia Floridsdorf Columbia 30 39 30 46
8 Donaufeld Donaufeld 30 48 32 45
9 Rennweger SV Rennweger 29 62 52 45
10 Gersthofer SV Gersthofer 30 44 48 41
11 Mannswörth Mannswörth 29 48 49 38
12 Ankerbrot Ankerbrot 30 37 56 33
13 Favoritner AC Favoritner 30 27 53 26
14 Gerasdorf Stammersdorf Gerasdorf 30 37 69 24
15 Slovan HAC Slovan HAC 30 33 82 19
16 Donau Donau 30 34 117 10
TEMPORADA 2005/2006
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Parndorf Parndorf 30 52 23 65
2 SKN St. Polten Polten 30 65 33 64
3 First Vienna First Vienna 30 56 21 62
4 PSV Wien PSV Wien 30 41 33 50
5 Admira Wacker II Admira 30 48 47 46
6 Wiener SC Wiener SC 30 49 51 43
7 Waidhofen Waidhofen 30 46 50 41
8 Würmla Würmla 30 36 43 38
9 Ritzing Ritzing 30 32 42 37
10 Kremser SC Kremser SC 30 36 42 36
11 Zwettl Zwettl 30 44 46 33
12 Neusiedl Neusiedl 30 41 49 31
13 Schwechat Schwechat 30 27 38 31
14 Eisenstadt SC Eisenstadt 30 33 47 31
15 Kottingbrunn Kottingbrunn 30 31 51 27
16 Donau Donau 30 23 44 27
TEMPORADA 1933/1934
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Admira Admira 22 69 41 49
2 Rapid Wien Rapid Wien 22 80 34 46
3 Austria Wien Austria Wien 22 56 36 39
4 First Vienna First Vienna 22 52 34 39
5 Wiener AC Wiener AC 23 52 65 33
6 FC Wien FC Wien 22 48 56 29
7 FAC Wien FAC Wien 22 37 49 25
8 Wacker Wien Wacker Wien 23 50 66 25
9 Wiener SC Wiener SC 22 36 41 24
10 Donau Donau 23 33 54 23
11 Hakoah Wien Hakoah Wien 23 31 47 22
12 Libertas Wien Libertas 22 35 56 21

  USO DE MEMORIA  
6,600,680 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.5976
Total Execution Time  0.5989
  CADENA URL  
/historico/Donau
  GET DATOS  
$_GET['/historico/Donau']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0294  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 = 73021
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17538 AND type_rel = 2
0.0151  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 = '17538' ORDER BY l.year DESC,cat.coefficient DESC
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 = '17538' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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 = 73021 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  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=17538 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (73021,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.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 73021 AND teamId = 17538
0.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 17538
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 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 = 73021 AND t.round = 23 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0147  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 = '17538' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17538' and rp.type = 4
0.0146  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 = '17538' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0155  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 = 73021 WHERE rp.league_id = 73021 AND rp.teamId = 17538 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.0153  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 = 73021 WHERE rp.league_id = 73021 AND rp.teamId = 17538 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150  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 = 73021 WHERE rp.league_id = 73021 AND rp.teamId = 17538 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 = 17538 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73021 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 68331 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.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 `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 = 63698 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.0156  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 = 57784 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.0165  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 = 50455 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.0162  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 = 44312 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 38915 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 3937 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 `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 = 3585 AND t.round = 29 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 `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 = 27184 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 `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 = 27219 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 `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 = 27271 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 `tables2006` 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 = 27587 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 `tables1934` 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 = 26238 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC