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