4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Radnik Hadžići
TEMPORADA 2023/2024
PRIMERA FBIH BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Sloboda Tuzla Sloboda 23 45 17 54
2 Stupcanica Olovo Stupcanica 23 40 16 49
3 NK Bratstvo Gračanica Bratstvo 23 33 29 37
4 Goražde Goražde 23 28 19 36
5 Vis Simm-Bau Simm-Bau 23 42 38 34
6 Tomislav Tomislav 23 37 33 34
7 FK Gornji Rahic Gornji Rahic 23 31 32 33
8 Celik Zenica Celik Zenica 23 28 26 32
9 Buducnost Banovici Buducnost 23 31 30 31
10 Zvijezda Zvijezda 23 32 31 30
11 Gradina Srebrenik Gradina 23 16 26 30
12 Radnik Hadžići Radnik 23 21 28 26
13 Rudar Kakanj Rudar Kakanj 23 26 31 25
14 TOSK Tesanj TOSK Tesanj 23 32 38 24
15 Jedinstvo Bihac Jedinstvo 23 16 41 23
16 NK Mladost Doboj Kakanj Mladost 23 24 47 14
TEMPORADA 2022/2023
PRIMERA FBIH BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 GOŠK Gabela GOŠK Gabela 30 59 24 64
2 Stupcanica Olovo Stupcanica 30 46 27 52
3 Buducnost Banovici Buducnost 30 41 37 50
4 Goražde Goražde 30 41 31 49
5 Zvijezda Zvijezda 30 59 52 47
6 Gradina Srebrenik Gradina 30 40 39 47
7 Tomislav Tomislav 30 43 39 43
8 Rudar Kakanj Rudar Kakanj 30 40 41 43
9 TOSK Tesanj TOSK Tesanj 30 29 26 40
10 Vis Simm-Bau Simm-Bau 30 42 46 39
11 Jedinstvo Bihac Jedinstvo 30 40 47 37
12 NK Bratstvo Gračanica Bratstvo 30 42 43 36
13 NK Mladost Doboj Kakanj Mladost 30 32 45 36
14 Radnik Hadžići Radnik 30 26 37 34
15 Travnik Travnik 30 26 49 31
16 FK Radnički Lukavac Radnički 30 34 57 24
TEMPORADA 2021/2022
PRIMERA FBIH BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Igman Konjic Igman Konjic 30 47 16 68
2 GOŠK Gabela GOŠK Gabela 30 56 24 66
3 Buducnost Banovici Buducnost 30 48 34 52
4 TOSK Tesanj TOSK Tesanj 30 46 32 52
5 Rudar Kakanj Rudar Kakanj 30 40 35 52
6 Gradina Srebrenik Gradina 30 49 47 45
7 NK Bratstvo Gračanica Bratstvo 30 48 43 44
8 Orasje Orasje 30 36 41 43
9 Goražde Goražde 30 33 40 38
10 Zvijezda Zvijezda 30 36 37 33
11 Vis Simm-Bau Simm-Bau 30 31 33 32
12 Radnik Hadžići Radnik 30 23 35 31
13 Jedinstvo Bihac Jedinstvo 30 34 56 29
14 Travnik Travnik 30 36 45 28
15 NK Mladost Doboj Kakanj Mladost 30 35 55 27
16 Tomislav Tomislav 30 29 54 22
TEMPORADA 2020/2021
PRIMERA FBIH BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Posušje Posušje 30 49 15 61
2 TOSK Tesanj TOSK Tesanj 30 48 28 54
3 Rudar Kakanj Rudar Kakanj 30 43 31 50
4 Goražde Goražde 30 43 37 49
5 Zvijezda Zvijezda 30 44 31 48
6 NK Bratstvo Gračanica Bratstvo 30 43 30 48
7 GOŠK Gabela GOŠK Gabela 30 38 27 43
8 Jedinstvo Bihac Jedinstvo 30 26 36 43
9 Radnik Hadžići Radnik 30 32 36 40
10 Buducnost Banovici Buducnost 30 38 49 40
11 Vis Simm-Bau Simm-Bau 30 42 37 39
12 Travnik Travnik 30 31 37 39
13 Igman Konjic Igman Konjic 30 38 35 37
14 Orasje Orasje 30 43 51 36
15 Capljina Capljina 30 38 49 36
16 Slaven Živinice Slaven 30 17 84 8
TEMPORADA 2019/2020
PRIMERA FBIH BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Olimpik Sarajevo Olimpik 16 28 13 37
2 TOSK Tesanj TOSK Tesanj 16 27 21 31
3 Goražde Goražde 16 27 15 28
4 GOŠK Gabela GOŠK Gabela 16 30 25 28
5 Capljina Capljina 16 19 15 24
6 Rudar Kakanj Rudar Kakanj 16 26 21 23
7 Travnik Travnik 16 23 21 23
8 Igman Konjic Igman Konjic 16 17 18 23
9 Zvijezda Zvijezda 16 23 26 22
10 Metalleghe-Bsi Jajce Metalleghe-B 16 23 26 21
11 Buducnost Banovici Buducnost 16 26 22 20
12 NK Bratstvo Gračanica Bratstvo 16 24 29 20
13 Orasje Orasje 16 24 32 18
14 Jedinstvo Bihac Jedinstvo 16 20 30 17
15 Slaven Živinice Slaven 16 15 24 13
16 Radnik Hadžići Radnik 16 17 31 13
TEMPORADA 2010/2011
PRIMERA FBIH BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 GOŠK Gabela GOŠK Gabela 30 38 21 56
2 Capljina Capljina 30 49 41 48
3 Iskra Bugojno Iskra 30 45 35 47
4 Krajina Cazin Krajina 30 41 31 47
5 Orasje Orasje 30 40 31 47
6 Jedinstvo Bihac Jedinstvo 30 38 39 46
7 Goražde Goražde 30 50 39 45
8 Gradina Srebrenik Gradina 30 44 39 44
9 Krajisnik Velika Krajisnik 30 41 40 44
10 Rudar Kakanj Rudar Kakanj 30 46 44 43
11 FK Famos Hrasnica Famos 30 49 49 43
12 Omladinac Omladinac 30 37 39 42
13 Bosna Visoko Bosna Visoko 30 39 44 41
14 Slaven Živinice Slaven 30 27 42 34
15 Igman Konjic Igman Konjic 30 34 57 31
16 Radnik Hadžići Radnik 30 26 53 20
TEMPORADA 2004/2005
PRIMERA FBIH BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Jedinstvo Bihac Jedinstvo 30 62 29 66
2 Velež Mostar Velež 30 55 23 63
3 Rudar Kakanj Rudar Kakanj 30 39 26 47
4 FK Famos Hrasnica Famos 30 31 27 46
5 FK Radnički Lukavac Radnički 29 30 22 42
6 Mramor Mramor 30 38 45 42
7 Vitez Vitez 30 44 35 41
8 NK Podgrmec NK Podgrmec 30 32 38 41
9 Ljubuski Ljubuski 30 41 44 40
10 GOŠK Gabela GOŠK Gabela 30 33 40 39
11 Iskra Bugojno Iskra 30 42 43 38
12 Brotnjo Citluk Brotnjo 30 36 49 38
13 Bosna Visoko Bosna Visoko 29 26 38 34
14 Kiseljak Kiseljak 30 29 44 34
15 Radnik Hadžići Radnik 30 26 41 33
16 NK Drinovci NK Drinovci 30 34 54 32

  USO DE MEMORIA  
5,830,456 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.0902
Total Execution Time  0.0915
  CADENA URL  
/historico/Radnik-Hadzici
  GET DATOS  
$_GET['/historico/Radnik-Hadzici']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=59674 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=364 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 364 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (743245,312189) ORDER BY n.cover_points DESC, update_date DESC
0.0022  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 = '59674' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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=59674 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 (74195,72797,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 = 72797 AND teamId = 59674
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 74195 AND teamId = 59674
0.0040  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 59674
0.0020  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 = '59674' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '59674' and rp.type = 4
0.0024  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 = '59674' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0036  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 = 72797 WHERE rp.league_id = 72797 AND rp.teamId = 59674 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.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 = 72797 WHERE rp.league_id = 72797 AND rp.teamId = 59674 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 = 72797 WHERE rp.league_id = 72797 AND rp.teamId = 59674 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 59674 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72797 AND t.round = 23 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 `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 = 68497 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.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 `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 = 63323 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.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 `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 = 57037 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.0024  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 = 50481 AND t.round = 18 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 `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 = 9001 AND t.round = 30 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 `tables2005` 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 = 24546 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC