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
with
libreplex_txs as (
select
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