select * from userdata where struserid in (select strcharid1 from account_char where straccountid in (select straccountid FROM tb_user where ref in (select strcharid1 from account_char where straccountid = 'sorgudegeri')))