Perform SELECT
queries from Base on the Pudgy Penguins NFT collection on Ethereum to see which NFTs an address owns over a specified block range.
0.00015
0xBd3531dA5CF5857e7CfAA92426877b022e612cf8
(the Pudgy Penguins contract address)5
0x29469395eAf6f95920E59F858042f0e28D98a20B
for the Blur NFT marketplace).20014590
to 20014690
).If you are familiar with SQL, the query you send translates to this statement:
SELECT token_ids
FROM pudgy_penguins
WHERE owner = '0x29469395eAf6f95920E59F858042f0e28D98a20B'
AND block >= 20014590
AND block <= 20014690
LIMIT 5 OFFSET 5
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.
respond
.Txn Hash
and navigate to the Logs
Tab. You should be able to see the token ids
which correspond to the NFTs of the holdertoken id
, then click on the NFT.Account ID of the Owner
The address of the Holder should ****correspond to the address you have specified in the query
Congratulations 🎉 you have made a query that fetches proved historic data on-chain!