4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del TuS Hordel
TEMPORADA 2002/2003
OBERLIGA GRUPO 7
Equipo PJ GF GC Puntos
1 Schalke 04 II Schalke 34 103 35 86
2 VfL Bochum II Bochum 34 79 35 77
3 Gutersloh Gutersloh 34 77 39 69
4 Lippstadt 08 Lippstadt 34 74 46 66
5 Eintracht Rheine Eintracht 34 63 60 51
6 Wattenscheid 09 II Wattenscheid 34 54 59 48
7 Hüls Hüls 34 55 48 46
8 Stadtlohn Stadtlohn 34 37 47 44
9 VfB Fichte Bielefeld Fichte 34 49 48 43
10 Siegen Sportfreunde 1899 II Siegen 34 49 61 43
11 SC Hassel SC Hassel 34 36 55 41
12 Emsdetten 05 Emsdetten 34 45 57 39
13 Lüner Lüner 34 55 66 38
14 Arminia Bielefeld II Arminia 34 41 63 37
15 Sprockhövel Sprockhövel 34 46 72 35
16 TuS Hordel TuS Hordel 34 52 62 33
17 Westfalia Herne Westfalia 34 39 61 28
18 TSG Dülmen TSG Dülmen 34 40 80 27
TEMPORADA 2001/2002
OBERLIGA GRUPO 6
Equipo PJ GF GC Puntos
1 B. Dortmund II Dortmund 34 91 34 78
2 Schalke 04 II Schalke 34 80 40 71
3 Eintracht Rheine Eintracht 34 54 37 67
4 Hüls Hüls 34 66 39 60
5 VfL Bochum II Bochum 34 58 42 59
6 Westfalia Herne Westfalia 34 50 39 58
7 VfB Fichte Bielefeld Fichte 34 55 55 54
8 SC Hassel SC Hassel 34 37 35 43
9 Gutersloh Gutersloh 34 51 58 43
10 Lüner Lüner 34 52 58 41
11 Stadtlohn Stadtlohn 34 46 52 41
12 TuS Hordel TuS Hordel 34 55 59 40
13 Wattenscheid 09 II Wattenscheid 34 45 59 39
14 Lippstadt 08 Lippstadt 34 42 51 37
15 TSG Dülmen TSG Dülmen 34 38 52 35
16 SF Oestrich-Iserlohn Oestrich-Ise 34 41 73 27
17 Preußen Lengerich Preußen 34 41 81 27
18 SV Hövelhof Hövelhof 34 23 61 25
TEMPORADA 2000/2001
OBERLIGA GRUPO 7
Equipo PJ GF GC Puntos
1 Paderborn Paderborn 36 85 29 86
2 VfL Bochum II Bochum 36 87 39 76
3 Hüls Hüls 36 93 41 74
4 Gutersloh Gutersloh 36 79 43 63
5 Schalke 04 II Schalke 36 84 63 60
6 Wattenscheid 09 II Wattenscheid 36 56 42 59
7 Eintracht Rheine Eintracht 36 69 57 55
8 Westfalia Herne Westfalia 36 65 45 53
9 Lüner Lüner 36 56 54 52
10 TuS Hordel TuS Hordel 36 67 86 48
11 Lippstadt 08 Lippstadt 36 64 55 47
12 TSG Dülmen TSG Dülmen 36 46 56 46
13 Stadtlohn Stadtlohn 36 54 56 45
14 SF Oestrich-Iserlohn Oestrich-Ise 36 51 73 44
15 Preußen Lengerich Preußen 36 65 76 42
16 Sprockhövel Sprockhövel 36 46 76 36
17 SC Herford SC Herford 36 33 67 29
18 SpVgg Beckum SpVgg Beckum 36 28 94 19
19 VfB Kirchellen Kirchellen 36 34 110 11
TEMPORADA 1999/2000
OBERLIGA GRUPO 7
Equipo PJ GF GC Puntos
1 Hüls Hüls 28 73 32 61
2 Schalke 04 II Schalke 28 58 34 51
3 Lippstadt 08 Lippstadt 28 49 38 47
4 SC Herford SC Herford 28 54 48 46
5 Westfalia Herne Westfalia 28 50 46 45
6 TuS Hordel TuS Hordel 28 53 39 44
7 Wattenscheid 09 II Wattenscheid 28 38 31 43
8 Eintracht Rheine Eintracht 28 45 41 40
9 Stadtlohn Stadtlohn 28 51 39 39
10 TSG Dülmen TSG Dülmen 28 34 43 38
11 SF Oestrich-Iserlohn Oestrich-Ise 28 43 56 35
12 VfB Kirchellen Kirchellen 28 47 56 29
13 Preußen Lengerich Preußen 28 42 55 27
14 SpVgg Beckum SpVgg Beckum 28 26 72 19
15 SpVgg Erkenschwick SpVgg 28 30 63 16
TEMPORADA 1998/1999
OBERLIGA GRUPO 7
Equipo PJ GF GC Puntos
1 VfL Bochum II Bochum 30 64 25 61
2 Schalke 04 II Schalke 30 68 29 53
3 Lippstadt 08 Lippstadt 30 65 43 52
4 Hüls Hüls 30 65 38 51
5 BW Post Recklinghausen Post 30 49 43 48
6 Wattenscheid 09 II Wattenscheid 30 50 38 47
7 TSG Dülmen TSG Dülmen 30 47 44 46
8 Stadtlohn Stadtlohn 30 44 38 44
9 Eintracht Rheine Eintracht 30 48 48 43
10 TuS Hordel TuS Hordel 30 44 58 38
11 VfB Kirchellen Kirchellen 30 50 61 35
12 SF Oestrich-Iserlohn Oestrich-Ise 30 42 55 34
13 SpVgg Beckum SpVgg Beckum 30 36 50 34
14 SV Langendreer Langendreer 30 37 55 33
15 Hasper SV Hasper SV 30 35 56 30
16 Hammer SpVg Hammer SpVg 30 19 82 14
TEMPORADA 1997/1998
OBERLIGA GRUPO 7
Equipo PJ GF GC Puntos
1 B. Dortmund II Dortmund 28 86 34 65
2 Schalke 04 II Schalke 28 67 35 55
3 Wattenscheid 09 II Wattenscheid 28 53 30 48
4 VfL Bochum II Bochum 28 44 26 48
5 Hasper SV Hasper SV 28 48 40 43
6 BW Post Recklinghausen Post 28 44 41 39
7 SF Oestrich-Iserlohn Oestrich-Ise 28 44 45 39
8 Stadtlohn Stadtlohn 28 39 41 36
9 TSG Dülmen TSG Dülmen 28 34 37 33
10 Hammer SpVg Hammer SpVg 28 38 62 33
11 SpVgg Beckum SpVgg Beckum 28 33 47 31
12 Hüls Hüls 28 32 51 29
13 TuS Hordel TuS Hordel 28 47 57 28
14 SV Rotthausen 12 Rotthausen 28 39 61 27
15 SpVgg Brakel SpVgg Brakel 28 34 75 15
TEMPORADA 1996/1997
OBERLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 Siegen Sportfreunde Siegen 30 89 26 76
2 Hasper SV Hasper SV 30 65 25 62
3 B. Dortmund II Dortmund 30 66 47 54
4 TuS Hordel TuS Hordel 30 61 41 52
5 TSG Dülmen TSG Dülmen 30 49 40 50
6 VfR Solde VfR Solde 30 69 51 48
7 SV Rotthausen 12 Rotthausen 30 41 49 42
8 Wattenscheid 09 II Wattenscheid 30 49 53 40
9 Hammer SpVg Hammer SpVg 30 43 56 37
10 SF Oestrich-Iserlohn Oestrich-Ise 30 44 64 35
11 SpVgg Brakel SpVgg Brakel 30 47 69 34
12 Hüls Hüls 30 35 51 33
13 Stadtlohn Stadtlohn 30 37 47 32
14 SpVgg Beckum SpVgg Beckum 30 39 58 32
15 Rot-Weiß Lüdenscheid Rot-Weiß 30 42 63 27
16 SV Holzwickede Holzwickede 30 38 74 25

  USO DE MEMORIA  
5,470,656 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7553
Total Execution Time  0.7566
  CADENA URL  
/historico/Tus-Hordel
  GET DATOS  
$_GET['/historico/Tus-Hordel']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0150  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 = 'Tus-Hordel' 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.0162  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 = 'Tus-Hordel' 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.0152  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=88698 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151  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=88698 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=88698 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=88698 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=88698 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=88698 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=88698 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151  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=88698 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0148  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=88698 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  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=88698 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0152  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=88698 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0154  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=88698 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151  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=88698 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0177  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 = 72016
0.0149  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=88698 AND type_rel = 2
0.0163  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 = '88698' ORDER BY l.year DESC,cat.coefficient DESC
0.0161  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 = '88698' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0160  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 = '88698' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148  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 = '88698' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147  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 = 72016 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149  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=88698 AND l.year in (2022,2023,2024) 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 (72016,67320) 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.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 72016 AND teamId = 88698
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 88698
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 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 = 72016 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146  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 = '88698' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '88698' and rp.type = 4
0.0148  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 = '88698' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0156  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 = 72016 WHERE rp.league_id = 72016 AND rp.teamId = 88698 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.0156  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 = 72016 WHERE rp.league_id = 72016 AND rp.teamId = 88698 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 events2023 e ON e.player_id = p.id AND e.league_id = 72016 WHERE rp.league_id = 72016 AND rp.teamId = 88698 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0159  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 = 88698 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0166  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 `tables2003` 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 = 28310 AND t.round = 34 ORDER BY team.conference 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 `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 = 28323 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0171  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 = 28320 AND t.round = 38 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 `tables2000` 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 = 28339 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 `tables1999` 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 = 28354 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 `tables1998` 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 = 28351 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 `tables1997` 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 = 28357 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 72016 ORDER BY nameShow LIMIT 100