SELECT

a.SIGNERS[0]

from eclipse.core.fact_events_inner a

join eclipse.core.fact_transactions b

on a.tx_id = b.tx_id

where

INSTRUCTION_PROGRAM_ID = 'turboe9kMc3mSR8BosPkVzoHUfn5RVNzZhkrT2hdGxN'

and EVENT_TYPE = 'createAccount'

and a.SUCCEEDED = 'TRUE'

and INNER_INDEX = 0

and LOG_MESSAGES[3] = 'Program log: Instruction: Onboard')

then 'Turbo Tap players' else 'New players' end as type,

count(DISTINCT tx_from) as addresses

from eclipse.core.fact_transfers

where MINT = 'Eth1111111111111111111111111111111111111111'

and TX_TO in ( SELECT signers[0]

from eclipse.core.fact_transactions

where LOG_MESSAGES[0] like '%STKgRMpqo41oATf18cHGFWaqVEe9gAWjLGzGZ9WpGH2%'

AND (LOG_MESSAGES[1] like '%Start%'

OR LOG_MESSAGES[1] like '%EndGame%'

OR LOG_MESSAGES[1] like '%Step%'))

and SUCCEEDED = 'TRUE'

group by all