Query editor
WITH latest AS (SELECTaddress,MAX_BY(name, _updated_at) AS name,MAX_BY(type, _updated_at) AS type,MAX_BY(parent_address, _updated_at) AS parent_addressFROM ton.nft_metadataWHERE parent_address IN (UPPER('0:07daa9ef301dc6ecbc862f165633f6be1ed981685212aebc22a97322b6ac3d6b'),UPPER('0:3889b13b33fdc0d7eede47edb67faf0a868892851537370c19cd67243dbd8a5c'),UPPER('0:551e764156dd15ac1e0465211b22e3d3a23649d30bbed657cb6f4d7b4df03aa5'),UPPER('0:f43c432fcd7095b87dbadda72541211dc47d4597d84de7da4f3f6858f80bcc9d'),UPPER('0:b1713116fee635f3a4cd66c9d2c848e22382bc0464cff7d74d951a2ce1ba7775'))GROUP BY address),labeled AS (SELECTaddress,name,type,CASEWHEN parent_address = UPPER('0:07daa9ef301dc6ecbc862f165633f6be1ed981685212aebc22a97322b6ac3d6b') THEN 'Sticker Pack'WHEN parent_address = UPPER('0:3889b13b33fdc0d7eede47edb67faf0a868892851537370c19cd67243dbd8a5c') THEN 'Fuse'WHEN parent_address = UPPER('0:551e764156dd15ac1e0465211b22e3d3a23649d30bbed657cb6f4d7b4df03aa5') THEN 'Elephant'WHEN parent_address = UPPER('0:f43c432fcd7095b87dbadda72541211dc47d4597d84de7da4f3f6858f80bcc9d') THEN 'Freeman'WHEN parent_address = UPPER('0:b1713116fee635f3a4cd66c9d2c848e22382bc0464cff7d74d951a2ce1ba7775') THEN 'Goodies'ELSE NULLEND AS platformFROM latest)SELECTl.address AS collection_address,l.name,l.platformFROM labeled lWHERE l.type = 'collection'AND l.platform IS NOT NULLAND LOWER(l.name) NOT LIKE '%empty%'AND LOWER(l.name) NOT LIKE '%test%';