AephiaRQ - Mining Fleets
    Updated 11 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 11 hours ago
    PLAYER_PROFILE
    WALLET
    MINING_FLEET
    1
    EaBZtysGxckNWqwKu1ZzcrxfTac8eE6X4AsD3KbPcmdiAvgWRsp3hytqvZHTzjWvaSXiRh7fYop3fYeYYJKX2EyLBS5Q3aaYzcSJumfKfRK7aA78SuUseAMEAa29hJkB84Rk
    2
    Grviw9XfGfEkW2AnvMKMSCzsyQU1SZ62wRRrokMdYqpw3VV6aT9orL2c1Y4dMvCCirg9qfKC5Uvei8SkHNWXRJ4dDtic8eMM2jRuE4VXGQkMfdMyX1cVZ2rzrJVTJYQV1SUF
    3
    7VGJ7akzxKiN842oPZwpzjNTT7cNhVdJmzsvNgzWtqM154Yukg7hXhWh8qjh7Mkgtt69PdPKrGDJ3LV1cv9Tdy6v63QETA6YjDyXGGk79nhNt5HzUCc3uHiMBQkX1CP9vhSd
    4
    BUDbY4rt6nKE57mP91nHH3fejNb6R4zrnAnfw9m9Si82DyLTNBKrsNzp1HEFdPKT92bSiGbkT9qErxfwcTcRtME6BLsdFCq5QnT7AJ7TfTALuZ2gDr5sGELDJNcWVCGMyqpc
    5
    Eyf2QJ8yTCu3ZXBz2V3x1J4xQ8twekMgGHChH4g6qA8EBZpvy3cLZktkTNxEEdN6xLNY6YtZ7TFQvYChzBdU1CuGSwtqhaF2UmhGp8nj823VxbAJazhAjWG57E8CcWua9Ny
    6
    4ndfZQPLGwJAWBk4aqJdaQGJ8tF9Bg2QKcUs64BsUYWThhq2P3TbFBFS7aAKAmnCmRFFcfH4wU6SXVpk4gD2zQJHbC7Ew7nhDDTwaDTANaK4qvNAbvJujDNmYpoLCXDQyJd
    7
    FSphdDmBZY15RcfaESsLr99cnQhkHVzdKiV1m5wkdwSc8Ah4gVgGh1FANbwfNUgRWZqGsViXbTwFCa8Nd28eJVyoC2DF3ZTkM1b4cuM4b3RvmZhvNeB9kZprBfg5eJZrTvui
    8
    3LAt8egSdxoR8ydnboC6rtBi5DqNGxwqvW1J7YWztQJT7hZLgnzBfywsmpiYWecKFHNXqvkyhxtQY5vtPsXE9dZcFgB2qVQ7D9UzVJ8i7hwbcrmTi44UVoU43D1v7tLZZcjd
    9
    8nCEkbxQ3UYAXWLuFCbYpkiGWkP9pwfDYVGuaJ4NcemT6UAZHmbYBKrLTrDK1w8MjihQMaG2HMJN87qudkiNi3uKBegumnfBJsoD161z5MGk3KhmkWJJzBFYNf2zyhw6kvbY
    10
    FURXQ3hywk4yAJfNCiVQmPeEi29HDAR7Bznw3Rj4ogdrDFckhQ95raoyrWEKjgmo6Fi6q2k6B5PBdtSsVsQzi4475CLmboG6KxdDeuy96zuQYwCTXwUgM7FpDgtnzE2H83HS
    11
    BjPPHzmpH4wyjLZkV9FcGC4BwPYNi1NHDnSDQs5QztMB2mSSPS2k8Zo2aoT7QdNvWRQJMnJQSE3h4ekxR5CUBhqb3XtqPF3EUNadHi92AUcBctG1oD4auqGrW3LKsTAjynZQ
    12
    GhMpDXZ9bTJtsyCehMCWQBmaaDGcmJsPM3RbQ6zy8L4CHTFtsQMhTm9k87GZ6Z5gZqcUkoGPZmbNUsAMRbpr6vj2VZY3U9fxhaQPBmvm1vFgZb7HRQpEvQUzkF5A5s83AQj
    13
    FFMNzBgG3rM7KEna5ZNRh7bRUB9dXhcyRS3dczpVzqCV3tWVQLggwqGNnoUzBuoFj8w8JatuRBMGH86UDbxz6tNLB8J26yx78u34C2dV6eYG5A3SJcaLN75mWDRtiGrs8Rqz
    14
    ARiydpFTRRhrhhyGMDLwydwqikUAVa5oXD8sawYAkEmc4qyXWSgP9kuMU6NuoPpBhjzm3CvQgZruXWMQrQPv7dE3tm5CCw6U6hUD4urWNUd1JVoJLwGUJxCF2P7FYZYrLxK
    15
    Ey1pir4MPEJyDDWzP2h9NrrTTUHf1Tw14Fb9NQzP7YEeFQ4rzpGAApsi64zDiqSWor8J1yk6oFimRrNzyFXe11gsEhBSmacr44ZVkCicffGq3uKtS5yo5vT8Fs7D9gg4Lxnb
    16
    G8Kv3sNc7Eq3UeEF4oB17XuYUQSZNPEsQ39NSZhdFoFF25Eza4YjNAtiPXD4dNpQg4uvrmyeRxX8TCXAf75nHg3Y2t3MTamzeQMrL1GfcBF8AFUKHpg2sVr4JxAqm7vhDWei
    17
    erMQ2AnCm5oFSJLDaNMRBX6C4eauuLMUJrE4NBKXqX18RwzRvX2Cd1c7u4vX6fWjYByQu6bvPK7qaiJ9aL4vUcc5FFoJUFtaZVEeJDpdUyJC4KsMVZ5D3U9PSN1AgpGGxJi
    18
    BYuv7VdfcVgyskjcGgtZfaNfgjtMVregTJHwiPEe6bo33vC7whN2uKsHeSpL8Mwyw9c6mu5DVNWuS1VAWnii6REd4tfamC8NdLmGb9agfGTHhUpbdK7qCPpFTKMo8BNMnZx2
    19
    BU1ajZM7kQkxqL5yZKZFun86YjLzUGHHXFghbQmoJfjoGex9MigVEXuzduZVUTM7LkPnSpBCz4S2AJ6LL7T5FWeQ5QqJriNNPiApcw65GWG2RaAgEaDLiXdbd3rKTKroPew
    20
    CFxeBKAybsKbaRKexAcvwXYLfRCkGz4Lu83M4M2swBEiHSpXKofLEXcm7dgtM9iyT3GUqo9pi9oGuQnUjhQVFTcg5sxSRPuxD3LnrGXWZeaERix11JL4veq38JmnjGo64nwc
    ...
    7049
    983KB
    3s