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

THISISNEVERTHAT 2017 S/S

 1     482     February 24 2017

QUIETIST 2017 S/S

 0     296     February 24 2017

FROM A TO B 2017 S/S

 1     300     February 24 2017

VIABON DE VIA 2017 S/S

 0     390     February 23 2017

URBANSTOFF 2017 S/S

 0     363     February 23 2017

STEALMONSTER 2017 S/S

 0     321     February 23 2017

JOHNNY CARSON 2017 S/S

 2     283     February 23 2017

PLAYMONSTER 2017 S/S

 0     306     February 23 2017

SLEAZY CORNER 2017 S/S

 0     434     February 23 2017

WVPROJECT 2017 S/S

 3     357     February 23 2017

MONTS 2017 S/S

 0     304     February 22 2017

LMC 2017 S/S

 0     402     February 22 2017

I AM NOT A HUMAN BEING 2017 S/S

 0     523     February 21 2017

FATALISM 2017 S/S

 0     320     February 21 2017

13MONTH 2017 S/S

 0     371     February 21 2017

UNIIS DESIGN 2017 S/S

 1     509     February 20 2017

J.DAUL 2017 S/S

 0     378     February 20 2017

ROMANTIC CROWN 2017 S/S

 0     667     February 20 2017

VIVASTUDIO 2017 S/S

 0     795     February 17 2017

CRITIC 2017 SPRING

 0     685     February 17 2017

AROUND80 2017 S/S

 1     500     February 17 2017

DRUG WITHOUT SIDE EFFECT 2017 S/S

 0     578     February 17 2017

URBANDTYPE 2017 S/S

 0     533     February 16 2017

NOIR 2017 S/S

 0     545     February 16 2017

XERO 2017 S/S

 0     584     February 16 2017

DEBB 2017 S/S

 0     513     February 15 2017

PEGADOR 2017 S/S

 1     713     February 14 2017

GRASSHOPPER 2017 S/S

 2     756     February 13 2017

PIECE MAKER 2017 SPRING

 1     977     February 10 2017

LIFUL 2017 S/S

 0     1108     February 10 2017