4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Fužinar
TEMPORADA 2023/2024
SEGUNDA ESLOVENIA 2. SNL
Equipo PJ GF GC Puntos
1 Nafta Lendava Nafta 28 55 27 58
2 Primorje Primorje 28 45 25 56
3 ND Gorica ND Gorica 28 50 25 52
4 Brinje-Grosuplje Brinje-Grosu 28 50 30 51
5 Beltinci Beltinci 28 40 21 50
6 Triglav Kranj Triglav 28 43 29 48
7 Bistrica iz Slovenske Bistrica 28 41 42 41
8 Rudar Velenje Rudar 28 33 44 36
9 NK Tolmin NK Tolmin 28 33 44 32
10 ND Bilje ND Bilje 28 41 50 31
11 Dekani Dekani 28 30 36 30
12 ND Dravinja Kostroj Dravinja 28 27 42 30
13 Ilirija 1911 Ilirija 1911 28 29 42 28
14 NK Krka NK Krka 28 34 49 27
15 Tabor Sežana Tabor 28 36 58 26
16 Fužinar Fužinar 28 30 53 24
TEMPORADA 2022/2023
SEGUNDA ESLOVENIA 2. SNL
Equipo PJ GF GC Puntos
1 NK Rogaška NK Rogaška 30 52 23 68
2 Aluminij Aluminij 30 58 23 64
3 Ilirija 1911 Ilirija 1911 30 55 30 54
4 NK Krka NK Krka 30 46 28 53
5 Beltinci Beltinci 30 47 45 44
6 Nafta Lendava Nafta 30 50 43 41
7 Primorje Primorje 30 42 40 41
8 Brinje-Grosuplje Brinje-Grosu 30 30 37 38
9 Bistrica iz Slovenske Bistrica 30 39 40 37
10 ND Bilje ND Bilje 30 40 53 37
11 Dekani Dekani 30 27 29 35
12 Triglav Kranj Triglav 30 33 52 35
13 Rudar Velenje Rudar 30 41 51 32
14 Fužinar Fužinar 30 39 56 31
15 NK Krsko NK Krsko 30 36 59 24
16 Roltek Dob Roltek Dob 30 37 63 21
TEMPORADA 2021/2022
SEGUNDA ESLOVENIA 2. SNL
Equipo PJ GF GC Puntos
1 ND Gorica ND Gorica 30 55 20 72
2 Triglav Kranj Triglav 30 55 19 62
3 NK Krka NK Krka 30 54 35 51
4 NK Rogaška NK Rogaška 30 51 38 51
5 Rudar Velenje Rudar 30 51 43 49
6 Nafta Lendava Nafta 30 68 36 47
7 ND Bilje ND Bilje 30 38 39 45
8 Primorje Primorje 30 46 36 41
9 Roltek Dob Roltek Dob 30 45 46 39
10 Ilirija 1911 Ilirija 1911 30 35 37 38
11 Fužinar Fužinar 30 46 52 37
12 Beltinci Beltinci 30 34 47 35
13 Dekani Dekani 30 31 38 31
14 NK Krsko NK Krsko 30 25 54 26
15 Brežice Brežice 30 28 60 20
16 Drava Ptuj Drava Ptuj 30 30 92 20
TEMPORADA 2020/2021
SEGUNDA ESLOVENIA 2. SNL GRUPO 3
Equipo PJ GF GC Puntos
1 Primorje Primorje 7 14 5 14
2 Drava Ptuj Drava Ptuj 7 10 7 12
3 Dekani Dekani 7 10 11 12
4 Smartno 1928 Smartno 1928 7 8 8 10
5 Fužinar Fužinar 7 13 10 8
6 NK Krsko NK Krsko 7 9 13 8
7 Beltinci Beltinci 7 10 13 6
8 Brda Dobrovo Brda Dobrovo 7 9 16 5
TEMPORADA 2019/2020
SEGUNDA ESLOVENIA 2. SNL
Equipo PJ GF GC Puntos
1 FC Koper FC Koper 20 42 13 44
2 ND Gorica ND Gorica 20 40 22 41
3 Radomlje Radomlje 20 48 23 40
4 Nafta Lendava Nafta 20 45 24 37
5 Fužinar Fužinar 20 35 22 37
6 NK Krsko NK Krsko 20 37 25 31
7 NK Krka NK Krka 20 31 32 31
8 ND Bilje ND Bilje 20 28 25 29
9 Roltek Dob Roltek Dob 20 37 35 29
10 Dekani Dekani 20 29 40 24
11 Drava Ptuj Drava Ptuj 20 28 34 21
12 Beltinci Beltinci 20 20 36 20
13 Brda Dobrovo Brda Dobrovo 20 22 38 19
14 Brežice Brežice 20 13 29 16
15 NK Rogaška NK Rogaška 20 16 47 14
16 Dravograd Dravograd 20 23 49 10
TEMPORADA 2018/2019
SEGUNDA ESLOVENIA 2. SNL
Equipo PJ GF GC Puntos
1 NK Bravo NK Bravo 30 70 28 69
2 Tabor Sežana Tabor 30 59 22 63
3 Radomlje Radomlje 30 71 38 59
4 NK Krka NK Krka 30 59 41 54
5 Nafta Lendava Nafta 30 52 35 50
6 Fužinar Fužinar 30 46 34 48
7 Drava Ptuj Drava Ptuj 30 49 35 45
8 Roltek Dob Roltek Dob 30 46 42 40
9 ND Bilje ND Bilje 30 33 54 36
10 NK Rogaška NK Rogaška 30 35 50 34
11 Beltinci Beltinci 30 35 57 31
12 Brda Dobrovo Brda Dobrovo 30 35 46 29
13 Dekani Dekani 30 44 65 28
14 Brežice Brežice 30 32 52 26
15 Ilirija 1911 Ilirija 1911 30 33 65 26
16 Ankaran Hrvatini Ankaran 30 27 62 25
TEMPORADA 2017/2018
SEGUNDA ESLOVENIA 2. SNL
Equipo PJ GF GC Puntos
1 NS Mura NS Mura 30 86 22 72
2 Drava Ptuj Drava Ptuj 30 68 37 66
3 Nafta Lendava Nafta 30 69 28 64
4 Radomlje Radomlje 30 58 47 57
5 NK Krka NK Krka 30 49 47 49
6 NK Bravo NK Bravo 30 55 32 49
7 Tabor Sežana Tabor 30 46 37 48
8 Ilirija 1911 Ilirija 1911 30 44 53 39
9 Brda Dobrovo Brda Dobrovo 30 37 42 38
10 Roltek Dob Roltek Dob 30 41 46 37
11 Dekani Dekani 30 39 64 36
12 Brežice Brežice 30 36 51 30
13 NK Rogaška NK Rogaška 30 42 54 27
14 Fužinar Fužinar 30 46 70 26
15 Zarica Kranj Zarica Kranj 30 36 64 25
16 NK Verzej NK Verzej 30 23 81 16
TEMPORADA 2016/2017
TERCERA ESLOVENIA 3. SNL GRUPO 3
Equipo PJ GF GC Puntos
1 Maribor II Maribor II 26 107 25 66
2 NK Rogaška NK Rogaška 26 76 29 54
3 Fužinar Fužinar 26 48 34 42
4 Dravograd Dravograd 26 40 38 41
5 NK Korotan Prevalje Korotan 26 57 44 40
6 NK Mons Claudius Rogatec Mons 26 52 45 39
7 Šmarje pri Jelšah Šmarje 26 37 39 38
8 ND Dravinja Kostroj Dravinja 26 35 39 36
9 Šampion Celje Šampion 26 47 57 33
10 SD Videm SD Videm 26 36 54 29
11 Dobrovce Dobrovce 26 41 63 29
12 Lenart Lenart 26 37 59 27
13 Brunšvik Brunšvik 26 46 66 26
14 Smartno 1928 Smartno 1928 26 19 86 14
TEMPORADA 2015/2016
TERCERA ESLOVENIA 3. SNL GRUPO 3
Equipo PJ GF GC Puntos
1 Brežice Brežice 26 69 22 66
2 Maribor II Maribor II 26 102 24 61
3 Šampion Celje Šampion 26 74 34 55
4 SD Videm SD Videm 26 51 44 46
5 Šmarje pri Jelšah Šmarje 26 59 40 45
6 Fužinar Fužinar 26 44 50 43
7 NK Mons Claudius Rogatec Mons 26 41 34 42
8 Dravograd Dravograd 26 42 42 33
9 Lenart Lenart 26 41 60 29
10 Dobrovce Dobrovce 26 48 73 23
11 ND Dravinja Kostroj Dravinja 26 34 56 22
12 Smartno 1928 Smartno 1928 26 31 58 21
13 ŠD Radlje ob Dravi Radlje Dravi 26 23 57 19
14 Podvinci Podvinci 26 18 83 10
TEMPORADA 2014/2015
TERCERA ESLOVENIA 3. SNL GRUPO 3
Equipo PJ GF GC Puntos
1 Maribor II Maribor II 26 80 25 67
2 Drava Ptuj Drava Ptuj 26 82 29 61
3 Podvinci Podvinci 26 49 35 43
4 Dravograd Dravograd 26 56 42 42
5 Šmarje pri Jelšah Šmarje 26 45 36 40
6 Fužinar Fužinar 26 39 35 40
7 Šampion Celje Šampion 26 66 49 38
8 NK Mons Claudius Rogatec Mons 26 37 61 38
9 ŠD Radlje ob Dravi Radlje Dravi 26 50 44 35
10 Lenart Lenart 26 41 50 33
11 NK Šentjur NK Šentjur 26 39 59 31
12 NK Korotan Prevalje Korotan 26 42 50 29
13 Bistrica iz Slovenske Bistrica 26 22 71 13
14 Malečnik Malečnik 26 28 90 13

  USO DE MEMORIA  
6,230,064 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1149
Total Execution Time  0.1162
  CADENA URL  
/historico/Fuzinar
  GET DATOS  
$_GET['/historico/Fuzinar']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0029  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 = 'Fuzinar' 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.0018  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=61086 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=61086 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=61086 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=61086 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041  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 = 72187
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61086 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=389 AND type_rel = 3
0.0023  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 = '61086' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 72187 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026  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 = 73730 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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=61086 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (73730,72187,71432) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 72187 AND teamId = 61086
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 73730 AND teamId = 61086
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 61086
0.0023  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 = 72187 AND t.round = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  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 = '61086' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '61086' and rp.type = 4
0.0020  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 = '61086' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0035  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 = 72187 WHERE rp.league_id = 72187 AND rp.teamId = 61086 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.0037  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 = 72187 WHERE rp.league_id = 72187 AND rp.teamId = 61086 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 72187 WHERE rp.league_id = 72187 AND rp.teamId = 61086 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 61086 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0021  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 = 72187 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 68064 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 63332 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 57519 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 62247 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 50029 AND t.round = 20 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 44073 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 38804 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2017` 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 = 33922 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2016` 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 = 15893 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2015` 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 = 9372 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 72187 ORDER BY nameShow LIMIT 100