alter table dtable.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from dtable.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM dtable.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into dtable.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into dtable.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);


alter table shop_beauty.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_beauty.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_beauty.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_beauty.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_beauty.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_hanjumall.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_hanjumall.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_hanjumall.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_hanjumall.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_hanjumall.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_sjcmall.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_sjcmall.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_sjcmall.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_sjcmall.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_sjcmall.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_dongamall.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_dongamall.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_dongamall.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_dongamall.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_dongamall.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_mooninmall.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_mooninmall.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_mooninmall.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_mooninmall.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_mooninmall.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_ilgumall.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_ilgumall.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_ilgumall.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_ilgumall.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_ilgumall.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_neodocumall.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_neodocumall.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_neodocumall.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_neodocumall.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_neodocumall.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_dongaprmall.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_dongaprmall.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_dongaprmall.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_dongaprmall.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_dongaprmall.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_daesungmall.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_daesungmall.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_daesungmall.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_daesungmall.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_daesungmall.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_ditecmall.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_ditecmall.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_ditecmall.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_ditecmall.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_ditecmall.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_sunggwangmall.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_sunggwangmall.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_sunggwangmall.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_sunggwangmall.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_sunggwangmall.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table webmotion_sample.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from webmotion_sample.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM webmotion_sample.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into webmotion_sample.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into webmotion_sample.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_mjmall.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_mjmall.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_mjmall.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_mjmall.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_mjmall.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_jebonteam.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_jebonteam.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_jebonteam.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_jebonteam.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_jebonteam.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_copynara.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_copynara.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_copynara.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_copynara.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_copynara.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_jungmoonmall.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_jungmoonmall.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_jungmoonmall.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_jungmoonmall.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_jungmoonmall.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_taeshinmedia.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_taeshinmedia.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_taeshinmedia.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_taeshinmedia.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_taeshinmedia.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_yurim.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_yurim.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_yurim.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_yurim.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_yurim.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_directdnp.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_directdnp.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_directdnp.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_directdnp.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_directdnp.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_jungwoo.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_jungwoo.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_jungwoo.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_jungwoo.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_jungwoo.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_wasu.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_wasu.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_wasu.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_wasu.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_wasu.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_gonggan.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_gonggan.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_gonggan.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_gonggan.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_gonggan.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_copyist.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_copyist.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_copyist.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_copyist.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_copyist.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_yujungcnp.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_yujungcnp.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_yujungcnp.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_yujungcnp.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_yujungcnp.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_sungsim.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_sungsim.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_sungsim.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_sungsim.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_sungsim.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_mirae.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_mirae.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_mirae.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_mirae.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_mirae.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_zeroone.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_zeroone.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_zeroone.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_zeroone.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_zeroone.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_chunil.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_chunil.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_chunil.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_chunil.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_chunil.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_gangnamdaedong.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_gangnamdaedong.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_gangnamdaedong.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_gangnamdaedong.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_gangnamdaedong.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_daeyang.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_daeyang.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_daeyang.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_daeyang.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_daeyang.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_yunhwa.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_yunhwa.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_yunhwa.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_yunhwa.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_yunhwa.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_sp6636.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_sp6636.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_sp6636.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_sp6636.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_sp6636.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_printchang.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_printchang.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_printchang.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_printchang.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_printchang.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_koreatp.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_koreatp.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_koreatp.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_koreatp.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_koreatp.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_pointing.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_pointing.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_pointing.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_pointing.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_pointing.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_naraeprinting.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_naraeprinting.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_naraeprinting.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_naraeprinting.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_naraeprinting.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_hanchang.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_hanchang.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_hanchang.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_hanchang.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_hanchang.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_baehyosang.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_baehyosang.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_baehyosang.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_baehyosang.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_baehyosang.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_chungwoon.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_chungwoon.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_chungwoon.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_chungwoon.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_chungwoon.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_sinyung.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_sinyung.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_sinyung.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_sinyung.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_sinyung.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_dongwoo.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_dongwoo.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_dongwoo.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_dongwoo.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_dongwoo.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_kscopy.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_kscopy.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_kscopy.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_kscopy.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_kscopy.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_dreamdipo.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_dreamdipo.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_dreamdipo.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_dreamdipo.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_dreamdipo.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_printvalley.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_printvalley.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_printvalley.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_printvalley.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_printvalley.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_hyundae.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_hyundae.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_hyundae.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_hyundae.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_hyundae.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_hycopy.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_hycopy.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_hycopy.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_hycopy.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_hycopy.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_bbobbai.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_bbobbai.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_bbobbai.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_bbobbai.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_bbobbai.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_koreaculture.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_koreaculture.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_koreaculture.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_koreaculture.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_koreaculture.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_daemyung.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_daemyung.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_daemyung.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_daemyung.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_daemyung.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_bookchungsa.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_bookchungsa.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_bookchungsa.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_bookchungsa.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_bookchungsa.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_kms.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_kms.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_kms.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_kms.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_kms.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_myungsung.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_myungsung.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_myungsung.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_myungsung.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_myungsung.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_designstory.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_designstory.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_designstory.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_designstory.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_designstory.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_designshinwoo.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_designshinwoo.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_designshinwoo.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_designshinwoo.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_designshinwoo.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_jejucopy.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_jejucopy.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_jejucopy.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_jejucopy.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_jejucopy.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_baekrok.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_baekrok.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_baekrok.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_baekrok.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_baekrok.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_jejucom.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_jejucom.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_jejucom.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_jejucom.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_jejucom.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_docupia.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_docupia.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_docupia.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_docupia.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_docupia.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_samildps.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_samildps.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_samildps.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_samildps.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_samildps.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_samyang.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_samyang.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_samyang.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_samyang.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_samyang.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_gaindigital.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_gaindigital.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_gaindigital.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_gaindigital.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_gaindigital.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_hangeulsystem.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_hangeulsystem.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_hangeulsystem.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_hangeulsystem.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_hangeulsystem.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_seodopnc.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_seodopnc.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_seodopnc.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_seodopnc.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_seodopnc.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_peoples.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_peoples.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_peoples.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_peoples.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_peoples.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_mookhyang.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_mookhyang.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_mookhyang.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_mookhyang.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_mookhyang.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_boriculture.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_boriculture.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_boriculture.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_boriculture.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_boriculture.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_jsixpackage.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_jsixpackage.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_jsixpackage.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_jsixpackage.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_jsixpackage.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_daehancnp.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_daehancnp.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_daehancnp.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_daehancnp.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_daehancnp.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_onestop.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_onestop.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_onestop.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_onestop.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_onestop.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_dongmoon.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_dongmoon.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_dongmoon.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_dongmoon.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_dongmoon.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_guyung.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_guyung.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_guyung.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_guyung.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_guyung.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_copyplus.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_copyplus.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_copyplus.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_copyplus.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_copyplus.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_kpcprinting.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_kpcprinting.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_kpcprinting.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_kpcprinting.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_kpcprinting.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_dongshings.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_dongshings.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_dongshings.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_dongshings.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_dongshings.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_taegwang.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_taegwang.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_taegwang.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_taegwang.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_taegwang.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_geultown.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_geultown.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_geultown.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_geultown.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_geultown.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_daemyungtotal.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_daemyungtotal.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_daemyungtotal.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_daemyungtotal.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_daemyungtotal.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_winmedia.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_winmedia.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_winmedia.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_winmedia.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_winmedia.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_jeilculture.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_jeilculture.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_jeilculture.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_jeilculture.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_jeilculture.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_yunggwang.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_yunggwang.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_yunggwang.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_yunggwang.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_yunggwang.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_digibusung.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_digibusung.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_digibusung.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_digibusung.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_digibusung.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_bomoonsa.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_bomoonsa.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_bomoonsa.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_bomoonsa.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_bomoonsa.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_samhwa.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_samhwa.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_samhwa.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_samhwa.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_samhwa.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_boramae.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_boramae.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_boramae.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_boramae.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_boramae.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_sungrae.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_sungrae.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_sungrae.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_sungrae.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_sungrae.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_shinhwa.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_shinhwa.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_shinhwa.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_shinhwa.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_shinhwa.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_sungmoon.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_sungmoon.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_sungmoon.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_sungmoon.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_sungmoon.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_sunjin.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_sunjin.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_sunjin.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_sunjin.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_sunjin.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_yusung.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_yusung.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_yusung.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_yusung.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_yusung.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_yale.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_yale.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_yale.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_yale.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_yale.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_yurimculture.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_yurimculture.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_yurimculture.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_yurimculture.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_yurimculture.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_hyundaeoffset.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_hyundaeoffset.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_hyundaeoffset.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_hyundaeoffset.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_hyundaeoffset.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_hanultari.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_hanultari.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_hanultari.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_hanultari.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_hanultari.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_hankook.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_hankook.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_hankook.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_hankook.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_hankook.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_kpcprinting_s.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_kpcprinting_s.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_kpcprinting_s.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_kpcprinting_s.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_kpcprinting_s.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_kyungsungculture.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_kyungsungculture.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_kyungsungculture.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_kyungsungculture.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_kyungsungculture.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_daesan.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_daesan.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_daesan.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_daesan.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_daesan.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_woori.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_woori.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_woori.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_woori.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_woori.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_borim.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_borim.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_borim.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_borim.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_borim.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table hanultari.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from hanultari.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM hanultari.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into hanultari.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into hanultari.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_sample2.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_sample2.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_sample2.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_sample2.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_sample2.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);

alter table shop_sample3.`hapBlackResult` ADD `coating_type` int(11) default 1 after `gubun`;

delete from shop_sample3.hapBlackResult WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);
delete FROM shop_sample3.hapBlackResult WHERE gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_sample3.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult where gubun = '1' AND midCode = 'f1' AND setPaperIdx in (19489,19494,19492,19491,19490,19496,19497);

insert into shop_sample3.hapBlackResult (idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin) select idx, gubun, coating_type, midCode, comIdx, setPaperIdx, docPan, docJul, rcount, dosuCode, rcount_calc, pyungDanga, ctp, prn, paper, cut, coating, attach, total_wonga, unit_wonga, total_sale, unit_sale, margin FROM webmotion.hapBlackResult  WHERE gubun = '1' AND midCode = 'f4' AND setPaperIdx in (2176, 19421,19425,19423,19407,19408,19426);