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 64b5cdb0083931fe7897956318f2fef7 95956 252 INSERT IGNORE INTO `9a29bbec6941493765bfe113734b5b55` (id, id2, domain) SELECT entity_id, domain_id, 0 FROM name_data WHERE value = ?; 9a29bbec6941493765bfe113734b5b55 950b65ed3e0467a6b587763699eab2c3 4b29e7795ff7ac28f1cb66c8511fe9bb DELETE FROM `64b5cdb0083931fe7897956318f2fef7` WHERE NOT EXISTS (SELECT 1 FROM `4b29e7795ff7ac28f1cb66c8511fe9bb` AS data WHERE data.id=`64b5cdb0083931fe7897956318f2fef7`.`id` LIMIT 1) INSERT IGNORE INTO `4b29e7795ff7ac28f1cb66c8511fe9bb` (id) SELECT DISTINCT entity_id AS id FROM (SELECT DISTINCT domain_id, entity_id, property_id FROM `text_data` AS subdata WHERE subdata.real_property_id IN (SELECT distinct id FROM `9a29bbec6941493765bfe113734b5b55`) AND subdata.value = ? UNION ALL SELECT DISTINCT domain_id, entity_id, property_id FROM `name_data` AS subdata WHERE subdata.real_property_id IN (SELECT distinct id FROM `9a29bbec6941493765bfe113734b5b55`) AND subdata.value = ? UNION ALL SELECT DISTINCT domain_id, entity_id, property_id FROM `enum_data` AS subdata WHERE subdata.real_property_id IN (SELECT distinct id FROM `9a29bbec6941493765bfe113734b5b55`) AND subdata.value = ? UNION ALL SELECT DISTINCT domain_id, entity_id, property_id FROM `reference_data` AS subdata WHERE subdata.real_property_id IN (SELECT distinct id FROM `9a29bbec6941493765bfe113734b5b55`) AND EXISTS (SELECT 1 FROM `950b65ed3e0467a6b587763699eab2c3` AS refIdsTable WHERE subdata.value=refIdsTable.id LIMIT 1) AND subdata.status != 'REPLACEMENT') as data 0 0