4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2007/2008
PRIMERA CHILE - CLAUSURA
Equipo PJ GF GC Puntos
1 Concepción Concepción 0 0 0 0
2 Univ de Chile Univ Chile 18 39 21 38
3 Colo-Colo Colo-Colo 18 32 19 33
4 Unión Española Unión 18 28 32 25
5 Ñublense Ñublense 18 21 29 17
6 Rangers Talca Rangers 18 25 25 30
7 U. Católica Católica 18 37 33 29
8 Everton Everton 18 28 25 28
9 La Serena La Serena 18 37 34 27
10 CD Provincial Osorno Provincial 18 19 39 10
11 Palestino Palestino 18 29 22 33
12 O'Higgins O'Higgins 18 39 35 28
13 Santiago Morning Santiago 18 30 32 26
14 Univ. Concepción Univ. 18 32 32 21
15 CD Melipilla Melipilla 18 19 38 11
16 Huachipato Huachipato 18 33 25 27
17 Cobreloa Cobreloa 18 34 32 27
18 Audax Italiano Audax 18 25 25 24
19 Antofagasta Antofagasta 18 20 27 23
20 Cobresal Cobresal 18 24 26 21
TEMPORADA 2006/2007
PRIMERA CHILE - APERTURA
Equipo PJ GF GC Puntos
1 Colo-Colo Colo-Colo 20 47 16 47
2 U. Católica Católica 20 36 14 46
3 Audax Italiano Audax 20 39 20 44
4 Huachipato Huachipato 20 35 21 40
5 Cobreloa Cobreloa 20 44 23 35
6 Cobresal Cobresal 20 31 21 32
7 Ñublense Ñublense 20 31 31 32
8 Unión Española Unión 20 29 25 28
9 CD Melipilla Melipilla 20 35 34 28
10 O'Higgins O'Higgins 20 30 38 27
11 La Serena La Serena 20 31 30 26
12 Everton Everton 20 24 27 26
13 Univ de Chile Univ Chile 20 20 21 25
14 Palestino Palestino 20 27 30 23
15 Concepción Concepción 20 20 34 23
16 Antofagasta Antofagasta 20 24 34 22
17 Univ. Concepción Univ. 20 25 33 17
18 Santiago Wanderers Santiago 20 24 33 16
19 Puerto Montt Puerto Montt 20 19 40 14
20 Coquimbo Unido Coquimbo 20 18 40 14
21 Lota Schwager Lota 20 28 52 12
TEMPORADA 2005/2006
PRIMERA CHILE - CLAUSURA
Equipo PJ GF GC Puntos
1 Cobreloa Cobreloa 18 40 24 37
2 Colo-Colo Colo-Colo 18 37 31 29
3 Santiago Wanderers Santiago 18 22 21 28
4 Palestino Palestino 18 16 25 20
5 Cobresal Cobresal 18 20 28 18
6 O'Higgins O'Higgins 18 31 20 35
7 Coquimbo Unido Coquimbo 18 23 22 29
8 Rangers Talca Rangers 18 22 24 24
9 Huachipato Huachipato 18 29 32 20
10 Unión Española Unión 18 20 34 14
11 Puerto Montt Puerto Montt 18 26 21 33
12 Audax Italiano Audax 18 32 24 29
13 Univ. Concepción Univ. 18 34 30 25
14 La Serena La Serena 18 32 39 18
15 Santiago Morning Santiago 18 22 32 17
16 U. Católica Católica 18 24 18 31
17 Univ de Chile Univ Chile 18 24 25 23
18 Antofagasta Antofagasta 18 25 25 21
19 Everton Everton 18 23 27 21
TEMPORADA 2004/2005
PRIMERA CHILE - CLAUSURA
Equipo PJ GF GC Puntos
1 U. Católica Católica 19 33 3 49
2 Huachipato Huachipato 19 31 20 34
3 Concepción Concepción 19 27 24 31
4 Unión San Felipe Unión 19 24 33 23
5 Puerto Montt Puerto Montt 19 17 31 18
6 Univ de Chile Univ Chile 19 34 24 38
7 La Serena La Serena 19 24 24 24
8 Everton Everton 19 23 22 23
9 Santiago Wanderers Santiago 19 17 23 23
10 Deportes Temuco Deportes 19 17 39 19
11 Cobresal Cobresal 19 30 24 28
12 Cobreloa Cobreloa 19 23 21 23
13 Palestino Palestino 19 24 28 20
14 Audax Italiano Audax 19 24 32 18
15 Rangers Talca Rangers 19 24 32 18
16 Colo-Colo Colo-Colo 19 47 17 44
17 Univ. Concepción Univ. 19 27 28 27
18 Unión Española Unión 19 30 33 25
19 CD Melipilla Melipilla 19 17 23 20
20 Coquimbo Unido Coquimbo 19 18 30 15
TEMPORADA 2003/2004
PRIMERA CHILE - CLAUSURA
Equipo PJ GF GC Puntos
1 Audax Italiano Audax 17 33 24 26
2 Cobreloa Cobreloa 17 37 26 25
3 Unión Española Unión 17 24 20 23
4 La Serena La Serena 17 23 38 16
5 Coquimbo Unido Coquimbo 17 21 26 18
6 Unión San Felipe Unión 17 18 25 18
7 Puerto Montt Puerto Montt 17 16 20 17
8 Santiago Wanderers Santiago 17 24 36 14
9 Colo-Colo Colo-Colo 17 29 19 32
10 Univ de Chile Univ Chile 17 27 14 30
11 Deportes Temuco Deportes 17 34 36 21
12 Palestino Palestino 16 23 25 21
13 Rangers Talca Rangers 17 19 33 15
14 U. Católica Católica 16 29 19 29
15 Cobresal Cobresal 17 32 26 28
16 Univ. Concepción Univ. 17 22 16 28
17 Everton Everton 17 20 26 22
18 Huachipato Huachipato 17 24 26 20
TEMPORADA 2002/2003
PRIMERA CHILE - CLAUSURA
Equipo PJ GF GC Puntos
1 Colo-Colo Colo-Colo 15 39 19 32
2 Univ. Concepción Univ. 15 35 15 32
3 Unión Española Unión 15 36 22 31
4 Santiago Wanderers Santiago 15 27 22 27
5 Palestino Palestino 15 35 28 26
6 Cobreloa Cobreloa 15 30 22 24
7 Univ de Chile Univ Chile 15 28 21 23
8 Cobresal Cobresal 15 27 26 21
9 U. Católica Católica 15 22 24 20
10 Huachipato Huachipato 15 30 33 20
11 Rangers Talca Rangers 15 19 35 19
12 Audax Italiano Audax 15 15 22 17
13 Puerto Montt Puerto Montt 15 23 34 15
14 Deportes Temuco Deportes 15 17 38 10
15 Unión San Felipe Unión 15 22 32 9
16 Coquimbo Unido Coquimbo 15 15 27 9
TEMPORADA 2001/2002
PRIMERA CHILE - CLAUSURA
Equipo PJ GF GC Puntos
1 Cobreloa Cobreloa 15 33 10 34
2 Univ de Chile Univ Chile 15 24 12 30
3 Cobresal Cobresal 15 22 19 27
4 U. Católica Católica 15 28 19 26
5 Santiago Wanderers Santiago 15 23 20 25
6 Unión Española Unión 15 24 17 24
7 Colo-Colo Colo-Colo 15 21 15 23
8 Unión San Felipe Unión 15 21 20 21
9 Huachipato Huachipato 15 22 18 20
10 Audax Italiano Audax 15 19 22 18
11 Coquimbo Unido Coquimbo 15 10 12 17
12 Concepción Concepción 15 20 26 14
13 Palestino Palestino 15 14 23 12
14 Rangers Talca Rangers 15 13 28 11
15 Santiago Morning Santiago 15 11 26 10
16 Deportes Temuco Deportes 15 14 32 8
TEMPORADA 2000/2001
PRIMERA CHILE
Equipo PJ GF GC Puntos
1 Santiago Wanderers Santiago 30 66 33 66
2 U. Católica Católica 30 60 29 60
3 Univ de Chile Univ Chile 30 56 34 57
4 Colo-Colo Colo-Colo 30 63 37 56
5 Cobreloa Cobreloa 30 39 28 48
6 Palestino Palestino 30 44 43 48
7 Huachipato Huachipato 30 57 41 46
8 Unión San Felipe Unión 30 46 39 40
9 Unión Española Unión 30 46 64 37
10 Coquimbo Unido Coquimbo 30 29 39 35
11 Audax Italiano Audax 30 27 40 32
12 Concepción Concepción 30 34 50 32
13 Rangers Talca Rangers 30 38 46 30
14 Santiago Morning Santiago 30 47 67 28
15 O'Higgins O'Higgins 30 40 68 25
16 Puerto Montt Puerto Montt 30 31 65 21
TEMPORADA 1999/2000
PRIMERA CHILE
Equipo PJ GF GC Puntos
1 Univ de Chile Univ Chile 30 62 27 61
2 Cobreloa Cobreloa 30 53 36 52
3 Colo-Colo Colo-Colo 30 58 46 49
4 Unión Española Unión 30 43 38 48
5 U. Católica Católica 30 51 42 44
6 Concepción Concepción 30 28 30 43
7 Santiago Wanderers Santiago 30 47 46 41
8 Audax Italiano Audax 30 38 34 40
9 Palestino Palestino 30 45 44 40
10 Santiago Morning Santiago 30 47 54 38
11 Coquimbo Unido Coquimbo 30 36 47 37
12 O'Higgins O'Higgins 30 43 52 36
13 Huachipato Huachipato 30 44 48 34
14 Puerto Montt Puerto Montt 30 42 54 34
15 Everton Everton 30 41 53 33
16 CD Provincial Osorno Provincial 30 37 64 23

  USO DE MEMORIA  
6,778,056 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1864
Total Execution Time  0.1876
  CADENA URL  
/historico/Colo-Colo/2008
  GET DATOS  
$_GET['/historico/Colo-Colo/2008']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (59)  
0.0051  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 = 'Colo-Colo' 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=9952 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=9952 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=9952 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=9952 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=9952 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=9952 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=9952 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 = 11333
0.0023  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 = 252
0.0023  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 = 253
0.0023  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 = 13551
0.0023  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 = 13552
0.0023  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 = 43429
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9952 AND type_rel = 2
0.0031  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 9952 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  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 (1878,1881,3293,4375,4674) 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 = '9952' AND l.year = 2008 ORDER BY l.year DESC,cat.coefficient DESC
0.0041  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 = '9952' 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 = 43429 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 11333 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 = 13552 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 = 252 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 = 253 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 = 13551 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0033  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=9952 AND l.year in (2007,2008,2009) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (43429,13559,13552,13440,12123,11362,9020) 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.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 9020 AND teamId = 9952
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 13440 AND teamId = 9952
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 11362 AND teamId = 9952
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 12123 AND teamId = 9952
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 13559 AND teamId = 9952
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 13552 AND teamId = 9952
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 43429 AND teamId = 9952
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 `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 = 11333 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '9952' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '9952' and rp.type = 4
0.0020  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 = '9952' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0032  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 = 11333 WHERE rp.league_id = 11333 AND rp.teamId = 9952 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 = 11333 WHERE rp.league_id = 11333 AND rp.teamId = 9952 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 11333 WHERE rp.league_id = 11333 AND rp.teamId = 9952 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0043  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 = 9952 AND l.year <= 2008 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 252 AND t.round = 19 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 = 253 AND t.round = 19 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 = 13440 AND t.round = 21 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 `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 = 9020 AND t.round = 21 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 `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 = 9021 AND t.round = 18 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 = 13441 AND t.round = 19 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 = 9022 AND t.round = 19 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 `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 = 13442 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0055  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 = 9023 AND t.round = 17 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 = 13443 AND t.round = 17 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 `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 = 9024 AND t.round = 15 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 `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 = 13444 AND t.round = 15 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 = 9025 AND t.round = 15 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 `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 = 13445 AND t.round = 15 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 `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 = 13446 AND t.round = 30 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 `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 = 13447 AND t.round = 30 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 = 11333 ORDER BY nameShow LIMIT 100