Query by multiple meta elements not seeming to work – wordpress is timing out

I don’t think you’ll be able to do this in a single query – what you seem to need is multiple relationships between conditions, and as it works currently, meta_query doesn’t let you do that. I googled it a bit and found others saying it doesn’t, but I also went into the core code and looked at the WP_Meta_Query class. I can tell you definitively, you can’t create multiple relations the way you need.

What I would suggest is to run a query that just grabs posts with my_featured_post = 1, as a meta query, and then get all the ids of those posts. Then run another query passing those ids to post__in – and running a meta query one for photo-image_page_id>0 OR photo-image_post_id >0

Related Posts:

  1. meta_query with meta values as serialize arrays
  2. Use REGEXP in WP_Query meta_query key
  3. How to query posts based on lat-lng coordinate as post meta?
  4. Set Alias for meta_query arguments in get_posts()
  5. How to Compare Two Meta Fields
  6. Is it possible to orderby multiple meta_keys when using meta_value_num?
  7. Getting attachments by meta value
  8. Using custom meta_query with relation not working as expected
  9. WP_Query meta_query where meta value ends in space
  10. Nested query inside Logical operator OR not working in meta_query
  11. What is an efficient way to query based on post_meta?
  12. WP_Query not working as expected for attachments and custom meta_query
  13. How do I create my own nested meta_query using posts_where / posts_join?
  14. WooCommerce: filter by parent product’s taxonomy and product variation’s meta data
  15. How to order a post type with meta_value_num and if meta_value_num does not exist then order by date
  16. Meta Query querrying several post types based on ACF fields is broken after update to WP 4.1
  17. Exclude post on loop by multiple meta key value
  18. How to get sum of meta_values of a meta_key in wp_query according to conditions
  19. How to query ‘posts_per_page’ to display a different blog posts index template?
  20. Order By Multiple Meta Fields
  21. meta_key and meta_value not working together
  22. Advanced WP Query hogs the SQL server
  23. Order posts by meta value and Date
  24. Query sticky posts with thumbnails
  25. How to get user_id from wordpress database inside ajax function?
  26. Meta query with order by another custom field
  27. How to query for custom field within Gutenberg block from outside of that post? [closed]
  28. WP_Query with multiple meta fields filter?
  29. How to combine meta_query and post__in in WP_Query
  30. Meta query with JSON value
  31. Get meta info related to current post
  32. How to orderby meta_value_num with dollar ($) sign
  33. Order a query result by a numeric meta key even if it does not exist, but put the posts with meta key first
  34. Single meta_query query using OR instead of AND in request’s WHERE statement
  35. Meta Query Array Error 500
  36. How to do meta_query for attachments?
  37. SQL: What is wrong with the following query (generated by WordPress WP_Query, ordering prices)
  38. Get attachment by meta_key value
  39. Using meta_query with multiple keys and compare values
  40. Why isn’t my `meta_query` array functioning properly?
  41. Overwrite YoastSEO meta-tags with another page’s [closed]
  42. How to orderby multiple meta fields if some fields are empty
  43. meta_query BETWEEN, but the range is stored in the custom field
  44. Suggestions on making this query/code more performant
  45. Is it possible to set specific posts to show first in a query?
  46. Order by meta value (numeric value lower to higher)
  47. Large AND OR query timing out
  48. Order ascending is ignored in meta query?
  49. WP_Query with different postmeta filter for each categories
  50. Slow WP_Query with ‘OR’ on meta_query
  51. Make meta query treat meta_value as 1 or 0
  52. Is this meta query problematic?
  53. WP Query Meta Value – How To Identify Specific, Unique Values?
  54. Order by meta_key doesn’t work
  55. Appending to existing WP_Query’s meta_query if exists
  56. Multiple meta_key ordering with pre_get_posts
  57. Get meta_value of a specific meta_key from all posts belonging to a specific custom type
  58. Custom query filter by ACF date custom field
  59. Nested array issue in meta_query
  60. Error in meta_query not get result
  61. Meta query with compare by more than 2 fields
  62. How to get current page nearest parent id?
  63. meta_query with array as value with multiple arrays
  64. Why doesn’t my WP Meta Query return any results?
  65. WP_Query meta compare must include ALL array values
  66. meta_query returning excluded result
  67. meta_query weird behaviour, static int will work, but not user data
  68. Creating a query that get all posts but places meta items first
  69. get_posts query is taking about 40 seconds to execute
  70. wp query to use both author id and meta_query
  71. meta_query – check for multiple meta values in key which holds an array of values
  72. WP_Query for a taxonomy value OR a custom post type meta field
  73. Searching for a specific month in a metadata saved as Timestamp (Wp_Query)
  74. Meta query orderby meta_value_num sorting by role first
  75. WP_Query on custom key and value
  76. Get posts having meta value between two numbers
  77. How to set meta_query if get_post_meta returns nested array for that key? [duplicate]
  78. Sorting with meta_query and multiple, optional meta keys
  79. Query by meta value (add a dropdown of all values)
  80. meta_query is not allowing to show posts when querying multiple arguments in a WP_Query
  81. Speed up WP_query with meta comparing dates
  82. Meta Query if Values Don’t Exist
  83. How to show all the associated posts with specific date of data metabox?
  84. WP_Query returns empty if meta_query has more than 7 values
  85. Is it possible to search for a string in posts OR postmeta?
  86. WP_Query Posts by Metadata from Option Tree
  87. WordPress meta_query not working
  88. Using orderby with 2 meta keys
  89. Passing conditional arrays to WP_Query() [closed]
  90. Why is WP_Query’s meta_query not filtering results?
  91. meta_query in wp_query not working as expected
  92. Get all user with both meta_value
  93. Using ‘meta_query’ with the ‘pre_get_posts()’ hook disables searching for post titles
  94. WP query with multiple custom meta not respecting orderby
  95. Get posts using multiple values from ACF checkbox as meta query wordpress
  96. WP Query returning all posts when Meta_query is null
  97. Passing a variable containing a comma separated list of values in a meta-query
  98. Complicated `orderby` based on text in custom field
  99. meta_query post_date not returning results
  100. WP Query: orderby with one meta key, but multiple values