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 (2981,2996,7507,10802,10804,10898,10899,11291,11470,11812,15227,15350,15538,17115,17266,17268,17270,17271,17571,17611,19676,19678,20001,20002,20003,20083,20086,20090,20091,20092,20093,22485,22486,22797,22798,22799,22804,22805,22806,23039,23040,28064,29210,29211,29212,29213,31528,40451,40452,43152,46659,46660)) OR (categoryID IN (594)) ) AND ( enabled=1) AND status_off <> 1