added left join on discount and parent category