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