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

Monori SE

Temporada 2023/2024

TEMPORADA 2023/2024

TERCERA HUNGRÍA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Békéscsaba	25	75	18	68
2	ESMTK	25	66	23	58
3	Hódmezővá	25	38	20	50
4	Körösladá	25	55	34	48
5	Szolnoki	25	49	32	45
6	Budapesti	26	48	31	41
7	BKV Előre	25	33	42	39
8	Monori SE	25	42	46	35
9	Dabas	25	31	49	29
10	Budapest	26	39	51	27
11	Penzugyor	25	30	37	26
12	Martfui LSE	25	39	54	25
13	Kecskemeti	25	33	35	24
14	Szeged II	25	30	37	21
15	Füzesgyarma	25	28	73	18
16	Cegledi	25	21	75	10

TEMPORADA 2022/2023

TERCERA HUNGRÍA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Iváncsa	35	88	34	86
2	Hódmezővá	34	68	33	74
3	ESMTK	34	57	27	65
4	Budapest	34	73	40	59
5	Budapest	34	51	46	58
6	Ferencváros	34	60	43	56
7	PTE-PEAC	35	48	34	56
8	Újpest	36	48	57	56
9	Dunaújváro	34	67	49	51
10	Monori SE	34	58	54	45
11	Paksi SE II	34	55	58	43
12	Szolnoki	35	51	58	41
13	Szekszárdi	34	35	48	40
14	Majosi SE	34	37	50	39
15	Kecskemeti	34	44	67	35
16	Dabas	34	29	67	30
17	Cegledi	34	40	81	27
18	Bánk	34	30	90	16
19	Makó FC	4	6	8	6
20	Balassagyarm	1	1	2	0

TEMPORADA 2021/2022

TERCERA HUNGRÍA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Kozarmisleny	38	80	23	92
2	Balassagyarm	38	69	35	81
3	Dunaújváro	38	76	37	78
4	Budapest	38	68	53	70
5	Makó FC	38	60	33	69
6	Paksi SE II	38	66	46	64
7	Iváncsa	38	74	45	62
8	Monori SE	38	59	43	61
9	Ferencváros	38	58	50	59
10	Budapest	38	49	52	52
11	Hódmezővá	38	55	62	52
12	Dabas	38	63	56	50
13	ESMTK	38	52	47	47
14	Szekszárdi	38	48	50	46
15	Cegledi	38	41	68	41
16	Samsung Vác	38	44	68	39
17	Build	38	37	76	30
18	Dabas-Gyón	38	30	72	30
19	Rákosmenti	38	40	87	23
20	Gerjeni SK	38	25	91	19

TEMPORADA 2020/2021

TERCERA HUNGRÍA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Iváncsa	38	78	27	86
2	Kecskemét	38	90	32	80
3	Dabas	38	66	29	74
4	Budapest	38	83	50	72
5	Ferencváros	38	75	36	70
6	Kozarmisleny	38	70	57	57
7	ESMTK	38	56	50	57
8	Monori SE	38	64	54	56
9	Dabas-Gyón	38	48	45	55
10	Paksi SE II	38	60	56	52
11	Újpest	38	58	50	51
12	Rákosmenti	38	40	48	48
13	Samsung Vác	38	53	54	47
14	Dunaújváro	38	52	56	47
15	Szekszárdi	38	41	53	47
16	Hódmezővá	38	48	72	46
17	Körösladá	38	59	71	40
18	Taksony	38	49	95	32
19	Szegedi VSE	38	30	94	24
20	Majosi SE	38	27	118	14

TEMPORADA 2019/2020

TERCERA HUNGRÍA GRUPO 2
Equipo		PJ	GF	GC	Puntos
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

TEMPORADA 2018/2019

SEGUNDA HUNGRÍA
Equipo		PJ	GF	GC	Puntos
1	Zalaegerszeg	38	77	41	82
2	Kaposvari	38	62	41	74
3	Gyirmot	38	75	50	65
4	Budapesti	38	73	64	65
5	Budaörsi	38	65	46	64
6	Békéscsaba	38	56	49	60
7	Soroksár	38	68	61	59
8	Györi ETO	38	60	46	58
9	Kazincbarcik	38	59	50	56
10	Nyíregyház	38	53	49	56
11	Csákvári	38	57	59	52
12	BFC Siófok	38	49	53	47
13	Samsung Vác	38	44	51	46
14	Dorogi FC	38	54	59	43
15	Tiszakécske	38	34	52	43
16	Budafoki	38	46	66	41
17	Balmazujvaro	38	33	48	40
18	Cegledi	38	35	68	32
19	Mosonmagyar�	38	35	61	31
20	Monori SE	38	49	70	30

TEMPORADA 2017/2018

TERCERA HUNGRÍA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Monori SE	28	77	18	76
2	ESMTK	28	37	24	50
3	Putnok VSE	28	46	40	46
4	Tiszaújvár	28	43	40	43
5	Jászberény	28	36	35	38
6	Diósgyőr	28	41	34	38
7	Nyírbátori	28	47	42	37
8	Füzesgyarma	28	38	39	36
9	Gyöngyös	28	41	45	36
10	Cigánd SE	28	41	51	35
11	Budapest	28	45	40	34
12	Debreceni	28	42	57	34
13	Tallya KSE	28	32	49	29
14	Balassagyarm	28	33	59	25
15	Tiszafuredi	28	32	58	24
16	Salgótarjá	0	0	0	0

TEMPORADA 2016/2017

TERCERA HUNGRÍA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Kazincbarcik	34	88	33	79
2	Monori SE	34	53	34	66
3	Jászberény	34	63	33	65
4	Budapest	34	64	37	56
5	Diósgyőr	34	53	49	50
6	Putnok VSE	34	46	49	49
7	Tallya KSE	34	53	58	49
8	Rákosmenti	34	69	54	48
9	Salgótarjá	34	56	45	48
10	ESMTK	34	41	45	47
11	Nyírbátori	34	51	42	46
12	BKV Előre	34	57	58	45
13	Tiszaújvár	34	38	40	45
14	Debreceni	34	49	50	42
15	FC Hatvan	34	48	50	40
16	REAC	34	42	55	40
17	Hajdúbösz�	34	33	72	29
18	Újpest	34	24	124	6

TEMPORADA 2015/2016

TERCERA HUNGRÍA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Kozarmisleny	32	81	15	81
2	Szeol	32	54	25	63
3	Dabas	32	52	34	51
4	Újbuda TC	32	47	34	50
5	Komlói	32	33	34	49
6	Penzugyor	32	36	30	46
7	Dunaharaszti	32	38	42	45
8	Szentlőrinc	32	40	44	44
9	Paksi SE II	32	53	54	42
10	Budapest	32	50	46	40
11	ESMTK	32	32	40	39
12	Monori SE	32	34	43	39
13	Gyulai	32	40	56	36
14	Bekescsaba	32	37	50	35
15	Hódmezővá	32	31	45	33
16	Szekszárdi	32	26	55	30
17	Bölcskei	32	32	69	29

TEMPORADA 2014/2015

TERCERA HUNGRÍA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Samsung Vác	28	64	27	57
2	Kozarmisleny	28	67	23	55
3	REAC	28	51	39	48
4	Szeol	28	41	30	46
5	Monori SE	28	47	40	45
6	Videoton II	28	48	34	44
7	Dunaharaszti	28	38	31	42
8	ESMTK	28	37	30	42
9	Dabas	28	47	41	42
10	Bölcskei	28	53	44	39
11	Szekszárdi	28	40	40	39
12	Gyulai	28	39	49	38
13	Szentlőrinc	28	33	48	30
14	Orosháza	28	22	49	26
15	Bajai	28	20	76	19
16	Maglódi TC	28	19	65	11

TEMPORADA 2013/2014

TERCERA HUNGRÍA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Soroksár	28	73	16	69
2	Szeged 2011	28	68	29	63
3	Budapest	28	70	40	56
4	Rákosmenti	28	59	34	51
5	Videoton II	28	46	29	50
6	Dunaharaszti	28	38	36	44
7	Gyulai	28	38	34	39
8	Orosháza	28	40	48	34
9	Szekszárdi	28	36	48	32
10	Bajai	28	27	47	30
11	Bölcskei	28	39	49	30
12	Monori SE	28	41	55	27
13	Dabas	28	37	60	26
14	ESMTK	28	37	53	26
15	Maglódi TC	28	37	60	25
16	Komlói	28	12	60	12

TEMPORADA 2012/2013

TERCERA HUNGRÍA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Soroksár	26	44	20	52
2	Monori SE	26	52	31	50
3	Gyulai	26	53	23	48
4	Dunaharaszti	26	41	27	48
5	Tököl	26	39	28	45
6	Dabas	26	49	38	40
7	Mórahalom	26	45	38	38
8	Nagykorosi	26	40	47	32
9	Vecsés FC	26	45	54	32
10	Szeol	26	31	34	30
11	Kecskemeti	26	35	46	28
12	Üllő SE	26	35	58	27
13	Makó FC	26	30	50	22
14	Hódmezővá	26	16	61	13

TEMPORADA 2011/2012

TERCERA HUNGRÍA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Dabas	30	64	22	64
2	Dunaharaszti	30	58	19	64
3	Gyulai	30	51	25	53
4	Szeol	30	72	38	51
5	Kecskemeti	30	53	34	51
6	Tápiószecs	30	58	47	47
7	Tököl	30	55	38	45
8	Csepel FC	30	39	27	43
9	Monori SE	30	44	50	39
10	Üllő SE	30	45	54	37
11	Hódmezővá	30	35	43	35
12	Makó FC	30	40	44	34
13	Szolnoki	30	29	48	33
14	Pilisi LK	30	18	58	30
15	Szarvasi FC	30	38	61	25
16	Jánoshidai	30	24	115	17

TEMPORADA 2010/2011

TERCERA HUNGRÍA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Eger	30	85	32	76
2	Balmazujvaro	30	74	29	61
3	Budapesti	30	66	37	58
4	Tiszaújvár	30	64	35	58
5	Putnok VSE	30	52	37	53
6	Rákosmenti	30	38	38	42
7	Salgótarjá	30	43	39	40
8	Gyöngyös	30	42	44	38
9	Tura VSK	30	45	52	38
10	Monori SE	30	39	44	36
11	Hevesi	30	46	60	34
12	Felsőtárk�	30	38	50	32
13	Ózdi FC	30	45	70	30
14	Dunakeszi	30	40	69	29
15	Balassagyarm	30	20	55	24
16	RAFC	30	30	76	20

TEMPORADA 2009/2010

TERCERA HUNGRÍA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Orosháza	24	61	32	47
2	Szolnoki	24	36	29	46
3	ESMTK	24	41	31	40
4	Szeol	24	34	28	39
5	Kecskemeti	24	47	39	38
6	Budapesti	24	35	33	36
7	Hódmezővá	24	27	37	31
8	Monori SE	24	33	31	30
9	Soroksár	24	30	29	30
10	Százhalomba	24	33	42	29
11	Dabas	24	26	42	28
12	Gyulai	24	31	36	26
13	Battonyai	24	29	54	19

TEMPORADA 2008/2009

TERCERA HUNGRÍA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Budapest	30	73	29	63
2	Szolnoki	30	60	30	62
3	Kecskemeti	30	76	36	59
4	Algyo SK	30	73	34	59
5	Budafoki LC	30	46	30	54
6	Hódmezővá	30	51	39	50
7	Orosháza	30	59	47	48
8	Erdi VSE	30	39	33	46
9	Gyulai	30	55	54	39
10	Dabas	30	53	60	39
11	Szeol	30	44	50	37
12	Monori SE	30	40	64	34
13	Újbuda TC	30	51	78	31
14	Izsaki	30	35	62	29
15	Kiskunfelegy	30	27	68	22
16	Jászapáti	30	17	85	14

TEMPORADA 2002/2003

SEGUNDA HUNGRÍA
Equipo		PJ	GF	GC	Puntos
1	Pécsi MFC	34	71	34	73
2	Szombathelyi	34	55	28	62
3	Buki TK	34	55	22	60
4	REAC II	34	60	44	60
5	Nyíregyház	34	63	44	55
6	Százhalomba	34	53	48	53
7	Kaposvari	34	52	39	51
8	Lombard	34	52	45	50
9	Kecskemét	34	57	42	48
10	Szolnoki	34	57	58	48
11	DVTK Borsodi	34	45	50	44
12	Foti	34	46	54	44
13	BKV Előre	34	54	56	43
14	Balassagyarm	34	49	57	40
15	Héviz FC	34	50	61	38
16	Tatabánya	34	40	57	33
17	Celldömölk	34	27	60	30
18	Monori SE	34	24	111	8

Competiciones que juega

Grupo 3

Tercera Hungría Grupo 3

Pos	Equipos		Pts
1		Békéscsaba	68
2		ESMTK	58
3		Hódmezővásárhelyi	50
4		Körösladány	48
5		Szolnoki MÁV	45
6		Budapesti Vasas II	41
7		BKV Előre	39
8		Monori SE	35
9		Dabas	29
10		Budapest Honvéd II	27
11		Penzugyor	26
12		Martfui LSE	25
13		Kecskemeti TE II	24
14		Szeged II	21
15		Füzesgyarmati	18
16		Cegledi	10

	Ascenso : Békéscsaba

RIVALES EN Copa Hungría

RIVALES EN Tercera Hungría

USO DE MEMORIA

7,307,296 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.1547
Total Execution Time	0.1560

CADENA URL

/historico/Monori-Se

GET DATOS

$_GET['/historico/Monori-Se']

POST DATOS

No hay datos POST existentes

CONSULTAS (40)

0.0029	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 = 'Monori-Se' 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.0019	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=17466 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=17466 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=17466 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=17466 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17466 AND type_rel = 2
0.0026	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=583 AND type_rel = 3
0.0032	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.0020	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.0027	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 = '17466' 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 = '17466' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 72645 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023	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=17466 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 (73256,72645,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 = 72645 AND teamId = 17466
0.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 73256 AND teamId = 17466
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 17466
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 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 = 72645 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '17466' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0021	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 = '17466' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0024	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 = 72645 WHERE rp.league_id = 72645 AND rp.teamId = 17466 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.0020	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 = 72645 WHERE rp.league_id = 72645 AND rp.teamId = 17466 AND (e.action = 4 or e.action = 5) 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 = 72645 WHERE rp.league_id = 72645 AND rp.teamId = 17466 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 = 17466 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 68429 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* `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 = 63555 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.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* `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 = 57110 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.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* `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
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 = 44343 AND t.round = 38 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 = 39609 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0045	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 = 33938 AND t.round = 34 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* `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 = 15967 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0043	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 = 4410 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* `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 = 3580 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* `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 = 24516 AND t.round = 26 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 = 24615 AND t.round = 30 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* `tables2011` 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 = 24634 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* `tables2010` 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 = 24639 AND t.round = 26 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* `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 = 24666 AND t.round = 30 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* `tables2003` 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 = 27656 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Monori SE

Monori SE

Selecciona un equipo

Competiciones que juega

Tercera Hungría Grupo 3

RIVALES EN Copa Hungría

RIVALES EN Tercera Hungría