update acs_mail_lite_mail_log
set last_mail_date = sysdate
where party_id = :user_id
insert into acs_mail_lite_mail_log (party_id, last_mail_date)
values (:user_id, sysdate)
update acs_mail_lite_bounce
set bounce_count = bounce_count + 1
where party_id = :rcpt_id
insert into acs_mail_lite_bounce (party_id, bounce_count)
values (:rcpt_id, 1)
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
select id
from acs_mail_lite_queue
where id=:id and (locking_server = '' or locking_server is NULL)
update acs_mail_lite_queue
set locking_server = :locking_server
where id=:id
delete from acs_mail_lite_queue
where id=:id
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 ","])