WP_Query hit max joins… How else can I build a search function that uses custom fields?

This seemed to do the trick, running it before my WP_Query:

$wpdb->query('SET OPTION SQL_BIG_SELECTS = 1');

Related Posts:

  1. How to search for posts IN OR title OR content OR author?
  2. Return only Count from a wp_query request?
  3. Use REGEXP in WP_Query meta_query key
  4. Order by DESC, ASC in custom WP_Query
  5. How to prevent execution of default query, while preserving ability to use WP_Query in template?
  6. Get posts by menu ID
  7. Slow SQL_CALC_FOUND_ROWS Query
  8. SQL query equivalent to WP User Query
  9. What’s wrong with this WP query?
  10. Stop all SQL_CALC_FOUND_ROWS wordpress queries
  11. How to count post meta key values for all posts in database
  12. How to use filter hook posts_join for querying taxonomy terms in posts_where?
  13. Group posts by meta_key
  14. Would this post meta be better added to the post table rather than post_meta table
  15. Order By Multiple Meta Fields
  16. meta_query on a date range using an array of values
  17. How to speed up wp_query, took more 5s to run against 100k posts
  18. SQL User Query by Multiple Roles using PHP
  19. WordPress Query is taking more then 20 second and stuck on creating index
  20. Get the Plugin Which Triggered a MySql Query in WordPress?
  21. Mysql query LIKE not working
  22. How to get posts on a specific date – WP Query
  23. Using WP_Query and WP_Meta_Query Outside of WordPress
  24. How to find exact match for search term in WP_Query? What is the additional string added in LIKE query in WP_Query?
  25. Improve wp query perfomance on large db
  26. Order by custom table and multiplication
  27. Single meta_query query using OR instead of AND in request’s WHERE statement
  28. why update and delete query not worked in custom table?
  29. How to display upcoming events by dat with Modern Events Calendar Lite
  30. How to use MySQL’s MATCH AGAINST in WP_Query?
  31. Slow WP_Query for custom post type
  32. Performance when getting post meta for post retrieved by meta value
  33. Hide Administrators From User List except current user (administrator)
  34. Add “Category” to Mysql Query
  35. Mysql query and order meta value
  36. Help with WP_Query – Too many mySQL queries
  37. Using hook to use DISTINCT in a wp_query
  38. pagination with ‘no_found_rows’ => true,
  39. Order by summing multiple values
  40. How to implement a new row_count method in WordPress?
  41. Wp query show post by author name or post title or post content
  42. Query most popular terms by taxonomy over 2 week period
  43. Which is faster wpdb & get_row or wp_query & ge_post_meta?
  44. how update data through ajax and jquery
  45. Meta Query doesn’t works as espected
  46. how to get Nearby zipcode
  47. How I can change the condition or compare operator for WP_Query in pre_get_posts
  48. Update query for wp_posts and wp_postmeta
  49. mysql query order by
  50. WP_Query with page_ids in arguments without a result
  51. Query multiple meta key values for template
  52. Reordering content using a meta value
  53. get_var is neither a string, integer, or array …?
  54. SQL query injection with fifu image
  55. Why last row deleted when refresh page
  56. WP Query – grouping posts by same meta key, adding together values from another key
  57. Woocommerce Get Orders By Meta Value
  58. SQL to join u3g_users & u3g_meta_value with repeating data
  59. order posts by a secondary query that counts items
  60. INNER JOIN custom tables – SQL Query
  61. use mysql variable in a $wpdb->query to reindex a column?
  62. One of two similar WP Query is very slow
  63. Fix wp_term_relationships slow query in get_posts
  64. WordPress Query optimaization for slow query
  65. Sorting query_posts() with a complex orderby filter
  66. Case insensitive ORDERBY in wpquery
  67. Query postmeta based on meta_value, return array of post_id
  68. Order Posts By Custom Field That is an array of objects
  69. Multiple wpostmeta.meta_key
  70. Slow query when selecting with large meta query or post__in
  71. WP_Query always returning the last custom post
  72. WP_Query to show post from a category OR custom field – Not 100% answered
  73. Get a list of the last posts grouped by author and filtered by category
  74. How to count post meta key values for all posts in database
  75. meta_query dates from an array
  76. Different sql queries count indicator on the main page [closed]
  77. Parsing External Table Arguments
  78. How to add a custom field and incrementing value for all the published posts
  79. WordPress query very slow on +/- 300k DB entries and 7 INNER JOIN
  80. SQL query into to WP query
  81. Bulk delete comments, foreach loop
  82. Posts per Page not working
  83. meta_query is overriding default search
  84. WP_query pagination on frontpage
  85. Custom Woocommerce Product Query
  86. Any way to use FETCH_KEY_PAIR with $wpdb?
  87. Usermeta data unserialize, extract and display in table in WordPress
  88. WP Query by 4 different taxonomies
  89. WP_Query no result if keyword contains number
  90. WP_QUERY order posts by two combined meta_value dates
  91. Trouble with serialized metadata
  92. Query by meta key and order by another meta key value
  93. How to display the category dropdown auto search list when key press?
  94. Redirect logged in users from a custom post type archive page if they don’t have a specific role
  95. Multiple WP_Query args combinations according to post type
  96. wp_set_object_terms() custom taxonomy not working correctly when using insert post
  97. pre_user_query vs pre_get_posts
  98. Exclude post from wp_query based on custom field boolean
  99. Categories In English version showing not canonical URL, instead shows query search result
  100. Custom WP Query order function possible?

Leave a Comment

File not found.