4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
20 jugadores
Csikszereda Sub 19 Csikszereda
M. Karacsony M. Karacsony 20 años POR
Mátyás Máthé Mátyás Máthé 19 años POR
T. Hadnagy T. Hadnagy 20 años DEF
R. Csala R. Csala 21 años DEF
N. Ketesdi N. Ketesdi 21 años DEF
B. Gergely B. Gergely 21 años 176cm 70kg DEF
O. El Sawy O. El Sawy 20 años MED
Botond Nagy Botond Nagy 20 años MED
D. Vereguț D. Vereguț 20 años MED
B. Sebestyén B. Sebestyén 20 años MED
Márk Boné Márk Boné 19 años MED
L. Finna L. Finna 20 años MED
S. Bujdosó S. Bujdosó 20 años MED
Norbert Balázs Norbert Balázs 21 años MED
Lucian Barsan Lucian Barsan 19 años MED
A. Albu A. Albu 21 años MED
T. Biró T. Biró 20 años DEL
S. Szakacs S. Szakacs 20 años DEL
R. Sándor R. Sándor 20 años DEL
M. Bărăbaș M. Bărăbaș 20 años DEL
20 jugadores
Farul Constanţa Sub 19 Farul Constanţa
David Dinca David Dinca 19 años 199cm POR
Alberto Cimpoesu Alberto Cimpoesu 17 años POR
Denis Curea Denis Curea 20 años DEF
Andrei Borza Andrei Borza 18 años 180cm 72kg DEF
D. Sirbu D. Sirbu 21 años 186cm 80kg DEF
Emanuel Martinovic Emanuel Martinovic 19 años 185cm DEF
Stefan Dutu Stefan Dutu 20 años DEF
G. Danuleasa G. Danuleasa 20 años 187cm 73kg DEF
D. Maftei D. Maftei 19 años 173cm 64kg DEF
C. Mituletu C. Mituletu 20 años DEF
N. Popescu N. Popescu 21 años 187cm 73kg MED
R. Tanasa R. Tanasa 20 años MED
C. Onut C. Onut 20 años MED
S. Bodisteanu S. Bodisteanu 21 años 180cm 65kg MED
R. Mălăele R. Mălăele 21 años 173cm 62kg MED
I. Cojocaru I. Cojocaru 20 años 183cm DEL
S. Agiveli S. Agiveli 20 años DEL
Robert Gabriel Baceanu Robert Gabriel Baceanu 19 años DEL
L. Andronache L. Andronache 20 años 189cm 72kg DEL
Denis Bujor Denis Bujor 19 años 167cm DEL

JUGADORES DESTACADOS


  USO DE MEMORIA  
4,410,720 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.2582
Total Execution Time  0.2601
  CADENA URL  
/liga_rumana_sub192022/grupo0/jugadores
  GET DATOS  
$_GET['/liga_rumana_sub192022/grupo0/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0105  SELECT type FROM routes WHERE alias = 'liga_rumana_sub192022'
0.0212  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_rumana_sub19' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2384 AND type_rel = 3
0.0105  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2384 ORDER BY order_id ASC
0.0106  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 2384 GROUP BY l.categoryId
0.0107  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=2384 GROUP BY l.year ORDER BY l.year DESC
0.0108  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 = 67573 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0110  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 67573 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0116  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 = 67573 AND dt.id IN (138778,102883,138776,143515) ORDER BY dt.relations DESC,dp.role ASC
0.0108  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-23 08:33:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0107  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-23 08:33:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0107  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-23 08:33:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-23 08:33:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0108  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 67573 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 67573 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 LIMIT 10
0.0108  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 67573 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 67573 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0106  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 67573 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 67573 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10