4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jornada 1
17 Jul 21 HNK RijekaHNK Rijeka 2 - 0 HNK GoricaHNK Gorica 4
18 Jul 21 NK Istra 1961Istra 1961 3 - 1 Hrvatski DragovoljacHrvatski 7
16 Jul 21 Dinamo ZagrebDinamo 0 - 2 NK Slaven BelupoSlaven 110
17 Jul 21 LokomotivaLokomotiva 2 - 2 HNK Hajduk SplitHajduk 2
16 Jul 21 NK OsijekNK Osijek 3 - 0 HNK SibenikSibenik 20
Jornada 2
24 Jul 21 HNK GoricaHNK Gorica 3 - 1 HNK SibenikSibenik 6
25 Jul 21 HNK Hajduk SplitHajduk 1 - 2 NK OsijekNK Osijek 1
24 Jul 21 NK Slaven BelupoSlaven 1 - 2 LokomotivaLokomotiva 5
23 Jul 21 Hrvatski DragovoljacHrvatski 0 - 4 Dinamo ZagrebDinamo 6
25 Jul 21 HNK RijekaHNK Rijeka 2 - 0 NK Istra 1961Istra 1961 5
Jornada 3
31 Jul 21 NK Istra 1961Istra 1961 1 - 2 HNK GoricaHNK Gorica 1
01 Ago 21 Dinamo ZagrebDinamo 3 - 3 HNK RijekaHNK Rijeka 28
30 Jul 21 LokomotivaLokomotiva 3 - 2 Hrvatski DragovoljacHrvatski 12
01 Ago 21 NK OsijekNK Osijek 0 - 0 NK Slaven BelupoSlaven 5
01 Ago 21 HNK Hajduk SplitHajduk 1 - 0 HNK SibenikSibenik 5
Jornada 4
07 Ago 21 HNK GoricaHNK Gorica 1 - 3 HNK Hajduk SplitHajduk ...
07 Ago 21 NK Slaven BelupoSlaven 1 - 1 HNK SibenikSibenik 2
08 Ago 21 Hrvatski DragovoljacHrvatski 1 - 2 NK OsijekNK Osijek ...
20 Oct 21 HNK RijekaHNK Rijeka 1 - 2 LokomotivaLokomotiva 16
15 Dic 21 NK Istra 1961Istra 1961 0 - 2 Dinamo ZagrebDinamo 81
Jornada 5
13 Ago 21 Dinamo ZagrebDinamo 1 - 0 HNK GoricaHNK Gorica 29
14 Ago 21 LokomotivaLokomotiva 4 - 0 NK Istra 1961Istra 1961 1
15 Ago 21 NK OsijekNK Osijek 1 - 0 HNK RijekaHNK Rijeka 1
15 Ago 21 HNK SibenikSibenik 6 - 2 Hrvatski DragovoljacHrvatski ...
14 Ago 21 HNK Hajduk SplitHajduk 2 - 0 NK Slaven BelupoSlaven 1
Jornada 6
21 Ago 21 HNK GoricaHNK Gorica 1 - 0 NK Slaven BelupoSlaven ...
20 Ago 21 Hrvatski DragovoljacHrvatski 0 - 1 HNK Hajduk SplitHajduk 15
22 Ago 21 HNK RijekaHNK Rijeka 2 - 1 HNK SibenikSibenik 1
22 Ago 21 NK Istra 1961Istra 1961 2 - 0 NK OsijekNK Osijek 3
21 Ago 21 Dinamo ZagrebDinamo 1 - 0 LokomotivaLokomotiva 38
Jornada 7
28 Ago 21 LokomotivaLokomotiva 0 - 1 HNK GoricaHNK Gorica 1
29 Ago 21 NK OsijekNK Osijek 0 - 2 Dinamo ZagrebDinamo 2
28 Ago 21 HNK SibenikSibenik 3 - 1 NK Istra 1961Istra 1961 ...
29 Ago 21 HNK Hajduk SplitHajduk 1 - 2 HNK RijekaHNK Rijeka 1
27 Ago 21 NK Slaven BelupoSlaven 0 - 1 Hrvatski DragovoljacHrvatski 2
Jornada 8
10 Sep 21 HNK GoricaHNK Gorica 1 - 1 Hrvatski DragovoljacHrvatski 10
11 Sep 21 HNK RijekaHNK Rijeka 2 - 1 NK Slaven BelupoSlaven 8
12 Sep 21 NK Istra 1961Istra 1961 1 - 3 HNK Hajduk SplitHajduk 2
11 Sep 21 Dinamo ZagrebDinamo 2 - 0 HNK SibenikSibenik 19
12 Sep 21 LokomotivaLokomotiva 1 - 1 NK OsijekNK Osijek 2
Jornada 9
19 Sep 21 NK OsijekNK Osijek 3 - 2 HNK GoricaHNK Gorica 2
18 Sep 21 HNK SibenikSibenik 2 - 1 LokomotivaLokomotiva ...
20 Abr 22 HNK Hajduk SplitHajduk 1 - 0 Dinamo ZagrebDinamo 15
18 Sep 21 NK Slaven BelupoSlaven 1 - 1 NK Istra 1961Istra 1961 5
17 Sep 21 Hrvatski DragovoljacHrvatski 2 - 2 HNK RijekaHNK Rijeka 7
Jornada 10
26 Sep 21 HNK GoricaHNK Gorica 3 - 4 HNK RijekaHNK Rijeka 3
27 Sep 21 Hrvatski DragovoljacHrvatski 0 - 1 NK Istra 1961Istra 1961 4
25 Sep 21 NK Slaven BelupoSlaven 1 - 4 Dinamo ZagrebDinamo 2
26 Sep 21 HNK Hajduk SplitHajduk 1 - 0 LokomotivaLokomotiva 3
25 Sep 21 HNK SibenikSibenik 0 - 2 NK OsijekNK Osijek 2
Jornada 11
01 Oct 21 HNK SibenikSibenik 1 - 2 HNK GoricaHNK Gorica 9
03 Oct 21 NK OsijekNK Osijek 1 - 1 HNK Hajduk SplitHajduk ...
02 Oct 21 LokomotivaLokomotiva 3 - 0 NK Slaven BelupoSlaven 1
03 Oct 21 Dinamo ZagrebDinamo 8 - 0 Hrvatski DragovoljacHrvatski 2
02 Oct 21 NK Istra 1961Istra 1961 3 - 6 HNK RijekaHNK Rijeka 2
Jornada 12
16 Oct 21 HNK GoricaHNK Gorica 1 - 1 NK Istra 1961Istra 1961 ...
16 Oct 21 HNK RijekaHNK Rijeka 3 - 3 Dinamo ZagrebDinamo 30
15 Oct 21 Hrvatski DragovoljacHrvatski 2 - 2 LokomotivaLokomotiva 2
17 Oct 21 NK Slaven BelupoSlaven 0 - 2 NK OsijekNK Osijek ...
17 Oct 21 HNK SibenikSibenik 2 - 0 HNK Hajduk SplitHajduk ...
Jornada 13
23 Oct 21 HNK Hajduk SplitHajduk 0 - 0 HNK GoricaHNK Gorica 11
22 Oct 21 HNK SibenikSibenik 1 - 1 NK Slaven BelupoSlaven 5
23 Oct 21 NK OsijekNK Osijek 1 - 0 Hrvatski DragovoljacHrvatski 5
24 Oct 21 LokomotivaLokomotiva 0 - 2 HNK RijekaHNK Rijeka ...
24 Oct 21 Dinamo ZagrebDinamo 1 - 1 NK Istra 1961Istra 1961 85
Jornada 14
30 Oct 21 HNK GoricaHNK Gorica 0 - 2 Dinamo ZagrebDinamo 8
01 Nov 21 NK Istra 1961Istra 1961 2 - 1 LokomotivaLokomotiva 12
08 Dic 21 HNK RijekaHNK Rijeka 0 - 0 NK OsijekNK Osijek 128
30 Oct 21 Hrvatski DragovoljacHrvatski 1 - 1 HNK SibenikSibenik 1
31 Oct 21 NK Slaven BelupoSlaven 3 - 2 HNK Hajduk SplitHajduk ...
Jornada 15
05 Nov 21 NK Slaven BelupoSlaven 1 - 2 HNK GoricaHNK Gorica 4
06 Nov 21 HNK Hajduk SplitHajduk 2 - 0 Hrvatski DragovoljacHrvatski ...
07 Nov 21 HNK SibenikSibenik 0 - 1 HNK RijekaHNK Rijeka 2
06 Nov 21 NK OsijekNK Osijek 3 - 0 NK Istra 1961Istra 1961 ...
07 Nov 21 LokomotivaLokomotiva 1 - 0 Dinamo ZagrebDinamo 30
Jornada 16
21 Nov 21 HNK GoricaHNK Gorica 2 - 2 LokomotivaLokomotiva ...
20 Nov 21 Dinamo ZagrebDinamo 1 - 1 NK OsijekNK Osijek 36
20 Nov 21 NK Istra 1961Istra 1961 3 - 4 HNK SibenikSibenik 1
21 Nov 21 HNK RijekaHNK Rijeka 2 - 3 HNK Hajduk SplitHajduk 3
19 Nov 21 Hrvatski DragovoljacHrvatski 1 - 2 NK Slaven BelupoSlaven 1
Jornada 17
27 Nov 21 Hrvatski DragovoljacHrvatski 0 - 1 HNK GoricaHNK Gorica 19
27 Nov 21 NK Slaven BelupoSlaven 1 - 2 HNK RijekaHNK Rijeka 5
26 Nov 21 HNK Hajduk SplitHajduk 4 - 0 NK Istra 1961Istra 1961 6
28 Nov 21 HNK SibenikSibenik 1 - 2 Dinamo ZagrebDinamo 1
26 Nov 21 NK OsijekNK Osijek 3 - 1 LokomotivaLokomotiva 35
Jornada 18
04 Dic 21 HNK GoricaHNK Gorica 1 - 1 NK OsijekNK Osijek 1
05 Dic 21 LokomotivaLokomotiva 1 - 1 HNK SibenikSibenik 1
05 Dic 21 Dinamo ZagrebDinamo 0 - 2 HNK Hajduk SplitHajduk 31
06 Dic 21 NK Istra 1961Istra 1961 1 - 2 NK Slaven BelupoSlaven 8
04 Dic 21 HNK RijekaHNK Rijeka 4 - 1 Hrvatski DragovoljacHrvatski 1
Jornada 19
11 Dic 21 HNK RijekaHNK Rijeka 1 - 2 HNK GoricaHNK Gorica 18
10 Dic 21 NK Istra 1961Istra 1961 3 - 0 Hrvatski DragovoljacHrvatski 11
12 Dic 21 Dinamo ZagrebDinamo 3 - 0 NK Slaven BelupoSlaven 1
11 Dic 21 LokomotivaLokomotiva 3 - 3 HNK Hajduk SplitHajduk 1
12 Dic 21 NK OsijekNK Osijek 3 - 1 HNK SibenikSibenik 1
Jornada 20
18 Dic 21 HNK GoricaHNK Gorica 2 - 3 HNK SibenikSibenik 12
19 Dic 21 HNK Hajduk SplitHajduk 0 - 0 NK OsijekNK Osijek 16
17 Dic 21 NK Slaven BelupoSlaven 2 - 1 LokomotivaLokomotiva 16
19 Dic 21 Hrvatski DragovoljacHrvatski 0 - 2 Dinamo ZagrebDinamo 22
18 Dic 21 HNK RijekaHNK Rijeka 1 - 0 NK Istra 1961Istra 1961 18
Jornada 21
28 Ene 22 NK Istra 1961Istra 1961 2 - 1 HNK GoricaHNK Gorica 37
30 Ene 22 Dinamo ZagrebDinamo 2 - 0 HNK RijekaHNK Rijeka 96
30 Ene 22 LokomotivaLokomotiva 2 - 1 Hrvatski DragovoljacHrvatski 19
29 Ene 22 NK OsijekNK Osijek 1 - 2 NK Slaven BelupoSlaven 6
29 Ene 22 HNK SibenikSibenik 1 - 3 HNK Hajduk SplitHajduk 1
Jornada 22
05 Feb 22 HNK GoricaHNK Gorica 0 - 4 HNK Hajduk SplitHajduk 4
04 Feb 22 NK Slaven BelupoSlaven 1 - 1 HNK SibenikSibenik 13
06 Feb 22 Hrvatski DragovoljacHrvatski 1 - 3 NK OsijekNK Osijek 1
05 Feb 22 HNK RijekaHNK Rijeka 3 - 2 LokomotivaLokomotiva ...
06 Feb 22 NK Istra 1961Istra 1961 1 - 2 Dinamo ZagrebDinamo 5
Jornada 23
12 Feb 22 Dinamo ZagrebDinamo 2 - 1 HNK GoricaHNK Gorica 14
12 Feb 22 LokomotivaLokomotiva 1 - 1 NK Istra 1961Istra 1961 4
13 Feb 22 NK OsijekNK Osijek 1 - 0 HNK RijekaHNK Rijeka 2
11 Feb 22 HNK SibenikSibenik 0 - 5 Hrvatski DragovoljacHrvatski 60
13 Feb 22 HNK Hajduk SplitHajduk 3 - 1 NK Slaven BelupoSlaven 1
Jornada 24
18 Feb 22 HNK GoricaHNK Gorica 0 - 3 NK Slaven BelupoSlaven 16
19 Feb 22 Hrvatski DragovoljacHrvatski 0 - 3 HNK Hajduk SplitHajduk 1
20 Feb 22 HNK RijekaHNK Rijeka 4 - 2 HNK SibenikSibenik ...
19 Feb 22 NK Istra 1961Istra 1961 2 - 3 NK OsijekNK Osijek 1
20 Feb 22 Dinamo ZagrebDinamo 0 - 0 LokomotivaLokomotiva 28
Jornada 25
26 Feb 22 LokomotivaLokomotiva 2 - 0 HNK GoricaHNK Gorica 1
27 Feb 22 NK OsijekNK Osijek 1 - 0 Dinamo ZagrebDinamo 6
27 Feb 22 HNK SibenikSibenik 2 - 1 NK Istra 1961Istra 1961 ...
26 Feb 22 HNK Hajduk SplitHajduk 1 - 3 HNK RijekaHNK Rijeka 3
25 Feb 22 NK Slaven BelupoSlaven 1 - 0 Hrvatski DragovoljacHrvatski 10
Jornada 26
06 Mar 22 HNK GoricaHNK Gorica 4 - 0 Hrvatski DragovoljacHrvatski ...
05 Mar 22 HNK RijekaHNK Rijeka 3 - 0 NK Slaven BelupoSlaven 22
06 Mar 22 NK Istra 1961Istra 1961 1 - 1 HNK Hajduk SplitHajduk 7
05 Mar 22 Dinamo ZagrebDinamo 3 - 0 HNK SibenikSibenik 2
04 Mar 22 LokomotivaLokomotiva 0 - 0 NK OsijekNK Osijek 63
Jornada 27
13 Mar 22 NK OsijekNK Osijek 0 - 0 HNK GoricaHNK Gorica 16
11 Mar 22 HNK SibenikSibenik 1 - 4 LokomotivaLokomotiva 16
12 Mar 22 HNK Hajduk SplitHajduk 0 - 0 Dinamo ZagrebDinamo 19
12 Mar 22 NK Slaven BelupoSlaven 0 - 0 NK Istra 1961Istra 1961 4
13 Mar 22 Hrvatski DragovoljacHrvatski 2 - 1 HNK RijekaHNK Rijeka 8
Jornada 28
19 Mar 22 HNK GoricaHNK Gorica 1 - 0 HNK RijekaHNK Rijeka 3
18 Mar 22 Hrvatski DragovoljacHrvatski 0 - 0 NK Istra 1961Istra 1961 7
20 Mar 22 NK Slaven BelupoSlaven 0 - 1 Dinamo ZagrebDinamo 18
19 Mar 22 HNK Hajduk SplitHajduk 4 - 0 LokomotivaLokomotiva 4
20 Mar 22 HNK SibenikSibenik 0 - 3 NK OsijekNK Osijek 4
Jornada 29
02 Abr 22 HNK SibenikSibenik 0 - 1 HNK GoricaHNK Gorica ...
03 Abr 22 NK OsijekNK Osijek 0 - 0 HNK Hajduk SplitHajduk 3
04 Abr 22 LokomotivaLokomotiva 3 - 1 NK Slaven BelupoSlaven 53
03 Abr 22 Dinamo ZagrebDinamo 2 - 0 Hrvatski DragovoljacHrvatski 22
02 Abr 22 NK Istra 1961Istra 1961 0 - 2 HNK RijekaHNK Rijeka 1
Jornada 30
08 Abr 22 HNK GoricaHNK Gorica 1 - 1 NK Istra 1961Istra 1961 24
10 Abr 22 HNK RijekaHNK Rijeka 1 - 2 Dinamo ZagrebDinamo 17
09 Abr 22 Hrvatski DragovoljacHrvatski 1 - 1 LokomotivaLokomotiva ...
10 Abr 22 NK Slaven BelupoSlaven 0 - 1 NK OsijekNK Osijek ...
09 Abr 22 HNK Hajduk SplitHajduk 2 - 1 HNK SibenikSibenik 10
Jornada 31
15 Abr 22 HNK Hajduk SplitHajduk 1 - 0 HNK GoricaHNK Gorica 9
16 Abr 22 HNK SibenikSibenik 2 - 1 NK Slaven BelupoSlaven 1
16 Abr 22 NK OsijekNK Osijek 2 - 1 Hrvatski DragovoljacHrvatski ...
16 Abr 22 LokomotivaLokomotiva 2 - 1 HNK RijekaHNK Rijeka 4
15 Abr 22 Dinamo ZagrebDinamo 3 - 0 NK Istra 1961Istra 1961 18
Jornada 32
24 Abr 22 HNK GoricaHNK Gorica 0 - 1 Dinamo ZagrebDinamo 66
23 Abr 22 NK Istra 1961Istra 1961 2 - 2 LokomotivaLokomotiva 4
23 Abr 22 HNK RijekaHNK Rijeka 3 - 1 NK OsijekNK Osijek 8
22 Abr 22 Hrvatski DragovoljacHrvatski 3 - 1 HNK SibenikSibenik 8
24 Abr 22 NK Slaven BelupoSlaven 0 - 0 HNK Hajduk SplitHajduk 12
Jornada 33
30 Abr 22 NK Slaven BelupoSlaven 2 - 1 HNK GoricaHNK Gorica ...
29 Abr 22 HNK Hajduk SplitHajduk 2 - 1 Hrvatski DragovoljacHrvatski 22
30 Abr 22 HNK SibenikSibenik 3 - 5 HNK RijekaHNK Rijeka 1
01 May 22 NK OsijekNK Osijek 2 - 2 NK Istra 1961Istra 1961 36
01 May 22 LokomotivaLokomotiva 1 - 1 Dinamo ZagrebDinamo 10
Jornada 34
07 May 22 HNK GoricaHNK Gorica 3 - 3 LokomotivaLokomotiva 2
08 May 22 Dinamo ZagrebDinamo 3 - 0 NK OsijekNK Osijek 29
07 May 22 NK Istra 1961Istra 1961 1 - 2 HNK SibenikSibenik 5
08 May 22 HNK RijekaHNK Rijeka 0 - 3 HNK Hajduk SplitHajduk 2
06 May 22 Hrvatski DragovoljacHrvatski 1 - 1 NK Slaven BelupoSlaven 10
Jornada 35
13 May 22 Hrvatski DragovoljacHrvatski 0 - 2 HNK GoricaHNK Gorica 15
14 May 22 NK Slaven BelupoSlaven 2 - 2 HNK RijekaHNK Rijeka 13
14 May 22 HNK Hajduk SplitHajduk 3 - 1 NK Istra 1961Istra 1961 2
15 May 22 HNK SibenikSibenik 0 - 2 Dinamo ZagrebDinamo 4
15 May 22 NK OsijekNK Osijek 1 - 0 LokomotivaLokomotiva ...
Jornada 36
21 May 22 HNK GoricaHNK Gorica 1 - 1 NK OsijekNK Osijek 8
20 May 22 LokomotivaLokomotiva 2 - 1 HNK SibenikSibenik 5
21 May 22 Dinamo ZagrebDinamo 3 - 1 HNK Hajduk SplitHajduk 38
20 May 22 NK Istra 1961Istra 1961 3 - 1 NK Slaven BelupoSlaven 29
21 May 22 HNK RijekaHNK Rijeka 1 - 0 Hrvatski DragovoljacHrvatski 14

Clasificación

Equipo PJ GF GC Puntos
1 Dinamo Zagreb Dinamo 36 68 22 79
2 HNK Hajduk Split Hajduk Split 36 64 31 72
3 NK Osijek NK Osijek 36 49 29 69
4 HNK Rijeka HNK Rijeka 36 71 51 65
5 Lokomotiva Lokomotiva 36 55 50 49
6 HNK Gorica HNK Gorica 36 43 50 45
7 NK Slaven Belupo Slaven 36 35 54 36
8 HNK Sibenik HNK Sibenik 36 46 75 32
9 NK Istra 1961 Istra 1961 36 42 67 31
10 Hrvatski Dragovoljac Hrvatski 36 31 75 19

  USO DE MEMORIA  
6,048,008 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1345
Total Execution Time  0.1366
  CADENA URL  
/croacia2022/grupo1/calendario
  GET DATOS  
$_GET['/croacia2022/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0018  SELECT type FROM routes WHERE alias = 'croacia2022'
0.0039  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 = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=100 ORDER BY order_id ASC
0.0019  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 = 63060 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0041  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 = 63060 ORDER BY round ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-25 00:02:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-25 00:02:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-25 00:02:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-25 00:02:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  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 = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0123  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 = 63060 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63060 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.0170  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 = 63060 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63060 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0034  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 = 63060 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63060 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0028  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 = 63060 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