20250313@182518.6564 vdhmfjnh63n58qvou2eo2an7br INICIO DE FICHEIRO DE LOG :: /var/www/webservices/logs/website.sql.log
20250313@182518.6562 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182518.6567 vdhmfjnh63n58qvou2eo2an7br Query : select st.stns valor from st where st.ref = '324.1538.00.1'
20250313@182518.6588 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182518.6591 vdhmfjnh63n58qvou2eo2an7br Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.1538.00.1' and sa.armazem = 133 
20250313@182518.6669 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182518.6673 vdhmfjnh63n58qvou2eo2an7br Query : select st.stns valor from st where st.ref = '324.1538.00.1'
20250313@182518.6701 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1538.00.1'
20250313@182518.6875 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182518.6900 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@182518.6917 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182518.6937 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@182518.6949 vdhmfjnh63n58qvou2eo2an7br Query : select sestamp valor from se where ref ='324.1538.00.1' and lote = 'r2401467300a'
20250313@182518.6966 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250313@182518.6979 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182518.6994 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@182518.7006 vdhmfjnh63n58qvou2eo2an7br Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut67d321000867d3230eaa','aut67d329744867d3230e22',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut67d329744867d3230e22'
20250313@182518.7220 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182518.7243 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@182518.7260 vdhmfjnh63n58qvou2eo2an7br Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut67d321000867d3230eaa',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 6.000, 6.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,50000 ,129.99,129.99*200.48,129.99,129.99*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,129.99*6.000,129.99*6.000*200.48 ,25.662000,25.662000*200.48 ,25.662000,25.662000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,129.99,129.99*200.48,129.99*6.000,129.99*6.000*200.48,'pll25031361893,841000004 ',129.99,129.99*6.000,129.99,129.99*6.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut67d329744867d3230e22'
20250313@182518.7619 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182518.7624 vdhmfjnh63n58qvou2eo2an7br Query : select st.usalote valor from st where st.ref = '324.1537.00.1'
20250313@182518.7653 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182518.7656 vdhmfjnh63n58qvou2eo2an7br Query : select st.stns valor from st where st.ref = '324.1537.00.1'
20250313@182518.7674 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182518.7677 vdhmfjnh63n58qvou2eo2an7br Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.1537.00.1' and sa.armazem = 133 
20250313@182518.7766 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182518.7769 vdhmfjnh63n58qvou2eo2an7br Query : select st.stns valor from st where st.ref = '324.1537.00.1'
20250313@182518.7788 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.1537.00.1'
20250313@182518.7963 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182518.7993 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@182518.8012 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182518.8035 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@182518.8047 vdhmfjnh63n58qvou2eo2an7br Query : select sestamp valor from se where ref ='324.1537.00.1' and lote = 'r2401467200a'
20250313@182518.8063 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250313@182518.8076 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182518.8094 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@182518.8107 vdhmfjnh63n58qvou2eo2an7br Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut67d323512867d3230ec5','aut67d329744867d3230e22',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut67d329744867d3230e22'
20250313@182518.8360 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182518.8385 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@182518.8406 vdhmfjnh63n58qvou2eo2an7br Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut67d323512867d3230ec5',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 4.000, 4.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,60000 ,119.99,119.99*200.48,119.99,119.99*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,119.99*4.000,119.99*4.000*200.48 ,23.049000,23.049000*200.48 ,23.049000,23.049000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,119.99,119.99*200.48,119.99*4.000,119.99*4.000*200.48,'pll25031361913,139000005 ',119.99,119.99*4.000,119.99,119.99*4.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut67d329744867d3230e22'
20250313@182518.8770 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182518.8816 vdhmfjnh63n58qvou2eo2an7br Query : select st.usalote valor from st where st.ref = '324.966.00.01'
20250313@182518.8955 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182518.8959 vdhmfjnh63n58qvou2eo2an7br Query : select st.stns valor from st where st.ref = '324.966.00.01'
20250313@182518.8978 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182518.8981 vdhmfjnh63n58qvou2eo2an7br Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.966.00.01' and sa.armazem = 133 
20250313@182518.9010 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182518.9013 vdhmfjnh63n58qvou2eo2an7br Query : select st.stns valor from st where st.ref = '324.966.00.01'
20250313@182518.9035 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.966.00.01'
20250313@182518.9056 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182518.9075 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@182518.9088 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182518.9107 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@182518.9118 vdhmfjnh63n58qvou2eo2an7br Query : select sestamp valor from se where ref ='324.966.00.01' and lote = 'r2401239200a'
20250313@182518.9134 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250313@182518.9150 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182518.9167 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@182518.9410 vdhmfjnh63n58qvou2eo2an7br Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut67d326687567d3230edf','aut67d329744867d3230e22',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut67d329744867d3230e22'
20250313@182518.9668 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182518.9691 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@182518.9715 vdhmfjnh63n58qvou2eo2an7br Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut67d326687567d3230edf',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 16.000, 16.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,70000 ,39.99,39.99*200.48,39.99,39.99*200.48 ,0,0,'un',' ' ,bo.marcada,1 ,39.99*16.000,39.99*16.000*200.48 ,11.329000,11.329000*200.48 ,11.329000,11.329000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,39.99,39.99*200.48,39.99*16.000,39.99*16.000*200.48,'pll25031361956,108000006 ',39.99,39.99*16.000,39.99,39.99*16.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut67d329744867d3230e22'
20250313@182519.9200 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182519.9800 vdhmfjnh63n58qvou2eo2an7br Query : select st.usalote valor from st where st.ref = '324.4911.00.1'
20250313@182519.1160 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182519.1190 vdhmfjnh63n58qvou2eo2an7br Query : select st.stns valor from st where st.ref = '324.4911.00.1'
20250313@182519.1380 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182519.1420 vdhmfjnh63n58qvou2eo2an7br Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.4911.00.1' and sa.armazem = 133 
20250313@182519.2710 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182519.2740 vdhmfjnh63n58qvou2eo2an7br Query : select st.stns valor from st where st.ref = '324.4911.00.1'
20250313@182519.2960 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.4911.00.1'
20250313@182519.4690 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182519.4890 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@182519.5050 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182519.5230 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@182519.5320 vdhmfjnh63n58qvou2eo2an7br Query : select sestamp valor from se where ref ='324.4911.00.1' and lote = 'r2401119200a'
20250313@182519.5610 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250313@182519.5740 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182519.5940 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@182519.6310 vdhmfjnh63n58qvou2eo2an7br Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut67d324200067d3230f0e','aut67d329744867d3230e22',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut67d329744867d3230e22'
20250313@182519.1499 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182519.2241 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@182519.2317 vdhmfjnh63n58qvou2eo2an7br Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut67d324200067d3230f0e',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 6.000, 6.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,80000 ,22.99,22.99*200.48,22.99,22.99*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,22.99*6.000,22.99*6.000*200.48 ,6.424000,6.424000*200.48 ,6.424000,6.424000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,22.99,22.99*200.48,22.99*6.000,22.99*6.000*200.48,'pll25031362180,135000007 ',22.99,22.99*6.000,22.99,22.99*6.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut67d329744867d3230e22'
20250313@182519.2684 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182519.2689 vdhmfjnh63n58qvou2eo2an7br Query : select st.usalote valor from st where st.ref = '324.2237.00.1'
20250313@182519.2705 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182519.2708 vdhmfjnh63n58qvou2eo2an7br Query : select st.stns valor from st where st.ref = '324.2237.00.1'
20250313@182519.2725 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182519.2728 vdhmfjnh63n58qvou2eo2an7br Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.2237.00.1' and sa.armazem = 133 
20250313@182519.3019 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182519.3023 vdhmfjnh63n58qvou2eo2an7br Query : select st.stns valor from st where st.ref = '324.2237.00.1'
20250313@182519.3095 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2237.00.1'
20250313@182519.3417 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182519.3437 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@182519.3627 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182519.3647 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@182519.3656 vdhmfjnh63n58qvou2eo2an7br Query : select sestamp valor from se where ref ='324.2237.00.1' and lote = 'r2401385200a'
20250313@182519.3679 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250313@182519.3691 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182519.3706 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@182519.3722 vdhmfjnh63n58qvou2eo2an7br Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut67d329088867d3230f5a','aut67d329744867d3230e22',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut67d329744867d3230e22'
20250313@182519.3897 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182519.3918 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@182519.3936 vdhmfjnh63n58qvou2eo2an7br Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut67d329088867d3230f5a',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 4.000, 4.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,90000 ,59.99,59.99*200.48,59.99,59.99*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,59.99*4.000,59.99*4.000*200.48 ,14.123000,14.123000*200.48 ,14.123000,14.123000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,59.99,59.99*200.48,59.99*4.000,59.99*4.000*200.48,'pll25031362205,558000008 ',59.99,59.99*4.000,59.99,59.99*4.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut67d329744867d3230e22'
20250313@182519.4251 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182519.4256 vdhmfjnh63n58qvou2eo2an7br Query : select st.usalote valor from st where st.ref = '324.2237.00.1'
20250313@182519.4272 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182519.4274 vdhmfjnh63n58qvou2eo2an7br Query : select st.stns valor from st where st.ref = '324.2237.00.1'
20250313@182519.4291 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182519.4295 vdhmfjnh63n58qvou2eo2an7br Query : select isnull(sum(stock) ,0)stock ,isnull(sum(qttrec),0) qttrec ,0 qttcat ,isnull(sum(rescli),0) rescli ,isnull(sum(resfor),0) resfor from sa where sa.ref = '324.2237.00.1' and sa.armazem = 133 
20250313@182519.4320 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182519.4323 vdhmfjnh63n58qvou2eo2an7br Query : select st.stns valor from st where st.ref = '324.2237.00.1'
20250313@182519.4347 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 st.tabiva ,st.ivaincl ,st.stns ,st.uni2 ,st.familia ,isnull(tx.taxa, 0) txiva ,unidade ,usalote ,epcpond ,noserie ,conversao ,st.texteis from st left join taxasiva tx on st.tabiva = tx.codigo where st.ref = '324.2237.00.1'
20250313@182519.4368 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182519.4387 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@182519.4402 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182519.4418 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,mandatory from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@182519.4427 vdhmfjnh63n58qvou2eo2an7br Query : select sestamp valor from se where ref ='324.2237.00.1' and lote = 'r2401385200a'
20250313@182519.4440 vdhmfjnh63n58qvou2eo2an7br Query : select top 1 convert(numeric(6,2),t.taxa) valor from taxasiva t where t.codigo='2'
20250313@182519.4456 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182519.4472 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi2' and documentnumber = 5
20250313@182519.4484 vdhmfjnh63n58qvou2eo2an7br Query : insert into wsbi2data (bi2stamp,bostamp,morada, local,codpost ,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis) select 'aut67d323730667d3230f6c','aut67d329744867d3230e22',bo.morada, bo.local,bo.codpost ,getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut' from wsbodata bo where bo.bostamp = 'aut67d329744867d3230e22'
20250313@182519.4677 vdhmfjnh63n58qvou2eo2an7br Query : select 1 valor from information_schema.tables where table_type='base table' and table_name='wstablefields'
20250313@182519.4699 vdhmfjnh63n58qvou2eo2an7br Query : select fieldkey,fieldname,fieldtype,calcformula from wstablefields where tablename = 'bi' and documentnumber = 5
20250313@182519.4718 vdhmfjnh63n58qvou2eo2an7br Query : insert into wsbidata (bistamp,ousrdata, ousrhora, usrdata,usrhora,ousrinis,usrinis ,obrano, qtt,uni2qtt ,no, estab,nmdos ,ndos, obranome,fechada, dataobra ,rdata ,dataopen, datafecho,local, morada ,codpost, nome,bostamp,lordem ,edebito,debito, epu,pu ,ivaincl,stns,unidade, unidad2 ,marcada,usalote ,ettdeb,ttdeb,epcusto, pcusto ,ecustoind,custoind ,vendedor,vendnm, ccusto,ncusto ,noserie,tabiva,iva ,ref,design,familia,desconto,desc2,desc3,desc4,eslvu,slvu,esltt,sltt,oobistamp,vumoeda,ttmoeda,slvumoeda,slttmoeda,lote,armazem,ar2mazem,obistamp ,stipo) select 'aut67d323730667d3230f6c',getdate(),convert(char(8),convert (time,getdate())),getdate(),convert(char(8),convert (time,getdate())),'aut','aut',bo.obrano, 2.000, 2.000*.0000000 ,bo.no, bo.estab,bo.nmdos ,bo.ndos, bo.obranome,bo.fechada, bo.dataobra ,bo.dataobra ,bo.dataopen,bo.datafecho,bo.local, bo.morada ,bo.codpost, bo.nome,bo.bostamp,100000 ,59.99,59.99*200.48,59.99,59.99*200.48 ,0,0,'un ',' ' ,bo.marcada,1 ,59.99*2.000,59.99*2.000*200.48 ,14.123000,14.123000*200.48 ,14.123000,14.123000*200.48 ,bo.vendedor,bo.vendnm,bo.ccusto,bo.ncusto ,0,2,23.00,?,?,?,0,0,0,0,59.99,59.99*200.48,59.99*2.000,59.99*2.000*200.48,'pll25031362205,558000008 ',59.99,59.99*2.000,59.99,59.99*2.000,?,?,?,?,4 from wsbodata bo where bo.bostamp = 'aut67d329744867d3230e22'
20250313@182519.5084 vdhmfjnh63n58qvou2eo2an7br Query : insert into wsbocreationlog (initialstamp,externalid,creationstatus,documenttypeid,idustamp,transactionid) values ('aut67d329744867d3230e22','','wait',5,'adm12071144683,938000003','')
20250313@182519.5171 vdhmfjnh63n58qvou2eo2an7br Query : use flama_phc
20250313@182519.5175 vdhmfjnh63n58qvou2eo2an7br Query : update u_wsusers set rqsttoken =? where userid ='userls001'
20250313@182519.5227 vdhmfjnh63n58qvou2eo2an7br Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5917';
20250313@182519.5284 vdhmfjnh63n58qvou2eo2an7br Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5917';

20250313@184025.4481 3gikvopl6ot17bdo5k4m9hc3i4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5918';
20250313@184025.4555 3gikvopl6ot17bdo5k4m9hc3i4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5918';
20250313@184025.4667 3gikvopl6ot17bdo5k4m9hc3i4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5918';
20250313@184025.4807 3gikvopl6ot17bdo5k4m9hc3i4 Query : use flama_phc
20250313@184025.4867 3gikvopl6ot17bdo5k4m9hc3i4 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250313@184025.4936 3gikvopl6ot17bdo5k4m9hc3i4 Query : use flama_phc
20250313@184025.4939 3gikvopl6ot17bdo5k4m9hc3i4 Query : select no, estab,szadrsdesc from szadrs where u_coddest=2459
20250313@184025.5035 3gikvopl6ot17bdo5k4m9hc3i4 Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2017 and bo.obrano = 2501731 
20250313@184025.5420 3gikvopl6ot17bdo5k4m9hc3i4 Query : use flama_phc
20250313@184025.5424 3gikvopl6ot17bdo5k4m9hc3i4 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250313@184025.5454 3gikvopl6ot17bdo5k4m9hc3i4 Query : use flama_phc
20250313@184025.5457 3gikvopl6ot17bdo5k4m9hc3i4 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250313@184025.5487 3gikvopl6ot17bdo5k4m9hc3i4 Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250313@184025.5510 3gikvopl6ot17bdo5k4m9hc3i4 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5918';
20250313@184025.5558 3gikvopl6ot17bdo5k4m9hc3i4 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5918';
20250313@184025.6080 t8nn782qg6kulkk47mopnfaj9n Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250313@184025.6090 t8nn782qg6kulkk47mopnfaj9n Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250313@184025.6169 t8nn782qg6kulkk47mopnfaj9n Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5919';
20250313@184025.6241 t8nn782qg6kulkk47mopnfaj9n Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5919';
20250313@184025.6311 t8nn782qg6kulkk47mopnfaj9n Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5919';
20250313@184025.6355 t8nn782qg6kulkk47mopnfaj9n Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5919';
20250313@184025.6435 t8nn782qg6kulkk47mopnfaj9n Query : use flama_phc
20250313@184025.6438 t8nn782qg6kulkk47mopnfaj9n Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250313@184025.6502 t8nn782qg6kulkk47mopnfaj9n Query : use flama_phc
20250313@184025.6504 t8nn782qg6kulkk47mopnfaj9n Query : select no, estab,szadrsdesc from szadrs where u_coddest=1453
20250313@184025.6588 t8nn782qg6kulkk47mopnfaj9n Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2017 and bo.obrano = 2501732 
20250313@184025.7280 t8nn782qg6kulkk47mopnfaj9n Query : use flama_phc
20250313@184025.7284 t8nn782qg6kulkk47mopnfaj9n Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250313@184025.7314 t8nn782qg6kulkk47mopnfaj9n Query : use flama_phc
20250313@184025.7316 t8nn782qg6kulkk47mopnfaj9n Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250313@184025.7339 t8nn782qg6kulkk47mopnfaj9n Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250313@184025.7370 t8nn782qg6kulkk47mopnfaj9n Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5919';
20250313@184025.7416 t8nn782qg6kulkk47mopnfaj9n Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5919';
20250313@184025.8350 71cf2419ecms73fboij1cn8cg1 Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250313@184025.8436 71cf2419ecms73fboij1cn8cg1 Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250313@184025.8534 71cf2419ecms73fboij1cn8cg1 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5920';
20250313@184025.9769 71cf2419ecms73fboij1cn8cg1 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5920';
20250313@184025.9854 71cf2419ecms73fboij1cn8cg1 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5920';
20250313@184025.9897 71cf2419ecms73fboij1cn8cg1 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5920';
20250313@184025.9970 71cf2419ecms73fboij1cn8cg1 Query : use flama_phc
20250313@184025.9973 71cf2419ecms73fboij1cn8cg1 Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250313@184026.5800 71cf2419ecms73fboij1cn8cg1 Query : use flama_phc
20250313@184026.6100 71cf2419ecms73fboij1cn8cg1 Query : select no, estab,szadrsdesc from szadrs where u_coddest=5338
20250313@184026.1480 71cf2419ecms73fboij1cn8cg1 Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2017 and bo.obrano = 2501734 
20250313@184026.5370 71cf2419ecms73fboij1cn8cg1 Query : use flama_phc
20250313@184026.5400 71cf2419ecms73fboij1cn8cg1 Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250313@184026.5690 71cf2419ecms73fboij1cn8cg1 Query : use flama_phc
20250313@184026.5720 71cf2419ecms73fboij1cn8cg1 Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250313@184026.5870 71cf2419ecms73fboij1cn8cg1 Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250313@184026.6110 71cf2419ecms73fboij1cn8cg1 Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5920';
20250313@184026.6670 71cf2419ecms73fboij1cn8cg1 Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5920';
20250313@184026.1210 bm12q37k6jm0sjbqhd84n9s76a Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250313@184026.1222 bm12q37k6jm0sjbqhd84n9s76a Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250313@184026.1298 bm12q37k6jm0sjbqhd84n9s76a Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5921';
20250313@184026.1368 bm12q37k6jm0sjbqhd84n9s76a Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5921';
20250313@184026.1458 bm12q37k6jm0sjbqhd84n9s76a Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5921';
20250313@184026.1495 bm12q37k6jm0sjbqhd84n9s76a Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5921';
20250313@184026.1566 bm12q37k6jm0sjbqhd84n9s76a Query : use flama_phc
20250313@184026.1569 bm12q37k6jm0sjbqhd84n9s76a Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250313@184026.1654 bm12q37k6jm0sjbqhd84n9s76a Query : use flama_phc
20250313@184026.1657 bm12q37k6jm0sjbqhd84n9s76a Query : select no, estab,szadrsdesc from szadrs where u_coddest=4197
20250313@184026.1706 bm12q37k6jm0sjbqhd84n9s76a Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2017 and bo.obrano = 2501736 
20250313@184026.2084 bm12q37k6jm0sjbqhd84n9s76a Query : use flama_phc
20250313@184026.2087 bm12q37k6jm0sjbqhd84n9s76a Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250313@184026.2120 bm12q37k6jm0sjbqhd84n9s76a Query : use flama_phc
20250313@184026.2123 bm12q37k6jm0sjbqhd84n9s76a Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250313@184026.2139 bm12q37k6jm0sjbqhd84n9s76a Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250313@184026.2172 bm12q37k6jm0sjbqhd84n9s76a Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5921';
20250313@184026.2220 bm12q37k6jm0sjbqhd84n9s76a Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5921';
20250313@184026.2856 jqjjs627mubtd946gic5cv1q0s Query : insert into uploadfiles ( name_original, name_new, option_type, relative_path, whencreated ) values ( ?, ?, ?, ?, getdate() )
20250313@184026.2868 jqjjs627mubtd946gic5cv1q0s Query : select uploadfile_id valor from uploadfiles where name_new = ? and option_type = ? 
20250313@184026.2944 jqjjs627mubtd946gic5cv1q0s Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5922';
20250313@184026.3016 jqjjs627mubtd946gic5cv1q0s Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5922';
20250313@184026.3087 jqjjs627mubtd946gic5cv1q0s Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5922';
20250313@184026.3124 jqjjs627mubtd946gic5cv1q0s Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5922';
20250313@184026.3205 jqjjs627mubtd946gic5cv1q0s Query : use flama_phc
20250313@184026.3208 jqjjs627mubtd946gic5cv1q0s Query : select top 1 secretkey valor from u_wsusers u where u.userid = ? and u.inactivo=0
20250313@184026.3274 jqjjs627mubtd946gic5cv1q0s Query : use flama_phc
20250313@184026.3277 jqjjs627mubtd946gic5cv1q0s Query : select no, estab,szadrsdesc from szadrs where u_coddest=557
20250313@184026.3360 jqjjs627mubtd946gic5cv1q0s Query : select bi.bistamp ,bi.ref code ,bi.qtt quantity ,bi.edebito ,bi.desconto ,bi.desc2 ,bi.desc3 ,bi.desc4 ,bi.bostamp ,st.u_uncxcl from bi inner join bo on bo.bostamp=bi.bostamp inner join st on st.ref = bi.ref where bo.ndos = 250 and bo.boano = 2017 and bo.obrano = 2501737 
20250313@184026.3735 jqjjs627mubtd946gic5cv1q0s Query : use flama_phc
20250313@184026.3739 jqjjs627mubtd946gic5cv1q0s Query : select szadrsstamp valor from szadrs where szadrsdesc='espaÇotrans,lda'
20250313@184026.3771 jqjjs627mubtd946gic5cv1q0s Query : use flama_phc
20250313@184026.3775 jqjjs627mubtd946gic5cv1q0s Query : select top 1 errorresult result ,errornumber errornumber ,descriptionpt description ,isnull(descriptionen,'') descriptionen ,isnull(descriptionfr,'') descriptionfr from wserrorcodes where errornumber = -9010
20250313@184026.3796 jqjjs627mubtd946gic5cv1q0s Query : insert into wserrorlog (errornumber, errormsg,requesttable,initialdata,finaldata) values (-9010,?,'ft',?,?)
20250313@184026.3822 jqjjs627mubtd946gic5cv1q0s Query : select concat(rtrim(relative_path),ltrim(name_new)) as valor from uploadfiles where uploadfile_id='5922';
20250313@184026.3868 jqjjs627mubtd946gic5cv1q0s Query : update uploadfiles set whenupdated=current_timestamp where uploadfile_id='5922';
