Run search query again without pagination gives no results?

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:

  1. Change searched term
  2. How to reset usual $query on search page to push custom $wpdb query there?
  3. what are the numbers between curly brackets in search query
  4. Search custom post type by meta data
  5. Custom query filter not working on woocommerce category page
  6. Search Terms – Querying on either description__like OR name__like in the same Term Query?
  7. $query->query_var[‘post_type’] not set for pages
  8. Filter query posts by the count of metas for a meta key
  9. search through post-type attachments titles
  10. How to set back query var author_name after unset it?
  11. pre_get_posts : ‘post__not_in’ doesn’t work with global variable
  12. Search query -> Show all pages except certain template
  13. Temporarily storing main search result
  14. Replace/Mute/Stop Search Query
  15. Query based on title, with ‘compare’ => ‘IN’
  16. is_search called incorreclty
  17. Attempt to improve WP search, can someone check my SQL query?
  18. Searching With Apostrophe
  19. How to change the amount of posts previewed on a page?
  20. Ideas how to search & replace post_content when string contains a newline?
  21. How to insert Collate into WordPress search query?
  22. Slow Search Queries – How to exclude pages, media, excerpt, authors, private posts?
  23. How to interfere to default search to make it search in custom fields?
  24. How to manage a particular “order by” for get_search_query()?
  25. Merge CPT Taxonomy and Post Taxonomy in $query->set
  26. WordPress search in modified post title
  27. Filter orders by modify date
  28. How to add url parameter to every search query in SearchWp?
  29. Add rewrite rule for archive search
  30. custom sorting media with multiple filters – error: not unique table/alias: wp_postmeta
  31. Restrict WordPress search to a single ACF field
  32. Modify behaviour of “s” parameter in wp_query
  33. Sort by postmeta on when searching
  34. Pagination adds search query (again)
  35. Speed up search query that searches in post meta?
  36. New custom post type entries are not sorted correctly in admin using pre_get_posts
  37. How to make MySQL search queries with quotes
  38. Limiting a filtered query
  39. $query->set( ‘post_type’, ‘post’ ); not working
  40. Why the pre_get_posts hook can cause apache stopped working?
  41. search.php is not generating the right results
  42. excludeCat function reverses order of blog posts
  43. Set posts per page for parent category and it’s all children
  44. Filter multiple different main queries on custom pages
  45. How to display search query as formatted text?
  46. Modify a query using both a text field and a true/false AFC field
  47. Admin Post List table Query filtering “WHERE” for custom post type
  48. Search query alteration not working for meta values
  49. pre get posts not working with Tribe Events
  50. is_search called incorrectly
  51. How to allow searching a custom meta key in admin list table?
  52. Using pre_get_posts to rewrite search query to display posts from multiple taxonomies
  53. Get all image from single page using this query
  54. Add multiple value to a query variable in WordPress
  55. Search and replace text across all posts
  56. wp_dropdown_categories with multiple select
  57. WordPress Number of Posts Not Changing With posts_per_page
  58. How to find objects by terms
  59. Custom $wpdb Query for Custom Post Type by Category
  60. Are database queries created using WordPress filters protected from SQL injection?
  61. Is there a conditional tag for latest post or do i need a query?
  62. get_posts() loop returns the same the_title() for each post
  63. How to check current user in meta value array in WP_Query meta_query
  64. Change media attachment author via mysql query
  65. How to modify archive query with pre_get_posts to append CPTs?
  66. Help with MySQL to $WPDB query
  67. Group custom post listing in admin section
  68. problem with sql query in wordpress plugin
  69. Post 2 Post Site Search
  70. Search queries don’t seem to work?
  71. Exclude all sticky posts front page twenty twelve
  72. get csv of users with user_meta
  73. Search for two strings in WP search
  74. Custom SQL Query passing array to WHERE p.id
  75. get posts by tag to showing in a widget
  76. Mysql query not working on WordPress 4.2.2
  77. Custom search SQL Query to add custom field in result
  78. get_post_meta with WP_query
  79. How to exclude custom fields from search queries?
  80. How properly create a blog template for wordpress?
  81. Is there a way to add a link directly into this media query?
  82. Amend taxonomy to search in wordpress admin
  83. How can I modify this code to make the search box include tags and meta
  84. Change search query in wordpress custom post type
  85. Search custom posts by meta key in admin
  86. meta_query not working
  87. Cannot get sql request from Query object?
  88. Customising the default wordpress search functionality
  89. WordPress query: merge meta key (number) values and sort
  90. Question about of query
  91. Including taxonomy in searches
  92. Search has query that will return no results
  93. pre_get_posts improperly searching revisions
  94. Custom Query problem access the values
  95. Exclude sticky posts from query
  96. If more than 1 image show post link?
  97. Rewrite Query_Var URL Parameter with Slug
  98. How to query different categories on index?
  99. Can’t See Media Queries with Inspect Tool [closed]
  100. Can I make a Heading block above a query loop block disappear when that query loop has no results?