SELECT c.*, d.* FROM album as c LEFT JOIN album_des as d ON (c.id = d.id) WHERE d.lang_id = '2' AND c.published = 1 AND c.cat_id = 12 ORDER BY c.ordering ASC
.