anonymous (cq FIND (role RECORD ) (entity (double_quoted " Sample ")) (entity_filter (which_exp WITH ) ( (filter_expression (pov (property Campaign ) = (value (atom (double_quoted " AL610 "))))) )) <EOF>) RECORD Sample 21ab76ecbfbbff38545ce0ef94b451e7 80228 356 INSERT IGNORE INTO `37217a61907cfa7e65c583c7bc8ef1b5` (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 = ?; 37217a61907cfa7e65c583c7bc8ef1b5 3c839cc2a21d8bed178e8d2530f4d975 acabc93a148f7ac76c82ffccfae3d9d1 DELETE FROM `21ab76ecbfbbff38545ce0ef94b451e7` WHERE NOT EXISTS (SELECT 1 FROM `acabc93a148f7ac76c82ffccfae3d9d1` AS data WHERE data.id=`21ab76ecbfbbff38545ce0ef94b451e7`.`id` LIMIT 1) INSERT IGNORE INTO `acabc93a148f7ac76c82ffccfae3d9d1` (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 `3c839cc2a21d8bed178e8d2530f4d975` AS refIdsTable WHERE subdata.value=refIdsTable.id LIMIT 1) AND subdata.status != "REPLACEMENT") as data WHERE EXISTS (Select 1 from `37217a61907cfa7e65c583c7bc8ef1b5` AS prop WHERE prop.id = data.property_id AND (prop.id2=data.entity_id OR prop.id2=0)) INSERT IGNORE INTO `37217a61907cfa7e65c583c7bc8ef1b5` SELECT id, id2, domain FROM `fee477f2b1d0e7bae7b27524d0b00fc1`; INSERT IGNORE INTO `fee477f2b1d0e7bae7b27524d0b00fc1` (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 `21ab76ecbfbbff38545ce0ef94b451e7` AS s WHERE s.id=r.entity_id) AND EXISTS (SELECT * FROM `37217a61907cfa7e65c583c7bc8ef1b5` AS p WHERE p.domain = 0 AND p.id2=0 AND p.id=r.property_id); 663 1 1395 124 34284 41895 19112 17065 2023-05-13 39005 39004 17038 17114 21731 17081 cod_AL610_001 21730 38912 43211 17084 43210 126436 6896 17093 12.0 18.0 1395 124 34284 41896 19112 17065 2023-05-13 39005 39004 17038 17114 21731 17081 cod_AL610_002 21730 38912 43211 17084 43210 126436 6896 17093 14.0 26.0 1395 124 34284 41897 19112 17065 2023-05-13 39005 39004 17038 17114 21731 17081 cod_AL610_003 21730 38912 43213 17084 43210 126436 6896 17093 27.0 168.0 141.0 1.0 6 f 7 5.0 1395 124 34284 41898 19112 17065 2023-05-13 39005 39004 17038 17114 21731 17081 cod_AL610_004 21730 38912 43213 17084 43210 126436 6896 17093 15.0 26.0 1395 124 34284 41899 19112 17065 2023-05-13 39005 39004 17038 17114 21731 17081 cod_AL610_005 21730 38912 43213 17084 43210 126436 6896 17093 12.0 13.0 1395 124 34284 41900 19112 17065 2023-05-13 39005 39004 17038 17114 21731 17081 cod_AL610_006 21730 38912 43215 17084 43210 126436 6896 17093 35.0 397.0 312.0 24.0 1 e m 5 46.0 1395 124 34284 41901 19112 17065 2023-05-13 39005 39004 17038 17114 21731 17081 cod_AL610_007 21730 38912 43215 17084 43210 126436 6896 17093 31.0 250.0 211.0 14.0 0 e m 5 26.0 1395 124 34284 41902 19112 17065 2023-05-13 39005 39004 17038 17114 21731 17081 cod_AL610_008 21730 38912 43215 17084 43210 126436 6896 17093 38.0 518.0 441.0 30.0 1 e f 4 34.0 1395 124 34284 41903 19112 17065 2023-05-13 39005 39004 17038 17114 21731 17081 cod_AL610_009 21730 38912 43215 17084 43210 126436 6896 17093 32.0 304.0 240.0 7.0 1 e m 5 50.0 1395 124 34284 41904 19112 17065 2023-05-13 39005 39004 17038 17114 21731 17081 cod_AL610_010 21730 38912 43215 17084 43210 126436 6896 17093 26.0 134.0 113.0 1.0 0 e m 6 13.0