Using meta_query on pre_get_posts to exclude a particular meta_key value

Yes, it behaves weird. No, shoot me, I can’t get a fix on precisely why and how (stacked joins are probably it).

I say flip it. The only posts you don’t want to see are those with true custom key. Query for their IDs separately, feed result into post__not_in, ditch this meta query entirely.

Related Posts:

  1. pre_get_posts and set
  2. WordPress Screwing Up ‘orderby’ => ‘meta_value_num’ in ‘pre_get_posts’
  3. Can I use pre_get_posts to add up values from two different meta_keys?
  4. meta_query Array
  5. Order resultset by configured value and then list all the rest
  6. WordPress meta query not working
  7. Why does this incorrect pre_get_posts meta_query work for sort order?
  8. How to do a meta query using REST-API in WordPress 4.7+?
  9. Get result from meta_query() between two numbers
  10. Query between two meta keys
  11. Archives for custom post type based on a “date” meta value
  12. get_users meta_query
  13. Meta query interfering with orderby relevance
  14. meta_query with multiple values
  15. Return posts with specific meta key first, but the rest in alpha order by last name
  16. meta_query key value from array
  17. filter search result with custom post type meta key
  18. Order by nested named meta queries with ‘exists’ and ‘not exists’
  19. Using get_terms() with meta_query parameters
  20. WP_User_Query with meta_query array relation ‘OR’
  21. Can’t sort order of wp_query with 2 meta keys
  22. meta_query problem
  23. Using meta_query and custom fields within pre_get_posts to return posts within a numerical range
  24. How to exlude posts that have certain meta_value?
  25. User Relationship
  26. meta_query results not the same with and without spaces
  27. WordPress Core – Optimizing meta_query generated SQL?
  28. Edit post_content on posts with Featured Image
  29. Display no post when metavalue is 0
  30. Wildcard with LIKE operator in Meta query
  31. meta_query, number comparison, not quite working as it should
  32. Meta Query Compare with Date
  33. Does meta_query working with value paramater higher then 999?
  34. Single meta_query query using OR instead of AND in request’s WHERE statement
  35. meta_query keys and sticky posts
  36. Custom post type archive with rand and meta_value
  37. Using meta_query with multiple keys and compare values
  38. Fastest way to do meta query when I don’t need the actual posts, and just need post_id?
  39. How to query post only with different excerpt?
  40. WP_Query with meta_query no results
  41. Order ascending is ignored in meta query?
  42. WP User Query Issues
  43. How to use meta query for greater than value in array?
  44. Wp Query custom search by meta query
  45. Filter posts by meta query?
  46. Meta query date column add [x] days to validate
  47. How to use orderby with meta_query?
  48. wordpress Meta_query between numbers range (not working)
  49. Orderby doesn’t work like expected on custom query
  50. I would like to have add_post_meta to return the ID instead of true or false
  51. Order by meta value
  52. Multiple meta_key ordering with pre_get_posts
  53. Sorting search results with custom dropdown
  54. Meta Query Based on Month Range
  55. Find posts by related taxonomy field
  56. wordpress meta value compare between two date
  57. Unpublish Authors With not Fulfilled Fields
  58. get_users with Serialized Custom Meta Value
  59. Sorting posts by ACF field
  60. Unable to use meta_query between currency values when value is over 1 million
  61. latitude/longitude meta_query
  62. meta_query displays all results and none, my query is wrong
  63. Delete all posts with a specific custom field using meta_query
  64. Use meta_query in args for relationship
  65. meta_query compare “=“ returns nothing when it seems it should
  66. Issue with user meta_query
  67. Woocommerce products search with custom fields
  68. How to get an archive page meta?
  69. Search for value(s) in meta field for a multi select
  70. How can I create a meta_query with an array of dates?
  71. How to count items of meta query?
  72. WordPress meta query with meta serialized data array value
  73. Reading Content in an Array as it relates to a meta_query
  74. wordpress meta query with multiple meta condition causing a load on server and slows down the server..!
  75. Trouble with calling an imploded variable in an array
  76. Memory Leak in Processing Large JSON file
  77. Exclude Posts Using Meta Query and User Meta
  78. meta_query not filering but meta_key works fine
  79. Query for user roles and their skills
  80. get posts meta query returning the latest post if no meta key found
  81. WordPress search between two newmeric values with a custom post type
  82. like_escape notice when using LIKE in meta query
  83. meta_query for user ID in array
  84. WP User Query with meta queries
  85. WP_Query with UNIX timestamp in meta query
  86. Querying by meta key and value
  87. How to compare date in post meta value
  88. Which Meta Query Compare Method Should I use?
  89. Sort posts by post views and consider meta key
  90. Sort posts in dashboard using custom field; also include posts where field isn’t set
  91. Meta query “OR” comparison not working as expected with array
  92. How to output meta_key in wp_postmeta?
  93. Looking for a way to exclude frontpage and nav menu from query filter
  94. WordPress Meta Query very slow with NOT EXISTS comparison
  95. ACF meta_query field treated as “0” resulting in false negative search when testing ranges
  96. Is it possible to customize meta query in this way?
  97. Ordering WP_Query results by second meta_key
  98. Custom taxonomy with custom meta value is not sorting correctly (query returns the same value for orderby regardless of sort column click)
  99. How making a new search box in admin post table working on a specific column
  100. wp_user_query with meta_value_num for leaderboard

Leave a Comment