| | |
|---|
| | | department_id, |
|---|
| | | stair_id, |
|---|
| | | second_level_id, |
|---|
| | | department_area, |
|---|
| | | concat( |
|---|
| | | IFNULL((SELECT name FROM area_code_2022 WHERE area_code_2022.code=(select city from automessage_organization_chart |
|---|
| | | where automessage_organization_chart.id=department_id)),''), |
|---|
| | | IFNULL((SELECT name FROM area_code_2022 WHERE area_code_2022.code=(select district from automessage_organization_chart |
|---|
| | | where automessage_organization_chart.id=department_id)),''), |
|---|
| | | IFNULL((SELECT name FROM area_code_2022 WHERE area_code_2022.code=(select village from automessage_organization_chart |
|---|
| | | where automessage_organization_chart.id=department_id)),'') |
|---|
| | | ) AS department_area,, |
|---|
| | | leisure_state, |
|---|
| | | master_ids, |
|---|
| | | master_names, |
|---|
