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

La Roma consigue la cesión de Yanga-Mbiwa

El defensa francés no encontró su sitio en el equipo inglés desde su llegada la pasada campaña y sale cedido al club italiano.

M. Yanga-Mbiwa

Mapou Yanga-Mbiwa. Imagen subida por: Aquino-10

La Roma y el Newcastle han llegado a un acuerdo para la cesión del internacional francés sub 21 Mapou Yanga-Mbiwa.

El jugador llegó el año pasado al equipo blanquinegro, pero no ha sido capaz de hacerse con un puesto en el equipo titular, aunque en su debe cabe mencionar que ha padecido diversas lesiones en el tobillo.

Llega al equipo de la Serie A cedido con una opción de compra que se estima en unos 6 millones de euros.

No hay comentarios


  USO DE MEMORIA  
4,003,584 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Notice / Index )  0.2771
Total Execution Time  0.2781
  CADENA URL  
/noticia/roma-consigue-cesion-yanga-mbiwa
  GET DATOS  
$_GET['/noticia/roma-consigue-cesion-yanga-mbiwa']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0003   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` = '95405'
0.0150  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 = 'roma-consigue-cesion-yanga-mbiwa' AND n.content_type != 2
0.0144  SELECT user_name FROM `fa_user` WHERE id = 44120
0.0146  SELECT * FROM rel_news WHERE id_new = 95405 ORDER BY (type = 5) DESC,(type = 4) DESC, (type = 3) DESC,(type = 1) DESC
0.0145  SELECT title as name,alias FROM topics WHERE id =4
0.0144  SELECT user_name FROM fa_user WHERE id =0
0.0145  SELECT u.user_name,u.id FROM rel_votes v INNER JOIN fa_user u ON v.userId = u.id WHERE v.contentId = 95405 AND v.contentType = 4 ORDER BY v.datetime ASC
0.0145  SELECT alias FROM `news` as p WHERE author_id = 622798 AND id < 95405 ORDER by p.id DESC LIMIT 1
0.0146  SELECT alias FROM `news` as p WHERE author_id = 622798 AND id > 95405 ORDER BY p.id ASC LIMIT 1
0.0145  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=95405
0.0145  SELECT id_content FROM rel_news WHERE id_new = '95405' AND type = '5'
0.0147  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.0145  SELECT * FROM topics ORDER BY priority ASC