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

Chivas Guadalajara

Entrenador: Fernando Gago

Temporada 2008/2009
TEMPORADA 2008/2009
LIGA MX - APERTURA
Equipo PJ GF GC Puntos
1 Atlante FC Atlante FC 17 22 16 27
2 Santos Laguna Santos 17 22 20 22
3 Pachuca Pachuca 17 25 25 21
4 Indios Indios 17 18 26 19
5 Monterrey Monterrey 17 18 26 19
6 Puebla Puebla 17 12 21 15
7 Pumas UNAM Pumas UNAM 17 22 13 26
8 Cruz Azul Cruz Azul 17 29 23 26
9 Tecos Tecos 17 30 28 25
10 Chivas Guadalajara Chivas 17 23 23 25
11 CA Morelia CA Morelia 17 27 20 24
12 América América 17 22 23 21
13 San Luis San Luis 17 24 20 29
14 Toluca Toluca 17 25 16 27
15 Tigres UANL Tigres UANL 17 22 16 26
16 Atlas Guadalajara Atlas 17 23 27 22
17 Chiapas Chiapas 17 20 34 18
18 Necaxa Necaxa 17 17 24 17
TEMPORADA 2007/2008
LIGA MX - APERTURA
Equipo PJ GF GC Puntos
1 Toluca Toluca 17 27 16 34
2 Pumas UNAM Pumas UNAM 17 32 19 24
3 Pachuca Pachuca 17 26 23 24
4 Chiapas Chiapas 17 22 28 18
5 Puebla Puebla 17 16 24 17
6 Tecos Tecos 17 24 38 17
7 Santos Laguna Santos 17 40 22 38
8 Atlante FC Atlante FC 17 32 19 33
9 América América 17 26 22 26
10 Veracruz Veracruz 17 20 35 18
11 Monterrey Monterrey 17 18 25 14
12 Atlas Guadalajara Atlas 17 23 33 12
13 Chivas Guadalajara Chivas 17 28 16 31
14 San Luis San Luis 17 31 30 29
15 Cruz Azul Cruz Azul 17 27 22 25
16 CA Morelia CA Morelia 17 20 25 22
17 Necaxa Necaxa 17 23 32 20
18 Tigres UANL Tigres UANL 17 16 22 16
TEMPORADA 2006/2007
LIGA MX - APERTURA
Equipo PJ GF GC Puntos
1 Cruz Azul Cruz Azul 17 27 20 30
2 Atlas Guadalajara Atlas 17 25 19 27
3 Chivas Guadalajara Chivas 17 26 18 26
4 Chiapas Chiapas 17 19 16 23
5 Querétaro Querétaro 17 20 25 18
6 Necaxa Necaxa 17 18 26 17
7 Monterrey Monterrey 17 27 21 27
8 Pachuca Pachuca 17 32 22 26
9 Veracruz Veracruz 17 26 31 26
10 Atlante FC Atlante FC 17 19 20 23
11 San Luis San Luis 17 14 12 20
12 Tecos Tecos 17 22 35 13
13 Pumas UNAM Pumas UNAM 17 21 11 29
14 América América 17 21 15 29
15 Toluca Toluca 17 27 16 27
16 CA Morelia CA Morelia 17 24 26 23
17 Tigres UANL Tigres UANL 17 14 37 14
18 Santos Laguna Santos 17 19 31 11
TEMPORADA 2005/2006
LIGA MX - CLAUSURA
Equipo PJ GF GC Puntos
1 Pachuca Pachuca 17 33 19 31
2 Chiapas Chiapas 17 28 18 30
3 Cruz Azul Cruz Azul 17 29 20 30
4 Atlante FC Atlante FC 17 19 15 27
5 San Luis San Luis 17 23 19 25
6 Toluca Toluca 17 22 19 24
7 Chivas Guadalajara Chivas 17 19 26 23
8 Dorados Dorados 17 24 24 22
9 CA Morelia CA Morelia 17 19 20 22
10 Pumas UNAM Pumas UNAM 17 15 16 22
11 Tecos Tecos 17 18 29 22
12 Tigres UANL Tigres UANL 17 15 15 21
13 América América 17 20 23 21
14 Atlas Guadalajara Atlas 17 23 23 20
15 Veracruz Veracruz 17 16 19 20
16 Monterrey Monterrey 17 17 21 18
17 Santos Laguna Santos 17 20 25 18
18 Necaxa Necaxa 17 19 28 18
TEMPORADA 2004/2005
LIGA MX - CLAUSURA
Equipo PJ GF GC Puntos
1 CA Morelia CA Morelia 17 27 16 35
2 Cruz Azul Cruz Azul 17 36 19 31
3 América América 17 38 27 30
4 Tecos Tecos 17 31 21 29
5 Necaxa Necaxa 17 28 20 28
6 Santos Laguna Santos 17 31 31 28
7 Monterrey Monterrey 17 24 25 27
8 Dorados Dorados 17 23 19 26
9 Tigres UANL Tigres UANL 17 25 19 24
10 Chivas Guadalajara Chivas 17 29 31 23
11 Toluca Toluca 17 17 22 23
12 Chiapas Chiapas 17 19 23 22
13 Atlante FC Atlante FC 17 24 21 20
14 Pachuca Pachuca 17 20 27 20
15 Puebla Puebla 17 19 29 16
16 Pumas UNAM Pumas UNAM 17 19 28 14
17 Veracruz Veracruz 17 15 33 14
18 Atlas Guadalajara Atlas 17 21 35 11
TEMPORADA 2003/2004
LIGA MX - CLAUSURA
Equipo PJ GF GC Puntos
1 Chiapas Chiapas 19 35 20 42
2 Pumas UNAM Pumas UNAM 19 42 19 41
3 Chivas Guadalajara Chivas 19 30 23 34
4 América América 19 34 27 32
5 Toluca Toluca 19 31 25 30
6 Atlante FC Atlante FC 19 29 26 27
7 Atlas Guadalajara Atlas 19 28 25 27
8 Pachuca Pachuca 19 32 33 26
9 Irapuato Irapuato 19 23 30 26
10 Querétaro Querétaro 19 24 27 24
11 Cruz Azul Cruz Azul 19 36 34 23
12 Tigres UANL Tigres UANL 19 37 39 23
13 CA Morelia CA Morelia 19 25 35 22
14 Santos Laguna Santos 19 31 30 21
15 Necaxa Necaxa 19 22 26 21
16 Puebla Puebla 19 27 29 20
17 Monterrey Monterrey 19 28 30 18
18 Tecos Tecos 19 32 40 18
19 San Luis San Luis 19 23 35 18
20 Veracruz Veracruz 19 25 41 17
TEMPORADA 2002/2003
LIGA MX - CLAUSURA
Equipo PJ GF GC Puntos
1 CA Morelia CA Morelia 19 34 20 35
2 Atlante FC Atlante FC 19 39 26 34
3 Monterrey Monterrey 19 31 22 34
4 Tigres UANL Tigres UANL 19 25 22 34
5 Toluca Toluca 19 40 30 33
6 Atlas Guadalajara Atlas 19 29 20 32
7 Tiburones Rojos de Veracruz Tiburones 19 23 18 32
8 Chivas Guadalajara Chivas 19 32 24 31
9 Santos Laguna Santos 19 30 24 30
10 América América 19 29 20 29
11 Cruz Azul Cruz Azul 19 24 24 24
12 Necaxa Necaxa 19 25 24 23
13 Cuernavaca Cuernavaca 19 24 27 23
14 Pachuca Pachuca 19 21 23 21
15 Pumas UNAM Pumas UNAM 19 25 35 20
16 San Luis San Luis 19 25 38 20
17 Chiapas Chiapas 19 15 26 19
18 Querétaro Querétaro 19 13 23 17
19 Puebla Puebla 19 15 31 16
20 Tecos Tecos 19 15 37 7
TEMPORADA 2001/2002
LIGA MX - APERTURA
Equipo PJ GF GC Puntos
1 Tigres UANL Tigres UANL 18 26 12 36
2 Toluca Toluca 18 33 22 32
3 Pachuca Pachuca 18 29 24 32
4 Cruz Azul Cruz Azul 18 33 24 30
5 Necaxa Necaxa 18 21 20 27
6 Atlante FC Atlante FC 18 24 22 26
7 Chivas Guadalajara Chivas 18 20 20 26
8 Santos Laguna Santos 18 36 34 24
9 América América 18 21 21 24
10 Puebla Puebla 18 22 22 23
11 Atlas Guadalajara Atlas 18 25 29 21
12 CA Morelia CA Morelia 18 24 30 20
13 Monterrey Monterrey 18 23 31 20
14 Irapuato Irapuato 18 27 26 19
15 Tecos Tecos 18 21 23 19
16 Celaya Celaya 18 27 33 19
17 León León 18 25 31 19
18 Reboceros de la Piedad Reboceros 18 28 40 19
19 Pumas UNAM Pumas UNAM 18 21 22 17

  USO DE MEMORIA  
6,468,968 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.2561
Total Execution Time  0.2574
  CADENA URL  
/historico/Guadalajara/2009
  GET DATOS  
$_GET['/historico/Guadalajara/2009']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (54)  
0.0055  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 = 'Guadalajara' AND l.year = 2009 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.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=1262 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=1262 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0043  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=1262 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0091  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=1262 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=1262 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0035  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 = 11303
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 = 11364
0.0032  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 = 2568
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 = 14251
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1262 AND type_rel = 2
0.0043  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1262 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 (607904,6211,2871,4661,5657) ORDER BY n.cover_points DESC, update_date DESC
0.0103  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 = '1262' ORDER BY l.year DESC,cat.coefficient DESC
0.0068  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 = '1262' AND l.year = 2009 ORDER BY l.year DESC,cat.coefficient DESC
0.0081  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 = '1262' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 11303 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 = 2568 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 = 14251 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0067  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=1262 AND l.year in (2008,2009,2010) ORDER BY l.id DESC, l.year DESC ;
0.0028  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 (71984,14283,14275,14252,12122,11364,2568) 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.0057  SELECT count(id) as num_players from rel_players WHERE league_id = 2568 AND teamId = 1262
0.0049  SELECT count(id) as num_players from rel_players WHERE league_id = 14252 AND teamId = 1262
0.0039  SELECT count(id) as num_players from rel_players WHERE league_id = 11364 AND teamId = 1262
0.0037  SELECT count(id) as num_players from rel_players WHERE league_id = 12122 AND teamId = 1262
0.0039  SELECT count(id) as num_players from rel_players WHERE league_id = 14275 AND teamId = 1262
0.0032  SELECT count(id) as num_players from rel_players WHERE league_id = 14283 AND teamId = 1262
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 71984 AND teamId = 1262
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 `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 = 11303 AND t.round = 4 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0051  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 = '1262' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0024  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1262' and rp.type = 4
0.0057  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 = '1262' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0018  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '1262' and rp.type = 4
0.0038  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 events2009 e ON e.player_id = p.id AND e.league_id = 11303 WHERE rp.league_id = 11303 AND rp.teamId = 1262 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.0033  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 events2009 e ON e.player_id = p.id AND e.league_id = 11303 WHERE rp.league_id = 11303 AND rp.teamId = 1262 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0038  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 events2009 e ON e.player_id = p.id AND e.league_id = 11303 WHERE rp.league_id = 11303 AND rp.teamId = 1262 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0099  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 = 1262 AND l.year <= 2009 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0032  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 = 2568 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 14251 AND t.round = 17 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 = 276 AND t.round = 17 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 `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 = 14252 AND t.round = 17 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 `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 = 13416 AND t.round = 17 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 = 14253 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 14254 AND t.round = 17 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 `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 = 13417 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 14255 AND t.round = 17 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 `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 = 13418 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 14256 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 13419 AND t.round = 19 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 `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 = 20820 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 = 20822 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 = 20824 AND t.round = 19 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 `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 = 30230 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 11303 ORDER BY nameShow LIMIT 100