SELECT DISTINCT `o`.`id`, `o`.`name`, `o`.`type_id`, `o`.`short_description`, `o`.`description`, `o`.`picture`, `o`.`add_date`, `t`.`type`, `ol`.`format_id`, (SELECT format_id FROM object_links WHERE format_id = 43 AND object_id = o.id LIMIT 1) AS `HD` FROM `objects` AS `o` LEFT JOIN `types` AS `t` ON t.id = o.type_id LEFT JOIN `object_links` AS `ol` ON ol.object_id = o.id WHERE (o.status = 1 ) AND (o.type_id = '2' ) AND (o.language = '14') GROUP BY `o`.`id` ORDER BY `o`.`add_date` desc LIMIT 9

Documentaires


Lister  »