SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=24-043&title=2017-up-yamaha-drive-2-exhaust-pipe-gasket'