I had a quick grep for SQL_CALC_FOUND_ROWS and found a few instances. I’m not sure which one is being called in your case, but here’s an interesting one from wp-includes/class-wp-query.php line 2904 onwards: $found_rows=””; if ( ! $q[‘no_found_rows’] && ! empty( $limits ) ) { $found_rows=”SQL_CALC_FOUND_ROWS”; } $old_request = “SELECT $found_rows $distinct $fields FROM {$wpdb->posts} … Read more
Sort the result of the main Query in shop page by a custom taxonomy
How to sort custom columns for custom post type without meta query and pre_get_posts?
How to use $query->set with post__in?
The problem was with my code. I was using wp_reset_postdata() before a section that shows the post title, which made it look like the WP_Query wasn’t working. Here’s my code now (it’s a slider that shows latest posts, and the regular feed shows scheduled posts). I updated my question with my new code
Removing taxonomy query by pre_get_posts
I made some fixes to this code as it doesn’t work anymore. The following code will search the terms to be LIKE the title OR the content OR the meta_value : function custom_search_where( $where ) { if ( is_search() ) { global $wpdb; // Overwrite the existing WHERE clause. $where=””; // Store all search terms … Read more
On your search form you use NULL (as a string) for Any selection. When the form is submitted it is sent as a string with the contents of the word null. Your isset then sees that, its set and sets the session to null (as a string). Which in turn messes up your query. To … Read more
If you are after on post from category a, one from category b, another form category c and then finally a custom post type – each of these would have to be a separate query. Think of these as ‘secondary queries’ – (the primary query being what lands you on the home page). So you’ll … Read more
That happens because of the way WordPress structures the MySQL queries, and the way posts joins postmeta. If a post doesn’t have a value in featured, it won’t join. Here are two options for you: Update the way you’re storing featured to store the value regardless (either ‘1’ or ‘0’). Ensure that every post has … Read more