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

RC Villalbés

Entrenador: Simón

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA FEDERACIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Ourense CF	33	51	19	70
2	Pontevedra	33	67	30	65
3	Zamora	33	37	19	60
4	Guijuelo	33	35	31	51
5	Rayo	33	46	40	48
6	Langreo	33	29	38	47
7	Compostela	33	33	35	47
8	Real	33	43	50	44
9	Coruxo	33	35	45	43
10	Deportivo	33	45	45	41
11	Real Avilés	33	40	35	41
12	Gimnástica	33	39	48	40
13	Marino	33	26	23	40
14	Villalbés	33	21	31	35
15	Arandina	33	35	44	32
16	Real Oviedo	33	26	40	30
17	Cayón	33	34	48	30
18	Covadonga	33	35	56	29

TEMPORADA 2022/2023

TERCERA FEDERACIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Deportivo	30	47	18	61
2	Arosa	30	45	26	58
3	Rápido	30	39	24	56
4	Villalbés	30	35	24	46
5	Ourense UD	30	38	30	45
6	Alondras CF	30	36	29	41
7	At. Arteixo	30	37	42	41
8	Somozas	30	32	37	40
9	Estradense	30	33	38	39
10	Celta Gran.	30	47	37	38
11	UD Paiosaco	30	31	42	37
12	Silva SD	30	38	46	37
13	Viveiro	30	29	37	37
14	CSD Arzua	30	28	48	31
15	Barco	30	26	38	31
16	Choco	30	27	52	15

TEMPORADA 2021/2022

TERCERA FEDERACIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	CD Lugo B	32	54	23	68
2	Ourense CF	32	48	21	67
3	Somozas	32	43	30	63
4	Barco	32	50	37	54
5	Deportivo	32	49	23	53
6	Rápido	32	39	26	51
7	Villalbés	32	43	24	50
8	Estradense	32	36	40	44
9	Alondras CF	32	30	29	40
10	Silva SD	32	34	41	39
11	CSD Arzua	32	29	35	38
12	Viveiro	32	32	42	36
13	Choco	32	32	43	35
14	Noia	32	30	49	29
15	Juvenil	32	25	43	28
16	At. Arnoia	32	25	54	22
17	SD Sofán	32	29	68	17

TEMPORADA 2020/2021

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Bergantiños	22	37	16	48
2	CD Lugo B	22	34	17	42
3	Somozas	22	41	21	41
4	Villalbés	22	34	26	40
5	Deportivo	22	41	27	32
6	Silva SD	22	21	20	30
7	CSD Arzua	22	32	23	29
8	Viveiro	22	25	39	28
9	Estudiantil	22	27	45	20
10	As Pontes	22	18	40	19
11	SD Fisterra	22	22	35	17
12	UD Paiosaco	22	16	39	12
13	Arenteiro	22	33	13	47
14	Arosa	22	27	14	41
15	Alondras CF	22	31	15	37
16	Estradense	22	35	34	31
17	Choco	22	28	22	31
18	Rápido	22	25	25	31
19	Barco	22	26	27	30
20	Ourense CF	22	33	29	28
21	Ribadumia	22	24	36	26
22	Ourense UD	22	25	32	25
23	UD Atios	22	18	32	20
24	Pontellas	22	12	38	9

TEMPORADA 2019/2020

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Compostela	27	50	15	61
2	Ourense CF	27	50	21	60
3	Arosa	27	42	31	47
4	Barco	27	40	40	47
5	Choco	27	40	28	43
6	CSD Arzua	27	40	39	41
7	Deportivo	27	38	28	40
8	Ourense UD	27	32	36	40
9	Arenteiro	27	29	31	35
10	Estradense	27	33	32	35
11	CD Lugo B	27	51	33	35
12	Silva SD	27	24	25	35
13	Bergantiños	27	27	31	34
14	Villalbés	27	30	30	34
15	Somozas	27	31	43	32
16	Alondras CF	27	32	45	32
17	As Pontes	27	39	44	28
18	Rápido	27	36	54	23
19	Pontellas	27	22	56	20
20	UD Paiosaco	27	23	47	17

TEMPORADA 2018/2019

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Racing	38	80	35	78
2	Bergantiños	38	58	42	74
3	Compostela	38	80	47	68
4	Alondras CF	38	47	36	65
5	Barco	38	58	43	64
6	Ourense CF	38	51	24	64
7	Choco	38	59	47	59
8	Ourense UD	38	45	39	59
9	Arosa	38	57	44	57
10	CD Lugo B	38	55	53	52
11	Villalbés	38	47	48	52
12	Silva SD	38	52	56	48
13	Arenteiro	38	41	53	47
14	Somozas	38	45	52	46
15	UD Paiosaco	38	46	59	45
16	Céltiga FC	38	36	66	41
17	Laracha	38	42	49	40
18	Ribadumia	38	41	65	38
19	Boiro	38	34	79	31
20	Porriño	38	37	74	27

TEMPORADA 2017/2018

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Compostela	38	78	34	86
2	Bergantiños	38	77	29	80
3	Villalbés	38	60	30	71
4	Alondras CF	38	61	34	69
5	Arosa	38	65	34	67
6	Somozas	38	63	42	63
7	Barco	38	63	44	63
8	Choco	38	50	44	59
9	Ourense CF	38	48	36	58
10	Boiro	38	52	53	58
11	Silva SD	38	45	46	55
12	Ribadumia	38	44	55	47
13	Céltiga FC	38	32	57	44
14	Arenteiro	38	39	61	42
15	Laracha	38	35	44	41
16	Cultural	38	48	82	34
17	Noia	38	42	72	32
18	Barbadás	38	29	61	32
19	Negreira	38	31	63	31
20	Villalonga	38	28	69	27

TEMPORADA 2016/2017

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Deportivo	38	79	31	81
2	Rápido	38	51	24	72
3	CCD Cerceda	38	65	36	71
4	Bergantiños	38	52	31	68
5	Villalbés	38	51	35	67
6	Arosa	38	51	38	64
7	Compostela	38	61	47	62
8	Villalonga	38	55	40	59
9	Silva SD	38	52	50	57
10	Choco	38	55	50	52
11	Barbadás	38	45	48	50
12	Negreira	38	51	48	49
13	Barco	38	50	55	49
14	Alondras CF	38	50	45	48
15	Ribadumia	38	41	52	48
16	Céltiga FC	38	42	45	47
17	CD Castro	38	47	72	37
18	As Pontes	38	32	67	28
19	Dubra	38	36	83	21
20	Club Ordenes	38	24	93	9

TEMPORADA 2015/2016

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Boiro	38	71	33	77
2	CCD Cerceda	38	64	40	72
3	Deportivo	38	74	46	67
4	Choco	38	57	40	63
5	Villalbés	38	51	43	58
6	Barco	38	55	54	57
7	Alondras CF	38	44	41	56
8	Rápido	38	51	46	55
9	Arosa	38	55	48	54
10	As Pontes	38	49	54	49
11	Ribadumia	38	54	51	48
12	Negreira	38	47	48	48
13	Silva SD	38	53	56	48
14	Barbadás	38	47	58	45
15	Club Ordenes	38	33	45	45
16	Bergantiños	38	38	43	43
17	Galicia	38	48	63	43
18	Ribadeo FC	38	41	68	35
19	Noia	38	28	59	32
20	Verín	38	30	54	31

TEMPORADA 2014/2015

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Pontevedra	38	65	25	79
2	Deportivo	38	66	32	71
3	CCD Cerceda	38	64	37	64
4	Choco	38	58	39	62
5	Bergantiños	38	46	31	59
6	Ribadeo FC	38	54	64	58
7	Ribadumia	38	56	44	58
8	Alondras CF	38	43	41	56
9	Villalbés	38	49	38	56
10	Rápido	38	48	35	56
11	Arosa	38	51	42	54
12	Barbadás	38	39	40	53
13	Club Ordenes	38	47	48	53
14	As Pontes	38	48	50	52
15	Boiro	38	51	48	51
16	Silva SD	38	44	58	48
17	Sanxenxo	38	48	65	41
18	Cultural	38	41	65	34
19	Laracha	38	28	61	33
20	Bertamiráns	38	26	109	8

TEMPORADA 2013/2014

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Somozas	38	72	36	75
2	CCD Cerceda	38	61	27	74
3	Boiro	38	66	37	74
4	Pontevedra	38	47	27	73
5	As Pontes	38	72	42	73
6	Choco	38	67	51	65
7	Arosa	38	48	39	59
8	Club Ordenes	38	49	38	58
9	Deportivo	38	54	55	54
10	Rápido	38	46	51	51
11	Barbadás	38	43	43	51
12	Alondras CF	38	46	51	46
13	Villalbés	38	31	47	46
14	Bertamiráns	38	34	45	42
15	Laracha	38	31	54	37
16	Cultural	38	46	74	35
17	Grixoa	38	32	55	33
18	Betanzos CF	38	30	55	31
19	CD Dorneda	38	33	57	31
20	Negreira	38	36	60	31

TEMPORADA 2012/2013

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Racing	38	98	22	97
2	Celta	38	75	34	77
3	Compostela	38	64	28	73
4	Deportivo	38	76	33	71
5	Pontevedra	38	57	45	63
6	As Pontes	38	56	53	59
7	Club Ordenes	38	45	38	55
8	Rápido	38	39	53	52
9	Alondras CF	38	48	45	52
10	Villalbés	38	45	42	48
11	CCD Cerceda	38	35	44	48
12	Somozas	38	41	45	47
13	Betanzos CF	38	48	61	47
14	Barbadás	38	39	47	47
15	SD Negreira	38	37	56	45
16	CD Dorneda	38	37	55	45
17	Villalonga	38	44	50	45
18	Bergantiños	38	28	63	30
19	Céltiga FC	38	28	71	25
20	Narón BP	38	30	85	20

Competiciones que juega

Segunda Federación Grupo 1

Pos	Equipos		Pts
1		Ourense CF	70
2		Pontevedra	65
3		Zamora	60
4		Guijuelo	51
5		Rayo Cantabria	48
6		Langreo	47
7		SD Compostela	47
8		Real Valladolid Promesas	44
9		Coruxo	43
10		Deportivo Fabril	41
11		Real Avilés Industrial	41
12		Gimnástica Torrelavega	40
13		Marino de Luanco	40
14		RC Villalbés	35
15		Arandina	32
16		Real Oviedo Vetusta	30
17		Cayón	30
18		CD Covadonga	29

	Ascenso : Ourense CF
	Playoff Ascenso : Pontevedra, Zamora, Guijuelo, Rayo Cantabria
	Playoff Descenso : Marino de Luanco
	Descenso : RC Villalbés, Arandina, Real Oviedo Vetusta, Cayón, CD Covadonga

RIVALES EN Copa Federación.

RIVALES EN Segunda Federaci.

USO DE MEMORIA

6,980,392 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.5814
Total Execution Time	0.5833

CADENA URL

/historico/Racing-Club-Villalbes

GET DATOS

$_GET['/historico/Racing-Club-Villalbes']

POST DATOS

No hay datos POST existentes

CONSULTAS (35)

0.0136	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 = 'Racing-Club-Villalbes' 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.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=9332 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=9332 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=9332 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=9332 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9332 AND type_rel = 2
0.0126	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 9332 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0129	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 (85580,85869,258596,260654,263247) 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 = '9332' 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 = '9332' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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=9332 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 (72729,72362,71489,71432,67975) 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.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 72362 AND teamId = 9332
0.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 67975 AND teamId = 9332
0.0131	SELECT count(id) as num_players from rel_players WHERE league_id = 71489 AND teamId = 9332
0.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 72729 AND teamId = 9332
0.0129	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 9332
0.0128	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 = '9332' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '9332' and rp.type = 4
0.0126	SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '9332' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0142	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 = 72362 WHERE rp.league_id = 72362 AND rp.teamId = 9332 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.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 = 72362 WHERE rp.league_id = 72362 AND rp.teamId = 9332 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 = 72362 WHERE rp.league_id = 72362 AND rp.teamId = 9332 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 = 9332 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 67975 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 = 62385 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 58579 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.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* `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 = 50269 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2019` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 44389 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* `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 = 39025 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* `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 = 33351 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* `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 = 15442 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 3911 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 = 2551 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* `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 = 1970 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

RC Villalbés

RC Villalbés

Selecciona un equipo

Competiciones que juega

Segunda Federación Grupo 1

RIVALES EN Copa Federación.

RIVALES EN Segunda Federaci.