SELECT newurl FROM URLRedirect with (nolock) WHERE division = 1 and OldURL = 'sku=lughex4ml&title=lug-nut,-4pkg-188inch-metric-chr-3-4-hex'