--SELECT *
--FROM ethereum.core.ez_decoded_event_logs
-- WHERE GET_PATH(DECODED_LOG, '') ilike '%0xe47d5cc33517d5b8433ff249efe094b989989acc%';
SELECT *
FROM ethereum.core.ez_decoded_event_logs,
lateral flatten (input => decoded_log)
WHERE value = '0xe47d5cc33517d5b8433ff249efe094b989989acc'
LIMIT 50