4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
23 jugadores
Portugal Sub 21 Portugal Sub 21
Francisco Meixedo Francisco Meixedo 22 años 190cm 73kg POR
Samuel Soares Samuel Soares 21 años 190cm 93kg POR
Celton Biai Celton Biai 23 años 188cm 82kg POR
L. Lelo L. Lelo 24 años 175cm 70kg DEF
Zé Carlos Zé Carlos 22 años 172cm 60kg DEF
Alexandre Penetra Alexandre Penetra 22 años 186cm 73kg DEF
Tomás Araújo Tomás Araújo 21 años 187cm 79kg DEF
Bernardo Vital Bernardo Vital 23 años 187cm 77kg DEF
André Amaro André Amaro 21 años 188cm 76kg DEF
Nuno Tavares Nuno Tavares 24 años 183cm 75kg DEF
Afonso Sousa Afonso Sousa 24 años 174cm 65kg MED
Vasco Sousa Vasco Sousa 21 años 164cm 56kg MED
João Neves João Neves 19 años 174cm 60kg MED
Samú Costa Samú Costa 23 años 185cm 75kg MED
André Almeida André Almeida 23 años 176cm 62kg MED
Paulo Bernardo Paulo Bernardo 22 años 180cm 78kg MED
Tiago Dantas Tiago Dantas 23 años 170cm 58kg MED
Henrique Araújo Henrique Araújo 22 años 182cm 75kg DEL
F. Conceição F. Conceição 21 años 170cm 64kg DEL
Diego Moreira Diego Moreira 19 años 179cm 69kg DEL
Vitinha Vitinha 24 años 178cm 70kg DEL
Fábio Silva Fábio Silva 21 años 185cm 75kg DEL
Pedro Neto Pedro Neto 24 años 172cm 62kg DEL
23 jugadores
Países Bajos Sub 21 Países Bajos
B. Verbruggen B. Verbruggen 21 años 194cm 75kg POR
Kjell Scherpen Kjell Scherpen 24 años 206cm 98kg POR
J. Schendelaar J. Schendelaar 23 años 186cm 75kg POR
J. Van Hecke J. Van Hecke 23 años 189cm 75kg DEF
S. Sambo S. Sambo 22 años 174cm 65kg DEF
M. Van De Ven M. Van De Ven 23 años 193cm 81kg DEF
Milan Van Ewijk Milan Van Ewijk 23 años 175cm 70kg DEF
Ian Maatsen Ian Maatsen 22 años 178cm 57kg DEF
Q. Hartman Q. Hartman 22 años 183cm 75kg DEF
Devyne Rensch Devyne Rensch 21 años 179cm 63kg DEF
R. Gravenberch R. Gravenberch 21 años 190cm 75kg MED
Ludovit Reis Ludovit Reis 23 años 178cm 78kg MED
Wouter Burger Wouter Burger 23 años 191cm 73kg MED
Sven Mijnans Sven Mijnans 24 años 190cm 70kg MED
Quinten Timber Quinten Timber 22 años 179cm 71kg MED
J. Ekkelenkamp J. Ekkelenkamp 24 años 188cm 83kg MED
K. Taylor K. Taylor 21 años 182cm 66kg MED
E. Tavşan E. Tavşan 23 años 183cm 74kg DEL
C. Summerville C. Summerville 22 años 174cm 66kg DEL
M. Manhoef M. Manhoef 22 años 179cm 71kg DEL
Brian Brobbey Brian Brobbey 22 años 180cm 78kg DEL
Thijs Dallinga Thijs Dallinga 23 años 190cm 64kg DEL
Joshua Zirkzee Joshua Zirkzee 22 años 193cm 84kg DEL
23 jugadores
Bélgica Sub 21 Bélgica Sub 21
Maxime Delanghe Maxime Delanghe 22 años 189cm 83kg POR
M. Vandevoordt M. Vandevoordt 22 años 192cm 76kg POR
S. Lammens S. Lammens 21 años 193cm 92kg POR
Koni De Winter Koni De Winter 21 años 191cm 74kg DEF
Hugo Siquet Hugo Siquet 21 años 180cm 66kg DEF
A. Al-Dakhil A. Al-Dakhil 22 años 187cm 70kg DEF
Maxim De Cuyper Maxim De Cuyper 23 años 182cm 66kg DEF
E. Pletinckx E. Pletinckx 23 años 190cm 87kg DEF
Olivier Deman Olivier Deman 24 años 181cm 74kg DEF
Zeno Debast Zeno Debast 20 años 191cm 73kg DEF
Louis Patris Louis Patris 22 años 187cm 75kg DEF
I. Van Der Brempt I. Van Der Brempt 22 años 187cm 74kg DEF
Eliot Matazo Eliot Matazo 22 años 170cm 74kg MED
Mandela Keita Mandela Keita 21 años 180cm 78kg MED
A. Vranckx A. Vranckx 21 años 183cm 78kg MED
Arne Engels Arne Engels 20 años 185cm 71kg MED
N. Raskin N. Raskin 23 años 178cm 74kg MED
C. De Ketelaere C. De Ketelaere 23 años 192cm 74kg MED
Anthony Descotte Anthony Descotte 20 años 180cm 75kg DEL
Michel Balikwisha Michel Balikwisha 22 años 178cm 69kg DEL
Y. Vertessen Y. Vertessen 23 años 176cm 69kg DEL
Loïs Openda Loïs Openda 24 años 177cm 67kg DEL
L. Ramazani L. Ramazani 23 años 168cm 55kg DEL
23 jugadores
Georgia Sub 21 Georgia Sub 21
Luka Kutaladze Luka Kutaladze 23 años 190cm POR
G. Mamardashvili G. Mamardashvili 23 años 197cm 87kg POR
Nodari Kalichava Nodari Kalichava 23 años 191cm POR
Saba Sazonov Saba Sazonov 22 años 194cm 82kg DEF
Tsotne Kapanadze Tsotne Kapanadze 22 años 173cm DEF
A. Kalandadze A. Kalandadze 22 años 188cm DEF
Irakli Azarov Irakli Azarov 22 años 179cm DEF
G. Gocholeishvili G. Gocholeishvili 23 años 178cm DEF
S. Khvadagiani S. Khvadagiani 21 años 186cm DEF
Iva Gelashvili Iva Gelashvili 23 años 191cm DEF
J. Jinjolava J. Jinjolava 23 años 181cm DEF
G. Moistsrapeshvili G. Moistsrapeshvili 22 años 183cm MED
Nika Gagnidze Nika Gagnidze 23 años 180cm MED
Luka Gagnidze Luka Gagnidze 21 años 175cm 72kg MED
Otar Mamageishvili Otar Mamageishvili 21 años 180cm MED
Gabriel Sigua Gabriel Sigua 18 años 190cm 70kg MED
A. Mekvabishvili A. Mekvabishvili 22 años 174cm MED
Nodar Lominadze Nodar Lominadze 22 años 194cm MED
Nika Khorkheli Nika Khorkheli 22 años 176cm 67kg DEL
Z. Davitashvili Z. Davitashvili 23 años 175cm 63kg DEL
Giorgi Gagua Giorgi Gagua 22 años 193cm 71kg DEL
G. Tsitaishvili G. Tsitaishvili 23 años 171cm 63kg DEL
Giorgi Guliashvili Giorgi Guliashvili 22 años 175cm DEL

Clasificación

Equipo PJ GF GC Puntos
1 Georgia Sub 21 Georgia 3 5 3 5
2 Portugal Sub 21 Portugal 3 3 4 4
3 Países Bajos Sub 21 Países 3 2 2 3
4 Bélgica Sub 21 Bélgica 3 3 4 2

  USO DE MEMORIA  
4,725,808 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0778
Total Execution Time  0.0798
  CADENA URL  
/europeo_sub_212023/grupo1/jugadores
  GET DATOS  
$_GET['/europeo_sub_212023/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0018  SELECT type FROM routes WHERE alias = 'europeo_sub_212023'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'europeo_sub_21' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=176 AND type_rel = 3
0.0037  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 176 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (1306837,1289144,1277910,1267030,1266707) ORDER BY n.cover_points DESC, update_date DESC
0.0020  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 = 70116 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 = 70116 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0035  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 = 70116 AND dt.id IN (6333,11673,13664,13647) 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-05-09 01:37:38' 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=2 AND last_update > '2024-05-09 01:37:38' 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=4 AND last_update > '2024-05-09 01:37:38' 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-05-09 01:37:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'europeo_sub_21' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0019  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 176 AND l.year = 2023
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (70116,70117,70118,70119,72346) 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 (70116,70117,70118,70119,72346) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (317325,342269,776757,316654,342270,346857,427259,427689,427872,705838) ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 176 AND l.year = 2023
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (70116,70117,70118,70119,72346) AND (e.action = 4 or e.action = 5) 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 (70116,70117,70118,70119,72346) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (307331,342393,347409,346857,348829,366796,427257,427763,427819,429356) ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 176 AND l.year = 2023
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (70116,70117,70118,70119,72346) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0023  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 (70116,70117,70118,70119,72346) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (307331,342393,347409,573136,798581,798680) ORDER BY rp.in_squad = 1 DESC
0.0026  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` 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 = 70116 AND t.round = 3 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC