Perform SELECT queries from Base, Fraxtal or Mantle on the Sappy Seals collection on Ethereum to see which Sappy Seals NFTs an address owns over a specified block range.

  1. Go to the sample query client contract for the L2 you’d like to query
    1. Base
    2. Fraxtal
    3. Mantle
  2. Click on “Connect to Web3” to connect your wallet.
  3. Expand the “queryNFT” section.
  4. Populate the following fields:
  5. Populate “holder” with an address you’d like to query (eg. 0x1C70D0A86475CC707b48aA79F112857e7957274f for the Staked Seals smart contract).
  6. Populate the “startBlock” and “endBlock” fields to identify the Ethereum mainnet block range you’d like to query over. You can get the most recent block numbers from Etherscan (eg. using the most recent block number in endblock and subtracting 100 to get a startblock - such as 20314348 to 20314358).
  7. Click the “Write” button to run the query.

Screenshot 2024-06-27 at 10.09.06.png

If you are familiar with SQL, the query you send translates to this statement:

SELECT token_ids
FROM   sappy_seals
WHERE  owner = '0x29469395eAf6f95920E59F858042f0e28D98a20B'
       AND block >= 20314348
       AND block <= 20314358
LIMIT  5 OFFSET 5

Check the Result of the Query

Once you sign and broadcast the query tx, the Lagrange Proof Network will compute an off-chain proof that it submits on chain once ready.

  1. Check the proof on the respective explorer in contract events (example for Basescan). Make sure the Method is respond.

Screenshot 2024-05-03 at 11.26.54.png

  1. Click on the Txn Hash and navigate to the Logs Tab. You should be able to see the token ids which correspond to the NFTs of the holder

Screenshot 2024-05-03 at 11.32.29.png

  1. Go to the Sappy Seals Collection on Opensea
  2. Check the owner of one of the NFT results by searching by the token id , then click on the NFT.

Screenshot 2024-07-15 at 9.26.09 PM.png

Screenshot 2024-07-15 at 10.21.20 PM.png

Account ID of the Owner

  1. The address of the Holder should ****correspond to the address you have specified in the query

    Screenshot 2024-07-15 at 10.23.09 PM.png


Congratulations 🎉 you have made a query that fetches proved historic data on-chain!