select man_id
from ims_cp_organizations o, ims_cp_items i
where ims_item_id=:item_id
and o.org_id=i.org_id
select sort_order, parent_item
from ims_cp_items
where ims_item_id = :ims_item_id
select sort_order
from ims_cp_items
where parent_item=:parent_item
and sort_order > :sort_order
order by sort_order
limit 1
select sort_order
from ims_cp_items
where parent_item=:parent_item
and sort_order < :sort_order
order by sort_order desc
limit 1
select ims_item_id
from ims_cp_items
where parent_item=:parent_item for update
update ims_cp_items
set sort_order =
( case when sort_order = :sort_order :: integer then :next_sort_order :: integer
when sort_order = :next_sort_order ::integer then :sort_order end )
where parent_item=:parent_item
and sort_order in (:sort_order, :next_sort_order)