SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=10-501-br06&title=lt-beige-mach3-oem-style-prem-rear-seat-by-reddot'