4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Rangers FC

Rangers FC

Entrenador: Philippe Clement

Temporada 2016/2017
TEMPORADA 2016/2017
LIGA ESCOCIA GRUPO 2
Equipo PJ GF GC Puntos
1 Celtic Celtic 5 19 3 106
2 Aberdeen Aberdeen 5 11 7 76
3 Rangers FC Rangers FC 5 8 10 67
4 St. Johnstone Johnstone 5 6 6 58
5 Heart of Midlothian Heart 5 4 9 46
6 Partick Thistle Partick 5 3 16 42
TEMPORADA 2015/2016
CHAMPIONSHIP ESCOCIA
Equipo PJ GF GC Puntos
1 Rangers FC Rangers FC 36 88 34 81
2 Falkirk Falkirk 36 61 34 70
3 Hibernian FC Hibernian 36 59 34 70
4 Raith Rovers Raith Rovers 36 52 46 62
5 Greenock Morton Greenock 36 39 42 43
6 St. Mirren St. Mirren 36 44 53 42
7 Queen of the South Queen South 36 46 56 42
8 Dumbarton Dumbarton 36 35 66 37
9 Livingston Livingston 36 37 51 31
10 Alloa Athletic Alloa 36 22 67 21
TEMPORADA 2014/2015
CHAMPIONSHIP ESCOCIA
Equipo PJ GF GC Puntos
1 Heart of Midlothian Heart 36 96 26 91
2 Hibernian FC Hibernian 36 70 32 70
3 Rangers FC Rangers FC 36 69 39 67
4 Queen of the South Queen South 36 58 41 60
5 Falkirk Falkirk 36 48 48 53
6 Raith Rovers Raith Rovers 36 42 65 43
7 Dumbarton Dumbarton 36 36 79 34
8 Livingston Livingston 36 41 53 32
9 Alloa Athletic Alloa 36 34 56 27
10 Cowdenbeath Cowdenbeath 36 31 86 25
TEMPORADA 2013/2014
LEAGUE ONE ESCOCIA
Equipo PJ GF GC Puntos
1 Rangers FC Rangers FC 36 106 18 102
2 Dunfermline Athletic FC Dunfermline 36 68 54 63
3 Stranraer Stranraer 36 57 57 51
4 Ayr United Ayr United 36 65 66 49
5 Stenhousemuir Stenhousemui 36 57 66 48
6 Airdrieonians Airdrieonian 36 47 57 45
7 Forfar Athletic Forfar 36 55 62 43
8 Brechin City Brechin City 36 57 71 42
9 East Fife East Fife 36 31 69 32
10 Arbroath Arbroath 36 52 75 31
TEMPORADA 2012/2013
LEAGUE TWO ESCOCIA
Equipo PJ GF GC Puntos
1 Rangers FC Rangers FC 36 87 29 83
2 Peterhead Peterhead 36 52 28 59
3 Queen's Park Queen's Park 36 60 54 56
4 Berwick Rangers Berwick 36 59 55 49
5 Elgin City Elgin City 36 67 69 49
6 Montrose Montrose 36 60 68 47
7 Stirling Albion Stirling 36 59 58 45
8 Annan Athletic Annan 36 54 65 43
9 Clyde Clyde 36 42 66 40
10 East Stirlingshire East 36 49 97 29
TEMPORADA 2011/2012
LIGA ESCOCIA GRUPO 2
Equipo PJ GF GC Puntos
1 Celtic Celtic 5 12 1 93
2 Rangers FC Rangers FC 5 12 3 73
3 Motherwell Motherwell 5 6 6 62
4 Dundee United Dundee 5 7 7 59
5 Heart of Midlothian Heart 5 4 11 52
6 St. Johnstone Johnstone 5 1 14 50
TEMPORADA 2010/2011
LIGA ESCOCIA GRUPO 1
Equipo PJ GF GC Puntos
1 Rangers FC Rangers FC 33 72 28 80
2 Celtic Celtic 33 72 21 79
3 Heart of Midlothian Heart 33 47 31 61
4 Dundee United Dundee 33 44 41 52
5 Kilmarnock Kilmarnock 33 47 41 47
6 Motherwell Motherwell 33 36 43 44
7 Inverness CT Inverness 33 44 42 41
8 Hibernian FC Hibernian 33 36 52 36
9 St. Johnstone Johnstone 33 18 39 34
10 Aberdeen Aberdeen 33 34 54 31
11 St. Mirren St. Mirren 33 31 54 28
12 Hamilton Academical Hamilton 33 20 55 19
TEMPORADA 2009/2010
LIGA ESCOCIA GRUPO 1
Equipo PJ GF GC Puntos
1 Rangers FC Rangers FC 33 73 22 77
2 Celtic Celtic 33 62 35 66
3 Dundee United Dundee 33 51 39 59
4 Hibernian FC Hibernian 33 47 43 50
5 Motherwell Motherwell 33 39 38 48
6 Heart of Midlothian Heart 33 32 39 44
7 St. Johnstone Johnstone 33 50 54 41
8 Hamilton Academical Hamilton 33 29 43 36
9 Aberdeen Aberdeen 33 31 46 34
10 Kilmarnock Kilmarnock 33 26 44 29
11 St. Mirren St. Mirren 33 32 45 28
12 Falkirk Falkirk 33 30 54 28
TEMPORADA 2008/2009
LIGA ESCOCIA GRUPO 1
Equipo PJ GF GC Puntos
1 Celtic Celtic 33 75 30 74
2 Rangers FC Rangers FC 33 68 26 73
3 Heart of Midlothian Heart 33 37 34 54
4 Dundee United Dundee 33 43 40 49
5 Aberdeen Aberdeen 33 36 33 48
6 Hibernian FC Hibernian 33 38 41 42
7 Motherwell Motherwell 33 36 44 41
8 Kilmarnock Kilmarnock 33 31 43 34
9 St. Mirren St. Mirren 33 28 44 34
10 Hamilton Academical Hamilton 33 26 47 34
11 Inverness CT Inverness 33 32 52 32
12 Falkirk Falkirk 33 32 48 28
TEMPORADA 2007/2008
LIGA ESCOCIA GRUPO 1
Equipo PJ GF GC Puntos
1 Rangers FC Rangers FC 33 78 27 79
2 Celtic Celtic 33 75 23 74
3 Motherwell Motherwell 33 43 40 53
4 Dundee United Dundee 33 48 38 50
5 Hibernian FC Hibernian 33 47 38 50
6 Aberdeen Aberdeen 33 43 53 44
7 Falkirk Falkirk 33 40 44 42
8 Heart of Midlothian Heart 33 42 48 42
9 Inverness CT Inverness 33 41 58 36
10 Kilmarnock Kilmarnock 33 34 46 33
11 St. Mirren St. Mirren 33 22 51 33
12 Gretna Gretna 33 29 76 17
TEMPORADA 2006/2007
LIGA ESCOCIA GRUPO 1
Equipo PJ GF GC Puntos
1 Celtic Celtic 33 59 25 78
2 Rangers FC Rangers FC 33 54 25 65
3 Aberdeen Aberdeen 33 46 33 57
4 Heart of Midlothian Heart 33 40 30 54
5 Kilmarnock Kilmarnock 33 43 49 46
6 Hibernian FC Hibernian 33 49 37 44
7 Falkirk Falkirk 33 40 42 40
8 Dundee United Dundee 33 39 53 40
9 Inverness CT Inverness 33 36 45 36
10 Motherwell Motherwell 33 35 49 36
11 St. Mirren St. Mirren 33 24 47 27
12 Dunfermline Athletic FC Dunfermline 33 19 49 23
TEMPORADA 2005/2006
LIGA ESCOCIA GRUPO 1
Equipo PJ GF GC Puntos
1 Celtic Celtic 33 88 31 85
2 Heart of Midlothian Heart 33 64 27 65
3 Rangers FC Rangers FC 33 59 34 62
4 Hibernian FC Hibernian 33 56 45 52
5 Kilmarnock Kilmarnock 33 59 56 51
6 Aberdeen Aberdeen 33 39 36 48
7 Motherwell Motherwell 33 50 55 44
8 Inverness CT Inverness 33 45 38 43
9 Dundee United Dundee 33 39 58 32
10 Falkirk Falkirk 33 31 61 25
11 Dunfermline Athletic FC Dunfermline 33 26 63 23
12 Livingston Livingston 33 20 72 15

  USO DE MEMORIA  
7,194,240 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.8920
Total Execution Time  0.8943
  CADENA URL  
/historico/Glasgow-Rangers-Fc/2017
  GET DATOS  
$_GET['/historico/Glasgow-Rangers-Fc/2017']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (52)  
0.0266  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 = 'Glasgow-Rangers-Fc' AND l.year = 2017 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.0133  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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0132  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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0132  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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0139  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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0152  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 = 38280
0.0145  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 = 34078
0.0234  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 = '1241' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0134  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 = 34078 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0251  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=1241 AND l.year in (2016,2017,2018) ORDER BY l.id DESC, l.year DESC ;
0.0134  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 (43280,39272,38977,38742,38427,16176,15405) 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.0161  SELECT count(id) as num_players from rel_players WHERE league_id = 43280 AND teamId = 1241
0.0180  SELECT count(id) as num_players from rel_players WHERE league_id = 15405 AND teamId = 1241
0.0157  SELECT count(id) as num_players from rel_players WHERE league_id = 38742 AND teamId = 1241
0.0173  SELECT count(id) as num_players from rel_players WHERE league_id = 38977 AND teamId = 1241
0.0161  SELECT count(id) as num_players from rel_players WHERE league_id = 39272 AND teamId = 1241
0.0139  SELECT count(id) as num_players from rel_players WHERE league_id = 16176 AND teamId = 1241
0.0284  SELECT count(id) as num_players from rel_players WHERE league_id = 38427 AND teamId = 1241
0.0129  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 = '1241' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0127  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1241' and rp.type = 4
0.0133  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 = '1241' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0234  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 events2017 e ON e.player_id = p.id AND e.league_id = 33312 WHERE rp.league_id = 33312 AND rp.teamId = 1241 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.0246  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 events2017 e ON e.player_id = p.id AND e.league_id = 33312 WHERE rp.league_id = 33312 AND rp.teamId = 1241 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0176  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 events2017 e ON e.player_id = p.id AND e.league_id = 33312 WHERE rp.league_id = 33312 AND rp.teamId = 1241 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147  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 = 1241 AND l.year <= 2017 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0128  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 = 33312 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 38280 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 2457 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 2027 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 1430 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 10312 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 10311 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 1086 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 `tables2010` 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 = 10310 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 `tables2010` 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 = 935 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 `tables2009` 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 = 10309 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 `tables2009` 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 = 281 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 `tables2008` 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 = 10308 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 `tables2008` 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 = 74 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 `tables2007` 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 = 10307 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  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 `tables2007` 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 = 380 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138  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 `tables2006` 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 = 10306 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 `tables2006` 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 = 381 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC