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

Guillermo Brown

Entrenador: Arnaldo Sialle

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 1
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
TEMPORADA 2021/2022
PRIMERA NACIONAL
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
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
PRIMERA NACIONAL
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
TEMPORADA 2015/2016
PRIMERA NACIONAL
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
TEMPORADA 2014/2015
PRIMERA NACIONAL
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
TEMPORADA 2013/2014
ARGENTINO A
Equipo PJ GF GC Puntos
1 Tiro Federal Rosario Tiro Federal 22 30 20 35
2 Guaraní A. Franco Guaraní 22 19 20 35
3 San Martín Tucumán Martín 22 21 16 34
4 JU Gualeguaychu Gualeguaychu 22 22 19 34
5 Central Córdoba Central 22 23 23 31
6 San Jorge Tucumán Jorge 22 22 23 31
7 Juventud Antoniana Juventud 22 21 17 30
8 Libertad Sunchales Libertad 22 22 19 30
9 Central Norte Central 22 26 27 26
10 Gimnasia Concepción Gimnasia 22 25 36 25
11 Gimnasia y Tiro Gimnasia 22 26 30 21
12 Chaco For Ever Chaco Ever 22 24 31 21
13 Dep. Santamarina Dep. 22 33 21 45
14 Juventud Universitario Juventud 22 35 20 38
15 Defensores Belgrano VR Defensores 22 34 23 37
16 Guillermo Brown Guillermo 22 31 24 33
17 CAI CAI 22 37 33 33
18 Cipolletti Cipolletti 22 29 25 32
19 Dep. Maipú Dep. Maipú 22 24 32 29
20 Unión Mar del Plata Unión Plata 22 26 27 28
21 Alvarado Alvarado 22 13 16 27
22 Sportivo Estudiantes Sportivo 22 28 32 27
23 Racing Olavarría Racing 22 22 37 18
24 Rivadavia Lincoln Rivadavia 22 18 40 15
TEMPORADA 2012/2013
ARGENTINO A
Equipo PJ GF GC Puntos
1 Talleres Córdoba Talleres 24 42 23 46
2 Gimnasia y Tiro Gimnasia 24 36 26 42
3 San Martín Tucumán Martín 24 29 22 37
4 Sportivo Belgrano Sportivo 24 37 28 36
5 San Jorge Tucumán Jorge 24 25 35 36
6 Juventud Antoniana Juventud 24 20 18 35
7 Central Norte Central 24 33 29 33
8 Central Córdoba Central 24 32 28 33
9 Libertad Sunchales Libertad 24 22 28 29
10 Tiro Federal Rosario Tiro Federal 24 20 24 27
11 Guaraní A. Franco Guaraní 24 24 29 23
12 Alumni Villa Maria Alumni Villa 24 17 29 20
13 Racing Córdoba Racing 24 18 36 18
14 Dep. Santamarina Dep. 22 28 18 39
15 Juventud Universitario Juventud 22 28 23 35
16 Dep. Maipú Dep. Maipú 22 31 27 33
17 Racing Olavarría Racing 22 33 28 30
18 Gimnasia Conce… Gimnasia 22 26 27 30
19 Defensores Belgrano VR Defensores 22 19 22 30
20 Rivadavia Lincoln Rivadavia 22 32 36 29
21 Cipolletti Cipolletti 22 27 26 28
22 Alvarado Alvarado 22 20 21 28
23 Unión Mar del Plata Unión Plata 22 24 30 28
24 Guillermo Brown Guillermo 22 25 33 27
25 Sportivo Desamparados Sportivo 22 26 28 25
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
ARGENTINO A GRUPO 2
Equipo PJ GF GC Puntos
1 Guillermo Brown Guillermo 8 16 5 19
2 Central Norte Central 8 12 10 16
3 Libertad Sunchales Libertad 8 13 12 11
4 Unión Mar del Plata Unión Plata 8 12 11 11
5 Sportivo Belgrano Sportivo 8 8 8 11
6 Unión Sunchales Unión 8 12 11 10
7 Sportivo Desamparados Sportivo 8 7 10 9
8 Talleres Córdoba Talleres 8 10 13 8
9 Huracán Tres Arroyos Huracán 8 6 16 4
TEMPORADA 2009/2010
ARGENTINO A GRUPO 1
Equipo PJ GF GC Puntos
1 Cipolletti Cipolletti 16 21 16 27
2 Huracán Tres Arroyos Huracán 16 23 13 25
3 Rivadavia Lincoln Rivadavia 16 15 13 23
4 Dep. Santamarina Dep. 16 15 16 23
5 Unión Mar del Plata Unión Plata 16 22 24 23
6 Villa Mitre Bahia Blanca Villa Mitre 16 18 19 19
7 Juventud Pergamino Juventud 16 18 23 15
8 Guillermo Brown Guillermo 16 16 30 12
9 Crucero del Norte Crucero 16 22 13 35
10 Unión Sunchales Unión 16 28 14 32
11 Patronato Patronato 16 20 13 26
12 Libertad Sunchales Libertad 16 17 14 26
13 Sportivo Belgrano Sportivo 16 12 15 19
14 Gimnasia Concepción Gimnasia 16 11 14 19
15 9 de Julio Rafaela Julio 16 17 26 14
16 Ben Hur Ben Hur 16 12 24 9
17 Dep. Maipú Dep. Maipú 16 24 17 30
18 Juventud Antoniana Juventud 16 18 14 27
19 Central Córdoba Central 16 20 20 26
20 Talleres Córdoba Talleres 16 24 16 25
21 Juventud Universitario Juventud 16 26 25 24
22 Racing Córdoba Racing 16 17 22 20
23 Sportivo Desamparados Sportivo 16 13 21 16
24 Estudiantes Río Cuarto Estudiantes 16 13 15 13
25 Alumni Villa Maria Alumni Villa 16 11 16 12

  USO DE MEMORIA  
7,980,688 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6569
Total Execution Time  0.6581
  CADENA URL  
/historico/Guillermo-Brown
  GET DATOS  
$_GET['/historico/Guillermo-Brown']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0135  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 = 'Guillermo-Brown' 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.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=5904 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=5904 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=5904 AND type_rel = 2
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 5904 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0127  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 (40870,87334,113687,208448,254015) ORDER BY n.cover_points DESC, update_date DESC
0.0130  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 = '5904' ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '5904' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '5904' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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=5904 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0125  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) 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.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 75057 AND teamId = 5904
0.0127  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 = '5904' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '5904' and rp.type = 4
0.0127  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 = '5904' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0125  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '5904' and rp.type = 4
0.0140  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 = 5904 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.0138  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 = 5904 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134  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 = 5904 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 = 5904 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0253  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.0255  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.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 `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.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 `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.0128  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.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 `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.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 `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.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 `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.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 `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.0127  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 = 3987 AND t.round = 14 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 = 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.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 = 2548 AND t.round = 22 ORDER BY team.conference 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 `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 = 2003 AND t.round = 26 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 = 16541 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 16543 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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 = 16557 AND t.round = 17 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 `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 = 16559 AND t.round = 5 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 `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 = 16546 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC