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 2020

Temporada Siguiente »

2019/2020

Tercera Grecia 2020 G 2

Ver

TEMPORADA 2019/2020

Equipo		PJ	GF	GC	Puntos
1	Almopos	25	59	10	61
2	Makedonikos	25	33	8	47
3	Poseidon	25	44	26	46
4	Anagennisi	25	34	19	45
5	Thermaikos	25	40	21	43
6	Edessaikos	25	35	15	42
7	Keravnos	24	34	28	39
8	Alexandros	26	25	20	39
9	Agrotikos	23	31	17	37
10	Kallikrateia	24	33	19	35
11	Niki	24	26	19	33
12	Florina	25	27	41	29
13	Astrapi	25	15	58	13
14	Seirína	22	4	70	3
15	Palaiochori	25	3	72	3

Ver

TEMPORADA 2018/2019

Equipo		PJ	GF	GC	Puntos
1	Elpis	26	51	15	57
2	Triglia	26	39	19	55
3	Niki	26	31	11	53
4	Palaiochori	26	45	27	52
5	Edessaikos	26	45	14	45
6	Almopos	26	37	18	42
7	Anagennisi	26	31	25	37
8	Makedonikos	26	32	30	36
9	Agrotikos	26	25	29	34
10	Koufalion	26	20	39	22
11	Olympiakos	26	13	33	22
12	Meliteas	26	28	66	18
13	Ermis	26	21	53	13
14	Langadas	26	14	53	13

Ver

TEMPORADA 2017/2018

Equipo		PJ	GF	GC	Puntos
1	Iraklis	28	63	17	65
2	Palaiochori	28	49	19	61
3	Makedonikos	28	32	22	47
4	Almopos	28	32	22	42
5	Edessaikos	28	30	28	41
6	Agrotikos	28	36	39	40
7	Pierikos	28	25	29	40
8	Langadas	28	46	33	39
9	Kardias	28	38	33	39
10	Naoussa	28	30	29	39
11	Kilkisiakos	28	31	32	37
12	AE Karitsa	28	28	39	28
13	Alexandros	28	22	47	25
14	Philippos	28	17	57	18
15	Kampaniakos	28	22	55	16

Ver

TEMPORADA 2016/2017

Equipo		PJ	GF	GC	Puntos
1	Apollon	30	64	17	73
2	Karaiskakis	30	43	14	66
3	Olympiakos	30	46	16	62
4	Diagoras	30	47	27	61
5	Pydna Kitros	30	42	24	53
6	Niki Volos	30	36	30	50
7	Tilikratis	30	28	28	43
8	Apolloniou	30	29	39	35
9	Thesprotos	30	36	40	34
10	Pierikos	30	21	35	33
11	Rigas	30	36	46	32
12	Amvrakia	30	26	42	30
13	Mavroi Aetoi	30	25	42	30
14	Ethnikos	30	21	37	28
15	Achilleas	30	30	54	26
16	Asteras	30	16	55	14

Ver

TEMPORADA 2015/2016

Equipo		PJ	GF	GC	Puntos
1	Aiginiakos	32	74	20	78
2	Karaiskakis	32	52	24	69
3	Niki Volos	32	47	22	64
4	Pydna Kitros	32	50	22	62
5	Pierikos	32	35	24	54
6	Thesprotos	32	43	29	52
7	Rigas	32	43	28	51
8	Achilleas	32	46	49	48
9	Ethnikos	32	23	25	40
10	Pyrasos	32	32	38	39
11	Oikonomos	32	32	47	39
12	Dotieas	32	24	37	34
13	Tyrnavos	32	25	30	33
14	Acheron	32	21	33	31
15	Opountios	32	23	36	27
16	Farkadona	32	29	64	19
17	Fokikos	32	9	80	5

Ver

TEMPORADA 2014/2015

Equipo		PJ	GF	GC	Puntos
1	Trikala	30	55	15	71
2	Karaiskakis	30	60	14	70
3	Achilleas	30	47	18	59
4	Opountios	30	52	26	53
5	Thesprotos	30	39	28	53
6	Rigas	30	42	19	49
7	Pyrasos	30	40	27	49
8	Oikonomos	30	42	31	46
9	Ethnikos	30	40	31	46
10	AEP Kozani	30	48	40	45
11	Dotieas	30	37	28	42
12	Anagennisi	29	39	30	39
13	Vataniakos	30	25	59	19
14	Makrochori	30	22	73	13
15	Pyrsos	29	10	77	1
16	Lefkadia	30	10	92	0

Ver

TEMPORADA 2013/2014

Equipo		PJ	GF	GC	Puntos
1	AE Larisa	30	87	15	73
2	Oikonomos	30	59	25	61
3	Kampaniakos	30	50	34	55
4	AEP Kozani	30	52	32	54
5	Ethnikos	30	48	24	52
6	Pyrsos	30	42	31	52
7	Thesprotos	30	42	27	51
8	Kastoria	30	48	38	51
9	Doxa	30	40	30	49
10	Odysseas	30	38	42	44
11	Doxa	30	43	40	37
12	Agios Thomas	30	42	51	30
13	Kastor	30	30	45	24
14	Keravnos	30	36	67	23
15	Olympos	30	18	84	17
16	Tilikratis	30	0	90	0

Ver

TEMPORADA 2012/2013

Equipo		PJ	GF	GC	Puntos
1	Fostiras	24	28	13	43
2	Panegialios	24	37	21	42
3	Acharnaikos	24	34	21	41
4	Episkopi	24	36	26	39
5	Asteras	24	32	26	39
6	Chania	24	31	24	38
7	Proodeftiki	24	34	26	36
8	Paniliakos	24	30	24	34
9	Glyfada	24	33	33	34
10	Rouvas	24	27	27	30
11	Korinthos	24	24	28	26
12	Kalamata FC	24	18	23	23
13	Ethnikos	24	0	72	0

Ver

TEMPORADA 2011/2012

Equipo		PJ	GF	GC	Puntos
1	Ethnikos	22	37	17	43
2	Niki Volos	22	31	11	40
3	Oikonomos	22	27	16	39
4	Apollon	22	25	15	38
5	Iraklis	22	31	14	36
6	Tilikratis	22	22	15	35
7	Tyrnavos	22	22	17	35
8	Vataniakos	22	16	26	24
9	Doxa	22	17	26	22
10	Odysseas	22	15	30	20
11	Alexandros	22	21	43	20
12	Aetos Skydra	22	14	48	7

Ver

TEMPORADA 2010/2011

Equipo		PJ	GF	GC	Puntos

Ver

TEMPORADA 2009/2010

Equipo		PJ	GF	GC	Puntos
1	Vyzas Megara	32	47	19	69
2	Athens	32	54	28	69
3	Panachaiki	32	60	31	66
4	Zakynthos	32	53	41	52
5	PAO Rouf	31	30	21	48
6	Olympiakos	32	31	28	48
7	Enosi	32	37	41	46
8	Agia	32	33	29	44
9	Korinthos	32	31	36	44
10	Panegialios	32	31	33	41
11	Keravnos	32	33	37	41
12	Aias	31	37	30	40
13	Platanias	32	32	36	39
14	Atsalenios	32	33	43	37
15	Panargiakos	32	30	39	35
16	Saronikos	32	32	58	27
17	Chaidari	32	23	77	8

Ver

TEMPORADA 2008/2009

Equipo		PJ	GF	GC	Puntos
1	Ilioupoli	34	66	22	81
2	Rodos	34	56	19	77
3	Panachaiki	34	48	19	75
4	Fostiras	34	47	30	62
5	Panargiakos	34	43	39	49
6	Korinthos	34	41	34	48
7	Agia	34	45	42	48
8	Keravnos	34	37	32	47
9	Chaidari	35	33	33	46
10	Vyzas Megara	34	40	33	45
11	Olympiakos	33	40	33	44
12	Aias	34	38	39	44
13	Atsalenios	34	31	30	42
14	AO Koropi	34	23	25	39
15	Agios	34	39	52	39
16	Asteras	34	31	44	36
17	Egaleo	34	31	73	20
18	Aiolikos	34	5	95	0

Ver

TEMPORADA 2007/2008

Equipo		PJ	GF	GC	Puntos
1	Ilioupoli	35	61	30	74
2	Diagoras	35	55	25	73
3	Panaitolikos	34	63	27	65
4	Korinthos	35	40	35	54
5	Rodos	35	33	25	52
6	Aias	35	45	45	52
7	Aiolikos	35	40	42	49
8	Panachaiki	34	41	32	48
9	Vyzas Megara	35	38	43	48
10	Asteras	35	41	42	47
11	Fostiras	35	44	40	45
12	Thyella	35	26	39	44
13	Atsalenios	35	33	47	44
14	AO Koropi	35	25	37	42
15	Messiniakos	35	30	37	40
16	Aharnaikos	35	33	43	37
17	Panegialios	35	35	53	35
18	Tiva	35	22	63	15

Ver

TEMPORADA 2006/2007

Equipo		PJ	GF	GC	Puntos
1	Agios	34	56	28	71
2	Rodos	34	51	20	69
3	Atsalenios	34	52	32	62
4	Panaitolikos	34	55	33	58
5	Diagoras	34	49	33	58
6	Ilioupoli	34	47	35	51
7	Thyella	34	42	36	51
8	Vyzas Megara	34	49	44	51
9	AO Koropi	34	43	45	49
10	Panachaiki	33	38	27	48
11	Aharnaikos	34	29	36	42
12	Tiva	34	43	46	40
13	Aiolikos	34	43	51	39
14	Apollon	34	37	52	37
15	Paniliakos	34	39	56	33
16	Ierapetra	33	28	54	29
17	PAO Vardas	34	23	52	28
18	Zakynthos	34	14	58	17

Ver

TEMPORADA 2005/2006

Equipo		PJ	GF	GC	Puntos
1	Asteras	32	56	19	73
2	Ethnikos	32	44	14	66
3	Messiniakos	32	38	22	63
4	Atsalenios	32	51	34	54
5	Chalkida	32	45	31	49
6	Thyella	32	35	33	48
7	Panaitolikos	32	33	27	45
8	Aharnaikos	32	36	38	44
9	Diagoras	32	32	35	41
10	Aiolikos	32	33	34	40
11	Rodos	32	35	35	39
12	Agios	32	27	31	37
13	Vyzas Megara	32	25	33	36
14	Apollon	32	23	43	34
15	Keratsini	32	19	43	26
16	Ionia 2000	32	30	58	25
17	Achaiki	32	22	54	20

Ver

TEMPORADA 2004/2005

Equipo		PJ	GF	GC	Puntos
1	Thrasyvoulos	32	59	23	71
2	Chaidari	32	58	27	67
3	Aharnaikos	32	50	26	63
4	Ethnikos	32	43	24	62
5	Rodos	32	28	25	48
6	Lilas	32	32	36	41
7	Agios	32	42	36	40
8	Keratsini	32	36	37	40
9	Atsalenios	32	28	36	40
10	Achaiki	32	44	54	40
11	Thyella	32	36	38	39
12	Pamisos	32	28	44	37
13	Vyzas Megara	31	29	33	36
14	Pano Mallia	32	30	41	35
15	Irodotos	31	21	37	29
16	Athinaida	32	31	55	27
17	Marko	32	30	53	24

Equipos de esta liga

USO DE MEMORIA

6,718,888 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.1139
Total Execution Time	0.1158

CADENA URL

/3_league_grecia2020/grupo2/historico

GET DATOS

$_GET['/3_league_grecia2020/grupo2/historico']

POST DATOS

No hay datos POST existentes

CONSULTAS (30)

0.0018	SELECT type FROM routes WHERE alias = '3_league_grecia2020'
0.0041	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '3_league_grecia' AND (l.group_code = 2 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=2 DESC LIMIT 1
0.0019	SELECT id,name,alias,stepParent FROM categories WHERE parentId=344 ORDER BY order_id ASC
0.0021	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 = 51442 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023	SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 344 AND group_code = 2 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 = 51442 AND t.round = 27 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 = 45474 AND t.round = 26 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 = 40661 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* `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 = 36066 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* `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 = 15927 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* `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 = 12486 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* `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 = 12263 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* `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 = 2782 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 = 24779 AND t.round = 22 ORDER BY team.conference 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* `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 = 24807 AND t.round = 34 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* `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 = 24844 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* `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 = 24847 AND t.round = 34 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 = 24850 AND t.round = 35 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* `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 = 24852 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* `tables2006` 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 = 24854 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* `tables2005` 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 = 24856 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-04-27 07:56:27' 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-27 07:56:27' 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-27 07:56:27' 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-27 07:56:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '3_league_grecia' 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 = 51442 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51442 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.0021	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 = 51442 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51442 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 events2020 e ON e.player_id = p.id AND e.league_id = 51442 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51442 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0043	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 = 51442 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC