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