The posts_where
filters the ‘WHERE’ part of the SQL statement, and not the query string. So
$where .= "&post_date > '".date('Y-m-d H:i:s', strtotime('-24 hours'))."'";
should be
$where .= " AND post_date > '".date('Y-m-d H:i:s', strtotime('-24 hours'))."'";
Also as this hook is fired for every query (admin and public side), you should use some logic to only append the custom where statement when required.
Alternatively, you can add the filter just before your query and remove it again afterwards:
add_filter( 'posts_where', 'filter_where' );
$query_string ='gdsr_sort=thumbs&posts_per_page=10';
query_posts( $query_string );
remove_filter( 'posts_where', 'filter_where' );
Related Posts:
- How can I create a meta_query with an array as meta_field?
- Query multiple meta key values?
- How to get comments by post ID?
- Is there a way of increasing the speed of this query?
- How can I query all users who registered today?
- Reversing the order of posts AFTER the query is performed
- what are the numbers between curly brackets in search query
- When/why does ‘$query->get( ‘tax_query’ );’ return empty?
- How to get link and title of next and previous post on single page
- How to display Section for certain time
- Search custom post type by meta data
- Multipart/formatted MySQL query problem
- Remove [gallery] shortcode altogether
- query multiple taxonomy and show post count
- Categories and products in random order
- add_query_arg() XSS Vulnerability
- When add_query_arg() is necessary?
- Filter query posts by the count of metas for a meta key
- Save default value for empty or missing post meta
- Listing posts by grouping dates
- Query posts by content lenght
- $wpdb doesn’t appear to work on page inside of a plugin
- Change searched term
- Query Posts By Post Publish Date, but sort by Custom Meta Key
- How to export current year posts from WordPress?
- MySQL variable in query
- Search query -> Show all pages except certain template
- How to execute a SQL-query which contains multiple queries using $wpdb->query?
- Only show upcoming event or current events
- Why a URL with a query is always slower than that without a query?
- Maintaining Queries in URL
- How to orderby multiple meta fields with another meta query
- Query posts using meta_key
- Modify users.php query with multiple taxonomies
- MySql Query very slow
- wpdb query problem to access previous 3 days posts
- WordPress Query wp-terms SLOW
- I can’t figure out what’s wrong with this statement. $wpdb->query update
- Different values for get_author_posts_url and get_the_author (posts 2 posts)
- Problem when try to add ++1 for user meta
- query statement containing variable won’t execute
- Get posts from category with custom query
- get_users with array as meta_value
- Related post based on content
- Slow Search Queries – How to exclude pages, media, excerpt, authors, private posts?
- exclude pingbacks from wordpress SQL query
- How to interfere to default search to make it search in custom fields?
- wp_posts query slowing down my website
- Advanced Custom Fields – Relationship post foreach query
- WP_User_Query with more than two custom meta values
- Declaring a var, placing it in a query and using the output of the query?
- how do i register global query in template
- How do I query for posts by custom meta and those that have been stickied?
- Select min/max meta from query
- Combining two meta_values within one row with query
- Sort query_terms_list for post_tags alphabetically
- Target a page with query
- List only parent attributes on woocommerce admin atrributes page
- Merge CPT Taxonomy and Post Taxonomy in $query->set
- How do I get specific readable results from this query and array results
- I want to get on those users their meta value are like “AGENT” .. but this query is not working
- Add rewrite rule for archive search
- How to create a filter and add query params to all links
- Get 2 meta values from meta key column
- WordPress add_query_arg from ajax and make url friendly
- Query Post interferes with Pagination
- My custom pagination not displaying
- Order WordPress Query by Custom Field While Still Using Tax_query Argument
- Wpdb->last_query returns bad query
- WP search exclude last letter from string
- Are there any best practices for creating a Like/Favourite feature in WordPress using custom MySQL tables and without any plugins?
- Query reversed when I use “category__not_in”
- How to reduce the load / no of queries on MySql Database
- Performance of wp_get_attachment_image_srcset() and wp_get_attachment_image_url()
- $query->set( ‘post_type’, ‘post’ ); not working
- How i make a custom sql query for Woocommerce
- Display result from custom post meta query
- Show certain number of post from tags
- Wpdb empty result only if language is Russian
- Include custom table in query
- How to fix this insert? Don’t work for me!
- Display Upload Author & Get Uploaded Post ID
- Display list of most recent grandchild (third tier) pages
- How can I display a number to represent the order of post?
- How to query custom post type one after another
- Update vs Insert logic but the last key is always inserted?
- Apply ordering args to newly merged queried
- Sort order in get_posts [closed]
- Query unique author ids with published post of type job
- Wpdb generates too many queries
- Get blog id of subdirectory multisite blog from name – *outside* of wordpress request processing
- Custom Query for searching through custom fields
- Query posts alphabetically within this function
- Conditional Tag Custom Querys?
- WordPress Unknown Query
- List of buyers for each product
- query posts only works on the first page
- Custom Query for wp_posts using wp_postmeta
- WP Query outputs three items within a div
- How to show sticky posts on all pages of the pagination, not just the first page?