[wp-hackers] Querying posts for all associated term_ids?
mikeschinkel at newclarity.net
Sat Sep 4 20:32:59 UTC 2010
I am trying to figure out if it is possible to use the WordPress database API without having to add hooks to get the distinct list of term IDs from a given taxonomy that are associated with posts of a given post type?
I looked and could not find any thing available in WordPress core even though it seems that I must be missing something. Here's the SQL code that achieves what I'm after:
FROM wp_posts p
INNER JOIN wp_term_relationships tr ON p.ID = tr.object_id
INNER JOIN wp_term_taxonomy tt ON tt.term_taxonomy_id = tr.term_taxonomy_id
FYI this came up in me trying to answer this question:
Thanks in advance.
More information about the wp-hackers