SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=8306&title=2008-up-yamaha-shuttle-4-shuttle-6-fuel-gauge-shuttle'