anonymous (cq FIND (role RECORD ) (entity (double_quoted " Sample ")) (entity_filter (which_exp WITH ) ( (filter_expression (pov (property Campaign ) = (value (atom (double_quoted " AL573 "))))) )) <EOF>) RECORD Sample 3904c57a55e043994b7e643aade098ee 80228 356 INSERT IGNORE INTO `ed6dab8e38df88a64f2d7b31e1011858` (id, id2, domain) SELECT property_id, entity_id, domain_id from name_overrides WHERE name = ? UNION ALL SELECT entity_id, domain_id, 0 FROM name_data WHERE value = ?; ed6dab8e38df88a64f2d7b31e1011858 e08cbf2e2bca981ce5a2e6d2a4f06a35 e951180b5686f90753ba020dddbfdb59 DELETE FROM `3904c57a55e043994b7e643aade098ee` WHERE NOT EXISTS (SELECT 1 FROM `e951180b5686f90753ba020dddbfdb59` AS data WHERE data.id=`3904c57a55e043994b7e643aade098ee`.`id` LIMIT 1) INSERT IGNORE INTO `e951180b5686f90753ba020dddbfdb59` (id) SELECT DISTINCT entity_id AS id FROM (SELECT DISTINCT domain_id, entity_id, property_id FROM `text_data` AS subdata WHERE subdata.value = ? UNION ALL SELECT DISTINCT domain_id, entity_id, property_id FROM `name_data` AS subdata WHERE subdata.value = ? UNION ALL SELECT DISTINCT domain_id, entity_id, property_id FROM `enum_data` AS subdata WHERE subdata.value = ? UNION ALL SELECT DISTINCT domain_id, entity_id, property_id FROM `reference_data` AS subdata WHERE EXISTS (SELECT 1 FROM `e08cbf2e2bca981ce5a2e6d2a4f06a35` AS refIdsTable WHERE subdata.value=refIdsTable.id LIMIT 1) AND subdata.status != "REPLACEMENT") as data WHERE EXISTS (Select 1 from `ed6dab8e38df88a64f2d7b31e1011858` AS prop WHERE prop.id = data.property_id AND (prop.id2=data.entity_id OR prop.id2=0)) INSERT IGNORE INTO `ed6dab8e38df88a64f2d7b31e1011858` SELECT id, id2, domain FROM `80368e9d977de4652b673575b711c721`; INSERT IGNORE INTO `80368e9d977de4652b673575b711c721` (id, id2, domain) SELECT r.value as id, r.entity_id as id2, 0 as domain_id FROM reference_data AS r WHERE status="REPLACEMENT" AND domain_id=0 AND EXISTS (SELECT * FROM `3904c57a55e043994b7e643aade098ee` AS s WHERE s.id=r.entity_id) AND EXISTS (SELECT * FROM `ed6dab8e38df88a64f2d7b31e1011858` AS p WHERE p.domain = 0 AND p.id2=0 AND p.id=r.property_id); 0 0