SELECT DISTINCT o."order_sid"
FROM "order"."order" o
INNER JOIN "order".item i ON (i.order_sid = o.order_sid)
INNER JOIN "product"."product" p ON (p.product_sid = i.product_sid AND is_gift is true)
INNER JOIN "order".status s ON (s.order_sid = o.order_sid AND s.status = 'completed')
INNER JOIN "order".status s2 ON (s2.order_sid = o.order_sid AND s2.status_sid <> s.status_sid AND s2.status = 'completed')