Error:
Query: select a.*,b.category as catname,b.shortname,count(c.complaint_id) as totalcomments,d.country_name,d.shortname as country_short from atulya_complaint a left join atulya_comment c on a.id=c.complaint_id and c.status='A',atulya_category b,atulya_country d where a.status='A' and a.category=b.id and a.country=d.id group by a.id order by a.posted_date DESC
Error Description: Got error 28 from storage engine