4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
13 jugadores
FCSB FCSB
D. Stângaciu D. Stângaciu 59 años POR
M. Belodedici M. Belodedici 59 años 185cm 78kg DEF
S. Iovan S. Iovan 63 años DEF
A. Bumbescu A. Bumbescu 64 años DEF
I. Bărbulescu I. Bărbulescu 66 años DEF
M. Majearu M. Majearu 63 años MED
L. Bölöni L. Bölöni 71 años MED
G. Hagi G. Hagi 59 años MED
T. Stoica T. Stoica 69 años MED
Balan Balan 64 años MED
G. Balint G. Balint 61 años 180cm 70kg MED
V. Piturca V. Piturca 67 años DEL
Marius Lăcătuș Marius Lăcătuș 60 años DEL
13 jugadores
Dynamo Kyiv Dynamo Kyiv
V. Chanov V. Chanov 57 años POR
S. Baltacha S. Baltacha 66 años 181cm 75kg DEF
Oleg Kuznetsov Oleg Kuznetsov 61 años 182cm 78kg DEF
A. Demyanenko A. Demyanenko 65 años DEF
Aleksandr Zavarov Aleksandr Zavarov 63 años 170cm 68kg MED
Vadim Evtushenko Vadim Evtushenko 66 años 177cm 70kg MED
P. Yakovenko P. Yakovenko 59 años MED
Aleksey Mikhaylichenko Aleksey Mikhaylichenko 61 años MED
Vasyl Rats Vasyl Rats 63 años MED
A. Bal A. Bal 56 años MED
I. Belanov I. Belanov 63 años DEL
O. Blokhin O. Blokhin 71 años DEL
Oleg Morozov Oleg Morozov 62 años DEL

Equipos de esta liga

2

  USO DE MEMORIA  
4,320,608 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.3513
Total Execution Time  0.3531
  CADENA URL  
/supercopa_europa1987/grupo0/jugadores
  GET DATOS  
$_GET['/supercopa_europa1987/grupo0/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0124  SELECT type FROM routes WHERE alias = 'supercopa_europa1987'
0.0252  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'supercopa_europa' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1987 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=133 AND type_rel = 3
0.0135  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 133 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  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 (1301072,1297561,230216,1281325,1273932) ORDER BY n.cover_points DESC, update_date DESC
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=133 ORDER BY order_id ASC
0.0126  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 = 11880 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0125  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 11880 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0131  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 = 11880 AND dt.id IN (9964,4257) ORDER BY dt.relations DESC,dp.role ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-05 23:48:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-05 23:48:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-05 23:48:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-05 23:48:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 133 AND l.year = 1987
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events1987 e WHERE e.league_id IN (11880) 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, e.player_id ASC LIMIT 10
0.0126  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (11880) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (258721) ORDER BY rp.in_squad = 1 DESC
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 133 AND l.year = 1987
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events1987 e WHERE e.league_id IN (11880) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0127  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 133 AND l.year = 1987
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events1987 e WHERE e.league_id IN (11880) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10