4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Vélez CF

Vélez CF

Entrenador: Catanha

Temporada 2023/2024

Estadísticas

ASISTENCIAS
Adrià Arjona3
R. Salama2
Luismi Gutiérrez2
Gastón1
Gastón Alonso1
D. Zamorano1
A. Ortega1
Alfonso Liceras1
Navas1
ENTRA
Israel Peter13
Chus Ruiz13
David Amez12
Alu Koroma9
Fran García8
Christian8
Adrià Arjona7
Bashiru7
Gastón Alonso6
A. Romero6
A. Jankulovski5
J. Marín5
Navas4
Edu4
K. Spence4
Charlie Dean2
Aarón2
Abde2
A. Ortega2
Kamal2
Álex Portillo2
G. Conesa2
Jesus1
Yeray1
Mário Gassamá1
S. Ocheche1
R. Salama1
D. Zamorano1
J. Fernández1
Tomás1
SALE
Kamal14
D. Zamorano13
Luismi Gutiérrez12
Tomás10
Dani Cosano10
Israel Peter9
Gastón8
R. Salama7
Abde7
Navas6
Álex Portillo5
David Amez5
Alu Koroma5
Adrià Arjona5
Bashiru4
Chus Ruiz3
Fran García3
Gastón Alonso3
Ale Briggs2
K. Spence2
A. Jankulovski2
Héctor2
A. Dolapo1
Alfonso Liceras1
A. Ortega1
Aarón1
A. Romero1
Kaya1

  USO DE MEMORIA  
5,047,960 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.2216
Total Execution Time  0.2229
  CADENA URL  
/estadisticas/velez-club-de-futbol
  GET DATOS  
$_GET['/estadisticas/velez-club-de-futbol']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0118  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'velez-club-de-futbol' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0106  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=8459 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=8459 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=8459 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=8459 AND type_rel = 2
0.0107  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 8459 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0107  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 (79416,187608,253806,278492,279289) ORDER BY n.cover_points DESC, update_date DESC
0.0115  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 = '8459' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0118  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 = 72365 WHERE rp.league_id = 72365 AND rp.teamId = 8459 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0120  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 = 72365 WHERE rp.league_id = 72365 AND rp.teamId = 8459 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0121  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 = 72365 WHERE rp.league_id = 72365 AND rp.teamId = 8459 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30