postgresql7.1
select message_id, sender_id, recipient_id, package_id, sent_date, body, subject, object_id, log_id
from acs_mail_log
where message_id <> 0
$recipient_where_clause
[template::list::filter_where_clauses -and -name messages]
[template::list::orderby_clause -orderby -name messages]