using posts_where for meta data on pre_get_posts

I doubt that ever worked by itself. WP_Query operates on posts database table. On the bottom SQL level to make use of post metadata you need to not only say what metadata you are looking for, but also instruct MySQL how metadata table connects to your posts table (JOIN realm).

I would attempt to keep manipulating query arguments for starters, it doesn’t seem like your conditions are that complicated (from what you quoted at least).

PS also don’t forget to remove your filters after, or you are messing up other queries.

Related Posts:

  1. How to modify posts_where filter only for the search query
  2. Search pre_get_posts filter which can handle multiple post types and categories?
  3. Sorting and limitation with pre_get_posts
  4. Get .subsubsub count of post per status queried using pre_get_posts
  5. Remove posts inside pre_get_posts using a custom query
  6. Filter pre_get_posts does not modify Mine/All/Pending
  7. Get Posts updated or published within the last x hours
  8. Run posts_where and posts_join only on the main query
  9. get_posts() interrupt because of filter
  10. pre_get_posts to hide everywhere posts from “Archive” category
  11. Custom SQL query slows down when using multiple OR … LIKE … in posts_where filter
  12. Apply pre_get_posts filter in a certain moment (just for a particular block of posts)
  13. Remove the post_content search from WHERE clause (and CONCAT sql function)
  14. Testing requested query in pre_get_posts
  15. Changing WooCommerce Display Price Based on User Role & Category [closed]
  16. Not able to change wp_title using add_filter
  17. How to hook a filter to catch get_post_meta when alternate a custom field output?
  18. Changing JPEG compression depending on image size
  19. Advanced Custom Fields and Yoast SEO keyword analysis [closed]
  20. Insert Custom HTML After Shortcode
  21. Is there a way to add another row to the tinyMCE kitchen sink toggle?
  22. How to add taxonomy filter on the query fly?
  23. What do add_filters() and apply_filter() do?
  24. add_filter to youtube embeds?
  25. SSL certificate for the host could not be verified
  26. Store source permalink on XMLRPC calls
  27. What to use instead of the content_save_pre filter?
  28. How to limit the pages displayed for choosing parent page on page attribute’s menu?
  29. How can I reliably and globally disable wptexturize?
  30. Customise Jetpack Publicize text
  31. Can’t change a label in woocommerce with the normal filter
  32. WordPress RSS feed – filter RSS content by custom field value
  33. What is the filter hook for custom fields content?
  34. Filter keywords from search query
  35. Add class to woocommerce checkout body based on filter [closed]
  36. Add classname to the_category() function?
  37. Filter the URL of next_posts_link & previous_posts_link
  38. Explanation for remove_filter used in the below code [closed]
  39. How to change the blog title with add_filter? details below
  40. How To Get User Data in Callback Function for pre_user_nicename?
  41. What’s the best way to split admin-only functionality in the theme’s functions.php file?
  42. Editing
  43. the_content filter – checking the post
  44. add_filter to apply_filters that exists within class
  45. Which built-in WordPress files are safe to edit?
  46. How do I target a single page to modify the comment form of only that page?
  47. Adding a title prefix with the the_title filter
  48. How to removes all instances of thumbnails displayed in my theme?
  49. Contact Form 7 filter similar to preprocess_comment [closed]
  50. How to modify an existing meta description?
  51. Adding TinyMCE buttons without removing plugin buttons?
  52. Filter on the_content doesn’t update the content being searched via register_rest_route
  53. Where to add_filter in theme functions.php?
  54. Applying posts_clauses filter to specific queries only
  55. tag removed not using a filter
  56. How to customize the “Insert/edit link” popup box?
  57. How to filter backend post list showing only posts having a shortcode
  58. How do I override the_excerpt so that it will display full content?
  59. Why does WordPress strip custom HTML that are form elements and theme SVG icons?
  60. Get current user data
  61. How can you wrap add_filter with a if is_home() statement?
  62. How to add attributes to WordPress Admin Sub Menu List Items
  63. How do I hook my function to run only after submitting login form
  64. How to combine multiple body classes
  65. How to write a filter to remove a form field (WordPress) [closed]
  66. Why doesn’t this function work when I know that the IP Address is “true”?
  67. why require – does not load filter
  68. term_link filter rewrite link only applying half of condition?
  69. How to change dynamically page title according to variable data?
  70. Map plugin with proximity search compatible with Buddypress
  71. Create a pre-filtered version of the Media Library
  72. What is the action hook to use if you want to capture the new password during password change?
  73. Get_template_part inside filter?
  74. How to filter Sidebar Content
  75. Removing URL and adding container around image in the featured image metabox
  76. How would I use a filter to remove header banner on certain post types
  77. Replace Data In Post & Update Meta Field Post Is Saved
  78. How to add custom media library mime icons?
  79. Customising the default wordpress search functionality
  80. get_post() with filters applied
  81. Ajax filter – show all results that contain at least one filter
  82. WP_Query filter by custom meta
  83. How to add a blog filter bar without paying money. (example inside)
  84. Override admin selected page layout
  85. WordPress: Issue with filtering users using date range
  86. Does anybody know what the $current_screen ->id for customizer.php is?
  87. How to filter reading/visibility posts based on role?
  88. Apply pre_get_posts to specific custom post type in the admin area
  89. Filter and validate user role in registration
  90. wordpress filtering out caps in wp_title? (UpperCase is changed to Uppercase)
  91. String Replace Caching & Chance of Collisions
  92. is_page_template() doesn’t work with excerpt_length filter
  93. Is there a way to overwrite a filter used in canonical.php?
  94. How do I remove certain HTML elements with specific classes from the feed?
  95. Adding an orderby filter, casting postmeta with multiple keys
  96. confusion with add_filter
  97. post->post_content filter
  98. Which action/filter can i use for a Member Plugin [closed]
  99. How to change this WP logo and posts url in block editor?
  100. Limit total tags in the_content