4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
24 jugadores
Avance Ezcabarte Avance Ezcabarte
F. Javier F. Javier
J. Musquiz J. Musquiz
Gallego Gallego POR
Catalán Catalán 29 años POR
D. Izquierdo D. Izquierdo DEF
Patxi Patxi DEF
Joseba Joseba DEF
I. Lecumberri I. Lecumberri DEF
Peio Peio 30 años DEF
Iñigo Nuin Iñigo Nuin DEF
Gorka Gorka DEF
G. Casajús G. Casajús DEF
Baranda Baranda 33 años DEF
Juan Carlos Juan Carlos DEF
Mikel Eguillor Mikel Eguillor DEF
J. Weiler J. Weiler MED
I. Sierra I. Sierra 30 años MED
Asier Asier MED
Marcos Marcos MED
J. García J. García MED
Txus Txus 30 años MED
Oteiza Oteiza 29 años MED
X. Zabalza X. Zabalza MED
Andrés Sáez Andrés Sáez DEL

Clasificación

Equipo PJ GF GC Puntos
1 Avance Ezcabarte Avance 18 45 17 45
2 Erriberri Erriberri 18 36 19 38
3 Gares Gares 18 30 18 33
4 CD Zirauki CD Zirauki 18 24 21 28
5 CD Iruña CD Iruña 18 21 19 25
6 Zarramonza Zarramonza 18 26 28 22
7 CF Beti Casedano Beti 18 25 34 20
8 Lagun Artea Lagun Artea 18 24 37 17
9 Burladés B Burladés B 18 17 35 15
10 Infanzones Infanzones 18 16 36 6

  USO DE MEMORIA  
5,819,352 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0035
Controller Execution Time ( Home / Category )  0.0841
Total Execution Time  0.0876
  CADENA URL  
/navarra2021/grupo1/jugadores
  GET DATOS  
$_GET['/navarra2021/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0035  SELECT id,name,alias,stepParent FROM categories WHERE parentId=83 ORDER BY order_id ASC
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 = 61240 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 = 61240 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0080  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 = 61240 AND dt.id IN (1391,989,401,1202,2793,3241,1502,19021,10595,122077) 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-27 19:53:50' 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-27 19:53:50' 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-04-27 19:53:50' 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=3 AND last_update > '2024-04-27 19:53:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0057  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 events2021 e ON e.player_id = p.id AND e.league_id = 61240 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 61240 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.0081  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 events2021 e ON e.player_id = p.id AND e.league_id = 61240 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 61240 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0025  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 events2021 e ON e.player_id = p.id AND e.league_id = 61240 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 61240 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0028  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2021` 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 = 61240 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