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

THISISNEVERTHAT 2017 S/S

 0     224     February 24 2017

VIABON DE VIA 2017 S/S

 0     268     February 23 2017

STEALMONSTER 2017 S/S

 0     212     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

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

DEBB 2017 S/S

 0     472     February 15 2017

PEGADOR 2017 S/S

 1     669     February 14 2017

PIECE MAKER 2017 SPRING

 1     932     February 10 2017

DCUMA 2017 SPRING

 2     662     February 10 2017

UNALLOYED 2017 S/S

 0     1137     February 10 2017

SLEEPYSLIP 2017 S/S

 4     1286     February 3 2017

SHETHISCOMMA 2017 S/S

 2     1617     January 26 2017

WOLPENDER 2017 S/S

 2     1477     January 25 2017

PLAYIAN 2016 F/W

 1     1469     January 20 2017

USUAL EDIT 2017 WINTER

 0     1410     January 16 2017

IDIOTS 2016 F/W

 1     1456     January 10 2017

RUGGED HOUSE 2016 F/W Part.2

 0     1718     January 5 2017

WESTWARD CALIFORNIA 2016 WINTER

 0     1824     January 4 2017

INDIGO CHILDREN 2016 WINTER

 0     1616     December 29 2016

NOWWHAT 2016 F/W

 0     1615     December 29 2016

BROWNPEANUT 2016 F/W Part.1

 0     1629     December 27 2016

VACAY 2016 F/W

 0     2161     December 23 2016