4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
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
PRIMERA B CHILE
Equipo PJ GF GC Puntos
1 Unión La Calera Unión 15 25 11 34
2 Deportes Copiapó Deportes 15 24 18 26
3 Cobreloa Cobreloa 15 30 28 23
4 Coquimbo Unido Coquimbo 15 18 16 22
5 Barnechea Barnechea 15 26 25 22
6 Magallanes Magallanes 15 18 19 21
7 Puerto Montt Puerto Montt 15 18 20 21
8 Cobresal Cobresal 15 23 20 20
9 Unión San Felipe Unión 15 14 14 20
10 San Marcos Arica Marcos Arica 15 20 21 20
11 La Serena La Serena 15 20 20 19
12 Ñublense Ñublense 15 11 13 18
13 CDSC Iberia CDSC Iberia 15 25 28 18
14 Santiago Morning Santiago 15 17 23 17
15 Deportes Valdivia Deportes 15 11 17 15
16 Rangers Talca Rangers 15 14 21 13
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 1
Equipo PJ GF GC Puntos
1 Unión La Calera Unión 24 39 24 45
2 Antofagasta Antofagasta 24 37 22 45
3 Deportes Iquique Deportes 24 30 25 34
4 Curicó Unido Curicó 24 34 29 33
5 San Marcos Arica Marcos Arica 24 41 55 27
6 Coquimbo Unido Coquimbo 24 24 34 26
7 Deportes Copiapó Deportes 24 28 44 18
8 Puerto Montt Puerto Montt 24 34 22 45
9 Unión Temuco Unión 24 35 27 41
10 Concepción Concepción 24 31 24 36
11 Lota Schwager Lota 24 31 29 34
12 Naval de Talcahuano Naval 24 27 26 29
13 Rangers Talca Rangers 24 26 33 28
14 CD Provincial Osorno Provincial 24 17 40 18

  USO DE MEMORIA  
6,965,848 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1348
Total Execution Time  0.1361
  CADENA URL  
/historico/Union-Calera/2022
  GET DATOS  
$_GET['/historico/Union-Calera/2022']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0037  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-Calera' AND l.year = 2022 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.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=5587 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=5587 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=5587 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=5587 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=5587 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 = 67077
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 = 66255
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 = 66979
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5587 AND type_rel = 2
0.0031  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 5587 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 (11358,14119,24159,35797,43444) ORDER BY n.cover_points DESC, update_date DESC
0.0031  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 = '5587' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0033  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 = '5587' 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 = 66979 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 = 67077 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 = 66255 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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=5587 AND l.year in (2021,2022,2023) 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 (71182,70762,67320,67077,66233,62028) 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.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 70762 AND teamId = 5587
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 62028 AND teamId = 5587
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 67077 AND teamId = 5587
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 66233 AND teamId = 5587
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 71182 AND teamId = 5587
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 5587
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 `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 = 67077 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  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 = '5587' 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 = '5587' 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 = '5587' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0028  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 events2022 e ON e.player_id = p.id AND e.league_id = 67077 WHERE rp.league_id = 67077 AND rp.teamId = 5587 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.0027  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 events2022 e ON e.player_id = p.id AND e.league_id = 67077 WHERE rp.league_id = 67077 AND rp.teamId = 5587 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 events2022 e ON e.player_id = p.id AND e.league_id = 67077 WHERE rp.league_id = 67077 AND rp.teamId = 5587 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 = 5587 AND l.year <= 2022 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 `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.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 `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.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 `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.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 `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 = 33434 AND t.round = 15 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 `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 = 36662 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 `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 = 38842 AND t.round = 15 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 `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.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 `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.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 = 67077 ORDER BY nameShow LIMIT 100