SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=a23-006&title=2014-up-ezgo-txt-kicker-dash-and-audio-kit'