SELECT st.order_id FROM shop_table st JOIN (SELECT order_id, SUM(product_total_price) sptp FROM order_details_table GROUP BY order_id) odt ON st.order_id = odt.order_id WHERE (order_total_price+order_shipping_price-order_discount_price) <> sptp