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