SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=2826&title=1996-04-columbia-harley-davidson-4-cycle-ngk-spark-plug'