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

El Genoa apuesta por Pinilla

El atacante chileno cambia de equipo pero se mantiene en la Serie A.

Foto principal de M. Pinilla | Chile

El internacional chileno sigue en Italia. Imagen subida por: jvdgs24

El Genoa y el Cagliari han llegado a un acuerdo para el traspaso del internacional chileno Mauricio Pinilla al equipo de Génova.

El futbolista, que llega después de realizar un buen Mundial, firma por el club genovés por una cantidad cercana al millón y medio de euros.

Firma por tres temporadas, en las que tratará de ser la referencia goleadora del Genoa. El futbolista había mostrado su deseo recientemente de regresar a su país -al Universidad de Chile-, pero parece que finalmente no se podrá dar.

No hay comentarios

Tags relacionados

  USO DE MEMORIA  
3,995,360 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Notice / Index )  0.2309
Total Execution Time  0.2318
  CADENA URL  
/noticia/genoa-apuesta-pinilla
  GET DATOS  
$_GET['/noticia/genoa-apuesta-pinilla']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0006   SELECT COUNT(DISTINCT c.`id`) AS num FROM comments AS c WHERE c.`active` = 1 AND c.device = 'web' AND c.to_review=0 AND c.comment_id!=0 AND c.lang = '1' AND c.`new_content_id` = '94441'
0.0129  SELECT n.*,rn.*,u.user_name,u.user_name as media_username,p.title as ptitle,p.width,p.height,v.code,v.title as vtitle,p.id as pid,v.id as vid,p.author_id as pauthor_id,v.author_id as vauthor_id, v.url as video_url, v.type AS vtype FROM `news` n INNER JOIN fa_user u ON u.id = n.author_id INNER JOIN `rel_news` as rn ON n.id = rn.id_new LEFT JOIN `pictures` as p ON n.picture_content_id = p.id AND p.banned=0 LEFT JOIN `videos` as v ON n.video_content_id = v.id WHERE n.alias = 'genoa-apuesta-pinilla' AND n.content_type != 2
0.0127  SELECT * FROM rel_news WHERE id_new = 94441 ORDER BY (type = 5) DESC,(type = 4) DESC, (type = 3) DESC,(type = 1) DESC
0.0125  SELECT title as name,alias FROM topics WHERE id =4
0.0125  SELECT user_name FROM fa_user WHERE id =0
0.0126  SELECT u.user_name,u.id FROM rel_votes v INNER JOIN fa_user u ON v.userId = u.id WHERE v.contentId = 94441 AND v.contentType = 4 ORDER BY v.datetime ASC
0.0129  SELECT alias FROM `news` as p WHERE author_id = 622798 AND id < 94441 ORDER by p.id DESC LIMIT 1
0.0125  SELECT alias FROM `news` as p WHERE author_id = 622798 AND id > 94441 ORDER BY p.id ASC LIMIT 1
0.0126  SELECT dp.id AS player_id, dp.nick AS player_name, dp.role AS player_role, dp.alias AS player_alias, odt.id AS origin_team_id, odt.nameShow AS origin_team_name, odt.basealias AS origin_team_alias, dtd.id AS dest_team_id, dtd.nameShow AS dest_team_name, dtd.basealias AS dest_team_alias FROM rel_budgets AS rb INNER JOIN dataplayers AS dp ON rb.player_id=dp.id LEFT JOIN datateams AS odt ON rb.origin_team_id=odt.id LEFT JOIN datateams AS dtd ON rb.destination_team_id=dtd.id WHERE rb.new_id=94441
0.0125  SELECT id_content FROM rel_news WHERE id_new = '94441' AND type = '5'
0.0129  SELECT l.id,c.`name` as name,l.group_code,l.total_group,c.CountryCode,c.`alias` as alias FROM leagues l INNER JOIN categories c ON c.id = l.categoryId WHERE l.status = 1 AND l.links = 2 AND l.year = 2024 AND c.listed = 1 AND l.tables = 1 AND l.group_code > 0 AND c.troncal = 1 AND l.game = 1 AND c.class < 5 ORDER BY c.coefficient DESC, c.name ASC ,l.group_code ASC
0.0128  SELECT * FROM topics ORDER BY priority ASC