ad_page_contract {
} -properties {
    out : onevalue
}

set out ""

db_foreach take_users {
        select 
          u.password, 
          u.salt, 
          u.password_question, 
          u.password_answer, 
          u.screen_name, 
          u.priv_name,
          u.priv_email, 
          pty.email, 
          pty.url, 
          per.first_names, 
          per.last_name 
        from 
          persons per,
          parties pty, 
          users u 
        where 
            u.user_id = pty.party_id 
          and 
            pty.party_id = per.person_id 
          and 
            u.email_verified_p = 't' 
          and 
            u.email_bouncing_p ='f'
} {
    append out "\"$password\",\"$salt\",\"$password_question\",\"$password_answer\",\"$screen_name\",\"$priv_name\",\"$priv_email\",\"$email\",\"$url\",\"$first_names\",\"$last_name\"\n"
}

# ,\"$\"
# ,\"$\",\"$\",\"$\",\"$\",\"$\",\"$\",\"$\"

ns_return 200 "text/plain" $out