select distinct wr_parent from hhp_write_lookbook where ca_name != 'STUDIO' and ((INSTR(wr_4, '캐주얼')) ) and (wr_num between -2458 and (-2458 + 10000))

PLAYIAN 2016 F/W

 0     51     January 20 2017

USUAL EDIT 2017 WINTER

 0     436     January 16 2017

IDIOTS 2016 F/W

 0     651     January 10 2017

RUGGED HOUSE 2016 F/W Part.2

 0     859     January 5 2017

WESTWARD CALIFORNIA 2016 WINTER

 0     968     January 4 2017

INDIGO CHILDREN 2016 WINTER

 0     985     December 29 2016

NOWWHAT 2016 F/W

 0     975     December 29 2016

BROWNPEANUT 2016 F/W Part.1

 0     1038     December 27 2016

VACAY 2016 F/W

 0     1498     December 23 2016

CHISWICK 2016 F/W

 0     1467     December 22 2016

MOSTWM 2016 F/W

 0     753     December 22 2016

STRIKE 2016 F/W

 0     713     December 22 2016

MANFROMUS 2016 F/W

 0     747     December 22 2016

GAINSBORO 2016 F/W

 0     721     December 21 2016

CAMEL WORK 2016 A/W

 0     1065     December 20 2016

ELLIOTI 2016 F/W

 0     849     December 20 2016

KING 2016 A/W

 0     1631     December 14 2016

GOODFELLAS 2016 A/W part.3

 0     1273     December 14 2016

QT8 2016 WINTER

 0     1262     December 14 2016

D.PRIQUE 2016 F/W

 1     1472     December 12 2016

WNDERKAMMER 2016 F/W

 0     1084     December 12 2016

ACOVER 2016 F/W Part.3

 0     1315     December 12 2016

CITLUS 2016 F/W

 0     1465     December 7 2016

LIFUL 2016 WINTER LOOKBOOK

 0     1087     December 6 2016

MOSCA 2016 F/W LOOKBOOK

 0     1200     November 30 2016

UNIFORM BRIDGE 2016-2017 A/W LOOKBOOK part. 3

 0     1133     November 28 2016

NAKEDSENSE 2016 WINTER LOOKBOOK

 0     1166     November 24 2016

WOLPENDER 2016 F/W LOOKBOOK

 0     1160     November 22 2016

AOTT 2016 WINTER LOOKBOOK

 0     1430     November 18 2016

STONY STRIDE 2016 F/W LOOKBOOK Part.2

 0     1136     November 16 2016