1030 - Got error 28 from storage engine

SELECT * FROM products p, products_description pd, products_to_categories p2c, categories c where c.categories_status='1' and p.products_id = p2c.products_id and p.products_id=pd.products_id and p2c.categories_id = c.categories_id and c.parent_id = '14' and p.products_status = '1' and pd.language_id = '2' order by p.products_date_added DESC limit 9

[XT SQL Error]