add mysql view for partof; add php webservice