SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=35168&title=tinted-yamaha-winged-windshield-(models-g29-drive)'