| | |
|---|
| | | left join "att_ad_base" county on town."p_ad_code" = county."ad_code" |
|---|
| | | left join "att_ad_base" city on county."p_ad_code" = city."ad_code" |
|---|
| | | left join "att_ad_base" province on city."p_ad_code" = province."ad_code" |
|---|
| | | left join "att_res_rsb_norspi" arrn on arb."guid" = arrn."res_guid" |
|---|
| | | left join ( |
|---|
| | | SELECT *, |
|---|
| | | ROW_NUMBER() OVER(PARTITION BY "res_guid" ORDER BY "res_guid") AS rn |
|---|
| | | from "att_res_rsb_norspi" arrn |
|---|
| | | ) arrn on arb."guid" = arrn."res_guid" AND arrn.rn = 1 |
|---|
| | | WHERE arb."is_deleted"=0 |
|---|
| | | <if test="obj.code != null and obj.code != '' "> |
|---|
| | | and (town."ad_code" = #{obj.code} or county."ad_code" = #{obj.code} or city."ad_code" = #{obj.code} or province."ad_code" |
|---|
