14/09/2022 08:59:51 am >> SELECT document_num FROM ps_document WHERE document_num = '68/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-09-14') 14/09/2022 08:59:51 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '68/A' , '2022-09-14' , 'A' , '206' , '0' , '4671015' , 'VIA N. BUONSERVIZI, 25 84135 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.40' , '42.40' , NOW() , NOW() ) 14/09/2022 08:59:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61794' 14/09/2022 08:59:51 am >> DELETE FROM ps_document_detail WHERE id_document = '61794' 14/09/2022 08:59:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61794' , '19021' , 'CHI E PAOLO - G. LAJOLA' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 14/09/2022 08:59:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61794' , '19925' , 'AMEN - NOV. 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 14/09/2022 08:59:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61794' , '19926' , 'AMEN - DIC. 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 14/09/2022 08:59:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61794' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 14/09/2022 08:59:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61794' , '19928' , 'PAROLA E PREGHIERA - OTT. 2022' , '2' , '-2' , '4' , '2.90' , '2.9' , '0' , '0' , '5.80' ) 14/09/2022 08:59:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61794' , '19929' , 'PAROLA E PREGHIERA - NOV. 2022' , '2' , '-2' , '4' , '2.90' , '2.9' , '0' , '0' , '5.80' ) 14/09/2022 09:38:32 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3838' 14/09/2022 09:38:32 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3838' , '10' , '156' , 'PARR. S. CASSIANO' , 'LUCCA' , 'DON RUGGERO ' , 'VIA MONS. MENEGAZZI 3' , '' , '44022' , 'COMACCHIO' , 'ATTENZIONE INDIRIZZO E\' DELLA CANONICA, TOGLIERE PARROCCHIA DALLA SPEDIZIONE' , '' , '3395662180' , '' , '91001340388' , NOW() , NOW() ) 14/09/2022 09:38:32 am >> UPDATE ps_customer SET email = 'parrocchiadisancassiano@virgilio.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3838' 14/09/2022 09:41:37 am >> SELECT document_num FROM ps_document WHERE document_num = '2730' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-14') 14/09/2022 09:41:37 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2730' , '2022-09-14' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.80' , '10.80' , NOW() , NOW() ) 14/09/2022 09:41:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61795' 14/09/2022 09:41:37 am >> DELETE FROM ps_document_detail WHERE id_document = '61795' 14/09/2022 09:41:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61795' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '10.8' , '10.8' , '0' , '0' , '10.80' ) 14/09/2022 09:41:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 14/09/2022 09:41:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 14/09/2022 09:42:45 am >> SELECT document_num FROM ps_document WHERE document_num = '115' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-14') 14/09/2022 09:42:45 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '115' , '2022-09-14' , '' , '3838' , '0' , '4674892' , 'VIA MONS. MENEGAZZI 3 44022 COMACCHIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '69.70' , '69.70' , NOW() , NOW() ) 14/09/2022 09:42:45 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61796' 14/09/2022 09:42:45 am >> DELETE FROM ps_document_detail WHERE id_document = '61796' 14/09/2022 09:42:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61796' , '2679' , 'CONOSCERE GESU\'' , '10' , '-10' , '4' , '3.50' , '3.5' , '0' , '15' , '29.75' ) 14/09/2022 09:42:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61796' , '4154' , 'FESTA DEL PERDONO' , '12' , '-12' , '4' , '3.00' , '3' , '0' , '15' , '30.60' ) 14/09/2022 09:42:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61796' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '15' , '5.10' ) 14/09/2022 09:42:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61796' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 14/09/2022 09:55:38 am >> SELECT document_num FROM ps_document WHERE document_num = '2731' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-14') 14/09/2022 09:55:38 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2731' , '2022-09-14' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.61' , '51.17' , NOW() , NOW() ) 14/09/2022 09:55:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61797' 14/09/2022 09:55:38 am >> DELETE FROM ps_document_detail WHERE id_document = '61797' 14/09/2022 09:55:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61797' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 14/09/2022 09:55:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 14/09/2022 09:55:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 14/09/2022 09:55:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61797' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 14/09/2022 09:55:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 14/09/2022 09:55:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 14/09/2022 09:55:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61797' , '19828' , 'CHIESA SINODALE NELLOGGI' , '1' , '-1' , '4' , '15.90' , '15.9' , '0' , '5' , '15.11' ) 14/09/2022 09:55:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '19828' AND id_supplier = '' 14/09/2022 09:55:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19828' , '' , '1' ) 14/09/2022 10:16:01 am >> SELECT document_num FROM ps_document WHERE document_num = '2732' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-14') 14/09/2022 10:16:01 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2732' , '2022-09-14' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '58.00' , '53.37' , NOW() , NOW() ) 14/09/2022 10:16:01 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61798' 14/09/2022 10:16:01 am >> DELETE FROM ps_document_detail WHERE id_document = '61798' 14/09/2022 10:16:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61798' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 14/09/2022 10:16:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '19102' AND id_supplier = '' 14/09/2022 10:16:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19102' , '' , '1' ) 14/09/2022 10:16:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61798' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 14/09/2022 10:16:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 14/09/2022 10:16:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 14/09/2022 10:16:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61798' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 14/09/2022 10:16:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 14/09/2022 10:16:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 14/09/2022 10:16:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61798' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '5.70' ) 14/09/2022 10:16:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 14/09/2022 10:16:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 14/09/2022 10:16:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61798' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '4.00' ) 14/09/2022 10:16:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 14/09/2022 10:16:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 14/09/2022 10:16:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61798' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 14/09/2022 10:16:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 14/09/2022 10:16:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 14/09/2022 10:16:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61798' , '19731' , 'ITINERARI CAT. PER LA VITA MATRIMONIALE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 14/09/2022 10:16:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '19731' AND id_supplier = '' 14/09/2022 10:16:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19731' , '' , '1' ) 14/09/2022 10:16:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61798' , '19805' , 'DESIDERIO DESIDERAVI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 14/09/2022 10:16:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '19805' AND id_supplier = '' 14/09/2022 10:16:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19805' , '' , '1' ) 14/09/2022 10:16:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61798' , '6014' , 'LUMINO BIANCO - 10B' , '1' , '-1' , '1' , '0.40' , '0.32786885245902' , '22' , '0' , '0.40' ) 14/09/2022 10:16:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '6014' AND id_supplier = '' 14/09/2022 10:16:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6014' , '' , '1' ) 14/09/2022 10:27:01 am >> SELECT document_num FROM ps_document WHERE document_num = '56' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-14') 14/09/2022 10:27:02 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '56' , '2022-09-14' , '' , '3385' , '0' , '37343286' , 'VIA MONS. MENEGAZZI, 3 44022 COMACCHIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '17.10' , '17.10' , NOW() , NOW() ) 14/09/2022 10:27:02 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '5413' 14/09/2022 10:27:02 am >> DELETE FROM ps_document_detail WHERE id_document = '5413' 14/09/2022 10:27:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5413' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 14/09/2022 10:43:10 am >> SELECT document_num FROM ps_document WHERE document_num = '2733' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-14') 14/09/2022 10:43:10 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2733' , '2022-09-14' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 14/09/2022 10:43:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61799' 14/09/2022 10:43:10 am >> DELETE FROM ps_document_detail WHERE id_document = '61799' 14/09/2022 10:43:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61799' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 14/09/2022 10:43:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 14/09/2022 10:43:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 14/09/2022 10:50:56 am >> SELECT document_num FROM ps_document WHERE document_num = '2734' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-14') 14/09/2022 10:50:56 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2734' , '2022-09-14' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '113.82' , '101.74' , NOW() , NOW() ) 14/09/2022 10:50:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61800' 14/09/2022 10:50:56 am >> DELETE FROM ps_document_detail WHERE id_document = '61800' 14/09/2022 10:50:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61800' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '1' , '-1' , '1' , '7.00' , '5.7377049180328' , '22' , '0' , '7.00' ) 14/09/2022 10:50:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '1425' AND id_supplier = '' 14/09/2022 10:50:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1425' , '' , '1' ) 14/09/2022 10:50:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61800' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '60.00' , '49.180327868852' , '22' , '0' , '60.00' ) 14/09/2022 10:50:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '1626' AND id_supplier = '' 14/09/2022 10:50:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1626' , '' , '1' ) 14/09/2022 10:50:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61800' , '19695' , 'STIMMATE - L. CRIPPA' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '5' , '7.51' ) 14/09/2022 10:50:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '19695' AND id_supplier = '' 14/09/2022 10:50:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19695' , '' , '1' ) 14/09/2022 10:50:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61800' , '18423' , 'VIA DI SAN FRANCESCO - G. POLIDORO' , '1' , '-1' , '4' , '4.80' , '4.8' , '0' , '5' , '4.56' ) 14/09/2022 10:50:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '18423' AND id_supplier = '' 14/09/2022 10:50:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18423' , '' , '1' ) 14/09/2022 10:50:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61800' , '7126' , 'NOVENE A S. FRANCESCO E S. CHIARA' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 14/09/2022 10:50:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '7126' AND id_supplier = '' 14/09/2022 10:50:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7126' , '' , '1' ) 14/09/2022 10:50:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61800' , '8290' , 'PREGHIERA DEL MATTINO E DELLA SERA - PER LAICI' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 14/09/2022 10:50:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '8290' AND id_supplier = '' 14/09/2022 10:50:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8290' , '' , '1' ) 14/09/2022 10:53:13 am >> SELECT document_num FROM ps_document WHERE document_num = '2710' AND id_document != '61765' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-12') 14/09/2022 10:53:13 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2710', document_date = '2022-09-12', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '27.55', price_tax_excluded = '27.55', date_upd = NOW() WHERE id_document = '61765' 14/09/2022 10:53:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61765' 14/09/2022 10:53:13 am >> DELETE FROM ps_document_detail WHERE id_document = '61765' 14/09/2022 10:53:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61765' , '17944' , 'CAPIRE BENEDETTO XVI - S. FONTANA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 14/09/2022 10:53:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '17944' AND id_supplier = '' 14/09/2022 10:53:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17944' , '' , '1' ) 14/09/2022 10:53:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61765' , '4154' , 'FESTA DEL PERDONO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 14/09/2022 10:53:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '4154' AND id_supplier = '' 14/09/2022 10:53:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4154' , '' , '1' ) 14/09/2022 10:53:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61765' , '16174' , 'SACRAMENTI SEGNI DI DIO NEL MONDO - J. RATZINGER' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 14/09/2022 10:53:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '16174' AND id_supplier = '' 14/09/2022 10:53:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16174' , '' , '1' ) 14/09/2022 10:54:00 am >> SELECT document_num FROM ps_document WHERE document_num = '2522' AND id_document != '60004' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-12') 14/09/2022 10:54:00 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2522', document_date = '2022-08-12', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '20.00', price_tax_excluded = '20.00', date_upd = NOW() WHERE id_document = '60004' 14/09/2022 10:54:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '60004' 14/09/2022 10:54:00 am >> DELETE FROM ps_document_detail WHERE id_document = '60004' 14/09/2022 10:54:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '60004' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3.85' , '3.85' , '0' , '0' , '3.85' ) 14/09/2022 10:54:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 14/09/2022 10:54:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 14/09/2022 10:54:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '60004' , '17577' , 'UN ALTRO PAPA' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 14/09/2022 10:54:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '17577' AND id_supplier = '' 14/09/2022 10:54:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17577' , '' , '1' ) 14/09/2022 10:56:33 am >> SELECT document_num FROM ps_document WHERE document_num = '2709' AND id_document != '61764' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-12') 14/09/2022 10:56:33 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2709', document_date = '2022-09-12', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '50.00', price_tax_excluded = '40.98', date_upd = NOW() WHERE id_document = '61764' 14/09/2022 10:56:33 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61764' 14/09/2022 10:56:33 am >> DELETE FROM ps_document_detail WHERE id_document = '61764' 14/09/2022 10:56:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61764' , '7921' , 'PERGAMENE - ANNIVERSARIO MATRIM. MOD. B' , '6' , '-6' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '3.00' ) 14/09/2022 10:56:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '7921' AND id_supplier = '' 14/09/2022 10:56:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7921' , '' , '1' ) 14/09/2022 10:56:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61764' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '25' , '-25' , '1' , '1.4000' , '1.1475409836066' , '22' , '0' , '35.00' ) 14/09/2022 10:56:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '791' AND id_supplier = '' 14/09/2022 10:56:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '791' , '' , '1' ) 14/09/2022 10:56:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61764' , '19923' , 'AGENDA LITURGICO PASTORALE 2023 - 40807' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '5' , '11.40' ) 14/09/2022 10:56:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '19923' AND id_supplier = '' 14/09/2022 10:56:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19923' , '' , '1' ) 14/09/2022 10:56:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61764' , '7921' , 'PERGAMENE - ANNIVERSARIO MATRIM. MOD. B' , '1' , '-1' , '1' , '0.6' , '0.49180327868852' , '22' , '0' , '0.60' ) 14/09/2022 10:56:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '7921' AND id_supplier = '' 14/09/2022 10:56:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7921' , '' , '1' ) 14/09/2022 11:02:06 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '2751' 14/09/2022 11:02:06 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '2751' , '10' , '123' , 'PARR. B. V. ROSARIO' , 'NOCERA' , 'DON RENATO' , 'P. ZZA MATRICE' , '' , '92020' , 'CASTROFILIPPO' , 'ORDINA TESE' , '' , '3392399962' , '' , '' , NOW() , NOW() ) 14/09/2022 11:02:06 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '2751' 14/09/2022 11:02:51 am >> SELECT document_num FROM ps_document WHERE document_num = '57' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-14') 14/09/2022 11:02:51 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '57' , '2022-09-14' , '' , '2751' , '0' , '74680487' , 'P. ZZA MATRICE 92020 CASTROFILIPPO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '18.00' , NOW() , NOW() ) 14/09/2022 11:02:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '5414' 14/09/2022 11:02:51 am >> DELETE FROM ps_document_detail WHERE id_document = '5414' 14/09/2022 11:02:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5414' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 14/09/2022 11:03:11 am >> SELECT document_num FROM ps_document WHERE document_num = '57' AND id_document != '5414' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-14') 14/09/2022 11:03:11 am >> UPDATE ps_document SET id_document_type = '21', document_num = '57', document_date = '2022-09-14', document_letter = '', id_customer = '2751', id_supplier = '', id_address = '74680487', address1 = 'P. ZZA MATRICE 92020 CASTROFILIPPO', address2 = '', note = 'BONIFICO TESE', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '18.00', price_tax_excluded = '18.00', date_upd = NOW() WHERE id_document = '5414' 14/09/2022 11:03:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '5414' 14/09/2022 11:03:11 am >> DELETE FROM ps_document_detail WHERE id_document = '5414' 14/09/2022 11:03:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5414' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 14/09/2022 11:03:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '133' AND id_supplier = '' 14/09/2022 11:03:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '133' , '' , '1' ) 14/09/2022 11:49:33 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '2751' 14/09/2022 11:49:33 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '2751' , '10' , '123' , 'PARR. B. V. ROSARIO' , 'NOCERA' , 'DON RENATO' , 'VIA VITTORIO EMANUELE' , '' , '92020' , 'CASTROFILIPPO' , 'ORDINA TESE' , '' , '3392399962' , '' , '' , NOW() , NOW() ) 14/09/2022 11:49:33 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '2751' 14/09/2022 11:50:33 am >> SELECT document_num FROM ps_document WHERE document_num = '57' AND id_document != '5414' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-14') 14/09/2022 11:50:33 am >> UPDATE ps_document SET id_document_type = '21', document_num = '57', document_date = '2022-09-14', document_letter = '', id_customer = '2751', id_supplier = '0', id_address = '74680488', address1 = 'P. ZZA MATRICE 92020 CASTROFILIPPO', address2 = '', note = 'BONIFICO TESE', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '18.00', price_tax_excluded = '18.00', date_upd = NOW() WHERE id_document = '5414' 14/09/2022 11:50:33 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '5414' 14/09/2022 11:50:33 am >> DELETE FROM ps_document_detail WHERE id_document = '5414' 14/09/2022 11:50:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5414' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 14/09/2022 11:50:49 am >> DELETE FROM ps_document WHERE id_document = '5414' 14/09/2022 11:50:49 am >> DELETE FROM ps_document_detail WHERE id_document = '5414' 14/09/2022 11:51:23 am >> SELECT document_num FROM ps_document WHERE document_num = '57' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-14') 14/09/2022 11:51:23 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '57' , '2022-09-14' , '' , '2751' , '0' , '74680488' , 'VIA VITTORIO EMANUELE 92020 CASTROFILIPPO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '18.00' , '18.00' , NOW() , NOW() ) 14/09/2022 11:51:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '5415' 14/09/2022 11:51:23 am >> DELETE FROM ps_document_detail WHERE id_document = '5415' 14/09/2022 11:51:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5415' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 14/09/2022 11:52:06 am >> SELECT document_num FROM ps_document WHERE document_num = '57' AND id_document != '5415' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-14') 14/09/2022 11:52:06 am >> UPDATE ps_document SET id_document_type = '21', document_num = '57', document_date = '2022-09-14', document_letter = '', id_customer = '2751', id_supplier = '', id_address = '74680488', address1 = 'VIA VITTORIO EMANUELE 92020 CASTROFILIPPO', address2 = '', note = 'bonifico - TESE', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '18.00', price_tax_excluded = '18.00', date_upd = NOW() WHERE id_document = '5415' 14/09/2022 11:52:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '5415' 14/09/2022 11:52:06 am >> DELETE FROM ps_document_detail WHERE id_document = '5415' 14/09/2022 11:52:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5415' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 14/09/2022 11:52:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '133' AND id_supplier = '' 14/09/2022 11:52:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '133' , '' , '1' ) 14/09/2022 12:22:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '2735' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-14') 14/09/2022 12:22:54 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2735' , '2022-09-14' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.60' , '6.23' , NOW() , NOW() ) 14/09/2022 12:22:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61801' 14/09/2022 12:22:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '61801' 14/09/2022 12:22:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61801' , '11691' , 'BRACCIALE TRECCIA DECINA - 818/7' , '2' , '-2' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '7.60' ) 14/09/2022 12:22:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11691' AND id_supplier = '' 14/09/2022 12:22:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11691' , '' , '1' ) 14/09/2022 03:38:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '58' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-14') 14/09/2022 03:38:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '58' , '2022-09-14' , '' , '2397' , '0' , '4669568' , 'P.ZZA DELLA CHIESA, 1 58100 ISTIA D\\\'OMBRONE' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '196.90' , '196.90' , NOW() , NOW() ) 14/09/2022 03:38:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '5926' 14/09/2022 03:38:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '5926' 14/09/2022 03:38:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5926' , '17' , 'LA FEDE NELLO ZAINETTO' , '40' , '-40' , '4' , '5.00' , '5' , '0' , '5' , '190.00' ) 14/09/2022 06:06:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '2688' AND id_document != '61740' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-09') 14/09/2022 06:06:41 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2688', document_date = '2022-09-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '27.00', price_tax_excluded = '26.63', date_upd = NOW() WHERE id_document = '61740' 14/09/2022 06:06:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61740' 14/09/2022 06:06:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '61740' 14/09/2022 06:06:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61740' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '6.1' , '6.1' , '0' , '0' , '6.10' ) 14/09/2022 06:06:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 14/09/2022 06:06:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 14/09/2022 06:06:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61740' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '9.50' ) 14/09/2022 06:06:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 14/09/2022 06:06:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 14/09/2022 06:06:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61740' , '14733' , 'PAOLO VI IL SANTO DELLA VITA - A. DE LORENZI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 14/09/2022 06:06:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14733' AND id_supplier = '' 14/09/2022 06:06:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14733' , '' , '1' ) 14/09/2022 06:58:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '2736' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-14') 14/09/2022 06:58:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2736' , '2022-09-14' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.80' , '5.57' , NOW() , NOW() ) 14/09/2022 06:58:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61802' 14/09/2022 06:58:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '61802' 14/09/2022 06:58:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61802' , '17347' , 'MEDAGLIA SAN BENEDETTO - M244/A' , '6' , '-6' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '1.80' ) 14/09/2022 06:58:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17347' AND id_supplier = '' 14/09/2022 06:58:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17347' , '' , '1' ) 14/09/2022 06:58:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61802' , '14772' , 'BRACCIALE SAN BENEDETTO 4 COLORI - 0818/3' , '2' , '-2' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '5.00' ) 14/09/2022 06:58:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14772' AND id_supplier = '' 14/09/2022 06:58:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14772' , '' , '1' )