Using DISTINCT in wp_query

I haven’t tried it myself, but that sounds like something for the posts_distinct or posts_groupby filters:

function search_distinct() {
    return "DISTINCT";
}
add_filter('posts_distinct', 'search_distinct');

Related Posts:

  1. Query all posts where a meta key does not exist
  2. Exclude a category from WP_Query
  3. Single loop for wp_query and wp_user_query
  4. WP_Query orderby custom field then post_date in one query
  5. query multiple taxonomies
  6. Custom Post Type, WP_Query and ‘orderby’
  7. Include post id[s] into WP_Query()
  8. Grab 5 latest posts from custom post type ‘announcements’
  9. Pagination Doesn’t Work
  10. Numeric pagination custom post type
  11. Using Query Posts With Multiple Post Types And A Taxonomy
  12. List with categories, subcategories and posts of custom posttype
  13. Sort the main query in subcategories/terms?
  14. Custom Taxonomy List links being re-written
  15. Can’t sort order of wp_query with 2 meta keys
  16. Get post info inside modal window?
  17. Want to filter only parent post in admin area
  18. Get count of custom post type created by current user
  19. Query Custom Post by Category
  20. Pagination Issue: Custom Post Type In Index
  21. Having trouble with custom date field for CPT query (WordPress)
  22. Quickest way to get last or oldest post date – WP Query
  23. WP_Query and using a variable for ‘cat’=> in the args array = WP Bug?
  24. Custom post query by taxonomy
  25. Separate Posts and Custom Post Type in Custom Taxonomy archive template
  26. CPT posts listed by category with custom rewrite URL, please help!
  27. How to use WP_Query in a CPT achive page?
  28. Use get_post_types to query only custom posts types
  29. Group custom posts by custom taxonomy names
  30. How can i skip same post from taxonomy term?
  31. Setting proper query for multiple custom admin filters
  32. Returning a list of custom post types excluding those without a specific meta_value
  33. query private custom post type
  34. Query custom post type with tags
  35. Randomize Posts. Skip the first post in ascending order
  36. Pagination for Custom Taxonomy Page [duplicate]
  37. Isotope Filtering with Bootstrap Tabs – Custom Post Type Query Loop in each Tab (Have to click twice to filter)
  38. Custom taxonomy rewrite give pagination 404
  39. WP_Query order by custom field, then randomly order some of results
  40. Get Posts by multiple custom fields is not working
  41. How to display post list inside post
  42. How to have this permalink structure: post_type/postname/custom_inner_page
  43. Sort entries by date mixing two post types
  44. Advanced search form with filters for custom taxonomies
  45. custom post type search by reference id
  46. Showing specific post in order of array wp_query
  47. WP the_posts() on single-cars.php get category link
  48. tax_query not working in template
  49. Custom Taxonomy Not Showing in Front-End When Outputting a Custom Post Type with WP_Query()
  50. Print current post category during WP_Query
  51. Multiple Custom Post Type queries, how to DRY it up
  52. Custom WP_Query always respond with 200 status even when no entry
  53. WPDB for post count on post
  54. post_per_page ignored in WP_Query
  55. Pagination 404 on Index with custom query
  56. WP_Query parameter conflict
  57. Retrieving meta-box from a custom-post-type
  58. How to include category name/id in wp_query for retrieving “custom post type” from a particular category?
  59. Cannot get custom post
  60. Custom post type and standard post not displaying or working
  61. Display custom post type for specific user
  62. Get all post from a post type
  63. Trying to add a class to post links
  64. A faster way to query custom post types with multiple conditions?
  65. Custom Post Type Archive Pagination
  66. List all Custom Post Type posts excluding certain Taxnomy term
  67. WP_Query: Posts within category OR custom post type
  68. Two queries – one with checkbox ticked, one without – comparing meta_query
  69. Custom post type pagination error
  70. WP query_posts group by meta field related
  71. WP Query from two Custom Post type fields as statement
  72. Apply category query clause to posts of custom type
  73. custom post type and a “sticky” position taxonomy
  74. Display post count for a specific month
  75. Query to Exclude Child Pages from Custom Post Type Archive
  76. WP_query has incorrect wp_posts.post_name = ‘asc’ when I have custom post type called ‘order’
  77. Randomizing WordPress Custom Post Type Sorting Through Them Without Page Refresh
  78. Order posts alphabetically with numbers but some of the posts has numbers in the title
  79. How to output custom post type title on custom page with category next to it?
  80. How to sort by multiple values in a nested WP_Query
  81. WP_Query to display number of custom post type filtered (order by) taxonomy
  82. 2 modal windows with ACF content on Archive page
  83. Custom Post Type – Display all, wrap in groups of 3
  84. Staggering featured post using ‘sticky’
  85. Ajax load more inside custom post type taxonomy
  86. Create a custom wp_query from a specific custom post type with specific taxonomy
  87. SQL LIKE in WP_Query
  88. How can you use a page for a custom post type?
  89. Query breaking with ‘posts_per_page’ => -1
  90. WP Query with multiple post types ordered by custom meta date then published date
  91. Query Pulling the same post twice
  92. Values inside a custom field to determine which category posts to display
  93. WP_Query get posts where post_name is empty
  94. How do I sort post listing by child post count?
  95. Listing all custom post types using a specific term on the said term’s template page, in groups
  96. Querying meta values within an array
  97. Filter Custom post type by another Custom post type
  98. Archive page – problem with pagination
  99. Assign a tag to custom post type using a query
  100. Query order by a numeric ACF field
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)