4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
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 2
Equipo PJ GF GC Puntos
1 Celtic Celtic 5 6 9 84
2 Rangers FC Rangers FC 5 7 7 72
3 Aberdeen Aberdeen 5 9 5 65
4 Heart of Midlothian Heart 5 7 5 61
5 Kilmarnock Kilmarnock 5 4 5 55
6 Hibernian FC Hibernian 5 7 9 49
TEMPORADA 2005/2006
LIGA ESCOCIA GRUPO 2
Equipo PJ GF GC Puntos
1 Celtic Celtic 5 5 6 91
2 Heart of Midlothian Heart 5 7 4 74
3 Rangers FC Rangers FC 5 8 3 73
4 Hibernian FC Hibernian 5 5 11 56
5 Kilmarnock Kilmarnock 5 4 8 55
6 Aberdeen Aberdeen 5 7 4 54
TEMPORADA 2004/2005
LIGA ESCOCIA GRUPO 2
Equipo PJ GF GC Puntos
1 Rangers FC Rangers FC 5 11 5 93
2 Celtic Celtic 5 8 7 92
3 Hibernian FC Hibernian 5 8 8 61
4 Aberdeen Aberdeen 5 6 6 61
5 Heart of Midlothian Heart 5 4 8 50
6 Motherwell Motherwell 5 5 8 48
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 1
Equipo PJ GF GC Puntos
1 Celtic Celtic 33 78 15 90
2 Rangers FC Rangers FC 33 75 23 77
3 Aberdeen Aberdeen 33 46 43 51
4 Livingston Livingston 33 40 35 49
5 Dunfermline Athletic FC Dunfermline 33 39 52 43
6 Heart of Midlothian Heart 33 44 46 42
7 Kilmarnock Kilmarnock 33 37 46 42
8 Dundee Dundee 33 35 50 37
9 Dundee United Dundee 33 32 56 35
10 Hibernian FC Hibernian 33 43 51 34
11 Motherwell Motherwell 33 42 61 33
12 St. Johnstone Johnstone 33 23 56 19
TEMPORADA 2000/2001
LIGA ESCOCIA GRUPO 2
Equipo PJ GF GC Puntos
1 Rangers FC Rangers FC 5 16 5 12
2 Celtic Celtic 5 9 5 9
3 Dundee Dundee 5 4 8 6
4 Heart of Midlothian Heart 5 4 6 5
5 Kilmarnock Kilmarnock 5 5 9 5
6 Hibernian FC Hibernian 5 5 10 5
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

  USO DE MEMORIA  
7,384,584 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1762
Total Execution Time  0.1774
  CADENA URL  
/historico/Glasgow-Rangers-Fc/2008
  GET DATOS  
$_GET['/historico/Glasgow-Rangers-Fc/2008']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (53)  
0.0071  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 = 2008 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.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.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.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.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 = 3619
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 = 11015
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 = 74
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 = 10308
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 = 40696
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 = 40697
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 = 20909
0.0060  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 = 2008 ORDER BY l.year DESC,cat.coefficient DESC
0.0051  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 = 3619 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 = 40696 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 = 20909 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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 = 11015 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 = 74 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0041  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 (2007,2008,2009) 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 (40697,38335,20910,20902,11015,10309,3619) 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.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 10309 AND teamId = 1241
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 3619 AND teamId = 1241
0.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 11015 AND teamId = 1241
0.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 40697 AND teamId = 1241
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 20902 AND teamId = 1241
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 20910 AND teamId = 1241
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 38335 AND teamId = 1241
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 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 = 3619 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 events2008 e ON e.player_id = p.id AND e.league_id = 3619 WHERE rp.league_id = 3619 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.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 events2008 e ON e.player_id = p.id AND e.league_id = 3619 WHERE rp.league_id = 3619 AND rp.teamId = 1241 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 events2008 e ON e.player_id = p.id AND e.league_id = 3619 WHERE rp.league_id = 3619 AND rp.teamId = 1241 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0055  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 <= 2008 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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.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 `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.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 `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.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 `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
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 `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.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 = 3619 ORDER BY nameShow LIMIT 100