select t1.fclass1,
       t1.fclass2,
       t1.ftitle,
       t1.submitby,
       t1.submitdate,
       t1.checkdate,
       t1.checkby,
       t1.createby,
       t1.createdate,
       t1.fnotes,
       t1.tarchivesid,
       t1.fstatus,
       t1.tagentsid,
       t1.tenterprise_userid,
       t1.fsalercanread,
       t1.fagentcanread,
       t1.fagentsalercanread
from tarchives t1
where t1.siteid =$siteid$ and tarchivesid=$tarchivesid$