select t2.fcontact as fname, t2.fprovince, t2.fcity, t2.fcounty, t1.fscore, t3.tenterprise_userid
from DSBCRM..tactionscore t1
       inner join DSBCRM..tagents t2 on t1.siteid = t2.siteid and t1.tagentsid = t2.tagentsid
       inner join tenterprise_users t3 on t2.siteid = t3.siteid and t2.tagentsid = t3.tagentsid and t3.fisadministrator=1
where t1.siteid =$siteid$