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

Deportivo Pereira

Entrenador: Leonel Álvarez

Temporada 2023/2024
TEMPORADA 2023/2024
APERTURA COLOMBIA
Equipo PJ GF GC Puntos
1 Atlético Bucaramanga Atlético 19 24 10 38
2 Deportes Tolima Deportes 19 31 18 38
3 Deportivo Pereira Deportivo 19 27 18 34
4 Santa Fe Santa Fe 19 22 12 34
5 La Equidad La Equidad 19 22 14 33
6 Millonarios Millonarios 19 28 20 31
7 Junior Junior 19 24 21 29
8 Once Caldas Once Caldas 19 16 16 29
9 Independiente Medellín Independient 19 22 31 29
10 América de Cali América 19 22 16 25
11 Águilas Doradas Águilas 19 20 19 25
12 At. Nacional Nacional 19 21 20 24
13 Fortaleza Fortaleza 19 18 20 24
14 Jaguares FC Jaguares FC 19 17 20 22
15 Deportivo Cali Deportivo 19 24 24 21
16 Deportivo Pasto Deportivo 19 15 21 19
17 Boyacá Chicó Boyacá 19 22 35 18
18 Envigado Envigado 19 15 25 16
19 Alianza FC Alianza FC 19 15 29 16
20 Patriotas Boyacá Patriotas 19 8 24 15
TEMPORADA 2022/2023
CLAUSURA COLOMBIA
Equipo PJ GF GC Puntos
1 Águilas Doradas Águilas 20 35 12 44
2 Independiente Medellín Independient 20 30 15 39
3 América de Cali América 20 35 19 37
4 Deportes Tolima Deportes 20 23 17 37
5 At. Nacional Nacional 20 33 21 33
6 Junior Junior 20 29 17 30
7 Millonarios Millonarios 20 21 20 30
8 Deportivo Cali Deportivo 20 25 25 28
9 Alianza FC Alianza FC 20 18 24 28
10 La Equidad La Equidad 20 19 20 26
11 Atlético Bucaramanga Atlético 20 20 22 26
12 Deportivo Pasto Deportivo 20 16 20 25
13 Santa Fe Santa Fe 20 21 29 24
14 Once Caldas Once Caldas 20 21 22 22
15 Unión Magdalena Unión 20 21 32 22
16 Atlético Huila Atlético 20 18 22 19
17 Deportivo Pereira Deportivo 20 19 28 19
18 Boyacá Chicó Boyacá 20 15 26 19
19 Jaguares FC Jaguares FC 20 7 21 14
20 Envigado Envigado 20 18 32 13
TEMPORADA 2021/2022
APERTURA COLOMBIA
Equipo PJ GF GC Puntos
1 Millonarios Millonarios 20 23 11 42
2 Deportes Tolima Deportes 20 29 14 40
3 At. Nacional Nacional 20 26 15 36
4 Independiente Medellín Independient 20 25 19 34
5 Junior Junior 20 30 21 32
6 Envigado Envigado 20 22 21 31
7 La Equidad La Equidad 20 21 16 30
8 Atlético Bucaramanga Atlético 20 27 25 29
9 Alianza FC Alianza FC 20 22 20 29
10 Santa Fe Santa Fe 20 29 26 27
11 Jaguares FC Jaguares FC 20 26 29 27
12 Once Caldas Once Caldas 20 18 18 26
13 Águilas Doradas Águilas 20 17 26 25
14 Deportivo Pereira Deportivo 20 21 26 23
15 América de Cali América 20 20 25 23
16 Deportivo Pasto Deportivo 20 16 20 22
17 Patriotas Boyacá Patriotas 20 19 23 21
18 Internacional de Palmira Internaciona 20 21 27 20
19 Deportivo Cali Deportivo 20 14 24 18
20 Unión Magdalena Unión 20 8 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 PRIMERA B COLOMBIA
Equipo PJ GF GC Puntos
1 Deportes Quindío Deportes 15 21 12 29
2 Boyacá Chicó Boyacá 15 25 19 27
3 Bogotá Bogotá 15 19 14 26
4 Internacional de Palmira Internaciona 15 24 19 25
5 Deportivo Pereira Deportivo 15 13 9 25
6 Real Cartagena Real 15 20 19 24
7 Fortaleza Fortaleza 15 18 15 22
8 Tigres FC Tigres FC 15 17 14 21
9 Leones Leones 15 19 17 21
10 Real Santander Real 15 16 17 20
11 Llaneros Llaneros 15 12 15 19
12 Real Cundinamarca Real 15 14 19 19
13 Atlético Fútbol Club Atlético 15 15 13 18
14 Boca Juniors de Cali Boca Juniors 15 15 25 11
15 Barranquilla Barranquilla 15 10 21 11
16 Orsomarso SC Orsomarso 15 13 23 8
TEMPORADA 2017/2018
PRIMERA B COLOMBIA GRUPO 2
Equipo PJ GF GC Puntos
1 Cúcuta Deportivo Cúcuta 6 9 3 13
2 Internacional de Palmira Internaciona 6 8 9 9
3 Llaneros Llaneros 6 7 9 7
4 Real Cartagena Real 6 7 10 6
5 Unión Magdalena Unión 6 13 4 16
6 Deportes Quindío Deportes 6 10 7 10
7 Deportivo Pereira Deportivo 6 10 10 9
8 Real Cundinamarca Real 6 1 13 0
TEMPORADA 2016/2017
CLAUSURA PRIMERA B COLOMBIA
Equipo PJ GF GC Puntos
1 Barranquilla Barranquilla 16 21 10 33
2 Deportivo Pereira Deportivo 16 23 13 30
3 Deportes Quindío Deportes 16 28 19 30
4 Leones Leones 16 20 15 30
5 Cúcuta Deportivo Cúcuta 16 30 20 27
6 Llaneros Llaneros 16 26 23 25
7 Real Cartagena Real 16 20 20 24
8 Orsomarso SC Orsomarso 16 16 14 23
9 Boyacá Chicó Boyacá 16 16 15 23
10 Unión Magdalena Unión 16 20 22 20
11 Atlético Fútbol Club Atlético 16 13 25 18
12 Bogotá Bogotá 16 10 19 14
13 Real Cundinamarca Real 16 14 28 14
14 Real Santander Real 16 21 25 14
15 Fortaleza Fortaleza 16 14 19 12
16 Universitario Popayán Universitari 16 13 18 12
TEMPORADA 2015/2016
PRIMERA B COLOMBIA GRUPO 2
Equipo PJ GF GC Puntos
1 Tigres FC Tigres FC 6 5 4 11
2 Deportivo Pereira Deportivo 6 10 6 9
3 Leones Leones 6 12 10 9
4 Bogotá Bogotá 6 5 12 3
5 América de Cali América 6 9 4 13
6 Deportes Quindío Deportes 6 9 6 11
7 Real Cartagena Real 6 6 10 5
8 Universitario Popayán Universitari 6 3 7 3
TEMPORADA 2014/2015
PRIMERA B COLOMBIA GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético Bucaramanga Atlético 32 55 17 71
2 Deportivo Pereira Deportivo 32 54 36 60
3 América de Cali América 32 61 37 56
4 Fortaleza Fortaleza 32 41 35 51
5 Real Cartagena Real 32 46 43 50
6 Leones Leones 32 33 36 50
7 Unión Magdalena Unión 32 37 28 48
8 Universitario Popayán Universitari 32 36 30 47
9 Deportes Quindío Deportes 32 43 36 45
10 Real Cundinamarca Real 32 38 45 38
11 Bogotá Bogotá 32 30 44 34
12 Tigres FC Tigres FC 32 38 56 33
13 Real Santander Real 32 36 52 32
14 Barranquilla Barranquilla 32 23 37 31
15 Llaneros Llaneros 32 33 51 30
16 Atlético Fútbol Club Atlético 32 37 58 24
TEMPORADA 2013/2014
CLAUSURA PRIMERA B COLOMBIA
Equipo PJ GF GC Puntos
1 Jaguares FC Jaguares FC 18 27 18 34
2 Deportivo Pereira Deportivo 18 28 15 33
3 Deportes Quindío Deportes 18 28 17 33
4 Deportivo Rionegro Deportivo 18 26 15 33
5 Unión Magdalena Unión 18 32 20 32
6 Cúcuta Deportivo Cúcuta 18 21 15 32
7 Atlético Bucaramanga Atlético 18 23 19 31
8 América de Cali América 18 25 17 30
9 Real Cartagena Real 18 20 18 30
10 Internacional de Palmira Internaciona 18 21 19 25
11 Real Cundinamarca Real 18 16 18 25
12 Llaneros Llaneros 18 25 25 22
13 Universitario Popayán Universitari 18 17 29 19
14 Real Santander Real 18 17 24 18
15 Tigres FC Tigres FC 18 11 20 13
16 Atlético Fútbol Club Atlético 18 18 35 13
17 Bogotá Bogotá 18 17 29 11
18 Barranquilla Barranquilla 18 11 30 11

  USO DE MEMORIA  
6,623,392 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7424
Total Execution Time  0.7436
  CADENA URL  
/historico/Deportivo-Pereira
  GET DATOS  
$_GET['/historico/Deportivo-Pereira']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (46)  
0.0163  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 = 'Deportivo-Pereira' 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.0131  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=912 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=912 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=912 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=912 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0140  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 = 75921
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=912 AND type_rel = 2
0.0130  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 912 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0132  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 (62383,85274,106765,106144,113475) ORDER BY n.cover_points DESC, update_date DESC
0.0138  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 = '912' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0143  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 = '912' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0130  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 = 75921 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0161  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=912 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0137  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 (75921,75230,74955,72456,70955,70934) 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.0158  SELECT count(id) as num_players from rel_players WHERE league_id = 74955 AND teamId = 912
0.0155  SELECT count(id) as num_players from rel_players WHERE league_id = 70934 AND teamId = 912
0.0162  SELECT count(id) as num_players from rel_players WHERE league_id = 72456 AND teamId = 912
0.0153  SELECT count(id) as num_players from rel_players WHERE league_id = 75921 AND teamId = 912
0.0160  SELECT count(id) as num_players from rel_players WHERE league_id = 75230 AND teamId = 912
0.0152  SELECT count(id) as num_players from rel_players WHERE league_id = 70955 AND teamId = 912
0.0130  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 = '912' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '912' and rp.type = 4
0.0127  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 = '912' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0139  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 = 912 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.0138  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 = 912 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135  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 = 912 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 = 912 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0134  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.0132  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.0135  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 = 66314 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.0136  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.0134  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.0132  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.0131  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.0131  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 = 48673 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 48674 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  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 = 42552 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  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 = 46940 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  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 = 37761 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 = 38802 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 20265 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 36592 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 19573 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 9458 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 3477 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 3209 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC