update CMPPropertyValue_v set editable=1 where propertyowner in (select elementid from CMPLogicalLocation_v);