Advanced search: roles and multiple taxonomies
I was able to solve my problem with this query, although I bet it can be more efficient (I just couldn’t figure out how to do it.) SELECT DISTINCT p.* FROM wp_posts p LEFT JOIN wp_usermeta um ON p.post_author = um.user_id LEFT JOIN wp_postmeta pm ON p.ID = pm.post_id INNER JOIN ( SELECT txrm.object_id FROM … Read more