postgresql
7.2
select o.title as category_name
from categories c,
acs_objects o,
category_object_map m
where c.category_id = o.object_id
and m.category_id = c.category_id
and m.object_id = :item_id
limit 1
select ci.name
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 p.page_order::integer
limit 1
select case when count(*) = 0 then 0 else 1 end
where exists (
select 1
from category_object_map
where category_id = :my_category_id)
select p.page_order
from cr_items ci,
xowiki_page p
where ci.parent_id = :folder_id
and ci.content_type = '::xowiki::PageInstance'
and p.page_id = ci.live_revision
and p.page_order is not null
order by p.page_order::integer desc