Error in Selection query
SELECT c.name as candidate_category,a.*,b.district as districts ,DATE_FORMAT(a.dob,'%d-%m-%Y') as date_of_birth from candidate as a left join districts as b on a.district = b.id left join category as c on c.id = a.category where a.status = '0' and a.approve_status = '1' and package = 'PREMIUM' and a.category = '1' order by a.id desc
Got error 28 from storage engine