How to list commenters and days since last commented

It looks like you could add the 

MAX( comment_date ) last_commented_date

to the field list to get the latest date, each user commented.

Then use e.g. the human_time_diff() function to get a human readable text for how long ago each user commented.

human_time_diff( strtotime( $result->last_commented_date) )

For safety reasons, you should then prepare the SQL statement with $wpdb->prepare(), since it contains the user input $amount.

Related Posts:

  1. Pre_get_comments and orderby comment_karma
  2. Query multiple custom post types in single loop
  3. The correct method to pass query vars in AJAX using ajaxurl
  4. How to search display_name column when using WP_User_Query
  5. Using WP_Query – how to display something IF there are no results
  6. Display user’s total comment count outside The Loop
  7. Facebook Comment Count
  8. How to order posts by modified date without using ‘query_posts’?
  9. Delete post revisions on post publish
  10. How to get user by display_name with WP_User_Query
  11. How to sort results from a custom database table
  12. Specific Loop For 2 Within Each
  13. How do I create comment-reply-button using element not
  14. How to check if comments are paginated?
  15. WP database error for comments_popup_link()
  16. How to add a post or page tag to the list of classes appearing in the body tag’s class attribute?
  17. Use two WP Query in template
  18. Uncaught TypeError: Cannot read property ‘firstChild’ of null after upgrading to WordPress 5.5
  19. Automatically generate Post/Page from searched Database item?
  20. Get ID of child from child slug, while knowing parent ID
  21. List User order by ID in Descending order (Backend)
  22. WordPress – query 5 posts with a specific post in top
  23. Why is variable not working on custom sql query using wpdb?
  24. How to get a list of all possible values of a specific user meta key?
  25. How does this WordPress Plugin (Thrive Comments) apply their custom comment sort? [closed]
  26. Show comments menu in dashboard only if the site has comment
  27. Custom filter in admin edit custom post type responding with invalid post type?
  28. Accessing the database from a plugin outside of action hooks
  29. Create WP_Query to search for posts by their categories or their parent/child categories
  30. ACF: how do I get the fields and its values of a specific group?
  31. Set WP_query ‘order’ option by another tables value
  32. WordPress default Search function inconsistent in WooCommerce Product Titles
  33. Increase offset while looping
  34. Two queries for a WP_User_Query search work perfectly apart, but not together
  35. edit_comment_link is not showing for comment author
  36. Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
  37. Genesis framework comments broken?
  38. WordPress SQL injection
  39. Which is the correct way to conditionally enqueue a CSS file?
  40. unable to use ‘new WP_Query’ in AJAX call
  41. Parse error: syntax error, unexpected ‘}’ on get_the_author_meta [closed]
  42. How to add text to the start of all comments?
  43. How to overwrite orderby with add_query_var
  44. Can’t update multiple rows with $wpdb query
  45. Appended comments but they show up above the content instead of below
  46. get comment data using comment id
  47. wp_delete_comment takes two tries to delete – then deletes all comments
  48. Change “No Comments” link to “My String” on Blog Post (Find Snippet in Code or use CSS, PHP Solution) [closed]
  49. How to display SQL query that ran in WC_Order_Query?
  50. Custom Post type slider with thumbnail navigation
  51. get_comments_number() returns 0
  52. WordPress PHP syntax doesn’t seem to be working correctly
  53. Querying for specific tags
  54. Limit tags shown in post
  55. Why my query does not run with prepare
  56. How to get comment_ID by post_ID in wordpress
  57. List of Events with Multiple Dates: Only NEXT Date
  58. Undefined variable: row?
  59. WordPress Custom Query: Combining Two Functions
  60. WordPress is removing query variables like page, p from the URL of a custom static page
  61. Reject all malicious URL requests functions.php
  62. Build A Custom SQL Query for WordPress Search
  63. comment_post (if comment is approved OR $comment_approved === 1) not working?
  64. WordPress Custom Form – Getting Query Vars, Weird Glitch?
  65. Add custom field on admin dashboard comments / reviews
  66. Display articles with a different template in the home page | Solved |
  67. array wordpress when get is null
  68. Reading URL Parameters
  69. How to pass parameters in wordpress shortcode?
  70. Display the list of user’s comments + the post title + date
  71. Category Page Displaying all Pages
  72. Comments on my custom post type
  73. Why does a header location on admin_head remove the query var I’m setting in the location?
  74. Offset with ajax load more posts duplicates
  75. wordpress query returning unexpected results
  76. How to add delete, approve, spam Links to Comments
  77. Real time notification on user profile after new comment
  78. How to do a MySql query in WordPress?
  79. What’s the correct offset value for order ASC?
  80. Pagination in WP Queries
  81. How can I display a query in a page?
  82. Getting most popular posts based on Facebook comments count
  83. A Space being added to url generated by custom plugin
  84. “Where… like” query not working as expected
  85. Unserializeing multiple column values that are stored in one database results variable
  86. Problems With Query and/or Template Part and/or PHP
  87. If Elseif Query
  88. How to callback custom field text
  89. How can I add more code to this?
  90. Does wp_query and query_posts affect website performance? [duplicate]
  91. How to get the rating value of each comment
  92. Trouble figuring out how to get my button to submit comment
  93. How to insert a variable into a query parameter?
  94. How to convert my comment.html to comment.php
  95. WP_Query not returning results
  96. Guests comment form – prevent duplicate email addresses
  97. Permissions error when I use my plugin to delete comments in the front-end
  98. Custom Filtering date with newsletter
  99. Display featured posts first, then display all others within a specific category in WordPress
  100. How to allow searching a custom meta key in admin list table?