Tags: Libreplex Inscriptions on Solana

[k2rbpz]

• Brief description of your tag (what are you trying to tag)?
  • Libreplex Inscriptions on the Solana blockchain
• What is the cadence of refresh this needs?
  • preferably daily as there are still numerous inscriptions being created, but lower rates are still ok
• SQL query:

with

libreplex_txs as (

select

block_timestamp
, f_inner.value :accounts[2] ::string as non_fungible_mint

from solana.core.fact_events
inner join lateral flatten (input => inner_instruction :instructions) f_inner
where succeeded
and array_contains('inscokhJarcjaEs59QbQ7hYjrKz25LEPRfCbP8EmdUp' ::variant, instruction :accounts)
and f_inner.value :programId = 'inscokhJarcjaEs59QbQ7hYjrKz25LEPRfCbP8EmdUp'
and substr(livequery.utils.udf_base58_to_hex(f_inner.value :data), 1, 18) in (
'0x893cf85eabccc360' -- CreateInscription
, '0x148e6512785a0975' -- CreateInscriptionV2
, '0xa82b4de6f0f7a1af' -- CreateInscriptionV3
)
and fact_events.block_timestamp > '2023-11-13'
)

select

'solana' as blockchain
, 'marqu' as creator
, non_fungible_mint as address
, 'libreplex' as tag_name
, 'inscription' as tag_type
, block_timestamp as start_date
, NULL as end_date

from libreplex_txs

[k2rbpz]

Link to the flipside query: https://flipsidecrypto.xyz/marqu/q/juWMOkYOB6Xa/libreplex-inscriptions---test-query