SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=45692&title=automotive-style-rear-view-mirror'