4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
18 jugadores
España Sub 19 España Sub 19
Rubén Rubén 39 años 187cm 80kg POR
Miguel Ángel Moyá Miguel Ángel Moyá 40 años 185cm 75kg POR
Tarantino Tarantino 39 años 182cm 77kg DEF
Alexis Alexis 38 años 183cm 75kg DEF
Melli Melli 39 años 184cm 75kg DEF
Miguel Flaño Miguel Flaño 39 años 177cm 72kg DEF
Migue Migue 40 años DEF
C. García C. García 40 años 184cm 82kg DEF
Eizaguirre Eizaguirre 40 años 188cm 79kg MED
Juanlu Hens Juanlu Hens 40 años 178cm 76kg MED
Javi Fuego Javi Fuego 40 años 181cm 74kg MED
M. Tello M. Tello 40 años 180cm 70kg MED
Sergio Torres Sergio Torres 40 años 172cm 68kg MED
G. Larrea G. Larrea 40 años 182cm 70kg MED
Bussy Bussy 39 años 180cm 77kg DEL
Manu Del Moral Manu Del Moral 40 años 186cm 77kg DEL
J. Gavilán J. Gavilán 38 años 178cm 71kg DEL
R. Soldado R. Soldado 38 años 180cm 74kg DEL
26 jugadores
Italia Sub 19 Italia Sub 19
Daniele Tazza Daniele Tazza 40 años POR
Marco Paoloni Marco Paoloni 40 años 186cm 81kg POR
Andrea Ivaldi Andrea Ivaldi 40 años 182cm POR
Damiano Ferronetti Damiano Ferronetti 39 años 184cm 74kg DEF
Mirko Stefani Mirko Stefani 40 años 180cm 80kg DEF
Giorgio Chiellini Giorgio Chiellini 39 años 187cm 86kg DEF
Andrea Mantovani Andrea Mantovani 39 años 185cm 77kg DEF
Gabriele Perico Gabriele Perico 40 años 183cm 79kg DEF
G. Bartolucci G. Bartolucci 40 años 183cm 76kg DEF
Mauro Belotti Mauro Belotti 39 años 185cm 84kg DEF
Giuseppe Scurto Giuseppe Scurto 40 años 191cm 80kg DEF
P. Cotroneo P. Cotroneo 40 años DEF
Alessandro Potenza Alessandro Potenza 40 años 185cm 79kg DEF
E. Corsi E. Corsi 39 años 179cm 72kg MED
A. Armenise A. Armenise 39 años MED
Simone Padoin Simone Padoin 40 años 179cm 74kg MED
F. Porcari F. Porcari 40 años 176cm 73kg MED
Paolo Facchinetti Paolo Facchinetti 40 años MED
Adriano D´astolfo Adriano D´astolfo 40 años 177cm MED
Francesco Lodi Francesco Lodi 40 años 183cm 70kg MED
Simon Laner Simon Laner 40 años 182cm 75kg MED
Alberto Aquilani Alberto Aquilani 39 años 185cm 81kg MED
Alex Gibbs Alex Gibbs 40 años 193cm 93kg DEL
Luigi Della Rocca Luigi Della Rocca 39 años 185cm 75kg DEL
Paolo De Crescenzo Paolo De Crescenzo 40 años DEL
Giampaolo Pazzini Giampaolo Pazzini 39 años 180cm 74kg DEL
16 jugadores
República Checa Sub 19 República Checa
Petr Bolek Petr Bolek 39 años 190cm 91kg POR
Václav Procházka Václav Procházka 39 años 185cm 79kg DEF
Roman Hubnik Roman Hubnik 39 años 191cm 84kg DEF
M. Latka M. Latka 39 años 192cm 83kg DEF
P. Eismann P. Eismann 39 años 182cm 77kg DEF
Michal Kadlec Michal Kadlec 39 años 185cm 75kg DEF
J. Kaufman J. Kaufman 40 años 188cm 84kg DEF
Lukáš Nachtman Lukáš Nachtman 39 años 194cm 86kg DEF
J. Knobloch J. Knobloch 40 años MED
Martin Klein Martin Klein 39 años 187cm 85kg MED
Galandr Galandr MED
Ladislav Volesak Ladislav Volesak 40 años 174cm 70kg MED
Tomáš Jirásek Tomáš Jirásek 39 años MED
Martin Pulkert Martin Pulkert 40 años 165cm 64kg MED
Adam Varadi Adam Varadi 39 años 178cm 79kg DEL
M. Papadopulos M. Papadopulos 39 años 184cm 79kg DEL

  USO DE MEMORIA  
4,505,664 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  2.4472
Total Execution Time  2.4491
  CADENA URL  
/amistosos_selecciones_sub192002/grupo1/jugadores
  GET DATOS  
$_GET['/amistosos_selecciones_sub192002/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0125  SELECT type FROM routes WHERE alias = 'amistosos_selecciones_sub192002'
0.0254  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'amistosos_selecciones_sub19' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2002 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1987 AND type_rel = 3
0.0128  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1987 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 (1303006,1303000,1216930,1203334,1196364) ORDER BY n.cover_points DESC, update_date DESC
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1987 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 = 41139 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 = 41139 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0137  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 = 41139 AND dt.id IN (6025,9117,9119,9123,63127,6021,6027,18082,6028,6024,63118,66047,11769,66043,137898) ORDER BY dt.relations DESC,dp.role ASC
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-03 20:17:04' 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 20:17:04' 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 20:17:04' 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 20:17:04' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0132  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'amistosos_selecciones_sub19' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2002 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0128  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1987 AND l.year = 2002
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (41139) 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 (41139) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (1273,11072,9534,11931,24359,30725,98943,492622,502428) ORDER BY rp.in_squad = 1 DESC
0.0129  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1987 AND l.year = 2002
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (41139) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
2.0736  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 (41139) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (9534,11072,71168,96724,287153) ORDER BY rp.in_squad = 1 DESC
0.0157  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1987 AND l.year = 2002
0.0127  SELECT e.action, count(e.action) as total, e.player_id FROM events2002 e WHERE e.league_id IN (41139) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10