select t4.fname fsaler, t2.fname, t3.fprovince, t3.fcity, t3.fcounty, t2.fphonenumber
from tnotice_users t1
       inner join tenterprise_users t2 on t1.siteid = t2.siteid and t1.tenterprise_userid = t2.tenterprise_userid
       inner join tagents t3 on t2.siteid = t3.siteid and t2.tagentsid = t3.tagentsid
       inner join tenterprise_users t4 on t3.siteid = t4.siteid and t3.fsaleruserid = t4.tenterprise_userid
where t1.siteid = $siteid$ and t1.tnoticeid = $tnoticeid$ and t1.flastreadtime is null and t3.fsaleruserid in $tenterprise_userid$