Add custom argument to WP_Query and modify SQL where clause

Solved it. The filter posts_where takes the query object as a second parameter.

Related Posts:

  1. WP_Query with “post_title LIKE ‘something%'”?
  2. Pagination with custom SQL query
  3. Whats the difference between post_limits and pre_get_posts?
  4. Using OR conditions in meta_query for query_posts argument
  5. Is it possible to wrap Geo Location search around WP_Query?
  6. Is it possible to select against a post’s parent’s fields with WP_Query?
  7. Extending WP_Query — Optimise SQL query
  8. How to filter sql only for a specific post type
  9. How to make an activities stream mixing posts and comments?
  10. SQL Statement generated by WP_Query not producing expected results
  11. What is an efficient way to query based on post_meta?
  12. SQL query equivalent to WP User Query
  13. Recommended way to drop a pending query (in pre_get_posts)?
  14. how to retrieve specific product attribute value in an sql query?
  15. Filter WordPress posts by between parameter
  16. SQL User Query by Multiple Roles using PHP
  17. Advanced WP Query hogs the SQL server
  18. SELECT * FROM $wpdb->posts WHERE ID > 160
  19. How To Get Some Data From WordPress Database Using WordPress $wpdb Query?
  20. Query post with meta_query where date is not in future
  21. WP User Query get all authors with last name starting with specific letter
  22. Select from wp_post and multiple meta_value from wp_postmeta
  23. How to correctly pass values to wpdb->prepare()?
  24. Sort users by “birthday” using WP_User_Query
  25. $wpdb select date range of posts
  26. How To Fix WP Query Returns Results But Shouldn’t?
  27. List of the years with posts presented
  28. SQL: What is wrong with the following query (generated by WordPress WP_Query, ordering prices)
  29. Slow WP_Query for custom post type
  30. Complex WP SQL Query
  31. Query that loads a custom type AND posts whose ids are not inside those custom types custom fields
  32. Optional Meta Query
  33. Sorting events by descending date, and ascending time if multiple events on a date
  34. Editing the default wordpress search
  35. WP Query related posts by tags
  36. Order by summing multiple values
  37. How to extract specific post
  38. Woocommerce – Changing the order of the upsell products [closed]
  39. Changing sort order for presentation by Jetpack infinite scroll
  40. Include data from custom table in WP_Query
  41. wordpress ajax relationship query
  42. How to pass orderby params to $wpdb->prepare()?
  43. Debugging wp_query orderby for taxonomy
  44. Is it possible to query from external database? [duplicate]
  45. Include post content of linked posts in search
  46. Make a SQL query with wpdb in WordPress
  47. Getting additional columns from sql
  48. List of ways to access WordPress database?
  49. Getting rid of unwanted nonSQL syntax characters when debugging a query
  50. How I can change the condition or compare operator for WP_Query in pre_get_posts
  51. Query where ANDing slug values not working
  52. Slow Query On Search
  53. WP_Query: apply an SQL function to meta fileld value
  54. How to avoid filling up an array each time I run a WP_query?
  55. How to SQL query posts IDs by categories AND authors?
  56. Randomly select one of last 3 posts
  57. SQL query injection with fifu image
  58. Passing a SQL query to the WP Query
  59. WP_Query() not working as expected
  60. WP Query – grouping posts by same meta key, adding together values from another key
  61. Any way to use FETCH_KEY_PAIR with $wpdb?
  62. What is the equivalent WP_Query of a SQL Query?
  63. Translating WP query into to SQL query
  64. Filtering posts for unique titles, only the most recent
  65. Slow wp_posts and wp_postmeta query using Advance Custom Fields
  66. How to search CPTs in draft using get_page_by_title()
  67. Calculating efficiently on large amount of data generated by wp_query
  68. What argument does my function need to echo get_results() query results
  69. Include post_status check within $wpdb query
  70. Find by post_meta, then sort by post_meta, then sort by date (wp_posts)
  71. WP Query to order posts by multiple meta fields
  72. Custom WP_Query with SQL directives for getting posts by authors and terms
  73. How to return value from sql and display it
  74. orderby in WP_query doesn’t works
  75. WP_Query with several meta_query-statements and order by meta_value
  76. wpdb LIKE request shows all database data
  77. Convert a WP Query into a simpler SQL query to fetch only COUNT of posts
  78. Group By query based on Custom Field
  79. How to make OR condition in WP_Query
  80. Order Search Results Page by meta_value If no Value Return Remaining Results
  81. How to filter, restrict and return posts based on custom user meta information
  82. Masonry, WP_Query & paged – first page repeating, second page not loading
  83. REST API: Limit Read Permissions for Default Endpoints
  84. wp_query to print posts if have X custom field value
  85. Rewrite gets completely ignored
  86. Should $query-> be used with conditional tags?
  87. Migrate posts from category and sub-category via SQL
  88. WP_Query author parameter not working
  89. How to order posts on each different category?
  90. Query Not working as expected
  91. tax_query not working on custom post type
  92. WP Query and multiple queries
  93. How to display post based on which is clicked
  94. date_query problem
  95. I wan to process the following js to process the AJAX Request on my function to calculate author Total Post views
  96. (How) Can I use ‘wild cards’ on the left hand side of an array argument?
  97. Combine privileged users array with my current query
  98. Get posts from similar time as current post
  99. Query posts filter not working
  100. WP_Query do not include posts with a certain value in a custom field –