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 Ciudad

Temporada 2023/2024

TEMPORADA 2023/2024

TERCERA GALICIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Sporting	27	97	13	75
2	Imperator	27	90	28	64
3	Eiris SD	27	83	27	56
4	Liceo	27	72	29	56
5	Maravillas	27	71	25	54
6	Coruña	27	70	30	49
7	Cd Calasanz	27	59	38	45
8	Ciudad	27	69	51	37
9	Sada	27	50	53	36
10	Sin Querer	27	55	64	32
11	S.D. Santa.	27	45	64	31
12	Galicia	27	32	66	21
13	Unión	27	36	66	21
14	CD Ciudad	27	34	83	21
15	Vioño CF	27	34	93	16
16	Deportivo	27	12	179	1

TEMPORADA 2022/2023

TERCERA GALICIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Sporting	30	114	22	73
2	Marte CD	30	87	29	73
3	Imperator	30	107	36	65
4	Liceo	30	96	42	63
5	Atletico	30	94	43	62
6	Maravillas	30	104	47	60
7	Coruña	30	66	39	58
8	Ciudad	30	85	57	43
9	Sin Querer	29	51	59	36
10	CD Ciudad	30	56	56	35
11	Eiris SD	30	59	62	35
12	S.D. Santa.	30	72	83	33
13	Vioño CF	29	34	96	19
14	Unión	30	44	99	17
15	Galicia	30	25	157	8
16	Deportivo	30	31	198	6

TEMPORADA 2021/2022

TERCERA GALICIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Sin Querer	24	59	31	55
2	Sada	24	62	41	49
3	CD Ciudad	24	64	27	47
4	Eiris SD	24	56	27	45
5	Maravillas	24	55	36	42
6	Liceo	24	52	29	41
7	S.D. Santa.	24	50	36	40
8	Ciudad	24	43	31	33
9	Coruña	24	51	54	32
10	Unión	24	50	69	26
11	Deportivo	24	48	68	22
12	Vioño CF	24	28	74	8
13	Galicia	24	24	119	4

TEMPORADA 2019/2020

TERCERA GALICIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Marte CD	20	46	15	45
2	Atlético	19	58	31	42
3	Sin Querer	19	62	14	41
4	Cd Calasanz	20	44	29	38
5	Unión	20	47	36	36
6	Galicia	20	46	31	32
7	CD Ciudad	20	51	30	31
8	Ciudad	20	41	44	29
9	Maravillas	20	30	52	23
10	S.D. Santa.	20	24	56	21
11	Liceo	19	22	44	16
12	Vioño CF	20	29	52	15
13	Eiris SD	19	22	57	13
14	Deportivo	20	23	54	11

TEMPORADA 2018/2019

SEGUNDA GALICIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Club Caion	34	84	29	81
2	Sporting	33	78	46	67
3	Abella Sdc	34	59	31	66
4	Torre SD	34	78	62	63
5	Vizoño	34	57	30	60
6	Queixas	34	75	57	55
7	Martiño	33	44	45	48
8	Santa Cruz.	34	55	52	44
9	Atletico	34	46	58	43
10	Español	34	53	55	42
11	Relámpago	34	49	60	41
12	Juvenil	34	39	53	41
13	Sporting	34	60	67	40
14	Visantoña	34	50	52	38
15	CD Obrero	34	44	63	34
16	CD Ciudad	34	51	87	32
17	Marino CF	34	48	78	28
18	Portazgo	34	46	91	22

TEMPORADA 2017/2018

TERCERA GALICIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	CD Obrero	25	92	29	62
2	CD Ciudad	26	89	28	59
3	Xuventude	26	84	28	59
4	Juvenil S.D.	26	67	34	51
5	Suevos CF	26	75	46	46
6	Orzán Sd	26	66	59	40
7	Aranga	26	68	64	37
8	Ozacesuras	26	72	61	36
9	Maravillas	26	49	50	36
10	Brexo Lema	26	69	73	30
11	Sobrado	25	36	85	19
12	Unión	26	40	106	17
13	Sigras CD	26	38	63	15
14	Vizoño B	26	27	146	9
15	Miguel	0	0	0	0
16	UD America	0	0	0	0

TEMPORADA 2016/2017

TERCERA GALICIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Relámpago	31	144	19	84
2	Español	33	104	20	84
3	CD Ciudad	33	107	36	71
4	Atlético	32	101	55	62
5	C.D.	32	100	50	60
6	Liceo	32	86	46	56
7	Orzán Sd	32	82	44	53
8	Marte CD	33	71	67	53
9	Cd Calasanz	33	81	47	52
10	Galicia	33	81	58	51
11	Eiris SD	33	87	89	46
12	Juvenil S.D.	33	58	85	30
13	S.D. Santa.	32	64	83	28
14	Compañía	32	60	127	25
15	Unión	33	50	159	21
16	Miguel	33	44	93	19
17	Peñarredond	11	30	26	13
18	Deportivo	33	10	255	1

TEMPORADA 2015/2016

SEGUNDA GALICIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Universidade	33	99	15	87
2	Torre SD	32	95	36	71
3	Sporting	33	87	43	67
4	Ciudad	33	77	40	67
5	Sin Querer	32	58	43	65
6	CD Ciudad	33	80	43	62
7	Español	33	62	33	61
8	Galicia	33	73	63	58
9	Relámpago	33	77	56	53
10	Juvenil S.D.	33	55	48	50
11	Atlético	33	68	85	32
12	C.D.	33	50	97	29
13	Cd Calasanz	32	45	79	26
14	Marte CD	33	49	90	26
15	Orzán Sd	32	36	73	25
16	Marola CF	33	37	88	22
17	Cocteleira	17	24	43	16
18	Liceo	33	20	117	3

TEMPORADA 2014/2015

PRIMERA GALICIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	UD Paiosaco	34	73	40	64
2	Tirso	34	49	39	64
3	Victoria CF	34	72	35	62
4	Marino CF	34	56	38	55
5	Boimorto CF	34	74	59	50
6	Olimpico CF	34	66	57	49
7	Cedeira SD	34	47	35	48
8	Rapido Neda	34	42	44	48
9	Ud Carral	34	70	66	47
10	Club Caion	34	39	35	46
11	Orillamar	34	55	52	46
12	Eume	34	63	57	45
13	Sporting	34	59	51	43
14	Imperator	34	47	50	43
15	Narón BP	34	64	76	43
16	Meiras CF	34	30	66	32
17	CD Ciudad	34	42	101	29
18	Cultural	34	38	85	27

Competiciones que juega

Grupo 1

Tercera Galicia Grupo 1

Pos	Equipos		Pts
1		Sporting Coruñés	75
2		Imperator OAR	64
3		Eiris SD	56
4		Liceo de Monelos	56
5		Maravillas S.D.	54
6		Coruña Arboco Club de Fútb.	49
7		Cd Calasanz	45
8		SCD Ciudad Jardín	37
9		Sada Atlético Club Futbol	36
10		Sin Querer	32
11		S.D. Santa Margarita	31
12		Galicia Gaiteira	21
13		Unión Sportiva	21
14		CD Ciudad	21
15		Vioño CF	16
16		C Deportivo Cristal	1

	Ascenso : Sporting Coruñés, Imperator OAR, Eiris SD, Liceo de Monelos

RIVALES EN Tercera Galicia

USO DE MEMORIA

5,779,560 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.4920
Total Execution Time	0.4932

CADENA URL

/historico/Cd-Ciudad

GET DATOS

$_GET['/historico/Cd-Ciudad']

POST DATOS

No hay datos POST existentes

CONSULTAS (29)

0.0168	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 = 'Cd-Ciudad' 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.0131	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=18880 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130	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=18880 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18880 AND type_rel = 2
0.0140	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 = '18880' ORDER BY l.year DESC,cat.coefficient DESC
0.0137	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 = '18880' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0132	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 = '18880' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0130	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 = 73754 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0137	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=18880 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0130	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 (73754) 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.0130	SELECT count(id) as num_players from rel_players WHERE league_id = 73754 AND teamId = 18880
0.0143	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 = 73754 AND t.round = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0135	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 = '18880' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0127	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '18880' and rp.type = 4
0.0134	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 = '18880' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0136	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 = 73754 WHERE rp.league_id = 73754 AND rp.teamId = 18880 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.0135	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 = 73754 WHERE rp.league_id = 73754 AND rp.teamId = 18880 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136	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 = 73754 WHERE rp.league_id = 73754 AND rp.teamId = 18880 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0143	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 = 18880 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0142	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 = 73754 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140	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 = 69299 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.0139	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 = 65415 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140	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 = 51549 AND t.round = 20 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142	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 = 45174 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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 = 39852 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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 = 35500 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 16816 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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 = 4051 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127	SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 73754 ORDER BY nameShow LIMIT 100

CD Ciudad

CD Ciudad

Selecciona un equipo

Competiciones que juega

Tercera Galicia Grupo 1

RIVALES EN Tercera Galicia