1030 - Got error 28 from storage engine

SELECT DISTINCT p.*, pd.*, p2c.*, c.*, cd.*, pp.*, pu.*, m.* FROM products p LEFT JOIN products_to_categories p2c ON p2c.products_id = p.products_id LEFT JOIN categories c ON c.categories_id = p2c.categories_id LEFT JOIN categories_description cd ON c.categories_id = cd.categories_id AND cd.language_id = 1 LEFT JOIN products_prices pp ON pp.product_id = p.products_id AND pp.qty=1 AND pp.group_id = 0 LEFT JOIN products_units pu ON pu.products_units_id = p.products_units_id LEFT JOIN manufacturers m ON m.manufacturers_id = p.manufacturers_id ,products_description pd WHERE p.products_status = '1' AND pd.products_id = p.products_id AND pd.language_id = 1 AND p.products_parent_id=10019670

[TEP STOP]