SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=10-510-br08&title=reddot-premium-honey-suede-gtw-mach-3-rear-seat-cushion'