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