| Query: | SELECT bp.*, GROUP_CONCAT(DISTINCT bc.id) as category_id, GROUP_CONCAT(DISTINCT bc.name) as category_name, GROUP_CONCAT(DISTINCT bc.query_string) as category_query_string, GROUP_CONCAT(DISTINCT bt.id) as tag_id, GROUP_CONCAT(DISTINCT bt.name) as tag_name, GROUP_CONCAT(DISTINCT bt.query_string) 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.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 |