Failed to execute the SQL query

select fid, count(*) as cnt from  metatag  m inner join  tag  t on t.id = m.tid  where ( t.tag='lcd' or t.tag='1-cm' or 1=0)  and m.ttype = 'item' group by fid order by 2 desc

Error 1030: Got error 12 from storage engine