select t1.fname, t1.fphonenumber, t1.fcommunity, t1.fhouseunit, t1.fhousenumber, t1.createdate,t1.fnotes,t2.fscore
from tagents_workersubmit t1
left join tagents_workerscoremx t2 on t1.siteid=t2.siteid and t1.tagentsid=t2.tagentsid and t1.tenterprise_userid=t2.tenterprise_userid
                                          and t1.tagents_workersubmitid=t2.fsourceid and t2.fsourceobject='tagents_workersubmit'
where t1.siteid =$siteid$ and t1.tagentsid=$tagentsid$ and t1.tenterprise_userid=$tenterprise_userid$
and t1.fsourceid is null