Exclude Duplicate Posts in this SELECT Query

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. How do I comment out a block of tags in XML?
5. ORA-01843 not a valid month- Comparing Dates
6. ORA-01830: date format picture ends before converting entire input string / Select sum where date query
7. R: Comment out block of code
8. Why do I get comment spam even with Akismet and Captcha?
9. What tools are available for managing/writing to WordPress? [closed]
10. How to rearrange fields in comment_form()
11. setting comments off as default for pages and custom post types?
12. Is it possible to pull comments from facebook into your blog?
13. Filtering the Admin Comments List to Show Only Comments from the Current User?
14. Non-threaded comment replies with link to original comment
15. Approve comment hook?
16. Commenting in user profile page?
17. How to change “You must be logged in to post a comment.”
18. comment_post_ID 0 (cannot remove from dashboard)
19. Disable comments on all posts/pages
20. How do I delete all comments from a specific old blog post?
21. Removing the “Website” Field from Comments and Replies?
22. Stop WordPress redirecting comment-page-1 to the post page?
23. Importing old Disqus comments into WordPress
24. How to add a class to the comment submit button?
25. How to wrap submit button of comment form with div
26. How to enable comments for pending and draft posts?
27. Using WordPress’ WYSIWYG for comments
28. Enable Submit Comment Without Page Reload (Using Ajax)?
29. What for is the table “wp_commentmeta” exactly?
30. Getting Post Comments for post ID using WP_Query() and a Custom Loop?
31. Add option to disable comments on a per posts basis?
32. Resetting comment count
33. When importing – failed to import: Invalid post type feedback
34. How to change the email notification recipient (user) for new comments?
35. Redirect user to a custom url after submitting the comment
36. Paginate result set from $wpdb->get_results()
37. Change Comment Author Display Name
38. Would switching to InnoDB from MyISAM improve performance of comments table?
39. Custom comment type based on thread level
40. How to add internal, revision comments to page updates
41. How to load and show comments with AJAX instead of pagination?
42. Linking to Page Showing Only Comments Without Parent Post
43. Comment Reply javascript
44. How do we remove the H3 tag for the reply-title I.D
45. Comments not appearing at all
46. comments reply script not working
47. How to display comment form error messages in the same page
48. 3 moderators to approve comment
49. How to deal with small scale comment spam on small commercial sites? [closed]
50. What should I do to make generated avatars different for anonymous comments?
51. A plugin where users can comment with Facebook or Twitter or OpenID [closed]
52. Check If comment author is registered
53. Comments screen in backend, how to disable email address of commenter for non admins
54. Add comments from the admin panel?
55. How can I limit the number of comments per registered user per day?
56. One comment per user per post but be able to reply to existing comments
57. How to use a custom comments template
58. Comment visibility
59. What’s the easiest way to close comments on media/attachments?
60. Reverse comment pagination numbers
61. Get comments for more than one post
62. How can I add comments to a page?
63. How to remove comment spam in WordPress
64. Post Comments using WP REST API v2 in WordPress
65. show number of open comments on custom dashboard
66. Show content only if member left a comment
67. Add placeholder attribute to comment form fields
68. Why do I get accidental comments without (the required) email address?
69. How is comment spam received without a comments form?
70. Does a reply to a wordpress comment notify the author of the comment?
71. What are the current recommended best-practices for comments.php?
72. human_time_diff() returns “48 years ago” for all comments
73. How do I set up real anonymous posting in bbpress forums? [closed]
74. Comment Count for each Comment Author
75. Link name in comments to Author page? Comment Author Meta in Comments?
76. How do I turn off wordpress comments ability to capture a users ip address?
77. Showing comments only to same custom user role
78. Parent comment’s author name
79. Success message in comment form
80. get_comments_number of depth-1 (Level 1) (1 post)
81. Show comments from multiple post IDs in comment template
82. Running a function on comment status change
83. How to allow the reply link to remain on the comment form after I have reached my 10 nested comment limit?
84. How can I control the comment counts filtering my CPT replies?
85. Hook to edit an column on comments screen?
86. Allowing more elements in comments via functions.php
87. Set post comments open function
88. Comment Author Name In Reply Form
89. How to auto-approve internal pingbacks?
90. Deep customization of the comment form?
91. Post comment as different user than logged in
92. “Categories” for comments?
93. get recent comments of a particular category
94. Threaded comments – deleting parent comment leads to orphan comments
95. How to hide “Trackback” on paginated comments
96. Allow anonymous comments, but prevent spam [closed]
97. Where to remove from comment’s feed?
98. Hook/Filter before and after comments
99. Using filter to add additional fields to comment_form()
100. How to add editor-style.css styling to wp_editor on front end for comments