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: 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"