holaplex / indexer

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

#499: change featured_listings to choose NFTs whose creators have many followers #500

Closed austinmilt closed 2 years ago

austinmilt commented 2 years ago

This PR changes the featured_listings query to select listings whose creators have many followers by sorting results by the sum of followers of NFT creators.

To increase query speed, the PR also adds filters to only consider creators who have > 0 share and are verified.

closes #499

austinmilt commented 2 years ago

converted to draft because we risk featuring only listings from the top profile if they have many listings. There may be a solution to limit the number of listings per seller https://stackoverflow.com/a/49049105