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

CD Puebla

Temporada 2023/2024

TEMPORADA 2023/2024

1ª AUTO. CASTILLA-LA MANCHA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	CD Bargas	29	65	28	62
2	CD Mocejon	29	49	20	62
3	Orgaceño	29	60	22	61
4	Poligono	29	61	25	60
5	CD Urda	30	61	31	55
6	Yébenes	29	50	34	50
7	Consuegra	30	56	38	50
8	Noves	29	43	42	41
9	Polan	29	46	53	39
10	Calera	29	39	40	39
11	Arges Futbol	30	59	74	35
12	CDEEF	30	36	55	25
13	Mentrida	29	34	81	23
14	Casarrubios	29	35	78	22
15	CD Puebla	29	26	68	19
16	Escalona	29	25	56	18

TEMPORADA 2022/2023

1ª AUTO. CASTILLA-LA MANCHA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Torpedo 66	30	80	29	66
2	Fuensalida	30	55	23	64
3	CD Sonseca	29	86	27	62
4	CD Mocejon	30	79	33	61
5	Santa Cruz.	30	41	38	50
6	Arges Futbol	30	59	49	44
7	Recas	29	52	47	44
8	Calera	30	49	52	43
9	CDEEF	30	61	46	42
10	Villaseca	30	65	73	41
11	CD Puebla	30	51	61	39
12	Noves	30	45	53	35
13	Mentrida	30	55	82	34
14	Polan	30	37	66	23
15	Corazon	30	23	87	14
16	Guadamur	30	28	100	14

TEMPORADA 2021/2022

1ª AUTO. CASTILLA-LA MANCHA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	CD Sonseca	30	92	27	70
2	CD Bargas	29	72	23	65
3	Fuensalida	30	69	26	63
4	Villaseca	29	64	53	51
5	Calera	28	38	29	48
6	Arges Futbol	29	60	48	46
7	Santa Cruz.	28	51	50	45
8	Noves	30	60	75	36
9	Guadamur	29	35	55	34
10	CDEEF	29	43	70	34
11	CD Puebla	30	41	46	32
12	Corazon	29	43	57	32
13	Mentrida	28	42	56	30
14	Talavera	30	43	65	27
15	Benquerencia	30	43	65	25
16	Mora B	28	22	73	14

TEMPORADA 2020/2021

PREFERENTE C. LA MANCHA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Hogar	21	42	12	45
2	Talavera	21	43	22	41
3	Cabanillas	21	33	19	39
4	CD Yuncos	21	38	25	36
5	Torpedo 66	21	33	33	32
6	CD Pantoja	21	35	27	32
7	Yunquera CD	21	29	24	31
8	ACDM Horche	21	29	22	28
9	Seseña	21	24	36	27
10	CD Mocejon	21	21	20	26
11	CDEEF	21	28	55	23
12	Casarrubios	21	23	35	22
13	CD Puebla	21	25	39	16
14	CD Qum FC	21	23	57	7

TEMPORADA 2019/2020

PREFERENTE C. LA MANCHA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Marchamalo	26	63	9	66
2	Mora CF	26	51	24	52
3	Hogar	26	49	28	50
4	CD Noblejas	26	39	25	46
5	CD Toledo B	26	46	33	45
6	Cabanillas	26	37	25	45
7	CD Yuncos	26	37	20	44
8	CD Sonseca	26	40	26	40
9	Seseña	26	39	44	33
10	Orgaceño	26	33	33	32
11	CD Mocejon	26	26	38	31
12	CD Urda	26	28	41	30
13	CD Qum FC	26	27	37	29
14	Formacion	26	21	45	26
15	CD Pantoja	26	20	32	25
16	ACDM Horche	26	16	46	24
17	CD Puebla	26	16	44	20
18	CDEEF	26	21	59	13

TEMPORADA 2018/2019

1ª AUTO. CASTILLA-LA MANCHA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	CDEEF	30	68	31	65
2	Orgaceño	30	74	34	64
3	CD Puebla	30	69	42	63
4	Consuegra	30	49	27	54
5	Yébenes	30	63	34	52
6	Fuensalida	30	52	46	43
7	Calera	30	55	57	42
8	Santa Cruz.	30	42	51	41
9	Arges Futbol	30	53	57	40
10	Talavera	30	45	59	39
11	CD Bargas	29	53	48	38
12	Casarrubios	29	60	58	35
13	Atletico	30	51	66	31
14	Cazalegas	30	52	77	29
15	Mentrida	30	48	63	27
16	Yepes CF	30	26	110	7

TEMPORADA 2017/2018

1ª AUTO. CASTILLA-LA MANCHA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	CD Torrijos	30	82	15	82
2	Villa CD	30	73	24	71
3	Santa Cruz.	30	44	28	59
4	CD Noblejas	29	61	36	55
5	CF Almaguer	29	54	34	49
6	Arges Futbol	30	54	60	41
7	Orgaceño	30	58	55	39
8	Talavera	29	42	50	38
9	CD Puebla	30	39	69	35
10	Fuensalida	30	48	54	34
11	Almoradiel	30	70	69	33
12	Atletico	29	38	56	32
13	Calera	30	33	58	31
14	Añover Tajo	29	30	48	30
15	Yepes CF	29	35	60	29
16	Mora B	30	25	70	12

TEMPORADA 2016/2017

1ª AUTO. CASTILLA-LA MANCHA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	CDEEF	30	77	26	69
2	CD Mocejon	30	91	45	62
3	Recas	30	58	34	61
4	Orgaceño	30	61	30	58
5	Valmojado	30	56	42	55
6	Talavera	30	56	40	49
7	Cobeja UD	30	63	42	48
8	Añover Tajo	30	48	44	48
9	Arges Futbol	29	45	44	46
10	Alameda	30	44	61	36
11	Casarrubios	30	41	62	32
12	CD Puebla	30	29	49	27
13	Mora B	30	42	63	27
14	Velada	29	31	57	25
15	Guadamur	30	41	114	19
16	Ciudad	30	30	60	15

TEMPORADA 2015/2016

1ª AUTO. CASTILLA-LA MANCHA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Corazon	30	58	21	71
2	Fuensalida	30	54	32	62
3	Formacion	30	66	34	60
4	CD Mocejon	30	63	43	57
5	Orgaceño	30	53	36	53
6	CDEEF	30	59	41	48
7	Mora B	30	68	47	47
8	Consuegra	30	46	46	41
9	CD Puebla	30	31	46	39
10	Gerindote	30	39	46	39
11	Recas	30	36	43	38
12	Ciudad	30	36	44	37
13	Valmojado	30	40	66	29
14	Guadamur	30	45	64	23
15	Camarena	30	44	72	22
16	Cd Sagreño	30	26	83	14

TEMPORADA 2014/2015

1ª AUTO. CASTILLA-LA MANCHA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Calera	30	72	33	63
2	Arges Futbol	30	77	38	62
3	Talavera	30	61	29	62
4	Fuensalida	30	58	31	56
5	Corazon	30	55	36	55
6	Orgaceño	30	54	42	49
7	Villaseca	30	61	59	41
8	CD Mocejon	30	66	63	40
9	Valmojado	30	47	59	35
10	Consuegra	30	44	56	34
11	Guadamur	30	47	58	32
12	Poligono	30	40	61	32
13	CD Puebla	30	46	70	32
14	Camarena	30	44	57	31
15	Oropesa	30	39	74	29
16	Villaluenga	30	42	87	20

Competiciones que juega

Grupo 3

1ª Auto. Castilla-La Mancha Grupo 3

Pos	Equipos		Pts
1		CD Bargas	62
2		CD Mocejon	62
3		CF Orgaceño	61
4		Poligono Toledo	60
5		CD Urda	55
6		CD Los Yébenes	50
7		At. Consuegra	50
8		Noves	41
9		Polan	39
10		Calera	39
11		Arges Futbol	35
12		CDEEF Patrocinio	25
13		Mentrida	23
14		Casarrubios Balompie	22
15		CD Puebla	19
16		Escalona	18

RIVALES EN 1ª Auto. Castill.

USO DE MEMORIA

6,033,456 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1050
Total Execution Time	0.1062

CADENA URL

/historico/Puebla

GET DATOS

$_GET['/historico/Puebla']

POST DATOS

No hay datos POST existentes

CONSULTAS (29)

0.0029	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 = 'Puebla' 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=30504 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=30504 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=30504 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=842 AND type_rel = 3
0.0024	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 842 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0025	SELECT /53 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 (915689,634735,309041,225873,64036) 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 = '30504' ORDER BY l.year DESC,cat.coefficient DESC
0.0023	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 = '30504' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0023	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 = '30504' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024	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=30504 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018	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 (73953) 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.0029	SELECT count(id) as num_players from rel_players WHERE league_id = 73953 AND teamId = 30504
0.0021	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 = '30504' 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 = '30504' and rp.type = 4
0.0021	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 = '30504' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0045	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 = 73953 WHERE rp.league_id = 73953 AND rp.teamId = 30504 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.0046	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 = 73953 WHERE rp.league_id = 73953 AND rp.teamId = 30504 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0036	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 = 73953 WHERE rp.league_id = 73953 AND rp.teamId = 30504 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024	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 = 30504 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 73953 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.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* `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 = 69451 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 = 64484 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* `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 = 58934 AND t.round = 21 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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* `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 = 45379 AND t.round = 30 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 = 39794 AND t.round = 30 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 = 34567 AND t.round = 30 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* `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 = 16793 AND t.round = 30 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* `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 = 5246 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

CD Puebla

CD Puebla

Selecciona un equipo

Competiciones que juega

1ª Auto. Castilla-La Mancha Grupo 3

RIVALES EN 1ª Auto. Castill.