-- Identical statement in every phase; deterministic ordering breaks all ties.
SELECT order_id, tenant_id, status, created_at, total_cents
FROM proof.orders
WHERE tenant_id = 42 AND status = 'open'
ORDER BY created_at DESC, order_id DESC
LIMIT 50;
