SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=13-073&title=clarion-10-inch-dvc-marine-subwoofer-with-rgb-lights'