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

Tachtsidis jugará en el Genoa

El griego regresa de su cesión al Torino, pero el club genovés ha comprado la mitad de su pase al Catania.

Foto principal de P. Tachtsidis | Grecia

Tachtsidis, en una foto oficial con Grecia. Imagen subida por: jvdgs24

El Genoa sigue perfilando su plantilla para la temporada que viene y acaba de confirmar la incorporación del griego Panagiotis Tachtsidis, jugador que los genoveses tenían cedido en el Torino.

El equipo de Génova, que era poseedor de la mitad del pase del griego, adquiere el 50% restante, propiedad del Catania, enviando a cambio al equipo siciliano a Francesco Lodi.

No hay comentarios


  USO DE MEMORIA  
3,999,680 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Notice / Index )  0.7115
Total Execution Time  0.7125
  CADENA URL  
/noticia/tachtsidis-jugara-genoa
  GET DATOS  
$_GET['/noticia/tachtsidis-jugara-genoa']  
  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` = '92269'
0.0170  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 = 'tachtsidis-jugara-genoa' AND n.content_type != 2
0.0145  SELECT * FROM rel_news WHERE id_new = 92269 ORDER BY (type = 5) DESC,(type = 4) DESC, (type = 3) DESC,(type = 1) DESC
0.2160  SELECT title as name,alias FROM topics WHERE id =4
0.0160  SELECT user_name FROM fa_user WHERE id =622798
0.1947  SELECT u.user_name,u.id FROM rel_votes v INNER JOIN fa_user u ON v.userId = u.id WHERE v.contentId = 92269 AND v.contentType = 4 ORDER BY v.datetime ASC
0.0273  SELECT alias FROM `news` as p WHERE author_id = 622798 AND id < 92269 ORDER by p.id DESC LIMIT 1
0.0221  SELECT alias FROM `news` as p WHERE author_id = 622798 AND id > 92269 ORDER BY p.id ASC LIMIT 1
0.0212  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=92269
0.0328  SELECT id_content FROM rel_news WHERE id_new = '92269' AND type = '5'
0.0212  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.0146  SELECT * FROM topics ORDER BY priority ASC