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

OVERSIZE HAPPENING 2017 WINTER

 0     953     December 1 2017

URBANDTYPE 2017 WINTER

 0     775     December 1 2017

UNCOMMONFACTORS 2017 F/W

 0     682     December 1 2017

SEW CLASSIC 2017 F/W

 0     456     December 1 2017

SLOW UNIVERSE 2017 A/W

 0     462     December 1 2017

RATIONNEMENT 2017 F/W

 0     393     December 1 2017

ONA 2017 F/W PART.2

 0     645     November 28 2017

ACOVER 2017 F/W

 0     610     November 28 2017

UMM 2017 WINTER

 0     645     November 27 2017

DOUBLE ADRENALINE SYNDROME 2017 F/W PART.2

 0     812     November 24 2017

SWCL 2017 A/W

 0     823     November 23 2017

SCULPTOR 2017 WINTER

 0     849     November 23 2017

RATIONNEMENT 2017 F/W

 1     600     November 23 2017

OVER THE ONE 2017 F/W

 0     592     November 22 2017

SNACKCULTURE 2017 WINTER

 0     559     November 22 2017

86ROAD 2017 A/W

 0     571     November 22 2017

UNCOMMONFACTORS 2017 F/W

 0     552     November 21 2017

SPECIAL GUEST 2017 F/W

 0     658     November 21 2017

FUZA 2017 F/W

 0     462     November 20 2017

USUAL EDIT 2017 F/W

 0     425     November 20 2017

UNALLOYED 2017 WINTER

 0     516     November 20 2017

HOWELL 2017 F/W

 0     412     November 17 2017

YAN13 2017 F/W Part.2

 0     379     November 17 2017

CITY BREEZE 2017 AUTUMN

 0     442     November 17 2017

AT THE MOMENT 2017 F/W Part.2

 0     453     November 16 2017

BROWNBREATH 2017 F/W

 0     386     November 16 2017

BE BLACK 2017 F/W

 0     384     November 15 2017

MIDNIGHT CIRCUS 2017 F/W

 0     391     November 15 2017

PIECEMAKER 2017 F/W

 0     332     November 15 2017

J.DAUL 2017 F/W

 0     423     November 14 2017