4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Colmenar Viejo
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
1ª REGIONAL MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 CUC Villalba Villalba 23 47 22 56
2 Colmenar Viejo Colmenar 21 54 18 47
3 AD Fundación Fundación 23 57 45 41
4 Torrelodones Torrelodones 22 41 23 37
5 Celtic Castilla Celtic 23 47 50 35
6 Aravaca B Aravaca B 23 45 34 34
7 Siete Picos Colmenar Siete Picos 23 43 36 34
8 Villanueva del Pardillo B Villanueva 23 40 38 32
9 CD La Cañada Cañada 23 39 37 32
10 Cerceda CF Cerceda CF 21 36 31 31
11 Unión Adarve B Unión 23 35 25 29
12 Cala Pozuelo Cala Pozuelo 23 33 35 29
13 CD Electrocor CF Electrocor 23 34 51 29
14 Unión Zona Norte Unión Zona 23 28 36 27
15 Galapagar B Galapagar B 23 33 36 25
16 Union de Aravaca Union 23 37 48 24
17 Hoyo de Manzanares Hoyo 22 23 49 15
18 Club San Agustin Club Agustin 23 25 83 7
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
TERCERA DIVISIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 Internacional de Madrid Internaciona 38 62 21 79
2 Getafe B Getafe B 38 67 31 78
3 Rayo Vallecano B Rayo 38 63 31 74
4 RSD Alcalá RSD Alcalá 38 63 32 72
5 CF Pozuelo CF Pozuelo 38 46 37 65
6 CD San Fernando Fernando 38 58 41 63
7 Paracuellos Antamira Paracuellos 38 59 38 63
8 CD Móstoles Móstoles 38 56 41 61
9 Alcorcón B Alcorcón B 38 65 43 57
10 Trival Valderas Trival 38 46 41 52
11 SAD Villaverde Villaverde 38 34 32 49
12 Leganés B Leganés B 38 61 67 49
13 Atlético de Pinto Atlético 38 34 43 47
14 CF San Agustín Agustín 38 43 54 45
15 DAV Santa Ana Santa 38 40 52 43
16 CDF Tres Cantos Tres Cantos 38 37 65 43
17 CD Los Yébenes-San Bruno Yébenes-San 38 26 63 33
18 El Álamo El Álamo 38 31 55 32
19 Colmenar Viejo Colmenar 38 45 72 30
20 CP Parla Escuela Parla 38 16 93 4
TEMPORADA 2016/2017
PREFERENTE MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 Colmenar Viejo Colmenar 34 59 33 67
2 CF San Agustín Agustín 34 58 35 66
3 CDF Tres Cantos Tres Cantos 34 59 36 64
4 San Sebastián Reyes B Sebastián 34 55 37 63
5 Coslada Coslada 34 62 38 61
6 Moratalaz Moratalaz 34 68 55 55
7 CD Canillas CD Canillas 34 47 42 52
8 Las Rozas Las Rozas 34 54 51 46
9 Periso CF Periso CF 34 63 60 45
10 CUC Villalba Villalba 34 54 60 40
11 RSD Alcalá B Alcalá 34 46 56 40
12 Complutense Alcala Complutense 34 36 39 39
13 AD Torrejón CF Torrejón 34 37 41 39
14 CD San Roque EFF Roque 34 31 49 39
15 Rayo Ciudad Alcobendas Rayo Ciudad 34 40 51 35
16 Sporting Hortaleza Sporting 34 40 53 35
17 CD Avance CD Avance 34 47 68 34
18 Siete Picos Colmenar Siete Picos 34 25 77 13
TEMPORADA 2015/2016
PREFERENTE MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 Villanueva del Pardillo Villanueva 34 61 31 72
2 DAV Santa Ana Santa 34 80 34 65
3 Alcobendas Alcobendas 34 57 30 63
4 Las Rozas Las Rozas 34 73 43 63
5 Periso CF Periso CF 34 59 43 61
6 Coslada Coslada 34 64 45 59
7 CDF Tres Cantos Tres Cantos 34 59 37 56
8 Complutense Alcala Complutense 34 50 50 47
9 Moratalaz Moratalaz 34 41 56 47
10 Sporting Hortaleza Sporting 34 66 70 45
11 CD Canillas CD Canillas 34 49 51 45
12 San Sebastián Reyes B Sebastián 34 45 46 43
13 Siete Picos Colmenar Siete Picos 34 55 60 42
14 AD Torrejón CF Torrejón 34 47 59 39
15 Galapagar Galapagar 34 45 62 35
16 AD Esperanza Esperanza 34 47 78 32
17 Colmenar Viejo Colmenar 34 31 83 23
18 Alameda de Osuna Alameda 34 36 87 17
TEMPORADA 2014/2015
TERCERA DIVISIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 Rayo Majadahonda Rayo 38 67 38 71
2 Paracuellos Antamira Paracuellos 38 59 39 64
3 CDA Navalcarnero Navalcarnero 38 43 37 64
4 Alcorcón B Alcorcón B 38 57 41 63
5 Unión Adarve Unión 38 40 31 63
6 UD Sanse UD Sanse 38 47 32 62
7 Internacional de Madrid Internaciona 38 48 42 60
8 RSD Alcalá RSD Alcalá 38 41 29 56
9 Real Madrid C Real Madrid 38 50 40 55
10 CF Pozuelo CF Pozuelo 38 46 45 54
11 AD Parla AD Parla 38 47 39 53
12 Atlético de Pinto Atlético 38 44 42 52
13 Atlético de Madrid C Atlético 38 53 66 49
14 Puerta Bonita Puerta 38 42 44 47
15 CD Móstoles Móstoles 38 44 46 46
16 CD San Fernando Fernando 38 35 42 44
17 Villanueva del Pardillo Villanueva 38 37 51 43
18 Alcobendas Alcobendas 38 35 49 36
19 Colmenar Viejo Colmenar 38 35 65 35
20 AD Torrejón CF Torrejón 38 22 74 20
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
TERCERA DIVISIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 Puerta Bonita Puerta 38 69 41 70
2 CUC Villalba Villalba 38 52 37 69
3 Trival Valderas Trival 38 70 45 68
4 Unión Adarve Unión 38 51 33 66
5 CF Pozuelo CF Pozuelo 38 51 33 64
6 RCD Carabanchel Carabanchel 38 59 38 63
7 AD Parla AD Parla 38 50 39 62
8 Rayo Majadahonda Rayo 38 62 45 59
9 Colmenar Viejo Colmenar 38 65 49 59
10 Real Aranjuez CF Real 38 47 55 51
11 Internacional de Madrid Internaciona 38 41 51 49
12 CD San Fernando Fernando 38 42 49 48
13 Atlético de Madrid C Atlético 38 45 59 47
14 Paracuellos Antamira Paracuellos 38 45 46 47
15 Atlético de Pinto Atlético 38 42 42 45
16 Alcorcón B Alcorcón B 38 31 50 42
17 Villaviciosa Odón Villaviciosa 38 30 45 41
18 CD Colonia Moscardó Colonia 38 32 52 38
19 CD Griñón CD Griñón 38 31 70 32
20 DAV Santa Ana Santa 38 30 66 19
TEMPORADA 2011/2012
TERCERA DIVISIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 Fuenlabrada Fuenlabrada 38 60 33 73
2 Real Madrid C Real Madrid 38 65 33 67
3 AD Parla AD Parla 38 59 39 64
4 Puerta Bonita Puerta 38 41 32 64
5 Colmenar Viejo Colmenar 38 59 42 62
6 RCD Carabanchel Carabanchel 38 39 29 60
7 Internacional de Madrid Internaciona 38 45 40 59
8 Paracuellos Antamira Paracuellos 38 52 42 57
9 CF Pozuelo CF Pozuelo 38 45 41 55
10 Rayo Majadahonda Rayo 38 51 37 53
11 CD Colonia Moscardó Colonia 38 42 31 53
12 Unión Adarve Unión 38 33 35 52
13 Atlético de Madrid C Atlético 38 49 52 48
14 Villaviciosa Odón Villaviciosa 38 34 47 47
15 Trival Valderas Trival 38 51 52 46
16 Atlético de Pinto Atlético 38 42 53 45
17 Móstoles Móstoles 38 37 59 42
18 CDA Navalcarnero Navalcarnero 38 41 64 34
19 Vicálvaro Vicálvaro 38 28 69 29
20 CD Fortuna CD Fortuna 38 17 60 19
TEMPORADA 2010/2011
TERCERA DIVISIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 Paracuellos Antamira Paracuellos 38 71 33 75
2 CF Pozuelo CF Pozuelo 38 52 44 65
3 Villaviciosa Odón Villaviciosa 38 43 30 63
4 Internacional de Madrid Internaciona 38 44 32 63
5 UD Sanse UD Sanse 38 57 36 63
6 Real Madrid C Real Madrid 38 54 36 61
7 Fuenlabrada Fuenlabrada 38 54 39 57
8 Rayo Majadahonda Rayo 38 62 52 55
9 Atlético de Pinto Atlético 38 46 47 54
10 Colmenar Viejo Colmenar 38 62 63 54
11 Trival Valderas Trival 38 55 51 53
12 Móstoles Móstoles 38 53 47 52
13 Puerta Bonita Puerta 38 53 59 52
14 AD Parla AD Parla 38 44 53 51
15 Atlético de Madrid C Atlético 38 52 52 50
16 CDA Navalcarnero Navalcarnero 38 44 46 49
17 CD San Fernando Fernando 38 45 49 47
18 Vallecas Vallecas 38 41 72 35
19 Las Rozas Las Rozas 38 42 79 24
20 Coslada Coslada 38 27 81 21
TEMPORADA 2009/2010
TERCERA DIVISIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 Rayo Vallecano B Rayo 38 68 23 85
2 AD Parla AD Parla 38 65 33 74
3 Getafe B Getafe B 38 77 41 70
4 Trival Valderas Trival 38 77 45 69
5 Fuenlabrada Fuenlabrada 38 52 33 68
6 Real Madrid C Real Madrid 38 59 43 64
7 CDA Navalcarnero Navalcarnero 38 49 48 57
8 Móstoles Móstoles 38 52 42 56
9 Rayo Majadahonda Rayo 38 46 47 54
10 Colmenar Viejo Colmenar 38 53 54 53
11 Atlético de Madrid C Atlético 38 55 51 52
12 CD San Fernando Fernando 38 42 58 50
13 UD Sanse UD Sanse 38 57 57 50
14 Atlético de Pinto Atlético 38 43 62 47
15 Vallecas Vallecas 38 47 51 46
16 Paracuellos Antamira Paracuellos 38 46 53 43
17 Arganda Arganda 38 40 61 39
18 DAV Santa Ana Santa 38 38 73 30
19 Ciempozuelos Ciempozuelos 38 36 81 24
20 Galáctico Pegaso Galáctico 38 27 73 23
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 2006/2007
TERCERA DIVISIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 RSD Alcalá RSD Alcalá 38 58 29 67
2 Getafe B Getafe B 38 52 33 67
3 CD San Fernando Fernando 38 37 28 62
4 AD Parla AD Parla 38 43 29 62
5 Atlético de Pinto Atlético 38 48 37 60
6 Ciempozuelos Ciempozuelos 38 61 42 60
7 Real Madrid C Real Madrid 38 53 38 59
8 CDA Navalcarnero Navalcarnero 38 58 54 58
9 Móstoles Móstoles 38 55 43 56
10 Rayo Majadahonda Rayo 38 41 32 52
11 Paracuellos Antamira Paracuellos 38 48 59 48
12 Atlético de Madrid C Atlético 38 43 47 47
13 Las Rozas Las Rozas 38 30 42 46
14 Rayo Vallecano B Rayo 38 38 41 46
15 Puerta Bonita Puerta 38 32 42 45
16 CUC Villalba Villalba 38 31 39 45
17 Pegaso Pegaso 39 37 45 42
18 Coslada Coslada 38 47 63 41
19 DAV Santa Ana Santa 38 40 54 39
20 Colonia Ofigevi Colonia 39 32 50 38
21 Colmenar Viejo Colmenar 38 38 75 32
TEMPORADA 2004/2005
TERCERA DIVISIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 Las Rozas Las Rozas 38 52 31 74
2 Móstoles Móstoles 38 67 39 72
3 AD Parla AD Parla 38 56 40 65
4 Ciempozuelos Ciempozuelos 38 53 33 63
5 Atlético de Pinto Atlético 38 57 45 62
6 Galáctico Pegaso Galáctico 38 74 50 62
7 Rayo Vallecano B Rayo 38 69 43 61
8 Rayo Majadahonda Rayo 38 60 39 59
9 Getafe B Getafe B 38 50 52 54
10 EM Cobeña EM Cobeña 38 53 45 54
11 Real Madrid C Real Madrid 38 52 44 54
12 DAV Santa Ana Santa 38 54 58 54
13 Atlético de Madrid C Atlético 38 52 64 50
14 Leganés B Leganés B 38 50 59 49
15 CD San Fernando Fernando 38 52 61 48
16 Real Aranjuez CF Real 38 35 41 46
17 Orcasitas Orcasitas 38 33 51 41
18 Colmenar Viejo Colmenar 38 37 68 34
19 AD Torrejón CF Torrejón 38 36 66 27
20 El Álamo El Álamo 38 35 98 14
TEMPORADA 1999/2000
TERCERA DIVISIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 Coslada Coslada 38 63 32 80
2 Real Madrid C Real Madrid 38 81 31 78
3 DAV Santa Ana Santa 38 76 42 71
4 RSD Alcalá RSD Alcalá 38 65 48 68
5 Alcorcón Alcorcón 38 58 38 64
6 Atlético de Pinto Atlético 38 41 41 60
7 Las Rozas Las Rozas 38 49 38 59
8 Rayo Vallecano B Rayo 38 52 48 58
9 Marianistas Amoros Marianistas 38 53 39 56
10 Leganés B Leganés B 38 51 49 54
11 Real Aranjuez CF Real 38 38 50 50
12 CDA Navalcarnero Navalcarnero 38 38 52 45
13 Galáctico Pegaso Galáctico 38 46 58 43
14 Getafe B Getafe B 38 37 46 42
15 CD Colonia Moscardó Colonia 38 44 49 40
16 Atlético Cercedilla Atlético 38 41 69 40
17 Puerta Bonita Puerta 38 36 42 36
18 Colmenar Viejo Colmenar 38 47 73 36
19 RCD Carabanchel Carabanchel 38 32 69 32
20 Villaviciosa CF Villaviciosa 38 38 72 29
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  
8,050,928 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.4158
Total Execution Time  0.4172
  CADENA URL  
/historico/Colmenar-Viejo
  GET DATOS  
$_GET['/historico/Colmenar-Viejo']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0119  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 = 'Colmenar-Viejo' 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.0105  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=814 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=814 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=814 AND type_rel = 2
0.0107  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 814 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0108  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 (277674,427710,737395) ORDER BY n.cover_points DESC, update_date DESC
0.0110  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 = '814' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0109  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 = '814' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0107  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 = 73536 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0110  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=814 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0105  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.0112  SELECT count(id) as num_players from rel_players WHERE league_id = 73536 AND teamId = 814
0.0110  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.0110  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 = '814' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '814' and rp.type = 4
0.0107  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 = '814' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0120  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 = 814 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.0117  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 = 814 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0115  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 = 814 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0111  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 = 814 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0213  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.0112  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.0110  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.0110  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 = 51290 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.0111  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.0109  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 = 33953 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 16701 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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