SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=cham-ya&title=yamaha-g14-g29-drive-red-dot-chameleon-soft-enclosure'