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

Tondela

Entrenador: Sergio Gaminha

Temporada 2023/2024

TEMPORADA 2023/2024

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

TEMPORADA 2022/2023

SEGUNDA LIGA
Equipo		PJ	GF	GC	Puntos
1	Moreirense	34	77	38	79
2	Farense	34	57	34	69
3	Estrela	34	55	35	63
4	Academico	34	51	45	53
5	Porto II	34	48	40	51
6	Mafra	34	46	49	47
7	Vilafranquen	34	42	36	46
8	Feirense	34	43	37	46
9	Torreense	34	38	41	44
10	Oliveirense	34	51	50	43
11	Tondela	34	35	35	40
12	Penafiel	34	36	47	39
13	Nacional	34	35	46	39
14	Benfica II	34	52	58	38
15	Leixões	34	38	49	38
16	Belenenses	34	41	59	35
17	Trofense	34	31	51	32
18	SC Covilha	34	31	57	28

TEMPORADA 2021/2022

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Porto	34	86	22	91
2	Sporting CP	34	73	23	85
3	Benfica	34	78	30	74
4	Sporting	34	52	31	65
5	Gil Vicente	34	47	42	51
6	Vitória	34	50	41	48
7	Santa Clara	34	38	54	40
8	Famalicão	34	45	51	39
9	Estoril	34	36	43	39
10	Marítimo	34	39	44	38
11	Paços	34	29	44	38
12	Boavista	34	39	52	38
13	Portimonense	34	31	45	38
14	Vizela	34	37	58	33
15	Arouca	34	30	54	31
16	Moreirense	34	33	51	29
17	Tondela	34	41	67	28
18	Belenenses	34	23	55	26

TEMPORADA 2020/2021

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Sporting CP	34	65	20	85
2	Porto	34	74	29	80
3	Benfica	34	69	27	76
4	Sporting	34	53	33	64
5	Paços	34	40	41	53
6	Santa Clara	34	44	36	46
7	Vitória	34	37	44	43
8	Moreirense	34	37	43	43
9	Famalicão	34	40	48	40
10	Belenenses	34	25	35	40
11	Gil Vicente	34	33	42	39
12	Tondela	34	36	57	36
13	Boavista	34	39	49	36
14	Portimonense	34	34	41	35
15	Marítimo	34	27	47	35
16	Rio Ave	34	25	40	34
17	Farense	34	31	48	31
18	Nacional	34	30	59	25

TEMPORADA 2019/2020

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Porto	34	74	22	82
2	Benfica	34	71	26	77
3	Sporting	34	61	40	60
4	Sporting CP	34	49	34	60
5	Rio Ave	34	48	36	55
6	Famalicão	34	53	51	54
7	Vitória	34	53	38	50
8	Moreirense	34	42	44	43
9	Santa Clara	34	36	41	43
10	Gil Vicente	34	40	44	43
11	Marítimo	34	34	42	39
12	Boavista	34	28	39	39
13	Paços	34	36	52	39
14	Tondela	34	30	44	36
15	Belenenses	34	27	54	35
16	Vitória	34	27	43	34
17	Portimonense	34	30	45	33
18	Desportivo	34	24	68	17

TEMPORADA 2018/2019

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Benfica	34	103	31	87
2	Porto	34	74	20	85
3	Sporting CP	34	72	33	74
4	Sporting	34	56	37	67
5	Vitória	34	46	34	52
6	Moreirense	34	39	44	52
7	Rio Ave	34	50	52	45
8	Boavista	34	34	40	44
9	Belenenses	34	42	51	43
10	Santa Clara	34	43	45	42
11	Portimonense	34	44	59	39
12	Marítimo	34	26	44	39
13	Vitória	34	28	39	36
14	Desportivo	34	35	49	36
15	Tondela	34	40	54	35
16	Chaves	34	34	57	32
17	Nacional	34	33	73	28
18	Feirense	34	27	64	20

TEMPORADA 2017/2018

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Porto	34	82	18	88
2	Benfica	34	80	22	81
3	Sporting CP	34	63	24	78
4	Sporting	34	74	29	75
5	Rio Ave	34	40	42	51
6	Chaves	34	47	55	47
7	Marítimo	34	36	49	47
8	Boavista	34	35	44	45
9	Vitória	34	45	56	43
10	Portimonense	34	52	60	38
11	Tondela	34	41	50	38
12	Belenenses	34	33	46	37
13	Desportivo	34	36	51	34
14	Moreirense	34	29	50	32
15	Vitória	34	39	62	32
16	Feirense	34	32	48	31
17	Paços	34	33	59	30
18	Estoril	34	29	61	30

TEMPORADA 2016/2017

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Benfica	34	72	18	82
2	Porto	34	71	19	76
3	Sporting CP	34	68	36	70
4	Vitória	34	50	39	62
5	Sporting	34	51	36	54
6	Marítimo	34	34	32	50
7	Rio Ave	34	41	39	49
8	Feirense	34	31	45	48
9	Boavista	34	33	36	43
10	Estoril	34	36	42	38
11	Chaves	34	35	42	38
12	Vitória	34	30	39	38
13	Paços	34	32	45	36
14	Belenenses	34	27	45	36
15	Moreirense	34	33	48	33
16	Tondela	34	29	52	32
17	Arouca	34	33	57	32
18	Nacional	34	22	58	21

TEMPORADA 2015/2016

LIGA PORTUGUESA
Equipo		PJ	GF	GC	Puntos
1	Benfica	34	88	22	88
2	Sporting CP	34	79	21	86
3	Porto	34	67	30	73
4	Sporting	34	54	35	58
5	Arouca	34	47	38	54
6	Rio Ave	34	44	44	50
7	Paços	34	43	42	49
8	Estoril	34	40	41	47
9	Belenenses	34	44	66	41
10	Vitória	34	45	53	40
11	Nacional	34	40	56	38
12	Moreirense	34	38	54	36
13	Marítimo	34	45	63	35
14	Boavista	34	24	41	33
15	Tondela	34	34	54	30
16	Vitória	34	40	61	30
17	União	34	27	50	29
18	Académica	34	32	60	25

TEMPORADA 2014/2015

SEGUNDA LIGA
Equipo		PJ	GF	GC	Puntos
1	Tondela	46	67	51	81
2	SC Covilha	46	78	46	80
3	União	46	69	39	80
4	Chaves	46	68	45	80
5	Sporting	46	66	57	78
6	Benfica II	46	81	60	77
7	Feirense	46	61	51	75
8	Freamunde	46	48	32	71
9	Vitória	46	71	57	65
10	Beira	46	52	48	63
11	Academico	46	55	56	62
12	Farense	46	51	54	62
13	Porto II	46	66	64	61
14	Portimonense	46	56	62	60
15	Oriental	46	47	59	58
16	Olhanense	46	51	56	55
17	Oliveirense	46	50	67	55
18	Desportivo	46	52	58	53
19	Santa Clara	46	33	42	51
20	Sporting	46	48	62	51
21	Leixões	46	53	67	50
22	Atlético	46	56	70	47
23	Marítimo	46	37	67	41
24	Trofense	46	35	81	36

TEMPORADA 2013/2014

SEGUNDA LIGA
Equipo		PJ	GF	GC	Puntos
1	Moreirense	42	65	25	79
2	Porto II	42	59	42	77
3	Penafiel	42	47	24	73
4	Desportivo	42	46	35	71
5	Benfica II	42	77	56	70
6	Sporting	42	61	50	70
7	Portimonense	42	58	48	67
8	Chaves	42	58	56	67
9	Tondela	42	41	38	59
10	Farense	42	45	44	57
11	Academico	42	43	43	54
12	Beira	42	45	48	54
13	União	42	50	46	52
14	Feirense	42	41	46	50
15	Santa Clara	42	38	46	48
16	SC Covilha	42	34	50	48
17	Leixões	42	42	57	47
18	Oliveirense	42	56	76	47
19	Trofense	42	36	61	47
20	Sporting	42	47	60	44
21	Marítimo	42	39	57	43
22	Atlético	42	34	54	40

TEMPORADA 2012/2013

SEGUNDA LIGA
Equipo		PJ	GF	GC	Puntos
1	Belenenses	42	75	41	94
2	Arouca	42	65	48	73
3	Leixões	42	49	36	68
4	Sporting	42	62	47	66
5	Desportivo	42	47	42	65
6	Portimonense	42	61	50	64
7	Benfica II	42	71	54	62
8	Penafiel	42	48	44	60
9	Oliveirense	42	52	49	60
10	Santa Clara	42	55	48	59
11	Tondela	42	55	60	59
12	Naval	42	51	50	57
13	Feirense	42	61	59	56
14	União	42	47	46	56
15	Porto II	42	49	49	54
16	Marítimo	42	40	46	49
17	Sporting	42	39	51	49
18	Atlético	42	45	63	44
19	Trofense	42	41	60	40
20	SC Covilha	42	37	52	38
21	Vitória	42	30	56	36
22	Freamunde	42	46	75	33

TEMPORADA 2011/2012

CAMPEONATO DE PORTUGAL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Tondela	30	49	22	63
2	Espinho	30	50	32	62
3	Operário	30	34	26	52
4	Boavista	30	43	31	50
5	Amarante	30	48	30	49
6	São João	30	43	46	49
7	Gondomar	30	27	31	44
8	Cinfães	30	35	40	43
9	Coimbrões	30	30	31	42
10	Anadia	30	45	42	40
11	Padroense	30	47	50	39
12	Aliados	30	41	40	37
13	Oliveira	30	34	50	28
14	Angrense	30	36	49	23
15	USC Paredes	30	30	50	23
16	Madalena FC	30	32	54	21

Competiciones que juega

Grupo 3

Segunda Liga

Pos	Equipos		Pts
1		CD Santa Clara	64
2		Nacional	62
3		AVS Futebol	59
4		Marítimo	57
5		Tondela	46
6		Paços de Ferreira	45
7		Porto II	44
8		Mafra	43
9		Academico Viseu	41
10		Torreense	41
11		União de Leiria	39
12		Benfica II	38
13		Penafiel	38
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 Copa de la Liga.

RIVALES EN Fases Previas Co.

RIVALES EN Taça de Portugal

USO DE MEMORIA

7,427,352 bytes

BENCHMARKS

Loading Time Base Classes	0.0017
Controller Execution Time ( Home / Category )	0.5669
Total Execution Time	0.5687

CADENA URL

/historico/Tondela

GET DATOS

$_GET['/historico/Tondela']

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.0121	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 = 'Tondela' 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.0105	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=6994 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106	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=6994 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106	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=6994 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106	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=6994 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106	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=6994 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106	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=6994 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0112	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 = 74075
0.0105	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6994 AND type_rel = 2
0.0113	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6994 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0109	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 (7726,15846,20069,24973,25184) ORDER BY n.cover_points DESC, update_date DESC
0.0113	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 = '6994' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0114	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 = '6994' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0107	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 = 72056 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0107	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 = 74075 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0115	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=6994 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0108	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 (74075,73560,72505,72056,71432,67608) 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.0118	SELECT count(id) as num_players from rel_players WHERE league_id = 72056 AND teamId = 6994
0.0151	SELECT count(id) as num_players from rel_players WHERE league_id = 73560 AND teamId = 6994
0.0126	SELECT count(id) as num_players from rel_players WHERE league_id = 72505 AND teamId = 6994
0.0109	SELECT count(id) as num_players from rel_players WHERE league_id = 74075 AND teamId = 6994
0.0109	SELECT count(id) as num_players from rel_players WHERE league_id = 67608 AND teamId = 6994
0.0114	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 6994
0.0112	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 = 72056 AND t.round = 31 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0107	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 = '6994' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0106	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6994' and rp.type = 4
0.0107	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 = '6994' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0126	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 = 6994 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.0127	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 = 6994 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0118	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 = 6994 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0118	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 = 6994 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0112	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 = 62752 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.0112	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 = 57339 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.0115	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 = 49945 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.0111	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 = 43558 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0114	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 = 31005 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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 = 15394 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115	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 = 3858 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113	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 = 2504 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113	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 = 1932 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110	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 = 1700 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Tondela

Tondela

Selecciona un equipo

Competiciones que juega

Segunda Liga

RIVALES EN Segunda Liga

RIVALES EN Copa de la Liga.

RIVALES EN Fases Previas Co.

RIVALES EN Taça de Portugal