select email_verified_p from users where user_id = :user_id select 1 from ml_mailing_list_user_map where list_id = :list_id and user_id = :user_id select l.sender_email, l.welcome_subject, l.welcome_body, l.welcome_mime_type, p.email as user_email, o.mime_charset from ml_mailing_lists l, ad_locales o, parties p where l.list_id = :list_id and o.locale = l.locale and p.party_id = :user_id