select folder_id, folder_name from messages_folders where (user_id = :user_id or user_id = 0) order by folder_id asc select concat('{n:"'||to_clob(party_name)||'", p:"'||to_clob(person_id)||'"}') as contact from (select persons.first_names||' '||persons.last_name as party_name, persons.person_id from persons,dotlrn_member_rels_approved where dotlrn_member_rels_approved.community_id = :community_id and dotlrn_member_rels_approved.user_id = persons.person_id and rownum <= $limit and rownum > $i order by party_name) select '{n:"'||party_name||'", p:"'||person_id||'"}' as contact from (select persons.first_names||' '||persons.last_name as party_name, persons.person_id from persons,dotlrn_member_rels_approved where dotlrn_member_rels_approved.community_id = :community_id and dotlrn_member_rels_approved.user_id = persons.person_id and rownum > 1500 order by party_name) select count(*) from persons,dotlrn_member_rels_approved where dotlrn_member_rels_approved.community_id = :community_id and dotlrn_member_rels_approved.user_id = persons.person_id