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

Cerdanyola FC

Entrenador: Oliver Ballabriga

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA FEDERACIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Hércules	32	49	28	59
2	Lleida	32	44	28	58
3	CE Europa	32	56	32	57
4	Badalona	32	38	23	56
5	Sant Andreu	32	50	33	54
6	Terrassa FC	32	42	38	46
7	Torrent	32	37	35	45
8	Andratx	32	39	43	43
9	Espanyol B	32	37	37	43
10	UD Alzira	32	37	41	42
11	Valencia	32	48	39	42
12	Peña	32	44	56	41
13	Saguntino	32	32	40	41
14	Formentera	32	35	42	38
15	Cerdanyola	32	34	40	37
16	Penya	32	31	47	34
17	CE Manresa	32	22	39	26
18	Nucía	32	22	56	21

TEMPORADA 2022/2023

SEGUNDA FEDERACIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	UD Melilla	34	41	15	66
2	Atlético B	34	60	33	65
3	Navalcarnero	34	46	28	62
4	Cacereño	34	35	23	55
5	Gimnástica	34	48	44	52
6	Villanovense	34	29	25	50
7	Guadalajara	34	49	35	48
8	CD Estepona	34	35	26	47
9	Unión	34	43	43	46
10	Cerdanyola	34	28	45	41
11	Atlético	34	38	39	41
12	UD Montijo	34	33	47	39
13	CD Coria	34	31	43	39
14	Leganés B	34	31	39	37
15	Alcorcón B	34	34	42	35
16	Diocesano	34	33	43	34
17	Yugo	34	25	41	33
18	Benito	34	19	47	32

TEMPORADA 2021/2022

SEGUNDA FEDERACIÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Numancia	34	45	26	62
2	Espanyol B	34	54	46	57
3	Peña	34	45	33	56
4	CD Teruel	34	36	37	52
5	Lleida	34	38	39	52
6	Ibiza	34	47	37	50
7	Formentera	34	38	32	50
8	Terrassa FC	34	49	42	47
9	CD Ebro	34	35	29	47
10	Brea	34	32	34	45
11	SD Tarazona	34	36	37	42
12	AE Prat	34	33	36	42
13	Cerdanyola	34	45	48	42
14	Andratx	34	37	36	41
15	Badalona	34	29	34	41
16	CE Europa	34	33	50	38
17	Huesca B	34	37	44	37
18	Ejea	34	28	57	23

TEMPORADA 2020/2021

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	CE Europa	20	35	17	44
2	Vilafranca	20	33	16	40
3	Terrassa FC	20	23	11	35
4	Cristóbal	20	17	13	31
5	CE Manresa	20	21	16	29
6	Castelldefel	20	19	20	28
7	Pobla	20	27	25	26
8	Santfeliuenc	20	16	24	22
9	UE Valls	20	12	24	17
10	Igualada	20	14	32	13
11	Montañesa	20	10	29	12
12	Cerdanyola	20	31	15	40
13	Girona FC B	20	29	12	37
14	Granollers	20	32	22	33
15	Sant Andreu	20	24	21	31
16	Vilassar	20	21	21	30
17	FE Grama	20	22	28	27
18	CF Peralada	20	16	18	25
19	UE Sants	20	17	25	24
20	UE Figueres	20	19	32	21
21	UA Horta	20	20	26	18
22	Banyoles	20	13	24	15

TEMPORADA 2019/2020

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	L´Hospitale	27	59	28	59
2	Terrassa FC	27	42	19	53
3	CE Europa	27	59	31	50
4	Sant Andreu	27	45	28	50
5	CF Peralada	27	38	26	46
6	Pobla	27	37	26	45
7	Vilafranca	27	38	27	44
8	Vilassar	27	44	34	44
9	Granollers	27	50	34	43
10	CE Manresa	27	37	28	39
11	Castelldefel	27	37	37	38
12	UA Horta	27	39	48	36
13	Cerdanyola	27	37	38	35
14	UE Figueres	27	43	48	31
15	Cristóbal	27	31	38	31
16	Santfeliuenc	27	31	44	29
17	Banyoles	27	22	35	28
18	Igualada	27	28	46	25
19	UE Sants	27	29	50	22
20	Reus	27	0	81	0

TEMPORADA 2018/2019

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Badalona	40	75	31	83
2	L´Hospitale	40	71	31	80
3	UA Horta	40	57	32	79
4	AE Prat	40	51	22	75
5	Sant Andreu	40	65	34	71
6	CE Europa	40	53	41	63
7	Reus	40	58	41	63
8	Terrassa FC	40	52	45	63
9	Vilafranca	40	53	42	62
10	Granollers	40	54	42	61
11	Cerdanyola	40	40	46	50
12	UE Figueres	40	36	46	49
13	Santfeliuenc	40	56	58	49
14	Pobla	40	44	46	48
15	Cristóbal	40	52	70	48
16	Castelldefel	40	39	56	43
17	UE Sants	40	37	56	43
18	FE Grama	40	30	57	33
19	Santboià	40	24	66	31
20	Ascó	40	31	65	30
21	Martinenc	40	34	85	26

TEMPORADA 2017/2018

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Espanyol B	38	74	25	90
2	Sant Andreu	38	61	24	71
3	L´Hospitale	38	61	31	71
4	Terrassa FC	38	60	38	64
5	AE Prat	38	57	35	63
6	Pobla	38	40	25	63
7	Ascó	38	47	41	60
8	CE Europa	38	48	46	58
9	Vilafranca	38	48	42	54
10	UE Figueres	38	47	43	53
11	UA Horta	38	47	52	50
12	Cerdanyola	38	35	43	48
13	Santboià	38	35	37	48
14	Reus	38	40	50	47
15	Santfeliuenc	38	43	42	46
16	Castelldefel	38	40	46	44
17	Granollers	38	32	54	38
18	Palamós	38	38	64	31
19	CF Gavá	38	28	87	21
20	Vilassar	38	24	80	18

TEMPORADA 2016/2017

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Olot	38	73	38	80
2	CF Peralada	38	68	27	77
3	Terrassa FC	38	48	26	66
4	Vilafranca	38	60	37	64
5	Sant Andreu	38	51	40	60
6	Ascó	38	44	37	57
7	Pobla	38	43	36	55
8	Granollers	38	47	54	50
9	UE Figueres	38	39	41	50
10	Vilassar	38	40	44	50
11	Palamós	38	49	55	49
12	CE Europa	38	28	32	47
13	Santfeliuenc	38	39	44	45
14	Cerdanyola	38	43	51	45
15	Castelldefel	38	34	51	42
16	Jonquera	38	19	29	42
17	Montañesa	38	32	48	42
18	Manlleu	38	41	59	40
19	Júpiter	38	32	52	35
20	Sabadell B	38	34	63	31

TEMPORADA 2015/2016

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	AE Prat	38	62	26	76
2	CF Gavá	38	69	38	70
3	CE Europa	38	60	33	68
4	Vilafranca	38	68	55	66
5	Montañesa	38	52	35	65
6	Sabadell B	38	57	41	62
7	Sant Andreu	38	54	46	55
8	Cerdanyola	38	52	50	54
9	Júpiter	38	60	68	51
10	UE Figueres	38	48	40	51
11	Ascó	38	35	43	49
12	Palamós	38	54	54	48
13	Terrassa FC	38	43	61	48
14	CF Peralada	38	50	54	47
15	Manlleu	38	44	58	47
16	Santfeliuenc	38	47	55	45
17	Granollers	38	52	63	44
18	Rubí	38	38	57	39
19	Morell	38	29	70	28
20	Masnou	38	40	67	26

TEMPORADA 2014/2015

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Ascó	38	61	34	72
2	Pobla	38	54	30	69
3	CE Europa	38	53	32	68
4	UE Figueres	38	46	44	59
5	Vilafranca	38	57	56	59
6	AE Prat	38	49	34	59
7	Terrassa FC	38	56	42	59
8	Rubí	38	47	40	54
9	Masnou	38	40	48	51
10	Cerdanyola	38	44	49	49
11	Palamós	38	52	53	49
12	CF Peralada	38	41	50	49
13	Montañesa	38	41	40	48
14	CF Gavá	38	42	54	48
15	Sabadell B	38	46	49	47
16	Santfeliuenc	38	41	48	47
17	Manlleu	38	51	54	45
18	Castelldefel	38	39	47	41
19	Martinenc	38	49	70	37
20	Vilassar	38	28	63	28

TEMPORADA 2013/2014

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Cornellà	38	58	40	73
2	Montañesa	38	61	31	73
3	CE Europa	38	52	29	69
4	Terrassa FC	38	55	35	69
5	Rubí	38	58	37	69
6	Ascó	38	53	40	68
7	Palamós	38	62	53	61
8	Pobla	38	45	37	57
9	Santfeliuenc	38	46	41	57
10	Manlleu	38	39	39	50
11	UE Figueres	38	51	52	47
12	Cerdanyola	38	52	58	46
13	Vilafranca	38	41	50	44
14	Masnou	38	36	46	44
15	CF Gavá	38	43	52	42
16	Castelldefel	38	47	50	42
17	Vilassar	38	35	49	42
18	Santboià	38	47	54	40
19	Rapitenca	38	31	67	31
20	Gramanet	38	25	77	18

TEMPORADA 2012/2013

PRIMERA CATALANA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Cerdanyola	34	62	32	73
2	Masnou	34	63	57	56
3	UA Horta	34	58	38	55
4	Jonquera	34	55	44	53
5	Cd Montcada	34	54	46	52
6	Farners	34	49	49	49
7	CF Peralada	34	50	41	48
8	Guíxols	34	46	45	46
9	Avià	34	59	59	46
10	Mollet	34	57	62	46
11	Vilassar	34	54	53	44
12	Cristóbal	34	40	45	43
13	Lloret	34	45	55	43
14	Granollers	34	49	53	42
15	Sant Cugat	34	44	50	39
16	Sant Quirze	34	53	66	39
17	Gramanet B	34	41	62	35
18	Ripollet	34	34	56	24

TEMPORADA 2011/2012

PRIMERA CATALANA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	UE Figueres	34	69	28	78
2	Vilassar	34	64	31	69
3	Palamós	34	66	29	67
4	Cristóbal	34	53	50	63
5	Cerdanyola	34	57	41	54
6	Mollet	34	61	44	53
7	UE Avià	34	61	59	48
8	Farners	34	63	63	45
9	Cf Lloret	34	48	59	45
10	Ripollet	34	65	65	44
11	Montcada	34	52	61	44
12	Guíxols	34	44	54	42
13	CF Peralada	34	58	58	41
14	Gramanet B	34	49	66	40
15	San Lorenzo	34	38	54	38
16	Premià	34	35	59	32
17	CE Manresa	34	45	65	28
18	Junior	34	32	74	24

TEMPORADA 1996/1997

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Palamós	40	87	35	88
2	Barcelona C	40	88	38	84
3	Badaloní	40	76	56	75
4	CE Europa	40	78	50	74
5	Tortosa	40	57	35	70
6	Vilobi FC	40	65	59	61
7	Tàrrega	40	56	55	61
8	Premià	40	54	42	60
9	Mataró	40	67	47	59
10	Santboià	40	51	55	55
11	Vilafranca	40	42	51	52
12	Rubí	40	44	51	51
13	Vilassar	40	54	62	51
14	Júpiter	40	58	68	51
15	Banyoles	40	46	62	51
16	Cerdanyola	40	73	82	50
17	Roda Barà	40	54	57	50
18	Balaguer	40	40	56	50
19	Girona	40	44	80	26
20	Granollers	40	36	72	26
21	UE Sants	40	39	96	25

TEMPORADA 1995/1996

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Tàrrega	38	80	35	73
2	CE Europa	38	71	45	70
3	Santboià	38	64	47	68
4	Palamós	38	50	32	63
5	Roda Barà	38	55	46	55
6	Premià	38	54	53	55
7	Balaguer	38	52	49	53
8	Vilobi FC	38	60	48	52
9	Tortosa	38	56	50	51
10	Mataró	38	53	58	51
11	Banyoles	38	50	59	48
12	Cerdanyola	38	35	44	48
13	Granollers	38	40	44	47
14	Girona	38	43	55	47
15	UE Sants	38	42	60	47
16	Júpiter	38	60	63	46
17	Rubí	38	47	46	45
18	UA Horta	38	43	63	44
19	Igualada	38	48	75	43
20	Guíxols	38	40	71	30

TEMPORADA 1994/1995

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Espanyol B	38	72	27	59
2	Tàrrega	38	70	36	52
3	Barcelona C	38	101	42	52
4	Vilobi FC	38	68	51	48
5	UA Horta	38	43	33	43
6	CF Gavá	38	66	52	42
7	Balaguer	38	44	40	40
8	Igualada	38	48	42	40
9	Roda Barà	38	47	49	40
10	Júpiter	38	68	66	39
11	UE Sants	38	51	57	37
12	Tortosa	38	59	55	36
13	Banyoles	38	54	56	35
14	Cerdanyola	38	61	65	35
15	Rubí	38	43	59	33
16	Granollers	38	31	41	32
17	CE Manresa	38	43	73	31
18	Badalona	38	45	68	30
19	Martinenc	38	40	59	30
20	Reus	38	16	99	6

TEMPORADA 1993/1994

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	CE Sabadell	38	76	33	54
2	Terrassa FC	38	65	41	53
3	Barcelona C	38	91	49	49
4	CE Europa	38	70	55	49
5	Balaguer	38	75	40	46
6	Badalona	38	64	50	45
7	Vilobi FC	38	57	50	42
8	Martinenc	38	69	53	41
9	Cristinenc	38	43	52	38
10	Cerdanyola	38	50	50	37
11	Júpiter	38	54	65	36
12	Igualada	38	51	60	36
13	Reus	38	57	56	35
14	Tortosa	38	44	62	32
15	UE Sants	38	49	57	31
16	Roda Barà	38	35	51	31
17	Granollers	38	51	66	30
18	Palafrugell	38	62	89	29
19	Olot	38	33	68	26
20	Blanes	38	30	79	20

Competiciones que juega

Segunda Federación Grupo 3

Pos	Equipos		Pts
1		Hércules	59
2		Lleida Esportiu	58
3		CE Europa	57
4		CF Badalona Futur	56
5		UE Sant Andreu	54
6		Terrassa FC	46
7		Torrent	45
8		Andratx	43
9		Espanyol B	43
10		UD Alzira	42
11		Valencia Mestalla	42
12		Peña Deportiva	41
13		At. Saguntino	41
14		SD Formentera	38
15		Cerdanyola FC	37
16		Penya Independent	34
17		CE Manresa	26
18		CF La Nucía	21

	Ascenso : Hércules
	Playoff Ascenso : Lleida Esportiu, CE Europa, CF Badalona Futur, UE Sant Andreu
	Playoff Descenso : At. Saguntino
	Descenso : SD Formentera, Cerdanyola FC, Penya Independent, CE Manresa, CF La Nucía

RIVALES EN Segunda Federaci.

USO DE MEMORIA

7,773,624 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6417
Total Execution Time	0.6429

CADENA URL

/historico/Cerdanyola-Valles-Fc

GET DATOS

$_GET['/historico/Cerdanyola-Valles-Fc']

POST DATOS

No hay datos POST existentes

CONSULTAS (39)

0.0149	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 = 'Cerdanyola-Valles-Fc' 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.0129	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=6089 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=6089 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=6089 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127	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=6089 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0137	SELECT c., l., cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 72554
0.0129	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6089 AND type_rel = 2
0.0131	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6089 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0138	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 (93103,159913,240533,822157,887292) ORDER BY n.cover_points DESC, update_date DESC
0.0160	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 = '6089' ORDER BY l.year DESC,cat.coefficient DESC
0.0149	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 = '6089' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0152	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 = '6089' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0150	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=6089 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0136	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 (72554,72364,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.0146	SELECT count(id) as num_players from rel_players WHERE league_id = 72364 AND teamId = 6089
0.0144	SELECT count(id) as num_players from rel_players WHERE league_id = 72554 AND teamId = 6089
0.0152	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 6089
0.0147	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 = 72364 AND t.round = 33 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127	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 = '6089' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6089' and rp.type = 4
0.0126	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 = '6089' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0139	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 = 72364 WHERE rp.league_id = 72364 AND rp.teamId = 6089 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.0137	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 = 72364 WHERE rp.league_id = 72364 AND rp.teamId = 6089 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133	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 = 72364 WHERE rp.league_id = 72364 AND rp.teamId = 6089 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130	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 = 6089 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 67969 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.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* `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 = 62382 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.0130	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 = 58583 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.0129	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 = 50273 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.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* `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 = 44393 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 39029 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 15446 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 3915 AND t.round = 38 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* `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 = 2555 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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* `tables2013` 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 = 1983 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 1458 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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* `tables1997` 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 = 21968 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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* `tables1996` 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 = 21947 AND t.round = 38 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* `tables1995` 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 = 21927 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Cerdanyola FC

Cerdanyola FC

Selecciona un equipo

Competiciones que juega

Segunda Federación Grupo 3

RIVALES EN Segunda Federaci.