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=6273 OR  enabled=1 AND categoryID=6274 OR  enabled=1 AND categoryID=6887 OR  enabled=1 AND categoryID=6275 OR  enabled=1 AND categoryID=6272 order by  in_stock DESC, Price, name