4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Hansa Rostock Sub 17
TEMPORADA 2022/2023
BUNDESLIGA SUB 17 GRUPO 5
Equipo PJ GF GC Puntos
1 Stuttgart Sub 17 Stuttgart 3 12 2 9
2 1. FC Nürnberg Sub 17 Nürnberg 3 13 6 9
3 TSV 1860 München Sub 17 1860 3 9 5 6
4 RB Leipzig Sub 17 Leipzig 3 9 7 6
5 Hannover 96 Sub 17 Hannover 3 7 5 6
6 Hertha BSC Sub 17 Hertha 3 6 5 6
7 Stuttgarter Kickers Sub 17 Stuttgarter 3 5 5 6
8 Hansa Rostock Sub 17 Hansa 3 5 4 5
9 Chemnitzer Sub 17 Chemnitzer 3 3 2 5
10 B. Leverkusen Sub 17 Leverkusen 3 8 7 4
11 Niendorfer TSV Sub 17 Niendorfer 2 4 3 4
12 Köln Sub 17 Köln 3 5 5 4
13 Karlsruher SC Sub 17 Karlsruher 3 2 2 4
14 Wolfsburg Sub 17 Wolfsburg 3 7 9 4
15 Werder Bremen Sub 17 Werder 3 7 10 4
16 VfL Bochum Sub 17 Bochum 3 6 7 3
17 Arminia Bielefeld Sub 17 Arminia 3 5 6 3
18 Hoffenheim Sub 17 Hoffenheim 3 4 5 3
19 Bayern München Sub 17 Bayern 3 5 8 3
20 Eintracht Frankfurt Sub 17 Eintracht 3 3 8 3
21 Preußen Münster Sub 17 Preußen 2 4 5 1
22 B. Dortmund Sub 17 Dortmund 3 5 7 1
23 Darmstadt 98 Sub 17 Darmstadt 3 2 7 0
24 Mainz 05 Sub 17 Mainz 3 4 10 0
TEMPORADA 2021/2022
BUNDESLIGA SUB 17 GRUPO 1
Equipo PJ GF GC Puntos
1 Hertha BSC Sub 17 Hertha 18 57 9 48
2 Hamburger SV Sub 17 Hamburger 18 41 17 39
3 FC St. Pauli Sub 17 Pauli 18 38 14 38
4 Chemnitzer Sub 17 Chemnitzer 18 26 21 34
5 Wolfsburg Sub 17 Wolfsburg 18 42 21 33
6 RB Leipzig Sub 17 Leipzig 18 34 23 33
7 Dynamo Dresden Sub 17 Dynamo 18 31 23 31
8 Werder Bremen Sub 17 Werder 18 43 33 30
9 Union Berlin Sub 17 Union Berlin 18 26 21 29
10 Hannover 96 Sub 17 Hannover 18 27 30 29
11 Viktoria Berlin Sub 17 Viktoria 18 25 30 24
12 Hansa Rostock Sub 17 Hansa 18 23 28 23
13 Erzgebirge Aue Sub 17 Erzgebirge 18 13 29 17
14 FC Carl Zeiss Jena Sub 17 Carl Zeiss. 18 14 26 16
15 Holstein Kiel Sub 17 Holstein 18 26 40 16
16 Energie Cottbus Sub 17 Energie 18 24 47 16
17 Hertha Zehlendorf Sub 17 Hertha 18 17 32 12
18 E. Braunschweig Sub 17 Braunschweig 18 12 34 11
19 Hallescher FC Sub 17 Hallescher 18 12 53 9
TEMPORADA 2016/2017
BUNDESLIGA SUB 17 GRUPO 1
Equipo PJ GF GC Puntos
1 Werder Bremen Sub 17 Werder 26 94 13 75
2 RB Leipzig Sub 17 Leipzig 26 86 23 59
3 Hamburger SV Sub 17 Hamburger 26 65 32 46
4 Wolfsburg Sub 17 Wolfsburg 26 62 39 46
5 Hertha BSC Sub 17 Hertha 26 41 31 45
6 FC St. Pauli Sub 17 Pauli 26 48 32 42
7 Holstein Kiel Sub 17 Holstein 26 55 41 40
8 1. FC Magdeburg Sub 17 Magdeburg 26 34 48 37
9 Dynamo Dresden Sub 17 Dynamo 26 43 61 32
10 Union Berlin Sub 17 Union Berlin 26 41 57 31
11 E. Braunschweig Sub 17 Braunschweig 26 31 58 22
12 Hansa Rostock Sub 17 Hansa 26 15 63 21
13 Tennis Borussia Sub 17 Tennis 26 14 53 14
14 Niendorfer TSV Sub 17 Niendorfer 26 17 95 7
TEMPORADA 2010/2011
BUNDESLIGA SUB 17 GRUPO 1
Equipo PJ GF GC Puntos
1 Werder Bremen Sub 17 Werder 26 73 22 59
2 Hertha BSC Sub 17 Hertha 26 67 29 56
3 VfL Osnabrück Sub 17 Osnabrück 26 53 29 49
4 Tennis Borussia Sub 17 Tennis 26 49 33 45
5 Wolfsburg Sub 17 Wolfsburg 26 48 32 39
6 Hannover 96 Sub 17 Hannover 26 46 39 39
7 FC St. Pauli Sub 17 Pauli 26 37 33 38
8 Dynamo Dresden Sub 17 Dynamo 26 31 36 36
9 Hamburger SV Sub 17 Hamburger 26 31 47 36
10 FC Carl Zeiss Jena Sub 17 Carl Zeiss. 26 38 56 35
11 Energie Cottbus Sub 17 Energie 26 40 37 33
12 Hansa Rostock Sub 17 Hansa 26 37 41 33
13 Rot-Weiß Erfurt Sub 17 Rot-Weiß 26 22 78 10
14 WTSV Concordia Sub 17 WTSV 26 18 78 8
TEMPORADA 2009/2010
BUNDESLIGA SUB 17 GRUPO 1
Equipo PJ GF GC Puntos
1 Hertha BSC Sub 17 Hertha 26 70 24 59
2 Wolfsburg Sub 17 Wolfsburg 26 58 26 54
3 Werder Bremen Sub 17 Werder 26 62 39 47
4 Hansa Rostock Sub 17 Hansa 26 53 36 41
5 Hamburger SV Sub 17 Hamburger 26 40 33 41
6 Energie Cottbus Sub 17 Energie 26 39 45 39
7 Hannover 96 Sub 17 Hannover 26 46 31 38
8 VfL Osnabrück Sub 17 Osnabrück 26 39 37 35
9 Rot-Weiß Erfurt Sub 17 Rot-Weiß 26 51 50 34
10 Tennis Borussia Sub 17 Tennis 26 37 40 34
11 FC Carl Zeiss Jena Sub 17 Carl Zeiss. 26 33 44 32
12 Union Berlin Sub 17 Union Berlin 26 30 66 26
13 Holstein Kiel Sub 17 Holstein 26 38 62 24
14 SC Weyhe Sub 17 Weyhe 26 23 86 6
TEMPORADA 2008/2009
BUNDESLIGA SUB 17 GRUPO 1
Equipo PJ GF GC Puntos
1 Wolfsburg Sub 17 Wolfsburg 26 84 19 66
2 Werder Bremen Sub 17 Werder 26 86 53 54
3 Hertha BSC Sub 17 Hertha 26 65 38 50
4 Hansa Rostock Sub 17 Hansa 26 50 36 43
5 Tennis Borussia Sub 17 Tennis 26 52 42 42
6 Hamburger SV Sub 17 Hamburger 26 48 37 40
7 VfL Osnabrück Sub 17 Osnabrück 26 45 44 40
8 Energie Cottbus Sub 17 Energie 26 52 46 39
9 Hannover 96 Sub 17 Hannover 26 35 42 34
10 Rot-Weiß Erfurt Sub 17 Rot-Weiß 26 36 69 27
11 Holstein Kiel Sub 17 Holstein 26 34 70 25
12 FC St. Pauli Sub 17 Pauli 26 32 50 24
13 WTSV Concordia Sub 17 WTSV 26 25 67 16
14 Hertha Zehlendorf Sub 17 Hertha 26 29 60 15
TEMPORADA 2007/2008
BUNDESLIGA SUB 17 GRUPO 1
Equipo PJ GF GC Puntos
1 Hertha BSC Sub 17 Hertha 6 18 6 16
2 Hansa Rostock Sub 17 Hansa 5 16 5 13
3 Werder Bremen Sub 17 Werder 6 13 6 12
4 Hamburger SV Sub 17 Hamburger 5 11 5 12
5 Holstein Kiel Sub 17 Holstein 5 7 10 9
6 Wolfsburg Sub 17 Wolfsburg 5 13 8 8
7 Energie Cottbus Sub 17 Energie 5 5 4 7
8 Tennis Borussia Sub 17 Tennis 5 10 11 5
9 Hannover 96 Sub 17 Hannover 6 3 5 5
10 VfL Osnabrück Sub 17 Osnabrück 6 9 12 5
11 Rot-Weiß Erfurt Sub 17 Rot-Weiß 6 6 12 5
12 Dynamo Dresden Sub 17 Dynamo 6 5 12 4
13 SG Sachsen Leipzig Sub 17 Sachsen 6 5 17 4
14 E. Braunschweig Sub 17 Braunschweig 6 7 15 2

  USO DE MEMORIA  
5,818,928 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5300
Total Execution Time  0.5313
  CADENA URL  
/historico/Fc-Hansa-Rostock
  GET DATOS  
$_GET['/historico/Fc-Hansa-Rostock']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0115  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 = 'Fc-Hansa-Rostock' 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.0132  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 = 'Fc-Hansa-Rostock' 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.0107  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=1070 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107  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=1070 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=1070 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=1070 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=1070 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=1070 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=1070 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=1070 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=1070 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=1070 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0112  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 = 68734
0.0112  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 = 71424
0.0111  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 = 71661
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1070 AND type_rel = 2
0.0107  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 = '1070' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0107  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 = '1070' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0106  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 = '1070' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0108  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 = 71424 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0107  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=1070 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0105  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 (71661) 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.0107  SELECT count(id) as num_players from rel_players WHERE league_id = 71661 AND teamId = 1070
0.0107  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 = '1070' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0106  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1070' and rp.type = 4
0.0111  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 = '1070' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0143  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 events2023 e ON e.player_id = p.id AND e.league_id = 68734 WHERE rp.league_id = 68734 AND rp.teamId = 1070 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.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 events2023 e ON e.player_id = p.id AND e.league_id = 68734 WHERE rp.league_id = 68734 AND rp.teamId = 1070 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131  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 events2023 e ON e.player_id = p.id AND e.league_id = 68734 WHERE rp.league_id = 68734 AND rp.teamId = 1070 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0118  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 = 1070 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0126  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 = 68734 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.0140  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 = 71424 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0120  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 = 71661 AND t.round = 3 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0117  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 = 63884 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115  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 = 44042 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0114  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 = 44061 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115  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 = 44099 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0118  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 = 44100 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0122  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 = 44101 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC