with STTHALOIDO as ( select * from terra.msgs where msg_value:contract::string = 'terra1plwvxr0923thz8hzcccstvtj2qj8zxfzzren7m'

and tx_status ='SUCCEEDED' and msg_value:execute_msg::string like '%join_ido%' ),

STTHALOIDOparticipants as (

select msg_value:sender::string as Address_of_users from STTHALOIDO GROUP BY Address_of_users

select * from STTHALOIDOparticipants