Has elegido rechazar las cookies basadas en consentimiento que utilizamos principalmente para gestionar la publicidad y las recomendaciones de contenido.

En adelante, para aceder a nuestra web tienes que elegir alguna de las siguientes opciones.

Has cambiado de idea y quieres
NAVEGAR GRATIS Y CON PUBLICIDAD...

Navega por besoccer.com y resultados-futbol.com con publicidad personalizada, seguimiento y cookies de forma gratuita.

Optar por esta opción te permitirá mantener tu experiencia de navegación como hasta ahora. Al aceptar las cookies y tecnologías similares, estás dando tu consentimiento para que recopilemos y utilicemos tu información de navegación con el propósito de adaptar la publicidad y la personalización según tus intereses. La presencia de esta publicidad es crucial para continuar proporcionando contenido de calidad, sevicios eficientes a los usuarios y mejorar la experiencia general de uso.

Nosotros y nuestros socios hacemos el siguiente tratamiento de datos: almacenamiento y acceso a información de geolocalización con propósitos de publicidad dirigida, almacenamiento y acceso a información de geolocalización para realizar estudios de mercado, almacenar o acceder a información en un dispositivo, analizar activamente las características del dispositivo para su identificación, compartir tus análisis de navegación y grupos de interés con terceros, crear un perfil para la personalización de contenidos, crear un perfil publicitario personalizado, desarrollar y mejorar productos, enriquecer el perfil con información de terceros, medir el rendimiento de los anuncios, medir el rendimiento del contenido, seleccionar anuncios básicos, seleccionar anuncios personalizados, seleccionar contenido personalizado, utilizar datos de localización geográfica precisa, utilizar estudios de mercado a fin de generar información sobre el público.

Aceptar y continuar gratis

...O sigues prefiriendo rechazar las cookies y entonces
CONTINÚA REGISTRÁNDOTE Y SUSCRIBIÉNDOTE

Navega por besoccer.com y resultados-futbol.com sin publicidad ni seguimiento suscribiéndote a nuestra web por 0,50 € al día.

Además de abonar la suscripción, es necesario realizar un registro previo para acceder. El mismo perfil de usuario es compartido entre los sitios besoccer.com y resultados-futbol.com

Accede por 0,50 € al día

Para saber más, consulta nuestra Política de Cookies.

Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

CF Pozuelo

Entrenador: Victor Aguirre Larrea

Temporada 2023/2024

TEMPORADA 2023/2024

TERCERA FEDERACIÓN GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Real Madrid	30	55	13	71
2	Móstoles	30	52	23	61
3	Leganés B	30	39	30	50
4	Tres Cantos	31	40	43	44
5	Las Rozas	31	44	35	43
6	RSD Alcalá	30	46	41	41
7	Alcorcón B	30	31	29	40
8	Colonia	30	40	43	40
9	Galapagar	31	39	45	40
10	Paracuellos	30	36	42	38
11	Torrejón	30	32	31	37
12	Trival	31	31	38	37
13	CD Canillas	31	30	41	37
14	AD Parla	30	35	43	36
15	Villanueva	30	25	33	34
16	Villalba	30	34	41	31
17	Rayo	30	36	52	30
18	CF Pozuelo	31	24	46	27

TEMPORADA 2022/2023

TERCERA FEDERACIÓN GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	CD Ursaria	30	62	22	68
2	Real Madrid	30	73	27	67
3	Getafe B	30	49	24	54
4	Paracuellos	30	48	40	48
5	Móstoles	30	38	32	47
6	RSD Alcalá	30	31	28	46
7	Las Rozas	30	37	38	45
8	Trival	30	38	44	37
9	CF Pozuelo	30	37	47	37
10	Torrejón	30	31	42	35
11	Galapagar	30	38	44	35
12	Villalba	30	30	45	34
13	CD Canillas	30	34	46	34
14	Rayo	30	42	45	33
15	Madrid 2021	30	31	52	32
16	Real	30	21	64	16

TEMPORADA 2021/2022

TERCERA FEDERACIÓN GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Atlético B	40	82	26	95
2	Las Rozas	40	68	35	75
3	Madrid 2021	40	61	42	72
4	Alcorcón B	40	63	39	69
5	Paracuellos	40	56	44	66
6	CD Ursaria	40	47	27	64
7	RSD Alcalá	40	45	40	64
8	Getafe B	40	56	46	61
9	Rayo	40	59	43	57
10	Torrejón	40	55	48	57
11	CF Pozuelo	40	39	45	57
12	Galapagar	40	50	57	56
13	Trival	40	40	42	53
14	AD Parla	40	46	46	52
15	Tres Cantos	40	41	52	47
16	Villaverde	40	35	45	45
17	Moratalaz	40	46	73	43
18	Villaviciosa	40	47	73	38
19	Complutense	40	31	58	37
20	Carabanchel	40	43	70	33
21	Colonia	40	20	79	17

TEMPORADA 2020/2021

TERCERA DIVISIÓN GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Unión	22	41	17	44
2	Moratalaz	22	36	20	40
3	Rayo	22	35	27	38
4	CF Pozuelo	22	33	20	38
5	Madrid 2021	22	19	18	33
6	Torrejón	22	32	17	32
7	Complutense	22	22	22	30
8	RSD Alcalá	22	20	16	28
9	Paracuellos	22	18	27	26
10	Villanueva	22	14	28	19
11	Fernando	22	18	36	18
12	Santa	22	11	51	10
13	Leganés B	20	34	12	50
14	Móstoles	20	28	11	44
15	Alcorcón B	20	32	15	34
16	AD Parla	20	20	20	28
17	Carabanchel	20	18	20	24
18	Atlético	20	20	30	24
19	Trival	20	15	21	23
20	Villaverde	20	18	29	21
21	El Álamo	20	24	33	16
22	Móstoles	20	15	26	15
23	Real	20	19	32	15

TEMPORADA 2019/2020

TERCERA DIVISIÓN GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Navalcarnero	28	44	22	53
2	Unión	28	43	35	47
3	Alcorcón B	28	40	26	47
4	RSD Alcalá	28	41	32	45
5	Trival	28	30	27	43
6	Leganés B	28	49	41	42
7	Móstoles	28	42	36	42
8	CF Pozuelo	28	36	38	40
9	Rayo	28	47	44	39
10	Madrid 2021	28	36	34	39
11	Santa	28	42	46	38
12	Carabanchel	28	32	32	36
13	Atlético	28	40	38	35
14	Torrejón	28	27	32	35
15	El Álamo	28	36	42	34
16	Moratalaz	28	29	37	34
17	Fernando	28	38	42	33
18	Paracuellos	28	35	38	33
19	AD Parla	28	30	50	22
20	Villaverde	28	16	41	19

TEMPORADA 2018/2019

TERCERA DIVISIÓN GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Getafe B	38	58	24	83
2	Las Rozas	38	69	34	79
3	Paracuellos	38	49	29	72
4	Móstoles	38	41	25	71
5	Villaverde	38	40	31	63
6	Trival	38	41	32	59
7	Rayo	38	58	47	59
8	Fernando	38	44	37	58
9	Leganés B	38	51	39	55
10	Atlético	38	41	51	51
11	Santa	38	51	48	47
12	Alcorcón B	38	26	35	44
13	RSD Alcalá	38	25	31	44
14	Carabanchel	38	29	37	44
15	AD Parla	38	39	49	43
16	CF Pozuelo	38	38	52	40
17	CD Canillas	38	34	52	39
18	Vicálvaro	38	37	58	34
19	Agustín	38	37	61	29
20	Tres Cantos	38	19	55	27

TEMPORADA 2017/2018

TERCERA DIVISIÓN GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Internaciona	38	62	21	79
2	Getafe B	38	67	31	78
3	Rayo	38	63	31	74
4	RSD Alcalá	38	63	32	72
5	CF Pozuelo	38	46	37	65
6	Fernando	38	58	41	63
7	Paracuellos	38	59	38	63
8	Móstoles	38	56	41	61
9	Alcorcón B	38	65	43	57
10	Trival	38	46	41	52
11	Villaverde	38	34	32	49
12	Leganés B	38	61	67	49
13	Atlético	38	34	43	47
14	Agustín	38	43	54	45
15	Santa	38	40	52	43
16	Tres Cantos	38	37	65	43
17	Yébenes-San	38	26	63	33
18	El Álamo	38	31	55	32
19	Colmenar	38	45	72	30
20	Parla	38	16	93	4

TEMPORADA 2016/2017

TERCERA DIVISIÓN GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Atlético B	38	63	40	73
2	Unión	38	55	41	66
3	Paracuellos	38	49	28	63
4	Móstoles	38	62	41	62
5	Leganés B	38	57	45	62
6	Getafe B	38	54	35	60
7	Atlético	38	36	30	58
8	RSD Alcalá	38	36	28	57
9	Internaciona	38	52	40	56
10	Santa	38	43	54	53
11	Villaverde	38	41	52	49
12	Fernando	38	44	43	49
13	Alcorcón B	38	40	46	48
14	CF Pozuelo	38	40	35	48
15	Rayo	38	57	49	47
16	Trival	38	44	48	46
17	Alcobendas	38	29	37	44
18	Aravaca	38	36	64	38
19	Villanueva	38	21	57	31
20	AD Parla	38	21	67	19

TEMPORADA 2015/2016

TERCERA DIVISIÓN GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	UD Sanse	38	68	26	81
2	Navalcarnero	38	76	42	72
3	CF Pozuelo	38	52	34	69
4	Atlético B	38	48	29	64
5	Fernando	38	58	45	60
6	Unión	38	55	38	59
7	Atlético	38	42	36	57
8	RSD Alcalá	38	53	49	57
9	Trival	38	44	35	57
10	Alcorcón B	38	57	53	55
11	Móstoles	38	48	40	52
12	Paracuellos	38	47	40	50
13	Aravaca	38	43	48	47
14	AD Parla	38	41	50	47
15	Rayo	38	44	42	46
16	Internaciona	38	33	43	43
17	Colonia	38	36	55	34
18	Puerta	38	40	56	33
19	Lugo	38	31	57	32
20	Villalba	38	19	117	2

TEMPORADA 2014/2015

TERCERA DIVISIÓN GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Rayo	38	67	38	71
2	Paracuellos	38	59	39	64
3	Navalcarnero	38	43	37	64
4	Alcorcón B	38	57	41	63
5	Unión	38	40	31	63
6	UD Sanse	38	47	32	62
7	Internaciona	38	48	42	60
8	RSD Alcalá	38	41	29	56
9	Real Madrid	38	50	40	55
10	CF Pozuelo	38	46	45	54
11	AD Parla	38	47	39	53
12	Atlético	38	44	42	52
13	Atlético	38	53	66	49
14	Puerta	38	42	44	47
15	Móstoles	38	44	46	46
16	Fernando	38	35	42	44
17	Villanueva	38	37	51	43
18	Alcobendas	38	35	49	36
19	Colmenar	38	35	65	35
20	Torrejón	38	22	74	20

TEMPORADA 2013/2014

TERCERA DIVISIÓN GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Trival	42	65	33	83
2	Rayo	42	86	50	81
3	Unión	42	60	30	81
4	UD Sanse	42	68	31	80
5	Internaciona	42	69	46	80
6	CF Pozuelo	42	60	37	71
7	Rayo	42	71	57	69
8	Fernando	42	58	40	67
9	RSD Alcalá	42	50	32	67
10	AD Parla	42	52	50	63
11	Paracuellos	42	46	49	56
12	Colmenar	42	63	70	55
13	Alcorcón B	42	65	67	51
14	Atlético	42	56	62	50
15	Atlético	42	58	61	50
16	Torrejón	42	56	64	50
17	Villalba	42	37	56	45
18	Aravaca	42	44	65	42
19	Real	42	43	82	34
20	Carabanchel	42	33	68	31
21	Vicálvaro	42	22	65	28
22	Yébenes-San	42	43	90	28

TEMPORADA 2012/2013

TERCERA DIVISIÓN GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Puerta	38	69	41	70
2	Villalba	38	52	37	69
3	Trival	38	70	45	68
4	Unión	38	51	33	66
5	CF Pozuelo	38	51	33	64
6	Carabanchel	38	59	38	63
7	AD Parla	38	50	39	62
8	Rayo	38	62	45	59
9	Colmenar	38	65	49	59
10	Real	38	47	55	51
11	Internaciona	38	41	51	49
12	Fernando	38	42	49	48
13	Atlético	38	45	59	47
14	Paracuellos	38	45	46	47
15	Atlético	38	42	42	45
16	Alcorcón B	38	31	50	42
17	Villaviciosa	38	30	45	41
18	Colonia	38	32	52	38
19	CD Griñón	38	31	70	32
20	Santa	38	30	66	19

TEMPORADA 2011/2012

TERCERA DIVISIÓN GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Fuenlabrada	38	60	33	73
2	Real Madrid	38	65	33	67
3	AD Parla	38	59	39	64
4	Puerta	38	41	32	64
5	Colmenar	38	59	42	62
6	Carabanchel	38	39	29	60
7	Internaciona	38	45	40	59
8	Paracuellos	38	52	42	57
9	CF Pozuelo	38	45	41	55
10	Rayo	38	51	37	53
11	Colonia	38	42	31	53
12	Unión	38	33	35	52
13	Atlético	38	49	52	48
14	Villaviciosa	38	34	47	47
15	Trival	38	51	52	46
16	Atlético	38	42	53	45
17	Móstoles	38	37	59	42
18	Navalcarnero	38	41	64	34
19	Vicálvaro	38	28	69	29
20	CD Fortuna	38	17	60	19

TEMPORADA 2010/2011

TERCERA DIVISIÓN GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Paracuellos	38	71	33	75
2	CF Pozuelo	38	52	44	65
3	Villaviciosa	38	43	30	63
4	Internaciona	38	44	32	63
5	UD Sanse	38	57	36	63
6	Real Madrid	38	54	36	61
7	Fuenlabrada	38	54	39	57
8	Rayo	38	62	52	55
9	Atlético	38	46	47	54
10	Colmenar	38	62	63	54
11	Trival	38	55	51	53
12	Móstoles	38	53	47	52
13	Puerta	38	53	59	52
14	AD Parla	38	44	53	51
15	Atlético	38	52	52	50
16	Navalcarnero	38	44	46	49
17	Fernando	38	45	49	47
18	Vallecas	38	41	72	35
19	Las Rozas	38	42	79	24
20	Coslada	38	27	81	21

TEMPORADA 2009/2010

PREFERENTE MADRID GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Las Rozas	34	64	26	79
2	CF Pozuelo	34	61	18	74
3	Coslada	34	75	36	71
4	Alcobendas	34	65	42	62
5	Torrejón	34	68	50	58
6	Unión	34	53	41	54
7	Torrelodones	34	53	50	44
8	Villanueva	34	52	53	44
9	Vicálvaro	34	46	51	43
10	Aravaca	34	36	48	43
11	Tres Cantos	34	43	56	42
12	Dosa	34	47	55	41
13	Brunete	34	58	67	41
14	Villalba	34	40	50	41
15	Moratalaz	34	42	58	35
16	Rayo	34	37	44	32
17	EFMO	34	33	59	30
18	Mejoreño	34	34	103	15

TEMPORADA 2008/2009

TERCERA DIVISIÓN GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	RSD Alcalá	40	65	22	88
2	AD Parla	40	63	34	77
3	Rayo	40	53	37	69
4	Paracuellos	40	59	43	68
5	Rayo	40	52	34	65
6	Getafe B	40	62	46	62
7	Ciempozuelos	40	49	42	60
8	Real Madrid	40	60	46	58
9	Vallecas	40	56	53	57
10	Fuenlabrada	40	50	48	56
11	Móstoles	40	48	41	56
12	Santa	40	46	52	53
13	UD Sanse	40	35	34	53
14	Atlético	40	52	49	53
15	Atlético	40	53	49	52
16	Galáctico	40	48	45	52
17	Puerta	40	35	41	51
18	Las Rozas	40	58	62	46
19	Colonia	40	35	59	30
20	CF Pozuelo	40	41	75	29
21	Union	40	31	139	8

TEMPORADA 2007/2008

TERCERA DIVISIÓN GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Ciempozuelos	40	74	36	81
2	Navalcarnero	40	69	49	77
3	RSD Alcalá	40	68	35	76
4	Móstoles	40	49	29	74
5	Getafe B	40	54	33	71
6	AD Parla	40	58	33	70
7	Paracuellos	40	57	36	68
8	Atlético	40	55	34	65
9	Real Madrid	40	58	52	60
10	Atlético	40	72	64	58
11	Las Rozas	40	43	47	56
12	Rayo	40	40	42	53
13	Rayo	40	40	31	51
14	Puerta	40	43	51	45
15	Villalba	40	52	58	45
16	CF Pozuelo	40	45	59	43
17	Fernando	40	34	58	42
18	Humanes	40	42	86	32
19	Villaviciosa	40	37	74	30
20	Torrejón	40	30	70	29
21	Unión	40	35	78	28

TEMPORADA 1988/1989

TERCERA DIVISIÓN GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Colonia	38	63	31	54
2	Móstoles	38	79	37	54
3	AD Parla	38	72	34	53
4	Real Madrid	38	63	27	50
5	Fuenlabrada	38	77	43	48
6	Carabanchel	38	50	40	43
7	Fernando	38	61	53	43
8	Navalcarnero	38	49	47	39
9	Rayo	38	61	68	38
10	Vicálvaro	38	59	57	37
11	Colmenar	38	55	58	36
12	Paracuellos	38	47	55	36
13	Pelayo AD	38	55	59	35
14	Valdemoro	38	53	50	33
15	Rayo	38	39	53	33
16	Vallecas	38	41	51	33
17	Real	38	44	56	30
18	Fuencarral	38	47	68	30
19	Ciempozuelos	38	39	68	28
20	CF Pozuelo	38	24	123	7

TEMPORADA 1987/1988

TERCERA DIVISIÓN GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Galáctico	38	82	28	58
2	Colonia	38	79	42	54
3	Móstoles	38	58	26	53
4	Colmenar	38	67	50	49
5	Rayo	38	58	51	44
6	Fuenlabrada	38	65	50	43
7	Pelayo AD	38	57	48	43
8	Fernando	38	52	40	42
9	Carabanchel	38	56	48	41
10	Real Madrid	38	50	46	40
11	Paracuellos	38	45	55	35
12	Navalcarnero	38	58	67	34
13	Vicálvaro	38	42	55	34
14	Real	38	51	59	32
15	Valdemoro	38	49	54	32
16	CF Pozuelo	38	40	71	28
17	Maravillas	38	38	56	28
18	Coslada	38	42	72	28
19	Alcorcón	38	33	61	25
20	Rayo Velilla	38	32	75	17

Competiciones que juega

Tercera Federación Grupo 7

Pos	Equipos		Pts
1		Real Madrid C	71
2		CD Móstoles	61
3		Leganés B	50
4		CDF Tres Cantos	44
5		Las Rozas	43
6		RSD Alcalá	41
7		Alcorcón B	40
8		CD Colonia Moscardó	40
9		Galapagar	40
10		Paracuellos Antamira	38
11		AD Torrejón CF	37
12		Trival Valderas	37
13		CD Canillas	37
14		AD Parla	36
15		Villanueva del Pardillo	34
16		CUC Villalba	31
17		Rayo Vallecano B	30
18		CF Pozuelo	27

	Ascenso : Real Madrid C
	Playoff Ascenso : CD Móstoles, Leganés B, CDF Tres Cantos, Las Rozas
	Descenso : CUC Villalba, Rayo Vallecano B, CF Pozuelo

RIVALES EN Copa Federación.

RIVALES EN Tercera Federaci.

USO DE MEMORIA

8,240,424 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.1499
Total Execution Time	0.1512

CADENA URL

/historico/Pozuelo-Alarcon

GET DATOS

$_GET['/historico/Pozuelo-Alarcon']

POST DATOS

No hay datos POST existentes

CONSULTAS (34)

0.0040	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 = 'Pozuelo-Alarcon' 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.0019	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=2010 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=2010 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=2010 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=2010 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=2010 AND type_rel = 2
0.0033	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2010 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 (70587,70823,93129,116599,173124) ORDER BY n.cover_points DESC, update_date DESC
0.0039	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 = '2010' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0043	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 = '2010' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0052	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=2010 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0022	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) 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.0044	SELECT count(id) as num_players from rel_players WHERE league_id = 72266 AND teamId = 2010
0.0029	SELECT count(id) as num_players from rel_players WHERE league_id = 72569 AND teamId = 2010
0.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 2010
0.0024	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 = '2010' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2010' and rp.type = 4
0.0022	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 = '2010' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0018	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '2010' and rp.type = 4
0.0053	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 = 2010 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.0039	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 = 2010 AND (e.action = 4 or e.action = 5) 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 = 2010 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029	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 = 2010 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 72266 AND t.round = 31 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* `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.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* `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.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* `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 = 58585 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2020` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 50275 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.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* `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.0029	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.0032	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.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* `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.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* `tables1989` 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 = 21801 AND t.round = 38 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* `tables1988` 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 = 21782 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

CF Pozuelo

CF Pozuelo

Selecciona un equipo

Competiciones que juega

Tercera Federación Grupo 7

RIVALES EN Copa Federación.

RIVALES EN Tercera Federaci.