select

3 as page_start,

helius_das.get_assets_by_group(

'mainnet',

-- the network, 'mainnet' or 'devnet'

{ 'groupKey': 'collection',

'groupValue': 'EcSoa68ijMSR2ZZetvBkCcKk7fWC5paMF7i5kTXRsS2o',

'page': page_start,

-- Starts at 1

'limit': 1000,

'sortBy': { 'sortBy': 'created',

'sortDirection': 'asc' } }

) as response

union

all

select

4 as page_start,

helius_das.get_assets_by_group(

'mainnet',

-- the network, 'mainnet' or 'devnet'

{ 'groupKey': 'collection',

'groupValue': 'EcSoa68ijMSR2ZZetvBkCcKk7fWC5paMF7i5kTXRsS2o',

'page': page_start,

-- Starts at 1

'limit': 1000,

'sortBy': { 'sortBy': 'created',

'sortDirection': 'asc' } }

) as response

),

honeyland_genesis_mints as (

select

CURRENT_TIMESTAMP() AS BLOCK_TIMESTAMP,

f.value :id as MINT,

f.value :ownership:owner as TX_TO,

f.value :content:metadata:attributes as metadata