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 Cuarte

Entrenador: Loreto

Temporada 2023/2024

TEMPORADA 2023/2024

TERCERA FEDERACIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	Ejea	32	45	24	63
2	CD Ebro	32	45	22	60
3	CD Cuarte	32	42	22	59
4	Caspe	32	41	31	58
5	CF Epila	32	46	30	53
6	Calamocha	32	36	26	49
7	Almudévar	32	34	27	49
8	Fraga	32	48	37	47
9	CD Utrillas	32	41	38	46
10	Huesca B	32	38	33	45
11	Atlético	32	25	22	45
12	Tamarite	32	48	51	40
13	CD Binéfar	32	35	48	35
14	Fuentes	32	33	44	34
15	Belchite	32	31	47	29
16	Illueca	32	24	49	24
17	SD Borja	32	14	39	22
18	Cariñena	32	32	68	19

TEMPORADA 2022/2023

TERCERA FEDERACIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	Robres	30	48	29	60
2	Barbastro	30	45	25	53
3	Huesca B	30	54	33	51
4	Ejea	30	47	33	48
5	Tamarite	30	44	41	48
6	Almudévar	30	36	28	47
7	Illueca	30	37	38	47
8	CF Epila	30	35	29	41
9	CD Utrillas	30	33	38	39
10	Calamocha	30	23	26	38
11	CD Binéfar	30	42	38	37
12	Caspe	30	30	39	36
13	CD Cuarte	30	27	34	35
14	Atlético	30	24	33	28
15	Cariñena	30	34	65	24
16	Almunia	30	34	64	22

TEMPORADA 2021/2022

TERCERA FEDERACIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	Deportivo	32	65	29	67
2	Utebo	32	63	28	66
3	Illueca	32	47	31	65
4	CD Binéfar	32	54	30	56
5	Robres	32	45	32	53
6	CD Cuarte	32	46	27	52
7	Atlético	32	40	23	49
8	Barbastro	32	36	29	48
9	Caspe	32	46	37	48
10	CF Epila	32	39	37	48
11	Cariñena	32	36	45	45
12	Calamocha	32	36	40	36
13	Belchite	32	35	43	33
14	Santa	32	31	40	33
15	SD Borja	32	31	48	29
16	Giner	32	23	97	18
17	Biescas	32	10	67	10

TEMPORADA 2020/2021

TERCERA DIVISIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	CD Teruel	22	34	11	49
2	Huesca B	22	36	18	45
3	Belchite	22	22	9	35
4	Deportivo	22	32	14	34
5	Illueca	22	23	16	34
6	CD Binéfar	22	29	17	32
7	Atlético	22	26	19	31
8	Cariñena	22	21	23	27
9	Tamarite	22	19	29	25
10	Valdefierro	22	20	36	22
11	Fraga	22	17	21	22
12	AD San Juan	22	0	66	0
13	Brea	22	34	12	42
14	CD Cuarte	22	32	21	39
15	Utebo	22	21	15	37
16	Barbastro	22	27	18	36
17	SD Borja	22	29	23	31
18	Calamocha	22	24	19	30
19	Sariñena	22	36	36	29
20	CF Epila	22	23	23	26
21	Robres	22	23	31	26
22	Almudévar	22	17	32	22
23	Villanueva	22	16	39	18
24	Sabiñánigo	22	24	37	14

TEMPORADA 2019/2020

TERCERA DIVISIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	SD Tarazona	28	58	20	65
2	CD Teruel	29	53	19	63
3	Brea	29	41	23	54
4	Deportivo	28	51	23	51
5	CD Cuarte	28	39	32	50
6	AD San Juan	28	38	30	46
7	SD Borja	28	37	29	45
8	Illueca	28	42	37	43
9	Sariñena	29	36	32	43
10	CD Binéfar	29	34	30	41
11	Barbastro	29	35	33	39
12	Fraga	29	35	33	37
13	Utebo	29	37	41	32
14	Atlético	29	24	34	32
15	Robres	29	31	39	28
16	Tamarite	29	27	45	28
17	Calamocha	28	32	48	27
18	Belchite	29	21	35	26
19	Villanueva	29	23	48	24
20	Valdefierro	28	22	56	22
21	Almudévar	28	18	47	19

TEMPORADA 2018/2019

PREFERENTE ARAGÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	CD Cuarte	34	69	28	72
2	Barbastro	34	54	27	71
3	CF Epila	34	52	39	59
4	Santa	34	55	47	59
5	Zuera	34	60	58	50
6	José	34	53	51	47
7	Biescas	34	39	44	47
8	Villa	34	48	49	46
9	Zaragoza	34	49	48	45
10	Mallén	34	37	45	45
11	Peña	34	48	41	43
12	Tardienta	34	43	46	43
13	AD Magallon	34	43	47	43
14	Actur Pablo	34	40	45	43
15	Gallur CD	34	40	52	42
16	Jacetano	34	42	51	41
17	Grañén	34	40	64	29
18	Altorricón	34	35	65	25

TEMPORADA 2017/2018

PREFERENTE ARAGÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	AD San Juan	34	69	26	74
2	Calamocha	34	66	31	69
3	Mequinenza	34	64	34	62
4	Fuentes	33	45	31	56
5	Calatayud	34	59	48	56
6	CF Epila	34	48	34	54
7	CD Cuarte	34	59	40	52
8	Alcañiz	34	51	40	51
9	Andorra	34	51	44	49
10	Actur Pablo	34	56	47	48
11	Cella	34	45	41	48
12	José	34	57	52	47
13	CD Utrillas	34	46	54	42
14	Mores CD	34	22	34	34
15	Teruel	33	24	74	25
16	Alfindén	34	32	65	24
17	Morata CD	34	29	70	23
18	Atlético	34	24	82	21

TEMPORADA 2016/2017

TERCERA DIVISIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	Deportivo	38	85	30	85
2	SD Tarazona	38	68	46	66
3	Utebo	38	60	38	66
4	Ejea	38	59	38	64
5	CD Teruel	38	65	39	62
6	SD Borja	38	48	35	60
7	Almudévar	38	66	49	57
8	Robres	38	46	45	55
9	Illueca	38	50	42	53
10	Sabiñánigo	38	53	51	53
11	Tamarite	38	56	69	51
12	Brea	38	48	55	48
13	CD Binéfar	38	40	41	45
14	Cariñena	38	55	64	45
15	Belchite	38	35	60	44
16	Sariñena	38	42	60	44
17	CD Cuarte	38	50	66	43
18	Atlético	38	46	60	39
19	CF Epila	38	38	75	36
20	Andorra	38	34	81	27

TEMPORADA 2015/2016

TERCERA DIVISIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	Deportivo	38	70	19	83
2	Andorra	38	64	31	82
3	SD Tarazona	38	70	33	73
4	CD Teruel	38	69	38	71
5	Sariñena	38	52	26	68
6	Ejea	38	66	38	66
7	Almudévar	38	65	37	64
8	Utebo	38	59	58	61
9	Cariñena	38	50	61	49
10	CD Binéfar	38	36	48	47
11	Atlético	38	54	58	45
12	SD Borja	38	27	36	45
13	Illueca	38	46	63	43
14	CD Cuarte	38	40	52	41
15	Sabiñánigo	38	35	47	41
16	Belchite	38	35	59	39
17	Atlético	38	40	66	39
18	Villa	38	40	68	36
19	Villanueva	38	40	66	32
20	Fraga	38	33	87	24

TEMPORADA 2014/2015

TERCERA DIVISIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	CD Ebro	38	84	27	86
2	CD Teruel	38	72	36	84
3	Sariñena	38	72	26	78
4	SD Tarazona	38	76	36	77
5	Andorra	38	54	24	76
6	SD Borja	38	54	34	61
7	CD Cuarte	38	46	40	60
8	Almudévar	38	49	39	59
9	Utebo	38	49	60	55
10	Ejea	38	51	45	52
11	Illueca	38	48	58	50
12	Villa	38	40	61	47
13	Atlético	38	51	62	43
14	Sabiñánigo	38	53	65	42
15	CD Binéfar	38	37	56	40
16	Villanueva	38	35	50	40
17	Tamarite	38	34	63	35
18	Caspe	38	30	48	35
19	Santa Isabel	38	29	52	29
20	Barbastro	38	26	108	6

TEMPORADA 2013/2014

TERCERA DIVISIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	Deportivo	40	95	30	95
2	CD Teruel	40	56	41	78
3	Ejea	40	58	29	72
4	Almudévar	40	78	37	71
5	Atlético	40	65	48	71
6	SD Tarazona	40	67	52	70
7	Utebo	40	57	51	69
8	SD Borja	40	52	34	64
9	Barbastro	40	56	49	59
10	Andorra	40	44	42	57
11	Villanueva	40	57	47	57
12	Tamarite	40	54	64	56
13	CD Ebro	40	67	54	51
14	Sabiñánigo	40	52	59	51
15	Illueca	40	40	51	49
16	CD Cuarte	40	47	53	48
17	Brea	40	39	76	39
18	Calatayud	40	46	79	38
19	Atlético	40	36	77	28
20	Altorricón	40	36	83	24
21	Oliver	40	35	81	21

TEMPORADA 2012/2013

TERCERA DIVISIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	Sariñena	38	70	20	84
2	Andorra	38	73	25	84
3	CD Ebro	38	66	40	73
4	Utebo	38	56	26	72
5	Atlético	38	70	50	70
6	Ejea	38	58	40	60
7	SD Borja	38	46	39	57
8	SD Tarazona	38	45	45	53
9	CD Cuarte	38	51	47	53
10	Villanueva	38	47	48	52
11	Oliver	38	45	49	48
12	Atlético	38	35	51	46
13	Barbastro	38	47	57	46
14	Almudévar	38	46	48	45
15	Sabiñánigo	38	51	55	44
16	Calatayud	38	37	52	44
17	Almunia	38	39	58	40
18	Valdefierro	38	38	50	39
19	Robres	38	41	63	30
20	CD Binéfar	38	19	117	15

TEMPORADA 2011/2012

TERCERA DIVISIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	Sariñena	36	64	23	76
2	Ejea	36	66	34	69
3	CD Cuarte	36	61	35	66
4	Utebo	36	52	31	63
5	Valdefierro	36	48	34	62
6	Villanueva	36	59	48	54
7	Sabiñánigo	36	54	48	54
8	Calatayud	36	44	34	53
9	CD Binéfar	36	42	39	51
10	Oliver	36	50	53	48
11	CD Ebro	36	42	47	47
12	Barbastro	36	54	59	47
13	Atlético	36	38	45	44
14	Robres	36	41	50	43
15	SD Tarazona	36	41	49	42
16	Tauste CD	36	50	59	37
17	Giner	36	41	68	31
18	Quinto	36	24	64	29
19	José	36	31	82	20

TEMPORADA 2010/2011

PREFERENTE ARAGÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	CD Cuarte	34	91	41	76
2	José	34	74	40	64
3	Atlético	34	63	40	64
4	Quinto	34	56	31	63
5	Belchite	34	59	49	57
6	Illueca	34	49	39	57
7	Almunia	34	44	32	56
8	Brea	34	48	51	56
9	Alcañiz	34	61	53	52
10	Cd Daroca	34	43	46	44
11	Fuentes	34	49	55	43
12	CD Utrillas	34	49	53	42
13	Peñas	34	37	51	35
14	Calamocha	34	52	71	35
15	Teruel B	34	30	44	34
16	Cd Movera	34	34	69	28
17	Alcorisa	34	36	73	27
18	Monzalbarba	34	33	70	19

TEMPORADA 2009/2010

TERCERA DIVISIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	CD Teruel	38	88	29	94
2	La Muela	38	73	24	90
3	Deportivo	38	96	33	84
4	Ejea	38	104	35	84
5	Atlético	38	77	42	81
6	Andorra	38	78	38	79
7	Sabiñánigo	38	53	60	52
8	Villanueva	38	60	62	46
9	Utebo	38	53	62	46
10	Valdefierro	38	46	63	46
11	Giner	38	40	74	43
12	Sariñena	38	36	61	43
13	Tauste CD	38	43	61	39
14	Barbastro	38	40	72	39
15	Calatayud	38	46	56	38
16	Mallén	38	37	57	36
17	CD Cuarte	38	40	73	36
18	Fraga	38	46	84	35
19	Alcañiz	38	55	86	34
20	Jacetano	38	34	73	30

TEMPORADA 2008/2009

TERCERA DIVISIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	Atlético	38	87	28	88
2	Deportivo	38	91	30	86
3	CD Teruel	38	78	22	82
4	La Muela	38	86	32	80
5	Ejea	38	74	38	71
6	Andorra	38	76	44	67
7	Utebo	38	61	58	57
8	Sariñena	38	51	58	57
9	Barbastro	38	51	58	50
10	Calatayud	38	52	56	47
11	Alcañiz	38	64	68	46
12	Villanueva	38	62	65	45
13	Sabiñánigo	38	35	60	43
14	CD Cuarte	38	45	59	42
15	Giner	38	40	67	41
16	Fraga	38	48	71	40
17	Lorenzo	38	36	76	38
18	CD Binéfar	38	50	82	38
19	Zuera	38	33	76	21
20	Brea	38	35	107	21

TEMPORADA 2007/2008

TERCERA DIVISIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	Ejea	40	95	37	93
2	Barbastro	40	102	24	88
3	CD Teruel	40	73	29	84
4	Atlético	40	76	34	81
5	Andorra	40	74	45	81
6	Deportivo	40	84	38	80
7	Villanueva	40	65	46	71
8	Sariñena	40	59	52	58
9	Calatayud	40	40	39	53
10	Sabiñánigo	40	51	57	52
11	Utebo	40	56	65	51
12	Lorenzo	40	48	74	43
13	CD Binéfar	40	42	71	43
14	CD Cuarte	40	52	81	43
15	Brea	40	52	91	43
16	Fraga	40	41	66	40
17	CD Ebro	40	40	65	40
18	Figueruelas	40	38	64	37
19	Illueca	40	43	78	33
20	Peñas	40	36	74	29
21	Jacetano	40	47	84	28

Competiciones que juega

Tercera Federación Grupo 17

Pos	Equipos		Pts
1		Ejea	63
2		CD Ebro	60
3		CD Cuarte	59
4		Caspe	58
5		CF Epila	53
6		Calamocha	49
7		Almudévar	49
8		Fraga	47
9		CD Utrillas	46
10		Huesca B	45
11		Atlético Monzón	45
12		CDJ Tamarite	40
13		CD Binéfar	35
14		Fuentes	34
15		CD Belchite 97	29
16		Illueca	24
17		SD Borja	22
18		CD Cariñena	19

	Ascenso : Ejea
	Playoff Ascenso : CD Ebro, CD Cuarte, Caspe, CF Epila
	Descenso : Illueca, SD Borja, CD Cariñena

RIVALES EN Tercera Federaci.

USO DE MEMORIA

7,642,056 bytes

BENCHMARKS

Loading Time Base Classes	0.0016
Controller Execution Time ( Home / Category )	0.2640
Total Execution Time	0.2656

CADENA URL

/historico/Cuarte-Industrial

GET DATOS

$_GET['/historico/Cuarte-Industrial']

POST DATOS

No hay datos POST existentes

CONSULTAS (40)

0.0054	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 = 'Cuarte-Industrial' 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=4728 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=4728 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=4728 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=4728 AND type_rel = 2
0.0050	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4728 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0031	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 (694191,712980,790787,822157,886617) ORDER BY n.cover_points DESC, update_date DESC
0.0046	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 = '4728' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0078	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 = '4728' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021	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 = 72277 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0060	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=4728 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0021	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 (72277,71432,68447) 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.0073	SELECT count(id) as num_players from rel_players WHERE league_id = 72277 AND teamId = 4728
0.0041	SELECT count(id) as num_players from rel_players WHERE league_id = 68447 AND teamId = 4728
0.0048	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 4728
0.0053	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 = 72277 AND t.round = 33 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0025	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 = '4728' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0047	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '4728' 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 = '4728' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '4728' and rp.type = 4
0.0149	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 = 72277 WHERE rp.league_id = 72277 AND rp.teamId = 4728 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.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 = 72277 WHERE rp.league_id = 72277 AND rp.teamId = 4728 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0077	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 = 72277 WHERE rp.league_id = 72277 AND rp.teamId = 4728 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0069	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 = 4728 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0070	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 = 67991 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.0048	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 = 62401 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.0045	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 = 58596 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.0052	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 = 50285 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.0059	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 = 44662 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0045	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 = 39350 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0047	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 = 33367 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0063	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 = 15459 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0073	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 = 3926 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0064	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 = 2567 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0064	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 = 1957 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0063	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 = 1411 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0059	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 = 1142 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0048	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 = 843 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0075	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 = 147 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0059	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 = 24 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

CD Cuarte

CD Cuarte

Selecciona un equipo

Competiciones que juega

Tercera Federación Grupo 17

RIVALES EN Tercera Federaci.