SELECT o.order_id, ol.line_id, ol.due_date FROM order_lines ol LEFT JOIN orders o ON o.order_id = ol.order_id LEFT JOIN eoc_collection_attempt_lines ecal ON ecal.line_id = ol.line_id LEFT JOIN eoc_collection_attempts eca ON eca.id = ecal.attempt_id AND eca.schedule_id = 4 WHERE o.completed = 1 AND ol.due_date IS NOT NULL AND ol.due_date < NOW() AND ecal.line_id IS NULL AND DATE_ADD(ol.due_date, INTERVAL 9 DAY) > NOW() AND DATEDIFF(DATE_ADD(ol.due_date, INTERVAL 9 day), NOW()) <= 2 AND ol.status NOT IN ('CANCELLED','RETURNED','CYCLE_RETURN') AND ol.order_flag = 'NONE'