11 lines
1.5 KiB
SQL
11 lines
1.5 KiB
SQL
DELETE FROM loota_box WHERE order_id = (SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'maakastanja'));
|
|
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'maakastanja')), '2025-09-27 10:00:00+00');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'maakastanja')), '2025-07-19 10:00:00+00');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'maakastanja')), '2025-09-13 10:00:00+00');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'maakastanja')), '2025-07-05 10:00:00+00');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'maakastanja')), '2025-08-16 10:00:00+00');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'maakastanja')), '2025-08-30 10:00:00+00');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'maakastanja')), '2025-08-02 10:00:00+00');
|
|
|