select firstname, lastname, fspro_userid, imageid, title, Organization as companyname, con.ImgPath + '/' + con.ImgName + '_100' + con.ImgExt as imgUrl from tbl_fspro_members fsp left outer join qry_ContentLookup con on con.ContentID = fsp.ImageID where fsp.ownerid = and fsp.fsl_tablecode = and fspro_userid in () order by lastname
team not defined