SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=31603&title=universal-12v-oscillating-fan'