Date of last blog update for specific authors only?

Ok, Paul, So I took a few minutes to figure this out (assuming this is where you’re going with this):

Here’s the MySQL query that will give you the latest post date, one user at a time: 

SELECT post_date FROM wp_posts WHERE post_author = 1066 ORDER BY post_date DESC LIMIT 1

(The number “1066” is arbitrary and represents a specific User ID on the table that I was testing this. So you would replace this with a given user ID for the user that you want to determine their latest post submission. )

So this simple bit of MySQL you would use in a database manager (like PHPmyAdmin) on the SQL command screen. A better solution would be to create an admin page that you can access from the WordPress Admin that can then list all your users and their latest contributions side-by-side. But that query is the heart of what you’re after, I think.

Related Posts:

  1. How can I fetch loop of post titles via AJAX?
  2. get product attributes for current product and store it in a variable
  3. How to add active class to custom menu using while loop and wp_list_pages
  4. MySQL query performed 4 times inside loop
  5. Print html when custom field has value inside while loop
  6. Post from one loop in different containers?
  7. Custom Loop Pagination on WordPress
  8. Infinite-Scroll Plugin and Jetpack Infinite Scroll Plugin – Adding to “Thoughts” Theme
  9. User Defined order on get_categories?
  10. Custom Loop through category menu to include sub categories
  11. How do I display the function the_content in this loop?
  12. Must Use Plugin Causing Query Error
  13. How to get to a specific position in wp_query?
  14. Advanced Custom Fields: Post Object – Not returning data [closed]
  15. Facebook “like” open graph meta in header.php
  16. Custom excerpt function re-factoring
  17. How can I show the post thumbnail from the most recent of a certain post type, in widget?
  18. How can I add multiple ‘tax_query’ arrays via a loop?
  19. ACF page while loop breaks footer while loop
  20. Using foreach loop breaks
  21. Split loop into two columns, how to favor one side over the other
  22. Dynamic Stylesheet loads but doesn’t finish
  23. Filter Select results based on selection
  24. Loop with slider (slider not loading)
  25. How to hide all child pages with post_query?
  26. How to sort posts based on the value (number) of a post’s metadata?
  27. Displaying Woocommerce Product Category in WordPress
  28. How can I add extra word in permalink when someone click download button?
  29. Increase offset while looping
  30. Woocommerce : Can’t get product info in loop
  31. remove post that has no content
  32. post thumbnail, conditions, else wont work
  33. Widgets in the loop if active
  34. I’m trying to create an array with a foreach loop, but the array only stores the last item [closed]
  35. PHP Warning: strip_tags() expects parameter 1 to be string?
  36. How to avoid duplicates when creating recent network posts
  37. Why in my theme I can’t see all the statics content under the posts?
  38. variable value disappears in a second loop
  39. How to unlink all posts from tracking same amount of views
  40. Why my loop isn’t working? [closed]
  41. Get all posts as an array ID => Name
  42. How to get post ID from button and pass title to Modal
  43. Problem with custom loop and wp_list_pluck [closed]
  44. Display child page content of a specific parent on home page
  45. Do not duplicate posts with multiple categories in multiple loops
  46. Infinite Loop – WP_Query
  47. How to wrap every 3 posts in a div (and close the last div too) [closed]
  48. Dividing the loop to style post differently
  49. WordPress loop is not working
  50. First post article different on Archives template
  51. How to add title attribute to archive items
  52. Strip from or something better?
  53. Problem in replacing the_content with the_excerpt()
  54. Search AJAX Filters – Multiple Query Loops Into One Loop (Optimization)
  55. Pagination contents not changing in Front page WordPress
  56. in_array not working on dev server but works on localhost
  57. How to Create Carousel Indicators in PHP Loop using wp_get_attachment_url function?
  58. Get title of page containing post grid within the posts
  59. Is there anyway I can call the year once?
  60. Display all categories including sub categories under a list ul
  61. Foreach Loop Of Post Types With Nested If Else If Not Completing Process
  62. Where does php code to load data go?
  63. Adding new divs with custom classes to products on WooCommerce shop page [closed]
  64. cURL needing to loop through all “next_page”
  65. Display page content in different sections – based on page break block?
  66. Filtering custom posts by using checkboxes for taxonomy in an ajax loop always gives server 500 error
  67. Latest posts feed with a specific post always first
  68. Show the subcategory name based on current product
  69. How can I get my pagination loop to display the correct number of total pages?
  70. Making list of posts with chosen description
  71. How fix error in the WordPress loop?
  72. what’s the syntax for if the image exists get the image?
  73. how to remove replicating a tag inside loop?
  74. My query keeps looping infinitely ! how to stop it?
  75. Efficient way of querying for a “fallback” post?
  76. Retrieving specific images from Media Library
  77. Loop 1 user randomly
  78. Create a hierarchical loop at predefined markup requirements
  79. enumerating custom taxonomies?
  80. Custom Taxonomy Link Text Echo Name Not Slug
  81. Adding unique marketing messages between certain products whilst using isotope/Infinite Scroll
  82. Problems With Query and/or Template Part and/or PHP
  83. Two loops in one function
  84. How to display thumbnail if post is assigned one otherwise not
  85. Pagenav Not appearing on custom Template
  86. Error trying import one category on page
  87. Remove the_content From Loop
  88. Adding if statement to content for homepage
  89. Tables not showing divs and loop/php items
  90. Pagination in category.php not functioning
  91. Implement “No related posts for this entry” into the loop?
  92. For each loop will not append to the_content hook
  93. How to handle parent and child pages?
  94. How do I remove blog entries from home page Twenty Eleven child theme?
  95. How to create a loop that will display one post and stop?
  96. Pagination not working properly
  97. How do I exclude the current post from the upcoming post query
  98. When a foreach loop is used multiple times in blocks, is there a way to ensure a variable always has a unique value?
  99. Custom theme on multisite has issues with standard loop output
  100. How to get the post title inside a custom block in a loop? block.js