4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
20 Jul 19 HNK GoricaHNK Gorica 1 - 1 Inter ZapresicInter 3
19 Jul 19 NK OsijekNK Osijek 2 - 0 NK Slaven BelupoSlaven 2
19 Jul 19 Dinamo ZagrebDinamo 3 - 0 LokomotivaLokomotiva 7
20 Jul 19 HNK RijekaHNK Rijeka 2 - 1 NK VarazdinVarazdin 5
21 Jul 19 HNK Hajduk SplitHajduk 2 - 0 NK Istra 1961Istra 1961 16
Ver jornada
Jornada 2
26 Jul 19 Inter ZapresicInter 0 - 2 NK Istra 1961Istra 1961 13
28 Jul 19 NK VarazdinVarazdin 0 - 3 HNK Hajduk SplitHajduk 1
27 Jul 19 LokomotivaLokomotiva 0 - 1 HNK RijekaHNK Rijeka 12
27 Jul 19 NK Slaven BelupoSlaven 0 - 3 Dinamo ZagrebDinamo ...
28 Jul 19 HNK GoricaHNK Gorica 3 - 1 NK OsijekNK Osijek ...
Ver jornada
Jornada 3
04 Ago 19 NK OsijekNK Osijek 3 - 1 Inter ZapresicInter 9
02 Ago 19 Dinamo ZagrebDinamo 3 - 1 HNK GoricaHNK Gorica 10
03 Ago 19 HNK RijekaHNK Rijeka 3 - 1 NK Slaven BelupoSlaven 2
04 Ago 19 HNK Hajduk SplitHajduk 3 - 0 LokomotivaLokomotiva 2
03 Ago 19 NK Istra 1961Istra 1961 3 - 1 NK VarazdinVarazdin ...
Ver jornada
Jornada 4
10 Ago 19 Inter ZapresicInter 2 - 2 NK VarazdinVarazdin 2
10 Ago 19 LokomotivaLokomotiva 4 - 1 NK Istra 1961Istra 1961 1
11 Ago 19 NK Slaven BelupoSlaven 2 - 1 HNK Hajduk SplitHajduk 7
11 Ago 19 HNK GoricaHNK Gorica 2 - 0 HNK RijekaHNK Rijeka 1
09 Ago 19 NK OsijekNK Osijek 0 - 0 Dinamo ZagrebDinamo 45
Ver jornada
Jornada 5
16 Ago 19 Inter ZapresicInter 1 - 2 Dinamo ZagrebDinamo 12
18 Ago 19 HNK RijekaHNK Rijeka 1 - 1 NK OsijekNK Osijek 8
18 Ago 19 HNK Hajduk SplitHajduk 3 - 0 HNK GoricaHNK Gorica ...
17 Ago 19 NK Istra 1961Istra 1961 2 - 3 NK Slaven BelupoSlaven ...
17 Ago 19 NK VarazdinVarazdin 1 - 1 LokomotivaLokomotiva ...
Ver jornada
Jornada 6
25 Ago 19 Inter ZapresicInter 1 - 2 LokomotivaLokomotiva 1
24 Ago 19 NK Slaven BelupoSlaven 1 - 1 NK VarazdinVarazdin ...
25 Ago 19 HNK GoricaHNK Gorica 1 - 1 NK Istra 1961Istra 1961 4
25 Ago 19 NK OsijekNK Osijek 1 - 0 HNK Hajduk SplitHajduk 2
18 Dic 19 Dinamo ZagrebDinamo 3 - 0 HNK RijekaHNK Rijeka 12
Ver jornada
Jornada 7
01 Sep 19 HNK RijekaHNK Rijeka 1 - 1 Inter ZapresicInter 7
31 Ago 19 HNK Hajduk SplitHajduk 1 - 0 Dinamo ZagrebDinamo 7
31 Ago 19 NK Istra 1961Istra 1961 0 - 0 NK OsijekNK Osijek ...
01 Sep 19 NK VarazdinVarazdin 1 - 3 HNK GoricaHNK Gorica ...
30 Ago 19 LokomotivaLokomotiva 6 - 1 NK Slaven BelupoSlaven 1
Ver jornada
Jornada 8
14 Sep 19 Inter ZapresicInter 3 - 1 NK Slaven BelupoSlaven ...
14 Sep 19 HNK GoricaHNK Gorica 0 - 0 LokomotivaLokomotiva ...
15 Sep 19 NK OsijekNK Osijek 2 - 2 NK VarazdinVarazdin 1
13 Sep 19 Dinamo ZagrebDinamo 1 - 0 NK Istra 1961Istra 1961 22
15 Sep 19 HNK RijekaHNK Rijeka 1 - 1 HNK Hajduk SplitHajduk 5
Ver jornada
Jornada 9
22 Sep 19 HNK Hajduk SplitHajduk 3 - 1 Inter ZapresicInter 2
22 Sep 19 NK Istra 1961Istra 1961 0 - 3 HNK RijekaHNK Rijeka ...
21 Sep 19 NK VarazdinVarazdin 1 - 0 Dinamo ZagrebDinamo 13
20 Sep 19 LokomotivaLokomotiva 2 - 1 NK OsijekNK Osijek 12
21 Sep 19 NK Slaven BelupoSlaven 2 - 0 HNK GoricaHNK Gorica ...
Ver jornada
Jornada 10
29 Sep 19 Inter ZapresicInter 0 - 2 HNK GoricaHNK Gorica 1
28 Sep 19 NK Slaven BelupoSlaven 0 - 4 NK OsijekNK Osijek ...
27 Sep 19 LokomotivaLokomotiva 0 - 4 Dinamo ZagrebDinamo 13
28 Sep 19 NK VarazdinVarazdin 0 - 2 HNK RijekaHNK Rijeka ...
29 Sep 19 NK Istra 1961Istra 1961 1 - 1 HNK Hajduk SplitHajduk 1
Ver jornada
Jornada 11
04 Oct 19 NK Istra 1961Istra 1961 2 - 2 Inter ZapresicInter 2
05 Oct 19 HNK Hajduk SplitHajduk 2 - 0 NK VarazdinVarazdin 3
06 Oct 19 HNK RijekaHNK Rijeka 1 - 1 LokomotivaLokomotiva 6
05 Oct 19 Dinamo ZagrebDinamo 1 - 0 NK Slaven BelupoSlaven 4
05 Oct 19 NK OsijekNK Osijek 2 - 1 HNK GoricaHNK Gorica ...
Ver jornada
Jornada 12
20 Oct 19 Inter ZapresicInter 3 - 3 NK OsijekNK Osijek ...
18 Oct 19 HNK GoricaHNK Gorica 2 - 4 Dinamo ZagrebDinamo 8
19 Oct 19 NK Slaven BelupoSlaven 1 - 2 HNK RijekaHNK Rijeka 2
20 Oct 19 LokomotivaLokomotiva 0 - 0 HNK Hajduk SplitHajduk 2
19 Oct 19 NK VarazdinVarazdin 1 - 0 NK Istra 1961Istra 1961 ...
Ver jornada
Jornada 13
25 Oct 19 NK VarazdinVarazdin 0 - 1 Inter ZapresicInter 2
27 Oct 19 NK Istra 1961Istra 1961 0 - 2 LokomotivaLokomotiva ...
26 Oct 19 HNK Hajduk SplitHajduk 2 - 0 NK Slaven BelupoSlaven 4
26 Oct 19 HNK RijekaHNK Rijeka 1 - 2 HNK GoricaHNK Gorica 4
27 Oct 19 Dinamo ZagrebDinamo 1 - 0 NK OsijekNK Osijek 2
Ver jornada
Jornada 14
02 Nov 19 Dinamo ZagrebDinamo 1 - 0 Inter ZapresicInter 5
03 Nov 19 NK OsijekNK Osijek 3 - 2 HNK RijekaHNK Rijeka ...
02 Nov 19 HNK GoricaHNK Gorica 2 - 1 HNK Hajduk SplitHajduk 4
03 Nov 19 NK Slaven BelupoSlaven 0 - 0 NK Istra 1961Istra 1961 ...
04 Nov 19 LokomotivaLokomotiva 2 - 1 NK VarazdinVarazdin 5
Ver jornada
Jornada 15
09 Nov 19 LokomotivaLokomotiva 3 - 1 Inter ZapresicInter ...
09 Nov 19 NK VarazdinVarazdin 0 - 0 NK Slaven BelupoSlaven ...
08 Nov 19 NK Istra 1961Istra 1961 2 - 2 HNK GoricaHNK Gorica 4
10 Nov 19 HNK Hajduk SplitHajduk 3 - 2 NK OsijekNK Osijek ...
10 Nov 19 HNK RijekaHNK Rijeka 0 - 5 Dinamo ZagrebDinamo 1
Ver jornada
Jornada 16
24 Nov 19 Inter ZapresicInter 1 - 4 HNK RijekaHNK Rijeka 2
22 Nov 19 Dinamo ZagrebDinamo 1 - 1 HNK Hajduk SplitHajduk 58
24 Nov 19 NK OsijekNK Osijek 1 - 0 NK Istra 1961Istra 1961 2
23 Nov 19 HNK GoricaHNK Gorica 1 - 0 NK VarazdinVarazdin 2
23 Nov 19 NK Slaven BelupoSlaven 1 - 0 LokomotivaLokomotiva ...
Ver jornada
Jornada 17
29 Nov 19 NK Slaven BelupoSlaven 3 - 0 Inter ZapresicInter 4
29 Nov 19 LokomotivaLokomotiva 4 - 0 HNK GoricaHNK Gorica 5
30 Nov 19 NK VarazdinVarazdin 1 - 1 NK OsijekNK Osijek ...
30 Nov 19 NK Istra 1961Istra 1961 1 - 2 Dinamo ZagrebDinamo 2
01 Dic 19 HNK Hajduk SplitHajduk 0 - 4 HNK RijekaHNK Rijeka ...
Ver jornada
Jornada 18
07 Dic 19 Inter ZapresicInter 1 - 1 HNK Hajduk SplitHajduk ...
08 Dic 19 HNK RijekaHNK Rijeka 2 - 0 NK Istra 1961Istra 1961 2
06 Dic 19 Dinamo ZagrebDinamo 1 - 0 NK VarazdinVarazdin 55
08 Dic 19 NK OsijekNK Osijek 4 - 0 LokomotivaLokomotiva 1
07 Dic 19 HNK GoricaHNK Gorica 2 - 0 NK Slaven BelupoSlaven 1
Ver jornada
Jornada 19
13 Dic 19 HNK GoricaHNK Gorica 1 - 1 Inter ZapresicInter 13
15 Dic 19 NK OsijekNK Osijek 3 - 2 NK Slaven BelupoSlaven ...
14 Dic 19 Dinamo ZagrebDinamo 1 - 0 LokomotivaLokomotiva 6
14 Dic 19 HNK RijekaHNK Rijeka 3 - 1 NK VarazdinVarazdin 1
15 Dic 19 HNK Hajduk SplitHajduk 2 - 1 NK Istra 1961Istra 1961 2
Ver jornada
Jornada 20
31 Ene 20 Inter ZapresicInter 2 - 0 NK Istra 1961Istra 1961 5
02 Feb 20 NK VarazdinVarazdin 0 - 3 HNK Hajduk SplitHajduk ...
01 Feb 20 LokomotivaLokomotiva 2 - 1 HNK RijekaHNK Rijeka ...
01 Feb 20 NK Slaven BelupoSlaven 0 - 2 Dinamo ZagrebDinamo 4
02 Feb 20 HNK GoricaHNK Gorica 0 - 0 NK OsijekNK Osijek ...
Ver jornada
Jornada 21
08 Feb 20 NK OsijekNK Osijek 1 - 1 Inter ZapresicInter 5
09 Feb 20 Dinamo ZagrebDinamo 2 - 0 HNK GoricaHNK Gorica 9
09 Feb 20 HNK RijekaHNK Rijeka 1 - 0 NK Slaven BelupoSlaven ...
08 Feb 20 HNK Hajduk SplitHajduk 1 - 0 LokomotivaLokomotiva ...
07 Feb 20 NK Istra 1961Istra 1961 1 - 0 NK VarazdinVarazdin 7
Ver jornada
Jornada 22
15 Feb 20 Inter ZapresicInter 1 - 2 NK VarazdinVarazdin 2
14 Feb 20 LokomotivaLokomotiva 2 - 0 NK Istra 1961Istra 1961 4
15 Feb 20 NK Slaven BelupoSlaven 2 - 1 HNK Hajduk SplitHajduk ...
16 Feb 20 HNK GoricaHNK Gorica 0 - 0 HNK RijekaHNK Rijeka 15
16 Feb 20 NK OsijekNK Osijek 1 - 0 Dinamo ZagrebDinamo 9
Ver jornada
Jornada 23
23 Feb 20 Dinamo ZagrebDinamo 3 - 2 Inter ZapresicInter 3
22 Feb 20 HNK RijekaHNK Rijeka 1 - 0 NK OsijekNK Osijek 2
22 Feb 20 HNK Hajduk SplitHajduk 6 - 0 HNK GoricaHNK Gorica ...
23 Feb 20 NK Istra 1961Istra 1961 1 - 1 NK Slaven BelupoSlaven 1
21 Feb 20 NK VarazdinVarazdin 0 - 2 LokomotivaLokomotiva 3
Ver jornada
Jornada 24
27 Feb 20 Inter ZapresicInter 0 - 2 LokomotivaLokomotiva 14
28 Feb 20 NK Slaven BelupoSlaven 0 - 0 NK VarazdinVarazdin 4
28 Feb 20 HNK GoricaHNK Gorica 3 - 0 NK Istra 1961Istra 1961 8
29 Feb 20 NK OsijekNK Osijek 0 - 0 HNK Hajduk SplitHajduk ...
29 Feb 20 Dinamo ZagrebDinamo 4 - 0 HNK RijekaHNK Rijeka 3
Ver jornada
Jornada 25
03 Mar 20 HNK RijekaHNK Rijeka 4 - 1 Inter ZapresicInter 1
04 Mar 20 HNK Hajduk SplitHajduk 0 - 2 Dinamo ZagrebDinamo 11
04 Mar 20 NK Istra 1961Istra 1961 1 - 0 NK OsijekNK Osijek 20
04 Mar 20 NK VarazdinVarazdin 2 - 2 HNK GoricaHNK Gorica 4
03 Mar 20 LokomotivaLokomotiva 3 - 0 NK Slaven BelupoSlaven 16
Ver jornada
Jornada 26
07 Mar 20 Inter ZapresicInter 0 - 2 NK Slaven BelupoSlaven ...
09 Mar 20 HNK GoricaHNK Gorica 1 - 3 LokomotivaLokomotiva 7
07 Mar 20 NK OsijekNK Osijek 2 - 0 NK VarazdinVarazdin 1
08 Mar 20 Dinamo ZagrebDinamo 2 - 0 NK Istra 1961Istra 1961 10
08 Mar 20 HNK RijekaHNK Rijeka 2 - 0 HNK Hajduk SplitHajduk 2
Ver jornada
Jornada 27
05 Jun 20 HNK Hajduk SplitHajduk 2 - 1 Inter ZapresicInter 33
07 Jun 20 NK Istra 1961Istra 1961 1 - 3 HNK RijekaHNK Rijeka 12
06 Jun 20 NK VarazdinVarazdin 1 - 3 Dinamo ZagrebDinamo 21
07 Jun 20 LokomotivaLokomotiva 0 - 1 NK OsijekNK Osijek 27
06 Jun 20 NK Slaven BelupoSlaven 0 - 0 HNK GoricaHNK Gorica 8
Ver jornada
Jornada 28
11 Jun 20 Inter ZapresicInter 0 - 3 HNK GoricaHNK Gorica 30
13 Jun 20 NK Slaven BelupoSlaven 0 - 0 NK OsijekNK Osijek 7
12 Jun 20 LokomotivaLokomotiva 1 - 0 Dinamo ZagrebDinamo 23
12 Jun 20 NK VarazdinVarazdin 0 - 0 HNK RijekaHNK Rijeka 28
11 Jun 20 NK Istra 1961Istra 1961 0 - 1 HNK Hajduk SplitHajduk 20
Ver jornada
Jornada 29
16 Jun 20 NK Istra 1961Istra 1961 2 - 0 Inter ZapresicInter ...
16 Jun 20 HNK Hajduk SplitHajduk 2 - 3 NK VarazdinVarazdin 54
16 Jun 20 HNK RijekaHNK Rijeka 2 - 2 LokomotivaLokomotiva 11
17 Jun 20 Dinamo ZagrebDinamo 3 - 2 NK Slaven BelupoSlaven 21
17 Jun 20 NK OsijekNK Osijek 2 - 1 HNK GoricaHNK Gorica 1
Ver jornada
Jornada 30
20 Jun 20 Inter ZapresicInter 0 - 1 NK OsijekNK Osijek 5
20 Jun 20 HNK GoricaHNK Gorica 0 - 0 Dinamo ZagrebDinamo 27
21 Jun 20 NK Slaven BelupoSlaven 1 - 0 HNK RijekaHNK Rijeka 4
21 Jun 20 LokomotivaLokomotiva 3 - 2 HNK Hajduk SplitHajduk 16
20 Jun 20 NK VarazdinVarazdin 3 - 0 NK Istra 1961Istra 1961 ...
Ver jornada
Jornada 31
25 Jun 20 NK VarazdinVarazdin 1 - 0 Inter ZapresicInter 5
25 Jun 20 NK Istra 1961Istra 1961 1 - 1 LokomotivaLokomotiva 22
26 Jun 20 HNK Hajduk SplitHajduk 2 - 1 NK Slaven BelupoSlaven 2
26 Jun 20 HNK RijekaHNK Rijeka 1 - 2 HNK GoricaHNK Gorica 32
27 Jun 20 Dinamo ZagrebDinamo 0 - 0 NK OsijekNK Osijek 19
Ver jornada
Jornada 32
01 Jul 20 Inter ZapresicInter 0 - 1 Dinamo ZagrebDinamo 8
01 Jul 20 NK OsijekNK Osijek 1 - 0 HNK RijekaHNK Rijeka 8
30 Jun 20 HNK GoricaHNK Gorica 3 - 1 HNK Hajduk SplitHajduk 3
30 Jun 20 NK Slaven BelupoSlaven 3 - 0 NK Istra 1961Istra 1961 2
30 Jun 20 LokomotivaLokomotiva 2 - 0 NK VarazdinVarazdin 13
Ver jornada
Jornada 33
04 Jul 20 LokomotivaLokomotiva 3 - 1 Inter ZapresicInter 33
04 Jul 20 NK VarazdinVarazdin 1 - 0 NK Slaven BelupoSlaven 4
04 Jul 20 NK Istra 1961Istra 1961 2 - 2 HNK GoricaHNK Gorica ...
05 Jul 20 HNK Hajduk SplitHajduk 0 - 1 NK OsijekNK Osijek 2
05 Jul 20 HNK RijekaHNK Rijeka 2 - 0 Dinamo ZagrebDinamo 8
Ver jornada
Jornada 34
11 Jul 20 Inter ZapresicInter 0 - 1 HNK RijekaHNK Rijeka 8
12 Jul 20 Dinamo ZagrebDinamo 2 - 3 HNK Hajduk SplitHajduk 4
11 Jul 20 NK OsijekNK Osijek 2 - 0 NK Istra 1961Istra 1961 7
10 Jul 20 HNK GoricaHNK Gorica 0 - 1 NK VarazdinVarazdin 15
12 Jul 20 NK Slaven BelupoSlaven 1 - 1 LokomotivaLokomotiva 11
Ver jornada
Jornada 35
17 Jul 20 NK Slaven BelupoSlaven 3 - 1 Inter ZapresicInter 3
19 Jul 20 LokomotivaLokomotiva 1 - 1 HNK GoricaHNK Gorica 11
18 Jul 20 NK VarazdinVarazdin 1 - 0 NK OsijekNK Osijek 9
18 Jul 20 NK Istra 1961Istra 1961 0 - 0 Dinamo ZagrebDinamo 27
19 Jul 20 HNK Hajduk SplitHajduk 2 - 3 HNK RijekaHNK Rijeka 3
Ver jornada
Jornada 36
25 Jul 20 Inter ZapresicInter 1 - 4 HNK Hajduk SplitHajduk 3
25 Jul 20 HNK RijekaHNK Rijeka 4 - 2 NK Istra 1961Istra 1961 3
24 Jul 20 Dinamo ZagrebDinamo 2 - 0 NK VarazdinVarazdin 11
25 Jul 20 NK OsijekNK Osijek 1 - 2 LokomotivaLokomotiva 8
24 Jul 20 HNK GoricaHNK Gorica 0 - 0 NK Slaven BelupoSlaven 7

Clasificación

Equipo PJ GF GC Puntos
1 Dinamo Zagreb Dinamo 36 62 20 80
2 Lokomotiva Lokomotiva 36 57 38 65
3 HNK Rijeka HNK Rijeka 36 58 42 64
4 NK Osijek NK Osijek 36 47 29 62
5 HNK Hajduk Split Hajduk Split 36 60 41 60
6 HNK Gorica HNK Gorica 36 44 48 49
7 NK Slaven Belupo Slaven 36 34 51 39
8 NK Varazdin NK Varazdin 36 29 50 36
9 NK Istra 1961 Istra 1961 36 27 59 25
10 Inter Zapresic Inter 36 32 72 17

  USO DE MEMORIA  
6,023,136 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1486
Total Execution Time  0.1505
  CADENA URL  
/croacia2020/grupo1/calendario
  GET DATOS  
$_GET['/croacia2020/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0017  SELECT type FROM routes WHERE alias = 'croacia2020'
0.0043  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 = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=100 AND type_rel = 3
0.0029  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 100 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1309625,1298184,1296183,1294805,1286371) ORDER BY n.cover_points DESC, update_date DESC
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 = 49969 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0042  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 = 49969 ORDER BY round ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 14:26:48' 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-27 14:26:48' 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-27 14:26:48' 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-27 14:26:48' 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 = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0134  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 = 49969 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 49969 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.0216  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 = 49969 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 49969 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0031  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 = 49969 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 49969 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0027  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 = 49969 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