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

« Temporada Anterior

Temporada 2024

2023/2024

Oeste

Eliminatoria

Tercera Eslovaquia 2024 G 1

Ver

TEMPORADA 2023/2024

Equipo		PJ	GF	GC	Puntos
1	Lokomotiva	24	36	25	46
2	Slovan	24	35	24	45
3	Sered	24	45	21	43
4	Hamsik	24	37	19	43
5	Slovan Duslo	24	40	26	42
6	Fomat Martin	24	40	34	40
7	Beluša	24	37	32	38
8	FC Malacky	24	32	27	33
9	Baník	24	33	30	33
10	FK Rača	24	30	26	32
11	Podkonice	24	39	47	29
12	Častkovce	24	32	39	26
13	Bánová	24	28	34	24
14	Veľké	24	28	33	23
15	Nove Mesto.	24	25	56	16
16	Dubnica	24	24	68	4

Ver

TEMPORADA 2022/2023

Equipo		PJ	GF	GC	Puntos
1	Spišská	30	68	21	71
2	Odeva Lipany	30	69	28	69
3	Vranov	30	58	25	62
4	Snina	30	54	42	47
5	Sobota	30	58	58	47
6	Oravské	30	48	38	45
7	Slávia	30	52	44	44
8	Bardejov	30	46	44	41
9	Tesla	30	45	55	36
10	Svidník	30	33	48	33
11	Filakovo	30	38	55	31
12	Novohrad	30	23	34	30
13	Baník	30	38	60	30
14	Poprad	30	33	50	28
15	Slovan	30	19	53	27
16	Námestovo	30	26	53	26

Ver

TEMPORADA 2021/2022

Equipo		PJ	GF	GC	Puntos
1	Dolný	30	81	31	68
2	Rakytovce	30	60	25	62
3	Fomat Martin	30	58	30	62
4	Oravské	30	55	27	56
5	Bánová	30	45	20	54
6	Novohrad	30	44	35	52
7	Filakovo	30	43	37	48
8	Podkonice	30	60	38	46
9	Baník	30	39	47	40
10	Sobota	30	32	58	35
11	Tatran	30	43	49	34
12	Kováčová	30	34	51	33
13	Liptovský	30	41	67	32
14	Žarnovica	30	39	73	24
15	Liptovská	30	28	65	21
16	Čadca	30	31	80	13

Ver

TEMPORADA 2020/2021

Equipo		PJ	GF	GC	Puntos
1	Námestovo	15	38	10	38
2	Rakytovce	15	31	13	35
3	Oravské	15	28	10	33
4	Sobota	15	32	22	28
5	Bánová	15	37	17	26
6	Fomat Martin	15	28	18	26
7	Tatran	15	30	29	24
8	Kováčová	15	23	12	23
9	Baník	15	19	19	19
10	Liptovská	15	28	42	19
11	Filakovo	15	19	14	18
12	Novohrad	15	25	42	16
13	Liptovský	15	20	28	14
14	Žarnovica	15	15	41	11
15	Čadca	15	12	35	9
16	Lokomotiva	15	10	43	4

Ver

TEMPORADA 2019/2020

Equipo		PJ	GF	GC	Puntos
1	Fomat Martin	14	49	6	38
2	Oravské	14	20	9	26
3	Bánová	14	23	16	26
4	Lokomotiva	14	19	14	25
5	Baník	14	17	15	25
6	Kováčová	14	28	14	23
7	Filakovo	14	20	14	20
8	Námestovo	14	19	17	20
9	Novohrad	14	17	20	20
10	Liptovský	14	16	19	18
11	Tatran	14	14	19	16
12	Sobota	14	18	28	15
13	Liptovská	14	20	28	14
14	Žarnovica	14	13	35	10
15	Čadca	14	7	30	9
16	Rakytovce	14	11	27	8

Ver

TEMPORADA 2018/2019

Equipo		PJ	GF	GC	Puntos
1	Ružomberok	30	78	23	68
2	Sobota	30	54	26	60
3	Námestovo	30	51	28	53
4	Lokomotiva	30	37	23	53
5	Filakovo	30	45	41	50
6	Fomat Martin	30	59	40	48
7	Liptovský	30	48	38	48
8	Oravské	30	47	37	47
9	Žarnovica	30	45	39	45
10	Baník	30	38	50	41
11	Novohrad	30	27	43	36
12	Tatran	30	30	46	31
13	Podbrezová	30	40	48	29
14	Poltár	30	40	80	22
15	Liptovská	30	37	77	22
16	Čadca	30	31	68	19

Ver

TEMPORADA 2017/2018

Equipo		PJ	GF	GC	Puntos
1	Petržalka	30	101	18	79
2	Rohoznik	30	103	18	74
3	Dunajská	30	78	24	69
4	Slovan	30	109	29	61
5	FK Rača	30	59	33	57
6	Slovan Most	30	58	34	57
7	Tomášov	30	46	62	41
8	Báhoň	30	50	55	37
9	Slovan	30	43	61	33
10	Bernolákovo	30	40	74	33
11	Rovinka	30	41	67	30
12	Lokomotiva	30	40	53	29
13	Pezinok	30	33	50	29
14	Vajnory	30	40	111	26
15	Lozorno	30	34	75	23
16	Svätý Jur	30	27	138	7

Ver

TEMPORADA 2016/2017

Equipo		PJ	GF	GC	Puntos
1	Liptovský	29	87	18	74
2	Kremnička	29	48	29	50
3	Baník	29	48	37	50
4	Podbrezová	29	61	48	49
5	Žarnovica	29	53	44	48
6	Námestovo	29	43	30	47
7	Novohrad	29	44	48	42
8	Čadca	29	41	50	40
9	Teplička	29	49	49	37
10	Tatran	29	40	41	36
11	Filakovo	29	40	50	33
12	Liptovská	29	43	63	32
13	Nová Bana	29	36	61	30
14	TJ Stráža	15	21	12	29
15	MFK Detva	29	35	72	21
16	Javorník	29	35	72	20

Ver

TEMPORADA 2015/2016

Equipo		PJ	GF	GC	Puntos
1	Svätý Jur	30	89	34	66
2	Inter	31	71	21	63
3	Rohoznik	30	65	32	60
4	FK Rača	30	54	26	51
5	Báhoň	30	46	37	51
6	Rovinka	31	46	38	49
7	Tomášov	30	56	52	47
8	Pezinok	30	47	46	43
9	Slovan Most	30	43	41	40
10	Slovan	30	40	47	37
11	Lokomotiva	30	43	42	36
12	Kráľová	31	38	56	30
13	Bernolákovo	30	33	62	29
14	Lozorno	31	37	72	29
15	Viničné	30	36	87	23
16	Slovenský	30	28	79	18

Ver

TEMPORADA 2014/2015

Equipo		PJ	GF	GC	Puntos
1	Spišská	30	65	30	56
2	Haniska	30	63	35	55
3	Odeva Lipany	30	37	30	52
4	Tatran	30	47	27	50
5	Vranov	30	43	30	50
6	Vyšné	30	52	44	47
7	Snina	30	39	34	47
8	Veľké	30	40	49	43
9	Slovan	30	31	42	43
10	Tesla	30	47	38	42
11	Družstevní	30	35	39	39
12	Milénium	30	37	52	39
13	Slovan	30	42	38	37
14	Futura	30	31	60	36
15	Starý	30	43	45	33
16	Zemplin	30	26	85	13

Ver

TEMPORADA 2013/2014

Equipo		PJ	GF	GC	Puntos
1	Baník	30	71	38	62
2	Žilina II	30	60	35	60
3	Dolný	30	46	30	54
4	Poprad	30	46	31	49
5	Bodva	30	51	36	47
6	Fomat Martin	30	43	32	45
7	Košice II	30	51	38	44
8	Lokomotíva	30	36	33	43
9	Slavoj	30	38	49	43
10	Futura	30	37	54	42
11	Tatran	30	32	31	39
12	Námestovo	30	34	34	35
13	Kremnička	30	26	40	30
14	Odeva Lipany	30	32	55	29
15	Vranov	30	30	58	27
16	Milénium	30	27	66	21

Ver

TEMPORADA 2012/2013

Equipo		PJ	GF	GC	Puntos
1	Pohronie	30	50	24	60
2	Poprad	30	40	30	51
3	Lokomotíva	30	37	30	47
4	Slavoj	30	52	46	45
5	Odeva Lipany	30	38	32	44
6	Námestovo	30	42	34	43
7	Bodva	30	29	30	43
8	Dukla II	30	30	28	42
9	Košice II	30	47	51	42
10	Vranov	30	41	36	41
11	Kremnička	30	42	46	40
12	Futura	30	42	40	39
13	Fomat Martin	30	40	51	38
14	Tatran	30	38	50	36
15	Spišská	30	37	47	32
16	LAFC	30	25	55	28

Ver

TEMPORADA 2011/2012

Equipo		PJ	GF	GC	Puntos
1	Bardejov	30	56	27	67
2	Baník	30	85	34	62
3	Lokomotíva	30	65	23	62
4	Tatran	30	58	42	50
5	Dukla II	30	57	38	49
6	Sokol Dolna	30	46	37	49
7	Vranov	30	39	45	44
8	Spišská	30	44	32	43
9	Odeva Lipany	30	51	45	43
10	Košice II	31	53	54	42
11	Poprad	30	36	32	41
12	Námestovo	31	34	49	38
13	Bodva	30	45	61	37
14	Slavoj	30	41	54	34
15	Kremnička	30	37	51	30
16	Lokomotiva	30	31	59	29
17	Stará	30	12	107	2

Ver

TEMPORADA 2010/2011

Equipo		PJ	GF	GC	Puntos
1	Podbrezová	30	49	15	64
2	Bardejov	30	50	27	62
3	Baník	30	62	43	53
4	Spišská	30	50	38	53
5	Poprad	30	40	38	44
6	Žilina II	30	41	41	44
7	Sokol Dolna	30	46	39	43
8	Tatran	30	49	44	43
9	Odeva Lipany	30	33	25	42
10	Dukla II	30	41	36	40
11	Vranov	30	43	46	36
12	Košice II	30	38	47	36
13	Lokomotiva	30	29	41	33
14	Slavoj	30	26	41	32
15	Stará	30	20	60	29
16	Futura	30	21	57	22

Ver

TEMPORADA 2009/2010

Equipo		PJ	GF	GC	Puntos
1	Bodva	30	63	22	64
2	Vranov	30	56	27	58
3	Podbrezová	30	50	21	52
4	Odeva Lipany	30	43	25	51
5	Tatran	30	48	40	51
6	Slavoj	30	39	37	47
7	Poprad	30	39	43	45
8	Dukla II	30	40	46	44
9	Spišská	30	39	43	40
10	Žilina II	30	40	44	36
11	Lokomotiva	30	35	38	35
12	Futura	30	24	38	34
13	Košice II	30	40	53	30
14	Stará	30	30	53	25
15	Banská	30	31	58	24
16	Čadca	30	25	54	22

Ver

TEMPORADA 2008/2009

Equipo		PJ	GF	GC	Puntos

Equipos de esta liga

USO DE MEMORIA

6,707,224 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.1063
Total Execution Time	0.1082

CADENA URL

/tercera_eslovaquia2024/grupo1/historico

GET DATOS

$_GET['/tercera_eslovaquia2024/grupo1/historico']

POST DATOS

No hay datos POST existentes

CONSULTAS (31)

0.0018	SELECT type FROM routes WHERE alias = 'tercera_eslovaquia2024'
0.0039	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera_eslovaquia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1607 AND type_rel = 3
0.0021	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1607 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022	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 (16697,1411) ORDER BY n.cover_points DESC, update_date DESC
0.0017	SELECT id,name,alias,stepParent FROM categories WHERE parentId=1607 ORDER BY order_id ASC
0.0022	SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1607 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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* `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 = 72793 AND t.round = 24 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 = 68510 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.0028	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 = 63444 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.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* `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 = 57027 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.0020	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 = 50483 AND t.round = 14 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* `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 = 44371 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 = 39125 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* `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 = 33423 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* `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 = 15810 AND t.round = 30 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 = 9374 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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 = 24443 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* `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 = 24452 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 = 24459 AND t.round = 32 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* `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 = 24474 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 = 24479 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019	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 = 24486 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-29 13:28:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-29 13:28:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-29 13:28:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-29 13:28:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020	SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 72793 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72793 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019	SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 72793 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72793 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019	SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 72793 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72793 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0044	SELECT ,(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 = 72793 AND t.round = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC