4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Cerdanyola FC

Cerdanyola FC

Entrenador: Oliver Ballabriga

Temporada 2023/2024

Estadísticas

ASISTENCIAS
Max Marcet5
Lucas Pariente4
R. Escoruela3
Boris Garrós2
N. Olmedo2
Álex Sánchez1
Adrián Barquero1
Carlos1
Richie1
ENTRA
Richie17
Lucas Pariente15
J. Castillo14
M. Ezzarfani11
N. Olmedo10
Adrián Barquero8
Carlos8
Jordi Aláez6
Boris Garrós5
Ronald Gbizie4
Jon Vega4
Manu Castillo4
Jan Pallise4
A. Cherradi4
Adrián Díaz3
M. Martínez3
Iñaki Recio3
Moisés2
Bruno Lorente1
Pere Martínez1
Óscar Arroyo1
Lluís Andreu1
SALE
Max Marcet13
Richie10
Carlos10
Adrián Díaz10
Boris Garrós9
R. Escoruela8
Jon Vega7
M. Ezzarfani6
Nico Kata6
Adrián Barquero5
Bruno Lorente5
N. Olmedo5
Marc Manchón4
Pere Martínez3
Guille Torres3
Lucas Pariente3
A. Cherradi2
Óscar Arroyo2
Moisés2
Jordi Aláez2
Manu Castillo2
Ronald Gbizie1
Iñaki Recio1
Álex Sánchez1

  USO DE MEMORIA  
5,062,920 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.3176
Total Execution Time  0.3190
  CADENA URL  
/estadisticas/Cerdanyola-Valles-Fc
  GET DATOS  
$_GET['/estadisticas/Cerdanyola-Valles-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6089 AND type_rel = 2
0.0147  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6089 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0161  SELECT /*35 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 (93103,159913,240533,822157,887292) ORDER BY n.cover_points DESC, update_date DESC
0.0170  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '6089' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0152  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '6089' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6089' and rp.type = 4
0.0147  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '6089' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0164  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 72364 WHERE rp.league_id = 72364 AND rp.teamId = 6089 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0172  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 72364 WHERE rp.league_id = 72364 AND rp.teamId = 6089 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 72364 WHERE rp.league_id = 72364 AND rp.teamId = 6089 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 72364 WHERE rp.league_id = 72364 AND rp.teamId = 6089 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 72364 WHERE rp.league_id = 72364 AND rp.teamId = 6089 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0206  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 72364 WHERE rp.league_id = 72364 AND rp.teamId = 6089 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30