4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
34 jugadores
Apolonia Fier Apolonia Fier
J. Tozaj J. Tozaj 23 años POR
M. Gjishti M. Gjishti 20 años POR
E. Çako E. Çako 32 años POR
Romeo Harizaj Romeo Harizaj 25 años 190cm POR
Orgest Merkaj Orgest Merkaj 20 años DEF
D. Andoni D. Andoni 28 años DEF
E. Sota E. Sota 25 años 188cm DEF
Ersildjo Asllanaj Ersildjo Asllanaj 22 años 190cm DEF
Klevis Lushaku Klevis Lushaku 23 años DEF
Rubin Hebeja Rubin Hebeja 22 años DEF
G. Sharavolli G. Sharavolli 29 años 170cm MED
E. Qosanji E. Qosanji 22 años MED
D. Duda D. Duda 28 años MED
Be. Ofori Be. Ofori 31 años 184cm MED
T. Hysenshahaj T. Hysenshahaj 32 años 174cm MED
K. Mehmeti K. Mehmeti 25 años MED
Aleksandro Zaimaj Aleksandro Zaimaj 26 años 172cm MED
Skerdilajd Levendi Skerdilajd Levendi 22 años 187cm MED
Sokol Ymeraj Sokol Ymeraj 25 años 186cm MED
S. Kumani S. Kumani 24 años MED
E. Smaçi E. Smaçi 25 años 186cm MED
Altin Kananaj Altin Kananaj 22 años MED
K. Prifti K. Prifti 28 años MED
R. Kardhashi R. Kardhashi 23 años DEL
Mario Gjata Mario Gjata 23 años 188cm DEL
R. Mihana R. Mihana 24 años 185cm DEL
Xhovalin Trifoni Xhovalin Trifoni 20 años DEL
M. Sota M. Sota 23 años DEL
Stefano Omeri Stefano Omeri 24 años DEL
A. Guri A. Guri 24 años DEL
K. Zoga K. Zoga 23 años DEL
E. Eyoh E. Eyoh 27 años DEL
Redi Kaçanolli Redi Kaçanolli 20 años DEL
J. Krasniqi J. Krasniqi 23 años 186cm DEL
29 jugadores
Kastrioti Krujë Kastrioti Krujë
Bruno Puja Bruno Puja 24 años 188cm POR
R. Lecka R. Lecka 25 años POR
E. Lumani E. Lumani 22 años POR
E. Selaci E. Selaci 33 años 195cm POR
T. Sefgjini T. Sefgjini 37 años 177cm DEF
E. Boyom E. Boyom 35 años 185cm 82kg DEF
E. Çela E. Çela 38 años 182cm DEF
A. Rami A. Rami 26 años 177cm DEF
F. Lena F. Lena 23 años DEF
Indrit Prodani Indrit Prodani 25 años 178cm DEF
S. Neziri S. Neziri 27 años 178cm DEF
L. Hussein L. Hussein 27 años 183cm DEF
F. Daci F. Daci 33 años 188cm DEF
Alen Kopaçi Alen Kopaçi 27 años DEF
X. Mehmeti X. Mehmeti 30 años 180cm MED
R. Nuriu R. Nuriu 25 años 183cm MED
A. Karakaçi A. Karakaçi 31 años 184cm MED
Alban Gjinaj Alban Gjinaj 23 años MED
Laurenc Xheka Laurenc Xheka 23 años 176cm MED
X. Haka X. Haka 23 años MED
H. Okebugwu H. Okebugwu 25 años 184cm MED
A. Basha A. Basha 26 años 183cm MED
B. Pepa B. Pepa 33 años 175cm MED
B. Rosaj B. Rosaj 23 años MED
P. Bardhi P. Bardhi 25 años 183cm DEL
S. Ajazi S. Ajazi 29 años 186cm DEL
T. Marku T. Marku 29 años 183cm DEL
K. Daci K. Daci 25 años 186cm DEL
S. Ndreu S. Ndreu 21 años DEL

JUGADORES DESTACADOS

Nombre Goles Equipo
S. Ajazi al S. Ajazi 1 KRU Kastrioti Krujë
R. Mihana al R. Mihana 1 APO Apolonia Fier

Equipos de esta liga

2

  USO DE MEMORIA  
4,439,672 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.3289
Total Execution Time  0.3307
  CADENA URL  
/primera_division_albania2020/grupo4/jugadores
  GET DATOS  
$_GET['/primera_division_albania2020/grupo4/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0125  SELECT type FROM routes WHERE alias = 'primera_division_albania2020'
0.0254  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_division_albania' AND (l.group_code = 4 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=4 DESC LIMIT 1
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=288 AND type_rel = 3
0.0129  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 288 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0130  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 (403000) ORDER BY n.cover_points DESC, update_date DESC
0.0130  SELECT id,name,alias,stepParent FROM categories WHERE parentId=288 ORDER BY order_id ASC
0.0133  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 57047 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0135  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 57047 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0158  SELECT dp.nick,dp.alias,dp.role,p.id,p.teamId,dp.height,dp.weight,p.team_id,p.player_id,p.squadNumber,dp.CountryCode,dp.age FROM rel_players p INNER JOIN dataplayers dp ON dp.id = p.player_id INNER JOIN datateams dt ON dt.id = p.teamId WHERE p.league_id = 57047 AND dt.id IN (6401,5833) ORDER BY dt.relations DESC,dp.role ASC
0.0132  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-03 04:17:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0134  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-03 04:17:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0133  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-03 04:17:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0134  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-03 04:17:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0139  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_division_albania' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0143  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 57047 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 57047 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0143  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 57047 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 57047 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0136  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 57047 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 57047 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10