4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Almirante Brown Almirante 36 36 30 61
2 Argentino Agropecuario Argentino 36 46 36 59
3 San Martín Tucumán Martín 36 38 24 56
4 Estudiantes Río Cuarto Estudiantes 36 34 32 55
5 Def. Belgrano Def. 36 44 35 53
6 Gimnasia Mendoza Gimnasia 36 45 37 53
7 San Martín San Juan Martín Juan 36 44 38 53
8 Temperley Temperley 36 42 38 53
9 Club Atlético Güemes Club 36 37 34 53
10 Deportivo Morón Deportivo 36 38 37 53
11 Nueva Chicago Nueva 36 34 25 52
12 Def. Unidos Def. Unidos 36 30 31 47
13 Alvarado Alvarado 36 35 40 44
14 Patronato Patronato 36 39 44 42
15 All Boys All Boys 36 31 40 42
16 Guillermo Brown Guillermo 36 35 42 38
17 Almagro Almagro 36 26 36 37
18 San Telmo San Telmo 36 40 52 37
19 Flandria Flandria 36 33 56 34
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Belgrano Belgrano 36 48 23 79
2 Instituto Instituto 36 48 23 68
3 San Martín Tucumán Martín 36 45 21 66
4 Gimnasia Mendoza Gimnasia 36 41 20 64
5 All Boys All Boys 36 45 33 60
6 Estudiantes Río Cuarto Estudiantes 36 39 29 58
7 CA Estudiantes Estudiantes 36 33 27 57
8 Almagro Almagro 36 35 33 57
9 Indep. Rivadavia Indep. 36 45 34 56
10 Chaco For Ever Chaco Ever 36 38 28 55
11 Dep. Riestra Dep. Riestra 36 34 26 54
12 Def. Belgrano Def. 36 37 30 54
13 Deportivo Morón Deportivo 36 31 21 53
14 San Martín San Juan Martín Juan 36 50 42 51
15 Chacarita Juniors Chacarita 36 48 44 48
16 Ferro Carril Oeste Ferro Carril 36 32 34 47
17 Deportivo Madryn Deportivo 36 44 42 46
18 Atlanta Atlanta 36 33 32 46
19 Quilmes Quilmes 36 42 46 46
20 Dep. Maipú Dep. Maipú 36 39 32 45
21 Atlético Mitre SdE Atlético 36 36 37 45
22 Brown Adrogue Brown 36 39 39 44
23 Gimnasia Jujuy Gimnasia 36 38 50 44
24 Guillermo Brown Guillermo 36 30 43 43
25 Almirante Brown Almirante 36 38 43 42
26 Temperley Temperley 36 34 41 41
27 Club Atlético Güemes Club 36 28 35 39
28 San Telmo San Telmo 36 36 52 39
29 Atletico Rafaela Atletico 36 40 43 38
30 Argentino Agropecuario Argentino 36 25 30 38
31 Villa Dálmine Villa 36 36 48 38
32 Alvarado Alvarado 36 31 46 37
33 Tristán Suárez Tristán 36 37 45 35
34 Nueva Chicago Nueva 36 33 48 32
35 Flandria Flandria 36 30 49 31
36 Dep. Santamarina Dep. 36 29 58 29
37 Sacachispas Sacachispas 36 21 41 27
Ver
TEMPORADA 2020/2021
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
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Atlanta Atlanta 20 33 20 38
2 Estudiantes Río Cuarto Estudiantes 21 29 19 37
3 CA Estudiantes Estudiantes 21 31 25 36
4 Temperley Temperley 21 22 19 32
5 Deportivo Morón Deportivo 21 19 18 32
6 Ferro Carril Oeste Ferro Carril 21 20 20 31
7 Platense Platense 21 22 25 30
8 Argentino Agropecuario Argentino 21 23 19 29
9 San Martín San Juan Martín Juan 21 19 22 28
10 Belgrano Belgrano 21 26 25 27
11 Alvarado Alvarado 21 27 28 26
12 Guillermo Brown Guillermo 21 18 21 25
13 Indep. Rivadavia Indep. 20 26 28 24
14 Barracas Central Barracas 21 19 26 21
15 Atlético Mitre SdE Atlético 21 11 19 17
16 Nueva Chicago Nueva 21 16 27 17
17 San Martín Tucumán Martín 21 33 13 44
18 Def. Belgrano Def. 21 25 13 41
19 Sarmiento Sarmiento 20 31 21 34
20 Dep. Riestra Dep. Riestra 21 15 14 33
21 Tigre Tigre 20 24 21 28
22 Atletico Rafaela Atletico 21 27 30 28
23 Gimnasia Mendoza Gimnasia 20 20 20 27
24 Villa Dálmine Villa 21 19 18 26
25 Instituto Instituto 21 26 24 25
26 Brown Adrogue Brown 21 18 22 24
27 Quilmes Quilmes 21 19 24 24
28 Chacarita Juniors Chacarita 21 15 26 24
29 Almagro Almagro 21 13 20 23
30 All Boys All Boys 21 17 23 22
31 Dep. Santamarina Dep. 20 15 19 20
32 Gimnasia Jujuy Gimnasia 21 13 22 19
Ver
TEMPORADA 2018/2019
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
Ver
TEMPORADA 2017/2018
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
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Argentinos Juniors Argentinos 44 61 24 88
2 Chacarita Juniors Chacarita 44 57 40 77
3 Guillermo Brown Guillermo 44 53 30 75
4 Indep. Rivadavia Indep. 44 48 44 67
5 Brown Adrogue Brown 44 57 50 65
6 Instituto Instituto 44 58 51 63
7 All Boys All Boys 44 43 45 62
8 Dep. Santamarina Dep. 44 45 43 61
9 San Martín Tucumán Martín 44 62 54 61
10 Almagro Almagro 44 35 34 60
11 Ferro Carril Oeste Ferro Carril 44 51 44 60
12 Nueva Chicago Nueva 44 53 47 60
13 Los Andes Los Andes 44 47 50 59
14 Central Córdoba Central 44 57 49 58
15 Flandria Flandria 44 39 40 56
16 JU Gualeguaychu Gualeguaychu 44 50 66 55
17 Sportivo Estudiantes Sportivo 44 40 58 54
18 Gimnasia Jujuy Gimnasia 44 36 45 52
19 Douglas Haig Douglas Haig 44 36 49 50
20 Boca Unidos Boca Unidos 44 42 54 47
21 Villa Dálmine Villa 44 45 60 47
22 Atlético Paraná Atlético 44 34 58 38
23 Crucero del Norte Crucero 44 36 50 37
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Talleres Córdoba Talleres 21 31 11 49
2 Chacarita Juniors Chacarita 21 30 12 43
3 Gimnasia Jujuy Gimnasia 21 26 16 38
4 Boca Unidos Boca Unidos 21 28 19 38
5 Villa Dálmine Villa 21 35 28 33
6 Crucero del Norte Crucero 21 26 25 32
7 Nueva Chicago Nueva 21 32 27 30
8 Guillermo Brown Guillermo 21 31 29 30
9 Los Andes Los Andes 21 21 22 30
10 Brown Adrogue Brown 21 27 26 28
11 JU Gualeguaychu Gualeguaychu 21 25 26 28
12 Almagro Almagro 21 23 25 28
13 Dep. Santamarina Dep. 21 16 19 27
14 All Boys All Boys 21 30 28 26
15 Ferro Carril Oeste Ferro Carril 21 21 27 26
16 Sportivo Estudiantes Sportivo 21 17 25 24
17 Juventud Universitario Juventud 21 20 23 22
18 Central Córdoba Central 21 23 27 21
19 Douglas Haig Douglas Haig 21 20 24 20
20 Indep. Rivadavia Indep. 21 14 26 20
21 Atlético Paraná Atlético 21 16 32 19
22 Instituto Instituto 21 18 33 16
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Atl. Tucumán Atl. 42 69 31 85
2 Patronato Patronato 42 60 24 82
3 Ferro Carril Oeste Ferro Carril 42 44 37 67
4 Dep. Santamarina Dep. 42 54 40 66
5 Instituto Instituto 42 48 38 62
6 Villa Dálmine Villa 42 44 42 60
7 Atlético Paraná Atlético 42 50 46 58
8 Douglas Haig Douglas Haig 42 45 46 58
9 Sportivo Estudiantes Sportivo 42 47 44 56
10 Gimnasia Jujuy Gimnasia 42 35 43 55
11 Los Andes Los Andes 42 46 49 54
12 JU Gualeguaychu Gualeguaychu 42 43 47 54
13 Boca Unidos Boca Unidos 42 37 42 54
14 All Boys All Boys 42 38 37 53
15 Central Córdoba Central 42 37 44 51
16 Indep. Rivadavia Indep. 42 38 46 51
17 Guaraní A. Franco Guaraní 42 38 43 50
18 Chacarita Juniors Chacarita 42 49 62 50
19 Guillermo Brown Guillermo 42 43 50 48
20 Gimnasia Mendoza Gimnasia 42 37 53 48
21 Sportivo Belgrano Sportivo 42 36 50 40
22 Unión Mar del Plata Unión Plata 42 36 60 37
Ver
TEMPORADA 2013/2014
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
Ver
TEMPORADA 2012/2013
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
Ver
TEMPORADA 2011/2012
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
Ver
TEMPORADA 2010/2011
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
Ver
TEMPORADA 2009/2010
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
Ver
TEMPORADA 2008/2009
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
Ver
TEMPORADA 2007/2008
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,306,896 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.2508
Total Execution Time  0.2528
  CADENA URL  
/primera_b_nacional2023/grupo1/historico
  GET DATOS  
$_GET['/primera_b_nacional2023/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0018  SELECT type FROM routes WHERE alias = 'primera_b_nacional2023'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_b_nacional' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=192 AND type_rel = 3
0.0030  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 192 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0023  SELECT /*53 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 (1300740,1300585,1297543,1297675,1290706) ORDER BY n.cover_points DESC, update_date DESC
0.0021  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 192 AND group_code = 1 and tables = 1 AND year <= 2023 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 70716 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0044  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 = 61653 AND t.round = 37 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0048  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.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 `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 = 50509 AND t.round = 21 ORDER BY team.conference ASC,t.position 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 `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 = 44242 AND t.round = 25 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 `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.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 `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 = 33440 AND t.round = 46 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 `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 = 20209 AND t.round = 21 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 `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 = 9170 AND t.round = 42 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 `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.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 = 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.0040  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.0041  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.0050  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.0047  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.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 `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.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-23 18:00:16' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-23 18:00:16' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-23 18:00:16' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-23 18:00:16' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0035  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_b_nacional' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0622  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2023 e ON e.player_id = p.id AND e.league_id = 70716 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 70716 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0442  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2023 e ON e.player_id = p.id AND e.league_id = 70716 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 70716 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0040  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2023 e ON e.player_id = p.id AND e.league_id = 70716 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 70716 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0047  SELECT *,(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 = 70716 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC