4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Reading 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 24 66 49 44
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 23 40 53 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 22 46 63 17
12 Norwich City Sub 18 Norwich City 22 37 74 16
13 Reading Sub 18 Reading 22 25 66 14
TEMPORADA 2022/2023
PROFESSIONAL DEVELOPMENT LEAGUE SUB 18
Equipo PJ GF GC Puntos
1 Barnsley Sub 18 Barnsley 28 81 34 67
2 Sheffield United Sub 18 Sheffield 28 57 32 56
3 Peterborough United Sub 18 Peterborough 28 59 42 53
4 Sheffield Wednesday Sub 18 Sheffield 27 42 42 40
5 Crewe Alexandra Sub 18 Crewe 28 50 45 38
6 Coventry City Sub 18 Coventry 27 47 52 36
7 Burnley Sub 18 Burnley 28 42 51 33
8 Hull City Sub 18 Hull City 27 41 76 21
9 Birmingham City Sub 18 Birmingham 28 43 74 20
10 Wigan Athletic Sub 18 Wigan 28 30 72 17
11 Charlton Athletic Sub 18 Charlton 28 84 47 54
12 Cardiff City Sub 18 Cardiff City 28 63 45 49
13 Bristol City Sub 18 Bristol City 28 73 51 48
14 Millwall Sub 18 Millwall 27 64 47 48
15 Reading Sub 18 Reading 28 55 47 45
16 Swansea City Sub 18 Swansea City 28 60 66 42
17 Colchester United Sub 18 Colchester 28 55 65 39
18 Ipswich Town Sub 18 Ipswich Town 28 58 73 33
19 Queens Park Rangers Sub 18 Queens Park 28 53 69 29
20 Watford Sub 18 Watford 28 42 69 25
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 4
Equipo PJ GF GC Puntos
1 Sunderland Sub 18 Sunderland 7 9 5 14
2 Reading Sub 18 Reading 7 10 6 13
3 Wolves Sub 18 Wolves 7 16 5 12
4 Derby County Sub 18 Derby County 7 10 10 12
5 Leicester Sub 18 Leicester 7 14 13 9
6 West Ham Sub 18 West 7 6 10 7
7 Liverpool Sub 18 Liverpool 7 12 17 7
8 Brighton & Hove Sub 18 Brighton 7 9 20 5

  USO DE MEMORIA  
6,211,728 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1418
Total Execution Time  0.1430
  CADENA URL  
/historico/Reading-Sub18
  GET DATOS  
$_GET['/historico/Reading-Sub18']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (44)  
0.0029  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 = 'Reading-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.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=60451 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=60451 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=60451 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=60451 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0039  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.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=60451 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1539 AND type_rel = 3
0.0022  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1539 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  SELECT /*53 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 (1288249,1181899,1178797,1128743,1117192) ORDER BY n.cover_points DESC, update_date DESC
0.0028  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 = '60451' ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '60451' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '60451' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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.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 = 74630 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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.0024  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=60451 AND l.year in (2023,2024,2025) 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 (74630,73675,73464,70921,68467) 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 = 73464 AND teamId = 60451
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 68467 AND teamId = 60451
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 73675 AND teamId = 60451
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 70921 AND teamId = 60451
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 74630 AND teamId = 60451
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 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 = 25 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 = '60451' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '60451' and rp.type = 4
0.0020  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 = '60451' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0037  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 = 60451 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.0030  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 = 60451 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 60451 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 = 60451 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0027  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 = 25 ORDER BY team.conference ASC,t.position 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 `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 = 68467 AND t.round = 10 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 `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.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 `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.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 = 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.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 `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.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 `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.0026  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.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 `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.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 `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.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 `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.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 `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 = 15602 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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