sturdy_deposits as (

SELECT

event_inputs:onBehalfOf as user

, tx_hash as sturdy_deposit_tx_hash

, block_timestamp as sturdy_first_deposit_date

, row_number() over (partition by event_inputs:onBehalfOf order by block_number asc) as tx_order

FROM ethereum.core.fact_event_logs

WHERE

contract_address in ('0xa422ca380bd70eef876292839222159e41aaee17')

and event_name = 'Deposit'

AND tx_status = 'SUCCESS'

AND event_removed = false

AND event_inputs:onBehalfOf IN (

-- suspect addresses from https://github.com/sturdyfi/sturdy-airdrop-sybil/issues/15

'0x2481fef92f6358a410f4b42a7672f23cac514c2a',

'0xf8b9130c48bfc12a3df4a6bd2aad9511d32d83aa',

'0xd7d97a98065f1bfe284ac869cc249f76c03326ea',

'0x05699eb25a059e6db3610145e3a3f56526988847',

'0x3c9052e1e1594902b4a7a43d58321dfc097a1719',

'0xe05cdf159909179018c59cee21356246891ef692',

'0x6c14cdc6b4b935614d2aa42635ed79b4617da0f5',

'0xc9a5a7fda5f10f701e74902cade11b104fe30fbe',

'0x93ea069784ba3580805ca976455201dff1cdc53f',

'0x7a4c8e3655d665f3e25ccd6b60b1b024629b3705',

'0x46671979c6188ebc1c795f6eae5ce209005f2dee',

'0x96a85cd7e5d7a08f668054394f028290f57aceaa',

'0x0388eaf12db6b8a977525d0ee0ec8f964f8aa9db',

'0x1a62e6f3fd7574666b84efd59763e807988829f5',

'0x87cab35e044b2e692341f4c6f767e4df58f38474',

'0x9e73201903164d3b476505f3c54f86cdcd4010df',

'0x94649845604d943cf105220045054f8bb3e3ce21',

'0x90fe5af1d4c992718641bccdef1520e45e78d5c6',

'0x135af87eff1d773e3aef90a7c1c971872b75452b',