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. Admin products page column not sorting
  9. How to do a meta query using REST-API in WordPress 4.7+?
  10. Meta query terribly slow
  11. meta_query sorting by 2 keys
  12. Get result from meta_query() between two numbers
  13. How to handle optional end date in compare clause in meta_query
  14. Changing the meta_query of the main query based on custom query_vars and using pre_get_posts
  15. Query between two meta keys
  16. Archives for custom post type based on a “date” meta value
  17. How to check a single number value against an array of meta_key values?
  18. get_users meta_query
  19. Meta query with multiple logic (AND / OR)
  20. Best practice – Meta Query vs. post_clauses for “left join” ordering
  21. Meta query interfering with orderby relevance
  22. meta_query with multiple values
  23. Different page parameters inside query
  24. Return posts with specific meta key first, but the rest in alpha order by last name
  25. meta_query key value from array
  26. filter search result with custom post type meta key
  27. LIKE %…% Meta Query
  28. Multiple Values stored as array in Meta Query
  29. Meta Query “IN” doesn’t work with ACF checkbox filter
  30. Order by nested named meta queries with ‘exists’ and ‘not exists’
  31. Documentation for post meta
  32. Help With issue on pre_get_posts filter in taxonomy
  33. Advanced orderby with multiple meta_query
  34. Arrange Posts By Date In Order Of Closest To The Current Date
  35. Using get_terms() with meta_query parameters
  36. WP_User_Query with meta_query array relation ‘OR’
  37. Can’t sort order of wp_query with 2 meta keys
  38. pre_get_posts filter using numeric meta_query comparison (from dates)
  39. meta_query problem
  40. Custom Upcoming Events List for Events Manager Plugin
  41. Very slow query with meta_query on large database
  42. How to use meta_query to check if a meta field has something set?
  43. Using meta_query and custom fields within pre_get_posts to return posts within a numerical range
  44. Comparing arrays with meta_query in pre_get_posts
  45. pre_get_posts and search query for admin
  46. Using database meta_values to calculate new post order using pre_get_posts or a ‘request’ hook
  47. How to exlude posts that have certain meta_value?
  48. User Relationship
  49. meta_query results not the same with and without spaces
  50. meta_query all posts between to ages
  51. How to make a WP REST API query with meta_query in WP4.7?
  52. pre_get_posts filter meta_query without conflicting existing meta_query
  53. WordPress Core – Optimizing meta_query generated SQL?
  54. Edit post_content on posts with Featured Image
  55. Nested Queries using meta_query
  56. Display no post when metavalue is 0
  57. Use both meta query and tax query
  58. Wildcard with LIKE operator in Meta query
  59. meta_query, number comparison, not quite working as it should
  60. Meta Query Compare with Date
  61. Query posts only if meta_value is not empty
  62. pre_get_posts order by not working
  63. Does meta_query working with value paramater higher then 999?
  64. Single meta_query query using OR instead of AND in request’s WHERE statement
  65. meta_query keys and sticky posts
  66. How to pass user meta_key and meta_value (values as array)
  67. WP_Query ordered by meta_value_num doesn’t fetch posts without this meta field
  68. Query Multiple values for same key
  69. Custom post type archive with rand and meta_value
  70. Comparing a field with several values at once with meta_query
  71. Using meta_query with multiple keys and compare values
  72. Meta query with a sub query group possible?
  73. meta_query compare=’!=’ with multiple custom fields
  74. Query posts with numeric meta values within a given range
  75. Fastest way to do meta query when I don’t need the actual posts, and just need post_id?
  76. meta_query not working on live site
  77. How to query post only with different excerpt?
  78. How do you get Posts by multiple meta_keys and meta_values with the Rest API V2?
  79. Query custom field with date
  80. Meta query with regular expression does not work
  81. Searching in title or meta, with a tax query too!
  82. WP_Query with meta_query no results
  83. Documentation for post meta
  84. Exclude posts from main loop based on meta value
  85. Help ordering Post loop by two meta values
  86. Order ascending is ignored in meta query?
  87. WP User Query Issues
  88. How to use meta query for greater than value in array?
  89. Sanitize Custom Field Value in Meta Query
  90. Wp Query custom search by meta query
  91. Pre Get Posts / Multiple Meta Keys / Orderby Single Key
  92. Filter posts by meta query?
  93. Help on multiple meta_query
  94. Meta query – How to display a null meta key
  95. How to query wp_postmeta table for any specific meta_value?
  96. User meta query results in PHP notice: only variables should be passed by reference
  97. meta_query with multiple values optimization
  98. Meta query date column add [x] days to validate
  99. Get a single post ID based on an exact match of 1 or more meta values
  100. How to use orderby with meta_query?

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)