kellenUntitled Query
Updated 2022-07-07Copy Reference Fork
9
1
2
3
4
5
6
›
⌄
SELECT v.collection, v.mint, v.token_id, v.deal_score_rank, v.rarity_rank, v.fair_market_price , m.image_url
FROM flipside_prod_db.crosschain.nft_fair_market_value v
LEFT JOIN solana.core.dim_nft_metadata m ON m.mint = v.mint
WHERE v.mint = '3hDW84qQdbh8TcCvJWwDQ1SXbqWmG6QxX84JCq7ZP4Dp'
ORDER BY CASE WHEN COALESCE(m.image_url, 'None') = 'None' THEN 1 ELSE 0 END
LIMIT 1
Run a query to Download Data