Buddypress export Profile Fields [closed]

Since the asker really doesn’t want to post the answer … someone has to do it:

SELECT wp_users.ID , wp_users.user_email 
FROM wp_users 
    LEFT JOIN wp_bp_xprofile_data ON wp_bp_xprofile_data.user_id = wp_users.ID, 
    WHERE wp_bp_xprofile_data.field_id = 8 
    AND wp_bp_xprofile_data.value="yes"

field_id = 8 being the Field you want to get (in my example, newsletter) wp_bp_xprofile_data.value="yes", being the value of the checkbox.