select cr.item_id as assessment_id, cr.title, cr.description, cf.package_id, p.instance_name as community_name, sc.node_id as comm_node_id, sa.node_id as as_node_id, s.session_id, s.completed_datetime, a.anonymous_p, a.assessment_id as assessment_rev_id, to_char(a.start_time, 'YYYY-MM-DD HH24:MI:SS') as start_time, to_char(a.end_time, 'YYYY-MM-DD HH24:MI:SS') as end_time, to_char(now(), 'YYYY-MM-DD HH24:MI:SS') as cur_time from as_assessmentsi a left join as_sessions s on (a.item_id = (select item_id from cr_revisions where revision_id = s.assessment_id) and s.subject_id = :user_id and not s.subject_id in (select grantee_id from acs_permissions_all where privilege = 'admin' and object_id in ([join $list_of_package_ids ", "]))), cr_revisions cr, cr_items ci, cr_folders cf, site_nodes sa, site_nodes sc, apm_packages p where a.assessment_id = cr.revision_id and cr.revision_id = ci.latest_revision and ci.parent_id = cf.folder_id and cf.package_id in ([join $list_of_package_ids ", "]) and sa.object_id = cf.package_id and sc.node_id = sa.parent_id and p.package_id = sc.object_id $status_clause order by lower(p.instance_name), lower(cr.title)