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

2019/2020

Oeste

Eliminatoria

Tercera Serbia 2020 G 4

Ver

TEMPORADA 2019/2020

Equipo		PJ	GF	GC	Puntos
1	Borac	19	50	13	50
2	Sloga	19	32	16	36
3	Budučnost	19	24	12	36
4	Jedinstvo	19	24	17	35
5	Sloga	19	31	26	32
6	Tutin	19	30	20	31
7	Loznica	19	23	21	31
8	Sušica	19	31	29	30
9	Trepča	19	24	19	29
10	Jošanica	18	18	17	27
11	Sloga	19	22	25	22
12	Takovo	19	14	28	19
13	Proleter	19	23	32	18
14	RSK Rabrovo	19	24	36	18
15	Mačva 1929	19	17	24	17
16	Mladi Radnik	19	16	28	17
17	Šumadija	19	17	35	16
18	Mokra Gora	18	10	32	13

Ver

TEMPORADA 2018/2019

Equipo		PJ	GF	GC	Puntos
1	Semendrija	30	46	18	65
2	Sloga	30	42	17	60
3	Jedinstvo	30	46	21	54
4	Tutin	30	43	21	53
5	Jošanica	30	37	33	47
6	Mladi Radnik	30	31	18	43
7	Šumadija	30	33	23	43
8	Budučnost	30	30	24	42
9	Mokra Gora	30	38	33	40
10	Sloga	30	39	37	38
11	Provo	30	30	35	37
12	Loznica	30	31	37	37
13	Drina	30	23	34	30
14	Proleter	30	27	47	30
15	FAP Priboj	30	14	62	20
16	Polet	30	20	70	13

Ver

TEMPORADA 2017/2018

Equipo		PJ	GF	GC	Puntos
1	Zlatibor	34	67	25	80
2	Sloga	34	54	17	80
3	Semendrija	34	61	31	64
4	Šumadija	34	57	29	60
5	Jedinstvo	34	41	25	60
6	Provo	34	44	35	53
7	Budučnost	34	45	38	47
8	Polet	34	36	43	45
9	Mladi Radnik	33	31	36	43
10	Mokra Gora	34	38	42	40
11	Proleter	33	33	38	40
12	Tutin	34	39	47	40
13	FAP Priboj	34	36	48	40
14	Loznica	34	38	45	39
15	Železničar	34	30	44	36
16	Karadjordje	34	27	59	31
17	Šumadija	34	21	45	27
18	Jedinstvo	34	24	75	19

Ver

TEMPORADA 2016/2017

Equipo		PJ	GF	GC	Puntos
1	Radnički	30	43	21	62
2	Budučnost	30	44	24	59
3	Sloga	30	53	34	56
4	Šapine	30	38	29	48
5	Zlatibor	30	30	28	42
6	Šumadija	30	42	41	40
7	Semendrija	30	33	27	39
8	Karadjordje	30	36	38	38
9	Polet	30	31	34	38
10	Jedinstvo	30	34	38	36
11	FAP Priboj	30	27	36	35
12	Loznica	30	35	39	34
13	Mokra Gora	30	25	35	32
14	Mihajlovac	30	33	51	31
15	Železničar	30	33	52	31
16	Jošanica	30	24	34	28

Ver

TEMPORADA 2015/2016

Equipo		PJ	GF	GC	Puntos
1	Mačva	30	48	16	62
2	Budučnost	30	42	20	56
3	Semendrija	30	46	29	55
4	Sloga	30	32	20	47
5	Šumadija	30	48	44	43
6	Mihajlovac	30	39	42	42
7	Karadjordje	30	33	30	41
8	Jedinstvo	30	28	33	41
9	Železničar	30	29	27	40
10	FAP Priboj	30	34	36	39
11	Mokra Gora	30	33	38	37
12	Polet	30	41	37	36
13	Šumadija	30	32	36	36
14	Jedinstvo	30	26	32	36
15	Sloga	30	16	40	27
16	Zvižd	30	21	68	20

Ver

TEMPORADA 2014/2015

Equipo		PJ	GF	GC	Puntos
1	Loznica	30	42	7	66
2	Železničar	30	47	21	62
3	Budučnost	30	50	27	56
4	Jedinstvo	30	32	22	46
5	Sloga	30	39	23	45
6	Šumadija	30	40	36	44
7	Semendrija	30	39	35	44
8	Polet	30	44	28	43
9	Šumadija	30	37	35	39
10	Zvižd	30	28	40	39
11	Karadjordje	30	39	42	38
12	Rudar	30	40	47	37
13	Pobeda	30	29	59	28
14	Jasenica	30	33	54	25
15	Bane Raška	30	20	46	23
16	Jošanica	30	30	67	19

Ver

TEMPORADA 2013/2014

Equipo		PJ	GF	GC	Puntos
1	Mačva	30	59	15	68
2	Polet	30	48	16	63
3	Loznica	30	44	14	63
4	Železničar	30	51	29	55
5	Šapine	30	44	29	49
6	Rudar	30	31	23	49
7	Jošanica	30	40	33	42
8	Pobeda	30	43	35	41
9	Semendrija	30	33	38	37
10	Bane Raška	30	27	39	35
11	Krušik	30	35	38	33
12	Šumadija	30	30	37	33
13	Partizan	30	28	56	26
14	Jasenica	30	26	46	24
15	Mladi Radnik	30	21	62	24
16	Sloboda	30	16	66	18

Ver

TEMPORADA 2012/2013

Equipo		PJ	GF	GC	Puntos
1	Dolina	30	55	28	58
2	Sloga	30	48	25	53
3	Sremska	30	43	28	49
4	Dunav Stari	30	33	38	46
5	Radnički	30	39	39	45
6	Pivara	30	32	24	44
7	Senta	30	36	31	44
8	Radnički	30	32	38	44
9	Tekstilac	30	37	38	43
10	Dinamo	30	36	35	42
11	Mladost	30	29	30	39
12	Palić	30	36	40	39
13	Jedinstvo	30	29	43	35
14	Cement	30	34	52	30
15	Srem Sremska	30	24	40	29
16	FK TSC	30	23	37	27

Ver

TEMPORADA 2011/2012

Equipo		PJ	GF	GC	Puntos
1	Jedinstvo	30	52	25	62
2	Rudar	30	54	23	58
3	Mačva	30	50	24	56
4	Pobeda	30	29	22	48
5	Železničar	30	31	30	47
6	Polet	30	39	24	46
7	Radnički	30	40	32	40
8	Partizan	30	37	32	40
9	Sloboda	30	27	38	40
10	Jasenica	30	32	42	38
11	Sloga	30	32	42	38
12	Šumadija	30	31	39	37
13	Vujić	30	24	26	35
14	Jedinstvo	30	30	50	28
15	Sloga Bajina	30	27	51	22
16	Sloga	30	24	59	21

Ver

TEMPORADA 2010/2011

Equipo		PJ	GF	GC	Puntos
1	Sloga	30	36	20	61
2	Sloga Bajina	30	49	18	57
3	Partizan	30	37	30	48
4	Radnički	30	40	35	46
5	Rudar	30	36	33	45
6	Mačva	30	44	27	42
7	Vujić	30	28	36	42
8	Sloga	30	34	33	41
9	Šumadija	30	37	45	39
10	Železničar	30	33	29	38
11	Jedinstvo	30	34	41	37
12	Sloga	30	31	43	37
13	Polet	30	30	48	37
14	Sloboda	30	31	34	36
15	FAP Priboj	30	25	39	33
16	Budućnost	30	21	35	27

Ver

TEMPORADA 2009/2010

Equipo		PJ	GF	GC	Puntos
1	Radnički	30	56	19	69
2	Mačva	30	50	9	67
3	Sloboda	30	43	26	52
4	Sloga	30	50	42	43
5	Rudar	30	29	29	43
6	Vujić	30	35	40	43
7	Železničar	30	30	27	41
8	Sloboda	30	33	40	40
9	Sloga	30	34	42	39
10	Jedinstvo	30	25	35	39
11	Šumadija	30	36	33	38
12	FAP Priboj	30	23	31	37
13	Radnički	30	28	43	37
14	Budućnost	30	31	44	36
15	Metalac	30	19	35	28
16	Morava	30	25	52	21

Ver

TEMPORADA 2008/2009

Equipo		PJ	GF	GC	Puntos
1	Sloga	30	43	17	62
2	Radnički	30	38	28	53
3	Sloboda	30	35	34	46
4	Jedinstvo	30	27	29	42
5	Radnički	30	38	28	41
6	Sloga	30	34	35	41
7	Čačak	30	29	34	41
8	Vujić	30	27	34	41
9	Mačva	30	30	28	40
10	Metalac	30	29	31	40
11	Sloga	30	33	41	40
12	Budućnost	30	35	37	39
13	FAP Priboj	30	34	46	39
14	Pozarevac	30	40	34	38
15	Železničar	30	38	35	38
16	Loznica	30	20	39	28

Ver

TEMPORADA 2007/2008

Equipo		PJ	GF	GC	Puntos
1	Mladi Radnik	30	63	17	77
2	Sloga	29	48	30	54
3	Mačva	30	30	27	43
4	Radnički	30	27	24	43
5	Pozarevac	29	38	28	42
6	Sloga	30	29	32	42
7	Metalac	30	34	32	39
8	Jedinstvo	30	29	35	39
9	Vujić	30	37	40	38
10	Budućnost	30	23	38	38
11	Čačak	30	32	40	37
12	Železničar	30	25	38	34
13	Morava	29	39	40	33
14	Sloga Bajina	30	25	36	33
15	Sloboda	29	25	30	32
16	Šumadija	30	29	46	30

Ver

TEMPORADA 2006/2007

Equipo		PJ	GF	GC	Puntos
1	Jagodina	34	78	28	70
2	Železničar	33	56	30	62
3	Sloga	34	50	38	59
4	Trajal	33	53	29	56
5	Sinđelić	34	62	40	55
6	Svrljig	34	51	41	52
7	Kopaonik	34	35	44	52
8	Dubočica	34	55	51	51
9	Timok	34	52	32	50
10	Morava	34	38	43	50
11	OFK Nis	34	55	52	49
12	Rudar Alpos	34	50	47	48
13	Jedinstvo	34	43	57	43
14	Bor	34	41	42	42
15	Toplicanin	34	49	60	42
16	Konstantin	34	50	66	34
17	Djerdap	34	40	76	24
18	Kosanica	34	20	102	11

Equipos de esta liga

USO DE MEMORIA

6,702,200 bytes

BENCHMARKS

Loading Time Base Classes	0.0018
Controller Execution Time ( Home / Category )	0.1071
Total Execution Time	0.1090

CADENA URL

/srpska_liga_serbia2020/grupo4/historico

GET DATOS

$_GET['/srpska_liga_serbia2020/grupo4/historico']

POST DATOS

No hay datos POST existentes

CONSULTAS (31)

0.0018	SELECT type FROM routes WHERE alias = 'srpska_liga_serbia2020'
0.0040	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'srpska_liga_serbia' AND (l.group_code = 4 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=4 DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1526 AND type_rel = 3
0.0019	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1526 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0019	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 (1029868) ORDER BY n.cover_points DESC, update_date DESC
0.0018	SELECT id,name,alias,stepParent FROM categories WHERE parentId=1526 ORDER BY order_id ASC
0.0020	SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 51080 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020	SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1526 AND group_code = 4 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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* `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 = 51080 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.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* `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 = 44709 AND t.round = 30 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* `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 = 39261 AND t.round = 34 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* `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 = 34069 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* `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 = 15800 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* `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 = 9196 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* `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 = 25178 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* `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 = 25185 AND t.round = 30 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 = 25197 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* `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 = 25208 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* `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 = 25219 AND t.round = 30 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* `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 = 25233 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* `tables2008` 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 = 28191 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* `tables2007` 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 = 28199 AND t.round = 34 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-05-07 23:39:31' 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-05-07 23:39:31' 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-05-07 23:39:31' 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-05-07 23:39:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'srpska_liga_serbia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
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 events2020 e ON e.player_id = p.id AND e.league_id = 51080 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51080 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 events2020 e ON e.player_id = p.id AND e.league_id = 51080 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51080 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
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 events2020 e ON e.player_id = p.id AND e.league_id = 51080 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51080 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0045	SELECT ,(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 = 51080 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