I ended up figuring this out by realizing that I could build a list of coauthor id’s using the template tags that ship with the coauthors plugin. Next, I observed how WordPress core does joins to query by taxonomy, but var_dumping the posts_request on a term archive page. At that point, I just had to swap in my coauthor ID’s and it works great.
Related Posts:
- How to use $wpdb to delete in a custom table
- get_results on large datasets
- Is there a (better) way to access $wpdb results?
- Using $wpdb generates DB error
- How do you use prepare when asking for a list of id’s
- how to execute different sql query in non-sanitized $wpdb->get_results function
- WPDB update row with != in where clause
- How to update records using $wpdb?
- Need help writing a $wpdb query
- show badge with count for pending items in custom post type
- WP Sql query multiple where clause
- WordPress SQL query – returning ‘true’ ‘false’ or ‘null’
- Modify the structure of data returned by $wpdb
- Syntax for $wpdb->prepare when searching in two columns
- Confused by $wpdb->prepare
- How to display user_nicename and usermeta values by custom query in WordPress?
- Optimizing WordPress Queries – Removing Group By ID
- How can I combine one field using wpdb and group by?
- $wpdb->prepare with ON DUPLICATE KEY UPDATE
- how to use $wpdb->prepare to update a custom table
- WPDB Placeholders and second argument for prepared statements
- Increment integer field in database when WHERE needs to be dynamic [closed]
- Custom SQL query ORDER BY term_order
- Custom $wpdb returns unexpected time based results
- How to left join meta in queries [closed]
- wpdb->get_row is selecting the variable as a column name
- CREATE TABLE with dbDelta does not create table
- $wpdb query outputs php code instead of executing it
- wpdb query not working
- WordPress wpdb->insert returns int(0) => doesn’t insert anything, no errors!
- WPDB SQL Ignore `post_status` Parameter
- how to list all post that are in the custom taxonomy using $wpdb
- WPDB SQL query SELECT from category
- How to use WHERE NOT EXISTS query to avoid duplicate entry using $wpdb to save in custom table?
- Creating an Angular factory from custom database table
- wpdb->update update the entire table instead of one row
- How do I update post based on meta_key in another table?
- How to set up prepared query using IN statement
- Custom database query to validate data
- Creates only one table and not the other
- Protect custom form from SQL injection
- looking for a way to allow users to backup the plugin db data(save as)
- SQL Query to select post title & post ID from a particular category
- Get comments after specific date
- query using wpdb in wordpress gets me no result
- Get count of rows based if column exists in two different tables
- query_vars doesn’t return query string (trying to get data from $wpdb)
- $wpdb->get_row() only returns a single row?
- what is the way to see the currently executing query in wordpress?
- $wpdb->last_error doesn’t show the query on error
- Multipart/formatted MySQL query problem
- How to make an activities stream mixing posts and comments?
- Delete/replace img tags in post content for auto published posts [closed]
- What does wp_update_post() do that the $wpdb class does not?
- wpdb-> not adding prefix to custom table
- WPDB: how to get the value of a field in a custom database table
- I am not understandinhg $wpdb->prepare correctly
- How to save html and text in the database?
- XOR functionality for meta_query
- Using WPDB class
- How can I migrate mysql_fetch_array to $wbpdb?
- wpdb get_results() and prepare when to use prepare?
- how to delete 30 day old data using PHP [closed]
- Return XML of Post Metadata
- Querying wpdb using PHP
- Problem in inserting row to custom database table
- sanitize_text_field and apostrophe problem
- Is there a WP function to get taxonomy name from taxonomy_term_id?
- wpdb query problem to access previous 3 days posts
- wpdb updating record in wordpress with json adds extra array elements
- How to display a specific category using a custom Query?
- AWS Bitnami WordPress – SELECT command denied to user
- PHP Fatal Error – $wpdb a non-object?
- List of ways to access WordPress database?
- How to optimize multiple insert into wordpress database
- $wpdb->prepare was called incorrectly when inserting multiple records
- How to protect a script execution on WordPress?
- how to connect to another database in wordpress
- $wpdb->insert() doesnt work anymore
- Perform a function when a user clicks register button
- $wpdb->get_var next var?
- How do I modify this wpdb query to include posts that have a post_status of publish and draft?
- Can’t find out why dbDelta dosen’t create my table
- How to get image path from id using SQL
- How to store sensitive user data (passwords)
- Check if Value Exists in Database, adding row details to variables and echoing result
- wpdb discards duplicate column names?
- How to Update multiple rows using $wpdb->update
- 2 $wpdb queries causing error Table ‘wp_postmeta’ is specified twice, both as a target for ‘UPDATE’
- Unable to use $wpdb in WordPress
- How to display specific data from custom database table in WordPress
- $wpdb post type and term query only works when there are no dashes or spaces in the term slug and title
- Why is an empty result an error? ( $wpdb->get_row )
- get_row returns empty when data exists
- wpdb->update error
- Wpdb generates too many queries
- Using $wpdb to update current post
- DBDelta: “table doesn’t exist” for a table that was just created
- $wpdb The query does not contain the correct number of placeholders
- $wpdb:insert, more arguements in $format array than in $data