WITH distinct_urn_snapshots AS (
    SELECT DISTINCT ON (urn_identifier, ilk_identifier)
        urn_identifier, ilk_identifier, block_height, ink, coalesce(art, 0), created, updated
        FROM api.urn_snapshot
        WHERE block_height <= api.max_block()
        ORDER BY urn_identifier, ilk_identifier, updated DESC)
SELECT *
    FROM distinct_urn_snapshots
    LIMIT NULL::integer
    OFFSET 0

-- My database has been migrated
SELECT * from api.all_urns();