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