anonymous (cq FIND (role RECORD ) (entity (double_quoted " Sample ")) (entity_filter (which_exp WITH ) ( (filter_expression (pov (property Campaign ) = (value (atom (double_quoted " AL592 "))))) )) <EOF>) RECORD Sample d2bef448b7f4e97f4df9557991e224dc 80228 356 INSERT IGNORE INTO `9654d8d3f865e47cc10e7a27569d0468` (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 = ?; 9654d8d3f865e47cc10e7a27569d0468 fdad3185c8d30572e7995f1f31dfe22e ea18394d3a899963eba76310166c5d00 DELETE FROM `d2bef448b7f4e97f4df9557991e224dc` WHERE NOT EXISTS (SELECT 1 FROM `ea18394d3a899963eba76310166c5d00` AS data WHERE data.id=`d2bef448b7f4e97f4df9557991e224dc`.`id` LIMIT 1) INSERT IGNORE INTO `ea18394d3a899963eba76310166c5d00` (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 `fdad3185c8d30572e7995f1f31dfe22e` AS refIdsTable WHERE subdata.value=refIdsTable.id LIMIT 1) AND subdata.status != "REPLACEMENT") as data WHERE EXISTS (Select 1 from `9654d8d3f865e47cc10e7a27569d0468` AS prop WHERE prop.id = data.property_id AND (prop.id2=data.entity_id OR prop.id2=0)) INSERT IGNORE INTO `9654d8d3f865e47cc10e7a27569d0468` SELECT id, id2, domain FROM `e97198ee6ee205aaad669642798e969c`; INSERT IGNORE INTO `e97198ee6ee205aaad669642798e969c` (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 `d2bef448b7f4e97f4df9557991e224dc` AS s WHERE s.id=r.entity_id) AND EXISTS (SELECT * FROM `9654d8d3f865e47cc10e7a27569d0468` AS p WHERE p.domain = 0 AND p.id2=0 AND p.id=r.property_id); 0 0