工单 005-20230705002 无法打开

​![](../../../../attachment/images-uuid/2fcd709ae96c47599be04727eedea9cd.png)

复现查询逻辑报错

有脏数据

​![](../../../../attachment/images-uuid/7ed4a629aa2a4cd497376360a88074dc.png)​

导致脏数据的位置

​![](../../../../attachment/images-uuid/2ae33f6fba1d45ad87c64be608e1ddda.png)​

相关 sql，删除中间表

```sql
SELECT api.*
from order_plain_info api
         LEFT JOIN adapt_work_order_domain_plain_info awodpi
                   ON api.id = awodpi.order_plain_info_id
         LEFT JOIN adapt_work_order_domain_info awodi
                   ON awodpi.adapt_work_order_domain_info_id = awodi.id
where awodi.domain = 'live.hcs.cmvideo.cn'
  AND awodi.config_change_work_order_id = 517
  AND api.plain = 0;

delete
from adapt_work_order_domain_plain_info
where adapt_work_order_domain_info_id = 245;
```

com.cmcc.cdn.platform.selfservice.service.impl.AdaptWorkOrderServiceImpl#saveAdaptWorkOrderDomainInfo