datavortexEvents to match
Updated 2024-11-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
›
⌄
⌄
SELECT DISTINCT
tx_id,
signers[0],
event_type,
decoded_instruction,
program_id
FROM solana.core.fact_decoded_instructions
WHERE tx_id IN (
'k8jTgMognjk2AUE8pXQj2722mJDxbEJsTUw2zN8Xvm7muBRm4ahwRz1eDqAFLk1qeEMfre9nKwSNCvqxU9g5Vff',
'4nCTErTw1tgnaVj2tpQpGyC1HQFJAvPx7d27si5jTujDwCtH4Qn33ds8k3pnhJ4Gd4AKmZz5T8MV8RZRVJ9YKo7z',
'3A6c21YYUewVtKSje5YwvTPehjT3y5x5uziuacPzJ6KH5wgLYLE3nv4FtVpZZCJSKtfnqihHDGxHpc4cJx5osYvv',
'vxa5wUdCYdtb5iiCMmkDnBb7U2hVD3MWLZF7XSPCEXV9QSwtBv1GdtMe8AgajohcYjK3Ertts1bJMTs98qfeZCf',
'2i8A5s1TvRnFYq8LavS7BWAngBDuWiaUzeAiRdRCuJus7mDN94zHzyniR4PaTUJ8mzqezpBxQjeDr4v859R7F7xk',
'3MSTu6rxZVAAE8o7nCZenhtxzxi9VLzyoYRZ2XL4Fr1veBCz3XTfjpTyyaziMTMgiVyFpkmK7CoE1BRCJcxc87Ur',
'35vrtbn75G4wPZ1qtgkwNSBwuAGFghtHuphQYn1LA7S4aputLNWb1Pe4tsYwTHJBb23rqoq9csBPV7MvbQEXDpkN',
'Zu7npnbReGEmX6AiCVa5xAF6aBz4DnF79jqDJuM2hnAdGdqNRwFsFBe8znuhYC3sfAHdQYHPKy7yVdjqsRoy153',
'44MzzJ5RM7kbuHNHJkwg2L6SbfEAtVPGC2Meb4ZSMqzHhodNCCS7Tszkazw5LyXja64Si7NMdiVxa6err9tvFCtH'
);
--AND index = 2
/*
SELECT
tx_id,
event_type,
index,
inner_instruction:instructions AS instructions
FROM solana.core.fact_events
WHERE tx_id = 'A5jPezeb6CLz7LJLagwSNjwRvbibNb6RF6dHNrTrTJM1DDZ8Bbj6smPhKKvjhva85yZV3mwfQg96z3ziLNfM1r7';
*/
QueryRunArchived: QueryRun has been archived