select * from itemshop
where item_cd = '012326' and shop_cd not in ('00210','00225','00230','00268','00426','00432','00701')
order by shop_cd

update itemshop
set endday = '99991231',
  end_date = '9999-12-31',
  update_by = 'System admin',
  update_at = '2024-05-21 12:20:00+00'
where item_cd = '012326' and shop_cd not in ('00210','00225','00230','00268','00426','00432','00701')

update itemshop
set endday = '99991231',
  end_date = '9999-12-31',
  update_by = 'System admin',
  update_at = '2024-05-21 12:20:00+00'
where item_cd = '148661' and shop_cd not in ('00210','00225','00230','00268','00426','00432','00701')

update itemshop
set endday = '99991231',
  end_date = '9999-12-31',
  update_by = 'System admin',
  update_at = '2024-05-21 12:20:00+00'
where item_cd = '122161' and shop_cd not in ('00210','00225','00230','00268','00426','00432','00701')