4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
PRIMERA CHILE
Equipo PJ GF GC Puntos
1 Univ de Chile Univ Chile 9 15 7 21
2 Palestino Palestino 9 14 4 18
3 Unión Española Unión 10 22 17 17
4 Deportes Iquique Deportes 9 18 14 16
5 Coquimbo Unido Coquimbo 9 11 8 15
6 Everton Everton 9 15 15 14
7 O'Higgins O'Higgins 10 11 13 14
8 Colo-Colo Colo-Colo 9 10 8 13
9 Cobreloa Cobreloa 9 10 15 13
10 U. Católica Católica 9 9 8 12
11 Huachipato Huachipato 9 7 9 12
12 Ñublense Ñublense 9 13 14 11
13 Audax Italiano Audax 9 9 13 8
14 Cobresal Cobresal 9 11 15 6
15 Unión La Calera Unión 9 6 13 6
16 Deportes Copiapó Deportes 9 12 20 6
TEMPORADA 2022/2023
PRIMERA CHILE
Equipo PJ GF GC Puntos
1 Huachipato Huachipato 30 48 30 57
2 Cobresal Cobresal 30 56 39 56
3 Colo-Colo Colo-Colo 30 45 29 54
4 Palestino Palestino 30 46 40 49
5 Coquimbo Unido Coquimbo 30 43 42 47
6 Everton Everton 30 42 39 45
7 U. Católica Católica 30 48 43 42
8 Unión La Calera Unión 30 42 41 41
9 Univ de Chile Univ Chile 30 40 42 40
10 Unión Española Unión 30 40 36 39
11 O'Higgins O'Higgins 30 37 39 35
12 Ñublense Ñublense 30 33 39 35
13 Audax Italiano Audax 30 36 43 35
14 Deportes Copiapó Deportes 30 32 45 34
15 Magallanes Magallanes 30 36 49 29
16 Curicó Unido Curicó 30 30 58 23
TEMPORADA 2021/2022
PRIMERA CHILE
Equipo PJ GF GC Puntos
1 Colo-Colo Colo-Colo 30 54 17 63
2 Ñublense Ñublense 30 46 32 52
3 Curicó Unido Curicó 30 48 30 49
4 Cobresal Cobresal 30 44 39 45
5 U. Católica Católica 30 41 38 45
6 Audax Italiano Audax 30 44 42 45
7 O'Higgins O'Higgins 30 31 31 44
8 Palestino Palestino 29 42 35 43
9 Everton Everton 30 40 27 42
10 Unión La Calera Unión 30 36 40 39
11 Unión Española Unión 30 37 44 37
12 Huachipato Huachipato 30 32 46 35
13 Univ de Chile Univ Chile 30 35 50 30
14 Coquimbo Unido Coquimbo 30 32 52 27
15 La Serena La Serena 30 28 56 27
16 Antofagasta Antofagasta 29 23 34 26
TEMPORADA 2020/2021
PRIMERA CHILE
Equipo PJ GF GC Puntos
1 U. Católica Católica 32 65 34 68
2 Colo-Colo Colo-Colo 32 49 26 62
3 Audax Italiano Audax 32 39 31 54
4 Unión La Calera Unión 32 41 40 51
5 Unión Española Unión 32 48 50 48
6 Antofagasta Antofagasta 32 34 36 47
7 Ñublense Ñublense 32 49 37 44
8 Palestino Palestino 32 48 50 41
9 Cobresal Cobresal 32 40 39 40
10 La Serena La Serena 32 40 42 39
11 Univ de Chile Univ Chile 32 34 37 39
12 Everton Everton 32 29 35 39
13 O'Higgins O'Higgins 32 31 41 38
14 Curicó Unido Curicó 32 37 39 37
15 Huachipato Huachipato 32 36 41 37
16 CD Melipilla Melipilla 32 39 51 32
17 Santiago Wanderers Santiago 32 24 54 21
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 - CLAUSURA
Equipo PJ GF GC Puntos
1 Colo-Colo Colo-Colo 17 45 20 42
2 U. Católica Católica 17 32 19 33
3 O'Higgins O'Higgins 17 20 12 30
4 Univ. Concepción Univ. 17 20 17 27
5 Palestino Palestino 17 25 20 26
6 Huachipato Huachipato 17 31 28 25
7 Deportes Iquique Deportes 17 23 23 25
8 Cobreloa Cobreloa 17 21 22 22
9 Unión Española Unión 17 25 34 22
10 Cobresal Cobresal 17 23 25 21
11 Antofagasta Antofagasta 17 19 23 21
12 Univ de Chile Univ Chile 17 27 27 20
13 Unión La Calera Unión 17 21 28 20
14 Audax Italiano Audax 17 22 22 19
15 Santiago Wanderers Santiago 17 22 24 19
16 Everton Everton 17 16 27 19
17 Ñublense Ñublense 17 20 30 17
18 Rangers Talca Rangers 17 15 26 16
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 - APERTURA
Equipo PJ GF GC Puntos
1 U. Católica Católica 17 34 18 38
2 Univ de Chile Univ Chile 17 39 20 35
3 Unión Española Unión 17 33 18 32
4 Palestino Palestino 17 26 20 30
5 O'Higgins O'Higgins 17 29 26 27
6 Colo-Colo Colo-Colo 17 30 25 25
7 Unión La Calera Unión 17 18 18 25
8 Unión San Felipe Unión 17 24 21 24
9 Huachipato Huachipato 17 24 27 22
10 La Serena La Serena 17 28 28 21
11 Audax Italiano Audax 17 24 28 21
12 Deportes Iquique Deportes 17 18 22 21
13 Univ. Concepción Univ. 17 24 26 20
14 Santiago Wanderers Santiago 17 23 31 19
15 Cobreloa Cobreloa 17 16 22 18
16 Santiago Morning Santiago 17 22 30 16
17 Ñublense Ñublense 17 17 31 14
18 Cobresal Cobresal 17 25 43 14

  USO DE MEMORIA  
6,888,328 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.3426
Total Execution Time  0.3449
  CADENA URL  
/historico/Union-Espanola
  GET DATOS  
$_GET['/historico/Union-Espanola']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0114  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 = 'Union-Espanola' AND l.year = 2024 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=2591 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  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=2591 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=2591 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0166  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 = '2591' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0202  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 = '2591' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0163  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=2591 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0025  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 (75067,71432,71182) 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.0110  SELECT count(id) as num_players from rel_players WHERE league_id = 75067 AND teamId = 2591
0.0094  SELECT count(id) as num_players from rel_players WHERE league_id = 71182 AND teamId = 2591
0.0065  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 2591
0.0132  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 events2024 e ON e.player_id = p.id AND e.league_id = 75067 WHERE rp.league_id = 75067 AND rp.teamId = 2591 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.0158  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 events2024 e ON e.player_id = p.id AND e.league_id = 75067 WHERE rp.league_id = 75067 AND rp.teamId = 2591 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0099  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 events2024 e ON e.player_id = p.id AND e.league_id = 75067 WHERE rp.league_id = 75067 AND rp.teamId = 2591 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0205  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 = 2591 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0036  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 `tables2024` 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 = 75067 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036  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 `tables2023` 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 = 70762 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.0040  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 `tables2022` 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 = 66255 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.0044  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 = 61822 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.0039  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.0044  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.0051  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.0077  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.0045  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 = 36658 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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.0053  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.0052  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.0066  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.0051  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.0037  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.0062  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.0049  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.0049  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.0047  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.0051  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