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

Villafranca

Entrenador: José Antonio Ruiz

Temporada 2023/2024

TEMPORADA 2023/2024

TERCERA FEDERACIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Benito	31	60	13	69
2	CD Coria	32	57	19	66
3	CD Azuaga	31	45	31	55
4	Castuera	32	42	35	49
5	Villafranca	31	41	24	49
6	Diocesano	32	46	44	46
7	Moralo	31	47	42	44
8	CF Jaraíz	32	46	46	43
9	Arroyo	32	33	33	42
10	Calamonte	31	37	44	41
11	Olivenza	32	29	34	39
12	Jerez	31	38	46	39
13	Pueblonuevo	32	31	42	39
14	Trujillo	31	29	36	34
15	Álvaro	31	28	45	31
16	Montehermoso	32	33	51	31
17	Racing	32	29	56	26
18	Fuente	32	25	55	24

TEMPORADA 2022/2023

TERCERA FEDERACIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Llerenense	30	52	22	64
2	CD Azuaga	30	58	29	62
3	Moralo	30	52	24	55
4	Olivenza	30	46	33	53
5	Jerez	30	39	25	49
6	Arroyo	30	30	31	46
7	Trujillo	30	28	28	44
8	Villafranca	30	34	33	43
9	Calamonte	30	38	33	42
10	Fuente	30	23	28	39
11	Pueblonuevo	30	36	41	32
12	Montehermoso	30	31	53	31
13	Álvaro	30	27	54	27
14	Miajadas	30	23	41	26
15	Plasencia	30	31	43	24
16	Estrella	30	30	60	21

TEMPORADA 2021/2022

TERCERA FEDERACIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Diocesano	30	61	30	63
2	Moralo	30	39	19	52
3	Llerenense	30	44	32	51
4	Jerez	30	38	30	49
5	Arroyo	30	40	30	48
6	Trujillo	30	40	27	48
7	CD Azuaga	30	41	31	48
8	Calamonte	30	35	33	43
9	Plasencia	30	24	29	38
10	Villafranca	30	27	30	37
11	Olivenza	30	31	35	33
12	Álvaro	30	36	44	31
13	Miajadas	30	30	48	29
14	Aceuchal	30	24	42	29
15	Badajoz	30	24	38	27
16	Extremadura	30	18	54	0

TEMPORADA 2020/2021

1ª REGIONAL EXTREMADURA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Villafranca	4	6	2	8
2	UD Talavera	4	7	6	7
3	Álvaro	4	5	6	5
4	Moraleja	4	5	7	4
5	Gimnástico	4	3	5	2

TEMPORADA 2019/2020

1ª REGIONAL EXTREMADURA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Estrella	25	74	17	61
2	Villafranca	25	67	20	59
3	Campanario	25	59	26	57
4	CD Zafra	25	56	26	51
5	Gimnástico	25	62	40	48
6	Santa Amalia	25	81	29	43
7	Ilipense-Zal	25	35	39	35
8	Castuera	25	38	37	32
9	Usagre	25	30	44	32
10	Olympic	25	44	52	29
11	Hernán	25	33	42	27
12	Gran Maestre	25	35	61	25
13	Ribereña	25	39	65	23
14	Frexnense	25	26	69	20
15	CD Berlanga	25	29	83	15
16	Nueva Ciudad	25	30	88	12

TEMPORADA 2018/2019

1ª REGIONAL EXTREMADURA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Fuente	30	69	32	70
2	Campanario	30	63	30	64
3	CD Zafra	30	63	28	63
4	Estrella	30	66	38	61
5	Villafranca	30	64	31	60
6	Guareña	30	46	50	46
7	Álvaro	30	67	55	44
8	CD Berlanga	30	54	59	36
9	Gran Maestre	30	51	45	35
10	Gimnástico	30	43	58	35
11	Ilipense-Zal	30	38	59	34
12	Atlético	30	50	73	32
13	Frexnense	30	23	46	28
14	Fornacense	30	35	63	28
15	Ribereña	30	34	69	25
16	Emérita	30	28	58	22

TEMPORADA 2017/2018

1ª REGIONAL EXTREMADURA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Llerenense	30	75	27	64
2	Villafranca	30	71	29	58
3	Frexnense	30	52	33	57
4	Estrella	30	63	38	56
5	Fuente	30	66	37	55
6	Serván	30	53	38	51
7	Campanario	30	46	33	49
8	CD Berlanga	30	63	52	42
9	Ribereña	30	44	48	42
10	Guareña	30	46	55	40
11	Santa Marta	30	49	62	38
12	Atlético	30	42	55	35
13	Ilipense-Zal	30	48	70	34
14	Monesterio	30	44	84	24
15	Usagre	30	37	73	22
16	CD Quintana	30	23	88	10

TEMPORADA 2016/2017

1ª REGIONAL EXTREMADURA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Castuera	30	50	10	69
2	Serván	30	48	27	57
3	Emérita	30	62	32	56
4	Álvaro	30	53	45	50
5	CD Quintana	30	46	44	47
6	Usagre	30	45	39	46
7	Almendralejo	30	49	46	46
8	Villafranca	29	44	35	45
9	Campanario	30	46	43	43
10	CD Berlanga	30	57	63	40
11	Guareña	30	41	48	32
12	Llerenense	30	43	55	31
13	Ribereña	30	40	55	29
14	Ilipense-Zal	30	31	50	28
15	Fornacense	29	46	57	27
16	Talarrubias	30	27	79	23

TEMPORADA 2015/2016

PREFERENTE EXTREMADURA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Estrella	30	66	37	60
2	Castuera	30	64	29	59
3	Ilipense-Zal	30	59	43	56
4	CD Quintana	30	50	27	56
5	Ribereña	30	55	40	54
6	Olympic	30	52	43	46
7	Hernán	30	43	28	46
8	CD Berlanga	30	57	50	46
9	Campanario	30	39	38	42
10	Llerenense	30	47	36	42
11	Villafranca	30	44	47	36
12	Fornacense	30	41	57	33
13	Talarrubias	30	42	49	32
14	Usagre	30	36	55	30
15	CP Rena	30	45	100	21
16	Sp Herrera	30	13	74	13

TEMPORADA 2014/2015

PREFERENTE EXTREMADURA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Estrella	30	76	27	66
2	Villafranca	30	56	28	60
3	Fornacense	30	59	38	58
4	Olympic	30	59	39	55
5	Ilipense-Zal	30	53	33	53
6	Llerenense	30	62	42	48
7	Monesterio	30	44	42	41
8	CP Rena	30	54	53	41
9	Belenense	30	38	40	40
10	Ribereña	30	54	53	37
11	Campanario	30	32	42	36
12	Talarrubias	30	40	53	34
13	Guareña	30	30	56	28
14	Sp Herrera	30	45	67	27
15	Metelinense	30	26	56	26
16	Gimnástico	30	24	83	16

TEMPORADA 2013/2014

PREFERENTE EXTREMADURA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	CP Valdivia	30	65	22	75
2	Estrella	30	68	32	65
3	Llerenense	30	61	38	60
4	Aceuchal	30	62	30	60
5	Fornacense	30	75	51	51
6	Villafranca	30	65	37	50
7	Sp Herrera	30	62	44	45
8	Campanario	30	49	45	39
9	Monesterio	30	37	45	37
10	Olympic	30	47	54	36
11	CP Rena	30	53	79	33
12	Talarrubias	30	49	66	31
13	Gimnástico	30	34	59	28
14	CD Berlanga	30	42	76	24
15	Guareña	30	29	66	20
16	Orellana	30	22	76	12

TEMPORADA 2011/2012

TERCERA DIVISIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Arroyo	38	100	22	95
2	Diter Zafra	38	63	38	81
3	Extremadura	38	75	23	78
4	Benito	38	63	29	78
5	Jerez	38	56	34	69
6	Miajadas	38	52	52	56
7	Deportivo	38	53	49	53
8	Mérida UD	38	42	43	53
9	CD Coria	38	49	55	50
10	Ciudad	38	45	46	45
11	Valdelacalza	38	31	42	45
12	Plasencia	38	41	62	45
13	Santa Amalia	38	53	67	44
14	Hernán	38	28	39	42
15	Pueblonuevo	38	59	83	41
16	Moralo	38	32	43	40
17	José	38	60	67	39
18	Sanvicenteñ	38	45	77	36
19	Villafranca	38	45	74	29
20	Chinato	38	27	74	20

TEMPORADA 2010/2011

PREFERENTE EXTREMADURA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Pueblonuevo	38	74	26	86
2	Villafranca	38	77	39	79
3	Puebla	38	58	29	71
4	CP Oliva	38	63	37	69
5	Fuente	38	68	52	67
6	Montijo	38	53	47	59
7	Racing	38	73	60	57
8	Calamonte	38	47	50	53
9	Estrella	38	51	51	51
10	Emérita	38	55	57	50
11	Nueva Ciudad	38	52	58	49
12	Monesterio	38	55	54	47
13	Burguillos	38	58	69	47
14	CD Azuaga	38	67	63	46
15	UD Talavera	38	39	52	46
16	Albuera-Faes	38	47	59	44
17	Guadiana	38	48	65	41
18	Gran Maestre	38	53	76	36
19	Francisco	38	43	82	28
20	Jorge	38	41	96	24

TEMPORADA 2009/2010

TERCERA DIVISIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	CD Badajoz	38	109	19	101
2	Jerez	38	76	14	89
3	Extremadura	38	77	26	79
4	Arroyo	38	72	43	74
5	Mérida UD	38	55	28	72
6	Villanueva	38	71	50	67
7	Ciudad	38	54	49	57
8	Benito	38	48	50	53
9	Sanvicenteñ	38	47	48	51
10	Imperio	38	59	56	47
11	Olivenza	38	33	45	47
12	Miajadas	38	28	42	44
13	Deportivo	38	54	68	43
14	Moralo	38	40	52	43
15	Valdelacalza	38	35	54	40
16	CD Coria	38	50	76	34
17	Santa Marta	38	43	69	31
18	Montehermoso	38	31	79	30
19	Estrella	38	27	84	27
20	Villafranca	38	30	87	23

TEMPORADA 2008/2009

PREFERENTE EXTREMADURA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Extremadura	38	105	26	87
2	Villafranca	38	77	41	82
3	Puebla	38	57	45	67
4	Imperio	37	56	38	62
5	Alburquerque	38	49	46	62
6	Monesterio	38	69	59	60
7	Calamonte	38	42	40	57
8	UD Montijo	38	71	59	56
9	José	38	47	53	51
10	Guadiana	38	44	50	49
11	Jorge	38	49	53	48
12	CP Oliva	37	45	48	47
13	Francisco	38	56	68	47
14	Pueblonuevo	38	58	54	46
15	Gran Maestre	38	51	48	45
16	UD Talavera	38	47	65	45
17	Racing	38	46	61	44
18	Extremadura	38	51	69	44
19	Nueva Ciudad	38	48	87	37
20	Guareña	38	24	82	22

TEMPORADA 2007/2008

TERCERA DIVISIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Benito	38	70	18	82
2	Cerro Reyes	38	78	33	78
3	Villanovense	38	73	35	74
4	Jerez	38	58	38	70
5	Plasencia	38	58	33	68
6	Diter Zafra	38	51	27	63
7	Villanueva	38	44	34	59
8	CD Badajoz	38	54	39	58
9	Cacereño	38	48	45	55
10	Moralo	38	41	55	48
11	Imperio	38	54	46	47
12	Estrella	38	36	47	43
13	Olivenza	38	32	64	42
14	CP Valdivia	38	45	59	42
15	Miajadas	38	31	46	39
16	Valdelacalza	38	42	64	39
17	Sanvicenteñ	38	34	75	38
18	Pueblonuevo	38	33	51	38
19	Santa Amalia	38	39	68	36
20	Villafranca	38	35	79	27

TEMPORADA 2006/2007

TERCERA DIVISIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Jerez	38	47	16	82
2	Benito	38	77	25	82
3	Imperio	38	67	28	81
4	Cacereño	38	71	31	75
5	Diter Zafra	38	57	21	73
6	Villanueva	38	60	24	67
7	CD Badajoz	38	50	34	58
8	Miajadas	38	62	64	57
9	Extremadura	38	44	39	56
10	Villafranca	38	51	49	55
11	Estrella	38	45	49	48
12	Moralo	38	42	43	47
13	Plasencia	38	48	44	45
14	Santa Amalia	38	46	58	43
15	Sanvicenteñ	38	40	60	43
16	Olivenza	38	30	47	41
17	CD Coria	38	46	63	38
18	Castuera	38	30	67	28
19	Monesterio	38	19	71	20
20	Moraleja	38	38	137	12

TEMPORADA 2005/2006

TERCERA DIVISIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Villanovense	40	75	35	90
2	Cerro Reyes	40	93	28	88
3	Benito	40	86	32	82
4	Villanueva	40	67	35	81
5	Miajadas	40	68	64	65
6	Jerez	40	61	50	62
7	Imperio	40	57	49	61
8	Plasencia	40	57	55	59
9	Cacereño	40	54	50	57
10	Estrella	40	42	51	57
11	Santa Amalia	40	44	52	51
12	Extremadura	40	56	69	47
13	CD Coria	40	57	83	46
14	Villafranca	40	46	60	45
15	Moralo	40	38	54	45
16	Olivenza	40	43	62	44
17	Monesterio	40	38	58	40
18	Amanecer	40	39	56	39
19	Alburquerque	40	46	65	39
20	Santa Marta	40	34	67	37
21	CP Valdivia	40	38	64	31

TEMPORADA 2004/2005

TERCERA DIVISIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Mérida UD	38	69	12	93
2	Villanovense	38	99	33	86
3	Cerro Reyes	38	90	27	86
4	Moralo	38	62	32	76
5	Imperio	38	58	29	73
6	Sporting	38	59	36	68
7	Cacereño	38	51	33	62
8	Plasencia	38	61	46	58
9	Extremadura	38	56	57	49
10	CD Coria	38	50	68	48
11	Miajadas	38	52	66	45
12	Villafranca	38	50	56	43
13	Estrella	38	36	53	43
14	Santa Amalia	38	32	43	38
15	Olivenza	38	34	60	38
16	Monesterio	38	26	63	36
17	Amanecer	38	34	68	34
18	Badajoz	38	37	58	32
19	Burguillos	38	31	95	25
20	Arroyo	38	36	88	19

Competiciones que juega

Tercera Federación Grupo 14

Pos	Equipos		Pts
1		CD Don Benito	69
2		CD Coria	66
3		CD Azuaga	55
4		Castuera	49
5		Villafranca	49
6		CD Diocesano	46
7		Moralo	44
8		CF Jaraíz	43
9		Arroyo	42
10		Calamonte	41
11		Olivenza	39
12		Jerez	39
13		Pueblonuevo	39
14		Trujillo	34
15		CD Don Álvaro	31
16		Montehermoso	31
17		Racing Valverdeño	26
18		UD Fuente de Cantos	24

	Ascenso : CD Don Benito
	Playoff Ascenso : CD Coria, CD Azuaga, Castuera, Villafranca
	Descenso : Montehermoso, Racing Valverdeño, UD Fuente de Cantos

RIVALES EN Copa Federación

RIVALES EN Copa Federación.

RIVALES EN Tercera Federaci.

USO DE MEMORIA

7,849,760 bytes

BENCHMARKS

Loading Time Base Classes	0.0018
Controller Execution Time ( Home / Category )	0.2019
Total Execution Time	0.2038

CADENA URL

/historico/Villafranca

GET DATOS

$_GET['/historico/Villafranca']

POST DATOS

No hay datos POST existentes

CONSULTAS (37)

0.0034	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 = 'Villafranca' 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=2705 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=2705 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=2705 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=2705 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=2705 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2470 AND type_rel = 3
0.0070	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 = '2705' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0035	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 = '2705' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0035	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=2705 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019	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 (74091,72676,72274) 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.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 72274 AND teamId = 2705
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 74091 AND teamId = 2705
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 72676 AND teamId = 2705
0.0021	SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '2705' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2705' and rp.type = 4
0.0020	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 = '2705' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0032	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 = 72274 WHERE rp.league_id = 72274 AND rp.teamId = 2705 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.0030	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 = 72274 WHERE rp.league_id = 72274 AND rp.teamId = 2705 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026	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 = 72274 WHERE rp.league_id = 72274 AND rp.teamId = 2705 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0044	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 = 2705 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0040	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 = 67988 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.0043	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 = 62398 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.0035	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 = 59501 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.0031	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 = 62268 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0042	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 = 51308 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039	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 = 44630 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038	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 = 39346 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0043	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 = 34429 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0055	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 = 16719 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037	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 = 4101 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034	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 = 1450 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031	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 = 1223 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032	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 = 814 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029	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 = 312 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0066	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* `tables2007` 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 = 99 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0046	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* `tables2005` 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 = 22107 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Villafranca

Villafranca

Selecciona un equipo

Competiciones que juega

Tercera Federación Grupo 14

RIVALES EN Copa Federación

RIVALES EN Copa Federación.

RIVALES EN Tercera Federaci.