<queryset>
    <fullquery name="get_items_id">
        <querytext>
            select ci.item_id
            from category_object_map c,
                cr_items ci,
                xowiki_page p
            where c.object_id = ci.item_id
                and ci.parent_id = :folder_id 
                and ci.content_type = '::xowiki::PageInstance'
                and category_id = :category_id
                and p.page_id = ci.live_revision
            order by page_order::integer
        </querytext>
    </fullquery>
</queryset>