Query to get the author who having maximum number of post (custom post type)

You can try with the following query, where the author data as well as the post count can be retrieved.

$sql = "SELECT SQL_CALC_FOUND_ROWS wp_users.ID,post_count FROM wp_users RIGHT JOIN (SELECT post_author, COUNT(*) as post_count FROM wp_posts WHERE ( ( post_type="custom-post-type" AND ( post_status="publish"  ) ) ) GROUP BY post_author) p ON (wp_users.ID = p.post_author) WHERE 1=1 ORDER BY post_count DESC";

$result = $wpdb->get_results($sql,OBJECT);
print_r($result);

Related Posts:

  1. Sorting a list of posts displayed under a list of associated terms (which should be sorted without initial articles)
  2. Including metaboxes from custom post types in global search — continued
  3. A faster way to query custom post types with multiple conditions?
  4. WP_query has incorrect wp_posts.post_name = ‘asc’ when I have custom post type called ‘order’
  5. Custom post order when using OR relation
  6. This wp_query will not return any posts and only seems to work with post_status inherit?
  7. convert custom query to wp_query
  8. Wrong request query on cpt and tax
  9. How to Mass Delete Images from Media Library
  10. Previous/Next Link by Meta Value in CPT
  11. Show custom post type filtered by category
  12. Randomize Posts. Skip the first post in ascending order
  13. Creating a navigation menu of all posts of a custom post type and their children posts?
  14. Get custom taxonomies from multiple posts
  15. Pagination for Custom Taxonomy Page [duplicate]
  16. Filtering WP_Query
  17. Search / Filter posts on Title/Content OR Tags
  18. Pagination on with query_posts in custom post type template
  19. Wp_query: sort by PHP variable
  20. WP_Query most viewed posts, in multiple Post Types, last 30 days, excluding a specific taxonomy term
  21. Custom-Posttype & Custom Taxonomy WP_Query
  22. Crafting WP_Query array, sort by date
  23. Custom loop with multiple taxonomy queries
  24. Return one unique custom post type result when it shares a custom taxonomy in WP_QUERY?
  25. Converting the_content string to an array?
  26. forming WP_Query for posts of all post types but from specific categories
  27. Get latest 3 posts from multiple CPT in one query
  28. Loop to fetch 3 post_thumbnail instances from 3 most recent custom post types named “portfolio”
  29. Display upcoming Events for next 7 Days
  30. Isotope Filtering with Bootstrap Tabs – Custom Post Type Query Loop in each Tab (Have to click twice to filter)
  31. Custom post ui plugin & WP_Query – Polylang
  32. How can I get the number of custom post type posts that have a specific attachment image set?
  33. How to use load more custom post type data normal or according to on click category tab In WP
  34. orderby rand is not working for a custom post types
  35. Problem querying Custom post type by custom fields
  36. Orderby CPT custom fields not working
  37. Custom taxonomy rewrite give pagination 404
  38. WP_Query order by custom field, then randomly order some of results
  39. WP_Query inside foreach loop returning same value for all options when filtered using ajax
  40. Mixing 2 custom post types with posts output in specific pattern
  41. Custom post taxonomies as tax_query terms?
  42. creat filter with wp_query
  43. Troubles with acf/save_post and WP_Query
  44. A method for ordering mixed dates in search result loop (theory only, no actual code)
  45. Query custom post type with ACF Date
  46. How to do WP_Query with two meta fields with orderby clause
  47. Stuck in Order by more then one
  48. Display featured image from one CPT within another CPT query
  49. Custom WP Query on custom meta and sort by multiple meta keys value
  50. Show only one post on custom post type archive
  51. Woocommerce search pagination not working
  52. How to order WP_Query by parent for hierarchical Custom Post Type?
  53. WordPress loop: Show only a Custom Post Type Taxononmy TERM
  54. How can I made custom taxonomies relationship?
  55. Query Multiple Custom Posts by Custom Fields
  56. What’s the WP way to load remaining custom posts?
  57. Why is this query not working? (Standard posts + custom post type)
  58. How do you paginate a query grouped by month?
  59. Custom taxonomies relationship
  60. Get Posts by multiple custom fields is not working
  61. Custom post type ‘articles’ ignores posts_per_page, reserved post_type?
  62. Several post types on WP Query by tag and taxonomy
  63. WP Query with categories only shows one post and ignores the category
  64. Polylang non-default language ignores tags in WP_Query
  65. WordPress request fiter order by related post’s post_title
  66. Custom Widget WP_Query problem
  67. Custom query at top of archive search page, arguments are overridden
  68. Order Custom Post Type by Custom Field Value
  69. WP_Query custom post type query not showing the exact post type
  70. How to display post list inside post
  71. Pagination issue on category.php using custom post type query
  72. How to have this permalink structure: post_type/postname/custom_inner_page
  73. Problem: wp_query outputs all images on site
  74. Query Custom Post Type Taxonomy term with multiple parameters
  75. Sort entries by date mixing two post types
  76. Why is my category template ignoring post type?
  77. First custom field value (out of several) displayed twice after query
  78. wp_reset_postdata() and wp_reset_query() inside shortcode are not working to reset original page query
  79. Prioritize posts in query by meta keys?
  80. Change sort order when using ‘orderby’ => ‘type’
  81. Order a custom post type admin screen by a second custom post type title
  82. Add Custom Post Type of specific Custom Taxonomy to regularly blog loop
  83. How to get all tags of a custom post type by id
  84. Filter Posts from the Main Query
  85. WP_Query orderby and tax_query
  86. Configuring a meta query with multiple post types that have the same relationship on a single page
  87. Different Ways to Query Custom Post Types?
  88. Order posts by 2 custom fields and if one custom field is zero orderby another custom field
  89. Pagination with custom query, custom search form, single and pages, ajax and no plugins
  90. Possible to filter custom post type with multiple meta data?
  91. can these 3 queries be re-written as 1 query?
  92. Advanced search form with filters for custom taxonomies
  93. How does order=asc effect a wp_query (its acting pretty weird in a loop)
  94. custom post type search by reference id
  95. pagination not working for category.php (custom post types in categories)
  96. Query based on custom fields start and end date
  97. Why is my WP_Query outputting my entries twice?
  98. How to display Related Posts based on number of taxonomy terms matched
  99. Retrieve custom post types by custom taxonomies with WP_Query
  100. Showing specific post in order of array wp_query
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)