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

Länk Vilaverdense

Entrenador: Sérgio Machado

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA LIGA
Equipo		PJ	GF	GC	Puntos
1	Santa Clara	30	40	17	63
2	Nacional	30	54	32	59
3	AVS Futebol	30	43	30	59
4	Marítimo	31	47	26	57
5	Tondela	30	41	37	45
6	Paços	30	35	27	45
7	Porto II	30	46	37	43
8	Mafra	31	37	35	43
9	Torreense	30	35	33	41
10	União	31	41	37	39
11	Academico	30	31	31	38
12	Penafiel	31	29	35	38
13	Benfica II	30	37	41	37
14	Leixões	31	25	36	32
15	Oliveirense	31	33	48	31
16	Feirense	31	28	46	27
17	Belenenses	30	24	49	26
18	Länk	31	27	56	24

TEMPORADA 2022/2023

LIGA 3 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	União	6	12	4	15
2	Sporting	6	5	5	9
3	FC Alverca	6	7	9	7
4	Felgueiras	6	4	10	4
5	Belenenses	6	8	4	11
6	Länk	6	9	2	11
7	Sanjoanense	6	4	6	8
8	Amora FC	6	4	13	3

TEMPORADA 2021/2022

CAMPEONATO DE PORTUGAL GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	USC Paredes	10	10	7	18
2	Länk	10	14	12	15
3	Leça FC	10	11	9	15
4	São	10	10	11	11
5	Salgueiros	10	10	12	11
6	Marítimo	10	12	16	8
7	Fontinhas	10	12	8	20
8	Moncarapache	10	9	3	19
9	Belenenses	10	17	9	16
10	Sertanense	10	11	11	11
11	Olhanense	10	5	14	7
12	Pêro	10	5	14	5

TEMPORADA 2020/2021

CAMPEONATO DE PORTUGAL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Sporting	22	61	12	55
2	Merelinense	22	34	13	48
3	Montalegre	22	36	24	38
4	Mirandela	22	24	16	35
5	Maria Fonte	22	30	29	32
6	Vianense	22	26	28	32
7	Länk	22	28	30	28
8	Pedras	22	19	23	26
9	Vidago	22	27	36	23
10	Braganca	22	16	25	20
11	Cerveira	22	11	27	15
12	Águia	22	12	61	8

TEMPORADA 2018/2019

CAMPEONATO DE PORTUGAL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Vizela	34	73	14	76
2	Fafe	34	62	27	73
3	São	34	56	24	72
4	Gil Vicente	34	65	30	70
5	Trofense	34	64	29	70
6	Felgueiras	34	57	35	67
7	Mirandela	34	51	43	52
8	Chaves II	34	57	48	48
9	Merelinense	34	38	38	44
10	Montalegre	34	41	54	43
11	Maria Fonte	34	45	54	40
12	Pedras	34	43	58	39
13	Oliveirense	34	40	58	37
14	Os Limianos	34	31	52	37
15	Torcatense	34	30	63	29
16	Desportivo	34	26	58	21
17	Caçadores	34	28	67	21
18	Länk	34	30	85	15

TEMPORADA 2017/2018

CAMPEONATO DE PORTUGAL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Vizela	30	53	11	73
2	Länk	30	65	29	64
3	Fafe	30	42	19	60
4	Mirandela	30	42	26	57
5	Merelinense	30	60	29	53
6	São	30	46	31	49
7	Oliveirense	30	41	27	44
8	Montalegre	30	39	38	38
9	Pedras	30	32	35	38
10	Torcatense	30	28	36	38
11	Braganca	30	31	43	33
12	Câmara	30	27	54	30
13	Atlético	30	28	55	26
14	Arões	30	25	41	24
15	Mondinense	30	27	68	23
16	Minas	30	24	68	11

TEMPORADA 2016/2017

CAMPEONATO DE PORTUGAL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Merelinense	18	39	10	45
2	Länk	18	38	15	38
3	Oliveirense	18	38	24	38
4	Braganca	18	38	29	34
5	Montalegre	18	23	30	21
6	Torcatense	18	18	28	21
7	Mirandela	18	17	24	18
8	Pedras	18	19	32	17
9	Os Limianos	18	16	34	11
10	Ponte Barca	18	14	34	10

TEMPORADA 2015/2016

CAMPEONATO DE PORTUGAL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Braganca	18	32	14	34
2	Länk	18	28	18	33
3	Pedras	18	25	16	32
4	Mirandela	18	32	17	29
5	Os Limianos	18	22	20	28
6	Marítimo	18	20	17	25
7	Camacha	18	20	23	19
8	Vianense	18	15	23	17
9	Minas	18	19	34	15
10	Neves FC	18	20	51	10

TEMPORADA 2014/2015

CAMPEONATO DE PORTUGAL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Fafe	18	28	10	37
2	Mirandela	18	23	12	35
3	Länk	18	17	15	29
4	Pedras	18	22	14	25
5	Braganca	18	19	17	25
6	Cerveira	18	20	27	23
7	Vianense	18	24	27	21
8	Santa Maria	18	17	19	19
9	Os Limianos	18	12	24	14
10	Vieira Sport	18	10	27	10

TEMPORADA 2013/2014

CAMPEONATO DE PORTUGAL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Os Limianos	18	27	16	34
2	Fafe	18	21	9	33
3	Braganca	18	24	17	33
4	Mirandela	18	21	13	29
5	Vianense	18	15	12	26
6	Santa Maria	18	17	21	22
7	Länk	18	12	15	21
8	Valenciano	18	16	22	21
9	Pedras	18	17	27	15
10	Ninense	18	11	29	8

TEMPORADA 2012/2013

CAMPEONATO DE PORTUGAL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Chaves	30	43	21	58
2	Ribeirão	30	43	24	55
3	Mirandela	30	41	29	53
4	Vizela	30	41	29	51
5	Tirsense	30	35	32	45
6	Os Limianos	30	33	30	45
7	Famalicão	30	42	35	43
8	Varzim	30	31	26	40
9	Fafe	30	37	33	40
10	Boavista	30	44	40	38
11	Gondomar	30	25	27	33
12	Amarante	30	30	33	33
13	Länk	30	22	36	33
14	Joane	30	27	48	28
15	Infesta	30	30	51	25
16	Padroense	30	23	53	21

TEMPORADA 2011/2012

III DIVISAO PORTUGAL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Santa Maria	22	43	19	45
2	Joane	22	33	23	42
3	Vianense	21	31	14	38
4	Braganca	22	30	20	38
5	Länk	22	27	20	38
6	Maria Fonte	22	23	26	30
7	Esposende	21	27	39	26
8	Marinhas	21	25	30	24
9	Melgacense	21	24	35	24
10	Amares	22	17	24	22
11	Fão	22	22	32	19
12	Cerveira	22	20	40	15

Competiciones que juega

Segunda Liga

Pos	Equipos		Pts
1		CD Santa Clara	63
2		Nacional	59
3		AVS Futebol	59
4		Marítimo	57
5		Tondela	45
6		Paços de Ferreira	45
7		Porto II	43
8		Mafra	43
9		Torreense	41
10		União de Leiria	39
11		Academico Viseu	38
12		Penafiel	38
13		Benfica II	37
14		Leixões	32
15		UD Oliveirense	31
16		Feirense	27
17		Os Belenenses	26
18		Länk Vilaverdense	24

	Ascenso : CD Santa Clara, Nacional
	Playoff Ascenso : AVS Futebol
	Playoff Descenso : Feirense
	Descenso : Os Belenenses, Länk Vilaverdense

RIVALES EN Segunda Liga

RIVALES EN Fases Previas Co.

RIVALES EN Taça de Portugal

USO DE MEMORIA

6,455,344 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1372
Total Execution Time	0.1384

CADENA URL

/historico/Vilaverdense

GET DATOS

$_GET['/historico/Vilaverdense']

POST DATOS

No hay datos POST existentes

CONSULTAS (42)

0.0033	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 = 'Vilaverdense' 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=7034 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=7034 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=7034 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=7034 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=7034 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=7034 AND type_rel = 2
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 7034 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021	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 (399590,1193144) ORDER BY n.cover_points DESC, update_date DESC
0.0030	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 = '7034' ORDER BY l.year DESC,cat.coefficient DESC
0.0023	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 = '7034' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0024	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 = '7034' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0025	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 = 73560 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024	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=7034 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 (73560,72505,72056,71886,71619,71432) 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.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 72056 AND teamId = 7034
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 71619 AND teamId = 7034
0.0037	SELECT count(id) as num_players from rel_players WHERE league_id = 73560 AND teamId = 7034
0.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 72505 AND teamId = 7034
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 71886 AND teamId = 7034
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 7034
0.0022	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 = '7034' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '7034' 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 = '7034' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0037	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 = 72056 WHERE rp.league_id = 72056 AND rp.teamId = 7034 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.0031	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 = 72056 WHERE rp.league_id = 72056 AND rp.teamId = 7034 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 = 72056 WHERE rp.league_id = 72056 AND rp.teamId = 7034 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026	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 = 7034 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* `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 = 72056 AND t.round = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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 = 68264 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.0023	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 = 71400 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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 = 63450 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.0022	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 = 66952 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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 = 58698 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.0024	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 = 44596 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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 = 39611 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	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 = 34050 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	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 = 16752 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	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 = 4337 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	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 = 2757 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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 = 2171 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	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 = 1703 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Länk Vilaverdense

Länk Vilaverdense

Selecciona un equipo

Competiciones que juega

Segunda Liga

RIVALES EN Segunda Liga

RIVALES EN Fases Previas Co.

RIVALES EN Taça de Portugal