SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=7980&title=club-car-precedent-ds-high-torque-motor-and-controller-conversion-system'