create table t1(
    barcode varchar(50) NOT NULL DEFAULT '',
    PRIMARY KEY (`barcode`))
ENGINE=MyISAM DEFAULT CHARSET=utf8;   
insert into t1 select distinct i.barcode from  opl_itemStats i where  i.import=1;
create table t2 like t1 ; 
insert into t2 select distinct i.barcode from  opl_itemStats i left outer join t1  using(barcode) where  t1.barcode is null;
delete i.* from opl_itemStats i inner join t2 using(barcode);
drop table t1;drop table t2;



