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,9219,9217,9189,9195,9225,44269,46028,46030,9191,9197,9199,9201,24673,24676,24679,24680,9189,9225,44273,46029,9191,9197,9199,9201,24675)) OR (categoryID IN (683,794,795,800,873,1014,833,834,835,828,829,830,831,832,823,824,825,826,827,836,837,838,672)) ) AND ( enabled=1) AND status_off <> 1