AephiaRQ - Mining Fleets
    Updated 16 hours ago
    /*
    SELECT
    instruction:accounts[0] as wallet
    ,instruction:accounts[1] as player_profile
    ,instruction:accounts[3] as mining_fleet

    FROM solana.core.fact_events
    WHERE program_id = 'SAGE2HAwep459SNq61LHvjxPk4pLPEJLoMETef7f7EE'
    AND instruction:accounts[4] = 'GAMEzqJehF8yAnKiTARUuhZMvLvkZVAsCVri5vSfemLr'
    AND instruction:accounts[18] = 'MineMBxARiRdMh7s1wdStSK4Ns3YfnLjBfvF5ZCnzuw'
    AND succeeded = 'true'
    AND block_timestamp > current_date-30 AND block_timestamp < current_date
    GROUP BY 1,2,3
    */

    --/*
    SELECT
    player_profile
    ,wallet
    ,mining_fleets as mining_fleet

    FROM SOLANA.SA.MINING_FLEETS
    GROUP BY 1,2,3
    --*/

    Last run: about 16 hours ago
    PLAYER_PROFILE
    WALLET
    MINING_FLEET
    1
    e31MkxbQAmMTq1tGfXSWWJhUHdt7ip6fRNVUK8Jf22eBgHVxDMmQz2hH4LzDuDbnz5Rw22m3PDgkjjiviPVfdEPCmcubJp9T5BXq4VtjmXfVQP6Lf3PMzfQCcSGzpoXKmbM
    2
    24X1q1KJYWGAEP731SjvsyywcF9uZ2Mzji34dEKDW7jsFKaARjtHg75T2bwLt9BhWCyGHn4yXXsEhCYuqAH9i8raC3XqB6WAR73k8ZCo4v8jKZHbXz5LuSKYTR3HJRzqB48s
    3
    2b5Pet8C47QqPWfvF8i5neWD4fyqPtEaXXxEuEe3ZJnDEDYJBBTojUGMqjWBDH4v7uPq1wdDKDRimqGmEtzUY1Z7E1XdhhQK1SgXDcyXjkM1prMZ9jtfaLDZCss2R5xwz8fK
    4
    4QDFnMLvnUexEEvu3C3aGrFoY4nhjET9YvFHoLXVmZC2G7rCtW3n8LMNvA7i6y4Lmknc14xK5TQWNdz7y5zHDi4sGENjp5GLdHMGaBcRvenpKAwx5TtWt3MsWAVeerTUSwqC
    5
    9ZnzsJ8v6JhyVnz9jj3sEu8Lr2GCVHP3tRGT4una9T58E1CWDXQbfkMzgQQmc1MTcWSc49nyo9E1dmeEN8efKXfWBaMxnFzkNvpQMCtFxmSa3MK3JavmkMQvMAqZmYT5ukyj
    6
    DiZCPvyR24fZGW9L1Jzo88XS3cxWsL6tZmAokWVyAZKyxCr8mg1Z3VsMhQHD4w7TYHzak5XPjCDrVY4uYWHK4FDAQv6Q7aZ76ay7tziNr1mvQhzPrgpsyL5EB3BDre9AxqC
    7
    B5o3m5XVgHpmUrxq6hiJcdMNsRVM6Ebc4KRUBtUuNSeXEoUhKwTHvSjMhd8Fk1tRQ16ETDBrdEUQJ7gExGwqJ98aAdQvpvNPWCP6xvnea3F1gJPqmcvnwuY1ZaTMj9FXBjJA
    8
    rrUpUPT6GdfKgriygP7TGAvzDGwYAXQDbHnVbcuc9E88rbs3roSS4xg9KGQGbPrsYN8Kz74hoM4tUJAVxQ3EobA7EUw4EAukHTXrhcSRxG6Lv2Hjfu3Ci3NW6kHbMaJf6nL
    9
    BZDVqTmPuLJraYNPTw8Tx61UiGzprEhYgmT6bAj7E1AG7RJKkNpi7Dggf7ij7N2eoV6vT5NBd3rV599xK57y7ifwHs6nids6GghFsBgdHnUAA81eQFXtnTkrMTWB29jeaZN4
    10
    Aq8VaMA4UsGDgeMSwcNDD9pDMjMwR2ygwr3S9kpPQFKm7uvuw3gcErxG9WZiPCjnZfz7dy25SVEdcVHgVjehWKJt5KDrMGzGuKNMTwbUjAVeuRyytK8tijAkhedhuKG8b1ba
    11
    5ivpiNc4TbJnG7fo89efcNQvJR3MhYT7jdBkaE3hwLR996WvjosxgopZajLrnz1BzCTzTwA8HavWrpvR7Ker3w5B3gvvbmzxCopxfT2A8dQkuAN2CuRR4Kgck9GxxKPEDanD
    12
    DaPrnPeUgN6qLt3hTVKoZQRomDzbzimcaMR5VmNNCVz86p9JKsgHVso3KcWf9Ffi1GrJLeBkmRz7dFfuNMqymhUx6B1tpKz9LYeTbXCEvn9af7UxX8WrER3EYsUCRTJPgAyn
    13
    BdNQKJw17jawL4qsKcydLHMMpUk7szcbf7oPAdF5sbFN7edjdvKdivY18HpYkSic2mMcvwqeGw2ni19GYXhyi3nn3Gqy517211pwpkLyn8w7Sk6ePNug6wc5vkThoYRbpuHZ
    14
    BtojjTREzhFCmcST6KCwEbyPgiJftU1MyAexcZNLLLEK7UM3ysfhNHd3XhaXGDz2URxMEtJ9Gn27hmCiVcM5k3e253tSs9F5hYHTfaf44irALxATB9NHzNftu9EiQ9Y4YejH
    15
    4YvxUTmDGxFh66tVGC3g2rw2E3JM6dNX6KPMSx7W7FQs8duL4GMGK5xC8aQaogkTPfBDmTyWZogGiXrkqxEiErxm2p511exRFm5aZas3J2GEKMjRLHLUuEA6u584CzdUmb6V
    16
    937WbqJhxcM8W4omx9yn4x6XSAAik8y7N5RJsmobAJS93Pw2yXimrjxkGGQ9SMiz8UNr4LMq4H81nNvEqUvMXPbpCptc7A4pg1b2L4fXVk5cWgntCt9QwowwZPxwDdQABU1Q
    17
    7e1gmus9ZU22k6inn8VoBKwEQpL3W6wZCtQhLhK6X6KNESrRf8M6G5gV5xAEHmEeUPBffzXXxU4fb9Hq5iY4ZNC948hVTPL24hcLNQcMh9QdPnSkFBbobMv5wTZHUwcw1kfr
    18
    BdNQKJw17jawL4qsKcydLHMMpUk7szcbf7oPAdF5sbFN7edjdvKdivY18HpYkSic2mMcvwqeGw2ni19GYXhyi3nn8z6A1QAPeegq2qduRZYfDMNufD6gVSBPkgvKMJ3fHBRV
    19
    Gpmyt2SWFxrJSSbLi1qYC93yFuovnDzSX6eSWcBCyysR8hBFAWkSu8rXNHTUNUkgtB99UUYTQ2qqgGCHnmdqtoHVERKhXz8PkD8e1AYjSiwKn6pWMohkhLwFxSjFXRWsgraf
    20
    FXtyF3qvDDGq4NrTW4AMudw7s9X3kRUxoTTYfsA5D6HBECTCD149xHpZSHqG767kSEEKpdLUPKYtDz8XfiwGCFNkGZf9MMSJa8LGDoJVGwM5LFK5poAA1eSikksQjvErC4id
    ...
    7276
    1015KB
    2s