Failed to execute the SQL query

select i.title,  c.title, c.id, i.unread, i.url, i.author, i.description, c.icon,  unix_timestamp(ifnull(i.pubdate,i.added)) as ts,  i.pubdate is not null as ispubdate, i.id, r.rating, i.category   from  item  i  left join  rating  r on (i.id = r.iid),  channels  c,  folders  f  where  i.cid = c.id and  i.category = 'biology' and  f.id=c.parent and  not(c.mode & 8) and  not(i.unread & 8) and  not(i.unread & 4) and i.cid = 14 and month(ifnull(i.pubdate,i.added))= 12  and year(ifnull(i.pubdate, i.added))= 2016  and dayofmonth(ifnull(i.pubdate,i.added))= 08  and  1=1  order by   ts desc, f.position asc, c.position asc , ts desc, i.id asc limit 0, 9999

Error 1030: Got error 28 from storage engine