denze-e7j2NU2023-03-11 04:42 PM
    Updated 2023-03-12
    -- SELECT
    -- contract_address AS nft_contract_address
    -- , decoded_log:tokenId::text AS token_id
    -- FROM ethereum.core.ez_decoded_event_logs
    -- WHERE true
    -- AND contract_address = lower('0xc143bbfcDBdBEd6d454803804752a064A622C1F3')
    -- AND event_name = 'BlueprintMinted'
    -- AND EXISTS (
    -- SELECT 1 FROM input_artist a
    -- WHERE true
    -- AND decoded_log:artist::text = a.artist_wallet
    -- )
    -- AND tx_status = 'SUCCESS'
    -- limit 100

    /*
    SELECT
    contract_address AS nft_contract_address
    , tokenId AS token_id
    from async_ethereum.BlueprintV11_evt_BlueprintMinted bm
    WHERE true
    */

    SELECT
    contract_address AS nft_contract_address
    , 'MakersPlace' AS name
    , decoded_log:_tokenId::text AS token_id
    , decoded_log:_from::text AS from_address
    , decoded_log:_to::text AS to_address
    , 1 AS amount
    , 'false' AS is_erc1155
    , ROW_NUMBER() OVER (PARTITION BY contract_address, decoded_log:tokenId::number ORDER BY block_number ASC, event_index ASC) AS rank_asc
    , ROW_NUMBER() OVER (PARTITION BY contract_address, decoded_log:tokenId::number ORDER BY block_number DESC, event_index DESC) AS rank_desc
    , *
    FROM ethereum.core.ez_decoded_event_logs
    Run a query to Download Data