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

Basel

Entrenador: Fabio Celestini

Temporada 2006/2007
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 2
Equipo PJ GF GC Puntos
1 Grasshopper Grasshopper 14 37 15 57
2 Basel Basel 14 38 17 56
3 Neuchâtel Xamax Neuchâtel 14 18 17 35
4 Young Boys Young Boys 14 21 29 34
5 Zurich Zurich 14 20 23 31
6 Servette Servette 14 16 26 31
7 Thun Thun 14 18 30 28
8 FC Wil FC Wil 14 19 30 26
TEMPORADA 2001/2002
LIGA SUIZA GRUPO 2
Equipo PJ GF GC Puntos
1 Basel Basel 14 36 16 55
2 Grasshopper Grasshopper 14 28 17 45
3 FC Lugano FC Lugano 14 23 19 42
4 Servette Servette 14 25 23 38
5 Zurich Zurich 14 14 17 35
6 St. Gallen St. Gallen 14 18 20 34
7 Young Boys Young Boys 14 18 25 31
8 Sion Sion 14 10 35 21
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 1
Equipo PJ GF GC Puntos
1 St. Gallen St. Gallen 22 42 25 45
2 Basel Basel 22 31 21 37
3 Lausanne Sports Lausanne 22 35 25 36
4 Grasshopper Grasshopper 22 40 25 34
5 Yverdon Yverdon 22 28 25 30
6 Luzern Luzern 22 28 29 28
7 Servette Servette 22 32 36 28
8 Zurich Zurich 22 22 27 27
9 Neuchâtel Xamax Neuchâtel 22 32 34 26
10 Aarau Aarau 22 30 42 26
11 FC Lugano FC Lugano 22 27 34 21
12 Delemont Delemont 22 24 48 17
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
TEMPORADA 1997/1998
LIGA SUIZA GRUPO 3
Equipo PJ GF GC Puntos
1 Neuchâtel Xamax Neuchâtel 14 35 22 26
2 FC Lugano FC Lugano 14 15 12 23
3 Basel Basel 14 27 22 22
4 Young Boys Young Boys 14 20 23 22
5 Solothurn Solothurn 14 17 15 21
6 Kriens Kriens 14 19 25 16
7 Baden Baden 14 15 23 12
8 Etoile Carouge Etoile 14 13 19 11
TEMPORADA 1996/1997
LIGA SUIZA GRUPO 1
Equipo PJ GF GC Puntos
1 Neuchâtel Xamax Neuchâtel 22 37 21 44
2 Grasshopper Grasshopper 22 42 27 39
3 Sion Sion 22 33 21 37
4 Aarau Aarau 22 21 14 35
5 Lausanne Sports Lausanne 22 35 32 34
6 St. Gallen St. Gallen 22 21 26 30
7 Zurich Zurich 22 24 25 27
8 Basel Basel 22 32 33 25
9 Servette Servette 22 24 25 24
10 Luzern Luzern 22 28 33 23
11 FC Lugano FC Lugano 22 14 32 15
12 Young Boys Young Boys 22 17 39 12
TEMPORADA 1995/1996
LIGA SUIZA GRUPO 2
Equipo PJ GF GC Puntos
1 Grasshopper Grasshopper 14 26 7 52
2 Sion Sion 14 20 14 47
3 Neuchâtel Xamax Neuchâtel 14 21 16 43
4 Aarau Aarau 14 23 18 39
5 Luzern Luzern 14 23 19 35
6 Basel Basel 14 11 20 28
7 St. Gallen St. Gallen 14 11 34 23
8 Servette Servette 14 18 25 22

  USO DE MEMORIA  
6,374,960 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1764
Total Execution Time  0.1776
  CADENA URL  
/historico/Basel/2007
  GET DATOS  
$_GET['/historico/Basel/2007']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (52)  
0.0049  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 = 2007 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.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.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 = 11006
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 = 11011
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 = 676
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10035 AND type_rel = 2
0.0024  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 10035 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023  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 (236,665,916,1062,2898) ORDER BY n.cover_points DESC, update_date DESC
0.0034  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 = 2007 ORDER BY l.year DESC,cat.coefficient DESC
0.0033  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.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 = 11011 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 = 676 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=10035 AND l.year in (2006,2007,2008) 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 (42355,40715,20662,11019,677) 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.0032  SELECT count(id) as num_players from rel_players WHERE league_id = 677 AND teamId = 10035
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 11019 AND teamId = 10035
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 40715 AND teamId = 10035
0.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 42355 AND teamId = 10035
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 20662 AND teamId = 10035
0.0021  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 = '10035' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '10035' and rp.type = 4
0.0025  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 = '10035' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '10035' and rp.type = 4
0.0048  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 events2007 e ON e.player_id = p.id AND e.league_id = 11006 WHERE rp.league_id = 11006 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.0035  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 events2007 e ON e.player_id = p.id AND e.league_id = 11006 WHERE rp.league_id = 11006 AND rp.teamId = 10035 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0036  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 events2007 e ON e.player_id = p.id AND e.league_id = 11006 WHERE rp.league_id = 11006 AND rp.teamId = 10035 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0049  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 <= 2007 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 `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.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 `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.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 `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.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 = 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.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 `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.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.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 `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.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 = 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.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 = 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.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 = 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.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 = 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.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.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 `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.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 `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 = 10084 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 `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 = 10086 AND t.round = 14 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 = 10093 AND t.round = 14 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 `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 = 10092 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 `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 = 10095 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 `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 = 10096 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC