SELECT phpbb_users.user_id, username, user_email, user_ip, pf_antispam_three FROM phpbb_users JOIN phpbb_profile_fields_data ON phpbb_users.user_id=phpbb_profile_fields_data.user_id