4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
29 jugadores
Sanvicenteño Sanvicenteño
J. Lara J. Lara
P. Basco P. Basco
M. Ramilo M. Ramilo
A. Castaño A. Castaño
F. Velerda F. Velerda
I. Fernandez I. Fernandez
R. Jover R. Jover
S. Santos S. Santos
A. Gonzalez A. Gonzalez
A. Estevez A. Estevez
M. Zambrano M. Zambrano
A. Carballo A. Carballo
I. Méndez I. Méndez
R. Gonzalez R. Gonzalez POR
Nono Nono 28 años 170cm 67kg DEF
Paco Paco 28 años 177cm 77kg DEF
Javi Javi DEF
S. Estirado S. Estirado DEF
Guri Guri 28 años 185cm 75kg DEF
Pike Pike 36 años 182cm 73kg MED
D. Scalise D. Scalise 21 años MED
Fran Gemio Fran Gemio 23 años MED
Ruben Ruben 27 años MED
J. Redondo J. Redondo MED
Sergio Sergio 26 años MED
R. Ranchel R. Ranchel 18 años 165cm 60kg MED
Luis Luis 29 años 176cm 64kg MED
Álvaro Álvaro 40 años 180cm 72kg DEL
Joaqui Joaqui 39 años 180cm 79kg DEL
23 jugadores
Valdelacalzada Valdelacalzada
J. Perez J. Perez
D. Escudero D. Escudero
J. Dorado J. Dorado
A. Trevijano A. Trevijano
K. Carmona K. Carmona
I. Nieto I. Nieto
J. Guillen J. Guillen
L. Rocha L. Rocha
I. Tarriño I. Tarriño POR
J. Silva J. Silva DEF
M. Garcia M. Garcia DEF
Saúl Saúl 35 años DEF
David David 34 años MED
Raúl Rivera Raúl Rivera 19 años MED
Gabri Gabri 44 años MED
J. Noriega J. Noriega 26 años MED
A. Lozano A. Lozano MED
Melitón Melitón MED
Carroza Carroza MED
J. Santiago J. Santiago DEL
I. Vazquez I. Vazquez DEL
Adri Adri DEL
Escorial Escorial 34 años DEL
24 jugadores
AD Lobón AD Lobón
I. Sandez I. Sandez
S. Capilla S. Capilla
D. Rodriguez D. Rodriguez
A. Sandez A. Sandez
J. Moreno J. Moreno
J. Ferreira J. Ferreira
Ernest Boateng Ernest Boateng
C. Polo C. Polo
J. Núñez J. Núñez
Kouba Kouba 42 años 182cm 81kg POR
J. González J. González DEF
Torino Torino DEF
J. Redondo J. Redondo DEF
Cisco Cisco 186cm 85kg DEF
J. Sauceda J. Sauceda MED
C. Garranchan C. Garranchan MED
J. Rodríguez J. Rodríguez MED
I. Carvajal I. Carvajal 22 años MED
David David MED
Leo Grajaú Leo Grajaú 23 años 175cm 73kg MED
Manu Manu 30 años MED
Juan Germán Juan Germán 42 años 177cm 74kg MED
M. Martín M. Martín MED
Rodri Rodri 50 años MED

Clasificación

Equipo PJ GF GC Puntos
1 EF Puebla de la Calzada Puebla 22 48 10 51
2 CD Gévora CD Gévora 22 44 12 48
3 Guadiana Guadiana 22 35 17 44
4 AD Lobón AD Lobón 22 45 31 40
5 Sanvicenteño Sanvicenteñ 22 35 31 37
6 CP Don Bosco Bosco 22 40 32 34
7 UD Talavera UD Talavera 22 26 29 29
8 CF San Jorge Jorge 22 26 33 26
9 Valdelacalzada Valdelacalza 22 26 36 22
10 CP Cheles CP Cheles 22 22 45 16
11 Alburquerque Alburquerque 22 22 67 11
12 AD Hipanolusa Hipanolusa 22 23 49 10

  USO DE MEMORIA  
6,298,160 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3201
Total Execution Time  0.3221
  CADENA URL  
/primera_regional_extremadura2024/grupo2/jugadores
  GET DATOS  
$_GET['/primera_regional_extremadura2024/grupo2/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=835 AND type_rel = 3
0.0135  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 835 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0139  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (890519,579263,322482) ORDER BY n.cover_points DESC, update_date DESC
0.0135  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 = 73531 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0133  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 73531 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0274  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 = 73531 AND dt.id IN (2274,2644,1264,149,10243,19027,2025,30036,10253,10162,152987,152986) ORDER BY dt.relations DESC,dp.role ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 08:22:29' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-09 08:22:29' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0128  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-09 08:22:29' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-09 08:22:29' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0178  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 = 73531 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73531 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.0303  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 = 73531 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73531 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0138  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 = 73531 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73531 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0142  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 = 73531 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC