SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=6074&title=1996-07-ezgo-front-cowl-rivet'