Septage vendor assignment

SELECT da_id FROM
 
		(SELECT login.da_id,COALESCE(login.da_last_requested_time,'2019/01/01') AS last_requested_time FROM st_septage_booking AS booking
 
		LEFT JOIN capcityview AS cg ON cg.subvcgid = booking.sb_vcg_id
 
		INNER JOIN st_septage_registration AS reg ON reg.sr_vcg_id =cg.mainvcgid AND reg.deleted=0 AND reg.sr_license_status =1 AND reg.sr_corp_vehicle = corpbooking AND ((reg.sr_pumping_type=booking.sb_pumping_type AND booking.sb_pumping_type!=3) OR (booking.sb_pumping_type=3))
 
		LEFT JOIN st_hose_length AS hl ON hl.hl_id = booking.sb_road_distance AND hl.deleted=0
 
		LEFT JOIN st_septage_road_width AS rw ON rw.rw_id = reg.sr_road_width AND rw.deleted=0
 
		LEFT JOIN st_septage_road_width AS booking_rw ON booking_rw.rw_id = booking.sb_road_width AND booking_rw.deleted=0
 
		LEFT JOIN st_septage_driver_auth AS login ON login.da_sr_id = reg.sr_id AND login.deleted=0 AND login.status =1 AND login.da_auto_status =1  --for only logined driver users
 
		WHERE rw.rw_value<=booking_rw.rw_value AND reg.sr_allowself=1 AND reg.sr_pipe_length>=hl.hl_to_length AND login.da_is_login=2 AND booking.sb_id=bookingid AND login.da_current_status=1
 
		AND da_id NOT IN (SELECT va_da_id FROM st_septage_booking_vendor_assignment WHERE deleted=0 AND va_status=1)
 
		 ORDER BY login.da_last_requested_time)
 
		AS vendor ORDER BY last_requested_time
 
		 LIMIT 1;