create table temp_should_display_brand
as
select distinct b.x_brand_id,i.imgname,s.store_id
from x_brand b,x_brand_st_img i,x_brand_store s
where b.x_brand_id = i.x_brand_id and b.x_brand_id = s.x_brand_id
and i.store_id = s.store_id and i.imgname is not null
and( b.cnname is not null or b.othername is not null);
update x_brand_store s set s.dispalyflg = 1 where s.x_brand_id in(select x_brand_id from temp_should_display_brand);
commit;
drop table temp_should_display_brand;
CREATE TABLE X_TEMP_X_ATTR AS
（select a.store_id,a.catentry_id, to_char(a.attr_id) as attr_id, max(to_char(a.attrval_id)) as attrval_id,
count(*) as count from x_catentryattr_store a ,attrval b,attr c where a.attrval_id=b.attrval_id and a.attr_id=c.attr_id and c.attrusage is null
group by a.catentry_id, a.attr_id, a.store_id
having count（* ） > 1）
delete from x_catentryattr_store xc
where xc.store_id||xc.catentry_id||xc.attr_id||
xc.attrval_id in
(select a.store_id||
a.catentry_id||
to_char(a.attr_id)||
to_char(a.attrval_id)
from x_catentryattr_store a, X_TEMP_ATTR b
where a.store_id = b.store_id
and a.catentry_id = b.catentry_id
and a.attr_id = b.attr_id
and a.attrval_id != b.attrval_id)
DELETE FROM x_catentryattr_store where store_id||
catentry_id||
attr_id = any(
SELECT ID from ( select row_number() over(partition by a.store_id,
a.catentry_id,
a.attr_id order by
a.attrval_id DESC) cno,to_char(a.attrval_id) AS ID,a.store_id||
a.catentry_id||
a.attr_id as key1 from x_catentryattr_store a
) te where te.cno > 1)