crypto_edgarLand Pull 6
    Updated 2024-02-23
    with helius_call as (
    select
    11 as page_start,
    helius_das.get_assets_by_group(
    'mainnet',
    -- the network, 'mainnet' or 'devnet'
    { 'groupKey': 'collection',
    'groupValue': 'FiYyx2DXEsQtK6iVzQyFzJSistUa56xnKFagotrd2Mzf',
    'page': page_start,
    -- Starts at 1
    'limit': 1000,
    'sortBy': { 'sortBy': 'created',
    'sortDirection': 'asc' } }
    ) as response
    union
    all
    select
    12 as page_start,
    helius_das.get_assets_by_group(
    'mainnet',
    -- the network, 'mainnet' or 'devnet'
    { 'groupKey': 'collection',
    'groupValue': 'FiYyx2DXEsQtK6iVzQyFzJSistUa56xnKFagotrd2Mzf',
    'page': page_start,
    -- Starts at 1
    'limit': 1000,
    'sortBy': { 'sortBy': 'created',
    'sortDirection': 'asc' } }
    ) as response
    ),
    heist_land_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