mamad-5XN3k32023-08-02 07:05 PM
    Updated 2023-08-02
    --with datat as (
    SELECT
    *
    FROM
    bsc.core.ez_decoded_event_logs
    WHERE
    contract_address = '0xcadc6c364e8fcad0f382fddfd6ff5b41d82eb3e4'


    /*with L (name,contract) as (
    --values
    ('Mystery Box 📦' , '0xce4f341622340d56e397740d325fd357e62b91cb'),
    ('Mystery Box 📦' , '0xcadc6c364e8fcad0f382fddfd6ff5b41d82eb3e4'),
    ('The Shards 🪞' , '0xd9c225efcc4162173a7369a14fd559de4e4aadae'),
    ('The Shards 🪞' , '0xf1d9a02674a7a45dc4d5cdd5da330f6a989f77d5'),
    ('Mini Shards 🪞' , '0x1bc274c3b3b24cef54d01aeeb9ffc73ac0b68936'),
    ('Mini Shards 🪞' , '0x49253c64e6fa46d299177b8a94ae49d2f82c5c95'),
    ('W3ST ⚡️' , '0xdff431165c232090ab28b476b5f7f3995c84cf7c'))

    select * from L*/
    Run a query to Download Data