Got error 28 from storage engine
SELECT * FROM SC_products p WHERE ((categoryID IN (5978,5980,5979)) AND (Price>0 AND enabled=1 AND hide_from_special_and_hit=0)) AND special=1 ORDER BY RAND() LIMIT 3