We can simplify your code and just run one query instead of two. The answer lies in rewinding your loop and rerunning it multiple times. We will use the build in loop counter, $current_post to count our posts. Just remember, this counter starts at 0, and not 1, so post 1 will be 0 So … Read more
You do want to “do a loop”. Within your header you want to make a fresh query for just those three posts and loop through them without upsetting the main query that you need further down each page. Here’s a standard loop calling three posts from your category: $wpse_235359_query = new WP_Query( array( ‘category_name’ => … Read more
I have found an answer by myself, for those landing here by google: $taxq = array( array( ‘taxonomy’ => ‘story_lng’, ‘field’ => ‘id’, ‘operator’ => ‘NOT EXISTS’, ) ); That results in AND (NOT EXISTS( SELECT 1 FROM wp_term_relationships INNER JOIN wp_term_taxonomy ON wp_term_taxonomy.term_taxonomy_id = wp_term_relationships.term_taxonomy_id WHERE wp_term_taxonomy.taxonomy = ‘story_lng’ AND wp_term_relationships.object_id = wp_posts.ID)) AND … Read more
Turns out, WordPress joins the postmeta table several times, depending on the meta query arguments. Yes that’s correct, and it’s also the reason why I said (in my other answer) that in an orderby array, you should use the key of an array in the meta_query which contains a direct item named/keyed key (where the … Read more
After a huge night overthinking this, and thanks to Joost de Valk (Yoast SEO plugin author), I found the solution. As per this thread: https://github.com/Yoast/wordpress-seo/issues/437 , what I want to achieve the way I do, is undoable, or at least, a very bad practice. If you want your custom query to have the default pagination … Read more
The WP_Pagenavi FAQ links to the following article to explain how to use the Pagenavi plugin with a secondary query by passing the wp_pagenavi() function a query parameter. From the tutorial: $my_query = new WP_Query(); while ( $my_query->have_posts() ) : $my_query->the_post(); the_title(); // more stuff here endwhile; wp_pagenavi( array( ‘query’ => $my_query ) ); wp_reset_postdata(); … Read more
Here is a rough outline of how you’d go about making a UNION work with WP_Query. add_filter( ‘posts_request’, function ($clauses) { $clauses = str_replace(‘SQL_CALC_FOUND_ROWS’,”,$clauses,$scfr); $scfr = (0 < $scfr) : ‘SQL_CALC_FOUND_ROWS’ : ”; $clause2 = $clauses; // manipulate this return “SELECT {$scfr} u.* FROM (({$clauses}) UNION ({$clause2})) as u”; }, 1, 2 ); Set up … Read more
You’re saving every query object for each category to the same transient. Because this happens fast and time frame is one day, you’re always getting the query object for the first category back. Make your transient name variable with the category, e.g. like this: $query_category_posts = get_transient(‘cached_posts_’ . $category ); Of course you then need … Read more
WordPress sets the php timezone to UTC for internal calculations. So at 4pm PST, date() will be producing a date that reads 10pm UTC. Hence the event is considered past. There are two ways to resolve this. (The preferred method) Store dates in the database in UTC. Handle all date calculations in UTC, and convert … Read more
If you could tell us what you’re exactly trying to achieve, we can help you better! <?php $paged = get_query_var(‘paged’) ? get_query_var(‘paged’) : 1; $args = array( ‘post_type’ => ‘question’, ‘posts_per_page’ => -1, ‘paged’ => $paged, ‘author’ => $user_id ); $my_query = new WP_Query($args); if($my_query->have_posts()): while($my_query->have_posts()):$my_query->the_post(); //Loop goes here… endwhile; //support for page-navi plugin, please … Read more