SELECT `id` , `fullname` , `username` , `email` , `image` , `city` , `country` , `followed_by` , `registration_type` , `activated_at` , `created_at` , `updated_at` , `deleted_at` , `other_social_media` FROM `ambassador` . `candidates` 