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 (35930,35931,35932,35933,35934,36247,36236,36248,36249,38059,38061,38062,38067,38068,49336,49337,49338,49339,49340,50047,50077,50212,50214,50215,50233,50234,50235,50236,50241,50243,50815,50817,50820,50821,50823,50824,51148,51150,51158,51163,51169,51173,51184,51187,51191,51194)) OR (categoryID IN (1079)) ) AND ( enabled=1) AND status_off <> 1