select ci.item_id as assessment_id, cr.title
from cr_items ci, cr_revisions cr
where cr.revision_id = ci.latest_revision
and ci.content_type = 'as_assessments'
and ci.parent_id = :folder_id
order by cr.title
select ci.item_id as assessment_id, cr.title
from cr_items ci, cr_revisions cr
where cr.revision_id = ci.latest_revision
and ci.content_type = 'as_assessments'
and ci.parent_id = :folder_id
and ci.item_id in (select object_id from acs_permissions where
grantee_id=:user_id and privilege='admin')
order by cr.title