denze-e7j2NURoyalties
    Updated 2023-11-08
    WITH

    contract AS (
    SELECT
    *
    FROM VALUES
    (lower('0x300e7a5fb0ab08af367d5fb3915930791bb08c2b'))
    AS data(nft_contract_address)
    )

    , input_token_ids AS (
    SELECT distinct
    F.value AS input_token_ids_num
    , 'tid' || F.value || '_' AS input_token_ids_string
    FROM (
    SELECT
    SPLIT(data.input_token_id_list, '_') AS input
    FROM VALUES
    ('{{royalty_token_ids}}')
    AS data(input_token_id_list)
    ) i
    , Table(Flatten(i.input)) AS F
    )

    , input_time AS (
    SELECT
    to_timestamp_ntz(data.time_period_start) AS time_period_start
    , CASE
    WHEN to_timestamp_ntz(data.time_period_end) > date_trunc('minute', current_timestamp) THEN date_trunc('minute', current_timestamp)
    ELSE date_trunc('minute', to_timestamp_ntz(data.time_period_end))
    END AS time_period_end
    FROM VALUES
    ('{{time_start}}', '{{time_end}}')
    AS data(time_period_start, time_period_end)
    )

    Run a query to Download Data