If I understand you correctly, something like this should help you.
global $wpdb;
$results = $wpdb->get_results( "SELECT post_author, SUM(comment_count) as comments FROM {$wpdb->posts} WHERE post_type="post" AND post_status="publish" GROUP BY post_author ORDER BY comments DESC LIMIT 10");
This will return you 10 authors of most commented posts (with highest sum of comments count of each post they have written).
I’m not sure if this is what you wanted though.
Related Posts:
- Get attachments from a post
- How to check username/password without signing in the user
- Add Custom User Capabilities Before or After the Custom User Role has Been Added?
- Writing a plugin that notify my friends of new post that mentions(@) them
- WordPress REST API call generates nonce twice on every call
- Why are two functions over-riding each other?
- Custom user profile, registration, login page with theme
- How to use WP default post list tables in a plugin?
- Rest Api How to get results of child categories with one api call
- How to add quick edit and bulk edit fields to users admin section
- WordPress Plugin Setting’s POST
- Comment `Reply` link doesn’t work if comments are loaded from ajax
- comment_email hook doesn’t seem to work for comment editor field
- Generating User(s) with Settings API
- Show comments fields in two columns
- WordPress admin deleted user details not removed in database. How to delete WordPress Users from Database
- Print WordPress username id inside JavaScript
- Function Get User Object By Username?
- Check if someone is editing a post (this content is currently locked)
- preprocess_comment array doesn’t have comment_ID
- How do I alter the comment form ‘allowed tags’ text in a plugin?
- Modify users.php page to create page/post on button clicked
- Can wp_list_comments output into variable?
- Subscribe to author?
- Comments do not respect display_name setting, how to make plugin to overcome this
- How to filter users list on user_status field with get_users()
- Frontend language per user
- Slow WP_query due to nested wp_query. Need Suggestions
- $reverse_top_level works the opposite way according to Codex?
- Display custom fields in frontside user profile
- How to integrate CLEditor to comment system?
- pre_get_post alter current post id
- global $current_user not current user
- Display list of uploaded images, filtered by user under a specific user group
- What is the proper way to get logged in user id in a plugin?
- is pre_get_comments not working?
- How to build a fool proof AdSense revenue sharing model?
- Hide custom post type by user roles
- How do I have now a duplicated user entry if this is not allowed (and I cannot replicate it)?
- How to replace default comments with custom HTML?
- How to allow only two (or more) users access to a plugin
- Why in this archive page that call query_posts() function show only the last 10 posts?
- First and last name fields not filled when using wp_insert_user
- Wp-admin Custom User Management
- Custom avatars in wordpress comments?
- get author of published post
- How to get custom post_author?
- Associate multiple email addresses with the same user account, so they can log in with either
- how to load the comment template from a plugin
- Update a user profile via frontend
- Best practice for Designing a Plugin with this scenario
- Adding another field to user table
- How to get the number of pages when paginating comments?
- How does “Your comment is awaiting moderation” work?
- How can I change my assigned user role in WordPress 3.5.1?
- How to relate the Category to user?
- disable defaault wordpress comments from a plugin
- How to show comments from different Plugins to same post type?
- How to check if `comment_meta` exists before inserting the comment?
- How to get the `comment_post_ID`?
- Adding a dropdown on the user admin
- Allowing duplicating users with same user_login and user_email
- Why User_login key doesn’t work with wp_update_user()
- How to grab data after wp user search is complete
- Email content as comment
- How to prevent users from deleting their accounts?
- User Registration Moderate
- admin-ajax.php returns “No Script Kiddies!” sometimes
- How to retrieve custom profile fields associated with different users
- WP Query Relations / Compare
- Upgrade routine: Interaction with user confirmation
- Query only title/field/featured media of posts [closed]
- Stop theme displaying comments
- How to limit the number of posts a user can view based on status
- Get Commentor IP When Marking Comment As Spam
- How can I add recent posts to menu like mashable
- Multiple Users Logged In Causing Incorrect Account Returned
- first_name property missing inside register_user action hook
- Get next page in get_posts
- isset($_POST[‘submit’]) ignored on comment submission
- user can login from single account detail from multiple locations(computer) at the same time [closed]
- Create Unique and Customized User ID for Website Members in WordPress
- How to get recent one post from each category on home page?
- When would I use either function for plugins?
- Test to see if jQuery or Prototype is queued by another plugin?
- How to properly load text domain of custom mu plugin
- Post from front-end with post types, categories and taxonomies
- Using Ajax call in jQuery doesn’t work in widget
- How to redirect to action on custom page within admin section
- Hook to See if Comment got a Reply?
- How to convert this cURL to wp_remote_get?
- is user logged in not working
- Override class inside $atts shortcode_atts in WordPress
- Is it possible to restrict all admin pages except theme customisation and storefront using plugin?
- Updating Woocommerce Settings API when WordPress Settings API saved and vise versa
- How to give a download link to a .csv file from the custom plugin?
- Gutenberg – is it ok to load dependencies multiple times?
- How to create dynamic content with get_post_meta?
- Return raw image proxy for wordpress plugin
- Use a page as a template for a custom post type