SELECT
			o.order_id, ol.line_id, ol.due_date, ecas.late_fee_assessed, ecas.buy_fee_assessed
		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 AND ecal.schedule_id = {$sent['id']}
		LEFT JOIN eoc_collection_attempts eca ON eca.id = ecal.attempt_id AND eca.schedule_id = {$sent['id']}
		LEFT JOIN eoc_collection_assessments ecas ON ecas.line_id = ol.line_id
		WHERE
			o.completed = 1
			AND
			ol.due_date IS NOT NULL AND ol.due_date <= DATE(NOW())
			AND
			ecal.line_id IS NULL
			AND
			DATE_ADD(ol.due_date, INTERVAL {$sent['offset_days']} DAY) >= DATE(NOW())
			AND
			DATEDIFF(DATE_ADD(ol.due_date, INTERVAL {$sent['offset_days']} day), DATE(NOW())) <= {$max_backpeddle}
			AND
			ol.status NOT IN ('CANCELLED','RETURNED','CYCLE_RETURN', 'RCE', 'PURCHASED')
			AND
			ol.order_flag = 'NONE'
			AND
			o.order_type = 'REGULAR'
			AND
			{$null_field} IS NULL
		ORDER BY
			o.order_id ASC