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

USUAL EDIT 2017 WINTER

 0     78     January 16 2017

SPECIAL GUEST 16 F/W

 1     390     January 13 2017

IDIOTS 2016 F/W

 0     502     January 10 2017

RUGGED HOUSE 2016 F/W Part.2

 0     703     January 5 2017

WESTWARD CALIFORNIA 2016 WINTER

 0     801     January 4 2017

MALA HAZY 2016 WINTER

 0     733     January 4 2017

TENUE 2016 F/W

 1     647     January 3 2017

INDIGO CHILDREN 2016 WINTER

 0     854     December 29 2016

NOWWHAT 2016 F/W

 0     872     December 29 2016

BROWNPEANUT 2016 F/W Part.1

 0     925     December 27 2016

VACAY 2016 F/W

 0     1371     December 23 2016

CHISWICK 2016 F/W

 0     1338     December 22 2016

OUTSTANDING ORDINARY 16 WINTER

 1     886     December 22 2016

MOSTWM 2016 F/W

 0     660     December 22 2016

LARTIGENT 2016 WINTER

 0     692     December 22 2016

STRIKE 2016 F/W

 0     644     December 22 2016

MANFROMUS 2016 F/W

 0     664     December 22 2016

GAINSBORO 2016 F/W

 0     646     December 21 2016

CAMEL WORK 2016 A/W

 0     981     December 20 2016

ELLIOTI 2016 F/W

 0     767     December 20 2016

KING 2016 A/W

 0     1540     December 14 2016

GOODFELLAS 2016 A/W part.3

 0     1192     December 14 2016

QT8 2016 WINTER

 0     1183     December 14 2016

D.PRIQUE 2016 F/W

 1     1393     December 12 2016

WNDERKAMMER 2016 F/W

 0     1009     December 12 2016

ACOVER 2016 F/W Part.3

 0     1256     December 12 2016

CITLUS 2016 F/W

 0     1414     December 7 2016

Bad Room 2016 WINTER

 0     1063     December 7 2016

COUP DE GRACE 2016 F/W

 0     1078     December 6 2016

DE L’HARMONIE 2016 F/W LOOKBOOK

 0     1068     December 6 2016