Table './shop/SC_products' is marked as crashed and should be repaired<hr>SELECT COUNT(DISTINCT p.productID) as cnt FROM SC_products p WHERE (categoryID IN (608,596,597,595)) AND ( enabled=1) AND `in_stock` &gt; 0