Table 'SC_products' is marked as crashed and should be repaired
SELECT COUNT(DISTINCT p.productID) as cnt FROM SC_products p WHERE (categoryID IN (731,732,733,734,735,736,737,738,729,730,740,741,742,743,739,744,746,747,745,748,749,750,728)) AND ( enabled=1)