SELECT c.id,c.name FROM customers c WHERE NOT EXISTS (SELECT 1 FROM orders o WHERE o.customer_id=c.id AND o.status='paid' AND o.order_date>='2026-09-01' AND o.order_date<'2026-10-01') ORDER BY c.id;