select distinct wr_parent from hhp_write_lookbook where ca_name != 'STUDIO' and ((INSTR(wr_4, '룩북')) ) and (wr_num between -2808 and (-2808 + 10000))

ONA 2017 S/S

 2     333     July 20 2017

VASTIC 2017 SUMMER

 0     224     July 20 2017

APPARELXIT 2017 SUMMER

 0     592     July 14 2017

MAUVE 2017 SUMMER

 0     642     July 14 2017

AKIYORU 2017 S/S

 1     766     July 4 2017

NINE ELEVEN 2017 S/S

 1     611     July 4 2017

USUAL EDIT 2017 SUMMER

 1     521     July 4 2017

WV PROJECT 2017 SUMMER

 2     1131     June 30 2017

NOWWHAT 2017 S/S

 0     882     June 28 2017

OBEY KOREA 2017 S/S

 1     1446     June 28 2017

XXIX 2017 S/S

 2     688     June 26 2017

DELTA MILSPEC 2017 S/S

 0     582     June 26 2017

SPUNKY 2017 SUMMER

 0     700     June 23 2017

GOODFELLAS 2017 S/S

 0     983     June 19 2017

MAINBOOTH 2017 SUMMER

 0     791     June 19 2017

KING 2017 S/S

 0     896     June 15 2017

FRIZMWORKS 2017 S/S

 0     810     June 15 2017

ADEMER 2017 S/S

 0     693     June 13 2017

CANEBROS 2017 S/S

 0     860     June 13 2017

UNIISDESIGN 2017 S/S

 0     741     June 13 2017

APPARELXIT 2017 S/S

 0     703     June 13 2017

BASEMOMENT 2017 S/S

 0     673     June 13 2017

MALAHAZY 2017 S/S

 0     724     June 13 2017

199XKIDS 2017 S/S

 0     831     June 12 2017

NOIR 2017 SUMMER

 0     631     June 12 2017

OUTSTANDING ORDINARY 2017 SUMMER

 0     615     June 12 2017

CODE IM 2017 SUMMER

 0     612     June 12 2017

LOKWARD 2017 S/S

 0     530     June 12 2017

QUEITIST 2017 SUMMER

 0     588     June 12 2017

SCULPTOR 2017 SUMMER

 0     828     June 9 2017