SELECT '001','og_mm_main','0x3a9368553435a3b88ea4a3d78877d9e5863b36ac' UNION ALL

SELECT '002','og_mm_mf','0xfe324b97d0dd56dccc337b40c890c69ef2c2a4e1' UNION ALL

SELECT '003','og_mm_binance','0xaec473930200fb2fbd593865ef0795148286c7a9' UNION ALL

SELECT '004','og_mm_fief','0x0041c020a2b50dd31ab112a3530328d3de686bdf' UNION ALL

SELECT '005','og_mm_yeti','0x1d8110d70601f04746fe01a96707aaeb3d938873' UNION ALL

SELECT '006','og_mm_tgburn1','0x996133d4dd4a043e09b4b432bfd8f3d13f888eff' UNION ALL

SELECT '007','new_mm_account1','0xa3dfd249d53d49f04dc3e844471129accbcd87f1' UNION ALL

SELECT '008','new_mm_clean','0x8c4abc9235384d462a3b145a3a099b8affd86ed9' UNION ALL

SELECT '009','core_tgmain','0x7974fb1cb6ec5e2913a23878fc9e31c5b6790543' UNION ALL

SELECT '010','core_taxes','0xa2c1656679a55f527524e3beccab45c80f32ac93' UNION ALL

SELECT '011','core_tgtrading','0xb850fa8b0c4bf92b210c991c065cb2fd0309fff2' UNION ALL

SELECT '012','core_personalmain','0xe92604451c24840ce13b5c4962a1a5cd8a86e7e0' UNION ALL

SELECT '013','core_tgnfts','0x7e0bc5644d55bbd648f3b10811d81b570d3cb1ec' UNION ALL

SELECT '014','core_tgnftburn','0xfc617cd0cd5c9eca9c30416bea70326d1a48b4bc' UNION ALL

SELECT '015','core_account7','0x72a004a46648c65755ef14957c1913c140c08a31' UNION ALL

SELECT '016','core_personalnft','0x6f3c1a15eaf20f5f31ca5604e404011d73a82905' UNION ALL

SELECT '017','core_personalarbitrum','0x8cebc4b7814c013ea0bcc2ac473bd75df3cdb626' UNION ALL

SELECT '018','core_mfnfts','0x44c0eda75cd8a0d01e072c222b8bb000918937ea' UNION ALL

SELECT '019','icarium_mm_personalarbitrum','0x6779e3cf2a8ff9437f16317b86e3861570a3be2a' UNION ALL

SELECT '020','icarium_mm_main','0x91e040f7ed5f7adb2eb4bccd6e01a143601972c1' UNION ALL

SELECT '021','icarium_mm_degen','0xf687bb09362bf7c1e7e19e245cbb477e43e16d74' UNION ALL

SELECT '022','new_mm_mfhyperspace','0x25dc9105d9fb686d7a4e65a8e80692519653efe1' UNION ALL

SELECT '023','icarium_mm_personalderivs','0x9714abd86b0b7b4ec53d189e1d69421ed4c10f43'

),

arb_transactions as (

SELECT *, 'arbitrum' as network

FROM arbitrum.core.ez_decoded_event_logs

WHERE origin_from_address IN (SELECT DISTINCT address FROM wallets)

ORDER BY block_number,event_index

),

avax_transactions as (

SELECT *, 'avalanche' as network

FROM avalanche.core.ez_decoded_event_logs