4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
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
PRIMERA B COLOMBIA GRUPO 1
Equipo PJ GF GC Puntos
1 Deportivo Pereira Deportivo 32 58 28 70
2 América de Cali América 32 48 24 60
3 Real Cartagena Real 32 47 36 57
4 Leones Leones 32 43 31 49
5 Universitario Popayán Universitari 32 37 35 49
6 Tigres FC Tigres FC 32 26 24 48
7 Deportes Quindío Deportes 32 36 33 44
8 Bogotá Bogotá 32 37 39 44
9 Real Cundinamarca Real 32 34 37 44
10 Cúcuta Deportivo Cúcuta 32 35 31 42
11 Orsomarso SC Orsomarso 32 35 48 40
12 Barranquilla Barranquilla 32 31 37 35
13 Unión Magdalena Unión 32 30 39 35
14 Real Santander Real 32 33 51 33
15 Llaneros Llaneros 32 31 42 31
16 Atlético Fútbol Club Atlético 32 19 45 25
TEMPORADA 2014/2015
PRIMERA B COLOMBIA GRUPO 2
Equipo PJ GF GC Puntos
1 Atlético Bucaramanga Atlético 6 10 3 13
2 América de Cali América 6 12 9 10
3 Real Cartagena Real 6 7 12 7
4 Universitario Popayán Universitari 6 8 13 4
5 Fortaleza Fortaleza 6 14 7 15
6 Deportivo Pereira Deportivo 6 12 5 13
7 Leones Leones 6 5 10 4
8 Unión Magdalena Unión 6 5 14 3
TEMPORADA 2013/2014
APERTURA PRIMERA B COLOMBIA
Equipo PJ GF GC Puntos
1 Atlético Bucaramanga Atlético 18 22 12 34
2 Llaneros Llaneros 18 23 15 33
3 América de Cali América 18 24 15 32
4 Jaguares FC Jaguares FC 18 26 20 31
5 Deportes Quindío Deportes 18 23 13 30
6 Cúcuta Deportivo Cúcuta 18 20 18 30
7 Deportivo Rionegro Deportivo 18 30 25 29
8 Unión Magdalena Unión 18 21 22 28
9 Real Cundinamarca Real 18 29 18 27
10 Real Cartagena Real 18 24 17 27
11 Universitario Popayán Universitari 18 25 25 26
12 Barranquilla Barranquilla 18 18 22 22
13 Real Santander Real 18 21 28 22
14 Internacional de Palmira Internaciona 18 21 26 19
15 Bogotá Bogotá 18 15 27 17
16 Tigres FC Tigres FC 18 17 28 14
17 Deportivo Pereira Deportivo 18 18 33 13
18 Atlético Fútbol Club Atlético 18 17 30 12
TEMPORADA 2012/2013
APERTURA PRIMERA B COLOMBIA
Equipo PJ GF GC Puntos
1 América de Cali América 18 31 8 39
2 Uniautónoma Uniautónoma 18 34 20 32
3 Bogotá Bogotá 18 32 23 30
4 Llaneros Llaneros 18 20 17 30
5 Deportivo Rionegro Deportivo 18 31 28 29
6 Internacional de Palmira Internaciona 18 25 23 29
7 Unión Magdalena Unión 18 22 20 29
8 Real Cundinamarca Real 18 29 13 28
9 Atlético Fútbol Club Atlético 18 20 23 28
10 Atlético Bucaramanga Atlético 18 23 22 26
11 Jaguares FC Jaguares FC 18 21 24 25
12 Real Cartagena Real 18 25 19 24
13 Deportivo Pereira Deportivo 18 28 29 23
14 Tigres FC Tigres FC 18 20 25 22
15 Fortaleza Fortaleza 18 17 25 19
16 Real Santander Real 18 22 35 18
17 Barranquilla Barranquilla 18 14 36 13
18 Universitario Popayán Universitari 18 17 41 10
TEMPORADA 2011/2012
CLAUSURA PRIMERA B COLOMBIA
Equipo PJ GF GC Puntos
1 Deportivo Pereira Deportivo 18 37 14 43
2 Alianza FC Alianza FC 18 35 18 34
3 América de Cali América 18 31 18 34
4 Deportivo Rionegro Deportivo 18 25 19 31
5 Universitario Popayán Universitari 18 20 21 30
6 Internacional de Palmira Internaciona 18 27 25 29
7 Uniautónoma Uniautónoma 18 23 20 27
8 Atlético Bucaramanga Atlético 18 22 24 27
9 Real Cundinamarca Real 18 15 12 25
10 Sucre FC Sucre FC 18 19 22 25
11 Bogotá Bogotá 18 22 30 23
12 Unión Magdalena Unión 18 19 20 21
13 Atlético Fútbol Club Atlético 18 22 25 19
14 Fortaleza Fortaleza 18 14 18 19
15 Tigres FC Tigres FC 18 12 18 16
16 Real Santander Real 18 22 31 16
17 Barranquilla Barranquilla 18 22 37 15
18 Llaneros Llaneros 18 11 26 13
TEMPORADA 2010/2011
APERTURA COLOMBIA
Equipo PJ GF GC Puntos
1 Once Caldas Once Caldas 18 33 16 39
2 Deportes Tolima Deportes 18 35 21 34
3 At. Nacional Nacional 18 34 25 34
4 Envigado Envigado 18 30 21 32
5 La Equidad La Equidad 18 23 14 29
6 Millonarios Millonarios 18 31 23 28
7 Deportivo Cali Deportivo 18 21 22 27
8 Cúcuta Deportivo Cúcuta 18 22 19 26
9 Boyacá Chicó Boyacá 18 25 24 25
10 Deportes Quindío Deportes 18 22 29 25
11 Águilas Doradas Águilas 18 24 23 24
12 América de Cali América 18 21 25 24
13 Real Cartagena Real 18 22 26 21
14 Santa Fe Santa Fe 18 18 22 21
15 Junior Junior 18 19 28 19
16 Atlético Huila Atlético 18 25 36 17
17 Independiente Medellín Independient 18 19 30 15
18 Deportivo Pereira Deportivo 18 15 35 5

  USO DE MEMORIA  
7,283,296 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.2999
Total Execution Time  0.3012
  CADENA URL  
/historico/America-Cali/2021
  GET DATOS  
$_GET['/historico/America-Cali/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (65)  
0.0121  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 = 'America-Cali' AND l.year = 2021 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.0025  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=207 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023  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=207 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0026  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=207 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025  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=207 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025  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=207 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024  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=207 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025  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=207 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025  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=207 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0026  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=207 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0047  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 = 62029
0.0047  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 = 62810
0.0048  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 = 60836
0.0053  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 = 63287
0.0045  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 = 62166
0.0045  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 = 61682
0.0045  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 = 65032
0.0091  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 = '207' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '207' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0031  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 = 61682 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0029  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 = 62810 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026  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 = 62029 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0032  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 = 62166 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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 = 65953 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0030  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 = 60836 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0034  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 = 63287 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0033  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 = 65032 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0173  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=207 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0036  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 (70369,66316,66314,66290,66233,65032,62810,62807,62166,62029) 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.0093  SELECT count(id) as num_players from rel_players WHERE league_id = 66290 AND teamId = 207
0.0053  SELECT count(id) as num_players from rel_players WHERE league_id = 66314 AND teamId = 207
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 62029 AND teamId = 207
0.0043  SELECT count(id) as num_players from rel_players WHERE league_id = 62810 AND teamId = 207
0.0034  SELECT count(id) as num_players from rel_players WHERE league_id = 66233 AND teamId = 207
0.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 62166 AND teamId = 207
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 70369 AND teamId = 207
0.0037  SELECT count(id) as num_players from rel_players WHERE league_id = 66316 AND teamId = 207
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 65032 AND teamId = 207
0.0158  SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 207
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 `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 = 62029 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 events2021 e ON e.player_id = p.id AND e.league_id = 62029 WHERE rp.league_id = 62029 AND rp.teamId = 207 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.0026  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 events2021 e ON e.player_id = p.id AND e.league_id = 62029 WHERE rp.league_id = 62029 AND rp.teamId = 207 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 events2021 e ON e.player_id = p.id AND e.league_id = 62029 WHERE rp.league_id = 62029 AND rp.teamId = 207 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0037  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 = 207 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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.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 `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.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 = 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.0021  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.0021  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.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 = 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.0021  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.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 `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.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 `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.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 `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.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 `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.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 = 3209 AND t.round = 18 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 `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.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 `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 = 2622 AND t.round = 18 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 `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 = 2415 AND t.round = 18 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 `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 = 1569 AND t.round = 18 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 `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 = 1662 AND t.round = 18 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 = 1296 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 = 62029 ORDER BY nameShow LIMIT 100