Table './shop/SS_product_options_values' 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=9398 OR enabled=1 AND categoryID=9400 OR enabled=1 AND categoryID=9401 OR enabled=1 AND categoryID=9399 OR enabled=1 AND categoryID=9397 OR enabled=1 AND categoryID=9586 OR enabled=1 AND categoryID=9545 OR enabled=1 AND categoryID=9546 OR enabled=1 AND categoryID=9403 OR enabled=1 AND categoryID=9404 OR enabled=1 AND categoryID=9405 OR enabled=1 AND categoryID=9406 OR enabled=1 AND categoryID=9789 OR enabled=1 AND categoryID=9407 OR enabled=1 AND categoryID=9408 OR enabled=1 AND categoryID=9409 OR enabled=1 AND categoryID=9547 OR enabled=1 AND categoryID=9548 OR enabled=1 AND categoryID=9410 OR enabled=1 AND categoryID=9411 OR enabled=1 AND categoryID=9583 OR enabled=1 AND categoryID=9785 OR enabled=1 AND categoryID=9584 OR enabled=1 AND categoryID=9412 OR enabled=1 AND categoryID=9549 OR enabled=1 AND categoryID=9413 OR enabled=1 AND categoryID=9414 OR enabled=1 AND categoryID=9716 OR enabled=1 AND categoryID=9767 OR enabled=1 AND categoryID=9415 OR enabled=1 AND categoryID=9416 OR enabled=1 AND categoryID=9417 OR enabled=1 AND categoryID=9418 OR enabled=1 AND categoryID=9550 OR enabled=1 AND categoryID=9419 OR enabled=1 AND categoryID=9420 OR enabled=1 AND categoryID=9402 OR enabled=1 AND categoryID=9880 OR enabled=1 AND categoryID=9422 OR enabled=1 AND categoryID=9423 OR enabled=1 AND categoryID=9424 OR enabled=1 AND categoryID=9425 OR enabled=1 AND categoryID=9426 OR enabled=1 AND categoryID=9421 OR enabled=1 AND categoryID=9886 OR enabled=1 AND categoryID=9428 OR enabled=1 AND categoryID=9429 OR enabled=1 AND categoryID=9430 OR enabled=1 AND categoryID=9800 OR enabled=1 AND categoryID=9625 OR enabled=1 AND categoryID=9427 OR enabled=1 AND categoryID=9433 OR enabled=1 AND categoryID=9434 OR enabled=1 AND categoryID=9435 OR enabled=1 AND categoryID=9436 OR enabled=1 AND categoryID=9437 OR enabled=1 AND categoryID=9741 OR enabled=1 AND categoryID=9438 OR enabled=1 AND categoryID=9621 OR enabled=1 AND categoryID=9792 OR enabled=1 AND categoryID=9439 OR enabled=1 AND categoryID=9432 OR enabled=1 AND categoryID=9577 OR enabled=1 AND categoryID=9440 OR enabled=1 AND categoryID=9441 OR enabled=1 AND categoryID=9445 OR enabled=1 AND categoryID=9443 OR enabled=1 AND categoryID=9444 OR enabled=1 AND categoryID=9442 OR enabled=1 AND categoryID=9817 OR enabled=1 AND categoryID=9447 OR enabled=1 AND categoryID=9448 OR enabled=1 AND categoryID=9449 OR enabled=1 AND categoryID=9450 OR enabled=1 AND categoryID=9446 OR enabled=1 AND categoryID=9451 OR enabled=1 AND categoryID=9452 OR enabled=1 AND categoryID=9453 OR enabled=1 AND categoryID=9454 OR enabled=1 AND categoryID=9660 OR enabled=1 AND categoryID=9879 OR enabled=1 AND categoryID=9887 OR enabled=1 AND categoryID=9896 OR enabled=1 AND categoryID=9895 OR enabled=1 AND categoryID=9888 OR enabled=1 AND categoryID=9396 order by in_stock DESC, Price, name