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

Deportivo Pasto

Entrenador: Gustavo Florentín

Temporada 2023/2024
TEMPORADA 2023/2024
APERTURA COLOMBIA
Equipo PJ GF GC Puntos
1 Deportes Tolima Deportes 19 31 18 38
2 Atlético Bucaramanga Atlético 18 23 10 35
3 Santa Fe Santa Fe 18 22 11 34
4 La Equidad La Equidad 18 22 12 33
5 Deportivo Pereira Deportivo 18 25 18 31
6 Millonarios Millonarios 18 25 20 28
7 Junior Junior 18 24 21 28
8 Once Caldas Once Caldas 18 16 16 28
9 Independiente Medellín Independient 18 21 31 26
10 América de Cali América 18 22 16 24
11 At. Nacional Nacional 19 21 20 24
12 Águilas Doradas Águilas 18 19 18 24
13 Fortaleza Fortaleza 18 17 19 23
14 Deportivo Cali Deportivo 18 24 24 20
15 Jaguares FC Jaguares FC 18 16 20 19
16 Boyacá Chicó Boyacá 18 22 32 18
17 Envigado Envigado 18 15 24 16
18 Deportivo Pasto Deportivo 18 12 21 16
19 Alianza FC Alianza FC 18 15 28 16
20 Patriotas Boyacá Patriotas 18 8 21 15
TEMPORADA 2022/2023
APERTURA COLOMBIA
Equipo PJ GF GC Puntos
1 Águilas Doradas Águilas 20 32 21 39
2 Millonarios Millonarios 20 30 18 38
3 At. Nacional Nacional 20 26 14 35
4 América de Cali América 20 32 23 32
5 Boyacá Chicó Boyacá 20 24 18 30
6 Alianza FC Alianza FC 20 27 22 30
7 Independiente Medellín Independient 20 29 24 29
8 Deportivo Pasto Deportivo 20 22 21 29
9 Junior Junior 20 17 17 28
10 Santa Fe Santa Fe 20 29 25 26
11 La Equidad La Equidad 20 20 17 26
12 Deportivo Pereira Deportivo 20 24 25 25
13 Deportes Tolima Deportes 20 23 26 24
14 Deportivo Cali Deportivo 20 20 26 23
15 Atlético Bucaramanga Atlético 20 15 21 20
16 Envigado Envigado 20 14 20 20
17 Once Caldas Once Caldas 20 17 24 20
18 Jaguares FC Jaguares FC 20 16 26 19
19 Unión Magdalena Unión 20 16 30 19
20 Atlético Huila Atlético 20 20 35 18
TEMPORADA 2021/2022
CLAUSURA COLOMBIA
Equipo PJ GF GC Puntos
1 Santa Fe Santa Fe 20 25 26 34
2 Águilas Doradas Águilas 20 23 15 33
3 Independiente Medellín Independient 20 30 25 33
4 Millonarios Millonarios 20 29 19 32
5 Deportivo Pereira Deportivo 20 26 21 32
6 Deportivo Pasto Deportivo 20 24 23 32
7 América de Cali América 20 21 11 31
8 Junior Junior 20 24 19 31
9 At. Nacional Nacional 20 31 25 30
10 Once Caldas Once Caldas 20 21 18 30
11 Atlético Bucaramanga Atlético 20 26 25 30
12 Unión Magdalena Unión 20 23 28 29
13 La Equidad La Equidad 20 28 27 28
14 Deportes Tolima Deportes 20 23 22 26
15 Envigado Envigado 20 22 22 26
16 Jaguares FC Jaguares FC 20 14 20 20
17 Alianza FC Alianza FC 20 24 32 17
18 Deportivo Cali Deportivo 20 22 35 16
19 Patriotas Boyacá Patriotas 20 21 28 15
20 Internacional de Palmira Internaciona 20 12 28 11
TEMPORADA 2020/2021
CLAUSURA COLOMBIA
Equipo PJ GF GC Puntos
1 At. Nacional Nacional 20 32 13 42
2 Millonarios Millonarios 20 36 23 36
3 Deportes Tolima Deportes 20 25 13 36
4 Junior Junior 20 25 21 33
5 Deportivo Pereira Deportivo 20 24 21 33
6 Alianza FC Alianza FC 20 27 18 31
7 Deportivo Cali Deportivo 20 27 21 31
8 América de Cali América 20 25 19 29
9 Envigado Envigado 20 24 23 27
10 Atlético Bucaramanga Atlético 20 26 29 27
11 Jaguares FC Jaguares FC 20 23 26 27
12 Independiente Medellín Independient 20 14 15 26
13 Águilas Doradas Águilas 20 24 25 25
14 Santa Fe Santa Fe 20 21 22 25
15 La Equidad La Equidad 20 20 21 25
16 Deportes Quindío Deportes 20 18 24 22
17 Once Caldas Once Caldas 20 18 30 20
18 Patriotas Boyacá Patriotas 20 14 21 18
19 Deportivo Pasto Deportivo 20 13 28 16
20 Atlético Huila Atlético 20 12 35 10
TEMPORADA 2019/2020
APERTURA COLOMBIA
Equipo PJ GF GC Puntos
1 Santa Fe Santa Fe 20 34 17 40
2 Deportes Tolima Deportes 20 30 16 37
3 At. Nacional Nacional 20 39 31 35
4 Deportivo Cali Deportivo 20 32 23 34
5 Deportivo Pasto Deportivo 20 27 19 34
6 América de Cali América 20 31 22 33
7 Junior Junior 20 27 17 33
8 La Equidad La Equidad 20 30 23 32
9 Águilas Doradas Águilas 20 27 21 31
10 Millonarios Millonarios 20 29 21 30
11 Once Caldas Once Caldas 20 23 20 29
12 Envigado Envigado 20 22 25 23
13 Atlético Bucaramanga Atlético 20 16 26 21
14 Independiente Medellín Independient 20 22 28 20
15 Alianza FC Alianza FC 20 22 35 19
16 Deportivo Pereira Deportivo 20 17 24 18
17 Jaguares FC Jaguares FC 20 21 30 17
18 Patriotas Boyacá Patriotas 20 10 21 17
19 Boyacá Chicó Boyacá 20 13 33 15
20 Cúcuta Deportivo Cúcuta 20 18 38 14
TEMPORADA 2018/2019
CLAUSURA COLOMBIA
Equipo PJ GF GC Puntos
1 At. Nacional Nacional 20 30 17 35
2 América de Cali América 20 29 26 35
3 Deportivo Cali Deportivo 20 34 25 34
4 Junior Junior 20 16 9 33
5 Santa Fe Santa Fe 20 22 12 32
6 Deportes Tolima Deportes 20 24 16 32
7 Alianza FC Alianza FC 20 17 14 32
8 Cúcuta Deportivo Cúcuta 20 28 28 32
9 Independiente Medellín Independient 20 32 26 31
10 Once Caldas Once Caldas 20 26 20 28
11 Millonarios Millonarios 20 24 27 28
12 Atlético Bucaramanga Atlético 20 23 23 25
13 Águilas Doradas Águilas 20 25 27 24
14 Deportivo Pasto Deportivo 20 24 25 23
15 Patriotas Boyacá Patriotas 20 19 20 23
16 Envigado Envigado 20 23 28 23
17 La Equidad La Equidad 20 19 24 20
18 Atlético Huila Atlético 20 13 24 16
19 Jaguares FC Jaguares FC 20 11 34 15
20 Unión Magdalena Unión 20 14 28 14
TEMPORADA 2017/2018
CLAUSURA COLOMBIA
Equipo PJ GF GC Puntos
1 Deportes Tolima Deportes 19 34 22 39
2 Once Caldas Once Caldas 19 25 16 36
3 La Equidad La Equidad 19 23 15 36
4 Atlético Bucaramanga Atlético 19 25 20 35
5 Independiente Medellín Independient 19 29 19 34
6 Junior Junior 19 32 17 32
7 Águilas Doradas Águilas 19 21 19 32
8 Santa Fe Santa Fe 19 27 13 31
9 At. Nacional Nacional 19 27 20 30
10 Deportivo Cali Deportivo 19 19 15 29
11 Millonarios Millonarios 19 23 23 25
12 América de Cali América 19 19 20 25
13 Envigado Envigado 19 20 28 20
14 Boyacá Chicó Boyacá 19 19 28 20
15 Patriotas Boyacá Patriotas 19 17 26 20
16 Alianza FC Alianza FC 19 22 33 19
17 Atlético Huila Atlético 19 13 22 18
18 Deportivo Pasto Deportivo 19 11 21 15
19 Jaguares FC Jaguares FC 19 13 29 14
20 Leones Leones 19 15 28 9
TEMPORADA 2016/2017
CLAUSURA COLOMBIA
Equipo PJ GF GC Puntos
1 Junior Junior 20 32 15 39
2 Santa Fe Santa Fe 20 21 10 39
3 At. Nacional Nacional 20 25 12 38
4 Millonarios Millonarios 20 26 14 36
5 Deportes Tolima Deportes 20 25 20 33
6 América de Cali América 20 19 15 31
7 La Equidad La Equidad 20 25 18 30
8 Jaguares FC Jaguares FC 20 25 21 28
9 Independiente Medellín Independient 20 23 20 27
10 Atlético Huila Atlético 20 21 23 27
11 Envigado Envigado 20 19 23 26
12 Tigres FC Tigres FC 20 13 19 26
13 Internacional de Palmira Internaciona 20 17 28 24
14 Deportivo Cali Deportivo 20 25 32 23
15 Deportivo Pasto Deportivo 20 25 29 21
16 Patriotas Boyacá Patriotas 20 19 25 21
17 Once Caldas Once Caldas 20 16 24 21
18 Alianza FC Alianza FC 20 16 28 19
19 Atlético Bucaramanga Atlético 20 18 24 18
20 Águilas Doradas Águilas 20 16 26 18
TEMPORADA 2015/2016
CLAUSURA COLOMBIA
Equipo PJ GF GC Puntos
1 At. Nacional Nacional 20 32 19 37
2 Deportivo Cali Deportivo 20 25 17 34
3 Deportes Tolima Deportes 20 25 16 33
4 Millonarios Millonarios 20 28 21 33
5 Santa Fe Santa Fe 20 22 15 33
6 Independiente Medellín Independient 20 31 26 33
7 Atlético Bucaramanga Atlético 20 24 19 32
8 Patriotas Boyacá Patriotas 20 23 19 32
9 Envigado Envigado 20 23 20 32
10 Alianza FC Alianza FC 20 22 17 30
11 Junior Junior 20 25 27 28
12 Águilas Doradas Águilas 20 23 28 26
13 Once Caldas Once Caldas 20 25 24 25
14 La Equidad La Equidad 20 24 27 23
15 Jaguares FC Jaguares FC 20 16 20 23
16 Atlético Huila Atlético 20 18 27 23
17 Fortaleza Fortaleza 20 20 28 20
18 Deportivo Pasto Deportivo 20 19 28 20
19 Internacional de Palmira Internaciona 20 22 34 14
20 Boyacá Chicó Boyacá 20 18 33 14
TEMPORADA 2014/2015
CLAUSURA COLOMBIA
Equipo PJ GF GC Puntos
1 At. Nacional Nacional 20 33 7 45
2 Junior Junior 20 31 23 36
3 Deportes Tolima Deportes 20 23 14 35
4 Independiente Medellín Independient 20 23 18 35
5 Once Caldas Once Caldas 20 25 14 34
6 Alianza FC Alianza FC 20 18 12 33
7 Deportivo Cali Deportivo 20 30 28 32
8 Santa Fe Santa Fe 20 26 15 31
9 Patriotas Boyacá Patriotas 20 24 19 31
10 Deportivo Pasto Deportivo 20 25 26 30
11 Millonarios Millonarios 20 20 16 28
12 La Equidad La Equidad 20 22 27 28
13 Envigado Envigado 20 18 18 25
14 Águilas Doradas Águilas 20 17 16 24
15 Internacional de Palmira Internaciona 20 20 20 24
16 Uniautónoma Uniautónoma 20 18 26 22
17 Boyacá Chicó Boyacá 20 10 29 17
18 Atlético Huila Atlético 20 12 28 16
19 Cúcuta Deportivo Cúcuta 20 15 37 12
20 Jaguares FC Jaguares FC 20 18 35 10
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

  USO DE MEMORIA  
6,653,448 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1767
Total Execution Time  0.1785
  CADENA URL  
/historico/Ad-Pasto
  GET DATOS  
$_GET['/historico/Ad-Pasto']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5944 AND type_rel = 2
0.0030  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 5944 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0026  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 (1735,1828,1874,3016,3130) 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 = '5944' ORDER BY l.year DESC,cat.coefficient DESC
0.0034  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 = '5944' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 74955 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0045  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=5944 AND l.year in (2023,2024,2025) 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 (74955,71742,70934,70900) 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.0040  SELECT count(id) as num_players from rel_players WHERE league_id = 74955 AND teamId = 5944
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 70934 AND teamId = 5944
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 71742 AND teamId = 5944
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 70900 AND teamId = 5944
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 = 74955 AND t.round = 19 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023  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 = '5944' 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 = '5944' and rp.type = 4
0.0025  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 = '5944' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0036  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 = 74955 WHERE rp.league_id = 74955 AND rp.teamId = 5944 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.0049  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 = 74955 WHERE rp.league_id = 74955 AND rp.teamId = 5944 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 = 74955 WHERE rp.league_id = 74955 AND rp.teamId = 5944 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  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 = 5944 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 74955 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 = 70934 AND t.round = 20 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 `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 = 70737 AND t.round = 20 ORDER BY team.conference ASC,t.position 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 `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 = 66290 AND t.round = 20 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 `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 = 60836 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.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 `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 = 63287 AND t.round = 20 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 `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 = 53475 AND t.round = 20 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 `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 = 48381 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 `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 = 48672 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 `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 = 42448 AND t.round = 19 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 `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 = 43561 AND t.round = 19 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 = 37731 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 `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 = 38746 AND t.round = 20 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 `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 = 20228 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 `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 = 33328 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 `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.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 = 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 `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.0029  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 = 3899 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 74955 ORDER BY nameShow LIMIT 100