Failed to execute the SQL query

select  i.title,  c.title, c.id, i.unread, i.url, i.enclosure, i.author, i.description, c.icon,  unix_timestamp(ifnull(i.pubdate,i.added)) as ts,  i.pubdate is not null as ispubdate, i.id  , null  from  Gre__item  i  inner join  Gre__channels  c on (c.id = i.cid)  inner join  Gre__folders  f on (f.id = c.parent)  where  not(i.unread & 8) and  not(i.unread & 4) and  1 = 1  and month(ifnull(i.pubdate,i.added))= 6  and year(ifnull(i.pubdate, i.added))= 2019  and dayofmonth(ifnull(i.pubdate,i.added))= 24  and  1=1  order by  f.position asc, c.position asc, ts desc, i.id asc limit  0, 10

Error 1030: Got error 28 from storage engine