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