select u.password as user_password, u.salt as user_salt, p.first_names || ' ' || p.last_name as user_name, y.email as user_email from users u, persons p, parties y where u.user_id = :user_id and p.person_id = u.user_id and y.party_id = u.user_id select u.password as user_password, u.salt as user_salt, p.first_names || ' ' || p.last_name as user_name, y.email as user_email from users u, persons p, parties y where u.user_id = :user_id and p.person_id = u.user_id and y.party_id = u.user_id select country_code, category_id from ml_country_codes