Ортопедическая профилактическая обувь  

select json_agg(row_to_json(q)) as rows from (select * from ( select * from ( select product_id, product_name, enabled, parent_id, image, product_type, contact_list, iscategory, producer, alias, modification, characteristics, article, root_id, ord, tags, (select min(price) from crm_order.product_price where department_id = any('{ }' ) and product_id=a.product_id ) as price, (select json_agg(row_to_json(z)) from (select * from crm_order.product_price where department_id = any('{ }' ) and product_id=a.product_id)z ) as price_json , user_data from crm_order.product a where 1=1 and enabled and ( parent_id='22712' or (select parent_id from crm_order.product where product_id=a.parent_id )='22712' or (select parent_id from crm_order.product where product_id=(select parent_id from crm_order.product where product_id=a.parent_id ) )='22712' ) )w )q where iscategory=false order by (user_data->>'priority')::int nulls last,image is not null desc,ord nulls last offset 0 limit 20)q