Got error 28 from storage engine<hr>SELECT * FROM SC_products p WHERE ((categoryID IN (2054,5874,5671,5686,6103,1315)) AND (Price&gt;0 AND enabled=1 AND hide_from_special_and_hit=0)) AND special=1 ORDER BY RAND() LIMIT 3