x2-300清理款式图片存在"无"历史脏数据

SQL

update a_goods_style s
set s.STYLE_IMG=(select STYLE_SKC_IMG
                 from (select a.STYLE_ID, b.STYLE_SKC_IMG
                       from a_goods_style a
                                inner join (select style_id, max(STYLE_SKC_IMG) STYLE_SKC_IMG
                                            from a_goods_style_skc
                                            where STYLE_SKC_IMG != '无'
                                              and STYLE_SKC_IMG is not null
                                            group by style_id) b on a.STYLE_ID = b.STYLE_ID
                       where a.STYLE_IMG is null
                          or STYLE_IMG = '无') a
                 where s.STYLE_ID = a.STYLE_ID)
WHERE STYLE_IMG is null
   or STYLE_IMG = '无' and exists(select 1
                                  from (select a.STYLE_ID, b.STYLE_SKC_IMG
                                        from a_goods_style a
                                                 inner join (select style_id, max(STYLE_SKC_IMG) STYLE_SKC_IMG
                                                             from a_goods_style_skc
                                                             where STYLE_SKC_IMG != '无'
                                                               and STYLE_SKC_IMG is not null
                                                             group by style_id) b on a.STYLE_ID = b.STYLE_ID
                                        where a.STYLE_IMG is null
                                           or STYLE_IMG = '无'));
commit;