Tax query AND/OR meta query [duplicate]

It’s not possible without a more custom query/filter.

I have achieved it with a filter (code taken from this guy on this gist – https://gist.github.com/elvismdev/61f8509eff8abcc21ef84154b74fbf56)

function f1_egpaf_meta_or_tax( $where, \WP_Query $q ) {
    // Get query vars.
    $tax_args = isset( $q->query_vars['tax_query'] ) ? $q->query_vars['tax_query'] : null;
    $meta_args = isset( $q->query_vars['meta_query'] ) ? $q->query_vars['meta_query'] : null;
    $meta_or_tax = isset( $q->query_vars['_meta_or_tax'] ) ? wp_validate_boolean( $q->query_vars['_meta_or_tax'] ) : false;

    // Construct the "tax OR meta" query.
    if ( $meta_or_tax && is_array( $tax_args ) && is_array( $meta_args ) ) {
        global $wpdb;
        // Primary id column.
        $field = 'ID';
        // Tax query.
        $sql_tax  = get_tax_sql( $tax_args, $wpdb->posts, $field );
        // Meta query.
        $sql_meta = get_meta_sql( $meta_args, 'post', $wpdb->posts, $field );
        // Modify the 'where' part.
        if ( isset( $sql_meta['where'] ) && isset( $sql_tax['where'] ) ) {
            $where  = str_replace(
            [ $sql_meta['where'], $sql_tax['where'] ],
            '',
            $where
            );
            $where .= sprintf(
            ' AND ( %s OR  %s ) ',
            substr( trim( $sql_meta['where'] ), 4 ),
            substr( trim( $sql_tax['where'] ), 4 )
            );
        }
    }
    return $where;
}
add_filter( 'posts_where', 'f1_egpaf_meta_or_tax', PHP_INT_MAX, 2 );

Then, just add '_meta_or_tax'=>trueto theargsarray passed toWP_Query()`

Related Posts:

  1. Nested meta_query with multiple relation keys
  2. Does tax_query really beats meta_query in all situations?
  3. WooCommerce: filter by parent product’s taxonomy and product variation’s meta data
  4. Querying by taxonomy vs Querying by Custom fields Speed Comparison
  5. Tax query clause inside a meta query clause?
  6. Is it a good idea to improve meta query performance by adding tax query?
  7. Query with meta_query and tax_query together not working properly
  8. How to search for meta_query LIKE or tax_query LIKE and grab these posts on search results?
  9. Is it possible to add relation between meta_query and tax_query?
  10. WP_Query for a taxonomy value OR a custom post type meta field
  11. Extending WP Query: Custom geolocation meta values work, but tax_query breaks
  12. Custom query with custom filtering returning incorrect results
  13. How to query posts based on lat-lng coordinate as post meta?
  14. Set Alias for meta_query arguments in get_posts()
  15. Add indexing to meta_value in wp_postmeta
  16. Is it possible to orderby multiple meta_keys when using meta_value_num?
  17. Custom WP_Query order by post_meta and (author) user_meta
  18. Using custom meta_query with relation not working as expected
  19. Perform query with meta_value date
  20. WP_Query meta_query where meta value ends in space
  21. Nested query inside Logical operator OR not working in meta_query
  22. What is an efficient way to query based on post_meta?
  23. datetime picker, timestamps and meta queries
  24. How do I create my own nested meta_query using posts_where / posts_join?
  25. How to order a post type with meta_value_num and if meta_value_num does not exist then order by date
  26. Compare two meta-fields in a wp_query (where meta-field-A is larger than meta-field-B)
  27. How to combine tax_query and date_query in WordPress
  28. Exclude post on loop by multiple meta key value
  29. Using tax_query reverses my post_type argument in a custom WP_Query
  30. get complex results set according to category structure
  31. Order posts by meta value and Date
  32. Query sticky posts with thumbnails
  33. WP_Query tax_query problem
  34. Order WP Query posts by custom order calculated from post meta values
  35. how to speed up a complex wp_query?
  36. Meta query with order by another custom field
  37. How to query for custom field within Gutenberg block from outside of that post? [closed]
  38. Empty tax_query array returns an empty array
  39. Meta Query for specific months
  40. Meta query with JSON value
  41. Get meta info related to current post
  42. Creating arguments from loop for WP_Query meta_query
  43. Order a query result by a numeric meta key even if it does not exist, but put the posts with meta key first
  44. Single meta_query query using OR instead of AND in request’s WHERE statement
  45. ACF Date Based wp_query
  46. How to do meta_query for attachments?
  47. SQL: What is wrong with the following query (generated by WordPress WP_Query, ordering prices)
  48. Using meta_query with multiple keys and compare values
  49. Mysql query and order meta value
  50. Why isn’t my `meta_query` array functioning properly?
  51. Overwrite YoastSEO meta-tags with another page’s [closed]
  52. How to orderby multiple meta fields if some fields are empty
  53. meta_query BETWEEN, but the range is stored in the custom field
  54. Suggestions on making this query/code more performant
  55. Is it possible to set specific posts to show first in a query?
  56. Orderby listing issue
  57. Order ascending is ignored in meta query?
  58. database query with more than a couple meta hangs and doesn’t complete
  59. Make meta query treat meta_value as 1 or 0
  60. Finding WordPress Posts assigned to multiple categories
  61. WP Query Meta Value – How To Identify Specific, Unique Values?
  62. Sort by presence of thumbnail
  63. Get posts in taxonomy randomly
  64. it’s possible make a WP_Query with math operations?
  65. Sorting search results with custom dropdown
  66. Meta query with compare by more than 2 fields
  67. WP_Query meta compare must include ALL array values
  68. meta_query returning excluded result
  69. What’s missing in this wp_query and meta_query
  70. meta_query weird behaviour, static int will work, but not user data
  71. Any quicker alternative for WP_Query “NOT IN”
  72. Tax Query on product_cat using NOT IN as operator does not exclude that category
  73. ACF: How to query for a given value count of an array like field? (e.g.: How many rows has a `flexible_content` field?)
  74. get_posts query is taking about 40 seconds to execute
  75. Trouble with serialized metadata
  76. meta_query order by date present -> future then show null
  77. list all post who have mutual taxonomy as current taxonomy!
  78. meta_query compare > not working
  79. meta_query is not allowing to show posts when querying multiple arguments in a WP_Query
  80. Speed up WP_query with meta comparing dates
  81. Meta Query if Values Don’t Exist
  82. Saving custom fields for WP_Query to retrieve
  83. In Product Category archives how to show Posts having same/similar prod_cat slug structure?
  84. How to show all the associated posts with specific date of data metabox?
  85. Is it possible to search for a string in posts OR postmeta?
  86. Custom query for tag and custom tag from 2 post type
  87. Filter posts/pages by user_role array
  88. WP_Query with MetaQuery issue
  89. WP_Query Posts by Metadata from Option Tree
  90. Custom loop – Isolating post meta output depending on current query taxonomy terms
  91. WP_Query with meta_value_num and meta_query not paged correctly
  92. Post Query not working after updating to 4.1
  93. Orderby Meta Value and Query from Meta Query
  94. The sorting of posts by a meta_query with two keys fails while separated as single queries it works
  95. Sort posts in dashboard using custom field; also include posts where field isn’t set
  96. Sort Posts with custom meta key by default which is currently set as optional
  97. WP_Query with several meta_query-statements and order by meta_value
  98. meta_query in wp_query not working as expected
  99. Output ACF field dynamicaly within a taxonomy loop [closed]
  100. get_post_meta bringing back results, but $wpdb->postmeta doesn’t