1030 - Got error 122 from storage engine

select p.products_fsk18, p.products_id, p.products_price, p.products_price_extra, p.products_price_shop, p.products_extra_charges, p.free_shipping, s.expires_date, s.specials_quantity, p.products_tax_class_id, m.manufacturers_name, p.products_image, pd.products_name, p.products_vpe, p.products_vpe_status, p.products_vpe_value, pd.products_short_description FROM orders_products opa left join specials s on opa.products_id = s.products_id and s.status = '1' AND s.specials_id IN (SELECT s.specials_id FROM specials s LEFT JOIN specials_to_zones sz ON s.specials_id = sz.specials_id WHERE s.products_id = p.products_id AND (sz.zone_id IN (1) OR sz.zone_id IS NULL)), orders_products opb, orders o, products_to_categories p2c, products p left outer join manufacturers m on p.manufacturers_id = m.manufacturers_id , products_description pd where opa.products_id = '5828' and opa.orders_id = opb.orders_id and opb.products_id != '5828' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id in (382,472,7758,7759,7760,7761,7762,7763,7764,7765,7766,7767,7768,7769,7770,7771,7786,7787,5075,2146,5042,5163,5076,5277,5164,381,5077) and pd.language_id = '3' and opb.products_id = pd.products_id group by p.products_id order by o.date_purchased desc limit 6

[XT SQL Error]