anonymous (cq FIND (role RECORD ) (entity (double_quoted " Sample ")) (entity_filter (which_exp WITH ) ( (filter_expression (pov (property Campaign ) = (value (atom (double_quoted " AL580 "))))) )) <EOF>) RECORD Sample 9cf82c249dabd699dc2ca001654d0f34 80228 356 INSERT IGNORE INTO `c9ffd3611a1ddc53a494e7ac24cfa754` (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 = ?; c9ffd3611a1ddc53a494e7ac24cfa754 160011bf45a5df0a810b50d3699296f6 7bd9ad2077ae6776bc4c96228c4c2011 DELETE FROM `9cf82c249dabd699dc2ca001654d0f34` WHERE NOT EXISTS (SELECT 1 FROM `7bd9ad2077ae6776bc4c96228c4c2011` AS data WHERE data.id=`9cf82c249dabd699dc2ca001654d0f34`.`id` LIMIT 1) INSERT IGNORE INTO `7bd9ad2077ae6776bc4c96228c4c2011` (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 `160011bf45a5df0a810b50d3699296f6` AS refIdsTable WHERE subdata.value=refIdsTable.id LIMIT 1) AND subdata.status != "REPLACEMENT") as data WHERE EXISTS (Select 1 from `c9ffd3611a1ddc53a494e7ac24cfa754` AS prop WHERE prop.id = data.property_id AND (prop.id2=data.entity_id OR prop.id2=0)) INSERT IGNORE INTO `c9ffd3611a1ddc53a494e7ac24cfa754` SELECT id, id2, domain FROM `647726988def10aaa236ce9fba4b3317`; INSERT IGNORE INTO `647726988def10aaa236ce9fba4b3317` (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 `9cf82c249dabd699dc2ca001654d0f34` AS s WHERE s.id=r.entity_id) AND EXISTS (SELECT * FROM `c9ffd3611a1ddc53a494e7ac24cfa754` AS p WHERE p.domain = 0 AND p.id2=0 AND p.id=r.property_id); 30 1 15776 18992 33803 6898 17106 21144 17065 33805 21141 2023-11-30T10:00:00+0000 21145 17072 33759 17037 17114 17115 17082 6897 21142 Salinty 15 PSU 1.1-a SW08_15 PSU_T0_1.1-a 15776 18992 33803 6898 17106 21144 17065 33805 21141 2023-11-30T10:00:00+0000 21145 17072 33759 17037 17114 17115 17082 6897 21142 Salinty 15 PSU 1.1-b SW08_15 PSU_T0_1.1-b 15776 18992 33803 6898 17106 21144 17065 33805 21141 2023-11-30T10:00:00+0000 21145 17072 33759 17037 17114 17115 17082 6897 21142 Salinty 15 PSU 2.1-a SW08_15 PSU_T0_2.1-a 15776 18992 33803 6898 17106 21144 17065 33805 21141 2023-11-30T10:00:00+0000 21145 17072 33759 17037 17114 17115 17082 6897 21142 Salinty 15 PSU 2.1-b SW08_15 PSU_T0_2.1-b 15776 18992 33803 6898 17106 21144 17065 33805 21141 2023-11-30T10:00:00+0000 21145 17072 33759 17037 17114 17115 17082 6897 21142 Salinty 15 PSU 3.1-a SW08_15 PSU_T0_3.1-a 15776 18992 33803 6898 17106 21144 17065 33805 21141 2023-11-30T10:00:00+0000 21145 17072 33759 17037 17114 17115 17082 6897 21142 Salinty 15 PSU 3.1-b SW08_15 PSU_T0_3.1-b 15776 18992 33803 6898 17106 21144 17065 33805 21141 2023-11-30T13:00:00+0000 21145 17072 33759 17037 17114 17115 17082 6897 21142 Salinty 7 PSU 1-a SW08_7 PSU_T1_1-a 15776 18992 33803 6898 17106 21144 17065 33805 21141 2023-11-30T13:00:00+0000 21145 17072 33759 17037 17114 17115 17082 6897 21142 Salinty 7 PSU 1-b SW08_7 PSU_T1_1-b 15776 18992 33803 6898 17106 21144 17065 33805 21141 2023-11-30T13:00:00+0000 21145 17072 33759 17037 17114 17115 17082 6897 21142 Salinty 7 PSU 2-a SW08_7 PSU_T1_2-a 15776 18992 33803 6898 17106 21144 17065 33805 21141 2023-11-30T13:00:00+0000 21145 17072 33759 17037 17114 17115 17082 6897 21142 Salinty 7 PSU 2-b SW08_7 PSU_T1_2-b