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 Villacarrillo

Temporada 2023/2024

TEMPORADA 2023/2024

PRIMERA ANDALUZA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Villacarrill	24	59	22	52
2	Carolinense	24	44	19	49
3	Navas CD	24	51	38	47
4	Begíjar CF	24	36	23	47
5	Inter Jaén	24	44	35	41
6	Atlético	24	50	31	40
7	CD Hispania	24	37	38	34
8	Vilches	24	40	35	30
9	UD Cazorla	24	39	38	30
10	Baeza CF	24	41	41	29
11	Villanueva	24	32	37	28
12	Torredonjime	24	37	48	27
13	CD Rus	24	30	49	25
14	AD Lopera	24	34	54	21
15	Atlético	24	34	60	20
16	Mancha Real	24	26	66	11

TEMPORADA 2022/2023

DIVISIÓN HONOR SENIOR GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	CD Rincón	30	58	22	68
2	Poli	30	39	20	58
3	Mijas	30	51	30	56
4	Alhaurín	30	50	27	55
5	Almuñecar	30	40	30	48
6	Alhaurino	30	47	37	47
7	Pedro	30	36	29	45
8	Martos CD	30	39	40	41
9	Casabermeja	30	40	39	40
10	Berja	30	49	61	37
11	Atarfe	30	37	40	36
12	CD Cantoria	30	38	47	36
13	Villacarrill	30	32	46	34
14	Cubillas FC	30	28	42	24
15	Vilches	30	23	53	20
16	UD Pavía	30	14	58	13

TEMPORADA 2021/2022

DIVISIÓN HONOR SENIOR GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	CD Estepona	36	82	26	83
2	Málaga City	36	61	29	75
3	Arenas	36	64	23	70
4	Maracena	36	73	36	66
5	Villacarrill	36	53	39	62
6	CD Rincón	36	54	39	60
7	CD Cantoria	36	58	52	58
8	Atarfe	36	53	50	54
9	Berja	36	51	47	53
10	Cubillas FC	36	48	40	52
11	Poli	36	42	36	50
12	Casabermeja	36	43	45	48
13	Celtic	36	48	46	48
14	Begíjar CF	36	40	45	45
15	Iliturgi	36	48	58	38
16	Cañada	36	39	69	26
17	Loja	36	29	73	18
18	Atlético	36	30	79	18
19	Churriana	36	29	113	16

TEMPORADA 2020/2021

DIVISIÓN HONOR SENIOR GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Arenas	18	28	15	36
2	Begíjar CF	18	28	18	29
3	Atarfe	18	21	20	29
4	Villacarrill	18	26	19	28
5	Celtic	18	30	25	27
6	Martos CD	18	22	23	26
7	Baeza CF	18	26	26	24
8	Cubillas FC	18	20	23	21
9	Vandalia	18	20	35	15
10	Villanueva	18	20	37	15

TEMPORADA 2019/2020

DIVISIÓN HONOR SENIOR GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Alhaurino	26	52	18	59
2	Torremolinos	27	46	17	57
3	CD Estepona	27	42	19	55
4	CD Rincón	26	48	32	46
5	Celtic	27	45	40	46
6	Athletic	27	37	37	44
7	Begíjar CF	26	34	25	42
8	Pedro	27	26	31	38
9	Atarfe	26	36	28	36
10	Arenas	26	37	34	36
11	Berja	27	37	28	35
12	Villacarrill	27	41	37	33
13	Martos CD	27	34	46	30
14	CD Cantoria	27	29	49	30
15	Cubillas FC	26	25	28	29
16	Churriana	26	24	44	27
17	Casabermeja	27	22	38	24
18	Guadix CF	26	19	44	22
19	Villanueva	26	21	60	11

TEMPORADA 2018/2019

DIVISIÓN HONOR SENIOR GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Atletico	34	61	29	71
2	Maracena	34	58	33	69
3	Berja	34	69	34	63
4	Casabermeja	34	41	32	56
5	Begíjar CF	34	54	42	55
6	Celtic	34	43	38	52
7	CD Estepona	34	42	41	51
8	Athletic	34	48	35	50
9	Arenas	34	58	51	50
10	Villacarrill	34	43	44	49
11	Cd Oriente	34	47	47	45
12	CD Vera	34	46	47	41
13	Malaka	34	41	51	41
14	Navas CD	34	42	42	40
15	CD Cártama	34	53	72	39
16	Cullar Vega	34	43	60	33
17	Atlético	34	31	77	26
18	Adra	34	24	69	18

TEMPORADA 2017/2018

TERCERA DIVISIÓN GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Malagueño	42	95	31	96
2	Almería B	42	97	35	86
3	Real Jaén	42	58	29	82
4	Antequera	42	78	37	82
5	Huétor	42	77	49	82
6	CF Motril	42	85	56	81
7	Linares	42	68	47	74
8	Mancha Real	42	66	46	72
9	Loja	42	87	63	69
10	El Palo FC	42	66	50	67
11	Torredonjime	42	79	65	67
12	Vélez CF	42	60	65	56
13	CD Rincón	42	53	61	52
14	Torremolinos	42	64	76	50
15	Martos CD	42	58	85	47
16	Atarfe	42	46	69	43
17	Pedro	42	43	80	43
18	Huétor Vega	42	47	74	38
19	Guadix CF	42	40	77	37
20	Maracena	42	44	73	35
21	Villacarrill	42	44	79	28
22	Melistar	42	24	132	12

TEMPORADA 2016/2017

DIVISIÓN HONOR SENIOR GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Torremolinos	36	96	28	86
2	Villacarrill	36	70	43	78
3	Athletic	36	62	40	69
4	Atletico	36	73	53	68
5	Torreperogil	36	71	55	61
6	Arenas	36	52	41	56
7	Estudiantes	36	59	53	56
8	Adra	36	61	65	48
9	CD Estepona	36	55	45	47
10	Poli	36	55	60	47
11	Cullar Vega	36	45	56	47
12	Linares	36	56	57	46
13	Atlético	36	50	56	45
14	UD Pavía	36	36	46	40
15	CD Ronda	36	45	71	38
16	Tiro Pichón	36	46	68	37
17	Cd Oriente	36	39	66	34
18	Cañada	36	38	70	31
19	Comarca	36	44	80	28

TEMPORADA 2015/2016

PRIMERA ANDALUZA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Alhaurino	34	84	37	74
2	Torredonjime	34	74	33	72
3	D.H. Andrés	34	83	49	67
4	Atletico	34	70	37	64
5	Torreperogil	34	54	40	60
6	Torremolinos	33	69	36	58
7	Athletic	33	56	38	51
8	Villacarrill	34	48	41	51
9	Tiro Pichón	34	61	58	45
10	Athletic	34	71	79	44
11	Malaka	34	56	72	40
12	CD Mijas	33	44	57	38
13	CF Alameda	34	50	72	37
14	Cala Míjas	34	34	51	36
15	Casabermeja	34	38	55	36
16	Benamiel	34	52	65	32
17	Barrio NSR	33	46	89	19
18	Fuengirola	34	19	100	12

TEMPORADA 2014/2015

TERCERA DIVISIÓN GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Linares	38	88	26	88
2	Malagueño	38	69	36	75
3	Pedro	38	65	35	73
4	Martos CD	38	66	42	71
5	Loja	38	55	36	69
6	Huétor	38	53	37	62
7	Villares	38	43	37	58
8	Maracena	38	66	52	57
9	Guadix CF	38	49	49	51
10	Mancha Real	38	36	34	50
11	Vélez CF	38	49	47	49
12	Español	38	53	70	48
13	Pvo. Ejido	38	55	75	47
14	CD Ronda	38	52	63	43
15	Antequera	38	51	55	42
16	Alhaurín	38	43	74	41
17	Atarfe	38	53	70	37
18	Villacarrill	38	32	64	31
19	Atletico	38	29	58	30
20	Los Molinos	38	32	79	26

TEMPORADA 2013/2014

TERCERA DIVISIÓN GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Marbella FC	38	81	37	86
2	Linares	38	71	28	82
3	Malagueño	38	74	34	82
4	Loja	38	88	44	79
5	Mancha Real	38	51	31	72
6	Vélez CF	38	60	31	67
7	Martos CD	38	65	49	60
8	Villacarrill	38	63	46	59
9	Huétor	38	36	42	53
10	Atarfe	38	48	49	50
11	Maracena	38	44	44	49
12	Español	38	58	71	49
13	Antequera	38	43	54	44
14	Pedro	38	34	54	44
15	CD Ronda	38	48	58	43
16	Los Molinos	38	53	64	43
17	Villares	38	36	55	42
18	Melilla	38	44	66	40
19	CD Huercal	38	29	106	13
20	Unión	38	16	79	0

TEMPORADA 2012/2013

TERCERA DIVISIÓN GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	El Palo FC	38	72	36	74
2	Mancha Real	38	50	27	72
3	Recreativo	38	73	35	72
4	Malagueño	38	71	27	71
5	Linares	38	52	30	70
6	Villacarrill	38	66	41	65
7	Martos CD	38	52	44	64
8	Vélez CF	38	51	47	56
9	Atarfe	38	58	48	53
10	Maracena	38	47	49	51
11	Marbella FC	38	52	53	49
12	Casino Real	38	43	44	48
13	Pedro	38	50	45	47
14	CD Ronda	38	53	56	45
15	Unión	38	45	55	45
16	Huétor	38	44	67	41
17	CD Huercal	38	33	73	31
18	Torremolinos	38	32	67	30
19	Alhaurín	38	29	79	23
20	Comarca	38	24	74	23

TEMPORADA 2011/2012

PRIMERA ANDALUZA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Villacarrill	34	79	22	86
2	Linares	34	85	21	83
3	Torremolinos	34	72	31	82
4	D.H. Andrés	34	84	38	77
5	Alhaurino	34	63	38	59
6	Churriana	34	45	47	48
7	Coín	34	48	51	48
8	Fuengirola	34	52	51	46
9	Úbeda Viva	34	44	43	46
10	Carolinense	34	33	53	42
11	Benamiel	34	47	47	41
12	CD Rincón	34	41	68	37
13	CF Alameda	34	36	52	36
14	Real Jaén	34	45	66	33
15	Barrio	34	40	62	32
16	Baeza CF	34	28	62	26
17	Marbellí	34	36	71	22
18	Malaka	34	25	80	17

TEMPORADA 2010/2011

PRIMERA ANDALUZA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Pedro	34	78	37	68
2	Nerja	34	69	36	66
3	Malaka	34	58	34	63
4	Villacarrill	34	50	40	60
5	Real Jaén	34	78	44	58
6	Úbeda Viva	34	55	34	53
7	Marbellí	34	39	42	52
8	Benamiel	34	61	56	51
9	D.H. Andrés	34	59	49	49
10	Churriana	34	58	40	48
11	Fuengirola	34	42	37	48
12	CD Rincón	34	42	46	44
13	Carolinense	34	47	59	43
14	Torremolinos	34	42	58	36
15	Cd Lauro	34	35	67	34
16	CD Mijas	34	38	87	30
17	Recreativo	34	47	78	26
18	Villanueva	34	27	81	13

TEMPORADA 2009/2010

2ª ANDALUZA JAÉN
Equipo		PJ	GF	GC	Puntos
1	Villacarrill	30	67	27	67
2	Carolinense	30	65	24	65
3	Villares	30	75	26	64
4	Racing Jaén	30	60	35	63
5	Villanueva	30	49	36	53
6	C.D. Útica	30	63	39	52
7	Valdepeñas	30	65	50	47
8	Santomera	30	68	59	44
9	Castillo	30	60	64	42
10	Guarroman	30	44	40	40
11	Guardia	30	33	31	35
12	Huelma CP	30	43	71	34
13	Villargordo	30	27	65	26
14	Mancha Real	30	34	70	22
15	Veteranos	30	22	72	14
16	C.D.	30	38	104	12

TEMPORADA 2002/2003

2ª ANDALUZA JAÉN
Equipo		PJ	GF	GC	Puntos
1	Recreativo	33	80	29	72
2	Jódar	33	69	34	72
3	Club	33	77	36	70
4	Iliturgi CF	33	54	26	69
5	Linares	34	60	25	63
6	Real Jaén	33	69	32	57
7	F.s.Valdepe�	33	54	47	56
8	Villacarrill	33	55	50	52
9	Urgavona CF	34	49	46	46
10	Torredonjime	33	51	57	36
11	P.Jienense	33	40	50	35
12	Puertas	33	44	62	34
13	Atlético	33	37	42	31
14	Vilches	33	43	67	31
15	Sierra	33	43	95	24
16	Ubeda	33	34	96	21
17	Jabalquinto	19	22	46	19
18	Veteranos	33	35	76	16

Competiciones que juega

Grupo 6

Primera Andaluza Grupo 6

Pos	Equipos		Pts
1		CD Villacarrillo	52
2		Carolinense	49
3		Navas CD	47
4		Begíjar CF	47
5		Inter de Jaén CF	41
6		Atlético Jaén	40
7		CD Hispania	34
8		Vilches	30
9		UD Cazorla	30
10		Baeza CF	29
11		CD Villanueva	28
12		UDC Torredonjimeno B	27
13		CD Rus	25
14		AD Lopera	21
15		Atlético Mengibar	20
16		Mancha Real B	11

	Playoff Ascenso : CD Villacarrillo, Carolinense, Navas CD, Begíjar CF
	Descenso : AD Lopera, Atlético Mengibar, Mancha Real B

RIVALES EN Primera Andaluza

USO DE MEMORIA

7,252,120 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6147
Total Execution Time	0.6159

CADENA URL

/historico/Cd-Villacarrillo

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (39)

0.0134	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-Villacarrillo' 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.0126	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=4767 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=4767 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4767 AND type_rel = 2
0.0129	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4767 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0130	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 (66891,67235,184168,322181,336518) ORDER BY n.cover_points DESC, update_date DESC
0.0130	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 = '4767' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0129	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 = '4767' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127	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 = 73629 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129	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=4767 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126	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 (73629,68672,67773) 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.0129	SELECT count(id) as num_players from rel_players WHERE league_id = 68672 AND teamId = 4767
0.0130	SELECT count(id) as num_players from rel_players WHERE league_id = 73629 AND teamId = 4767
0.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 67773 AND teamId = 4767
0.0134	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 = 73629 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0130	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 = '4767' 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 = '4767' and rp.type = 4
0.0129	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 = '4767' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0125	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '4767' and rp.type = 4
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 = 73629 WHERE rp.league_id = 73629 AND rp.teamId = 4767 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 = 73629 WHERE rp.league_id = 73629 AND rp.teamId = 4767 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132	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 = 73629 WHERE rp.league_id = 73629 AND rp.teamId = 4767 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131	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 = 4767 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 73629 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.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* `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 = 68672 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.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* `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 = 63952 AND t.round = 38 ORDER BY team.conference ASC,t.position 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* `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 = 61680 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127	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 = 58972 AND t.round = 18 ORDER BY team.conference ASC,t.position 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* `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 = 51037 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.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* `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 = 44942 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* `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 = 34071 AND t.round = 38 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* `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 = 16714 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134	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 = 3918 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 = 2708 AND t.round = 38 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* `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 = 1953 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* `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 = 1469 AND t.round = 34 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* `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 = 1150 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* `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 = 2951 AND t.round = 30 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* `tables2003` 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 = 2944 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

CD Villacarrillo

CD Villacarrillo

Selecciona un equipo

Competiciones que juega

Primera Andaluza Grupo 6

RIVALES EN Primera Andaluza