SQL Error: Got error 28 from storage engine (1030)

SELECT mid, mname, price, show_brand, imgsmall, short, cid, cname, cnamesingle, scid, subname, subnamesingle, sid, sname, pid, pname, COUNT(*) AS 'num' FROM properties p1, properties p2, model, producer, cat, subcat, series WHERE p2.pmid='3971' AND p2.pfid=p1.pfid AND p1.pmid=mid AND mid!='3971' AND cid=catid AND scid=scatid AND sid=serid AND pid=prodid GROUP BY p1.pmid HAVING num>=1 ORDER BY num DESC LIMIT 0, 20
Context:/var/www/vanna/data/www/laniver.ru/similar.php line 83