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

Deportes Iquique

Entrenador: Miguel Ramírez

Temporada 2020/2021
TEMPORADA 2020/2021
PRIMERA B CHILE
Equipo PJ GF GC Puntos
1 Coquimbo Unido Coquimbo 30 42 22 55
2 Deportes Copiapó Deportes 30 49 36 52
3 Santiago Morning Santiago 30 43 26 51
4 Deportes Temuco Deportes 30 44 28 49
5 Puerto Montt Puerto Montt 30 34 30 48
6 Deportes Santa Cruz Deportes 30 36 37 45
7 Magallanes Magallanes 30 38 34 41
8 Deportes Iquique Deportes 30 52 45 40
9 Fernández Vial Fernández 30 45 39 40
10 San Luis de Quillota Luis 30 33 32 40
11 Unión San Felipe Unión 30 34 40 36
12 Rangers Talca Rangers 30 34 42 35
13 Univ. Concepción Univ. 30 32 37 33
14 Cobreloa Cobreloa 30 35 41 33
15 Barnechea Barnechea 30 28 44 24
16 San Marcos Arica Marcos Arica 30 14 60 16
TEMPORADA 2019/2020
PRIMERA CHILE
Equipo PJ GF GC Puntos
1 U. Católica Católica 34 65 35 65
2 Unión La Calera Unión 34 59 41 57
3 Univ de Chile Univ Chile 34 49 33 52
4 Unión Española Unión 34 55 53 52
5 Palestino Palestino 34 49 45 51
6 Antofagasta Antofagasta 34 43 42 48
7 Cobresal Cobresal 34 45 40 47
8 Huachipato Huachipato 34 43 44 46
9 Curicó Unido Curicó 34 40 52 46
10 O'Higgins O'Higgins 34 40 39 45
11 Santiago Wanderers Santiago 34 42 53 44
12 Everton Everton 34 37 41 43
13 Audax Italiano Audax 34 47 50 41
14 Univ. Concepción Univ. 34 38 46 41
15 La Serena La Serena 34 34 41 39
16 Colo-Colo Colo-Colo 34 33 43 39
17 Deportes Iquique Deportes 34 38 46 38
18 Coquimbo Unido Coquimbo 34 33 46 35
TEMPORADA 2018/2019
PRIMERA CHILE
Equipo PJ GF GC Puntos
1 U. Católica Católica 24 44 14 53
2 Colo-Colo Colo-Colo 24 37 30 40
3 Palestino Palestino 24 42 31 38
4 Unión La Calera Unión 24 29 23 36
5 Coquimbo Unido Coquimbo 24 29 27 34
6 Huachipato Huachipato 24 31 30 34
7 Audax Italiano Audax 24 35 35 34
8 O'Higgins O'Higgins 24 34 35 34
9 Unión Española Unión 25 32 35 34
10 Cobresal Cobresal 25 31 39 34
11 Everton Everton 24 21 24 29
12 Antofagasta Antofagasta 24 34 35 27
13 Curicó Unido Curicó 24 36 43 26
14 Univ de Chile Univ Chile 24 32 38 24
15 Deportes Iquique Deportes 24 24 40 24
16 Univ. Concepción Univ. 24 23 35 23
TEMPORADA 2017/2018
PRIMERA CHILE
Equipo PJ GF GC Puntos
1 U. Católica Católica 30 39 25 61
2 Univ. Concepción Univ. 30 45 31 58
3 Univ de Chile Univ Chile 30 45 37 57
4 Antofagasta Antofagasta 30 48 33 53
5 Colo-Colo Colo-Colo 30 40 38 43
6 Unión La Calera Unión 30 38 38 43
7 Unión Española Unión 30 44 42 41
8 O'Higgins O'Higgins 30 41 41 41
9 Huachipato Huachipato 30 39 32 39
10 Audax Italiano Audax 30 40 40 34
11 Everton Everton 30 39 44 34
12 Curicó Unido Curicó 30 35 40 34
13 Palestino Palestino 30 41 45 32
14 Deportes Iquique Deportes 30 34 42 32
15 Deportes Temuco Deportes 30 29 45 28
16 San Luis de Quillota Luis 30 24 48 23
TEMPORADA 2016/2017
TORNEO DE TRANSICIÓN CHILE
Equipo PJ GF GC Puntos
1 Colo-Colo Colo-Colo 15 33 13 33
2 Unión Española Unión 15 18 12 31
3 Univ de Chile Univ Chile 15 21 18 30
4 Everton Everton 15 24 19 26
5 Audax Italiano Audax 15 24 19 25
6 Deportes Temuco Deportes 15 15 12 22
7 Antofagasta Antofagasta 15 14 13 21
8 Curicó Unido Curicó 15 11 14 18
9 San Luis de Quillota Luis 15 15 20 18
10 Univ. Concepción Univ. 15 16 15 17
11 U. Católica Católica 15 17 19 16
12 Huachipato Huachipato 15 11 17 16
13 Santiago Wanderers Santiago 15 16 17 15
14 O'Higgins O'Higgins 15 15 24 15
15 Palestino Palestino 15 18 24 13
16 Deportes Iquique Deportes 15 8 20 9
TEMPORADA 2015/2016
PRIMERA CHILE - CLAUSURA
Equipo PJ GF GC Puntos
1 U. Católica Católica 15 33 25 29
2 Colo-Colo Colo-Colo 15 19 11 28
3 O'Higgins O'Higgins 15 28 24 28
4 Palestino Palestino 15 24 18 25
5 Univ. Concepción Univ. 15 22 24 25
6 Santiago Wanderers Santiago 15 31 26 23
7 Antofagasta Antofagasta 15 23 18 21
8 Deportes Iquique Deportes 15 23 22 19
9 Huachipato Huachipato 15 26 27 19
10 Univ de Chile Univ Chile 15 29 25 16
11 San Luis de Quillota Luis 15 22 25 16
12 Audax Italiano Audax 15 16 19 16
13 Unión Española Unión 15 20 24 15
14 Cobresal Cobresal 15 14 21 14
15 San Marcos Arica Marcos Arica 15 10 17 12
16 Unión La Calera Unión 15 16 30 11
TEMPORADA 2014/2015
PRIMERA CHILE - CLAUSURA
Equipo PJ GF GC Puntos
1 Cobresal Cobresal 17 29 20 34
2 Colo-Colo Colo-Colo 17 32 21 32
3 Huachipato Huachipato 17 29 28 31
4 U. Católica Católica 17 40 31 29
5 Unión La Calera Unión 17 33 26 27
6 Univ. Concepción Univ. 17 27 26 27
7 Univ de Chile Univ Chile 17 36 27 26
8 San Marcos Arica Marcos Arica 17 26 19 24
9 O'Higgins O'Higgins 17 21 23 24
10 Unión Española Unión 17 20 23 23
11 Cobreloa Cobreloa 17 22 23 22
12 Audax Italiano Audax 17 23 24 21
13 Deportes Iquique Deportes 17 27 30 21
14 Antofagasta Antofagasta 17 25 27 20
15 Ñublense Ñublense 17 19 21 19
16 Palestino Palestino 17 26 34 19
17 Santiago Wanderers Santiago 17 21 26 17
18 Barnechea Barnechea 17 13 40 8
TEMPORADA 2013/2014
PRIMERA CHILE - APERTURA
Equipo PJ GF GC Puntos
1 U. Católica Católica 17 37 13 39
2 O'Higgins O'Higgins 17 28 13 39
3 Unión Española Unión 17 21 15 28
4 Univ de Chile Univ Chile 17 31 16 27
5 Palestino Palestino 17 26 26 27
6 Deportes Iquique Deportes 17 22 21 26
7 Ñublense Ñublense 17 28 28 24
8 Colo-Colo Colo-Colo 17 22 23 24
9 Cobresal Cobresal 17 18 25 24
10 Cobreloa Cobreloa 17 19 18 23
11 Antofagasta Antofagasta 17 18 22 23
12 Univ. Concepción Univ. 17 21 19 22
13 Santiago Wanderers Santiago 17 20 25 21
14 Audax Italiano Audax 17 23 25 17
15 Everton Everton 17 16 29 16
16 Unión La Calera Unión 17 15 24 15
17 Rangers Talca Rangers 17 20 32 15
18 Huachipato Huachipato 17 9 20 13
TEMPORADA 2012/2013
TORNEO DE TRANSICIÓN CHILE
Equipo PJ GF GC Puntos
1 Unión Española Unión 17 32 12 38
2 U. Católica Católica 17 36 19 38
3 Cobreloa Cobreloa 17 33 18 34
4 O'Higgins O'Higgins 17 28 19 31
5 Univ de Chile Univ Chile 17 37 29 30
6 Everton Everton 17 25 24 27
7 Unión La Calera Unión 17 25 26 26
8 Rangers Talca Rangers 17 25 22 24
9 Santiago Wanderers Santiago 17 22 28 23
10 Colo-Colo Colo-Colo 17 26 27 21
11 Palestino Palestino 17 20 23 20
12 Ñublense Ñublense 17 20 26 20
13 Antofagasta Antofagasta 17 31 34 19
14 Audax Italiano Audax 17 24 29 19
15 Huachipato Huachipato 17 24 31 19
16 Deportes Iquique Deportes 17 14 25 13
17 San Marcos Arica Marcos Arica 17 19 34 12
18 Cobresal Cobresal 17 22 37 11
TEMPORADA 2011/2012
PRIMERA CHILE - CLAUSURA
Equipo PJ GF GC Puntos
1 Colo-Colo Colo-Colo 17 32 14 33
2 Univ de Chile Univ Chile 17 32 20 33
3 Rangers Talca Rangers 17 27 19 30
4 Palestino Palestino 17 22 18 30
5 Deportes Iquique Deportes 17 24 27 30
6 Huachipato Huachipato 17 23 21 25
7 Unión Española Unión 17 28 28 24
8 Audax Italiano Audax 17 29 26 23
9 U. Católica Católica 17 24 23 23
10 Cobresal Cobresal 17 22 24 22
11 Unión San Felipe Unión 17 19 21 21
12 Cobreloa Cobreloa 17 23 24 20
13 Antofagasta Antofagasta 17 26 29 20
14 O'Higgins O'Higgins 17 22 27 20
15 Santiago Wanderers Santiago 17 27 28 19
16 Unión La Calera Unión 17 11 18 15
17 Univ. Concepción Univ. 17 17 28 15
18 La Serena La Serena 17 20 33 12
TEMPORADA 2010/2011
PRIMERA CHILE - CLAUSURA
Equipo PJ GF GC Puntos
1 Univ de Chile Univ Chile 17 39 15 39
2 Cobreloa Cobreloa 17 27 17 31
3 Colo-Colo Colo-Colo 17 27 28 30
4 Audax Italiano Audax 17 29 23 29
5 U. Católica Católica 17 29 18 28
6 La Serena La Serena 17 26 23 28
7 Unión La Calera Unión 17 20 18 24
8 Unión Española Unión 17 31 23 23
9 Cobresal Cobresal 17 22 29 23
10 Santiago Wanderers Santiago 17 19 22 20
11 Deportes Iquique Deportes 17 30 41 20
12 Univ. Concepción Univ. 17 20 21 19
13 Santiago Morning Santiago 17 29 34 19
14 Palestino Palestino 17 19 24 19
15 Ñublense Ñublense 17 22 32 19
16 O'Higgins O'Higgins 17 23 26 17
17 Huachipato Huachipato 17 25 30 17
18 Unión San Felipe Unión 17 16 29 13
TEMPORADA 2009/2010
PRIMERA B CHILE - APERTURA FASE 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Deportes Iquique Deportes 14 22 9 30
2 Unión La Calera Unión 14 19 11 24
3 Curicó Unido Curicó 14 19 12 22
4 Antofagasta Antofagasta 14 17 15 21
5 Unión Temuco Unión 14 19 22 20
6 Concepción Concepción 14 14 18 15
7 Puerto Montt Puerto Montt 14 13 22 12
8 Lota Schwager Lota 14 13 27 11

  USO DE MEMORIA  
6,667,456 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.6184
Total Execution Time  0.6197
  CADENA URL  
/historico/Deportes-Iquique/2021
  GET DATOS  
$_GET['/historico/Deportes-Iquique/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0185  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-Iquique' AND l.year = 2021 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.0113  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=5586 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0112  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=5586 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0112  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=5586 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0224  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 = 61982
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5586 AND type_rel = 2
0.0107  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 5586 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0109  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 (7782,8004,30717,68291,74142) ORDER BY n.cover_points DESC, update_date DESC
0.0116  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 = '5586' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '5586' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0118  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 = 63073 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0116  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 = 61982 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0138  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=5586 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0110  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 (66979,66687,53558) 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.0119  SELECT count(id) as num_players from rel_players WHERE league_id = 53558 AND teamId = 5586
0.0111  SELECT count(id) as num_players from rel_players WHERE league_id = 66687 AND teamId = 5586
0.0140  SELECT count(id) as num_players from rel_players WHERE league_id = 66979 AND teamId = 5586
0.0121  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2021` 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 = 61982 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0175  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 events2021 e ON e.player_id = p.id AND e.league_id = 61982 WHERE rp.league_id = 61982 AND rp.teamId = 5586 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.0174  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 events2021 e ON e.player_id = p.id AND e.league_id = 61982 WHERE rp.league_id = 61982 AND rp.teamId = 5586 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0162  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 events2021 e ON e.player_id = p.id AND e.league_id = 61982 WHERE rp.league_id = 61982 AND rp.teamId = 5586 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0140  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 = 5586 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0125  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 `tables2021` 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 = 61982 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0223  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 `tables2020` 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 = 53558 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 `tables2019` 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 = 48720 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0117  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 `tables2018` 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 = 42540 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 `tables2017` 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 = 29174 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 `tables2017` 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 = 38839 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 `tables2016` 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 = 15421 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 `tables2016` 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 = 20173 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 3898 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0114  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 = 8950 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 2527 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 2528 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 9059 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 1558 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 1940 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 1295 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 1309 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 24547 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 24556 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 61982 ORDER BY nameShow LIMIT 100