SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=10-508-gy07&title=dd-pewter-suede-ez-rxv-prem-front-seat-by-reddot'