RIDGELINE / QUERY STUDIO / QUERY #4781

EDITORPOSTGRES · ANALYTICS

SELECT o.id, o.customer_id, o.total, p.status FROM orders o JOIN payments p ON p.order_id = o.id WHERE o.created_at > now() - interval '24 hours' AND p.status IN ('pending','authorized') ORDER BY o.created_at DESC LIMIT 500;

Run query⌘⏎ to run