SQLAI.ai

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