4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Southampton Sub 18
TEMPORADA 2023/2024
PREMIER LEAGUE SUB 18 GRUPO 2
Equipo PJ GF GC Puntos
1 Chelsea Sub 18 Chelsea 21 67 33 51
2 West Ham Sub 18 West 22 66 44 46
3 Arsenal Sub 18 Arsenal 22 76 38 44
4 Fulham Sub 18 Fulham 23 61 48 41
5 Tottenham Hotspur Sub 18 Tottenham 22 67 53 39
6 Crystal Palace Sub 18 Crystal 22 56 44 38
7 Brighton & Hove Sub 18 Brighton 22 51 51 31
8 Leicester Sub 18 Leicester 22 39 48 25
9 West Bromwich Albion Sub 18 West 22 40 59 25
10 Southampton Sub 18 Southampton 22 43 53 20
11 Aston Villa Sub 18 Aston Villa 21 44 60 17
12 Norwich City Sub 18 Norwich City 22 37 74 16
13 Reading Sub 18 Reading 21 22 64 11
TEMPORADA 2022/2023
PREMIER LEAGUE SUB 18 GRUPO 2
Equipo PJ GF GC Puntos
1 West Ham Sub 18 West 22 75 32 57
2 Fulham Sub 18 Fulham 22 70 39 40
3 Crystal Palace Sub 18 Crystal 22 60 41 39
4 Chelsea Sub 18 Chelsea 22 54 42 37
5 Tottenham Hotspur Sub 18 Tottenham 22 51 45 36
6 Brighton & Hove Sub 18 Brighton 22 32 48 29
7 West Bromwich Albion Sub 18 West 22 32 42 24
8 Southampton Sub 18 Southampton 22 45 58 24
9 Leicester Sub 18 Leicester 22 34 50 24
10 Aston Villa Sub 18 Aston Villa 22 43 63 24
11 Arsenal Sub 18 Arsenal 22 43 51 23
12 Norwich City Sub 18 Norwich City 22 32 60 16
TEMPORADA 2021/2022
PREMIER LEAGUE SUB 18 GRUPO 2
Equipo PJ GF GC Puntos
1 Southampton Sub 18 Southampton 26 80 34 62
2 West Ham Sub 18 West 26 70 25 58
3 Crystal Palace Sub 18 Crystal 26 61 31 53
4 Arsenal Sub 18 Arsenal 26 58 43 48
5 Leicester Sub 18 Leicester 26 47 31 47
6 Fulham Sub 18 Fulham 26 53 30 46
7 Chelsea Sub 18 Chelsea 26 66 49 46
8 Brighton & Hove Sub 18 Brighton 26 57 58 33
9 Tottenham Hotspur Sub 18 Tottenham 26 52 66 31
10 West Bromwich Albion Sub 18 West 26 42 63 29
11 Reading Sub 18 Reading 26 36 62 24
12 Aston Villa Sub 18 Aston Villa 26 44 69 20
13 Birmingham City Sub 18 Birmingham 26 29 76 14
14 Norwich City Sub 18 Norwich City 26 20 78 10
TEMPORADA 2020/2021
PREMIER LEAGUE SUB 18 GRUPO 2
Equipo PJ GF GC Puntos
1 Fulham Sub 18 Fulham 24 75 23 56
2 Crystal Palace Sub 18 Crystal 24 67 32 56
3 Brighton & Hove Sub 18 Brighton 24 61 37 45
4 Arsenal Sub 18 Arsenal 24 52 45 40
5 Aston Villa Sub 18 Aston Villa 24 45 52 38
6 Tottenham Hotspur Sub 18 Tottenham 24 52 37 37
7 Chelsea Sub 18 Chelsea 24 57 43 36
8 Norwich City Sub 18 Norwich City 24 58 58 29
9 West Bromwich Albion Sub 18 West 24 49 64 28
10 West Ham Sub 18 West 24 35 57 25
11 Reading Sub 18 Reading 24 53 81 20
12 Leicester Sub 18 Leicester 25 40 81 18
13 Southampton Sub 18 Southampton 25 43 77 16
TEMPORADA 2019/2020
PREMIER LEAGUE SUB 18 GRUPO 2
Equipo PJ GF GC Puntos
1 Fulham Sub 18 Fulham 17 53 24 40
2 West Ham Sub 18 West 17 51 28 37
3 Chelsea Sub 18 Chelsea 16 44 21 36
4 Leicester Sub 18 Leicester 18 44 35 27
5 Tottenham Hotspur Sub 18 Tottenham 17 43 33 26
6 Brighton & Hove Sub 18 Brighton 17 30 33 24
7 Aston Villa Sub 18 Aston Villa 17 33 37 22
8 Southampton Sub 18 Southampton 18 27 40 19
9 Arsenal Sub 18 Arsenal 16 28 34 17
10 Reading Sub 18 Reading 16 25 34 15
11 Norwich City Sub 18 Norwich City 16 32 48 11
12 Swansea City Sub 18 Swansea City 15 20 63 5
TEMPORADA 2018/2019
PREMIER LEAGUE SUB 18 GRUPO 2
Equipo PJ GF GC Puntos
1 Arsenal Sub 18 Arsenal 22 86 23 60
2 Tottenham Hotspur Sub 18 Tottenham 22 81 26 56
3 Chelsea Sub 18 Chelsea 22 42 24 44
4 Southampton Sub 18 Southampton 22 48 41 35
5 Brighton & Hove Sub 18 Brighton 22 40 37 34
6 Aston Villa Sub 18 Aston Villa 22 51 43 32
7 Leicester Sub 18 Leicester 22 37 46 29
8 West Ham Sub 18 West 22 38 52 29
9 Fulham Sub 18 Fulham 22 36 45 24
10 Reading Sub 18 Reading 22 22 53 19
11 Swansea City Sub 18 Swansea City 22 19 53 12
12 Norwich City Sub 18 Norwich City 22 20 77 8
TEMPORADA 2017/2018
PREMIER LEAGUE SUB 18 GRUPO 2
Equipo PJ GF GC Puntos
1 Chelsea Sub 18 Chelsea 22 64 21 54
2 Arsenal Sub 18 Arsenal 22 61 33 45
3 Southampton Sub 18 Southampton 22 38 25 42
4 Tottenham Hotspur Sub 18 Tottenham 22 58 39 34
5 Leicester Sub 18 Leicester 22 38 33 33
6 Swansea City Sub 18 Swansea City 22 32 44 31
7 Fulham Sub 18 Fulham 22 40 33 30
8 Brighton & Hove Sub 18 Brighton 22 36 43 24
9 Aston Villa Sub 18 Aston Villa 22 27 36 23
10 West Ham Sub 18 West 22 27 51 21
11 Reading Sub 18 Reading 22 24 50 21
12 Norwich City Sub 18 Norwich City 22 22 59 13
TEMPORADA 2016/2017
PREMIER LEAGUE SUB 18
Equipo PJ GF GC Puntos
1 Man. City Sub 18 Man. City 22 70 22 55
2 Man. Utd Sub 18 Man. 22 63 31 46
3 Liverpool Sub 18 Liverpool 22 50 33 46
4 Blackburn Rovers Sub 18 Blackburn 22 40 27 44
5 Everton Sub 18 Everton 22 49 35 39
6 Derby County Sub 18 Derby County 22 38 45 32
7 Middlesbrough Sub 18 Middlesbroug 22 33 40 24
8 Stoke City Sub 18 Stoke City 22 34 49 23
9 Newcastle Sub 18 Newcastle 22 25 43 22
10 West Bromwich Albion Sub 18 West 22 29 42 18
11 Sunderland Sub 18 Sunderland 22 23 55 13
12 Wolves Sub 18 Wolves 22 30 62 10
13 Chelsea Sub 18 Chelsea 22 68 21 52
14 Arsenal Sub 18 Arsenal 22 46 26 41
15 Reading Sub 18 Reading 22 51 40 39
16 West Ham Sub 18 West 22 37 31 34
17 Fulham Sub 18 Fulham 22 39 32 33
18 Aston Villa Sub 18 Aston Villa 22 31 39 33
19 Tottenham Hotspur Sub 18 Tottenham 22 48 36 31
20 Norwich City Sub 18 Norwich City 22 46 38 31
21 Southampton Sub 18 Southampton 22 28 41 26
22 Brighton & Hove Sub 18 Brighton 22 28 51 23
23 Swansea City Sub 18 Swansea City 22 23 60 12
24 Leicester Sub 18 Leicester 22 17 47 11
TEMPORADA 2015/2016
PREMIER LEAGUE SUB 18 GRUPO 2
Equipo PJ GF GC Puntos
1 Chelsea Sub 18 Chelsea 22 65 27 50
2 Reading Sub 18 Reading 22 47 27 42
3 Fulham Sub 18 Fulham 22 44 29 39
4 West Ham Sub 18 West 22 30 29 37
5 Aston Villa Sub 18 Aston Villa 22 42 34 36
6 Arsenal Sub 18 Arsenal 22 49 45 35
7 Leicester Sub 18 Leicester 22 39 37 32
8 Tottenham Hotspur Sub 18 Tottenham 22 43 40 31
9 Brighton & Hove Sub 18 Brighton 22 32 51 22
10 Norwich City Sub 18 Norwich City 22 28 48 21
11 Southampton Sub 18 Southampton 22 34 57 15
12 Swansea City Sub 18 Swansea City 22 25 54 13
TEMPORADA 2014/2015
PREMIER LEAGUE SUB 18 GRUPO 5
Equipo PJ GF GC Puntos
1 Stoke City Sub 18 Stoke City 7 18 11 14
2 Blackburn Rovers Sub 18 Blackburn 7 13 8 14
3 Newcastle Sub 18 Newcastle 7 14 9 10
4 Southampton Sub 18 Southampton 7 10 12 10
5 Fulham Sub 18 Fulham 7 13 11 9
6 Bolton Wanderers Sub 18 Bolton 7 9 10 9
7 Norwich City Sub 18 Norwich City 7 11 15 7
8 Arsenal Sub 18 Arsenal 7 10 22 4

  USO DE MEMORIA  
6,032,544 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.6841
Total Execution Time  0.6853
  CADENA URL  
/historico/Southampton-Sub18
  GET DATOS  
$_GET['/historico/Southampton-Sub18']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0169  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 = 'Southampton-Sub18' 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.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=60450 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=60450 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=60450 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=60450 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0292  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 = 73464
0.0149  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 = 73675
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=60450 AND type_rel = 2
0.0146  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 60450 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0151  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (604650,657890) ORDER BY n.cover_points DESC, update_date DESC
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 = '60450' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0157  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 = '60450' 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 = 73675 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 73464 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0151  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=60450 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (74630,73675,73464) 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.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 73464 AND teamId = 60450
0.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 73675 AND teamId = 60450
0.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 74630 AND teamId = 60450
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 = 73464 AND t.round = 24 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0167  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 = 73464 WHERE rp.league_id = 73464 AND rp.teamId = 60450 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.0163  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 = 73464 WHERE rp.league_id = 73464 AND rp.teamId = 60450 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0158  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 = 73464 WHERE rp.league_id = 73464 AND rp.teamId = 60450 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0157  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 = 60450 AND l.year <= 2024 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 `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 = 73464 AND t.round = 24 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 `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 = 68466 AND t.round = 22 ORDER BY team.conference ASC,t.position 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 `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 = 63653 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.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 `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 = 58678 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.0147  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 = 50825 AND t.round = 20 ORDER BY team.conference ASC,t.position 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 `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 = 44824 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 39918 AND t.round = 22 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 `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 = 63067 AND t.round = 1 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 `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 = 39167 AND t.round = 22 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 `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 = 15608 AND t.round = 22 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 `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 = 9257 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 15603 AND t.round = 7 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 = 73464 ORDER BY nameShow LIMIT 100