blob: e8bb1c338de623e5040e10e13bff52ba6d3fe7d9 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
INSERT INTO public.scrooge_eats_orders
SELECT 10001,ID.id,now(),0
FROM
(
SELECT S.id FROM public.scrooge_eats_accounts AS S,public.companies AS C
WHERE C.name = 'DTF' AND S.company_id = C.id
) AS ID;
INSERT INTO public.scrooge_eats_basket_items ( order_id,item_id,quantity )
SELECT 10001,I.id,1
FROM
(
SELECT id,price FROM public.scrooge_eats_items
WHERE name SIMILAR TO '(Paella)|(Cider)'
) AS I
|
