Table './kaprizka_masterdom/SC_products' is marked as crashed and should be repaired
SELECT COUNT(DISTINCT p.productID) as cnt FROM SC_products p WHERE brandID=2 AND (categoryID IN (589)) AND ( enabled=1)