Table 'SS_products' is marked as crashed and should be repaired SQL query : select count(*) from SS_products AS pt LEFT JOIN SS_product_options_values AS po ON pt.productID=po.productID and po.optionID=36 where enabled=1 AND categoryID=8676 OR enabled=1 AND categoryID=8682 OR enabled=1 AND categoryID=8677 OR enabled=1 AND categoryID=9862 OR enabled=1 AND categoryID=8678 OR enabled=1 AND categoryID=8679 OR enabled=1 AND categoryID=8680 OR enabled=1 AND categoryID=9582 OR enabled=1 AND categoryID=6807 order by in_stock DESC, Price, name