anonymous (cq FIND (role RECORD ) (entity (double_quoted " Sample ")) (entity_filter (which_exp WITH ) ( (filter_expression (pov (property Campaign ) = (value (atom (double_quoted " AL594 "))))) )) <EOF>) RECORD Sample 2420257ba2ea31cf9d954cc3396b8cd1 81445 252 INSERT IGNORE INTO `aa84bd5580d0610394e2e21661b56a04` (id, id2, domain) SELECT entity_id, domain_id, 0 FROM name_data WHERE value = ?; aa84bd5580d0610394e2e21661b56a04 82701d29d9fc3ca6f5fe74fb781b2046 b899ef0e01b1b8bc9fcad44aa9621704 DELETE FROM `2420257ba2ea31cf9d954cc3396b8cd1` WHERE NOT EXISTS (SELECT 1 FROM `b899ef0e01b1b8bc9fcad44aa9621704` AS data WHERE data.id=`2420257ba2ea31cf9d954cc3396b8cd1`.`id` LIMIT 1) INSERT IGNORE INTO `b899ef0e01b1b8bc9fcad44aa9621704` (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 `aa84bd5580d0610394e2e21661b56a04`) 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 `aa84bd5580d0610394e2e21661b56a04`) 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 `aa84bd5580d0610394e2e21661b56a04`) 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 `aa84bd5580d0610394e2e21661b56a04`) AND EXISTS (SELECT 1 FROM `82701d29d9fc3ca6f5fe74fb781b2046` AS refIdsTable WHERE subdata.value=refIdsTable.id LIMIT 1) AND subdata.status != 'REPLACEMENT') as data 870 1 1395 124 34284 19112 21730 38912 17065 39011 39005 39004 17038 17114 21731 17081 126436 nur Länge, Gewicht und Finclips, für Funk Uni HH cod_AL594_001 16.0 42.0 17084 26057 6896 17093 1395 124 34284 19112 21730 38912 17065 39011 39005 39004 17038 17114 21731 17081 126436 nur Länge, Gewicht und Finclips, für Funk Uni HH cod_AL594_002 16.0 41.0 17084 26057 6896 17093 1395 124 34284 19112 21730 38912 17065 39009 39005 39004 17038 17114 21731 17081 126436 nur Länge, Gewicht und Finclips, für Funk Uni HH cod_AL594_003 19.0 58.0 17084 26057 6896 17093 1395 124 34284 19112 21730 38912 17065 39007 39005 39004 17038 17114 21731 17081 126436 40.0 1 12.0 5 cod_AL594_100 m 32.0 294.0 240.0 17084 26057 6896 17093 1395 124 34284 19112 21730 38912 17065 39007 39005 39004 17038 17114 21731 17081 126436 18.0 1 6.0 5 cod_AL594_101 m 30.0 218.0 188.0 17084 26057 6896 17093 1395 124 34284 19112 21730 38912 17065 39007 39005 39004 17038 17114 21731 17081 126436 45.0 1 10.0 5 cod_AL594_102 m 33.0 296.0 228.0 17084 26057 6896 17093 1395 124 34284 19112 21730 38912 17065 39007 39005 39004 17038 17114 21731 17081 126436 10.0 1 6.0 6 editet by H.R: (gutted > weight = 296) cod_AL594_103 m 30.5 222.0 17084 26057 6896 17093 1395 124 34284 19112 21730 38912 17065 39007 39005 39004 17038 17114 21731 17081 126436 12.0 1 5.0 5 cod_AL594_104 m 31.0 216.0 194.0 17084 26057 6896 17093 1395 124 34284 19112 21730 38912 17065 39007 39005 39004 17038 17114 21731 17081 126436 2.0 0 4.0 3 cod_AL594_105 f 26.0 144.0 132.0 17084 26057 6896 17093 1395 124 34284 19112 21730 38912 17065 39007 39005 39004 17038 17114 21731 17081 126436 12.0 1 6.0 5 cod_AL594_106 m 28.0 170.0 152.0 17084 26057 6896 17093