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

Deportes Tolima

Entrenador: David González

Temporada 2014/2015
TEMPORADA 2014/2015
APERTURA COLOMBIA
Equipo PJ GF GC Puntos
1 Atlético Huila Atlético 20 33 22 41
2 Envigado Envigado 20 21 13 36
3 Deportivo Cali Deportivo 20 36 24 35
4 Independiente Medellín Independient 20 31 22 35
5 Millonarios Millonarios 20 36 23 34
6 At. Nacional Nacional 20 33 24 34
7 Deportes Tolima Deportes 20 29 16 33
8 Junior Junior 20 27 16 33
9 Santa Fe Santa Fe 20 29 19 31
10 Águilas Doradas Águilas 20 23 16 30
11 Patriotas Boyacá Patriotas 20 17 18 27
12 La Equidad La Equidad 20 21 21 26
13 Once Caldas Once Caldas 20 29 32 23
14 Internacional de Palmira Internaciona 20 22 25 21
15 Jaguares FC Jaguares FC 20 21 32 21
16 Alianza FC Alianza FC 20 17 22 20
17 Boyacá Chicó Boyacá 20 16 29 17
18 Cúcuta Deportivo Cúcuta 20 16 33 15
19 Uniautónoma Uniautónoma 20 13 30 15
20 Deportivo Pasto Deportivo 20 11 44 9
TEMPORADA 2013/2014
CLAUSURA COLOMBIA
Equipo PJ GF GC Puntos
1 Santa Fe Santa Fe 18 24 13 31
2 Independiente Medellín Independient 18 29 21 30
3 At. Nacional Nacional 18 26 12 29
4 Águilas Doradas Águilas 18 23 21 29
5 Once Caldas Once Caldas 18 24 17 28
6 Deportivo Cali Deportivo 18 25 25 28
7 Deportes Tolima Deportes 18 23 25 28
8 Atlético Huila Atlético 18 25 18 27
9 Alianza FC Alianza FC 18 17 16 27
10 Patriotas Boyacá Patriotas 18 19 24 26
11 Boyacá Chicó Boyacá 18 23 22 22
12 Junior Junior 18 19 20 22
13 Fortaleza Fortaleza 18 17 21 21
14 Envigado Envigado 18 18 20 20
15 Millonarios Millonarios 18 22 28 20
16 Deportivo Pasto Deportivo 18 15 23 18
17 Uniautónoma Uniautónoma 18 15 23 18
18 La Equidad La Equidad 18 16 31 14
TEMPORADA 2012/2013
CLAUSURA COLOMBIA
Equipo PJ GF GC Puntos
1 At. Nacional Nacional 18 29 12 37
2 Millonarios Millonarios 18 28 18 31
3 Junior Junior 18 29 24 30
4 Deportivo Cali Deportivo 18 22 13 28
5 Once Caldas Once Caldas 18 24 17 28
6 Santa Fe Santa Fe 18 24 17 28
7 Deportivo Pasto Deportivo 18 21 20 27
8 Águilas Doradas Águilas 18 20 20 27
9 Independiente Medellín Independient 18 24 19 24
10 La Equidad La Equidad 18 24 21 23
11 Patriotas Boyacá Patriotas 18 17 17 23
12 Envigado Envigado 18 17 22 22
13 Deportes Tolima Deportes 18 19 23 21
14 Atlético Huila Atlético 18 24 30 20
15 Alianza FC Alianza FC 18 14 24 18
16 Cúcuta Deportivo Cúcuta 18 19 27 16
17 Boyacá Chicó Boyacá 18 21 29 15
18 Deportes Quindío Deportes 18 10 33 14
TEMPORADA 2011/2012
CLAUSURA COLOMBIA
Equipo PJ GF GC Puntos
1 Millonarios Millonarios 18 25 9 37
2 La Equidad La Equidad 18 26 17 33
3 Junior Junior 18 27 14 32
4 Águilas Doradas Águilas 18 23 12 32
5 At. Nacional Nacional 18 25 14 30
6 Deportes Tolima Deportes 18 27 19 29
7 Independiente Medellín Independient 18 23 18 26
8 Deportivo Pasto Deportivo 18 22 20 25
9 Cúcuta Deportivo Cúcuta 18 22 22 24
10 Santa Fe Santa Fe 18 18 22 23
11 Deportivo Cali Deportivo 18 21 22 22
12 Boyacá Chicó Boyacá 18 19 22 22
13 Deportes Quindío Deportes 18 20 25 22
14 Envigado Envigado 18 15 18 21
15 Once Caldas Once Caldas 18 19 27 19
16 Patriotas Boyacá Patriotas 18 17 28 17
17 Atlético Huila Atlético 18 12 31 12
18 Real Cartagena Real 18 13 34 12
TEMPORADA 2010/2011
CLAUSURA COLOMBIA
Equipo PJ GF GC Puntos
1 Junior Junior 18 28 22 31
2 Once Caldas Once Caldas 18 34 23 29
3 Millonarios Millonarios 18 21 17 28
4 Santa Fe Santa Fe 18 22 19 28
5 Envigado Envigado 18 20 18 28
6 Boyacá Chicó Boyacá 18 19 16 27
7 Águilas Doradas Águilas 18 21 19 27
8 Independiente Medellín Independient 18 27 25 25
9 América de Cali América 18 22 24 25
10 Deportivo Pereira Deportivo 18 23 16 24
11 Deportivo Cali Deportivo 18 15 20 23
12 At. Nacional Nacional 18 24 23 22
13 Atlético Huila Atlético 18 20 22 22
14 Deportes Quindío Deportes 18 23 26 22
15 Deportes Tolima Deportes 18 21 25 22
16 Real Cartagena Real 18 21 25 19
17 La Equidad La Equidad 18 12 22 16
18 Cúcuta Deportivo Cúcuta 18 17 28 15
TEMPORADA 2009/2010
CLAUSURA COLOMBIA
Equipo PJ GF GC Puntos
1 Deportes Tolima Deportes 18 35 15 36
2 Once Caldas Once Caldas 18 34 26 36
3 Santa Fe Santa Fe 18 26 13 35
4 At. Nacional Nacional 18 25 23 33
5 Deportes Quindío Deportes 18 25 20 31
6 Atlético Huila Atlético 18 28 24 30
7 Cúcuta Deportivo Cúcuta 18 24 18 28
8 La Equidad La Equidad 18 23 23 28
9 Deportivo Cali Deportivo 18 31 23 26
10 América de Cali América 18 25 23 25
11 Independiente Medellín Independient 18 22 22 24
12 Millonarios Millonarios 18 25 25 22
13 Boyacá Chicó Boyacá 18 16 26 21
14 Junior Junior 18 21 28 16
15 Real Cartagena Real 18 17 29 15
16 Internacional de Palmira Internaciona 18 14 30 13
17 Deportivo Pereira Deportivo 18 12 22 9
18 Envigado Envigado 18 19 32 9
TEMPORADA 2008/2009
APERTURA COLOMBIA
Equipo PJ GF GC Puntos
1 La Equidad La Equidad 18 23 17 32
2 Deportes Tolima Deportes 18 21 16 32
3 Junior Junior 18 30 18 31
4 Cúcuta Deportivo Cúcuta 18 16 14 31
5 Boyacá Chicó Boyacá 18 24 22 30
6 Envigado Envigado 18 22 24 29
7 Once Caldas Once Caldas 18 23 14 28
8 Deportivo Cali Deportivo 18 22 20 26
9 Deportes Quindío Deportes 18 23 23 25
10 Real Cartagena Real 18 23 24 25
11 América de Cali América 18 24 21 24
12 Deportivo Pereira Deportivo 18 26 25 24
13 Atlético Huila Atlético 18 21 26 24
14 Santa Fe Santa Fe 18 20 25 21
15 Millonarios Millonarios 18 16 20 17
16 Deportivo Pasto Deportivo 18 12 17 17
17 At. Nacional Nacional 18 16 25 16
18 Independiente Medellín Independient 18 18 29 11
TEMPORADA 2007/2008
CLAUSURA COLOMBIA
Equipo PJ GF GC Puntos
1 Deportes Tolima Deportes 18 22 16 33
2 Junior Junior 18 27 19 31
3 At. Nacional Nacional 18 20 19 30
4 América de Cali América 18 25 17 29
5 Independiente Medellín Independient 18 24 19 29
6 Deportivo Pereira Deportivo 18 23 20 29
7 La Equidad La Equidad 18 18 16 29
8 Deportivo Cali Deportivo 18 30 21 28
9 Millonarios Millonarios 18 26 18 28
10 Once Caldas Once Caldas 18 20 20 27
11 Santa Fe Santa Fe 18 18 15 26
12 Envigado Envigado 18 19 19 21
13 Deportes Quindío Deportes 18 16 22 21
14 Boyacá Chicó Boyacá 18 17 24 20
15 Atlético Bucaramanga Atlético 18 13 23 20
16 Deportivo Pasto Deportivo 18 9 17 16
17 Atlético Huila Atlético 18 17 26 15
18 Cúcuta Deportivo Cúcuta 18 9 22 15
TEMPORADA 2006/2007
APERTURA COLOMBIA
Equipo PJ GF GC Puntos
1 Deportivo Cali Deportivo 17 30 17 33
2 Cúcuta Deportivo Cúcuta 17 28 16 33
3 Millonarios Millonarios 18 26 17 30
4 Boyacá Chicó Boyacá 18 20 16 30
5 At. Nacional Nacional 17 30 20 29
6 Santa Fe Santa Fe 18 23 21 29
7 Independiente Medellín Independient 17 30 28 28
8 Atlético Huila Atlético 18 24 23 28
9 Atlético Bucaramanga Atlético 18 23 21 27
10 Deportivo Pasto Deportivo 18 19 21 23
11 Junior Junior 18 22 26 23
12 Deportes Tolima Deportes 18 26 28 20
13 América de Cali América 18 24 35 19
14 Once Caldas Once Caldas 18 18 25 18
15 Deportes Quindío Deportes 18 14 22 18
16 Deportivo Pereira Deportivo 17 14 19 15
17 Real Cartagena Real 17 13 22 14
18 La Equidad La Equidad 18 21 28 13
TEMPORADA 2005/2006
CLAUSURA COLOMBIA
Equipo PJ GF GC Puntos
1 Deportes Tolima Deportes 17 29 17 33
2 Independiente Medellín Independient 18 29 22 32
3 Boyacá Chicó Boyacá 18 22 15 32
4 Atlético Huila Atlético 18 25 17 31
5 At. Nacional Nacional 18 20 15 31
6 Cúcuta Deportivo Cúcuta 18 22 18 31
7 Deportivo Pasto Deportivo 18 23 15 30
8 Millonarios Millonarios 18 23 19 27
9 Deportes Quindío Deportes 18 24 25 27
10 Deportivo Cali Deportivo 18 23 21 25
11 Real Cartagena Real 18 17 17 25
12 Santa Fe Santa Fe 18 34 30 24
13 Deportivo Pereira Deportivo 17 20 21 21
14 Junior Junior 18 19 29 20
15 Once Caldas Once Caldas 18 23 31 19
16 Atlético Bucaramanga Atlético 17 19 29 15
17 América de Cali América 17 18 31 12
18 Envigado Envigado 18 14 32 12

  USO DE MEMORIA  
6,990,928 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1910
Total Execution Time  0.1924
  CADENA URL  
/historico/Deportes-Tolima/2015
  GET DATOS  
$_GET['/historico/Deportes-Tolima/2015']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (60)  
0.0043  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 = 'Deportes-Tolima' AND l.year = 2015 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=900 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=900 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=900 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=900 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=900 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=900 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=900 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=900 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 16582
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 = 9440
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 = 15429
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 = 14193
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 = 19801
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 = 9752
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 = 16248
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=900 AND type_rel = 2
0.0029  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 900 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 (1273,2285,2753,3016,4686) ORDER BY n.cover_points DESC, update_date DESC
0.0038  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 = '900' AND l.year = 2015 ORDER BY l.year DESC,cat.coefficient DESC
0.0036  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 = '900' 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 = 9752 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 = 16582 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 = 19801 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 = 9440 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 = 15429 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 = 14193 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0030  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=900 AND l.year in (2014,2015,2016) 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 (42739,37349,33863,33328,20228,14193) 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.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 20228 AND teamId = 900
0.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 33328 AND teamId = 900
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 33863 AND teamId = 900
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 14193 AND teamId = 900
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 37349 AND teamId = 900
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 42739 AND teamId = 900
0.0020  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2015` 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 = 16582 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0040  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 events2015 e ON e.player_id = p.id AND e.league_id = 16582 WHERE rp.league_id = 16582 AND rp.teamId = 900 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.0042  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 events2015 e ON e.player_id = p.id AND e.league_id = 16582 WHERE rp.league_id = 16582 AND rp.teamId = 900 AND (e.action = 4 or e.action = 5) 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 events2015 e ON e.player_id = p.id AND e.league_id = 16582 WHERE rp.league_id = 16582 AND rp.teamId = 900 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0038  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 = 900 AND l.year <= 2015 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2015` 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 = 15429 AND t.round = 20 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 `tables2015` 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 = 9440 AND t.round = 20 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 `tables2014` 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 = 3373 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 `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 = 2414 AND t.round = 18 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 `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 = 2529 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 `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 = 1563 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 `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 = 1542 AND t.round = 18 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 `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 = 1296 AND t.round = 18 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 `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 = 1390 AND t.round = 18 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 `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 = 1009 AND t.round = 18 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 = 1095 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 `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 = 1008 AND t.round = 18 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 `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 = 1007 AND t.round = 18 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 = 254 AND t.round = 18 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 = 255 AND t.round = 18 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 `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 = 13000 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 `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 = 12998 AND t.round = 18 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 = 12993 AND t.round = 18 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 = 12996 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 16582 ORDER BY nameShow LIMIT 100