Histórico Kelen - Tercera Hungría G 2

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.

TERCERA HUNGRÍA GRUPO 2
1	Tatabánya	27	55	26	59
2	Veszprém	27	57	32	56
3	Bicskei	27	45	25	56
4	III.	27	51	27	54
5	Gyirmót II	27	52	50	41
6	Dorogi FC	27	39	33	40
7	Komaromi	27	34	31	39
8	Budaörsi	27	45	51	38
9	Sopron	27	36	35	34
10	Puskás	27	41	35	33
11	Balatonfüre	27	32	40	32
12	Kelen	27	32	51	32
13	Győri	27	41	41	31
14	Haladas	27	35	58	22
15	Zalaegerszeg	27	27	52	20
16	Csornai SE	27	28	63	12

TERCERA HUNGRÍA GRUPO 1
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

TERCERA HUNGRÍA GRUPO 3
1	Mosonmagyar�	38	114	20	100
2	Budapest	38	93	32	88
3	Veszprém	38	69	29	80
4	Győri	38	68	45	67
5	Puskás	38	65	39	66
6	Bicskei	38	50	44	62
7	Pápai	38	49	41	59
8	Tatabánya	38	52	43	57
9	Kaposvari	38	50	46	53
10	Nagykanizsai	38	60	67	53
11	Fehérvár	38	47	54	52
12	Zalaegerszeg	38	59	63	48
13	Balatonfüre	38	54	67	47
14	Erdi VSE	38	56	69	46
15	Kelen	38	43	52	42
16	Gyirmót II	38	61	71	40
17	Komaromi	38	55	73	35
18	Sopron	38	37	81	28
19	Gárdony	38	35	72	22
20	Andráshida	38	26	135	11

TERCERA HUNGRÍA GRUPO 2
1	Pécsi MFC	19	65	9	48
2	Szentlőrinc	19	30	10	44
3	Monori SE	19	32	14	38
4	Iváncsa	19	31	18	35
5	Kozarmisleny	19	31	25	31
6	Dunaújváro	19	27	26	31
7	Rákosmenti	19	29	30	25
8	Dabas-Gyón	19	20	28	25
9	Budapest	19	33	28	24
10	Dabas	19	13	19	23
11	Kecskemét	19	25	26	21
12	Szekszárdi	19	22	34	19
13	Taksony	19	17	30	18
14	Szabadkikoto	19	20	54	15
15	Dunaharaszti	19	12	37	11
16	Kelen	19	20	39	10

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

	Ascenso : Tatabánya

USO DE MEMORIA

5,442,880 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.5832
Total Execution Time	0.5845

CADENA URL

/historico/Kelen-Sc

GET DATOS

$_GET['/historico/Kelen-Sc']

POST DATOS

No hay datos POST existentes

CONSULTAS (31)

0.0153	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 = 'Kelen-Sc' 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=121561 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=121561 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=121561 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=121561 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0295	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 = 73256
0.0144	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=121561 AND type_rel = 2
0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=583 AND type_rel = 3
0.0145	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 583 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0145	SELECT /53 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 (100827) ORDER BY n.cover_points DESC, update_date DESC
0.0148	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 = '121561' ORDER BY l.year DESC,cat.coefficient DESC
0.0147	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 = '121561' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0146	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 = '121561' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0152	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.0146	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.0148	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=121561 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145	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.0147	SELECT count(id) as num_players from rel_players WHERE league_id = 72644 AND teamId = 121561
0.0149	SELECT count(id) as num_players from rel_players WHERE league_id = 73256 AND teamId = 121561
0.0145	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 121561
0.0149	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 = 72644 AND t.round = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0145	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 = '121561' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0147	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '121561' 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 = '121561' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0154	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 = 121561 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.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 = 72644 WHERE rp.league_id = 72644 AND rp.teamId = 121561 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154	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 = 121561 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0152	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 = 121561 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0165	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.0167	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 = 63556 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.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* `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 = 50573 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

Kelen

Kelen

Selecciona un equipo

Competiciones que juega

Tercera Hungría Grupo 2

RIVALES EN Copa Hungría

RIVALES EN Tercera Hungría

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