SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=10-307p&title=blade-rear-seat-assembly,-g150,-cfblk,-charcoal,-gray'