4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
12 jugadores
Managua Sub 20 Managua Sub 20
D. Mairena D. Mairena
D. García D. García 21 años 179cm
I. Martinez I. Martinez
Y. Espinoza Y. Espinoza
L. Gómez L. Gómez
K. Benavidez K. Benavidez
J. Rubi J. Rubi
M. Huete M. Huete DEF
D. Rocha D. Rocha 21 años MED
J. Martínez J. Martínez 24 años MED
I. Correa I. Correa 29 años MED
J. Herrera J. Herrera 21 años DEL
20 jugadores
Real Estelí Sub 20 Real Estelí
M. Cruz M. Cruz
C. Herrera C. Herrera
J. Arias J. Arias
Aleman Aleman
E. Martínez E. Martínez 22 años DEF
C. Herrera C. Herrera 20 años DEF
L. Castro L. Castro MED
O. Salinas O. Salinas 20 años 170cm MED
Luis Borge Luis Borge 20 años MED
H. Medina H. Medina 22 años MED
K. Batiz K. Batiz 20 años 177cm 74kg MED
Y. López Y. López 21 años DEL
R. Gómez R. Gómez 19 años 167cm DEL
L. Figueroa L. Figueroa DEL
O. Rodríguez O. Rodríguez 19 años DEL
D. Corrales D. Corrales 20 años DEL
W. Talavera W. Talavera 21 años 173cm 50kg DEL
W. Palacios W. Palacios 20 años DEL
E. Castillo E. Castillo 21 años DEL
B. Tenorio B. Tenorio 19 años DEL
13 jugadores
Diriangén Sub 20 Diriangén
J. Aleman J. Aleman
Velez Velez
O. Hernandez O. Hernandez
L. Campos L. Campos 21 años
S. Saballos S. Saballos
D. Sánchez D. Sánchez
M. Daniel Cruz M. Daniel Cruz MED
C. Muñoz C. Muñoz 23 años MED
J. Hurtado J. Hurtado 19 años 172cm 55kg MED
J. Arias J. Arias 22 años 170cm DEL
E. Pérez E. Pérez 23 años 190cm 77kg DEL
M. Molina M. Molina DEL
J. Martinez J. Martinez 34 años 179cm 72kg DEL
14 jugadores
Walter Ferretti Sub 20 Walter Ferretti
L. Solis L. Solis 21 años
D. Calero D. Calero
R. Morales R. Morales
R. Åkeson R. Åkeson 20 años DEF
C. Gaitán C. Gaitán 34 años 173cm 69kg MED
B. Forbes B. Forbes MED
H. Gámez H. Gámez 22 años MED
A. Araica A. Araica MED
F. Gutiérrez F. Gutiérrez MED
C. Pulido C. Pulido MED
B. Ordóñez B. Ordóñez MED
C. Patterson C. Patterson 21 años DEL
U. Jhonson U. Jhonson DEL
S. Aburto S. Aburto DEL
13 jugadores
Juventus Managua Sub 20 Juventus Managua
K. Mirando K. Mirando 21 años
L. Pacheco L. Pacheco
F. Vallecillo F. Vallecillo 21 años 185cm 76kg DEF
J. Sequeira J. Sequeira MED
K. Thomas K. Thomas MED
L. Bonilla L. Bonilla 21 años 178cm 77kg MED
B. Román B. Román 22 años 170cm MED
E. Castañeda E. Castañeda MED
B. Ordóñez B. Ordóñez MED
C. Guevara C. Guevara 25 años MED
D. Aleman D. Aleman 25 años 170cm MED
R. Chávez R. Chávez DEL
J. Montiel J. Montiel DEL
7 jugadores
Dep. Ocotal Sub 20 Dep. Ocotal
Lopez Lopez
J. Mairen J. Mairen
J. Cardoza J. Cardoza 28 años 177cm 74kg DEF
J. Fortin J. Fortin 19 años MED
C. Rodríguez C. Rodríguez 32 años MED
J. Sandoval J. Sandoval MED
L. Tercero L. Tercero DEL
7 jugadores
Municipal Jalapa Sub 20 Municipal Jalapa
K. Benavidez K. Benavidez
J. Sanchez J. Sanchez
J. Gaona J. Gaona
E. Aguilar E. Aguilar
J. López J. López 18 años MED
M. Barahona M. Barahona 18 años MED
J. Herrera J. Herrera 21 años DEL

Clasificación

Equipo PJ GF GC Puntos
1 Real Estelí Sub 20 Real Estelí 18 51 12 49
2 Diriangén Sub 20 Diriangén 18 34 16 39
3 Juventus Managua Sub 20 Juventus 18 29 17 32
4 Managua Sub 20 Managua 18 26 16 28
5 Walter Ferretti Sub 20 Walter 18 26 21 24
6 UNAN Managua Sub 20 UNAN Managua 18 17 25 23
7 Municipal Jalapa Sub 20 Municipal 18 18 25 20
8 Dep. Ocotal Sub 20 Dep. Ocotal 17 13 28 15
9 Real Madriz Sub 20 Real Madriz 18 10 37 11
10 Sport Sébaco Sub 20 Sport 17 11 38 6

  USO DE MEMORIA  
5,257,072 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0683
Total Execution Time  0.0702
  CADENA URL  
/liga_primera_sub_20_nicaragua_apertura2022/grupo1/jugadores
  GET DATOS  
$_GET['/liga_primera_sub_20_nicaragua_apertura2022/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0017  SELECT type FROM routes WHERE alias = 'liga_primera_sub_20_nicaragua_apertura2022'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_primera_sub_20_nicaragua_apertura' AND (l.group_code = 1 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=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2359 AND type_rel = 3
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2359 ORDER BY order_id ASC
0.0018  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 2359 GROUP BY l.categoryId
0.0018  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=2359 GROUP BY l.year ORDER BY l.year 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 = 63540 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0018  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 63540 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0034  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 = 63540 AND dt.id IN (136278,136279,136287,136280,136282,136285,136281,143268,136283,143267) ORDER BY dt.relations DESC,dp.role ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-23 15:37:49' 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-23 15:37:49' 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=4 AND last_update > '2024-04-23 15:37:49' 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-23 15:37:49' 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 = 'liga_primera_sub_20_nicaragua_apertura' 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.0051  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 = 63540 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63540 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.0023  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 = 63540 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63540 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0022  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 = 63540 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63540 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0027  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` 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 = 63540 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC