from ethereum.core.ez_decoded_event_logs

where CONTRACT_ADDRESS = '0x47cbe25bbdb40a774cc37e1da92d10c2c7ec897f'

and CONTRACT_NAME = 'Matic Validator'

and ORIGIN_FUNCTION_SIGNATURE = '0x6a761202'

and ORIGIN_TO_ADDRESS = '0xfa7d2a996ac6350f4b56c043112da0366a59b74c') ,

txs1 as (select TX_HASH,DECODED_LOG:tokenId as tokenId

from ethereum.core.ez_decoded_event_logs

where CONTRACT_ADDRESS = '0x47cbe25bbdb40a774cc37e1da92d10c2c7ec897f'

and CONTRACT_NAME = 'Matic Validator'

and ORIGIN_FUNCTION_SIGNATURE = '0x4fdd20f1'

and ORIGIN_TO_ADDRESS = '0x5e3ef299fddf15eaa0432e6e66473ace8c13d908')

SELECT '0x4c92d14186482f54c2bc452d40236bbedb35982f2819d6bbd30e381be7dfa2b0'as TX_HASH, '0x20cf1d8870dd7306aa5ca13aafa86b5f09a476c1'as CONTRACT_ADDRESS, '145' as tokenId

UNION

SELECT '0x4c92d14186482f54c2bc452d40236bbedb35982f2819d6bbd30e381be7dfa2b0'as TX_HASH, '0x6031a416a4d0fb4cdd9186494d89d8ef39b2d036'as CONTRACT_ADDRESS, '146' as tokenId

UNION

SELECT '0x4994ab40cdc4e3d4a57648c417e24b88debe19f6ab28fd07ed6781d48c0cec27'as TX_HASH, '0xfceeadc436b28b686fa376671a7739e509fae4ab'as CONTRACT_ADDRESS, '148' as tokenId

UNION

SELECT '0x4994ab40cdc4e3d4a57648c417e24b88debe19f6ab28fd07ed6781d48c0cec27'as TX_HASH, '0xea077b10a0ed33e4f68edb2655c18fda38f84712'as CONTRACT_ADDRESS, '149' as tokenId

UNION

SELECT '0x7e1dd8a5802cba2ebd9fbd55b6358546f88d4aab22401ac8f8d6a497d3d05892'as TX_HASH, '0xd1ca51e013ca7d84af6b8230acf91ff372635a32'as CONTRACT_ADDRESS, '160' as tokenId

UNION

SELECT '0x7e1dd8a5802cba2ebd9fbd55b6358546f88d4aab22401ac8f8d6a497d3d05892'as TX_HASH, '0x2dfae485427012edd71b8f7a5b135ada0d61a03a'as CONTRACT_ADDRESS, '161' as tokenId

UNION

SELECT '0x7e1dd8a5802cba2ebd9fbd55b6358546f88d4aab22401ac8f8d6a497d3d05892'as TX_HASH, '0x15c2b3adca66e26b6f230b4023f52a285b7f9995'as CONTRACT_ADDRESS, '162' as tokenId

UNION

SELECT '0x645e1d2c7eba9d4c573be1649935429b970c33042c0dbbf7964303fba3fe6a10'as TX_HASH, '0xcc22dd2158195cd2d5b24a89e86c1d2ebfb818a4'as CONTRACT_ADDRESS, '170' as tokenId

UNION

SELECT '0x645e1d2c7eba9d4c573be1649935429b970c33042c0dbbf7964303fba3fe6a10'as TX_HASH, '0x7bf6b861d5c119e1b2ee45b28b2dc6f7297aa5e4'as CONTRACT_ADDRESS, '171' as tokenId

union

select t.TX_HASH,CONTRACT_ADDRESS,t.tokenId

from txs2 t left join ethereum.core.ez_decoded_event_logs e on t.TX_HASH=e.TX_HASH

where EVENT_NAME = 'OwnershipTransferred'