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

Las Rozas

Entrenador: Manu González

Temporada 2023/2024
TEMPORADA 2023/2024
TERCERA FEDERACIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 Real Madrid C Real Madrid 32 58 16 73
2 CD Móstoles Móstoles 32 55 29 62
3 Leganés B Leganés B 32 44 32 54
4 Las Rozas Las Rozas 32 46 36 46
5 RSD Alcalá RSD Alcalá 32 50 44 45
6 CDF Tres Cantos Tres Cantos 32 41 44 45
7 CD Colonia Moscardó Colonia 32 44 46 44
8 AD Torrejón CF Torrejón 32 38 35 41
9 Alcorcón B Alcorcón B 32 32 31 41
10 Galapagar Galapagar 32 42 48 41
11 Paracuellos Antamira Paracuellos 32 39 46 39
12 Trival Valderas Trival 32 32 39 38
13 AD Parla AD Parla 32 37 45 38
14 CD Canillas CD Canillas 32 32 44 37
15 CUC Villalba Villalba 32 39 44 35
16 Villanueva del Pardillo Villanueva 32 26 35 35
17 Rayo Vallecano B Rayo 32 38 55 33
18 CF Pozuelo CF Pozuelo 32 25 49 27
TEMPORADA 2022/2023
TERCERA FEDERACIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 CD Ursaria CD Ursaria 30 62 22 68
2 Real Madrid C Real Madrid 30 73 27 67
3 Getafe B Getafe B 30 49 24 54
4 Paracuellos Antamira Paracuellos 30 48 40 48
5 CD Móstoles Móstoles 30 38 32 47
6 RSD Alcalá RSD Alcalá 30 31 28 46
7 Las Rozas Las Rozas 30 37 38 45
8 Trival Valderas Trival 30 38 44 37
9 CF Pozuelo CF Pozuelo 30 37 47 37
10 AD Torrejón CF Torrejón 30 31 42 35
11 Galapagar Galapagar 30 38 44 35
12 CUC Villalba Villalba 30 30 45 34
13 CD Canillas CD Canillas 30 34 46 34
14 Rayo Vallecano B Rayo 30 42 45 33
15 CDE Madrid 2021 Madrid 2021 30 31 52 32
16 Real Aranjuez CF Real 30 21 64 16
TEMPORADA 2021/2022
TERCERA FEDERACIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 Atlético B Atlético B 40 82 26 95
2 Las Rozas Las Rozas 40 68 35 75
3 CDE Madrid 2021 Madrid 2021 40 61 42 72
4 Alcorcón B Alcorcón B 40 63 39 69
5 Paracuellos Antamira Paracuellos 40 56 44 66
6 CD Ursaria CD Ursaria 40 47 27 64
7 RSD Alcalá RSD Alcalá 40 45 40 64
8 Getafe B Getafe B 40 56 46 61
9 Rayo Vallecano B Rayo 40 59 43 57
10 AD Torrejón CF Torrejón 40 55 48 57
11 CF Pozuelo CF Pozuelo 40 39 45 57
12 Galapagar Galapagar 40 50 57 56
13 Trival Valderas Trival 40 40 42 53
14 AD Parla AD Parla 40 46 46 52
15 CDF Tres Cantos Tres Cantos 40 41 52 47
16 SAD Villaverde Villaverde 40 35 45 45
17 Moratalaz Moratalaz 40 46 73 43
18 Villaviciosa Odón Villaviciosa 40 47 73 38
19 Complutense Alcala Complutense 40 31 58 37
20 RCD Carabanchel Carabanchel 40 43 70 33
21 CD Colonia Moscardó Colonia 40 20 79 17
TEMPORADA 2020/2021
SEGUNDA DIVISIÓN B GRUPO 5
Equipo PJ GF GC Puntos
1 UD Sanse UD Sanse 18 22 14 35
2 RM Castilla RM Castilla 18 30 21 32
3 Internacional de Madrid Internaciona 18 24 16 30
4 Rayo Majadahonda Rayo 18 17 16 28
5 Atlético Baleares Atlético 18 26 21 24
6 CDA Navalcarnero Navalcarnero 18 16 18 20
7 Las Rozas Las Rozas 18 16 25 20
8 Atlético B Atlético B 18 15 20 19
9 Poblense Poblense 18 16 21 16
10 Getafe B Getafe B 18 11 21 13
11 CD Badajoz CD Badajoz 18 32 9 41
12 Extremadura Extremadura 18 24 16 31
13 CF Talavera CF Talavera 18 23 19 27
14 Villanovense Villanovense 18 15 8 27
15 CD Don Benito Benito 18 16 21 24
16 AD Mérida AD Mérida 18 12 12 23
17 UD Melilla UD Melilla 18 15 19 23
18 Villarrubia CF Villarrubia 18 17 24 20
19 UD Yugo Socuéllamos Yugo 18 13 25 16
20 CP Villarrobledo Villarrobled 18 15 29 10
TEMPORADA 2019/2020
SEGUNDA DIVISIÓN B GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético Baleares Atlético 28 44 22 58
2 UD Ibiza UD Ibiza 28 41 18 56
3 Atlético B Atlético B 28 52 27 53
4 Peña Deportiva Peña 28 43 41 45
5 Coruxo Coruxo 28 32 30 41
6 Rayo Majadahonda Rayo 28 31 29 41
7 RM Castilla RM Castilla 28 42 35 40
8 Internacional de Madrid Internaciona 28 39 37 40
9 Pontevedra Pontevedra 28 38 40 38
10 Langreo Langreo 28 28 33 38
11 Racing Ferrol Racing 28 33 33 37
12 Real Oviedo Vetusta Real Oviedo 28 31 38 37
13 UD Melilla UD Melilla 28 29 37 36
14 Celta Fortuna Celta 28 41 45 35
15 Sporting Atlético Sporting 28 36 31 34
16 Las Palmas At. Palmas 28 20 35 34
17 Las Rozas Las Rozas 28 32 29 33
18 Marino de Luanco Marino 28 26 37 32
19 Getafe B Getafe B 28 25 37 28
20 UD Sanse UD Sanse 28 24 53 19
TEMPORADA 2018/2019
TERCERA DIVISIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 Getafe B Getafe B 38 58 24 83
2 Las Rozas Las Rozas 38 69 34 79
3 Paracuellos Antamira Paracuellos 38 49 29 72
4 CD Móstoles Móstoles 38 41 25 71
5 SAD Villaverde Villaverde 38 40 31 63
6 Trival Valderas Trival 38 41 32 59
7 Rayo Vallecano B Rayo 38 58 47 59
8 CD San Fernando Fernando 38 44 37 58
9 Leganés B Leganés B 38 51 39 55
10 Atlético de Pinto Atlético 38 41 51 51
11 DAV Santa Ana Santa 38 51 48 47
12 Alcorcón B Alcorcón B 38 26 35 44
13 RSD Alcalá RSD Alcalá 38 25 31 44
14 RCD Carabanchel Carabanchel 38 29 37 44
15 AD Parla AD Parla 38 39 49 43
16 CF Pozuelo CF Pozuelo 38 38 52 40
17 CD Canillas CD Canillas 38 34 52 39
18 Vicálvaro Vicálvaro 38 37 58 34
19 CF San Agustín Agustín 38 37 61 29
20 CDF Tres Cantos Tres Cantos 38 19 55 27
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
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
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
PREFERENTE MADRID GRUPO 1
Equipo PJ GF GC Puntos
1 Alcobendas Alcobendas 34 38 25 62
2 Villanueva del Pardillo Villanueva 34 51 32 60
3 RSD Alcalá B Alcalá 34 66 41 58
4 CDF Tres Cantos Tres Cantos 34 48 44 55
5 CD San Roque EFF Roque 34 50 38 54
6 CD Canillas CD Canillas 34 38 33 53
7 Periso CF Periso CF 34 45 46 49
8 Dosa Dosa 34 53 47 48
9 Moratalaz Moratalaz 34 53 43 48
10 Las Rozas Las Rozas 34 42 42 47
11 San Sebastián Reyes B Sebastián 34 49 49 46
12 Coslada Coslada 34 49 58 46
13 CF Pozuelo B Pozuelo 34 49 54 44
14 Futbol de Torres Futbol 34 58 55 44
15 Unión Adarve B Unión 34 46 47 43
16 Atlético Velilla CF Atlético 34 43 50 42
17 DAV Santa Ana Santa 34 39 55 36
18 At. Leones Castilla Leones 34 16 74 10
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
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
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
TERCERA DIVISIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 RSD Alcalá RSD Alcalá 40 65 22 88
2 AD Parla AD Parla 40 63 34 77
3 Rayo Majadahonda Rayo 40 53 37 69
4 Paracuellos Antamira Paracuellos 40 59 43 68
5 Rayo Vallecano B Rayo 40 52 34 65
6 Getafe B Getafe B 40 62 46 62
7 Ciempozuelos Ciempozuelos 40 49 42 60
8 Real Madrid C Real Madrid 40 60 46 58
9 Vallecas Vallecas 40 56 53 57
10 Fuenlabrada Fuenlabrada 40 50 48 56
11 Móstoles Móstoles 40 48 41 56
12 DAV Santa Ana Santa 40 46 52 53
13 UD Sanse UD Sanse 40 35 34 53
14 Atlético de Madrid C Atlético 40 52 49 53
15 Atlético de Pinto Atlético 40 53 49 52
16 Galáctico Pegaso Galáctico 40 48 45 52
17 Puerta Bonita Puerta 40 35 41 51
18 Las Rozas Las Rozas 40 58 62 46
19 Colonia Ofigevi Colonia 40 35 59 30
20 CF Pozuelo CF Pozuelo 40 41 75 29
21 Union Collado Villalba Union 40 31 139 8
TEMPORADA 2007/2008
TERCERA DIVISIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 Ciempozuelos Ciempozuelos 40 74 36 81
2 CDA Navalcarnero Navalcarnero 40 69 49 77
3 RSD Alcalá RSD Alcalá 40 68 35 76
4 Móstoles Móstoles 40 49 29 74
5 Getafe B Getafe B 40 54 33 71
6 AD Parla AD Parla 40 58 33 70
7 Paracuellos Antamira Paracuellos 40 57 36 68
8 Atlético de Pinto Atlético 40 55 34 65
9 Real Madrid C Real Madrid 40 58 52 60
10 Atlético de Madrid C Atlético 40 72 64 58
11 Las Rozas Las Rozas 40 43 47 56
12 Rayo Majadahonda Rayo 40 40 42 53
13 Rayo Vallecano B Rayo 40 40 31 51
14 Puerta Bonita Puerta 40 43 51 45
15 CUC Villalba Villalba 40 52 58 45
16 CF Pozuelo CF Pozuelo 40 45 59 43
17 CD San Fernando Fernando 40 34 58 42
18 Humanes Humanes 40 42 86 32
19 Villaviciosa Odón Villaviciosa 40 37 74 30
20 AD Torrejón CF Torrejón 40 30 70 29
21 Unión Adarve Unión 40 35 78 28
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 2005/2006
TERCERA DIVISIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 Real Madrid C Real Madrid 38 80 31 80
2 AD Parla AD Parla 38 52 25 75
3 EM Cobeña EM Cobeña 38 49 40 66
4 Getafe B Getafe B 38 48 33 65
5 Atlético de Pinto Atlético 38 51 32 60
6 Galáctico Pegaso Galáctico 38 47 34 59
7 Ciempozuelos Ciempozuelos 38 42 38 56
8 Rayo Vallecano B Rayo 38 44 41 51
9 Rayo Majadahonda Rayo 38 37 37 50
10 Coslada Coslada 38 43 50 50
11 CD San Fernando Fernando 38 32 37 49
12 CDA Navalcarnero Navalcarnero 38 47 44 48
13 Las Rozas Las Rozas 38 28 29 48
14 DAV Santa Ana Santa 38 37 46 46
15 CUC Villalba Villalba 38 33 44 45
16 Atlético de Madrid C Atlético 38 39 46 44
17 RCD Carabanchel Carabanchel 38 35 46 44
18 CD Colonia Moscardó Colonia 38 28 53 38
19 Leganés B Leganés B 38 28 55 32
20 Real Aranjuez CF Real 38 27 66 25
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 2003/2004
TERCERA DIVISIÓN GRUPO 7
Equipo PJ GF GC Puntos
1 Móstoles Móstoles 38 64 31 71
2 Galáctico Pegaso Galáctico 38 56 39 69
3 Atlético de Pinto Atlético 38 72 36 68
4 Las Rozas Las Rozas 38 44 31 66
5 AD Torrejón CF Torrejón 38 73 53 65
6 CDA Navalcarnero Navalcarnero 38 55 36 64
7 CD San Fernando Fernando 38 50 46 59
8 Ciempozuelos Ciempozuelos 38 54 52 56
9 Rayo Vallecano B Rayo 38 51 47 53
10 AD Parla AD Parla 38 55 49 53
11 Leganés B Leganés B 38 52 49 50
12 DAV Santa Ana Santa 38 49 52 49
13 Atlético de Madrid C Atlético 38 56 55 48
14 Real Aranjuez CF Real 38 61 60 48
15 Orcasitas Orcasitas 38 43 46 48
16 Real Madrid C Real Madrid 38 48 44 47
17 Tornado Tornado 38 40 64 44
18 Coslada Coslada 38 34 67 30
19 RCD Carabanchel Carabanchel 38 34 85 24
20 Puerta Bonita Puerta 38 32 81 20

  USO DE MEMORIA  
8,305,480 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1572
Total Execution Time  0.1584
  CADENA URL  
/historico/Rozas
  GET DATOS  
$_GET['/historico/Rozas']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0033  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 = 'Rozas' 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=1522 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=1522 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=1522 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=1522 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=1522 AND type_rel = 2
0.0022  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1522 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0024  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 (302039,502954,637063,637527,646366) ORDER BY n.cover_points DESC, update_date DESC
0.0031  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '1522' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0027  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '1522' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0035  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=1522 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (72569,72266,71432,69563) 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 = 72266 AND teamId = 1522
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 69563 AND teamId = 1522
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 72569 AND teamId = 1522
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1522
0.0035  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72266 WHERE rp.league_id = 72266 AND rp.teamId = 1522 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.0031  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 = 72266 WHERE rp.league_id = 72266 AND rp.teamId = 1522 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 72266 WHERE rp.league_id = 72266 AND rp.teamId = 1522 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 = 1522 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 67981 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.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 `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 = 62391 AND t.round = 42 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 58612 AND t.round = 18 ORDER BY team.conference ASC,t.position 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 `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 = 50265 AND t.round = 28 ORDER BY team.conference ASC,t.position 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 `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 = 44395 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 `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 = 39190 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 = 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.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 = 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.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 `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.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 `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 = 2679 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.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 `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 = 1117 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0034  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 = 137 AND t.round = 42 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 `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 = 14 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 `tables2007` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 92 AND t.round = 40 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 `tables2006` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 22119 AND t.round = 38 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 `tables2005` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 22100 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 t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2004` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 22084 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC