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

NOWWHAT 2017 S/S

 0     76     June 28 2017

XXIX 2017 S/S

 1     178     June 26 2017

DELTA MILSPEC 2017 S/S

 0     145     June 26 2017

SPUNKY 2017 SUMMER

 0     291     June 23 2017

GOODFELLAS 2017 S/S

 0     603     June 19 2017

2CUBE 2017 S/S

 1     304     June 19 2017

MAINBOOTH 2017 SUMMER

 0     496     June 19 2017

KING 2017 S/S

 0     670     June 15 2017

FRIZMWORKS 2017 S/S

 0     571     June 15 2017

ADEMER 2017 S/S

 0     507     June 13 2017

CANEBROS 2017 S/S

 0     642     June 13 2017

UNIISDESIGN 2017 S/S

 0     562     June 13 2017

APPARELXIT 2017 S/S

 0     524     June 13 2017

BASEMOMENT 2017 S/S

 0     476     June 13 2017

MALAHAZY 2017 S/S

 0     530     June 13 2017

199XKIDS 2017 S/S

 0     660     June 12 2017

NOIR 2017 SUMMER

 0     496     June 12 2017

OUTSTANDING ORDINARY 2017 SUMMER

 0     463     June 12 2017

CODE IM 2017 SUMMER

 0     500     June 12 2017

LOKWARD 2017 S/S

 0     445     June 12 2017

QUEITIST 2017 SUMMER

 0     476     June 12 2017

SCULPTOR 2017 SUMMER

 0     640     June 9 2017

STONYSTRIDE 2017 S/S

 0     512     June 9 2017

ASL 2017 SUMMER

 0     624     June 8 2017

MIDNIGHTMOVE 2017 S/S

 2     543     June 8 2017

MIX 2017 SUMMER

 0     1059     June 2 2017

CRITIC 2017 SUMMER

 0     787     June 2 2017

SLEAZY CORNER 2017 S/S Part.3

 0     684     June 2 2017

Ellioti 2017 SUMMER

 0     584     June 2 2017

UNALLOYED 2017 S/S

 0     583     June 2 2017