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