I'm trying to do a custom query which is outside the scope of a single
WP_Query, I think I should be using
$wpdb but my SQL is a bit ropey. Also I only need the post IDs returned not post objects.
Basically I need to find all posts with a meta value of
$foobar whose parent post has one or more specific terms. I.E:
postmeta has a field
my_custom_field with a value
post_parent has the
RETURN the post's IDs as an array.
Any pointers would be great. Thanks!