ft.*,

fb.EXTRA_DATA,

fb.MINER,

fb.BLOCK_HEADER_JSON,

fb.TX_COUNT

ethereum.core.fact_transactions ft

ethereum.core.fact_blocks fb

ft.BLOCK_NUMBER = fb.BLOCK_NUMBER

(ft.FROM_ADDRESS = fb.MINER)

AND (ft.POSITION < fb.TX_COUNT-1)

AND (fb.BLOCK_TIMESTAMP BETWEEN '2023-09-01' AND '2023-09-01')

-- AND (ft.TX_HASH IN ('0xea6df8d018c98a20b4e0e1c19af313aa6a75754d1c3ee9f9986de9e07bc92fbb','0xe40104e359eb154e6f747afd3febd6170235864f83deacadedb954d59a76c6d9'))

ORDER BY

ft.BLOCK_TIMESTAMP DESC;