SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=13-078&title=clarion-25ft-white-16-awg-parallel-conductor-speaker-cable'