select distinct wr_parent from hhp_write_lookbook where ca_name != 'STUDIO' and ((INSTR(LOWER(wr_4), LOWER('IDIOTS'))) ) and (wr_num between -3093 and (-3093 + 10000)) and ( start_datetime is NULL or start_datetime <= now() )

IDIOTS 2016 F/W

 1     2759     January 10 2017