BuddyPress.org

Even this doesn’t work:

$email = $wpdb->query("SELECT user_email FROM $wpdb->signups WHERE activation_key = %s", $key);

And this also does not work:

$email = $wpdb->query("SELECT user_email FROM $wpdb->users WHERE ID = %s", $user_id);

??