Зест Сліп капс.№30 Elephant Co., Ltd.

select json_agg(row_to_json(q)) as rows from (select * from ( select w.localization,price_modification,a.department_id,w.department_name,w.city, w.address, w.image,w.coord_x,w.coord_y,w.work_time, ( select row_to_json(kk) as d2 from (select amount::int,((amount-amount::int)*5)::int amount_partition,price_info::jsonb || jsonb_build_object('main', e.price) price_info from crm_order.product_price kk where product_id=a.product_id and department_id=a.department_id and amount>0 order by coalesce((price_info->>'action')::numeric,(price_info->>'main')::numeric) limit 1)kk ), q.partitions from crm_order.product_price a left join (select department_id, department_name, city, city_id, address, image, st_x(st_centroid(geom)) as coord_x, st_y(st_centroid(geom)) as coord_y,details->>'work_time' work_time, details->'localization' as localization from crm_order.order_department)w on w.department_id=a.department_id left join (select product_id,price from crm_order.product)e on e.product_id=a.product_id left join lateral (select json_agg(row_to_json(q))partitions from (select unit,amount_max,localization,price_info from crm_order.product_partition q where a.product_id=q.product_id)q)q on 1=1 where a.amount>0 and a.product_id='2296581130184296006' and (case when ''<>'' then (a.department_id in (select department_id from crm_order.order_department where order_region_id='')) else true end ) )q where department_id not in (select distinct department_id from crm_order.order_item where user_id='4AcCAY0l3x63foQGbWv1i6s7rHp16NLC' and order_id is null and department_id is not null) and department_id in (select department_id from crm_order.order_department where city_id = '2151687791023490766' and enabled) order by department_id::bigint nulls last offset 0 limit 1000)q