I just tested Co Authors Plus after upgrading to WordPress 4.6. You’re right, this is an issue with CoAuthors Plus.
I got the following error when doing the query:
WordPress database error: [Not unique table/alias: ‘wp_term_relationships’]
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_taxonomy ON ( wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id ) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (1) ) AND ((wp_posts.post_author = 1 OR (wp_term_taxonomy.taxonomy = ‘author’ AND wp_term_taxonomy.term_id = ‘5’))) AND wp_posts.post_type = ‘post’ AND ((wp_posts.post_status = ‘publish’)) GROUP BY wp_posts.ID HAVING MAX( IF ( wp_term_taxonomy.taxonomy = ‘author’, IF ( wp_term_taxonomy.term_id = ‘5’,2,1 ),0 ) ) <> 1 ORDER BY wp_posts.post_date DESC LIMIT 0, 1
The issue is that CoAuthors Plus uses a custom taxonomy called ‘author’ for assigning multiple authors to a post. If you queried by just author or just category the shortcode still works. But when you query for both, CoAuthors Plus is not properly accounting for the two separate taxonomies (‘author’ and ‘category’).
This isn’t an issue in Display Posts Shortcode. If you do a standard WordPress query you get the same issue: https://gist.github.com/billerickson/c2422064a108e777dd15fa44dfd60306
I’m going to see if I can reach out to the author of CoAuthors Plus.
(By the way, once this is worked out you might want to use the CoAuthors Plus Addon to show all the authors in a shortcode).