1301 lines
232 KiB
SQL
1301 lines
232 KiB
SQL
DELETE FROM loota_customer;
|
|
DELETE FROM loota_order;
|
|
DELETE FROM loota_box;
|
|
|
|
|
|
-- Livonsaari
|
|
INSERT INTO loota_customer (identifier) VALUES ('bataatti');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'bataatti'), 'Livonsaari');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'bataatti')), '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 = 'bataatti')), '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 = 'bataatti')), '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 = 'bataatti')), '2025-09-06 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 = 'bataatti')), '2025-10-18 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 = 'bataatti')), '2025-09-20 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 = 'bataatti')), '2025-10-04 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 = 'bataatti')), '2025-08-02 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 = 'bataatti')), '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 = 'bataatti')), '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 = 'bataatti')), '2025-07-26 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 = 'bataatti')), '2025-08-23 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 = 'bataatti')), '2025-08-09 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 = 'bataatti')), '2025-10-11 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 = 'bataatti')), '2025-07-12 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 = 'bataatti')), '2025-09-13 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('intianlootus');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'intianlootus'), 'Livonsaari');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'intianlootus')), '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 = 'intianlootus')), '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 = 'intianlootus')), '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 = 'intianlootus')), '2025-09-06 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 = 'intianlootus')), '2025-10-18 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 = 'intianlootus')), '2025-09-20 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 = 'intianlootus')), '2025-10-04 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 = 'intianlootus')), '2025-08-02 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 = 'intianlootus')), '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 = 'intianlootus')), '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 = 'intianlootus')), '2025-07-26 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 = 'intianlootus')), '2025-08-23 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 = 'intianlootus')), '2025-08-09 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 = 'intianlootus')), '2025-10-11 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 = 'intianlootus')), '2025-07-12 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 = 'intianlootus')), '2025-09-13 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('isotakiainen');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'isotakiainen'), 'Livonsaari');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'isotakiainen')), '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 = 'isotakiainen')), '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 = 'isotakiainen')), '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 = 'isotakiainen')), '2025-09-06 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 = 'isotakiainen')), '2025-10-18 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 = 'isotakiainen')), '2025-09-20 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 = 'isotakiainen')), '2025-10-04 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 = 'isotakiainen')), '2025-08-02 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 = 'isotakiainen')), '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 = 'isotakiainen')), '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 = 'isotakiainen')), '2025-07-26 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 = 'isotakiainen')), '2025-08-23 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 = 'isotakiainen')), '2025-08-09 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 = 'isotakiainen')), '2025-10-11 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 = 'isotakiainen')), '2025-07-12 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 = 'isotakiainen')), '2025-09-13 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('kaurajuuri');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'kaurajuuri'), 'Livonsaari');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'kaurajuuri')), '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 = 'kaurajuuri')), '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 = 'kaurajuuri')), '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 = 'kaurajuuri')), '2025-09-06 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 = 'kaurajuuri')), '2025-10-18 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 = 'kaurajuuri')), '2025-09-20 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 = 'kaurajuuri')), '2025-10-04 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 = 'kaurajuuri')), '2025-08-02 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 = 'kaurajuuri')), '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 = 'kaurajuuri')), '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 = 'kaurajuuri')), '2025-07-26 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 = 'kaurajuuri')), '2025-08-23 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 = 'kaurajuuri')), '2025-08-09 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 = 'kaurajuuri')), '2025-10-11 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 = 'kaurajuuri')), '2025-07-12 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 = 'kaurajuuri')), '2025-09-13 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('lanttu');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'lanttu'), 'Livonsaari');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'lanttu')), '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 = 'lanttu')), '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 = 'lanttu')), '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 = 'lanttu')), '2025-09-06 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 = 'lanttu')), '2025-10-18 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 = 'lanttu')), '2025-09-20 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 = 'lanttu')), '2025-10-04 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 = 'lanttu')), '2025-08-02 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 = 'lanttu')), '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 = 'lanttu')), '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 = 'lanttu')), '2025-07-26 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 = 'lanttu')), '2025-08-23 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 = 'lanttu')), '2025-08-09 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 = 'lanttu')), '2025-10-11 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 = 'lanttu')), '2025-07-12 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 = 'lanttu')), '2025-09-13 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('maakastanja');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'maakastanja'), 'Livonsaari');
|
|
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-06 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-20 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-10-04 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-26 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-23 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-09 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-12 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('maniokki');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'maniokki'), 'Livonsaari');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'maniokki')), '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 = 'maniokki')), '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 = 'maniokki')), '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 = 'maniokki')), '2025-09-06 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 = 'maniokki')), '2025-10-18 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 = 'maniokki')), '2025-09-20 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 = 'maniokki')), '2025-10-04 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 = 'maniokki')), '2025-08-02 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 = 'maniokki')), '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 = 'maniokki')), '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 = 'maniokki')), '2025-07-26 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 = 'maniokki')), '2025-08-23 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 = 'maniokki')), '2025-08-09 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 = 'maniokki')), '2025-10-11 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 = 'maniokki')), '2025-07-12 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 = 'maniokki')), '2025-09-13 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('mukulakäenkaali');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'mukulakäenkaali'), 'Livonsaari');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'mukulakäenkaali')), '2025-09-06 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 = 'mukulakäenkaali')), '2025-09-20 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 = 'mukulakäenkaali')), '2025-10-04 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 = 'mukulakäenkaali')), '2025-07-26 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 = 'mukulakäenkaali')), '2025-08-23 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 = 'mukulakäenkaali')), '2025-08-09 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 = 'mukulakäenkaali')), '2025-07-12 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('timjami');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'timjami'), 'Livonsaari');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'timjami')), '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 = 'timjami')), '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 = 'timjami')), '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 = 'timjami')), '2025-09-06 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 = 'timjami')), '2025-10-18 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 = 'timjami')), '2025-09-20 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 = 'timjami')), '2025-10-04 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 = 'timjami')), '2025-08-02 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 = 'timjami')), '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 = 'timjami')), '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 = 'timjami')), '2025-07-26 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 = 'timjami')), '2025-08-23 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 = 'timjami')), '2025-08-09 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 = 'timjami')), '2025-10-11 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 = 'timjami')), '2025-07-12 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 = 'timjami')), '2025-09-13 10:00:00+00');
|
|
|
|
-- Pienet
|
|
INSERT INTO loota_customer (identifier) VALUES ('mustajuuri');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'mustajuuri'), 'Askainen');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'mustajuuri')), '2025-09-24 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 = 'mustajuuri')), '2025-07-02 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 = 'mustajuuri')), '2025-08-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 = 'mustajuuri')), '2025-09-10 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 = 'mustajuuri')), '2025-07-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 = 'mustajuuri')), '2025-08-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 = 'mustajuuri')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('nauris');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'nauris'), 'Askainen');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'nauris')), '2025-08-06 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 = 'nauris')), '2025-09-17 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 = 'nauris')), '2025-08-20 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 = 'nauris')), '2025-07-23 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 = 'nauris')), '2025-09-03 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 = 'nauris')), '2025-07-09 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 = 'nauris')), '2025-10-01 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('nuolijuuri');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'nuolijuuri'), 'Kirjakahvila');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'nuolijuuri')), '2025-08-06 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 = 'nuolijuuri')), '2025-09-24 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 = 'nuolijuuri')), '2025-09-17 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 = 'nuolijuuri')), '2025-08-20 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 = 'nuolijuuri')), '2025-08-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 = 'nuolijuuri')), '2025-09-10 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 = 'nuolijuuri')), '2025-08-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 = 'nuolijuuri')), '2025-09-03 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 = 'nuolijuuri')), '2025-10-01 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 = 'nuolijuuri')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('palsternakka');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'palsternakka'), 'Kirjakahvila');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'palsternakka')), '2025-08-06 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 = 'palsternakka')), '2025-09-24 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 = 'palsternakka')), '2025-09-17 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 = 'palsternakka')), '2025-08-20 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 = 'palsternakka')), '2025-08-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 = 'palsternakka')), '2025-09-10 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 = 'palsternakka')), '2025-08-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 = 'palsternakka')), '2025-09-03 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 = 'palsternakka')), '2025-10-01 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 = 'palsternakka')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('persilja');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'persilja'), 'Kirjakahvila');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'persilja')), '2025-08-06 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 = 'persilja')), '2025-09-24 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 = 'persilja')), '2025-09-17 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 = 'persilja')), '2025-08-20 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 = 'persilja')), '2025-08-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 = 'persilja')), '2025-09-10 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 = 'persilja')), '2025-08-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 = 'persilja')), '2025-09-03 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 = 'persilja')), '2025-10-01 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 = 'persilja')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('peruna');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'peruna'), 'Kirjakahvila');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'peruna')), '2025-09-24 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 = 'peruna')), '2025-07-02 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 = 'peruna')), '2025-08-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 = 'peruna')), '2025-09-10 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 = 'peruna')), '2025-07-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 = 'peruna')), '2025-08-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 = 'peruna')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('piparjuuri');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'piparjuuri'), 'Kirjakahvila');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'piparjuuri')), '2025-10-15 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 = 'piparjuuri')), '2025-08-06 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 = 'piparjuuri')), '2025-10-08 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 = 'piparjuuri')), '2025-09-24 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 = 'piparjuuri')), '2025-09-17 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 = 'piparjuuri')), '2025-08-20 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 = 'piparjuuri')), '2025-07-02 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 = 'piparjuuri')), '2025-08-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 = 'piparjuuri')), '2025-09-10 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 = 'piparjuuri')), '2025-07-23 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 = 'piparjuuri')), '2025-07-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 = 'piparjuuri')), '2025-08-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 = 'piparjuuri')), '2025-09-03 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 = 'piparjuuri')), '2025-07-09 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 = 'piparjuuri')), '2025-10-01 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 = 'piparjuuri')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('porkkana');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'porkkana'), 'Kirjakahvila');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'porkkana')), '2025-10-15 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 = 'porkkana')), '2025-08-06 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 = 'porkkana')), '2025-10-08 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 = 'porkkana')), '2025-09-24 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 = 'porkkana')), '2025-09-17 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 = 'porkkana')), '2025-08-20 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 = 'porkkana')), '2025-07-02 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 = 'porkkana')), '2025-08-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 = 'porkkana')), '2025-09-10 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 = 'porkkana')), '2025-07-23 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 = 'porkkana')), '2025-07-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 = 'porkkana')), '2025-08-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 = 'porkkana')), '2025-09-03 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 = 'porkkana')), '2025-07-09 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 = 'porkkana')), '2025-10-01 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 = 'porkkana')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('punajuuri');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'punajuuri'), 'Kissakahvila');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'punajuuri')), '2025-08-06 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 = 'punajuuri')), '2025-09-24 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 = 'punajuuri')), '2025-09-17 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 = 'punajuuri')), '2025-08-20 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 = 'punajuuri')), '2025-08-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 = 'punajuuri')), '2025-09-10 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 = 'punajuuri')), '2025-08-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 = 'punajuuri')), '2025-09-03 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 = 'punajuuri')), '2025-10-01 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 = 'punajuuri')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('retiisi');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'retiisi'), 'Kissakahvila');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'retiisi')), '2025-10-15 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 = 'retiisi')), '2025-08-06 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 = 'retiisi')), '2025-10-08 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 = 'retiisi')), '2025-09-24 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 = 'retiisi')), '2025-09-17 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 = 'retiisi')), '2025-08-20 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 = 'retiisi')), '2025-07-02 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 = 'retiisi')), '2025-08-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 = 'retiisi')), '2025-09-10 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 = 'retiisi')), '2025-07-23 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 = 'retiisi')), '2025-07-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 = 'retiisi')), '2025-08-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 = 'retiisi')), '2025-09-03 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 = 'retiisi')), '2025-07-09 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 = 'retiisi')), '2025-10-01 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 = 'retiisi')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('selleri');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'selleri'), 'Kissakahvila');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'selleri')), '2025-10-15 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 = 'selleri')), '2025-08-06 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 = 'selleri')), '2025-10-08 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 = 'selleri')), '2025-09-24 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 = 'selleri')), '2025-09-17 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 = 'selleri')), '2025-08-20 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 = 'selleri')), '2025-07-02 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 = 'selleri')), '2025-08-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 = 'selleri')), '2025-09-10 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 = 'selleri')), '2025-07-23 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 = 'selleri')), '2025-07-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 = 'selleri')), '2025-08-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 = 'selleri')), '2025-09-03 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 = 'selleri')), '2025-07-09 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 = 'selleri')), '2025-10-01 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 = 'selleri')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('ruotiselleri');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'ruotiselleri'), 'Kissakahvila');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'ruotiselleri')), '2025-10-15 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 = 'ruotiselleri')), '2025-08-06 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 = 'ruotiselleri')), '2025-10-08 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 = 'ruotiselleri')), '2025-09-24 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 = 'ruotiselleri')), '2025-09-17 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 = 'ruotiselleri')), '2025-08-20 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 = 'ruotiselleri')), '2025-07-02 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 = 'ruotiselleri')), '2025-08-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 = 'ruotiselleri')), '2025-09-10 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 = 'ruotiselleri')), '2025-07-23 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 = 'ruotiselleri')), '2025-07-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 = 'ruotiselleri')), '2025-08-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 = 'ruotiselleri')), '2025-09-03 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 = 'ruotiselleri')), '2025-07-09 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 = 'ruotiselleri')), '2025-10-01 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 = 'ruotiselleri')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('taaro');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'taaro'), 'Kissakahvila');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'taaro')), '2025-08-06 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 = 'taaro')), '2025-09-17 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 = 'taaro')), '2025-08-20 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 = 'taaro')), '2025-07-23 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 = 'taaro')), '2025-09-03 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 = 'taaro')), '2025-07-09 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 = 'taaro')), '2025-10-01 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('ulluko');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'ulluko'), 'Koroinen');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'ulluko')), '2025-10-15 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 = 'ulluko')), '2025-08-06 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 = 'ulluko')), '2025-10-08 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 = 'ulluko')), '2025-09-24 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 = 'ulluko')), '2025-09-17 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 = 'ulluko')), '2025-08-20 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 = 'ulluko')), '2025-07-02 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 = 'ulluko')), '2025-08-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 = 'ulluko')), '2025-09-10 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 = 'ulluko')), '2025-07-23 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 = 'ulluko')), '2025-07-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 = 'ulluko')), '2025-08-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 = 'ulluko')), '2025-09-03 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 = 'ulluko')), '2025-07-09 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 = 'ulluko')), '2025-10-01 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 = 'ulluko')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('vesikastanja');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'vesikastanja'), 'Koroinen');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'vesikastanja')), '2025-08-06 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 = 'vesikastanja')), '2025-09-24 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 = 'vesikastanja')), '2025-09-17 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 = 'vesikastanja')), '2025-08-20 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 = 'vesikastanja')), '2025-08-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 = 'vesikastanja')), '2025-09-10 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 = 'vesikastanja')), '2025-08-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 = 'vesikastanja')), '2025-09-03 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 = 'vesikastanja')), '2025-10-01 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 = 'vesikastanja')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('endiivi');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'endiivi'), 'Koroinen');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'endiivi')), '2025-10-15 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 = 'endiivi')), '2025-08-06 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 = 'endiivi')), '2025-10-08 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 = 'endiivi')), '2025-09-24 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 = 'endiivi')), '2025-09-17 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 = 'endiivi')), '2025-08-20 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 = 'endiivi')), '2025-07-02 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 = 'endiivi')), '2025-08-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 = 'endiivi')), '2025-09-10 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 = 'endiivi')), '2025-07-23 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 = 'endiivi')), '2025-07-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 = 'endiivi')), '2025-08-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 = 'endiivi')), '2025-09-03 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 = 'endiivi')), '2025-07-09 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 = 'endiivi')), '2025-10-01 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 = 'endiivi')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('merikaali');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'merikaali'), 'Koroinen');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'merikaali')), '2025-10-15 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 = 'merikaali')), '2025-08-06 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 = 'merikaali')), '2025-10-08 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 = 'merikaali')), '2025-09-24 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 = 'merikaali')), '2025-09-17 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 = 'merikaali')), '2025-08-20 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 = 'merikaali')), '2025-07-02 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 = 'merikaali')), '2025-08-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 = 'merikaali')), '2025-09-10 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 = 'merikaali')), '2025-07-23 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 = 'merikaali')), '2025-07-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 = 'merikaali')), '2025-08-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 = 'merikaali')), '2025-09-03 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 = 'merikaali')), '2025-07-09 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 = 'merikaali')), '2025-10-01 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 = 'merikaali')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('fenkoli');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'fenkoli'), 'Koroinen');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'fenkoli')), '2025-10-15 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 = 'fenkoli')), '2025-08-06 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 = 'fenkoli')), '2025-10-08 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 = 'fenkoli')), '2025-09-24 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 = 'fenkoli')), '2025-09-17 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 = 'fenkoli')), '2025-08-20 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 = 'fenkoli')), '2025-07-02 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 = 'fenkoli')), '2025-08-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 = 'fenkoli')), '2025-09-10 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 = 'fenkoli')), '2025-07-23 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 = 'fenkoli')), '2025-07-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 = 'fenkoli')), '2025-08-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 = 'fenkoli')), '2025-09-03 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 = 'fenkoli')), '2025-07-09 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 = 'fenkoli')), '2025-10-01 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 = 'fenkoli')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('keräkaali');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'keräkaali'), 'Koroinen');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'keräkaali')), '2025-09-24 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 = 'keräkaali')), '2025-07-02 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 = 'keräkaali')), '2025-08-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 = 'keräkaali')), '2025-09-10 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 = 'keräkaali')), '2025-07-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 = 'keräkaali')), '2025-08-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 = 'keräkaali')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('kiinankaali');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'kiinankaali'), 'Koroinen');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'kiinankaali')), '2025-08-06 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 = 'kiinankaali')), '2025-09-24 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 = 'kiinankaali')), '2025-09-17 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 = 'kiinankaali')), '2025-08-20 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 = 'kiinankaali')), '2025-08-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 = 'kiinankaali')), '2025-09-10 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 = 'kiinankaali')), '2025-08-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 = 'kiinankaali')), '2025-09-03 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 = 'kiinankaali')), '2025-10-01 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 = 'kiinankaali')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('kurttukaali');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'kurttukaali'), 'Merimasku');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'kurttukaali')), '2025-10-15 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 = 'kurttukaali')), '2025-08-06 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 = 'kurttukaali')), '2025-10-08 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 = 'kurttukaali')), '2025-09-24 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 = 'kurttukaali')), '2025-09-17 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 = 'kurttukaali')), '2025-08-20 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 = 'kurttukaali')), '2025-07-02 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 = 'kurttukaali')), '2025-08-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 = 'kurttukaali')), '2025-09-10 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 = 'kurttukaali')), '2025-07-23 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 = 'kurttukaali')), '2025-07-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 = 'kurttukaali')), '2025-08-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 = 'kurttukaali')), '2025-09-03 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 = 'kurttukaali')), '2025-07-09 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 = 'kurttukaali')), '2025-10-01 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 = 'kurttukaali')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('kyssäkaali');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'kyssäkaali'), 'Merimasku');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'kyssäkaali')), '2025-10-15 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 = 'kyssäkaali')), '2025-08-06 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 = 'kyssäkaali')), '2025-10-08 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 = 'kyssäkaali')), '2025-09-24 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 = 'kyssäkaali')), '2025-09-17 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 = 'kyssäkaali')), '2025-08-20 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 = 'kyssäkaali')), '2025-07-02 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 = 'kyssäkaali')), '2025-08-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 = 'kyssäkaali')), '2025-09-10 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 = 'kyssäkaali')), '2025-07-23 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 = 'kyssäkaali')), '2025-07-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 = 'kyssäkaali')), '2025-08-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 = 'kyssäkaali')), '2025-09-03 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 = 'kyssäkaali')), '2025-07-09 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 = 'kyssäkaali')), '2025-10-01 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 = 'kyssäkaali')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('lehtikaali');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'lehtikaali'), 'Naantali');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'lehtikaali')), '2025-10-15 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 = 'lehtikaali')), '2025-08-06 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 = 'lehtikaali')), '2025-10-08 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 = 'lehtikaali')), '2025-09-24 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 = 'lehtikaali')), '2025-09-17 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 = 'lehtikaali')), '2025-08-20 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 = 'lehtikaali')), '2025-07-02 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 = 'lehtikaali')), '2025-08-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 = 'lehtikaali')), '2025-09-10 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 = 'lehtikaali')), '2025-07-23 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 = 'lehtikaali')), '2025-07-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 = 'lehtikaali')), '2025-08-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 = 'lehtikaali')), '2025-09-03 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 = 'lehtikaali')), '2025-07-09 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 = 'lehtikaali')), '2025-10-01 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 = 'lehtikaali')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('punakaali');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'punakaali'), 'Naantali');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'punakaali')), '2025-10-15 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 = 'punakaali')), '2025-08-06 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 = 'punakaali')), '2025-10-08 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 = 'punakaali')), '2025-09-24 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 = 'punakaali')), '2025-09-17 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 = 'punakaali')), '2025-08-20 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 = 'punakaali')), '2025-07-02 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 = 'punakaali')), '2025-08-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 = 'punakaali')), '2025-09-10 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 = 'punakaali')), '2025-07-23 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 = 'punakaali')), '2025-07-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 = 'punakaali')), '2025-08-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 = 'punakaali')), '2025-09-03 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 = 'punakaali')), '2025-07-09 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 = 'punakaali')), '2025-10-01 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 = 'punakaali')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('ruusukaali');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'ruusukaali'), 'Naantali');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'ruusukaali')), '2025-10-15 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 = 'ruusukaali')), '2025-08-06 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 = 'ruusukaali')), '2025-10-08 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 = 'ruusukaali')), '2025-09-24 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 = 'ruusukaali')), '2025-09-17 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 = 'ruusukaali')), '2025-08-20 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 = 'ruusukaali')), '2025-07-02 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 = 'ruusukaali')), '2025-08-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 = 'ruusukaali')), '2025-09-10 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 = 'ruusukaali')), '2025-07-23 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 = 'ruusukaali')), '2025-07-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 = 'ruusukaali')), '2025-08-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 = 'ruusukaali')), '2025-09-03 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 = 'ruusukaali')), '2025-07-09 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 = 'ruusukaali')), '2025-10-01 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 = 'ruusukaali')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('kardoni');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'kardoni'), 'Naantali');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'kardoni')), '2025-10-15 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 = 'kardoni')), '2025-08-06 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 = 'kardoni')), '2025-10-08 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 = 'kardoni')), '2025-09-24 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 = 'kardoni')), '2025-09-17 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 = 'kardoni')), '2025-08-20 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 = 'kardoni')), '2025-07-02 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 = 'kardoni')), '2025-08-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 = 'kardoni')), '2025-09-10 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 = 'kardoni')), '2025-07-23 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 = 'kardoni')), '2025-07-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 = 'kardoni')), '2025-08-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 = 'kardoni')), '2025-09-03 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 = 'kardoni')), '2025-07-09 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 = 'kardoni')), '2025-10-01 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 = 'kardoni')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('keltasipuli');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'keltasipuli'), 'Naantali');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'keltasipuli')), '2025-10-15 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 = 'keltasipuli')), '2025-08-06 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 = 'keltasipuli')), '2025-10-08 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 = 'keltasipuli')), '2025-09-24 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 = 'keltasipuli')), '2025-09-17 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 = 'keltasipuli')), '2025-08-20 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 = 'keltasipuli')), '2025-07-02 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 = 'keltasipuli')), '2025-08-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 = 'keltasipuli')), '2025-09-10 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 = 'keltasipuli')), '2025-07-23 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 = 'keltasipuli')), '2025-07-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 = 'keltasipuli')), '2025-08-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 = 'keltasipuli')), '2025-09-03 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 = 'keltasipuli')), '2025-07-09 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 = 'keltasipuli')), '2025-10-01 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 = 'keltasipuli')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('salottisipuli');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'salottisipuli'), 'Raisio');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'salottisipuli')), '2025-10-15 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 = 'salottisipuli')), '2025-08-06 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 = 'salottisipuli')), '2025-10-08 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 = 'salottisipuli')), '2025-09-24 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 = 'salottisipuli')), '2025-09-17 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 = 'salottisipuli')), '2025-08-20 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 = 'salottisipuli')), '2025-07-02 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 = 'salottisipuli')), '2025-08-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 = 'salottisipuli')), '2025-09-10 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 = 'salottisipuli')), '2025-07-23 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 = 'salottisipuli')), '2025-07-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 = 'salottisipuli')), '2025-08-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 = 'salottisipuli')), '2025-09-03 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 = 'salottisipuli')), '2025-07-09 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 = 'salottisipuli')), '2025-10-01 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 = 'salottisipuli')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('lamopinaatti');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'lamopinaatti'), 'Raisio');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'lamopinaatti')), '2025-08-06 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 = 'lamopinaatti')), '2025-09-17 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 = 'lamopinaatti')), '2025-08-20 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 = 'lamopinaatti')), '2025-07-23 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 = 'lamopinaatti')), '2025-09-03 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 = 'lamopinaatti')), '2025-07-09 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 = 'lamopinaatti')), '2025-10-01 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('lehtimangoldi');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'lehtimangoldi'), 'Viherlassila');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'lehtimangoldi')), '2025-10-15 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 = 'lehtimangoldi')), '2025-08-06 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 = 'lehtimangoldi')), '2025-10-08 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 = 'lehtimangoldi')), '2025-09-24 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 = 'lehtimangoldi')), '2025-09-17 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 = 'lehtimangoldi')), '2025-08-20 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 = 'lehtimangoldi')), '2025-07-02 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 = 'lehtimangoldi')), '2025-08-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 = 'lehtimangoldi')), '2025-09-10 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 = 'lehtimangoldi')), '2025-07-23 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 = 'lehtimangoldi')), '2025-07-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 = 'lehtimangoldi')), '2025-08-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 = 'lehtimangoldi')), '2025-09-03 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 = 'lehtimangoldi')), '2025-07-09 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 = 'lehtimangoldi')), '2025-10-01 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 = 'lehtimangoldi')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('pillisipuli');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'pillisipuli'), 'Viherlassila');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'pillisipuli')), '2025-09-24 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 = 'pillisipuli')), '2025-07-02 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 = 'pillisipuli')), '2025-08-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 = 'pillisipuli')), '2025-09-10 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 = 'pillisipuli')), '2025-07-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 = 'pillisipuli')), '2025-08-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 = 'pillisipuli')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('talvisipuli');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'talvisipuli'), 'Viherlassila');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'talvisipuli')), '2025-10-15 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 = 'talvisipuli')), '2025-08-06 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 = 'talvisipuli')), '2025-10-08 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 = 'talvisipuli')), '2025-09-24 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 = 'talvisipuli')), '2025-09-17 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 = 'talvisipuli')), '2025-08-20 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 = 'talvisipuli')), '2025-07-02 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 = 'talvisipuli')), '2025-08-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 = 'talvisipuli')), '2025-09-10 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 = 'talvisipuli')), '2025-07-23 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 = 'talvisipuli')), '2025-07-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 = 'talvisipuli')), '2025-08-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 = 'talvisipuli')), '2025-09-03 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 = 'talvisipuli')), '2025-07-09 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 = 'talvisipuli')), '2025-10-01 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 = 'talvisipuli')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('pinaatti');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'pinaatti'), 'Viherlassila');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'pinaatti')), '2025-08-06 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 = 'pinaatti')), '2025-09-17 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 = 'pinaatti')), '2025-08-20 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 = 'pinaatti')), '2025-07-23 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 = 'pinaatti')), '2025-09-03 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 = 'pinaatti')), '2025-07-09 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 = 'pinaatti')), '2025-10-01 10:00:00+00');
|
|
|
|
-- Isot
|
|
INSERT INTO loota_customer (identifier) VALUES ('pinaattihierakka');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'pinaattihierakka'), 'Askainen');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'pinaattihierakka')), '2025-08-06 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 = 'pinaattihierakka')), '2025-10-08 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 = 'pinaattihierakka')), '2025-09-24 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 = 'pinaattihierakka')), '2025-09-17 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 = 'pinaattihierakka')), '2025-08-20 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 = 'pinaattihierakka')), '2025-07-02 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 = 'pinaattihierakka')), '2025-08-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 = 'pinaattihierakka')), '2025-09-10 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 = 'pinaattihierakka')), '2025-07-23 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 = 'pinaattihierakka')), '2025-07-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 = 'pinaattihierakka')), '2025-08-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 = 'pinaattihierakka')), '2025-09-03 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 = 'pinaattihierakka')), '2025-07-09 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 = 'pinaattihierakka')), '2025-10-15 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 = 'pinaattihierakka')), '2025-10-01 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 = 'pinaattihierakka')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('purjo');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'purjo'), 'Askainen');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'purjo')), '2025-08-06 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 = 'purjo')), '2025-10-08 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 = 'purjo')), '2025-09-24 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 = 'purjo')), '2025-09-17 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 = 'purjo')), '2025-08-20 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 = 'purjo')), '2025-07-02 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 = 'purjo')), '2025-08-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 = 'purjo')), '2025-09-10 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 = 'purjo')), '2025-07-23 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 = 'purjo')), '2025-07-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 = 'purjo')), '2025-08-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 = 'purjo')), '2025-09-03 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 = 'purjo')), '2025-07-09 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 = 'purjo')), '2025-10-15 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 = 'purjo')), '2025-10-01 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 = 'purjo')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('paparperi');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'paparperi'), 'Askainen');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'paparperi')), '2025-08-06 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 = 'paparperi')), '2025-10-08 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 = 'paparperi')), '2025-09-24 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 = 'paparperi')), '2025-09-17 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 = 'paparperi')), '2025-08-20 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 = 'paparperi')), '2025-07-02 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 = 'paparperi')), '2025-08-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 = 'paparperi')), '2025-09-10 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 = 'paparperi')), '2025-07-23 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 = 'paparperi')), '2025-07-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 = 'paparperi')), '2025-08-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 = 'paparperi')), '2025-09-03 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 = 'paparperi')), '2025-07-09 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 = 'paparperi')), '2025-10-15 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 = 'paparperi')), '2025-10-01 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 = 'paparperi')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('ruoholaukka');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'ruoholaukka'), 'Kirjakahvila');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'ruoholaukka')), '2025-09-24 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 = 'ruoholaukka')), '2025-07-02 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 = 'ruoholaukka')), '2025-08-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 = 'ruoholaukka')), '2025-09-10 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 = 'ruoholaukka')), '2025-07-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 = 'ruoholaukka')), '2025-08-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 = 'ruoholaukka')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('ruohosipuli');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'ruohosipuli'), 'Kirjakahvila');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'ruohosipuli')), '2025-08-06 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 = 'ruohosipuli')), '2025-09-24 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 = 'ruohosipuli')), '2025-09-17 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 = 'ruohosipuli')), '2025-08-20 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 = 'ruohosipuli')), '2025-08-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 = 'ruohosipuli')), '2025-09-10 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 = 'ruohosipuli')), '2025-08-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 = 'ruohosipuli')), '2025-09-03 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 = 'ruohosipuli')), '2025-10-01 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 = 'ruohosipuli')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('ruokaparsa');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'ruokaparsa'), 'Kirjakahvila');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'ruokaparsa')), '2025-08-06 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 = 'ruokaparsa')), '2025-09-17 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 = 'ruokaparsa')), '2025-08-20 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 = 'ruokaparsa')), '2025-07-23 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 = 'ruokaparsa')), '2025-09-03 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 = 'ruokaparsa')), '2025-07-09 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 = 'ruokaparsa')), '2025-10-01 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('ruokasalaatti');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'ruokasalaatti'), 'Kirjakahvila');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'ruokasalaatti')), '2025-08-06 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 = 'ruokasalaatti')), '2025-09-24 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 = 'ruokasalaatti')), '2025-09-17 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 = 'ruokasalaatti')), '2025-08-20 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 = 'ruokasalaatti')), '2025-08-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 = 'ruokasalaatti')), '2025-09-10 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 = 'ruokasalaatti')), '2025-08-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 = 'ruokasalaatti')), '2025-09-03 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 = 'ruokasalaatti')), '2025-10-01 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 = 'ruokasalaatti')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('jäävuorisalaatti');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'jäävuorisalaatti'), 'Kirjakahvila');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'jäävuorisalaatti')), '2025-09-24 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 = 'jäävuorisalaatti')), '2025-07-02 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 = 'jäävuorisalaatti')), '2025-08-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 = 'jäävuorisalaatti')), '2025-09-10 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 = 'jäävuorisalaatti')), '2025-07-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 = 'jäävuorisalaatti')), '2025-08-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 = 'jäävuorisalaatti')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('sareptansinappi');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'sareptansinappi'), 'Kirjakahvila');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'sareptansinappi')), '2025-08-06 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 = 'sareptansinappi')), '2025-10-08 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 = 'sareptansinappi')), '2025-09-24 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 = 'sareptansinappi')), '2025-09-17 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 = 'sareptansinappi')), '2025-08-20 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 = 'sareptansinappi')), '2025-07-02 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 = 'sareptansinappi')), '2025-08-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 = 'sareptansinappi')), '2025-09-10 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 = 'sareptansinappi')), '2025-07-23 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 = 'sareptansinappi')), '2025-07-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 = 'sareptansinappi')), '2025-08-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 = 'sareptansinappi')), '2025-09-03 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 = 'sareptansinappi')), '2025-07-09 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 = 'sareptansinappi')), '2025-10-15 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 = 'sareptansinappi')), '2025-10-01 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 = 'sareptansinappi')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('lehtiselleri');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'lehtiselleri'), 'Kirjakahvila');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'lehtiselleri')), '2025-09-24 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 = 'lehtiselleri')), '2025-07-02 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 = 'lehtiselleri')), '2025-08-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 = 'lehtiselleri')), '2025-09-10 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 = 'lehtiselleri')), '2025-07-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 = 'lehtiselleri')), '2025-08-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 = 'lehtiselleri')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('rosmariini');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'rosmariini'), 'Kirjakahvila');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'rosmariini')), '2025-08-06 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 = 'rosmariini')), '2025-10-08 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 = 'rosmariini')), '2025-09-24 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 = 'rosmariini')), '2025-09-17 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 = 'rosmariini')), '2025-08-20 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 = 'rosmariini')), '2025-07-02 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 = 'rosmariini')), '2025-08-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 = 'rosmariini')), '2025-09-10 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 = 'rosmariini')), '2025-07-23 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 = 'rosmariini')), '2025-07-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 = 'rosmariini')), '2025-08-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 = 'rosmariini')), '2025-09-03 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 = 'rosmariini')), '2025-07-09 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 = 'rosmariini')), '2025-10-15 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 = 'rosmariini')), '2025-10-01 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 = 'rosmariini')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('sikuri');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'sikuri'), 'Kirjakahvila');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'sikuri')), '2025-08-06 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 = 'sikuri')), '2025-09-24 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 = 'sikuri')), '2025-09-17 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 = 'sikuri')), '2025-08-20 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 = 'sikuri')), '2025-08-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 = 'sikuri')), '2025-09-10 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 = 'sikuri')), '2025-08-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 = 'sikuri')), '2025-09-03 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 = 'sikuri')), '2025-10-01 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 = 'sikuri')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('sinappikaali');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'sinappikaali'), 'Kissakahvila');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'sinappikaali')), '2025-08-06 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 = 'sinappikaali')), '2025-09-24 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 = 'sinappikaali')), '2025-09-17 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 = 'sinappikaali')), '2025-08-20 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 = 'sinappikaali')), '2025-08-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 = 'sinappikaali')), '2025-09-10 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 = 'sinappikaali')), '2025-08-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 = 'sinappikaali')), '2025-09-03 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 = 'sinappikaali')), '2025-10-01 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 = 'sinappikaali')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('tarhamaltsa');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'tarhamaltsa'), 'Kissakahvila');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'tarhamaltsa')), '2025-08-06 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 = 'tarhamaltsa')), '2025-09-24 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 = 'tarhamaltsa')), '2025-09-17 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 = 'tarhamaltsa')), '2025-08-20 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 = 'tarhamaltsa')), '2025-08-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 = 'tarhamaltsa')), '2025-09-10 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 = 'tarhamaltsa')), '2025-08-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 = 'tarhamaltsa')), '2025-09-03 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 = 'tarhamaltsa')), '2025-10-01 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 = 'tarhamaltsa')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('valkosipuli');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'valkosipuli'), 'Kissakahvila');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'valkosipuli')), '2025-08-06 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 = 'valkosipuli')), '2025-10-08 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 = 'valkosipuli')), '2025-09-24 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 = 'valkosipuli')), '2025-09-17 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 = 'valkosipuli')), '2025-08-20 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 = 'valkosipuli')), '2025-07-02 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 = 'valkosipuli')), '2025-08-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 = 'valkosipuli')), '2025-09-10 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 = 'valkosipuli')), '2025-07-23 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 = 'valkosipuli')), '2025-07-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 = 'valkosipuli')), '2025-08-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 = 'valkosipuli')), '2025-09-03 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 = 'valkosipuli')), '2025-07-09 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 = 'valkosipuli')), '2025-10-15 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 = 'valkosipuli')), '2025-10-01 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 = 'valkosipuli')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('vesikrassi');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'vesikrassi'), 'Kissakahvila');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'vesikrassi')), '2025-08-06 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 = 'vesikrassi')), '2025-10-08 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 = 'vesikrassi')), '2025-09-24 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 = 'vesikrassi')), '2025-09-17 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 = 'vesikrassi')), '2025-08-20 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 = 'vesikrassi')), '2025-07-02 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 = 'vesikrassi')), '2025-08-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 = 'vesikrassi')), '2025-09-10 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 = 'vesikrassi')), '2025-07-23 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 = 'vesikrassi')), '2025-07-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 = 'vesikrassi')), '2025-08-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 = 'vesikrassi')), '2025-09-03 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 = 'vesikrassi')), '2025-07-09 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 = 'vesikrassi')), '2025-10-15 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 = 'vesikrassi')), '2025-10-01 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 = 'vesikrassi')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('vihanneskrassi');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'vihanneskrassi'), 'Kissakahvila');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'vihanneskrassi')), '2025-08-06 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 = 'vihanneskrassi')), '2025-10-08 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 = 'vihanneskrassi')), '2025-09-24 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 = 'vihanneskrassi')), '2025-09-17 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 = 'vihanneskrassi')), '2025-08-20 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 = 'vihanneskrassi')), '2025-07-02 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 = 'vihanneskrassi')), '2025-08-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 = 'vihanneskrassi')), '2025-09-10 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 = 'vihanneskrassi')), '2025-07-23 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 = 'vihanneskrassi')), '2025-07-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 = 'vihanneskrassi')), '2025-08-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 = 'vihanneskrassi')), '2025-09-03 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 = 'vihanneskrassi')), '2025-07-09 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 = 'vihanneskrassi')), '2025-10-15 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 = 'vihanneskrassi')), '2025-10-01 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 = 'vihanneskrassi')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('vihannesportulakka');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'vihannesportulakka'), 'kissakahvila');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'vihannesportulakka')), '2025-08-06 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 = 'vihannesportulakka')), '2025-09-24 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 = 'vihannesportulakka')), '2025-09-17 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 = 'vihannesportulakka')), '2025-08-20 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 = 'vihannesportulakka')), '2025-08-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 = 'vihannesportulakka')), '2025-09-10 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 = 'vihannesportulakka')), '2025-08-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 = 'vihannesportulakka')), '2025-09-03 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 = 'vihannesportulakka')), '2025-10-01 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 = 'vihannesportulakka')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('vuononkaali');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'vuononkaali'), 'Kissakahvila');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'vuononkaali')), '2025-08-06 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 = 'vuononkaali')), '2025-09-24 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 = 'vuononkaali')), '2025-09-17 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 = 'vuononkaali')), '2025-08-20 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 = 'vuononkaali')), '2025-08-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 = 'vuononkaali')), '2025-09-10 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 = 'vuononkaali')), '2025-08-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 = 'vuononkaali')), '2025-09-03 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 = 'vuononkaali')), '2025-10-01 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 = 'vuononkaali')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('herne');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'herne'), 'Kissakahvila');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'herne')), '2025-08-06 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 = 'herne')), '2025-09-24 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 = 'herne')), '2025-09-17 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 = 'herne')), '2025-08-20 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 = 'herne')), '2025-08-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 = 'herne')), '2025-09-10 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 = 'herne')), '2025-08-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 = 'herne')), '2025-09-03 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 = 'herne')), '2025-10-01 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 = 'herne')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('härkäpapu');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'härkäpapu'), 'Kissakahvila');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'härkäpapu')), '2025-08-06 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 = 'härkäpapu')), '2025-10-08 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 = 'härkäpapu')), '2025-09-24 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 = 'härkäpapu')), '2025-09-17 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 = 'härkäpapu')), '2025-08-20 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 = 'härkäpapu')), '2025-07-02 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 = 'härkäpapu')), '2025-08-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 = 'härkäpapu')), '2025-09-10 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 = 'härkäpapu')), '2025-07-23 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 = 'härkäpapu')), '2025-07-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 = 'härkäpapu')), '2025-08-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 = 'härkäpapu')), '2025-09-03 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 = 'härkäpapu')), '2025-07-09 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 = 'härkäpapu')), '2025-10-15 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 = 'härkäpapu')), '2025-10-01 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 = 'härkäpapu')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('jättikurpitsa');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'jättikurpitsa'), 'Koroinen');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'jättikurpitsa')), '2025-08-06 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 = 'jättikurpitsa')), '2025-09-24 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 = 'jättikurpitsa')), '2025-09-17 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 = 'jättikurpitsa')), '2025-08-20 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 = 'jättikurpitsa')), '2025-08-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 = 'jättikurpitsa')), '2025-09-10 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 = 'jättikurpitsa')), '2025-08-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 = 'jättikurpitsa')), '2025-09-03 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 = 'jättikurpitsa')), '2025-10-01 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 = 'jättikurpitsa')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('kukkalaali');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'kukkalaali'), 'Koroinen');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'kukkalaali')), '2025-08-06 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 = 'kukkalaali')), '2025-09-24 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 = 'kukkalaali')), '2025-09-17 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 = 'kukkalaali')), '2025-08-20 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 = 'kukkalaali')), '2025-08-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 = 'kukkalaali')), '2025-09-10 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 = 'kukkalaali')), '2025-08-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 = 'kukkalaali')), '2025-09-03 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 = 'kukkalaali')), '2025-10-01 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 = 'kukkalaali')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('parsakaali');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'parsakaali'), 'Koroinen');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'parsakaali')), '2025-08-06 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 = 'parsakaali')), '2025-10-08 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 = 'parsakaali')), '2025-09-24 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 = 'parsakaali')), '2025-09-17 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 = 'parsakaali')), '2025-08-20 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 = 'parsakaali')), '2025-07-02 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 = 'parsakaali')), '2025-08-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 = 'parsakaali')), '2025-09-10 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 = 'parsakaali')), '2025-07-23 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 = 'parsakaali')), '2025-07-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 = 'parsakaali')), '2025-08-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 = 'parsakaali')), '2025-09-03 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 = 'parsakaali')), '2025-07-09 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 = 'parsakaali')), '2025-10-15 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 = 'parsakaali')), '2025-10-01 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 = 'parsakaali')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('kurkku');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'kurkku'), 'Koroinen');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'kurkku')), '2025-08-06 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 = 'kurkku')), '2025-10-08 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 = 'kurkku')), '2025-09-24 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 = 'kurkku')), '2025-09-17 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 = 'kurkku')), '2025-08-20 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 = 'kurkku')), '2025-07-02 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 = 'kurkku')), '2025-08-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 = 'kurkku')), '2025-09-10 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 = 'kurkku')), '2025-07-23 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 = 'kurkku')), '2025-07-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 = 'kurkku')), '2025-08-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 = 'kurkku')), '2025-09-03 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 = 'kurkku')), '2025-07-09 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 = 'kurkku')), '2025-10-15 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 = 'kurkku')), '2025-10-01 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 = 'kurkku')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('kesäkurpitsa');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'kesäkurpitsa'), 'Koroinen');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'kesäkurpitsa')), '2025-08-06 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 = 'kesäkurpitsa')), '2025-09-24 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 = 'kesäkurpitsa')), '2025-09-17 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 = 'kesäkurpitsa')), '2025-08-20 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 = 'kesäkurpitsa')), '2025-08-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 = 'kesäkurpitsa')), '2025-09-10 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 = 'kesäkurpitsa')), '2025-08-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 = 'kesäkurpitsa')), '2025-09-03 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 = 'kesäkurpitsa')), '2025-10-01 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 = 'kesäkurpitsa')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('spagettikurpitsa');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'spagettikurpitsa'), 'Koroinen');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'spagettikurpitsa')), '2025-08-06 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 = 'spagettikurpitsa')), '2025-09-17 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 = 'spagettikurpitsa')), '2025-08-20 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 = 'spagettikurpitsa')), '2025-07-23 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 = 'spagettikurpitsa')), '2025-09-03 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 = 'spagettikurpitsa')), '2025-07-09 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 = 'spagettikurpitsa')), '2025-10-01 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('latva-artisokka');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'latva-artisokka'), 'Koroinen');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'latva-artisokka')), '2025-08-06 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 = 'latva-artisokka')), '2025-10-08 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 = 'latva-artisokka')), '2025-09-24 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 = 'latva-artisokka')), '2025-09-17 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 = 'latva-artisokka')), '2025-08-20 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 = 'latva-artisokka')), '2025-07-02 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 = 'latva-artisokka')), '2025-08-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 = 'latva-artisokka')), '2025-09-10 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 = 'latva-artisokka')), '2025-07-23 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 = 'latva-artisokka')), '2025-07-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 = 'latva-artisokka')), '2025-08-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 = 'latva-artisokka')), '2025-09-03 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 = 'latva-artisokka')), '2025-07-09 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 = 'latva-artisokka')), '2025-10-15 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 = 'latva-artisokka')), '2025-10-01 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 = 'latva-artisokka')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('maissi');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'maissi'), 'Koroinen');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'maissi')), '2025-08-06 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 = 'maissi')), '2025-10-08 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 = 'maissi')), '2025-09-24 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 = 'maissi')), '2025-09-17 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 = 'maissi')), '2025-08-20 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 = 'maissi')), '2025-07-02 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 = 'maissi')), '2025-08-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 = 'maissi')), '2025-09-10 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 = 'maissi')), '2025-07-23 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 = 'maissi')), '2025-07-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 = 'maissi')), '2025-08-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 = 'maissi')), '2025-09-03 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 = 'maissi')), '2025-07-09 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 = 'maissi')), '2025-10-15 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 = 'maissi')), '2025-10-01 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 = 'maissi')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('munakoiso');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'munakoiso'), 'Koroinen');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'munakoiso')), '2025-08-06 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 = 'munakoiso')), '2025-10-08 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 = 'munakoiso')), '2025-09-24 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 = 'munakoiso')), '2025-09-17 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 = 'munakoiso')), '2025-08-20 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 = 'munakoiso')), '2025-07-02 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 = 'munakoiso')), '2025-08-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 = 'munakoiso')), '2025-09-10 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 = 'munakoiso')), '2025-07-23 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 = 'munakoiso')), '2025-07-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 = 'munakoiso')), '2025-08-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 = 'munakoiso')), '2025-09-03 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 = 'munakoiso')), '2025-07-09 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 = 'munakoiso')), '2025-10-15 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 = 'munakoiso')), '2025-10-01 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 = 'munakoiso')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('okra');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'okra'), 'Koroinen');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'okra')), '2025-08-06 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 = 'okra')), '2025-09-24 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 = 'okra')), '2025-09-17 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 = 'okra')), '2025-08-20 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 = 'okra')), '2025-08-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 = 'okra')), '2025-09-10 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 = 'okra')), '2025-08-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 = 'okra')), '2025-09-03 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 = 'okra')), '2025-10-01 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 = 'okra')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('paprika');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'paprika'), 'Masku');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'paprika')), '2025-09-24 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 = 'paprika')), '2025-07-02 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 = 'paprika')), '2025-08-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 = 'paprika')), '2025-09-10 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 = 'paprika')), '2025-07-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 = 'paprika')), '2025-08-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 = 'paprika')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('parsaherne');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'parsaherne'), 'Masku');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'parsaherne')), '2025-08-06 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 = 'parsaherne')), '2025-10-08 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 = 'parsaherne')), '2025-09-24 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 = 'parsaherne')), '2025-09-17 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 = 'parsaherne')), '2025-08-20 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 = 'parsaherne')), '2025-07-02 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 = 'parsaherne')), '2025-08-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 = 'parsaherne')), '2025-09-10 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 = 'parsaherne')), '2025-07-23 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 = 'parsaherne')), '2025-07-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 = 'parsaherne')), '2025-08-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 = 'parsaherne')), '2025-09-03 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 = 'parsaherne')), '2025-07-09 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 = 'parsaherne')), '2025-10-15 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 = 'parsaherne')), '2025-10-01 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 = 'parsaherne')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('tarhapapu');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'tarhapapu'), 'Merimasku');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'tarhapapu')), '2025-08-06 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 = 'tarhapapu')), '2025-10-08 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 = 'tarhapapu')), '2025-09-24 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 = 'tarhapapu')), '2025-09-17 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 = 'tarhapapu')), '2025-08-20 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 = 'tarhapapu')), '2025-07-02 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 = 'tarhapapu')), '2025-08-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 = 'tarhapapu')), '2025-09-10 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 = 'tarhapapu')), '2025-07-23 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 = 'tarhapapu')), '2025-07-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 = 'tarhapapu')), '2025-08-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 = 'tarhapapu')), '2025-09-03 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 = 'tarhapapu')), '2025-07-09 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 = 'tarhapapu')), '2025-10-15 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 = 'tarhapapu')), '2025-10-01 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 = 'tarhapapu')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('tomaatti');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'tomaatti'), 'Naantali');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'tomaatti')), '2025-08-06 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 = 'tomaatti')), '2025-10-08 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 = 'tomaatti')), '2025-09-24 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 = 'tomaatti')), '2025-09-17 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 = 'tomaatti')), '2025-08-20 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 = 'tomaatti')), '2025-07-02 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 = 'tomaatti')), '2025-08-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 = 'tomaatti')), '2025-09-10 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 = 'tomaatti')), '2025-07-23 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 = 'tomaatti')), '2025-07-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 = 'tomaatti')), '2025-08-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 = 'tomaatti')), '2025-09-03 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 = 'tomaatti')), '2025-07-09 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 = 'tomaatti')), '2025-10-15 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 = 'tomaatti')), '2025-10-01 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 = 'tomaatti')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('kirsikkatomaatti');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'kirsikkatomaatti'), 'Naantali');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'kirsikkatomaatti')), '2025-08-06 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 = 'kirsikkatomaatti')), '2025-10-08 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 = 'kirsikkatomaatti')), '2025-09-24 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 = 'kirsikkatomaatti')), '2025-09-17 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 = 'kirsikkatomaatti')), '2025-08-20 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 = 'kirsikkatomaatti')), '2025-07-02 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 = 'kirsikkatomaatti')), '2025-08-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 = 'kirsikkatomaatti')), '2025-09-10 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 = 'kirsikkatomaatti')), '2025-07-23 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 = 'kirsikkatomaatti')), '2025-07-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 = 'kirsikkatomaatti')), '2025-08-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 = 'kirsikkatomaatti')), '2025-09-03 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 = 'kirsikkatomaatti')), '2025-07-09 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 = 'kirsikkatomaatti')), '2025-10-15 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 = 'kirsikkatomaatti')), '2025-10-01 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 = 'kirsikkatomaatti')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('basilika');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'basilika'), 'Naantali');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'basilika')), '2025-08-06 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 = 'basilika')), '2025-09-17 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 = 'basilika')), '2025-08-20 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 = 'basilika')), '2025-07-23 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 = 'basilika')), '2025-09-03 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 = 'basilika')), '2025-07-09 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 = 'basilika')), '2025-10-01 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('korianteri');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'korianteri'), 'Naantali');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'korianteri')), '2025-08-06 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 = 'korianteri')), '2025-10-08 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 = 'korianteri')), '2025-09-24 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 = 'korianteri')), '2025-09-17 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 = 'korianteri')), '2025-08-20 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 = 'korianteri')), '2025-07-02 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 = 'korianteri')), '2025-08-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 = 'korianteri')), '2025-09-10 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 = 'korianteri')), '2025-07-23 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 = 'korianteri')), '2025-07-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 = 'korianteri')), '2025-08-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 = 'korianteri')), '2025-09-03 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 = 'korianteri')), '2025-07-09 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 = 'korianteri')), '2025-10-15 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 = 'korianteri')), '2025-10-01 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 = 'korianteri')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('kynteli');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'kynteli'), 'Raisio');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'kynteli')), '2025-08-06 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 = 'kynteli')), '2025-10-08 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 = 'kynteli')), '2025-09-24 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 = 'kynteli')), '2025-09-17 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 = 'kynteli')), '2025-08-20 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 = 'kynteli')), '2025-07-02 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 = 'kynteli')), '2025-08-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 = 'kynteli')), '2025-09-10 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 = 'kynteli')), '2025-07-23 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 = 'kynteli')), '2025-07-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 = 'kynteli')), '2025-08-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 = 'kynteli')), '2025-09-03 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 = 'kynteli')), '2025-07-09 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 = 'kynteli')), '2025-10-15 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 = 'kynteli')), '2025-10-01 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 = 'kynteli')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('piparminttu');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'piparminttu'), 'Raisio');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'piparminttu')), '2025-08-06 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 = 'piparminttu')), '2025-10-08 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 = 'piparminttu')), '2025-09-24 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 = 'piparminttu')), '2025-09-17 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 = 'piparminttu')), '2025-08-20 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 = 'piparminttu')), '2025-07-02 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 = 'piparminttu')), '2025-08-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 = 'piparminttu')), '2025-09-10 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 = 'piparminttu')), '2025-07-23 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 = 'piparminttu')), '2025-07-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 = 'piparminttu')), '2025-08-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 = 'piparminttu')), '2025-09-03 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 = 'piparminttu')), '2025-07-09 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 = 'piparminttu')), '2025-10-15 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 = 'piparminttu')), '2025-10-01 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 = 'piparminttu')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('viherminttu');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'viherminttu'), 'Raisio');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'viherminttu')), '2025-08-06 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 = 'viherminttu')), '2025-10-08 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 = 'viherminttu')), '2025-09-24 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 = 'viherminttu')), '2025-09-17 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 = 'viherminttu')), '2025-08-20 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 = 'viherminttu')), '2025-07-02 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 = 'viherminttu')), '2025-08-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 = 'viherminttu')), '2025-09-10 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 = 'viherminttu')), '2025-07-23 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 = 'viherminttu')), '2025-07-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 = 'viherminttu')), '2025-08-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 = 'viherminttu')), '2025-09-03 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 = 'viherminttu')), '2025-07-09 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 = 'viherminttu')), '2025-10-15 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 = 'viherminttu')), '2025-10-01 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 = 'viherminttu')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('laventeli');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'laventeli'), 'Raisio');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'laventeli')), '2025-08-06 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 = 'laventeli')), '2025-10-08 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 = 'laventeli')), '2025-09-24 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 = 'laventeli')), '2025-09-17 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 = 'laventeli')), '2025-08-20 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 = 'laventeli')), '2025-07-02 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 = 'laventeli')), '2025-08-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 = 'laventeli')), '2025-09-10 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 = 'laventeli')), '2025-07-23 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 = 'laventeli')), '2025-07-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 = 'laventeli')), '2025-08-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 = 'laventeli')), '2025-09-03 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 = 'laventeli')), '2025-07-09 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 = 'laventeli')), '2025-10-15 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 = 'laventeli')), '2025-10-01 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 = 'laventeli')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('lipstikka');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'lipstikka'), 'Raisio');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'lipstikka')), '2025-08-06 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 = 'lipstikka')), '2025-09-24 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 = 'lipstikka')), '2025-09-17 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 = 'lipstikka')), '2025-08-20 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 = 'lipstikka')), '2025-08-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 = 'lipstikka')), '2025-09-10 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 = 'lipstikka')), '2025-08-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 = 'lipstikka')), '2025-09-03 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 = 'lipstikka')), '2025-10-01 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 = 'lipstikka')), '2025-07-30 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('mukulaselleri');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'mukulaselleri'), 'Viherlassila');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'mukulaselleri')), '2025-08-06 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 = 'mukulaselleri')), '2025-09-17 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 = 'mukulaselleri')), '2025-08-20 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 = 'mukulaselleri')), '2025-07-23 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 = 'mukulaselleri')), '2025-09-03 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 = 'mukulaselleri')), '2025-07-09 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 = 'mukulaselleri')), '2025-10-01 10:00:00+00');
|
|
INSERT INTO loota_customer (identifier) VALUES ('nokkonen');
|
|
INSERT INTO loota_order(customer_id, location) VALUES ((SELECT id FROM loota_customer WHERE identifier = 'nokkonen'), 'Viherlassila');
|
|
INSERT INTO loota_box (order_id, delivery_date) VALUES ((SELECT id FROM loota_order WHERE customer_id = (SELECT id FROM loota_customer WHERE identifier = 'nokkonen')), '2025-08-06 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 = 'nokkonen')), '2025-10-08 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 = 'nokkonen')), '2025-09-24 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 = 'nokkonen')), '2025-09-17 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 = 'nokkonen')), '2025-08-20 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 = 'nokkonen')), '2025-07-02 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 = 'nokkonen')), '2025-08-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 = 'nokkonen')), '2025-09-10 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 = 'nokkonen')), '2025-07-23 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 = 'nokkonen')), '2025-07-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 = 'nokkonen')), '2025-08-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 = 'nokkonen')), '2025-09-03 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 = 'nokkonen')), '2025-07-09 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 = 'nokkonen')), '2025-10-15 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 = 'nokkonen')), '2025-10-01 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 = 'nokkonen')), '2025-07-30 10:00:00+00');
|