WP_Query
does not handle this sort of query: use two instances of WP_Query
, and then combine the results.
Untested code:
$posts = new WP_Query( array(
'post_type' => 'post',
) );
$post_ids = array_column( $posts->posts, 'ID' );
$author = new WP_Query( array(
'post_type' => 'any',
'author' => 123,
'post__not_in' => $post_ids, // prevent duplicates
) );
$combined = array_merge( $posts->posts, $author->posts );
There are filters inside of WP_Query
that you can use to modify the SQL statement (ex: posts_where
), but need to be careful as it can impact other queries.
Related Posts:
- WP_Query with “post_title LIKE ‘something%'”?
- Pagination with custom SQL query
- Whats the difference between post_limits and pre_get_posts?
- Using OR conditions in meta_query for query_posts argument
- Is it possible to wrap Geo Location search around WP_Query?
- Is it possible to select against a post’s parent’s fields with WP_Query?
- Extending WP_Query — Optimise SQL query
- How to filter sql only for a specific post type
- How to make an activities stream mixing posts and comments?
- SQL Statement generated by WP_Query not producing expected results
- What is an efficient way to query based on post_meta?
- SQL query equivalent to WP User Query
- Recommended way to drop a pending query (in pre_get_posts)?
- how to retrieve specific product attribute value in an sql query?
- Filter WordPress posts by between parameter
- SQL User Query by Multiple Roles using PHP
- Advanced WP Query hogs the SQL server
- SELECT * FROM $wpdb->posts WHERE ID > 160
- How To Get Some Data From WordPress Database Using WordPress $wpdb Query?
- Query post with meta_query where date is not in future
- WP User Query get all authors with last name starting with specific letter
- Select from wp_post and multiple meta_value from wp_postmeta
- How to correctly pass values to wpdb->prepare()?
- Sort users by “birthday” using WP_User_Query
- $wpdb select date range of posts
- How To Fix WP Query Returns Results But Shouldn’t?
- List of the years with posts presented
- SQL: What is wrong with the following query (generated by WordPress WP_Query, ordering prices)
- Slow WP_Query for custom post type
- Complex WP SQL Query
- Query that loads a custom type AND posts whose ids are not inside those custom types custom fields
- Optional Meta Query
- Sorting events by descending date, and ascending time if multiple events on a date
- Editing the default wordpress search
- WP Query related posts by tags
- Order by summing multiple values
- How to extract specific post
- Woocommerce – Changing the order of the upsell products [closed]
- Changing sort order for presentation by Jetpack infinite scroll
- Include data from custom table in WP_Query
- wordpress ajax relationship query
- How to pass orderby params to $wpdb->prepare()?
- Debugging wp_query orderby for taxonomy
- Is it possible to query from external database? [duplicate]
- Include post content of linked posts in search
- Make a SQL query with wpdb in WordPress
- Getting additional columns from sql
- List of ways to access WordPress database?
- Getting rid of unwanted nonSQL syntax characters when debugging a query
- How I can change the condition or compare operator for WP_Query in pre_get_posts
- Query where ANDing slug values not working
- Slow Query On Search
- WP_Query: apply an SQL function to meta fileld value
- How to avoid filling up an array each time I run a WP_query?
- How to SQL query posts IDs by categories AND authors?
- Randomly select one of last 3 posts
- SQL query injection with fifu image
- Passing a SQL query to the WP Query
- WP_Query() not working as expected
- WP Query – grouping posts by same meta key, adding together values from another key
- Any way to use FETCH_KEY_PAIR with $wpdb?
- What is the equivalent WP_Query of a SQL Query?
- Translating WP query into to SQL query
- Filtering posts for unique titles, only the most recent
- Slow wp_posts and wp_postmeta query using Advance Custom Fields
- How to search CPTs in draft using get_page_by_title()
- Calculating efficiently on large amount of data generated by wp_query
- What argument does my function need to echo get_results() query results
- Include post_status check within $wpdb query
- Find by post_meta, then sort by post_meta, then sort by date (wp_posts)
- WP Query to order posts by multiple meta fields
- Custom WP_Query with SQL directives for getting posts by authors and terms
- How to return value from sql and display it
- orderby in WP_query doesn’t works
- WP_Query with several meta_query-statements and order by meta_value
- wpdb LIKE request shows all database data
- Convert a WP Query into a simpler SQL query to fetch only COUNT of posts
- Add custom argument to WP_Query and modify SQL where clause
- Group By query based on Custom Field
- Using a custom WP_Query with get_template_part loop
- Is it possible to orderby multiple meta_keys when using meta_value_num?
- Pagination wont work with search results template [duplicate]
- Sort by meta key on archive page
- Retrieve or Query Pages by ID
- Complex date range with WP_Query and BETWEEN
- Attachment changing page’s permalink – $post not resetting?
- List custom taxonomy terms sharing posts with a term from a second custom taxonomy
- How can I filter by slug depending on language selection
- Advanced WP_Query with meta_query, orderby?
- How to search for meta_query LIKE or tax_query LIKE and grab these posts on search results?
- How to create dynamic value in WP_Query meta_query
- How to search by slug and old slug in single API
- What code to use in an array to call the current sub-category?
- Order by meta date with a thousanth of a second defaults to post order
- How to debug none working search query?
- Show All with Isotope
- active link for most recent post on vertical tabs
- option select form always deleting the sql query
- Send a variable with a URL and get a variable with Wp query
- Showing Counts on Comment List with Custom Query