4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
13 jugadores
PSV PSV
Koch Koch 52 años 193cm 90kg POR
Arthur Numan Arthur Numan 54 años 182cm DEF
Z. Petrovic Z. Petrovic 58 años DEF
S. Valckx S. Valckx 60 años DEF
Jaap Stam Jaap Stam 51 años 191cm 89kg DEF
A. Bruggink A. Bruggink 46 años 184cm 81kg MED
B. Zenden B. Zenden 47 años 174cm 70kg MED
Wim Jonk Wim Jonk 57 años 185cm 77kg MED
P. Cocu P. Cocu 53 años 183cm 70kg MED
Demo Demo 48 años 185cm 78kg MED
Vampeta Vampeta 50 años 183cm 78kg MED
Degryse Degryse 58 años 173cm 69kg DEL
G. De Bilde G. De Bilde 52 años 180cm 72kg DEL
14 jugadores
Roda JC Roda JC
N. Damjanac N. Damjanac 52 años POR
J. Valgaeren J. Valgaeren 48 años DEF
Melvin Plet Melvin Plet 49 años 180cm 72kg DEF
Ramon Van Haaren Ramon Van Haaren 51 años 180cm 70kg DEF
Ger Senden Ger Senden 52 años 183cm 70kg DEF
Regillio Vrede Regillio Vrede 51 años 198cm DEF
A. Ooijer A. Ooijer 49 años 185cm 74kg DEF
Jan-Pieter Martens Jan-Pieter Martens 49 años 175cm 70kg MED
Maarten Schops Maarten Schops 48 años 180cm 73kg MED
Edwin Grünholz Edwin Grünholz 54 años MED
Arnold Doomernik Arnold Doomernik 53 años MED
Eric Van Der Luer Eric Van Der Luer 58 años MED
Peter Van Houdt Peter Van Houdt 47 años 175cm 70kg DEL
B. Peeters B. Peeters 50 años 196cm 83kg DEL

Equipos de esta liga

2

  USO DE MEMORIA  
4,291,432 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0665
Total Execution Time  0.0685
  CADENA URL  
/supercopa_holanda1997/grupo0/jugadores
  GET DATOS  
$_GET['/supercopa_holanda1997/grupo0/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0018  SELECT type FROM routes WHERE alias = 'supercopa_holanda1997'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'supercopa_holanda' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1997 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=298 AND type_rel = 3
0.0028  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 298 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0029  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 (1271603,1168754,1168680,1167983,1028543) ORDER BY n.cover_points DESC, update_date DESC
0.0021  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 = 25255 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 25255 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0034  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 = 25255 AND dt.id IN (2023,2174) ORDER BY dt.relations DESC,dp.role ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 14:54:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 14:54:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 14:54:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 14:54:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 298 AND l.year = 1997
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (25255) 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.0021  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 (25255) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (5891,4927,265730) ORDER BY rp.in_squad = 1 DESC
0.0021  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 298 AND l.year = 1997
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (25255) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0020  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 (25255) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (1467,264900) ORDER BY rp.in_squad = 1 DESC
0.0021  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 298 AND l.year = 1997
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events1997 e WHERE e.league_id IN (25255) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10