Find most recent authors

Use a custom SQL query to grab the latest 16 post IDs with unique authors;

$post_IDs = $wpdb->get_col( "SELECT ID FROM $wpdb->posts WHERE post_type="product" AND post_status="publish" GROUP BY post_author ORDER BY post_date DESC LIMIT 16" );

Then start up a new query with the post__in argument;

$recent_posts = new WP_Query( array( 'post__in' => $post_IDs, 'post_type' => 'product' ) );

Related Posts:

  1. How to show list of posts by author and category?
  2. Get the author of the latest revision
  3. Change all author links in Blog roll
  4. List of authors posts minus very latest
  5. show latest authors blog post
  6. Getting posts from multiple users?
  7. Query *only* sticky posts
  8. This AJAX Code Doesn’t Work – Looking for elegant solution
  9. Cannot access current post’s ID in custom plugin
  10. Filter posts by author and category simultaneously
  11. Show a list of recently viewed posts to a user
  12. How to use alternate post layout at key points in post loop?
  13. Showing random content / pictures from earlier posts in a sticky post?
  14. Differentiate between posts and pages in search results
  15. Related posts loop based on tags AND categories doesn’t work without at least one tag assigned
  16. Loop through all product posts?
  17. Display post category in foreach loop with category link
  18. How To Get Posts With A Specific Word
  19. How to display posts on a static page? (like search loop)
  20. Why WP_Query(‘showposts=5’) shows only 1 post?
  21. Displaying Latest Posts on a Page
  22. Display all posts that were published before full post on single.php
  23. problems with loading posts in a table-row
  24. Blog page pagination is not working after using the offset argument
  25. WP Query – Posts Per Page not working in combination with category__in
  26. Show posts by a custom post author
  27. More then one menu items are assigned with “current-menu-item” class
  28. How to add tags (custom taxonomy) to post class css?
  29. List authors with the last post title and order by last post date
  30. Listing Specific Categories from Current Post with Depth
  31. “Right Way” to make custom Loop respect reading settings inside admin panel?
  32. Only display sticky post or latest post in custom loop
  33. get_the_category listing in hierarchial order
  34. Display Notification Bar on Header on Certain Post Count
  35. Exclude current custom post on single post
  36. why does wordpress ignore the post args?
  37. obtain the author id given the post id
  38. Loop doesn’t show title of second post and posts thereafter
  39. Grid post page on WordPress with Bootstrap, the_excerpt(); Problem
  40. Loop parent terms {display posts} AND loop child terms {display posts}
  41. How to add add more properties to WP_Post object in search results loop
  42. Custom taxonomy archive page problem
  43. Loop don’t work within single.php page
  44. static landing page leading to author specific pages w/ “live” content
  45. All Posts Linking to Author Posts directly
  46. How to show all posts by author on buddypress profile with navigation
  47. Getting blog pagination to work on page set as front page
  48. Make loop inside slider divisible [closed]
  49. How to add automatically bootstrap 4 order-lg-1 and order-lg-2 classes for columns in foreach loop based on the count?
  50. Echo Text If User Is Logged in But NOT the Author of post
  51. Only allow posts with a specific term to only be viewed by other authors with the same term in their post
  52. How to limit author related post listing ?
  53. separate the post of a category by subcategory
  54. How to display post list in a table layout (multiple queries in single loop)
  55. Not all posts showing in query
  56. Optimize CPT-function with a loop
  57. Get latest author posts inside the loop
  58. Limiting the amount of posts retrieved by the loop
  59. Display 3 posts with different HTML markup using a loop
  60. Changing wp_link_pages() to “Next Page” and “Previous Page” buttons?
  61. Authors’ Links on Homepage Not Going to Author Post Pages
  62. How to repeat a loop after 4 posts [duplicate]
  63. adding my posts (author posts) in menu
  64. How to separate each individual blog post?
  65. Error while excluding a post from another loop (using its ID)
  66. Is there a way to define the $post var outside the loop?
  67. Only the most recent post is showing on my category page (working on localhost, not live site)
  68. Change of author not updating
  69. Limit Post Creation Count by Author or Role
  70. show loop id post , only first id can read
  71. Can I Paginate Post after every 25 tag?
  72. Alternative content between posts no repetition
  73. Start loop from specific post ID
  74. Display new posts categories in separated divs
  75. Wp_query loop is not working as it should
  76. Maximum number of posts per page before affecting performance?
  77. Display post order ranking within wordpress loop
  78. Custom author search
  79. Problem with wp_insert_post()
  80. How to control Post view count incresing in sidebar widget posts too?
  81. WordPress loop uses unmodified posts array, why?
  82. Add row after three columns
  83. Modify WordPress loop after it has been run
  84. Skip posts, but keep posts per page
  85. Multiple Post Repeat for Related Post Loop by Category
  86. index.php is only displaying current month’s posts?
  87. Loop doesn’t display posts. It displays a link to the home page instead
  88. Grab next post title in archive page
  89. Where should get_post_meta() go to get $post->ID get_post_meta() is empty and $post->ID & get_the_id() are working
  90. Show post if in category
  91. Display the current post author and his url in the post header
  92. Displaying categories items among posts
  93. Show last post of employee in his profile page
  94. Show all posts in category
  95. how to show all type of author posts in author page (SOLVED)
  96. How to show total view count across all posts for an author
  97. First post in loop displays twice
  98. Wrap every 2 posts
  99. Add author section on Author archive posts
  100. What function does the loop of displaying posts?

Leave a Comment