SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=05-015&title=tan-oem-front-cowl-for-precedent'