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. WP_Query: getting posts where custom field exists
  27. Display posts with specific value first in query
  28. Get every post with value in meta key
  29. Custom Query: If One Post Object Field Value Is The Same As Another
  30. How to hide posts of a specific custom category in WordPress?
  31. change order of images attached to post
  32. Meta_query ‘compare’ => ‘LIKE’ not working?
  33. Diamond question mark in text after migrating content
  34. Modify date query by URL parameter using pre_get_posts and $_GET
  35. Is it possible to retrieve posts depending on meta_key LIKE condition? [duplicate]
  36. Loop through incrementing custom fields
  37. Custom search SQL Query to add custom field in result
  38. add_query_arg to compare and display events from a certain date
  39. Comparing 2 Decimal Numbers from custom fields and displaying posts
  40. tax query between operator like
  41. Meta query relation ‘OR’ not working as expected
  42. Why doesn’t my WP Meta Query return any results?
  43. WP_query multiple custom fields not working
  44. How to exclude custom fields from search queries?
  45. WP_Query meta compare must include ALL array values
  46. WP_Query () using taxonomy, custom post types
  47. Custom Query Fields – Altering Meta Value
  48. Multiple Custom Field Query
  49. Custom Query: query by post custom meta data
  50. Get array of posts based on custom field values
  51. Is it possible to compare the current time with a custom “start” and “end date
  52. How to update custom field of a posts in a particular category
  53. Searching with Multiple (Parallel) Criteria on Custom Fields?
  54. How to query posts by month based on date custom field?
  55. Custom Field Date Problem
  56. meta_query where the meta value is not the post title
  57. meta_query weird behaviour, static int will work, but not user data
  58. Need to search a custom field (ingredients, one long string per post), but want it to allow phrases/non-exact matches
  59. Compare ACF date field (if exists) and post date and order DESC
  60. Order by the first array within a meta_query
  61. Making WP_Query limit results by date before today where date is a meta_query
  62. Query ACF relationship field – Comparator IN – Value array
  63. multiple meta_query and orderby question
  64. ACF: How to query for a given value count of an array like field? (e.g.: How many rows has a `flexible_content` field?)
  65. get posts based on non-single metadata
  66. Problem with revisions only returning four results
  67. How to _GET multiple value checkbox WP_Query in Custom Toxonomy / Custom Fields
  68. Search & column order by meta value in admin
  69. WP Query from two Custom Post type fields as statement
  70. How do i create a custom post query when the meta value is an array?
  71. Using OR relation in meta_query to check for a value before sorting by another
  72. Woocommerce products search with custom fields
  73. How to save multiple values with same meta_key, each value linked to another tag id
  74. How to improve my non-unique metadata MySQL entries?
  75. WP Query – grouping posts by same meta key, adding together values from another key
  76. Dynamically populate query source in Elementor post widget
  77. Woocommerce Get Orders By Meta Value
  78. meta_query is overriding default search
  79. Trouble with serialized metadata
  80. WP_Query not ordering correctly
  81. How to do WP_User_Query for Nested Array value Inside Nested Array field
  82. Meta query and compare “!=” not working as expected
  83. Comparing Meta Field date in WPQuery using Meta_Query?
  84. Meta query orderby meta_value_num sorting by role first
  85. WP meta_query args not working in function
  86. Filtering posts by ACF meta query
  87. Getting posts by custom field value
  88. meta query multiple values for the same key
  89. Sort custom post archives by a meta value from a different custom post type?
  90. WP_Query, ACF field and array
  91. Why does my numeric meta query work only on one meta key and not the other?
  92. Query to sort a list by meta key first (if it exists), and show remaining posts without meta key ordered by title
  93. Strange results from WP_Query
  94. meta_query to check all custom fields
  95. Order by Date Custom Field
  96. Custom post types – meta_query: search lesson which starts sooner
  97. WP Query. Ordering posts by another post types meta
  98. post type => ‘any’ not applied my custom queries
  99. searching by keywords in post’s metas or pagination links problem
  100. Slow wp_posts and wp_postmeta query using Advance Custom Fields

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)