<selectid="queryRealtime"resultType="cn.yangxianda.elevator.vo.ElevatorMonitorStatusVO"parameterType="map">
SELECT
t_elevator.registration_code AS registrationCode,
t_using_elevator_corporation.administrative_region AS administrativeRegion,
t_using_elevator_corporation.`name` AS usingCorp,
t_elevator.installation_location AS installLocation,
t_maintenance_corporation.corp_name AS maintenanceCorpName,
t_device.device_type AS deviceType,
t_device.communication_line AS communicateLine
FROM
elevator t_elevator
LEFT JOIN
using_elevator_corporation t_using_elevator_corporation
ON
t_elevator.using_elevator_corporation_id = t_using_elevator_corporation.using_elevator_corporation_id
LEFT JOIN
maintenance_corporation t_maintenance_corporation
ON
t_elevator.maintenance_corporation_id = t_maintenance_corporation.corp_id
LEFT JOIN
elevator_device_relat t_elevator_device_relat
ON
t_elevator.elevator_id = t_elevator_device_relat.elevator_id
LEFT JOIN
device t_device
ON
t_elevator_device_relat.device_id = t_device.device_id
${ew.customSqlSegment}
</select>