4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
18 jugadores
Escocia Sub 17 Escocia Sub 17
R. Mccrorie R. Mccrorie 26 años 188cm 80kg POR
Ross Doohan Ross Doohan 26 años 186cm 73kg POR
Harvey Clair Harvey Clair 25 años 183cm 76kg DEF
Greig Mcnaughton Greig Mcnaughton 26 años DEF
Blair Kidd Blair Kidd 25 años DEF
Thomas Mcintyre Thomas Mcintyre 25 años 185cm 75kg DEF
Mark Finlayson Mark Finlayson 25 años DEF
Regan Hendry Regan Hendry 26 años 176cm 73kg MED
Ross Mccrorie Ross Mccrorie 26 años 187cm 70kg MED
Mark Hill Mark Hill 25 años MED
Philip James Philip James 27 años MED
Sean Mckirdy Sean Mckirdy 26 años 177cm 70kg MED
Calvin Miller Calvin Miller 26 años 182cm 70kg MED
Aaron Norris Aaron Norris 26 años 172cm 64kg MED
Josh Jeffries Josh Jeffries 26 años DEL
Jordan Allan Jordan Allan 25 años 176cm DEL
Alistair Coote Alistair Coote 25 años 170cm 65kg DEL
Frank Ross Frank Ross 26 años 172cm 68kg DEL
18 jugadores
Irlanda Sub 17 Irlanda Sub 17
C. Kelleher C. Kelleher 25 años 188cm 71kg POR
Ross Treacy Ross Treacy 25 años 175cm 70kg POR
Conor Masterson Conor Masterson 25 años 185cm 72kg DEF
Robert Mccourt Robert Mccourt 26 años 178cm 64kg DEF
Shane Hanney Shane Hanney 26 años 182cm 74kg DEF
Darragh Leahy Darragh Leahy 26 años 177cm 72kg DEF
T. Clarke T. Clarke 26 años 165cm 64kg DEF
Corey O'keeffe Corey O'keeffe 25 años 184cm 70kg DEF
Josh Barrett Josh Barrett 25 años 181cm 71kg MED
Jake Doyle Jake Doyle 25 años 175cm 68kg MED
Avis Ganiyu Avis Ganiyu 26 años MED
Jonathan Lunney Jonathan Lunney 26 años 175cm 70kg MED
Conor Levingston Conor Levingston 26 años 175cm MED
Brandon Payne Brandon Payne 26 años MED
Conor Davis Conor Davis 25 años 165cm DEL
Gerry Mcdonagh Gerry Mcdonagh 26 años 193cm 69kg DEL
Z. Elbouzedi Z. Elbouzedi 26 años 185cm 70kg DEL
Steven Kinsella Steven Kinsella 25 años 175cm 72kg DEL
18 jugadores
Islas Feroe Sub 17 Islas Feroe
Bárdur Reynatröd Bárdur Reynatröd 24 años 191cm POR
Silas Eydsteinsson Silas Eydsteinsson 26 años 188cm POR
Eyðstein Zachariasen Eyðstein Zachariasen 25 años DEF
Johan Hognesen Johan Hognesen 25 años 170cm DEF
Bjarni Petersen Bjarni Petersen 25 años 188cm DEF
Ari Olsen Ari Olsen 25 años 185cm DEF
Svein Magnussen Svein Magnussen 25 años DEF
J. Andreasen J. Andreasen 25 años 188cm MED
Johann Gaardbo Johann Gaardbo 25 años MED
Fannhard Skoradal Fannhard Skoradal 25 años MED
Morits Mortensen Morits Mortensen 25 años MED
Janus Samuelsen Janus Samuelsen 25 años 180cm MED
Hannes Agnarsson Hannes Agnarsson 25 años 185cm DEL
David Muller David Muller 25 años DEL
Adrian Justinussen Adrian Justinussen 25 años 180cm 70kg DEL
Petur Knudsen Petur Knudsen 26 años 180cm DEL
Teit Jacobsen Teit Jacobsen 26 años 185cm 80kg DEL
Paetur Petersen Paetur Petersen 26 años 181cm DEL
18 jugadores
Gibraltar Sub 17 Gibraltar
Ayden Vinales Ayden Vinales 26 años 167cm POR
Bradley Banda Bradley Banda 26 años 183cm POR
Jayce Olivero Jayce Olivero 25 años 182cm 77kg DEF
Philip Gillingwater Philip Gillingwater 25 años DEF
Jaime Serra Jaime Serra 25 años 174cm DEF
Kevagn Ronco Kevagn Ronco 26 años 176cm DEF
Ethan Britto Ethan Britto 23 años 178cm DEF
Cecil Prescott Cecil Prescott 24 años DEF
Leon Payas Leon Payas 26 años DEF
Liam Crisp Liam Crisp 24 años 175cm DEF
Leon Clinton Leon Clinton 25 años 170cm MED
Karl Poggio Karl Poggio 25 años MED
Andrew Hernandez Andrew Hernandez 25 años 174cm MED
Max Cottrell Max Cottrell 24 años 180cm MED
Shaun De Los Santos Shaun De Los Santos 26 años MED
Byron Espinosa Byron Espinosa 25 años DEL
Theo Pizarro Theo Pizarro 25 años 184cm DEL
Liam Thorne Liam Thorne 26 años DEL

Clasificación

Equipo PJ GF GC Puntos
1 Escocia Sub 17 Escocia 3 8 0 7
2 Irlanda Sub 17 Irlanda 3 9 2 7
3 Islas Feroe Sub 17 Islas Feroe 3 2 8 1
4 Gibraltar Sub 17 Gibraltar 3 0 9 1

  USO DE MEMORIA  
4,676,288 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0039
Controller Execution Time ( Home / Category )  0.1110
Total Execution Time  0.1150
  CADENA URL  
/clasificacion_europeo_sub_172015/grupo1/jugadores
  GET DATOS  
$_GET['/clasificacion_europeo_sub_172015/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0018  SELECT type FROM routes WHERE alias = 'clasificacion_europeo_sub_172015'
0.0050  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clasificacion_europeo_sub_17' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2015 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1861 AND type_rel = 3
0.0022  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1861 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0028  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 (1307751,1241421,1240622,1120790,1119720) ORDER BY n.cover_points DESC, update_date DESC
0.0019  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 = 58151 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 58151 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0033  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 = 58151 AND dt.id IN (63714,63716,88874,88889) ORDER BY dt.relations DESC,dp.role ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 15:17:18' 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-28 15:17:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 15:17:18' 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=3 AND last_update > '2024-04-28 15:17:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clasificacion_europeo_sub_17' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2015 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0040  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1861 AND l.year = 2015
0.0044  SELECT e.action, count(e.action) as total, e.player_id FROM events2015 e WHERE e.league_id IN (58151,58152,58153,58154,58155,58156,58157,58158,58159,58160,58161,58162,58163,58164,58165,58166,58167,58168,58169,58170,58171) 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.0025  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 (58151,58152,58153,58154,58155,58156,58157,58158,58159,58160,58161,58162,58163,58164,58165,58166,58167,58168,58169,58170,58171) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (309791,309616,230248,295740,285900,297325,309748,319445,341409,92382) ORDER BY rp.in_squad = 1 DESC
0.0028  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1861 AND l.year = 2015
0.0077  SELECT e.action, count(e.action) as total, e.player_id FROM events2015 e WHERE e.league_id IN (58151,58152,58153,58154,58155,58156,58157,58158,58159,58160,58161,58162,58163,58164,58165,58166,58167,58168,58169,58170,58171) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0026  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 (58151,58152,58153,58154,58155,58156,58157,58158,58159,58160,58161,58162,58163,58164,58165,58166,58167,58168,58169,58170,58171) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (308110,92382,276933,286266,290415,290750,296255,326466,343059,344169) ORDER BY rp.in_squad = 1 DESC
0.0030  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1861 AND l.year = 2015
0.0026  SELECT e.action, count(e.action) as total, e.player_id FROM events2015 e WHERE e.league_id IN (58151,58152,58153,58154,58155,58156,58157,58158,58159,58160,58161,58162,58163,58164,58165,58166,58167,58168,58169,58170,58171) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0027  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 (58151,58152,58153,58154,58155,58156,58157,58158,58159,58160,58161,58162,58163,58164,58165,58166,58167,58168,58169,58170,58171) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (223450,248652,251055,282841,286266,290415,290750,290777,295692,302257) ORDER BY rp.in_squad = 1 DESC
0.0049  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2015` 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 = 58151 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC