1SELECT 
2    name, 
3    price_adj, 
4    currency_symbol, 
5    orderbook, 
6    created_at, 
7    SPLIT_PART(name, '.', -1) as tld 
8FROM "@blt.doma_testnet_core.listings" 
9WHERE created_at >= CURRENT_TIMESTAMP - INTERVAL '7 days'
10    AND name != 'negromotion.com'
11ORDER BY created_at DESC 
12LIMIT 50