| | |
|---|
| | | g."guid" AS provinceCode |
|---|
| | | FROM |
|---|
| | | "SJZT_MD"."att_res_base" a |
|---|
| | | RIGHT JOIN ( SELECT * FROM "SJZT_MD"."tb_res_general_investigation_state" WHERE "danger_level" <![CDATA[<>]]> '0' AND "check_state" = '3' ) c ON a."guid" = c."res_guid" |
|---|
| | | LEFT JOIN ( SELECT * FROM "SJZT_MD"."tb_res_general_investigation_state" WHERE "danger_level" <![CDATA[<>]]> '0' AND "check_state" = '3' ) c ON a."guid" = c."res_guid" |
|---|
| | | LEFT JOIN YWXT."att_ad_base" d ON d."ad_code" = a."interior_ad_guid" |
|---|
| | | LEFT JOIN YWXT."att_ad_base" e ON d."p_ad_code" = e."ad_code" |
|---|
| | | LEFT JOIN YWXT."att_ad_base" f ON e."p_ad_code" = f."ad_code" |
|---|
| | |
|---|
| | | f."guid" AS provinceCode |
|---|
| | | FROM |
|---|
| | | "SJZT_MD"."tb_res_dyke" a |
|---|
| | | RIGHT JOIN ( |
|---|
| | | LEFT JOIN ( |
|---|
| | | SELECT |
|---|
| | | a.* |
|---|
| | | FROM |
|---|
