select item_id
from cr_items
where parent_id = :folder_id
and content_type = '::xowiki::FormPage'
and name like :letter
order by name
select name
from cr_items
where item_id = :item_id
select distinct substr(name,1,1)
from cr_items
where parent_id = :folder_id
and content_type = '::xowiki::FormPage'
order by substr(name,1,1)
select instance_attributes
from xowiki_form_pagei
where item_id = :item_id
select item_id,
name
from cr_items
where parent_id = :folder_id
and content_type = '::xowiki::FormPage'
and name like :letter
order by name
select sum(times_used) as count
from content_glossary_term_count
where folder_id = :folder_id
and term = :name