select ownerid, fsl_tablecode
from tbl_fspro_members with (nolock)
where fspro_userid =
and ownerid =
and fsl_tablecode =
select fsp.fspro_userid, firstname, lastname, title, email, phone, fax, PhoneExt, cellphone, PrimaryOfficeID, PrimaryTerritoryID, fsp.ImageID,
con.ImgPath + con.ImgName + '_100' + con.ImgExt as imgUrl100,
con.ImgPath + con.ImgName + '_thn' + con.ImgExt as imgUrlthn,
staffmember, orgid, orgtype, OfficeAddrSame,
address1, address2, city, state, zipcode, salutation, fsp.LinkedIn, fsp.caJobFunction, fsp.comments
from tbl_fspro_members fsp with (nolock)
left outer join qry_ContentLookup con with (nolock)
on con.ContentID = fsp.ImageID
where fsp.fspro_userid =
and fsp.ownerid =
and fsp.fsl_tablecode =
select *
from qryJobFunctions
where jobFunctionId =
SELECT opr.logoid, ImgPath + ImgName + '_100' + ImgExt as LogoIconPath
FROM tbl_opr_clientoperators opr with (nolock)
INNER JOIN qry_ContentLookup img with (nolock)
ON img.ContentID = opr.logoid
WHERE opr.operatorid =
select mfrid
from tbl_bro_principals with (nolock)
where principalid =