select i.name as filename, r.content_length as file_length from cr_items i, cr_revisions r where i.parent_id = :mail_job_id and r.item_id = i.item_id select title as selection_name from us_selections where selection_id = :selection_id select name as list_name from ml_mailing_lists where list_id = :list_id