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'