| Query: | SELECT bp.*, GROUP_CONCAT(DISTINCT bc.id ORDER BY bc.id ASC) as category_id, GROUP_CONCAT(DISTINCT bc.name ORDER BY bc.id ASC) as category_name, GROUP_CONCAT(DISTINCT bc.query_string ORDER BY bc.id ASC) as category_query_string, GROUP_CONCAT(DISTINCT bt.id ORDER BY bt.id ASC) as tag_id, GROUP_CONCAT(DISTINCT bt.name ORDER BY bt.id ASC) as tag_name, GROUP_CONCAT(DISTINCT bt.query_string ORDER BY bt.id ASC) as tag_query_string, count(bpc.post_id) as comments_cnt FROM cms_blog_posts bp LEFT JOIN cms_blog_categories_posts bcp ON bcp.post_id = bp.id LEFT JOIN cms_blog_categories bc ON bcp.blog_catgory_id = bc.id LEFT JOIN cms_blog_post_tags btp ON btp.post_id = bp.id LEFT JOIN cms_tags bt ON btp.tag_id = bt.id LEFT JOIN cms_blog_post_comments bpc ON bp.id = bpc.post_id WHERE bp.website_id = '154' AND bp.is_archived = '0' AND bp.status = '1' AND bp.is_delete = '0' AND bp.schedule_date <= CONVERT_TZ(UTC_TIMESTAMP, 'GMT', 'Asia/Kolkata') AND bp.language_id = '1' GROUP BY bp.id ORDER BY bp.publish_date DESC, bp.id DESC LIMIT -5, 5 |