4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jornada 1
21 Nov 21 Al Ahli TripoliAhli 1 - 0 Al ShatAl Shat ...
21 Nov 21 AlmahallaAlmahalla 1 - 3 Olympic AzzaweyaOlympic ...
21 Nov 21 Al HilalAl Hilal 2 - 2 Al Ta'awonAl Ta'awon ...
21 Nov 21 Khaleej SartKhaleej 0 - 3 Al Ahly BenghaziAhly ...
22 Nov 21 Darnes SCDarnes SC 0 - 0 Al Nasr BenghaziNasr ...
22 Nov 21 Abu SalimAbu Salim 0 - 2 Al-IttihadAl-Ittihad ...
22 Nov 21 Al-KhmesAl-Khmes 2 - 0 Al-Madina SCAl-Madina ...
22 Nov 21 Shabaab al JabalShabaab 0 - 1 Al SadaqaAl Sadaqa ...
23 Nov 21 Asswehly SCAsswehly 0 - 0 Al-Athad MisurataAl-Athad ...
23 Nov 21 Al-TahaddiAl-Tahaddi 1 - 5 Al-AkhdarAl-Akhdar ...
Jornada 2
29 Nov 21 Al SadaqaAl Sadaqa 0 - 1 Al HilalAl Hilal ...
29 Nov 21 Al ShatAl Shat 0 - 1 Al-Madina SCAl-Madina ...
29 Nov 21 Al Ahly BenghaziAhly 3 - 1 Shabaab al JabalShabaab ...
30 Nov 21 Al-AkhdarAl-Akhdar 2 - 0 Al Ta'awonAl Ta'awon ...
30 Nov 21 Al-KhmesAl-Khmes 0 - 1 Olympic AzzaweyaOlympic ...
30 Nov 21 Al Nasr BenghaziNasr 2 - 0 Al-TahaddiAl-Tahaddi ...
01 Dic 21 Darnes SCDarnes SC 0 - 0 Khaleej SartKhaleej ...
01 Dic 21 Asswehly SCAsswehly 0 - 2 AlmahallaAlmahalla ...
01 Dic 21 Abu SalimAbu Salim 1 - 0 Al-Athad MisurataAl-Athad ...
01 Dic 21 Al-IttihadAl-Ittihad 1 - 0 Al Ahli TripoliAhli ...
Jornada 3
06 Dic 21 Al SadaqaAl Sadaqa 0 - 2 Al Ahly BenghaziAhly ...
06 Dic 21 Al-KhmesAl-Khmes 0 - 1 Asswehly SCAsswehly ...
29 Dic 21 Al-Athad MisurataAl-Athad 1 - 1 Al-IttihadAl-Ittihad ...
06 Dic 21 Al HilalAl Hilal 1 - 1 Al-AkhdarAl-Akhdar ...
07 Dic 21 Al Ta'awonAl Ta'awon 2 - 3 Al Nasr BenghaziNasr ...
07 Dic 21 Shabaab al JabalShabaab 0 - 2 Darnes SCDarnes SC ...
07 Dic 21 Olympic AzzaweyaOlympic 2 - 0 Al ShatAl Shat ...
07 Dic 21 AlmahallaAlmahalla 0 - 0 Abu SalimAbu Salim ...
07 Dic 21 Al-TahaddiAl-Tahaddi 1 - 0 Khaleej SartKhaleej ...
18 Dic 21 Al Ahli TripoliAhli 0 - 0 Al-Madina SCAl-Madina ...
Jornada 4
02 Ene 22 Al-IttihadAl-Ittihad 1 - 1 AlmahallaAlmahalla ...
03 Ene 22 Al Ahli TripoliAhli 2 - 2 Al-Athad MisurataAl-Athad ...
10 Dic 21 Al Ahly BenghaziAhly 2 - 0 Al HilalAl Hilal ...
11 Dic 21 Al-AkhdarAl-Akhdar 2 - 1 Al Nasr BenghaziNasr ...
11 Dic 21 Darnes SCDarnes SC 3 - 0 Al SadaqaAl Sadaqa ...
11 Dic 21 Al-Madina SCAl-Madina 2 - 2 Olympic AzzaweyaOlympic ...
11 Dic 21 Khaleej SartKhaleej 2 - 2 Al Ta'awonAl Ta'awon ...
12 Dic 21 Asswehly SCAsswehly 2 - 0 Al ShatAl Shat ...
12 Dic 21 Al-KhmesAl-Khmes 0 - 0 Abu SalimAbu Salim ...
12 Dic 21 Shabaab al JabalShabaab 2 - 1 Al-TahaddiAl-Tahaddi ...
Jornada 5
07 Ene 22 Al-IttihadAl-Ittihad 0 - 0 Al-KhmesAl-Khmes ...
15 Dic 21 Darnes SCDarnes SC 0 - 1 Al Ahly BenghaziAhly ...
15 Dic 21 AlmahallaAlmahalla 1 - 1 Al-Athad MisurataAl-Athad ...
16 Dic 21 Khaleej SartKhaleej 3 - 6 Al-AkhdarAl-Akhdar ...
16 Dic 21 Al ShatAl Shat 0 - 0 Abu SalimAbu Salim ...
16 Dic 21 Al-TahaddiAl-Tahaddi 1 - 1 Al SadaqaAl Sadaqa ...
17 Dic 21 Al Ta'awonAl Ta'awon 3 - 0 Shabaab al JabalShabaab ...
17 Dic 21 Al HilalAl Hilal 1 - 2 Al Nasr BenghaziNasr ...
22 Dic 21 Al-Madina SCAl-Madina 0 - 0 Asswehly SCAsswehly ...
22 Dic 21 Olympic AzzaweyaOlympic 0 - 0 Al Ahli TripoliAhli ...
Jornada 6
23 Dic 21 Al-TahaddiAl-Tahaddi 1 - 2 Al Ahly BenghaziAhly ...
23 Dic 21 Al-Athad MisurataAl-Athad 1 - 0 Al-KhmesAl-Khmes ...
25 Dic 21 Al HilalAl Hilal 1 - 0 Darnes SCDarnes SC ...
25 Dic 21 Al SadaqaAl Sadaqa 1 - 0 Al Ta'awonAl Ta'awon ...
25 Dic 21 Al ShatAl Shat 0 - 1 Al-IttihadAl-Ittihad ...
26 Dic 21 Al-AkhdarAl-Akhdar 5 - 0 Shabaab al JabalShabaab ...
26 Dic 21 Olympic AzzaweyaOlympic 0 - 2 Asswehly SCAsswehly ...
26 Dic 21 Abu SalimAbu Salim 0 - 0 Al-Madina SCAl-Madina ...
26 Dic 21 Al Ahli TripoliAhli 0 - 0 AlmahallaAlmahalla ...
26 Dic 21 Al Nasr BenghaziNasr 3 - 0 Khaleej SartKhaleej ...
Jornada 7
02 Ene 22 Darnes SCDarnes SC 0 - 0 Al-TahaddiAl-Tahaddi ...
03 Ene 22 Al Ahly BenghaziAhly 2 - 1 Al Ta'awonAl Ta'awon ...
04 Ene 22 Al-AkhdarAl-Akhdar 1 - 0 Al SadaqaAl Sadaqa ...
05 Ene 22 Khaleej SartKhaleej 0 - 2 Al HilalAl Hilal ...
06 Ene 22 Shabaab al JabalShabaab 1 - 0 Al Nasr BenghaziNasr ...
08 Ene 22 Asswehly SCAsswehly 0 - 1 Al Ahli TripoliAhli ...
09 Ene 22 Al ShatAl Shat 0 - 2 Al-Athad MisurataAl-Athad ...
10 Ene 22 Olympic AzzaweyaOlympic 0 - 1 Abu SalimAbu Salim ...
12 Ene 22 Al-Madina SCAl-Madina 0 - 1 Al-IttihadAl-Ittihad ...
12 Ene 22 Al-KhmesAl-Khmes 0 - 0 AlmahallaAlmahalla ...
Jornada 8
13 Ene 22 Al Nasr BenghaziNasr 3 - 1 Al SadaqaAl Sadaqa ...
13 Ene 22 Al Ta'awonAl Ta'awon 2 - 0 Darnes SCDarnes SC ...
14 Ene 22 Al Ahly BenghaziAhly 2 - 0 Al-AkhdarAl-Akhdar ...
14 Ene 22 Khaleej SartKhaleej 2 - 2 Shabaab al JabalShabaab ...
15 Ene 22 Asswehly SCAsswehly 2 - 1 Abu SalimAbu Salim ...
15 Ene 22 Al HilalAl Hilal 2 - 1 Al-TahaddiAl-Tahaddi ...
16 Ene 22 AlmahallaAlmahalla 1 - 1 Al ShatAl Shat ...
16 Ene 22 Al Ahli TripoliAhli 3 - 1 Al-KhmesAl-Khmes ...
17 Ene 22 Al-IttihadAl-Ittihad 5 - 0 Olympic AzzaweyaOlympic ...
17 Ene 22 Al-Athad MisurataAl-Athad 1 - 1 Al-Madina SCAl-Madina ...
Jornada 9
18 Ene 22 Al-AkhdarAl-Akhdar 3 - 0 Darnes SCDarnes SC ...
19 Ene 22 Al SadaqaAl Sadaqa 1 - 0 Khaleej SartKhaleej ...
19 Ene 22 Al Ta'awonAl Ta'awon 1 - 0 Al-TahaddiAl-Tahaddi ...
20 Ene 22 Shabaab al JabalShabaab 0 - 0 Al HilalAl Hilal ...
20 Ene 22 Al-KhmesAl-Khmes 4 - 2 Al ShatAl Shat ...
20 Ene 22 Abu SalimAbu Salim 0 - 2 Al Ahli TripoliAhli ...
22 Ene 22 Al Nasr BenghaziNasr 0 - 1 Al Ahly BenghaziAhly ...
21 Ene 22 Al-Madina SCAl-Madina 2 - 0 AlmahallaAlmahalla ...
21 Ene 22 Al-IttihadAl-Ittihad 0 - 0 Asswehly SCAsswehly ...
21 Ene 22 Al-Athad MisurataAl-Athad 1 - 1 Olympic AzzaweyaOlympic ...
Jornada 10
09 Feb 22 Al SadaqaAl Sadaqa 3 - 0 Shabaab al JabalShabaab ...
10 Feb 22 Al Ta'awonAl Ta'awon 1 - 0 Al HilalAl Hilal ...
10 Feb 22 Al Ahly BenghaziAhly 4 - 0 Khaleej SartKhaleej ...
11 Feb 22 Al-AkhdarAl-Akhdar 0 - 0 Al-TahaddiAl-Tahaddi ...
11 Feb 22 Al Nasr BenghaziNasr 5 - 0 Darnes SCDarnes SC ...
29 Mar 22 Al-IttihadAl-Ittihad 2 - 1 Abu SalimAbu Salim ...
06 Mar 22 Al ShatAl Shat 0 - 0 Al Ahli TripoliAhli ...
12 Feb 22 Al-Madina SCAl-Madina 0 - 0 Al-KhmesAl-Khmes ...
12 Feb 22 Olympic AzzaweyaOlympic 1 - 0 AlmahallaAlmahalla ...
13 Feb 22 Al-Athad MisurataAl-Athad 1 - 0 Asswehly SCAsswehly ...
Jornada 11
16 Feb 22 Al Ta'awonAl Ta'awon 0 - 1 Al-AkhdarAl-Akhdar ...
16 Feb 22 Shabaab al JabalShabaab 0 - 0 Al Ahly BenghaziAhly ...
16 Feb 22 Al HilalAl Hilal 0 - 0 Al SadaqaAl Sadaqa ...
18 Feb 22 Khaleej SartKhaleej 4 - 3 Darnes SCDarnes SC ...
17 Feb 22 Al-TahaddiAl-Tahaddi 0 - 4 Al Nasr BenghaziNasr ...
17 Jun 22 Al Ahli TripoliAhli 2 - 1 Al-IttihadAl-Ittihad ...
18 Feb 22 Al-Madina SCAl-Madina 3 - 1 Al ShatAl Shat ...
18 Feb 22 Olympic AzzaweyaOlympic 2 - 1 Al-KhmesAl-Khmes ...
19 Feb 22 Al-Athad MisurataAl-Athad 0 - 1 Abu SalimAbu Salim ...
19 Feb 22 AlmahallaAlmahalla 4 - 3 Asswehly SCAsswehly ...
Jornada 12
28 Mar 22 Al-Madina SCAl-Madina 0 - 1 Al Ahli TripoliAhli ...
12 Abr 22 Al-IttihadAl-Ittihad 1 - 0 Al-Athad MisurataAl-Athad ...
02 Mar 22 Al ShatAl Shat 0 - 2 Olympic AzzaweyaOlympic ...
03 Mar 22 Khaleej SartKhaleej 1 - 1 Al-TahaddiAl-Tahaddi ...
03 Mar 22 Abu SalimAbu Salim 1 - 1 AlmahallaAlmahalla ...
03 Mar 22 Asswehly SCAsswehly 2 - 2 Al-KhmesAl-Khmes ...
03 Mar 22 Al Ahly BenghaziAhly 1 - 0 Al SadaqaAl Sadaqa ...
04 Mar 22 Darnes SCDarnes SC 1 - 0 Shabaab al JabalShabaab ...
04 Mar 22 Al-AkhdarAl-Akhdar 0 - 0 Al HilalAl Hilal ...
04 Mar 22 Al Nasr BenghaziNasr 3 - 2 Al Ta'awonAl Ta'awon ...
Jornada 13
09 Mar 22 Al HilalAl Hilal 1 - 0 Al Ahly BenghaziAhly ...
10 Mar 22 Al Ta'awonAl Ta'awon 0 - 0 Khaleej SartKhaleej ...
10 Mar 22 Al Nasr BenghaziNasr 2 - 2 Al-AkhdarAl-Akhdar ...
11 Mar 22 Al SadaqaAl Sadaqa 2 - 1 Darnes SCDarnes SC ...
11 Mar 22 Al-TahaddiAl-Tahaddi 1 - 2 Shabaab al JabalShabaab ...
09 Mar 22 Al-KhmesAl-Khmes 1 - 1 Abu SalimAbu Salim ...
09 Mar 22 Olympic AzzaweyaOlympic 1 - 1 Al-Madina SCAl-Madina ...
28 Abr 22 Al-Athad MisurataAl-Athad 1 - 1 Al Ahli TripoliAhli ...
28 Abr 22 AlmahallaAlmahalla 1 - 2 Al-IttihadAl-Ittihad ...
11 Mar 22 Al ShatAl Shat 0 - 0 Asswehly SCAsswehly ...
Jornada 14
06 May 22 Al-KhmesAl-Khmes 0 - 0 Al-IttihadAl-Ittihad ...
21 Jun 22 Al Ahli TripoliAhli 2 - 1 Olympic AzzaweyaOlympic ...
14 Mar 22 Al-Athad MisurataAl-Athad 1 - 1 AlmahallaAlmahalla ...
15 Mar 22 Al Ahly BenghaziAhly 1 - 1 Darnes SCDarnes SC ...
15 Mar 22 Al-AkhdarAl-Akhdar 6 - 1 Khaleej SartKhaleej ...
15 Mar 22 Al SadaqaAl Sadaqa 1 - 1 Al-TahaddiAl-Tahaddi ...
16 Mar 22 Shabaab al JabalShabaab 0 - 4 Al Ta'awonAl Ta'awon ...
16 Mar 22 Al Nasr BenghaziNasr 2 - 1 Al HilalAl Hilal ...
16 Mar 22 Asswehly SCAsswehly 2 - 2 Al-Madina SCAl-Madina ...
16 Mar 22 Abu SalimAbu Salim 2 - 1 Al ShatAl Shat ...
Jornada 15
19 Mar 22 Al-KhmesAl-Khmes 1 - 2 Al-Athad MisurataAl-Athad ...
20 Mar 22 Asswehly SCAsswehly 2 - 2 Olympic AzzaweyaOlympic ...
20 Mar 22 Al-Madina SCAl-Madina 0 - 0 Abu SalimAbu Salim ...
06 Abr 22 Shabaab al JabalShabaab 2 - 3 Al-AkhdarAl-Akhdar ...
07 Abr 22 Khaleej SartKhaleej 0 - 0 Al Nasr BenghaziNasr ...
06 Abr 22 Al Ahly BenghaziAhly 1 - 0 Al-TahaddiAl-Tahaddi ...
23 Mar 22 Al Ta'awonAl Ta'awon 1 - 1 Al SadaqaAl Sadaqa ...
23 Mar 22 Darnes SCDarnes SC 0 - 0 Al HilalAl Hilal ...
25 Mar 22 Al-IttihadAl-Ittihad 2 - 0 Al ShatAl Shat ...
24 Mar 22 AlmahallaAlmahalla 0 - 3 Al Ahli TripoliAhli ...
Jornada 16
10 Abr 22 Al-TahaddiAl-Tahaddi 3 - 2 Darnes SCDarnes SC ...
11 Abr 22 Al HilalAl Hilal 1 - 1 Khaleej SartKhaleej ...
11 Abr 22 Al Ta'awonAl Ta'awon 0 - 1 Al Ahly BenghaziAhly ...
11 Abr 22 Al SadaqaAl Sadaqa 0 - 0 Al-AkhdarAl-Akhdar ...
12 Abr 22 Al Nasr BenghaziNasr 2 - 0 Shabaab al JabalShabaab ...
09 May 22 Abu SalimAbu Salim 0 - 0 Olympic AzzaweyaOlympic ...
10 Jun 22 Al Ahli TripoliAhli 0 - 2 Asswehly SCAsswehly ...
11 May 22 Al-Athad MisurataAl-Athad 3 - 0 Al ShatAl Shat ...
10 May 22 Al-IttihadAl-Ittihad 2 - 3 Al-Madina SCAl-Madina ...
11 May 22 AlmahallaAlmahalla 2 - 1 Al-KhmesAl-Khmes ...
Jornada 17
15 Abr 22 Darnes SCDarnes SC 1 - 1 Al Ta'awonAl Ta'awon ...
15 Abr 22 Al-TahaddiAl-Tahaddi 1 - 0 Al HilalAl Hilal ...
16 Abr 22 Al-AkhdarAl-Akhdar 0 - 1 Al Ahly BenghaziAhly ...
16 Abr 22 Al SadaqaAl Sadaqa 2 - 2 Al Nasr BenghaziNasr ...
17 Abr 22 Shabaab al JabalShabaab 3 - 3 Khaleej SartKhaleej ...
24 Jun 22 Al ShatAl Shat 0 - 4 AlmahallaAlmahalla ...
24 Jun 22 Al-KhmesAl-Khmes 1 - 1 Al Ahli TripoliAhli ...
24 Jun 22 Abu SalimAbu Salim 0 - 3 Asswehly SCAsswehly ...
24 Jun 22 Al-Madina SCAl-Madina 0 - 1 Al-Athad MisurataAl-Athad 1
24 Jun 22 Olympic AzzaweyaOlympic 1 - 0 Al-IttihadAl-Ittihad ...
Jornada 18
14 May 22 Darnes SCDarnes SC 0 - 0 Al-AkhdarAl-Akhdar ...
14 May 22 Al HilalAl Hilal 1 - 0 Shabaab al JabalShabaab ...
14 May 22 Khaleej SartKhaleej 3 - 0 Al SadaqaAl Sadaqa ...
14 May 22 Al-TahaddiAl-Tahaddi 4 - 2 Al Ta'awonAl Ta'awon ...
22 Abr 22 Al Ahly BenghaziAhly 0 - 2 Al Nasr BenghaziNasr ...
27 Jun 22 AlmahallaAlmahalla 4 - 0 Al-Madina SCAl-Madina ...
27 Jun 22 Asswehly SCAsswehly 3 - 0 Al-IttihadAl-Ittihad ...
27 Jun 22 Al Ahli TripoliAhli 4 - 0 Abu SalimAbu Salim ...
27 Jun 22 Al ShatAl Shat 0 - 1 Al-KhmesAl-Khmes ...
27 Jun 22 Olympic AzzaweyaOlympic 1 - 0 Al-Athad MisurataAl-Athad ...

Clasificación

Equipo PJ GF GC Puntos
1 Al Ahly Benghazi Ahly 18 27 7 44
2 Al Nasr Benghazi Nasr 18 36 15 37
3 Al-Akhdar Al-Akhdar 18 37 14 36
4 Al Hilal Al Hilal 18 14 13 25
5 Al Sadaqa Al Sadaqa 18 14 20 21
6 Al Ta'awon Al Ta'awon 18 24 23 20
7 Al-Tahaddi Al-Tahaddi 18 17 28 17
8 Darnes SC Darnes SC 18 14 23 16
9 Khaleej Sart Khaleej Sart 18 20 38 14
10 Shabaab al Jabal Shabaab 18 13 35 13
11 Al Ahli Tripoli Ahli Tripoli 18 23 10 34
12 Al-Ittihad Al-Ittihad 18 22 13 32
13 Olympic Azzaweya Olympic 18 20 18 30
14 Asswehly SC Asswehly SC 18 24 15 28
15 Al-Athad Misurata Al-Athad 18 18 13 26
16 Almahalla Almahalla 18 23 20 23
17 Al-Madina SC Al-Madina 18 15 18 21
18 Abu Salim Abu Salim 18 9 18 20
19 Al-Khmes Al-Khmes 18 15 18 17
20 Al Shat Al Shat 18 5 31 4

  USO DE MEMORIA  
6,227,936 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3168
Total Execution Time  0.3188
  CADENA URL  
/liga_libia2022/grupo1/calendario
  GET DATOS  
$_GET['/liga_libia2022/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0108  SELECT type FROM routes WHERE alias = 'liga_libia2022'
0.0224  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_libia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0109  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1704 AND type_rel = 3
0.0110  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1704 ORDER BY order_id ASC
0.0107  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 = 65938 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0115  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 calendars2022 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 65938 ORDER BY round ASC
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-18 12:08:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0112  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-18 12:08:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0114  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-18 12:08:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0113  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-18 12:08:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0121  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_libia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0119  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 events2022 e ON e.player_id = p.id AND e.league_id = 65938 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 65938 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.0116  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 events2022 e ON e.player_id = p.id AND e.league_id = 65938 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 65938 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0116  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 events2022 e ON e.player_id = p.id AND e.league_id = 65938 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 65938 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0166  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` 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 = 65938 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