select ci.item_id, ci.name, ci.live_revision as revision_id, p.page_order from category_object_map c, cr_items ci, xowiki_page p where c.object_id = ci.item_id and ci.parent_id = :wiki_folder_id and ci.content_type = '::xowiki::PageInstance' and p.page_id = ci.live_revision and category_id = :cat_id order by p.page_order select parent_id from categories where category_id = :cat_id select category_id from categories where parent_id = :cat_id order by category_id desc select category_id from categories where parent_id = :parent_id and category_id < :cat_id order by category_id desc select parent_id from categories where category_id = :cat_id select category_id from categories where parent_id = :parent_id and category_id > :cat_id order by category_id select category_id from categories where parent_id = :subcategory order by category_id