4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Aravaca
TEMPORADA 2023/2024
PREFERENTE MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 CF San Agustín Agustín 6 9 4 14
2 Moratalaz Moratalaz 6 9 5 12
3 Aravaca Aravaca 6 13 6 11
4 Las Rozas B Las Rozas B 6 11 6 11
5 Vicálvaro Vicálvaro 6 14 8 10
6 Sporting Hortaleza Sporting 6 15 12 10
7 CD San Fernando Fernando 6 11 8 10
8 Cala Pozuelo Cala Pozuelo 6 6 6 9
9 Unión Zona Norte Unión Zona 6 6 4 8
10 AD Torrejon CF B Torrejon 6 7 7 8
11 Coslada Coslada 6 10 11 8
12 Robledo Robledo 6 8 11 8
13 Colmenar Viejo Colmenar 6 9 8 6
14 EF Concepción A Concepción 6 7 8 6
15 CD Moraleja Futbol Moraleja 6 10 11 5
16 San Sebastián Reyes B Sebastián 6 5 9 4
17 Unión Valdebernardo Unión 6 7 20 3
18 Alameda de Osuna Alameda 6 2 15 0
TEMPORADA 2022/2023
PREFERENTE MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 CDF Tres Cantos Tres Cantos 34 72 32 69
2 Villanueva del Pardillo Villanueva 34 57 35 60
3 CF San Agustín Agustín 34 55 34 59
4 Unión Zona Norte Unión Zona 34 66 52 58
5 Moratalaz Moratalaz 34 63 58 56
6 Aravaca Aravaca 34 62 42 55
7 CD Moraleja Futbol Moraleja 34 48 54 48
8 Vicálvaro Vicálvaro 34 53 54 47
9 Las Rozas B Las Rozas B 34 39 34 46
10 EF Concepción A Concepción 34 31 45 45
11 CD Los Yébenes-San Bruno Yébenes-San 34 43 50 43
12 Colmenar Viejo Colmenar 34 37 54 41
13 AD Torrejon CF B Torrejon 34 54 62 39
14 San Sebastián Reyes B Sebastián 34 46 60 39
15 Rayo Ciudad Alcobendas Rayo Ciudad 34 47 53 38
16 CD Electrocor CF Electrocor 34 55 61 36
17 Complutense Alcala Complutense 34 37 54 34
18 Periso CF Periso CF 34 39 70 31
TEMPORADA 2021/2022
PREFERENTE MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 CD Canillas CD Canillas 34 50 33 58
2 CUC Villalba Villalba 34 56 41 57
3 San Sebastián Reyes B Sebastián 34 54 39 56
4 Villanueva del Pardillo Villanueva 34 63 41 55
5 EF Concepción A Concepción 34 48 33 55
6 Colmenar Viejo Colmenar 34 66 55 52
7 CF San Agustín Agustín 34 42 38 52
8 CD Moraleja Futbol Moraleja 34 47 41 49
9 Periso CF Periso CF 34 50 55 49
10 Aravaca Aravaca 34 55 50 48
11 Unión Zona Norte Unión Zona 34 53 48 46
12 Moratalaz B Moratalaz B 34 60 60 45
13 Alcobendas Alcobendas 34 40 52 44
14 Coslada Coslada 34 52 52 44
15 CD San Fernando Fernando 34 46 44 42
16 Sporting Hortaleza Sporting 34 36 54 38
17 DAV Santa Ana Santa 34 32 65 28
18 AD Fundación Fundación 34 39 88 17
TEMPORADA 2020/2021
PREFERENTE MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 Galapagar Galapagar 19 44 16 45
2 CDF Tres Cantos Tres Cantos 19 41 15 45
3 CF San Agustín Agustín 19 35 19 35
4 Alcobendas Alcobendas 19 33 23 35
5 CD Moraleja Futbol Moraleja 19 34 22 34
6 Colmenar Viejo Colmenar 19 33 30 34
7 Aravaca Aravaca 19 39 20 32
8 San Sebastián Reyes B Sebastián 19 32 30 28
9 CD Canillas CD Canillas 19 28 22 27
10 Periso CF Periso CF 19 26 22 27
11 CUC Villalba Villalba 19 23 23 27
12 EF Concepción A Concepción 19 25 24 26
13 Sporting Hortaleza Sporting 19 31 32 26
14 CD Avance CD Avance 19 22 24 24
15 Rayo Ciudad Alcobendas Rayo Ciudad 19 23 21 23
16 AD Torrejon CF B Torrejon 19 21 34 18
17 Barrio Pilar Barrio Pilar 19 18 37 12
18 CD San Roque EFF Roque 19 30 48 11
19 Dosa Dosa 19 22 53 11
20 Atletico Villalba Atletico 19 10 55 4
TEMPORADA 2019/2020
PREFERENTE MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 Complutense Alcala Complutense 23 37 23 46
2 Villanueva del Pardillo Villanueva 23 32 19 42
3 CD San Roque EFF Roque 23 34 28 42
4 CD Canillas CD Canillas 23 23 18 39
5 Periso CF Periso CF 23 40 24 37
6 CF San Agustín Agustín 23 39 27 37
7 Alcobendas Alcobendas 23 25 21 34
8 CDF Tres Cantos Tres Cantos 23 32 29 34
9 Galapagar Galapagar 23 33 23 33
10 Atletico Villalba Atletico 23 35 32 33
11 CD Moraleja Futbol Moraleja 23 28 25 33
12 Aravaca Aravaca 23 28 27 29
13 Rayo Ciudad Alcobendas Rayo Ciudad 23 20 23 26
14 Sporting Hortaleza Sporting 23 23 32 26
15 AD Torrejon CF B Torrejon 23 25 38 18
16 EF Concepción A Concepción 23 22 44 17
17 Dosa Dosa 23 22 43 16
18 Barrio Pilar Barrio Pilar 23 15 37 16
TEMPORADA 2018/2019
PREFERENTE MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 Moratalaz Moratalaz 34 51 27 68
2 AD Torrejón CF Torrejón 34 46 25 63
3 Galapagar Galapagar 34 53 32 61
4 EF Concepción A Concepción 34 45 30 59
5 Alcobendas Alcobendas 34 48 36 55
6 Villanueva del Pardillo Villanueva 34 54 42 54
7 CD Moraleja Futbol Moraleja 34 45 37 51
8 Aravaca Aravaca 34 54 54 51
9 Complutense Alcala Complutense 34 46 42 47
10 Coslada Coslada 34 43 43 44
11 Sporting Hortaleza Sporting 34 56 61 44
12 CD San Roque EFF Roque 34 36 47 42
13 Periso CF Periso CF 34 38 45 40
14 Torrelodones Torrelodones 34 41 45 38
15 Barrio Pilar Barrio Pilar 34 31 43 38
16 San Agustin Guadalix B Agustin 34 33 46 35
17 CUC Villalba Villalba 34 25 56 34
18 Colmenar Viejo Colmenar 34 19 53 14
TEMPORADA 2017/2018
PREFERENTE MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 Las Rozas Las Rozas 34 72 29 79
2 CD Canillas CD Canillas 34 63 34 62
3 Villanueva del Pardillo Villanueva 34 51 29 60
4 Periso CF Periso CF 34 53 46 57
5 AD Torrejón CF Torrejón 34 53 45 57
6 Galapagar Galapagar 34 53 43 54
7 Aravaca Aravaca 34 44 36 54
8 CUC Villalba Villalba 34 41 38 46
9 Coslada Coslada 34 42 43 46
10 Torrelodones Torrelodones 34 39 48 45
11 CD San Roque EFF Roque 34 33 39 43
12 EF Concepción A Concepción 34 46 61 41
13 Complutense Alcala Complutense 34 45 49 41
14 Alcobendas Alcobendas 34 42 51 40
15 Dosa Dosa 34 55 59 38
16 San Sebastián Reyes B Sebastián 34 50 47 37
17 RSD Alcalá B Alcalá 34 32 71 29
18 Camarma Camarma 34 31 77 18
TEMPORADA 2016/2017
TERCERA DIVISIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 Atlético B Atlético B 38 63 40 73
2 Unión Adarve Unión 38 55 41 66
3 Paracuellos Antamira Paracuellos 38 49 28 63
4 CD Móstoles Móstoles 38 62 41 62
5 Leganés B Leganés B 38 57 45 62
6 Getafe B Getafe B 38 54 35 60
7 Atlético de Pinto Atlético 38 36 30 58
8 RSD Alcalá RSD Alcalá 38 36 28 57
9 Internacional de Madrid Internaciona 38 52 40 56
10 DAV Santa Ana Santa 38 43 54 53
11 SAD Villaverde Villaverde 38 41 52 49
12 CD San Fernando Fernando 38 44 43 49
13 Alcorcón B Alcorcón B 38 40 46 48
14 CF Pozuelo CF Pozuelo 38 40 35 48
15 Rayo Vallecano B Rayo 38 57 49 47
16 Trival Valderas Trival 38 44 48 46
17 Alcobendas Alcobendas 38 29 37 44
18 Aravaca Aravaca 38 36 64 38
19 Villanueva del Pardillo Villanueva 38 21 57 31
20 AD Parla AD Parla 38 21 67 19
TEMPORADA 2015/2016
TERCERA DIVISIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 UD Sanse UD Sanse 38 68 26 81
2 CDA Navalcarnero Navalcarnero 38 76 42 72
3 CF Pozuelo CF Pozuelo 38 52 34 69
4 Atlético B Atlético B 38 48 29 64
5 CD San Fernando Fernando 38 58 45 60
6 Unión Adarve Unión 38 55 38 59
7 Atlético de Pinto Atlético 38 42 36 57
8 RSD Alcalá RSD Alcalá 38 53 49 57
9 Trival Valderas Trival 38 44 35 57
10 Alcorcón B Alcorcón B 38 57 53 55
11 CD Móstoles Móstoles 38 48 40 52
12 Paracuellos Antamira Paracuellos 38 47 40 50
13 Aravaca Aravaca 38 43 48 47
14 AD Parla AD Parla 38 41 50 47
15 Rayo Vallecano B Rayo 38 44 42 46
16 Internacional de Madrid Internaciona 38 33 43 43
17 CD Colonia Moscardó Colonia 38 36 55 34
18 Puerta Bonita Puerta 38 40 56 33
19 CD Lugo Fuenlabrada Lugo 38 31 57 32
20 CUC Villalba Villalba 38 19 117 2
TEMPORADA 2014/2015
PREFERENTE MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 Aravaca Aravaca 34 60 36 64
2 CUC Villalba Villalba 34 50 38 59
3 Siete Picos Colmenar Siete Picos 34 63 48 58
4 Complutense Alcala Complutense 34 55 41 58
5 Las Rozas Las Rozas 34 59 43 57
6 Periso CF Periso CF 34 54 47 53
7 Coslada Coslada 34 53 52 52
8 CDF Tres Cantos Tres Cantos 34 56 50 51
9 Galapagar Galapagar 34 50 44 49
10 Alameda de Osuna Alameda 34 53 53 47
11 Moratalaz Moratalaz 34 51 47 45
12 CD Canillas CD Canillas 34 45 42 45
13 Vicálvaro Vicálvaro 34 39 42 43
14 San Sebastián Reyes B Sebastián 34 41 52 42
15 Dosa Dosa 34 37 57 35
16 CF Pozuelo B Pozuelo 34 43 60 31
17 RSD Alcalá B Alcalá 34 36 64 28
18 CD San Roque EFF Roque 34 39 68 27
TEMPORADA 2013/2014
TERCERA DIVISIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 Trival Valderas Trival 42 65 33 83
2 Rayo Vallecano B Rayo 42 86 50 81
3 Unión Adarve Unión 42 60 30 81
4 UD Sanse UD Sanse 42 68 31 80
5 Internacional de Madrid Internaciona 42 69 46 80
6 CF Pozuelo CF Pozuelo 42 60 37 71
7 Rayo Majadahonda Rayo 42 71 57 69
8 CD San Fernando Fernando 42 58 40 67
9 RSD Alcalá RSD Alcalá 42 50 32 67
10 AD Parla AD Parla 42 52 50 63
11 Paracuellos Antamira Paracuellos 42 46 49 56
12 Colmenar Viejo Colmenar 42 63 70 55
13 Alcorcón B Alcorcón B 42 65 67 51
14 Atlético de Madrid C Atlético 42 56 62 50
15 Atlético de Pinto Atlético 42 58 61 50
16 AD Torrejón CF Torrejón 42 56 64 50
17 CUC Villalba Villalba 42 37 56 45
18 Aravaca Aravaca 42 44 65 42
19 Real Aranjuez CF Real 42 43 82 34
20 RCD Carabanchel Carabanchel 42 33 68 31
21 Vicálvaro Vicálvaro 42 22 65 28
22 CD Los Yébenes-San Bruno Yébenes-San 42 43 90 28
TEMPORADA 2012/2013
PREFERENTE MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 Aravaca Aravaca 34 66 28 80
2 AD Torrejón CF Torrejón 34 63 36 65
3 Las Rozas Cf Rozas 34 56 37 63
4 Alcobendas Alcobendas 34 58 34 61
5 Juventud Sanse B Juventud 34 50 45 54
6 CD Canillas CD Canillas 34 57 49 49
7 RSD Alcalá B Alcalá 34 44 39 47
8 Dosa Dosa 34 58 61 45
9 At. Leones Castilla Leones 34 37 48 45
10 Coslada Coslada 34 33 36 44
11 Unión Adarve B Unión 34 41 46 44
12 CF Pozuelo B Pozuelo 34 54 63 43
13 Moratalaz Moratalaz 34 42 46 42
14 Periso CF Periso CF 34 43 46 41
15 Torrelodones Cf Torrelodones 34 55 54 37
16 Ef Madrid Oeste Madrid Oeste 34 38 49 31
17 CD La Resaca Resaca 34 38 80 29
18 CF Gandarío-Sanse Gandarío-Sa 34 40 76 25
TEMPORADA 2011/2012
PREFERENTE MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 CUC Villalba Villalba 34 69 25 74
2 DAV Santa Ana Santa 34 65 28 73
3 CD San Fernando Fernando 34 69 26 72
4 AD Torrejón CF Torrejón 34 64 31 69
5 Alcobendas Alcobendas 34 49 44 51
6 Aravaca Aravaca 34 48 45 49
7 Dosa Dosa 34 49 55 47
8 RSD Alcalá B Alcalá 34 42 49 45
9 Las Rozas Las Rozas 34 46 53 42
10 Torrelodones Torrelodones 34 32 40 40
11 Coslada Coslada 34 36 47 40
12 Periso CF Periso CF 34 46 57 39
13 CD La Resaca Resaca 34 39 63 38
14 CD Canillas CD Canillas 34 38 50 37
15 CDF Tres Cantos Tres Cantos 34 37 44 36
16 Villanueva del Pardillo Villanueva 34 33 47 32
17 Complutense Nadador Complutense 34 41 69 30
18 Cd Recuerdo Cd Recuerdo 34 30 60 29
TEMPORADA 2010/2011
PREFERENTE MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 Vicálvaro Vicálvaro 34 62 30 72
2 Unión Adarve Unión 34 59 32 64
3 AD Torrejón CF Torrejón 34 65 43 61
4 Alcobendas Alcobendas 34 54 35 59
5 Dosa Dosa 34 73 50 57
6 CUC Villalba Villalba 34 63 50 57
7 Aravaca Aravaca 34 53 50 49
8 Villanueva del Pardillo Villanueva 34 56 60 49
9 DAV Santa Ana Santa 34 49 46 48
10 Unión Tres Cantos Unión Tres 34 40 44 45
11 CD Canillas CD Canillas 34 39 54 41
12 Torrelodones Torrelodones 34 36 36 40
13 RSD Alcalá B Alcalá 34 40 48 39
14 Cd Recuerdo Cd Recuerdo 34 55 61 37
15 San Sebastián Reyes B Sebastián 34 50 63 36
16 Brunete Brunete 34 48 61 36
17 Dehesa Luis Ii Dehesa Luis 34 37 74 24
18 AD Fundación Fundación 34 41 83 18
TEMPORADA 2009/2010
PREFERENTE MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 Las Rozas Las Rozas 34 64 26 79
2 CF Pozuelo CF Pozuelo 34 61 18 74
3 Coslada Coslada 34 75 36 71
4 Alcobendas Alcobendas 34 65 42 62
5 AD Torrejón CF Torrejón 34 68 50 58
6 Unión Adarve Unión 34 53 41 54
7 Torrelodones Torrelodones 34 53 50 44
8 Villanueva del Pardillo Villanueva 34 52 53 44
9 Vicálvaro Vicálvaro 34 46 51 43
10 Aravaca Aravaca 34 36 48 43
11 Tres Cantos Tres Cantos 34 43 56 42
12 Dosa Dosa 34 47 55 41
13 Brunete Brunete 34 58 67 41
14 CUC Villalba Villalba 34 40 50 41
15 Moratalaz Moratalaz 34 42 58 35
16 Rayo Majadahonda Sub 19 B Rayo 34 37 44 32
17 EFMO Boadilla EFMO 34 33 59 30
18 Mejoreño Mejoreño 34 34 103 15
TEMPORADA 2008/2009
PREFERENTE MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 CD San Fernando Fernando 34 69 23 79
2 Colmenar Viejo Colmenar 34 75 24 76
3 AD Torrejón CF Torrejón 34 70 34 66
4 Coslada Coslada 34 61 35 61
5 Unión Adarve Unión 34 59 46 58
6 Alcobendas Alcobendas 34 62 47 54
7 Aravaca Aravaca 34 57 51 52
8 Brunete Brunete 34 57 56 51
9 Vicálvaro Vicálvaro 34 47 51 45
10 Rayo Majadahonda Sub 19 B Rayo 34 52 61 42
11 Tres Cantos Tres Cantos 34 45 63 41
12 Moratalaz Moratalaz 34 49 55 40
13 Loeches Loeches 34 40 61 39
14 RSD Alcalá B Alcalá 34 45 51 37
15 Atl. León Castilla Atl. León C. 34 51 71 32
16 Gandarío Sanse Gandarío 34 54 95 29
17 Montijo Montijo 34 43 77 26
18 G. Pegaso B G. Pegaso B 34 34 69 26
TEMPORADA 2002/2003
TERCERA DIVISIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 UD Sanse UD Sanse 38 71 36 72
2 CDA Navalcarnero Navalcarnero 38 67 43 72
3 Fuenlabrada Fuenlabrada 38 58 37 70
4 Rayo Majadahonda Rayo 38 65 42 69
5 Rayo Vallecano B Rayo 38 70 51 68
6 Real Madrid C Real Madrid 38 63 47 62
7 Móstoles Móstoles 38 61 42 59
8 Las Rozas Las Rozas 38 50 35 58
9 Leganés B Leganés B 38 74 59 56
10 CD San Fernando Fernando 38 54 56 55
11 Atlético de Pinto Atlético 38 62 48 54
12 Atlético de Madrid C Atlético 38 51 54 52
13 Orcasitas Orcasitas 38 44 49 49
14 Puerta Bonita Puerta 38 55 54 46
15 DAV Santa Ana Santa 38 42 55 42
16 Galáctico Pegaso Galáctico 38 48 66 41
17 CD Fortuna CD Fortuna 38 43 59 40
18 Aravaca Aravaca 38 51 66 40
19 CD Colonia Moscardó Colonia 38 39 72 28
20 Mejoreño Mejoreño 38 25 122 11
TEMPORADA 1998/1999
TERCERA DIVISIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 Real Madrid C Real Madrid 40 88 45 83
2 Leganés B Leganés B 40 57 29 76
3 Coslada Coslada 40 48 32 69
4 Marianistas Amoros Marianistas 40 55 46 68
5 DAV Santa Ana Santa 40 65 41 66
6 Colmenar Viejo Colmenar 40 72 59 61
7 Real Aranjuez CF Real 40 62 48 60
8 Puerta Bonita Puerta 40 57 48 58
9 CD Colonia Moscardó Colonia 40 50 46 58
10 RSD Alcalá RSD Alcalá 40 58 46 55
11 CDA Navalcarnero Navalcarnero 40 53 50 54
12 RCD Carabanchel Carabanchel 40 61 68 54
13 Rayo Vallecano B Rayo 40 47 48 53
14 Las Rozas Las Rozas 40 43 54 48
15 Galáctico Pegaso Galáctico 40 46 55 47
16 AD Villaviciosa De Odón Villaviciosa 40 44 59 46
17 Getafe B Getafe B 40 40 49 45
18 AD Parla AD Parla 40 38 55 43
19 CD San Fernando Fernando 40 40 55 43
20 Rayo Majadahonda Rayo 40 35 71 35
21 Aravaca Aravaca 40 41 96 31

  USO DE MEMORIA  
7,540,968 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1516
Total Execution Time  0.1529
  CADENA URL  
/historico/Aravaca
  GET DATOS  
$_GET['/historico/Aravaca']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0028  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 = 'Aravaca' 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.0018  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=240 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=240 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=240 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 240 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023  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 (93129,142042,202655) ORDER BY n.cover_points DESC, update_date DESC
0.0024  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 = '240' ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '240' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '240' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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=240 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (73536) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 73536 AND teamId = 240
0.0021  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 73536 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '240' 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 = '240' and rp.type = 4
0.0020  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 = '240' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0034  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 = 73536 WHERE rp.league_id = 73536 AND rp.teamId = 240 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.0032  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 = 73536 WHERE rp.league_id = 73536 AND rp.teamId = 240 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 events2024 e ON e.player_id = p.id AND e.league_id = 73536 WHERE rp.league_id = 73536 AND rp.teamId = 240 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 240 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0045  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 73536 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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 = 68737 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.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 `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 = 63727 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.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 `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 = 59963 AND t.round = 19 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 `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 = 51262 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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 = 44759 AND t.round = 34 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 = 33357 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 `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 = 15448 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036  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 = 3994 AND t.round = 34 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 `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 = 2557 AND t.round = 42 ORDER BY team.conference 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 `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 = 1990 AND t.round = 34 ORDER BY team.conference 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 `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 = 1463 AND t.round = 34 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 `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 = 1127 AND t.round = 34 ORDER BY team.conference 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 `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 = 852 AND t.round = 34 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 `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 = 291 AND t.round = 34 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 `tables2003` 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 = 22068 AND t.round = 38 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 `tables1999` 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 = 22004 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC