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     153     January 22 2018

PERSTEP 2018 S/S

 0     193     January 22 2018

BABY CENTAUR 2017 F/W

 0     250     January 19 2018

SUPERLATIVE 2017 F/W

 0     259     January 19 2018

STARE 2018 S/S

 0     413     January 16 2018

WVProject 2018 S/S

 0     365     January 16 2018

LA FUDGE STORE 2018 Early Spring Season

 0     350     January 15 2018

REORG 2017 F/W

 0     281     January 15 2018

BREDA 2017 F/W

 0     232     January 15 2018

RUHM 2017 WINTER

 0     245     January 15 2018

VITALSIGN 2017 F/W

 0     216     January 15 2018

BLACKHOODY 2017 F/W

 0     300     January 15 2018

MADMARS 2017 F/W

 0     256     January 15 2018

LIPUNDERPOINT 2017 WINTER

 0     263     January 15 2018

ELLIOTI 2017 WINTER HOLIDAY SEASON

 0     254     January 15 2018

ULKIN 2018 S/S

 0     345     January 12 2018

ULKIN 2017 F/W

 0     323     January 12 2018

MSKN2ND 2017-2018 WINTER CAPSULE COLLECTION

 0     361     January 12 2018

GHOST CELL 2017 F/W

 0     271     January 12 2018

LIPUNDERPOINT NONE SEASON

 0     478     January 12 2018

ENZO BLUES 2017 F/W

 0     365     January 12 2018

RINSE & CO 2017 A/W

 0     272     January 12 2018

UNGLAYER 2017 F/W

 0     331     January 12 2018

LOKWARD 2017 F/W

 0     473     January 9 2018

OUTSTANDING 2017 F/W

 0     388     January 9 2018

SEWCLASSIC 2017 A/W

 0     482     January 9 2018

BLESSED BULLET 2017 F/W

 0     338     January 9 2018

FRESH ANTI YOUTH 2017 WINTER

 0     494     January 8 2018

BPB 2017 WINTER CAPSULE COLLECTION

 0     731     January 5 2018

86ROAD 2018 S/S

 0     588     January 4 2018