SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=reb+ya1+4556'