4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
31 jugadores
Tineo Tineo
G. Rodriguez G. Rodriguez
A. Mayo A. Mayo
I. Alonso I. Alonso
M. Mayo M. Mayo
S. Rodríguez S. Rodríguez
J. Bermejo J. Bermejo
J. Fernandez J. Fernandez
M. Ibias M. Ibias
F. Alonso F. Alonso
H. Puertas H. Puertas
I. Alvarez I. Alvarez
M. Lahri M. Lahri
I. Bueno I. Bueno
J. Cuervo J. Cuervo
J. Garcia J. Garcia
H. Perez H. Perez
A. Redruello A. Redruello
A. Garcia A. Garcia
I. Llamas I. Llamas 31 años POR
J. Alvarez J. Alvarez DEF
Juan Juan 35 años MED
Jesus Jesus MED
Miguel Miguel 29 años MED
Edu Edu MED
Pablín Pablín 30 años MED
Carlos Fernandez Carlos Fernandez 23 años MED
Pablo Álvarez Pablo Álvarez 27 años 187cm 76kg MED
David David 27 años DEL
Omar Omar 30 años 180cm 70kg DEL
E. Luca E. Luca 23 años 190cm DEL
Renato Renato 27 años DEL
24 jugadores
Puerto Vega FC Puerto Vega FC
J. Suarez J. Suarez
A. Suarez A. Suarez
V. Guzman V. Guzman
C. Lopez C. Lopez
P. Vilar P. Vilar
D. Álvarez D. Álvarez
J. Fernandez J. Fernandez
R. Menendez R. Menendez
Carlos Infanzon Alvarez Carlos Infanzon Alvarez
R. Fernández R. Fernández
M. Suarez M. Suarez
Borja Fernández Rodríguez Borja Fernández Rodríguez
Adrián Adrián 35 años POR
Pelayo Pelayo DEF
Guzmán Guzmán 34 años DEF
S. Fernandez S. Fernandez DEF
Iván Prendes Iván Prendes 29 años DEF
Aramo Aramo 24 años MED
M. Gion M. Gion MED
More More 33 años MED
I. Rivero I. Rivero MED
Ardura Ardura 31 años 183cm 74kg MED
Diego Diego DEL
Guille Méndez Guille Méndez 32 años 177cm 67kg DEL

Clasificación

Equipo PJ GF GC Puntos
1 Puerto Vega FC Puerto Vega 32 78 30 74
2 Club Hispano Club Hispano 32 66 35 65
3 Atlético Camocha Atlético 32 58 39 55
4 Siderúrgico Llaranes CF Siderúrgico 32 50 36 55
5 Fabril CD Fabril CD 32 59 38 52
6 Navia CF Navia CF 32 43 36 49
7 Narcea Narcea 32 50 44 47
8 Tineo Tineo 32 41 46 44
9 Barcia CF B Barcia CF B 32 48 55 43
10 Codema CF Codema CF 32 52 61 40
11 Triple A Gijón Triple 32 49 54 38
12 Podes CF Podes CF 32 47 57 36
13 CD Salas CD Salas 32 39 46 36
14 Condal B Condal B 32 53 60 36
15 Gozón Gozón 32 47 58 34
16 CD Manuel Rubio Manuel Rubio 32 33 49 32
17 CD Treviense Treviense 32 28 53 29
18 GD Bosco GD Bosco 32 36 80 25

  USO DE MEMORIA  
7,416,592 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0027
Controller Execution Time ( Home / Category )  0.6731
Total Execution Time  0.6759
  CADENA URL  
/primera_regional_asturias2024/grupo2/jugadores
  GET DATOS  
$_GET['/primera_regional_asturias2024/grupo2/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0215  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 = 2 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=2 DESC LIMIT 1
0.0105  SELECT id,name,alias,stepParent FROM categories WHERE parentId=709 ORDER BY order_id ASC
0.0106  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 73671 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0244  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 = 73671 AND dt.id IN (19828,3915,359,1778,2498,20086,20072,19830,20073,20065,19827,19817,20062,112881,143380,138975,138972,143381) ORDER BY dt.relations DESC,dp.role ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 15:28:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-01 15:28:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-01 15:28:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-01 15:28:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0215  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 = 73671 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73671 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.0262  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 = 73671 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73671 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0118  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 = 73671 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73671 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0117  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 = 73671 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