如果数据重复，如何在插入新条目时删除旧条目。在我的例子中，每天晚上都有一个作业运行以插入新记录，但是当记录发生任何更改时，它会插入一个新记录，而不是删除旧记录。

SELECT
op.order_product_id,
op.order_id,
o.date_added as booking_date,
o.date_modified,
o.order_status_id as order_status,

REVERSE(SUBSTRING_INDEX(REVERSE(op.resource), '/' , 1)) as entity_id,
op.name as stay_name,
CASE WHEN op.legacy_product_id IS NULL THEN op.product_id ELSE op.legacy_product_id END as legacy_product_id,
op.total as stay_amount

FROM opencart.order_product op
LEFT JOIN opencart.order o ON o.order_id = op.order_id
LEFT JOIN opencart.order_option ot ON ot.order_id = op.order_id AND ot.name = 'Anzahl der Personen'

where op.product_id NOT IN (2,3,5)
AND o.order_status_id IN (5,7)

AND DATE(o.date_modified) >= current_date() - INTERVAL 3 DAY 
AND DATE(o.date_modified) < current_date()

GROUP BY 1