FROM ethereum.core.ez_nft_sales

WHERE NFT_ADDRESS = '0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb' AND EVENT_TYPE= 'sale'

AND BUYER_ADDRESS != '0x0000000000000000000000000000000000000000' AND PRICE_USD !=0 AND BLOCK_TIMESTAMP::DATE > '2020-05-04' AND TX_HASH != '0x92488a00dfa0746c300c66a716e6cc11ba9c0f9d40d8c58e792cc7fcebf432d0'),

WRAPPED_CRYPTOPUNKS AS (

SELECT *, CONCAT('CryptoPunks ', TokenID) "NFT_NAME" FROM ethereum.core.ez_nft_sales

WHERE NFT_ADDRESS = LOWER('0xb7F7F6C52F2e2fdb1963Eab30438024864c313F6') AND SELLER_ADDRESS != '0x0000000000000000000000000000000000000000'

AND BUYER_ADDRESS != '0x0000000000000000000000000000000000000000' AND PRICE_USD != 0),

ALL_CRYPTOPUNKS_SALES AS (SELECT *,

IFF(BUYER_ADDRESS IN ('0x0232d1083e970f0c78f56202b9a666b526fa379f', '0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685','0x6639c089adfba8bb9968da643c6be208a70d6daa'), 'punksOTC', BUYER_ADDRESS ) AS UPDATED_BUYER_ADDRESS,

IFF(SELLER_ADDRESS IN ('0x0232d1083e970f0c78f56202b9a666b526fa379f', '0x1919db36ca2fa2e15f9000fd9cdc2edcf863e685','0x6639c089adfba8bb9968da643c6be208a70d6daa'), 'punksOTC', SELLER_ADDRESS ) AS UPDATED_SELLER_ADDRESS

FROM kk