- I have 2 customs post type : "Artist" and "Concert",
- the "Concert" custom post type is the child of the "Artist" custom post type,
- the "Artist" custom post type has a "genre" taxonomy.
What I'm trying to do (for instance): list all the concerts which belong to artists of the "pop" genre.
Here is the query of my dream:
SELECT * FROM posts WHERE post_type = "concert" AND post_parent_term = "pop"
I think currently there is no such thing as post_parent_term, hope I'm wrong ... (I know i can add the "genre" taxonomy to the "Concert" custom post type and voilà! But I'm really curious to know if there is another way to achieve that).
Thanks by advance.