select distinct ax.articles_id, ad.articles_name, a.articles_last_modified from articles_xsell ax LEFT JOIN articles a USING(articles_id) LEFT JOIN articles_description ad USING(articles_id) where ax.xsell_id = '42' and ad.language_id = '4' and a.articles_status = '1' order by a.articles_last_modified