select m.sender_email, m.confirm_subject, m.confirm_body, m.confirm_mime_type, m.welcome_subject, m.welcome_body, m.welcome_mime_type, l.mime_charset from ml_mailing_lists m, ad_locales l where m.list_id = :list_id and l.locale = m.locale select party_id from parties where email = lower(:email)