4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Kurilovec
TEMPORADA 2023/2024
TERCERA CROACIA 3. NL GRUPO 3
Equipo PJ GF GC Puntos
1 Segesta Segesta 17 37 19 33
2 Lučko Lučko 17 24 14 31
3 NK Trešnjevka Trešnjevka 17 34 26 30
4 Kurilovec Kurilovec 17 30 25 30
5 NK Maksimir NK Maksimir 17 39 22 29
6 Gaj Mače Gaj Mače 16 29 20 29
7 Dinamo OO Dinamo OO 17 25 27 29
8 Lukavec Lukavec 17 27 25 28
9 Vrapče Vrapče 17 32 28 27
10 NK Ponikve NK Ponikve 17 22 26 25
11 NK HASK Zagreb HASK Zagreb 17 30 29 19
12 Zagorec Zagorec 16 25 24 19
13 Samobor Samobor 17 18 26 19
14 Bistra Bistra 17 21 30 19
15 Tondach Bedekovcina Tondach 17 27 38 16
16 Petrinja Petrinja 17 16 31 16
17 NK Zelina NK Zelina 17 31 41 15
18 Sava Strmec Sava Strmec 17 13 29 13
TEMPORADA 2022/2023
TERCERA CROACIA 3. NL GRUPO 1
Equipo PJ GF GC Puntos
1 NK Karlovac 1919 Karlovac 34 79 12 87
2 NK Maksimir NK Maksimir 34 73 48 68
3 Vrapče Vrapče 34 61 31 65
4 Lučko Lučko 34 60 46 58
5 Samobor Samobor 34 52 41 54
6 NK Ponikve NK Ponikve 34 48 48 53
7 Segesta Segesta 34 57 40 48
8 Sava Strmec Sava Strmec 34 43 59 47
9 NK Trešnjevka Trešnjevka 34 52 59 46
10 Lukavec Lukavec 34 37 49 43
11 Gaj Mače Gaj Mače 34 52 61 42
12 Kurilovec Kurilovec 34 38 51 40
13 NK HASK Zagreb HASK Zagreb 34 42 60 40
14 Petrinja Petrinja 34 49 61 39
15 Bistra Bistra 34 44 63 38
16 Dinamo OO Dinamo OO 34 55 67 37
17 Tekstilac Ravnice Tekstilac 34 36 50 36
18 Vrbovec Vrbovec 34 39 71 24
TEMPORADA 2021/2022
TERCERA CROACIA 3. NL GRUPO 1
Equipo PJ GF GC Puntos
1 Zagorec Zagorec 34 82 38 78
2 NK Dugo Selo Dugo Selo 34 61 31 68
3 NK Trnje NK Trnje 34 64 43 63
4 NK Karlovac 1919 Karlovac 34 68 24 62
5 Lučko Lučko 34 65 36 61
6 NK Maksimir NK Maksimir 34 55 40 57
7 Vrbovec Vrbovec 34 56 59 49
8 Tekstilac Ravnice Tekstilac 34 37 42 47
9 Gaj Mače Gaj Mače 34 53 51 46
10 NK HASK Zagreb HASK Zagreb 34 46 45 45
11 Vrapče Vrapče 34 56 48 43
12 Bistra Bistra 34 53 56 41
13 Kurilovec Kurilovec 34 39 44 36
14 Lukavec Lukavec 34 37 69 33
15 NK Trešnjevka Trešnjevka 34 53 78 29
16 NK Ponikve NK Ponikve 34 32 53 28
17 Segesta Segesta 34 33 76 26
18 Petrinja Petrinja 34 32 89 25
TEMPORADA 2020/2021
TERCERA CROACIA 3. NL GRUPO 1
Equipo PJ GF GC Puntos
1 NK Jarun NK Jarun 33 78 34 76
2 NK Trnje NK Trnje 32 60 24 70
3 Kurilovec Kurilovec 33 66 48 62
4 Zagorec Zagorec 32 65 60 54
5 Lučko Lučko 33 45 42 47
6 NK Ponikve NK Ponikve 33 48 50 47
7 Bistra Bistra 33 59 50 45
8 NK Karlovac 1919 Karlovac 33 43 43 45
9 NK Dugo Selo Dugo Selo 33 47 54 45
10 Gaj Mače Gaj Mače 32 58 54 44
11 NK Trešnjevka Trešnjevka 33 45 58 44
12 NK Maksimir NK Maksimir 33 65 68 41
13 Segesta Segesta 32 43 57 37
14 NK HASK Zagreb HASK Zagreb 33 36 59 36
15 Vrapče Vrapče 33 52 68 34
16 Petrinja Petrinja 33 42 58 34
17 Vrbovec Vrbovec 33 52 58 33
18 NK Špansko NK Špansko 33 42 61 30
TEMPORADA 2019/2020
TERCERA CROACIA 3. NL GRUPO 1
Equipo PJ GF GC Puntos
1 Vinogradar Vinogradar 17 33 15 40
2 Kurilovec Kurilovec 17 28 18 33
3 Petrinja Petrinja 17 29 25 33
4 NK Maksimir NK Maksimir 17 31 27 28
5 Zagorec Zagorec 17 22 22 27
6 NK Jarun NK Jarun 17 30 24 23
7 NK Ponikve NK Ponikve 17 22 20 23
8 Lučko Lučko 17 23 23 23
9 Gaj Mače Gaj Mače 17 27 24 22
10 Vrapče Vrapče 17 24 26 20
11 Vrbovec Vrbovec 17 25 27 18
12 Bistra Donja Bistra Donja 17 18 21 18
13 NK Špansko NK Špansko 17 18 25 17
14 NK Trnje NK Trnje 17 23 30 16
15 NK Dugo Selo Dugo Selo 17 21 28 16
16 NK HASK Zagreb HASK Zagreb 17 13 32 15
TEMPORADA 2018/2019
TERCERA CROACIA 3. NL GRUPO 3
Equipo PJ GF GC Puntos
1 Vinogradar Vinogradar 34 93 37 80
2 Dubrava Tim kabel Dubrava 34 82 36 74
3 HNK Orijent Rijeka Orijent 34 72 47 68
4 NK Trnje NK Trnje 34 61 41 58
5 Kurilovec Kurilovec 34 64 41 55
6 NK HASK Zagreb HASK Zagreb 34 52 42 51
7 NK Dugo Selo Dugo Selo 34 49 60 50
8 NK Opatija NK Opatija 34 55 50 48
9 Jadran Jadran 34 55 61 47
10 Krk Krk 34 52 54 45
11 NK Ponikve NK Ponikve 34 42 56 44
12 Vrbovec Vrbovec 34 48 61 43
13 NK Maksimir NK Maksimir 34 54 58 42
14 Zagorec Zagorec 34 55 60 40
15 NK Špansko NK Špansko 34 47 75 38
16 NK Jarun NK Jarun 34 46 62 37
17 Novigrad Novigrad 34 50 66 33
18 NK Zagreb NK Zagreb 34 26 96 15
TEMPORADA 2017/2018
TERCERA CROACIA 3. NL GRUPO 1
Equipo PJ GF GC Puntos
1 Vinogradar Vinogradar 34 73 26 74
2 NK Opatija NK Opatija 34 55 28 69
3 Dubrava Tim kabel Dubrava 34 65 45 61
4 Vrbovec Vrbovec 34 53 38 58
5 Zagorec Zagorec 34 64 56 55
6 NK Maksimir NK Maksimir 34 57 50 49
7 Kurilovec Kurilovec 34 54 52 49
8 Krk Krk 34 45 54 45
9 NK Zagreb NK Zagreb 34 46 51 44
10 NK Trnje NK Trnje 34 52 57 42
11 NK HASK Zagreb HASK Zagreb 34 63 56 41
12 Jadran Jadran 34 46 49 41
13 NK Špansko NK Špansko 34 43 52 41
14 NK Dugo Selo Dugo Selo 34 38 49 41
15 NK Pazinka NK Pazinka 34 40 51 40
16 Vrapče Vrapče 34 52 54 39
17 NK Rudar Labin Rudar Labin 34 31 69 33
18 Segesta Segesta 34 36 76 31
TEMPORADA 2013/2014
TERCERA CROACIA 3. NL GRUPO 2
Equipo PJ GF GC Puntos
1 NK Maksimir NK Maksimir 30 59 40 59
2 NK Dugo Selo Dugo Selo 30 64 30 58
3 Bistra Donja Bistra Donja 30 49 21 58
4 Stupnik Stupnik 30 63 38 54
5 Vrbovec Vrbovec 30 49 26 54
6 Zagorec Zagorec 30 54 39 54
7 NK Trnje NK Trnje 30 63 38 53
8 Dubrava Tim kabel Dubrava 30 55 34 48
9 NK HASK Zagreb HASK Zagreb 30 47 30 46
10 Vrapče Vrapče 30 34 26 45
11 NK Špansko NK Špansko 30 41 67 35
12 Samobor Samobor 30 40 49 33
13 Kurilovec Kurilovec 30 29 48 28
14 NK Libertas NK Libertas 30 38 79 20
15 Klas Micevec Klas Micevec 30 19 59 18
16 NK Karlovac 1919 Karlovac 30 13 93 4
TEMPORADA 2012/2013
TERCERA CROACIA 3. NL GRUPO 3
Equipo PJ GF GC Puntos
1 Segesta Segesta 30 80 35 68
2 NK Dugo Selo Dugo Selo 30 60 32 58
3 NK Trnje NK Trnje 30 62 45 53
4 Vrapče Vrapče 30 41 26 51
5 Samobor Samobor 30 46 36 48
6 Stupnik Stupnik 30 53 50 46
7 Bistra Donja Bistra Donja 30 37 37 46
8 Kurilovec Kurilovec 30 53 39 44
9 NK Maksimir NK Maksimir 30 39 36 44
10 Dubrava Tim kabel Dubrava 30 41 32 42
11 Vrbovec Vrbovec 30 48 53 39
12 Tekstilac Ravnice Tekstilac 30 37 46 38
13 Lekenik Lekenik 30 35 45 36
14 NK Trešnjevka Trešnjevka 30 24 52 23
15 Gaj Mače Gaj Mače 30 22 67 19
16 Sava Strmec Sava Strmec 30 29 76 11

  USO DE MEMORIA  
5,900,264 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.4875
Total Execution Time  0.4888
  CADENA URL  
/historico/Udranik-Karilovec
  GET DATOS  
$_GET['/historico/Udranik-Karilovec']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0134  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Udranik-Karilovec' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=86958 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=86958 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0269  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 73586
0.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=86958 AND type_rel = 2
0.0137  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '86958' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0143  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '86958' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0136  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 73586 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=86958 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0125  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (73586) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 73586 AND teamId = 86958
0.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` 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 = 73586 AND t.round = 17 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '86958' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '86958' and rp.type = 4
0.0126  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '86958' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0128  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73586 WHERE rp.league_id = 73586 AND rp.teamId = 86958 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73586 WHERE rp.league_id = 73586 AND rp.teamId = 86958 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73586 WHERE rp.league_id = 73586 AND rp.teamId = 86958 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0127  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 86958 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0130  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` 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 = 73586 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(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 = 68851 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(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 = 64041 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2021` 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 = 58549 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(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 = 51148 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(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 = 44727 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2018` 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 = 39730 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2014` 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 = 24834 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2013` 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 = 24823 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 73586 ORDER BY nameShow LIMIT 100