4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Ops!

404: El contenido solicitado ya no existe

Posibles jugadores que estás buscando:


  USO DE MEMORIA  
3,765,904 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Player / Index )  0.1400
Total Execution Time  0.1411
  CADENA URL  
/jugador/j-ferrel-aguilera-m-862699
  GET DATOS  
$_GET['/jugador/j-ferrel-aguilera-m-862699']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (6)  
0.0112  SELECT p.*,rp.*,dt.*,p.id as playerId,c.Name,'' as buy_url, p.twitter AS player_twitter FROM `dataplayers` p INNER JOIN `rel_players` rp ON rp.player_id = p.id AND rp.year = 2024 INNER JOIN `datateams` dt ON dt.id = rp.teamId LEFT JOIN country c ON c.code2 = p.CountryCode INNER JOIN categories AS ct ON rp.category_id=ct.id WHERE p.alias = 'j-ferrel-aguilera-m-862699' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0113  SELECT p.*,rp.*,dt.*,p.id as playerId,c.Name,'' as buy_url, p.twitter AS player_twitter FROM `dataplayers` p INNER JOIN `rel_players` rp ON rp.player_id = p.id INNER JOIN `datateams` dt ON dt.id = rp.teamId LEFT JOIN country c ON c.code2 = p.CountryCode INNER JOIN categories AS ct ON rp.category_id=ct.id WHERE p.alias = 'j-ferrel-aguilera-m-862699' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0109  SELECT player_id,table_suffix FROM dataplayers_suffix WHERE alias='j-ferrel-aguilera-m-862699'
0.0116  SELECT p.*,rp.*,dt.*,p.id as playerId,c.Name,'' as buy_url, p.twitter AS player_twitter FROM `dataplayers` p INNER JOIN `rel_players` rp ON rp.player_id = p.id INNER JOIN `datateams` dt ON dt.id = rp.teamId LEFT JOIN country c ON c.code2 = p.CountryCode INNER JOIN categories AS ct ON rp.category_id=ct.id WHERE p.id = '' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0115   SELECT `alias` FROM `dataplayers` AS dp LEFT JOIN `rel_players` AS rp ON rp.`player_id` = dp.`id` AND rp.in_squad = 1 WHERE `old_alias` = 'j-ferrel-aguilera-m-862699' AND (`alias` != '' OR `alias` IS NOT NULL) AND rp.`year` = '2024'
0.0131  SELECT dp.id, dp.nick, dp.name, dp.last_name, dp.alias, dt.nameShow, dt.basealias, dt.id AS team_id, rp.year, LOWER(dp.countryCode) AS countryCode, IF(dp.birthdate,YEAR(DATE('2024-01-01 01:01:01'))-YEAR(dp.birthdate),'-') as age, dp.twitter as player_twitter FROM dataplayers AS dp INNER JOIN rel_players AS rp ON dp.id=rp.player_id AND rp.in_squad = 1 INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.nick!='' AND dp.last_name!='' AND dp.valor > 0 AND CONCAT(dp.name, dp.last_name, dp.nick) LIKE '%j%' OR CONCAT(dp.name, dp.last_name, dp.nick) LIKE '%ferrel%' OR CONCAT(dp.name, dp.last_name, dp.nick) LIKE '%aguilera%' OR CONCAT(dp.name, dp.last_name, dp.nick) LIKE '%m%' GROUP BY dp.id LIMIT 2