You can use WordPress’s tax_query arg when fetching posts to achieve what you’re trying to do, this is also easily extendable with more than one taxonomy.
$query = array(
'post_type' => $YOUR_POST_TYPE,
'posts_per_page' => -1 // get all
'tax_query' => array(
'relation' => 'OR'
)
);
$query['tax_query'][] = array(
'taxonomy' => 'YOUR_TAXONOMY',
'terms' => $ARRAY_WITH_TERMS,
'field' => 'ID',
'operator' => 'IN'
$query['tax_query'][] = array(
'taxonomy' => 'YOUR_TAXONOMY_2',
'terms' => $ARRAY_WITH_TERMS_2,
'field' => 'ID',
'operator' => 'IN'
$posts = query_posts( $query );
Might this be what you’re looking for?
Related Posts:
- Multipart/formatted MySQL query problem
- wpdb COALESCE won’t work
- Get posts from category with custom query
- Valid SQL query return empty
- mysql query – how to escape apostrophe?
- Updating with $qpdb->query() always returns 0 rows affected
- How to return count of custom post type posts with a specific custom field value via $wpdb?
- WordPress Mysql query and Duplicate
- Mysql query and odd results
- Return only Count from a wp_query request?
- Differences between wpdb->get_results() and wpdb->query()
- wpdb get posts by taxonomy SQL
- How many WordPress SQL Queries per page?
- Custom $wpdb Query for Custom Post Type by Category
- Can’t pass table to $wpdb->prepare
- $wpdb->get_var not returning a result
- Are database queries created using WordPress filters protected from SQL injection?
- Most effective use of DB querys
- $wpdb->query() vs. $wpdb->get_results() vs. phpMyAdmin
- Mysql / WordPress killing my server with 80k users [closed]
- Slow meta_query with about 4 milion record on wp_postmeta
- Select User by Joining Multiple Meta Value Results
- mySQL query. ORDER BY meta_key
- $wpdb doesn’t appear to work on page inside of a plugin
- Strange string in console from wpdb query
- Using $wpdb->update but confused on the WHERE in and SET
- Update slug (URL) of pending posts via phpMyAdmin
- My SQL function to change user_name
- You have an error in your SQL syntax – Help with query
- What’s wrong with my $wpdb prepare?
- Make one query for adding entries to database
- Why is variable not working on custom sql query using wpdb?
- MySQL variable in query
- How to execute a SQL-query which contains multiple queries using $wpdb->query?
- Alter a specific query on WordPress
- Advanced SELECT query with condtional statements
- how would I create a custom query to get all users, and a related post based on a postmeta field?
- Help with MySQL to $WPDB query
- SQL query to select posts from multiple categories
- How do I see the mysql query generated by get_posts( $args )?
- wpdb->term_taxonomy count posts from both published and private posts?
- wpdb print all post meta
- Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
- MySql Query very slow
- Searching With Apostrophe
- wpdb query problem to access previous 3 days posts
- WordPress Query wp-terms SLOW
- How to write: $wpdb->update having WHERE NOT value pair in the array
- I can’t figure out what’s wrong with this statement. $wpdb->query update
- Use mysql_query instead of $wpdb query
- Custom Query – Based on user input
- Custom WordPress Table wpdb
- Custom SQL Query passing array to WHERE p.id
- Best practice to limit results in get_row()?
- Placing a widget with $wpdb query
- Custom Query returns array, but I can’t see it’s elements
- Ideas how to search & replace post_content when string contains a newline?
- Query Column of Specific ID from Database Table
- Query the WordPress database to get data together with replaced information
- $wpdb->prepare affecting the query?
- Optimize slow SQL query for multiple meta values
- prepare function sql safe method
- WordPress Insert not working with ajax
- How do I query for posts by custom meta and those that have been stickied?
- Formatting a date/time returned from a custom $wpdb query
- How to delete all images from code in all post_content
- How do I get specific readable results from this query and array results
- I want to get on those users their meta value are like “AGENT” .. but this query is not working
- Delete oldest wordpress post (SQL query)
- Displaying data from custom table
- Get 2 meta values from meta key column
- PHP Fatal error: Uncaught Error: Call to a member function insert() on null
- SQL query to delete users with multiple meta keys and comments
- WordPress Database Query works in phpMyAdmin but not in the code
- OR condition not working
- Trouble migrating custom post types from non-wordpress cms
- implementing my wp_query using $wpdb class
- Are there any best practices for creating a Like/Favourite feature in WordPress using custom MySQL tables and without any plugins?
- Exclude Posts from a Widget
- Fastest and most efficient SQL query to check if UID exists
- Performance of wp_get_attachment_image_srcset() and wp_get_attachment_image_url()
- Use $wpdb->get_results with filter based on array
- $wpdb query for price in custom field value
- Display result from custom post meta query
- Wpdb empty result only if language is Russian
- Run an update query in a function
- How to fix this insert? Don’t work for me!
- Function returning queried meta value based on current post ID
- Problem on wpdb queries, wp_insert_post, wp_insert_user etc. The query runs twice
- Update vs Insert logic but the last key is always inserted?
- There is way to improve this query? wordpress get post data and some meta data
- $wpdb: how to use a query as a base for another query?
- Wpdb generates too many queries
- Custom Query for searching through custom fields
- sql for querying post and their category
- How to reference same column name but different table in custom db query
- Retrieving custom field array value through db query
- How to get one result using wpdb class?
- Delete query won’t run
- update $wpdb one query