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 Jul 22 NK Istra 1961Istra 1961 0 - 2 HNK Hajduk SplitHajduk 4
17 Jul 22 NK VarazdinVarazdin 0 - 1 NK Slaven BelupoSlaven 10
15 Jul 22 Dinamo ZagrebDinamo 3 - 2 LokomotivaLokomotiva 97
16 Jul 22 NK OsijekNK Osijek 2 - 1 HNK GoricaHNK Gorica 10
16 Jul 22 HNK SibenikSibenik 0 - 1 HNK RijekaHNK Rijeka 11
Ver jornada
Jornada 2
14 Sep 22 HNK Hajduk SplitHajduk 2 - 0 HNK RijekaHNK Rijeka 19
23 Jul 22 HNK GoricaHNK Gorica 0 - 0 HNK SibenikSibenik 14
24 Jul 22 LokomotivaLokomotiva 2 - 1 NK OsijekNK Osijek 6
23 Jul 22 NK Slaven BelupoSlaven 1 - 5 Dinamo ZagrebDinamo 13
22 Jul 22 NK Istra 1961Istra 1961 1 - 2 NK VarazdinVarazdin 34
Ver jornada
Jornada 3
29 Jul 22 Dinamo ZagrebDinamo 4 - 1 NK Istra 1961Istra 1961 22
31 Jul 22 NK OsijekNK Osijek 0 - 0 NK Slaven BelupoSlaven 9
30 Jul 22 NK VarazdinVarazdin 0 - 2 HNK Hajduk SplitHajduk 5
29 Jul 22 HNK SibenikSibenik 2 - 1 LokomotivaLokomotiva 30
31 Jul 22 HNK RijekaHNK Rijeka 1 - 1 HNK GoricaHNK Gorica 3
Ver jornada
Jornada 4
05 Ago 22 NK VarazdinVarazdin 1 - 1 Dinamo ZagrebDinamo 121
07 Ago 22 LokomotivaLokomotiva 3 - 1 HNK RijekaHNK Rijeka 1
06 Ago 22 NK Istra 1961Istra 1961 1 - 0 NK OsijekNK Osijek 2
06 Ago 22 NK Slaven BelupoSlaven 0 - 0 HNK SibenikSibenik 3
26 Oct 22 HNK Hajduk SplitHajduk 3 - 1 HNK GoricaHNK Gorica 25
Ver jornada
Jornada 5
13 Ago 22 Dinamo ZagrebDinamo 4 - 1 HNK Hajduk SplitHajduk 29
14 Ago 22 NK OsijekNK Osijek 2 - 2 NK VarazdinVarazdin 3
12 Ago 22 HNK SibenikSibenik 0 - 0 NK Istra 1961Istra 1961 21
14 Ago 22 HNK RijekaHNK Rijeka 0 - 1 NK Slaven BelupoSlaven 7
13 Ago 22 HNK GoricaHNK Gorica 3 - 2 LokomotivaLokomotiva 2
Ver jornada
Jornada 6
20 Ago 22 Dinamo ZagrebDinamo 5 - 2 NK OsijekNK Osijek 9
21 Ago 22 HNK Hajduk SplitHajduk 2 - 1 LokomotivaLokomotiva 3
19 Ago 22 NK Slaven BelupoSlaven 2 - 1 HNK GoricaHNK Gorica 3
21 Ago 22 NK Istra 1961Istra 1961 1 - 1 HNK RijekaHNK Rijeka 11
20 Ago 22 NK VarazdinVarazdin 2 - 2 HNK SibenikSibenik ...
Ver jornada
Jornada 7
28 Ago 22 NK OsijekNK Osijek 2 - 1 HNK Hajduk SplitHajduk 2
28 Ago 22 HNK SibenikSibenik 1 - 2 Dinamo ZagrebDinamo 27
27 Ago 22 HNK RijekaHNK Rijeka 1 - 2 NK VarazdinVarazdin 8
26 Ago 22 HNK GoricaHNK Gorica 0 - 2 NK Istra 1961Istra 1961 14
27 Ago 22 LokomotivaLokomotiva 0 - 1 NK Slaven BelupoSlaven 2
Ver jornada
Jornada 8
02 Sep 22 Dinamo ZagrebDinamo 3 - 1 HNK RijekaHNK Rijeka 44
03 Sep 22 NK OsijekNK Osijek 1 - 1 HNK SibenikSibenik 7
03 Sep 22 NK VarazdinVarazdin 2 - 1 HNK GoricaHNK Gorica 1
04 Sep 22 HNK Hajduk SplitHajduk 5 - 1 NK Slaven BelupoSlaven 5
04 Sep 22 NK Istra 1961Istra 1961 1 - 2 LokomotivaLokomotiva 4
Ver jornada
Jornada 9
10 Sep 22 HNK RijekaHNK Rijeka 0 - 3 NK OsijekNK Osijek ...
10 Sep 22 HNK GoricaHNK Gorica 0 - 1 Dinamo ZagrebDinamo 144
09 Sep 22 HNK SibenikSibenik 1 - 1 HNK Hajduk SplitHajduk 25
11 Sep 22 NK Slaven BelupoSlaven 0 - 3 NK Istra 1961Istra 1961 4
11 Sep 22 LokomotivaLokomotiva 1 - 2 NK VarazdinVarazdin 18
Ver jornada
Jornada 10
18 Sep 22 LokomotivaLokomotiva 1 - 2 Dinamo ZagrebDinamo 6
18 Sep 22 HNK RijekaHNK Rijeka 0 - 0 HNK SibenikSibenik 3
17 Sep 22 HNK Hajduk SplitHajduk 2 - 2 NK Istra 1961Istra 1961 5
16 Sep 22 NK Slaven BelupoSlaven 1 - 0 NK VarazdinVarazdin 5
17 Sep 22 HNK GoricaHNK Gorica 0 - 1 NK OsijekNK Osijek 2
Ver jornada
Jornada 11
02 Oct 22 HNK RijekaHNK Rijeka 0 - 1 HNK Hajduk SplitHajduk 1
01 Oct 22 Dinamo ZagrebDinamo 4 - 1 NK Slaven BelupoSlaven 23
30 Sep 22 NK VarazdinVarazdin 1 - 1 NK Istra 1961Istra 1961 16
01 Oct 22 NK OsijekNK Osijek 4 - 1 LokomotivaLokomotiva ...
02 Oct 22 HNK SibenikSibenik 1 - 1 HNK GoricaHNK Gorica 1
Ver jornada
Jornada 12
09 Oct 22 NK Slaven BelupoSlaven 0 - 4 NK OsijekNK Osijek ...
08 Oct 22 HNK Hajduk SplitHajduk 2 - 1 NK VarazdinVarazdin 8
15 Mar 23 NK Istra 1961Istra 1961 1 - 0 Dinamo ZagrebDinamo 157
07 Oct 22 LokomotivaLokomotiva 1 - 1 HNK SibenikSibenik 53
09 Oct 22 HNK GoricaHNK Gorica 0 - 2 HNK RijekaHNK Rijeka ...
Ver jornada
Jornada 13
16 Oct 22 Dinamo ZagrebDinamo 3 - 1 NK VarazdinVarazdin 70
15 Oct 22 NK OsijekNK Osijek 2 - 0 NK Istra 1961Istra 1961 ...
14 Oct 22 HNK SibenikSibenik 0 - 2 NK Slaven BelupoSlaven 9
15 Oct 22 HNK GoricaHNK Gorica 0 - 1 HNK Hajduk SplitHajduk 20
16 Oct 22 HNK RijekaHNK Rijeka 3 - 0 LokomotivaLokomotiva ...
Ver jornada
Jornada 14
21 Oct 22 HNK Hajduk SplitHajduk 1 - 1 Dinamo ZagrebDinamo 235
22 Oct 22 NK VarazdinVarazdin 4 - 1 NK OsijekNK Osijek 3
23 Oct 22 NK Istra 1961Istra 1961 0 - 0 HNK SibenikSibenik 11
23 Oct 22 NK Slaven BelupoSlaven 2 - 1 HNK RijekaHNK Rijeka ...
22 Oct 22 LokomotivaLokomotiva 2 - 1 HNK GoricaHNK Gorica 3
Ver jornada
Jornada 15
29 Oct 22 NK OsijekNK Osijek 1 - 0 Dinamo ZagrebDinamo 35
28 Oct 22 HNK SibenikSibenik 1 - 2 NK VarazdinVarazdin 55
29 Oct 22 HNK RijekaHNK Rijeka 0 - 1 NK Istra 1961Istra 1961 6
30 Oct 22 LokomotivaLokomotiva 2 - 2 HNK Hajduk SplitHajduk 20
31 Oct 22 HNK GoricaHNK Gorica 1 - 1 NK Slaven BelupoSlaven 11
Ver jornada
Jornada 16
05 Nov 22 HNK Hajduk SplitHajduk 3 - 1 NK OsijekNK Osijek 7
06 Nov 22 Dinamo ZagrebDinamo 3 - 0 HNK SibenikSibenik 4
06 Nov 22 NK VarazdinVarazdin 0 - 3 HNK RijekaHNK Rijeka ...
04 Nov 22 NK Istra 1961Istra 1961 1 - 0 HNK GoricaHNK Gorica 65
05 Nov 22 NK Slaven BelupoSlaven 0 - 0 LokomotivaLokomotiva 2
Ver jornada
Jornada 17
12 Nov 22 NK Slaven BelupoSlaven 2 - 2 HNK Hajduk SplitHajduk 14
12 Nov 22 LokomotivaLokomotiva 2 - 0 NK Istra 1961Istra 1961 4
18 Ene 23 HNK GoricaHNK Gorica 0 - 0 NK VarazdinVarazdin 43
13 Nov 22 HNK RijekaHNK Rijeka 2 - 7 Dinamo ZagrebDinamo 8
13 Nov 22 HNK SibenikSibenik 0 - 2 NK OsijekNK Osijek 3
Ver jornada
Jornada 18
21 Ene 23 NK OsijekNK Osijek 1 - 1 HNK RijekaHNK Rijeka 4
22 Ene 23 HNK Hajduk SplitHajduk 2 - 1 HNK SibenikSibenik 12
21 Ene 23 Dinamo ZagrebDinamo 0 - 0 HNK GoricaHNK Gorica 195
22 Ene 23 NK VarazdinVarazdin 0 - 0 LokomotivaLokomotiva 1
20 Ene 23 NK Istra 1961Istra 1961 0 - 0 NK Slaven BelupoSlaven 55
Ver jornada
Jornada 19
29 Ene 23 NK Istra 1961Istra 1961 3 - 0 HNK Hajduk SplitHajduk 35
28 Ene 23 Dinamo ZagrebDinamo 2 - 1 LokomotivaLokomotiva 22
29 Ene 23 NK OsijekNK Osijek 2 - 0 HNK GoricaHNK Gorica 1
28 Ene 23 HNK SibenikSibenik 1 - 2 HNK RijekaHNK Rijeka 1
27 Ene 23 NK VarazdinVarazdin 1 - 0 NK Slaven BelupoSlaven 13
Ver jornada
Jornada 20
05 Feb 23 HNK Hajduk SplitHajduk 1 - 2 HNK RijekaHNK Rijeka 14
04 Feb 23 NK Slaven BelupoSlaven 1 - 1 Dinamo ZagrebDinamo 54
04 Feb 23 LokomotivaLokomotiva 1 - 0 NK OsijekNK Osijek 3
05 Feb 23 HNK GoricaHNK Gorica 0 - 3 HNK SibenikSibenik ...
03 Feb 23 NK Istra 1961Istra 1961 2 - 1 NK VarazdinVarazdin 27
Ver jornada
Jornada 21
10 Feb 23 Dinamo ZagrebDinamo 1 - 0 NK Istra 1961Istra 1961 359
11 Feb 23 NK VarazdinVarazdin 1 - 4 HNK Hajduk SplitHajduk 8
12 Feb 23 HNK RijekaHNK Rijeka 2 - 0 HNK GoricaHNK Gorica 20
11 Feb 23 NK OsijekNK Osijek 0 - 0 NK Slaven BelupoSlaven ...
12 Feb 23 HNK SibenikSibenik 0 - 4 LokomotivaLokomotiva 1
Ver jornada
Jornada 22
19 Feb 23 HNK Hajduk SplitHajduk 2 - 1 HNK GoricaHNK Gorica 26
18 Feb 23 LokomotivaLokomotiva 1 - 2 HNK RijekaHNK Rijeka 2
17 Feb 23 NK Slaven BelupoSlaven 0 - 1 HNK SibenikSibenik 61
19 Feb 23 NK VarazdinVarazdin 1 - 3 Dinamo ZagrebDinamo 17
18 Feb 23 NK Istra 1961Istra 1961 1 - 0 NK OsijekNK Osijek 3
Ver jornada
Jornada 23
26 Feb 23 Dinamo ZagrebDinamo 4 - 0 HNK Hajduk SplitHajduk 6
26 Feb 23 NK OsijekNK Osijek 0 - 1 NK VarazdinVarazdin 2
24 Feb 23 HNK SibenikSibenik 0 - 0 NK Istra 1961Istra 1961 20
25 Feb 23 HNK RijekaHNK Rijeka 0 - 1 NK Slaven BelupoSlaven 11
25 Feb 23 HNK GoricaHNK Gorica 1 - 0 LokomotivaLokomotiva 11
Ver jornada
Jornada 24
05 Mar 23 Dinamo ZagrebDinamo 1 - 1 NK OsijekNK Osijek 116
05 Mar 23 HNK Hajduk SplitHajduk 3 - 4 LokomotivaLokomotiva 24
04 Mar 23 NK Slaven BelupoSlaven 1 - 1 HNK GoricaHNK Gorica 4
04 Mar 23 NK VarazdinVarazdin 2 - 0 HNK SibenikSibenik 2
03 Mar 23 NK Istra 1961Istra 1961 0 - 2 HNK RijekaHNK Rijeka 18
Ver jornada
Jornada 25
12 Mar 23 NK OsijekNK Osijek 0 - 2 HNK Hajduk SplitHajduk 1
11 Mar 23 HNK SibenikSibenik 2 - 1 Dinamo ZagrebDinamo 119
12 Mar 23 HNK RijekaHNK Rijeka 3 - 1 NK VarazdinVarazdin 5
10 Mar 23 HNK GoricaHNK Gorica 5 - 4 NK Istra 1961Istra 1961 66
11 Mar 23 LokomotivaLokomotiva 1 - 0 NK Slaven BelupoSlaven 5
Ver jornada
Jornada 26
19 Mar 23 Dinamo ZagrebDinamo 1 - 0 HNK RijekaHNK Rijeka 24
18 Mar 23 HNK Hajduk SplitHajduk 1 - 0 NK Slaven BelupoSlaven 36
19 Mar 23 NK Istra 1961Istra 1961 0 - 0 LokomotivaLokomotiva 7
17 Mar 23 NK VarazdinVarazdin 2 - 1 HNK GoricaHNK Gorica 44
18 Mar 23 NK OsijekNK Osijek 0 - 0 HNK SibenikSibenik 1
Ver jornada
Jornada 27
01 Abr 23 HNK GoricaHNK Gorica 1 - 1 Dinamo ZagrebDinamo 49
02 Abr 23 HNK RijekaHNK Rijeka 1 - 1 NK OsijekNK Osijek 1
01 Abr 23 HNK SibenikSibenik 2 - 3 HNK Hajduk SplitHajduk 3
02 Abr 23 LokomotivaLokomotiva 1 - 1 NK VarazdinVarazdin 6
31 Mar 23 NK Slaven BelupoSlaven 2 - 0 NK Istra 1961Istra 1961 8
Ver jornada
Jornada 28
07 Abr 23 HNK Hajduk SplitHajduk 2 - 2 NK Istra 1961Istra 1961 58
07 Abr 23 NK Slaven BelupoSlaven 1 - 1 NK VarazdinVarazdin 1
08 Abr 23 LokomotivaLokomotiva 1 - 2 Dinamo ZagrebDinamo 32
08 Abr 23 HNK GoricaHNK Gorica 2 - 0 NK OsijekNK Osijek 6
08 Abr 23 HNK RijekaHNK Rijeka 1 - 0 HNK SibenikSibenik 11
Ver jornada
Jornada 29
16 Abr 23 HNK RijekaHNK Rijeka 2 - 0 HNK Hajduk SplitHajduk 2
15 Abr 23 Dinamo ZagrebDinamo 4 - 0 NK Slaven BelupoSlaven 11
15 Abr 23 NK OsijekNK Osijek 2 - 2 LokomotivaLokomotiva 1
14 Abr 23 HNK SibenikSibenik 0 - 4 HNK GoricaHNK Gorica 10
16 Abr 23 NK VarazdinVarazdin 0 - 0 NK Istra 1961Istra 1961 2
Ver jornada
Jornada 30
22 Abr 23 HNK Hajduk SplitHajduk 2 - 0 NK VarazdinVarazdin 7
21 Abr 23 NK Slaven BelupoSlaven 2 - 1 NK OsijekNK Osijek 29
21 Abr 23 LokomotivaLokomotiva 1 - 0 HNK SibenikSibenik 36
23 Abr 23 HNK GoricaHNK Gorica 1 - 0 HNK RijekaHNK Rijeka 1
22 Abr 23 NK Istra 1961Istra 1961 0 - 0 Dinamo ZagrebDinamo 12
Ver jornada
Jornada 31
27 Abr 23 HNK RijekaHNK Rijeka 2 - 0 LokomotivaLokomotiva 57
26 Abr 23 NK OsijekNK Osijek 1 - 0 NK Istra 1961Istra 1961 70
25 Abr 23 HNK SibenikSibenik 3 - 1 NK Slaven BelupoSlaven 11
26 Abr 23 HNK GoricaHNK Gorica 0 - 0 HNK Hajduk SplitHajduk 37
26 Abr 23 Dinamo ZagrebDinamo 2 - 0 NK VarazdinVarazdin 70
Ver jornada
Jornada 32
30 Abr 23 HNK Hajduk SplitHajduk 0 - 0 Dinamo ZagrebDinamo 16
30 Abr 23 NK VarazdinVarazdin 1 - 3 NK OsijekNK Osijek ...
29 Abr 23 NK Istra 1961Istra 1961 3 - 0 HNK SibenikSibenik ...
01 May 23 NK Slaven BelupoSlaven 1 - 3 HNK RijekaHNK Rijeka 4
01 May 23 LokomotivaLokomotiva 2 - 2 HNK GoricaHNK Gorica 9
Ver jornada
Jornada 33
06 May 23 HNK GoricaHNK Gorica 0 - 0 NK Slaven BelupoSlaven ...
05 May 23 HNK SibenikSibenik 0 - 2 NK VarazdinVarazdin 15
06 May 23 HNK RijekaHNK Rijeka 2 - 2 NK Istra 1961Istra 1961 12
07 May 23 NK OsijekNK Osijek 0 - 0 Dinamo ZagrebDinamo 30
07 May 23 LokomotivaLokomotiva 0 - 3 HNK Hajduk SplitHajduk 20
Ver jornada
Jornada 34
13 May 23 HNK Hajduk SplitHajduk 3 - 0 NK OsijekNK Osijek 1
14 May 23 Dinamo ZagrebDinamo 4 - 0 HNK SibenikSibenik 9
14 May 23 NK VarazdinVarazdin 2 - 0 HNK RijekaHNK Rijeka ...
13 May 23 NK Istra 1961Istra 1961 1 - 0 HNK GoricaHNK Gorica 4
12 May 23 NK Slaven BelupoSlaven 0 - 0 LokomotivaLokomotiva 26
Ver jornada
Jornada 35
19 May 23 NK Slaven BelupoSlaven 0 - 1 HNK Hajduk SplitHajduk 15
21 May 23 HNK RijekaHNK Rijeka 1 - 2 Dinamo ZagrebDinamo 23
20 May 23 HNK GoricaHNK Gorica 5 - 2 NK VarazdinVarazdin ...
21 May 23 LokomotivaLokomotiva 3 - 1 NK Istra 1961Istra 1961 ...
19 May 23 HNK SibenikSibenik 1 - 4 NK OsijekNK Osijek 14
Ver jornada
Jornada 36
28 May 23 HNK Hajduk SplitHajduk 3 - 0 HNK SibenikSibenik 10
27 May 23 NK OsijekNK Osijek 1 - 1 HNK RijekaHNK Rijeka 3
28 May 23 Dinamo ZagrebDinamo 4 - 1 HNK GoricaHNK Gorica 11
26 May 23 NK VarazdinVarazdin 0 - 0 LokomotivaLokomotiva 41
27 May 23 NK Istra 1961Istra 1961 1 - 1 NK Slaven BelupoSlaven 4

Clasificación

Equipo PJ GF GC Puntos
1 Dinamo Zagreb Dinamo 36 81 28 81
2 HNK Hajduk Split Hajduk Split 36 65 41 71
3 NK Osijek NK Osijek 36 46 41 50
4 HNK Rijeka HNK Rijeka 36 44 44 49
5 NK Istra 1961 Istra 1961 36 36 38 46
6 NK Varazdin NK Varazdin 36 41 51 46
7 Lokomotiva Lokomotiva 36 45 50 43
8 NK Slaven Belupo Slaven 36 27 46 43
9 HNK Gorica HNK Gorica 36 36 50 32
10 HNK Sibenik HNK Sibenik 36 24 56 27

  USO DE MEMORIA  
6,044,608 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1862
Total Execution Time  0.1882
  CADENA URL  
/croacia2023/grupo1/calendario
  GET DATOS  
$_GET['/croacia2023/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0022  SELECT type FROM routes WHERE alias = 'croacia2023'
0.0053  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'croacia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0024  SELECT id,name,alias,stepParent FROM categories WHERE parentId=100 ORDER BY order_id ASC
0.0031  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 = 67813 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0072  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 calendars2023 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 67813 ORDER BY round ASC
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 03:55:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0026  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 03:55:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 03:55:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 03:55:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0035  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'croacia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0416  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 events2023 e ON e.player_id = p.id AND e.league_id = 67813 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 67813 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.0321  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 events2023 e ON e.player_id = p.id AND e.league_id = 67813 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 67813 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0033  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 events2023 e ON e.player_id = p.id AND e.league_id = 67813 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 67813 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0032  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` 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 = 67813 AND t.round = 36 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC