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

Gai Assulin firma con el Mallorca

El jugador, que la pasada campaña se desenvolvió en el Hércules, llega libre y firma por dos temporadas.

Gai Assulin ficha por el Granada

Gai Assulin encuentra nuevo club. Imagen subida por: guasch

El RCD Mallorca ha firmado al extremo israelí Gai Assulin por dos años. 


El jugador, que llega libre, jugó la temporada pasada con el Hércules cedido por el Granada, y ocupa la posición de extremo, pudiendo jugar en las dos bandas. 


Procede de la cantera del Barcelona, donde en su día fue considerado una de las más firmes promesas del equipo.

No hay comentarios

Tags relacionados

  USO DE MEMORIA  
3,995,056 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Notice / Index )  0.0532
Total Execution Time  0.0542
  CADENA URL  
/noticia/gai-assulin-firma-mallorca
  GET DATOS  
$_GET['/noticia/gai-assulin-firma-mallorca']  
  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` = '94741'
0.0025  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 = 'gai-assulin-firma-mallorca' AND n.content_type != 2
0.0018  SELECT user_name FROM `fa_user` WHERE id = 165207
0.0020  SELECT * FROM rel_news WHERE id_new = 94741 ORDER BY (type = 5) DESC,(type = 4) DESC, (type = 3) DESC,(type = 1) DESC
0.0018  SELECT title as name,alias FROM topics WHERE id =4
0.0018  SELECT user_name FROM fa_user WHERE id =0
0.0021  SELECT u.user_name,u.id FROM rel_votes v INNER JOIN fa_user u ON v.userId = u.id WHERE v.contentId = 94741 AND v.contentType = 4 ORDER BY v.datetime ASC
0.0019  SELECT alias FROM `news` as p WHERE author_id = 44120 AND id < 94741 ORDER by p.id DESC LIMIT 1
0.0019  SELECT alias FROM `news` as p WHERE author_id = 44120 AND id > 94741 ORDER BY p.id ASC LIMIT 1
0.0018  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=94741
0.0019  SELECT id_content FROM rel_news WHERE id_new = '94741' AND type = '5'
0.0020  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.0019  SELECT * FROM topics ORDER BY priority ASC