LTirrellhoneypot user mint_type_full failed tx limit
    Updated 2023-04-22
    -- forked from honeypot user mint_type_full failed tx @ https://flipsidecrypto.xyz/edit/queries/09cdf0ed-d84e-4093-9ed4-24f41b1fec14
    -- forked from honeypot user mint_type_full @ https://flipsidecrypto.xyz/edit/queries/3e92bb36-9f71-4796-bbf4-409c357791cc
    -- forked from honeypot @ https://flipsidecrypto.xyz/edit/queries/e7c743f7-1e80-48bd-b8f3-0a00ae481d2c
    with
    top_address as (
    SELECT
    signers[0] as address,
    count(distinct tx_id) as tx_count
    from
    solana.core.fact_transactions
    where
    array_contains(
    '6Sj47sKP8wpCJ5XfBzFmzKvDk7VdvaXoLDa1KthxD57X'::variant,
    signers
    )
    and block_timestamp::date > '2023-04-18'
    group by
    address
    )
    SELECT
    signers[0] as address,
    case
    when succeeded then 'Succeeded'
    else 'Failed'
    end as succeeded,
    count(distinct tx_id) as tx_count
    from
    solana.core.fact_transactions
    where
    array_contains(
    '6Sj47sKP8wpCJ5XfBzFmzKvDk7VdvaXoLDa1KthxD57X'::variant,
    signers
    )
    and block_timestamp::date > '2023-04-18'
    and address in (
    select
    Run a query to Download Data