Executed Query -> select b.*, bc.category_name, count(distinct comments.id) as no_of_comments from tbl_blogs b left join tbl_blog_categories bc on bc.id = b.blog_category_id left join tbl_blog_comments comments on comments.blog_id = b.id where b.status = 'a' and b.blog_slug = 'visit-of-british-dy-high-commissioner-1555396947'
ERROR:"SQLSTATE[42000]: Syntax error or access violation: 1140 In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'svumshow_svum.b.id'; this is incompatible with sql_mode=only_full_group_by: 311"