AephiaRQ - Cargo Fleets
    Updated 22 hours ago
    WITH scanning_fleets AS (
    SELECT
    player_profile
    ,scanning_fleet

    FROM $query('3a8ebe5d-26a2-455a-a891-95f51d6728e5')
    GROUP BY 1,2

    )



    ,mining_fleets AS (
    SELECT
    player_profile
    ,wallet
    ,mining_fleet

    FROM $query('c8db2715-8e54-400b-b37b-37057390cd40')
    GROUP BY 1,2,3

    )


    ,cargo_fleets AS (
    SELECT
    instruction:accounts[7]::string as player_profile
    ,instruction:accounts[0]::string as cargo_fleet


    FROM mining_fleets mf,
    solana.core.fact_events
    WHERE program_id = 'SAGE2HAwep459SNq61LHvjxPk4pLPEJLoMETef7f7EE'
    AND instruction:accounts[7] IN (mf.player_profile)
    Last run: about 22 hours ago
    PLAYER_PROFILE
    CARGO_FLEET
    1
    J4nGsHVEJ4ZEcmaEb1BJ1ChRDtS93L4ChCfwbnK4dgnjGENTH8KZHimJx7nLjbmxRemTCowx8y4VaW2peLthxhRS
    2
    DRckeF77miyiTXTJzRJxP68XqoUK9Pb3j2SWrpsHC6cC3T4ei66Jsys9Bajw5R7NXNJPKYjEsf4G7dTayC5qSfjA
    3
    5agg9QLkhFaDDoEkGRM5eiGxzfWYhNEZ9phJMd6cFow16yfR6ZNUxFKMMhnaXAo5B92NFTTXDTD4kZohUpCf4kp
    4
    EgXehCkKi4NLWgiCFaVRzh7Hw4rUqaqkW3UUus8coJxbCq6DwALtiGpW6dXpprnXywg5AA2hTBSs7jXDCFUQR11K
    5
    HZyKb9hLQjm7YEpM1oP3xQC2snaQims3N5yWz2p7CRHn3gxP1hqv9yD1ux7vQBuSjxgVYEdToSxRZ2zaGvL5Wnoj
    6
    BU1ajZM7kQkxqL5yZKZFun86YjLzUGHHXFghbQmoJfjoHb4C1WuknyJFezHDcyPrRsfyy9MQt7Z6HKRATFb38iad
    7
    4iverYQrVrxA4umYzoDYH2Jvojvm9u2cZFSa8eWMVqYmG471HDKMLf55MVkRpgXoBmDnu3apJb8Fmpp1wn9LF5i
    8
    BPzn5AnR8yNZrQyHs4p182MgiD2PnLrfbyD9KeLw3t7D6QXpHPH9o7HK8z1QieVkKoVcz9ttLYaVKy1T1FuYWTgt
    9
    5kCcKMtrrXCfDUVrzrb1XJCWnTiCTZd9daUx4gBjt7Wn2p868NfJrZSDXmTg7F9PfzTS3yfUs1jJPZh7T4rp8sMM
    10
    364preq8pHWjMBF5hZv48JEtDXjaP3C7JbUCoudYogVrB68vTJnyYZEcW3SQXGjZwQwcrDALZCdREGEUCWUArYas
    11
    93qXpd5i5etD6kH2b7PjKYnJVb5gX3JXXg7WXPhKyDz533L77CLXGmbrDPkXYkMNheit4Xv8nZgPAwz1cwvVe6Y3
    12
    5kCcKMtrrXCfDUVrzrb1XJCWnTiCTZd9daUx4gBjt7Wn6pWLMVmKqLoS6JzQmNQjCwfCJ7hU5rPmTNrwqy7hhwy1
    13
    DRckeF77miyiTXTJzRJxP68XqoUK9Pb3j2SWrpsHC6cC5pQT1NqcqwQgUitWcJTZXEQtHyaod7CfZNZbf9pC78mF
    14
    FTZpQHfqWkk9W9uvP9VXu9EDJYezbWJdYqpcKJ9iYtpFDxZMB5Q9oahioLrqqhJZkdGrafBW6yxxTXSSpE7L5gBG
    15
    36BgqkNhasemZkRGz18f2yDhwoRtHM16nB2wzexGm6xnE8YrVWX2YtU8pvq1SZPDNXbSUSvdnN1ucyxwYe6qXVs5
    16
    329DyXiW66V5EAEF6FNmrrZKnMrMuVEaUV788HjgbzdqHp9Fcpmujg6W94mQHzmRQwdsMt9L8rhswaT6UabBnfic
    17
    HGQb6qsBFyDG1gCkufNV5iUtWRfLB8ypF1Z9KsMuYAig8DGpmPyhqe9C6rrjmyRQNd47iYUxfRcCDLoq1zb6jM3M
    18
    8gZyzhBj1ya6gW1UmYRDxi5bTfpn5aDfXK8dtGbJf9SE9GyXXK6iMYPkCC6Jczs5agZWbL5enU3E8LoVTC2nn7jQ
    19
    5D8cphS3FRWEQYSnYd6HBPxCYyuRjKu98tTZJJfWP6Vn6kZKQrFFjfsS7GLpzfT8SHQhPq7g58d5nU6GkyE9kGik
    20
    FuTa9petsdv1bSEAZbBuuNozkT3C3gPtyCSdXbWNk31bAzqb1JzA3Jvti9jDjwapgkoZUTovmCpFjFYaakCUgf3V
    ...
    799
    75KB
    7s