SELECT xml_nodes.docid, xml_index.path, xml_nodes.nodedata FROM xml_index, xml_nodes 
           WHERE 
              ( 
                   (xml_index.nodeid=xml_nodes.parentnodeid AND xml_index.path IN ('originator/individualName/surName', 'originator/individualName/givenName' , 
                                                                                 'creator/individualName/surName' ,    'creator/individualName/givenName' , 
                                                                                 'originator/organizationName' , 'dataset/title' ) 
                    AND xml_nodes.nodetype = 'TEXT'
                   ) 
                 OR  
                  (xml_index.nodeid=xml_nodes.nodeid AND ( xml_index.path IN ( '@order', '@packageId' ) AND xml_nodes.nodetype = 'ATTRIBUTE'))
               );
SELECT docid, rev, docname, doctype, date_created,date_updated from xml_documents;
INSERT INTO xml_queryresult (returnfield_id, docid, queryresult_string) VALUES (?, ?, ?);