token_name,

to_number(trim(token_name,'Ecumenopolis #')) AS Number,

project_name,

replace(token_metadata:traits[1]:value::string,'Theme: ','') AS Theme,

replace(token_metadata:traits[2]:value::string,'Palette: ','') AS Palette,

replace(token_metadata:traits[3]:value::string,'Lights: ','') AS Lights,

replace(token_metadata:traits[4]:value::string,'Atmosphere: ','') AS Atmosphere,

replace(token_metadata:traits[5]:value::string,'Blueprint: ','') AS Blueprint,

replace(token_metadata:traits[6]:value::string,'Architect: ','') AS Architect,

replace(token_metadata:traits[7]:value::string,'Painter: ','') AS Painter,

replace(token_metadata:traits[8]:value::string,'Lean: ','') AS Lean,

replace(token_metadata:traits[9]:value::string,'Complication: ','') AS Complication,

replace(token_metadata:traits[10]:value::string,'Vertigo: ','') AS Vertigo,

replace(token_metadata:traits[11]:value::string,'Warping: ','') AS Warping,

replace(token_metadata:traits[12]:value::string,'Stacked: ','') AS Stacked,

replace(token_metadata:traits[13]:value::string,'Height: ','') AS Height,

replace(token_metadata:traits[14]:value::string,'Scale: ','') AS Scale,

replace(token_metadata:traits[15]:value::string,'Takeover: ','') AS Takeover

from ethereum.nft_metadata

where contract_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270'

and lower(token_name) LIKE '%ecumenopolis%'

and number <> 0)

select token_name, palette

from total

where palette in ('Lunar', 'Rogue', 'Argon', 'Mercury', 'Lunar, Rusted')

order by 2 desc