select prj.prjid,prj.prjnum,prj.prjname from tbladmin_PrjDetail prj,tbladmin_ProjectLA pla,tbladmin_LaDetails la where prj.prjID=pla.prjID and la.LaId=pla.LaID and (prj.chkprjarchive=0 or prj.chkprjarchive is null) and chkPrjLive=1 and pla.IsLeadLA=1 and la.LaGovOff =7  order by prjNum