Display Posts by modifying the where clause only for my query

If you’re going to add the filter on the where clause, then just make sure you remove it using remove_filter() and the exact same signature immediately after you create the query.

In your example, you’re using query_posts(), so add the filter, run your query, and then remove your filter right afterward.

add_filter( 'posts_where', 'my_posts_where_filter', 10, 2 );
query_posts( $query_string );
remove_filter( 'posts_where', 'my_posts_where_filter', 10, 2 );

It is to be noted that when you use the 2-argument version, the second argument can be of great use in limiting your filter to only affecting the queries you’re interested in.

add_filter( 'posts_where', 'my_posts_where_filter', 10, 2 );
function my_posts_where_filter( $where_clause, $query_object ){
  // check conditions on your query object...

  // ... then manipulate your $where_clause accordingly
  return $where_clause;
}

If you go that route, you can probably dispense with the remove_filter() altogether.

Further, you can probably dispense with query_posts() too, while you’re at it. if you’re already mucking around with get_posts() filters, which are run on every query, adding in another query with query_posts() is just going to slow down your blog load times.

So find a way to identify the page you’re on (inspect the $query_object using print_r() to see what goodies it holds, or use a conditional like is_main_query() etc), then wrap your additional WHERE conditions within a big ol’ if{ } block. Set up your filter NOT from the page template you’re on, but rather from within your functions.php, or some included class. And of course test, test, test to make sure you’re not affecting other pages of your site, or some widget, or your RSS feed, or the admin back end.

Related Posts:

  1. When to use WP_query(), query_posts() and pre_get_posts
  2. Nested meta_query with multiple relation keys
  3. WP Query where title begins with a specific letter
  4. WP_Query vs get_posts
  5. Using OR conditions in meta_query for query_posts argument
  6. Order posts by ID in the given order
  7. Query Multiple Post types each with own meta query
  8. Get posts by menu ID
  9. Get the number of posts from the current page results
  10. Query Custom Meta Value with Increment
  11. How to know which one is the main query?
  12. get query’s query string
  13. Meta Query with date and time on the same Day before given time
  14. How to use filter hook posts_join for querying taxonomy terms in posts_where?
  15. Multiple search queries on one page
  16. How to show only one post for each categories of taxonomy of custom post that contains a specific custom field
  17. Pass the same object to multiple widgets in a template with one query
  18. How add a custom posttype name using ACF field to a query post array
  19. Page navigation doesn’t show when query category
  20. 2 loops on page – one with orderby rand second orderby date
  21. Query post with meta_query where date is not in future
  22. Next/Prev posts on same page
  23. How to query a custom post type with a taxonomy filter but display post type archive page?
  24. WP_Query last five posts, simply ordered by meta_value
  25. WP Pagination on Posts Search Results Page resulting from AJAX WP Query
  26. WP_Query “OR”: Find posts by ID, Name or Post Title?
  27. Five posts from a category in footer
  28. Change query_posts to WP_Query in page but does not work
  29. WP_Query condition affects posts_per_page count
  30. How can I create ‘future’ and ‘past’ parameter for restAPI by filtering the CPT custom date field by greater than / less than current datetime?
  31. Serve specific “template” page at any URL that ends in its slug
  32. How to display multiple custom fields with the same meta_key in an ascending order?
  33. new WP_Query(), have_posts() return false in user_register hook
  34. how to make members list directory through wordpress post custom meta key.
  35. Add class to first post in custom loop using post_class filter
  36. Some doubts about how the main query and the custom query works in this custom theme?
  37. How to exclude post formats from wordpress recent posts in a tabs widget [closed]
  38. How to increase load time of an archive/search page (WP_Query)
  39. Query Page Content From Theme Options?
  40. Query all posts if multiple meta key don’t exist
  41. Is there a better way to pull in custom content without querying posts?
  42. Reset WordPress Post Query to default
  43. How to get all post except particular category without breaking the paging
  44. How do I rewrite this loop as a new WP_Query style-loop?
  45. Include current post into loop
  46. Filter Custom Taxonomy Posts
  47. How to provide meta_key array to wp_query?
  48. Easy way to write complex queries in wordpress
  49. Filter post query to only show direct children of category
  50. Order post type by sum of two custom fields
  51. get_posts output always same post
  52. Query_posts works when appending via AJAX call wp_query doesn’t?
  53. Use WP_Query or query_posts() or get_posts() for optimizing a site?
  54. How to make posts unqueryable/unpublish posts where ACF relationship field is an unpublished post? [closed]
  55. Posts Query | Query to only show sub categories
  56. How do I add a relation parameter to my filter query?
  57. Creating attachments archive in tags and categories
  58. Get next/prev image/attachment in time with date query
  59. Show single posts date, in a page of posts
  60. specific post is not excluded from the loop
  61. Why doesn’t my WP Meta Query return any results?
  62. Paginate pages with dynamic query
  63. filter posts by meta key with pagination
  64. Trouble Making WP_Query paged
  65. Performance concerns: index.php vs taxonomy-$taxonomy.php
  66. Determine if ID is page or post and query the ID
  67. Custom template for password protected page
  68. WP_Query Class custom field parameters
  69. Add AJAX “Load more” on custom query block
  70. Optimising WP_Query with ACF Fields
  71. Elementor posts custom query based on tag [closed]
  72. Filter products on category AND tag
  73. Facing problem with tax_query results
  74. How do i create a custom post query when the meta value is an array?
  75. How do I stop the same post showing multiple times in a archive?
  76. Get posts that match defined arrays of tags
  77. Custom query to retrieve oldest post and retrieve others with date interval
  78. trying to change from query_post to WP_Query
  79. How to query most recent post for each author?
  80. Sorting query_posts() with a complex orderby filter
  81. I need query_posts() to order results first by a meta value and then by post ID
  82. WordPress For Loop Prints Unwanted Extra Paragraph Element
  83. How to search CPTs in draft using get_page_by_title()
  84. Orderby query does not work for custom fields even with meta query
  85. Custom WP_query and integrating into theme file
  86. query_posts() doesn’t seem to be called in my page
  87. Some doubts about how the main query and the custom query works in this custom theme?
  88. Fetching $_POST from Page Template into functions.php
  89. Ordering Posts by parent category, name ascending
  90. Optimising specific Query with ACF meta objects
  91. How to organize a WP_Query’s list of posts by category and display category title?
  92. query_posts with sorting on a custom datestamp
  93. query post based on comparison
  94. WordPress Query showing multiple titles
  95. Query Posts by date range with fixed beginning and end
  96. custom query to get posts
  97. Multiple loop for “featured” items returns wrong posts
  98. Having trouble using this post category query on multiple pages?
  99. Query Posts to fetch Posts with Unique Tag
  100. query_posts problem – need help

Leave a Comment

tech