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 (9218,2164,9216,45996,2791,9224,40246,2789,2790,39604)) OR (categoryID IN (823,824,825,826,827,795)) ) AND ( enabled=1) AND status_off <> 1