[2025-08-25 11:54:32]
[2025-08-25 11:54:32]
INSERT INTO ordbook_m ( part, route, ordstate, ocode, ccode, orddate, deldate, ordtime, bigo, shop_phone02, shop_memo, shop_receiver_uname, shop_receiver_zipcode, shop_receiver_address, shop_receiver_phone01, shop_receiver_phone02,ucode) VALUE ( '1', '1', '0', '1', '000184', '2025-08-25', '2025-08-25', '250825115151', '', '', '', '', '', '', '', '','')[2025-08-25 11:54:32]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( '[블렌딩] 크로우 1kg', '000818', '1kg', '5', '28000', '', '5011', '1' , '2025-08-25 11:54:32'  , 1 )[2025-08-25 11:54:32]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( '크림얼그레이 밀크티 원액', '000823', '1000ml', '2', '15910', '', '5011', '2' , '2025-08-25 11:54:32'  , 2 )[2025-08-25 11:54:36]
[2025-08-25 11:54:36]
UPDATE ordbook_m SET orddate = '2025-08-25', deldate = '2025-08-25', bigo = '', shop_memo = '', shop_receiver_uname = '', shop_receiver_zipcode = '', shop_receiver_address = '', shop_receiver_phone01 = '', shop_receiver_phone02 = '', ucode = ''  WHERE ordno = '5011' [2025-08-25 11:54:36]
UPDATE ordbook_d SET pname = '[블렌딩] 크로우 1kg', pcode = '000818', pnorm = '1kg', ordqnt = '5', price = '28000', bigo = '' , lastmodify = '2025-08-25 11:54:36'  , parentseq = '1'  WHERE ordno = '5011' AND seq = '1'[2025-08-25 11:54:36]
UPDATE ordbook_d SET pname = '크림얼그레이 밀크티 원액', pcode = '000823', pnorm = '1000ml', ordqnt = '2', price = '15910', bigo = '' , lastmodify = '2025-08-25 11:54:36'  , parentseq = '2'  WHERE ordno = '5011' AND seq = '2'[2025-08-25 12:39:13]
[2025-08-25 12:39:13]
INSERT INTO ordbook_m ( part, route, ordstate, ocode, ccode, orddate, deldate, ordtime, bigo, shop_phone02, shop_memo, shop_receiver_uname, shop_receiver_zipcode, shop_receiver_address, shop_receiver_phone01, shop_receiver_phone02,ucode) VALUE ( '1', '1', '0', '1', '000260', '2025-08-25', '2025-08-25', '250825123905', '', '', '', '', '', '', '', '','')[2025-08-25 12:39:13]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( '[블렌딩] 크로우 1kg', '000818', '1kg', '5', '28000', '', '5012', '1' , '2025-08-25 12:39:13'  , 1 )[2025-08-25 12:39:20]
[2025-08-25 12:39:20]
UPDATE ordbook_m SET orddate = '2025-08-25', deldate = '2025-08-25', bigo = '', shop_memo = '', shop_receiver_uname = '', shop_receiver_zipcode = '', shop_receiver_address = '', shop_receiver_phone01 = '', shop_receiver_phone02 = '', ucode = ''  WHERE ordno = '5012' [2025-08-25 12:39:20]
UPDATE ordbook_d SET pname = '[블렌딩] 크로우 1kg', pcode = '000818', pnorm = '1kg', ordqnt = '5', price = '28000', bigo = '' , lastmodify = '2025-08-25 12:39:20'  , parentseq = '1'  WHERE ordno = '5012' AND seq = '1'[2025-08-25 16:13:50]
[2025-08-25 16:13:50]
INSERT INTO ordbook_m ( part, route, ordstate, ocode, ccode, orddate, deldate, ordtime, bigo, shop_phone02, shop_memo, shop_receiver_uname, shop_receiver_zipcode, shop_receiver_address, shop_receiver_phone01, shop_receiver_phone02,ucode) VALUE ( '1', '1', '0', '1', '000078', '2025-08-25', '2025-08-25', '250825161345', '', '', '', '', '', '', '', '','')[2025-08-25 16:13:50]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( '[블렌딩] 스패로우 1kg', '000796', '1kg', '5', '23000', '', '5013', '1' , '2025-08-25 16:13:50'  , 1 )[2025-08-25 20:33:40]
[2025-08-25 20:33:40]
INSERT INTO ordbook_m ( part, route, ordstate, ocode, ccode, orddate, deldate, ordtime, bigo, shop_phone02, shop_memo, shop_receiver_uname, shop_receiver_zipcode, shop_receiver_address, shop_receiver_phone01, shop_receiver_phone02,ucode) VALUE ( '1', '1', '0', '1', '000363', '2025-08-25', '2025-08-25', '250825203317', '', '', '', '', '', '', '', '','')[2025-08-25 20:33:40]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( 'SHOTT 바닐라 시럽', '000020', '1000ml', '5', '15500', '', '5014', '1' , '2025-08-25 20:33:40'  , 1 )[2025-08-25 20:34:34]
[2025-08-25 20:34:34]
UPDATE ordbook_m SET orddate = '2025-08-25', deldate = '2025-08-25', bigo = '', shop_memo = '', shop_receiver_uname = '', shop_receiver_zipcode = '', shop_receiver_address = '', shop_receiver_phone01 = '', shop_receiver_phone02 = '', ucode = ''  WHERE ordno = '5014' [2025-08-25 20:34:34]
UPDATE ordbook_d SET pname = 'SHOTT 바닐라 시럽', pcode = '000020', pnorm = '1000ml', ordqnt = '5', price = '15500', bigo = '' , lastmodify = '2025-08-25 20:34:34'  , parentseq = '1'  WHERE ordno = '5014' AND seq = '1'[2025-08-25 20:34:34]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( '[블렌딩] 크로우 1kg', '000818', '1kg', '10', '28000', '', '5014', '2' , '2025-08-25 20:34:34'  , 2 )[2025-08-25 20:34:34]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( '[싱글] 디카페인 원두커피 1kg', '000916', '1kg', '1', '34000', '', '5014', '3' , '2025-08-25 20:34:34'  , 3 )[2025-08-25 20:34:34]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( '[블렌딩] 에-블렌드 1kg', '001007', '1kg', '2', '23000', '', '5014', '4' , '2025-08-25 20:34:34'  , 4 )[2025-08-25 20:34:34]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( '[블렌딩] 이-블렌드 1kg', '001023', '1kg', '5', '26000', '', '5014', '5' , '2025-08-25 20:34:34'  , 5 )[2025-08-25 20:35:16]
[2025-08-25 20:35:16]
UPDATE ordbook_m SET orddate = '2025-08-25', deldate = '2025-08-25', bigo = '', shop_memo = '', shop_receiver_uname = '', shop_receiver_zipcode = '', shop_receiver_address = '', shop_receiver_phone01 = '', shop_receiver_phone02 = '', ucode = ''  WHERE ordno = '5014' [2025-08-25 20:35:16]
UPDATE ordbook_d SET pname = 'SHOTT 바닐라 시럽', pcode = '000020', pnorm = '1000ml', ordqnt = '5', price = '15500', bigo = '' , lastmodify = '2025-08-25 20:35:16'  , parentseq = '1'  WHERE ordno = '5014' AND seq = '1'[2025-08-25 20:35:16]
UPDATE ordbook_d SET pname = '[블렌딩] 크로우 1kg', pcode = '000818', pnorm = '1kg', ordqnt = '10', price = '28000', bigo = '' , lastmodify = '2025-08-25 20:35:16'  , parentseq = '2'  WHERE ordno = '5014' AND seq = '2'[2025-08-25 20:35:16]
UPDATE ordbook_d SET pname = '[싱글] 디카페인 원두커피 1kg', pcode = '000916', pnorm = '1kg', ordqnt = '1', price = '34000', bigo = '' , lastmodify = '2025-08-25 20:35:16'  , parentseq = '3'  WHERE ordno = '5014' AND seq = '3'[2025-08-25 20:35:16]
UPDATE ordbook_d SET pname = '[블렌딩] 에-블렌드 1kg', pcode = '001007', pnorm = '1kg', ordqnt = '2', price = '23000', bigo = '' , lastmodify = '2025-08-25 20:35:16'  , parentseq = '4'  WHERE ordno = '5014' AND seq = '4'[2025-08-25 20:35:16]
UPDATE ordbook_d SET pname = '[블렌딩] 이-블렌드 1kg', pcode = '001023', pnorm = '1kg', ordqnt = '5', price = '26000', bigo = '' , lastmodify = '2025-08-25 20:35:16'  , parentseq = '5'  WHERE ordno = '5014' AND seq = '5'[2025-08-25 20:35:16]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( 'SHOTT 바닐라 시럽', '000020', '1000ml', '5', '15500', '', '5014', '6' , '2025-08-25 20:35:16'  , 6 )[2025-08-25 20:35:16]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( '다빈치 구운아몬드 시럽', '000857', '750ml', '5', '11500', '', '5014', '7' , '2025-08-25 20:35:16'  , 7 )[2025-08-25 20:35:16]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( 'SHOTT 헤이즐넛 시럽', '000968', '1000ml', '1', '17000', '', '5014', '8' , '2025-08-25 20:35:16'  , 8 )[2025-08-25 20:35:48]
DELETE FROM ordbook_d WHERE ordno = \'5014\' AND seq= \'8\'[2025-08-25 20:36:52]
[2025-08-25 20:36:52]
UPDATE ordbook_m SET orddate = '2025-08-25', deldate = '2025-08-25', bigo = '', shop_memo = '', shop_receiver_uname = '', shop_receiver_zipcode = '', shop_receiver_address = '', shop_receiver_phone01 = '', shop_receiver_phone02 = '', ucode = ''  WHERE ordno = '5014' [2025-08-25 20:36:52]
UPDATE ordbook_d SET pname = 'SHOTT 바닐라 시럽', pcode = '000020', pnorm = '1000ml', ordqnt = '3', price = '15500', bigo = '' , lastmodify = '2025-08-25 20:36:52'  , parentseq = '1'  WHERE ordno = '5014' AND seq = '1'[2025-08-25 20:36:52]
UPDATE ordbook_d SET pname = '[블렌딩] 크로우 1kg', pcode = '000818', pnorm = '1kg', ordqnt = '8', price = '28000', bigo = '' , lastmodify = '2025-08-25 20:36:52'  , parentseq = '2'  WHERE ordno = '5014' AND seq = '2'[2025-08-25 20:36:52]
UPDATE ordbook_d SET pname = '[싱글] 디카페인 원두커피 1kg', pcode = '000916', pnorm = '1kg', ordqnt = '1', price = '34000', bigo = '' , lastmodify = '2025-08-25 20:36:52'  , parentseq = '3'  WHERE ordno = '5014' AND seq = '3'[2025-08-25 20:36:52]
UPDATE ordbook_d SET pname = '[블렌딩] 에-블렌드 1kg', pcode = '001007', pnorm = '1kg', ordqnt = '2', price = '23000', bigo = '' , lastmodify = '2025-08-25 20:36:52'  , parentseq = '4'  WHERE ordno = '5014' AND seq = '4'[2025-08-25 20:36:52]
UPDATE ordbook_d SET pname = '[블렌딩] 이-블렌드 1kg', pcode = '001023', pnorm = '1kg', ordqnt = '3', price = '26000', bigo = '' , lastmodify = '2025-08-25 20:36:52'  , parentseq = '5'  WHERE ordno = '5014' AND seq = '5'[2025-08-25 20:36:52]
UPDATE ordbook_d SET pname = 'SHOTT 바닐라 시럽', pcode = '000020', pnorm = '1000ml', ordqnt = '5', price = '15500', bigo = '' , lastmodify = '2025-08-25 20:36:52'  , parentseq = '6'  WHERE ordno = '5014' AND seq = '6'[2025-08-25 20:36:52]
UPDATE ordbook_d SET pname = '다빈치 구운아몬드 시럽', pcode = '000857', pnorm = '750ml', ordqnt = '5', price = '11500', bigo = '' , lastmodify = '2025-08-25 20:36:52'  , parentseq = '7'  WHERE ordno = '5014' AND seq = '7'[2025-08-25 23:11:48]
[2025-08-25 23:11:48]
UPDATE ordbook_m SET orddate = '2025-08-25', deldate = '2025-08-25', bigo = '', shop_memo = '', shop_receiver_uname = '', shop_receiver_zipcode = '', shop_receiver_address = '', shop_receiver_phone01 = '', shop_receiver_phone02 = '', ucode = ''  WHERE ordno = '5014' [2025-08-25 23:11:48]
UPDATE ordbook_d SET pname = 'SHOTT 바닐라 시럽', pcode = '000020', pnorm = '1000ml', ordqnt = '3', price = '15500', bigo = '' , lastmodify = '2025-08-25 23:11:48'  , parentseq = '1'  WHERE ordno = '5014' AND seq = '1'[2025-08-25 23:11:48]
UPDATE ordbook_d SET pname = '[블렌딩] 크로우 1kg', pcode = '000818', pnorm = '1kg', ordqnt = '8', price = '28000', bigo = '' , lastmodify = '2025-08-25 23:11:48'  , parentseq = '2'  WHERE ordno = '5014' AND seq = '2'[2025-08-25 23:11:48]
UPDATE ordbook_d SET pname = '[싱글] 디카페인 원두커피 1kg', pcode = '000916', pnorm = '1kg', ordqnt = '1', price = '34000', bigo = '' , lastmodify = '2025-08-25 23:11:48'  , parentseq = '3'  WHERE ordno = '5014' AND seq = '3'[2025-08-25 23:11:48]
UPDATE ordbook_d SET pname = '[블렌딩] 에-블렌드 1kg', pcode = '001007', pnorm = '1kg', ordqnt = '2', price = '23000', bigo = '' , lastmodify = '2025-08-25 23:11:48'  , parentseq = '4'  WHERE ordno = '5014' AND seq = '4'[2025-08-25 23:11:48]
UPDATE ordbook_d SET pname = '[블렌딩] 이-블렌드 1kg', pcode = '001023', pnorm = '1kg', ordqnt = '3', price = '26000', bigo = '' , lastmodify = '2025-08-25 23:11:48'  , parentseq = '5'  WHERE ordno = '5014' AND seq = '5'[2025-08-25 23:11:48]
UPDATE ordbook_d SET pname = 'SHOTT 바닐라 시럽', pcode = '000020', pnorm = '1000ml', ordqnt = '5', price = '15500', bigo = '' , lastmodify = '2025-08-25 23:11:48'  , parentseq = '6'  WHERE ordno = '5014' AND seq = '6'[2025-08-25 23:11:48]
UPDATE ordbook_d SET pname = '다빈치 구운아몬드 시럽', pcode = '000857', pnorm = '750ml', ordqnt = '5', price = '11500', bigo = '' , lastmodify = '2025-08-25 23:11:48'  , parentseq = '7'  WHERE ordno = '5014' AND seq = '7'[2025-08-25 23:11:48]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq , lastmodify  , parentseq  ) VALUES ( '보성 유기농 말차', '000719', '500g', '1', '36273', '', '5014', '8' , '2025-08-25 23:11:48'  , 8 )