Your SQL dump proved to be informative.. Either 1=2 or 1=0 in a SQL statement means something you passed your WP_Query was invalid.
It appears that in your tax_query you specified 'field'=>'term_id', which isn’t a valid option – it should be just 'field'=>'id'.
Related Posts:
- Change searched term
- How to reset usual $query on search page to push custom $wpdb query there?
- what are the numbers between curly brackets in search query
- Search custom post type by meta data
- Custom query filter not working on woocommerce category page
- Search Terms – Querying on either description__like OR name__like in the same Term Query?
- $query->query_var[‘post_type’] not set for pages
- Filter query posts by the count of metas for a meta key
- search through post-type attachments titles
- How to set back query var author_name after unset it?
- pre_get_posts : ‘post__not_in’ doesn’t work with global variable
- Search query -> Show all pages except certain template
- Temporarily storing main search result
- Replace/Mute/Stop Search Query
- Query based on title, with ‘compare’ => ‘IN’
- is_search called incorreclty
- Attempt to improve WP search, can someone check my SQL query?
- Searching With Apostrophe
- How to change the amount of posts previewed on a page?
- Ideas how to search & replace post_content when string contains a newline?
- How to insert Collate into WordPress search query?
- Slow Search Queries – How to exclude pages, media, excerpt, authors, private posts?
- How to interfere to default search to make it search in custom fields?
- How to manage a particular “order by” for get_search_query()?
- Merge CPT Taxonomy and Post Taxonomy in $query->set
- WordPress search in modified post title
- Filter orders by modify date
- How to add url parameter to every search query in SearchWp?
- Add rewrite rule for archive search
- custom sorting media with multiple filters – error: not unique table/alias: wp_postmeta
- Restrict WordPress search to a single ACF field
- Modify behaviour of “s” parameter in wp_query
- Sort by postmeta on when searching
- Pagination adds search query (again)
- Speed up search query that searches in post meta?
- New custom post type entries are not sorted correctly in admin using pre_get_posts
- How to make MySQL search queries with quotes
- Limiting a filtered query
- $query->set( ‘post_type’, ‘post’ ); not working
- Why the pre_get_posts hook can cause apache stopped working?
- search.php is not generating the right results
- excludeCat function reverses order of blog posts
- Set posts per page for parent category and it’s all children
- Filter multiple different main queries on custom pages
- How to display search query as formatted text?
- Modify a query using both a text field and a true/false AFC field
- Admin Post List table Query filtering “WHERE” for custom post type
- Search query alteration not working for meta values
- Get all image from single page using this query
- How to tune search argument in WP_Query to show only exactly the same results?
- WordPress Number of Posts Not Changing With posts_per_page
- How to find objects by terms
- How to get my loop to pull posts into three columns
- Can’t pass table to $wpdb->prepare
- Date query year and month OR just year
- get post id using the $query_vars variable
- Building an Advanced Search (text, tags, category, custom fields) – Getting the wrong SQL query
- Category archive page – loop through posts of certain tag (with pagination) – pre_get_posts
- Including only current user’s posts in search
- How select a specific query when setting offset?
- Change media attachment author via mysql query
- How to modify archive query with pre_get_posts to append CPTs?
- sql select query in wordpress ‘page’ [closed]
- wpdb->term_taxonomy count posts from both published and private posts?
- Group custom post listing in admin section
- pre_get_posts : only get posts by wp_usermeta value
- get_posts showing only 5 posts. (nopaging and posts_per_page -1 not working)
- Order posts by date, but also give priority for a specific term
- Combine “Exclude” Query in functions.php
- prepare function sql safe method
- Wrap/close ‘query’ for a first-letter ordered listing of posts
- wpdb query with dynamic column name?
- How do you display the number of a post in a query?
- Searching with Multiple (Parallel) Criteria on Custom Fields?
- Show Posts via cat+cat in URL that are in both Categories doesn’t work
- get products by custom date variable
- How to delete all images from code in all post_content
- Excluding posts from search results page with meta query not working
- How to sort by two meta keys in admin area?
- pre_user_query vs pre_get_posts
- How to exclude woocommerece product category in search results?
- wp query multiple values > display a specific value first
- PHP Fatal error: Uncaught Error: Call to a member function insert() on null
- Nested select statements not working
- Add to search posts query array with post IDS which will appear first
- Fastest and most efficient SQL query to check if UID exists
- Advanced Custom Fields Query with Different Values of the Same Key
- No results for taxonomy archive page
- Search Functionality broken by the wp 4.2 update
- How to perform a search inside a specific taxonomy category
- Show links to child pages on both parent AND child pages
- Modify Global Posts Plugin
- SQL: Search query to get attachments only of those parents which are published
- How to reference same column name but different table in custom db query
- Retrieving custom field array value through db query
- SQL Query : how copy all tags of post into their post content in wordpress by sql query
- AJAX loading with custom parameters
- How do I troubleshoot Maximum execution time of 60 seconds exceeded in updating a Media File?
- update $wpdb one query
- How to use a dynamic term id for the query block