Error: Table './10w40/product_to_store' is marked as crashed and last (automatic?) repair failed
Error No: 144
SELECT COUNT(DISTINCT p.product_id) AS total
FROM product p
LEFT JOIN product_description pd
ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s
ON (p.product_id = p2s.product_id) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) INNER JOIN product_to_car ptc ON ptc.product_id=p.product_id WHERE
pd.language_id = '1'
AND p.status = '1'
#AND p.date_available <= NOW()
AND p2s.store_id = '0' AND p2c.category_id = '71' AND ( mfa_id='516' )