4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jornada 1
28 Sep 19 Ionikos NikeaIonikos 0 - 0 TrikalaTrikala ...
29 Sep 19 EgaleoEgaleo 0 - 2 Kalamata FCKalamata ...
29 Sep 19 KavalaKavala 4 - 1 Triglia RafinasTriglia ...
29 Sep 19 IalysosIalysos 0 - 0 OF IerapetraIerapetra ...
29 Sep 19 Enosis AspropyrgosEnosis 2 - 2 Olympiakos VolosOlympiakos ...
29 Sep 19 Niki VolosNiki Volos 2 - 1 ThesprotosThesprotos ...
29 Sep 19 Veria NPSVeria NPS 0 - 0 DiagorasDiagoras ...
Jornada 2
05 Oct 19 KavalaKavala 0 - 0 EgaleoEgaleo ...
06 Oct 19 Kalamata FCKalamata 2 - 0 IalysosIalysos ...
06 Oct 19 Triglia RafinasTriglia 2 - 0 Enosis AspropyrgosEnosis ...
06 Oct 19 OF IerapetraIerapetra 2 - 1 Niki VolosNiki Volos ...
06 Oct 19 Olympiakos VolosOlympiakos 0 - 2 Veria NPSVeria NPS ...
06 Oct 19 ThesprotosThesprotos 0 - 2 Ionikos NikeaIonikos ...
06 Oct 19 DiagorasDiagoras 1 - 2 TrikalaTrikala ...
Jornada 3
13 Oct 19 EgaleoEgaleo 1 - 0 IalysosIalysos ...
12 Oct 19 Enosis AspropyrgosEnosis 1 - 0 KavalaKavala ...
13 Oct 19 Niki VolosNiki Volos 1 - 1 Kalamata FCKalamata ...
13 Oct 19 Veria NPSVeria NPS 2 - 1 Triglia RafinasTriglia ...
13 Oct 19 Ionikos NikeaIonikos 0 - 1 OF IerapetraIerapetra ...
13 Oct 19 TrikalaTrikala 1 - 1 Olympiakos VolosOlympiakos ...
13 Oct 19 DiagorasDiagoras 4 - 1 ThesprotosThesprotos ...
Jornada 4
20 Oct 19 Enosis AspropyrgosEnosis 1 - 1 EgaleoEgaleo ...
20 Oct 19 IalysosIalysos 1 - 0 Niki VolosNiki Volos ...
20 Oct 19 KavalaKavala 1 - 0 Veria NPSVeria NPS ...
19 Oct 19 Kalamata FCKalamata 1 - 0 Ionikos NikeaIonikos ...
20 Oct 19 Triglia RafinasTriglia 0 - 1 TrikalaTrikala ...
20 Oct 19 OF IerapetraIerapetra 0 - 0 DiagorasDiagoras ...
19 Oct 19 Olympiakos VolosOlympiakos 1 - 1 ThesprotosThesprotos ...
Jornada 5
27 Oct 19 EgaleoEgaleo 2 - 0 Niki VolosNiki Volos ...
26 Oct 19 Veria NPSVeria NPS 1 - 1 Enosis AspropyrgosEnosis ...
27 Oct 19 Ionikos NikeaIonikos 1 - 0 IalysosIalysos ...
26 Oct 19 TrikalaTrikala 0 - 0 KavalaKavala ...
27 Oct 19 DiagorasDiagoras 2 - 0 Kalamata FCKalamata ...
27 Oct 19 ThesprotosThesprotos 3 - 0 Triglia RafinasTriglia ...
27 Oct 19 Olympiakos VolosOlympiakos 2 - 1 OF IerapetraIerapetra ...
Jornada 6
03 Nov 19 Veria NPSVeria NPS 3 - 1 EgaleoEgaleo ...
02 Nov 19 Niki VolosNiki Volos 1 - 2 Ionikos NikeaIonikos ...
03 Nov 19 Enosis AspropyrgosEnosis 1 - 1 TrikalaTrikala ...
03 Nov 19 IalysosIalysos 1 - 1 DiagorasDiagoras ...
03 Nov 19 KavalaKavala 4 - 1 ThesprotosThesprotos ...
03 Nov 19 Kalamata FCKalamata 1 - 2 Olympiakos VolosOlympiakos ...
03 Nov 19 Triglia RafinasTriglia 0 - 2 OF IerapetraIerapetra ...
Jornada 7
10 Nov 19 EgaleoEgaleo 1 - 2 Ionikos NikeaIonikos ...
09 Nov 19 TrikalaTrikala 2 - 1 Veria NPSVeria NPS ...
10 Nov 19 DiagorasDiagoras 1 - 1 Niki VolosNiki Volos ...
10 Nov 19 ThesprotosThesprotos 1 - 0 Enosis AspropyrgosEnosis ...
10 Nov 19 Olympiakos VolosOlympiakos 2 - 0 IalysosIalysos ...
10 Nov 19 OF IerapetraIerapetra 3 - 2 KavalaKavala ...
10 Nov 19 Triglia RafinasTriglia 1 - 0 Kalamata FCKalamata ...
Jornada 8
17 Nov 19 TrikalaTrikala 2 - 1 EgaleoEgaleo ...
17 Nov 19 Ionikos NikeaIonikos 3 - 2 DiagorasDiagoras ...
17 Nov 19 Veria NPSVeria NPS 1 - 1 ThesprotosThesprotos ...
16 Nov 19 Niki VolosNiki Volos 2 - 0 Olympiakos VolosOlympiakos ...
17 Nov 19 Enosis AspropyrgosEnosis 3 - 0 OF IerapetraIerapetra ...
17 Nov 19 IalysosIalysos 1 - 2 Triglia RafinasTriglia ...
17 Nov 19 KavalaKavala 2 - 1 Kalamata FCKalamata ...
Jornada 9
24 Nov 19 EgaleoEgaleo 0 - 2 DiagorasDiagoras ...
23 Nov 19 ThesprotosThesprotos 1 - 2 TrikalaTrikala ...
24 Nov 19 Olympiakos VolosOlympiakos 1 - 1 Ionikos NikeaIonikos ...
24 Nov 19 OF IerapetraIerapetra 0 - 1 Veria NPSVeria NPS ...
24 Nov 19 Triglia RafinasTriglia 0 - 0 Niki VolosNiki Volos ...
24 Nov 19 Kalamata FCKalamata 2 - 2 Enosis AspropyrgosEnosis ...
24 Nov 19 IalysosIalysos 0 - 0 KavalaKavala ...
Jornada 10
01 Dic 19 ThesprotosThesprotos 0 - 1 EgaleoEgaleo ...
01 Dic 19 DiagorasDiagoras 0 - 0 Olympiakos VolosOlympiakos ...
30 Nov 19 TrikalaTrikala 3 - 0 OF IerapetraIerapetra ...
01 Dic 19 Ionikos NikeaIonikos 2 - 0 Triglia RafinasTriglia ...
30 Nov 19 Veria NPSVeria NPS 2 - 0 Kalamata FCKalamata ...
30 Nov 19 Niki VolosNiki Volos 2 - 0 KavalaKavala ...
30 Nov 19 Enosis AspropyrgosEnosis 1 - 0 IalysosIalysos ...
Jornada 11
08 Dic 19 EgaleoEgaleo 0 - 1 Olympiakos VolosOlympiakos ...
08 Dic 19 OF IerapetraIerapetra 1 - 0 ThesprotosThesprotos ...
08 Dic 19 Triglia RafinasTriglia 1 - 1 DiagorasDiagoras ...
07 Dic 19 Kalamata FCKalamata 0 - 1 TrikalaTrikala ...
08 Dic 19 KavalaKavala 0 - 0 Ionikos NikeaIonikos ...
08 Dic 19 IalysosIalysos 1 - 0 Veria NPSVeria NPS ...
08 Dic 19 Niki VolosNiki Volos 3 - 0 Enosis AspropyrgosEnosis ...
Jornada 12
14 Dic 19 OF IerapetraIerapetra 0 - 0 EgaleoEgaleo ...
15 Dic 19 Olympiakos VolosOlympiakos 3 - 1 Triglia RafinasTriglia ...
15 Dic 19 ThesprotosThesprotos 3 - 1 Kalamata FCKalamata ...
15 Dic 19 DiagorasDiagoras 0 - 0 KavalaKavala ...
15 Dic 19 TrikalaTrikala 3 - 0 IalysosIalysos ...
15 Dic 19 Ionikos NikeaIonikos 2 - 0 Enosis AspropyrgosEnosis ...
15 Dic 19 Veria NPSVeria NPS 3 - 0 Niki VolosNiki Volos ...
Jornada 13
22 Dic 19 EgaleoEgaleo 1 - 1 Triglia RafinasTriglia ...
22 Dic 19 Kalamata FCKalamata 2 - 3 OF IerapetraIerapetra ...
22 Dic 19 KavalaKavala 2 - 0 Olympiakos VolosOlympiakos ...
22 Dic 19 IalysosIalysos 1 - 0 ThesprotosThesprotos ...
22 Dic 19 Enosis AspropyrgosEnosis 0 - 3 DiagorasDiagoras ...
21 Dic 19 Niki VolosNiki Volos 2 - 0 TrikalaTrikala ...
22 Dic 19 Ionikos NikeaIonikos 0 - 0 Veria NPSVeria NPS ...
Jornada 14
04 Ene 20 Kalamata FCKalamata 0 - 1 EgaleoEgaleo ...
05 Ene 20 Triglia RafinasTriglia 1 - 2 KavalaKavala ...
05 Ene 20 OF IerapetraIerapetra 3 - 0 IalysosIalysos 1
04 Ene 20 Olympiakos VolosOlympiakos 4 - 1 Enosis AspropyrgosEnosis ...
05 Ene 20 ThesprotosThesprotos 0 - 1 Niki VolosNiki Volos ...
04 Ene 20 DiagorasDiagoras 0 - 1 Veria NPSVeria NPS ...
05 Ene 20 TrikalaTrikala 1 - 0 Ionikos NikeaIonikos ...
Jornada 15
11 Ene 20 EgaleoEgaleo 0 - 0 KavalaKavala ...
12 Ene 20 IalysosIalysos 0 - 0 Kalamata FCKalamata 1
11 Ene 20 Enosis AspropyrgosEnosis 0 - 3 Triglia RafinasTriglia ...
11 Ene 20 Niki VolosNiki Volos 0 - 0 OF IerapetraIerapetra 1
12 Ene 20 Veria NPSVeria NPS 1 - 0 Olympiakos VolosOlympiakos ...
12 Ene 20 Ionikos NikeaIonikos 1 - 1 ThesprotosThesprotos ...
12 Ene 20 TrikalaTrikala 0 - 1 DiagorasDiagoras ...
Jornada 16
18 Ene 20 IalysosIalysos 1 - 0 EgaleoEgaleo ...
18 Ene 20 KavalaKavala 0 - 0 Enosis AspropyrgosEnosis 1
19 Ene 20 Kalamata FCKalamata 0 - 2 Niki VolosNiki Volos ...
19 Ene 20 Triglia RafinasTriglia 0 - 0 Veria NPSVeria NPS ...
18 Ene 20 OF IerapetraIerapetra 0 - 0 Ionikos NikeaIonikos ...
19 Ene 20 Olympiakos VolosOlympiakos 2 - 2 TrikalaTrikala 4
19 Ene 20 ThesprotosThesprotos 1 - 2 DiagorasDiagoras ...
Jornada 17
26 Ene 20 EgaleoEgaleo 0 - 2 Enosis AspropyrgosEnosis ...
26 Ene 20 Niki VolosNiki Volos 2 - 0 IalysosIalysos ...
25 Ene 20 Veria NPSVeria NPS 0 - 2 KavalaKavala ...
26 Ene 20 Ionikos NikeaIonikos 1 - 0 Kalamata FCKalamata ...
26 Ene 20 TrikalaTrikala 2 - 0 Triglia RafinasTriglia ...
26 Ene 20 DiagorasDiagoras 0 - 0 OF IerapetraIerapetra ...
26 Ene 20 ThesprotosThesprotos 4 - 1 Olympiakos VolosOlympiakos ...
Jornada 18
02 Feb 20 Niki VolosNiki Volos 1 - 1 EgaleoEgaleo ...
02 Feb 20 Enosis AspropyrgosEnosis 2 - 2 Veria NPSVeria NPS ...
01 Feb 20 IalysosIalysos 2 - 2 Ionikos NikeaIonikos ...
01 Feb 20 KavalaKavala 0 - 0 TrikalaTrikala ...
02 Feb 20 Kalamata FCKalamata 1 - 0 DiagorasDiagoras ...
01 Feb 20 Triglia RafinasTriglia 0 - 1 ThesprotosThesprotos ...
02 Feb 20 OF IerapetraIerapetra 1 - 3 Olympiakos VolosOlympiakos ...
Jornada 19
09 Feb 20 EgaleoEgaleo 1 - 0 Veria NPSVeria NPS ...
08 Feb 20 Ionikos NikeaIonikos 2 - 0 Niki VolosNiki Volos ...
08 Feb 20 TrikalaTrikala 1 - 0 Enosis AspropyrgosEnosis ...
09 Feb 20 DiagorasDiagoras 3 - 1 IalysosIalysos ...
09 Feb 20 ThesprotosThesprotos 1 - 0 KavalaKavala ...
09 Feb 20 Olympiakos VolosOlympiakos 2 - 1 Kalamata FCKalamata ...
09 Feb 20 OF IerapetraIerapetra 3 - 0 Triglia RafinasTriglia ...
Jornada 20
16 Feb 20 Ionikos NikeaIonikos 3 - 0 EgaleoEgaleo ...
15 Feb 20 Veria NPSVeria NPS 1 - 1 TrikalaTrikala ...
16 Feb 20 Niki VolosNiki Volos 2 - 1 DiagorasDiagoras ...
16 Feb 20 Enosis AspropyrgosEnosis 1 - 2 ThesprotosThesprotos ...
16 Feb 20 IalysosIalysos 4 - 0 Olympiakos VolosOlympiakos ...
16 Feb 20 KavalaKavala 0 - 0 OF IerapetraIerapetra ...
15 Feb 20 Kalamata FCKalamata 1 - 0 Triglia RafinasTriglia ...
Jornada 21
23 Feb 20 EgaleoEgaleo 1 - 0 TrikalaTrikala ...
22 Feb 20 DiagorasDiagoras 1 - 0 Ionikos NikeaIonikos ...
23 Feb 20 ThesprotosThesprotos 2 - 4 Veria NPSVeria NPS ...
22 Feb 20 Olympiakos VolosOlympiakos 1 - 1 Niki VolosNiki Volos ...
22 Feb 20 OF IerapetraIerapetra 1 - 0 Enosis AspropyrgosEnosis ...
22 Feb 20 Triglia RafinasTriglia 0 - 2 IalysosIalysos ...
23 Feb 20 Kalamata FCKalamata 0 - 1 KavalaKavala ...
Jornada 22
29 Feb 20 DiagorasDiagoras 1 - 0 EgaleoEgaleo ...
29 Feb 20 TrikalaTrikala 2 - 1 ThesprotosThesprotos ...
01 Mar 20 Ionikos NikeaIonikos 2 - 0 Olympiakos VolosOlympiakos ...
29 Feb 20 Veria NPSVeria NPS 1 - 2 OF IerapetraIerapetra 3
29 Feb 20 Niki VolosNiki Volos 2 - 2 Triglia RafinasTriglia ...
01 Mar 20 Enosis AspropyrgosEnosis 1 - 0 Kalamata FCKalamata 1
01 Mar 20 KavalaKavala 3 - 0 IalysosIalysos ...
Jornada 23
07 Mar 20 EgaleoEgaleo 1 - 0 ThesprotosThesprotos ...
08 Mar 20 Olympiakos VolosOlympiakos 0 - 1 DiagorasDiagoras ...
07 Mar 20 OF IerapetraIerapetra 0 - 1 TrikalaTrikala ...
08 Mar 20 Triglia RafinasTriglia 1 - 0 Ionikos NikeaIonikos ...
08 Mar 20 Kalamata FCKalamata 1 - 1 Veria NPSVeria NPS ...
08 Mar 20 KavalaKavala 0 - 1 Niki VolosNiki Volos ...
07 Mar 20 IalysosIalysos 2 - 2 Enosis AspropyrgosEnosis ...
Jornada 24
15 Mar 20 Olympiakos VolosOlympiakos Apl EgaleoEgaleo ...
15 Mar 20 ThesprotosThesprotos Apl OF IerapetraIerapetra ...
15 Mar 20 DiagorasDiagoras Apl Triglia RafinasTriglia ...
15 Mar 20 TrikalaTrikala Apl Kalamata FCKalamata ...
15 Mar 20 Ionikos NikeaIonikos Apl KavalaKavala ...
15 Mar 20 Veria NPSVeria NPS Apl IalysosIalysos ...
15 Mar 20 Enosis AspropyrgosEnosis Apl Niki VolosNiki Volos ...
Jornada 25
22 Mar 20 EgaleoEgaleo Apl OF IerapetraIerapetra ...
22 Mar 20 Triglia RafinasTriglia Apl Olympiakos VolosOlympiakos ...
22 Mar 20 Kalamata FCKalamata Apl ThesprotosThesprotos ...
22 Mar 20 KavalaKavala Apl DiagorasDiagoras ...
22 Mar 20 IalysosIalysos Apl TrikalaTrikala ...
22 Mar 20 Enosis AspropyrgosEnosis Apl Ionikos NikeaIonikos ...
22 Mar 20 Niki VolosNiki Volos Apl Veria NPSVeria NPS ...
Jornada 26
29 Mar 20 Triglia RafinasTriglia Apl EgaleoEgaleo ...
29 Mar 20 OF IerapetraIerapetra Apl Kalamata FCKalamata ...
29 Mar 20 Olympiakos VolosOlympiakos Apl KavalaKavala ...
29 Mar 20 ThesprotosThesprotos Apl IalysosIalysos ...
29 Mar 20 DiagorasDiagoras Apl Enosis AspropyrgosEnosis ...
29 Mar 20 TrikalaTrikala Apl Niki VolosNiki Volos ...
29 Mar 20 Veria NPSVeria NPS Apl Ionikos NikeaIonikos ...

Clasificación

Equipo PJ GF GC Puntos
1 Trikala Trikala 23 28 14 46
2 Ionikos Nikea Ionikos 23 26 13 40
3 Diagoras Diagoras 23 27 15 38
4 Niki Volos Niki Volos 23 27 20 37
5 OF Ierapetra Ierapetra 23 23 19 37
6 Kavala Kavala 23 23 12 36
7 Veria NPS Veria NPS 23 27 19 35
8 Olympiakos Volos Olympiakos 23 28 32 31
9 Egaleo Egaleo 23 14 22 27
10 Thesprotos Thesprotos 23 26 33 24
11 Ialysos Ialysos 23 17 28 24
12 Enosis Aspropyrgos Enosis 23 21 33 20
13 Triglia Rafinas Triglia 23 17 33 20
14 Kalamata FC Kalamata FC 23 17 28 19

  USO DE MEMORIA  
6,166,320 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1411
Total Execution Time  0.1430
  CADENA URL  
/football_league_grecia2020/grupo1/calendario
  GET DATOS  
$_GET['/football_league_grecia2020/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0018  SELECT type FROM routes WHERE alias = 'football_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 = 'football_league_grecia' AND (l.group_code = 1 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=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=343 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 343 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (1147869,1023679,880709,826534,810791) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=343 ORDER BY order_id ASC
0.0019  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 = 51506 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0042  SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2, dt1.stadium as stadium_name FROM calendars2020 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 51506 ORDER BY round ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 09:19:14' 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-28 09:19:14' 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-28 09:19:14' 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-28 09:19:14' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0033  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'football_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.0193  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 = 51506 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51506 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.0029  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 = 51506 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51506 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0040  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 = 51506 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51506 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0033  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 = 51506 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC