select distinct wr_parent from hhp_write_lookbook where ca_name != 'STUDIO' and ((INSTR(wr_4, '힙합퍼')) ) and (wr_num between -3093 and (-3093 + 10000)) and ( start_datetime is NULL or start_datetime <= now() )

ABOVE 2018 A/W

 0     197     January 22 2018

PERSTEP 2018 S/S

 0     213     January 22 2018

BABY CENTAUR 2017 F/W

 0     260     January 19 2018

SUPERLATIVE 2017 F/W

 0     266     January 19 2018

STARE 2018 S/S

 0     422     January 16 2018

WVProject 2018 S/S

 0     371     January 16 2018

LA FUDGE STORE 2018 Early Spring Season

 0     356     January 15 2018

REORG 2017 F/W

 0     289     January 15 2018

BREDA 2017 F/W

 0     237     January 15 2018

RUHM 2017 WINTER

 0     253     January 15 2018

VITALSIGN 2017 F/W

 0     222     January 15 2018

BLACKHOODY 2017 F/W

 0     306     January 15 2018

MADMARS 2017 F/W

 0     260     January 15 2018

LIPUNDERPOINT 2017 WINTER

 0     269     January 15 2018

ELLIOTI 2017 WINTER HOLIDAY SEASON

 0     260     January 15 2018

ULKIN 2018 S/S

 0     351     January 12 2018

ULKIN 2017 F/W

 0     336     January 12 2018

MSKN2ND 2017-2018 WINTER CAPSULE COLLECTION

 0     369     January 12 2018

GHOST CELL 2017 F/W

 0     285     January 12 2018

LIPUNDERPOINT NONE SEASON

 0     486     January 12 2018

ENZO BLUES 2017 F/W

 0     370     January 12 2018

RINSE & CO 2017 A/W

 0     275     January 12 2018

UNGLAYER 2017 F/W

 0     335     January 12 2018

LOKWARD 2017 F/W

 0     479     January 9 2018

OUTSTANDING 2017 F/W

 0     395     January 9 2018

SEWCLASSIC 2017 A/W

 0     491     January 9 2018

BLESSED BULLET 2017 F/W

 0     343     January 9 2018

FRESH ANTI YOUTH 2017 WINTER

 0     501     January 8 2018

BPB 2017 WINTER CAPSULE COLLECTION

 0     733     January 5 2018

86ROAD 2018 S/S

 0     591     January 4 2018