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 (48936,47872,47876,47880,47883,47893,47894,47897,47900,47901,47902,47903,47904,47905,47916,47927,47928,48877,48878,48879,48880,48882,48885,48884,48886,48892,48893,48903,48906,48915,48916,48920,48923,48924,48927,48930,47904,47927,47928)) OR (categoryID IN (1068,1069,1070,1071,1072,1067)) ) AND ( enabled=1) AND status_off <> 1