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

S. Ubilla

Jugador del Antofagasta

Noticias de S. Ubilla ( Hay 1 Noticias )

Ordenar por Destacadas Últimas noticias Más populares Más comentadas Más votadas
6
Encuesta
Crees que Ubilla llegara al Colo
Crees que Ubilla llegara al Colo
8903 2
SI NP

  USO DE MEMORIA  
4,071,560 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Newlist / Index )  0.1785
Total Execution Time  0.1798
  CADENA URL  
/noticias/jugador/s-ubilla-94144
  GET DATOS  
$_GET['/noticias/jugador/s-ubilla-94144']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (5)  
0.0541  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 = 's-ubilla-94144' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0113  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 75087
0.0113  SELECT p.id,p.votes_up,p.content_type,p.teaser,p.totalcomments,p.votes_down,p.title,p.views,p.alias,p.video_content_id,p.picture_content_id,LEFT(p.body,300) as body,pic.author_id as pauthor_id,v.author_id as vauthor_id FROM `news` as p INNER JOIN fa_user_mini u ON u.id = p.author_id INNER JOIN `rel_news` as rp ON p.id = rp.id_new LEFT JOIN `pictures` as pic ON p.picture_content_id = pic.id AND pic.banned=0 LEFT JOIN `videos` as v ON p.video_content_id = v.id WHERE (v.id is not null or p.id is not null) AND rp.id_content = '94144' and rp.type = 3 ORDER BY p.id DESC LIMIT 0, 12
0.0108  SELECT t.title, t.alias, rel.id_new FROM rel_news AS rel INNER JOIN topics AS t ON rel.id_content=t.id WHERE rel.type=5 AND rel.id_new IN (28581)
0.0108  SELECT COUNT(DISTINCT(p.id)) as total FROM `news` p INNER JOIN `rel_news` as rp ON p.id = rp.id_new WHERE rp.id_content = '94144' and rp.type = 3