SELECT a.*, ad.article_data_id, ad.lang, ad.title, ad.body, ad.seo_title, ad.seo_body, ad.tag, ad.handle, u.* FROM article a LEFT JOIN article_data ad ON a.article_id = ad.article_id LEFT JOIN user u USING(user_id) LEFT JOIN f2a ON a.article_id = f2a.article_id WHERE parent_id IN(268,521,687,1669) GROUP BY a.article_id ORDER BY a.date_start DESC