Using Query Monitor I was able to find the source of this query, it was from a plugin “starbox” which uses the query to fetch the last 3 posts from the author of a given post. Editing the plugin by commenting out the part it runs this query solved the issue.
You can have more than two. You could have as many as you like but you may have performance penalties if you try to use too many. I’d expect this to be true especially if you use an OR relationship. See the following for a way to create your tax_query array dynamically. https://wordpress.stackexchange.com/a/97444/21376 To adapt … Read more
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
Executing the code you posted results in a crash inside the PHP module. I assume you’re running PHP as module inside apache on windows, if the module crashes, apache crashes as well. Ensure that you’re using the right PHP modules here. Are you sure you need the Thread-Safe variant of PHP for apache? Those are … 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