Table './azb74/SC_products' is marked as crashed and should be repaired
SELECT COUNT(DISTINCT p.productID) as cnt FROM SC_products p WHERE (categoryID IN (840)) AND ( enabled=1) AND status_off <> 1