id_, code_,type_, icon_, gis_area_, addvcd_, area_id_, address_type_, floor_, supplier_company_id_, repair_company_id_, repair_user_id_, manager_company_id_, manager_user_id_, last_time_ SELECT e.*, a.code_ as areaCode,a.name_ as areaName FROM device_video_point_extend e LEFT JOIN device_base_area a on a.id_ = e.area_id_ and a.is_dele_='0' where e.code_ = #{videoCode}