SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=1075&title=duro-desert-off-road-tire-22x11x10'