Are you actually using ‘after’ => date(‘Y-m-d h:i’,time()) in your code? That will always ask for posts older newer that the exact current time when that query is run. Something like this: ‘after’ => date( ‘Y-m-d h:i’, time() – 60 * 60 * 24 ) would give you a reference for 24 hours in the … Read more
You’ve got trailing space in your $query->set(). Instead of $query->set( ‘date_query ‘, … it should be: $query->set( ‘date_query’, …
You have not stated how the selection works, but you need to have some kind of conditional set when a specific month is selected and when a year archive is selected. I also do not know where get_the_time comes in or its relevance to the query. But anyways, there are some other really big issues … Read more
Try to add date_query to the $qry in the solution mentioned here. $qry = new WP_Query( array( ‘cat’ => $current_post_categories[0], ‘posts_per_page’ => 2, ‘post__not_in’ => array( $current_post_id ), ‘date_query’ => array( array( ‘before’ => $post->post_date, ), ), ));
I’m afraid that there is no way to do such advanced queries using WP_Query. But, of course, you can still achieve that result, but you’ll need to write a little bit more code. There are two solutions: It’s hard to give you precise code, because there aren’t many details in your question, but maybe this … Read more
I wonder if you mean this kind of date_query: $query->set( ‘date_query’, [ [ ‘after’ => ‘today midnight’, ‘column’ => ‘post_date_gmt’, ‘inclusive’ => true, ], ] ); where we use the after attribute. Here the after date will be calculated by WP_Date_Query as: gmdate( ‘Y-m-d H:i:s’, strtotime( ‘today midnight’, current_time( ‘timestamp’ ) ) ); With the … Read more
You can use the posts_where filter: // Add custom filter add_filter( ‘posts_where’, ‘wpse_modified’ ); // Fetch posts $query = new WP_Query( $lastupdated_args ); where you can define the filter callback as: function wpse_modified( $where ) { global $wpdb; // Run only once: remove_filter( current_filter(), __FUNCTION__ ); // Append custom SQL return $where . ” AND … Read more
I had the same issue. I had searched many times for this issue. but I could not find a solution for this. get the most viewed post for the last 2 days not to get the posts for the last 2 days I have a table named “wp_popularpostssummary”. Result ll be so from this table … Read more
It might be possible to achieve this by using the post clauses filters and rewriting the generated SQL query. You can also run 3 queries, One very lean query to get the desired posts from the date_query One very lean query to get all the posts from the meta_query One final query to get the … Read more