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

IDIOTS 2016 F/W

 1     2384     January 10 2017