SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=10-506-br06&title=lt-beige-ez-exp-pod-oem-style-prem-front-seat-by-reddot'