4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Tekstilac Derventa
TEMPORADA 2022/2023
PRIMERA RS BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Krupa na Vrbasu Krupa Vrbasu 34 98 24 85
2 Zvijezda 09 Zvijezda 09 34 77 26 69
3 Laktaši Laktaši 34 76 34 69
4 Slavija Slavija 34 56 40 55
5 Sloboda Novi Grad Sloboda Novi 34 51 42 55
6 Rudar Prijedor Rudar 34 48 34 53
7 Radnik Bijeljina Radnik 34 47 33 53
8 Sutjeska Foča Sutjeska 34 48 60 46
9 Kozara Gradiška Kozara 34 48 56 43
10 Željezničar Banja Luka Željezniča 34 41 57 43
11 Ljubic Prnjavor Ljubic 34 41 66 41
12 Famos Vojkovici Famos 34 40 53 40
13 Sloboda Mrkonjic Grad Sloboda 34 45 59 40
14 FK Omarska FK Omarska 34 42 76 38
15 Drina Zvornik Drina 34 44 53 38
16 FK Modrica FK Modrica 34 32 73 33
17 FK Podrinje FK Podrinje 34 38 62 31
18 Tekstilac Derventa Tekstilac 34 28 52 31
TEMPORADA 2021/2022
PRIMERA RS BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Krupa na Vrbasu Krupa Vrbasu 30 73 16 75
2 Sloga Doboj Sloga Doboj 30 67 20 68
3 Sloboda Novi Grad Sloboda Novi 30 52 16 65
4 Zvijezda 09 Zvijezda 09 30 61 30 58
5 Sutjeska Foča Sutjeska 30 59 39 55
6 Drina Zvornik Drina 30 49 36 50
7 Slavija Slavija 30 40 41 43
8 FK Omarska FK Omarska 30 34 41 39
9 Ljubic Prnjavor Ljubic 30 52 57 38
10 Tekstilac Derventa Tekstilac 30 25 34 37
11 Željezničar Banja Luka Željezniča 30 40 47 33
12 FK Modrica FK Modrica 30 33 63 31
13 Kozara Gradiška Kozara 30 36 47 29
14 FK Podrinje FK Podrinje 30 27 57 27
15 Kozarska Dubica Kozarska 30 22 51 24
16 Buducnost Pilica Buducnost 30 20 95 10
TEMPORADA 2020/2021
PRIMERA RS BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Rudar Prijedor Rudar 30 51 20 63
2 Leotar Leotar 30 47 27 54
3 Zvijezda 09 Zvijezda 09 30 50 33 53
4 Željezničar Banja Luka Željezniča 30 46 37 46
5 Tekstilac Derventa Tekstilac 30 35 36 45
6 Sloboda Novi Grad Sloboda Novi 30 25 27 44
7 FK Modrica FK Modrica 30 52 37 43
8 Kozara Gradiška Kozara 30 34 28 42
9 Slavija Slavija 30 30 33 41
10 Kozarska Dubica Kozarska 30 35 38 39
11 Sloga Doboj Sloga Doboj 30 34 29 38
12 Ljubic Prnjavor Ljubic 30 45 45 38
13 Drina Zvornik Drina 30 39 50 38
14 Sutjeska Foča Sutjeska 30 39 40 35
15 FK Podrinje FK Podrinje 30 17 56 21
16 Jedinstvo Brcko Jedinstvo 30 29 72 18
TEMPORADA 2019/2020
PRIMERA RS BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Krupa na Vrbasu Krupa Vrbasu 14 34 6 38
2 Rudar Prijedor Rudar 14 20 7 27
3 Kozara Gradiška Kozara 14 15 16 22
4 Željezničar Banja Luka Željezniča 14 20 12 19
5 Tekstilac Derventa Tekstilac 14 22 20 16
6 FK Modrica FK Modrica 13 15 15 14
7 Slavija Slavija 13 14 20 13
8 FK Podrinje FK Podrinje 13 10 20 13
9 Jedinstvo Brcko Jedinstvo 13 12 28 8
10 Sloga Gornje Crnjelovo Sloga Gornje 2 0 18 0
TEMPORADA 2018/2019
PRIMERA RS BOSNIA-HERZEGOVINA GRUPO 3
Equipo PJ GF GC Puntos
1 Slavija Slavija 10 17 10 42
2 FK Modrica FK Modrica 10 9 6 41
3 Tekstilac Derventa Tekstilac 10 8 4 40
4 Sutjeska Foča Sutjeska 10 14 12 36
5 Drina Zvornik Drina 10 13 9 35
6 Sloboda Mrkonjic Grad Sloboda 10 4 24 19
TEMPORADA 2017/2018
PRIMERA RS BOSNIA-HERZEGOVINA GRUPO 2
Equipo PJ GF GC Puntos
1 Zvijezda 09 Zvijezda 09 10 28 8 30
2 Rudar Prijedor Rudar 10 19 5 22
3 FK Podrinje FK Podrinje 10 14 23 9
4 Slavija Slavija 10 8 19 9
5 Drina Zvornik Drina 10 10 11 8
6 Tekstilac Derventa Tekstilac 10 6 19 5
TEMPORADA 2016/2017
PRIMERA RS BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Borac Banja Luka Borac Banja 32 61 12 81
2 FK Podrinje FK Podrinje 32 47 29 59
3 Rudar Prijedor Rudar 32 59 40 52
4 Drina Zvornik Drina 32 39 29 52
5 Sloga Doboj Sloga Doboj 32 61 52 47
6 Sloboda Mrkonjic Grad Sloboda 32 43 51 46
7 Slavija Slavija 32 51 41 42
8 Zvijezda 09 Zvijezda 09 32 36 51 42
9 Kozara Gradiška Kozara 32 39 44 36
10 Tekstilac Derventa Tekstilac 32 18 26 36
11 Sutjeska Foča Sutjeska 32 30 52 33
12 FK Borac Samac Borac Samac 32 24 81 11
TEMPORADA 2015/2016
PRIMERA RS BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Krupa na Vrbasu Krupa Vrbasu 30 58 19 70
2 Mladost Velika Obarska Mladost 30 64 25 59
3 Tekstilac Derventa Tekstilac 30 41 26 47
4 Zvijezda 09 Zvijezda 09 30 42 34 47
5 Kozara Gradiška Kozara 30 41 31 46
6 Sutjeska Foča Sutjeska 30 38 36 46
7 Sloboda Mrkonjic Grad Sloboda 30 38 44 44
8 Leotar Leotar 30 36 42 42
9 Sloboda Novi Grad Sloboda Novi 30 40 41 38
10 FK Borac Samac Borac Samac 30 33 49 31
11 Drina HE Visegrad Drina 30 19 51 24
12 Vlasenica Vlasenica 30 22 74 11
TEMPORADA 2014/2015
PRIMERA RS BOSNIA-HERZEGOVINA
Equipo PJ GF GC Puntos
1 Rudar Prijedor Rudar 26 31 14 50
2 Leotar Leotar 26 29 22 48
3 Krupa na Vrbasu Krupa Vrbasu 26 34 25 43
4 Kozara Gradiška Kozara 26 44 31 41
5 Tekstilac Derventa Tekstilac 26 23 18 41
6 Sutjeska Foča Sutjeska 26 30 29 39
7 Sloboda Novi Grad Sloboda Novi 26 36 40 37
8 Vlasenica Vlasenica 26 30 32 36
9 Proleter Proleter 26 33 35 34
10 FK Podrinje FK Podrinje 26 22 20 33
11 Sloboda Mrkonjic Grad Sloboda 26 28 34 33
12 Drina HE Visegrad Drina 26 29 37 30
13 Mladost Gacko Mladost 26 28 47 24
14 FK Napredak Donji Sepak Napredak 26 31 44 20

  USO DE MEMORIA  
5,424,608 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6231
Total Execution Time  0.6243
  CADENA URL  
/historico/Tekstilac-Derventa
  GET DATOS  
$_GET['/historico/Tekstilac-Derventa']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0163  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 = 'Tekstilac-Derventa' 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.0145  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=19811 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0148  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=19811 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19811 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=852 AND type_rel = 3
0.0151  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 852 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0145  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 (305326) ORDER BY n.cover_points DESC, update_date DESC
0.0149  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 = '19811' ORDER BY l.year DESC,cat.coefficient DESC
0.0146  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 = '19811' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '19811' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0149  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=19811 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146  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,68498) 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.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 68498 AND teamId = 19811
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 74195 AND teamId = 19811
0.0145  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 = 74195 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146  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 = '19811' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '19811' and rp.type = 4
0.0146  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 = '19811' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0150  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 = 74195 WHERE rp.league_id = 74195 AND rp.teamId = 19811 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.0149  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 = 74195 WHERE rp.league_id = 74195 AND rp.teamId = 19811 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148  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 = 74195 WHERE rp.league_id = 74195 AND rp.teamId = 19811 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148  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 = 19811 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0291  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 = 68498 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.0148  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 = 63575 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.0149  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 = 57038 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.0146  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 = 50482 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.0147  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 = 44656 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 49721 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 38953 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 43368 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 33946 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 15786 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 4321 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 74195 ORDER BY nameShow LIMIT 100