4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
30 jugadores
PSV PSV
L. Koopmans L. Koopmans 30 años 190cm 76kg POR
R. Pasveer R. Pasveer 40 años 187cm 88kg POR
Jeroen Zoet Jeroen Zoet 33 años 189cm 87kg POR
K. Paal K. Paal 26 años 174cm 70kg DEF
Jetro Willems Jetro Willems 30 años 177cm 66kg DEF
Menno Koch Menno Koch 29 años 195cm 78kg DEF
H. Moreno H. Moreno 36 años 186cm 80kg DEF
Simon Poulsen Simon Poulsen 39 años 184cm 81kg DEF
S. Arias S. Arias 32 años 178cm 72kg DEF
N. Isimat-Mirin N. Isimat-Mirin 32 años 187cm 83kg DEF
S. Alberto S. Alberto 27 años 178cm 68kg DEF
J. De Wijs J. De Wijs 29 años 189cm 84kg DEF
J. Brenet J. Brenet 30 años 181cm 74kg DEF
J. Hendrix J. Hendrix 29 años 181cm 70kg MED
D. Rigo D. Rigo 25 años 180cm 72kg MED
Davy Pröpper Davy Pröpper 32 años 185cm 79kg MED
A. Guardado A. Guardado 37 años 167cm 60kg MED
R. Lundqvist R. Lundqvist 26 años 183cm 72kg MED
S. Schaars S. Schaars 40 años 178cm 75kg MED
Gastón Pereiro Gastón Pereiro 28 años 188cm 75kg MED
L. Narsingh L. Narsingh 33 años 175cm 69kg MED
Adam Maher Adam Maher 30 años 174cm 73kg MED
Luuk De Jong Luuk De Jong 33 años 188cm 80kg DEL
Beto Da Silva Beto Da Silva 27 años 178cm 69kg DEL
A. Boljević A. Boljević 28 años 185cm 57kg DEL
S. Bergwijn S. Bergwijn 26 años 178cm 74kg DEL
J. Locadia J. Locadia 30 años 191cm 79kg DEL
F. Jozefzoon F. Jozefzoon 33 años 173cm 70kg DEL
Maxime Lestienne Maxime Lestienne 31 años 176cm 63kg DEL
R. Vloet R. Vloet 28 años 188cm 75kg DEL
28 jugadores
Feyenoord Feyenoord
K. Miazek K. Miazek 27 años 192cm 77kg POR
P. Hansson P. Hansson 37 años 185cm 84kg POR
B. Jones B. Jones 42 años 194cm 76kg POR
W. Hahn W. Hahn 31 años 190cm 96kg POR
Justin Bijlow Justin Bijlow 26 años 188cm 76kg POR
K. Vermeer K. Vermeer 38 años 182cm 78kg POR
J. Van Der Heijden J. Van Der Heijden 36 años 175cm 71kg DEF
S. Van Beek S. Van Beek 29 años 189cm 76kg DEF
M. Nelom M. Nelom 33 años 174cm 69kg DEF
E. Botteghin E. Botteghin 36 años 193cm 89kg DEF
R. Karsdorp R. Karsdorp 29 años 184cm 80kg DEF
B. Nieuwkoop B. Nieuwkoop 28 años 181cm 72kg DEF
W. Dammers W. Dammers 29 años 185cm 68kg DEF
Terence Kongolo Terence Kongolo 30 años 188cm 70kg DEF
L. Woudenberg L. Woudenberg 30 años 186cm 74kg DEF
M. Vejinovic M. Vejinovic 34 años 186cm 67kg MED
K. El Ahmadi K. El Ahmadi 39 años 179cm 78kg MED
Simon Gustafson Simon Gustafson 29 años 185cm 74kg MED
Jens Toornstra Jens Toornstra 35 años 178cm 74kg MED
Tonny Vilhena Tonny Vilhena 29 años 175cm 73kg MED
Renato Tapia Renato Tapia 28 años 185cm 80kg MED
E. Elia E. Elia 37 años 176cm 70kg DEL
Nicolai Jørgensen Nicolai Jørgensen 33 años 190cm 83kg DEL
N. Robertha N. Robertha 26 años 182cm 73kg DEL
E. Hansson E. Hansson 25 años 172cm 64kg DEL
M. Kramer M. Kramer 35 años 196cm 80kg DEL
D. Kuyt D. Kuyt 43 años 184cm 77kg DEL
B. Basaçikoglu B. Basaçikoglu 29 años 179cm 70kg DEL

Equipos de esta liga

2

  USO DE MEMORIA  
4,466,664 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3669
Total Execution Time  0.3689
  CADENA URL  
/supercopa_holanda2017/grupo0/jugadores
  GET DATOS  
$_GET['/supercopa_holanda2017/grupo0/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0126  SELECT type FROM routes WHERE alias = 'supercopa_holanda2017'
0.0253  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 = 2017 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=298 AND type_rel = 3
0.0128  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.0129  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.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=298 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 = 28005 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 28005 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0136  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 = 28005 AND dt.id IN (2023,1135) 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-03 09:46:10' 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-03 09:46:10' 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-03 09:46:10' 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-03 09:46:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 298 AND l.year = 2017
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events2017 e WHERE e.league_id IN (28005) 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 (28005) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (107897) ORDER BY rp.in_squad = 1 DESC
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 298 AND l.year = 2017
0.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events2017 e WHERE e.league_id IN (28005) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0128  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 (28005) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (68372,85181,124974) ORDER BY rp.in_squad = 1 DESC
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 298 AND l.year = 2017
0.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events2017 e WHERE e.league_id IN (28005) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10