Error: Table './10w40/product_to_store' is marked as crashed and last (automatic?) repair failed<br />Error No: 144<br />
		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) WHERE 
		pd.language_id = '1' 
		AND p.status = '1' 
		#AND p.date_available <= NOW() 
		AND p2s.store_id = '0' AND p2c.category_id = '42'