ID_, NAME_, TYPE_, CODE_, MAN_, TEL_, ADDRESS_, ROAD_ID_, LNG_, LAT_, PEG_VAL_, CREATE_BY_, CREATE_NAME_, CREATE_ORG_ID_, CREATE_ORG_NAME_, CREATE_COMPANY_ID_, CREATE_COMPANY_NAME_, CREATE_TIME_, UPDATE_BY_, UPDATE_NAME_, UPDATE_COMPANY_NAME_, UPDATE_COMPANY_ID_, UPDATE_ORG_ID_, UPDATE_ORG_NAME_, UPDATE_TIME_, LAST_TIME_, IS_DELE_, VERSION_, TENANT_ID_ SELECT t.*, r.name_ AS roadName, r.code_ AS roadCode FROM biz_base_team t LEFT JOIN biz_base_road r ON t.road_id_=r.id_ ${ew.customSqlSegment} SELECT t.*,r.name_ AS roadName,r.code_ AS roadCode FROM biz_base_team t LEFT JOIN biz_base_road r ON t.road_id_=r.id_ WHERE t.is_dele_='0' AND r.is_dele_='0' AND t.id_ = #{id} SELECT t.id_,t.name_ FROM biz_base_team t JOIN biz_base_team_member tm ON t.id_=tm.team_id_ WHERE t.is_dele_='0' AND tm.is_dele_='0' AND tm.user_id_ = #{userId} SELECT o.id_ FROM uc_org o JOIN biz_base_road r ON o.name_ = r.name_ WHERE o.grade_ = '5' AND o.org_kind_ = 'dept' and o.is_dele_='0' and r.is_dele_='0' AND r.id_=#{id} LIMIT 1 SELECT id_ FROM uc_org WHERE grade_= CASE #{type} WHEN '1' THEN '-1' WHEN '2' THEN '-2' ELSE '-3' END AND parent_id_=#{id} AND is_dele_ = '0' LIMIT 1 WITH road_info AS ( SELECT CONCAT(SUBSTRING_INDEX(o.path_, '.', LENGTH(o.path_) - LENGTH(REPLACE(o.path_, '.', '')) - 1), '.', r.id_, '.') AS path_, r.id_ AS ROAD_ID_, r.name_ AS ROAD_NAME_, r.code_ AS ROAD_CODE_ FROM uc_org o JOIN biz_base_road r ON o.name_ = r.ADDRESS_ WHERE o.grade_ = '5' AND o.org_kind_ = 'dept' and o.is_dele_='0' and r.is_dele_='0' ) SELECT o.ID_ AS ORG_ID_ FROM uc_org o INNER JOIN road_info ri ON ri.path_ LIKE CONCAT('%', o.path_, '%') WHERE o.grade_='3' AND o.is_dele_ = '0' AND o.org_kind_ = 'ogn' AND ri.ROAD_ID_= #{roadId} LIMIT 1