1030 - Got error 28 from storage engine

select p.products_fsk18,p.products_id,p.products_price,p.products_tax_class_id,p.products_image,pd.products_name,pd.products_name_id,pd.products_short_description from orders_products op join orders o on op.orders_id=o.orders_id join products p on p.products_id=op.products_id join products_description pd on pd.products_id=p.products_id where op.orders_id IN(9221,9548,9706,11565,11623,11772,12490,26373,38720) and op.products_id!=1570 and p.products_status=1 and p.products_price>0 and pd.language_id=10 group by op.products_id order by o.date_purchased desc limit 6

[XT SQL Error]