4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
17 Ago 19 Bled HirterBled Hirter 0 - 6 Brinje-GrosupljeBrinje-Gros ...
17 Ago 19 NK ŽiriNK Žiri 0 - 0 Arne Tabor 69Arne Tabor ...
17 Ago 19 ND Adria MirenAdria Miren 1 - 1 KočevjeKočevje ...
17 Ago 19 PrimorjePrimorje 2 - 0 Fama VipavaFama Vipava ...
17 Ago 19 ŠencurŠencur 2 - 3 NK TolminNK Tolmin ...
17 Ago 19 Ilirija 1911Ilirija 2 - 2 MNK IzolaMNK Izola ...
17 Ago 19 Svoboda LjubljanaSvoboda 3 - 1 Sava KranjSava Kranj ...
Ver jornada
Jornada 2
24 Ago 19 Brinje-GrosupljeBrinje-Gros 0 - 1 Sava KranjSava Kranj ...
24 Ago 19 MNK IzolaMNK Izola 1 - 1 Svoboda LjubljanaSvoboda ...
24 Ago 19 NK TolminNK Tolmin 1 - 1 Ilirija 1911Ilirija ...
25 Ago 19 Fama VipavaFama Vipava 2 - 4 ŠencurŠencur ...
24 Ago 19 KočevjeKočevje 1 - 4 PrimorjePrimorje ...
27 Ago 19 Arne Tabor 69Arne Tabor 2 - 2 ND Adria MirenAdria Miren ...
24 Ago 19 Bled HirterBled Hirter 3 - 1 NK ŽiriNK Žiri ...
Ver jornada
Jornada 3
31 Ago 19 NK ŽiriNK Žiri 1 - 2 Brinje-GrosupljeBrinje-Gros ...
01 Sep 19 ND Adria MirenAdria Miren 1 - 2 Bled HirterBled Hirter ...
31 Ago 19 PrimorjePrimorje 2 - 0 Arne Tabor 69Arne Tabor ...
31 Ago 19 ŠencurŠencur 5 - 0 KočevjeKočevje ...
01 Sep 19 Ilirija 1911Ilirija 0 - 1 Fama VipavaFama Vipava ...
30 Ago 19 Svoboda LjubljanaSvoboda 2 - 2 NK TolminNK Tolmin ...
31 Ago 19 Sava KranjSava Kranj 3 - 0 MNK IzolaMNK Izola ...
Ver jornada
Jornada 4
07 Sep 19 Brinje-GrosupljeBrinje-Gros 4 - 0 MNK IzolaMNK Izola ...
07 Sep 19 NK TolminNK Tolmin 2 - 2 Sava KranjSava Kranj ...
08 Sep 19 Fama VipavaFama Vipava 1 - 1 Svoboda LjubljanaSvoboda ...
06 Sep 19 KočevjeKočevje 2 - 5 Ilirija 1911Ilirija ...
07 Sep 19 Arne Tabor 69Arne Tabor 2 - 3 ŠencurŠencur ...
07 Sep 19 Bled HirterBled Hirter 4 - 0 PrimorjePrimorje ...
07 Sep 19 NK ŽiriNK Žiri 3 - 3 ND Adria MirenAdria Miren ...
Ver jornada
Jornada 5
14 Sep 19 ND Adria MirenAdria Miren 2 - 2 Brinje-GrosupljeBrinje-Gros ...
14 Sep 19 PrimorjePrimorje 3 - 3 NK ŽiriNK Žiri ...
14 Sep 19 ŠencurŠencur 0 - 0 Bled HirterBled Hirter ...
14 Sep 19 Ilirija 1911Ilirija 1 - 1 Arne Tabor 69Arne Tabor ...
13 Sep 19 Svoboda LjubljanaSvoboda 6 - 0 KočevjeKočevje ...
14 Sep 19 Sava KranjSava Kranj 2 - 0 Fama VipavaFama Vipava ...
14 Sep 19 MNK IzolaMNK Izola 1 - 2 NK TolminNK Tolmin ...
Ver jornada
Jornada 6
22 Sep 19 Brinje-GrosupljeBrinje-Gros 2 - 0 NK TolminNK Tolmin ...
22 Sep 19 Fama VipavaFama Vipava 1 - 1 MNK IzolaMNK Izola ...
21 Sep 19 KočevjeKočevje 0 - 4 Sava KranjSava Kranj ...
21 Sep 19 Arne Tabor 69Arne Tabor 3 - 4 Svoboda LjubljanaSvoboda ...
21 Sep 19 Bled HirterBled Hirter 1 - 1 Ilirija 1911Ilirija ...
21 Sep 19 NK ŽiriNK Žiri 2 - 3 ŠencurŠencur ...
21 Sep 19 ND Adria MirenAdria Miren 0 - 1 PrimorjePrimorje ...
Ver jornada
Jornada 7
28 Sep 19 PrimorjePrimorje 3 - 0 Brinje-GrosupljeBrinje-Gros ...
27 Sep 19 ŠencurŠencur 1 - 0 ND Adria MirenAdria Miren ...
29 Sep 19 Ilirija 1911Ilirija 2 - 2 NK ŽiriNK Žiri ...
27 Sep 19 Svoboda LjubljanaSvoboda 6 - 2 Bled HirterBled Hirter ...
28 Sep 19 Sava KranjSava Kranj 1 - 1 Arne Tabor 69Arne Tabor ...
28 Sep 19 MNK IzolaMNK Izola 4 - 2 KočevjeKočevje ...
28 Sep 19 NK TolminNK Tolmin 1 - 2 Fama VipavaFama Vipava ...
Ver jornada
Jornada 8
06 Oct 19 Brinje-GrosupljeBrinje-Gros 1 - 0 Fama VipavaFama Vipava ...
05 Oct 19 KočevjeKočevje 3 - 2 NK TolminNK Tolmin ...
05 Oct 19 Arne Tabor 69Arne Tabor 2 - 1 MNK IzolaMNK Izola ...
05 Oct 19 Bled HirterBled Hirter 4 - 3 Sava KranjSava Kranj ...
05 Oct 19 NK ŽiriNK Žiri 1 - 4 Svoboda LjubljanaSvoboda ...
05 Oct 19 ND Adria MirenAdria Miren 2 - 2 Ilirija 1911Ilirija ...
05 Oct 19 PrimorjePrimorje 2 - 1 ŠencurŠencur ...
Ver jornada
Jornada 9
11 Oct 19 ŠencurŠencur 0 - 3 Brinje-GrosupljeBrinje-Gros ...
12 Oct 19 Ilirija 1911Ilirija 0 - 0 PrimorjePrimorje ...
12 Oct 19 Svoboda LjubljanaSvoboda 3 - 0 ND Adria MirenAdria Miren ...
12 Oct 19 Sava KranjSava Kranj 2 - 0 NK ŽiriNK Žiri ...
13 Oct 19 MNK IzolaMNK Izola 1 - 0 Bled HirterBled Hirter ...
13 Oct 19 NK TolminNK Tolmin 2 - 0 Arne Tabor 69Arne Tabor ...
13 Oct 19 Fama VipavaFama Vipava 1 - 0 KočevjeKočevje ...
Ver jornada
Jornada 10
19 Oct 19 Brinje-GrosupljeBrinje-Gros 0 - 1 KočevjeKočevje ...
19 Oct 19 Arne Tabor 69Arne Tabor 0 - 0 Fama VipavaFama Vipava ...
19 Oct 19 Bled HirterBled Hirter 1 - 0 NK TolminNK Tolmin ...
19 Oct 19 NK ŽiriNK Žiri 0 - 0 MNK IzolaMNK Izola ...
19 Oct 19 ND Adria MirenAdria Miren 3 - 1 Sava KranjSava Kranj ...
19 Oct 19 PrimorjePrimorje 4 - 4 Svoboda LjubljanaSvoboda ...
18 Oct 19 ŠencurŠencur 1 - 1 Ilirija 1911Ilirija ...
Ver jornada
Jornada 11
26 Oct 19 Ilirija 1911Ilirija 1 - 2 Brinje-GrosupljeBrinje-Gros ...
26 Oct 19 Svoboda LjubljanaSvoboda 2 - 3 ŠencurŠencur ...
26 Oct 19 Sava KranjSava Kranj 1 - 2 PrimorjePrimorje ...
27 Oct 19 MNK IzolaMNK Izola 2 - 2 ND Adria MirenAdria Miren ...
26 Oct 19 NK TolminNK Tolmin 3 - 0 NK ŽiriNK Žiri ...
27 Oct 19 Fama VipavaFama Vipava 1 - 0 Bled HirterBled Hirter ...
26 Oct 19 KočevjeKočevje 2 - 2 Arne Tabor 69Arne Tabor ...
Ver jornada
Jornada 12
02 Nov 19 Brinje-GrosupljeBrinje-Gros 5 - 2 Arne Tabor 69Arne Tabor ...
02 Nov 19 Bled HirterBled Hirter 5 - 0 KočevjeKočevje ...
02 Nov 19 NK ŽiriNK Žiri 2 - 0 Fama VipavaFama Vipava ...
02 Nov 19 ND Adria MirenAdria Miren 1 - 2 NK TolminNK Tolmin ...
02 Nov 19 PrimorjePrimorje 7 - 0 MNK IzolaMNK Izola ...
02 Nov 19 ŠencurŠencur 1 - 0 Sava KranjSava Kranj ...
03 Nov 19 Ilirija 1911Ilirija 0 - 5 Svoboda LjubljanaSvoboda ...
Ver jornada
Jornada 13
09 Nov 19 Svoboda LjubljanaSvoboda 4 - 1 Brinje-GrosupljeBrinje-Gros ...
09 Nov 19 Sava KranjSava Kranj 3 - 1 Ilirija 1911Ilirija ...
10 Nov 19 MNK IzolaMNK Izola 2 - 0 ŠencurŠencur ...
09 Nov 19 NK TolminNK Tolmin 0 - 1 PrimorjePrimorje ...
09 Nov 19 KočevjeKočevje 0 - 2 NK ŽiriNK Žiri ...
09 Nov 19 Arne Tabor 69Arne Tabor 0 - 1 Bled HirterBled Hirter ...
10 Nov 19 Fama VipavaFama Vipava 1 - 0 ND Adria MirenAdria Miren ...
Ver jornada
Jornada 14
16 Nov 19 Brinje-GrosupljeBrinje-Gros 0 - 0 Bled HirterBled Hirter ...
17 Nov 19 Arne Tabor 69Arne Tabor 2 - 4 NK ŽiriNK Žiri ...
16 Nov 19 KočevjeKočevje 2 - 2 ND Adria MirenAdria Miren ...
16 Nov 19 Fama VipavaFama Vipava 0 - 1 PrimorjePrimorje ...
16 Nov 19 NK TolminNK Tolmin 1 - 0 ŠencurŠencur ...
16 Nov 19 MNK IzolaMNK Izola 1 - 2 Ilirija 1911Ilirija ...
16 Nov 19 Sava KranjSava Kranj 0 - 2 Svoboda LjubljanaSvoboda ...
Ver jornada
Jornada 15
14 Mar 20 Sava KranjSava Kranj Apl Brinje-GrosupljeBrinje-Gros ...
14 Mar 20 Svoboda LjubljanaSvoboda Apl MNK IzolaMNK Izola ...
14 Mar 20 Ilirija 1911Ilirija Apl NK TolminNK Tolmin ...
14 Mar 20 ŠencurŠencur Apl Fama VipavaFama Vipava ...
14 Mar 20 PrimorjePrimorje Apl KočevjeKočevje ...
15 Mar 20 ND Adria MirenAdria Miren Apl Arne Tabor 69Arne Tabor ...
14 Mar 20 NK ŽiriNK Žiri Apl Bled HirterBled Hirter ...
Ver jornada
Jornada 16
21 Mar 20 Brinje-GrosupljeBrinje-Gros Apl NK ŽiriNK Žiri ...
21 Mar 20 Bled HirterBled Hirter Apl ND Adria MirenAdria Miren ...
21 Mar 20 Arne Tabor 69Arne Tabor Apl PrimorjePrimorje ...
21 Mar 20 KočevjeKočevje Apl ŠencurŠencur ...
22 Mar 20 Fama VipavaFama Vipava Apl Ilirija 1911Ilirija ...
21 Mar 20 NK TolminNK Tolmin Apl Svoboda LjubljanaSvoboda ...
21 Mar 20 MNK IzolaMNK Izola Apl Sava KranjSava Kranj ...
Ver jornada
Jornada 17
28 Mar 20 MNK IzolaMNK Izola Apl Brinje-GrosupljeBrinje-Gros ...
28 Mar 20 Sava KranjSava Kranj Apl NK TolminNK Tolmin ...
28 Mar 20 Svoboda LjubljanaSvoboda Apl Fama VipavaFama Vipava ...
29 Mar 20 Ilirija 1911Ilirija Apl KočevjeKočevje ...
26 Mar 20 ŠencurŠencur Apl Arne Tabor 69Arne Tabor ...
28 Mar 20 PrimorjePrimorje Apl Bled HirterBled Hirter ...
28 Mar 20 ND Adria MirenAdria Miren Apl NK ŽiriNK Žiri ...
Ver jornada
Jornada 18
04 Abr 20 Brinje-GrosupljeBrinje-Gros Apl ND Adria MirenAdria Miren ...
04 Abr 20 NK ŽiriNK Žiri Apl PrimorjePrimorje ...
04 Abr 20 Bled HirterBled Hirter Apl ŠencurŠencur ...
04 Abr 20 Arne Tabor 69Arne Tabor Apl Ilirija 1911Ilirija ...
04 Abr 20 KočevjeKočevje Apl Svoboda LjubljanaSvoboda ...
04 Abr 20 Fama VipavaFama Vipava Apl Sava KranjSava Kranj ...
04 Abr 20 NK TolminNK Tolmin Apl MNK IzolaMNK Izola ...
Ver jornada
Jornada 19
11 Abr 20 NK TolminNK Tolmin Apl Brinje-GrosupljeBrinje-Gros ...
11 Abr 20 MNK IzolaMNK Izola Apl Fama VipavaFama Vipava ...
11 Abr 20 Sava KranjSava Kranj Apl KočevjeKočevje ...
11 Abr 20 Svoboda LjubljanaSvoboda Apl Arne Tabor 69Arne Tabor ...
11 Abr 20 Ilirija 1911Ilirija Apl Bled HirterBled Hirter ...
11 Abr 20 ŠencurŠencur Apl NK ŽiriNK Žiri ...
11 Abr 20 PrimorjePrimorje Apl ND Adria MirenAdria Miren ...
Ver jornada
Jornada 20
18 Abr 20 Brinje-GrosupljeBrinje-Gros Apl PrimorjePrimorje ...
18 Abr 20 ND Adria MirenAdria Miren Apl ŠencurŠencur ...
18 Abr 20 NK ŽiriNK Žiri Apl Ilirija 1911Ilirija ...
18 Abr 20 Bled HirterBled Hirter Apl Svoboda LjubljanaSvoboda ...
18 Abr 20 Arne Tabor 69Arne Tabor Apl Sava KranjSava Kranj ...
18 Abr 20 KočevjeKočevje Apl MNK IzolaMNK Izola ...
18 Abr 20 Fama VipavaFama Vipava Apl NK TolminNK Tolmin ...
Ver jornada
Jornada 21
25 Abr 20 Fama VipavaFama Vipava Apl Brinje-GrosupljeBrinje-Gros ...
25 Abr 20 NK TolminNK Tolmin Apl KočevjeKočevje ...
25 Abr 20 MNK IzolaMNK Izola Apl Arne Tabor 69Arne Tabor ...
25 Abr 20 Sava KranjSava Kranj Apl Bled HirterBled Hirter ...
25 Abr 20 Svoboda LjubljanaSvoboda Apl NK ŽiriNK Žiri ...
25 Abr 20 Ilirija 1911Ilirija Apl ND Adria MirenAdria Miren ...
25 Abr 20 ŠencurŠencur Apl PrimorjePrimorje ...
Ver jornada
Jornada 22
02 May 20 Brinje-GrosupljeBrinje-Gros Apl ŠencurŠencur ...
02 May 20 PrimorjePrimorje Apl Ilirija 1911Ilirija ...
02 May 20 ND Adria MirenAdria Miren Apl Svoboda LjubljanaSvoboda ...
02 May 20 NK ŽiriNK Žiri Apl Sava KranjSava Kranj ...
02 May 20 Bled HirterBled Hirter Apl MNK IzolaMNK Izola ...
02 May 20 Arne Tabor 69Arne Tabor Apl NK TolminNK Tolmin ...
02 May 20 KočevjeKočevje Apl Fama VipavaFama Vipava ...
Ver jornada
Jornada 23
09 May 20 KočevjeKočevje Apl Brinje-GrosupljeBrinje-Gros ...
09 May 20 Fama VipavaFama Vipava Apl Arne Tabor 69Arne Tabor ...
09 May 20 NK TolminNK Tolmin Apl Bled HirterBled Hirter ...
09 May 20 MNK IzolaMNK Izola Apl NK ŽiriNK Žiri ...
09 May 20 Sava KranjSava Kranj Apl ND Adria MirenAdria Miren ...
09 May 20 Svoboda LjubljanaSvoboda Apl PrimorjePrimorje ...
09 May 20 Ilirija 1911Ilirija Apl ŠencurŠencur ...
Ver jornada
Jornada 24
16 May 20 Brinje-GrosupljeBrinje-Gros Apl Ilirija 1911Ilirija ...
16 May 20 ŠencurŠencur Apl Svoboda LjubljanaSvoboda ...
16 May 20 PrimorjePrimorje Apl Sava KranjSava Kranj ...
16 May 20 ND Adria MirenAdria Miren Apl MNK IzolaMNK Izola ...
16 May 20 NK ŽiriNK Žiri Apl NK TolminNK Tolmin ...
16 May 20 Bled HirterBled Hirter Apl Fama VipavaFama Vipava ...
16 May 20 Arne Tabor 69Arne Tabor Apl KočevjeKočevje ...
Ver jornada
Jornada 25
23 May 20 Arne Tabor 69Arne Tabor Apl Brinje-GrosupljeBrinje-Gros ...
23 May 20 KočevjeKočevje Apl Bled HirterBled Hirter ...
23 May 20 Fama VipavaFama Vipava Apl NK ŽiriNK Žiri ...
23 May 20 NK TolminNK Tolmin Apl ND Adria MirenAdria Miren ...
23 May 20 MNK IzolaMNK Izola Apl PrimorjePrimorje ...
23 May 20 Sava KranjSava Kranj Apl ŠencurŠencur ...
23 May 20 Svoboda LjubljanaSvoboda Apl Ilirija 1911Ilirija ...
Ver jornada
Jornada 26
30 May 20 Brinje-GrosupljeBrinje-Gros Apl Svoboda LjubljanaSvoboda ...
30 May 20 Ilirija 1911Ilirija Apl Sava KranjSava Kranj ...
30 May 20 ŠencurŠencur Apl MNK IzolaMNK Izola ...
30 May 20 PrimorjePrimorje Apl NK TolminNK Tolmin ...
30 May 20 ND Adria MirenAdria Miren Apl Fama VipavaFama Vipava ...
30 May 20 NK ŽiriNK Žiri Apl KočevjeKočevje ...
30 May 20 Bled HirterBled Hirter Apl Arne Tabor 69Arne Tabor ...

Clasificación

Equipo PJ GF GC Puntos
1 Bled Hirter Bled Hirter 0 0 0 0
2 Arne Tabor 69 Arne Tabor 0 0 0 0
3 Kočevje Kočevje 0 0 0 0
4 Fama Vipava Fama Vipava 0 0 0 0
5 NK Tolmin NK Tolmin 0 0 0 0
6 MNK Izola MNK Izola 0 0 0 0
7 Brinje-Grosuplje Brinje-Grosu 0 0 0 0
8 Svoboda Ljubljana Svoboda 0 0 0 0
9 Ilirija 1911 Ilirija 1911 0 0 0 0
10 Šencur Šencur 0 0 0 0
11 Primorje Primorje 0 0 0 0
12 ND Adria Miren Adria Miren 0 0 0 0
13 NK Žiri NK Žiri 0 0 0 0
14 Sava Kranj Sava Kranj 0 0 0 0

  USO DE MEMORIA  
5,956,864 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.3977
Total Execution Time  0.3997
  CADENA URL  
/tercera_eslovenia2020/grupo1/calendario
  GET DATOS  
$_GET['/tercera_eslovenia2020/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0144  SELECT type FROM routes WHERE alias = 'tercera_eslovenia2020'
0.0293  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera_eslovenia' 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.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1603 AND type_rel = 3
0.0145  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1603 ORDER BY order_id ASC
0.0146  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 = 50427 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0153  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 = 50427 ORDER BY round ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 18:38:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 18:38:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 18:38:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 18:38:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0152  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera_eslovenia' 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.0149  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 = 50427 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50427 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.0153  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 = 50427 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50427 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0155  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 = 50427 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50427 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0193  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 = 50427 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC