I have 2 channels, artists and artwork.
I want to display the artwork entries where their parent entry, in the artists channel, has the status set to 'open'.
I would like to show all the fields from the artwork entry.
As I can't search against the parent field status using the channel entries tag i presume I will have to use the query module, which I am happy to do.
What query would I use to show the entries?