select t1.tagents_productid,
       t1.siteid,
       t1.createby,
       t1.changeby,
       t1.createdate,
       t1.changedate,
       t1.tagentsid,
       t1.fprodname,
       t1.fprodnum,
       t1.fprice,
       t1.fnotes,
       t1.fisonsale,
       t1.fonsaledate,
       t1.fonsaleby,
       t1.foffsaleby,
       t1.foffsaledate
from tagents_product t1
where t1.siteid = $siteid$ and tagentsid=$tagentsid$ and tagents_productid=$tagents_productid$