1030 - Got error -1 from table handler

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.categories_id = '24' and p.products_status = '1' and pd.language_id = '2' group by p.products_id order by p.products_date_added DESC limit 10

[XT SQL Error]