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

III. Kerületi TVE

Temporada 2023/2024

TEMPORADA 2023/2024

TERCERA HUNGRÍA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Tatabánya	26	51	26	56
2	Veszprém	26	55	32	53
3	Bicskei	25	40	23	50
4	III.	25	41	24	48
5	Komaromi	26	33	28	39
6	Budaörsi	26	44	44	38
7	Gyirmót II	26	49	50	38
8	Dorogi FC	26	37	33	37
9	Sopron	25	35	31	34
10	Puskás	26	41	33	33
11	Balatonfüre	26	31	38	32
12	Kelen	26	32	47	32
13	Győri	26	39	41	28
14	Haladas	26	35	55	22
15	Zalaegerszeg	26	25	51	17
16	Csornai SE	25	26	58	12

TEMPORADA 2022/2023

TERCERA HUNGRÍA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Veszprém	38	82	24	92
2	Tatabánya	38	77	35	90
3	Nagykanizsai	38	105	41	87
4	Puskás	38	77	35	70
5	III.	38	82	40	68
6	Erdi VSE	38	55	33	65
7	Bicskei	38	59	41	63
8	Kaposvari	38	58	44	60
9	Budaörsi	38	56	43	60
10	Balatonfüre	38	50	52	56
11	Fehérvár	38	48	56	55
12	Komaromi	38	57	53	53
13	Győri	38	61	60	52
14	Gyirmót II	38	65	83	39
15	Zalaegerszeg	38	45	83	38
16	Kelen	38	42	60	32
17	Csornai SE	38	42	85	27
18	Teskánd	38	50	111	25
19	Móri SE	38	35	93	21
20	Zsámbéki	38	33	107	13

TEMPORADA 2021/2022

SEGUNDA HUNGRÍA
Equipo		PJ	GF	GC	Puntos
1	Budapesti	38	80	22	85
2	Kecskemét	38	75	36	77
3	Diósgyőr	38	57	40	72
4	Szeged 2011	38	64	34	66
5	BFC Siófok	38	42	37	59
6	Szombathelyi	38	37	30	57
7	Györi ETO	38	57	46	56
8	Soroksár	38	67	61	52
9	FC Ajka	38	49	49	51
10	Nyíregyház	38	45	51	50
11	Pécsi MFC	38	38	39	48
12	Csákvári	38	52	57	43
13	Tiszakécske	38	41	65	42
14	Budafoki	38	39	50	42
15	Békéscsaba	38	53	69	42
16	Szentlőrinc	38	39	57	42
17	Dorogi FC	38	35	60	41
18	Szolnoki	38	35	55	38
19	Budaörsi	38	40	61	38
20	III.	38	36	62	37

TEMPORADA 2020/2021

TERCERA HUNGRÍA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	III.	38	91	22	88
2	Mosonmagyar�	38	79	35	74
3	Veszprém	37	61	44	67
4	Nagykanizsai	38	77	50	66
5	Tatabánya	37	56	39	61
6	Lipot SK	38	66	58	60
7	Sopron	38	56	50	60
8	Puskás	38	67	51	58
9	Komaromi	38	52	59	56
10	Erdi VSE	38	51	54	54
11	Balatonfüre	38	69	58	52
12	Bicskei	38	42	50	50
13	Zalaegerszeg	38	56	64	49
14	Lombard	38	48	56	48
15	Fehérvár	38	52	58	47
16	BKV Előre	38	46	60	44
17	Gárdony	38	58	82	44
18	Szabadkikoto	38	63	82	37
19	Ménfőcsana	38	37	72	29
20	Nagyatádi	38	32	115	12

TEMPORADA 2019/2020

TERCERA HUNGRÍA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Erdi VSE	19	40	16	42
2	III.	19	43	21	41
3	Lipot SK	19	33	21	39
4	Ménfőcsana	19	25	22	30
5	Pápai	19	25	22	30
6	Komaromi	19	29	23	29
7	Nagykanizsai	19	25	27	28
8	Veszprém	19	22	16	25
9	Mosonmagyar�	19	30	29	25
10	Bicskei	19	20	24	22
11	Puskás	19	29	27	21
12	BKV Előre	19	21	27	20
13	Sárvári	19	15	22	20
14	Videoton II	19	17	25	20
15	Héviz FC	19	22	40	13
16	Balatonlelle	19	13	47	10

TEMPORADA 2018/2019

TERCERA HUNGRÍA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	FC Ajka	30	85	20	71
2	Erdi VSE	30	59	40	59
3	Puskás	30	53	40	50
4	Komaromi	30	51	42	49
5	III.	30	49	46	49
6	Nagykanizsai	30	45	41	42
7	Ménfőcsana	30	45	47	41
8	Pápai	30	50	46	40
9	BKV Előre	30	49	56	38
10	Penzugyor	30	40	50	33
11	Szabadkikoto	30	41	60	33
12	Sárvári	30	26	33	32
13	Dunaharaszti	30	36	56	32
14	Videoton II	30	42	49	31
15	Csepel FC	30	26	54	30
16	Andráshida	30	29	46	27

TEMPORADA 2017/2018

TERCERA HUNGRÍA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Kaposvari	30	66	24	70
2	FC Ajka	30	76	31	64
3	Erdi VSE	30	56	34	57
4	Puskás	30	57	34	53
5	III.	30	49	43	50
6	Andráshida	30	43	41	48
7	Pápai	30	48	43	46
8	BKV Előre	30	37	36	45
9	Csepel FC	30	43	34	42
10	Videoton II	30	48	54	39
11	Dunaharaszti	30	38	46	33
12	Penzugyor	30	32	53	29
13	Szabadkikoto	30	30	72	27
14	Csornai SE	30	27	55	26
15	Veszprém	30	38	58	26
16	Gyirmót II	30	28	58	23

TEMPORADA 2016/2017

TERCERA HUNGRÍA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Györi ETO	32	84	22	81
2	Erdi VSE	32	70	36	72
3	Kaposvari	32	65	26	64
4	FC Ajka	32	58	39	59
5	Csornai SE	32	44	34	54
6	Puskás	32	54	38	51
7	Budapest	32	63	49	46
8	III.	32	47	43	45
9	Csepel FC	32	35	35	44
10	Andráshida	32	41	46	43
11	Gyirmót II	32	34	43	40
12	Veszprém	32	32	49	40
13	Videoton II	32	41	60	35
14	Sárvári	32	24	42	33
15	Héviz FC	32	27	42	31
16	Komaromi	32	27	65	19
17	Diósdi TC	32	15	92	16
18	Tatabánya	0	0	0	0

TEMPORADA 2015/2016

TERCERA HUNGRÍA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Ferencváros	32	65	26	72
2	Mosonmagyar�	32	72	34	69
3	Dorogi FC	32	44	16	68
4	Györi ETO	32	60	33	57
5	Tatabánya	32	55	40	55
6	Videoton II	32	70	50	53
7	Andráshida	32	49	38	50
8	BKV Előre	32	49	39	47
9	Budapest	32	44	46	46
10	Erdi VSE	32	47	47	44
11	Puskás	32	56	53	39
12	III.	32	47	55	39
13	Diósdi TC	32	39	48	39
14	Csepel FC	32	27	71	26
15	Csornai SE	32	26	62	21
16	Sárvári	32	28	76	20
17	Balatonfüre	32	26	70	17

TEMPORADA 2014/2015

TERCERA HUNGRÍA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Budaörsi	28	63	19	64
2	Dorogi FC	28	36	18	57
3	Győri	28	50	26	54
4	Diósdi TC	28	37	35	47
5	Tatabánya	28	53	35	45
6	Rákosmenti	28	44	30	45
7	Újbuda TC	28	34	33	44
8	BKV Előre	28	41	38	40
9	Sárvári	28	33	43	35
10	III.	28	39	48	34
11	Balatonfüre	28	37	42	30
12	Mosonmagyar�	28	32	43	29
13	Csepel FC	28	25	34	28
14	Nagyatádi	28	22	49	24
15	Tököl	28	13	66	7
16	Veszprém	0	0	0	0

TEMPORADA 2012/2013

TERCERA HUNGRÍA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Budaörsi	27	48	19	58
2	ESMTK	27	56	25	54
3	Diósdi TC	27	52	20	51
4	Videoton II	27	52	29	48
5	Jászapáti	27	59	37	48
6	Csepel FC	27	41	24	45
7	Erdi VSE	27	43	34	40
8	Sárisápi	27	41	50	40
9	Biatorbágy	27	41	32	39
10	Százhalomba	27	46	53	37
11	Penzugyor	28	35	47	35
12	III.	27	41	37	33
13	Budafoki LC	27	27	71	18
14	Rakosmenti	27	25	70	14
15	RAFC	27	25	84	8

TEMPORADA 2011/2012

TERCERA HUNGRÍA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Erdi VSE	30	75	21	75
2	Dorogi FC	30	51	14	68
3	ESMTK	30	64	25	61
4	Újbuda TC	30	58	38	55
5	Soroksár	30	46	26	51
6	Diósdi TC	30	54	39	48
7	Sárisápi	30	42	37	48
8	Biatorbágy	30	43	35	46
9	Penzugyor	30	47	40	44
10	Százhalomba	30	48	52	37
11	RAFC	30	31	51	33
12	Bicskei	30	33	51	28
13	III.	30	39	62	28
14	Budafoki LC	30	27	51	28
15	Törökbáli	30	34	79	19
16	Gázművek	30	21	92	5

TEMPORADA 2008/2009

TERCERA HUNGRÍA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Szigetszentm	30	77	22	73
2	Velence SE	30	80	38	68
3	Soroksár	30	59	30	64
4	Siófok II	30	54	26	53
5	Dunaharaszti	30	63	40	52
6	Móri SE	30	47	36	42
7	Törökbáli	30	55	54	39
8	Penzugyor	30	37	46	38
9	Csepel FC	29	36	40	37
10	Videoton II	30	40	49	35
11	Sárisápi	29	35	49	31
12	Dorogi FC	29	36	52	31
13	III.	30	39	63	30
14	Kornye	30	36	65	26
15	Balatonlelle	29	29	54	24
16	Csillaghegyi	30	29	88	14

TEMPORADA 1998/1999

LIGA HUNGRÍA
Equipo		PJ	GF	GC	Puntos
1	REAC	34	77	26	83
2	Ferencváros	34	61	40	64
3	Újpest FC	34	58	40	63
4	Györi ETO	34	53	39	59
5	Dunaferr	34	54	46	57
6	Budapesti	34	51	44	55
7	Zalaegerszeg	34	43	37	53
8	DVTK Borsodi	34	56	54	51
9	Debreceni	34	53	39	49
10	Samsung Vác	34	51	49	49
11	Gazszer	34	37	40	44
12	Budapest	34	38	50	42
13	Nyíregyház	34	46	52	39
14	Szombathelyi	34	39	54	36
15	BFC Siófok	34	32	49	30
16	Fehérvár	34	36	54	30
17	Budapest	34	34	53	27
18	III.	34	40	93	18

TEMPORADA 1996/1997

LIGA HUNGRÍA
Equipo		PJ	GF	GC	Puntos
1	Budapest	34	87	25	85
2	Újpest FC	34	75	35	76
3	Ferencváros	34	69	37	74
4	Budapesti	34	50	33	64
5	Debreceni	34	55	38	52
6	Budapest	34	43	36	49
7	Budapest	34	42	44	45
8	Fehérvár	34	45	44	42
9	Györi ETO	34	44	51	42
10	Szombathelyi	34	39	42	40
11	Samsung Vác	34	40	48	40
12	BFC Siófok	34	36	53	40
13	Zalaegerszeg	34	34	51	40
14	Békéscsaba	34	37	62	36
15	III.	34	45	55	35
16	Stadler	34	27	50	28
17	Pécsi MFC	34	31	68	26
18	Csepel FC	34	43	70	25

Competiciones que juega

Grupo 2

Tercera Hungría Grupo 2

Pos	Equipos		Pts
1		Tatabánya	56
2		Veszprém	53
3		Bicskei	50
4		III. Kerületi TVE	48
5		Komaromi	39
6		Budaörsi	38
7		Gyirmót II	38
8		Dorogi FC	37
9		Sopron	34
10		Puskás Akadémia II	33
11		Balatonfüredi	32
12		Kelen	32
13		Győri ETO II	28
14		Haladas / Zanati	22
15		Zalaegerszegi TE II	17
16		Csornai SE	12

	Ascenso : Tatabánya

RIVALES EN Copa Hungría

RIVALES EN Tercera Hungría

USO DE MEMORIA

7,064,072 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1350
Total Execution Time	0.1361

CADENA URL

/historico/Iii-Keruleti-Tue

GET DATOS

$_GET['/historico/Iii-Keruleti-Tue']

POST DATOS

No hay datos POST existentes

CONSULTAS (38)

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 = 'Iii-Keruleti-Tue' 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=20433 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=20433 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=20433 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=20433 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040	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 = 72644
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=20433 AND type_rel = 2
0.0024	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 = '20433' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0029	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 = '20433' 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 = 73256 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020	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 = 72644 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026	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=20433 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020	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 (73256,72644,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 = 72644 AND teamId = 20433
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 73256 AND teamId = 20433
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 20433
0.0020	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 = '20433' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0017	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '20433' and rp.type = 4
0.0019	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 = '20433' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 72644 WHERE rp.league_id = 72644 AND rp.teamId = 20433 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.0021	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 = 72644 WHERE rp.league_id = 72644 AND rp.teamId = 20433 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023	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 = 72644 WHERE rp.league_id = 72644 AND rp.teamId = 20433 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032	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 = 20433 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0033	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 = 72644 AND t.round = 26 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* `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 = 68427 AND t.round = 38 ORDER BY team.conference ASC,t.position 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* `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 = 63278 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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 = 57111 AND t.round = 38 ORDER BY team.conference ASC,t.position 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* `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 = 50574 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.0026	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 = 44612 AND t.round = 30 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 = 39608 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030	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 = 33944 AND t.round = 34 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* `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 = 15968 AND t.round = 34 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* `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 = 4411 AND t.round = 30 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* `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 = 24562 AND t.round = 29 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* `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 = 24595 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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 = 24661 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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* `tables1999` 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 = 674 AND t.round = 34 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* `tables1997` 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 = 13985 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

III. Kerületi TVE

III. Kerületi TVE

Selecciona un equipo

Competiciones que juega

Tercera Hungría Grupo 2

RIVALES EN Copa Hungría

RIVALES EN Tercera Hungría