pub const LIST_OBJECT_PLACEMENTS: &str = "\
SELECT i.collection, c.account, i.seq, i.link_id, i.flags, i.level \
FROM items i JOIN collections c ON c.id = i.collection \
WHERE i.object_hash = :hash AND i.deleted = 0 AND i.retained_at IS NULL \
ORDER BY c.account IS NULL, c.account, i.collection";Expand description
The same on the dedup axis, by body rather than identity, so it pairs placements two servers gave different link ids.