i would like to query all profiles in the system having additional fields for each service the profile is subscribed to. In every field i would like to have the values 0 for no and 1 for yes.
I tried to have two queries, one querying all profiles and a second one querying the subscribers to a specific service but i can't find a way to flag the first query result with the population of the second queries' result as yes or no.
Also couldn't alternatively find a way searching for the subscriptions directly in the first query as additional data, but failed.
What is the most suitable way of doing that?
Thank you very much in advance for your contribution and help,