4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
23 jugadores
Sabiñánigo Sabiñánigo
L. Lopez L. Lopez
J. Zamora J. Zamora
C. Garcia C. Garcia
D. Arechavaleta D. Arechavaleta
F. Navarro F. Navarro
A. Suleiman A. Suleiman
A. Vargas A. Vargas 25 años POR
Ivan Toro Ivan Toro DEF
Villar Villar 30 años DEF
Héctor Héctor 25 años DEF
P. Anies P. Anies DEF
Cabrero Cabrero DEF
R. Cristea R. Cristea DEF
J. Gorgas J. Gorgas 27 años 171cm 64kg DEF
F. Blasco F. Blasco MED
A. Tanase A. Tanase MED
P. Ara P. Ara MED
Erick Sebastian Erick Sebastian MED
D. Angoy D. Angoy MED
A. Herranz A. Herranz MED
D. Grasa D. Grasa MED
J. Monge J. Monge MED
Berrendo Berrendo 32 años DEL
23 jugadores
San Lorenzo Flumen Lorenzo Flumen
D. Sierra D. Sierra
G. Piedrafita G. Piedrafita
G. Casado G. Casado
J. Gaibor J. Gaibor
O. Pardo O. Pardo
Hector Olivan Raya Hector Olivan Raya 32 años
M. Juste M. Juste
A. Claraco A. Claraco
M. Blasco M. Blasco
Pablo Pablo POR
Raul Raul POR
Angel Angel 44 años DEF
F. Latorre F. Latorre 26 años 185cm 84kg DEF
A. Arnal A. Arnal MED
Mostafa Mostafa MED
Beired Beired MED
Gabriel Gabriel MED
Joserra Joserra MED
David David 27 años MED
Claver Claver MED
Daniel J Daniel J MED
Sampere Sampere DEL
Agustín Peralta Agustín Peralta DEL
26 jugadores
Huesca B Huesca B
Víctor Otín Víctor Otín 25 años POR
Biarge Biarge 20 años POR
J. Gasca J. Gasca 24 años 193cm 92kg POR
Nogueras Nogueras 46 años DEF
Arnedillo Arnedillo 29 años 182cm 77kg DEF
D. Fonte D. Fonte 24 años DEF
Lorenzo Lorenzo DEF
C. Villellas C. Villellas 24 años DEF
Suso Suso 28 años DEF
D. Arnedillo D. Arnedillo 24 años 174cm DEF
J. Val J. Val 25 años DEF
H. Espierrez H. Espierrez DEF
J. Olivan J. Olivan 28 años MED
C. Puente C. Puente MED
Carlos Calvo Carlos Calvo 29 años MED
G. Ojeda G. Ojeda 25 años MED
R. Carrasco R. Carrasco 22 años MED
Pablo Tomeo Pablo Tomeo 24 años 186cm MED
D. Cortes D. Cortes 22 años MED
D. Cabrero D. Cabrero 24 años 166cm 58kg MED
K. Mohamed K. Mohamed MED
M. Mallen M. Mallen 22 años DEL
Gustavo Abizanda Gustavo Abizanda 23 años DEL
Pumareta Pumareta 23 años 191cm 76kg DEL
D. Figueras D. Figueras DEL
R. Hernando R. Hernando 24 años 185cm DEL

Clasificación

Equipo PJ GF GC Puntos
1 Huesca B Huesca B 24 46 10 59
2 Sabiñánigo Sabiñánigo 24 52 14 52
3 Santa Anastasia CF Santa 24 44 27 50
4 Peñas Oscenses Peñas 24 40 19 46
5 Zuera Zuera 24 39 25 44
6 Casetas Casetas 24 27 20 36
7 AD Tardienta Tardienta 24 26 23 35
8 CF Villa De Alagón Villa 24 28 23 33
9 Actur Pablo Iglesias Actur Pablo 24 31 28 32
10 Mallén Mallén 24 37 44 28
11 Peña Ferranca Peña 24 21 26 27
12 Zaragoza 2014 Zaragoza 24 22 44 26
13 CD Delicias CD Delicias 24 24 33 24
14 AD Magallon AD Magallon 23 29 40 23
15 Biescas Biescas 23 19 29 22
16 Peña Fragatina Peña 24 22 47 22
17 San Lorenzo Flumen Lorenzo 24 26 42 20
18 CD Mequinenza Mequinenza 24 14 53 10

  USO DE MEMORIA  
7,119,480 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0024
Controller Execution Time ( Home / Category )  0.1211
Total Execution Time  0.1235
  CADENA URL  
/aragon2020/grupo1/jugadores
  GET DATOS  
$_GET['/aragon2020/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0022  SELECT type FROM routes WHERE alias = 'aragon2020'
0.0052  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'aragon' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=85 ORDER BY order_id ASC
0.0021  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 51281 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0084  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 = 51281 AND dt.id IN (2199,647,9655,1622,2798,3962,6152,1942,1948,103028,9663,29008,6153,493,29021,18993,28963,28984) 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:40:46' 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:40:46' 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-27 19:40:46' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0025  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 19:40:46' 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 = 'aragon' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0119  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 events2020 e ON e.player_id = p.id AND e.league_id = 51281 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51281 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.0188  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 events2020 e ON e.player_id = p.id AND e.league_id = 51281 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51281 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0032  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 events2020 e ON e.player_id = p.id AND e.league_id = 51281 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51281 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0047  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` 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 = 51281 AND t.round = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC