How to get the parent’s taxonomy?

What I’m trying to do (for instance):
list all the concerts which belong to
artists of the “pop” genre.

You can do it in two steps:

// 1. Get all the pop artist IDs
$artist_ids = get_posts( array(
  'fields' => 'ids',
  'post_type' => 'artist',
  'genre' => 'pop'
) );

// 2. Get all the concerts associated to those artists
$artist_ids = implode( ',', array_map( 'absint', $artist_ids ) );

$concerts = $wpdb->get_results( "
  SELECT * FROM $wpdb->posts
  WHERE post_type="concert"
  AND post_status="publish"
  AND post_parent IN ({$artist_ids})
  ORDER BY post_date DESC
" );

There’s a post_parent argument in WP_Query, but it doesn’t accept an array, hence the direct query.

Leave a Comment