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 ebf5e4a389cd7b8205dd0f77f5e9c671 81445 252 INSERT IGNORE INTO `634cf2acbaf8f82c86dad51ec02b543d` (id, id2, domain) SELECT entity_id, domain_id, 0 FROM name_data WHERE value = ?; 634cf2acbaf8f82c86dad51ec02b543d 14378ddd8a459f0174567bc0c43838b8 2890c9d304e9dfc9a3cce35425d2c4c7 DELETE FROM `ebf5e4a389cd7b8205dd0f77f5e9c671` WHERE NOT EXISTS (SELECT 1 FROM `2890c9d304e9dfc9a3cce35425d2c4c7` AS data WHERE data.id=`ebf5e4a389cd7b8205dd0f77f5e9c671`.`id` LIMIT 1) INSERT IGNORE INTO `2890c9d304e9dfc9a3cce35425d2c4c7` (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 `634cf2acbaf8f82c86dad51ec02b543d`) 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 `634cf2acbaf8f82c86dad51ec02b543d`) 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 `634cf2acbaf8f82c86dad51ec02b543d`) 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 `634cf2acbaf8f82c86dad51ec02b543d`) AND EXISTS (SELECT 1 FROM `14378ddd8a459f0174567bc0c43838b8` AS refIdsTable WHERE subdata.value=refIdsTable.id LIMIT 1) AND subdata.status != 'REPLACEMENT') as data 0 0