Exclude Duplicate Posts in this SELECT Query

Remove

DISTINCT

And add

GROUP BY $wpdb->posts.ID

before ‘ORDER BY’

Related Posts:

  1. Display commenter’s registration date on comments?
  2. In wp_list_comments comment dates won’t work?
  3. Display date and time into post edit comments section
  4. Disable comments on all posts/pages
  5. Stop WordPress redirecting comment-page-1 to the post page?
  6. Importing old Disqus comments into WordPress
  7. How to add a class to the comment submit button?
  8. Linking to Page Showing Only Comments Without Parent Post
  9. Comments screen in backend, how to disable email address of commenter for non admins
  10. How can I limit the number of comments per registered user per day?
  11. Post Comments using WP REST API v2 in WordPress
  12. Show content only if member left a comment
  13. Parent comment’s author name
  14. get_comments_number of depth-1 (Level 1) (1 post)
  15. How can I control the comment counts filtering my CPT replies?
  16. How to auto-approve internal pingbacks?
  17. Using filter to add additional fields to comment_form()
  18. Disable wordpress comments API
  19. List Recent Comments from Across a Multi-site Network
  20. Can I store my custom comment_type into wp_comments table?
  21. Number of External Links in Comments – Moderation Option
  22. What is comment_karma?
  23. How to override function twentyten_comment
  24. Comments screen in backend, how to disable Quick Edit | Edit | History | Spam | for non admins
  25. How To Remove The “Click here to cancel reply” Link From The WordPress Comment Form
  26. Get most active users sort by comment count
  27. Passing arguments to wp_list_comments callback function
  28. What are the additional fields in wp_comments used for?
  29. Enable Recent Comments widget to display comments on attachment posts
  30. Change allowed HTML tags for comments
  31. comments_template not working correcly in custom template files
  32. How can I highlight admin comments?
  33. On WordPress 4.4, how to get the post id using the comment_post hook
  34. Block comments from search engine indexing
  35. How to change style of Disqus comment count on main page
  36. Adding another arg to comments_popup_link
  37. Show last n comments
  38. Threaded commenting: how to show threads by last active first?
  39. edit_comment capability for subscriber
  40. How to add attributes to the comment form tag?
  41. How to add replyToUrl schema.org to WordPress comments?
  42. oEmbed does not work for comments
  43. Get comments from post and sort by commentmeta value
  44. Yoast makes comment_reply_link function output plain link to comment instead of reply link
  45. Problems with comments callback (Argument #1 is not an array?)
  46. Can WordPress comments have titles and taxonomy?
  47. Same email for all comments
  48. Comments system doesn’t like International domains
  49. Comments on homepage (index.php) are duplicated under posts
  50. Email notification to an email address other than admin for custom type post comments in wordpress
  51. How do I reply to comments from admin panel on a tablet PC?
  52. Disable comments for a user? [closed]
  53. Polls with respective comments?
  54. Why does akismet prevent jetpack comments from appearing in my moderation queue? [closed]
  55. Filtering the Admin Comments List to Show Only Comments from the Current User?
  56. Comment Link from get_comments()?
  57. if null or int(0) value to 0
  58. Problem with WordPress Comment
  59. Only show own comments in admin panel
  60. Where are comment ratings stored?
  61. Comments change the template name
  62. I can’t post comment via REST API
  63. how to SELECT for the current post id?
  64. WordPress scruity issue – Totally disable all comments by CSS — secure enough?
  65. Sending comment notifications to different recipients depending on taxonomy terms
  66. wp_new_comment requires author url and author email
  67. How to display the user’s comment status on the front end
  68. get_comments_number() vs. get_post_field( ‘comment_count’, ID )
  69. Where are comments coded when using custom theme?
  70. What is the point of get_comment_count() if you cannot limit by a comment type?
  71. Wrong IP address in comment section
  72. Comments turned off, but ‘Leave a reply’ link still there [duplicate]
  73. How to output number of comments with link to comments
  74. Highlight comments made by registered users of the site
  75. How do I make Twenty Ten display comments on the home page?
  76. It doesn’t matter if I have more than one comment. get_comments_number still equal to one?
  77. Sort post comments from newest to oldest in pagination
  78. Get all comments associated with a specific page ID (comment_post_ID)
  79. Update post “A” on comment submition on post “B”
  80. How do I add custom field to Admin comment form and display
  81. I would like to count number of comments after 5 days ago
  82. Using Disqus with headless WordPress setup?
  83. Attaching author tag to the comment
  84. Comments counter only for Authors Posts
  85. How to show a “Comments Are Closed” message on posts where comments have been closed?
  86. Necessary to have a comments.php if there are no comments?
  87. Comments pagination on author page
  88. Comments page id wp_list_comments
  89. Inserting comments via a procedure
  90. transition_comment_status gets called when untrashing comments
  91. Can I use WP comments for custom tables?
  92. How can I have a full comments.php for an easy editing of all its aspects?
  93. Transfer comments from one domain to another
  94. WordPress is adding above html
  95. Passing user meta through comment form
  96. How do I separate author avatars and comments in 3.4.2?
  97. How do I convert users who put an email and username for a comment into registered users? [duplicate]
  98. Display DISQUS on homepage
  99. How to stop a specific person to comment on my blog? [closed]
  100. Add ACF Quick Edit Columns on Comments