4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CA Huracán

CA Huracán

Entrenador: Frank Kudelka

Temporada 2015/2016
TEMPORADA 2015/2016
LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 San Lorenzo San Lorenzo 16 23 16 34
2 Godoy Cruz Godoy Cruz 16 27 14 33
3 Independiente Independient 16 22 12 27
4 Arsenal de Sarandí Arsenal 16 21 15 27
5 Gimnasia La Plata Gimnasia 16 19 19 25
6 Vélez Sarsfield Vélez 16 20 19 24
7 Rosario Central Rosario 16 19 16 20
8 Patronato Patronato 16 19 23 20
9 River Plate River Plate 16 21 22 18
10 Sarmiento Sarmiento 16 10 18 17
11 Colón Colón 16 21 31 17
12 Belgrano Belgrano 16 21 24 16
13 Banfield Banfield 16 15 20 15
14 Quilmes Quilmes 16 21 32 15
15 Olimpo Olimpo 16 11 20 13
16 Lanús Lanús 16 28 10 38
17 Estudiantes La Plata Estudiantes 16 25 11 32
18 Atl. Tucumán Atl. 16 26 19 30
19 Defensa y Justicia Defensa 16 25 16 25
20 CA Huracán CA Huracán 16 21 15 25
21 Racing Club Racing Club 16 29 26 24
22 San Martín San Juan Martín Juan 16 23 20 23
23 Unión Santa Fe Unión Santa 16 24 22 22
24 Tigre Tigre 16 21 17 20
25 Boca Juniors Boca Juniors 16 15 13 20
26 Aldosivi Aldosivi 16 19 28 17
27 Newell's Old Boys Newell's 16 16 21 16
28 Temperley Temperley 16 14 21 16
29 Argentinos Juniors Argentinos 16 11 29 12
30 Atletico Rafaela Atletico 16 14 32 9
TEMPORADA 2014/2015
LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 Boca Juniors Boca Juniors 30 49 26 64
2 San Lorenzo San Lorenzo 30 44 20 61
3 Rosario Central Rosario 30 47 26 59
4 Racing Club Racing Club 30 40 23 57
5 Independiente Independient 30 44 22 54
6 Belgrano Belgrano 30 33 23 51
7 Estudiantes La Plata Estudiantes 30 34 28 51
8 Banfield Banfield 30 38 32 50
9 River Plate River Plate 30 46 33 49
10 Tigre Tigre 30 32 25 46
11 Quilmes Quilmes 30 38 37 45
12 Gimnasia La Plata Gimnasia 30 41 38 44
13 Lanús Lanús 30 33 29 42
14 Unión Santa Fe Unión Santa 30 38 37 41
15 Aldosivi Aldosivi 30 37 40 40
16 Newell's Old Boys Newell's 30 27 30 40
17 San Martín San Juan Martín Juan 30 32 34 37
18 Olimpo Olimpo 30 23 26 36
19 Colón Colón 30 26 31 34
20 Argentinos Juniors Argentinos 30 30 38 33
21 Defensa y Justicia Defensa 30 27 31 32
22 Godoy Cruz Godoy Cruz 30 32 40 32
23 CA Huracán CA Huracán 30 29 37 30
24 Sarmiento Sarmiento 30 24 34 30
25 Temperley Temperley 30 19 29 30
26 Nueva Chicago Nueva 30 29 38 29
27 Vélez Sarsfield Vélez 30 27 37 29
28 Arsenal de Sarandí Arsenal 30 25 44 27
29 Atletico Rafaela Atletico 30 29 51 23
30 Crucero del Norte Crucero 30 21 55 14
TEMPORADA 2013/2014
PRIMERA NACIONAL
Equipo PJ GF GC Puntos
1 Banfield Banfield 42 71 40 78
2 Defensa y Justicia Defensa 42 67 45 75
3 Independiente Independient 42 49 37 67
4 CA Huracán CA Huracán 42 43 30 67
5 Atl. Tucumán Atl. 42 44 36 64
6 Instituto Instituto 42 54 46 62
7 Gimnasia Jujuy Gimnasia 42 41 35 61
8 Crucero del Norte Crucero 42 45 42 59
9 San Martín San Juan Martín Juan 42 49 52 57
10 Unión Santa Fe Unión Santa 42 48 48 55
11 Indep. Rivadavia Indep. 42 50 51 55
12 Sarmiento Sarmiento 42 45 47 55
13 Ferro Carril Oeste Ferro Carril 42 35 39 55
14 Boca Unidos Boca Unidos 42 43 46 54
15 Sportivo Belgrano Sportivo 42 39 40 53
16 Aldosivi Aldosivi 42 42 47 51
17 Douglas Haig Douglas Haig 42 35 44 51
18 Brown Adrogue Brown 42 45 50 50
19 Patronato Patronato 42 30 34 49
20 Talleres Córdoba Talleres 42 48 58 45
21 Almirante Brown Almirante 42 30 48 42
22 Villa San Carlos Villa Carlos 42 31 69 24
TEMPORADA 2012/2013
PRIMERA NACIONAL
Equipo PJ GF GC Puntos
1 Rosario Central Rosario 38 51 29 74
2 Gimnasia La Plata Gimnasia 38 53 25 73
3 Olimpo Olimpo 38 43 22 66
4 Banfield Banfield 38 45 39 58
5 Sarmiento Sarmiento 38 40 34 58
6 Defensa y Justicia Defensa 38 45 46 57
7 Patronato Patronato 38 42 40 56
8 CA Huracán CA Huracán 38 44 41 54
9 Atl. Tucumán Atl. 38 44 40 51
10 Gimnasia Jujuy Gimnasia 38 25 29 50
11 Douglas Haig Douglas Haig 38 43 44 49
12 Indep. Rivadavia Indep. 38 33 36 48
13 Almirante Brown Almirante 38 43 45 46
14 Boca Unidos Boca Unidos 38 32 37 45
15 Crucero del Norte Crucero 38 31 40 45
16 Aldosivi Aldosivi 38 37 45 44
17 Ferro Carril Oeste Ferro Carril 38 29 32 43
18 Instituto Instituto 38 33 41 39
19 Deportivo Merlo Deportivo 38 30 57 37
20 Nueva Chicago Nueva 38 33 54 31
TEMPORADA 2011/2012
PRIMERA NACIONAL
Equipo PJ GF GC Puntos
1 River Plate River Plate 38 66 28 73
2 Quilmes Quilmes 38 62 21 72
3 Instituto Instituto 38 56 28 70
4 Rosario Central Rosario 38 49 33 69
5 Boca Unidos Boca Unidos 38 55 48 57
6 Patronato Patronato 38 41 38 56
7 Ferro Carril Oeste Ferro Carril 38 29 28 56
8 Almirante Brown Almirante 38 36 30 55
9 Gimnasia La Plata Gimnasia 38 38 33 54
10 Defensa y Justicia Defensa 38 50 50 54
11 Aldosivi Aldosivi 38 50 47 53
12 CA Huracán CA Huracán 38 43 50 46
13 Indep. Rivadavia Indep. 38 35 50 45
14 Deportivo Merlo Deportivo 38 28 38 43
15 Atl. Tucumán Atl. 38 33 49 42
16 Guillermo Brown Guillermo 38 46 63 38
17 Sportivo Desamparados Sportivo 38 34 55 37
18 Gimnasia Jujuy Gimnasia 38 32 50 34
19 Atlanta Atlanta 38 28 50 34
20 Chacarita Juniors Chacarita 38 24 46 32
TEMPORADA 2010/2011
CLAUSURA ARGENTINA
Equipo PJ GF GC Puntos
1 Vélez Sarsfield Vélez 19 36 17 39
2 Lanús Lanús 19 29 16 35
3 Godoy Cruz Godoy Cruz 19 33 28 34
4 Olimpo Olimpo 19 28 23 30
5 Argentinos Juniors Argentinos 19 16 11 30
6 Independiente Independient 19 30 20 29
7 Boca Juniors Boca Juniors 19 24 22 28
8 Banfield Banfield 19 24 24 27
9 River Plate River Plate 19 15 15 26
10 Arsenal de Sarandí Arsenal 19 25 22 25
11 Tigre Tigre 19 25 26 25
12 All Boys All Boys 19 14 19 25
13 Estudiantes La Plata Estudiantes 19 18 19 24
14 San Lorenzo San Lorenzo 19 19 17 23
15 Racing Club Racing Club 19 25 26 23
16 Gimnasia La Plata Gimnasia 20 21 25 21
17 Colón Colón 19 20 27 21
18 Quilmes Quilmes 19 24 27 20
19 Newell's Old Boys Newell's 19 16 32 16
20 CA Huracán CA Huracán 20 18 44 14
TEMPORADA 2009/2010
CLAUSURA ARGENTINA
Equipo PJ GF GC Puntos
1 Argentinos Juniors Argentinos 19 35 23 41
2 Estudiantes La Plata Estudiantes 19 33 14 40
3 Godoy Cruz Godoy Cruz 19 28 14 37
4 Independiente Independient 19 25 18 34
5 Banfield Banfield 19 24 16 32
6 Newell's Old Boys Newell's 19 32 18 30
7 Lanús Lanús 19 25 23 29
8 Racing Club Racing Club 19 21 22 29
9 Vélez Sarsfield Vélez 19 25 20 27
10 CA Huracán CA Huracán 19 21 22 26
11 Tigre Tigre 19 28 26 24
12 Gimnasia La Plata Gimnasia 19 21 29 24
13 River Plate River Plate 19 16 21 22
14 Colón Colón 19 20 32 21
15 San Lorenzo San Lorenzo 19 16 21 20
16 Boca Juniors Boca Juniors 19 28 35 20
17 Rosario Central Rosario 19 12 19 19
18 Arsenal de Sarandí Arsenal 19 19 33 19
19 Chacarita Juniors Chacarita 19 22 33 13
20 Atl. Tucumán Atl. 19 14 26 13
TEMPORADA 2008/2009
CLAUSURA ARGENTINA
Equipo PJ GF GC Puntos
1 Vélez Sarsfield Vélez 19 29 13 40
2 CA Huracán CA Huracán 19 35 19 38
3 Lanús Lanús 19 32 26 38
4 Colón Colón 19 29 19 34
5 Racing Club Racing Club 19 23 21 30
6 Estudiantes La Plata Estudiantes 19 22 18 29
7 Gimnasia La Plata Gimnasia 19 23 21 28
8 River Plate River Plate 19 24 25 27
9 Godoy Cruz Godoy Cruz 19 23 26 26
10 Rosario Central Rosario 19 23 21 25
11 San Lorenzo San Lorenzo 19 27 26 24
12 Banfield Banfield 19 25 25 23
13 Tigre Tigre 19 24 25 23
14 Boca Juniors Boca Juniors 19 22 25 22
15 Newell's Old Boys Newell's 19 21 22 21
16 Independiente Independient 19 22 36 21
17 San Martín Tucumán Martín 19 20 23 20
18 Arsenal de Sarandí Arsenal 19 19 30 18
19 Gimnasia Jujuy Gimnasia 19 15 24 17
20 Argentinos Juniors Argentinos 19 19 32 15
TEMPORADA 2007/2008
CLAUSURA ARGENTINA
Equipo PJ GF GC Puntos
1 River Plate River Plate 19 29 13 43
2 Boca Juniors Boca Juniors 19 33 15 39
3 Estudiantes La Plata Estudiantes 19 29 17 39
4 San Lorenzo San Lorenzo 19 30 21 35
5 Vélez Sarsfield Vélez 19 24 17 32
6 Independiente Independient 19 25 15 31
7 Argentinos Juniors Argentinos 19 23 24 30
8 Newell's Old Boys Newell's 19 21 19 29
9 Rosario Central Rosario 19 26 23 27
10 Arsenal de Sarandí Arsenal 19 22 25 25
11 Colón Colón 19 25 27 23
12 Banfield Banfield 19 36 36 22
13 CA Huracán CA Huracán 19 15 17 22
14 Tigre Tigre 19 24 37 22
15 Olimpo Olimpo 19 21 32 20
16 Racing Club Racing Club 21 17 23 19
17 Gimnasia Jujuy Gimnasia 21 22 29 19
18 Lanús Lanús 19 26 39 18
19 Gimnasia La Plata Gimnasia 19 19 26 17
20 San Martín San Juan Martín Juan 19 20 30 17
TEMPORADA 2006/2007
PRIMERA B NACIONAL - APERTURA
Equipo PJ GF GC Puntos
1 Olimpo Olimpo 19 36 17 40
2 Platense Platense 19 31 14 38
3 Tigre Tigre 19 23 17 35
4 San Martín San Juan Martín Juan 19 25 18 34
5 Chacarita Juniors Chacarita 19 22 14 33
6 CA Huracán CA Huracán 19 29 26 33
7 Atletico Rafaela Atletico 19 24 14 32
8 Unión Santa Fe Unión Santa 19 28 17 28
9 San Martín Tucumán Martín 19 21 20 25
10 Aldosivi Aldosivi 19 25 32 24
11 CAI CAI 19 26 27 23
12 Ferro Carril Oeste Ferro Carril 19 19 23 23
13 Instituto Instituto 19 22 29 20
14 Talleres Córdoba Talleres 19 19 23 19
15 Tiro Federal Rosario Tiro Federal 19 23 28 19
16 Defensa y Justicia Defensa 19 11 19 19
17 Almagro Almagro 19 18 31 19
18 Villa Mitre Bahia Blanca Villa Mitre 19 22 27 17
19 Huracán Tres Arroyos Huracán 19 17 33 16
20 Ben Hur Ben Hur 19 22 34 13
TEMPORADA 2005/2006
PRIMERA B NACIONAL - CLAUSURA
Equipo PJ GF GC Puntos
1 Nueva Chicago Nueva 19 30 20 35
2 Belgrano Belgrano 19 29 19 35
3 San Martín San Juan Martín Juan 19 23 15 33
4 Talleres Córdoba Talleres 19 27 20 33
5 Atletico Rafaela Atletico 19 27 21 31
6 Tigre Tigre 19 13 13 31
7 San Martín Mendoza Martín 19 27 25 30
8 Aldosivi Aldosivi 19 20 21 29
9 Chacarita Juniors Chacarita 19 24 18 26
10 Juventud Antoniana Juventud 19 23 20 26
11 Ben Hur Ben Hur 19 17 16 26
12 El Porvenir El Porvenir 19 14 23 24
13 Godoy Cruz Godoy Cruz 19 20 21 23
14 CAI CAI 19 19 25 23
15 CA Huracán CA Huracán 19 27 29 22
16 Unión Santa Fe Unión Santa 19 16 19 22
17 Defensa y Justicia Defensa 19 28 25 21
18 Almagro Almagro 19 14 24 17
19 Huracán Tres Arroyos Huracán 19 15 26 16
20 Ferro Carril Oeste Ferro Carril 19 15 28 14
TEMPORADA 2004/2005
PRIMERA B NACIONAL - CLAUSURA
Equipo PJ GF GC Puntos
1 Gimnasia Jujuy Gimnasia 19 30 17 35
2 CAI CAI 19 26 18 34
3 Atletico Rafaela Atletico 19 26 23 29
4 Talleres Córdoba Talleres 19 27 18 28
5 Belgrano Belgrano 19 22 23 28
6 Chacarita Juniors Chacarita 19 30 28 27
7 CA Huracán CA Huracán 19 25 23 27
8 Tiro Federal Rosario Tiro Federal 19 14 17 27
9 San Martín Mendoza Martín 19 29 24 26
10 Juventud Antoniana Juventud 19 23 20 26
11 San Martín San Juan Martín Juan 19 18 16 25
12 Godoy Cruz Godoy Cruz 19 23 27 25
13 Unión Santa Fe Unión Santa 19 23 28 25
14 Ferro Carril Oeste Ferro Carril 19 24 20 24
15 Nueva Chicago Nueva 19 21 20 23
16 Racing Córdoba Racing 19 22 27 19
17 El Porvenir El Porvenir 19 14 22 19
18 Def. Belgrano Def. 19 18 27 19
19 Defensa y Justicia Defensa 19 15 20 18
20 Sarmiento Sarmiento 19 25 37 14
TEMPORADA 2003/2004
PRIMERA B NACIONAL - CLAUSURA
Equipo PJ GF GC Puntos
1 Almagro Almagro 19 35 19 37
2 Argentinos Juniors Argentinos 19 28 18 36
3 Huracán Tres Arroyos Huracán 19 26 15 34
4 Godoy Cruz Godoy Cruz 19 26 21 33
5 El Porvenir El Porvenir 19 26 16 31
6 Ferro Carril Oeste Ferro Carril 19 20 19 30
7 San Martín San Juan Martín Juan 19 22 23 29
8 Belgrano Belgrano 19 22 15 28
9 CA Huracán CA Huracán 19 31 28 28
10 Tiro Federal Rosario Tiro Federal 19 27 26 27
11 Unión Santa Fe Unión Santa 19 28 29 26
12 Los Andes Los Andes 19 23 29 25
13 Instituto Instituto 19 22 23 24
14 Gimnasia Jujuy Gimnasia 19 26 32 22
15 Defensa y Justicia Defensa 19 27 34 21
16 CAI CAI 19 23 25 20
17 Def. Belgrano Def. 19 21 26 20
18 Gimnasia Concepción Gimnasia 19 25 31 19
19 Juventud Antoniana Juventud 19 17 32 17
20 San Martín Mendoza Martín 19 16 30 13
TEMPORADA 2002/2003
CLAUSURA ARGENTINA
Equipo PJ GF GC Puntos
1 River Plate River Plate 19 43 18 43
2 Boca Juniors Boca Juniors 19 36 23 39
3 Vélez Sarsfield Vélez 19 27 12 38
4 Rosario Central Rosario 19 40 18 37
5 Nueva Chicago Nueva 21 32 33 32
6 Olimpo Olimpo 19 22 17 31
7 Colón Colón 19 19 14 29
8 San Lorenzo San Lorenzo 19 27 28 29
9 Estudiantes La Plata Estudiantes 19 24 18 28
10 Talleres Córdoba Talleres 21 25 26 27
11 Gimnasia La Plata Gimnasia 19 21 26 26
12 Racing Club Racing Club 19 26 24 25
13 Lanús Lanús 19 27 29 25
14 Banfield Banfield 19 18 20 23
15 Arsenal de Sarandí Arsenal 19 12 13 22
16 Newell's Old Boys Newell's 19 21 26 22
17 Independiente Independient 19 13 25 18
18 Unión Santa Fe Unión Santa 19 18 29 17
19 Chacarita Juniors Chacarita 19 11 24 11
20 CA Huracán CA Huracán 19 12 46 6
TEMPORADA 2001/2002
CLAUSURA ARGENTINA
Equipo PJ GF GC Puntos
1 River Plate River Plate 19 39 13 43
2 Gimnasia La Plata Gimnasia 19 33 23 37
3 Boca Juniors Boca Juniors 19 26 17 35
4 CA Huracán CA Huracán 19 27 24 30
5 Banfield Banfield 19 21 19 30
6 Racing Club Racing Club 19 19 18 29
7 Newell's Old Boys Newell's 19 26 25 28
8 Estudiantes La Plata Estudiantes 19 34 27 27
9 Vélez Sarsfield Vélez 19 27 20 26
10 Lanús Lanús 19 20 18 26
11 San Lorenzo San Lorenzo 19 24 23 26
12 Colón Colón 19 24 23 24
13 Nueva Chicago Nueva 19 16 21 24
14 Chacarita Juniors Chacarita 19 23 24 21
15 Unión Santa Fe Unión Santa 19 20 27 21
16 Rosario Central Rosario 19 20 26 20
17 Argentinos Juniors Argentinos 19 20 32 20
18 Belgrano Belgrano 19 16 24 18
19 Talleres Córdoba Talleres 19 14 31 17
20 Independiente Independient 19 14 28 15

  USO DE MEMORIA  
8,413,000 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  1.0184
Total Execution Time  1.0197
  CADENA URL  
/historico/Ca-Huracan/2016
  GET DATOS  
$_GET['/historico/Ca-Huracan/2016']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (57)  
0.0181  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 = 'Ca-Huracan' AND l.year = 2016 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.0146  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=585 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=585 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=585 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=585 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=585 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=585 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=585 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0152  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 = 20052
0.0152  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 = 20056
0.0152  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 = 43045
0.0150  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 = 20217
0.0149  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 = 19918
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=585 AND type_rel = 2
0.0152  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 585 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0147  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 (1314072,928,2073,8452,8656) ORDER BY n.cover_points DESC, update_date DESC
0.0160  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 = '585' AND l.year = 2016 ORDER BY l.year DESC,cat.coefficient DESC
0.0157  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 = '585' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0145  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 = 43045 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146  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 = 20052 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  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 = 20217 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146  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 = 20176 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0160  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=585 AND l.year in (2015,2016,2017) ORDER BY l.id DESC, l.year DESC ;
0.0147  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 (43057,37834,37690,37686,33424,30386,20056,9123,3855) 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.0160  SELECT count(id) as num_players from rel_players WHERE league_id = 33424 AND teamId = 585
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 3855 AND teamId = 585
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 20056 AND teamId = 585
0.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 43057 AND teamId = 585
0.0161  SELECT count(id) as num_players from rel_players WHERE league_id = 37834 AND teamId = 585
0.0156  SELECT count(id) as num_players from rel_players WHERE league_id = 37686 AND teamId = 585
0.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 37690 AND teamId = 585
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 9123 AND teamId = 585
0.0204  SELECT count(id) as num_players from rel_players WHERE league_id = 30386 AND teamId = 585
0.0152  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 20176 AND t.round = 16 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0170  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 events2016 e ON e.player_id = p.id AND e.league_id = 20176 WHERE rp.league_id = 20176 AND rp.teamId = 585 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.0187  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 events2016 e ON e.player_id = p.id AND e.league_id = 20176 WHERE rp.league_id = 20176 AND rp.teamId = 585 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0161  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 events2016 e ON e.player_id = p.id AND e.league_id = 20176 WHERE rp.league_id = 20176 AND rp.teamId = 585 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0175  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 = 585 AND l.year <= 2016 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0152  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 = 20176 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 3855 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165  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 = 8714 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0167  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 = 1999 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 = 1387 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 8382 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 8384 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 `tables2009` 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 = 8386 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 `tables2008` 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 = 8388 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables2007` 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 = 12942 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables2007` 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 = 12943 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 `tables2006` 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 = 12944 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 `tables2006` 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 = 12945 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0166  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 `tables2005` 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 = 12946 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 `tables2005` 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 = 12947 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 `tables2004` 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 = 27496 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0166  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 `tables2004` 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 = 12948 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165  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 `tables2003` 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 = 8400 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158  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 = 20176 ORDER BY nameShow LIMIT 100