Failed to execute the SQL query

 select  UNIX_TIMESTAMP( ifnull(i.pubdate, i.added)) as ts_,  year( ifnull(i.pubdate, i.added)) as y_,  month( ifnull(i.pubdate, i.added)) as m_,  dayofmonth( ifnull(i.pubdate, i.added)) as d_,  count(*) as cnt_  from  item  i  where  UNIX_TIMESTAMP(ifnull(i.pubdate, i.added)) < 1206050399  and cid=7  and not(i.unread & 4)  group by y_,m_,d_  order by ts_ desc limit 4

Error 1030: Got error 12 from storage engine