4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
26 jugadores
CD Turón CD Turón
J. Rodriguez J. Rodriguez
P. Fernandez P. Fernandez
F. Paniceres F. Paniceres
Pelayo Pelayo
A. Gingeira A. Gingeira
P. Mon P. Mon
Cristian Cristian
E. Patino E. Patino
G. Espina G. Espina
B. Rodriguez B. Rodriguez
J. Sanchez J. Sanchez
J. Iglesias J. Iglesias 40 años 182cm 77kg POR
David David 26 años POR
Álex Hornas Álex Hornas 32 años DEF
Illan Illan 23 años DEF
I. Pascual I. Pascual 25 años DEF
Bagües Bagües 21 años DEF
J. Hernández J. Hernández 31 años DEF
Pablo Jorge Pablo Jorge DEF
Gabri Suárez Gabri Suárez 22 años MED
Jorge Jorge MED
J. Fernandez J. Fernandez MED
Damián Damián 33 años MED
S. Rodriguez S. Rodriguez MED
Alejandro Alejandro DEL
Morilla Morilla 35 años DEL
27 jugadores
Ribadedeva Ribadedeva
R. Herrera R. Herrera
E. Lopez E. Lopez
R. Bueres R. Bueres
Rojas Rojas
C. Valle C. Valle
M. Piedralba M. Piedralba
B. Fernandez B. Fernandez
A. Borbolla A. Borbolla
F. Erice F. Erice
J. Sánchez J. Sánchez
D. Blanco D. Blanco
I. Fernandez I. Fernandez
D. Marcos D. Marcos
J. Ermin J. Ermin
J. Villar J. Villar
P. Castañeda P. Castañeda 28 años 180cm 77kg POR
R. Barrial R. Barrial POR
Asier Asier 27 años 177cm 77kg DEF
I. Azcuenaga I. Azcuenaga DEF
Yefri Reyes Yefri Reyes 29 años 183cm 81kg DEF
Rafael Clase Rafael Clase MED
Luis Garavito Luis Garavito 23 años MED
Morán Morán 26 años MED
Rojas Rojas MED
A. Varela A. Varela 22 años DEL
Alejandro Alejandro DEL
Cristian Cristian 26 años DEL
27 jugadores
Madalena Madalena
V. Alfonzo V. Alfonzo
V. Estrada V. Estrada
G. Blanco G. Blanco
D. Perez D. Perez
B. Santapaz B. Santapaz
E. Fernandez E. Fernandez
V. Longo V. Longo
P. Vazquez P. Vazquez
L. Ocejo L. Ocejo
M. Valle M. Valle
A. Pires A. Pires
Yago Yago 24 años 199cm 87kg POR
R. Fernandes R. Fernandes POR
Alfredo Alfredo DEF
Naranjo Naranjo 29 años DEF
R. Ayala R. Ayala MED
Totti Totti 32 años MED
M. González M. González MED
M. Fernandez M. Fernandez 36 años MED
Mariano Mariano MED
A. Felipe A. Felipe MED
Rene Rene DEL
R. Suárez R. Suárez 42 años DEL
M. Costales M. Costales DEL
Keke Keke 38 años 179cm 75kg DEL
Nacho Nacho DEL
D. Alvarez D. Alvarez DEL

Clasificación

Equipo PJ GF GC Puntos
1 CD Turón CD Turón 31 69 22 76
2 UD San Claudio Claudio 31 77 32 66
3 Europa de Nava Europa Nava 31 55 24 66
4 Nalón CF Nalón CF 31 48 23 59
5 Grujoan Grujoan 31 57 34 55
6 Madalena Madalena 31 61 53 53
7 Real Juvencia Real 31 48 41 51
8 UP Langreo B Langreo 31 61 48 46
9 Ribadesella Ribadesella 31 54 36 43
10 CD San Jorge Jorge 31 41 39 42
11 Pumarín CF Pumarín CF 31 37 40 41
12 Quintueles CF Quintueles 31 42 63 33
13 Ribadedeva Ribadedeva 31 34 47 32
14 Lealtad de Villaviciosa B Lealtad 31 42 64 26
15 Arguero CF Arguero CF 31 31 66 25
16 CD La Manjoya Manjoya 31 23 51 24
17 Rosal FC Rosal FC 31 31 83 20
18 Santa Marina de Mieres Santa Marina 31 23 68 15

  USO DE MEMORIA  
7,203,616 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0023
Controller Execution Time ( Home / Category )  0.1648
Total Execution Time  0.1671
  CADENA URL  
/primera_regional_asturias2024/grupo1/jugadores
  GET DATOS  
$_GET['/primera_regional_asturias2024/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0038  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_regional_asturias' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 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=709 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 = 73670 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 = 73670 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0167  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 = 73670 AND dt.id IN (9425,2156,4688,20104,9429,20084,20110,6989,20067,81138,20093,18988,81141,81143,103036,20116,20098,142571) ORDER BY dt.relations DESC,dp.role ASC
0.0036  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 19:17:27' 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-04-27 19:17:27' 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:17:27' 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-27 19:17:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_regional_asturias' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0256  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 events2024 e ON e.player_id = p.id AND e.league_id = 73670 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73670 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.0434  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 events2024 e ON e.player_id = p.id AND e.league_id = 73670 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73670 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0060  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 events2024 e ON e.player_id = p.id AND e.league_id = 73670 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73670 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0050  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` 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 = 73670 AND t.round = 32 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC