Read orders for a subscription
Gets all orders for a given subscription. Use the SubscriptionOrders table and pass SubscriptionId='...' in the WITH clause.
SELECT * FROM Orders
WHERE SubscriptionId_1='iBPfMFS6TZSxrLzSOrq8PQ'
OR SubscriptionId_2='iBPfMFS6TZSxrLzSOrq8PQ'
OR SubscriptionId_3='iBPfMFS6TZSxrLzSOrq8PQ'
ORDER BY OrderDate