4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Feronikeli

Feronikeli

Entrenador: Shefki Kuqi

Temporada 2023/2024
TEMPORADA 2023/2024
LIGA KOSOVO
Equipo PJ GF GC Puntos
1 Ballkani Ballkani 32 54 25 66
2 KF Llapi KF Llapi 32 49 24 64
3 FC Drita FC Drita 32 45 23 62
4 Malisheva Malisheva 32 50 37 53
5 Prishtina Prishtina 32 34 27 46
6 Dukagjini Dukagjini 32 31 40 39
7 SC Gjilani SC Gjilani 32 33 33 35
8 Feronikeli Feronikeli 32 29 44 34
9 Fushë Kosova Fushë 32 19 51 20
10 KF Liria Prizren Liria 32 19 59 14
TEMPORADA 2021/2022
LIGA KOSOVO
Equipo PJ GF GC Puntos
1 Ballkani Ballkani 36 61 26 76
2 FC Drita FC Drita 36 56 25 64
3 SC Gjilani SC Gjilani 36 57 36 62
4 KF Llapi KF Llapi 36 57 44 54
5 Prishtina Prishtina 36 49 37 51
6 Drenica Skënderaj Drenica 36 51 48 50
7 Dukagjini Dukagjini 36 37 34 50
8 Malisheva Malisheva 36 45 43 48
9 Ulpiana Ulpiana 36 34 72 27
10 Feronikeli Feronikeli 36 16 98 12
TEMPORADA 2020/2021
LIGA KOSOVO
Equipo PJ GF GC Puntos
1 Prishtina Prishtina 36 65 27 78
2 FC Drita FC Drita 36 59 28 76
3 Ballkani Ballkani 36 79 43 74
4 SC Gjilani SC Gjilani 36 37 38 48
5 KF Llapi KF Llapi 36 49 56 43
6 Feronikeli Feronikeli 36 44 36 42
7 Drenica Skënderaj Drenica 36 34 48 42
8 Trepça'89 Trepça'89 36 38 54 42
9 Arbëria Arbëria 36 42 58 40
10 Besa Pejë Besa Pejë 36 27 86 15
TEMPORADA 2019/2020
LIGA KOSOVO
Equipo PJ GF GC Puntos
1 SC Gjilani SC Gjilani 33 61 27 68
2 FC Drita FC Drita 33 57 23 68
3 Ballkani Ballkani 33 59 25 67
4 Prishtina Prishtina 33 59 25 62
5 Feronikeli Feronikeli 33 50 40 47
6 KF Llapi KF Llapi 33 51 62 45
7 Trepça'89 Trepça'89 33 55 55 44
8 Drenica Skënderaj Drenica 33 39 40 44
9 Flamurtari Flamurtari 33 42 56 43
10 Ferizaj Ferizaj 33 34 70 29
11 Vushtrria Vushtrria 33 34 76 21
12 Dukagjini Dukagjini 33 27 69 19
TEMPORADA 2018/2019
LIGA KOSOVO
Equipo PJ GF GC Puntos
1 Feronikeli Feronikeli 33 64 14 80
2 Prishtina Prishtina 33 49 12 75
3 KF Llapi KF Llapi 33 54 24 69
4 FC Drita FC Drita 33 47 39 48
5 Ferizaj Ferizaj 33 39 41 46
6 Flamurtari Flamurtari 33 33 39 45
7 Drenica Skënderaj Drenica 33 41 33 43
8 Ballkani Ballkani 33 35 36 43
9 Trepça'89 Trepça'89 33 40 45 42
10 SC Gjilani SC Gjilani 33 28 37 38
11 KF Liria Prizren Liria 33 30 60 28
12 KEK-u KEK-u 33 24 104 1
TEMPORADA 2017/2018
LIGA KOSOVO
Equipo PJ GF GC Puntos
1 FC Drita FC Drita 33 53 21 67
2 Prishtina Prishtina 33 39 18 64
3 KF Llapi KF Llapi 33 51 41 54
4 Trepça'89 Trepça'89 33 41 25 53
5 Feronikeli Feronikeli 33 32 18 48
6 Drenica Skënderaj Drenica 33 34 27 48
7 KF Liria Prizren Liria 33 34 30 48
8 SC Gjilani SC Gjilani 33 29 21 46
9 Vëllaznimi Vëllaznimi 33 29 28 44
10 Flamurtari Flamurtari 33 28 53 25
11 Besa Pejë Besa Pejë 33 28 64 22
12 Vllaznia Vllaznia 33 16 68 14
TEMPORADA 2016/2017
LIGA KOSOVO
Equipo PJ GF GC Puntos
1 Trepça'89 Trepça'89 33 72 24 77
2 Prishtina Prishtina 33 46 18 72
3 KF Llapi KF Llapi 33 44 30 68
4 Feronikeli Feronikeli 33 61 27 65
5 SC Gjilani SC Gjilani 33 36 28 48
6 Besa Pejë Besa Pejë 33 42 39 47
7 Drenica Skënderaj Drenica 33 37 47 40
8 KF Liria Prizren Liria 33 41 39 37
9 FC Drita FC Drita 33 21 34 35
10 Ferizaj Ferizaj 33 24 36 31
11 Trepça Mitrovicë Trepça 33 37 64 23
12 Hajvalia Hajvalia 33 12 87 7
TEMPORADA 2015/2016
LIGA KOSOVO
Equipo PJ GF GC Puntos
1 Feronikeli Feronikeli 33 53 27 69
2 Hajvalia Hajvalia 33 44 26 59
3 Trepça'89 Trepça'89 33 53 30 56
4 Besa Pejë Besa Pejë 33 37 27 53
5 SC Gjilani SC Gjilani 33 29 27 49
6 KF Llapi KF Llapi 33 44 44 44
7 KF Liria Prizren Liria 33 35 45 44
8 Prishtina Prishtina 33 29 34 43
9 Drenica Skënderaj Drenica 33 38 48 40
10 FC Drita FC Drita 33 33 43 36
11 Istogu Istogu 33 24 40 34
12 Vushtrria Vushtrria 33 24 52 26
TEMPORADA 2014/2015
LIGA KOSOVO
Equipo PJ GF GC Puntos
1 Feronikeli Feronikeli 33 51 25 67
2 Besa Pejë Besa Pejë 33 51 37 66
3 Prishtina Prishtina 33 43 28 56
4 Hajvalia Hajvalia 33 46 32 54
5 Vushtrria Vushtrria 33 36 27 50
6 Trepça'89 Trepça'89 33 52 36 48
7 Drenica Skënderaj Drenica 33 39 35 44
8 Istogu Istogu 33 41 45 43
9 FC Drita FC Drita 33 30 38 39
10 Vëllaznimi Vëllaznimi 33 24 38 34
11 Ferizaj Ferizaj 33 22 55 21
12 Trepça Mitrovicë Trepça 33 18 57 19
TEMPORADA 2013/2014
LIGA KOSOVO
Equipo PJ GF GC Puntos
1 Vushtrria Vushtrria 33 48 22 64
2 Prishtina Prishtina 33 39 26 57
3 Trepça'89 Trepça'89 33 45 31 53
4 Ferizaj Ferizaj 33 43 35 51
5 Besa Pejë Besa Pejë 33 37 36 49
6 Hajvalia Hajvalia 33 40 32 47
7 FC Drita FC Drita 33 43 37 47
8 Drenica Skënderaj Drenica 33 45 42 45
9 Feronikeli Feronikeli 33 28 33 41
10 Trepça Mitrovicë Trepça 33 25 32 36
11 Fushë Kosova Fushë 33 29 49 32
12 Hysi Hysi 33 21 68 28

  USO DE MEMORIA  
5,839,320 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6710
Total Execution Time  0.6722
  CADENA URL  
/historico/Feronikeli
  GET DATOS  
$_GET['/historico/Feronikeli']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0156  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 = 'Feronikeli' 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=61707 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=61707 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=61707 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=61707 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0294  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 = 74775
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61707 AND type_rel = 2
0.0146  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 61707 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0148  SELECT /*35 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 (651779,651356,660903,660113,662490) ORDER BY n.cover_points DESC, update_date DESC
0.0150  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 = '61707' ORDER BY l.year DESC,cat.coefficient DESC
0.0148  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 = '61707' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0148  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 = '61707' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147  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 = 74775 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150  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 = 72418 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150  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=61707 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 (74775,72418,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.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 72418 AND teamId = 61707
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 74775 AND teamId = 61707
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 61707
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 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 = 72418 AND t.round = 32 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0147  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 = '61707' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '61707' 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 = '61707' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0158  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 = 72418 WHERE rp.league_id = 72418 AND rp.teamId = 61707 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.0156  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 = 72418 WHERE rp.league_id = 72418 AND rp.teamId = 61707 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0152  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 = 72418 WHERE rp.league_id = 72418 AND rp.teamId = 61707 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149  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 = 61707 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0151  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 = 63712 AND t.round = 36 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 = 58692 AND t.round = 36 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 `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 = 49955 AND t.round = 33 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 `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 = 44235 AND t.round = 33 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 = 38986 AND t.round = 33 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 `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 = 33899 AND t.round = 33 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 = 15699 AND t.round = 33 ORDER BY team.conference 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 `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 = 9508 AND t.round = 33 ORDER BY team.conference 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 `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 = 16222 AND t.round = 33 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 = 72418 ORDER BY nameShow LIMIT 100