with article_data as (

select 1 as rn,'null' as catogery,'Lore 1 ♡ Introducing Mibera' as title, '<a href=https://0xhoneyjar.mirror.xyz/GTBSEjmFrVJ1CrCS0kUl-vaRZA6PY-c7IBs259jF1Fo>Lore 1 ♡ Introducing Mibera</a>' as articles, '0x6b31859e5e32a5212f1ba4d7b377604b9d4c7a60' as contract_address, 4713 as total_supply

union all

select 2 as rn,'null' as catogery,'Lore 2 ♡[HONEY] Online to get Offline: Clear pill vs Rave pill' as title, '<a href=https://0xhoneyjar.mirror.xyz/2KBy89fU4bNB09n1Mq74xkJEHyJ2Y8O1ocFdiCGMwpQ>Lore 2 ♡[HONEY] Online to get Offline: Clear pill vs Rave pill</a>' as articles, '0x9247edf18518c4dccfa7f8b2345a1e8a4738204f' as contract_address, 2355 as total_supply

union all

select 3 as rn,'null' as catogery,'Lore 3 ♡ [BERA] Kali/acc vs Cybernetic Psychedelic Mysticism' as title, '<a href=https://0xhoneyjar.mirror.xyz/B6C07ZIXarc77aSIL9TwFpKkxxnwNFkoQUtCQbVUG8Y>Lore 3 ♡ [BERA] Kali/acc vs Cybernetic Psychedelic Mysticism</a>' as articles, '0xb2c7f411aa425d3fce42751e576a01b1ff150385' as contract_address, 1175 as total_supply

union all

select 4 as rn,'null' as catogery,'Lore 4 ♡ [BGT] Network Spirituality (Spirit) vs Network Mysticism (Soul)' as title, '<a href=https://0xhoneyjar.mirror.xyz/cxMVbB4IklLs51vZp0vNe0dtegoRg-sF_RoNpPUGREw>Lore 4 ♡ [BGT] Network Spirituality (Spirit) vs Network Mysticism (Soul)</a>' as articles, '0xa12064e3b1f6102435e77aa68569e79955070357' as contract_address, 571 as total_supply

union all

select 5 as rn,'null' as catogery,'Lore 5 ♡ Mibera Initiation Ritual' as title, '<a href=https://0xhoneyjar.mirror.xyz/m84Rmtqo1EYJDXcuyw7V0dQ0qvuvLiuxuGNR4NWWtmw>Lore 5 ♡ Mibera Initiation Ritual </a>' as articles, '0x6ca29eed22f04c1ec6126c59922844811dcbcdfa' as contract_address, 271 as total_supply

union all

select 6 as rn,'null' as catogery,'Lore 6 ♡ MiberaMaker Design Document' as title, '<a href=https://0xhoneyjar.mirror.xyz/wr2WuLyOcqs_1VcHArJqIrLdl2JptvisI4wjWVCgGqY>Lore 6 ♡ MiberaMaker Design Document</a>' as articles, '0x7988434E1469d35fa5F442e649dE45D47c3df23C' as contract_address, 126 as total_supply

--0x96C200Ec4CcA0bc57444cFEe888cfbA78a1ddBD8

union all

select 7 as rn,'null' as catogery,'Lore 7 ♡ MiberaMaker Design Document' as title, '<a href=https://0xhoneyjar.mirror.xyz/A79gl6lTz-rZdHlrgaR4mt2EdghG6LUtVZp8PYAe5qc>Lore 7 ♡ MiberaMaker Design Document</a>' as articles, '0x96C200Ec4CcA0bc57444cFEe888cfbA78a1ddBD8' as contract_address, 107 as total_supply

,

collections as (

SELECT

block_timestamp::date as ddate

, PROJECT_NAME

, SUM(PRICE_USD) as volume

from ethereum.nft.ez_nft_sales

WHERE 1=1

AND NFT_ADDRESS IN (lower('0xCB0477d1Af5b8b05795D89D59F4667b59eAE9244'), '0x89b2249d7fbb30765d94c163929cd04b5afa77e3')

GROUP BY 1, 2

UNION ALL