4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Schott Mainz Sub 19
TEMPORADA 2020/2021
REGIONALLIGA SUB 19 GRUPO 1
Equipo PJ GF GC Puntos
1 Eintracht Trier Sub 19 Eintracht 8 22 14 19
2 Schott Mainz Sub 19 Schott Mainz 7 18 9 18
3 SV 07 Elversberg Sub 19 Elversberg 6 21 5 16
4 TuS Koblenz Sub 19 Koblenz 7 19 8 13
5 Gonsenheim Sub 19 Gonsenheim 8 14 12 13
6 FV Speyer Sub 19 Speyer 7 15 10 12
7 Offenbach Sub 19 Offenbach 7 18 17 12
8 Sportfreunde Eisbachtal Sub Sportfreunde 7 17 14 11
9 FK Pirmasens Sub 19 Pirmasens 6 12 11 9
10 Ludwigshafener SC Sub 19 Ludwigshafen 7 11 15 9
11 Schaumberg Sub 19 Schaumberg 6 6 10 7
12 Bretzenheim Sub 19 Bretzenheim 7 17 22 7
13 W. Worms Sub 19 Worms 7 10 14 6
14 TuS RW Koblenz Sub 19 Koblenz 8 12 23 6
15 FC 08 Homburg Sub 19 Homburg 8 10 20 5
16 Saarlouis/Dillingen Sub 19 Saarlouis/Di 8 6 24 3
TEMPORADA 2019/2020
REGIONALLIGA SUB 19 GRUPO 1
Equipo PJ GF GC Puntos
1 Saarbrücken Sub 19 Saarbrücken 15 73 15 42
2 Schott Mainz Sub 19 Schott Mainz 15 40 11 37
3 FV Speyer Sub 19 Speyer 15 46 21 34
4 SV 07 Elversberg Sub 19 Elversberg 15 35 20 28
5 TuS Koblenz Sub 19 Koblenz 15 35 28 26
6 W. Worms Sub 19 Worms 15 30 21 25
7 Eintracht Trier Sub 19 Eintracht 15 31 35 21
8 FK Pirmasens Sub 19 Pirmasens 14 29 31 14
9 TuS RW Koblenz Sub 19 Koblenz 14 18 35 14
10 Gonsenheim Sub 19 Gonsenheim 14 30 44 13
11 Ludwigshafener SC Sub 19 Ludwigshafen 15 23 51 13
12 FC 08 Homburg Sub 19 Homburg 14 22 33 9
13 Bretzenheim Sub 19 Bretzenheim 15 27 58 8
14 Saarlouis/Dillingen Sub 19 Saarlouis/Di 15 13 49 8
TEMPORADA 2018/2019
REGIONALLIGA SUB 19 GRUPO 1
Equipo PJ GF GC Puntos
1 SV 07 Elversberg Sub 19 Elversberg 26 90 31 63
2 Saarbrücken Sub 19 Saarbrücken 26 61 36 50
3 W. Worms Sub 19 Worms 26 78 53 44
4 FV Speyer Sub 19 Speyer 26 82 47 41
5 Gonsenheim Sub 19 Gonsenheim 26 63 59 40
6 Ludwigshafener SC Sub 19 Ludwigshafen 26 58 47 37
7 FK Pirmasens Sub 19 Pirmasens 26 47 50 36
8 TuS Koblenz Sub 19 Koblenz 26 43 56 36
9 FC 08 Homburg Sub 19 Homburg 26 47 56 34
10 Schott Mainz Sub 19 Schott Mainz 26 43 42 33
11 Eintracht Trier Sub 19 Eintracht 26 58 65 29
12 Meisenheim Sub 19 Meisenheim 26 54 82 29
13 SV Saar 05 Sub 19 Saar 26 46 88 23
14 Sportfreunde Eisbachtal Sub Sportfreunde 26 44 102 23
TEMPORADA 2017/2018
REGIONALLIGA SUB 19 GRUPO 1
Equipo PJ GF GC Puntos
1 SV 07 Elversberg Sub 19 Elversberg 26 99 17 71
2 Saarbrücken Sub 19 Saarbrücken 26 112 19 57
3 FK Pirmasens Sub 19 Pirmasens 26 69 45 53
4 TuS Koblenz Sub 19 Koblenz 26 63 47 50
5 Gonsenheim Sub 19 Gonsenheim 26 58 32 49
6 W. Worms Sub 19 Worms 26 76 53 40
7 Eintracht Trier Sub 19 Eintracht 26 51 49 37
8 Schott Mainz Sub 19 Schott Mainz 26 47 49 37
9 FV Speyer Sub 19 Speyer 26 63 70 31
10 FC 08 Homburg Sub 19 Homburg 26 35 62 26
11 Meisenheim Sub 19 Meisenheim 26 32 77 22
12 Schaumberg Sub 19 Schaumberg 26 29 67 16
13 Offenbach Sub 19 Offenbach 26 36 94 15
14 Rhein-Hunsrück Sub 19 Rhein-Hunsr 26 36 125 9
TEMPORADA 2016/2017
REGIONALLIGA SUB 19 GRUPO 1
Equipo PJ GF GC Puntos
1 Eintracht Trier Sub 19 Eintracht 26 66 20 65
2 SV 07 Elversberg Sub 19 Elversberg 26 68 31 53
3 Saarbrücken Sub 19 Saarbrücken 26 73 30 52
4 FK Pirmasens Sub 19 Pirmasens 26 52 20 50
5 Schott Mainz Sub 19 Schott Mainz 26 63 55 43
6 TuS Koblenz Sub 19 Koblenz 26 54 51 40
7 Gonsenheim Sub 19 Gonsenheim 26 57 44 36
8 FC 08 Homburg Sub 19 Homburg 26 48 50 36
9 W. Worms Sub 19 Worms 26 41 55 33
10 Offenbach Sub 19 Offenbach 26 45 69 30
11 FV Speyer Sub 19 Speyer 26 41 53 29
12 Sportfreunde Eisbachtal Sub Sportfreunde 26 51 69 22
13 SG Mülheim-Kärlich Sub 19 Mülheim-Kä 26 20 73 15
14 Huns. Morbach Sub 19 Huns. 26 20 79 13
TEMPORADA 2015/2016
REGIONALLIGA SUB 19 GRUPO 1
Equipo PJ GF GC Puntos
1 Kaiserslautern Sub 19 Kaiserslaute 26 126 13 70
2 FK Pirmasens Sub 19 Pirmasens 26 76 19 63
3 Schott Mainz Sub 19 Schott Mainz 26 53 24 54
4 Gonsenheim Sub 19 Gonsenheim 26 88 32 51
5 TuS Koblenz Sub 19 Koblenz 26 70 54 46
6 Eintracht Trier Sub 19 Eintracht 26 59 46 38
7 Sportfreunde Eisbachtal Sub Sportfreunde 26 43 48 38
8 W. Worms Sub 19 Worms 26 57 42 37
9 Offenbach Sub 19 Offenbach 26 57 62 34
10 SV 07 Elversberg Sub 19 Elversberg 26 46 52 28
11 SG Mülheim-Kärlich Sub 19 Mülheim-Kä 26 36 110 24
12 Wirges Sub 19 Wirges 26 33 84 20
13 Obere Saar Sub 19 Obere Saar 26 33 91 20
14 Ingelheim Sub 19 Ingelheim 26 17 117 4
TEMPORADA 2014/2015
REGIONALLIGA SUB 19 GRUPO 1
Equipo PJ GF GC Puntos
1 FK Pirmasens Sub 19 Pirmasens 26 64 16 64
2 TuS Koblenz Sub 19 Koblenz 26 77 32 60
3 SV 07 Elversberg Sub 19 Elversberg 26 71 38 55
4 Gonsenheim Sub 19 Gonsenheim 26 48 23 51
5 Schott Mainz Sub 19 Schott Mainz 26 54 37 41
6 Eintracht Trier Sub 19 Eintracht 26 55 52 37
7 W. Worms Sub 19 Worms 26 47 41 35
8 SG Mülheim-Kärlich Sub 19 Mülheim-Kä 26 39 53 30
9 Offenbach Sub 19 Offenbach 26 41 55 27
10 Sportfreunde Eisbachtal Sub Sportfreunde 26 32 47 27
11 Saarlouis/Dillingen Sub 19 Saarlouis/Di 26 37 59 26
12 Phönix Schifferstadt Sub 19 Phönix 26 39 70 22
13 Ludwigshafener SC Sub 19 Ludwigshafen 26 34 74 21
14 Rot-Weiß Hasborn Rot-Weiß 26 31 72 16
TEMPORADA 2013/2014
REGIONALLIGA SUB 19 GRUPO 1
Equipo PJ GF GC Puntos
1 Saarbrücken Sub 19 Saarbrücken 26 101 25 66
2 Ludwigshafener SC Sub 19 Ludwigshafen 26 70 37 58
3 Schott Mainz Sub 19 Schott Mainz 26 91 38 50
4 SV 07 Elversberg Sub 19 Elversberg 26 61 50 38
5 W. Worms Sub 19 Worms 26 53 51 37
6 Eintracht Trier Sub 19 Eintracht 26 45 47 37
7 TuS Koblenz Sub 19 Koblenz 26 55 66 37
8 FK Pirmasens Sub 19 Pirmasens 26 38 38 36
9 Rot-Weiß Hasborn Rot-Weiß 26 54 68 34
10 Offenbach Sub 19 Offenbach 26 45 64 29
11 Sportfreunde Eisbachtal Sub Sportfreunde 26 47 77 29
12 Phönix Schifferstadt Sub 19 Phönix 26 49 70 27
13 TSG Kaiserslautern Sub 19 Kaiserslaute 26 53 85 26
14 Wirges Sub 19 Wirges 26 37 83 15

  USO DE MEMORIA  
5,719,104 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1761
Total Execution Time  0.1773
  CADENA URL  
/historico/Tsv-Schott-Mainz-Sub-19
  GET DATOS  
$_GET['/historico/Tsv-Schott-Mainz-Sub-19']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0023  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 = 'Tsv-Schott-Mainz-Sub-19' 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.0030  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 = 'Tsv-Schott-Mainz-Sub-19' 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.0018  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=138433 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=138433 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=138433 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=138433 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=138433 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=138433 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=138433 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=138433 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=138433 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=138433 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=138433 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025  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 = 60205
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=138433 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2398 AND type_rel = 3
0.0021  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 = '138433' ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '138433' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '138433' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 60205 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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=138433 AND l.year in (2020,2021,2022) 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 (63794,60208) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 60208 AND teamId = 138433
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 63794 AND teamId = 138433
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 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 = 60205 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '138433' 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 = '138433' and rp.type = 4
0.0021  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 = '138433' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 events2021 e ON e.player_id = p.id AND e.league_id = 60205 WHERE rp.league_id = 60205 AND rp.teamId = 138433 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.0019  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 events2021 e ON e.player_id = p.id AND e.league_id = 60205 WHERE rp.league_id = 60205 AND rp.teamId = 138433 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 events2021 e ON e.player_id = p.id AND e.league_id = 60205 WHERE rp.league_id = 60205 AND rp.teamId = 138433 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 138433 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0021  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 = 60205 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.0022  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 = 60208 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.0023  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 = 60209 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 60241 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 60255 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 60302 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 60305 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 60317 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 60205 ORDER BY nameShow LIMIT 100