Exclude Authors based off date of last post

So far as I know there is no ‘last posted on’ value saved for a user. You can find that information by referencing the post_date in the *_posts table against the author data in *_users and *_usermeta. With that in mind I can think of several solutions.

First Solution:

  1. Pull your authors. You need this later.
  2. Pull all of your published posts.
  3. Loop through the posts sorting things by author and keeping track of the most recent post_date for each author.
  4. You can then loop through the sorted posts and print them out.

Here are the problems:

  1. You are pulling all of your published posts. This could potentially be a very heavy, slow page, and could even time out or run out of memory. The upside is that your existing code pulls all of your published posts as well but does so with a lot more database queries, which is usually but not always worse than one big query.
  2. You have to loop through all of your posts in order to sort them and then loop through again to print them. Again, heavy, slow, and may have execution timeout or memory problems. Again, you are more or less forced into this if you want to do what you are trying to do.

Second Solution:

Another solution would be to run a query to pull the latest post for each user ID, use that to sort the author data, then use your existing code to print them. I believe you will need to write the SQL for that query. I don’t think there is anything built in to do it. It may not have as many memory problems as the first solution but it is adding a query to the several queries you already have.

Third solution:

Still another solution would be to be to loop through your posts and add a ‘last posted’ value to *_usermeta for each author. You’d have to update this whenever a post date is changed or a post published. You could then use the meta parameters of get_users to sort on that ‘last posted’ field. This is more efficient than the immediately preceding solution but is more complicated. It still requires several trips to the database.

As you can imagine, there is a fair chunk of code, and debugging time, to any of these solutions. Apologies for not providing it. I don’t think I could get it right without actually implementing the several solutions and debugging them.

Maybe an alternative:

Another thing you might consider is doing your server, and your visitors, a favor by not printing posts for all authors on the same page, since that really works out to printing all published posts on the same page plus sorting overhead. For example, print an author ‘index’ page sorted by last post date if you want, with a link to an author detail page that has the posts on it (which is fact is very similar to what happens by default– authors show up at “/author/author-name”).

Also, you shouldn’t be using query_posts. It clobbers the main query. Use get_posts instead.

Related Posts:

  1. Display all authors and their only one latest post
  2. Display Authors in a grid loop
  3. How to get Author ID outside the loop
  4. Get List of all the Authors
  5. Next Posts Prev Posts for Standard post format only
  6. Cannot retieve the_content() and the_author() – both returning empty strings
  7. Get author_id in wordpress
  8. Display Post Author Link above the loop
  9. How can I display other user avatars on an author profile page?
  10. Exclude page from loop results
  11. Can’t grab author info outside of the loop
  12. Exclude category from get_the_category
  13. Saving return value from the_author_posts_link()
  14. Display more than 10 posts on author.php file
  15. How to add a byline to all the pages?
  16. Exclude current post ID from loop in sidepbar.php
  17. List ALL posts by author on author archive
  18. Only Show Excerpt After First 3 Posts
  19. Displaying posts limit: can’t get pagination to display [duplicate]
  20. Exclude Author by ID
  21. How to show list of posts by author and category?
  22. Get date of last update outside of loop
  23. How do I get the attributes of a short code from a post?
  24. WordPress category & taxonomy loop with pagination
  25. Changing behavior of the loop twice in one page
  26. “Blog pages show at most” in The Loop
  27. wp_insert_posts Fatal error: Maximum function nesting level of ‘100’ reached, aborting!
  28. Post Loop not Returning Permalink
  29. Displaying child page content of a certain parent
  30. Pagination adding extra posts only on page 2
  31. If Loop has odd number of posts on last page Custom style for last post in it
  32. How can I use get_permalink() outside the loop?
  33. Content/Excerpt length control for a specific loop?
  34. Two loops by pre_get_post on same page
  35. How to check for specific content in comments in the loop
  36. Why we use if with while loop?
  37. Problem the_permalink
  38. Loop repeating design pattern
  39. Sort Posts By Category?
  40. Can’t access login screen, wp-login.php 404’s
  41. Create static front-page with 3-5 recent posts
  42. Why is my loop not dynamically grabbing the correct Category and displaying all categorized posts?
  43. Query posts if meta key starts with
  44. 3 Posts in Loop, Show Stickies First
  45. Loop within a loop (Again) for template
  46. How to use current_post to open a new unordered list every five posts
  47. Rating system and changing the loop
  48. Pagination for multiple loops
  49. Ajax Button to load more Posts into a timeline
  50. How to target thumbnails of the first post in the loop
  51. Infinite Scroll on a loop?
  52. Problem getting current post tags to show in a widget
  53. Include multiple page ids in loop
  54. “Call to a member function have_posts() on array” error on have_posts();
  55. How to exclude or filter password protected posts when using next_post_link() previous_post_link
  56. For each loop on every word in post
  57. Display name of taxonomy once
  58. Displaying the first, second, and third posts from a category in separate slides
  59. Get the image src and href data from posts
  60. Call wp-blog-header.php header without performing a wp_query
  61. Display post formats differently on index.php (loop in function)
  62. How to output thumbnail twice in a loop
  63. Frontpage pagination by week
  64. Integrating WordPress with Your Website
  65. Multiple instances of Featured Image Thumbnail As A Background On Homepage
  66. Accessing the Posts page Content
  67. how to run loop in function.php that sends email based on specific conditions?
  68. How to use this $tax_selection variable in this custom loop?
  69. Display all categories as plain text
  70. Query post & loop problem.
  71. How do i create a loop that list and divide posts into months?
  72. Forcing page to top of the list when using get_pages
  73. How to display fields from the loop in two separate divs
  74. get_page_by_title not working inside fucntions.php
  75. How to use single.php output in function.php
  76. Duplicate posts on archive page
  77. Get gallery in loop through ajax
  78. Pagination on a underscore custom theme
  79. Build a Page which shows the Oldest Post with specific Custom Field Value
  80. WordPress multiple loops with default pagination
  81. Loop random posts and display odd and even based on two alternating meta values?
  82. Get top Page IDs from menu and cycle through their child pages on a scroller
  83. How to manually define the primary loop
  84. Url outside the loop
  85. How to filter get previous post function by meta value DESC and post date DESC?
  86. Style first 3 posts differently and use a 2nd loop to get rest of posts / offset and pagination broken
  87. Posts Per Page is Not Returning Correct Number
  88. Echo Most Recent Sticky Post in Loop?
  89. WordPress Tags in class
  90. Set loop format & have a loop inside other one
  91. Need a conditional to test if title of parent page matches title of child page
  92. Query counting excluded category on paged loop
  93. The Loop isn’t working
  94. Why is my pagination showing up?
  95. the loop – how to control whether wp or plug-in runs it
  96. Having issue with WordPress loop
  97. How to implement template file and the loop
  98. Show only posts from todays date [duplicate]
  99. Why did my most recent article fall behind an older one on my site?
  100. I make sticky post for my archive page for custom post type with ACF field and loop is not working
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)