<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="https://biosamples.geomar.de/webinterface/1794835805/webcaosdb.xsl" ?>
<Response srid="97052562-80cc-43b9-ae09-c9664030dc8a" timestamp="1795057687185" baseuri="https://biosamples.geomar.de" count="0">
  <noscript>
    <h1>Please enable JavaScript!</h1>
  </noscript>
  <UserInfo>
    <Roles>
      <Role>anonymous</Role>
    </Roles>
  </UserInfo>
  <Query string="FIND RECORD &quot;Sample&quot; WITH (Campaign = &quot;AL592&quot;)" results="0" cached="false" etag="98a7165d-ff6c-4805-a2cf-aa16bc897ba9">
    <ParseTree>(cq FIND  (role RECORD ) (entity (double_quoted " Sample "))   (entity_filter (which_exp WITH ) ( (filter_expression (pov (property Campaign  ) =   (value (atom (double_quoted " AL592 "))))) )) &lt;EOF&gt;)</ParseTree>
    <Role>RECORD</Role>
    <Entity>Sample</Entity>
    <Filter>
      <POV property="Campaign" operator="=" value="AL592">
        <sourceSet>e3df115fb43de1c9e01e047e275a6441</sourceSet>
        <sourceSetCountBefore>98074</sourceSetCountBefore>
        <propertiesTableCountBefore>252</propertiesTableCountBefore>
        <initPOVPropertiesTableStmt2 />
        <initPOVPropertiesTableStmt1>INSERT IGNORE INTO `7aa240952751afa78b181df90f5fef4f` (id, id2, domain) SELECT entity_id, domain_id, 0 FROM name_data WHERE value = ?;</initPOVPropertiesTableStmt1>
        <propertiesTable>7aa240952751afa78b181df90f5fef4f</propertiesTable>
        <refIdsTable>98471a7a23af6c4bad780be9776b0069</refIdsTable>
        <applyPOVIntermediateResultSet>8986e9aced97693fe54ba1ca6ac7b0c0</applyPOVIntermediateResultSet>
        <applyPOVStmt2>DELETE FROM `e3df115fb43de1c9e01e047e275a6441` WHERE NOT EXISTS (SELECT 1 FROM `8986e9aced97693fe54ba1ca6ac7b0c0` AS data WHERE data.id=`e3df115fb43de1c9e01e047e275a6441`.`id` LIMIT 1)</applyPOVStmt2>
        <applyPOVStmt1>INSERT IGNORE INTO `8986e9aced97693fe54ba1ca6ac7b0c0` (id) SELECT DISTINCT entity_id AS id FROM (SELECT DISTINCT domain_id, entity_id, property_id FROM `text_data` AS subdata WHERE  subdata.real_property_id IN (SELECT distinct id FROM `7aa240952751afa78b181df90f5fef4f`)  AND  subdata.value = ? 
UNION ALL SELECT DISTINCT domain_id, entity_id, property_id FROM `name_data` AS subdata WHERE  subdata.real_property_id IN (SELECT distinct id FROM `7aa240952751afa78b181df90f5fef4f`)  AND  subdata.value = ? 
UNION ALL SELECT DISTINCT domain_id, entity_id, property_id FROM `enum_data` AS subdata WHERE  subdata.real_property_id IN (SELECT distinct id FROM `7aa240952751afa78b181df90f5fef4f`)  AND  subdata.value = ? 
UNION ALL SELECT DISTINCT domain_id, entity_id, property_id FROM `reference_data` AS subdata WHERE  subdata.real_property_id IN (SELECT distinct id FROM `7aa240952751afa78b181df90f5fef4f`)  AND EXISTS
                        (SELECT 1 FROM `98471a7a23af6c4bad780be9776b0069` AS refIdsTable WHERE subdata.value=refIdsTable.id LIMIT 1) AND subdata.status != 'REPLACEMENT') as data</applyPOVStmt1>
        <replTblStmt2 />
        <replTblStmt1 />
        <applyPOVIntermediateResultSetCount>0</applyPOVIntermediateResultSetCount>
        <refIdsTableCountBefore>0</refIdsTableCountBefore>
      </POV>
    </Filter>
  </Query>
</Response>
