denze-e7j2NU2023-03-11 04:42 PM
Updated 2023-03-12
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
32
33
34
35
36
›
⌄
⌄
-- SELECT
-- contract_address AS nft_contract_address
-- , decoded_log:tokenId::text AS token_id
-- FROM ethereum.core.ez_decoded_event_logs
-- WHERE true
-- AND contract_address = lower('0xc143bbfcDBdBEd6d454803804752a064A622C1F3')
-- AND event_name = 'BlueprintMinted'
-- AND EXISTS (
-- SELECT 1 FROM input_artist a
-- WHERE true
-- AND decoded_log:artist::text = a.artist_wallet
-- )
-- AND tx_status = 'SUCCESS'
-- limit 100
/*
SELECT
contract_address AS nft_contract_address
, tokenId AS token_id
from async_ethereum.BlueprintV11_evt_BlueprintMinted bm
WHERE true
*/
SELECT
contract_address AS nft_contract_address
, 'MakersPlace' AS name
, decoded_log:_tokenId::text AS token_id
, decoded_log:_from::text AS from_address
, decoded_log:_to::text AS to_address
, 1 AS amount
, 'false' AS is_erc1155
, ROW_NUMBER() OVER (PARTITION BY contract_address, decoded_log:tokenId::number ORDER BY block_number ASC, event_index ASC) AS rank_asc
, ROW_NUMBER() OVER (PARTITION BY contract_address, decoded_log:tokenId::number ORDER BY block_number DESC, event_index DESC) AS rank_desc
, *
FROM ethereum.core.ez_decoded_event_logs
Run a query to Download Data