anonymous (cq FIND (role RECORD ) (entity (double_quoted " Sample ")) (entity_filter (which_exp WITH ) ( (filter_expression (pov (property Campaign ) = (value (atom (double_quoted " AL592 "))))) )) <EOF>) RECORD Sample 37388fb14ee7d5293a6b579a0a7f9b84 83705 252 INSERT IGNORE INTO `b1ba9e1b997b4d6f1600916cbac6c5bf` (id, id2, domain) SELECT entity_id, domain_id, 0 FROM name_data WHERE value = ?; b1ba9e1b997b4d6f1600916cbac6c5bf ef4bf44fa2106c975d52b8273e9e885e a1e7d36dc0b68ffe761cb8df44d97b59 DELETE FROM `37388fb14ee7d5293a6b579a0a7f9b84` WHERE NOT EXISTS (SELECT 1 FROM `a1e7d36dc0b68ffe761cb8df44d97b59` AS data WHERE data.id=`37388fb14ee7d5293a6b579a0a7f9b84`.`id` LIMIT 1) INSERT IGNORE INTO `a1e7d36dc0b68ffe761cb8df44d97b59` (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 `b1ba9e1b997b4d6f1600916cbac6c5bf`) 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 `b1ba9e1b997b4d6f1600916cbac6c5bf`) 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 `b1ba9e1b997b4d6f1600916cbac6c5bf`) 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 `b1ba9e1b997b4d6f1600916cbac6c5bf`) AND EXISTS (SELECT 1 FROM `ef4bf44fa2106c975d52b8273e9e885e` AS refIdsTable WHERE subdata.value=refIdsTable.id LIMIT 1) AND subdata.status != 'REPLACEMENT') as data 0 0