4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Blackburn Rovers Sub 18
TEMPORADA 2023/2024
PREMIER LEAGUE SUB 18 GRUPO 1
Equipo PJ GF GC Puntos
1 Man. Utd Sub 18 Man. 24 77 28 62
2 Man. City Sub 18 Man. City 23 66 24 53
3 Wolves Sub 18 Wolves 24 42 34 41
4 Leeds United Sub 18 Leeds United 24 53 49 34
5 Derby County Sub 18 Derby County 23 50 49 34
6 Liverpool Sub 18 Liverpool 23 55 57 32
7 Newcastle Sub 18 Newcastle 22 43 49 27
8 Middlesbrough Sub 18 Middlesbroug 23 28 42 27
9 Nottingham Forest Sub 18 Nottingham 22 32 44 26
10 Blackburn Rovers Sub 18 Blackburn 21 34 54 24
11 Everton Sub 18 Everton 22 29 35 22
12 Stoke City Sub 18 Stoke City 23 38 57 20
13 Sunderland Sub 18 Sunderland 22 28 53 18
TEMPORADA 2022/2023
PREMIER LEAGUE SUB 18 GRUPO 1
Equipo PJ GF GC Puntos
1 Man. City Sub 18 Man. City 24 81 23 57
2 Sunderland Sub 18 Sunderland 24 63 30 53
3 Man. Utd Sub 18 Man. 24 56 39 44
4 Everton Sub 18 Everton 24 43 41 33
5 Stoke City Sub 18 Stoke City 24 31 39 32
6 Liverpool Sub 18 Liverpool 24 55 54 31
7 Derby County Sub 18 Derby County 24 48 47 31
8 Middlesbrough Sub 18 Middlesbroug 24 34 55 30
9 Nottingham Forest Sub 18 Nottingham 24 37 43 29
10 Blackburn Rovers Sub 18 Blackburn 24 37 56 26
11 Wolves Sub 18 Wolves 24 31 54 26
12 Newcastle Sub 18 Newcastle 24 42 54 24
13 Leeds United Sub 18 Leeds United 24 44 67 20
TEMPORADA 2021/2022
PREMIER LEAGUE SUB 18 GRUPO 1
Equipo PJ GF GC Puntos
1 Man. City Sub 18 Man. City 26 87 26 61
2 Liverpool Sub 18 Liverpool 26 85 45 51
3 Man. Utd Sub 18 Man. 26 58 47 42
4 Nottingham Forest Sub 18 Nottingham 26 36 32 42
5 Blackburn Rovers Sub 18 Blackburn 26 56 38 38
6 Middlesbrough Sub 18 Middlesbroug 26 38 45 38
7 Burnley Sub 18 Burnley 26 40 44 36
8 Wolves Sub 18 Wolves 26 41 46 36
9 Leeds United Sub 18 Leeds United 26 66 70 34
10 Everton Sub 18 Everton 26 28 37 31
11 Sunderland Sub 18 Sunderland 26 39 48 29
12 Derby County Sub 18 Derby County 26 31 62 27
13 Stoke City Sub 18 Stoke City 26 33 56 22
14 Newcastle Sub 18 Newcastle 26 27 69 17
TEMPORADA 2020/2021
PREMIER LEAGUE SUB 18 GRUPO 1
Equipo PJ GF GC Puntos
1 Man. City Sub 18 Man. City 23 71 18 60
2 Man. Utd Sub 18 Man. 23 71 26 57
3 Liverpool Sub 18 Liverpool 24 75 26 52
4 Middlesbrough Sub 18 Middlesbroug 23 47 40 39
5 Everton Sub 18 Everton 23 39 38 35
6 Wolves Sub 18 Wolves 23 38 44 33
7 Derby County Sub 18 Derby County 23 41 53 30
8 Blackburn Rovers Sub 18 Blackburn 23 34 43 29
9 Burnley Sub 18 Burnley 23 33 36 28
10 Stoke City Sub 18 Stoke City 23 28 56 23
11 Newcastle Sub 18 Newcastle 23 44 57 21
12 Leeds United Sub 18 Leeds United 23 30 71 15
13 Sunderland Sub 18 Sunderland 23 31 74 11
TEMPORADA 2019/2020
PREMIER LEAGUE SUB 18 GRUPO 1
Equipo PJ GF GC Puntos
1 Man. City Sub 18 Man. City 17 56 16 43
2 Liverpool Sub 18 Liverpool 15 48 28 31
3 Everton Sub 18 Everton 16 48 33 31
4 Derby County Sub 18 Derby County 17 38 25 28
5 Stoke City Sub 18 Stoke City 15 33 22 28
6 Man. Utd Sub 18 Man. 16 34 32 23
7 Wolves Sub 18 Wolves 15 22 23 21
8 Middlesbrough Sub 18 Middlesbroug 16 28 38 21
9 West Bromwich Albion Sub 18 West 16 34 42 20
10 Newcastle Sub 18 Newcastle 16 23 38 15
11 Blackburn Rovers Sub 18 Blackburn 15 24 35 14
12 Sunderland Sub 18 Sunderland 16 11 67 0
TEMPORADA 2018/2019
PREMIER LEAGUE SUB 18 GRUPO 1
Equipo PJ GF GC Puntos
1 Derby County Sub 18 Derby County 22 63 27 51
2 Liverpool Sub 18 Liverpool 22 59 32 51
3 Everton Sub 18 Everton 22 65 34 44
4 Man. Utd Sub 18 Man. 22 60 39 43
5 Middlesbrough Sub 18 Middlesbroug 22 52 48 35
6 Stoke City Sub 18 Stoke City 22 42 39 32
7 Man. City Sub 18 Man. City 22 46 34 29
8 Blackburn Rovers Sub 18 Blackburn 21 44 48 27
9 West Bromwich Albion Sub 18 West 21 43 60 18
10 Newcastle Sub 18 Newcastle 22 17 62 14
11 Wolves Sub 18 Wolves 21 20 46 11
12 Sunderland Sub 18 Sunderland 21 19 61 10
TEMPORADA 2017/2018
PREMIER LEAGUE SUB 18 GRUPO 1
Equipo PJ GF GC Puntos
1 Man. Utd Sub 18 Man. 22 65 33 48
2 Man. City Sub 18 Man. City 22 58 34 42
3 Liverpool Sub 18 Liverpool 22 50 35 38
4 Stoke City Sub 18 Stoke City 22 49 34 37
5 Everton Sub 18 Everton 22 51 41 37
6 Derby County Sub 18 Derby County 22 45 38 33
7 Sunderland Sub 18 Sunderland 22 39 44 32
8 West Bromwich Albion Sub 18 West 22 49 57 26
9 Middlesbrough Sub 18 Middlesbroug 22 37 52 25
10 Newcastle Sub 18 Newcastle 22 37 48 24
11 Wolves Sub 18 Wolves 22 31 53 19
12 Blackburn Rovers Sub 18 Blackburn 22 28 70 10
TEMPORADA 2016/2017
PREMIER LEAGUE SUB 18 GRUPO 0
Equipo PJ GF GC Puntos
1 Chelsea Sub 18 Chelsea 1 4 0 3
2 Newcastle Sub 18 Newcastle 1 3 0 3
3 Norwich City Sub 18 Norwich City 1 5 3 3
4 Swansea City Sub 18 Swansea City 1 3 1 3
5 Southampton Sub 18 Southampton 1 2 0 3
6 Wolves Sub 18 Wolves 1 2 0 3
7 Man. City Sub 18 Man. City 1 3 2 3
8 Everton Sub 18 Everton 1 2 1 3
9 Arsenal Sub 18 Arsenal 1 2 2 1
10 Aston Villa Sub 18 Aston Villa 1 2 2 1
11 Fulham Sub 18 Fulham 1 2 2 1
12 Liverpool Sub 18 Liverpool 1 2 2 1
13 Man. Utd Sub 18 Man. 1 2 2 1
14 Reading Sub 18 Reading 1 2 2 1
15 Stoke City Sub 18 Stoke City 1 2 2 1
16 Tottenham Hotspur Sub 18 Tottenham 1 2 2 1
17 Blackburn Rovers Sub 18 Blackburn 1 2 3 0
18 Middlesbrough Sub 18 Middlesbroug 1 1 2 0
19 Derby County Sub 18 Derby County 1 3 5 0
20 Leicester Sub 18 Leicester 1 1 3 0
21 Brighton & Hove Sub 18 Brighton 1 0 2 0
22 West Bromwich Albion Sub 18 West 1 0 2 0
23 Sunderland Sub 18 Sunderland 1 0 3 0
24 West Ham Sub 18 West 1 0 4 0
TEMPORADA 2015/2016
PREMIER LEAGUE SUB 18 GRUPO 1
Equipo PJ GF GC Puntos
1 Man. City Sub 18 Man. City 22 53 23 48
2 Everton Sub 18 Everton 22 57 33 48
3 Liverpool Sub 18 Liverpool 22 45 28 43
4 Blackburn Rovers Sub 18 Blackburn 22 45 31 37
5 Sunderland Sub 18 Sunderland 22 44 40 36
6 Middlesbrough Sub 18 Middlesbroug 22 43 38 34
7 Wolves Sub 18 Wolves 22 42 40 28
8 West Bromwich Albion Sub 18 West 22 29 44 25
9 Newcastle Sub 18 Newcastle 22 27 59 20
10 Derby County Sub 18 Derby County 22 39 51 18
11 Man. Utd Sub 18 Man. 22 29 44 18
12 Stoke City Sub 18 Stoke City 22 23 45 16
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,141,800 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1284
Total Execution Time  0.1296
  CADENA URL  
/historico/Blackburn-Rovers-Sub18
  GET DATOS  
$_GET['/historico/Blackburn-Rovers-Sub18']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0028  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 = 'Blackburn-Rovers-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=60439 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=60439 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=60439 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=60439 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=60439 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1539 AND type_rel = 3
0.0023  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.0025  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.0025  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 = '60439' 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 = 73675 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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 = 73463 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0030  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=60439 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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,73463) 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.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 73463 AND teamId = 60439
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 73675 AND teamId = 60439
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 74630 AND teamId = 60439
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 `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 = 73463 AND t.round = 26 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 = '60439' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0021  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '60439' 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 = '60439' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0042  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 = 73463 WHERE rp.league_id = 73463 AND rp.teamId = 60439 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.0044  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 = 73463 WHERE rp.league_id = 73463 AND rp.teamId = 60439 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 events2024 e ON e.player_id = p.id AND e.league_id = 73463 WHERE rp.league_id = 73463 AND rp.teamId = 60439 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 = 60439 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73463 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.0030  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 = 68465 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.0025  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 = 63652 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.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 = 58677 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.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 `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 = 50824 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 = 44823 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 `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 = 39917 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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.0034  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.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 `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 = 15607 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 9256 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 `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