4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Zvijezda 09 Sub 19
TEMPORADA 2023/2024
LIGA BOSNIA SUB 19
Equipo PJ GF GC Puntos
1 FK Sarajevo Sub 19 Sarajevo 21 62 19 48
2 Zrinjski Mostar Sub 19 Zrinjski 21 58 21 45
3 Velež Mostar Sub 19 Velež 21 50 31 41
4 Željezničar Sub 19 Željezniča 21 53 39 37
5 Siroki Brijeg Sub 19 Siroki 21 55 26 36
6 FK Borac Banja Luka Sub 19 Borac Banja 21 39 34 32
7 Zeljeznicar Banja Luka Sub Zeljeznicar 21 34 40 31
8 FK Sloboda Tuzla Sub 19 Sloboda 21 35 29 29
9 Zvijezda 09 Sub 19 Zvijezda 21 43 41 27
10 Tuzla City Sub 19 Tuzla City 21 32 47 24
11 Krupa na Vrbasu Sub 19 Krupa Vrbasu 21 24 49 21
12 Radnik Bijeljina Sub 19 Radnik 21 31 46 19
13 Radnik Hadžići Sub 19 Radnik 21 20 66 12
14 FK Kozara Gradiska Sub 19 Kozara 21 26 74 11
TEMPORADA 2022/2023
LIGA BOSNIA SUB 19
Equipo PJ GF GC Puntos
1 FK Sarajevo Sub 19 Sarajevo 26 68 18 66
2 Zrinjski Mostar Sub 19 Zrinjski 26 81 34 56
3 FK Borac Banja Luka Sub 19 Borac Banja 26 58 33 53
4 Siroki Brijeg Sub 19 Siroki 26 72 48 43
5 Tuzla City Sub 19 Tuzla City 26 66 40 40
6 FK Sloboda Tuzla Sub 19 Sloboda 26 54 38 40
7 Krupa na Vrbasu Sub 19 Krupa Vrbasu 26 51 46 35
8 Željezničar Sub 19 Željezniča 26 52 58 34
9 Radnik Hadžići Sub 19 Radnik 26 46 47 31
10 Zvijezda 09 Sub 19 Zvijezda 26 38 53 30
11 Zeljeznicar Banja Luka Sub Zeljeznicar 26 38 55 29
12 Radnik Bijeljina Sub 19 Radnik 26 36 64 29
13 FK Sloga Meridian Sub 19 Sloga 26 35 74 25
14 Buducnost Banovici Sub 19 Buducnost 26 19 106 5
TEMPORADA 2021/2022
LIGA BOSNIA SUB 19
Equipo PJ GF GC Puntos
1 FK Borac Banja Luka Sub 19 Borac Banja 24 49 28 47
2 FK Sarajevo Sub 19 Sarajevo 24 49 19 45
3 Zrinjski Mostar Sub 19 Zrinjski 24 63 36 45
4 Željezničar Sub 19 Željezniča 24 58 38 41
5 FK Sloboda Tuzla Sub 19 Sloboda 24 36 33 39
6 Krupa na Vrbasu Sub 19 Krupa Vrbasu 24 39 39 34
7 Zvijezda 09 Sub 19 Zvijezda 24 34 34 33
8 Zeljeznicar Banja Luka Sub Zeljeznicar 24 30 43 32
9 Tuzla City Sub 19 Tuzla City 24 36 34 31
10 Siroki Brijeg Sub 19 Siroki 24 41 44 31
11 Radnik Hadžići Sub 19 Radnik 24 34 45 29
12 Radnik Bijeljina Sub 19 Radnik 24 31 47 28
13 Mladost Doboj-Kakanj Sub 19 Mladost 24 36 53 26
14 Prijedor Sub 19 Prijedor 24 14 57 13
TEMPORADA 2020/2021
LIGA BOSNIA SUB 19
Equipo PJ GF GC Puntos
1 Zvijezda 09 Sub 19 Zvijezda 26 58 14 63
2 FK Sloboda Tuzla Sub 19 Sloboda 26 55 19 61
3 Željezničar Sub 19 Željezniča 26 45 19 47
4 FK Borac Banja Luka Sub 19 Borac Banja 26 40 31 44
5 FK Sarajevo Sub 19 Sarajevo 26 45 33 39
6 Zrinjski Mostar Sub 19 Zrinjski 26 36 37 39
7 Siroki Brijeg Sub 19 Siroki 26 28 27 34
8 Olimpik Sarajevo Sub 19 Olimpik 26 31 54 32
9 Zeljeznicar Banja Luka Sub Zeljeznicar 26 40 50 31
10 Prijedor Sub 19 Prijedor 26 26 42 27
11 Mladost Doboj-Kakanj Sub 19 Mladost 26 25 44 26
12 Krupa na Vrbasu Sub 19 Krupa Vrbasu 26 33 52 25
13 Radnik Hadžići Sub 19 Radnik 26 32 53 25
14 Velež Mostar Sub 19 Velež 26 23 42 24
TEMPORADA 2019/2020
LIGA BOSNIA SUB 19
Equipo PJ GF GC Puntos
1 Željezničar Sub 19 Željezniča 15 46 15 35
2 Zrinjski Mostar Sub 19 Zrinjski 15 29 11 34
3 FK Sloboda Tuzla Sub 19 Sloboda 15 27 12 33
4 Prijedor Sub 19 Prijedor 15 24 19 27
5 FK Sarajevo Sub 19 Sarajevo 15 26 15 26
6 FK Borac Banja Luka Sub 19 Borac Banja 15 27 19 26
7 Zvijezda 09 Sub 19 Zvijezda 15 25 17 25
8 Siroki Brijeg Sub 19 Siroki 15 19 22 21
9 Olimpik Sarajevo Sub 19 Olimpik 15 14 23 14
10 Mladost Doboj-Kakanj Sub 19 Mladost 15 20 28 13
11 Krupa na Vrbasu Sub 19 Krupa Vrbasu 15 9 24 13
12 Velež Mostar Sub 19 Velež 15 22 29 12
13 FK Slavija Sarajevo Sub 19 Slavija 15 13 38 9
14 Travnik Sub 19 Travnik 15 11 40 8
TEMPORADA 2018/2019
LIGA BOSNIA SUB 19
Equipo PJ GF GC Puntos
1 Zrinjski Mostar Sub 19 Zrinjski 26 65 24 62
2 Željezničar Sub 19 Željezniča 26 65 21 59
3 FK Sarajevo Sub 19 Sarajevo 26 43 34 43
4 FK Sloboda Tuzla Sub 19 Sloboda 26 35 32 43
5 Siroki Brijeg Sub 19 Siroki 26 40 25 39
6 Krupa na Vrbasu Sub 19 Krupa Vrbasu 26 31 37 36
7 Zvijezda 09 Sub 19 Zvijezda 26 43 41 34
8 Mladost Doboj-Kakanj Sub 19 Mladost 26 33 33 33
9 FK Borac Banja Luka Sub 19 Borac Banja 26 44 40 32
10 Travnik Sub 19 Travnik 26 36 62 32
11 Velež Mostar Sub 19 Velež 26 37 61 31
12 FK Slavija Sarajevo Sub 19 Slavija 26 33 38 30
13 Radnik Bijeljina Sub 19 Radnik 26 36 49 29
14 NK Celik Zenica Sub 19 Celik Zenica 26 17 61 12
TEMPORADA 2017/2018
LIGA BOSNIA SUB 19
Equipo PJ GF GC Puntos
1 FK Sarajevo Sub 19 Sarajevo 26 104 29 67
2 Zrinjski Mostar Sub 19 Zrinjski 26 60 21 53
3 Zvijezda 09 Sub 19 Zvijezda 26 57 23 51
4 Željezničar Sub 19 Željezniča 26 74 35 49
5 FK Sloboda Tuzla Sub 19 Sloboda 26 50 37 46
6 Siroki Brijeg Sub 19 Siroki 26 61 43 43
7 Krupa na Vrbasu Sub 19 Krupa Vrbasu 26 40 38 40
8 Radnik Bijeljina Sub 19 Radnik 26 39 41 39
9 Velež Mostar Sub 19 Velež 26 33 55 32
10 FK Borac Banja Luka Sub 19 Borac Banja 26 34 48 31
11 Mladost Doboj-Kakanj Sub 19 Mladost 26 37 57 30
12 NK Celik Zenica Sub 19 Celik Zenica 26 28 52 18
13 Vitez Sub 19 Vitez 26 31 75 11
14 GOŠK Gabela Sub 19 GOŠK Gabela 26 20 114 8

  USO DE MEMORIA  
5,492,808 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1187
Total Execution Time  0.1207
  CADENA URL  
/historico/Fk-Zvijezda-09-Sub-19
  GET DATOS  
$_GET['/historico/Fk-Zvijezda-09-Sub-19']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0031  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-Zvijezda-09-Sub-19' 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.0024  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=118296 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024  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=118296 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0038  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 = 72881
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=118296 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2095 AND type_rel = 3
0.0022  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 = '118296' ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '118296' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0041  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 = '118296' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 72881 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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=118296 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (72881) 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.0071  SELECT count(id) as num_players from rel_players WHERE league_id = 72881 AND teamId = 118296
0.0026  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 = 72881 AND t.round = 21 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '118296' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '118296' and rp.type = 4
0.0019  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 = '118296' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 72881 WHERE rp.league_id = 72881 AND rp.teamId = 118296 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.0031  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 = 72881 WHERE rp.league_id = 72881 AND rp.teamId = 118296 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 = 72881 WHERE rp.league_id = 72881 AND rp.teamId = 118296 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 = 118296 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72881 AND t.round = 21 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 68380 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 63913 AND t.round = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 58468 AND t.round = 26 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 = 51464 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0043  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 = 48021 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 48025 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC