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