all active products with their prices
SELECT p.id, p.name, p.description, p.image, p.stripeId, pr.unitAmount, pr.recurring, pr.type, pr.metadata, pr.currency, pr.stripeId
FROM Product p
JOIN Price pr ON p.id = pr.productId
WHERE p.active = TRUE AND pr.active = TRUE;
- Public
- ·
- Wed, 25 Jan 2023 11:36:47 GMT