4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jornada 1
27 Mar 21 Niki VolosNiki Volos 1 - 2 EgaleoEgaleo ...
28 Mar 21 RodosRodos 0 - 0 EpiskopiEpiskopi ...
28 Mar 21 IalysosIalysos 1 - 1 Athens KallitheaAthens ...
28 Mar 21 Asteras VlachiotiAsteras 1 - 0 Enosis AspropyrgosEnosis ...
28 Mar 21 SantoriniSantorini 0 - 0 Kalamata FCKalamata ...
28 Mar 21 Apollon PontouApollon 0 - 1 ThesprotosThesprotos ...
28 Mar 21 Veria NPSVeria NPS 3 - 0 AEP KozaniAEP Kozani ...
28 Mar 21 KavalaKavala 2 - 1 Panserraikos FCPanserraiko ...
28 Mar 21 Olympiakos VolosOlympiakos 1 - 0 Triglia RafinasTriglia ...
28 Mar 21 PierikosPierikos 2 - 0 Almopos ArideaAlmopos ...
Jornada 2
31 Mar 21 EgaleoEgaleo 0 - 2 IalysosIalysos ...
31 Mar 21 RodosRodos 1 - 1 Niki VolosNiki Volos ...
31 Mar 21 Enosis AspropyrgosEnosis 0 - 2 Kalamata FCKalamata ...
31 Mar 21 Athens KallitheaAthens 1 - 1 SantoriniSantorini ...
31 Mar 21 EpiskopiEpiskopi 1 - 0 Asteras VlachiotiAsteras ...
31 Mar 21 ThesprotosThesprotos 0 - 1 KavalaKavala ...
31 Mar 21 Veria NPSVeria NPS 1 - 0 Apollon PontouApollon ...
31 Mar 21 Triglia RafinasTriglia 1 - 1 Almopos ArideaAlmopos ...
31 Mar 21 Panserraikos FCPanserraiko 2 - 0 PierikosPierikos ...
31 Mar 21 AEP KozaniAEP Kozani 1 - 3 Olympiakos VolosOlympiakos ...
Jornada 3
04 Abr 21 Niki VolosNiki Volos 0 - 1 IalysosIalysos ...
03 Abr 21 Asteras VlachiotiAsteras 0 - 0 RodosRodos ...
04 Abr 21 SantoriniSantorini 1 - 0 EgaleoEgaleo ...
04 Abr 21 Kalamata FCKalamata 1 - 0 EpiskopiEpiskopi ...
04 Abr 21 Enosis AspropyrgosEnosis 0 - 3 Athens KallitheaAthens ...
04 Abr 21 Apollon PontouApollon 0 - 1 KavalaKavala ...
04 Abr 21 Olympiakos VolosOlympiakos 0 - 1 Veria NPSVeria NPS ...
04 Abr 21 PierikosPierikos 2 - 0 ThesprotosThesprotos ...
04 Abr 21 Almopos ArideaAlmopos 1 - 1 AEP KozaniAEP Kozani ...
04 Abr 21 Triglia RafinasTriglia 0 - 0 Panserraikos FCPanserraiko ...
Jornada 4
10 Abr 21 EgaleoEgaleo 1 - 0 Enosis AspropyrgosEnosis ...
10 Abr 21 RodosRodos 0 - 0 Kalamata FCKalamata ...
10 Abr 21 IalysosIalysos 1 - 0 SantoriniSantorini ...
10 Abr 21 Asteras VlachiotiAsteras 0 - 0 Niki VolosNiki Volos ...
10 Abr 21 EpiskopiEpiskopi 0 - 0 Athens KallitheaAthens ...
10 Abr 21 ThesprotosThesprotos 0 - 0 Triglia RafinasTriglia ...
10 Abr 21 Veria NPSVeria NPS 2 - 0 Almopos ArideaAlmopos ...
10 Abr 21 KavalaKavala 3 - 0 PierikosPierikos ...
10 Abr 21 Olympiakos VolosOlympiakos 1 - 0 Apollon PontouApollon ...
10 Abr 21 AEP KozaniAEP Kozani 0 - 2 Panserraikos FCPanserraiko ...
Jornada 5
14 Abr 21 Niki VolosNiki Volos 1 - 1 SantoriniSantorini ...
14 Abr 21 EgaleoEgaleo 1 - 3 EpiskopiEpiskopi ...
14 Abr 21 Kalamata FCKalamata 2 - 0 Asteras VlachiotiAsteras ...
14 Abr 21 Enosis AspropyrgosEnosis 3 - 0 IalysosIalysos ...
14 Abr 21 Athens KallitheaAthens 2 - 3 RodosRodos ...
14 Abr 21 Apollon PontouApollon 2 - 2 PierikosPierikos ...
14 Abr 21 ThesprotosThesprotos 3 - 1 AEP KozaniAEP Kozani ...
14 Abr 21 Almopos ArideaAlmopos 0 - 1 Olympiakos VolosOlympiakos ...
14 Abr 21 Triglia RafinasTriglia 3 - 2 KavalaKavala ...
14 Abr 21 Panserraikos FCPanserraiko 1 - 0 Veria NPSVeria NPS ...
Jornada 6
18 Abr 21 RodosRodos 1 - 0 EgaleoEgaleo ...
18 Abr 21 IalysosIalysos 1 - 0 EpiskopiEpiskopi ...
18 Abr 21 Asteras VlachiotiAsteras 1 - 2 Athens KallitheaAthens ...
18 Abr 21 SantoriniSantorini 0 - 0 Enosis AspropyrgosEnosis ...
17 Abr 21 Kalamata FCKalamata 0 - 0 Niki VolosNiki Volos ...
18 Abr 21 Veria NPSVeria NPS 3 - 1 ThesprotosThesprotos ...
18 Abr 21 KavalaKavala 5 - 1 AEP KozaniAEP Kozani ...
18 Abr 21 Olympiakos VolosOlympiakos 0 - 1 Panserraikos FCPanserraiko 2
18 Abr 21 PierikosPierikos 2 - 0 Triglia RafinasTriglia ...
18 Abr 21 Almopos ArideaAlmopos 4 - 1 Apollon PontouApollon ...
Jornada 7
24 Abr 21 EgaleoEgaleo 1 - 0 Asteras VlachiotiAsteras ...
24 Abr 21 IalysosIalysos 0 - 2 RodosRodos ...
19 May 21 Enosis AspropyrgosEnosis 3 - 2 Niki VolosNiki Volos ...
24 Abr 21 Athens KallitheaAthens 2 - 1 Kalamata FCKalamata ...
24 Abr 21 EpiskopiEpiskopi 1 - 0 SantoriniSantorini ...
24 Abr 21 ThesprotosThesprotos 1 - 0 Olympiakos VolosOlympiakos ...
24 Abr 21 KavalaKavala 0 - 0 Veria NPSVeria NPS ...
24 Abr 21 Triglia RafinasTriglia 0 - 0 Apollon PontouApollon ...
24 Abr 21 Panserraikos FCPanserraiko 3 - 0 Almopos ArideaAlmopos ...
24 Abr 21 AEP KozaniAEP Kozani 0 - 1 PierikosPierikos ...
Jornada 8
29 Abr 21 Niki VolosNiki Volos 1 - 0 Athens KallitheaAthens 1
28 Abr 21 Asteras VlachiotiAsteras 1 - 1 IalysosIalysos ...
28 Abr 21 SantoriniSantorini 1 - 0 RodosRodos ...
29 Abr 21 Kalamata FCKalamata 2 - 0 EgaleoEgaleo 3
26 May 21 EpiskopiEpiskopi 1 - 1 Enosis AspropyrgosEnosis 2
28 Abr 21 Apollon PontouApollon 0 - 3 Panserraikos FCPanserraiko ...
28 Abr 21 Olympiakos VolosOlympiakos 1 - 3 KavalaKavala ...
28 Abr 21 PierikosPierikos 0 - 1 Veria NPSVeria NPS ...
28 Abr 21 Almopos ArideaAlmopos 0 - 0 ThesprotosThesprotos ...
28 Abr 21 AEP KozaniAEP Kozani 0 - 0 Triglia RafinasTriglia ...
Jornada 9
05 May 21 Niki VolosNiki Volos 0 - 0 EpiskopiEpiskopi ...
02 Jun 21 RodosRodos 1 - 0 Enosis AspropyrgosEnosis ...
05 May 21 IalysosIalysos 0 - 0 Kalamata FCKalamata ...
04 May 21 SantoriniSantorini 1 - 0 Asteras VlachiotiAsteras ...
19 May 21 Athens KallitheaAthens 1 - 0 EgaleoEgaleo ...
05 May 21 Apollon PontouApollon 3 - 0 AEP KozaniAEP Kozani ...
05 May 21 Veria NPSVeria NPS 0 - 0 Triglia RafinasTriglia 1
05 May 21 KavalaKavala 2 - 1 Almopos ArideaAlmopos ...
05 May 21 PierikosPierikos 1 - 1 Olympiakos VolosOlympiakos ...
19 May 21 Panserraikos FCPanserraiko 1 - 0 ThesprotosThesprotos ...
Jornada 10
09 May 21 EgaleoEgaleo 0 - 0 Niki VolosNiki Volos ...
09 May 21 EpiskopiEpiskopi 0 - 0 RodosRodos ...
26 May 21 Athens KallitheaAthens 2 - 1 IalysosIalysos 3
09 Jun 21 Enosis AspropyrgosEnosis 0 - 4 Asteras VlachiotiAsteras 2
09 May 21 Kalamata FCKalamata 1 - 0 SantoriniSantorini ...
26 May 21 ThesprotosThesprotos 1 - 2 Apollon PontouApollon ...
09 May 21 AEP KozaniAEP Kozani 0 - 0 Veria NPSVeria NPS ...
08 May 21 Panserraikos FCPanserraiko 1 - 3 KavalaKavala ...
09 May 21 Triglia RafinasTriglia 2 - 0 Olympiakos VolosOlympiakos ...
09 May 21 Almopos ArideaAlmopos 3 - 1 PierikosPierikos ...
Jornada 11
12 May 21 IalysosIalysos 1 - 1 EgaleoEgaleo ...
12 May 21 Niki VolosNiki Volos 1 - 2 RodosRodos ...
12 May 21 Kalamata FCKalamata 2 - 0 Enosis AspropyrgosEnosis ...
02 Jun 21 SantoriniSantorini 1 - 0 Athens KallitheaAthens ...
20 May 21 Asteras VlachiotiAsteras 1 - 1 EpiskopiEpiskopi 1
02 Jun 21 KavalaKavala 1 - 1 ThesprotosThesprotos 2
12 May 21 Apollon PontouApollon 0 - 3 Veria NPSVeria NPS ...
12 May 21 Almopos ArideaAlmopos 3 - 0 Triglia RafinasTriglia ...
12 May 21 PierikosPierikos 1 - 0 Panserraikos FCPanserraiko ...
13 May 21 Olympiakos VolosOlympiakos 3 - 0 AEP KozaniAEP Kozani ...
Jornada 12
16 May 21 IalysosIalysos 1 - 1 Niki VolosNiki Volos ...
17 May 21 RodosRodos 2 - 1 Asteras VlachiotiAsteras 3
16 May 21 EgaleoEgaleo 3 - 0 SantoriniSantorini ...
16 May 21 EpiskopiEpiskopi 1 - 0 Kalamata FCKalamata ...
16 May 21 Athens KallitheaAthens 1 - 0 Enosis AspropyrgosEnosis ...
16 May 21 KavalaKavala 0 - 1 Apollon PontouApollon ...
16 May 21 Veria NPSVeria NPS 3 - 0 Olympiakos VolosOlympiakos ...
16 May 21 ThesprotosThesprotos 0 - 2 PierikosPierikos ...
16 May 21 AEP KozaniAEP Kozani 0 - 0 Almopos ArideaAlmopos ...
15 May 21 Panserraikos FCPanserraiko 1 - 0 Triglia RafinasTriglia ...
Jornada 13
23 May 21 Enosis AspropyrgosEnosis 0 - 2 EgaleoEgaleo ...
22 May 21 Kalamata FCKalamata 1 - 0 RodosRodos ...
23 May 21 SantoriniSantorini 1 - 1 IalysosIalysos ...
23 May 21 Niki VolosNiki Volos 1 - 0 Asteras VlachiotiAsteras ...
23 May 21 Athens KallitheaAthens 2 - 0 EpiskopiEpiskopi ...
23 May 21 Triglia RafinasTriglia 2 - 1 ThesprotosThesprotos ...
23 May 21 Almopos ArideaAlmopos 0 - 0 Veria NPSVeria NPS ...
23 May 21 PierikosPierikos 0 - 2 KavalaKavala ...
16 Jun 21 Apollon PontouApollon 2 - 0 Olympiakos VolosOlympiakos 1
23 May 21 Panserraikos FCPanserraiko 1 - 0 AEP KozaniAEP Kozani ...
Jornada 14
29 May 21 SantoriniSantorini 0 - 1 Niki VolosNiki Volos ...
30 May 21 EpiskopiEpiskopi 0 - 0 EgaleoEgaleo ...
30 May 21 Asteras VlachiotiAsteras 0 - 1 Kalamata FCKalamata ...
30 May 21 IalysosIalysos 2 - 0 Enosis AspropyrgosEnosis ...
30 May 21 RodosRodos 3 - 2 Athens KallitheaAthens ...
30 May 21 PierikosPierikos 3 - 0 Apollon PontouApollon ...
30 May 21 AEP KozaniAEP Kozani 1 - 1 ThesprotosThesprotos ...
30 May 21 Olympiakos VolosOlympiakos 2 - 0 Almopos ArideaAlmopos ...
30 May 21 KavalaKavala 3 - 1 Triglia RafinasTriglia ...
29 May 21 Veria NPSVeria NPS 1 - 0 Panserraikos FCPanserraiko ...
Jornada 15
06 Jun 21 EgaleoEgaleo 1 - 1 RodosRodos ...
06 Jun 21 EpiskopiEpiskopi 3 - 0 IalysosIalysos ...
06 Jun 21 Athens KallitheaAthens 1 - 0 Asteras VlachiotiAsteras ...
06 Jun 21 Enosis AspropyrgosEnosis 1 - 2 SantoriniSantorini ...
05 Jun 21 Niki VolosNiki Volos 2 - 2 Kalamata FCKalamata 3
06 Jun 21 ThesprotosThesprotos 3 - 2 Veria NPSVeria NPS 1
06 Jun 21 AEP KozaniAEP Kozani 0 - 2 KavalaKavala ...
06 Jun 21 Panserraikos FCPanserraiko 0 - 1 Olympiakos VolosOlympiakos ...
06 Jun 21 Triglia RafinasTriglia 1 - 1 PierikosPierikos ...
06 Jun 21 Apollon PontouApollon 3 - 1 Almopos ArideaAlmopos ...
Jornada 16
13 Jun 21 Asteras VlachiotiAsteras 1 - 0 EgaleoEgaleo ...
13 Jun 21 RodosRodos 1 - 2 IalysosIalysos ...
13 Jun 21 Niki VolosNiki Volos 6 - 1 Enosis AspropyrgosEnosis ...
13 Jun 21 Kalamata FCKalamata 1 - 0 Athens KallitheaAthens ...
13 Jun 21 SantoriniSantorini 2 - 2 EpiskopiEpiskopi ...
12 Jun 21 Olympiakos VolosOlympiakos 4 - 2 ThesprotosThesprotos ...
12 Jun 21 Veria NPSVeria NPS 2 - 0 KavalaKavala ...
23 Jun 21 Apollon PontouApollon 1 - 1 Triglia RafinasTriglia ...
13 Jun 21 Almopos ArideaAlmopos 1 - 0 Panserraikos FCPanserraiko ...
13 Jun 21 PierikosPierikos 1 - 1 AEP KozaniAEP Kozani ...
Jornada 17
19 Jun 21 Athens KallitheaAthens 0 - 0 Niki VolosNiki Volos ...
19 Jun 21 IalysosIalysos 1 - 2 Asteras VlachiotiAsteras ...
19 Jun 21 RodosRodos 1 - 3 SantoriniSantorini ...
19 Jun 21 EgaleoEgaleo 2 - 0 Kalamata FCKalamata ...
19 Jun 21 Enosis AspropyrgosEnosis 1 - 2 EpiskopiEpiskopi ...
20 Jun 21 Panserraikos FCPanserraiko 2 - 0 Apollon PontouApollon ...
20 Jun 21 KavalaKavala 1 - 2 Olympiakos VolosOlympiakos ...
20 Jun 21 Veria NPSVeria NPS 2 - 1 PierikosPierikos ...
20 Jun 21 ThesprotosThesprotos 1 - 0 Almopos ArideaAlmopos ...
20 Jun 21 Triglia RafinasTriglia 3 - 0 AEP KozaniAEP Kozani ...
Jornada 18
26 Jun 21 EpiskopiEpiskopi 0 - 0 Niki VolosNiki Volos 3
26 Jun 21 Enosis AspropyrgosEnosis 0 - 2 RodosRodos ...
26 Jun 21 Kalamata FCKalamata 4 - 0 IalysosIalysos ...
26 Jun 21 Asteras VlachiotiAsteras 2 - 1 SantoriniSantorini ...
26 Jun 21 EgaleoEgaleo 0 - 0 Athens KallitheaAthens ...
27 Jun 21 Triglia RafinasTriglia 0 - 0 Veria NPSVeria NPS ...
27 Jun 21 Almopos ArideaAlmopos 3 - 1 KavalaKavala ...
27 Jun 21 Olympiakos VolosOlympiakos 3 - 3 PierikosPierikos ...
27 Jun 21 ThesprotosThesprotos 3 - 2 Panserraikos FCPanserraiko ...
27 Jun 21 AEP KozaniAEP Kozani 1 - 1 Apollon PontouApollon ...

Clasificación

Equipo PJ GF GC Puntos
1 Veria NPS Veria NPS 18 24 6 38
2 Kavala Kavala 18 32 18 35
3 Panserraikos FC Panserraikos 18 21 12 31
4 Olympiakos Volos Olympiakos 18 23 21 29
5 Pierikos Pierikos 18 23 21 26
6 Thesprotos Thesprotos 18 19 24 22
7 Triglia Rafinas Triglia 18 14 16 21
8 Almopos Aridea Almopos 18 18 21 20
9 Apollon Pontou Apollon 18 16 25 19
10 AEP Kozani AEP Kozani 18 7 33 7
11 Kalamata FC Kalamata FC 18 20 7 35
12 Rodos Rodos 18 20 15 30
13 Athens Kallithea Athens 18 20 14 29
14 Episkopi Episkopi 18 15 10 27
15 Santorini Santorini 18 15 16 24
16 Ialysos Ialysos 18 16 22 24
17 Egaleo Egaleo 18 14 14 23
18 Niki Volos Niki Volos 18 18 14 22
19 Asteras Vlachioti Asteras 18 14 16 19
20 Enosis Aspropyrgos Enosis 18 10 34 8

  USO DE MEMORIA  
6,373,704 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3944
Total Execution Time  0.3963
  CADENA URL  
/football_league_grecia2021/grupo1/calendario
  GET DATOS  
$_GET['/football_league_grecia2021/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0128  SELECT type FROM routes WHERE alias = 'football_league_grecia2021'
0.0263  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 = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=343 AND type_rel = 3
0.0144  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.0134  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.0130  SELECT id,name,alias,stepParent FROM categories WHERE parentId=343 ORDER BY order_id ASC
0.0132  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 343 GROUP BY l.categoryId
0.0133  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=343 GROUP BY l.year ORDER BY l.year DESC
0.0144  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 calendars2021 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 60731 ORDER BY round ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 23:26:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 23:26:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 23:26:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 23:26:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  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 = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0166  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 events2021 e ON e.player_id = p.id AND e.league_id = 60731 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 60731 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.0129  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 events2021 e ON e.player_id = p.id AND e.league_id = 60731 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 60731 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0130  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 events2021 e ON e.player_id = p.id AND e.league_id = 60731 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 60731 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0139  SELECT *,(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 = 60731 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC