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

ABOVE 2018 A/W

 0     146     January 22 2018

PERSTEP 2018 S/S

 0     186     January 22 2018

BABY CENTAUR 2017 F/W

 0     246     January 19 2018

SUPERLATIVE 2017 F/W

 0     253     January 19 2018

STARE 2018 S/S

 0     409     January 16 2018

WVProject 2018 S/S

 0     362     January 16 2018

LA FUDGE STORE 2018 Early Spring Season

 0     346     January 15 2018

REORG 2017 F/W

 0     279     January 15 2018

BREDA 2017 F/W

 0     231     January 15 2018

RUHM 2017 WINTER

 0     244     January 15 2018

VITALSIGN 2017 F/W

 0     215     January 15 2018

BLACKHOODY 2017 F/W

 0     296     January 15 2018

MADMARS 2017 F/W

 0     251     January 15 2018

LIPUNDERPOINT 2017 WINTER

 0     259     January 15 2018

ELLIOTI 2017 WINTER HOLIDAY SEASON

 0     252     January 15 2018

ULKIN 2018 S/S

 0     344     January 12 2018

ULKIN 2017 F/W

 0     322     January 12 2018

MSKN2ND 2017-2018 WINTER CAPSULE COLLECTION

 0     359     January 12 2018

GHOST CELL 2017 F/W

 0     269     January 12 2018

LIPUNDERPOINT NONE SEASON

 0     477     January 12 2018

ENZO BLUES 2017 F/W

 0     361     January 12 2018

RINSE & CO 2017 A/W

 0     271     January 12 2018

UNGLAYER 2017 F/W

 0     330     January 12 2018

LOKWARD 2017 F/W

 0     472     January 9 2018

OUTSTANDING 2017 F/W

 0     387     January 9 2018

SEWCLASSIC 2017 A/W

 0     480     January 9 2018

BLESSED BULLET 2017 F/W

 0     336     January 9 2018

FRESH ANTI YOUTH 2017 WINTER

 0     492     January 8 2018

BPB 2017 WINTER CAPSULE COLLECTION

 0     731     January 5 2018

86ROAD 2018 S/S

 0     586     January 4 2018