배송비

무료배송

배송사

로젠택배

도서산간

6,000원 (제주: 6,000원) 도서산간지역보기

출고마감

15시

이력번호

803047909215

가공일

2024-11-21

소비기한

2026-11-20

재고

재고

공급불가지역

인증

인증

주문마감

주문마감

도착예정일

오늘 오전 10시까지 결제 시
내일 도착

SELECT Uid, Summary, ImgBanner, Discount, DiscountUnit, IsUseGoodsType, kind, StartDate, EndDate, likedealerid, isUseLimitDay, useLimitDay, useStartDate, useEndDate, MinPrice, Title FROM T_COUPON (nolock) AS C WHERE SiteID='deefub2b' AND IsUse=? AND (Kind=? or Kind=? or Kind=? or Kind=? or Kind=? or Kind=? or Kind=? or Kind=? or Kind=? or Kind=? or Kind=? or Kind=? ) AND ( UseMode='0' OR Uid IN (SELECT CouponUid FROM T_COUPON_GOODS_USE (nolock) WHERE GoodsUid=? AND CateCode=?) OR (SELECT COUNT(*) FROM fnGetCateParent('deefub2b', ?) WHERE CateCode=C.IssueCateCode)>0 ) AND ( (IssueMode='0' OR IssueMode Is Null) OR Uid IN (SELECT CouponUid FROM T_COUPON_GOODS_ISSUE (nolock) WHERE GoodsUid=? AND CateCode=?) OR (SELECT COUNT(*) FROM fnGetCateParent('deefub2b', ?) WHERE CateCode=C.IssueCateCode)>0 OR IssueEventUid IN (SELECT E.Uid FROM T_EVENT (nolock) AS E JOIN T_EVENT_GOODS (nolock) AS EG ON E.Uid=EG.EventUid WHERE E.Method='100' AND E.IsIng='T' AND E.State='100' AND EG.GoodsUid=? AND EG.CateCode=?) ) and (issueLimit = 0 or issueLimit > (SELECT COUNT(*) FROM T_COUPON_MEMBER WHERE SiteID=C.SiteID AND CouponUid=C.Uid AND IsTrash = 'F'))

할인쿠폰

사용 가능한 할인 쿠폰이 있어요! 할인쿠폰 받기

할인쿠폰 받기

전체받기