Untitled

SELECT 
        COUNT(1) AS is_user_non_us
        FROM prof_user_outside_US AS p
        LEFT JOIN user_info AS u ON p.user_id = u.user_id
        WHERE
        p.user_id = %s
        OR (
            u.has_set_password = 0
            AND u.class_id = 3
        )