SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=10-504-br07&title=2008-up-ezgo-rxv-red-dot-premium-oem-style-mushroom-front-seat-replacement'