4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del FK Radnički Lukavac
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 2016/2017
PRIMERA FBIH BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 GOŠK Gabela GOŠK Gabela 30 50 26 56
2 Bosna Visoko Bosna Visoko 30 39 29 50
3 FK Tuzla City Tuzla City 30 43 36 48
4 Rudar Kakanj Rudar Kakanj 30 40 28 46
5 Capljina Capljina 30 34 25 46
6 Travnik Travnik 30 44 36 46
7 NK Bratstvo Gračanica Bratstvo 30 43 34 45
8 Zvijezda Zvijezda 30 40 32 45
9 Orasje Orasje 30 40 42 44
10 Jedinstvo Bihac Jedinstvo 30 34 37 44
11 Velež Mostar Velež 30 39 33 43
12 Goražde Goražde 30 35 32 43
13 FK Radnički Lukavac Radnički 30 37 51 36
14 Buducnost Banovici Buducnost 30 36 40 35
15 Bosna Sema Bosna Sema 30 38 46 32
16 Novi Travnik Novi Travnik 30 14 79 10
TEMPORADA 2015/2016
PRIMERA FBIH BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Metalleghe-Bsi Jajce Metalleghe-B 30 52 24 61
2 Zvijezda Zvijezda 30 49 26 59
3 Bosna Visoko Bosna Visoko 30 47 36 47
4 Orasje Orasje 30 41 30 47
5 Capljina Capljina 30 39 30 47
6 NK Bratstvo Gračanica Bratstvo 30 38 30 46
7 Buducnost Banovici Buducnost 30 34 27 46
8 GOŠK Gabela GOŠK Gabela 30 33 27 45
9 Rudar Kakanj Rudar Kakanj 30 41 32 44
10 Jedinstvo Bihac Jedinstvo 30 41 35 43
11 Goražde Goražde 30 31 31 42
12 Novi Travnik Novi Travnik 30 51 43 41
13 FK Radnički Lukavac Radnički 30 38 46 38
14 HNK Branitelj Branitelj 30 25 44 27
15 Ljubuski Ljubuski 30 17 39 21
16 NK Podgrmec NK Podgrmec 30 17 94 20
TEMPORADA 2014/2015
PRIMERA FBIH BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 NK Mladost Doboj Kakanj Mladost 30 39 25 59
2 GOŠK Gabela GOŠK Gabela 30 48 18 57
3 NK Bratstvo Gračanica Bratstvo 30 42 28 53
4 Buducnost Banovici Buducnost 30 37 27 53
5 Goražde Goražde 30 33 19 50
6 Metalleghe-Bsi Jajce Metalleghe-B 30 34 26 50
7 FK Radnički Lukavac Radnički 30 38 26 47
8 Jedinstvo Bihac Jedinstvo 30 31 23 43
9 Rudar Kakanj Rudar Kakanj 30 35 33 43
10 HNK Branitelj Branitelj 30 20 25 35
11 Orasje Orasje 30 33 42 35
12 Capljina Capljina 30 38 44 34
13 NK Podgrmec NK Podgrmec 30 27 41 34
14 Gradina Srebrenik Gradina 30 29 40 31
15 Turbina Jablanica Turbina 30 17 48 27
16 Igman Konjic Igman Konjic 30 20 56 13
TEMPORADA 2013/2014
PRIMERA FBIH BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Sloboda Tuzla Sloboda 30 61 16 71
2 Jedinstvo Bihac Jedinstvo 30 50 10 69
3 NK Bratstvo Gračanica Bratstvo 30 55 32 53
4 Rudar Kakanj Rudar Kakanj 30 37 23 50
5 Orasje Orasje 30 48 40 48
6 NK Mladost Doboj Kakanj Mladost 30 41 36 43
7 GOŠK Gabela GOŠK Gabela 30 42 34 42
8 Capljina Capljina 30 41 36 42
9 Gradina Srebrenik Gradina 30 29 30 41
10 FK Radnički Lukavac Radnički 30 37 27 40
11 HNK Branitelj Branitelj 30 39 32 39
12 Buducnost Banovici Buducnost 30 42 39 39
13 Igman Konjic Igman Konjic 30 37 53 39
14 NK Podgrmec NK Podgrmec 30 38 61 39
15 Iskra Bugojno Iskra 30 20 58 27
16 NK Troglav NK Troglav 30 8 98 5
TEMPORADA 2012/2013
PRIMERA FBIH BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Vitez Vitez 28 54 24 55
2 FK Radnički Lukavac Radnički 28 40 29 45
3 HNK Branitelj Branitelj 28 43 41 44
4 Rudar Kakanj Rudar Kakanj 28 32 25 42
5 NK Bratstvo Gračanica Bratstvo 28 34 28 42
6 Sloboda Tuzla Sloboda 28 40 27 41
7 Jedinstvo Bihac Jedinstvo 28 45 33 41
8 Capljina Capljina 28 36 45 41
9 Iskra Bugojno Iskra 28 32 33 37
10 Buducnost Banovici Buducnost 28 36 35 36
11 NK Podgrmec NK Podgrmec 28 27 42 36
12 NK Troglav NK Troglav 28 30 37 34
13 Bosna Visoko Bosna Visoko 28 28 37 33
14 Goražde Goražde 28 35 46 32
15 Krajina Cazin Krajina 28 24 54 28
16 Krajisnik Velika Krajisnik 0 0 0 0
TEMPORADA 2007/2008
PRIMERA FBIH BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Zvijezda Zvijezda 30 56 11 69
2 GOŠK Gabela GOŠK Gabela 30 43 35 49
3 Rudar Kakanj Rudar Kakanj 30 44 39 46
4 NK Bratstvo Gračanica Bratstvo 30 37 31 45
5 NK Drinovci NK Drinovci 30 29 36 45
6 Buducnost Banovici Buducnost 30 40 30 44
7 Iskra Bugojno Iskra 30 40 33 44
8 FK Famos Hrasnica Famos 30 36 31 44
9 NK Troglav NK Troglav 30 36 31 44
10 FK Ozren Semizovac Ozren 30 38 36 44
11 Bosna Visoko Bosna Visoko 30 41 39 43
12 FK Radnički Lukavac Radnički 30 34 43 43
13 Igman Konjic Igman Konjic 30 38 41 41
14 Gradina Srebrenik Gradina 30 26 49 29
15 NK Kresevo Stanic Kresevo 30 28 49 28
16 Brotnjo Citluk Brotnjo 30 30 62 25
TEMPORADA 2006/2007
PRIMERA FBIH BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Rudar Kakanj Rudar Kakanj 30 50 21 60
2 Travnik Travnik 30 51 32 59
3 NK Troglav NK Troglav 30 45 33 49
4 Zvijezda Zvijezda 30 42 28 48
5 Gradina Srebrenik Gradina 30 38 31 46
6 FK Famos Hrasnica Famos 30 36 34 46
7 Igman Konjic Igman Konjic 30 52 40 45
8 Brotnjo Citluk Brotnjo 30 38 42 44
9 NK Kresevo Stanic Kresevo 30 39 43 42
10 GOŠK Gabela GOŠK Gabela 30 36 44 42
11 Bosna Visoko Bosna Visoko 30 34 42 41
12 Buducnost Banovici Buducnost 30 29 29 40
13 Krajina Cazin Krajina 30 26 31 38
14 FK Radnički Lukavac Radnički 30 27 43 38
15 Mramor Mramor 30 34 60 29
16 TOSK Tesanj TOSK Tesanj 30 28 52 26
TEMPORADA 2005/2006
PRIMERA FBIH BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Velež Mostar Velež 30 52 21 64
2 Rudar Kakanj Rudar Kakanj 30 48 27 50
3 Brotnjo Citluk Brotnjo 30 58 33 48
4 NK Kresevo Stanic Kresevo 30 42 41 48
5 FK Famos Hrasnica Famos 30 38 23 47
6 NK Troglav NK Troglav 30 45 42 47
7 Gradina Srebrenik Gradina 30 56 39 46
8 GOŠK Gabela GOŠK Gabela 30 37 29 46
9 Bosna Visoko Bosna Visoko 30 39 38 46
10 Mramor Mramor 30 30 37 46
11 FK Radnički Lukavac Radnički 30 29 29 45
12 Vitez Vitez 30 33 33 43
13 Iskra Bugojno Iskra 30 36 34 42
14 NK Podgrmec NK Podgrmec 30 31 51 31
15 Olimpik Sarajevo Olimpik 30 28 48 25
16 Ljubuski Ljubuski 30 9 86 10
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,904,144 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4999
Total Execution Time  0.5011
  CADENA URL  
/historico/Fk-Radnicki
  GET DATOS  
$_GET['/historico/Fk-Radnicki']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0135  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 = 'Fk-Radnicki' 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=13156 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=13156 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13156 AND type_rel = 2
0.0130  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 = '13156' ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '13156' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '13156' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  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 = '13156' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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=13156 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (71432,68497) 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.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 68497 AND teamId = 13156
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 13156
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 = '13156' 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 = '13156' 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 = '13156' 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 = 71432 WHERE rp.league_id = 71432 AND rp.teamId = 13156 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.0127  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 = 71432 WHERE rp.league_id = 71432 AND rp.teamId = 13156 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 71432 WHERE rp.league_id = 71432 AND rp.teamId = 13156 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128  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 = 13156 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 `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.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 `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 = 33560 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 `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 = 15787 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 `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 = 4505 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 `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 = 8986 AND t.round = 30 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 `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 = 2831 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 `tables2008` 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 = 8996 AND t.round = 30 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 `tables2007` 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 = 8993 AND t.round = 30 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 `tables2006` 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 = 8992 AND t.round = 30 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 `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
0.0305  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 = 71432 ORDER BY nameShow LIMIT 100