search

holaplex / indexer

Index Solana data using a Geyser plugin (downstream service cluster)
https://holaplex.com
GNU Affero General Public License v3.0
162 stars 38 forks source link

Add wallet nfts query #748

Closed alchemistgo87 closed 2 years ago

alchemistgo87 commented 2 years ago

Example Sql Query:

SELECT metadatas.address, metadatas.name, metadatas.seller_fee_basis_points, metadatas.update_authority_address, metadatas.mint_address, metadatas.primary_sale_happened, metadatas.uri, metadatas.slot, metadata_jsons.description, metadata_jsons.image, metadata_jsons.animation_url, metadata_jsons.external_url, metadata_jsons.category, metadata_jsons.model, current_metadata_owners.token_account_address, listings.metadata, listings.price, listings.seller FROM metadata_jsons INNER JOIN metadatas ON metadata_jsons.metadata_address = metadatas.address INNER JOIN current_metadata_owners ON metadatas.mint_address = current_metadata_owners.mint_address LEFT JOIN listings ON listings.metadata = metadatas.address AND listings.seller = current_metadata_owners.owner_address WHERE owner_address = '14EEGLkAskxJyhnR1LNqmnGY9MkgQHxfXuik2SpnjYjN' AND burned_at IS NULL AND listings.purchase_id IS NULL AND listings.canceled_at IS NULL AND listings.auction_house <> '3o9d13qUvEuuauhFrVom1vuCzgNsJifeaBYDPquaT73Y' AND ((listings.expiry IS NULL) OR (listings.expiry > '2022-09-19 14:44:41')) ORDER BY listings.created_at DESC LIMIT 20 OFFSET 0