select distinct wr_parent from hhp_write_lookbook where ca_name != 'STUDIO' and ((INSTR(wr_4, '힙합퍼닷컴')) ) and (wr_num between -2504 and (-2504 + 10000))

ACOVER 2017 S/S

 0     168     February 27 2017

THISISNEVERTHAT 2017 S/S

 2     692     February 24 2017

VIABON DE VIA 2017 S/S

 0     466     February 23 2017

STEALMONSTER 2017 S/S

 0     386     February 23 2017

PLAYMONSTER 2017 S/S

 0     349     February 23 2017

SLEAZY CORNER 2017 S/S

 0     498     February 23 2017

WVPROJECT 2017 S/S

 3     412     February 23 2017

FATALISM 2017 S/S

 0     366     February 21 2017

13MONTH 2017 S/S

 0     418     February 21 2017

UNIIS DESIGN 2017 S/S

 1     571     February 20 2017

J.DAUL 2017 S/S

 0     425     February 20 2017

ROMANTIC CROWN 2017 S/S

 0     734     February 20 2017

VIVASTUDIO 2017 S/S

 0     856     February 17 2017

CRITIC 2017 SPRING

 0     745     February 17 2017

DEBB 2017 S/S

 0     551     February 15 2017

PEGADOR 2017 S/S

 1     748     February 14 2017

PIECE MAKER 2017 SPRING

 1     998     February 10 2017

DCUMA 2017 SPRING

 2     683     February 10 2017

UNALLOYED 2017 S/S

 0     1159     February 10 2017

SLEEPYSLIP 2017 S/S

 4     1330     February 3 2017

CRITIC WEAR MFG 2017 SPRING

 4     2165     February 1 2017

SHETHISCOMMA 2017 S/S

 2     1673     January 26 2017

WOLPENDER 2017 S/S

 2     1535     January 25 2017

PLAYIAN 2016 F/W

 1     1504     January 20 2017

USUAL EDIT 2017 WINTER

 0     1434     January 16 2017

IDIOTS 2016 F/W

 1     1483     January 10 2017

RUGGED HOUSE 2016 F/W Part.2

 0     1768     January 5 2017

WESTWARD CALIFORNIA 2016 WINTER

 0     1849     January 4 2017

INDIGO CHILDREN 2016 WINTER

 0     1642     December 29 2016

NOWWHAT 2016 F/W

 0     1639     December 29 2016