SELECT docid,docname,doctype,date_created, date_updated, rev FROM xml_documents WHERE docid IN ( (SELECT DISTINCT docid FROM xml_path_index WHERE (UPPER(nodedata) LIKE '%ORGANIZATION OF BIOLOGICAL FIELD STATIONS%' AND path = 'organizationName') AND (UPPER(nodedata) LIKE '%SOIL%' AND path IN ('surName', 'givenName','keyword','para','geogrpahicDescription','literalLayout','title', '@packageid','abstract/para') ) ) AND ( docid IN ( SELECT docid from xml_access WHERE( ( lower(principal_name) = 'public' AND perm_type = 'allow' AND (permission='4' OR permission='5' OR permission='6' OR permission='7') ) OR ( lower(principal_name) = 'public' AND perm_type = 'allow' AND (permission='4' OR permission='5' OR permission='6' OR permission='7') ) ) AND subtreeid IS NULL ) AND docid NOT IN ( SELECT docid from xml_access WHERE( ( lower(principal_name) = 'public' AND perm_type = 'deny' AND perm_order ='allowFirst' AND (permission='4' OR permission='5' OR permission='6' OR permission='7') ) OR ( lower(principal_name) = 'public' AND perm_type = 'deny' AND perm_order ='allowFirst' AND (permission='4' OR permission='5' OR permission='6' OR permission='7') ) ) AND subtreeid IS NULL ) )