4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
24 Sep 23 El Sekka El HadidSekka Hadid 0 - 0 La VienaLa Viena 1
26 Sep 23 Dekernes SCDekernes 1 - 3 ItesalatItesalat ...
26 Sep 23 Gomhoreyat ShepinGomhoreyat 0 - 1 Ghazl El MehallaGhazl ...
24 Sep 23 Haras El-HodoodHaras 1 - 0 Abo Qir SemadSemad ...
25 Sep 23 Al Nasr TaadenNasr Taaden 1 - 3 Asyut PetroleumAsyut 1
25 Sep 23 NogoomNogoom 0 - 0 MakadiMakadi ...
25 Sep 23 PetroJetPetroJet 2 - 0 Aswan SCAswan SC ...
26 Sep 23 ProxyProxy 2 - 2 Olympic El QanahOlympic 5
26 Sep 23 TantaTanta 1 - 0 Raya GhazlRaya Ghazl 3
26 Sep 23 Wadi DeglaWadi Degla 2 - 1 Misr El-MakasaMisr 2
Ver jornada
Jornada 2
01 Oct 23 Ghazl El MehallaGhazl 1 - 1 Haras El-HodoodHaras ...
02 Oct 23 Aswan SCAswan SC 2 - 0 NogoomNogoom ...
02 Oct 23 Asyut PetroleumAsyut 0 - 1 ProxyProxy ...
02 Oct 23 MakadiMakadi 2 - 2 Dekernes SCDekernes ...
02 Oct 23 Misr El-MakasaMisr 0 - 1 El Sekka El HadidSekka Hadid ...
03 Oct 23 Abo Qir SemadSemad 2 - 1 TantaTanta 2
03 Oct 23 Olympic El QanahOlympic 1 - 2 PetroJetPetroJet ...
03 Oct 23 Raya GhazlRaya Ghazl 1 - 1 Wadi DeglaWadi Degla 1
03 Oct 23 La VienaLa Viena 3 - 0 Al Nasr TaadenNasr Taaden 1
03 Oct 23 ItesalatItesalat 4 - 0 Gomhoreyat ShepinGomhoreyat ...
Ver jornada
Jornada 3
08 Oct 23 Haras El-HodoodHaras 1 - 0 ItesalatItesalat ...
08 Oct 23 Ghazl El MehallaGhazl 2 - 0 Abo Qir SemadSemad 3
09 Oct 23 Dekernes SCDekernes 1 - 0 Aswan SCAswan SC ...
09 Oct 23 Gomhoreyat ShepinGomhoreyat 1 - 1 MakadiMakadi 3
09 Oct 23 Al Nasr TaadenNasr Taaden 1 - 1 Misr El-MakasaMisr ...
09 Oct 23 NogoomNogoom 0 - 3 Olympic El QanahOlympic 2
09 Oct 23 PetroJetPetroJet 1 - 0 Asyut PetroleumAsyut 5
09 Oct 23 ProxyProxy 0 - 1 La VienaLa Viena 9
10 Oct 23 El Sekka El HadidSekka Hadid 2 - 2 Raya GhazlRaya Ghazl 49
10 Oct 23 Wadi DeglaWadi Degla 0 - 0 TantaTanta 121
Ver jornada
Jornada 4
16 Oct 23 Aswan SCAswan SC 1 - 2 Gomhoreyat ShepinGomhoreyat 11
16 Oct 23 Asyut PetroleumAsyut 1 - 0 NogoomNogoom ...
16 Oct 23 Raya GhazlRaya Ghazl 2 - 1 Al Nasr TaadenNasr Taaden 11
16 Oct 23 MakadiMakadi 1 - 1 Haras El-HodoodHaras 5
16 Oct 23 Misr El-MakasaMisr 3 - 3 ProxyProxy 1
17 Oct 23 Abo Qir SemadSemad 1 - 1 Wadi DeglaWadi Degla 1
17 Oct 23 Olympic El QanahOlympic 2 - 0 Dekernes SCDekernes ...
17 Oct 23 La VienaLa Viena 3 - 2 PetroJetPetroJet 1
17 Oct 23 TantaTanta 1 - 1 El Sekka El HadidSekka Hadid ...
17 Oct 23 ItesalatItesalat 0 - 2 Ghazl El MehallaGhazl 1
Ver jornada
Jornada 5
22 Oct 23 Haras El-HodoodHaras 1 - 1 Aswan SCAswan SC ...
23 Oct 23 Dekernes SCDekernes 2 - 0 Asyut PetroleumAsyut 5
23 Oct 23 Ghazl El MehallaGhazl 1 - 1 MakadiMakadi 6
23 Oct 23 Al Nasr TaadenNasr Taaden 2 - 1 TantaTanta 9
23 Oct 23 NogoomNogoom 2 - 1 La VienaLa Viena 15
23 Oct 23 PetroJetPetroJet 2 - 1 Misr El-MakasaMisr 6
24 Oct 23 El Sekka El HadidSekka Hadid 0 - 0 Wadi DeglaWadi Degla 24
24 Oct 23 Gomhoreyat ShepinGomhoreyat 0 - 1 Olympic El QanahOlympic 4
24 Oct 23 ProxyProxy 2 - 1 Raya GhazlRaya Ghazl 2
24 Oct 23 ItesalatItesalat 1 - 2 Abo Qir SemadSemad 4
Ver jornada
Jornada 6
29 Oct 23 Aswan SCAswan SC 2 - 0 Ghazl El MehallaGhazl ...
30 Oct 23 Asyut PetroleumAsyut 2 - 0 Gomhoreyat ShepinGomhoreyat ...
30 Oct 23 MakadiMakadi 1 - 1 ItesalatItesalat 2
30 Oct 23 Misr El-MakasaMisr 1 - 1 NogoomNogoom 2
31 Oct 23 Wadi DeglaWadi Degla 3 - 0 Al Nasr TaadenNasr Taaden ...
31 Oct 23 Abo Qir SemadSemad 1 - 0 El Sekka El HadidSekka Hadid 4
31 Oct 23 Olympic El QanahOlympic 1 - 1 Haras El-HodoodHaras 1
31 Oct 23 Raya GhazlRaya Ghazl 1 - 0 PetroJetPetroJet 1
31 Oct 23 La VienaLa Viena 3 - 0 Dekernes SCDekernes ...
01 Nov 23 TantaTanta 4 - 0 ProxyProxy ...
Ver jornada
Jornada 7
06 Nov 23 Dekernes SCDekernes 3 - 1 Misr El-MakasaMisr 3
06 Nov 23 Gomhoreyat ShepinGomhoreyat 0 - 0 La VienaLa Viena 20
06 Nov 23 Haras El-HodoodHaras 3 - 1 Asyut PetroleumAsyut 1
06 Nov 23 MakadiMakadi 2 - 1 Abo Qir SemadSemad 11
06 Nov 23 Al Nasr TaadenNasr Taaden 2 - 3 El Sekka El HadidSekka Hadid ...
06 Nov 23 ItesalatItesalat 1 - 0 Aswan SCAswan SC 2
07 Nov 23 Ghazl El MehallaGhazl 2 - 1 Olympic El QanahOlympic ...
07 Nov 23 NogoomNogoom 1 - 1 Raya GhazlRaya Ghazl ...
07 Nov 23 PetroJetPetroJet 2 - 1 TantaTanta 14
07 Nov 23 ProxyProxy 1 - 2 Wadi DeglaWadi Degla 2
Ver jornada
Jornada 8
12 Nov 23 Wadi DeglaWadi Degla 1 - 1 PetroJetPetroJet ...
13 Nov 23 Abo Qir SemadSemad 5 - 0 Al Nasr TaadenNasr Taaden 10
13 Nov 23 Aswan SCAswan SC 3 - 2 MakadiMakadi 4
13 Nov 23 Asyut PetroleumAsyut 1 - 0 Ghazl El MehallaGhazl 7
13 Nov 23 Misr El-MakasaMisr 1 - 0 Gomhoreyat ShepinGomhoreyat 9
14 Nov 23 Olympic El QanahOlympic 2 - 2 ItesalatItesalat 1
14 Nov 23 El Sekka El HadidSekka Hadid 0 - 0 ProxyProxy 24
13 Nov 23 Raya GhazlRaya Ghazl 2 - 2 Dekernes SCDekernes 15
14 Nov 23 La VienaLa Viena 2 - 2 Haras El-HodoodHaras 12
14 Nov 23 TantaTanta 2 - 1 NogoomNogoom 15
Ver jornada
Jornada 9
19 Nov 23 PetroJetPetroJet 1 - 1 El Sekka El HadidSekka Hadid ...
20 Nov 23 Aswan SCAswan SC 0 - 0 Abo Qir SemadSemad 10
20 Nov 23 Ghazl El MehallaGhazl 2 - 1 La VienaLa Viena 14
20 Nov 23 Haras El-HodoodHaras 6 - 2 Misr El-MakasaMisr 19
21 Nov 23 MakadiMakadi 2 - 1 Olympic El QanahOlympic 7
20 Nov 23 ProxyProxy 2 - 1 Al Nasr TaadenNasr Taaden 8
21 Nov 23 ItesalatItesalat 2 - 3 Asyut PetroleumAsyut 1
21 Nov 23 Dekernes SCDekernes 1 - 1 TantaTanta 8
21 Nov 23 Gomhoreyat ShepinGomhoreyat 1 - 2 Raya GhazlRaya Ghazl 1
21 Nov 23 NogoomNogoom 1 - 2 Wadi DeglaWadi Degla 1
Ver jornada
Jornada 10
29 Nov 23 El Sekka El HadidSekka Hadid 4 - 0 NogoomNogoom 2
29 Nov 23 Olympic El QanahOlympic 1 - 1 Aswan SCAswan SC ...
29 Nov 23 Asyut PetroleumAsyut 1 - 0 MakadiMakadi 5
29 Nov 23 Raya GhazlRaya Ghazl 0 - 0 Haras El-HodoodHaras 17
29 Nov 23 Misr El-MakasaMisr 1 - 2 Ghazl El MehallaGhazl 9
27 Nov 23 Al Nasr TaadenNasr Taaden 1 - 2 PetroJetPetroJet 2
28 Nov 23 Abo Qir SemadSemad 1 - 1 ProxyProxy ...
28 Nov 23 La VienaLa Viena 1 - 0 ItesalatItesalat 5
29 Nov 23 TantaTanta 1 - 0 Gomhoreyat ShepinGomhoreyat 1
30 Nov 23 Wadi DeglaWadi Degla 3 - 1 Dekernes SCDekernes 4
Ver jornada
Jornada 11
04 Dic 23 Haras El-HodoodHaras 3 - 1 TantaTanta ...
04 Dic 23 Aswan SCAswan SC 0 - 0 Asyut PetroleumAsyut 4
04 Dic 23 MakadiMakadi 0 - 1 La VienaLa Viena 7
04 Dic 23 NogoomNogoom 2 - 1 Al Nasr TaadenNasr Taaden ...
04 Dic 23 ItesalatItesalat 2 - 1 Misr El-MakasaMisr 4
05 Dic 23 Olympic El QanahOlympic 0 - 0 Abo Qir SemadSemad 1
05 Dic 23 Dekernes SCDekernes 0 - 1 El Sekka El HadidSekka Hadid ...
04 Dic 23 Ghazl El MehallaGhazl 0 - 0 Raya GhazlRaya Ghazl 31
05 Dic 23 Gomhoreyat ShepinGomhoreyat 0 - 0 Wadi DeglaWadi Degla 2
04 Dic 23 PetroJetPetroJet 3 - 0 ProxyProxy 6
Ver jornada
Jornada 12
15 Dic 23 TantaTanta 0 - 0 Ghazl El MehallaGhazl 15
16 Dic 23 Wadi DeglaWadi Degla 1 - 2 Haras El-HodoodHaras ...
14 Dic 23 Asyut PetroleumAsyut 0 - 2 Olympic El QanahOlympic ...
15 Dic 23 Misr El-MakasaMisr 2 - 1 MakadiMakadi ...
14 Dic 23 Al Nasr TaadenNasr Taaden 0 - 1 Dekernes SCDekernes ...
14 Dic 23 Abo Qir SemadSemad 1 - 3 PetroJetPetroJet 3
14 Dic 23 El Sekka El HadidSekka Hadid 0 - 0 Gomhoreyat ShepinGomhoreyat 10
14 Dic 23 Raya GhazlRaya Ghazl 2 - 1 ItesalatItesalat ...
14 Dic 23 La VienaLa Viena 2 - 2 Aswan SCAswan SC 5
14 Dic 23 ProxyProxy 2 - 1 NogoomNogoom 1
Ver jornada
Jornada 13
20 Dic 23 Ghazl El MehallaGhazl 0 - 0 Wadi DeglaWadi Degla 3
20 Dic 23 Haras El-HodoodHaras 0 - 0 El Sekka El HadidSekka Hadid 4
18 Dic 23 Olympic El QanahOlympic 2 - 1 La VienaLa Viena 12
20 Dic 23 Aswan SCAswan SC 4 - 1 Misr El-MakasaMisr ...
18 Dic 23 Asyut PetroleumAsyut 2 - 1 Abo Qir SemadSemad 3
18 Dic 23 Gomhoreyat ShepinGomhoreyat 3 - 2 Al Nasr TaadenNasr Taaden 3
20 Dic 23 MakadiMakadi 1 - 2 Raya GhazlRaya Ghazl 2
19 Dic 23 Dekernes SCDekernes 0 - 0 ProxyProxy 1
19 Dic 23 NogoomNogoom 0 - 1 PetroJetPetroJet 11
19 Dic 23 ItesalatItesalat 1 - 0 TantaTanta 3
Ver jornada
Jornada 14
27 Dic 23 El Sekka El HadidSekka Hadid 1 - 1 Ghazl El MehallaGhazl 10
28 Dic 23 Raya GhazlRaya Ghazl 0 - 0 Aswan SCAswan SC 2
28 Dic 23 Misr El-MakasaMisr 0 - 1 Olympic El QanahOlympic 3
25 Dic 23 Al Nasr TaadenNasr Taaden 1 - 2 Haras El-HodoodHaras 10
27 Dic 23 TantaTanta 2 - 1 MakadiMakadi 12
28 Dic 23 Abo Qir SemadSemad 0 - 2 NogoomNogoom 14
27 Dic 23 La VienaLa Viena 1 - 1 Asyut PetroleumAsyut 9
27 Dic 23 PetroJetPetroJet 3 - 0 Dekernes SCDekernes 14
27 Dic 23 ProxyProxy 3 - 0 Gomhoreyat ShepinGomhoreyat 10
27 Dic 23 Wadi DeglaWadi Degla 1 - 0 ItesalatItesalat 9
Ver jornada
Jornada 15
03 Ene 24 Aswan SCAswan SC 1 - 3 TantaTanta 1
03 Ene 24 Asyut PetroleumAsyut 3 - 2 Misr El-MakasaMisr 4
03 Ene 24 Ghazl El MehallaGhazl 1 - 0 Al Nasr TaadenNasr Taaden 31
03 Ene 24 La VienaLa Viena 0 - 0 Abo Qir SemadSemad 15
03 Ene 24 MakadiMakadi 0 - 0 Wadi DeglaWadi Degla 1
02 Ene 24 Olympic El QanahOlympic 0 - 0 Raya GhazlRaya Ghazl 48
02 Ene 24 Dekernes SCDekernes 3 - 2 NogoomNogoom 15
03 Ene 24 Gomhoreyat ShepinGomhoreyat 0 - 1 PetroJetPetroJet 9
02 Ene 24 Haras El-HodoodHaras 1 - 1 ProxyProxy 12
02 Ene 24 ItesalatItesalat 2 - 4 El Sekka El HadidSekka Hadid 4
Ver jornada
Jornada 16
08 Ene 24 Raya GhazlRaya Ghazl 1 - 1 Asyut PetroleumAsyut 4
08 Ene 24 Misr El-MakasaMisr 0 - 3 La VienaLa Viena 4
08 Ene 24 Al Nasr TaadenNasr Taaden 0 - 1 ItesalatItesalat 6
08 Ene 24 NogoomNogoom 1 - 1 Gomhoreyat ShepinGomhoreyat 1
09 Ene 24 Abo Qir SemadSemad 0 - 0 Dekernes SCDekernes 7
09 Ene 24 El Sekka El HadidSekka Hadid 1 - 1 MakadiMakadi 19
09 Ene 24 ProxyProxy 2 - 2 Ghazl El MehallaGhazl 13
09 Ene 24 TantaTanta 1 - 0 Olympic El QanahOlympic 21
10 Ene 24 PetroJetPetroJet 4 - 0 Haras El-HodoodHaras 10
10 Ene 24 Wadi DeglaWadi Degla 2 - 0 Aswan SCAswan SC 6
Ver jornada
Jornada 17
15 Ene 24 Olympic El QanahOlympic 0 - 2 Wadi DeglaWadi Degla ...
15 Ene 24 Aswan SCAswan SC 1 - 0 El Sekka El HadidSekka Hadid 10
15 Ene 24 Asyut PetroleumAsyut 0 - 0 TantaTanta 7
15 Ene 24 Ghazl El MehallaGhazl 1 - 1 PetroJetPetroJet 19
15 Ene 24 Gomhoreyat ShepinGomhoreyat 2 - 1 Dekernes SCDekernes 3
15 Ene 24 Haras El-HodoodHaras 1 - 0 NogoomNogoom 18
15 Ene 24 La VienaLa Viena 2 - 0 Raya GhazlRaya Ghazl 1
15 Ene 24 MakadiMakadi 0 - 0 Al Nasr TaadenNasr Taaden 4
16 Ene 24 Misr El-MakasaMisr 0 - 2 Abo Qir SemadSemad 2
15 Ene 24 ItesalatItesalat 0 - 0 ProxyProxy 1
Ver jornada
Jornada 18
22 Ene 24 Abo Qir SemadSemad 2 - 0 Gomhoreyat ShepinGomhoreyat ...
22 Ene 24 El Sekka El HadidSekka Hadid 0 - 0 Olympic El QanahOlympic 3
22 Ene 24 Dekernes SCDekernes 1 - 1 Haras El-HodoodHaras ...
22 Ene 24 Raya GhazlRaya Ghazl 4 - 0 Misr El-MakasaMisr ...
22 Ene 24 Al Nasr TaadenNasr Taaden 1 - 1 Aswan SCAswan SC ...
22 Ene 24 NogoomNogoom 0 - 1 Ghazl El MehallaGhazl 1
22 Ene 24 PetroJetPetroJet 2 - 1 ItesalatItesalat 4
22 Ene 24 ProxyProxy 2 - 1 MakadiMakadi 4
22 Ene 24 TantaTanta 1 - 1 La VienaLa Viena 1
22 Ene 24 Wadi DeglaWadi Degla 2 - 1 Asyut PetroleumAsyut 1
Ver jornada
Jornada 19
29 Ene 24 Abo Qir SemadSemad 0 - 0 Raya GhazlRaya Ghazl 8
29 Ene 24 Olympic El QanahOlympic 1 - 0 Al Nasr TaadenNasr Taaden ...
29 Ene 24 Aswan SCAswan SC 0 - 1 ProxyProxy 2
29 Ene 24 Asyut PetroleumAsyut 0 - 1 El Sekka El HadidSekka Hadid 2
29 Ene 24 Ghazl El MehallaGhazl 2 - 0 Dekernes SCDekernes 2
29 Ene 24 Haras El-HodoodHaras 1 - 0 Gomhoreyat ShepinGomhoreyat ...
29 Ene 24 La VienaLa Viena 3 - 4 Wadi DeglaWadi Degla 3
29 Ene 24 MakadiMakadi 0 - 1 PetroJetPetroJet 1
29 Ene 24 Misr El-MakasaMisr 0 - 3 TantaTanta 1
29 Ene 24 ItesalatItesalat 1 - 0 NogoomNogoom ...

Clasificación

Equipo PJ GF GC Puntos
1 PetroJet PetroJet 18 33 13 42
2 Wadi Degla Wadi Degla 19 27 13 38
3 Haras El-Hodood Haras 19 28 18 36
4 Ghazl El Mehalla Ghazl 19 21 12 35
5 La Viena La Viena 19 29 18 31
6 Tanta Tanta 19 24 16 30
7 El Sekka El Hadid Sekka Hadid 19 20 12 29
8 Proxy Proxy 19 23 23 29
9 Raya Ghazl Raya Ghazl 19 21 16 28
10 Olympic El Qanah Olympic 19 21 16 28
11 Asyut Petroleum Asyut 19 20 20 28
12 Abo Qir Semad Semad 19 19 16 25
13 Itesalat Itesalat 19 23 23 24
14 Aswan SC Aswan SC 19 19 20 22
15 Dekernes SC Dekernes SC 19 19 28 21
16 Makadi Makadi 18 17 22 15
17 Gomhoreyat Shepin Gomhoreyat 19 10 25 14
18 Nogoom Nogoom 19 14 28 13
19 Misr El-Makasa Misr 19 18 44 9
20 Al Nasr Taaden Nasr Taaden 19 14 37 6

  USO DE MEMORIA  
6,358,472 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.3691
Total Execution Time  0.3711
  CADENA URL  
/2nd_division_egipto2024/grupo1/calendario
  GET DATOS  
$_GET['/2nd_division_egipto2024/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0125  SELECT type FROM routes WHERE alias = '2nd_division_egipto2024'
0.0253  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '2nd_division_egipto' 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.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=518 AND type_rel = 3
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=518 ORDER BY order_id ASC
0.0127  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 = 73991 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0135  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 calendars2024 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 73991 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 06:51:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 06:51:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 06:51:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 06:51:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = '2nd_division_egipto' AND (l.group_code = 0 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=0 DESC LIMIT 1
0.0183  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 = 73991 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73991 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 events2024 e ON e.player_id = p.id AND e.league_id = 73991 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73991 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0132  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 = 73991 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73991 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0151  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 = 73991 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC