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

Clasificación

Equipo PJ GF GC Puntos
1 Dinamo Zagreb Dinamo 36 74 20 92
2 HNK Rijeka HNK Rijeka 36 70 36 67
3 NK Osijek NK Osijek 36 61 36 62
4 HNK Hajduk Split Hajduk Split 36 59 39 62
5 HNK Gorica HNK Gorica 36 57 46 59
6 Lokomotiva Lokomotiva 36 51 43 49
7 NK Slaven Belupo Slaven 36 41 53 37
8 Inter Zapresic Inter 36 40 84 31
9 NK Istra 1961 Istra 1961 36 31 73 25
10 NK Rudes NK Rudes 36 26 80 14

  USO DE MEMORIA  
6,056,104 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4371
Total Execution Time  0.4390
  CADENA URL  
/croacia2019/grupo1/calendario
  GET DATOS  
$_GET['/croacia2019/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0144  SELECT type FROM routes WHERE alias = 'croacia2019'
0.0292  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 = 2019 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=100 AND type_rel = 3
0.0150  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.0147  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.0145  SELECT id,name,alias,stepParent FROM categories WHERE parentId=100 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 = 43939 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 calendars2019 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 43939 ORDER BY round ASC
0.0148  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 13:26:35' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0147  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 13:26:35' 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-27 13:26:35' 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-27 13:26:35' 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 = 'croacia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2019 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0236  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 events2019 e ON e.player_id = p.id AND e.league_id = 43939 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 43939 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.0257  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 events2019 e ON e.player_id = p.id AND e.league_id = 43939 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 43939 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0156  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 events2019 e ON e.player_id = p.id AND e.league_id = 43939 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 43939 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0155  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2019` 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 = 43939 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC