select da.archive_name, dar.creation_user, dar.version_name, u.email as creation_email from download_arch_revisions_obj dar, download_archives_obj da, cc_users u where da.archive_id = dar.archive_id and dar.revision_id = :revision_id and u.user_id = dar.creation_user select email as approving_email, first_names || ' ' || last_name as approving_name from cc_users where user_id = :user_id