Hi all,
As per the title I’m trying to compile a list of artists who are from a specific area ID where the artist has a release with a date within a specified period. From what I’ve been able to see from my queries so far I can’t simply query releases by area because this includes artists who aren’t from that area and simply had a release there. So one way to do this would be to search by artists from a specific area and then loop through their releases finding any that have a release date between my specified period, but this isn’t very efficient. I’ve been trying to do this using HTTP requests as I don’t have the skillset to replicate the postgres database and run my own SQL queries. Is there a more efficient way to achieve what I’ve described? Thanks!