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

Aldosivi

Entrenador: Andrés Yllana

Temporada 2023/2024
TEMPORADA 2023/2024
PRIMERA NACIONAL
Equipo PJ GF GC Puntos
1 San Martín Tucumán Martín 13 14 5 24
2 Quilmes Quilmes 13 16 6 23
3 San Martín San Juan Martín Juan 13 12 10 21
4 CA Estudiantes Estudiantes 13 9 7 21
5 Chacarita Juniors Chacarita 13 14 12 19
6 All Boys All Boys 13 9 7 19
7 Gimnasia Jujuy Gimnasia 13 11 10 18
8 Argentino Agropecuario Argentino 13 18 14 17
9 Ferro Carril Oeste Ferro Carril 13 19 17 17
10 Arsenal de Sarandí Arsenal 13 10 11 17
11 Racing Córdoba Racing 13 10 11 17
12 CA San Miguel Miguel 12 10 8 16
13 Alvarado Alvarado 13 9 12 16
14 Guillermo Brown Guillermo 13 11 14 14
15 Talleres R. Escalada Talleres 13 9 14 14
16 Dep. Maipú Dep. Maipú 13 10 18 14
17 Patronato Patronato 12 9 15 12
18 Club Atlético Güemes Club 13 8 13 11
19 Tristán Suárez Tristán 13 13 19 10
20 Colón Colón 13 22 9 28
21 San Telmo San Telmo 13 19 7 28
22 Def. Belgrano Def. 13 20 11 23
23 Nueva Chicago Nueva 13 11 5 21
24 Aldosivi Aldosivi 13 14 9 21
25 Estudiantes Río Cuarto Estudiantes 13 13 8 20
26 Gimnasia y Tiro Gimnasia 13 10 6 20
27 Deportivo Morón Deportivo 13 15 17 17
28 Gimnasia Mendoza Gimnasia 13 14 16 17
29 Temperley Temperley 13 12 12 16
30 Def. Unidos Def. Unidos 13 12 15 16
31 Atlanta Atlanta 13 11 15 16
32 Chaco For Ever Chaco Ever 13 13 12 15
33 Deportivo Madryn Deportivo 13 9 11 15
34 Atlético Mitre SdE Atlético 13 6 8 14
35 Almagro Almagro 13 8 17 14
36 Atletico Rafaela Atletico 13 9 15 9
37 Almirante Brown Almirante 13 7 14 8
38 Brown Adrogue Brown 13 7 23 8
TEMPORADA 2022/2023
PRIMERA NACIONAL GRUPO 2
Equipo PJ GF GC Puntos
1 Indep. Rivadavia Indep. 34 51 33 68
2 Chacarita Juniors Chacarita 34 48 23 67
3 Dep. Maipú Dep. Maipú 34 46 31 63
4 Quilmes Quilmes 34 44 31 53
5 Atletico Rafaela Atletico 34 38 31 53
6 Atlético Mitre SdE Atlético 34 38 37 52
7 Dep. Riestra Dep. Riestra 34 40 34 50
8 Ferro Carril Oeste Ferro Carril 34 45 37 49
9 Brown Adrogue Brown 34 34 31 47
10 Gimnasia Jujuy Gimnasia 34 36 40 44
11 Deportivo Madryn Deportivo 34 28 28 43
12 Racing Córdoba Racing 34 44 43 41
13 Chaco For Ever Chaco Ever 34 30 43 40
14 CA Estudiantes Estudiantes 34 31 40 36
15 Atlanta Atlanta 34 33 41 35
16 Aldosivi Aldosivi 34 33 44 35
17 Tristán Suárez Tristán 34 36 53 34
18 Villa Dálmine Villa 34 21 56 20
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
PRIMERA NACIONAL GRUPO 1
Equipo PJ GF GC Puntos
1 Almagro Almagro 24 31 16 41
2 Aldosivi Aldosivi 24 30 22 41
3 San Martín Tucumán Martín 24 29 21 39
4 Brown Adrogue Brown 24 27 20 37
5 Sarmiento Sarmiento 24 31 27 37
6 Instituto Instituto 24 22 19 37
7 Atletico Rafaela Atletico 24 34 22 36
8 Villa Dálmine Villa 24 24 17 36
9 Argentino Agropecuario Argentino 24 30 28 35
10 Gimnasia Jujuy Gimnasia 24 18 11 34
11 Deportivo Morón Deportivo 24 22 23 33
12 Quilmes Quilmes 24 24 23 32
13 Atlético Mitre SdE Atlético 24 21 22 32
14 Indep. Rivadavia Indep. 24 20 19 31
15 JU Gualeguaychu Gualeguaychu 24 20 29 30
16 Guillermo Brown Guillermo 24 25 27 28
17 Los Andes Los Andes 24 17 22 27
18 Ferro Carril Oeste Ferro Carril 24 21 31 26
19 Dep. Riestra Dep. Riestra 24 29 24 25
20 Sportivo Estudiantes Sportivo 24 13 19 25
21 Boca Unidos Boca Unidos 24 23 31 25
22 All Boys All Boys 24 24 33 25
23 Nueva Chicago Nueva 24 20 31 25
24 Flandria Flandria 24 28 36 24
25 Dep. Santamarina Dep. 24 20 30 24
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
PRIMERA NACIONAL
Equipo PJ GF GC Puntos
1 Atletico Rafaela Atletico 38 65 26 77
2 Unión Santa Fe Unión Santa 38 49 38 69
3 San Martín San Juan Martín Juan 38 46 32 64
4 Belgrano Belgrano 38 53 37 59
5 Gimnasia Jujuy Gimnasia 38 40 41 54
6 Almirante Brown Almirante 38 32 28 52
7 Aldosivi Aldosivi 38 45 47 52
8 Boca Unidos Boca Unidos 38 43 46 52
9 Atl. Tucumán Atl. 38 44 41 51
10 Instituto Instituto 38 38 35 51
11 Deportivo Merlo Deportivo 38 32 37 51
12 Rosario Central Rosario 38 44 44 50
13 Patronato Patronato 38 41 43 50
14 Ferro Carril Oeste Ferro Carril 38 38 47 47
15 San Martín Tucumán Martín 38 33 41 45
16 Chacarita Juniors Chacarita 38 24 36 44
17 Defensa y Justicia Defensa 38 37 42 43
18 Indep. Rivadavia Indep. 38 44 49 40
19 Tiro Federal Rosario Tiro Federal 38 37 56 37
20 CAI CAI 38 38 57 34
TEMPORADA 2009/2010
PRIMERA NACIONAL
Equipo PJ GF GC Puntos
1 Olimpo Olimpo 38 50 24 71
2 Quilmes Quilmes 38 39 31 64
3 Atletico Rafaela Atletico 38 53 35 63
4 All Boys All Boys 38 45 37 63
5 Instituto Instituto 38 39 29 60
6 Belgrano Belgrano 38 47 41 57
7 San Martín San Juan Martín Juan 38 48 39 56
8 Gimnasia Jujuy Gimnasia 38 34 37 54
9 Unión Santa Fe Unión Santa 38 54 49 53
10 Defensa y Justicia Defensa 38 54 53 52
11 San Martín Tucumán Martín 38 39 41 50
12 Ferro Carril Oeste Ferro Carril 38 36 39 49
13 Boca Unidos Boca Unidos 38 42 48 48
14 Platense Platense 38 40 41 47
15 Indep. Rivadavia Indep. 38 47 58 47
16 Deportivo Merlo Deportivo 38 35 44 46
17 Tiro Federal Rosario Tiro Federal 38 52 53 44
18 CAI CAI 38 47 52 43
19 Aldosivi Aldosivi 38 44 54 42
20 Sportivo Italiano Sportivo 38 34 74 22
TEMPORADA 2008/2009
PRIMERA NACIONAL
Equipo PJ GF GC Puntos
1 Atl. Tucumán Atl. 38 59 30 74
2 Chacarita Juniors Chacarita 38 58 30 72
3 Atletico Rafaela Atletico 38 47 39 62
4 Belgrano Belgrano 38 36 29 62
5 Instituto Instituto 38 50 43 59
6 Aldosivi Aldosivi 38 32 33 57
7 Ferro Carril Oeste Ferro Carril 38 52 48 52
8 Quilmes Quilmes 38 39 41 51
9 All Boys All Boys 38 46 46 50
10 Tiro Federal Rosario Tiro Federal 38 45 46 50
11 Indep. Rivadavia Indep. 38 46 48 50
12 Talleres Córdoba Talleres 38 50 54 50
13 San Martín San Juan Martín Juan 38 46 41 49
14 Defensa y Justicia Defensa 38 47 47 49
15 Unión Santa Fe Unión Santa 38 48 52 49
16 Los Andes Los Andes 38 51 57 45
17 Olimpo Olimpo 38 39 59 40
18 Platense Platense 38 37 51 37
19 CAI CAI 38 35 45 36
20 Almagro Almagro 38 36 60 32
TEMPORADA 2007/2008
PRIMERA NACIONAL
Equipo PJ GF GC Puntos
1 San Martín Tucumán Martín 38 47 28 66
2 Godoy Cruz Godoy Cruz 38 54 41 65
3 Unión Santa Fe Unión Santa 38 52 43 56
4 Belgrano Belgrano 38 45 41 56
5 Chacarita Juniors Chacarita 38 46 45 56
6 Quilmes Quilmes 38 43 36 55
7 Tiro Federal Rosario Tiro Federal 38 44 36 54
8 Atletico Rafaela Atletico 38 49 44 53
9 CAI CAI 38 48 52 51
10 Ferro Carril Oeste Ferro Carril 38 40 44 51
11 Aldosivi Aldosivi 38 54 47 48
12 Indep. Rivadavia Indep. 38 50 51 47
13 Talleres Córdoba Talleres 38 48 64 46
14 Almagro Almagro 38 40 49 43
15 Instituto Instituto 38 32 46 43
16 Defensa y Justicia Defensa 38 32 49 43
17 Platense Platense 38 45 55 42
18 Almirante Brown Almirante 38 42 26 41
19 Ben Hur Ben Hur 38 29 46 38
20 Nueva Chicago Nueva 38 47 44 34

  USO DE MEMORIA  
8,453,512 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6625
Total Execution Time  0.6637
  CADENA URL  
/historico/Aldosivi
  GET DATOS  
$_GET['/historico/Aldosivi']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0179  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 = 'Aldosivi' 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.0147  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=5902 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=5902 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5902 AND type_rel = 2
0.0153  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 5902 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0149  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 (8231,17149,21681,29277,30996) ORDER BY n.cover_points DESC, update_date DESC
0.0156  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 = '5902' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0154  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 = '5902' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148  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=5902 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (75057,70412) 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.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 75057 AND teamId = 5902
0.0152  SELECT count(id) as num_players from rel_players WHERE league_id = 70412 AND teamId = 5902
0.0158  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 = 75057 WHERE rp.league_id = 75057 AND rp.teamId = 5902 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.0159  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 = 75057 WHERE rp.league_id = 75057 AND rp.teamId = 5902 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0157  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 = 75057 WHERE rp.league_id = 75057 AND rp.teamId = 5902 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151  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 = 5902 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0296  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 = 70827 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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.0155  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.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 `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.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 `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.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 `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 = 39647 AND t.round = 25 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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.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 `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.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 `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 = 3853 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157  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.0161  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.0162  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.0162  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.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 `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 = 12934 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0168  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 = 12933 AND t.round = 38 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 `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 = 12932 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0169  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 = 12931 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC