Title: Exporting users Last modified: November 2, 2018 --- # Exporting users * Resolved [chinatownlee](https://wordpress.org/support/users/chinatownlee/) * (@chinatownlee) * [7 years, 7 months ago](https://wordpress.org/support/topic/exporting-users-3/) * Hi Greg, * any idea how could I export Buddypress user data, specifically users that have at least 1 advert running on my classifieds website? This would help creating personalized marketing communication. Viewing 2 replies - 1 through 2 (of 2 total) * Plugin Author [Greg Winiarski](https://wordpress.org/support/users/gwin/) * (@gwin) * [7 years, 6 months ago](https://wordpress.org/support/topic/exporting-users-3/#post-10848372) * You can get a list of user IDs with at least one active Advert by running the query below from phpMyAdmin * ``` SELECT post_author, user_email, COUNT(*) as active_ads FROM wp_posts INNER JOIN wp_users ON wp_posts.post_author = wp_users.ID WHERE post_type = 'advert' AND post_status = 'publish' GROUP BY post_author; ``` * This query will return the list of user IDs, user email and the number of active Ads the user has, something like this * ``` post_author | user_email | active_ads ------------+----------------------+----------- 1 | test@example.com | 3 11 | john.doe@example.com | 1 ``` * Thread Starter [chinatownlee](https://wordpress.org/support/users/chinatownlee/) * (@chinatownlee) * [7 years, 6 months ago](https://wordpress.org/support/topic/exporting-users-3/#post-10851546) * Thanks, Greg. Viewing 2 replies - 1 through 2 (of 2 total) The topic ‘Exporting users’ is closed to new replies. * ![](https://ps.w.org/wpadverts/assets/icon-256x256.png?rev=2423472) * [WPAdverts - Classifieds Plugin](https://wordpress.org/plugins/wpadverts/) * [Frequently Asked Questions](https://wordpress.org/plugins/wpadverts/#faq) * [Support Threads](https://wordpress.org/support/plugin/wpadverts/) * [Active Topics](https://wordpress.org/support/plugin/wpadverts/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/wpadverts/unresolved/) * [Reviews](https://wordpress.org/support/plugin/wpadverts/reviews/) * 2 replies * 2 participants * Last reply from: [chinatownlee](https://wordpress.org/support/users/chinatownlee/) * Last activity: [7 years, 6 months ago](https://wordpress.org/support/topic/exporting-users-3/#post-10851546) * Status: resolved