SELECT o.id, o.placed_at
FROM orders o
LEFT JOIN invoices i ON i.order_id = o.id
WHERE i.order_id IS NULL
ORDER BY o.placed_at;
SELECT o.id, o.placed_at
FROM orders o
LEFT JOIN invoices i ON i.order_id = o.id
WHERE i.order_id IS NULL
ORDER BY o.placed_at;