ravelmanual-emerald
    Updated 2025-02-27
    WITH base AS (
    SELECT
    ft.block_timestamp,
    el.origin_from_address AS minter,
    el.origin_to_address,
    el.tx_hash,
    TRY_CAST(
    CASE
    WHEN TRY_CAST(utils.udf_hex_to_int(SUBSTR(topic_3, -40, 40)) AS DECIMAL(38,0)) <= 888
    THEN utils.udf_hex_to_int(SUBSTR(topic_3, -40, 40))
    ELSE NULL
    END
    AS DECIMAL(38,0)) AS tokenID
    FROM monad.testnet.fact_event_logs el
    INNER JOIN monad.testnet.fact_traces ft
    ON el.tx_hash = ft.tx_hash
    WHERE contract_address = LOWER('0x2FC49a061b8ec3615b5cd1806bf287909069c5Be')
    AND TX_SUCCEEDED = 'TRUE'
    AND EVENT_REMOVED = 'FALSE'
    )

    ,base2 AS (
    SELECT
    tx_hash,
    COUNT(CASE WHEN tokenID IS NOT NULL THEN 1 END) AS tokenID_count,
    COUNT(CASE WHEN tokenID IS NULL THEN 1 END) AS null_tokenID_count
    FROM base
    GROUP BY tx_hash
    )

    ,base3 AS (
    select *
    from base2
    where null_tokenID_count > tokenID_count
    )

    Last run: 19 days ago
    BLOCK_NUMBER
    BLOCK_TIMESTAMP
    TX_HASH
    TX_POSITION
    EVENT_INDEX
    CONTRACT_ADDRESS
    TOPICS
    TOPIC_0
    TOPIC_1
    TOPIC_2
    TOPIC_3
    DATA
    EVENT_REMOVED
    ORIGIN_FROM_ADDRESS
    ORIGIN_TO_ADDRESS
    ORIGIN_FUNCTION_SIGNATURE
    TX_SUCCEEDED
    FACT_EVENT_LOGS_ID
    INSERTED_TIMESTAMP
    MODIFIED_TIMESTAMP
    1
    40312152025-02-19 21:47:46.0000x93d6b560cd1f29662f58c9c4faf1d39221f3bd8b937335ff426f97821cc306a5460x25548ba29a0071f30e4bdcd98ea72f79341b07a1
    ["0xce771ab142d4dae572f01bd7e3eb77c8241179ce1a8128451099727badfba64e","0...
    0xce771ab142d4dae572f01bd7e3eb77c8241179ce1a8128451099727badfba64e0x000000000000000000000000ee7c7ffd631c6cdfb42dff6e544833c910fea4e90x0000000000000000000000002fc49a061b8ec3615b5cd1806bf287909069c5be0x000000000000000000000000548930259d5aa86e67c0bd18ae1f57ee2abaeb2a
    0x03000000000000000000000000000000000000000000000000000000003d82dc000000...
    FALSE0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a0x25548ba29a0071f30e4bdcd98ea72f79341b07a10xd057c8b1TRUE9fb66cd54e503a3931f47d6c671d2d8c2025-02-19 22:53:20.6652025-02-19 22:53:20.665
    2
    40312152025-02-19 21:47:46.0000x93d6b560cd1f29662f58c9c4faf1d39221f3bd8b937335ff426f97821cc306a5470x2fc49a061b8ec3615b5cd1806bf287909069c5be
    ["0xc9c7c3fe08b88b4df9d4d47ef47d2c43d55c025a0ba88ca442580ed9e7348a16"]
    0xc9c7c3fe08b88b4df9d4d47ef47d2c43d55c025a0ba88ca442580ed9e7348a16
    0x0000000000000000000000000000000000000000000000000000000000000040000000...
    FALSE0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a0x25548ba29a0071f30e4bdcd98ea72f79341b07a10xd057c8b1TRUEaa28d04a50c083c2cbc541326e5754972025-02-19 22:53:20.6652025-02-19 22:53:20.665
    3
    40312152025-02-19 21:47:46.0000x93d6b560cd1f29662f58c9c4faf1d39221f3bd8b937335ff426f97821cc306a5480x2fc49a061b8ec3615b5cd1806bf287909069c5be
    ["0x8292fce18fa69edf4db7b94ea2e58241df0ae57f97e0a6c9b29067028bf92d76","0...
    0x8292fce18fa69edf4db7b94ea2e58241df0ae57f97e0a6c9b29067028bf92d760x00000000000000000000000000000000000000000000000000000000000000000x000000000000000000000000548930259d5aa86e67c0bd18ae1f57ee2abaeb2a0xFALSE0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a0x25548ba29a0071f30e4bdcd98ea72f79341b07a10xd057c8b1TRUE10648d72862b78550405d219ec8fdee22025-02-19 22:53:20.6652025-02-19 22:53:20.665
    4
    40312152025-02-19 21:47:46.0000x93d6b560cd1f29662f58c9c4faf1d39221f3bd8b937335ff426f97821cc306a5490x2fc49a061b8ec3615b5cd1806bf287909069c5be
    ["0x2f8788117e7eff1d82e926ec794901d17c78024a50270940304540a733656f0d","0...
    0x2f8788117e7eff1d82e926ec794901d17c78024a50270940304540a733656f0d0x00000000000000000000000000000000000000000000000000000000000000000x000000000000000000000000548930259d5aa86e67c0bd18ae1f57ee2abaeb2a0x00000000000000000000000025548ba29a0071f30e4bdcd98ea72f79341b07a10xFALSE0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a0x25548ba29a0071f30e4bdcd98ea72f79341b07a10xd057c8b1TRUEf8a8ccacc599229ed9cec99c383be8972025-02-19 22:53:20.6652025-02-19 22:53:20.665
    5
    40312152025-02-19 21:47:46.0000x93d6b560cd1f29662f58c9c4faf1d39221f3bd8b937335ff426f97821cc306a54100x2fc49a061b8ec3615b5cd1806bf287909069c5be
    ["0x2f8788117e7eff1d82e926ec794901d17c78024a50270940304540a733656f0d","0...
    0x2f8788117e7eff1d82e926ec794901d17c78024a50270940304540a733656f0d0x9f2df0fed2c77648de5860a4cc508cd0818c85b8b8a1ab4ceeef8d981c8956a60x000000000000000000000000548930259d5aa86e67c0bd18ae1f57ee2abaeb2a0x00000000000000000000000025548ba29a0071f30e4bdcd98ea72f79341b07a10xFALSE0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a0x25548ba29a0071f30e4bdcd98ea72f79341b07a10xd057c8b1TRUEf6793f3b790e1670c7f275ef7319ee1e2025-02-19 22:53:20.6652025-02-19 22:53:20.665
    6
    40312152025-02-19 21:47:46.0000x93d6b560cd1f29662f58c9c4faf1d39221f3bd8b937335ff426f97821cc306a54110x2fc49a061b8ec3615b5cd1806bf287909069c5be
    ["0x2f8788117e7eff1d82e926ec794901d17c78024a50270940304540a733656f0d","0...
    0x2f8788117e7eff1d82e926ec794901d17c78024a50270940304540a733656f0d0x8502233096d909befbda0999bb8ea2f3a6be3c138b9fbf003752a4c8bce86f6c0x000000000000000000000000548930259d5aa86e67c0bd18ae1f57ee2abaeb2a0x00000000000000000000000025548ba29a0071f30e4bdcd98ea72f79341b07a10xFALSE0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a0x25548ba29a0071f30e4bdcd98ea72f79341b07a10xd057c8b1TRUEb6a9bd4c7fd90b41467d1f468cbf794a2025-02-19 22:53:20.6652025-02-19 22:53:20.665
    7
    40312152025-02-19 21:47:46.0000x93d6b560cd1f29662f58c9c4faf1d39221f3bd8b937335ff426f97821cc306a54120x2fc49a061b8ec3615b5cd1806bf287909069c5be
    ["0x2f8788117e7eff1d82e926ec794901d17c78024a50270940304540a733656f0d","0...
    0x2f8788117e7eff1d82e926ec794901d17c78024a50270940304540a733656f0d0x8502233096d909befbda0999bb8ea2f3a6be3c138b9fbf003752a4c8bce86f6c0x00000000000000000000000000000000000000000000000000000000000000000x00000000000000000000000025548ba29a0071f30e4bdcd98ea72f79341b07a10xFALSE0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a0x25548ba29a0071f30e4bdcd98ea72f79341b07a10xd057c8b1TRUE3669a3115e732f69fd8f28f37f5293e32025-02-19 22:53:20.6652025-02-19 22:53:20.665
    8
    40312152025-02-19 21:47:46.0000x93d6b560cd1f29662f58c9c4faf1d39221f3bd8b937335ff426f97821cc306a54130x2fc49a061b8ec3615b5cd1806bf287909069c5be
    ["0x2f8788117e7eff1d82e926ec794901d17c78024a50270940304540a733656f0d","0...
    0x2f8788117e7eff1d82e926ec794901d17c78024a50270940304540a733656f0d0x6bd6b5318a46e5fff572d5e4258a20774aab40cc35ac7680654b9081fcc82f800x000000000000000000000000548930259d5aa86e67c0bd18ae1f57ee2abaeb2a0x00000000000000000000000025548ba29a0071f30e4bdcd98ea72f79341b07a10xFALSE0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a0x25548ba29a0071f30e4bdcd98ea72f79341b07a10xd057c8b1TRUEec3ae958eb1df30c41ce563f464c99032025-02-19 22:53:20.6652025-02-19 22:53:20.665
    9
    40312152025-02-19 21:47:46.0000x93d6b560cd1f29662f58c9c4faf1d39221f3bd8b937335ff426f97821cc306a54140x2fc49a061b8ec3615b5cd1806bf287909069c5be
    ["0xbd79b86ffe0ab8e8776151514217cd7cacd52c909f66475c3af44e129f0b00ff","0...
    0xbd79b86ffe0ab8e8776151514217cd7cacd52c909f66475c3af44e129f0b00ff0x6bd6b5318a46e5fff572d5e4258a20774aab40cc35ac7680654b9081fcc82f800x00000000000000000000000000000000000000000000000000000000000000000x6bd6b5318a46e5fff572d5e4258a20774aab40cc35ac7680654b9081fcc82f800xFALSE0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a0x25548ba29a0071f30e4bdcd98ea72f79341b07a10xd057c8b1TRUEd08f16a3458156e0190c4bb1ceb2efae2025-02-19 22:53:20.6652025-02-19 22:53:20.665
    10
    40312152025-02-19 21:47:46.0000x93d6b560cd1f29662f58c9c4faf1d39221f3bd8b937335ff426f97821cc306a54150x2fc49a061b8ec3615b5cd1806bf287909069c5be
    ["0xe2497bd806ec41a6e0dd992c29a72efc0ef8fec9092d1978fd4a1e00b2f18304","0...
    0xe2497bd806ec41a6e0dd992c29a72efc0ef8fec9092d1978fd4a1e00b2f183040x0000000000000000000000001af20c6b23373350ad464700b5965ce4b0d2ad940x00000000000000000000000000000000000000000000000000000000000000faFALSE0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a0x25548ba29a0071f30e4bdcd98ea72f79341b07a10xd057c8b1TRUEae8d715d5fff18abb835af668d7fe1b82025-02-19 22:53:20.6652025-02-19 22:53:20.665
    11
    40312152025-02-19 21:47:46.0000x93d6b560cd1f29662f58c9c4faf1d39221f3bd8b937335ff426f97821cc306a54160x2fc49a061b8ec3615b5cd1806bf287909069c5be
    ["0x90d7ec04bcb8978719414f82e52e4cb651db41d0e6f8cea6118c2191e6183adb","0...
    0x90d7ec04bcb8978719414f82e52e4cb651db41d0e6f8cea6118c2191e6183adb0x000000000000000000000000548930259d5aa86e67c0bd18ae1f57ee2abaeb2a0x0000000000000000000000000000000000000000000000000000000000000000FALSE0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a0x25548ba29a0071f30e4bdcd98ea72f79341b07a10xd057c8b1TRUE6804fdcd3c49f93d5582dd9e322b08ea2025-02-19 22:53:20.6652025-02-19 22:53:20.665
    12
    40312152025-02-19 21:47:46.0000x93d6b560cd1f29662f58c9c4faf1d39221f3bd8b937335ff426f97821cc306a54170x2fc49a061b8ec3615b5cd1806bf287909069c5be
    ["0x299d17e95023f496e0ffc4909cff1a61f74bb5eb18de6f900f4155bfa1b3b333","0...
    0x299d17e95023f496e0ffc4909cff1a61f74bb5eb18de6f900f4155bfa1b3b3330x000000000000000000000000548930259d5aa86e67c0bd18ae1f57ee2abaeb2a0xFALSE0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a0x25548ba29a0071f30e4bdcd98ea72f79341b07a10xd057c8b1TRUE9a44d2a869fb20fea84ccfa570c0181b2025-02-19 22:53:20.6652025-02-19 22:53:20.665
    13
    40312152025-02-19 21:47:46.0000x93d6b560cd1f29662f58c9c4faf1d39221f3bd8b937335ff426f97821cc306a54180x2fc49a061b8ec3615b5cd1806bf287909069c5be
    ["0x7f26b83ff96e1f2b6a682f133852f6798a09c465da95921460cefb3847402498"]
    0x7f26b83ff96e1f2b6a682f133852f6798a09c465da95921460cefb38474024980x0000000000000000000000000000000000000000000000000000000000000001FALSE0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a0x25548ba29a0071f30e4bdcd98ea72f79341b07a10xd057c8b1TRUEf6fbb2668348d4ccc0414d8b80b0ab472025-02-19 22:53:20.6652025-02-19 22:53:20.665
    14
    40313252025-02-19 21:48:41.0000xa4056c45a9b93ad5ae9b57e2e60d25d5b397c6ce9cf62b394168da9d86c34864000x2fc49a061b8ec3615b5cd1806bf287909069c5be
    ["0x2a0365091ef1a40953c670dce28177e37520648a6fdc91506bffac0ab045570d","0...
    0x2a0365091ef1a40953c670dce28177e37520648a6fdc91506bffac0ab045570d0x0000000000000000000000000000000000000000000000000000000000000000
    0x0000000000000000000000000000000000000000000000000000000000000063000000...
    FALSE0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a0x2fc49a061b8ec3615b5cd1806bf287909069c5be0xd37c353bTRUEff5dc6353e18626672dbb60aba95e1ce2025-02-19 22:53:20.6652025-02-19 22:53:20.665
    15
    40313892025-02-19 21:49:13.0000x363a94bb1cd2e0e680c69ffabf9a47e737c5dc5740053cc718539c15dd9033495130x2fc49a061b8ec3615b5cd1806bf287909069c5be
    ["0x2a0365091ef1a40953c670dce28177e37520648a6fdc91506bffac0ab045570d","0...
    0x2a0365091ef1a40953c670dce28177e37520648a6fdc91506bffac0ab045570d0x0000000000000000000000000000000000000000000000000000000000000064
    0x00000000000000000000000000000000000000000000000000000000000000c7000000...
    FALSE0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a0x2fc49a061b8ec3615b5cd1806bf287909069c5be0xd37c353bTRUE4471148ce2e701627d8a533c689002d82025-02-19 22:53:20.6652025-02-19 22:53:20.665
    16
    40314592025-02-19 21:49:48.0000xe1ebbdb34bb5463e84cbd2b8c640650d770823c03216052f72336105544e6605270x2fc49a061b8ec3615b5cd1806bf287909069c5be
    ["0x2a0365091ef1a40953c670dce28177e37520648a6fdc91506bffac0ab045570d","0...
    0x2a0365091ef1a40953c670dce28177e37520648a6fdc91506bffac0ab045570d0x00000000000000000000000000000000000000000000000000000000000000c8
    0x000000000000000000000000000000000000000000000000000000000000012b000000...
    FALSE0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a0x2fc49a061b8ec3615b5cd1806bf287909069c5be0xd37c353bTRUEae0b0fa918d7c95aaa25b7ef67a924372025-02-19 22:53:20.6652025-02-19 22:53:20.665
    17
    40315172025-02-19 21:50:17.0000x5aa4892b0140a321f303d9e28fb21e9fccea72892e697871ec1ebf552e9e68ee260x2fc49a061b8ec3615b5cd1806bf287909069c5be
    ["0x2a0365091ef1a40953c670dce28177e37520648a6fdc91506bffac0ab045570d","0...
    0x2a0365091ef1a40953c670dce28177e37520648a6fdc91506bffac0ab045570d0x000000000000000000000000000000000000000000000000000000000000012c
    0x000000000000000000000000000000000000000000000000000000000000018f000000...
    FALSE0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a0x2fc49a061b8ec3615b5cd1806bf287909069c5be0xd37c353bTRUE978cbfb3385f6d8bda33de78aaef17d82025-02-19 22:53:20.6652025-02-19 22:53:20.665
    18
    40315792025-02-19 21:50:48.0000xf27290c6c7a43b00a95f1a100134603e592c0686e3950cf24437a0e594fd503f6170x2fc49a061b8ec3615b5cd1806bf287909069c5be
    ["0x2a0365091ef1a40953c670dce28177e37520648a6fdc91506bffac0ab045570d","0...
    0x2a0365091ef1a40953c670dce28177e37520648a6fdc91506bffac0ab045570d0x0000000000000000000000000000000000000000000000000000000000000190
    0x00000000000000000000000000000000000000000000000000000000000001f3000000...
    FALSE0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a0x2fc49a061b8ec3615b5cd1806bf287909069c5be0xd37c353bTRUEb8a169cec4e8235a74e2935afd46feb12025-02-19 22:53:20.6652025-02-19 22:53:20.665
    19
    40316442025-02-19 21:51:21.0000xe2fb6b27f176db14237e02b6b3edd56a8d710aaf8115d5a3de503df5e89aed78150x2fc49a061b8ec3615b5cd1806bf287909069c5be
    ["0x2a0365091ef1a40953c670dce28177e37520648a6fdc91506bffac0ab045570d","0...
    0x2a0365091ef1a40953c670dce28177e37520648a6fdc91506bffac0ab045570d0x00000000000000000000000000000000000000000000000000000000000001f4
    0x0000000000000000000000000000000000000000000000000000000000000257000000...
    FALSE0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a0x2fc49a061b8ec3615b5cd1806bf287909069c5be0xd37c353bTRUE6617e513f48b51e0597eab8ffa3b00e12025-02-19 22:53:20.6652025-02-19 22:53:20.665
    20
    40316992025-02-19 21:51:48.0000x241fa178aa7c7a80cb562d04aba73f12fc8963d4c37c38254bfdf5461bb03def330x2fc49a061b8ec3615b5cd1806bf287909069c5be
    ["0x2a0365091ef1a40953c670dce28177e37520648a6fdc91506bffac0ab045570d","0...
    0x2a0365091ef1a40953c670dce28177e37520648a6fdc91506bffac0ab045570d0x0000000000000000000000000000000000000000000000000000000000000258
    0x00000000000000000000000000000000000000000000000000000000000002bb000000...
    FALSE0x548930259d5aa86e67c0bd18ae1f57ee2abaeb2a0x2fc49a061b8ec3615b5cd1806bf287909069c5be0xd37c353bTRUE19fd55b243ff8eefa717d4cccd49a1b22025-02-19 22:53:20.6652025-02-19 22:53:20.665
    ...
    533
    445KB
    8s