4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del NK Karlovac 1919
TEMPORADA 2023/2024
SEGUNDA CROACIA 2. NL
Equipo PJ GF GC Puntos
1 NK Opatija NK Opatija 25 42 18 55
2 NK Križevci Križevci 25 44 21 51
3 NK Karlovac 1919 Karlovac 25 37 29 47
4 NK Kustošija Kustošija 25 47 22 46
5 Mladost Ždralovi Mladost 25 47 22 45
6 NK Jadran LP Jadran 25 35 21 40
7 Marsonia Marsonia 25 44 43 37
8 NK Dugo Selo Dugo Selo 25 31 31 30
9 Bjelovar Bjelovar 25 40 44 30
10 Hrvace Hrvace 25 37 48 29
11 NK Trnje NK Trnje 25 27 42 29
12 Grobničan Grobničan 25 36 35 26
13 Hrvatski Dragovoljac Hrvatski 25 25 41 26
14 Jadran Jadran 25 29 48 24
15 Krk Krk 25 20 36 23
16 Belisce Belisce 25 16 56 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 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 2011/2012
LIGA CROATA HNL
Equipo PJ GF GC Puntos
1 Dinamo Zagreb Dinamo 30 73 11 75
2 HNK Hajduk Split Hajduk Split 30 50 24 54
3 NK Slaven Belupo Slaven 30 41 27 52
4 Split Split 30 43 32 50
5 HNK Cibalia HNK Cibalia 30 35 35 45
6 NK Zagreb NK Zagreb 30 36 42 45
7 Lokomotiva Lokomotiva 30 33 33 44
8 NK Osijek NK Osijek 30 45 38 43
9 NK Istra 1961 Istra 1961 30 35 33 42
10 Zadar Zadar 30 29 44 40
11 Inter Zapresic Inter 30 33 33 38
12 HNK Rijeka HNK Rijeka 30 29 29 38
13 Lučko Lučko 30 29 36 31
14 HNK Sibenik HNK Sibenik 30 27 39 27
15 NK Karlovac 1919 Karlovac 30 25 53 24
16 NK Varazdin NK Varazdin 30 16 70 8
TEMPORADA 2010/2011
LIGA CROATA HNL
Equipo PJ GF GC Puntos
1 Dinamo Zagreb Dinamo 30 52 12 72
2 HNK Hajduk Split Hajduk Split 30 54 32 55
3 Split Split 30 38 22 53
4 HNK Cibalia HNK Cibalia 30 33 24 44
5 Inter Zapresic Inter 30 31 35 42
6 NK Karlovac 1919 Karlovac 30 25 27 41
7 NK Slaven Belupo Slaven 30 34 30 40
8 NK Osijek NK Osijek 30 31 29 39
9 HNK Rijeka HNK Rijeka 30 29 35 39
10 Zadar Zadar 30 31 34 38
11 NK Varazdin NK Varazdin 30 32 38 36
12 HNK Sibenik HNK Sibenik 30 37 38 35
13 NK Zagreb NK Zagreb 30 32 39 35
14 Lokomotiva Lokomotiva 30 24 37 33
15 NK Istra 1961 Istra 1961 30 24 44 31
16 Hrvatski Dragovoljac Hrvatski 30 24 55 23
TEMPORADA 2009/2010
LIGA CROATA HNL
Equipo PJ GF GC Puntos
1 Dinamo Zagreb Dinamo 30 70 20 62
2 HNK Hajduk Split Hajduk Split 30 50 21 58
3 HNK Cibalia HNK Cibalia 30 46 20 57
4 HNK Sibenik HNK Sibenik 30 34 37 50
5 NK Osijek NK Osijek 30 49 36 47
6 NK Karlovac 1919 Karlovac 30 32 23 47
7 NK Slaven Belupo Slaven 30 44 45 43
8 Lokomotiva Lokomotiva 30 35 38 42
9 HNK Rijeka HNK Rijeka 30 49 44 40
10 NK Varazdin NK Varazdin 30 36 43 36
11 NK Istra 1961 Istra 1961 30 31 40 35
12 Zadar Zadar 30 27 41 34
13 NK Zagreb NK Zagreb 30 43 49 33
14 Inter Zapresic Inter 30 36 50 33
15 Medjimurje Cakovec Medjimurje 30 37 61 29
16 NK Croatia Sesvete Croatia 30 30 81 14
TEMPORADA 2008/2009
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 NK Istra 1961 Istra 1961 30 46 20 60
2 NK Karlovac 1919 Karlovac 30 50 24 59
3 Lokomotiva Lokomotiva 30 50 30 59
4 Slavonac Slavonac 29 38 16 57
5 Medjimurje Cakovec Medjimurje 30 61 34 50
6 Hrvatski Dragovoljac Hrvatski 30 38 36 49
7 NK Solin NK Solin 30 37 31 47
8 Vinogradar Vinogradar 30 40 50 40
9 Imotski Imotski 30 31 45 34
10 Suhopolje Suhopolje 30 33 37 33
11 Segesta Segesta 30 33 47 33
12 Junak Sinj Junak Sinj 30 35 51 33
13 Mosor Mosor 30 25 44 30
14 Pomorac Pomorac 29 27 44 29
15 Moslavina Moslavina 30 33 51 28
16 Trogir Trogir 30 32 49 21

  USO DE MEMORIA  
6,239,456 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.4238
Total Execution Time  0.4251
  CADENA URL  
/historico/Karlovac
  GET DATOS  
$_GET['/historico/Karlovac']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0213  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 = 72477
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3979 AND type_rel = 2
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2677 AND type_rel = 3
0.0111  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 = '3979' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0110  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 = 72477 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0121  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=3979 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0115  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 (73205,72477,72000,71432,68851) 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.0119  SELECT count(id) as num_players from rel_players WHERE league_id = 72477 AND teamId = 3979
0.0111  SELECT count(id) as num_players from rel_players WHERE league_id = 68851 AND teamId = 3979
0.0113  SELECT count(id) as num_players from rel_players WHERE league_id = 73205 AND teamId = 3979
0.0105  SELECT count(id) as num_players from rel_players WHERE league_id = 72000 AND teamId = 3979
0.0111  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 3979
0.0109  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 = 72477 AND t.round = 25 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0107  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 = '3979' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '3979' and rp.type = 4
0.0107  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 = '3979' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0112  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 = 72477 WHERE rp.league_id = 72477 AND rp.teamId = 3979 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.0108  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 = 72477 WHERE rp.league_id = 72477 AND rp.teamId = 3979 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0110  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 = 72477 WHERE rp.league_id = 72477 AND rp.teamId = 3979 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0109  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 = 3979 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0110  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 = 72477 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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.0112  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.0111  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.0109  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.0110  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 `tables2012` 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 = 1342 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 `tables2011` 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 = 1069 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  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 `tables2010` 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 = 875 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 `tables2009` 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 = 8708 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC