4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
18 jugadores
Barcelona Barcelona
R. Hesp R. Hesp 58 años 194cm 94kg POR
W. Bogarde W. Bogarde 53 años 190cm 80kg DEF
M. Nadal M. Nadal 57 años 187cm 83kg DEF
Albert Ferrer Albert Ferrer 53 años 170cm 65kg DEF
Sergi Sergi 52 años 173cm 64kg DEF
M. Reiziger M. Reiziger 50 años 178cm 71kg DEF
Abelardo Abelardo 54 años 180cm 77kg DEF
Giovanni Giovanni 52 años 190cm 78kg MED
I. De La Peña I. De La Peña 47 años 170cm 70kg MED
Òscar Òscar 51 años 182cm 76kg MED
Luis Figo Luis Figo 51 años 180cm 75kg MED
D. Ciric D. Ciric 49 años 180cm 73kg MED
Celades Celades 48 años 175cm 71kg MED
G. Amor G. Amor 56 años 174cm 69kg MED
Rivaldo Rivaldo 52 años 186cm 83kg DEL
Luis Enrique Luis Enrique 53 años 180cm 73kg DEL
Sonny Anderson Sonny Anderson 53 años 181cm 72kg DEL
H. Stoichkov H. Stoichkov 58 años 178cm 76kg DEL
17 jugadores
B. Dortmund B. Dortmund
Stefan Klos Stefan Klos 52 años 183cm 86kg POR
M. Binz M. Binz 58 años 183cm 76kg DEF
Jürgen Kohler Jürgen Kohler 58 años 186cm 87kg DEF
M. Kree M. Kree 59 años 183cm 82kg DEF
R. Schneider R. Schneider 51 años 187cm 81kg DEF
L. Ricken L. Ricken 47 años 178cm 72kg MED
K. Reinhardt K. Reinhardt 56 años 180cm 78kg MED
B. Mehnert B. Mehnert 47 años 183cm 79kg MED
Jörg Heinrich Jörg Heinrich 54 años 186cm 77kg MED
V. But V. But 46 años 183cm 80kg MED
Steffen Freund Steffen Freund 54 años 180cm 79kg MED
M. Zorc M. Zorc 61 años 183cm 73kg MED
B. Gambo B. Gambo 45 años 175cm 71kg MED
I. Tanko I. Tanko 46 años 180cm 80kg DEL
Jovan Kirovski Jovan Kirovski 48 años 180cm 75kg DEL
H. Decheiver H. Decheiver 54 años 185cm 82kg DEL
S. Chapuisat S. Chapuisat 54 años 180cm 75kg DEL

Equipos de esta liga

2

  USO DE MEMORIA  
4,338,056 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3551
Total Execution Time  0.3571
  CADENA URL  
/supercopa_europa1998/grupo0/jugadores
  GET DATOS  
$_GET['/supercopa_europa1998/grupo0/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0125  SELECT type FROM routes WHERE alias = 'supercopa_europa1998'
0.0251  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 = 1998 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.0136  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.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 = 11891 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 = 11891 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0129  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 = 11891 AND dt.id IN (429,530) ORDER BY dt.relations DESC,dp.role ASC
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 15:36:21' 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-01 15:36:21' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-01 15:36:21' 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-01 15:36:21' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0128  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 133 AND l.year = 1998
0.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events1998 e WHERE e.league_id IN (11891) 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.0129  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 (11891) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (89153,252436,258382,264956) ORDER BY rp.in_squad = 1 DESC
0.0128  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 133 AND l.year = 1998
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events1998 e WHERE e.league_id IN (11891) 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 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 (11891) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (5936,257879,266355,266561,267205) ORDER BY rp.in_squad = 1 DESC
0.0127  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 133 AND l.year = 1998
0.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events1998 e WHERE e.league_id IN (11891) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10