SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=65023&title=2007-16-yamaha-g29-drive-red-dot-door-max-white-soft-enclosure'