Table './azb74/SC_products' is marked as crashed and should be repaired
SELECT COUNT(DISTINCT p.productID) as cnt FROM SC_products p WHERE ( (p.productID IN (33568,33659,33660,33661,33663,33664,33665,36070,36374,40241,40242,40243,40244,47106,48329,48337,48338)) OR (categoryID IN (1037)) ) AND ( enabled=1) AND status_off <> 1