07/10/2022 09:20:31 am >> UPDATE ps_document SET id_document_type = '31', document_num = '1269/09/2022', document_date = '2022-09-29', document_letter = '09', id_customer = '0', id_supplier = '', id_address = '4669610', address1 = 'RYNEK WIELUNSKI, 27 42202 CZESTOCHOWA', address2 = '', note = 'DA CAMBIARE', price_shipping = '30.50', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '625.42', price_tax_excluded = '512.64', date_upd = NOW() WHERE id_document = '65174' 07/10/2022 09:20:31 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 = '65174' 07/10/2022 09:20:31 am >> DELETE FROM ps_document_detail WHERE id_document = '65174' 07/10/2022 09:20:31 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 ( '65174' , '20064' , 'CATENINA IN ACCIAIO - NS053' , '12' , '12' , '1' , '1.8300' , '1.5' , '22' , '0' , '26.79' ) 07/10/2022 09:20:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '20064' AND id_supplier = '' 07/10/2022 09:20:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20064' , '' , '1' ) 07/10/2022 09:20:31 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 ( '65174' , '20066' , 'CATENINA IN ACCIAIO - NS055' , '12' , '12' , '1' , '1.2600' , '1.0327868852459' , '22' , '0' , '18.45' ) 07/10/2022 09:20:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '20066' AND id_supplier = '' 07/10/2022 09:20:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20066' , '' , '1' ) 07/10/2022 09:20:31 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 ( '65174' , '20065' , 'CATENINA IN ACCIAIO - NS054' , '12' , '12' , '1' , '1.5900' , '1.3032786885246' , '22' , '0' , '23.28' ) 07/10/2022 09:20:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '20065' AND id_supplier = '' 07/10/2022 09:20:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20065' , '' , '1' ) 07/10/2022 09:20:31 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 ( '65174' , '18222' , 'ROSARIO COLORATO - R316' , '204' , '204' , '1' , '0.1600' , '0.13114754098361' , '22' , '0' , '39.82' ) 07/10/2022 09:20:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '18222' AND id_supplier = '' 07/10/2022 09:20:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18222' , '' , '1' ) 07/10/2022 09:20:31 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 ( '65174' , '20061' , 'BRACCIALE DECINA - BC528' , '48' , '48' , '1' , '0.6500' , '0.5327868852459' , '22' , '0' , '38.06' ) 07/10/2022 09:20:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '20061' AND id_supplier = '' 07/10/2022 09:20:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20061' , '' , '1' ) 07/10/2022 09:20:31 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 ( '65174' , '20062' , 'BRACCIALE DECINA - BD018' , '48' , '48' , '1' , '0.6100' , '0.5' , '22' , '0' , '35.72' ) 07/10/2022 09:20:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '20062' AND id_supplier = '' 07/10/2022 09:20:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20062' , '' , '1' ) 07/10/2022 09:20:32 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 ( '65174' , '20063' , 'BRACCIALE EMATITE - BC2023S' , '10' , '10' , '1' , '2.9300' , '2.4016393442623' , '22' , '0' , '35.75' ) 07/10/2022 09:20:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '20063' AND id_supplier = '' 07/10/2022 09:20:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20063' , '' , '1' ) 07/10/2022 09:20:32 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 ( '65174' , '18220' , 'CATENA CON CROCE - NS020' , '36' , '36' , '1' , '0.8500' , '0.69672131147541' , '22' , '0' , '37.33' ) 07/10/2022 09:20:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '18220' AND id_supplier = '' 07/10/2022 09:20:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18220' , '' , '1' ) 07/10/2022 09:20:32 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 ( '65174' , '20067' , 'CATENINA CON MED. SAN BENEDETTO - NS047' , '12' , '12' , '1' , '0.8500' , '0.69672131147541' , '22' , '0' , '12.44' ) 07/10/2022 09:20:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '20067' AND id_supplier = '' 07/10/2022 09:20:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20067' , '' , '1' ) 07/10/2022 09:20:32 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 ( '65174' , '20068' , 'CORONA ROSARIO ACCIAIO - NS086' , '12' , '12' , '1' , '2.6700' , '2.1885245901639' , '22' , '0' , '39.09' ) 07/10/2022 09:20:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '20068' AND id_supplier = '' 07/10/2022 09:20:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20068' , '' , '1' ) 07/10/2022 09:20:32 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 ( '65174' , '18218' , 'DECINA LEGNO CHIARO - FR52' , '400' , '400' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '97.60' ) 07/10/2022 09:20:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '18218' AND id_supplier = '' 07/10/2022 09:20:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18218' , '' , '1' ) 07/10/2022 09:20:32 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 ( '65174' , '20069' , 'SACCHETTO' , '100' , '100' , '1' , '0.0900' , '0.073770491803279' , '22' , '0' , '10.98' ) 07/10/2022 09:20:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '20069' AND id_supplier = '' 07/10/2022 09:20:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20069' , '' , '1' ) 07/10/2022 09:20:32 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 ( '65174' , '20071' , 'ROSARIO MISSIONARIO MM8' , '108' , '108' , '1' , '0.3700' , '0.30327868852459' , '22' , '0' , '48.75' ) 07/10/2022 09:20:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '20071' AND id_supplier = '' 07/10/2022 09:20:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20071' , '' , '1' ) 07/10/2022 09:20:32 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 ( '65174' , '20072' , 'BRACCIALE - BC1759N' , '120' , '120' , '1' , '0.6500' , '0.5327868852459' , '22' , '0' , '95.16' ) 07/10/2022 09:20:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '20072' AND id_supplier = '' 07/10/2022 09:20:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20072' , '' , '1' ) 07/10/2022 09:20:32 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 ( '65174' , '18891' , 'ROSARIO LEGNO - R984' , '108' , '108' , '1' , '0.2200' , '0.18032786885246' , '22' , '0' , '28.99' ) 07/10/2022 09:20:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '18891' AND id_supplier = '' 07/10/2022 09:20:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18891' , '' , '1' ) 07/10/2022 09:20:50 am >> UPDATE ps_document SET id_document_type = '31', document_num = '1269/09/2022', document_date = '2022-09-29', document_letter = '09', id_customer = '0', id_supplier = '', id_address = '4669610', address1 = 'RYNEK WIELUNSKI, 27 42202 CZESTOCHOWA', address2 = '', note = '', price_shipping = '30.50', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '625.42', price_tax_excluded = '512.64', date_upd = NOW() WHERE id_document = '65174' 07/10/2022 09:20:50 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 = '65174' 07/10/2022 09:20:50 am >> DELETE FROM ps_document_detail WHERE id_document = '65174' 07/10/2022 09:20:50 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 ( '65174' , '20064' , 'CATENINA IN ACCIAIO - NS053' , '12' , '12' , '1' , '1.8300' , '1.5' , '22' , '0' , '26.79' ) 07/10/2022 09:20:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '20064' AND id_supplier = '' 07/10/2022 09:20:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20064' , '' , '1' ) 07/10/2022 09:20:50 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 ( '65174' , '20066' , 'CATENINA IN ACCIAIO - NS055' , '12' , '12' , '1' , '1.2600' , '1.0327868852459' , '22' , '0' , '18.45' ) 07/10/2022 09:20:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '20066' AND id_supplier = '' 07/10/2022 09:20:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20066' , '' , '1' ) 07/10/2022 09:20:50 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 ( '65174' , '20065' , 'CATENINA IN ACCIAIO - NS054' , '12' , '12' , '1' , '1.5900' , '1.3032786885246' , '22' , '0' , '23.28' ) 07/10/2022 09:20:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '20065' AND id_supplier = '' 07/10/2022 09:20:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20065' , '' , '1' ) 07/10/2022 09:20:50 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 ( '65174' , '18222' , 'ROSARIO COLORATO - R316' , '204' , '204' , '1' , '0.1600' , '0.13114754098361' , '22' , '0' , '39.82' ) 07/10/2022 09:20:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '18222' AND id_supplier = '' 07/10/2022 09:20:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18222' , '' , '1' ) 07/10/2022 09:20:50 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 ( '65174' , '20061' , 'BRACCIALE DECINA - BC528' , '48' , '48' , '1' , '0.6500' , '0.5327868852459' , '22' , '0' , '38.06' ) 07/10/2022 09:20:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '20061' AND id_supplier = '' 07/10/2022 09:20:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20061' , '' , '1' ) 07/10/2022 09:20:50 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 ( '65174' , '20062' , 'BRACCIALE DECINA - BD018' , '48' , '48' , '1' , '0.6100' , '0.5' , '22' , '0' , '35.72' ) 07/10/2022 09:20:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '20062' AND id_supplier = '' 07/10/2022 09:20:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20062' , '' , '1' ) 07/10/2022 09:20:50 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 ( '65174' , '20063' , 'BRACCIALE EMATITE - BC2023S' , '10' , '10' , '1' , '2.9300' , '2.4016393442623' , '22' , '0' , '35.75' ) 07/10/2022 09:20:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '20063' AND id_supplier = '' 07/10/2022 09:20:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20063' , '' , '1' ) 07/10/2022 09:20:50 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 ( '65174' , '18220' , 'CATENA CON CROCE - NS020' , '36' , '36' , '1' , '0.8500' , '0.69672131147541' , '22' , '0' , '37.33' ) 07/10/2022 09:20:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '18220' AND id_supplier = '' 07/10/2022 09:20:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18220' , '' , '1' ) 07/10/2022 09:20:50 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 ( '65174' , '20067' , 'CATENINA CON MED. SAN BENEDETTO - NS047' , '12' , '12' , '1' , '0.8500' , '0.69672131147541' , '22' , '0' , '12.44' ) 07/10/2022 09:20:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '20067' AND id_supplier = '' 07/10/2022 09:20:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20067' , '' , '1' ) 07/10/2022 09:20:50 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 ( '65174' , '20068' , 'CORONA ROSARIO ACCIAIO - NS086' , '12' , '12' , '1' , '2.6700' , '2.1885245901639' , '22' , '0' , '39.09' ) 07/10/2022 09:20:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '20068' AND id_supplier = '' 07/10/2022 09:20:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20068' , '' , '1' ) 07/10/2022 09:20:50 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 ( '65174' , '18218' , 'DECINA LEGNO CHIARO - FR52' , '400' , '400' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '97.60' ) 07/10/2022 09:20:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '18218' AND id_supplier = '' 07/10/2022 09:20:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18218' , '' , '1' ) 07/10/2022 09:20: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 ( '65174' , '20069' , 'SACCHETTO' , '100' , '100' , '1' , '0.0900' , '0.073770491803279' , '22' , '0' , '10.98' ) 07/10/2022 09:20:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '20069' AND id_supplier = '' 07/10/2022 09:20:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20069' , '' , '1' ) 07/10/2022 09:20: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 ( '65174' , '20071' , 'ROSARIO MISSIONARIO MM8' , '108' , '108' , '1' , '0.3700' , '0.30327868852459' , '22' , '0' , '48.75' ) 07/10/2022 09:20:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '20071' AND id_supplier = '' 07/10/2022 09:20:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20071' , '' , '1' ) 07/10/2022 09:20: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 ( '65174' , '20072' , 'BRACCIALE - BC1759N' , '120' , '120' , '1' , '0.6500' , '0.5327868852459' , '22' , '0' , '95.16' ) 07/10/2022 09:20:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '20072' AND id_supplier = '' 07/10/2022 09:20:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20072' , '' , '1' ) 07/10/2022 09:20: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 ( '65174' , '18891' , 'ROSARIO LEGNO - R984' , '108' , '108' , '1' , '0.2200' , '0.18032786885246' , '22' , '0' , '28.99' ) 07/10/2022 09:20:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '18891' AND id_supplier = '' 07/10/2022 09:20:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18891' , '' , '1' ) 07/10/2022 09:24:14 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 ( '32' , '1484' , '2022-09-30' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '8' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2475.50' , '2475.50' , NOW() , NOW() ) 07/10/2022 09:24:14 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 = '65195' 07/10/2022 09:24:14 am >> DELETE FROM ps_document_detail WHERE id_document = '65195' 07/10/2022 09:24:14 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 ( '65195' , '5444' , 'IO SONO CON VOI - CAT.' , '250' , '0' , '4' , '5.5000' , '5.5' , '0' , '30' , '962.50' ) 07/10/2022 09:24:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '5444' AND id_supplier = '79' 07/10/2022 09:24:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5444' , '79' , '1' ) 07/10/2022 09:24:15 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 ( '65195' , '11193' , 'VENITE CON ME CAT.' , '150' , '0' , '4' , '5.5000' , '5.5' , '0' , '30' , '577.50' ) 07/10/2022 09:24:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '11193' AND id_supplier = '79' 07/10/2022 09:24:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11193' , '79' , '1' ) 07/10/2022 09:24:15 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 ( '65195' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '150' , '0' , '4' , '5.5000' , '5.5' , '0' , '30' , '577.50' ) 07/10/2022 09:24:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '9676' AND id_supplier = '79' 07/10/2022 09:24:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9676' , '79' , '1' ) 07/10/2022 09:24:15 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 ( '65195' , '5887' , 'LITURGIA DELLE ORE - VOL. I - PER SACERDOTI E RELIGIOSI' , '2' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '49.00' ) 07/10/2022 09:24:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '5887' AND id_supplier = '79' 07/10/2022 09:24:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5887' , '79' , '1' ) 07/10/2022 09:24:15 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 ( '65195' , '5888' , 'LITURGIA DELLE ORE - VOL. II - PER SACERDOTI E RELIGIOSI' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '24.50' ) 07/10/2022 09:24:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '5888' AND id_supplier = '79' 07/10/2022 09:24:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5888' , '79' , '1' ) 07/10/2022 09:24:15 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 ( '65195' , '5889' , 'LITURGIA DELLE ORE - VOL. III - PER SACERDOTI E RELIGIOSI' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '24.50' ) 07/10/2022 09:24:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '5889' AND id_supplier = '79' 07/10/2022 09:24:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5889' , '79' , '1' ) 07/10/2022 09:24:15 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 ( '65195' , '5890' , 'LITURGIA DELLE ORE - VOL. IV - PER SACERDOTI E RELIGIOSI' , '2' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '49.00' ) 07/10/2022 09:24:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '5890' AND id_supplier = '79' 07/10/2022 09:24:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5890' , '79' , '1' ) 07/10/2022 09:24:15 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 ( '65195' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '2' , '0' , '4' , '110.0000' , '110' , '0' , '30' , '154.00' ) 07/10/2022 09:24:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '79' 07/10/2022 09:24:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '79' , '1' ) 07/10/2022 09:24:15 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 ( '65195' , '8290' , 'PREGHIERA DEL MATTINO E DELLA SERA - PER LAICI' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '24.50' ) 07/10/2022 09:24:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '8290' AND id_supplier = '79' 07/10/2022 09:24:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8290' , '79' , '1' ) 07/10/2022 09:24:15 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 ( '65195' , '3419' , 'DIARIO LA MISERICORDIA DIVINA - S. FAUSTINA K.' , '1' , '0' , '4' , '13.0000' , '13' , '0' , '30' , '9.10' ) 07/10/2022 09:24:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '3419' AND id_supplier = '79' 07/10/2022 09:24:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3419' , '79' , '1' ) 07/10/2022 09:24:15 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 ( '65195' , '19680' , 'SANTA MESSA - J.J. SILVESTRE VALOR' , '1' , '0' , '4' , '28.0000' , '28' , '0' , '45' , '15.40' ) 07/10/2022 09:24:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '19680' AND id_supplier = '79' 07/10/2022 09:24:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19680' , '79' , '1' ) 07/10/2022 09:26:33 am >> SELECT document_num FROM ps_document WHERE document_num = '74/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-07') 07/10/2022 09:26:33 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' , '74/A' , '2022-10-07' , 'A' , '3865' , '0' , '4673708' , 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '76.60' , '71.80' , NOW() , NOW() ) 07/10/2022 09:26: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 = '65196' 07/10/2022 09:26:33 am >> DELETE FROM ps_document_detail WHERE id_document = '65196' 07/10/2022 09:26: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 ( '65196' , '16307' , 'BRACCIALE IN GOMMA DECINA' , '40' , '-40' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '20.00' ) 07/10/2022 09:26: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 ( '65196' , '17414' , 'BIBBIA SCRUTATE LE SCRITTURE - TELATA' , '1' , '-1' , '4' , '34.00' , '34' , '0' , '0' , '34.00' ) 07/10/2022 09:26: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 ( '65196' , '19588' , 'SCELTA DI ENEA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 07/10/2022 09:26: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 ( '65196' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '3.30' ) 07/10/2022 09:26: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 ( '65196' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '1' , '-1' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '3.30' ) 07/10/2022 09:53:46 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1931/CAV' AND id_product != '19771' AND ean13 != '' 07/10/2022 09:53:46 am >> UPDATE ps_product SET id_supplier = '113', reference = '', ean13 = '1931/CAV', date_upd = NOW() WHERE id_product = '19771' 07/10/2022 09:53:46 am >> UPDATE ps_product_lang SET name = 'ROSARIO ARGENTO/EMATITE', description = '' WHERE id_product = '19771' 07/10/2022 09:53:46 am >> UPDATE ps_product SET wholesale_price = '12.73', on_sale = '0', price = '28.688524590163937' WHERE id_product = '19771' 07/10/2022 09:53:46 am >> UPDATE ps_product_shop SET wholesale_price = '12.73', price = '28.688524590163937', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19771' 07/10/2022 09:53:46 am >> DELETE FROM ps_specific_price WHERE id_product = '19771' 07/10/2022 10:02:54 am >> SELECT document_num FROM ps_document WHERE document_num = '2956' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-07') 07/10/2022 10:02:54 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' , '2956' , '2022-10-07' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.91' , '31.09' , NOW() , NOW() ) 07/10/2022 10:02:54 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 = '65197' 07/10/2022 10:02:54 am >> DELETE FROM ps_document_detail WHERE id_document = '65197' 07/10/2022 10:02:54 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 ( '65197' , '20016' , 'ALLELUJA - 2023' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '5' , '9.41' ) 07/10/2022 10:02:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '20016' AND id_supplier = '' 07/10/2022 10:02:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20016' , '' , '1' ) 07/10/2022 10:02:54 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 ( '65197' , '19938' , 'AGENDA 2023 SAN PAOLO' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 07/10/2022 10:02:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '19938' AND id_supplier = '' 07/10/2022 10:02:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19938' , '' , '1' ) 07/10/2022 10:02:54 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 ( '65197' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 07/10/2022 10:02:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 07/10/2022 10:02:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 07/10/2022 10:02:54 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 ( '65197' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 07/10/2022 10:02:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 07/10/2022 10:02:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 07/10/2022 10:52:14 am >> SELECT document_num FROM ps_document WHERE document_num = '2957' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-07') 07/10/2022 10:52:14 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' , '2957' , '2022-10-07' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 07/10/2022 10:52:14 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 = '65198' 07/10/2022 10:52:14 am >> DELETE FROM ps_document_detail WHERE id_document = '65198' 07/10/2022 10:52:14 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 ( '65198' , '9125' , 'ROSARIO IN PLASTICA - NERO' , '20' , '-20' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '5.00' ) 07/10/2022 10:52:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '9125' AND id_supplier = '' 07/10/2022 10:52:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9125' , '' , '1' ) 07/10/2022 10:52:14 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 ( '65198' , '9126' , 'ROSARIO IN PLASTICA - ROSSO' , '10' , '-10' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '2.50' ) 07/10/2022 10:52:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '9126' AND id_supplier = '' 07/10/2022 10:52:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9126' , '' , '1' ) 07/10/2022 10:52:14 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 ( '65198' , '9123' , 'ROSARIO IN PLASTICA - AZZURRO' , '10' , '-10' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '2.50' ) 07/10/2022 10:52:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '9123' AND id_supplier = '' 07/10/2022 10:52:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9123' , '' , '1' ) 07/10/2022 11:15:05 am >> SELECT document_num FROM ps_document WHERE document_num = '2958' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-07') 07/10/2022 11:15:05 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' , '2958' , '2022-10-07' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '3.69' , NOW() , NOW() ) 07/10/2022 11:15:05 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 = '65199' 07/10/2022 11:15:05 am >> DELETE FROM ps_document_detail WHERE id_document = '65199' 07/10/2022 11:15:05 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 ( '65199' , '18134' , 'CROCE SAN BENEDETTO CM 7 - CSB3' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 07/10/2022 11:15:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '18134' AND id_supplier = '' 07/10/2022 11:15:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18134' , '' , '1' ) 07/10/2022 11:17:14 am >> SELECT document_num FROM ps_document WHERE document_num = '2959' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-07') 07/10/2022 11:17:14 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' , '2959' , '2022-10-07' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '31.15' , NOW() , NOW() ) 07/10/2022 11:17:14 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 = '65200' 07/10/2022 11:17:14 am >> DELETE FROM ps_document_detail WHERE id_document = '65200' 07/10/2022 11:17:14 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 ( '65200' , '2142' , 'CLERGY BLU ML - MISTO 44 ' , '1' , '-1' , '1' , '38' , '31.147540983607' , '22' , '0' , '38.00' ) 07/10/2022 11:17:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '2142' AND id_supplier = '' 07/10/2022 11:17:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2142' , '' , '1' ) 07/10/2022 11:23:04 am >> SELECT document_num FROM ps_document WHERE document_num = '2960' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-07') 07/10/2022 11:23:04 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' , '2960' , '2022-10-07' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '239.00' , '201.82' , NOW() , NOW() ) 07/10/2022 11:23:04 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 = '65201' 07/10/2022 11:23:04 am >> DELETE FROM ps_document_detail WHERE id_document = '65201' 07/10/2022 11:23:04 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 ( '65201' , '16689' , 'OSTIA PAN DI CENA mm80' , '6' , '-6' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '12.00' ) 07/10/2022 11:23:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 07/10/2022 11:23:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 07/10/2022 11:23:04 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 ( '65201' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '7.60' ) 07/10/2022 11:23:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 07/10/2022 11:23:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 07/10/2022 11:23:04 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 ( '65201' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '17.4' , '17.4' , '0' , '0' , '17.40' ) 07/10/2022 11:23:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 07/10/2022 11:23:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 07/10/2022 11:23:04 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 ( '65201' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '81' , '66.393442622951' , '22' , '0' , '81.00' ) 07/10/2022 11:23:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 07/10/2022 11:23:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 07/10/2022 11:23:04 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 ( '65201' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '50' , '-50' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '25.00' ) 07/10/2022 11:23:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '7924' AND id_supplier = '' 07/10/2022 11:23:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7924' , '' , '1' ) 07/10/2022 11:23:04 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 ( '65201' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8' , '6.5573770491803' , '22' , '0' , '48.00' ) 07/10/2022 11:23:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 07/10/2022 11:23:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 07/10/2022 11:23:04 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 ( '65201' , '11389' , 'VINO ROSSO DOLCE - 103' , '6' , '-6' , '1' , '8' , '6.5573770491803' , '22' , '0' , '48.00' ) 07/10/2022 11:23:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '11389' AND id_supplier = '' 07/10/2022 11:23:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11389' , '' , '1' ) 07/10/2022 11:24:10 am >> SELECT document_num FROM ps_document WHERE document_num = '2961' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-07') 07/10/2022 11:24: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' , '2961' , '2022-10-07' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.50' , '7.50' , NOW() , NOW() ) 07/10/2022 11:24: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 = '65202' 07/10/2022 11:24:10 am >> DELETE FROM ps_document_detail WHERE id_document = '65202' 07/10/2022 11:24: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 ( '65202' , '19920' , 'CALENDARIO LITURGICO 2023 - 8078' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 07/10/2022 11:24:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '19920' AND id_supplier = '' 07/10/2022 11:24:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19920' , '' , '1' ) 07/10/2022 11:24: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 ( '65202' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '7' , '7' , '0' , '0' , '7.00' ) 07/10/2022 11:24:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 07/10/2022 11:24:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 07/10/2022 11:29:06 am >> SELECT document_num FROM ps_document WHERE document_num = '2962' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-07') 07/10/2022 11:29:06 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' , '2962' , '2022-10-07' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.00' , '13.11' , NOW() , NOW() ) 07/10/2022 11:29: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 = '65203' 07/10/2022 11:29:06 am >> DELETE FROM ps_document_detail WHERE id_document = '65203' 07/10/2022 11:29: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 ( '65203' , '18220' , 'CATENA CON CROCE - NS020' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 07/10/2022 11:29:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '18220' AND id_supplier = '' 07/10/2022 11:29:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18220' , '' , '1' ) 07/10/2022 11:29: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 ( '65203' , '18213' , 'BRACCIALE CROCI COLORATO - BC569' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 07/10/2022 11:29:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '18213' AND id_supplier = '' 07/10/2022 11:29:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18213' , '' , '1' ) 07/10/2022 11:29: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 ( '65203' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '12.5' , '10.245901639344' , '22' , '0' , '12.50' ) 07/10/2022 11:29:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 07/10/2022 11:29:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 07/10/2022 11:37:19 am >> SELECT document_num FROM ps_document WHERE document_num = '2963' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-07') 07/10/2022 11:37:19 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' , '2963' , '2022-10-07' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.50' , '44.33' , NOW() , NOW() ) 07/10/2022 11:37:19 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 = '65204' 07/10/2022 11:37:19 am >> DELETE FROM ps_document_detail WHERE id_document = '65204' 07/10/2022 11:37:19 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 ( '65204' , '11151' , 'LIBRI' , '5' , '-5' , '4' , '3.5' , '3.5' , '0' , '0' , '17.50' ) 07/10/2022 11:37:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 07/10/2022 11:37:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 07/10/2022 11:37:19 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 ( '65204' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 07/10/2022 11:37:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 07/10/2022 11:37:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 07/10/2022 11:37:19 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 ( '65204' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '2' , '-2' , '1' , '10' , '8.1967213114754' , '22' , '0' , '20.00' ) 07/10/2022 11:37:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '13355' AND id_supplier = '' 07/10/2022 11:37:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13355' , '' , '1' ) 07/10/2022 11:37:19 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 ( '65204' , '5538' , 'LACCIO MARRONE' , '20' , '-20' , '1' , '0.05' , '0.040983606557377' , '22' , '0' , '1.00' ) 07/10/2022 11:37:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '5538' AND id_supplier = '' 07/10/2022 11:37:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5538' , '' , '1' ) 07/10/2022 11:39:31 am >> SELECT document_num FROM ps_document WHERE document_num = '2964' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-07') 07/10/2022 11:39:31 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' , '2964' , '2022-10-07' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '9.02' , NOW() , NOW() ) 07/10/2022 11:39:31 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 = '65205' 07/10/2022 11:39:31 am >> DELETE FROM ps_document_detail WHERE id_document = '65205' 07/10/2022 11:39:31 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 ( '65205' , '14063' , 'STELLARIO PLEX CM 10 / 12' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 07/10/2022 11:39:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '14063' AND id_supplier = '' 07/10/2022 11:39:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14063' , '' , '1' ) 07/10/2022 11:41:23 am >> SELECT document_num FROM ps_document WHERE document_num = '2965' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-07') 07/10/2022 11:41:24 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' , '2965' , '2022-10-07' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.56' , '28.56' , NOW() , NOW() ) 07/10/2022 11:41:24 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 = '65206' 07/10/2022 11:41:24 am >> DELETE FROM ps_document_detail WHERE id_document = '65206' 07/10/2022 11:41:24 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 ( '65206' , '6283' , 'MASSIME ETERNE - 8362' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 07/10/2022 11:41:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '6283' AND id_supplier = '' 07/10/2022 11:41:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6283' , '' , '1' ) 07/10/2022 11:41:24 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 ( '65206' , '15846' , 'CARLO ACUTIS - F. OCCHETTA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 07/10/2022 11:41:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '15846' AND id_supplier = '' 07/10/2022 11:41:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15846' , '' , '1' ) 07/10/2022 11:41:24 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 ( '65206' , '7543' , 'PARABOLE DI GESÙ' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 07/10/2022 11:41:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '7543' AND id_supplier = '' 07/10/2022 11:41:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7543' , '' , '1' ) 07/10/2022 11:41:24 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 ( '65206' , '19932' , '100 IDEE PER IL CATECHISMO 2' , '1' , '-1' , '4' , '14.90' , '14.9' , '0' , '5' , '14.16' ) 07/10/2022 11:41:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '19932' AND id_supplier = '' 07/10/2022 11:41:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19932' , '' , '1' ) 07/10/2022 11:41:24 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 ( '65206' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.9' , '1.9' , '0' , '0' , '1.90' ) 07/10/2022 11:41:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 07/10/2022 11:41:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 07/10/2022 11:44:19 am >> SELECT document_num FROM ps_document WHERE document_num = '2966' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-07') 07/10/2022 11:44:19 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' , '2966' , '2022-10-07' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.04' , '47.04' , NOW() , NOW() ) 07/10/2022 11:44:19 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 = '65207' 07/10/2022 11:44:19 am >> DELETE FROM ps_document_detail WHERE id_document = '65207' 07/10/2022 11:44:19 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 ( '65207' , '19760' , 'RAGAZZI CHE SQUADRA - 3' , '1' , '-1' , '4' , '16.50' , '16.5' , '0' , '5' , '15.68' ) 07/10/2022 11:44:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '19760' AND id_supplier = '' 07/10/2022 11:44:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19760' , '' , '1' ) 07/10/2022 11:44:19 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 ( '65207' , '19758' , 'RAGAZZI CHE SQUADRA - 1' , '1' , '-1' , '4' , '16.50' , '16.5' , '0' , '5' , '15.68' ) 07/10/2022 11:44:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '19758' AND id_supplier = '' 07/10/2022 11:44:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19758' , '' , '1' ) 07/10/2022 11:44:19 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 ( '65207' , '19759' , 'RAGAZZI CHE SQUADRA - 2' , '1' , '-1' , '4' , '16.50' , '16.5' , '0' , '5' , '15.68' ) 07/10/2022 11:44:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '19759' AND id_supplier = '' 07/10/2022 11:44:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19759' , '' , '1' ) 07/10/2022 11:45:27 am >> SELECT document_num FROM ps_document WHERE document_num = '2967' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-07') 07/10/2022 11:45:27 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' , '2967' , '2022-10-07' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.05' , '18.05' , NOW() , NOW() ) 07/10/2022 11:45:27 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 = '65208' 07/10/2022 11:45:27 am >> DELETE FROM ps_document_detail WHERE id_document = '65208' 07/10/2022 11:45:27 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 ( '65208' , '8250' , 'PREGATE, PREGATE, PREGATE - 8001' , '1' , '-1' , '4' , '19.00' , '19' , '0' , '5' , '18.05' ) 07/10/2022 11:45:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '8250' AND id_supplier = '' 07/10/2022 11:45:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8250' , '' , '1' ) 07/10/2022 12:53:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '75/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-07') 07/10/2022 12:53:04 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 ( '24' , '75/A' , '2022-10-07' , 'A' , '922' , '0' , '4671011' , 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '498.53' , '421.99' , NOW() , NOW() ) 07/10/2022 12:53:04 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 = '65209' 07/10/2022 12:53:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '65209' 07/10/2022 12:53:04 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 ( '65209' , '16689' , 'OSTIA PAN DI CENA mm80' , '20' , '-20' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '40.00' ) 07/10/2022 12:53:04 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 ( '65209' , '' , 'ostia' , '1' , '-1' , '3' , '1.9' , '1.8269230769231' , '4' , '0' , '1.90' ) 07/10/2022 12:53:04 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 ( '65209' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '112.80' ) 07/10/2022 12:53:04 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 ( '65209' , '19271' , 'SIGNORE MI CONDUSSE - G. SALONIA' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 07/10/2022 12:53:04 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 ( '65209' , '20048' , 'AGENDA MISSIONARIA 2023' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 07/10/2022 12:53:04 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 ( '65209' , '20054' , 'MESSALINO QUOTIDIANO - NOV DIC GEN 2023' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '0' , '15.00' ) 07/10/2022 12:53:04 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 ( '65209' , '19926' , 'AMEN - DIC. 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 07/10/2022 12:53:04 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 ( '65209' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '6' , '-6' , '4' , '0.70' , '0.7' , '0' , '0' , '4.20' ) 07/10/2022 12:53:04 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 ( '65209' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '2' , '-2' , '1' , '36.50' , '29.918032786885' , '22' , '0' , '73.00' ) 07/10/2022 12:53:04 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 ( '65209' , '19397' , 'CLERGY COTONE 100% ML - C02' , '1' , '-1' , '1' , '41.9' , '34.344262295082' , '22' , '0' , '41.90' ) 07/10/2022 12:53:04 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 ( '65209' , '2266' , 'CLERGY GRIGIO CHIARO ML - COTONE 41 ' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '15' , '38.25' ) 07/10/2022 12:53:04 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 ( '65209' , '2151' , 'CLERGY BLU MM - COTONE 41 ' , '1' , '-1' , '1' , '39.5' , '32.377049180328' , '22' , '15' , '33.58' ) 07/10/2022 12:53:04 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 ( '65209' , '' , 'maglie' , '3' , '-3' , '1' , '35' , '28.688524590164' , '22' , '0' , '105.00' ) 07/10/2022 01:05:52 pm >> DELETE FROM ps_document WHERE id_document = '61145' 07/10/2022 01:05:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '61145' 07/10/2022 02:39:29 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884041920' AND id_product != '6283' AND ean13 != '' 07/10/2022 02:39:29 pm >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788884041920', date_upd = NOW() WHERE id_product = '6283' 07/10/2022 02:39:29 pm >> UPDATE ps_product_lang SET name = 'MASSIME ETERNE - 8362', description = '' WHERE id_product = '6283' 07/10/2022 02:39:29 pm >> UPDATE ps_product SET wholesale_price = '3.00', on_sale = '0', price = '7' WHERE id_product = '6283' 07/10/2022 02:39:29 pm >> UPDATE ps_product_shop SET wholesale_price = '3.00', price = '7', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '6283' 07/10/2022 02:39:29 pm >> DELETE FROM ps_specific_price WHERE id_product = '6283' 07/10/2022 03:03:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '11' AND id_document != '7137' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-10-05') 07/10/2022 03:03:07 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '11', document_date = '2022-10-05', document_letter = '', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', 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 = '1300.00', price_tax_excluded = '1300.00', date_upd = NOW() WHERE id_document = '7137' 07/10/2022 03:03:07 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 = '7137' 07/10/2022 03:03:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '7137' 07/10/2022 03:03:07 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 ( '7137' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '360' , '-360' , '4' , '2.5000' , '2.5' , '0' , '0' , '900.00' ) 07/10/2022 03:03:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23' AND id_supplier = '' 07/10/2022 03:03:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23' , '' , '1' ) 07/10/2022 03:03:07 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 ( '7137' , '17' , 'LA FEDE NELLO ZAINETTO' , '80' , '-80' , '4' , '5.0000' , '5' , '0' , '0' , '400.00' ) 07/10/2022 03:03:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17' AND id_supplier = '' 07/10/2022 03:03:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17' , '' , '1' ) 07/10/2022 03:09:03 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 ( '33' , '2884' , '2022-10-06' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '173.60' , '173.60' , NOW() , NOW() ) 07/10/2022 03:09:03 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 = '65210' 07/10/2022 03:09:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '65210' 07/10/2022 03:09:03 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 ( '65210' , '17526' , 'PREGHIERE EUCARISTICHE PER CONCELEBRAZIONE N.E.' , '10' , '10' , '4' , '6.00' , '6' , '0' , '30' , '42.0000' ) 07/10/2022 03:09:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17526' AND id_supplier = '79' 07/10/2022 03:09:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17526' , '79' , '1' ) 07/10/2022 03:09:03 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 ( '65210' , '8290' , 'PREGHIERA DEL MATTINO E DELLA SERA - PER LAICI' , '1' , '1' , '4' , '35.00' , '35' , '0' , '30' , '24.5000' ) 07/10/2022 03:09:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8290' AND id_supplier = '79' 07/10/2022 03:09:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8290' , '79' , '1' ) 07/10/2022 03:09:03 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 ( '65210' , '5887' , 'LITURGIA DELLE ORE - VOL. I - PER SACERDOTI E RELIGIOSI' , '1' , '1' , '4' , '35.00' , '35' , '0' , '30' , '24.5000' ) 07/10/2022 03:09:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5887' AND id_supplier = '79' 07/10/2022 03:09:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5887' , '79' , '1' ) 07/10/2022 03:09:03 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 ( '65210' , '5888' , 'LITURGIA DELLE ORE - VOL. II - PER SACERDOTI E RELIGIOSI' , '1' , '1' , '4' , '35.00' , '35' , '0' , '30' , '24.5000' ) 07/10/2022 03:09:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5888' AND id_supplier = '79' 07/10/2022 03:09:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5888' , '79' , '1' ) 07/10/2022 03:09:03 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 ( '65210' , '5889' , 'LITURGIA DELLE ORE - VOL. III - PER SACERDOTI E RELIGIOSI' , '1' , '1' , '4' , '35.00' , '35' , '0' , '30' , '24.5000' ) 07/10/2022 03:09:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5889' AND id_supplier = '79' 07/10/2022 03:09:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5889' , '79' , '1' ) 07/10/2022 03:09:03 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 ( '65210' , '5890' , 'LITURGIA DELLE ORE - VOL. IV - PER SACERDOTI E RELIGIOSI' , '1' , '1' , '4' , '35.00' , '35' , '0' , '30' , '24.5000' ) 07/10/2022 03:09:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5890' AND id_supplier = '79' 07/10/2022 03:09:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5890' , '79' , '1' ) 07/10/2022 03:09:03 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 ( '65210' , '3419' , 'DIARIO LA MISERICORDIA DIVINA - S. FAUSTINA K.' , '1' , '1' , '4' , '13.00' , '13' , '0' , '30' , '9.1000' ) 07/10/2022 03:09:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3419' AND id_supplier = '79' 07/10/2022 03:09:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3419' , '79' , '1' ) 07/10/2022 03:52:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '2968' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-07') 07/10/2022 03:52:26 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' , '2968' , '2022-10-07' , '' , '3553' , '' , '4671021' , 'VIALE ITALIA 83100 AVELLINO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '445.61' , '445.61' , NOW() , NOW() ) 07/10/2022 03:52:26 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 = '65211' 07/10/2022 03:52:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '65211' 07/10/2022 03:52:26 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 ( '65211' , '14719' , 'TU MI AMI DAVVERO' , '7' , '-7' , '4' , '4.41' , '4.41' , '0' , '' , '30.87' ) 07/10/2022 03:52:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14719' AND id_supplier = '' 07/10/2022 03:52:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14719' , '' , '1' ) 07/10/2022 03:52:26 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 ( '65211' , '10751' , 'TU MI PERDONI' , '5' , '-5' , '4' , '4.41' , '4.41' , '0' , '0' , '22.05' ) 07/10/2022 03:52:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10751' AND id_supplier = '' 07/10/2022 03:52:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10751' , '' , '1' ) 07/10/2022 03:52:26 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 ( '65211' , '14719' , 'TU MI AMI DAVVERO' , '41' , '-41' , '4' , '5.31' , '5.31' , '0' , '0' , '217.71' ) 07/10/2022 03:52:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14719' AND id_supplier = '' 07/10/2022 03:52:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14719' , '' , '1' ) 07/10/2022 03:52:26 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 ( '65211' , '10751' , 'TU MI PERDONI' , '30' , '-30' , '4' , '5.31' , '5.31' , '0' , '0' , '159.30' ) 07/10/2022 03:52:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10751' AND id_supplier = '' 07/10/2022 03:52:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10751' , '' , '1' ) 07/10/2022 03:52:26 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 ( '65211' , '19758' , 'RAGAZZI CHE SQUADRA - 1' , '1' , '-1' , '4' , '16.50' , '16.5' , '0' , '5' , '15.68' ) 07/10/2022 03:52:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19758' AND id_supplier = '' 07/10/2022 03:52:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19758' , '' , '1' ) 07/10/2022 03:52:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '2969' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-07') 07/10/2022 03:52:41 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' , '2969' , '2022-10-07' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.85' , '21.85' , NOW() , NOW() ) 07/10/2022 03:52: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 = '65212' 07/10/2022 03:52:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '65212' 07/10/2022 03:52: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 ( '65212' , '20024' , 'PER LETERNITA - R. SARAH' , '1' , '-1' , '4' , '23.00' , '23' , '0' , '5' , '21.85' ) 07/10/2022 03:52:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20024' AND id_supplier = '' 07/10/2022 03:52:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20024' , '' , '1' ) 07/10/2022 03:54:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '2968' AND id_document != '65211' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-07') 07/10/2022 03:54:48 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2968', document_date = '2022-10-07', document_letter = '', id_customer = '', id_supplier = '', id_address = '', address1 = 'VIALE ITALIA 83100 AVELLINO', 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 = '445.61', price_tax_excluded = '445.61', date_upd = NOW() WHERE id_document = '65211' 07/10/2022 03:54:48 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 = '65211' 07/10/2022 03:54:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '65211' 07/10/2022 03:54:48 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 ( '65211' , '14719' , 'TU MI AMI DAVVERO' , '7' , '-7' , '4' , '4.4100' , '4.41' , '0' , '' , '30.87' ) 07/10/2022 03:54:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14719' AND id_supplier = '' 07/10/2022 03:54:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14719' , '' , '1' ) 07/10/2022 03:54:48 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 ( '65211' , '10751' , 'TU MI PERDONI' , '5' , '-5' , '4' , '4.4100' , '4.41' , '0' , '0' , '22.05' ) 07/10/2022 03:54:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10751' AND id_supplier = '' 07/10/2022 03:54:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10751' , '' , '1' ) 07/10/2022 03:54:48 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 ( '65211' , '14719' , 'TU MI AMI DAVVERO' , '41' , '-41' , '4' , '5.3100' , '5.31' , '0' , '0' , '217.71' ) 07/10/2022 03:54:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14719' AND id_supplier = '' 07/10/2022 03:54:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14719' , '' , '1' ) 07/10/2022 03:54:48 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 ( '65211' , '10751' , 'TU MI PERDONI' , '30' , '-30' , '4' , '5.3100' , '5.31' , '0' , '0' , '159.30' ) 07/10/2022 03:54:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10751' AND id_supplier = '' 07/10/2022 03:54:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10751' , '' , '1' ) 07/10/2022 03:54:48 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 ( '65211' , '19758' , 'RAGAZZI CHE SQUADRA - 1' , '1' , '-1' , '4' , '16.5000' , '16.5' , '0' , '5' , '15.68' ) 07/10/2022 03:54:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19758' AND id_supplier = '' 07/10/2022 03:54:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19758' , '' , '1' ) 07/10/2022 03:55:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '2970' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-07') 07/10/2022 03:55:47 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' , '2970' , '2022-10-07' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '102.00' , '102.00' , NOW() , NOW() ) 07/10/2022 03:55:47 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 = '65213' 07/10/2022 03:55:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '65213' 07/10/2022 03:55:47 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 ( '65213' , '13999' , 'ENCHIRIDION SYMBOLORUM - DENZINGER' , '1' , '-1' , '4' , '102' , '102' , '0' , '0' , '102.00' ) 07/10/2022 03:55:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13999' AND id_supplier = '' 07/10/2022 03:55:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13999' , '' , '1' ) 07/10/2022 04:06:52 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 07/10/2022 04:06:52 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20074' , '1' , '' , 'nuovo-prodotto' ) 07/10/2022 04:06:52 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20074' , '1' , '1' , '2' , NOW() , NOW() ) 07/10/2022 04:06:52 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20074' , '0' , '1' , '0' , '0' ) 07/10/2022 04:10:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1965/CAV' AND id_product != '20074' AND ean13 != '' 07/10/2022 04:10:28 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1965/CAV', date_upd = NOW() WHERE id_product = '20074' 07/10/2022 04:10:28 pm >> UPDATE ps_product_lang SET name = 'ROSARIO ARG/PERLA/EMATITE ', description = '' WHERE id_product = '20074' 07/10/2022 04:10:28 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '39.34426229508197' WHERE id_product = '20074' 07/10/2022 04:10:28 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '39.34426229508197', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20074' 07/10/2022 04:10:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '20074' 07/10/2022 04:11:13 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1965/CAV' AND id_product != '20074' AND ean13 != '' 07/10/2022 04:11:13 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1965/CAV', date_upd = NOW() WHERE id_product = '20074' 07/10/2022 04:11:13 pm >> UPDATE ps_product_lang SET name = 'ROSARIO ARG/PERLA/EMATITE ', description = '' WHERE id_product = '20074' 07/10/2022 04:11:13 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '39.34426229508197' WHERE id_product = '20074' 07/10/2022 04:11:13 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '39.34426229508197', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20074' 07/10/2022 04:11:13 pm >> DELETE FROM ps_specific_price WHERE id_product = '20074' 07/10/2022 04:11:13 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20074' 07/10/2022 04:11:13 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20075' , '1' , '' , 'nuovo-prodotto' ) 07/10/2022 04:11:13 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20075' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20074' 07/10/2022 04:11:14 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20075' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20074' 07/10/2022 04:12:12 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1497/CAV' AND id_product != '20075' AND ean13 != '' 07/10/2022 04:12:12 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1497/CAV', date_upd = NOW() WHERE id_product = '20075' 07/10/2022 04:12:12 pm >> UPDATE ps_product_lang SET name = 'ROSARIO ARGENTO/EMATITE', description = '' WHERE id_product = '20075' 07/10/2022 04:12:12 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = 'NaN' WHERE id_product = '20075' 07/10/2022 04:12:12 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = 'NaN', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20075' 07/10/2022 04:12:12 pm >> DELETE FROM ps_specific_price WHERE id_product = '20075' 07/10/2022 04:13:29 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1497/CAV' AND id_product != '20075' AND ean13 != '' 07/10/2022 04:13:29 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1497/CAV', date_upd = NOW() WHERE id_product = '20075' 07/10/2022 04:13:29 pm >> UPDATE ps_product_lang SET name = 'ROSARIO ARGENTO/EMATITE', description = '' WHERE id_product = '20075' 07/10/2022 04:13:29 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = 'NaN' WHERE id_product = '20075' 07/10/2022 04:13:30 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = 'NaN', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20075' 07/10/2022 04:13:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '20075' 07/10/2022 04:15:00 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20075' 07/10/2022 04:15:00 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20076' , '1' , '' , 'nuovo-prodotto' ) 07/10/2022 04:15:00 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20076' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20075' 07/10/2022 04:15:00 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20076' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20075' 07/10/2022 04:15:50 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1826RA' AND id_product != '20076' AND ean13 != '' 07/10/2022 04:15:50 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1826RA', date_upd = NOW() WHERE id_product = '20076' 07/10/2022 04:15:50 pm >> UPDATE ps_product_lang SET name = 'ROSARIO ARGENTO/QUARZO', description = '' WHERE id_product = '20076' 07/10/2022 04:15:50 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '40.90163934426229' WHERE id_product = '20076' 07/10/2022 04:15:50 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '40.90163934426229', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20076' 07/10/2022 04:15:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '20076' 07/10/2022 04:16:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1826RA' AND id_product != '20076' AND ean13 != '' 07/10/2022 04:16:43 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1826RA', date_upd = NOW() WHERE id_product = '20076' 07/10/2022 04:16:43 pm >> UPDATE ps_product_lang SET name = 'ROSARIO ARGENTO/QUARZO', description = '' WHERE id_product = '20076' 07/10/2022 04:16:43 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '40.90163934426229' WHERE id_product = '20076' 07/10/2022 04:16:43 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '40.90163934426229', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20076' 07/10/2022 04:16:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '20076' 07/10/2022 04:16:45 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20076' 07/10/2022 04:16:45 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20077' , '1' , '' , 'nuovo-prodotto' ) 07/10/2022 04:16:45 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20077' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20076' 07/10/2022 04:16:45 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20077' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20076' 07/10/2022 04:17:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1375/CAV' AND id_product != '20077' AND ean13 != '' 07/10/2022 04:17:30 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1375/CAV', date_upd = NOW() WHERE id_product = '20077' 07/10/2022 04:17:30 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ARGENTO', description = '' WHERE id_product = '20077' 07/10/2022 04:17:30 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20.081967213114755' WHERE id_product = '20077' 07/10/2022 04:17:30 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20.081967213114755', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20077' 07/10/2022 04:17:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '20077' 07/10/2022 04:18:49 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20077' 07/10/2022 04:18:49 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20078' , '1' , '' , 'nuovo-prodotto' ) 07/10/2022 04:18:49 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20078' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20077' 07/10/2022 04:18:49 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20078' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20077' 07/10/2022 04:19:18 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1936/CAV' AND id_product != '20078' AND ean13 != '' 07/10/2022 04:19:18 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1936/CAV', date_upd = NOW() WHERE id_product = '20078' 07/10/2022 04:19:18 pm >> UPDATE ps_product_lang SET name = 'ROSARIO ARGENTO', description = '' WHERE id_product = '20078' 07/10/2022 04:19:18 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '40.90163934426229' WHERE id_product = '20078' 07/10/2022 04:19:18 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '40.90163934426229', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20078' 07/10/2022 04:19:18 pm >> DELETE FROM ps_specific_price WHERE id_product = '20078' 07/10/2022 04:20:23 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20078' 07/10/2022 04:20:23 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20079' , '1' , '' , 'nuovo-prodotto' ) 07/10/2022 04:20:23 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20079' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20078' 07/10/2022 04:20:23 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20079' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20078' 07/10/2022 04:20:57 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '312/EMA' AND id_product != '20079' AND ean13 != '' 07/10/2022 04:20:57 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '312/EMA', date_upd = NOW() WHERE id_product = '20079' 07/10/2022 04:20:57 pm >> UPDATE ps_product_lang SET name = 'ROSARIO ARGENTO', description = '' WHERE id_product = '20079' 07/10/2022 04:20:57 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '48.36065573770492' WHERE id_product = '20079' 07/10/2022 04:20:57 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '48.36065573770492', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20079' 07/10/2022 04:20:57 pm >> DELETE FROM ps_specific_price WHERE id_product = '20079' 07/10/2022 04:21:42 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20079' 07/10/2022 04:21:42 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20080' , '1' , '' , 'nuovo-prodotto' ) 07/10/2022 04:21:42 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20080' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20079' 07/10/2022 04:21:42 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20080' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20079' 07/10/2022 04:22:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1480' AND id_product != '20080' AND ean13 != '' 07/10/2022 04:22:25 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1480', date_upd = NOW() WHERE id_product = '20080' 07/10/2022 04:22:25 pm >> UPDATE ps_product_lang SET name = 'ROSARIO ARGENTO/ULIVO', description = '' WHERE id_product = '20080' 07/10/2022 04:22:25 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '32.704918032786885' WHERE id_product = '20080' 07/10/2022 04:22:25 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '32.704918032786885', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20080' 07/10/2022 04:22:25 pm >> DELETE FROM ps_specific_price WHERE id_product = '20080' 07/10/2022 04:25:26 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001800' AND id_product != '18762' AND ean13 != '' 07/10/2022 04:25:26 pm >> UPDATE ps_product SET id_supplier = '113', reference = '', ean13 = '001800', date_upd = NOW() WHERE id_product = '18762' 07/10/2022 04:25:26 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ARG. - 1568/1570', description = '' WHERE id_product = '18762' 07/10/2022 04:25:26 pm >> UPDATE ps_product SET wholesale_price = '13.40', on_sale = '0', price = '30.24590163934426' WHERE id_product = '18762' 07/10/2022 04:25:26 pm >> UPDATE ps_product_shop SET wholesale_price = '13.40', price = '30.24590163934426', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18762' 07/10/2022 04:25:26 pm >> DELETE FROM ps_specific_price WHERE id_product = '18762' 07/10/2022 04:26:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001800' AND id_product != '18762' AND ean13 != '' 07/10/2022 04:26:39 pm >> UPDATE ps_product SET id_supplier = '113', reference = '', ean13 = '001800', date_upd = NOW() WHERE id_product = '18762' 07/10/2022 04:26:39 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ARG. - 1568/1570', description = '' WHERE id_product = '18762' 07/10/2022 04:26:39 pm >> UPDATE ps_product SET wholesale_price = '13.40', on_sale = '0', price = '30.24590163934426' WHERE id_product = '18762' 07/10/2022 04:26:39 pm >> UPDATE ps_product_shop SET wholesale_price = '13.40', price = '30.24590163934426', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18762' 07/10/2022 04:26:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '18762' 07/10/2022 04:27:12 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001800' AND id_product != '18762' AND ean13 != '' 07/10/2022 04:27:12 pm >> UPDATE ps_product SET id_supplier = '113', reference = '', ean13 = '001800', date_upd = NOW() WHERE id_product = '18762' 07/10/2022 04:27:12 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ARG. - 1568/1570', description = '' WHERE id_product = '18762' 07/10/2022 04:27:12 pm >> UPDATE ps_product SET wholesale_price = '13.40', on_sale = '0', price = '30.24590163934426' WHERE id_product = '18762' 07/10/2022 04:27:12 pm >> UPDATE ps_product_shop SET wholesale_price = '13.40', price = '30.24590163934426', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18762' 07/10/2022 04:27:12 pm >> DELETE FROM ps_specific_price WHERE id_product = '18762' 07/10/2022 04:28:03 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1976/CAV' AND id_product != '19780' AND ean13 != '' 07/10/2022 04:28:03 pm >> UPDATE ps_product SET id_supplier = '113', reference = '', ean13 = '1976/CAV', date_upd = NOW() WHERE id_product = '19780' 07/10/2022 04:28:03 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ARGENTO/EMATITE', description = '' WHERE id_product = '19780' 07/10/2022 04:28:03 pm >> UPDATE ps_product SET wholesale_price = '6.18', on_sale = '0', price = '13.934426229508198' WHERE id_product = '19780' 07/10/2022 04:28:03 pm >> UPDATE ps_product_shop SET wholesale_price = '6.18', price = '13.934426229508198', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19780' 07/10/2022 04:28:03 pm >> DELETE FROM ps_specific_price WHERE id_product = '19780' 07/10/2022 04:29:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001798' AND id_product != '18760' AND ean13 != '' 07/10/2022 04:29:48 pm >> UPDATE ps_product SET id_supplier = '113', reference = '', ean13 = '001798', date_upd = NOW() WHERE id_product = '18760' 07/10/2022 04:29:48 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ARG - 1819', description = '' WHERE id_product = '18760' 07/10/2022 04:29:48 pm >> UPDATE ps_product SET wholesale_price = '11.31', on_sale = '0', price = '25.81967213114754' WHERE id_product = '18760' 07/10/2022 04:29:48 pm >> UPDATE ps_product_shop SET wholesale_price = '11.31', price = '25.81967213114754', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18760' 07/10/2022 04:29:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '18760' 07/10/2022 04:30:27 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20080' 07/10/2022 04:30:27 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20081' , '1' , '' , 'nuovo-prodotto' ) 07/10/2022 04:30:27 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20081' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20080' 07/10/2022 04:30:27 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20081' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20080' 07/10/2022 04:31:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '4455' AND id_product != '20081' AND ean13 != '' 07/10/2022 04:31:17 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '4455', date_upd = NOW() WHERE id_product = '20081' 07/10/2022 04:31:17 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ARGENTO', description = '' WHERE id_product = '20081' 07/10/2022 04:31:17 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '19.262295081967213' WHERE id_product = '20081' 07/10/2022 04:31:17 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '19.262295081967213', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20081' 07/10/2022 04:31:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '20081' 07/10/2022 04:41:08 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1497/CAV' AND id_product != '20075' AND ean13 != '' 07/10/2022 04:41:08 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1497/CAV', date_upd = NOW() WHERE id_product = '20075' 07/10/2022 04:41:08 pm >> UPDATE ps_product_lang SET name = 'ROSARIO ARGENTO/EMATITE', description = '' WHERE id_product = '20075' 07/10/2022 04:41:08 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '32.37704918032787' WHERE id_product = '20075' 07/10/2022 04:41:08 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '32.37704918032787', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20075' 07/10/2022 04:41:08 pm >> DELETE FROM ps_specific_price WHERE id_product = '20075' 07/10/2022 04:45:34 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002008' AND id_product != '19785' AND ean13 != '' 07/10/2022 04:45:34 pm >> UPDATE ps_product SET id_supplier = '113', reference = '', ean13 = '002008', date_upd = NOW() WHERE id_product = '19785' 07/10/2022 04:45:34 pm >> UPDATE ps_product_lang SET name = 'ROSARIO MADREPERLA MM4 - 10M4', description = '' WHERE id_product = '19785' 07/10/2022 04:45:34 pm >> UPDATE ps_product SET wholesale_price = '2.57', on_sale = '0', price = '6.147540983606557' WHERE id_product = '19785' 07/10/2022 04:45:34 pm >> UPDATE ps_product_shop SET wholesale_price = '2.57', price = '6.147540983606557', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19785' 07/10/2022 04:45:34 pm >> DELETE FROM ps_specific_price WHERE id_product = '19785' 07/10/2022 04:45:52 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002009' AND id_product != '19786' AND ean13 != '' 07/10/2022 04:45:52 pm >> UPDATE ps_product SET id_supplier = '113', reference = '', ean13 = '002009', date_upd = NOW() WHERE id_product = '19786' 07/10/2022 04:45:52 pm >> UPDATE ps_product_lang SET name = 'ROSARIO MADREPERLA MM5 - 10M5', description = '' WHERE id_product = '19786' 07/10/2022 04:45:52 pm >> UPDATE ps_product SET wholesale_price = '2.66', on_sale = '0', price = '6.557377049180328' WHERE id_product = '19786' 07/10/2022 04:45:52 pm >> UPDATE ps_product_shop SET wholesale_price = '2.66', price = '6.557377049180328', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19786' 07/10/2022 04:45:52 pm >> DELETE FROM ps_specific_price WHERE id_product = '19786' 07/10/2022 04:46:00 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002034' AND id_product != '20073' AND ean13 != '' 07/10/2022 04:46:00 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002034', date_upd = NOW() WHERE id_product = '20073' 07/10/2022 04:46:00 pm >> UPDATE ps_product_lang SET name = 'ROSARIO CRISTALLO - 01M46', description = '' WHERE id_product = '20073' 07/10/2022 04:46:00 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7.786885245901639' WHERE id_product = '20073' 07/10/2022 04:46:00 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7.786885245901639', id_tax_rules_group = '1', id_category_default = '421', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20073' 07/10/2022 04:46:00 pm >> DELETE FROM ps_specific_price WHERE id_product = '20073' 07/10/2022 04:46:19 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 ( '31' , '1119/2022' , '2022-09-28' , '2022' , '0' , '113' , '4669149' , 'VIA VALLE CALDA, 7 16013 CAMPO LIGURE' , '' , '' , '0.01' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '1428.01' , '1170.51' , NOW() , NOW() ) 07/10/2022 04:46:19 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 = '65214' 07/10/2022 04:46:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '65214' 07/10/2022 04:46:19 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 ( '65214' , '18762' , 'BRACCIALE ARG. - 1568/1570' , '2' , '2' , '1' , '14.85' , '12.172131147541' , '22' , '5' , '34.4223' ) 07/10/2022 04:46:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18762' AND id_supplier = '113' 07/10/2022 04:46:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18762' , '113' , '1' ) 07/10/2022 04:46:19 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 ( '65214' , '19780' , 'BRACCIALE ARGENTO/EMATITE' , '1' , '1' , '1' , '6.5' , '5.327868852459' , '22' , '5' , '7.5335' ) 07/10/2022 04:46:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19780' AND id_supplier = '113' 07/10/2022 04:46:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19780' , '113' , '1' ) 07/10/2022 04:46:19 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 ( '65214' , '20079' , 'ROSARIO ARGENTO' , '1' , '1' , '1' , '24.6' , '20.16393442623' , '22' , '5' , '28.5114' ) 07/10/2022 04:46:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20079' AND id_supplier = '113' 07/10/2022 04:46:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20079' , '113' , '1' ) 07/10/2022 04:46:19 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 ( '65214' , '20078' , 'ROSARIO ARGENTO' , '1' , '1' , '1' , '19.9' , '16.311475409836' , '22' , '5' , '23.0641' ) 07/10/2022 04:46:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20078' AND id_supplier = '113' 07/10/2022 04:46:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20078' , '113' , '1' ) 07/10/2022 04:46:19 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 ( '65214' , '20075' , 'ROSARIO ARGENTO/EMATITE' , '1' , '1' , '1' , '15.4' , '12.622950819672' , '22' , '5' , '17.8486' ) 07/10/2022 04:46:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20075' AND id_supplier = '113' 07/10/2022 04:46:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20075' , '113' , '1' ) 07/10/2022 04:46:19 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 ( '65214' , '18760' , 'BRACCIALE ARG - 1819' , '1' , '1' , '1' , '12.5' , '10.245901639344' , '22' , '5' , '14.4875' ) 07/10/2022 04:46:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18760' AND id_supplier = '113' 07/10/2022 04:46:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18760' , '113' , '1' ) 07/10/2022 04:46:19 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 ( '65214' , '20081' , 'BRACCIALE ARGENTO' , '1' , '1' , '1' , '9.1' , '7.4590163934426' , '22' , '5' , '10.5469' ) 07/10/2022 04:46:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20081' AND id_supplier = '113' 07/10/2022 04:46:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20081' , '113' , '1' ) 07/10/2022 04:46:19 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 ( '65214' , '19771' , 'ROSARIO ARGENTO/EMATITE' , '2' , '2' , '1' , '13.5' , '11.065573770492' , '22' , '5' , '31.2930' ) 07/10/2022 04:46:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19771' AND id_supplier = '113' 07/10/2022 04:46:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19771' , '113' , '1' ) 07/10/2022 04:46:19 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 ( '65214' , '20074' , 'ROSARIO ARG/PERLA/EMATITE ' , '1' , '1' , '1' , '18.6' , '15.245901639344' , '22' , '5' , '21.5574' ) 07/10/2022 04:46:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20074' AND id_supplier = '113' 07/10/2022 04:46:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20074' , '113' , '1' ) 07/10/2022 04:46:19 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 ( '65214' , '20076' , 'ROSARIO ARGENTO/QUARZO' , '1' , '1' , '1' , '20' , '16.393442622951' , '22' , '5' , '23.1800' ) 07/10/2022 04:46:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20076' AND id_supplier = '113' 07/10/2022 04:46:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20076' , '113' , '1' ) 07/10/2022 04:46:19 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 ( '65214' , '20060' , 'CALICE IN ARGENTO - 12097' , '1' , '1' , '1' , '697.1' , '571.39344262295' , '22' , '5' , '807.9389' ) 07/10/2022 04:46:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20060' AND id_supplier = '113' 07/10/2022 04:46:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20060' , '113' , '1' ) 07/10/2022 04:46:19 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 ( '65214' , '18336' , 'PATENA ARGENTO 800 - 12090/15' , '1' , '1' , '1' , '173.4' , '142.13114754098' , '22' , '5' , '200.9706' ) 07/10/2022 04:46:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18336' AND id_supplier = '113' 07/10/2022 04:46:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18336' , '113' , '1' ) 07/10/2022 04:46:19 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 ( '65214' , '20080' , 'ROSARIO ARGENTO/ULIVO' , '1' , '1' , '1' , '15.7' , '12.868852459016' , '22' , '5' , '18.1963' ) 07/10/2022 04:46:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20080' AND id_supplier = '113' 07/10/2022 04:46:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20080' , '113' , '1' ) 07/10/2022 04:46:19 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 ( '65214' , '20077' , 'BRACCIALE ARGENTO' , '2' , '2' , '1' , '9.4' , '7.7049180327869' , '22' , '5' , '21.7892' ) 07/10/2022 04:46:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20077' AND id_supplier = '113' 07/10/2022 04:46:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20077' , '113' , '1' ) 07/10/2022 04:46:19 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 ( '65214' , '19785' , 'ROSARIO MADREPERLA MM4 - 10M4' , '18' , '18' , '1' , '2.7' , '2.2131147540984' , '22' , '5' , '56.3274' ) 07/10/2022 04:46:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19785' AND id_supplier = '113' 07/10/2022 04:46:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19785' , '113' , '1' ) 07/10/2022 04:46:19 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 ( '65214' , '19786' , 'ROSARIO MADREPERLA MM5 - 10M5' , '10' , '10' , '1' , '2.8' , '2.2950819672131' , '22' , '5' , '32.4520' ) 07/10/2022 04:46:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19786' AND id_supplier = '113' 07/10/2022 04:46:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19786' , '113' , '1' ) 07/10/2022 04:46:20 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 ( '65214' , '20073' , 'ROSARIO CRISTALLO - 01M46' , '24' , '24' , '1' , '2.8' , '2.2950819672131' , '22' , '5' , '77.8848' ) 07/10/2022 04:46:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20073' AND id_supplier = '113' 07/10/2022 04:46:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20073' , '113' , '1' ) 07/10/2022 05:50:16 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'ptOZJ6Yaxoto1CTx' , NOW() , NOW() ) 07/10/2022 05:50:16 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3928' , '1' ) 07/10/2022 05:50:16 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3928' , '2' ) 07/10/2022 05:50:16 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3928' , '3' ) 07/10/2022 05:53:31 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3928' 07/10/2022 05:53:31 pm >> 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 ( '3928' , '10' , '137' , 'PARR. S. MARIA IN VAL VERDE' , 'DELL\'OSSO' , 'DON GIANNI ' , 'VIA VALERIANI 19' , '' , '40026' , 'IMOLA' , '' , '' , '3335984749' , '' , '90001800375' , NOW() , NOW() ) 07/10/2022 05:53:32 pm >> UPDATE ps_customer SET email = 'parrocchiavalverde@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3928' 07/10/2022 05:54:34 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3928' 07/10/2022 05:54:34 pm >> 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 ( '3928' , '10' , '137' , 'PARR. S. MARIA IN VAL VERDE' , 'DELL\'OSSO' , 'DON GIANNI ' , 'VIA VALERIANI 19' , '' , '40026' , 'IMOLA' , 'spedire a ZANELLI LUCIA VIA GOITO 4 400126 IMOLA BO' , '' , '3335984749' , '' , '90001800375' , NOW() , NOW() ) 07/10/2022 05:54:34 pm >> UPDATE ps_customer SET email = 'parrocchiavalverde@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3928' 07/10/2022 05:56:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '152' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-07') 07/10/2022 05:56:06 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' , '152' , '2022-10-07' , '' , '3928' , '0' , '4675448' , 'VIA VALERIANI 19 40026 IMOLA' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '50.90' , '50.90' , NOW() , NOW() ) 07/10/2022 05:56:06 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 = '65215' 07/10/2022 05:56:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '65215' 07/10/2022 05:56:06 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 ( '65215' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '20' , '-20' , '4' , '2.40' , '2.4' , '0' , '15' , '40.80' ) 07/10/2022 05:56:06 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 ( '65215' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '15' , '5.10' ) 07/10/2022 06:15:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '76/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-07') 07/10/2022 06:15:40 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 ( '24' , '76/A' , '2022-10-07' , 'A' , '483' , '0' , '4672000' , 'VIA CASSIA, 731 00189 ROMA' , '' , 'CONGREGAZIONE DEI PRETI DELLA DOTTRINA CRISTIANA - IBAN: IT06V0834289640012010000844' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '108.00' , '108.00' , NOW() , NOW() ) 07/10/2022 06:15:40 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 = '65216' 07/10/2022 06:15:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '65216' 07/10/2022 06:15:40 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 ( '65216' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '50' , '-50' , '4' , '1.60' , '1.6' , '0' , '15' , '68.00' ) 07/10/2022 06:15:40 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 ( '65216' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '10' , '-10' , '4' , '5.00' , '5' , '0' , '20' , '40.00' ) 07/10/2022 06:17:28 pm >> DELETE FROM ps_document WHERE id_document = '65216' 07/10/2022 06:17:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '65216' 07/10/2022 06:20:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '76/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-07') 07/10/2022 06:20:08 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 ( '24' , '76/A' , '2022-10-07' , 'A' , '949' , '0' , '4671033' , 'VIA P. PALMIERI, 39 10138 TORINO' , '' , 'CONGREGAZIONE DEI PRETI DELLA DOTTRINA CRISTIANA IBAN: IT06V0834289640012010000844' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '108.00' , '108.00' , NOW() , NOW() ) 07/10/2022 06:20:08 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 = '65217' 07/10/2022 06:20:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '65217' 07/10/2022 06:20:08 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 ( '65217' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '50' , '-50' , '4' , '1.60' , '1.6' , '0' , '15' , '68.00' ) 07/10/2022 06:20:08 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 ( '65217' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '10' , '-10' , '4' , '5.00' , '5' , '0' , '20' , '40.00' ) 07/10/2022 06:20:08 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 ( '65217' , '19911' , 'LIBRO AGENDA CATTOLICO 2023' , '4' , '-4' , '4' , '18.00' , '18' , '0' , '100' , '0.00' ) 07/10/2022 06:23:16 pm >> DELETE FROM ps_document WHERE id_document = '65217' 07/10/2022 06:23:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '65217' 07/10/2022 06:51:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '22/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-07') 07/10/2022 06:51:07 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 ( '22' , '22/S' , '2022-10-07' , 'S' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'venduto settembre 2022' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '2065.05' , '2065.05' , NOW() , NOW() ) 07/10/2022 06:51:07 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 = '7141' 07/10/2022 06:51:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '7141' 07/10/2022 06:51:07 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 ( '7141' , '9' , 'PSICOLOGIA PRATICA PER EDUCATORI' , '7' , '0' , '4' , '10.50' , '10.5' , '0' , '50' , '36.75' ) 07/10/2022 06:51:08 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 ( '7141' , '11' , 'COME PREPARARSI ALLA CONFESSIONE' , '1' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 07/10/2022 06:51:08 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 ( '7141' , '15' , 'LA BIBBIA: GENESI ALBUM+FIGURINE' , '1' , '0' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 07/10/2022 06:51:08 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 ( '7141' , '17' , 'LA FEDE NELLO ZAINETTO' , '38' , '0' , '4' , '5.00' , '5' , '0' , '50' , '95.00' ) 07/10/2022 06:51:08 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 ( '7141' , '20' , 'GIOVEDÌ SANTO' , '5' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '3.75' ) 07/10/2022 06:51:08 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 ( '7141' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '77' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '57.75' ) 07/10/2022 06:51:08 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 ( '7141' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '6' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '7.50' ) 07/10/2022 06:51:08 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 ( '7141' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '7' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '8.75' ) 07/10/2022 06:51:08 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 ( '7141' , '121' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '20' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '25.00' ) 07/10/2022 06:51:08 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 ( '7141' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '13' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '16.25' ) 07/10/2022 06:51:08 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 ( '7141' , '125' , 'MIE PREGHIERINE - N. E.' , '37' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '27.75' ) 07/10/2022 06:51:08 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 ( '7141' , '33' , '100 GIORNI CON LO SPIRITO' , '40' , '0' , '4' , '7.50' , '7.5' , '0' , '50' , '150.00' ) 07/10/2022 06:51:08 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 ( '7141' , '35' , 'ANGELI - I NOSTRI MIGLIORI AMICI' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 07/10/2022 06:51:08 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 ( '7141' , '40' , 'A TAVOLA CON GESU' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 07/10/2022 06:51:08 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 ( '7141' , '56' , 'MARIA LA MAMMA DI GESU' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 07/10/2022 06:51:08 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 ( '7141' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '30' , '0' , '4' , '2.00' , '2' , '0' , '50' , '30.00' ) 07/10/2022 06:51:08 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 ( '7141' , '62' , 'GIOVANNI XXIII° SANTO .....IL PAPA BUONO' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 07/10/2022 06:51:08 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 ( '7141' , '66' , 'BEATI GLI INVITATI ALLA CENA DEL SIGNORE' , '2' , '0' , '4' , '6.50' , '6.5' , '0' , '50' , '6.50' ) 07/10/2022 06:51:08 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 ( '7141' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '7' , '0' , '4' , '2.00' , '2' , '0' , '50' , '7.00' ) 07/10/2022 06:51:08 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 ( '7141' , '72' , 'FEDE, SPERANZA E CARITA' , '1' , '0' , '4' , '6.00' , '6' , '0' , '50' , '3.00' ) 07/10/2022 06:51:08 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 ( '7141' , '75' , 'IL SEGNO DELLA CROCE' , '20' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '15.00' ) 07/10/2022 06:51:08 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 ( '7141' , '92' , 'LA PREGHIERA DEL ROSARIO' , '10' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '12.50' ) 07/10/2022 06:51:08 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 ( '7141' , '99' , 'AVE MARIA PREGHIERE MARIANE' , '5' , '0' , '4' , '2.00' , '2' , '0' , '50' , '5.00' ) 07/10/2022 06:51:08 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 ( '7141' , '101' , 'GESU BENEDICI LA NOSTRA FAMIGLIA' , '5' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '3.75' ) 07/10/2022 06:51:08 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 ( '7141' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '7' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '8.75' ) 07/10/2022 06:51:08 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 ( '7141' , '110' , 'SE MI AMI NON PIANGERE' , '10' , '0' , '4' , '1.5' , '1.5' , '0' , '50' , '7.50' ) 07/10/2022 06:51:08 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 ( '7141' , '111' , 'I NONNI SONO UN TESORO' , '102' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '91.80' ) 07/10/2022 06:51:08 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 ( '7141' , '123' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '20' , '0' , '4' , '3.00' , '3' , '0' , '50' , '30.00' ) 07/10/2022 06:51:08 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 ( '7141' , '114' , 'Le preghiere dei ragazzi' , '1' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 07/10/2022 06:51:08 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 ( '7141' , '115' , 'SAN FRANCESCO DASSISI RACCONTATO AI RAGAZZI N.E.' , '79' , '0' , '4' , '4.00' , '4' , '0' , '50' , '158.00' ) 07/10/2022 06:51:08 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 ( '7141' , '117' , 'La preghiera delle cinque dita n.e.' , '25' , '0' , '4' , '1.5' , '1.5' , '0' , '50' , '18.75' ) 07/10/2022 06:51:08 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 ( '7141' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '19' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '23.75' ) 07/10/2022 06:51:08 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 ( '7141' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '45' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '56.25' ) 07/10/2022 06:51:08 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 ( '7141' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '126' , '0' , '4' , '18.00' , '18' , '0' , '50' , '1134.00' ) 07/10/2022 06:51:08 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 ( '7141' , '126' , 'SACRAMENTO DEL PERDONO' , '11' , '0' , '4' , '2.00' , '2' , '0' , '50' , '11.00' ) 07/10/2022 06:55:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '23/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-07') 07/10/2022 06:55:26 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 ( '25' , '23/S' , '2022-10-07' , 'S' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'resa settembre 2022' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '105.70' , '105.70' , NOW() , NOW() ) 07/10/2022 06:55:26 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 = '7142' 07/10/2022 06:55:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '7142' 07/10/2022 06:55:26 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 ( '7142' , '11' , 'COME PREPARARSI ALLA CONFESSIONE' , '1' , '1' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 07/10/2022 06:55:26 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 ( '7142' , '17' , 'LA FEDE NELLO ZAINETTO' , '2' , '2' , '4' , '5.00' , '5' , '0' , '50' , '5.00' ) 07/10/2022 06:55:26 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 ( '7142' , '20' , 'GIOVEDÌ SANTO' , '11' , '11' , '4' , '1.50' , '1.5' , '0' , '50' , '8.25' ) 07/10/2022 06:55:26 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 ( '7142' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '10' , '10' , '4' , '1.50' , '1.5' , '0' , '50' , '7.50' ) 07/10/2022 06:55:26 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 ( '7142' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '3' , '3' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 07/10/2022 06:55:26 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 ( '7142' , '54' , 'BENEDETTO XVI ° ..... UNA PAGINA DI STORIA' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 07/10/2022 06:55:26 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 ( '7142' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '24' , '24' , '4' , '2.00' , '2' , '0' , '50' , '24.00' ) 07/10/2022 06:55:26 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 ( '7142' , '75' , 'IL SEGNO DELLA CROCE' , '5' , '5' , '4' , '1.50' , '1.5' , '0' , '50' , '3.75' ) 07/10/2022 06:55:26 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 ( '7142' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '18' , '18' , '4' , '2.50' , '2.5' , '0' , '50' , '22.50' ) 07/10/2022 06:55:26 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 ( '7142' , '110' , 'SE MI AMI NON PIANGERE' , '3' , '3' , '4' , '1.80' , '1.8' , '0' , '50' , '2.70' ) 07/10/2022 06:55:26 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 ( '7142' , '123' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '2' , '2' , '4' , '3.00' , '3' , '0' , '50' , '3.00' ) 07/10/2022 06:55:26 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 ( '7142' , '114' , 'Le preghiere dei ragazzi' , '1' , '1' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 07/10/2022 06:55:26 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 ( '7142' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '6' , '6' , '4' , '2.50' , '2.5' , '0' , '50' , '7.50' ) 07/10/2022 06:55:26 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 ( '7142' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '4' , '4' , '4' , '3.00' , '3' , '0' , '50' , '6.00' ) 07/10/2022 06:55:26 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 ( '7142' , '126' , 'SACRAMENTO DEL PERDONO' , '9' , '9' , '4' , '2.00' , '2' , '0' , '50' , '9.00' ) 07/10/2022 07:18:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '39/E' AND id_document != '65193' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-06') 07/10/2022 07:18:40 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '39/E', document_date = '2022-10-06', document_letter = 'E', id_customer = '189', id_supplier = '', id_address = '4670598', address1 = 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '1596.50', price_tax_excluded = '1596.50', date_upd = NOW() WHERE id_document = '65193' 07/10/2022 07:18:40 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 = '65193' 07/10/2022 07:18:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '65193' 07/10/2022 07:18:40 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 ( '65193' , '5457' , 'IO SONO CON VOI 1 PARTE' , '600' , '-600' , '4' , '2.5000' , '2.5' , '0' , '38' , '930.00' ) 07/10/2022 07:18:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 07/10/2022 07:18:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 07/10/2022 07:18:40 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 ( '65193' , '11191' , 'VENITE CON ME 1 PARTE' , '360' , '-360' , '4' , '2.5000' , '2.5' , '0' , '38' , '558.00' ) 07/10/2022 07:18:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11191' AND id_supplier = '' 07/10/2022 07:18:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11191' , '' , '1' ) 07/10/2022 07:18:40 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 ( '65193' , '2679' , 'CONOSCERE GESU\'' , '50' , '-50' , '4' , '3.5000' , '3.5' , '0' , '38' , '108.50' ) 07/10/2022 07:18:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 07/10/2022 07:18:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 07/10/2022 07:23:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '22/S' AND id_document != '7141' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-07') 07/10/2022 07:23:49 pm >> UPDATE ps_document SET id_document_type = '22', document_num = '22/S', document_date = '2022-10-07', document_letter = 'S', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'VENDUTO SETTEMBRE 2022', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '14', id_causal = '0', price_tax_included = '2065.05', price_tax_excluded = '2065.05', date_upd = NOW() WHERE id_document = '7141' 07/10/2022 07:23:49 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 = '7141' 07/10/2022 07:23:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '7141' 07/10/2022 07:23:49 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 ( '7141' , '9' , 'PSICOLOGIA PRATICA PER EDUCATORI' , '7' , '0' , '4' , '10.5000' , '10.5' , '0' , '50' , '36.75' ) 07/10/2022 07:23:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9' AND id_supplier = '' 07/10/2022 07:23:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9' , '' , '1' ) 07/10/2022 07:23:50 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 ( '7141' , '11' , 'COME PREPARARSI ALLA CONFESSIONE' , '1' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '0.75' ) 07/10/2022 07:23:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11' AND id_supplier = '' 07/10/2022 07:23:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11' , '' , '1' ) 07/10/2022 07:23:50 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 ( '7141' , '15' , 'LA BIBBIA: GENESI ALBUM+FIGURINE' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '50' , '7.50' ) 07/10/2022 07:23:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15' AND id_supplier = '' 07/10/2022 07:23:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15' , '' , '1' ) 07/10/2022 07:23:50 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 ( '7141' , '17' , 'LA FEDE NELLO ZAINETTO' , '38' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '95.00' ) 07/10/2022 07:23:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17' AND id_supplier = '' 07/10/2022 07:23:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17' , '' , '1' ) 07/10/2022 07:23:50 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 ( '7141' , '20' , 'GIOVEDÌ SANTO' , '5' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '3.75' ) 07/10/2022 07:23:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20' AND id_supplier = '' 07/10/2022 07:23:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20' , '' , '1' ) 07/10/2022 07:23:50 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 ( '7141' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '77' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '57.75' ) 07/10/2022 07:23:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '124' AND id_supplier = '' 07/10/2022 07:23:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '124' , '' , '1' ) 07/10/2022 07:23:50 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 ( '7141' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '6' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '7.50' ) 07/10/2022 07:23:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23' AND id_supplier = '' 07/10/2022 07:23:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23' , '' , '1' ) 07/10/2022 07:23:50 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 ( '7141' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '7' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '8.75' ) 07/10/2022 07:23:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24' AND id_supplier = '' 07/10/2022 07:23:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24' , '' , '1' ) 07/10/2022 07:23:50 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 ( '7141' , '121' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '20' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '25.00' ) 07/10/2022 07:23:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '121' AND id_supplier = '' 07/10/2022 07:23:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '121' , '' , '1' ) 07/10/2022 07:23:50 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 ( '7141' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '13' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '16.25' ) 07/10/2022 07:23:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '130' AND id_supplier = '' 07/10/2022 07:23:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '130' , '' , '1' ) 07/10/2022 07:23:51 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 ( '7141' , '125' , 'MIE PREGHIERINE - N. E.' , '37' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '27.75' ) 07/10/2022 07:23:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '125' AND id_supplier = '' 07/10/2022 07:23:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '125' , '' , '1' ) 07/10/2022 07:23:51 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 ( '7141' , '33' , '100 GIORNI CON LO SPIRITO' , '40' , '0' , '4' , '7.5000' , '7.5' , '0' , '50' , '150.00' ) 07/10/2022 07:23:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '33' AND id_supplier = '' 07/10/2022 07:23:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '33' , '' , '1' ) 07/10/2022 07:23:51 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 ( '7141' , '35' , 'ANGELI - I NOSTRI MIGLIORI AMICI' , '1' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 07/10/2022 07:23:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '35' AND id_supplier = '' 07/10/2022 07:23:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '35' , '' , '1' ) 07/10/2022 07:23:51 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 ( '7141' , '40' , 'A TAVOLA CON GESU' , '1' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 07/10/2022 07:23:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '40' AND id_supplier = '' 07/10/2022 07:23:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '40' , '' , '1' ) 07/10/2022 07:23:51 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 ( '7141' , '56' , 'MARIA LA MAMMA DI GESU' , '1' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 07/10/2022 07:23:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '56' AND id_supplier = '' 07/10/2022 07:23:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '56' , '' , '1' ) 07/10/2022 07:23:51 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 ( '7141' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '30' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '30.00' ) 07/10/2022 07:23:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '57' AND id_supplier = '' 07/10/2022 07:23:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '57' , '' , '1' ) 07/10/2022 07:23:51 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 ( '7141' , '62' , 'GIOVANNI XXIII° SANTO .....IL PAPA BUONO' , '1' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 07/10/2022 07:23:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '62' AND id_supplier = '' 07/10/2022 07:23:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '62' , '' , '1' ) 07/10/2022 07:23:52 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 ( '7141' , '66' , 'BEATI GLI INVITATI ALLA CENA DEL SIGNORE' , '2' , '0' , '4' , '6.5000' , '6.5' , '0' , '50' , '6.50' ) 07/10/2022 07:23:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '66' AND id_supplier = '' 07/10/2022 07:23:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '66' , '' , '1' ) 07/10/2022 07:23:52 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 ( '7141' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '7' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '7.00' ) 07/10/2022 07:23:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '67' AND id_supplier = '' 07/10/2022 07:23:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '67' , '' , '1' ) 07/10/2022 07:23:52 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 ( '7141' , '72' , 'FEDE, SPERANZA E CARITA' , '1' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '3.00' ) 07/10/2022 07:23:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '72' AND id_supplier = '' 07/10/2022 07:23:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '72' , '' , '1' ) 07/10/2022 07:23:52 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 ( '7141' , '75' , 'IL SEGNO DELLA CROCE' , '20' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '15.00' ) 07/10/2022 07:23:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '75' AND id_supplier = '' 07/10/2022 07:23:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '75' , '' , '1' ) 07/10/2022 07:23:52 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 ( '7141' , '92' , 'LA PREGHIERA DEL ROSARIO' , '10' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '12.50' ) 07/10/2022 07:23:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '92' AND id_supplier = '' 07/10/2022 07:23:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '92' , '' , '1' ) 07/10/2022 07:23:52 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 ( '7141' , '99' , 'AVE MARIA PREGHIERE MARIANE' , '5' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '5.00' ) 07/10/2022 07:23:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '99' AND id_supplier = '' 07/10/2022 07:23:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '99' , '' , '1' ) 07/10/2022 07:23:52 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 ( '7141' , '101' , 'GESU BENEDICI LA NOSTRA FAMIGLIA' , '5' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '3.75' ) 07/10/2022 07:23:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '101' AND id_supplier = '' 07/10/2022 07:23:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '101' , '' , '1' ) 07/10/2022 07:23:53 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 ( '7141' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '7' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '8.75' ) 07/10/2022 07:23:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '127' AND id_supplier = '' 07/10/2022 07:23:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '127' , '' , '1' ) 07/10/2022 07:23:53 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 ( '7141' , '110' , 'SE MI AMI NON PIANGERE' , '10' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '7.50' ) 07/10/2022 07:23:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '110' AND id_supplier = '' 07/10/2022 07:23:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '110' , '' , '1' ) 07/10/2022 07:23:53 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 ( '7141' , '111' , 'I NONNI SONO UN TESORO' , '102' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '91.80' ) 07/10/2022 07:23:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '111' AND id_supplier = '' 07/10/2022 07:23:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '111' , '' , '1' ) 07/10/2022 07:23:53 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 ( '7141' , '123' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '20' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '30.00' ) 07/10/2022 07:23:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '123' AND id_supplier = '' 07/10/2022 07:23:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '123' , '' , '1' ) 07/10/2022 07:23:53 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 ( '7141' , '114' , 'Le preghiere dei ragazzi' , '1' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '0.75' ) 07/10/2022 07:23:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '114' AND id_supplier = '' 07/10/2022 07:23:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '114' , '' , '1' ) 07/10/2022 07:23:53 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 ( '7141' , '115' , 'SAN FRANCESCO DASSISI RACCONTATO AI RAGAZZI N.E.' , '79' , '0' , '4' , '4.0000' , '4' , '0' , '50' , '158.00' ) 07/10/2022 07:23:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '115' AND id_supplier = '' 07/10/2022 07:23:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '115' , '' , '1' ) 07/10/2022 07:23:53 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 ( '7141' , '117' , 'La preghiera delle cinque dita n.e.' , '25' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '18.75' ) 07/10/2022 07:23:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '117' AND id_supplier = '' 07/10/2022 07:23:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '117' , '' , '1' ) 07/10/2022 07:23:53 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 ( '7141' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '19' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '23.75' ) 07/10/2022 07:23:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '118' AND id_supplier = '' 07/10/2022 07:23:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '118' , '' , '1' ) 07/10/2022 07:23: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 ( '7141' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '45' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '56.25' ) 07/10/2022 07:23:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '132' AND id_supplier = '' 07/10/2022 07:23:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '132' , '' , '1' ) 07/10/2022 07:23: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 ( '7141' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '126' , '0' , '4' , '18.0000' , '18' , '0' , '50' , '1134.00' ) 07/10/2022 07:23:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '133' AND id_supplier = '' 07/10/2022 07:23:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '133' , '' , '1' ) 07/10/2022 07:23: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 ( '7141' , '126' , 'SACRAMENTO DEL PERDONO' , '11' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '11.00' ) 07/10/2022 07:23:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '126' AND id_supplier = '' 07/10/2022 07:23:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '126' , '' , '1' ) 07/10/2022 07:29:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '2971' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-07') 07/10/2022 07:29:20 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' , '2971' , '2022-10-07' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 07/10/2022 07:29:20 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 = '65218' 07/10/2022 07:29:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '65218' 07/10/2022 07:29:20 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 ( '65218' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 07/10/2022 07:29:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11097' AND id_supplier = '' 07/10/2022 07:29:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11097' , '' , '1' ) 07/10/2022 07:29:20 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 ( '65218' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 07/10/2022 07:29:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 07/10/2022 07:29:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 07/10/2022 07:31:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '23/S' AND id_document != '7142' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-07') 07/10/2022 07:31:55 pm >> UPDATE ps_document SET id_document_type = '25', document_num = '23/S', document_date = '2022-10-07', document_letter = 'S', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'RESA SETTEMBRE 2022', 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 = '105.70', price_tax_excluded = '105.70', date_upd = NOW() WHERE id_document = '7142' 07/10/2022 07:31:56 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 = '7142' 07/10/2022 07:31:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '7142' 07/10/2022 07:31:56 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 ( '7142' , '11' , 'COME PREPARARSI ALLA CONFESSIONE' , '1' , '1' , '4' , '1.5000' , '1.5' , '0' , '50' , '0.75' ) 07/10/2022 07:31:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11' AND id_supplier = '' 07/10/2022 07:31:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11' , '' , '1' ) 07/10/2022 07:31:56 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 ( '7142' , '17' , 'LA FEDE NELLO ZAINETTO' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 07/10/2022 07:31:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17' AND id_supplier = '' 07/10/2022 07:31:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17' , '' , '1' ) 07/10/2022 07:31:56 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 ( '7142' , '20' , 'GIOVEDÌ SANTO' , '11' , '11' , '4' , '1.5000' , '1.5' , '0' , '50' , '8.25' ) 07/10/2022 07:31:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20' AND id_supplier = '' 07/10/2022 07:31:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20' , '' , '1' ) 07/10/2022 07:31:56 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 ( '7142' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '10' , '10' , '4' , '1.5000' , '1.5' , '0' , '50' , '7.50' ) 07/10/2022 07:31:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '124' AND id_supplier = '' 07/10/2022 07:31:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '124' , '' , '1' ) 07/10/2022 07:31:56 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 ( '7142' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '3' , '3' , '4' , '2.5000' , '2.5' , '0' , '50' , '3.75' ) 07/10/2022 07:31:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24' AND id_supplier = '' 07/10/2022 07:31:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24' , '' , '1' ) 07/10/2022 07:31:56 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 ( '7142' , '54' , 'BENEDETTO XVI ° ..... UNA PAGINA DI STORIA' , '1' , '1' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 07/10/2022 07:31:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '54' AND id_supplier = '' 07/10/2022 07:31:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '54' , '' , '1' ) 07/10/2022 07:31:57 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 ( '7142' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '24' , '24' , '4' , '2.0000' , '2' , '0' , '50' , '24.00' ) 07/10/2022 07:31:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '67' AND id_supplier = '' 07/10/2022 07:31:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '67' , '' , '1' ) 07/10/2022 07:31:57 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 ( '7142' , '75' , 'IL SEGNO DELLA CROCE' , '5' , '5' , '4' , '1.5000' , '1.5' , '0' , '50' , '3.75' ) 07/10/2022 07:31:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '75' AND id_supplier = '' 07/10/2022 07:31:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '75' , '' , '1' ) 07/10/2022 07:31:57 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 ( '7142' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '18' , '18' , '4' , '2.5000' , '2.5' , '0' , '50' , '22.50' ) 07/10/2022 07:31:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '127' AND id_supplier = '' 07/10/2022 07:31:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '127' , '' , '1' ) 07/10/2022 07:31:57 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 ( '7142' , '110' , 'SE MI AMI NON PIANGERE' , '3' , '3' , '4' , '1.8000' , '1.8' , '0' , '50' , '2.70' ) 07/10/2022 07:31:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '110' AND id_supplier = '' 07/10/2022 07:31:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '110' , '' , '1' ) 07/10/2022 07:31:57 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 ( '7142' , '123' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '2' , '2' , '4' , '3.0000' , '3' , '0' , '50' , '3.00' ) 07/10/2022 07:31:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '123' AND id_supplier = '' 07/10/2022 07:31:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '123' , '' , '1' ) 07/10/2022 07:31:57 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 ( '7142' , '114' , 'Le preghiere dei ragazzi' , '1' , '1' , '4' , '1.5000' , '1.5' , '0' , '50' , '0.75' ) 07/10/2022 07:31:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '114' AND id_supplier = '' 07/10/2022 07:31:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '114' , '' , '1' ) 07/10/2022 07:31:58 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 ( '7142' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '6' , '6' , '4' , '2.5000' , '2.5' , '0' , '50' , '7.50' ) 07/10/2022 07:31:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '118' AND id_supplier = '' 07/10/2022 07:31:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '118' , '' , '1' ) 07/10/2022 07:31:58 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 ( '7142' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '4' , '4' , '4' , '3.0000' , '3' , '0' , '50' , '6.00' ) 07/10/2022 07:31:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '129' AND id_supplier = '' 07/10/2022 07:31:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '129' , '' , '1' ) 07/10/2022 07:31:58 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 ( '7142' , '126' , 'SACRAMENTO DEL PERDONO' , '9' , '9' , '4' , '2.0000' , '2' , '0' , '50' , '9.00' ) 07/10/2022 07:31:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '126' AND id_supplier = '' 07/10/2022 07:31:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '126' , '' , '1' ) 07/10/2022 07:56:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '2793' AND id_document != '61880' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-20') 07/10/2022 07:56:53 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2793', document_date = '2022-09-20', 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 = '348.51', price_tax_excluded = '341.18', date_upd = NOW() WHERE id_document = '61880' 07/10/2022 07:56:53 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 = '61880' 07/10/2022 07:56:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '61880' 07/10/2022 07:56:53 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 ( '61880' , '1671' , 'CANTICO DEI CANTICI - RIL.' , '1' , '-1' , '4' , '39.0000' , '39' , '0' , '5' , '37.05' ) 07/10/2022 07:56:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1671' AND id_supplier = '' 07/10/2022 07:56:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1671' , '' , '1' ) 07/10/2022 07:56:53 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 ( '61880' , '14439' , 'CARLO MARIA MARTINI' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '5' , '7.51' ) 07/10/2022 07:56:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14439' AND id_supplier = '' 07/10/2022 07:56:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14439' , '' , '1' ) 07/10/2022 07:56:53 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 ( '61880' , '14440' , 'GINO BARTALI' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '5' , '7.51' ) 07/10/2022 07:56:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14440' AND id_supplier = '' 07/10/2022 07:56:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14440' , '' , '1' ) 07/10/2022 07:56:53 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 ( '61880' , '14441' , 'LORENZO MILANI' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '5' , '7.51' ) 07/10/2022 07:56:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14441' AND id_supplier = '' 07/10/2022 07:56:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14441' , '' , '1' ) 07/10/2022 07:56:53 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 ( '61880' , '14442' , 'MALALA' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '5' , '7.51' ) 07/10/2022 07:56:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14442' AND id_supplier = '' 07/10/2022 07:56:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14442' , '' , '1' ) 07/10/2022 07:56:53 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 ( '61880' , '14443' , 'MARCELLO CANDIA' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '5' , '7.51' ) 07/10/2022 07:56:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14443' AND id_supplier = '' 07/10/2022 07:56:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14443' , '' , '1' ) 07/10/2022 07:56:53 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 ( '61880' , '14445' , 'CHIARA LUBICH' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '5' , '7.51' ) 07/10/2022 07:56:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14445' AND id_supplier = '' 07/10/2022 07:56:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14445' , '' , '1' ) 07/10/2022 07:56:53 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 ( '61880' , '14444' , 'CARLO GNOCCHI' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '5' , '7.51' ) 07/10/2022 07:56:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14444' AND id_supplier = '' 07/10/2022 07:56:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14444' , '' , '1' ) 07/10/2022 07:56:53 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 ( '61880' , '14446' , 'EUGENIA BONETTI' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '5' , '7.51' ) 07/10/2022 07:56:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14446' AND id_supplier = '' 07/10/2022 07:56:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14446' , '' , '1' ) 07/10/2022 07:56:53 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 ( '61880' , '14447' , 'ROSARIO LIVATINO' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '5' , '7.51' ) 07/10/2022 07:56:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14447' AND id_supplier = '' 07/10/2022 07:56:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14447' , '' , '1' ) 07/10/2022 07:56:53 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 ( '61880' , '14448' , 'GIORGIO LA PIRA' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '5' , '7.51' ) 07/10/2022 07:56:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14448' AND id_supplier = '' 07/10/2022 07:56:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14448' , '' , '1' ) 07/10/2022 07:56: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 ( '61880' , '19482' , 'MARIA NELLA NOTTE DELLA FEDE - M. T. DI CALCUTTA' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '5' , '7.51' ) 07/10/2022 07:56:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19482' AND id_supplier = '' 07/10/2022 07:56:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19482' , '' , '1' ) 07/10/2022 07:56: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 ( '61880' , '19484' , 'DONO DI LIBERTA - M. KOLBE' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '5' , '7.51' ) 07/10/2022 07:56:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19484' AND id_supplier = '' 07/10/2022 07:56:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19484' , '' , '1' ) 07/10/2022 07:56: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 ( '61880' , '19764' , 'PRIMO PASSO - TACCUINO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 07/10/2022 07:56:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19764' AND id_supplier = '' 07/10/2022 07:56:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19764' , '' , '1' ) 07/10/2022 07:56: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 ( '61880' , '19765' , 'TUTTI I SANTI GIORNI - GUIDA' , '1' , '-1' , '4' , '11.5000' , '11.5' , '0' , '5' , '10.93' ) 07/10/2022 07:56:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19765' AND id_supplier = '' 07/10/2022 07:56:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19765' , '' , '1' ) 07/10/2022 07:56: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 ( '61880' , '19759' , 'RAGAZZI CHE SQUADRA - 2' , '1' , '-1' , '4' , '16.5000' , '16.5' , '0' , '5' , '15.68' ) 07/10/2022 07:56:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19759' AND id_supplier = '' 07/10/2022 07:56:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19759' , '' , '1' ) 07/10/2022 07:56: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 ( '61880' , '19760' , 'RAGAZZI CHE SQUADRA - 3' , '1' , '-1' , '4' , '16.5000' , '16.5' , '0' , '5' , '15.68' ) 07/10/2022 07:56:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19760' AND id_supplier = '' 07/10/2022 07:56:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19760' , '' , '1' ) 07/10/2022 07:56: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 ( '61880' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '5' , '-5' , '4' , '5.00' , '5' , '0' , '5' , '23.75' ) 07/10/2022 07:56:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 07/10/2022 07:56:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 07/10/2022 07:56: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 ( '61880' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '1' , '-1' , '1' , '0.8000' , '0.65573770491803' , '22' , '0' , '0.80' ) 07/10/2022 07:56:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17004' AND id_supplier = '' 07/10/2022 07:56:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17004' , '' , '1' ) 07/10/2022 07:56: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 ( '61880' , '19202' , 'LETTERA AGLI SPOSI' , '6' , '-6' , '4' , '3.0000' , '3' , '0' , '5' , '17.10' ) 07/10/2022 07:56:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19202' AND id_supplier = '' 07/10/2022 07:56:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19202' , '' , '1' ) 07/10/2022 07:56: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 ( '61880' , '19542' , 'LETTERA AGLI SPOSI' , '4' , '-4' , '4' , '3.5000' , '3.5' , '0' , '5' , '13.32' ) 07/10/2022 07:56:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19542' AND id_supplier = '' 07/10/2022 07:56:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19542' , '' , '1' ) 07/10/2022 07:56:55 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 ( '61880' , '13005' , 'PASSAPORTO DEL CATECHISTA' , '13' , '-13' , '4' , '1.2000' , '1.2' , '0' , '0' , '15.60' ) 07/10/2022 07:56:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13005' AND id_supplier = '' 07/10/2022 07:56:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13005' , '' , '1' ) 07/10/2022 07:56:55 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 ( '61880' , '18376' , 'NOSTALGIA DEL PANE - L. EPICOCO' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.76' ) 07/10/2022 07:56:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18376' AND id_supplier = '' 07/10/2022 07:56:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18376' , '' , '1' ) 07/10/2022 07:56:55 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 ( '61880' , '18377' , 'CHI RESTA SALDO? - E. BIANCHI' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.76' ) 07/10/2022 07:56:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18377' AND id_supplier = '' 07/10/2022 07:56:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18377' , '' , '1' ) 07/10/2022 07:56:55 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 ( '61880' , '18378' , 'RAGIONE E IL CORAGGIO - A. COMASTRI' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.76' ) 07/10/2022 07:56:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18378' AND id_supplier = '' 07/10/2022 07:56:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18378' , '' , '1' ) 07/10/2022 07:56:55 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 ( '61880' , '18379' , 'STUPIDITA - D. BONHOEFFER' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.76' ) 07/10/2022 07:56:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18379' AND id_supplier = '' 07/10/2022 07:56:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18379' , '' , '1' ) 07/10/2022 07:56:55 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 ( '61880' , '18381' , 'DIREZIONE PER CUI SI AVANZA - A. CANOPI' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.76' ) 07/10/2022 07:56:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18381' AND id_supplier = '' 07/10/2022 07:56:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18381' , '' , '1' ) 07/10/2022 07:56:55 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 ( '61880' , '18380' , 'BELLEZZA DELLORDINE - S. WEIL' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.76' ) 07/10/2022 07:56:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18380' AND id_supplier = '' 07/10/2022 07:56:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18380' , '' , '1' ) 07/10/2022 07:56:55 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 ( '61880' , '18382' , 'MADRE E IL FIGLIO - G. RAVASI' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.76' ) 07/10/2022 07:56:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18382' AND id_supplier = '' 07/10/2022 07:56:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18382' , '' , '1' ) 07/10/2022 07:56:55 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 ( '61880' , '18383' , 'TALENTO DI VIVERE TUTTO - E. HILLESUM' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.76' ) 07/10/2022 07:56:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18383' AND id_supplier = '' 07/10/2022 07:56:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18383' , '' , '1' ) 07/10/2022 07:56:55 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 ( '61880' , '18384' , 'SULLE TRACCE DI GESU - C. MARTINI' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.76' ) 07/10/2022 07:56:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18384' AND id_supplier = '' 07/10/2022 07:56:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18384' , '' , '1' ) 07/10/2022 07:56:55 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 ( '61880' , '18385' , 'LETTERA A GESU NEL DESERTO - T. BELLO' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.76' ) 07/10/2022 07:56:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18385' AND id_supplier = '' 07/10/2022 07:56:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18385' , '' , '1' ) 07/10/2022 07:56:56 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 ( '61880' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '4.00' ) 07/10/2022 07:56:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 07/10/2022 07:56:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 07/10/2022 07:56:56 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 ( '61880' , '5559' , 'LASCIATE CHE I BAMBINI VENGANO A ME' , '6' , '-6' , '4' , '5.5000' , '5.5' , '0' , '5' , '31.38' ) 07/10/2022 07:56:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5559' AND id_supplier = '' 07/10/2022 07:56:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5559' , '' , '1' ) 07/10/2022 07:56:56 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 ( '61880' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.75' , '1.75' , '0' , '0' , '1.75' ) 07/10/2022 07:56:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 07/10/2022 07:56:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 07/10/2022 07:56:56 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 ( '61880' , '9948' , 'SFERA DIAMETRO MM 100' , '6' , '-6' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '39.00' ) 07/10/2022 07:56:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9948' AND id_supplier = '' 07/10/2022 07:56:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9948' , '' , '1' ) 07/10/2022 07:57:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '2744' AND id_document != '61811' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-15') 07/10/2022 07:57:17 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2744', document_date = '2022-09-15', 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 = '313.40', price_tax_excluded = '263.92', date_upd = NOW() WHERE id_document = '61811' 07/10/2022 07:57:17 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 = '61811' 07/10/2022 07:57:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '61811' 07/10/2022 07:57:18 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 ( '61811' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '50.00' ) 07/10/2022 07:57:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15387' AND id_supplier = '' 07/10/2022 07:57:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15387' , '' , '1' ) 07/10/2022 07:57:18 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 ( '61811' , '18401' , 'CAMICE CON TRAMEZZO - 406TPACQ' , '1' , '-1' , '1' , '155.0000' , '127.04918032787' , '22' , '0' , '155.00' ) 07/10/2022 07:57:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18401' AND id_supplier = '' 07/10/2022 07:57:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18401' , '' , '1' ) 07/10/2022 07:57:18 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 ( '61811' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '2' , '-2' , '4' , '4.5' , '4.5' , '0' , '0' , '9.00' ) 07/10/2022 07:57:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 07/10/2022 07:57:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 07/10/2022 07:57:18 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 ( '61811' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '4.00' ) 07/10/2022 07:57:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 07/10/2022 07:57:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 07/10/2022 07:57:18 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 ( '61811' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 07/10/2022 07:57:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 07/10/2022 07:57:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 07/10/2022 07:57:18 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 ( '61811' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 07/10/2022 07:57:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 07/10/2022 07:57:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 07/10/2022 07:57:18 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 ( '61811' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 07/10/2022 07:57:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 07/10/2022 07:57:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 07/10/2022 07:57:18 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 ( '61811' , '15188' , 'TRE LETTERE DI GIOVANNI - G. ZEVINI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 07/10/2022 07:57:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15188' AND id_supplier = '' 07/10/2022 07:57:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15188' , '' , '1' )