4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2003/2004
LIGA ESCOCIA GRUPO 2
Equipo PJ GF GC Puntos
1 Celtic Celtic 5 6 5 98
2 Rangers FC Rangers FC 5 10 7 81
3 Heart of Midlothian Heart 5 9 4 68
4 Dunfermline Athletic FC Dunfermline 5 10 9 53
5 Dundee United Dundee 5 8 9 49
6 Motherwell Motherwell 5 3 12 46
TEMPORADA 2002/2003
LIGA ESCOCIA GRUPO 2
Equipo PJ GF GC Puntos
1 Celtic Celtic 5 17 4 97
2 Rangers FC Rangers FC 5 15 5 97
3 Heart of Midlothian Heart 5 2 4 63
4 Kilmarnock Kilmarnock 5 4 10 57
5 Dunfermline Athletic FC Dunfermline 5 6 15 46
6 Dundee Dundee 5 6 12 44
TEMPORADA 2001/2002
LIGA ESCOCIA GRUPO 2
Equipo PJ GF GC Puntos
1 Celtic Celtic 5 16 3 103
2 Rangers FC Rangers FC 5 7 4 85
3 Livingston Livingston 5 10 12 58
4 Aberdeen Aberdeen 5 5 6 55
5 Heart of Midlothian Heart 5 8 11 48
6 Dunfermline Athletic FC Dunfermline 5 2 12 45
TEMPORADA 2000/2001
LIGA ESCOCIA GRUPO 1
Equipo PJ GF GC Puntos
1 Celtic Celtic 33 81 24 88
2 Rangers FC Rangers FC 33 60 31 70
3 Hibernian FC Hibernian 33 52 25 61
4 Kilmarnock Kilmarnock 33 39 44 49
5 Heart of Midlothian Heart 33 52 44 47
6 Dundee Dundee 33 47 41 41
7 Dunfermline Athletic FC Dunfermline 33 32 48 41
8 Motherwell Motherwell 33 37 48 39
9 Aberdeen Aberdeen 33 37 48 36
10 St. Johnstone Johnstone 33 35 48 35
11 Dundee United Dundee 33 30 58 23
12 St. Mirren St. Mirren 33 21 64 19
TEMPORADA 1999/2000
LIGA ESCOCIA
Equipo PJ GF GC Puntos
1 Rangers FC Rangers FC 36 96 26 90
2 Celtic Celtic 36 90 38 69
3 Heart of Midlothian Heart 36 47 40 54
4 Motherwell Motherwell 36 49 63 52
5 St. Johnstone Johnstone 36 36 44 42
6 Hibernian FC Hibernian 36 49 61 41
7 Dundee Dundee 36 45 64 41
8 Dundee United Dundee 36 34 57 39
9 Kilmarnock Kilmarnock 36 38 52 37
10 Aberdeen Aberdeen 36 44 83 33
TEMPORADA 1998/1999
LIGA ESCOCIA
Equipo PJ GF GC Puntos
1 Rangers FC Rangers FC 36 78 31 77
2 Celtic Celtic 36 84 35 71
3 St. Johnstone Johnstone 36 39 38 57
4 Kilmarnock Kilmarnock 36 47 29 56
5 Dundee Dundee 36 36 56 46
6 Heart of Midlothian Heart 36 44 50 42
7 Motherwell Motherwell 36 35 54 41
8 Aberdeen Aberdeen 36 43 71 37
9 Dundee United Dundee 36 37 48 34
10 Dunfermline Athletic FC Dunfermline 36 28 59 28
TEMPORADA 1997/1998
LIGA ESCOCIA
Equipo PJ GF GC Puntos
1 Celtic Celtic 36 64 24 74
2 Rangers FC Rangers FC 36 76 38 72
3 Heart of Midlothian Heart 36 70 46 67
4 Kilmarnock Kilmarnock 36 40 52 50
5 St. Johnstone Johnstone 36 38 42 48
6 Aberdeen Aberdeen 36 39 53 39
7 Dundee United Dundee 36 43 51 37
8 Dunfermline Athletic FC Dunfermline 36 43 68 37
9 Motherwell Motherwell 36 46 64 34
10 Hibernian FC Hibernian 36 38 59 30
TEMPORADA 1996/1997
LIGA ESCOCIA
Equipo PJ GF GC Puntos
1 Rangers FC Rangers FC 36 85 33 80
2 Celtic Celtic 36 78 32 75
3 Dundee United Dundee 36 46 33 60
4 Heart of Midlothian Heart 36 46 43 52
5 Dunfermline Athletic FC Dunfermline 36 52 65 45
6 Aberdeen Aberdeen 36 45 54 44
7 Kilmarnock Kilmarnock 36 41 61 39
8 Motherwell Motherwell 36 44 55 38
9 Hibernian FC Hibernian 36 38 55 38
10 Raith Rovers Raith Rovers 36 29 73 25
TEMPORADA 1995/1996
LIGA ESCOCIA
Equipo PJ GF GC Puntos
1 Rangers FC Rangers FC 36 85 25 87
2 Celtic Celtic 36 74 25 83
3 Aberdeen Aberdeen 36 52 45 55
4 Heart of Midlothian Heart 36 55 53 55
5 Hibernian FC Hibernian 36 43 57 43
6 Raith Rovers Raith Rovers 36 41 57 43
7 Kilmarnock Kilmarnock 36 39 54 41
8 Motherwell Motherwell 36 28 39 39
9 Partick Thistle Partick 36 29 62 30
10 Falkirk Falkirk 36 31 60 24
TEMPORADA 1994/1995
LIGA ESCOCIA
Equipo PJ GF GC Puntos
1 Rangers FC Rangers FC 36 60 35 69
2 Motherwell Motherwell 36 50 50 54
3 Hibernian FC Hibernian 36 49 37 53
4 Celtic Celtic 36 39 33 51
5 Falkirk Falkirk 36 48 47 48
6 Heart of Midlothian Heart 36 44 51 43
7 Kilmarnock Kilmarnock 36 40 48 43
8 Partick Thistle Partick 36 40 50 43
9 Aberdeen Aberdeen 36 43 46 41
10 Dundee United Dundee 36 40 56 36
TEMPORADA 1993/1994
LIGA ESCOCIA
Equipo PJ GF GC Puntos
1 Rangers FC Rangers FC 44 74 41 80
2 Motherwell Motherwell 44 58 43 74
3 Aberdeen Aberdeen 44 58 36 72
4 Celtic Celtic 44 51 38 65
5 Hibernian FC Hibernian 44 53 48 63
6 Dundee United Dundee 44 47 48 53
7 Heart of Midlothian Heart 44 37 43 53
8 Kilmarnock Kilmarnock 44 36 45 52
9 Partick Thistle Partick 44 46 57 52
10 St. Johnstone Johnstone 44 35 47 50
11 Dundee Dundee 44 42 57 37
12 Raith Rovers Raith Rovers 44 46 80 37
TEMPORADA 1992/1993
LIGA ESCOCIA
Equipo PJ GF GC Puntos
1 Rangers FC Rangers FC 44 97 35 106
2 Aberdeen Aberdeen 44 87 36 91
3 Celtic Celtic 44 68 41 84
4 Dundee United Dundee 44 56 49 66
5 Heart of Midlothian Heart 44 46 51 59
6 St. Johnstone Johnstone 44 52 66 50
7 Hibernian FC Hibernian 44 54 64 49
8 Partick Thistle Partick 44 50 71 48
9 Motherwell Motherwell 44 46 62 46
10 Dundee Dundee 44 48 68 45
11 Falkirk Falkirk 44 60 86 40
12 Airdrieonians Airdrieonian 44 35 70 35
TEMPORADA 1991/1992
LIGA ESCOCIA
Equipo PJ GF GC Puntos
1 Rangers FC Rangers FC 44 101 31 105
2 Heart of Midlothian Heart 44 60 37 90
3 Celtic Celtic 44 88 42 88
4 Dundee United Dundee 44 66 50 70
5 Aberdeen Aberdeen 44 55 42 65
6 Hibernian FC Hibernian 44 53 45 65
7 Airdrieonians Airdrieonian 44 50 70 49
8 St. Johnstone Johnstone 44 52 73 49
9 Falkirk Falkirk 44 54 73 47
10 Motherwell Motherwell 44 43 61 44
11 St. Mirren St. Mirren 44 33 73 30
12 Dunfermline Athletic FC Dunfermline 44 22 80 22
TEMPORADA 1990/1991
LIGA ESCOCIA
Equipo PJ GF GC Puntos
1 Rangers FC Rangers FC 36 62 23 79
2 Aberdeen Aberdeen 36 62 27 75
3 Celtic Celtic 36 52 38 58
4 Dundee United Dundee 36 41 29 58
5 Heart of Midlothian Heart 36 48 55 49
6 Motherwell Motherwell 36 51 50 45
7 St. Johnstone Johnstone 36 41 54 42
8 Dunfermline Athletic FC Dunfermline 36 38 61 35
9 Hibernian FC Hibernian 36 24 51 31
10 St. Mirren St. Mirren 36 28 59 24
TEMPORADA 1989/1990
LIGA ESCOCIA
Equipo PJ GF GC Puntos
1 Rangers FC Rangers FC 36 48 19 71
2 Aberdeen Aberdeen 36 56 33 61
3 Heart of Midlothian Heart 36 54 35 60
4 Dundee United Dundee 36 36 39 46
5 Hibernian FC Hibernian 36 34 41 46
6 Motherwell Motherwell 36 43 47 45
7 Celtic Celtic 36 37 37 44
8 Dunfermline Athletic FC Dunfermline 36 37 50 41
9 St. Mirren St. Mirren 36 28 48 40
10 Dundee Dundee 36 41 65 29
TEMPORADA 1988/1989
LIGA ESCOCIA
Equipo PJ GF GC Puntos
1 Rangers FC Rangers FC 36 62 26 82
2 Aberdeen Aberdeen 36 51 25 68
3 Celtic Celtic 36 66 44 67
4 Dundee United Dundee 36 44 26 60
5 Hibernian FC Hibernian 36 37 36 48
6 Heart of Midlothian Heart 36 35 42 40
7 St. Mirren St. Mirren 36 39 55 40
8 Dundee Dundee 36 34 48 37
9 Motherwell Motherwell 36 35 44 34
10 Hamilton Academical Hamilton 36 19 76 20

  USO DE MEMORIA  
7,426,192 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.2100
Total Execution Time  0.2112
  CADENA URL  
/historico/Glasgow-Rangers-Fc/2004
  GET DATOS  
$_GET['/historico/Glasgow-Rangers-Fc/2004']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (59)  
0.0105  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 = 2004 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.0019  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.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=1241 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=1241 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=1241 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=1241 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=1241 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=1241 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=1241 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=1241 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=1241 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=1241 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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.0019  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.0026  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 = 9632
0.0025  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 = 383
0.0026  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 = 10304
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 = 22507
0.0025  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 = 23533
0.0052  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 = '1241' AND l.year = 2004 ORDER BY l.year DESC,cat.coefficient DESC
0.0054  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.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 = 9632 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 = 23533 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 = 22507 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 = 383 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0052  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 (2003,2004,2005) 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 (40734,23535,22510,10990,10305,9632) 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.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 10305 AND teamId = 1241
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 9632 AND teamId = 1241
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 10990 AND teamId = 1241
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 40734 AND teamId = 1241
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 22510 AND teamId = 1241
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 23535 AND teamId = 1241
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 `tables2004` 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 = 9632 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0046  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 events2004 e ON e.player_id = p.id AND e.league_id = 9632 WHERE rp.league_id = 9632 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.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 events2004 e ON e.player_id = p.id AND e.league_id = 9632 WHERE rp.league_id = 9632 AND rp.teamId = 1241 AND (e.action = 4 or e.action = 5) 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 events2004 e ON e.player_id = p.id AND e.league_id = 9632 WHERE rp.league_id = 9632 AND rp.teamId = 1241 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0059  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 <= 2004 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 `tables2004` 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 = 383 AND t.round = 33 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 `tables2004` 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 = 10304 AND t.round = 5 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 `tables2003` 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 = 384 AND t.round = 33 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 `tables2003` 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 = 10303 AND t.round = 5 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 `tables2002` 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 = 385 AND t.round = 33 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 `tables2002` 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 = 10302 AND t.round = 5 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 `tables2001` 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 = 10301 AND t.round = 5 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 `tables2001` 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 = 386 AND t.round = 33 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 `tables2000` 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 = 387 AND t.round = 36 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 `tables1999` 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 = 388 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `tables1998` 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 = 389 AND t.round = 36 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 `tables1997` 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 = 390 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036  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 `tables1996` 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 = 391 AND t.round = 36 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 `tables1995` 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 = 392 AND t.round = 36 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 `tables1994` 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 = 10356 AND t.round = 44 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 `tables1993` 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 = 10357 AND t.round = 44 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 `tables1992` 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 = 10367 AND t.round = 44 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 `tables1991` 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 = 10366 AND t.round = 36 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 `tables1990` 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 = 10365 AND t.round = 36 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 `tables1989` 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 = 10364 AND t.round = 36 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 = 9632 ORDER BY nameShow LIMIT 100