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 fedf2b583b833ac575357f3196572488 80228 356 INSERT IGNORE INTO `60d1502788ba6bca767c0c3e71535ba4` (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 = ?; 60d1502788ba6bca767c0c3e71535ba4 647b53922725c6caf8ca89736dc6b24e f35bfe9ee394134e67d6af486580434b DELETE FROM `fedf2b583b833ac575357f3196572488` WHERE NOT EXISTS (SELECT 1 FROM `f35bfe9ee394134e67d6af486580434b` AS data WHERE data.id=`fedf2b583b833ac575357f3196572488`.`id` LIMIT 1) INSERT IGNORE INTO `f35bfe9ee394134e67d6af486580434b` (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 `647b53922725c6caf8ca89736dc6b24e` AS refIdsTable WHERE subdata.value=refIdsTable.id LIMIT 1) AND subdata.status != "REPLACEMENT") as data WHERE EXISTS (Select 1 from `60d1502788ba6bca767c0c3e71535ba4` AS prop WHERE prop.id = data.property_id AND (prop.id2=data.entity_id OR prop.id2=0)) INSERT IGNORE INTO `60d1502788ba6bca767c0c3e71535ba4` SELECT id, id2, domain FROM `b4dffac1553b9ae4573f3cd16595b003`; INSERT IGNORE INTO `b4dffac1553b9ae4573f3cd16595b003` (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 `fedf2b583b833ac575357f3196572488` AS s WHERE s.id=r.entity_id) AND EXISTS (SELECT * FROM `60d1502788ba6bca767c0c3e71535ba4` AS p WHERE p.domain = 0 AND p.id2=0 AND p.id=r.property_id); 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