<?xml version="1.0"?> <queryset> <fullquery name="acs_mail_lite::get_address_array.get_user_name_and_id"> <querytext> select person_id as user_id, first_names || ' ' || last_name as user_name from parties, persons where email = :email and party_id = person_id order by party_id desc limit 1 </querytext> </fullquery> <fullquery name="acs_mail_lite::sweeper.get_queued_message"> <querytext> select message_id as id from acs_mail_lite_queue where message_id=:id and (locking_server = '' or locking_server is NULL) </querytext> </fullquery> <fullquery name="acs_mail_lite::sweeper.lock_queued_message"> <querytext> update acs_mail_lite_queue set locking_server = :locking_server where message_id=:id </querytext> </fullquery> <fullquery name="acs_mail_lite::sweeper.delete_queue_entry"> <querytext> delete from acs_mail_lite_queue where message_id=:id </querytext> </fullquery> <fullquery name="acs_mail_lite::send_immediately.get_file_info"> <querytext> select r.mime_type,r.title, r.content as filename, i.name from cr_revisions r, cr_items i where r.revision_id = i.latest_revision and i.item_id in ([join $item_ids ","]) </querytext> </fullquery> </queryset>