style24.doc/산출물/4.구축/데이터처리/04.품목EP카테고리매핑(TB_EP_CATE).sql

DROP TABLE TMP_EP_CATE;

CREATE TABLE TMP_EP_CATE AS
SELECT '10'            AS EP_GB
     , '여성의류>자켓' AS ITEMKIND_NM
     , '50000815'      AS EP_CATE_CD
FROM   DUAL
;

ALTER TABLE TMP_EP_CATE MODIFY COLUMN ITEMKIND_NM VARCHAR(50);
ALTER TABLE TMP_EP_CATE MODIFY COLUMN EP_CATE_CD VARCHAR(20);

TRUNCATE TABLE TMP_EP_CATE;

INSERT INTO TMP_EP_CATE VALUES ('10', '여성의류>자켓', '50000815');
INSERT INTO TMP_EP_CATE VALUES ('10', '여성의류>점퍼', '50000814');
INSERT INTO TMP_EP_CATE VALUES ('10', '여성의류>코트', '50000813');
INSERT INTO TMP_EP_CATE VALUES ('10', '여성의류>야상/사파리', '50000814');
INSERT INTO TMP_EP_CATE VALUES ('10', '여성의류>셔츠', '50000804');
INSERT INTO TMP_EP_CATE VALUES ('10', '여성의류>블라우스', '50000804');
INSERT INTO TMP_EP_CATE VALUES ('10', '여성의류>긴소매티셔츠', '50000803');
INSERT INTO TMP_EP_CATE VALUES ('10', '여성의류>반소매티셔츠', '50000803');
INSERT INTO TMP_EP_CATE VALUES ('10', '여성의류>니트', '50000805');
INSERT INTO TMP_EP_CATE VALUES ('10', '여성의류>가디건', '50000806');
INSERT INTO TMP_EP_CATE VALUES ('10', '여성의류>베스트/조끼', '50000817');
INSERT INTO TMP_EP_CATE VALUES ('10', '여성의류>나시/탑', '50000803');
INSERT INTO TMP_EP_CATE VALUES ('10', '여성의류>팬츠', '50000810');
INSERT INTO TMP_EP_CATE VALUES ('10', '여성의류>정장바지', '50000810');
INSERT INTO TMP_EP_CATE VALUES ('10', '여성의류>슬랙스', '50000810');
INSERT INTO TMP_EP_CATE VALUES ('10', '여성의류>반바지/숏츠', '50000810');
INSERT INTO TMP_EP_CATE VALUES ('10', '여성의류>점프수트', '50000811');
INSERT INTO TMP_EP_CATE VALUES ('10', '여성의류>레깅스', '50000812');
INSERT INTO TMP_EP_CATE VALUES ('10', '여성의류>스커트', '50000808');
INSERT INTO TMP_EP_CATE VALUES ('10', '여성의류>원피스', '50000807');
INSERT INTO TMP_EP_CATE VALUES ('10', '여성의류>데님>슬림/스키니', '50000809');
INSERT INTO TMP_EP_CATE VALUES ('10', '여성의류>데님>일자/스트레이트', '50000809');
INSERT INTO TMP_EP_CATE VALUES ('10', '여성의류>데님>부츠컷/와이드', '50000809');
INSERT INTO TMP_EP_CATE VALUES ('10', '여성의류>데님>쇼츠/반바지/9부', '50000809');
INSERT INTO TMP_EP_CATE VALUES ('10', '여성의류>데님>테이퍼드/배기/기타', '50000809');
INSERT INTO TMP_EP_CATE VALUES ('10', '여성의류>임부복>임부상의', '50000487');
INSERT INTO TMP_EP_CATE VALUES ('10', '여성의류>임부복>임부원피스', '50000488');
INSERT INTO TMP_EP_CATE VALUES ('10', '여성의류>임부복>임부스커트', '50000499');
INSERT INTO TMP_EP_CATE VALUES ('10', '여성의류>임부복>임부바지', '50000496');
INSERT INTO TMP_EP_CATE VALUES ('10', '여성의류>임부복>임부레깅스', '50000501');
INSERT INTO TMP_EP_CATE VALUES ('10', '여성의류>임부복>세트의류', '50000487');
INSERT INTO TMP_EP_CATE VALUES ('10', '남성의류>자켓', '50000838');
INSERT INTO TMP_EP_CATE VALUES ('10', '남성의류>점퍼', '50000837');
INSERT INTO TMP_EP_CATE VALUES ('10', '남성의류>코트', '50000839');
INSERT INTO TMP_EP_CATE VALUES ('10', '남성의류>야상/사파리', '50000837');
INSERT INTO TMP_EP_CATE VALUES ('10', '남성의류>니트', '50000831');
INSERT INTO TMP_EP_CATE VALUES ('10', '남성의류>가디건', '50000832');
INSERT INTO TMP_EP_CATE VALUES ('10', '남성의류>베스트/조끼', '50000834');
INSERT INTO TMP_EP_CATE VALUES ('10', '남성의류>셔츠', '50000833');
INSERT INTO TMP_EP_CATE VALUES ('10', '남성의류>반팔셔츠', '50000833');
INSERT INTO TMP_EP_CATE VALUES ('10', '남성의류>긴소매티셔츠', '50000830');
INSERT INTO TMP_EP_CATE VALUES ('10', '남성의류>반소매티셔츠', '50000830');
INSERT INTO TMP_EP_CATE VALUES ('10', '남성의류>나시/탑', '50000830');
INSERT INTO TMP_EP_CATE VALUES ('10', '남성의류>팬츠', '50000836');
INSERT INTO TMP_EP_CATE VALUES ('10', '남성의류>정장바지', '50000840');
INSERT INTO TMP_EP_CATE VALUES ('10', '남성의류>슬랙스', '50000836');
INSERT INTO TMP_EP_CATE VALUES ('10', '남성의류>반바지/숏츠', '50000836');
INSERT INTO TMP_EP_CATE VALUES ('10', '남성의류>점프수트', '50000836');
INSERT INTO TMP_EP_CATE VALUES ('10', '남성의류>레깅스', '50003805');
INSERT INTO TMP_EP_CATE VALUES ('10', '남성의류>데님>슬림/스키니', '50000835');
INSERT INTO TMP_EP_CATE VALUES ('10', '남성의류>데님>일자/스트레이트', '50000835');
INSERT INTO TMP_EP_CATE VALUES ('10', '남성의류>데님>부츠컷/와이드', '50000835');
INSERT INTO TMP_EP_CATE VALUES ('10', '남성의류>데님>쇼츠/반바지/9부', '50000835');
INSERT INTO TMP_EP_CATE VALUES ('10', '남성의류>데님>테이퍼드/배기/기타', '50000835');
INSERT INTO TMP_EP_CATE VALUES ('10', '유니의류>자켓', '50000838');
INSERT INTO TMP_EP_CATE VALUES ('10', '유니의류>점퍼', '50000837');
INSERT INTO TMP_EP_CATE VALUES ('10', '유니의류>코트', '50000839');
INSERT INTO TMP_EP_CATE VALUES ('10', '유니의류>야상/사파리', '50000837');
INSERT INTO TMP_EP_CATE VALUES ('10', '유니의류>니트', '50000805');
INSERT INTO TMP_EP_CATE VALUES ('10', '유니의류>가디건', '50000806');
INSERT INTO TMP_EP_CATE VALUES ('10', '유니의류>베스트/조끼', '50000834');
INSERT INTO TMP_EP_CATE VALUES ('10', '유니의류>셔츠', '50000833');
INSERT INTO TMP_EP_CATE VALUES ('10', '유니의류>반팔셔츠', '50000833');
INSERT INTO TMP_EP_CATE VALUES ('10', '유니의류>긴소매티셔츠', '50000830');
INSERT INTO TMP_EP_CATE VALUES ('10', '유니의류>반소매티셔츠', '50000830');
INSERT INTO TMP_EP_CATE VALUES ('10', '유니의류>나시/탑', '50000803');
INSERT INTO TMP_EP_CATE VALUES ('10', '유니의류>팬츠', '50000810');
INSERT INTO TMP_EP_CATE VALUES ('10', '유니의류>슬랙스', '50000836');
INSERT INTO TMP_EP_CATE VALUES ('10', '유니의류>반바지/숏츠', '50000810');
INSERT INTO TMP_EP_CATE VALUES ('10', '유니의류>점프수트', '50000811');
INSERT INTO TMP_EP_CATE VALUES ('10', '유니의류>레깅스', '50000812');
INSERT INTO TMP_EP_CATE VALUES ('10', '유니의류>데님>슬림/스키니', '50000809');
INSERT INTO TMP_EP_CATE VALUES ('10', '유니의류>데님>일자/스트레이트', '50000835');
INSERT INTO TMP_EP_CATE VALUES ('10', '유니의류>데님>부츠컷/와이드', '50000835');
INSERT INTO TMP_EP_CATE VALUES ('10', '유니의류>데님>쇼츠/반바지/9부', '50000809');
INSERT INTO TMP_EP_CATE VALUES ('10', '유니의류>데님>테이퍼드/배기/기타', '50000835');
INSERT INTO TMP_EP_CATE VALUES ('10', '스포츠>남성스포츠의류>상의', '50000841');
INSERT INTO TMP_EP_CATE VALUES ('10', '스포츠>남성스포츠의류>하의', '50000841');
INSERT INTO TMP_EP_CATE VALUES ('10', '스포츠>남성스포츠의류>세트', '50000841');
INSERT INTO TMP_EP_CATE VALUES ('10', '스포츠>남성스포츠의류>시즌의류', '50000841');
INSERT INTO TMP_EP_CATE VALUES ('10', '스포츠>여성스포츠의류>상의', '50003171');
INSERT INTO TMP_EP_CATE VALUES ('10', '스포츠>여성스포츠의류>하의', '50003172');
INSERT INTO TMP_EP_CATE VALUES ('10', '스포츠>여성스포츠의류>세트', '50003173');
INSERT INTO TMP_EP_CATE VALUES ('10', '스포츠>여성스포츠의류>시즌의류', '50000818');
INSERT INTO TMP_EP_CATE VALUES ('10', '스포츠>유니스포츠의류>상의', '50000841');
INSERT INTO TMP_EP_CATE VALUES ('10', '스포츠>유니스포츠의류>하의', '50000841');
INSERT INTO TMP_EP_CATE VALUES ('10', '스포츠>유니스포츠의류>세트', '50000841');
INSERT INTO TMP_EP_CATE VALUES ('10', '스포츠>유니스포츠의류>시즌의류', '50006381');
INSERT INTO TMP_EP_CATE VALUES ('10', '스포츠>스포츠잡화>운동화/등산화', '50001768');
INSERT INTO TMP_EP_CATE VALUES ('10', '스포츠>스포츠잡화>모자/가방/잡화', '50000022');
INSERT INTO TMP_EP_CATE VALUES ('10', '골프>남성골프의류>골프티셔츠', '50002796');
INSERT INTO TMP_EP_CATE VALUES ('10', '골프>남성골프의류>골프셔츠', '50002796');
INSERT INTO TMP_EP_CATE VALUES ('10', '골프>남성골프의류>골프조끼', '50002800');
INSERT INTO TMP_EP_CATE VALUES ('10', '골프>남성골프의류>골프바지', '50002801');
INSERT INTO TMP_EP_CATE VALUES ('10', '골프>남성골프의류>골프점퍼', '50002798');
INSERT INTO TMP_EP_CATE VALUES ('10', '골프>남성골프의류>골프자켓', '50002799');
INSERT INTO TMP_EP_CATE VALUES ('10', '골프>여성골프의류>골프티셔츠', '50002796');
INSERT INTO TMP_EP_CATE VALUES ('10', '골프>여성골프의류>골프셔츠', '50002796');
INSERT INTO TMP_EP_CATE VALUES ('10', '골프>여성골프의류>골프조끼', '50002800');
INSERT INTO TMP_EP_CATE VALUES ('10', '골프>여성골프의류>골프바지', '50002801');
INSERT INTO TMP_EP_CATE VALUES ('10', '골프>여성골프의류>골프점퍼', '50002798');
INSERT INTO TMP_EP_CATE VALUES ('10', '골프>여성골프의류>골프자켓', '50002799');
INSERT INTO TMP_EP_CATE VALUES ('10', '골프>골프잡화>골프화', '50001740');
INSERT INTO TMP_EP_CATE VALUES ('10', '골프>골프잡화>골프모자', '50002805');
INSERT INTO TMP_EP_CATE VALUES ('10', '골프>골프잡화>골프장갑', '50002804');
INSERT INTO TMP_EP_CATE VALUES ('10', '골프>골프잡화>골프벨트', '50002807');
INSERT INTO TMP_EP_CATE VALUES ('10', '골프>골프잡화>골프백', '50002795');
INSERT INTO TMP_EP_CATE VALUES ('10', '골프>골프잡화>골프양말', '50002806');
INSERT INTO TMP_EP_CATE VALUES ('10', '골프>골프잡화>골프기타잡화', '50002820');
INSERT INTO TMP_EP_CATE VALUES ('10', '언더웨어>여성언더웨어>팬티', '50000826');
INSERT INTO TMP_EP_CATE VALUES ('10', '언더웨어>여성언더웨어>브래지어', '50000823');
INSERT INTO TMP_EP_CATE VALUES ('10', '언더웨어>여성언더웨어>언더세트', '50000825');
INSERT INTO TMP_EP_CATE VALUES ('10', '언더웨어>여성언더웨어>나시/내의/잠옷', '50000826');
INSERT INTO TMP_EP_CATE VALUES ('10', '언더웨어>여성언더웨어>기타언더웨어', '50003816');
INSERT INTO TMP_EP_CATE VALUES ('10', '언더웨어>임부언더웨어>수유브라', '50004030');
INSERT INTO TMP_EP_CATE VALUES ('10', '언더웨어>임부언더웨어>임부팬티', '50004031');
INSERT INTO TMP_EP_CATE VALUES ('10', '언더웨어>임부언더웨어>임부내의', '50004032');
INSERT INTO TMP_EP_CATE VALUES ('10', '언더웨어>임부언더웨어>임부속옷', '50004033');
INSERT INTO TMP_EP_CATE VALUES ('10', '언더웨어>임부언더웨어>수유복', '50000487');
INSERT INTO TMP_EP_CATE VALUES ('10', '언더웨어>남성언더웨어>팬티', '50000845');
INSERT INTO TMP_EP_CATE VALUES ('10', '언더웨어>남성언더웨어>나시/내의/잠옷', '50000848');
INSERT INTO TMP_EP_CATE VALUES ('10', '언더웨어>남성언더웨어>기타언더웨어', '50000846');
INSERT INTO TMP_EP_CATE VALUES ('10', '언더웨어>남성언더웨어>언더세트', '50000847');
INSERT INTO TMP_EP_CATE VALUES ('10', '베이비>배냇저고리', '50000529');
INSERT INTO TMP_EP_CATE VALUES ('10', '베이비>배냇가운', '50000529');
INSERT INTO TMP_EP_CATE VALUES ('10', '베이비>우주복', '50000532');
INSERT INTO TMP_EP_CATE VALUES ('10', '베이비>바디슈트', '50000528');
INSERT INTO TMP_EP_CATE VALUES ('10', '베이비>출산선물', '50005307');
INSERT INTO TMP_EP_CATE VALUES ('10', '베이비>내의', '50007138');
INSERT INTO TMP_EP_CATE VALUES ('10', '베이비>실내복', '50007136');
INSERT INTO TMP_EP_CATE VALUES ('10', '베이비>팬티', '50007140');
INSERT INTO TMP_EP_CATE VALUES ('10', '베이비>런닝', '50007139');
INSERT INTO TMP_EP_CATE VALUES ('10', '베이비>언더세트', '50007142');
INSERT INTO TMP_EP_CATE VALUES ('10', '베이비>잠옷/수면의류', '50007136');
INSERT INTO TMP_EP_CATE VALUES ('10', '베이비>상하복세트', '50000271');
INSERT INTO TMP_EP_CATE VALUES ('10', '베이비>점퍼', '50000419');
INSERT INTO TMP_EP_CATE VALUES ('10', '베이비>자켓', '50000418');
INSERT INTO TMP_EP_CATE VALUES ('10', '베이비>코트', '50000420');
INSERT INTO TMP_EP_CATE VALUES ('10', '베이비>티셔츠', '50000535');
INSERT INTO TMP_EP_CATE VALUES ('10', '베이비>셔츠/블라우스', '50000536');
INSERT INTO TMP_EP_CATE VALUES ('10', '베이비>니트', '50000409');
INSERT INTO TMP_EP_CATE VALUES ('10', '베이비>가디건', '50000410');
INSERT INTO TMP_EP_CATE VALUES ('10', '베이비>베스트', '50000270');
INSERT INTO TMP_EP_CATE VALUES ('10', '베이비>원피스', '50000414');
INSERT INTO TMP_EP_CATE VALUES ('10', '베이비>스커트', '50000412');
INSERT INTO TMP_EP_CATE VALUES ('10', '베이비>팬츠', '50000411');
INSERT INTO TMP_EP_CATE VALUES ('10', '베이비>레깅스', '50007116');
INSERT INTO TMP_EP_CATE VALUES ('10', '베이비>치랭스', '50007116');
INSERT INTO TMP_EP_CATE VALUES ('10', '베이비>시즌테마의류', '50007122');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈여아>내의', '50007138');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈여아>실내복', '50007136');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈여아>잠옷/이너', '50007136');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈여아>팬티', '50007140');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈여아>런닝', '50007139');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈여아>상하복세트', '50007114');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈여아>점퍼', '50000419');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈여아>자켓', '50000418');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈여아>코트', '50000420');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈여아>티셔츠', '50000535');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈여아>셔츠/블라우스', '50007114');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈여아>니트', '50000409');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈여아>가디건', '50000410');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈여아>베스트', '50000270');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈여아>원피스', '50000414');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈여아>스커트', '50000412');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈여아>팬츠', '50000411');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈여아>데님팬츠', '50007115');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈여아>트레이닝팬츠', '50000416');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈여아>레깅스', '50007116');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈여아>치랭스', '50007116');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈여아>시즌테마의류', '50007122');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈남아>내의', '50007138');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈남아>실내복', '50007136');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈남아>잠옷/이너', '50007136');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈남아>팬티', '50007140');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈남아>런닝', '50007139');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈남아>상하복세트', '50007114');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈남아>점퍼', '50000419');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈남아>자켓', '50000418');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈남아>코트', '50000420');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈남아>티셔츠', '50000535');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈남아>셔츠', '50007114');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈남아>니트', '50000409');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈남아>가디건', '50000410');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈남아>조끼', '50000270');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈남아>팬츠', '50000411');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈남아>데님팬츠', '50007115');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈남아>트레이닝팬츠', '50000416');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈남아>시즌테마의류', '50007122');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈공용>내의', '50007138');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈공용>실내복', '50007136');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈공용>잠옷/이너', '50007136');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈공용>상하복세트', '50007114');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈공용>점퍼', '50000419');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈공용>자켓', '50000418');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈공용>코트', '50000420');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈공용>티셔츠', '50000535');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈공용>셔츠', '50007114');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈공용>니트', '50000409');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈공용>가디건', '50000410');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈공용>조끼', '50000270');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈공용>팬츠', '50000411');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈공용>데님팬츠', '50007115');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈공용>트레이닝팬츠', '50000416');
INSERT INTO TMP_EP_CATE VALUES ('10', '키즈공용>시즌테마의류', '50007122');
INSERT INTO TMP_EP_CATE VALUES ('10', '주니어여아>코트', '50000420');
INSERT INTO TMP_EP_CATE VALUES ('10', '주니어여아>점퍼/자켓', '50000419');
INSERT INTO TMP_EP_CATE VALUES ('10', '주니어여아>티셔츠', '50000535');
INSERT INTO TMP_EP_CATE VALUES ('10', '주니어여아>셔츠', '50007114');
INSERT INTO TMP_EP_CATE VALUES ('10', '주니어여아>면팬츠', '50000411');
INSERT INTO TMP_EP_CATE VALUES ('10', '주니어여아>데님팬츠', '50007115');
INSERT INTO TMP_EP_CATE VALUES ('10', '주니어여아>트레이닝팬츠', '50000416');
INSERT INTO TMP_EP_CATE VALUES ('10', '주니어여아>상하복세트', '50007114');
INSERT INTO TMP_EP_CATE VALUES ('10', '주니어여아>원피스', '50000414');
INSERT INTO TMP_EP_CATE VALUES ('10', '주니어여아>스커트', '50000412');
INSERT INTO TMP_EP_CATE VALUES ('10', '주니어여아>속옷', '50007143');
INSERT INTO TMP_EP_CATE VALUES ('10', '주니어여아>니트/가디건/조끼', '50000409');
INSERT INTO TMP_EP_CATE VALUES ('10', '주니어여아>시즌테마의류', '50007122');
INSERT INTO TMP_EP_CATE VALUES ('10', '주니어남아>코트', '50000420');
INSERT INTO TMP_EP_CATE VALUES ('10', '주니어남아>점퍼/자켓', '50000419');
INSERT INTO TMP_EP_CATE VALUES ('10', '주니어남아>티셔츠', '50000535');
INSERT INTO TMP_EP_CATE VALUES ('10', '주니어남아>셔츠', '50007114');
INSERT INTO TMP_EP_CATE VALUES ('10', '주니어남아>면팬츠', '50000411');
INSERT INTO TMP_EP_CATE VALUES ('10', '주니어남아>데님팬츠', '50007115');
INSERT INTO TMP_EP_CATE VALUES ('10', '주니어남아>트레이닝팬츠', '50000416');
INSERT INTO TMP_EP_CATE VALUES ('10', '주니어남아>상하복세트', '50007114');
INSERT INTO TMP_EP_CATE VALUES ('10', '주니어남아>속옷', '50007142');
INSERT INTO TMP_EP_CATE VALUES ('10', '주니어남아>니트/가디건/조끼', '50000409');
INSERT INTO TMP_EP_CATE VALUES ('10', '주니어남아>시즌테마의류', '50007122');
INSERT INTO TMP_EP_CATE VALUES ('10', '주니어공용>코트', '50000420');
INSERT INTO TMP_EP_CATE VALUES ('10', '주니어공용>점퍼/자켓', '50000419');
INSERT INTO TMP_EP_CATE VALUES ('10', '주니어공용>티셔츠', '50000535');
INSERT INTO TMP_EP_CATE VALUES ('10', '주니어공용>셔츠', '50007114');
INSERT INTO TMP_EP_CATE VALUES ('10', '주니어공용>면팬츠', '50000411');
INSERT INTO TMP_EP_CATE VALUES ('10', '주니어공용>데님팬츠', '50007115');
INSERT INTO TMP_EP_CATE VALUES ('10', '주니어공용>트레이닝팬츠', '50000416');
INSERT INTO TMP_EP_CATE VALUES ('10', '주니어공용>니트/가디건/조끼', '50000409');
INSERT INTO TMP_EP_CATE VALUES ('10', '주니어공용>상하복세트', '50007114');
INSERT INTO TMP_EP_CATE VALUES ('10', '주니어공용>시즌테마의류', '50007122');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>여성잡화>운동화', '50003839');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>여성잡화>구두/신발', '50003818');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>여성잡화>가방', '50000639');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>여성잡화>지갑', '50003983');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>여성잡화>벨트', '50000539');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>여성잡화>스카프', '50004010');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>여성잡화>머플러', '50000565');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>여성잡화>워머', '50000566');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>여성잡화>모자', '50003992');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>여성잡화>장갑', '50000551');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>여성잡화>양말', '50003995');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>여성잡화>스타킹', '50004023');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>여성잡화>기타잡화', '50000563');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>여성잡화>시계/주얼리/순금', '50004158');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>남성잡화>운동화', '50003854');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>남성잡화>구두/신발', '50000783');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>남성잡화>가방', '50000651');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>남성잡화>지갑', '50003985');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>남성잡화>벨트', '50003989');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>남성잡화>안경/선글라스', '50000554');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>남성잡화>머플러', '50000565');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>남성잡화>워머', '50000566');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>남성잡화>모자', '50003992');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>남성잡화>장갑', '50000552');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>남성잡화>양말', '50004003');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>남성잡화>기타잡화', '50004012');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>남성잡화>시계/주얼리/순금', '50004140');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>아동잡화>신발', '50004198');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>아동잡화>모자', '50000349');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>아동잡화>우산', '50000226');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>아동잡화>우비', '50007125');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>아동잡화>장화', '50005466');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>아동잡화>가방', '50004206');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>아동잡화>양말', '50000223');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>아동잡화>타이즈', '50007126');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>아동잡화>스카프', '50000353');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>아동잡화>머플러', '50000352');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>아동잡화>장갑', '50000350');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>아동잡화>워머', '50000352');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>아동잡화>스타킹', '50007126');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>아동잡화>헤어/패션잡화', '50007112');
INSERT INTO TMP_EP_CATE VALUES ('10', '패션잡화>아동잡화>시즌잡화', '50000269');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>클렌징>클렌징폼', '50000451');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>클렌징>클렌징크림', '50000453');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>클렌징>클렌징오일', '50000452');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>클렌징>클렌징로션/워터', '50000456');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>클렌징>필링/스크럽', '50000461');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>클렌징>클렌징티슈', '50000457');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>클렌징>립&아이리무버', '50000460');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>클렌징>파우더 워시', '50000459');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>클렌징>천연/미용비누', '50000458');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>스킨케어>스킨', '50000437');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>스킨케어>로션', '50000438');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>스킨케어>크림/오일', '50000440');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>스킨케어>에센스', '50000439');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>스킨케어>아이케어', '50000441');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>스킨케어>팩/마스크', '50000469');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>스킨케어>마사지', '50000468');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>스킨케어>세트', '50000444');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>스킨케어>미니어쳐', '50000444');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>선케어>썬로션', '50000445');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>선케어>썬크림', '50000445');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>선케어>썬스프레이', '50000446');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>선케어>애프터썬케어', '50000449');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>선케어>썬밤', '50000447');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>베이스메이크업>BB크림', '50000470');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>베이스메이크업>CC크림', '50000471');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>베이스메이크업>메이크업베이스', '50000345');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>베이스메이크업>컨실러', '50000347');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>베이스메이크업>트윈케이크', '50000346');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>베이스메이크업>팩트파우더', '50004580');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>베이스메이크업>루스파우더', '50004196');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>베이스메이크업>파운데이션', '50005288');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>베이스메이크업>프라이머', '50000472');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>베이스메이크업>메이크업세트', '50000390');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>색조메이크업>아이섀도우', '50000396');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>색조메이크업>아이라이너', '50004584');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>색조메이크업>마스카라', '50000397');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>색조메이크업>아이브로우', '50000398');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>색조메이크업>블러셔', '50000399');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>색조메이크업>하이라이터', '50000400');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>색조메이크업>립글로스', '50000393');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>색조메이크업>립스틱', '50000391');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>색조메이크업>립라이너', '50000395');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>색조메이크업>틴트', '50000394');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>색조메이크업>립케어', '50000392');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>네일케어>네일칼라', '50000402');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>네일케어>네일케어', '50000407');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>네일케어>네일리무버', '50000405');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>네일케어>네일아트', '50000403');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>네일케어>네일스티커', '50000403');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>바디케어>바디클렌저', '50000285');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>바디케어>바디세트', '50000285');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>바디케어>바디솝', '50000288');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>바디케어>바디스크럽', '50000286');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>바디케어>입욕제', '50000291');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>바디케어>여성청결제', '50000287');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>바디케어>바디로션/크림', '50000408');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>바디케어>샤워코롱', '50005287');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>바디케어>바디파우더', '50000284');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>바디케어>태닝', '50004404');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>바디케어>아로마테라피', '50000292');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>바디케어>바디미스트', '50000283');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>바디케어>제모제', '50000294');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>바디케어>데오드란트', '50000293');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>바디케어>바디슬리밍', '50000295');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>바디케어>풋케어', '50000290');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>바디케어>핸드케어', '50000289');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>헤어케어>샴푸/린스', '50000297');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>헤어케어>팩/트리트먼트', '50000299');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>헤어케어>헤어에센스/앰플', '50000300');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>헤어케어>헤어세트', '50000305');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>헤어케어>탈모케어', '50000304');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>헤어스타일링>염색약', '50000311');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>헤어스타일링>파마약', '50004585');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>헤어스타일링>스프레이', '50000307');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>헤어스타일링>무스', '50000308');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>헤어스타일링>헤어젤', '50000309');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>남성화장품>스킨', '50000321');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>남성화장품>로션', '50000322');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>남성화장품>화장품세트', '50000334');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>남성화장품>에센스/크림', '50000324');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>남성화장품>클렌징', '50000328');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>남성화장품>필링/스크럽', '50000329');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>남성화장품>쉐이빙', '50000332');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>남성화장품>남성메이크업', '50000331');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>남성화장품>남성선케어', '50000327');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>남성화장품>마스크팩/코팩', '50000330');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>향수>남성향수', '50000313');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>향수>여성향수', '50000312');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>향수>공용향수', '50000314');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>향수>세트/미니어처', '50000315');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>뷰티소품>바디소품', '50000316');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>뷰티소품>아이소품', '50004386');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>뷰티소품>페이스소품', '50004395');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>뷰티소품>헤어소품', '50004401');
INSERT INTO TMP_EP_CATE VALUES ('10', '화장품/미용>뷰티소품>기타뷰티소품', '50000316');
INSERT INTO TMP_EP_CATE VALUES ('10', '출산/육아>출산준비물>출산선물세트', '50005307');
INSERT INTO TMP_EP_CATE VALUES ('10', '출산/육아>출산준비물>겉속싸개/손발싸개', '50000530');
INSERT INTO TMP_EP_CATE VALUES ('10', '출산/육아>출산준비물>손수건', '50005306');
INSERT INTO TMP_EP_CATE VALUES ('10', '출산/육아>위생용품', '50000604');
INSERT INTO TMP_EP_CATE VALUES ('10', '출산/육아>목욕용품', '50000716');
INSERT INTO TMP_EP_CATE VALUES ('10', '출산/육아>기타생활용품', '50000584');
INSERT INTO TMP_EP_CATE VALUES ('10', '출산/육아>수유이유용품', '50000685');
INSERT INTO TMP_EP_CATE VALUES ('10', '출산/육아>유아식기', '50000478');
INSERT INTO TMP_EP_CATE VALUES ('10', '출산/육아>유아스킨케어', '50000719');
INSERT INTO TMP_EP_CATE VALUES ('10', '출산/육아>유아침구>아기이불/요/패드', '50000512');
INSERT INTO TMP_EP_CATE VALUES ('10', '출산/육아>유아침구>유아배게', '50005304');
INSERT INTO TMP_EP_CATE VALUES ('10', '출산/육아>완구/교구', '50004646');
INSERT INTO TMP_EP_CATE VALUES ('10', '출산/육아>유아가구/리빙', '50000476');
INSERT INTO TMP_EP_CATE VALUES ('10', '출산/육아>이동/외출/안전용품', '50000704');
INSERT INTO TMP_EP_CATE VALUES ('10', '생활용품>세제/세정/탈취>세탁세제', '50002509');
INSERT INTO TMP_EP_CATE VALUES ('10', '생활용품>세제/세정/탈취>섬유유연제', '50002675');
INSERT INTO TMP_EP_CATE VALUES ('10', '생활용품>세제/세정/탈취>주방세제', '50002497');
INSERT INTO TMP_EP_CATE VALUES ('10', '생활용품>세제/세정/탈취>탈취/방향제', '50002681');
INSERT INTO TMP_EP_CATE VALUES ('10', '생활용품>세제/세정/탈취>해충퇴치용품', '50006956');
INSERT INTO TMP_EP_CATE VALUES ('10', '생활용품>세제/세정/탈취>살균소독제', '50002499');
INSERT INTO TMP_EP_CATE VALUES ('10', '생활용품>위생용품>화장지', '50002486');
INSERT INTO TMP_EP_CATE VALUES ('10', '생활용품>위생용품>키친타올', '50002487');
INSERT INTO TMP_EP_CATE VALUES ('10', '생활용품>위생용품>생리대/팬티라이너', '50002491');
INSERT INTO TMP_EP_CATE VALUES ('10', '생활용품>위생용품>구강용품', '50001933');
INSERT INTO TMP_EP_CATE VALUES ('10', '생활용품>위생용품>렌즈/눈관리용품', '50001944');
INSERT INTO TMP_EP_CATE VALUES ('10', '생활용품>욕실용품>면도용품', '50002308');
INSERT INTO TMP_EP_CATE VALUES ('10', '생활용품>욕실용품>욕실정리용품', '50008688');
INSERT INTO TMP_EP_CATE VALUES ('10', '생활용품>욕실용품>샤워용품', '50008530');
INSERT INTO TMP_EP_CATE VALUES ('10', '생활용품>주방용품>식기', '50004533');
INSERT INTO TMP_EP_CATE VALUES ('10', '생활용품>주방용품>잔/컵', '50004537');
INSERT INTO TMP_EP_CATE VALUES ('10', '생활용품>주방용품>보관/밀폐용기', '50004576');
INSERT INTO TMP_EP_CATE VALUES ('10', '생활용품>주방용품>조리기구', '50004779');
INSERT INTO TMP_EP_CATE VALUES ('10', '생활용품>주방용품>커피/차용품', '50004562');
INSERT INTO TMP_EP_CATE VALUES ('10', '생활용품>주방용품>주방잡화', '50004832');
INSERT INTO TMP_EP_CATE VALUES ('10', '생활용품>주방용품>베이킹/제빵', '50004814');
INSERT INTO TMP_EP_CATE VALUES ('10', '가구/인테리어>가구>침실가구', '50001309');
INSERT INTO TMP_EP_CATE VALUES ('10', '가구/인테리어>가구>주방가구', '50001318');
INSERT INTO TMP_EP_CATE VALUES ('10', '가구/인테리어>가구>수납가구', '50001320');
INSERT INTO TMP_EP_CATE VALUES ('10', '가구/인테리어>가구>오피스가구', '50003304');
INSERT INTO TMP_EP_CATE VALUES ('10', '가구/인테리어>침구>침구세트', '50003493');
INSERT INTO TMP_EP_CATE VALUES ('10', '가구/인테리어>침구>이불솜/배게솜/요솜', '50003509');
INSERT INTO TMP_EP_CATE VALUES ('10', '가구/인테리어>커튼', '50003514');
INSERT INTO TMP_EP_CATE VALUES ('10', '가구/인테리어>블라인드/롤스크린', '50000859');
INSERT INTO TMP_EP_CATE VALUES ('10', '가구/인테리어>카페트/러그', '50000981');
INSERT INTO TMP_EP_CATE VALUES ('10', '가구/인테리어>인테리어소품>거울', '50003237');
INSERT INTO TMP_EP_CATE VALUES ('10', '가구/인테리어>인테리어소품>시계', '50003343');
INSERT INTO TMP_EP_CATE VALUES ('10', '가구/인테리어>인테리어소품>조명', '50003334');
INSERT INTO TMP_EP_CATE VALUES ('10', '가구/인테리어>인테리어소품>액자', '50003347');
INSERT INTO TMP_EP_CATE VALUES ('10', '가구/인테리어>인테리어소품>캔들/디퓨저', '50003353');
INSERT INTO TMP_EP_CATE VALUES ('10', '가구/인테리어>인테리어소품>홈데코소품', '50003656');
INSERT INTO TMP_EP_CATE VALUES ('10', '디지털/가전>생활가전', '50006368');
INSERT INTO TMP_EP_CATE VALUES ('10', '디지털/가전>주방가전', '50001726');
INSERT INTO TMP_EP_CATE VALUES ('10', '디지털/가전>계절가전', '50002540');
INSERT INTO TMP_EP_CATE VALUES ('10', '디지털/가전>미용가전', '50001864');
INSERT INTO TMP_EP_CATE VALUES ('10', '디지털/가전>음향가전', '50002322');
INSERT INTO TMP_EP_CATE VALUES ('10', '디지털/가전>영상가전', '50000153');
INSERT INTO TMP_EP_CATE VALUES ('10', '디지털/가전>휴대폰악세서리', '50000264');
INSERT INTO TMP_EP_CATE VALUES ('10', '디지털/가전>학습기기', '50001730');
INSERT INTO TMP_EP_CATE VALUES ('10', '디지털/가전>카메라/캠코더', '50002919');
INSERT INTO TMP_EP_CATE VALUES ('10', '디지털/가전>PC/노트북/액서서리', '50000151');
INSERT INTO TMP_EP_CATE VALUES ('10', '디지털/가전>주변기기', '50001587');
INSERT INTO TMP_EP_CATE VALUES ('10', '디지털/가전>건강가전', '50001830');
INSERT INTO TMP_EP_CATE VALUES ('10', '문구/취미>문구/팬시>필기류', '50008888');
INSERT INTO TMP_EP_CATE VALUES ('10', '문구/취미>문구/팬시>노트류', '50003549');
INSERT INTO TMP_EP_CATE VALUES ('10', '문구/취미>문구/팬시>디자인문구용품', '50003549');
INSERT INTO TMP_EP_CATE VALUES ('10', '문구/취미>문구/팬시>선물/팬시류', '50003767');
INSERT INTO TMP_EP_CATE VALUES ('10', '문구/취미>사무용품', '50006877');
INSERT INTO TMP_EP_CATE VALUES ('10', '문구/취미>애완용품', '50000233');
INSERT INTO TMP_EP_CATE VALUES ('10', '문구/취미>키덜트', '50004278');
INSERT INTO TMP_EP_CATE VALUES ('10', '문구/취미>취미/여가', '50007337');
INSERT INTO TMP_EP_CATE VALUES ('10', '도서>영유아서적>유아전집', '50006387');
INSERT INTO TMP_EP_CATE VALUES ('10', '도서>영유아서적>스티커북/퍼즐북', '50004433');
INSERT INTO TMP_EP_CATE VALUES ('10', '도서>영유아서적>그림/색칠공부', '50004434');
INSERT INTO TMP_EP_CATE VALUES ('10', '도서>영유아서적>종이접기/만들기', '50006998');
INSERT INTO TMP_EP_CATE VALUES ('10', '도서>영유아서적>워크북', '50004429');
INSERT INTO TMP_EP_CATE VALUES ('10', '도서>영유아서적>팝업/헝겊책', '50004227');
INSERT INTO TMP_EP_CATE VALUES ('10', '도서>영유아서적>창작/인성/전래/유아동화', '50006391');
INSERT INTO TMP_EP_CATE VALUES ('10', '도서>자격증/수험서', '50007340');
INSERT INTO TMP_EP_CATE VALUES ('10', '도서>참고서', '50007340');
INSERT INTO TMP_EP_CATE VALUES ('10', '도서>경제/경영', '50007340');
INSERT INTO TMP_EP_CATE VALUES ('10', '도서>외국어', '50007335');
INSERT INTO TMP_EP_CATE VALUES ('10', '도서>예술', '50007337');
INSERT INTO TMP_EP_CATE VALUES ('10', '도서>예체능', '50006397');
INSERT INTO TMP_EP_CATE VALUES ('10', '도서>가정/생활/요리', '50007339');
INSERT INTO TMP_EP_CATE VALUES ('10', '도서>교양/취미', '50006397');
INSERT INTO TMP_EP_CATE VALUES ('10', '도서>문화/예술', '50006397');
INSERT INTO TMP_EP_CATE VALUES ('10', '도서>소설', '50006398');
INSERT INTO TMP_EP_CATE VALUES ('10', '도서>문학/논술', '50006398');
INSERT INTO TMP_EP_CATE VALUES ('10', '도서>만화', '50006398');
INSERT INTO TMP_EP_CATE VALUES ('10', '도서>초/중/고학습>과학/자연관찰/백과', '50006396');
INSERT INTO TMP_EP_CATE VALUES ('10', '도서>초/중/고학습>역사/사회/위인', '50006398');
INSERT INTO TMP_EP_CATE VALUES ('10', '도서>초/중/고학습>한글/수학', '50006394');
INSERT INTO TMP_EP_CATE VALUES ('10', '도서>초/중/고학습>학습만화', '50006398');
INSERT INTO TMP_EP_CATE VALUES ('10', '도서>초/중/고학습>청소년전집', '50006391');
INSERT INTO TMP_EP_CATE VALUES ('10', '도서>DVD/음반', '50000222');

-- UPDATE TMP_EP_CATE SET ITEMKIND_NM = CONCAT(ITEMKIND_NM,'>');

COMMIT;

SELECT * FROM TMP_EP_CATE;

TRUNCATE TABLE TB_EP_CATE;
INSERT INTO TB_EP_CATE
SELECT EP_GB
     , ITEMKIND_CD
     , EP_CATE_CD
     , NULL          AS EP_CATE_NM
     , 'Y'           AS USE_YN
     , 1             AS REG_NO
     , NOW()         AS REG_DT
     , 1             AS UPD_NO
     , NOW()         AS UPD_DT
FROM   (
        SELECT A.EP_GB
             , (SELECT ITEMKIND_CD
                FROM   TB_ITEMKIND
                WHERE  ITEMKIND_NM = A.ITEMKIND_NM
               )             AS ITEMKIND_CD
             , A.ITEMKIND_NM
             , A.EP_CATE_CD
        FROM   TMP_EP_CATE A
       ) Z
WHERE  ITEMKIND_CD IS NOT NULL
AND    NOT EXISTS (SELECT 1
                   FROM   TB_EP_CATE
                   WHERE  EP_GB = Z.EP_GB
                   AND    ITEMKIND_CD = Z.ITEMKIND_CD
                   AND    EP_CATE_CD = Z.EP_CATE_CD
                  )
;

SELECT * FROM TB_EP_CATE;

-- EP데이터는 있으나 품목 데이터가 없는 거 조회
SELECT ITEMKIND_CD
     , ITEMKIND_NM
FROM   (
        SELECT A.EP_GB
             , (SELECT ITEMKIND_CD
                FROM   TB_ITEMKIND
                WHERE  ITEMKIND_NM = A.ITEMKIND_NM
               )             AS ITEMKIND_CD
             , A.ITEMKIND_NM
             , A.EP_CATE_CD
        FROM   TMP_EP_CATE A
       ) Z
WHERE  ITEMKIND_CD IS NULL
;