4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Alianza Atl. Sullana

Alianza Atl. Sullana

Entrenador: Jorge Espejo

Temporada 2023/2024
TEMPORADA 2023/2024
PERÚ - LIGA 1 FASE 1
Equipo PJ GF GC Puntos
1 Sporting Cristal Sporting 12 34 12 31
2 Universitario de Deportes Universitari 12 18 4 30
3 Alianza Lima Alianza Lima 12 26 10 24
4 FBC Melgar FBC Melgar 12 20 14 23
5 Cusco FC Cusco FC 13 16 15 23
6 Cienciano Cienciano 13 17 18 20
7 ADT de Tarma Tarma 12 21 20 18
8 Comerciantes Unidos Comerciantes 12 18 20 18
9 Sport Huancayo Sport 13 16 22 17
10 UTC Cajamarca Cajamarca 13 16 17 15
11 Atlético Grau Atlético 13 14 15 14
12 Los Chankas Los Chankas 12 19 20 13
13 Alianza Atl. Sullana Alianza Atl. 12 9 12 13
14 Sport Boys Association Sport Boys. 13 11 15 12
15 Deportivo Garcilaso Deportivo 12 15 18 11
16 Univ. César Vallejo Univ. César 12 13 20 11
17 CA Manucci CA Manucci 13 10 30 11
18 Unión Comercio Unión 13 12 23 7
TEMPORADA 2022/2023
PERÚ - LIGA 1 FASE 2
Equipo PJ GF GC Puntos
1 Universitario de Deportes Universitari 18 28 8 39
2 FBC Melgar FBC Melgar 18 31 13 38
3 Alianza Lima Alianza Lima 18 18 6 37
4 Sporting Cristal Sporting 18 31 13 36
5 ADT de Tarma Tarma 18 21 13 34
6 Sport Huancayo Sport 18 22 14 29
7 Deportivo Garcilaso Deportivo 18 24 20 27
8 Univ. César Vallejo Univ. César 18 25 19 24
9 Cienciano Cienciano 18 21 20 24
10 Sport Boys Association Sport Boys. 18 15 23 23
11 CA Manucci CA Manucci 18 19 22 20
12 UTC Cajamarca Cajamarca 18 21 23 19
13 Cusco FC Cusco FC 18 18 23 18
14 Atlético Grau Atlético 17 17 27 18
15 Deportivo Binacional Deportivo 18 25 34 17
16 Unión Comercio Unión 18 18 32 17
17 Academia Cantolao Academia 18 12 26 17
18 Alianza Atl. Sullana Alianza Atl. 18 14 25 16
19 Deportivo Municipal Deportivo 17 17 36 12
TEMPORADA 2021/2022
PERÚ - LIGA 1 FASE 2
Equipo PJ GF GC Puntos
1 Alianza Lima Alianza Lima 18 31 10 42
2 Sporting Cristal Sporting 18 39 17 41
3 Atlético Grau Atlético 18 30 19 37
4 Universitario de Deportes Universitari 18 25 10 33
5 FBC Melgar FBC Melgar 18 31 18 33
6 Univ. César Vallejo Univ. César 18 25 24 33
7 UTC Cajamarca Cajamarca 18 28 24 28
8 Sport Huancayo Sport 18 26 18 27
9 Alianza Atl. Sullana Alianza Atl. 18 23 21 27
10 Deportivo Binacional Deportivo 18 28 19 26
11 Cienciano Cienciano 18 24 23 25
12 ADT de Tarma Tarma 18 25 25 24
13 Sport Boys Association Sport Boys. 18 23 31 21
14 Deportivo Municipal Deportivo 18 20 29 20
15 Academia Cantolao Academia 18 19 22 19
16 Ayacucho FC Ayacucho FC 18 16 28 14
17 CA Manucci CA Manucci 18 13 33 13
18 Carlos Stein Carlos Stein 18 18 43 6
19 Univ. San Martín Univ. 18 17 47 6
TEMPORADA 2020/2021
PERÚ - LIGA 1 FASE 1
Equipo PJ GF GC Puntos
1 Univ. San Martín Univ. 9 10 6 19
2 Ayacucho FC Ayacucho FC 9 16 10 15
3 Universitario de Deportes Universitari 9 12 11 15
4 Cienciano Cienciano 9 14 12 14
5 CA Manucci CA Manucci 9 13 14 12
6 Alianza Atl. Sullana Alianza Atl. 9 10 9 10
7 UTC Cajamarca Cajamarca 9 9 12 10
8 Academia Cantolao Academia 9 8 13 10
9 FBC Melgar FBC Melgar 9 11 12 9
10 Sporting Cristal Sporting 9 18 6 24
11 Univ. César Vallejo Univ. César 9 17 8 18
12 Alianza Lima Alianza Lima 9 12 6 16
13 Sport Huancayo Sport 9 8 9 12
14 Sport Boys Association Sport Boys. 9 12 14 10
15 Alianza Universidad Alianza 9 8 13 10
16 Cusco FC Cusco FC 9 12 13 8
17 Deportivo Municipal Deportivo 9 6 15 7
18 Deportivo Binacional Deportivo 9 8 21 4
TEMPORADA 2019/2020
PERÚ - LIGA 2
Equipo PJ GF GC Puntos
1 Union Huaral Union Huaral 9 20 14 18
2 Sport Chavelines Juniors Sport 9 14 8 17
3 Alianza Atl. Sullana Alianza Atl. 9 16 11 17
4 Juan Aurich Chiclayo Juan Aurich 9 14 12 16
5 Pirata FC Pirata FC 9 15 10 15
6 Comerciantes Unidos Comerciantes 9 14 11 12
7 Unión Comercio Unión 9 10 12 11
8 Deportivo Coopsol Deportivo 9 5 10 8
9 Santos FC Santos FC 9 13 20 6
10 Los Chankas Los Chankas 9 6 19 4
TEMPORADA 2018/2019
PERÚ - LIGA 2
Equipo PJ GF GC Puntos
1 Cienciano Cienciano 22 56 26 44
2 Alianza Atl. Sullana Alianza Atl. 22 45 21 43
3 Juan Aurich Chiclayo Juan Aurich 22 35 24 42
4 Atlético Grau Atlético 22 52 30 41
5 Santos FC Santos FC 22 29 21 41
6 Deportivo Coopsol Deportivo 22 36 27 37
7 Comerciantes Unidos Comerciantes 22 32 33 33
8 Union Huaral Union Huaral 22 30 26 32
9 Los Chankas Los Chankas 22 25 33 30
10 Sport Loreto Sport Loreto 22 28 46 15
11 Los Caimanes Caimanes 22 21 55 5
12 Sport Victoria Sport 22 9 56 0
TEMPORADA 2017/2018
PERÚ - LIGA 2
Equipo PJ GF GC Puntos
1 Univ. César Vallejo Univ. César 28 53 21 59
2 Cienciano Cienciano 28 63 30 55
3 CA Manucci CA Manucci 28 65 33 52
4 Union Huaral Union Huaral 28 58 39 48
5 Deportivo Hualgayo Deportivo 28 49 38 48
6 Juan Aurich Chiclayo Juan Aurich 28 51 27 47
7 Alianza Atl. Sullana Alianza Atl. 28 48 37 47
8 Atlético Grau Atlético 28 58 42 42
9 Deportivo Coopsol Deportivo 28 46 32 37
10 Los Chankas Los Chankas 28 38 36 37
11 Los Caimanes Caimanes 28 38 57 27
12 Alfredo Salinas Alfredo 28 30 63 27
13 Sport Victoria Sport 28 34 54 25
14 Sport Loreto Sport Loreto 28 38 68 24
15 Willy Serrato Willy 28 23 115 10
TEMPORADA 2016/2017
PERÚ - LIGA 1 FASE 2
Equipo PJ GF GC Puntos
1 Alianza Lima Alianza Lima 15 23 15 34
2 Cusco FC Cusco FC 15 29 15 32
3 FBC Melgar FBC Melgar 15 30 12 31
4 Universitario de Deportes Universitari 15 29 19 29
5 Deportivo Municipal Deportivo 15 23 20 23
6 Sport Rosario Sport 15 20 17 20
7 Sport Huancayo Sport 15 22 22 20
8 UTC Cajamarca Cajamarca 15 17 17 20
9 Sporting Cristal Sporting 15 27 24 18
10 Juan Aurich Chiclayo Juan Aurich 15 22 28 17
11 Academia Cantolao Academia 15 13 22 17
12 Comerciantes Unidos Comerciantes 15 23 25 15
13 Ayacucho FC Ayacucho FC 15 18 26 14
14 Univ. San Martín Univ. 15 20 29 14
15 Unión Comercio Unión 15 15 22 13
16 Alianza Atl. Sullana Alianza Atl. 15 13 31 13
TEMPORADA 2015/2016
PERÚ - LIGA 1 FASE 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Sporting Cristal Sporting 15 25 16 53
2 Universitario de Deportes Universitari 15 20 27 51
3 Sport Huancayo Sport 15 22 14 46
4 FBC Melgar FBC Melgar 15 24 20 46
5 Deportivo Municipal Deportivo 15 17 14 46
6 Alianza Lima Alianza Lima 15 13 11 45
7 Unión Comercio Unión 15 19 16 42
8 Comerciantes Unidos Comerciantes 15 18 15 41
9 Alianza Atl. Sullana Alianza Atl. 15 17 19 41
10 Juan Aurich Chiclayo Juan Aurich 15 19 18 40
11 UTC Cajamarca Cajamarca 15 15 15 40
12 Cusco FC Cusco FC 15 17 27 36
13 Ayacucho FC Ayacucho FC 15 14 16 33
14 Defensor La Bocana Defensor 15 14 22 32
15 Univ. San Martín Univ. 15 18 21 30
16 Univ. César Vallejo Univ. César 15 18 19 27
TEMPORADA 2014/2015
PERÚ - LIGA 1 FASE 2
Equipo PJ GF GC Puntos
1 FBC Melgar FBC Melgar 16 29 11 29
2 Cusco FC Cusco FC 16 26 16 29
3 Sport Huancayo Sport 16 28 20 28
4 Universitario de Deportes Universitari 16 26 20 28
5 Sporting Cristal Sporting 16 35 24 27
6 Univ. César Vallejo Univ. César 16 18 20 27
7 Univ. San Martín Univ. 16 17 17 24
8 UTC Cajamarca Cajamarca 16 18 15 23
9 Juan Aurich Chiclayo Juan Aurich 16 22 25 19
10 Ayacucho FC Ayacucho FC 16 22 26 19
11 Cienciano Cienciano 16 16 19 18
12 Unión Comercio Unión 16 27 32 18
13 Deportivo Municipal Deportivo 16 13 22 18
14 Alianza Lima Alianza Lima 16 18 21 17
15 Alianza Atl. Sullana Alianza Atl. 16 20 29 16
16 León de Huánuco León 16 21 31 15
17 Sport Loreto Sport Loreto 16 13 21 14
TEMPORADA 2010/2011
PERÚ - LIGA 1 FASE 1
Equipo PJ GF GC Puntos
1 Alianza Lima Alianza Lima 30 45 22 58
2 Juan Aurich Chiclayo Juan Aurich 30 46 21 56
3 Sport Huancayo Sport 30 49 33 50
4 Univ. San Martín Univ. 30 43 24 47
5 León de Huánuco León 30 37 30 46
6 Ayacucho FC Ayacucho FC 30 42 41 44
7 Unión Comercio Unión 30 46 43 43
8 Cienciano Cienciano 30 42 46 40
9 Cobresol Cobresol 30 32 36 40
10 Sport Boys Association Sport Boys. 30 27 47 37
11 Sporting Cristal Sporting 30 28 35 36
12 FBC Melgar FBC Melgar 30 37 44 34
13 Universitario de Deportes Universitari 30 25 35 34
14 Univ. César Vallejo Univ. César 30 30 42 34
15 Alianza Atl. Sullana Alianza Atl. 30 24 41 33
16 CNI CNI 30 32 45 30
TEMPORADA 2009/2010
PERÚ - LIGA 1 FASE 1
Equipo PJ GF GC Puntos
1 Univ. San Martín Univ. 30 61 30 62
2 León de Huánuco León 30 55 31 56
3 Alianza Lima Alianza Lima 30 50 31 56
4 Universitario de Deportes Universitari 30 43 22 53
5 Univ. César Vallejo Univ. César 30 48 30 53
6 Juan Aurich Chiclayo Juan Aurich 30 42 31 48
7 Sporting Cristal Sporting 30 43 42 44
8 Sport Huancayo Sport 30 44 48 38
9 Ayacucho FC Ayacucho FC 30 36 43 38
10 CNI CNI 30 39 51 37
11 FBC Melgar FBC Melgar 30 38 49 36
12 Cienciano Cienciano 30 35 50 33
13 Total Chalaco Total 30 31 43 32
14 Sport Boys Association Sport Boys. 30 34 55 30
15 José Gálvez José 30 19 39 28
16 Alianza Atl. Sullana Alianza Atl. 30 24 47 24

  USO DE MEMORIA  
6,355,808 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1812
Total Execution Time  0.1824
  CADENA URL  
/historico/Alianza-Atletico-Sullana
  GET DATOS  
$_GET['/historico/Alianza-Atletico-Sullana']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=171 AND type_rel = 2
0.0040  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 171 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0031  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 (44507,45382,46910,49858,51040) ORDER BY n.cover_points DESC, update_date DESC
0.0085  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 = '171' ORDER BY l.year DESC,cat.coefficient DESC
0.0073  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 = '171' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0032  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=171 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0021  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 (74999,70809) 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.0034  SELECT count(id) as num_players from rel_players WHERE league_id = 74999 AND teamId = 171
0.0039  SELECT count(id) as num_players from rel_players WHERE league_id = 70809 AND teamId = 171
0.0030  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 74999 AND t.round = 13 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 = '171' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '171' and rp.type = 4
0.0021  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 = '171' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0045  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 = 74999 WHERE rp.league_id = 74999 AND rp.teamId = 171 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.0050  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 = 74999 WHERE rp.league_id = 74999 AND rp.teamId = 171 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034  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 = 74999 WHERE rp.league_id = 74999 AND rp.teamId = 171 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032  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 = 171 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 70808 AND t.round = 19 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 `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 = 70809 AND t.round = 19 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 `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 = 66203 AND t.round = 19 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 `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 = 66204 AND t.round = 19 ORDER BY team.conference ASC,t.position 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 `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 = 63314 AND t.round = 17 ORDER BY team.conference ASC,t.position 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 `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 = 61643 AND t.round = 9 ORDER BY team.conference ASC,t.position 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 `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 = 59711 AND t.round = 9 ORDER BY team.conference ASC,t.position 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 `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 = 49570 AND t.round = 22 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 `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 = 43140 AND t.round = 30 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 = 37854 AND t.round = 14 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 = 37754 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 = 38471 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 `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 = 34450 AND t.round = 14 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 `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 = 20243 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 `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 = 20244 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 `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 = 10886 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 12133 AND t.round = 17 ORDER BY team.conference 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 `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 = 1298 AND t.round = 30 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 `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 = 1212 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC