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 ","])