| | |
|---|
| | | ad.area_name, |
|---|
| | | dz.zone_name as defense_zone_name |
|---|
| | | from ja_fw_task_schedule ts |
|---|
| | | left join ja_fw_device d on d.id = ts.device_id and d.is_deleted = 0 |
|---|
| | | left join ja_fw_area_divide ad on ad.id = ts.area_divide_id and ad.is_deleted = 0 |
|---|
| | | left join ja_fw_defense_scene ds on ds.id = ts.defense_scene_id and ds.is_deleted = 0 |
|---|
| | | left join ja_fw_device d on d.id = ts.device_id |
|---|
| | | left join ja_fw_area_divide ad on ad.id = ts.area_divide_id |
|---|
| | | left join ja_fw_defense_scene ds on ds.id = ts.defense_scene_id |
|---|
| | | left join ja_fw_defense_zone dz on dz.is_deleted = 0 |
|---|
| | | and dz.defense_scene_ids is not null |
|---|
| | | and dz.defense_scene_ids != '' |
|---|
