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 (727,838,1537,1538,1826,1828,1833,2870,2984,3195,3655,3807,3836,3946,3949,4073,4204,4205,4206,4446,4536,4749,5326,5327,5360,5361,5362,5445,5466,5519,5559,5560,5765,5931,5948,5949,6383,8392,9837,11793,11839,12499,12792,12954,12958,14366,14381,14531,14712,15934,16058,16278,16552,16577,17215,17743,20582,20966,21039,21776,21781,21873,22070,22126,22153,26303,26759,28163,29406,29414,31227,31393,33190,48204,43868,48962,43869,43870,45049,47080,47082,48156,48158,50175)) OR (categoryID IN (637)) ) AND ( enabled=1) AND status_off <> 1