Select RelatedColorNameEn,RelatedColorNo From TB_CodeRelatedColor Where RelatedColorNoIsUse = 1 and RelatedColorNameEn in ( select RelatedColor from ( select RelatedColor, (select count(*) from VW_Product As A Inner Join TB_CollectionColor As B On A.CodeProductColor = B.CodeProductColor Inner Join TB_Collection As C On B.CollectionNo = C.CollectionNo where CodeProductStatusNo = 1 And ProductStock > 0 and ColorIsUse = 1 and (p_type in (0)) and (B.codeProductColor = 'E609' ) and A.CodeProductColor = TB_CodeProductColor.CodeProductColor) as cnt from TB_CodeProductColor where ColorIsUse = 1 ) tempTable where cnt > 0 )

lesportsac

HomeCOLLECTION

COLLECTION

SELECT GROUP
SELECT COLOR
SELECT PRINT MOTIF

MONOGRAM FLORAL

신상품순

15 items: View 12 | View all

BACK
1 2 다음 페이지

TOP