select distinct wr_parent from hhp_write_lookbook where ca_name != 'STUDIO' and ((INSTR(LOWER(wr_4), LOWER('LOOKBOOK'))) ) and (wr_num between -2773 and (-2773 + 10000))

XXIX 2017 S/S

 0     21     June 26 2017

DELTA MILSPEC 2017 S/S

 0     25     June 26 2017

SPUNKY 2017 SUMMER

 0     207     June 23 2017

GOODFELLAS 2017 S/S

 0     533     June 19 2017

KING 2017 S/S

 0     603     June 15 2017

FRIZMWORKS 2017 S/S

 0     504     June 15 2017

ADEMER 2017 S/S

 0     464     June 13 2017

CANEBROS 2017 S/S

 0     594     June 13 2017

UNIISDESIGN 2017 S/S

 0     509     June 13 2017

APPARELXIT 2017 S/S

 0     469     June 13 2017

BASEMOMENT 2017 S/S

 0     428     June 13 2017

MALAHAZY 2017 S/S

 0     477     June 13 2017

199XKIDS 2017 S/S

 0     607     June 12 2017

NOIR 2017 SUMMER

 0     452     June 12 2017

OUTSTANDING ORDINARY 2017 SUMMER

 0     415     June 12 2017

CODE IM 2017 SUMMER

 0     451     June 12 2017

LOKWARD 2017 S/S

 0     413     June 12 2017

QUEITIST 2017 SUMMER

 0     437     June 12 2017

SCULPTOR 2017 SUMMER

 0     626     June 9 2017

STONYSTRIDE 2017 S/S

 0     499     June 9 2017

ASL 2017 SUMMER

 0     602     June 8 2017

MIDNIGHTMOVE 2017 S/S

 2     528     June 8 2017

MIX 2017 SUMMER

 0     1040     June 2 2017

Ellioti 2017 SUMMER

 0     574     June 2 2017

UNALLOYED 2017 S/S

 0     567     June 2 2017

YOUX 2017 SUMMER

 0     658     June 1 2017

STUNT 2017 S/S

 0     537     June 1 2017

THE ROYAL WE 2017 SUMMER

 0     552     May 31 2017

C.O.M.E 2017 S/S

 0     613     May 31 2017

SWCL 2017 S/S

 0     477     May 30 2017