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

THISISNEVERTHAT 2017 S/S

 0     145     February 24 2017

VIABON DE VIA 2017 S/S

 0     236     February 23 2017

STEALMONSTER 2017 S/S

 0     185     February 23 2017

PLAYMONSTER 2017 S/S

 0     162     February 23 2017

SLEAZY CORNER 2017 S/S

 0     248     February 23 2017

WVPROJECT 2017 S/S

 3     256     February 23 2017

LMC 2017 S/S

 0     310     February 22 2017

FATALISM 2017 S/S

 0     252     February 21 2017

13MONTH 2017 S/S

 0     294     February 21 2017

UNIIS DESIGN 2017 S/S

 1     423     February 20 2017

J.DAUL 2017 S/S

 0     310     February 20 2017

ROMANTIC CROWN 2017 S/S

 0     555     February 20 2017

VIVASTUDIO 2017 S/S

 0     718     February 17 2017

CRITIC 2017 SPRING

 0     605     February 17 2017

AROUND80 2017 S/S

 1     441     February 17 2017

URBANDTYPE 2017 S/S

 0     474     February 16 2017

XERO 2017 S/S

 0     512     February 16 2017

DEBB 2017 S/S

 0     463     February 15 2017

PEGADOR 2017 S/S

 1     659     February 14 2017

GRASSHOPPER 2017 S/S

 2     699     February 13 2017

PIECE MAKER 2017 SPRING

 1     910     February 10 2017

LIFUL 2017 S/S

 0     1076     February 10 2017

UNIFORM BRIDGE 2017 S/S

 0     926     February 10 2017

DCUMA 2017 SPRING

 2     661     February 10 2017

UNALLOYED 2017 S/S

 0     1133     February 10 2017

SLEEPYSLIP 2017 S/S

 4     1275     February 3 2017

CRITIC WEAR MFG 2017 SPRING

 4     2084     February 1 2017

SHETHISCOMMA 2017 S/S

 2     1610     January 26 2017

WOLPENDER 2017 S/S

 2     1468     January 25 2017

PLAYIAN 2016 F/W

 1     1464     January 20 2017