select t1.fclass1,t1.fclass2,t1.ftitle,t1.submitby,t1.submitdate,t1.fnotes,t1.fstatus,t1.tarchives_adid,t1.createby,t1.createdate,
       t1.fsalercanread,t1.fagentcanread,t1.fagentsalercanread
from tarchives_ad t1
where  t1.siteid=$siteid$ and $where$