SELECT s.id, s."userId", u.email, s."planId", s."planType", s.status, s."isYearly", s."startDate", s."endDate"
FROM subscriptions s
LEFT JOIN users u ON u.id = s."userId"
ORDER BY s."createdAt" DESC
LIMIT 10;