SELECT p.post_id, p.image, p.date_created as date, pd.name, pd.description, a.username, a.firstname, a.lastname, ( SELECT count(*) FROM `journal2_blog_comments` bc WHERE bc.post_id = p.post_id AND bc.status = 1 AND bc.parent_id = 0 ) as comments FROM `journal2_blog_post` p LEFT JOIN `journal2_blog_post_description` pd ON p.post_id = pd.post_id LEFT JOIN `user` a ON p.author_id = a.user_id WHERE pd.language_id = 1 AND p.status = 1 GROUP BY p.post_id ORDER BY p.date_created DESC LIMIT 0,8;#0.20412/0.20414