[2025-08-19 10:21:59]
[2025-08-19 10:21:59]
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', '000776', '2025-08-19', '2025-08-20', '250819102110', '이영희', '', '', '', '', '', '', '','')[2025-08-19 10:21:59]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq   , parentseq  ) VALUES ( '소대창', '000222', '4kg(냉장)-국내산한우', '2', '180000', '', '68085', '1'   , 1 )[2025-08-19 10:21:59]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq   , parentseq  ) VALUES ( '양념소갈비', '003086', '왕갈비(12대*1pack(10㎝*23㎝)-미국산', '2', '348000', '', '68085', '2'   , 2 )[2025-08-19 10:22:24]
[2025-08-19 10:22:24]
UPDATE ordbook_m SET orddate = '2025-08-19', deldate = '2025-08-20', bigo = '이영희', shop_memo = '', shop_receiver_uname = '', shop_receiver_zipcode = '', shop_receiver_address = '', shop_receiver_phone01 = '', shop_receiver_phone02 = '', ucode = ''  WHERE ordno = '68085' [2025-08-19 10:22:24]
UPDATE ordbook_d SET pname = '소대창', pcode = '000222', pnorm = '4kg(냉장)-국내산한우', ordqnt = '2', price = '180000', bigo = ''   , parentseq = '1'  WHERE ordno = '68085' AND seq = '1'[2025-08-19 10:22:24]
UPDATE ordbook_d SET pname = '양념소갈비', pcode = '003086', pnorm = '왕갈비(12대*1pack(10㎝*23㎝)-미국산', ordqnt = '2', price = '348000', bigo = ''   , parentseq = '2'  WHERE ordno = '68085' AND seq = '2'[2025-08-19 10:22:24]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq   , parentseq  ) VALUES ( '삶은깐양', '024202', '슬라이스2kg(뉴질랜드산)', '2', '26000', '', '68085', '3'   , 3 )[2025-08-19 10:22:38]
[2025-08-19 10:22:38]
UPDATE ordbook_m SET orddate = '2025-08-19', deldate = '2025-08-20', bigo = '이영희', shop_memo = '', shop_receiver_uname = '', shop_receiver_zipcode = '', shop_receiver_address = '', shop_receiver_phone01 = '', shop_receiver_phone02 = '', ucode = ''  WHERE ordno = '68085' [2025-08-19 10:22:38]
UPDATE ordbook_d SET pname = '소대창', pcode = '000222', pnorm = '4kg(냉장)-국내산한우', ordqnt = '2', price = '180000', bigo = ''   , parentseq = '1'  WHERE ordno = '68085' AND seq = '1'[2025-08-19 10:22:38]
UPDATE ordbook_d SET pname = '양념소갈비', pcode = '003086', pnorm = '왕갈비(12대*1pack(10㎝*23㎝)-미국산', ordqnt = '2', price = '348000', bigo = ''   , parentseq = '2'  WHERE ordno = '68085' AND seq = '2'[2025-08-19 10:22:38]
UPDATE ordbook_d SET pname = '삶은깐양', pcode = '024202', pnorm = '슬라이스2kg(뉴질랜드산)', ordqnt = '2', price = '26000', bigo = ''   , parentseq = '3'  WHERE ordno = '68085' AND seq = '3'[2025-08-19 10:22:38]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq   , parentseq  ) VALUES ( '롯데)아이시스(생수)', '008985', '500ml*20', '10', '3740', '', '68085', '4'   , 4 )[2025-08-19 10:22:55]
[2025-08-19 10:22:55]
UPDATE ordbook_m SET orddate = '2025-08-19', deldate = '2025-08-20', bigo = '이영희', shop_memo = '', shop_receiver_uname = '', shop_receiver_zipcode = '', shop_receiver_address = '', shop_receiver_phone01 = '', shop_receiver_phone02 = '', ucode = ''  WHERE ordno = '68085' [2025-08-19 10:22:55]
UPDATE ordbook_d SET pname = '소대창', pcode = '000222', pnorm = '4kg(냉장)-국내산한우', ordqnt = '2', price = '180000', bigo = ''   , parentseq = '1'  WHERE ordno = '68085' AND seq = '1'[2025-08-19 10:22:55]
UPDATE ordbook_d SET pname = '양념소갈비', pcode = '003086', pnorm = '왕갈비(12대*1pack(10㎝*23㎝)-미국산', ordqnt = '2', price = '348000', bigo = ''   , parentseq = '2'  WHERE ordno = '68085' AND seq = '2'[2025-08-19 10:22:55]
UPDATE ordbook_d SET pname = '삶은깐양', pcode = '024202', pnorm = '슬라이스2kg(뉴질랜드산)', ordqnt = '2', price = '26000', bigo = ''   , parentseq = '3'  WHERE ordno = '68085' AND seq = '3'[2025-08-19 10:22:55]
UPDATE ordbook_d SET pname = '롯데)아이시스(생수)', pcode = '008985', pnorm = '500ml*20', ordqnt = '10', price = '3740', bigo = ''   , parentseq = '4'  WHERE ordno = '68085' AND seq = '4'[2025-08-19 10:23:40]
[2025-08-19 10:23:40]
UPDATE ordbook_m SET orddate = '2025-08-19', deldate = '2025-08-20', bigo = '이영희', shop_memo = '', shop_receiver_uname = '', shop_receiver_zipcode = '', shop_receiver_address = '', shop_receiver_phone01 = '', shop_receiver_phone02 = '', ucode = ''  WHERE ordno = '68085' [2025-08-19 10:23:40]
UPDATE ordbook_d SET pname = '소대창', pcode = '000222', pnorm = '4kg(냉장)-국내산한우', ordqnt = '2', price = '180000', bigo = ''   , parentseq = '1'  WHERE ordno = '68085' AND seq = '1'[2025-08-19 10:23:40]
UPDATE ordbook_d SET pname = '양념소갈비', pcode = '003086', pnorm = '왕갈비(12대*1pack(10㎝*23㎝)-미국산', ordqnt = '2', price = '348000', bigo = ''   , parentseq = '2'  WHERE ordno = '68085' AND seq = '2'[2025-08-19 10:23:41]
UPDATE ordbook_d SET pname = '삶은깐양', pcode = '024202', pnorm = '슬라이스2kg(뉴질랜드산)', ordqnt = '2', price = '26000', bigo = ''   , parentseq = '3'  WHERE ordno = '68085' AND seq = '3'[2025-08-19 10:23:41]
UPDATE ordbook_d SET pname = '롯데)아이시스(생수)', pcode = '008985', pnorm = '500ml*20', ordqnt = '10', price = '3740', bigo = ''   , parentseq = '4'  WHERE ordno = '68085' AND seq = '4'[2025-08-19 10:52:58]
[2025-08-19 10:52:58]
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', '000271', '2025-08-19', '2025-08-19', '250819105250', '', '', '', '', '', '', '', '','')[2025-08-19 10:52:58]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq   , parentseq  ) VALUES ( '소양깃머리', '000814', '16KG(냉동)-뉴질랜드(大)', '1', '800000', '', '68088', '1'   , 1 )[2025-08-19 10:52:58]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq   , parentseq  ) VALUES ( '기본양념소스', '001381', '15L', '1', '70000', '', '68088', '2'   , 2 )[2025-08-19 10:53:16]
[2025-08-19 10:53:16]
UPDATE ordbook_m SET orddate = '2025-08-19', deldate = '2025-08-20', bigo = '', shop_memo = '', shop_receiver_uname = '', shop_receiver_zipcode = '', shop_receiver_address = '', shop_receiver_phone01 = '', shop_receiver_phone02 = '', ucode = ''  WHERE ordno = '68088' [2025-08-19 10:53:16]
UPDATE ordbook_d SET pname = '소양깃머리', pcode = '000814', pnorm = '16KG(냉동)-뉴질랜드(大)', ordqnt = '1', price = '800000', bigo = ''   , parentseq = '1'  WHERE ordno = '68088' AND seq = '1'[2025-08-19 10:53:16]
UPDATE ordbook_d SET pname = '기본양념소스', pcode = '001381', pnorm = '15L', ordqnt = '1', price = '70000', bigo = ''   , parentseq = '2'  WHERE ordno = '68088' AND seq = '2'[2025-08-19 10:53:16]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq   , parentseq  ) VALUES ( '소대창', '000222', '4kg(냉장)-국내산한우', '3', '180000', '', '68088', '3'   , 3 )[2025-08-19 10:53:20]
[2025-08-19 10:53:20]
UPDATE ordbook_m SET orddate = '2025-08-19', deldate = '2025-08-20', bigo = '', shop_memo = '', shop_receiver_uname = '', shop_receiver_zipcode = '', shop_receiver_address = '', shop_receiver_phone01 = '', shop_receiver_phone02 = '', ucode = ''  WHERE ordno = '68088' [2025-08-19 10:53:20]
UPDATE ordbook_d SET pname = '소양깃머리', pcode = '000814', pnorm = '16KG(냉동)-뉴질랜드(大)', ordqnt = '1', price = '800000', bigo = ''   , parentseq = '1'  WHERE ordno = '68088' AND seq = '1'[2025-08-19 10:53:20]
UPDATE ordbook_d SET pname = '기본양념소스', pcode = '001381', pnorm = '15L', ordqnt = '1', price = '70000', bigo = ''   , parentseq = '2'  WHERE ordno = '68088' AND seq = '2'[2025-08-19 10:53:20]
UPDATE ordbook_d SET pname = '소대창', pcode = '000222', pnorm = '4kg(냉장)-국내산한우', ordqnt = '3', price = '180000', bigo = ''   , parentseq = '3'  WHERE ordno = '68088' AND seq = '3'[2025-08-19 13:05:48]
[2025-08-19 13:05:48]
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', '000780', '2025-08-19', '2025-08-21', '250819130158', '김현숙', '', '', '', '', '', '', '','')[2025-08-19 13:05:48]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq   , parentseq  ) VALUES ( '오뚜기)옛날당면', '000085', '1kg*10', '1', '106480', '', '68089', '1'   , 1 )[2025-08-19 13:05:48]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq   , parentseq  ) VALUES ( '소대창', '000222', '4kg(냉장)-국내산한우', '2', '180000', '', '68089', '2'   , 2 )[2025-08-19 13:05:48]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq   , parentseq  ) VALUES ( '소양깃머리', '000814', '16KG(냉동)-뉴질랜드(大)', '2', '800000', '', '68089', '3'   , 3 )[2025-08-19 13:07:10]
DELETE FROM ordbook_d WHERE ordno = \'68089\' AND seq= \'1\'[2025-08-19 13:07:53]
[2025-08-19 13:07:53]
UPDATE ordbook_m SET orddate = '2025-08-19', deldate = '2025-08-21', bigo = '김현숙', shop_memo = '', shop_receiver_uname = '', shop_receiver_zipcode = '', shop_receiver_address = '', shop_receiver_phone01 = '', shop_receiver_phone02 = '', ucode = ''  WHERE ordno = '68089' [2025-08-19 13:07:53]
UPDATE ordbook_d SET pname = '소대창', pcode = '000222', pnorm = '4kg(냉장)-국내산한우', ordqnt = '2', price = '180000', bigo = ''   , parentseq = '2'  WHERE ordno = '68089' AND seq = '2'[2025-08-19 13:07:53]
UPDATE ordbook_d SET pname = '소양깃머리', pcode = '000814', pnorm = '16KG(냉동)-뉴질랜드(大)', ordqnt = '2', price = '800000', bigo = ''   , parentseq = '3'  WHERE ordno = '68089' AND seq = '3'[2025-08-19 13:07:53]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq   , parentseq  ) VALUES ( '백설)올리브유', '000861', '0.9L*12ea', '1', '258720', '', '68089', '4'   , 4 )[2025-08-19 13:07:53]
INSERT INTO ordbook_d (pname, pcode, pnorm , ordqnt, price, bigo, ordno, seq   , parentseq  ) VALUES ( '삶은팥', '013907', '4kg', '4', '9200', '', '68089', '5'   , 5 )[2025-08-19 13:47:50]
DELETE FROM ordbook_d WHERE ordno = \'68089\' AND seq= \'5\'