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