select docid, path, nodedata, parentnodeid from xml_path_index where 
    (path like 'originator/individualName/surName' or 
     path like 'originator/individualName/givenName' or 
     path like 'creator/individualName/surName' or 
     path like 'creator/individualName/givenName' or 
     path like 'originator/organizationName' or 
     path like 'creator/organizationName' or 
     path like 'dataset/title' or 
     path like 'keyword' ) 
 AND docid in    
   ('ABS.4','access.10','access.7','access.8','access.9',
    'ADCP_template.50','adler.3','ALASDatabaseAccess.3','ALEXXX_015ADCP015R00_19990817.50',
    'ALEXXX_015ADCP015R00_19990906.50','ALEXXX_015ADCP015R00_19991108.50',
    'ALEXXX_015ADCP015R00_20000106.50','ALEXXX_015ADCP015R00_20000302.50',
    'ALEXXX_015ADCP015R00_20000523.50','ALEXXX_015ADCP015R00_20000815.50')