flipside

    ronin egg searcher but mobs keys (must clean before)
    LittlerDataronin egg searcher but mobs keys (must clean before)
    Updated 2025-02-13
    with egg_mints as (

    select
    tx_hash
    ,block_timestamp
    ,to_address
    ,token_id
    ,concat ('https://ronin.metadata.ragmon.gg/0x89b84f8dd9be7ba6aafba802c6e4a7fc8be242ca/', token_id) as nft_metadata
    from ronin.nft.ez_nft_transfers
    where 1=1
    and contract_address= '0x89b84f8dd9be7ba6aafba802c6e4a7fc8be242ca'
    and IS_MINT = 'TRUE'
    and from_address = '0x0000000000000000000000000000000000000000'
    ),
    flatten as (
    select
    tx_hash
    ,block_timestamp
    ,to_address
    ,token_id
    ,nft_metadata
    ,live.udf_api(nft_metadata) as response
    ,case when key = 'description' then value end as description
    --,case when key = 'attributes' then value[3]:value end as mob_name
    ,case when key = 'attributes' then value[4]:value end as rarity
    ,case when key = 'attributes' then value[6]:value end as transport_method
    ,case when key = 'attributes' then value[7]:value end as targets
    ,case when key = 'attributes' then value[9]:value end as battle_type
    from egg_mints
    , lateral flatten (input => response:data)
    where key in ('attributes', 'description')
    )

    select
    tx_hash
    Last run: about 1 month ago
    TX_HASH
    BLOCK_TIMESTAMP
    TO_ADDRESS
    TOKEN_ID
    NFT_METADATA
    MAX(DESCRIPTION)
    MAX(MOB_NAME)
    MAX(RARITY)
    MAX(TRANSPORT_METHOD)
    MAX(TARGETS)
    MAX(BATTLE_TYPE)
    1
    		0x810a25c46fb1e21a3f2bd0d6b722f47dde752f9512367e4540ba55c7e7a0c1a52025-02-13 12:07:02.0000xc145d4a37f80750df65b998c87f51645129ef819321https://ronin.metadata.ragmon.gg/0x89b84f8dd9be7ba6aafba802c6e4a7fc8be242ca/321
    Lunatic Egg
    17
    18
    18
    1739711756
    2
    		0x4ba3683eb8231592ec7fae401fdf85dd095577c091f1756103814cc596c8b81f2025-02-13 12:03:11.0000xc145d4a37f80750df65b998c87f51645129ef819313https://ronin.metadata.ragmon.gg/0x89b84f8dd9be7ba6aafba802c6e4a7fc8be242ca/313
    Lunatic Egg
    17
    18
    18
    1739711708
    3
    		0xf1ca6e017ce4d3bcb563c0fe94c08c2798a596b35e804bf38f2c848735b69a132025-02-13 06:46:28.0000xc145d4a37f80750df65b998c87f51645129ef819207https://ronin.metadata.ragmon.gg/0x89b84f8dd9be7ba6aafba802c6e4a7fc8be242ca/207
    Zherlthsh Egg
    36
    11
    11
    1739689156
    4
    		0xce866cf716dcf6150904caf7e1f7457dde2925f4d2c6673431221442f1afba3b2025-02-13 06:55:01.0000xc145d4a37f80750df65b998c87f51645129ef819228https://ronin.metadata.ragmon.gg/0x89b84f8dd9be7ba6aafba802c6e4a7fc8be242ca/228
    Zherlthsh Egg
    36
    11
    11
    1739689310
    5
    		0x31f88c36dbc4d718e1613021a15dc74865bfa0e04d90838d02fcc84d8b17944a2025-02-13 07:06:05.0000xc145d4a37f80750df65b998c87f51645129ef819241https://ronin.metadata.ragmon.gg/0x89b84f8dd9be7ba6aafba802c6e4a7fc8be242ca/241
    Holden Egg
    23
    22
    22
    1739689901
    6
    		0x769ca242e97d829abf63da9b0b0bff3c5fbe011597d9e93afcde38b96640d48c2025-02-13 16:24:47.0000xc145d4a37f80750df65b998c87f51645129ef819385https://ronin.metadata.ragmon.gg/0x89b84f8dd9be7ba6aafba802c6e4a7fc8be242ca/385
    King Alligator Egg
    28
    6
    6
    1739723732
    7
    		0xec60d5c9957856f9b182f93df005a6201178dc6bd0d1a9321fd95dae402f358b2025-02-13 06:55:22.0000xc145d4a37f80750df65b998c87f51645129ef819229https://ronin.metadata.ragmon.gg/0x89b84f8dd9be7ba6aafba802c6e4a7fc8be242ca/229
    Zherlthsh Egg
    36
    22
    22
    1739689316
    8
    		0x9049d6671988e47b7417bccd3e6a7a7d497dea354e0c064b0e7b7546959c6d392025-02-13 01:59:11.0000x6d20bf47282c43e4ef0b44c5b14e062f944d12d598https://ronin.metadata.ragmon.gg/0x89b84f8dd9be7ba6aafba802c6e4a7fc8be242ca/98
    Savage Babe Egg
    5
    10
    4
    1739671733
    9
    		0xb92fb96684625fe5734b4a06f79e18dafb947f58e19a6f1632079cf8e12107f12025-02-13 01:27:47.0000x6d20bf47282c43e4ef0b44c5b14e062f944d12d585https://ronin.metadata.ragmon.gg/0x89b84f8dd9be7ba6aafba802c6e4a7fc8be242ca/85
    Savage Babe Egg
    5
    16
    16
    1739670872
    10
    		0xab403da4d426769275bb887628b27b38ee4d0b1eae8b1a73bc4ec40e800f43792025-02-13 10:18:38.0000xc145d4a37f80750df65b998c87f51645129ef819281https://ronin.metadata.ragmon.gg/0x89b84f8dd9be7ba6aafba802c6e4a7fc8be242ca/281
    Coco Egg
    15
    16
    16
    1739711510
    11
    		0x1aafb1fcfb803cb8c32ce31fdb38d11d3f807b150e5f5ad9e8e88ef3960a85512025-02-13 06:51:10.0000xc145d4a37f80750df65b998c87f51645129ef819222https://ronin.metadata.ragmon.gg/0x89b84f8dd9be7ba6aafba802c6e4a7fc8be242ca/222
    Zherlthsh Egg
    36
    22
    22
    1739689265
    12
    		0x4c2dfd36dff49e8da4480380edc3c605150d3a3cc3365d8bd9269946f9f4708b2025-02-13 16:41:59.0000x29a0b292d65e6449e24a1ce699878ea6309fe308401https://ronin.metadata.ragmon.gg/0x89b84f8dd9be7ba6aafba802c6e4a7fc8be242ca/401
    Poring Egg
    1
    2
    1
    1739724713
    13
    		0xd3b0fa9d4098ff9bac7a169da91407841af3244f6f1af790b8cdd684cc6c97b62025-02-12 23:59:38.0000xbd06bb2d40e0eae03e1532c86c52e1d52ce87e4153https://ronin.metadata.ragmon.gg/0x89b84f8dd9be7ba6aafba802c6e4a7fc8be242ca/53
    Banshee Egg
    26
    10
    9
    1739664197
    14
    		0xbd6fe5f6566369a4f4a2e461dbcb132a81b973dcb9e5b8f16d5e206e531f3e6b2025-02-13 01:25:56.0000x6d20bf47282c43e4ef0b44c5b14e062f944d12d580https://ronin.metadata.ragmon.gg/0x89b84f8dd9be7ba6aafba802c6e4a7fc8be242ca/80
    Zherlthsh Egg
    36
    17
    17
    1739670827
    15
    		0x5843808d0ad075b5f17af2ee1bf0936f9c9c29070b22efa627d393df6c2284282025-02-13 10:55:47.0000x2dcb3136a10a212e4446693514d90cab940201dd305https://ronin.metadata.ragmon.gg/0x89b84f8dd9be7ba6aafba802c6e4a7fc8be242ca/305
    Baphomet Egg
    3
    3
    1
    1739703479
    16
    		0xa158057797d4221f6e7e47848a92946f4e7731a12f1d268bb7671ac4660f3c662025-02-13 14:08:38.0000x272a0f390a38870b4ac449c6f66181b62f6a06d5372https://ronin.metadata.ragmon.gg/0x89b84f8dd9be7ba6aafba802c6e4a7fc8be242ca/372
    Greatest General Egg
    38
    4
    7
    1739715056
    17
    		0xa0de9db327f06f8d86f55fd6aaf28c2032b0ca4ff9692143b39d29a25d83e5532025-02-13 07:03:05.0000xc145d4a37f80750df65b998c87f51645129ef819233https://ronin.metadata.ragmon.gg/0x89b84f8dd9be7ba6aafba802c6e4a7fc8be242ca/233
    Holden Egg
    23
    22
    22
    1739689757
    18
    		0x0fc8824206a0cb4574e4c8c64db2af6ab5d8fcb5cf7b241e2d4c37b3e6eed4672025-02-13 06:44:19.0000xc145d4a37f80750df65b998c87f51645129ef819201https://ronin.metadata.ragmon.gg/0x89b84f8dd9be7ba6aafba802c6e4a7fc8be242ca/201
    Zherlthsh Egg
    36
    22
    22
    1739689111
    19
    		0x41f671697fffef39d2e3b50f94af6267f94b259992003d5d5a12cbf792e4ca322025-02-13 10:17:20.0000xc145d4a37f80750df65b998c87f51645129ef819279https://ronin.metadata.ragmon.gg/0x89b84f8dd9be7ba6aafba802c6e4a7fc8be242ca/279
    Coco Egg
    15
    18
    18
    1739711495
    20
    		0xa831e59fefcd02558c40530822c9737d890af79f9435a16cfda6cc1dc189cb652025-02-13 13:31:29.0000xc145d4a37f80750df65b998c87f51645129ef819362https://ronin.metadata.ragmon.gg/0x89b84f8dd9be7ba6aafba802c6e4a7fc8be242ca/362
    Steam Goblin Egg
    27
    17
    17
    1739723696
    ...
    369
    97KB
    15s