4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Bristol City WFC Fem

Bristol City WFC Fem

Entrenador: Lauren Smith

Temporada 2023/2024
TEMPORADA 2023/2024
PREMIER LEAGUE FEMENINA
Equipo PJ GF GC Puntos
1 Man. City Fem Man. City 19 54 12 49
2 Chelsea Fem Chelsea Fem 18 53 14 46
3 Arsenal Fem Arsenal Fem 19 45 18 43
4 Man. Utd Fem Man. 19 41 25 32
5 Liverpool Fem Liverpool 19 27 25 32
6 Tottenham Hotspur Fem Tottenham 18 25 31 26
7 Aston Villa Fem Aston Villa 19 24 40 20
8 Brighton & Hove Fem Brighton 19 25 41 18
9 Everton Fem Everton Fem 19 17 34 18
10 Leicester Fem Leicester 19 25 39 17
11 West Ham Fem West 19 17 40 13
12 Bristol City WFC Fem Bristol City 19 20 54 6
TEMPORADA 2022/2023
PREMIER LEAGUE 2 FEMENINA
Equipo PJ GF GC Puntos
1 Bristol City WFC Fem Bristol City 22 39 12 48
2 Birmingham City Fem Birmingham 22 39 22 47
3 London City Lionesses London City 22 49 20 45
4 Charlton Athletic Fem Charlton 22 34 27 38
5 Crystal Palace Fem Crystal 22 28 34 34
6 Southampton Fem Southampton 22 22 15 33
7 Durham Fem Durham Fem 22 30 29 28
8 Sheffield United Fem Sheffield 22 32 25 27
9 Lewes Fem Lewes Fem 22 20 29 26
10 Blackburn Rovers Fem Blackburn 22 20 29 23
11 Sunderland Fem Sunderland 22 26 38 18
12 Coventry United Fem Coventry 22 16 75 7
TEMPORADA 2021/2022
PREMIER LEAGUE 2 FEMENINA
Equipo PJ GF GC Puntos
1 Liverpool Fem Liverpool 22 49 11 52
2 London City Lionesses London City 22 35 22 41
3 Bristol City WFC Fem Bristol City 22 43 28 37
4 Crystal Palace Fem Crystal 22 35 39 37
5 Charlton Athletic Fem Charlton 22 27 18 34
6 Durham Fem Durham Fem 22 30 28 34
7 Sheffield United Fem Sheffield 22 34 31 33
8 Lewes Fem Lewes Fem 22 23 24 29
9 Sunderland Fem Sunderland 22 23 32 24
10 Blackburn Rovers Fem Blackburn 22 17 41 17
11 Coventry United Fem Coventry 22 18 32 12
12 Watford Fem Watford Fem 22 18 46 11
TEMPORADA 2020/2021
PREMIER LEAGUE FEMENINA
Equipo PJ GF GC Puntos
1 Chelsea Fem Chelsea Fem 22 69 10 57
2 Man. City Fem Man. City 22 65 13 55
3 Arsenal Fem Arsenal Fem 22 63 15 48
4 Man. Utd Fem Man. 22 44 20 47
5 Everton Fem Everton Fem 22 39 30 32
6 Brighton & Hove Fem Brighton 22 21 41 27
7 Reading Fem Reading Fem 22 25 41 24
8 Tottenham Hotspur Fem Tottenham 22 18 41 18
9 Birmingham City Fem Birmingham 22 15 44 16
10 West Ham Fem West 22 21 39 15
11 Aston Villa Fem Aston Villa 22 15 47 15
12 Bristol City WFC Fem Bristol City 22 18 72 12
TEMPORADA 2019/2020
PREMIER LEAGUE FEMENINA
Equipo PJ GF GC Puntos
1 Man. City Fem Man. City 16 39 9 40
2 Chelsea Fem Chelsea Fem 15 47 11 39
3 Arsenal Fem Arsenal Fem 15 40 13 36
4 Man. Utd Fem Man. 14 24 12 23
5 Reading Fem Reading Fem 14 21 24 21
6 Tottenham Hotspur Fem Tottenham 15 15 24 20
7 Everton Fem Everton Fem 14 21 21 19
8 West Ham Fem West 14 19 34 16
9 Brighton & Hove Fem Brighton 16 11 30 13
10 Bristol City WFC Fem Bristol City 14 9 38 9
11 Birmingham City Fem Birmingham 13 5 23 7
12 Liverpool Fem Liverpool 14 8 20 6
TEMPORADA 2018/2019
PREMIER LEAGUE FEMENINA
Equipo PJ GF GC Puntos
1 Arsenal Fem Arsenal Fem 20 70 13 54
2 Man. City Fem Man. City 20 53 17 47
3 Chelsea Fem Chelsea Fem 20 46 14 42
4 Birmingham City Fem Birmingham 19 26 16 37
5 Reading Fem Reading Fem 20 33 30 27
6 Bristol City WFC Fem Bristol City 20 17 34 25
7 West Ham Fem West 20 25 37 23
8 Liverpool Fem Liverpool 20 21 38 22
9 Brighton & Hove Fem Brighton 20 16 38 16
10 Everton Fem Everton Fem 19 14 35 12
11 Yeovil Town Fem Yeovil Town 20 11 60 7
TEMPORADA 2017/2018
PREMIER LEAGUE FEMENINA
Equipo PJ GF GC Puntos
1 Chelsea Fem Chelsea Fem 18 44 13 44
2 Man. City Fem Man. City 18 51 17 38
3 Arsenal Fem Arsenal Fem 18 38 18 37
4 Reading Fem Reading Fem 18 40 18 32
5 Birmingham City Fem Birmingham 18 30 18 30
6 Liverpool Fem Liverpool 18 30 27 28
7 Sunderland Fem Sunderland 18 15 40 16
8 Bristol City WFC Fem Bristol City 18 13 47 16
9 Everton Fem Everton Fem 18 19 30 14
10 Yeovil Town Fem Yeovil Town 18 2 54 2
TEMPORADA 2016/2017
PREMIER LEAGUE FEMENINA
Equipo PJ GF GC Puntos
1 Chelsea Fem Chelsea Fem 8 32 3 19
2 Man. City Fem Man. City 8 17 6 19
3 Arsenal Fem Arsenal Fem 8 22 9 18
4 Liverpool Fem Liverpool 8 20 18 14
5 Sunderland Fem Sunderland 8 4 14 9
6 Reading Fem Reading Fem 8 10 15 8
7 Birmingham City Fem Birmingham 8 6 10 7
8 Bristol City WFC Fem Bristol City 8 5 21 4
9 Yeovil Town Fem Yeovil Town 8 6 26 1
TEMPORADA 2014/2015
PREMIER LEAGUE FEMENINA
Equipo PJ GF GC Puntos
1 Chelsea Fem Chelsea Fem 14 30 10 32
2 Man. City Fem Man. City 14 25 11 30
3 Arsenal Fem Arsenal Fem 14 21 13 27
4 Sunderland Fem Sunderland 14 24 24 20
5 Notts County Fem Notts County 14 20 20 15
6 Birmingham City Fem Birmingham 14 7 14 13
7 Liverpool Fem Liverpool 14 15 24 13
8 Bristol City WFC Fem Bristol City 14 12 38 8
TEMPORADA 2013/2014
PREMIER LEAGUE FEMENINA
Equipo PJ GF GC Puntos
1 Liverpool Fem Liverpool 14 19 10 26
2 Chelsea Fem Chelsea Fem 14 23 16 26
3 Birmingham City Fem Birmingham 14 20 14 25
4 Notts County Fem Notts County 14 12 8 19
5 Man. City Fem Man. City 14 13 16 19
6 Arsenal Fem Arsenal Fem 13 22 20 18
7 Bristol City WFC Fem Bristol City 14 18 24 14
8 Everton Fem Everton Fem 13 9 28 4
TEMPORADA 2012/2013
PREMIER LEAGUE FEMENINA
Equipo PJ GF GC Puntos
1 Liverpool Fem Liverpool 14 46 19 36
2 Arsenal Fem Arsenal Fem 14 31 11 33
3 Bristol City WFC Fem Bristol City 14 30 20 31
4 Birmingham City Fem Birmingham 14 16 21 18
5 Everton Fem Everton Fem 14 23 30 15
6 Notts County Fem Notts County 14 10 15 10
7 Chelsea Fem Chelsea Fem 14 20 27 10
8 Doncaster Belles Doncaster 14 9 42 6
TEMPORADA 2011/2012
PREMIER LEAGUE FEMENINA
Equipo PJ GF GC Puntos
1 Arsenal Fem Arsenal Fem 14 39 18 34
2 Birmingham City Fem Birmingham 14 31 18 26
3 Everton Fem Everton Fem 14 20 16 25
4 Bristol City WFC Fem Bristol City 14 17 16 18
5 Notts County Fem Notts County 14 24 26 18
6 Chelsea Fem Chelsea Fem 14 20 23 17
7 Doncaster Belles Doncaster 14 14 28 11
8 Liverpool Fem Liverpool 14 15 35 5
TEMPORADA 2010/2011
PREMIER LEAGUE FEMENINA
Equipo PJ GF GC Puntos
1 Arsenal Fem Arsenal Fem 14 29 9 32
2 Birmingham City Fem Birmingham 14 29 13 29
3 Everton Fem Everton Fem 14 19 13 25
4 Notts County Fem Notts County 14 18 16 21
5 Bristol City WFC Fem Bristol City 14 14 20 16
6 Chelsea Fem Chelsea Fem 14 14 19 15
7 Doncaster Belles Doncaster 14 9 26 9
8 Liverpool Fem Liverpool 14 10 26 7

  USO DE MEMORIA  
6,062,184 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Home / Category )  0.1431
Total Execution Time  0.1448
  CADENA URL  
/historico/Bristol-City-Femenino
  GET DATOS  
$_GET['/historico/Bristol-City-Femenino']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
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 = 'Bristol-City-Femenino' 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.0020  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=87771 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=87771 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=87771 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=87771 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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 = 72940
0.0024  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 = 74416
0.0023  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 = 74246
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=87771 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 87771 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  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 (252341,415869) ORDER BY n.cover_points DESC, update_date DESC
0.0029  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 = '87771' 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 = 74246 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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 = 74416 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 72940 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0037  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=87771 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 (74416,74246,72940,68395) 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 = 68395 AND teamId = 87771
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 72940 AND teamId = 87771
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 74416 AND teamId = 87771
0.0030  SELECT count(id) as num_players from rel_players WHERE league_id = 74246 AND teamId = 87771
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 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 = 72940 AND t.round = 20 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  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 = '87771' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '87771' 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 = '87771' 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 = 72940 WHERE rp.league_id = 72940 AND rp.teamId = 87771 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.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 = 72940 WHERE rp.league_id = 72940 AND rp.teamId = 87771 AND (e.action = 4 or e.action = 5) 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 = 72940 WHERE rp.league_id = 72940 AND rp.teamId = 87771 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0038  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 = 87771 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 = 72940 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.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 `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 = 68395 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.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 `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 = 65613 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.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 = 58275 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.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 = 50033 AND t.round = 17 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 = 44648 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 = 39843 AND t.round = 18 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 = 37880 AND t.round = 8 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 `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 = 28559 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 28561 AND t.round = 14 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 `tables2013` 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 = 28564 AND t.round = 14 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 `tables2012` 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 = 28565 AND t.round = 14 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 `tables2011` 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 = 28566 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC