Það fór eitthvað úrskeiðis. Vinsamlega reyndu aftur Whole query: SELECT `tr`.`ID_TrailerFile`, `tr`.`Description`, `tr`.`Hits`, `tr`.`Movie`, `tr`.`Cdate`, `vfs`.`fileName`, `vfs`.`systemName` , `vfs`.`type` , `mm`.`Poster`,`mm`.`ID_Movie`,`mm`.`Title`,`mm`.`year` FROM `Trailer` `tr` INNER JOIN `vfsFile` `vfs` ON `tr`.`ID_TrailerFile` = `vfs`.`id` INNER JOIN `Movie` `mm` ON `tr`.`Movie` = `mm`.`ID_Movie` WHERE `tr`.`ID_TrailerFile` = '142471'