src/test/resources/runtimets/queries/channel/drop_channel_check_datasets/drop_channel_check_datasets.3.query.aql

use dataverse channels;

for $result in dataset Metadata.Channel
for $x in dataset Metadata.Dataset
where $x.DatasetName = $result.SubscriptionsDatasetName
or $x.DatasetName = $result.ResultsDatasetName
return $x;