select t2.tenterprise_userid, t2.fname, t2.fphonenumber
from tarchives_sc t1
         inner join tenterprise_users t2 on t1.siteid = t2.siteid and t2.fphonenumber is not null
    and t1.fsalercanread = 1 and t2.fusertype = 'ÆóÒµ'
         left join tarchives_sc_userdata t4
                   on t1.tarchives_scid = t4.tarchives_scid and t2.tenterprise_userid = t4.tenterprise_userid
where t1.siteid = $siteid$ and t1.tarchives_scid=$tarchives_scid$ and t4.tarchives_sc_useid is null and t2.tenterprise_userid in $tenterprise_userid$