SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=30824&title=ezgo-txt-ex-ray-speedometer-kit-with-model-specific-mount'