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 2023/2024
TEMPORADA 2023/2024
LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 Argentinos Juniors Argentinos 0 0 0 0
2 Atl. Tucumán Atl. 0 0 0 0
3 Banfield Banfield 0 0 0 0
4 Barracas Central Barracas 0 0 0 0
5 Belgrano Belgrano 0 0 0 0
6 Boca Juniors Boca Juniors 0 0 0 0
7 CA Huracán CA Huracán 0 0 0 0
8 Central Córdoba Central 0 0 0 0
9 Defensa y Justicia Defensa 0 0 0 0
10 Dep. Riestra Dep. Riestra 0 0 0 0
11 Estudiantes La Plata Estudiantes 0 0 0 0
12 Gimnasia La Plata Gimnasia 0 0 0 0
13 Godoy Cruz Godoy Cruz 0 0 0 0
14 Indep. Rivadavia Indep. 0 0 0 0
15 Independiente Independient 0 0 0 0
16 Instituto Instituto 0 0 0 0
17 Lanús Lanús 0 0 0 0
18 Newell's Old Boys Newell's 0 0 0 0
19 Platense Platense 0 0 0 0
20 Racing Club Racing Club 0 0 0 0
21 River Plate River Plate 0 0 0 0
22 Rosario Central Rosario 0 0 0 0
23 San Lorenzo San Lorenzo 0 0 0 0
24 Sarmiento Sarmiento 0 0 0 0
25 Talleres Córdoba Talleres 0 0 0 0
26 Tigre Tigre 0 0 0 0
27 Unión Santa Fe Unión Santa 0 0 0 0
28 Vélez Sarsfield Vélez 0 0 0 0
TEMPORADA 2022/2023
COPA LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 CA Huracán CA Huracán 14 19 11 26
2 River Plate River Plate 14 24 16 24
3 Banfield Banfield 14 11 6 23
4 Rosario Central Rosario 14 17 13 23
5 Independiente Independient 14 15 11 23
6 Vélez Sarsfield Vélez 14 17 14 22
7 Instituto Instituto 14 11 7 20
8 Colón Colón 14 19 17 20
9 Talleres Córdoba Talleres 14 15 15 17
10 Atl. Tucumán Atl. 14 9 12 17
11 Gimnasia La Plata Gimnasia 14 13 21 15
12 Argentinos Juniors Argentinos 14 19 23 14
13 Barracas Central Barracas 14 10 21 14
14 Arsenal de Sarandí Arsenal 14 10 15 13
15 Racing Club Racing Club 14 22 16 24
16 Godoy Cruz Godoy Cruz 14 14 9 22
17 Belgrano Belgrano 14 20 18 21
18 Platense Platense 14 13 16 20
19 Central Córdoba Central 14 11 14 19
20 Newell's Old Boys Newell's 14 14 10 18
21 Boca Juniors Boca Juniors 14 17 16 18
22 San Lorenzo San Lorenzo 14 11 11 18
23 Estudiantes La Plata Estudiantes 14 11 13 17
24 Sarmiento Sarmiento 14 8 8 16
25 Unión Santa Fe Unión Santa 14 10 13 16
26 Defensa y Justicia Defensa 14 12 16 14
27 Tigre Tigre 14 8 13 13
28 Lanús Lanús 14 9 14 12
TEMPORADA 2021/2022
LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 Boca Juniors Boca Juniors 27 34 28 52
2 Racing Club Racing Club 27 41 24 50
3 River Plate River Plate 27 43 22 47
4 CA Huracán CA Huracán 27 35 21 47
5 Atl. Tucumán Atl. 27 32 22 46
6 San Lorenzo San Lorenzo 27 33 23 43
7 Tigre Tigre 27 41 32 43
8 Argentinos Juniors Argentinos 27 33 24 42
9 Gimnasia La Plata Gimnasia 27 26 18 41
10 Patronato Patronato 27 31 27 40
11 Newell's Old Boys Newell's 27 26 22 40
12 Defensa y Justicia Defensa 27 29 27 40
13 Talleres Córdoba Talleres 27 28 26 35
14 Independiente Independient 27 31 31 35
15 Godoy Cruz Godoy Cruz 27 25 29 35
16 Central Córdoba Central 27 34 37 34
17 Barracas Central Barracas 27 31 37 34
18 Estudiantes La Plata Estudiantes 27 28 40 33
19 Platense Platense 27 23 25 32
20 Rosario Central Rosario 27 24 28 32
21 Sarmiento Sarmiento 27 27 32 32
22 Unión Santa Fe Unión Santa 27 28 36 32
23 Arsenal de Sarandí Arsenal 27 28 29 30
24 Banfield Banfield 27 23 29 30
25 Colón Colón 27 24 36 29
26 Vélez Sarsfield Vélez 27 30 33 28
27 Lanús Lanús 27 22 40 21
28 Aldosivi Aldosivi 27 16 48 16
TEMPORADA 2020/2021
COPA LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 Colón Colón 13 23 10 25
2 Estudiantes La Plata Estudiantes 13 16 10 22
3 River Plate River Plate 13 25 11 21
4 Racing Club Racing Club 13 14 12 21
5 San Lorenzo San Lorenzo 13 16 16 21
6 Banfield Banfield 13 14 12 20
7 Argentinos Juniors Argentinos 13 14 11 19
8 Rosario Central Rosario 13 16 18 18
9 Central Córdoba Central 13 14 17 17
10 Godoy Cruz Godoy Cruz 13 18 24 15
11 Platense Platense 13 12 19 14
12 Arsenal de Sarandí Arsenal 13 11 23 12
13 Aldosivi Aldosivi 13 15 21 11
14 Vélez Sarsfield Vélez 13 23 13 31
15 Boca Juniors Boca Juniors 13 22 12 22
16 Independiente Independient 13 16 10 20
17 Talleres Córdoba Talleres 13 19 16 20
18 Lanús Lanús 13 18 18 19
19 Unión Santa Fe Unión Santa 13 12 14 19
20 Atl. Tucumán Atl. 13 24 20 18
21 Gimnasia La Plata Gimnasia 13 15 20 15
22 CA Huracán CA Huracán 13 14 17 13
23 Patronato Patronato 13 12 17 12
24 Defensa y Justicia Defensa 13 15 21 12
25 Sarmiento Sarmiento 13 10 19 12
26 Newell's Old Boys Newell's 13 14 21 11
TEMPORADA 2019/2020
LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 Boca Juniors Boca Juniors 23 35 8 48
2 River Plate River Plate 23 41 18 47
3 Vélez Sarsfield Vélez 23 27 14 39
4 Racing Club Racing Club 23 28 23 39
5 Argentinos Juniors Argentinos 23 22 17 39
6 Defensa y Justicia Defensa 23 26 18 36
7 Lanús Lanús 23 32 29 36
8 San Lorenzo San Lorenzo 23 32 30 36
9 Rosario Central Rosario 23 31 29 36
10 Newell's Old Boys Newell's 23 33 25 35
11 Arsenal de Sarandí Arsenal 23 37 32 34
12 Talleres Córdoba Talleres 23 34 30 34
13 Estudiantes La Plata Estudiantes 23 23 22 30
14 Independiente Independient 23 27 25 29
15 Atl. Tucumán Atl. 23 22 25 29
16 Unión Santa Fe Unión Santa 23 21 30 27
17 Banfield Banfield 23 19 23 26
18 Central Córdoba Central 23 21 29 26
19 Gimnasia La Plata Gimnasia 23 22 23 23
20 Patronato Patronato 23 22 34 23
21 CA Huracán CA Huracán 23 17 27 22
22 Aldosivi Aldosivi 23 20 35 22
23 Colón Colón 23 17 39 18
24 Godoy Cruz Godoy Cruz 23 22 46 18
TEMPORADA 2018/2019
LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 Racing Club Racing Club 25 43 16 57
2 Defensa y Justicia Defensa 25 33 18 53
3 Boca Juniors Boca Juniors 25 42 18 51
4 River Plate River Plate 25 42 21 45
5 Atl. Tucumán Atl. 25 36 29 42
6 Vélez Sarsfield Vélez 25 34 25 40
7 Independiente Independient 25 35 28 38
8 Unión Santa Fe Unión Santa 25 29 24 36
9 Tigre Tigre 25 39 42 36
10 CA Huracán CA Huracán 25 28 28 35
11 Lanús Lanús 25 27 32 34
12 Talleres Córdoba Talleres 25 25 24 33
13 Aldosivi Aldosivi 25 21 24 33
14 Godoy Cruz Godoy Cruz 25 23 30 32
15 Newell's Old Boys Newell's 25 26 23 29
16 Banfield Banfield 25 27 31 29
17 Estudiantes La Plata Estudiantes 25 21 25 29
18 Gimnasia La Plata Gimnasia 25 21 32 29
19 Patronato Patronato 25 29 37 26
20 Rosario Central Rosario 25 16 26 26
21 San Martín San Juan Martín Juan 25 24 34 25
22 Belgrano Belgrano 25 16 23 24
23 San Lorenzo San Lorenzo 25 21 30 23
24 Colón Colón 25 21 33 23
25 San Martín Tucumán Martín 25 25 38 23
26 Argentinos Juniors Argentinos 25 15 28 22
TEMPORADA 2017/2018
LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 Boca Juniors Boca Juniors 27 50 22 58
2 Godoy Cruz Godoy Cruz 27 45 24 56
3 San Lorenzo San Lorenzo 27 31 20 50
4 CA Huracán CA Huracán 27 35 24 48
5 Talleres Córdoba Talleres 27 33 20 46
6 Independiente Independient 27 29 19 46
7 Racing Club Racing Club 27 46 32 45
8 River Plate River Plate 27 39 26 45
9 Defensa y Justicia Defensa 27 41 34 44
10 Unión Santa Fe Unión Santa 27 33 23 43
11 Colón Colón 27 32 22 41
12 Argentinos Juniors Argentinos 27 36 30 41
13 Belgrano Belgrano 27 29 28 40
14 Vélez Sarsfield Vélez 27 31 32 38
15 Atl. Tucumán Atl. 27 29 26 36
16 Estudiantes La Plata Estudiantes 27 25 26 36
17 Banfield Banfield 27 27 24 35
18 San Martín San Juan Martín Juan 27 30 36 33
19 Patronato Patronato 27 26 32 33
20 Rosario Central Rosario 27 30 41 32
21 Lanús Lanús 27 20 37 29
22 Newell's Old Boys Newell's 27 23 28 27
23 Gimnasia La Plata Gimnasia 27 28 43 27
24 Tigre Tigre 27 26 33 24
25 Temperley Temperley 27 22 46 23
26 Chacarita Juniors Chacarita 27 23 40 18
27 Arsenal de Sarandí Arsenal 27 19 36 17
28 Olimpo Olimpo 27 16 50 15
TEMPORADA 2016/2017
LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 Boca Juniors Boca Juniors 30 62 25 63
2 River Plate River Plate 30 51 28 56
3 Estudiantes La Plata Estudiantes 30 46 26 56
4 Racing Club Racing Club 30 51 40 55
5 Banfield Banfield 30 42 35 54
6 Independiente Independient 30 39 23 53
7 San Lorenzo San Lorenzo 30 46 35 53
8 Lanús Lanús 30 36 25 50
9 Newell's Old Boys Newell's 30 40 30 49
10 Defensa y Justicia Defensa 30 31 23 49
11 Colón Colón 30 32 25 49
12 Rosario Central Rosario 30 40 31 44
13 Gimnasia La Plata Gimnasia 30 26 24 43
14 Godoy Cruz Godoy Cruz 30 34 34 43
15 Talleres Córdoba Talleres 30 35 30 42
16 Olimpo Olimpo 30 37 32 38
17 Atletico Rafaela Atletico 30 31 30 37
18 Temperley Temperley 30 30 38 37
19 Vélez Sarsfield Vélez 30 31 40 37
20 Patronato Patronato 30 30 40 34
21 Atl. Tucumán Atl. 30 34 40 33
22 San Martín San Juan Martín Juan 30 27 40 33
23 Unión Santa Fe Unión Santa 30 25 39 32
24 Tigre Tigre 30 33 43 31
25 CA Huracán CA Huracán 30 23 30 29
26 Sarmiento Sarmiento 30 31 51 28
27 Arsenal de Sarandí Arsenal 30 27 50 27
28 Belgrano Belgrano 30 21 34 26
29 Quilmes Quilmes 30 18 43 25
30 Aldosivi Aldosivi 30 15 40 25
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

  USO DE MEMORIA  
8,671,448 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7919
Total Execution Time  0.7931
  CADENA URL  
/historico/Ca-Huracan
  GET DATOS  
$_GET['/historico/Ca-Huracan']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (49)  
0.0194  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 = 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.0126  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.0126  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.0125  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.0125  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.0125  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.0126  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.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=585 AND type_rel = 2
0.0136  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.0129  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 (928,2073,8452,8656,11182) ORDER BY n.cover_points DESC, update_date DESC
0.0141  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 = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0160  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.0140  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 (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (75100,75056,74909,74880,71432,71367,71148) 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.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 74880 AND teamId = 585
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 75056 AND teamId = 585
0.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 71148 AND teamId = 585
0.0133  SELECT count(id) as num_players from rel_players WHERE league_id = 71367 AND teamId = 585
0.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 74909 AND teamId = 585
0.0190  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 585
0.0158  SELECT count(id) as num_players from rel_players WHERE league_id = 75100 AND teamId = 585
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 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 = 75056 AND t.round = 1 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0139  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 = '585' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0130  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '585' and rp.type = 4
0.0132  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 = '585' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0126  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '585' and rp.type = 4
0.0128  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 = 75056 WHERE rp.league_id = 75056 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.0127  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 = 75056 WHERE rp.league_id = 75056 AND rp.teamId = 585 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0127  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 = 75056 WHERE rp.league_id = 75056 AND rp.teamId = 585 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0159  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 <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 74880 AND t.round = 14 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 `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 = 70411 AND t.round = 27 ORDER BY team.conference ASC,t.position 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 `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 = 70413 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 66295 AND t.round = 14 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 `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 = 67703 AND t.round = 27 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 `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 = 61201 AND t.round = 25 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 = 61219 AND t.round = 13 ORDER BY team.conference ASC,t.position 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 `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 = 49952 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  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 = 43555 AND t.round = 25 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  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 = 38943 AND t.round = 27 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 `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 = 33424 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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.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 = 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.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 = 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.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 = 2501 AND t.round = 42 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 `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.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 `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.0133  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.0130  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