SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=7255&title=jakes-stainless-club-car-precedent-brush-guard-(fits-2004-up)'