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

IDIOTS 2016 F/W

 1     2073     January 10 2017