SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=b-3144&title=club-car-precedent-09-up-onward-tempo-eco-lithium-70v-105ah-extended-range-conversion-kit&srsltid=afmbooogwmycahqbuw6firufojdlouaeudxdhqpobgkwbmdw88ca1zge'