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

Quilmes

Entrenador: Darío Franco

Temporada 2020/2021
TEMPORADA 2020/2021
PRIMERA NACIONAL
Equipo PJ GF GC Puntos
1 Tigre Tigre 32 50 25 60
2 Quilmes Quilmes 32 45 31 59
3 Almirante Brown Almirante 32 40 32 59
4 San Martín Tucumán Martín 32 34 18 57
5 Argentino Agropecuario Argentino 32 36 26 53
6 Belgrano Belgrano 32 35 24 52
7 Gimnasia Mendoza Gimnasia 32 34 35 44
8 Alvarado Alvarado 32 32 30 42
9 Temperley Temperley 32 29 34 41
10 Atlanta Atlanta 32 27 34 39
11 CA Estudiantes Estudiantes 32 29 28 38
12 Atlético Mitre SdE Atlético 32 37 44 37
13 Dep. Maipú Dep. Maipú 32 27 38 36
14 Estudiantes Río Cuarto Estudiantes 32 23 26 34
15 Dep. Riestra Dep. Riestra 32 30 36 34
16 Chacarita Juniors Chacarita 32 29 50 27
17 Nueva Chicago Nueva 32 23 49 21
18 Barracas Central Barracas 34 43 33 58
19 Ferro Carril Oeste Ferro Carril 34 49 28 57
20 Indep. Rivadavia Indep. 34 47 39 56
21 Deportivo Morón Deportivo 34 36 34 53
22 Club Atlético Güemes Club 34 38 31 52
23 Gimnasia Jujuy Gimnasia 34 34 29 52
24 Brown Adrogue Brown 34 41 40 47
25 Tristán Suárez Tristán 34 43 42 45
26 Almagro Almagro 34 41 40 43
27 Def. Belgrano Def. 34 27 32 42
28 Instituto Instituto 34 33 39 40
29 All Boys All Boys 34 31 32 39
30 San Martín San Juan Martín Juan 34 37 39 38
31 Villa Dálmine Villa 34 25 30 38
32 Atletico Rafaela Atletico 34 34 37 37
33 Guillermo Brown Guillermo 34 25 32 37
34 San Telmo San Telmo 34 34 50 37
35 Dep. Santamarina Dep. 34 23 34 33
TEMPORADA 2019/2020
PRIMERA NACIONAL GRUPO 2
Equipo PJ GF GC Puntos
1 San Martín San Juan Martín Juan 7 5 1 15
2 Barracas Central Barracas 7 7 4 14
3 Belgrano Belgrano 7 8 3 12
4 Alvarado Alvarado 7 12 8 9
5 Atlético Mitre SdE Atlético 7 8 9 8
6 Guillermo Brown Guillermo 7 6 7 6
7 Nueva Chicago Nueva 7 6 12 5
8 Indep. Rivadavia Indep. 7 3 11 4
9 Quilmes Quilmes 7 9 7 13
10 Instituto Instituto 7 11 9 12
11 Almagro Almagro 7 7 5 12
12 Dep. Santamarina Dep. 7 11 10 10
13 Brown Adrogue Brown 7 6 5 9
14 Gimnasia Jujuy Gimnasia 7 9 9 8
15 All Boys All Boys 7 3 8 7
16 Chacarita Juniors Chacarita 7 6 9 5
TEMPORADA 2018/2019
PRIMERA NACIONAL
Equipo PJ GF GC Puntos
1 Sarmiento Sarmiento 24 32 14 46
2 Arsenal de Sarandí Arsenal 24 36 19 46
3 Nueva Chicago Nueva 24 32 25 42
4 Almagro Almagro 24 26 21 40
5 Platense Platense 24 30 18 39
6 Central Córdoba Central 24 27 24 37
7 Gimnasia Mendoza Gimnasia 24 28 31 37
8 Indep. Rivadavia Indep. 24 25 19 36
9 Brown Adrogue Brown 24 20 17 36
10 Ferro Carril Oeste Ferro Carril 24 33 32 35
11 Atlético Mitre SdE Atlético 24 27 30 35
12 Argentino Agropecuario Argentino 24 16 13 34
13 Villa Dálmine Villa 24 30 25 33
14 Temperley Temperley 24 26 27 31
15 Deportivo Morón Deportivo 24 21 25 30
16 Def. Belgrano Def. 24 20 24 29
17 Atletico Rafaela Atletico 24 23 25 26
18 Quilmes Quilmes 24 24 27 26
19 Gimnasia Jujuy Gimnasia 24 22 27 25
20 Guillermo Brown Guillermo 24 19 24 25
21 Olimpo Olimpo 24 24 36 25
22 Instituto Instituto 24 26 32 24
23 Dep. Santamarina Dep. 24 21 29 24
24 Chacarita Juniors Chacarita 24 17 30 24
25 Los Andes Los Andes 24 13 24 20
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
TORNEO DE TRANSICIÓN
Equipo PJ GF GC Puntos
1 Racing Club Racing Club 19 30 16 41
2 River Plate River Plate 19 34 13 39
3 Lanús Lanús 19 28 23 35
4 Independiente Independient 19 31 29 33
5 Boca Juniors Boca Juniors 19 25 23 31
6 Estudiantes La Plata Estudiantes 19 23 23 31
7 Tigre Tigre 19 30 26 26
8 San Lorenzo San Lorenzo 19 26 22 26
9 Arsenal de Sarandí Arsenal 19 27 25 26
10 Belgrano Belgrano 19 26 26 25
11 Vélez Sarsfield Vélez 19 21 22 25
12 Newell's Old Boys Newell's 19 21 24 25
13 Atletico Rafaela Atletico 19 25 29 25
14 Gimnasia La Plata Gimnasia 19 16 15 24
15 Rosario Central Rosario 19 21 28 21
16 Godoy Cruz Godoy Cruz 19 31 39 21
17 Banfield Banfield 19 25 25 20
18 Defensa y Justicia Defensa 19 19 30 20
19 Olimpo Olimpo 19 15 22 19
20 Quilmes Quilmes 19 17 31 12
TEMPORADA 2012/2013
CLAUSURA ARGENTINA
Equipo PJ GF GC Puntos
1 Newell's Old Boys Newell's 19 40 21 38
2 River Plate River Plate 19 28 22 35
3 Lanús Lanús 19 26 14 33
4 San Lorenzo San Lorenzo 19 26 16 32
5 Quilmes Quilmes 19 28 22 31
6 Racing Club Racing Club 19 24 17 29
7 Godoy Cruz Godoy Cruz 19 23 16 29
8 Arsenal de Sarandí Arsenal 19 25 22 29
9 San Martín San Juan Martín Juan 19 31 28 26
10 Belgrano Belgrano 19 14 13 23
11 Atletico Rafaela Atletico 19 21 23 23
12 Independiente Independient 19 16 17 22
13 Tigre Tigre 19 22 30 21
14 Vélez Sarsfield Vélez 19 18 20 20
15 Estudiantes La Plata Estudiantes 19 15 19 20
16 All Boys All Boys 19 15 24 20
17 Colón Colón 19 20 30 20
18 Argentinos Juniors Argentinos 19 13 21 18
19 Boca Juniors Boca Juniors 19 13 29 18
20 Unión Santa Fe Unión Santa 19 17 31 17
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
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
TEMPORADA 2006/2007
CLAUSURA ARGENTINA
Equipo PJ GF GC Puntos
1 San Lorenzo San Lorenzo 19 34 17 45
2 Boca Juniors Boca Juniors 19 38 20 39
3 Estudiantes La Plata Estudiantes 19 28 17 37
4 River Plate River Plate 19 26 17 33
5 Arsenal de Sarandí Arsenal 19 31 24 30
6 Lanús Lanús 19 24 19 28
7 Colón Colón 19 28 24 28
8 Argentinos Juniors Argentinos 19 21 17 26
9 Vélez Sarsfield Vélez 19 22 26 26
10 Godoy Cruz Godoy Cruz 19 24 22 25
11 Independiente Independient 19 23 24 25
12 Rosario Central Rosario 19 17 21 24
13 Racing Club Racing Club 19 28 30 23
14 Newell's Old Boys Newell's 19 22 30 22
15 Nueva Chicago Nueva 19 19 28 21
16 Banfield Banfield 19 22 30 19
17 Belgrano Belgrano 19 24 27 18
18 Gimnasia La Plata Gimnasia 19 19 28 17
19 Gimnasia Jujuy Gimnasia 19 11 22 17
20 Quilmes Quilmes 19 18 36 12
TEMPORADA 2005/2006
CLAUSURA ARGENTINA
Equipo PJ GF GC Puntos
1 Boca Juniors Boca Juniors 19 37 14 43
2 Lanús Lanús 19 26 15 35
3 River Plate River Plate 19 39 24 34
4 Gimnasia Jujuy Gimnasia 19 26 16 33
5 Gimnasia La Plata Gimnasia 19 31 22 32
6 Newell's Old Boys Newell's 19 27 18 31
7 Banfield Banfield 19 28 22 31
8 San Lorenzo San Lorenzo 19 15 14 28
9 Olimpo Olimpo 19 22 22 26
10 Vélez Sarsfield Vélez 19 21 18 25
11 Estudiantes La Plata Estudiantes 19 25 31 24
12 Independiente Independient 19 18 18 23
13 Rosario Central Rosario 19 15 17 23
14 Argentinos Juniors Argentinos 19 26 28 22
15 Arsenal de Sarandí Arsenal 19 17 20 22
16 Colón Colón 19 19 26 20
17 Quilmes Quilmes 19 16 28 20
18 Racing Club Racing Club 19 14 24 19
19 Instituto Instituto 19 16 37 13
20 Tiro Federal Rosario Tiro Federal 19 15 39 12
TEMPORADA 2004/2005
CLAUSURA ARGENTINA
Equipo PJ GF GC Puntos
1 Vélez Sarsfield Vélez 19 32 14 39
2 Banfield Banfield 19 25 16 33
3 Racing Club Racing Club 19 25 17 32
4 Estudiantes La Plata Estudiantes 19 28 23 31
5 Rosario Central Rosario 19 27 24 31
6 Arsenal de Sarandí Arsenal 19 27 22 30
7 Gimnasia La Plata Gimnasia 19 25 25 29
8 Lanús Lanús 19 36 27 28
9 Instituto Instituto 19 32 30 28
10 River Plate River Plate 19 31 29 27
11 Colón Colón 19 30 23 26
12 Independiente Independient 19 29 26 26
13 Olimpo Olimpo 19 18 22 26
14 Newell's Old Boys Newell's 19 22 21 24
15 Boca Juniors Boca Juniors 19 26 30 22
16 San Lorenzo San Lorenzo 19 23 29 22
17 Argentinos Juniors Argentinos 19 28 30 21
18 Quilmes Quilmes 19 16 23 20
19 Almagro Almagro 19 25 44 16
20 Huracán Tres Arroyos Huracán 19 12 42 5
TEMPORADA 2003/2004
CLAUSURA ARGENTINA
Equipo PJ GF GC Puntos
1 River Plate River Plate 19 41 21 40
2 Boca Juniors Boca Juniors 19 34 17 36
3 Talleres Córdoba Talleres 19 30 19 35
4 Banfield Banfield 19 27 17 32
5 Vélez Sarsfield Vélez 19 31 21 31
6 Quilmes Quilmes 19 21 16 29
7 Arsenal de Sarandí Arsenal 19 21 22 29
8 Racing Club Racing Club 19 29 29 28
9 San Lorenzo San Lorenzo 19 18 16 26
10 Atletico Rafaela Atletico 19 25 24 26
11 Colón Colón 19 20 26 25
12 Newell's Old Boys Newell's 19 28 25 22
13 Independiente Independient 19 21 27 22
14 Estudiantes La Plata Estudiantes 19 19 29 21
15 Lanús Lanús 19 21 27 20
16 Olimpo Olimpo 19 18 28 19
17 Gimnasia La Plata Gimnasia 19 21 26 17
18 Nueva Chicago Nueva 19 18 27 17
19 Chacarita Juniors Chacarita 19 21 34 17
20 Rosario Central Rosario 19 16 29 13

  USO DE MEMORIA  
8,546,312 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1664
Total Execution Time  0.1677
  CADENA URL  
/historico/Quilmes/2021
  GET DATOS  
$_GET['/historico/Quilmes/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0032  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 = 'Quilmes' 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.0020  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=3066 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=3066 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=3066 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041  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 = 66514
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3066 AND type_rel = 2
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 3066 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  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 (2923,3001,6988,7011,9693) ORDER BY n.cover_points DESC, update_date DESC
0.0034  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 = '3066' ORDER BY l.year DESC,cat.coefficient DESC
0.0031  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 = '3066' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0027  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 = '3066' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 66514 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026  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=3066 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (66514,66245,49506) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 66514 AND teamId = 3066
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 66245 AND teamId = 3066
0.0094  SELECT count(id) as num_players from rel_players WHERE league_id = 49506 AND teamId = 3066
0.0040  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 = 60153 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  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 = '3066' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '3066' and rp.type = 4
0.0022  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 = '3066' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0018  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '3066' and rp.type = 4
0.0040  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 = 60153 WHERE rp.league_id = 60153 AND rp.teamId = 3066 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.0035  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 = 60153 WHERE rp.league_id = 60153 AND rp.teamId = 3066 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 = 60153 WHERE rp.league_id = 60153 AND rp.teamId = 3066 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033  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 = 3066 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0042  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 = 60153 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.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 `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 = 66510 AND t.round = 7 ORDER BY team.conference ASC,t.position 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 = 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.0031  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 = 3442 AND t.round = 19 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 = 3841 AND t.round = 19 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 = 8376 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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.0025  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.0028  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.0030  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.0027  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
0.0025  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 = 8391 AND t.round = 19 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 `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 = 8393 AND t.round = 19 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 `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 = 8395 AND t.round = 19 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 `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 = 8397 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC