Meta Query with AND & OR?

Sorry, doesn’t work that way. The “simple” meta parameters are converted into part of the meta_query as a whole. So it’s not a separate thing, and your OR relation applies to it as well.

Your query thus is not possible with the normal query system, because you want to mix ANDs with ORs (you want items that have event_data ANDed with a bunch of others with ORs between them).

You’ll have to resort to either custom SQL or rethink your design.

Related Posts:

  1. Query post by date (stored custom field meta as yyyymmdd) and differentiate across 12 months
  2. Can I query custom meta data through WP_Query
  3. Trying to perform complex custom field query with order by set to field value
  4. Compare meta_query decimals not working right
  5. Comparing timestamps in meta query doesn’t work
  6. Display two post types ordered by two custom fields
  7. Using OR in WP_Query negates the “NOT EXISTS” compare
  8. How can I combine meta_query queries?
  9. Difference between ‘LIKE’ and ‘IN’ in meta queries
  10. WP_Query display next custom post from today’s date
  11. Upcoming Event: How do I sort database by custom date field, but ignore past dates?
  12. Meta query with timestamp using WP_query
  13. Conditional custom field query
  14. Alter main archive, to show posts with meta as last
  15. Meta Query And/Or
  16. The best way to collision check in WP
  17. How to query for posts with either one or another custom field
  18. Best way to sort estates and query them (for rent? yes/no. contains office space? yes/no)?
  19. How can I modify my meta_query to work with prices that are stored in the database that contain dollar signs and commas?
  20. Query multiple post types, but different order for each
  21. Query against multiple locations within single custom post type post
  22. Query by meta value (add a dropdown of all values)
  23. Create custom query for search?
  24. Meta_query not filtering posts
  25. Complex WP_Query Using Post Date And Post Meta
  26. ORDER BY custom field value
  27. How can I make wp-pagenavi work on a custom query built upon a form submission? [closed]
  28. Query WooCommerce orders where meta data does not exist
  29. Finding all results from database within 500 miles of the given latitude and longitude [closed]
  30. Order Posts by Closest Numeric Values
  31. Is there a way to do multiple ordering on a multiple meta_query?
  32. Can serialized arrays in DB be matched against serialized arrays with meta_query?
  33. Slow meta query with multi meta keys
  34. Using WP Query to search by multiple meta fields
  35. Sorting posts by multiple values, combined
  36. Sort by posts that have a featured image?
  37. WP_Meta_Query causing long-running MySQL queries
  38. $wp_query meta_key naming issue [closed]
  39. Meta_query and numeric comparison [closed]
  40. Adding Custom Fields to Search
  41. Multiple relationships in a query
  42. Loop to display random posts only if a custom field matches category
  43. WP Query Returning All Posts
  44. WP_Query: include custom post type only with specific meta value
  45. Add quicklink to in the Admin posts page where I can query by a meta_key
  46. How to make Meta Query case sensitive?
  47. Custom Field Create Bulk via SQL Query
  48. Create Pop-Up Box with Custom Field Content Inside the Loop
  49. How make a custom search on backend in WordPress without plugin?
  50. How to add a new meta key and assign timestamp to posts
  51. Get content from pages with same meta_key from Database
  52. Meta_query with multiple keys and multiple values
  53. Order RSS content by an advanced custom field value
  54. How do I have WP_Query match posts based on search parameter OR meta fields? (rather than search parameters AND meta fields)?
  55. Order by empty custom field
  56. First custom field value (out of several) displayed twice after query
  57. Why orderbyb meta_value_num won’t affect the generated SQL Query order?
  58. get posts where a custom field contains a text
  59. Get post ids sorted by meta_key
  60. querying a custom field
  61. Passing meta_box string to post__in?
  62. Avoiding ACF get_field and returning to core WordPress function
  63. pre_get_posts : only get posts by wp_usermeta value
  64. meta_value and meta_key filtering returning no posts [closed]
  65. Meta_query ‘compare’ => ‘LIKE’ not working?
  66. Diamond question mark in text after migrating content
  67. Modify date query by URL parameter using pre_get_posts and $_GET
  68. Is it possible to retrieve posts depending on meta_key LIKE condition? [duplicate]
  69. Why doesn’t my WP Meta Query return any results?
  70. WP_query multiple custom fields not working
  71. WP_Query meta compare must include ALL array values
  72. WP_Query () using taxonomy, custom post types
  73. Multiple Custom Field Query
  74. Searching with Multiple (Parallel) Criteria on Custom Fields?
  75. Custom Field Date Problem
  76. meta_query weird behaviour, static int will work, but not user data
  77. Need to search a custom field (ingredients, one long string per post), but want it to allow phrases/non-exact matches
  78. Compare ACF date field (if exists) and post date and order DESC
  79. Making WP_Query limit results by date before today where date is a meta_query
  80. Using OR relation in meta_query to check for a value before sorting by another
  81. Dynamically populate query source in Elementor post widget
  82. WP_Query not ordering correctly
  83. Meta query orderby meta_value_num sorting by role first
  84. meta query multiple values for the same key
  85. Sort custom post archives by a meta value from a different custom post type?
  86. Why does my numeric meta query work only on one meta key and not the other?
  87. Query to sort a list by meta key first (if it exists), and show remaining posts without meta key ordered by title
  88. meta_query to check all custom fields
  89. Custom post types – meta_query: search lesson which starts sooner
  90. post type => ‘any’ not applied my custom queries
  91. Compare meta key separation
  92. Advanced Post Display/Pagination/Ordering
  93. Selecting posts older than the current Unix epoch timestamp
  94. Query Posts Via WordPress URL
  95. How to Order Posts by Custom Fields?
  96. query specific posts according their custom fields, using sql SELECT
  97. How to add a prefix to existing custom fields over MYSQL query?
  98. Custom Post Type + Custom Meta Query Not Showing 2012 Posts
  99. Dynamic background image used in css after selector
  100. Get Posts ordered by a date custom meta field

Leave a Comment