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

Resultados de Fútbol

CD Villamuriel

Temporada 2023/2024

TEMPORADA 2023/2024

PREFERENTE C. LEÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Briviesca	28	59	19	57
2	Villamuriel	28	46	25	53
3	Turégano	28	54	37	49
4	Vista Alegre	28	37	25	45
5	Villarcayo	28	36	27	44
6	José	28	48	36	44
7	Numancia B	28	38	30	42
8	SC Uxama	28	35	40	41
9	Calasanz	28	41	34	39
10	Racing	28	24	34	39
11	Cebrereña	28	37	41	36
12	UP Palencia	28	25	28	33
13	Belorado	28	41	60	31
14	Unami CP	28	32	45	25
15	Deportivo	28	29	44	25
16	Carejas	28	16	73	11

TEMPORADA 2022/2023

PREFERENTE C. LEÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	DiocesÁvila	32	70	19	74
2	Turégano	32	81	28	71
3	Briviesca	32	88	26	67
4	Palencia	32	72	25	64
5	José	32	65	35	61
6	Cebrereña	32	65	34	53
7	Vista Alegre	32	57	39	52
8	Calasanz	32	79	47	52
9	Racing	32	55	42	46
10	Villarcayo	32	47	45	45
11	SC Uxama	32	43	40	41
12	UP Palencia	32	42	48	40
13	Villamuriel	32	45	68	32
14	Cuéllar	32	37	112	27
15	Abejar	32	25	92	15
16	Granja	32	23	73	13
17	Las Navas	32	21	142	8

TEMPORADA 2021/2022

PREFERENTE C. LEÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Becerril	30	59	12	75
2	Unami CP	30	68	24	74
3	Turégano	30	53	28	59
4	Palencia	30	72	42	56
5	José	30	55	44	54
6	Villamuriel	30	67	49	49
7	Granja	30	59	45	48
8	Briviesca	30	45	36	46
9	Villarcayo	30	37	39	42
10	Calasanz	30	50	54	37
11	SC Uxama	30	46	53	37
12	Polideportiv	30	35	55	29
13	Racing	30	37	58	29
14	Monteresma	30	35	87	23
15	Burgalés	30	21	50	22
16	Tardelcuende	30	10	73	5
17	Real Burgos	0	0	0	0

TEMPORADA 2020/2021

PREFERENTE C. LEÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Palencia CF	18	51	17	40
2	Castilla	18	46	19	40
3	Briviesca	18	30	13	36
4	Villamuriel	18	26	20	29
5	Palencia	18	36	29	27
6	Villarcayo	18	11	21	18
7	Polideportiv	18	14	37	16
8	Racing	18	18	23	16
9	Carejas	18	12	38	12
10	Vista Alegre	18	7	34	12

TEMPORADA 2019/2020

PREFERENTE C. LEÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	DiocesÁvila	24	55	15	58
2	Cebrereña	24	50	20	53
3	SC Uxama	24	39	19	50
4	Briviesca	24	41	20	47
5	Unami CP	24	42	34	45
6	Castilla	24	47	23	42
7	José	24	28	20	40
8	Palencia CF	24	41	35	36
9	Turégano	24	39	32	32
10	Villarcayo	24	27	23	32
11	Racing	24	34	41	29
12	Villamuriel	24	27	31	27
13	San Esteban	24	29	46	26
14	Tardelcuende	24	36	42	20
15	Carejas	24	28	42	20
16	Calasanz	24	28	42	20
17	Vista Alegre	24	29	61	17
18	Candeleda	24	10	84	6

TEMPORADA 2018/2019

PREFERENTE C. LEÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Becerril	32	65	14	73
2	Mirandés B	32	71	26	72
3	DiocesÁvila	32	97	25	70
4	Unami CP	32	72	34	60
5	Villarcayo	32	44	38	60
6	Castilla	31	77	47	55
7	Villamuriel	32	45	38	53
8	José	32	39	25	49
9	Racing	32	44	42	41
10	Tardelcuende	32	54	58	41
11	Calasanz	31	45	71	34
12	Palencia CF	32	39	50	33
13	Cuéllar	32	49	70	33
14	Venta Baños	32	37	68	28
15	Espinar-San	32	37	88	26
16	Arandina	32	32	63	25
17	Bosco	32	20	110	12
18	Palencia	0	0	0	0

TEMPORADA 2017/2018

PREFERENTE C. LEÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Briviesca	34	78	30	79
2	Granja	34	86	29	78
3	Unami CP	34	78	27	76
4	DiocesÁvila	34	83	37	65
5	Mirandés B	34	66	37	61
6	Racing	34	52	43	55
7	Villarcayo	34	44	39	53
8	Villamuriel	34	51	42	47
9	Palencia	34	53	56	47
10	Castilla	34	50	58	46
11	Tardelcuende	34	44	70	46
12	Espinar-San	34	41	70	38
13	Palencia CF	34	27	45	36
14	Univ. Burgos	34	42	57	35
15	CD Raudense	34	43	74	28
16	Carejas	34	24	56	25
17	Norma	34	38	72	23
18	Polideportiv	34	32	90	19

TEMPORADA 2016/2017

TERCERA DIVISIÓN GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Gimnástica	38	97	22	91
2	Atl. Astorga	38	83	37	80
3	Unionistas	38	77	29	78
4	Palencia	38	73	35	76
5	SD Almazán	38	69	47	68
6	Zamora	38	51	42	60
7	Real Ávila	38	65	55	54
8	Numancia B	38	55	55	53
9	Virgen	38	56	56	50
10	Atl.	38	42	51	48
11	Burgalés	38	53	53	48
12	La Bañeza	38	49	52	47
13	José	38	39	68	45
14	Atlético	38	53	70	44
15	Burgos CF B	38	39	55	43
16	Cebrereña	38	38	55	41
17	SC Uxama	38	37	45	41
18	Villamuriel	38	35	49	37
19	Mirandés B	38	26	49	37
20	Villaralbo	38	27	139	13

TEMPORADA 2015/2016

TERCERA DIVISIÓN GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Zamora	38	75	29	84
2	Gimnástica	38	74	32	77
3	Palencia	38	64	26	75
4	Villaralbo	38	52	26	71
5	La Bañeza	38	53	30	70
6	Virgen	38	55	52	62
7	Atlético	38	52	53	54
8	Atl.	38	48	44	53
9	SC Uxama	38	37	53	51
10	Numancia B	38	51	43	50
11	SD Almazán	38	50	53	49
12	Cebrereña	38	55	61	46
13	Villamuriel	38	38	47	46
14	Burgalés	38	37	41	46
15	Burgos CF B	38	33	50	43
16	Palencia	38	40	63	40
17	Mirandés B	38	39	67	36
18	Ciudad	38	38	68	36
19	Santa Marta	38	37	57	36
20	Becerril	38	34	67	25

TEMPORADA 2014/2015

PREFERENTE C. LEÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	SC Uxama	31	64	24	68
2	Villamuriel	31	63	24	67
3	Unami CP	31	70	29	66
4	José	31	55	29	58
5	Polideportiv	31	56	36	58
6	Venta Baños	31	39	35	48
7	Briviesca	31	50	36	46
8	Burgos CF B	31	41	39	40
9	Arandina	31	37	45	40
10	Real Burgos	31	52	59	38
11	Racing	31	38	47	38
12	CD Sotillo	31	38	57	35
13	CD Juventud	31	39	53	30
14	Bosco	31	27	44	30
15	CD Raudense	31	40	58	30
16	Univ. Burgos	31	20	76	14
17	Cuéllar	16	8	46	0

TEMPORADA 2013/2014

PREFERENTE C. LEÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Mirandés B	32	64	14	81
2	Burgos CF B	32	77	37	70
3	Palencia	32	66	26	63
4	SC Uxama	32	75	39	59
5	Burgos CF B	32	63	35	57
6	Villamuriel	32	54	35	56
7	Velilla	32	52	37	51
8	Briviesca	32	60	43	50
9	Real Burgos	32	55	57	46
10	Polideportiv	32	46	58	33
11	Cuéllar	32	31	65	33
12	CD Raudense	32	36	67	32
13	Juventud	32	39	59	31
14	Bosco	32	44	55	31
15	CD Sotillo	32	39	79	22
16	C.D.	32	27	74	22
17	Tiemblo	32	33	81	15

TEMPORADA 2011/2012

PREFERENTE C. LEÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Cuéllar	30	63	28	69
2	Unami CP	29	56	27	66
3	Cebrereña	29	52	29	58
4	SC Uxama	30	39	31	46
5	Becerril	30	43	35	45
6	Villamuriel	30	38	30	43
7	Polideportiv	30	50	46	42
8	Antonio	30	39	40	42
9	Mirandés B	30	34	45	42
10	Velilla	30	39	43	38
11	Gimnástica	30	44	49	38
12	Briviesca	30	39	60	32
13	Real Ávila	30	33	53	31
14	San José	30	32	45	30
15	Bosco	30	38	54	29
16	Venta Baños	30	25	49	17

TEMPORADA 2010/2011

PREFERENTE C. LEÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Granja	34	80	24	72
2	Estructuras	34	68	32	67
3	Cuéllar	34	67	38	63
4	Unami CP	34	57	35	60
5	Bosco	34	49	51	52
6	Becerril	34	53	35	50
7	Villamuriel	34	49	37	50
8	Velilla	34	41	46	46
9	Antonio	34	43	50	45
10	San José	34	37	48	44
11	Polideportiv	34	47	55	43
12	SC Uxama	34	56	62	42
13	Milan	34	47	66	40
14	Norma	34	42	64	39
15	Gimnástica	34	47	60	36
16	CD Navaleno	34	44	89	21
17	D. Arenas	34	30	105	11

TEMPORADA 2009/2010

PREFERENTE C. LEÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Cebrereña	30	65	24	67
2	Palencia	30	52	17	65
3	Unami CP	30	62	33	57
4	Villamuriel	30	55	29	53
5	Becerril	30	56	40	47
6	Velilla	30	52	42	43
7	SC Uxama	30	39	51	40
8	Norma	29	39	35	38
9	San José	30	28	31	37
10	Cuéllar	30	46	46	34
11	Bosco	30	43	61	31
12	Polideportiv	29	44	59	29
13	CD Navaleno	30	39	70	28
14	D. Arenas	30	29	60	28
15	Castilla	30	29	88	14
16	Burgos	1	0	0	1

TEMPORADA 2008/2009

PREFERENTE C. LEÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Racing	30	80	25	70
2	Venta Baños	30	61	20	66
3	Atlético	30	70	51	54
4	Polideportiv	30	64	52	51
5	Palencia	30	50	27	50
6	Espinar-San	30	66	52	50
7	Cuéllar	30	55	46	44
8	Vadillos	30	50	41	42
9	Villamuriel	30	35	39	42
10	SC Uxama	30	41	52	42
11	CD Navaleno	30	51	57	41
12	Bosco	30	41	53	35
13	Unami CP	30	43	44	34
14	Mirandés B	30	34	47	33
15	Castilla	30	34	62	24
16	Real Ávila	30	43	86	18
17	Las Navas	30	22	93	6

Competiciones que juega

Grupo 1

Preferente C. León Grupo 1

Pos	Equipos		Pts
1		CF Briviesca	57
2		CD Villamuriel	53
3		Turégano	49
4		Vista Alegre CD	45
5		Villarcayo Nela	44
6		CD San José	44
7		Numancia B	42
8		SC Uxama	41
9		Calasanz de Soria	39
10		Racing Lermeño CF	39
11		Cebrereña	36
12		UP Palencia	33
13		Belorado	31
14		Unami CP	25
15		Deportivo Arenas	25
16		Carejas Paredes	11

	Ascenso : CF Briviesca
	Playoff Ascenso : CD Villamuriel, Turégano
	Descenso : Belorado, Unami CP, Deportivo Arenas, Carejas Paredes

RIVALES EN Preferente C. Le.

USO DE MEMORIA

6,892,368 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6671
Total Execution Time	0.6683

CADENA URL

/historico/Villamuriel

GET DATOS

$_GET['/historico/Villamuriel']

POST DATOS

No hay datos POST existentes

CONSULTAS (32)

0.0154	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 = 'Villamuriel' 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.0145	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=2710 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=2710 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0296	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 = 73528
0.0144	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2710 AND type_rel = 2
0.0146	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2710 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0150	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 (93130,239840,556996,555583,556950) ORDER BY n.cover_points DESC, update_date DESC
0.0154	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 = '2710' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0163	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=2710 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0148	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 (73528) 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.0149	SELECT count(id) as num_players from rel_players WHERE league_id = 73528 AND teamId = 2710
0.0150	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 = '2710' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2710' and rp.type = 4
0.0146	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 = '2710' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0159	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 = 73528 WHERE rp.league_id = 73528 AND rp.teamId = 2710 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.0153	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 = 73528 WHERE rp.league_id = 73528 AND rp.teamId = 2710 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151	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 = 73528 WHERE rp.league_id = 73528 AND rp.teamId = 2710 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148	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 = 2710 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0150	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 = 73528 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.0296	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 = 68798 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.0151	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 = 63673 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.0150	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 = 59994 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.0150	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 = 51275 AND t.round = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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 = 39359 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0308	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 = 33358 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0315	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 = 15449 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162	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 = 4090 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0159	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 = 2681 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160	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 = 1465 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163	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 = 1151 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158	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 = 853 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161	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 = 292 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

Resultados de Fútbol

CD Villamuriel

CD Villamuriel

Selecciona un equipo

Competiciones que juega

Preferente C. León Grupo 1

RIVALES EN Preferente C. Le.