4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
34 jugadores
Villaescusa SD Villaescusa SD
B. Lopez B. Lopez
D. Lorenzo D. Lorenzo
V. Carrera V. Carrera
A. Diaz A. Diaz
R. Criado R. Criado
O. Diego O. Diego
Alfonso Alfonso
A. Castaños A. Castaños
M. Bravo M. Bravo
A. Cuenca A. Cuenca
B. Ceballos B. Ceballos
A. Rio A. Rio
J. García J. García
P. Bedoya P. Bedoya
M. Castanedo M. Castanedo
D. Rodriguez D. Rodriguez
M. Escandon M. Escandon
H. Perez H. Perez
M. Diez M. Diez 21 años
F. Madera F. Madera
P. Ibañez P. Ibañez
S. Gaño S. Gaño 24 años 182cm POR
A. Noriega A. Noriega POR
Revuelta Revuelta DEF
Sergio Sergio 27 años DEF
Manu Manu 30 años MED
D. Torre D. Torre 23 años MED
M. Diallo M. Diallo MED
O. Hornero Maza O. Hornero Maza MED
Stiven Stiven MED
S. Bermudez S. Bermudez 26 años MED
Nicolás Nicolás 29 años MED
Álvaro Álvaro 34 años 172cm 65kg DEL
J. Gonzalez J. Gonzalez 22 años 178cm 80kg DEL
31 jugadores
Revilla B Revilla B
J. Macho J. Macho
J. Ruiz J. Ruiz
Chechu Ruiz Chechu Ruiz
H. Campos H. Campos
A. Salinas A. Salinas
M. Gomez M. Gomez
O. Achurra O. Achurra
K. Perez K. Perez
M. Palazuelos M. Palazuelos
D. Oruña D. Oruña
V. Puertas V. Puertas
Luis García Luis García 19 años POR
Ángel Díaz Ángel Díaz 19 años POR
A. Campuzano A. Campuzano POR
Jesus Jesus 27 años 175cm DEF
Á. Montes Á. Montes DEF
M. Borbolla M. Borbolla DEF
A. Salcines A. Salcines MED
Anthony Anthony 20 años MED
D. Prellezo D. Prellezo MED
R. Ruiz R. Ruiz 23 años MED
F. Gañan F. Gañan MED
S. Canales S. Canales 22 años MED
B. Martínez B. Martínez MED
D. Abascal D. Abascal 23 años MED
J. Vallejo J. Vallejo 21 años 171cm 70kg DEL
Mario Diego Mario Diego 21 años 187cm 82kg DEL
Ibrahim Ibrahim 42 años 180cm 82kg DEL
M. Diallo M. Diallo DEL
J. Gonzalez J. Gonzalez 21 años DEL
Luis Megia Luis Megia DEL

Clasificación

Equipo PJ GF GC Puntos
1 CD Ramales CD Ramales 32 68 28 71
2 Minerva Fc Minerva Fc 32 68 33 69
3 Revilla B Revilla B 32 99 47 66
4 Ayrón Club Ayrón Club 32 75 34 64
5 Ampuero FC Ampuero FC 32 57 37 60
6 Cd Montañas Del Pas Montañas 32 50 46 52
7 Polanco CF Polanco CF 32 47 42 48
8 Escobedo B Escobedo B 32 56 54 45
9 Atlético España De Cueto Atlético 32 60 60 43
10 Villaescusa SD Villaescusa 32 54 62 43
11 Santiago Galas Santiago 32 48 54 40
12 CD Calasanz CD Calasanz 32 44 54 39
13 Vimenor B Vimenor B 32 45 41 38
14 Marina de Cudeyo Marina 32 44 53 36
15 Rio Gandara CD Gandara 32 57 69 36
16 Buelna Buelna 32 38 64 33
17 Nueva Montaña Nueva 32 38 83 20
18 Rinconeda Rinconeda 32 31 118 3

  USO DE MEMORIA  
7,398,432 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4687
Total Execution Time  0.4707
  CADENA URL  
/primera_regional_cantabria2024/grupo1/jugadores
  GET DATOS  
$_GET['/primera_regional_cantabria2024/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0148  SELECT type FROM routes WHERE alias = 'primera_regional_cantabria2024'
0.0291  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_regional_cantabria' 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.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=703 AND type_rel = 3
0.0147  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 703 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0147  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 (573581,333269) ORDER BY n.cover_points DESC, update_date DESC
0.0149  SELECT id,name,alias,stepParent FROM categories WHERE parentId=703 ORDER BY order_id ASC
0.0153  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 73507 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0494  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 = 73507 AND dt.id IN (4760,20012,558,20018,9444,2162,3499,2703,364,20045,9442,20052,20003,20004,91350,122234,138686,143319) ORDER BY dt.relations DESC,dp.role ASC
0.0150  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-08 06:22:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-08 06:22:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-08 06:22:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-08 06:22:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0569  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 = 73507 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73507 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.0403  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 = 73507 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73507 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0162  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 = 73507 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73507 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0159  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 = 73507 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