WHEN '0x8942595a2dc5181df0465af0d7be08c8f23c93af' THEN 'V0.1.0'

WHEN '0xb6029ea3b2c51d09a50b53ca8012feeb05bda35a' THEN 'V1.0.0'

WHEN '0xae32496491b53841efb51829d6f886387708f99b' THEN 'V1.1.0'

WHEN '0x34cfac646f301356faa8b21e94227e3583fe3f5f' THEN 'V1.1.1'

WHEN '0x6851d6fdfafd08c0295c392436245e5bc78b0185' THEN 'V1.2.0'

WHEN '0xd9db270c1b5e3bd161e8c8503c55ceabee709552' THEN 'V1.3.0'

WHEN '0x3e5c63644e683549055b9be8653de26e0b4cd36e' THEN 'V1.3.0L2'

END AS METHOD_VERSION, COUNT(DISTINCT(FROM_ADDRESS)) AS TOTAL_SAFE FROM ethereum.core.fact_traces

WHERE

(

(

TO_ADDRESS = '0xb6029ea3b2c51d09a50b53ca8012feeb05bda35a'

AND SUBSTR(input, 1, 10) = '0xa97ab18a'

) OR

(

(

TO_ADDRESS = '0xae32496491b53841efb51829d6f886387708f99b' OR

TO_ADDRESS = '0x34cfac646f301356faa8b21e94227e3583fe3f5f' OR

TO_ADDRESS = '0xd9db270c1b5e3bd161e8c8503c55ceabee709552' OR

TO_ADDRESS = '0x6851d6fdfafd08c0295c392436245e5bc78b0185'

)

AND SUBSTR(input, 1, 10) = '0xb63e800d'

) OR

(

TO_ADDRESS = '0x8942595a2dc5181df0465af0d7be08c8f23c93af'

AND SUBSTR(input, 1, 10) = '0x0ec78d9e'

)

)

AND TYPE = 'DELEGATECALL'

AND TX_STATUS = 'SUCCESS'

GROUP BY METHOD_VERSION

ORDER BY TOTAL_SAFE DESC