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 '%T%' AND path LIKE 'surName' INTERSECT SELECT DISTINCT docid FROM xml_path_index WHERE UPPER(nodedata) LIKE '%LAND%' AND path LIKE 'para' INTERSECT SELECT DISTINCT docid FROM xml_path_index WHERE UPPER(nodedata) LIKE '%LAND%' AND path LIKE 'title' INTERSECT SELECT DISTINCT docid FROM xml_path_index WHERE UPPER(nodedata) LIKE '%LAND%' AND path LIKE '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 ) )