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