4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2012/2013
LIGA SUIZA
Equipo PJ GF GC Puntos
1 Basel Basel 36 61 31 72
2 Grasshopper Grasshopper 36 48 32 69
3 St. Gallen St. Gallen 36 54 36 59
4 Zurich Zurich 36 62 48 55
5 Thun Thun 36 44 46 48
6 Sion Sion 36 40 54 48
7 Young Boys Young Boys 36 48 50 43
8 Luzern Luzern 36 41 52 42
9 Lausanne Sports Lausanne 36 32 51 33
10 Servette Servette 36 32 62 26
TEMPORADA 2011/2012
LIGA SUIZA
Equipo PJ GF GC Puntos
1 Basel Basel 34 78 33 74
2 Luzern Luzern 34 46 32 54
3 Young Boys Young Boys 34 52 38 51
4 Servette Servette 34 45 53 48
5 Thun Thun 34 38 41 43
6 Zurich Zurich 34 43 44 41
7 Lausanne Sports Lausanne 34 29 61 30
8 Grasshopper Grasshopper 34 32 66 26
9 Neuchâtel Xamax Neuchâtel 18 22 22 26
10 Sion Sion 34 40 35 17
TEMPORADA 2010/2011
LIGA SUIZA
Equipo PJ GF GC Puntos
1 Basel Basel 36 76 44 73
2 Zurich Zurich 36 74 44 72
3 Young Boys Young Boys 36 65 50 57
4 Sion Sion 36 47 36 54
5 Thun Thun 36 48 43 49
6 Luzern Luzern 36 62 57 48
7 Grasshopper Grasshopper 36 45 54 41
8 Neuchâtel Xamax Neuchâtel 36 44 67 32
9 AC Bellinzona Bellinzona 36 42 75 32
10 St. Gallen St. Gallen 36 34 67 31
TEMPORADA 2009/2010
LIGA SUIZA
Equipo PJ GF GC Puntos
1 Basel Basel 36 90 46 80
2 Young Boys Young Boys 36 78 47 77
3 Grasshopper Grasshopper 36 65 43 65
4 Luzern Luzern 36 66 55 58
5 Sion Sion 36 63 57 51
6 St. Gallen St. Gallen 36 53 56 46
7 Zurich Zurich 36 55 58 45
8 Neuchâtel Xamax Neuchâtel 36 55 57 41
9 AC Bellinzona Bellinzona 36 42 92 25
10 Aarau Aarau 36 32 88 23
TEMPORADA 2008/2009
LIGA SUIZA
Equipo PJ GF GC Puntos
1 Zurich Zurich 36 80 36 79
2 Young Boys Young Boys 36 85 46 73
3 Basel Basel 36 72 44 72
4 Grasshopper Grasshopper 36 57 48 50
5 Aarau Aarau 36 35 51 44
6 AC Bellinzona Bellinzona 36 44 51 43
7 Neuchâtel Xamax Neuchâtel 36 50 57 40
8 Sion Sion 36 44 60 37
9 Luzern Luzern 36 45 62 35
10 FC Vaduz FC Vaduz 36 28 85 22
TEMPORADA 2007/2008
LIGA SUIZA
Equipo PJ GF GC Puntos
1 Basel Basel 36 73 39 74
2 Young Boys Young Boys 36 82 49 70
3 Zurich Zurich 36 58 43 56
4 Grasshopper Grasshopper 36 57 49 54
5 Aarau Aarau 36 47 48 47
6 Luzern Luzern 36 40 49 44
7 Sion Sion 36 48 51 43
8 Neuchâtel Xamax Neuchâtel 36 48 55 41
9 St. Gallen St. Gallen 36 39 69 34
10 Thun Thun 36 30 70 27
TEMPORADA 2006/2007
LIGA SUIZA
Equipo PJ GF GC Puntos
1 Zurich Zurich 36 67 32 75
2 Basel Basel 36 77 40 74
3 Sion Sion 36 57 42 60
4 Young Boys Young Boys 36 52 42 59
5 St. Gallen St. Gallen 36 47 44 55
6 Grasshopper Grasshopper 36 54 41 50
7 Thun Thun 36 30 58 37
8 Luzern Luzern 36 31 58 33
9 Aarau Aarau 36 28 55 26
10 Schaffhausen Schaffhausen 36 27 58 25
TEMPORADA 2005/2006
LIGA SUIZA
Equipo PJ GF GC Puntos
1 Zurich Zurich 36 86 36 78
2 Basel Basel 36 87 42 78
3 Young Boys Young Boys 36 60 46 62
4 Grasshopper Grasshopper 36 44 33 55
5 Thun Thun 36 50 53 49
6 St. Gallen St. Gallen 36 51 56 40
7 Aarau Aarau 36 29 63 35
8 Schaffhausen Schaffhausen 36 32 55 33
9 Neuchâtel Xamax Neuchâtel 36 41 70 33
10 Yverdon Yverdon 36 38 64 32
TEMPORADA 2004/2005
LIGA SUIZA
Equipo PJ GF GC Puntos
1 Basel Basel 34 81 45 70
2 Thun Thun 34 69 42 60
3 Grasshopper Grasshopper 34 51 50 50
4 Young Boys Young Boys 34 60 52 49
5 Zurich Zurich 34 55 57 48
6 Neuchâtel Xamax Neuchâtel 34 36 48 38
7 St. Gallen St. Gallen 34 51 60 36
8 Aarau Aarau 34 42 64 32
9 Schaffhausen Schaffhausen 34 36 59 32
10 Servette Servette 18 24 28 20
TEMPORADA 2003/2004
LIGA SUIZA
Equipo PJ GF GC Puntos
1 Basel Basel 36 86 32 85
2 Young Boys Young Boys 36 75 48 72
3 Servette Servette 36 61 62 52
4 Zurich Zurich 36 58 52 50
5 St. Gallen St. Gallen 36 54 57 50
6 Thun Thun 36 51 57 49
7 Grasshopper Grasshopper 36 62 74 41
8 Aarau Aarau 36 57 69 38
9 Neuchâtel Xamax Neuchâtel 36 46 63 36
10 FC Wil FC Wil 36 37 73 29
TEMPORADA 2002/2003
LIGA SUIZA GRUPO 1
Equipo PJ GF GC Puntos
1 Grasshopper Grasshopper 22 58 26 49
2 Basel Basel 22 57 25 47
3 Thun Thun 22 33 33 31
4 FC Wil FC Wil 22 43 45 31
5 Zurich Zurich 22 35 37 31
6 Neuchâtel Xamax Neuchâtel 22 30 33 31
7 Young Boys Young Boys 22 41 41 30
8 Servette Servette 22 45 37 29
9 Luzern Luzern 22 31 38 24
10 St. Gallen St. Gallen 22 31 48 24
11 Delemont Delemont 22 24 44 20
12 Aarau Aarau 22 19 40 18
TEMPORADA 2001/2002
LIGA SUIZA GRUPO 1
Equipo PJ GF GC Puntos
1 Basel Basel 22 52 37 43
2 FC Lugano FC Lugano 22 39 33 38
3 Grasshopper Grasshopper 22 50 33 37
4 St. Gallen St. Gallen 22 38 32 35
5 Servette Servette 22 36 29 34
6 Sion Sion 22 40 29 33
7 Young Boys Young Boys 22 35 28 31
8 Zurich Zurich 22 24 27 30
9 Aarau Aarau 22 28 25 27
10 Neuchâtel Xamax Neuchâtel 22 28 36 25
11 Lausanne Sports Lausanne 22 24 49 16
12 Luzern Luzern 22 23 59 13
TEMPORADA 2000/2001
LIGA SUIZA GRUPO 2
Equipo PJ GF GC Puntos
1 Grasshopper Grasshopper 14 29 14 46
2 FC Lugano FC Lugano 14 24 19 41
3 St. Gallen St. Gallen 14 23 28 40
4 Basel Basel 14 18 16 37
5 Servette Servette 14 26 19 37
6 Lausanne Sports Lausanne 14 15 27 33
7 Sion Sion 14 16 22 32
8 Zurich Zurich 14 12 18 28
TEMPORADA 1999/2000
LIGA SUIZA GRUPO 2
Equipo PJ GF GC Puntos
1 St. Gallen St. Gallen 14 33 14 54
2 Lausanne Sports Lausanne 14 22 13 44
3 Basel Basel 14 16 16 40
4 Grasshopper Grasshopper 14 30 26 37
5 Servette Servette 14 25 21 31
6 Luzern Luzern 14 17 30 31
7 Neuchâtel Xamax Neuchâtel 14 25 29 29
8 Yverdon Yverdon 14 16 35 22
TEMPORADA 1998/1999
LIGA SUIZA GRUPO 2
Equipo PJ GF GC Puntos
1 Grasshopper Grasshopper 14 31 11 46
2 Servette Servette 14 19 14 46
3 Lausanne Sports Lausanne 14 28 20 45
4 Zurich Zurich 14 24 15 42
5 Basel Basel 14 18 19 33
6 Luzern Luzern 14 13 27 28
7 Neuchâtel Xamax Neuchâtel 14 12 27 28
8 St. Gallen St. Gallen 14 13 25 24

  USO DE MEMORIA  
6,724,088 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1835
Total Execution Time  0.1848
  CADENA URL  
/historico/Basel/2013
  GET DATOS  
$_GET['/historico/Basel/2013']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (56)  
0.0042  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 = 'Basel' AND l.year = 2013 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=10035 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=10035 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=10035 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=10035 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=10035 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=10035 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=10035 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=10035 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0028  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 = 2155
0.0027  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 = 2257
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 = 2039
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 = 42838
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 = 42839
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 = 42840
0.0029  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 = 20655
0.0045  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 = '10035' AND l.year = 2013 ORDER BY l.year DESC,cat.coefficient DESC
0.0035  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 = '10035' 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 = 42839 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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 = 20655 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 = 2155 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 = 2039 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0053  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=10035 AND l.year in (2012,2013,2014) 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 (43334,42840,20656,2825,2471,2420,2399) 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.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 2420 AND teamId = 10035
0.0032  SELECT count(id) as num_players from rel_players WHERE league_id = 2825 AND teamId = 10035
0.0035  SELECT count(id) as num_players from rel_players WHERE league_id = 2471 AND teamId = 10035
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 42840 AND teamId = 10035
0.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 20656 AND teamId = 10035
0.0030  SELECT count(id) as num_players from rel_players WHERE league_id = 43334 AND teamId = 10035
0.0046  SELECT count(id) as num_players from rel_players WHERE league_id = 2399 AND teamId = 10035
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 `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 = 2155 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0031  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 events2013 e ON e.player_id = p.id AND e.league_id = 2155 WHERE rp.league_id = 2155 AND rp.teamId = 10035 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.0031  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 events2013 e ON e.player_id = p.id AND e.league_id = 2155 WHERE rp.league_id = 2155 AND rp.teamId = 10035 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 events2013 e ON e.player_id = p.id AND e.league_id = 2155 WHERE rp.league_id = 2155 AND rp.teamId = 10035 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0040  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 = 10035 AND l.year <= 2013 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 `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 = 2039 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 `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 = 1358 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 `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 = 1094 AND t.round = 36 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 `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 = 874 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 `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 = 675 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 `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 = 676 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 `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 = 677 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 `tables2005` 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 = 678 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 `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 = 679 AND t.round = 36 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 = 10074 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 `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 = 680 AND t.round = 22 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 `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 = 10073 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 `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 = 681 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 `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 = 682 AND t.round = 22 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 = 10072 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 `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 = 683 AND t.round = 22 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 `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 = 10071 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 `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 = 684 AND t.round = 22 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 = 10070 AND t.round = 14 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 = 2155 ORDER BY nameShow LIMIT 100