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
Álex Álex 49 años 179cm 73kg POR
R. Valbuena R. Valbuena 49 años 193cm 83kg POR
Quique Medina Quique Medina 49 años 180cm 77kg DEF
Ramón Ramón 49 años 182cm 81kg DEF
Quevedo Quevedo 49 años DEF
Castro Castro 49 años 168cm 62kg DEF
Sergio Korino Sergio Korino 49 años 182cm 73kg DEF
Gerardo Gerardo 49 años 172cm 69kg DEF
Arpón Arpón 49 años 183cm 77kg MED
Pecharromán Pecharromán 49 años 179cm 73kg MED
Xavi Moro Xavi Moro 48 años 176cm 72kg MED
Palacios Palacios 49 años 185cm 84kg MED
Rández Rández 49 años 183cm 77kg MED
Mikel Alonso Mikel Alonso 49 años MED
Sandro Sandro 49 años 170cm 63kg MED
Basaras Basaras 49 años DEL
Emilio Emilio 49 años 166cm 69kg DEL
Aldeondo Aldeondo 49 años 171cm 71kg DEL
14 jugadores
Brasil Sub 19 Brasil Sub 19
Dida Dida 50 años 196cm 85kg POR
Wágner Alves Wágner Alves 50 años 176cm 70kg DEF
Juárez Juárez 50 años 183cm 71kg DEF
Gélson Baresi Gélson Baresi 49 años 180cm 82kg DEF
Marcelinho Paulista Marcelinho Paulista 50 años 179cm 73kg MED
Yan Yan 48 años MED
Sávio Sávio 50 años 175cm 69kg MED
Rodrigo Carbone Rodrigo Carbone 50 años 179cm 71kg MED
André Luis André Luis 50 años MED
Emerson Emerson 50 años 181cm 75kg MED
Tomy Adriano Giacomeli Tomy Adriano Giacomeli 50 años 187cm MED
Paulo Miranda Paulo Miranda 50 años MED
Gian Gian 49 años 174cm 75kg MED
Magrao Giuliano Magrao Giuliano 50 años DEL
12 jugadores
Colombia Sub 19 Colombia Sub 19
César Jaramillo César Jaramillo 50 años
D. Vélez D. Vélez 50 años POR
J. González J. González 49 años DEF
F. Oviedo F. Oviedo 50 años 185cm 74kg MED
J. Moreno J. Moreno 30 años 175cm 73kg MED
Wilmer Ortegón Wilmer Ortegón 50 años 178cm 78kg MED
J. Garcia J. Garcia 47 años 174cm 69kg MED
Jhon Tierradentro Jhon Tierradentro 50 años 185cm 81kg MED
Francisco Mosquera Francisco Mosquera 50 años 174cm 73kg MED
Nixon Perea Nixon Perea 50 años 181cm MED
O. Restrepo O. Restrepo 50 años MED
Andrés Felipe Andrés Felipe 47 años DEL
17 jugadores
Chile Sub 19 Chile Sub 19
Á. Varas Á. Varas 48 años POR
R. Rojas R. Rojas 49 años DEF
Carlos Valenzuela Carlos Valenzuela 50 años DEF
Max Müller Max Müller 51 años 172cm 72kg DEF
F. Rojas F. Rojas 49 años DEF
Daniel Véliz Daniel Véliz 50 años DEF
Sergio Villegas Sergio Villegas 50 años MED
Ricardo Lyon Trapp Ricardo Lyon Trapp 50 años MED
Juan Silva Juan Silva 49 años MED
Milton Flores Milton Flores 50 años MED
Freddy Ferragut Freddy Ferragut 49 años 178cm 76kg MED
Mella Mella 49 años MED
Clarence Acuña Clarence Acuña 49 años 174cm 76kg MED
Sergio Vargas Sergio Vargas 50 años DEL
Sebastián Rozental Sebastián Rozental 47 años 178cm 79kg DEL
Fran Torré Fran Torré 49 años DEL
Marcelo Salas Marcelo Salas 49 años 173cm 73kg DEL
1 jugadores
Venezuela Sub 19 Venezuela
Danny Vigas Danny Vigas 50 años 186cm 85kg POR

Clasificación

Equipo PJ GF GC Puntos
1 España Sub 19 España 7 9 7 13
2 Chile Sub 19 Chile 2 2 1 4
3 Brasil Sub 19 Brasil 1 2 0 3
4 Colombia Sub 19 Colombia 1 1 2 0
5 Venezuela Sub 19 Venezuela 1 1 2 0
6 Ecuador Sub 19 Ecuador 1 0 1 0
7 Cuba Sub 19 Cuba Sub 19 1 1 3 0

  USO DE MEMORIA  
4,733,496 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0023
Controller Execution Time ( Home / Category )  0.4573
Total Execution Time  0.4596
  CADENA URL  
/amistosos_selecciones_sub191992/grupo1/jugadores
  GET DATOS  
$_GET['/amistosos_selecciones_sub191992/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0145  SELECT type FROM routes WHERE alias = 'amistosos_selecciones_sub191992'
0.0291  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 = 1992 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1987 AND type_rel = 3
0.0146  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.0147  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.0145  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1987 ORDER BY order_id ASC
0.0145  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 = 57807 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 57807 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0153  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 = 57807 AND dt.id IN (6025,106079,106100,106081,138017,138018,138019) ORDER BY dt.relations DESC,dp.role ASC
0.0149  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-30 20:54:53' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-30 20:54:53' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-30 20:54:53' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-30 20:54:53' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0292  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 = 1992 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0148  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1987 AND l.year = 1992
0.0149  SELECT e.action, count(e.action) as total, e.player_id FROM events1992 e WHERE e.league_id IN (57807) 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.0150  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 (57807) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (258229,257723,258006,258018,259278,260281,265540,271395,360610,458510) ORDER BY rp.in_squad = 1 DESC
0.0158  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1987 AND l.year = 1992
0.0153  SELECT e.action, count(e.action) as total, e.player_id FROM events1992 e WHERE e.league_id IN (57807) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0160  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1987 AND l.year = 1992
0.0147  SELECT e.action, count(e.action) as total, e.player_id FROM events1992 e WHERE e.league_id IN (57807) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0156  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1992` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 57807 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC