SELECT `file`.`id`, `file`.`type`, `file`.`filename`, `file`.`mimetype`, `file`.`filesize`, `file`.`label_en` AS `label`, `file`.`created`, `file`.`modified` FROM `file` LEFT JOIN `news_image` ON news_image.file_id = file.id WHERE (news_image.news_id = ) ORDER BY `news_image`.`id` ASC