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     224     February 24 2017

QUIETIST 2017 S/S

 0     157     February 24 2017

FROM A TO B 2017 S/S

 0     155     February 24 2017

VIABON DE VIA 2017 S/S

 0     269     February 23 2017

URBANSTOFF 2017 S/S

 0     250     February 23 2017

STEALMONSTER 2017 S/S

 0     212     February 23 2017

JOHNNY CARSON 2017 S/S

 2     206     February 23 2017

PLAYMONSTER 2017 S/S

 0     186     February 23 2017

SLEAZY CORNER 2017 S/S

 0     284     February 23 2017

WVPROJECT 2017 S/S

 3     279     February 23 2017

LMC 2017 S/S

 0     330     February 22 2017

I AM NOT A HUMAN BEING 2017 S/S

 0     435     February 21 2017

FATALISM 2017 S/S

 0     265     February 21 2017

13MONTH 2017 S/S

 0     306     February 21 2017

UNIIS DESIGN 2017 S/S

 1     438     February 20 2017

J.DAUL 2017 S/S

 0     318     February 20 2017

ROMANTIC CROWN 2017 S/S

 0     574     February 20 2017

VIVASTUDIO 2017 S/S

 0     734     February 17 2017

CRITIC 2017 SPRING

 0     620     February 17 2017

AROUND80 2017 S/S

 1     453     February 17 2017

DRUG WITHOUT SIDE EFFECT 2017 S/S

 0     527     February 17 2017

URBANDTYPE 2017 S/S

 0     485     February 16 2017

NOIR 2017 S/S

 0     501     February 16 2017

XERO 2017 S/S

 0     526     February 16 2017

DEBB 2017 S/S

 0     473     February 15 2017

PEGADOR 2017 S/S

 1     669     February 14 2017

GRASSHOPPER 2017 S/S

 2     710     February 13 2017

PIECE MAKER 2017 SPRING

 1     932     February 10 2017

LIFUL 2017 S/S

 0     1086     February 10 2017

UNIFORM BRIDGE 2017 S/S

 0     932     February 10 2017