18/03/2023 08:42:21 am >> SELECT document_num FROM ps_document WHERE document_num = '9' AND id_document != '81356' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-02-14') 18/03/2023 08:42:22 am >> UPDATE ps_document SET id_document_type = '24', document_num = '9', document_date = '2023-02-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2642', address1 = 'V.LE BACCHIGLIONE, 20 20139 MILANO', address2 = '', note = 'RESA - n. c. ricevuta', 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 = '173.30', price_tax_excluded = '173.30', date_upd = NOW() WHERE id_document = '81356' 18/03/2023 08:42:22 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 = '81356' 18/03/2023 08:42:22 am >> DELETE FROM ps_document_detail WHERE id_document = '81356' 18/03/2023 08:42:22 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 ( '81356' , '17153' , 'SAN CHARBEL' , '1' , '-1' , '4' , '7.5000' , '7.5' , '0' , '0' , '7.50' ) 18/03/2023 08:42:22 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 ( '81356' , '13578' , 'GRANDE CROCIATA DELLAMORE - C. RIVAS' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 18/03/2023 08:42:22 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 ( '81356' , '15799' , 'PAROLE DI LUCE E VITA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/03/2023 08:42:22 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 ( '81356' , '4118' , 'FEDE INSEGNATA AI FIGLI - L. FANZAGA' , '1' , '-1' , '4' , '15.5000' , '15.5' , '0' , '0' , '15.50' ) 18/03/2023 08:42:22 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 ( '81356' , '19165' , 'MESSAGGIO TEOLOGICO DI GUADALUPE - S. ALDAY' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 18/03/2023 08:42:22 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 ( '81356' , '17968' , 'IO SONO LA MADRE DI GESU - M. STANZIONE' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/03/2023 08:42:22 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 ( '81356' , '3762' , 'ECCO TUA MADRE' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/03/2023 08:42:22 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 ( '81356' , '16266' , 'IPOTESI SU GESU - V. MESSORI' , '1' , '-1' , '4' , '16.8000' , '16.8' , '0' , '0' , '16.80' ) 18/03/2023 08:42:22 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 ( '81356' , '13941' , 'SANTO VOLTO' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 18/03/2023 08:42:22 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 ( '81356' , '9595' , 'SANTA RITA - 15 MEDITAZIONI' , '1' , '-1' , '4' , '7.5000' , '7.5' , '0' , '0' , '7.50' ) 18/03/2023 08:42:22 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 ( '81356' , '16400' , 'LODE QUOTIDIANA A MARIA' , '2' , '-2' , '4' , '6.0000' , '6' , '0' , '0' , '12.00' ) 18/03/2023 08:42:22 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 ( '81356' , '14545' , 'ROSARIO - M. DELBREL' , '2' , '-2' , '4' , '9.0000' , '9' , '0' , '0' , '18.00' ) 18/03/2023 08:42:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81356' , '13653' , 'LIBERACI DAL MALE - PREGHIERE DI LIBERAZIONE - VOL. 2' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/03/2023 08:42:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81356' , '17558' , 'IN SINU JESU' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/03/2023 08:42:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81356' , '16399' , 'CONCERTO DI NATALE - S. CONTI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/03/2023 08:42:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81356' , '14544' , 'DIVENTARE AMICI DELLO SPIRITO SANTO - R. CANTALAMESSA' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '0' , '4.00' ) 18/03/2023 08:45:43 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '216' 18/03/2023 08:45:43 am >> UPDATE ps_stock_available SET quantity = quantity + '-22' WHERE id_product = '216' 18/03/2023 09:06:42 am >> UPDATE ps_document SET id_document_type = '31', document_num = '49', document_date = '2023-01-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4674530', address1 = 'VIA CORTI 29 24126 BERGAMO', 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 = '592.92', price_tax_excluded = '486.00', date_upd = NOW() WHERE id_document = '80525' 18/03/2023 09:06:42 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 = '80525' 18/03/2023 09:06:42 am >> DELETE FROM ps_document_detail WHERE id_document = '80525' 18/03/2023 09:06:42 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 ( '80525' , '20645' , 'DALMATICA - 881' , '5' , '5' , '1' , '34.0000' , '27.868852459016' , '22' , '0' , '207.40' ) 18/03/2023 09:06:42 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 ( '80525' , '20646' , 'STOLA DIACONALE - 881' , '5' , '5' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '183.00' ) 18/03/2023 09:06:42 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 ( '80525' , '20647' , 'CASULA - 498' , '1' , '1' , '1' , '166' , '136.06557377049' , '22' , '0' , '202.5200' ) 18/03/2023 09:08:07 am >> UPDATE ps_document SET id_document_type = '31', document_num = '1/206', document_date = '2022-08-01', document_letter = '206', id_customer = '0', id_supplier = '', id_address = '4674531', address1 = 'VIA DEI CONTI FALLUC, 70/A 88100 CATANZARO', address2 = '', note = '', price_shipping = '14.52', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '732.65', price_tax_excluded = '600.53', date_upd = NOW() WHERE id_document = '59917' 18/03/2023 09:08:07 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 = '59917' 18/03/2023 09:08:07 am >> DELETE FROM ps_document_detail WHERE id_document = '59917' 18/03/2023 09:08:07 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 ( '59917' , '19865' , 'CASULA CROCE ELICA - CSL080V' , '4' , '4' , '1' , '90.0000' , '73.770491803279' , '22' , '3' , '426.02' ) 18/03/2023 09:08:07 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 ( '59917' , '19866' , 'CASULA CROCE UVA - CSL111' , '4' , '4' , '1' , '32.0000' , '26.229508196721' , '22' , '3' , '151.48' ) 18/03/2023 09:08:07 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 ( '59917' , '19867' , 'CINGOLO NODO BIANCO - F9756' , '25' , '25' , '1' , '0.9' , '0.73770491803279' , '22' , '3' , '26.6265' ) 18/03/2023 09:08:07 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 ( '59917' , '19868' , 'CINGOLO 2 FIOCCHI - F9798' , '4' , '4' , '1' , '10.0600' , '8.2459016393443' , '22' , '3' , '47.62' ) 18/03/2023 09:08:07 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 ( '59917' , '19869' , 'CINGOLO 2 FIOCCHI - F9799' , '4' , '4' , '1' , '13.3500' , '10.94262295082' , '22' , '3' , '63.19' ) 18/03/2023 09:13:19 am >> DELETE FROM ps_document WHERE id_document = '80525' 18/03/2023 09:13:19 am >> DELETE FROM ps_document_detail WHERE id_document = '80525' 18/03/2023 09:14:26 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 ( '31' , '49' , '2023-01-20' , '' , '0' , '163' , '4674530' , 'VIA CORTI 29 24126 BERGAMO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '592.92' , '486.00' , NOW() , NOW() ) 18/03/2023 09:14:26 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 = '82354' 18/03/2023 09:14:26 am >> DELETE FROM ps_document_detail WHERE id_document = '82354' 18/03/2023 09:14:26 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 ( '82354' , '20645' , 'DALMATICA - 881' , '5' , '5' , '1' , '34' , '27.868852459016' , '22' , '0' , '207.4000' ) 18/03/2023 09:14:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '20645' AND id_supplier = '163' 18/03/2023 09:14:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20645' , '163' , '1' ) 18/03/2023 09:14:26 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 ( '82354' , '20646' , 'STOLA DIACONALE - 881D' , '5' , '5' , '1' , '30' , '24.590163934426' , '22' , '0' , '183.0000' ) 18/03/2023 09:14:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '20646' AND id_supplier = '163' 18/03/2023 09:14:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20646' , '163' , '1' ) 18/03/2023 09:14:26 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 ( '82354' , '20647' , 'CASULA - 498' , '1' , '1' , '1' , '166' , '136.06557377049' , '22' , '0' , '202.5200' ) 18/03/2023 09:14:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '20647' AND id_supplier = '163' 18/03/2023 09:14:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20647' , '163' , '1' ) 18/03/2023 10:57:43 am >> SELECT document_num FROM ps_document WHERE document_num = '34/A' AND id_document != '82289' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-03-14') 18/03/2023 10:57:43 am >> UPDATE ps_document SET id_document_type = '24', document_num = '34/A', document_date = '2023-03-14', document_letter = 'A', id_customer = '1656', id_supplier = '', id_address = '4677544', address1 = 'VIA NAZIONALE 84060 OMIGNANO SCALO', 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 = '637.50', price_tax_excluded = '522.54', date_upd = NOW() WHERE id_document = '82289' 18/03/2023 10:57:43 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 = '82289' 18/03/2023 10:57:43 am >> DELETE FROM ps_document_detail WHERE id_document = '82289' 18/03/2023 10:57:43 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 ( '82289' , '15529' , 'TUNICA 2 PIEGONI COLLO RISV. - PTA002B00' , '2' , '-2' , '1' , '45.0000' , '36.885245901639' , '22' , '0' , '90.00' ) 18/03/2023 10:57:44 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 ( '82289' , '16730' , 'TUNICA AVORIO BORDO ORO - AETA03B05' , '8' , '-8' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '440.00' ) 18/03/2023 10:57:44 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 ( '82289' , '15481' , 'CROCE IHS - 2389/CZ' , '27' , '-27' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '67.50' ) 18/03/2023 10:57:44 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 ( '82289' , '18223' , 'CORONA MISSIONARIA - R102' , '40' , '-40' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '40.00' ) 18/03/2023 10:57:44 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 ( '82289' , '20516' , 'CROCE COMUNIONE - 42/08' , '8' , '-8' , '1' , '1.20' , '0.98360655737705' , '22' , '100' , '0.00' ) 18/03/2023 10:59:36 am >> SELECT document_num FROM ps_document WHERE document_num = '103/A' AND id_document != '74912' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-11-26') 18/03/2023 10:59:36 am >> UPDATE ps_document SET id_document_type = '24', document_num = '103/A', document_date = '2022-11-26', document_letter = 'A', id_customer = '371', id_supplier = '', id_address = '4670910', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', address2 = '', note = 'parrocchia', 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 = '282.40', price_tax_excluded = '247.24', date_upd = NOW() WHERE id_document = '74912' 18/03/2023 10:59:36 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 = '74912' 18/03/2023 10:59:36 am >> DELETE FROM ps_document_detail WHERE id_document = '74912' 18/03/2023 10:59:36 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 ( '74912' , '0' , 'candele' , '1' , '-1' , '0' , '23.5000' , '23.5' , '0' , '0' , '23.50' ) 18/03/2023 10:59:36 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 ( '74912' , '19071' , 'BAMBINELLO CM 32 - PB9941' , '1' , '-1' , '1' , '50.0000' , '40.983606557377' , '22' , '0' , '50.00' ) 18/03/2023 10:59:36 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 ( '74912' , '0' , 'CUSCINO' , '1' , '-1' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '20.00' ) 18/03/2023 10:59:36 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 ( '74912' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '960' , '-960' , '4' , '0.0400' , '0.04' , '0' , '0' , '38.40' ) 18/03/2023 10:59:36 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 ( '74912' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '30' , '-30' , '4' , '1.0000' , '1' , '0' , '15' , '25.50' ) 18/03/2023 10:59:36 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 ( '74912' , '20645' , 'DALMATICA - 881' , '1' , '-1' , '1' , '90.00' , '73.770491803279' , '22' , '0' , '90.00' ) 18/03/2023 10:59:36 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 ( '74912' , '6014' , 'LUMINO BIANCO - 10B' , '70' , '-70' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '35.00' ) 18/03/2023 11:00:12 am >> SELECT document_num FROM ps_document WHERE document_num = '886' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-18') 18/03/2023 11:00:12 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' , '886' , '2023-03-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '5.00' , NOW() , NOW() ) 18/03/2023 11:00:12 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 = '82355' 18/03/2023 11:00:12 am >> DELETE FROM ps_document_detail WHERE id_document = '82355' 18/03/2023 11:00:12 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 ( '82355' , '7271' , 'ORAZIONI IN SUFFRAGIO DELLE ANIME DEL PURGATORIO - 8477' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 18/03/2023 11:00:12 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 ( '82355' , '16909' , 'CUORE A CUORE CON GESU - 8134' , '2' , '-2' , '4' , '1.50' , '1.5' , '0' , '0' , '3.00' ) 18/03/2023 11:05:56 am >> SELECT document_num FROM ps_document WHERE document_num = '887' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-18') 18/03/2023 11:05:56 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '887' , '2023-03-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.50' , '6.15' , NOW() , NOW() ) 18/03/2023 11:05:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82356' 18/03/2023 11:05:56 am >> DELETE FROM ps_document_detail WHERE id_document = '82356' 18/03/2023 11:05:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82356' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 18/03/2023 11:12:52 am >> SELECT document_num FROM ps_document WHERE document_num = '888' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-18') 18/03/2023 11:12:52 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' , '888' , '2023-03-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 18/03/2023 11:12:52 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 = '82357' 18/03/2023 11:12:52 am >> DELETE FROM ps_document_detail WHERE id_document = '82357' 18/03/2023 11:12:52 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 ( '82357' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 18/03/2023 11:13:14 am >> DELETE FROM ps_document WHERE id_document = '82266' 18/03/2023 11:13:14 am >> DELETE FROM ps_document_detail WHERE id_document = '82266' 18/03/2023 11:19:16 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '10516' 18/03/2023 11:19:16 am >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '10516' 18/03/2023 11:19:46 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '10515' 18/03/2023 11:19:46 am >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '10515' 18/03/2023 11:20:04 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '10511' 18/03/2023 11:20:04 am >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '10511' 18/03/2023 11:20:25 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '10508' 18/03/2023 11:20:25 am >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '10508' 18/03/2023 11:20:55 am >> DELETE FROM ps_product WHERE id_product = '10500' 18/03/2023 11:20:55 am >> DELETE FROM ps_product_shop WHERE id_product = '10500' 18/03/2023 11:20:55 am >> DELETE FROM ps_product_lang WHERE id_product = '10500' 18/03/2023 11:20:55 am >> DELETE FROM ps_stock_available WHERE id_product = '10500' 18/03/2023 11:21:37 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '10244' 18/03/2023 11:21:37 am >> UPDATE ps_stock_available SET quantity = quantity + '-2' WHERE id_product = '10244' 18/03/2023 11:21:47 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '10243' 18/03/2023 11:21:47 am >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '10243' 18/03/2023 11:21:56 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '10242' 18/03/2023 11:21:56 am >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '10242' 18/03/2023 11:22:27 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '10198' 18/03/2023 11:22:27 am >> UPDATE ps_stock_available SET quantity = quantity + '-4' WHERE id_product = '10198' 18/03/2023 11:22:47 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '10196' 18/03/2023 11:22:47 am >> UPDATE ps_stock_available SET quantity = quantity + '-2' WHERE id_product = '10196' 18/03/2023 11:22:56 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '10193' 18/03/2023 11:22:56 am >> UPDATE ps_stock_available SET quantity = quantity + '-2' WHERE id_product = '10193' 18/03/2023 11:23:44 am >> DELETE FROM ps_product WHERE id_product = '9727' 18/03/2023 11:23:44 am >> DELETE FROM ps_product_shop WHERE id_product = '9727' 18/03/2023 11:23:44 am >> DELETE FROM ps_product_lang WHERE id_product = '9727' 18/03/2023 11:23:44 am >> DELETE FROM ps_stock_available WHERE id_product = '9727' 18/03/2023 11:24:18 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '9726' 18/03/2023 11:24:18 am >> UPDATE ps_stock_available SET quantity = quantity + '-10' WHERE id_product = '9726' 18/03/2023 11:24:36 am >> DELETE FROM ps_product WHERE id_product = '9388' 18/03/2023 11:24:36 am >> DELETE FROM ps_product_shop WHERE id_product = '9388' 18/03/2023 11:24:36 am >> DELETE FROM ps_product_lang WHERE id_product = '9388' 18/03/2023 11:24:36 am >> DELETE FROM ps_stock_available WHERE id_product = '9388' 18/03/2023 11:25:16 am >> DELETE FROM ps_product WHERE id_product = '9457' 18/03/2023 11:25:16 am >> DELETE FROM ps_product_shop WHERE id_product = '9457' 18/03/2023 11:25:16 am >> DELETE FROM ps_product_lang WHERE id_product = '9457' 18/03/2023 11:25:16 am >> DELETE FROM ps_stock_available WHERE id_product = '9457' 18/03/2023 11:25:28 am >> DELETE FROM ps_product WHERE id_product = '9201' 18/03/2023 11:25:28 am >> DELETE FROM ps_product_shop WHERE id_product = '9201' 18/03/2023 11:25:28 am >> DELETE FROM ps_product_lang WHERE id_product = '9201' 18/03/2023 11:25:28 am >> DELETE FROM ps_stock_available WHERE id_product = '9201' 18/03/2023 11:25:56 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '9195' 18/03/2023 11:25:57 am >> UPDATE ps_stock_available SET quantity = quantity + '-307' WHERE id_product = '9195' 18/03/2023 11:26:14 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '9182' 18/03/2023 11:26:14 am >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '9182' 18/03/2023 11:26:32 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '9178' 18/03/2023 11:26:32 am >> UPDATE ps_stock_available SET quantity = quantity + '-12' WHERE id_product = '9178' 18/03/2023 11:27:05 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '9172' 18/03/2023 11:27:05 am >> UPDATE ps_stock_available SET quantity = quantity + '-10' WHERE id_product = '9172' 18/03/2023 11:27:25 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '9169' 18/03/2023 11:27:25 am >> UPDATE ps_stock_available SET quantity = quantity + '-31' WHERE id_product = '9169' 18/03/2023 11:27:58 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '9168' 18/03/2023 11:27:58 am >> UPDATE ps_stock_available SET quantity = quantity + '-105' WHERE id_product = '9168' 18/03/2023 11:28:22 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '9167' 18/03/2023 11:28:22 am >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '9167' 18/03/2023 11:29:14 am >> DELETE FROM ps_product WHERE id_product = '9145' 18/03/2023 11:29:14 am >> DELETE FROM ps_product_shop WHERE id_product = '9145' 18/03/2023 11:29:14 am >> DELETE FROM ps_product_lang WHERE id_product = '9145' 18/03/2023 11:29:14 am >> DELETE FROM ps_stock_available WHERE id_product = '9145' 18/03/2023 11:29:32 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '9138' 18/03/2023 11:29:32 am >> UPDATE ps_stock_available SET quantity = quantity + '-6' WHERE id_product = '9138' 18/03/2023 11:30:07 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '9136' 18/03/2023 11:30:07 am >> UPDATE ps_stock_available SET quantity = quantity + '-10' WHERE id_product = '9136' 18/03/2023 11:59:50 am >> SELECT document_num FROM ps_document WHERE document_num = '889' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-18') 18/03/2023 11:59:50 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' , '889' , '2023-03-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '68.70' , '56.31' , NOW() , NOW() ) 18/03/2023 11:59: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 = '82358' 18/03/2023 11:59:50 am >> DELETE FROM ps_document_detail WHERE id_document = '82358' 18/03/2023 11:59: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 ( '82358' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' , '-1' , '1' , '22.00' , '18.032786885246' , '22' , '0' , '22.00' ) 18/03/2023 11:59: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 ( '82358' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '9.5' , '7.7868852459016' , '22' , '0' , '9.50' ) 18/03/2023 11:59: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 ( '82358' , '7202' , 'ARTICOLI RELIGIOSI' , '31' , '-31' , '1' , '1.2' , '0.98360655737705' , '22' , '0' , '37.20' ) 18/03/2023 12:17:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '54' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-03-18') 18/03/2023 12:17:49 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' , '54' , '2023-03-18' , '' , '1178' , '0' , '4671042' , 'P. ZZA LINGUITI, 1 84095 GIFFONI VALLE PIANA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '76.50' , '76.50' , NOW() , NOW() ) 18/03/2023 12:17: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 = '82359' 18/03/2023 12:17:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '82359' 18/03/2023 12:17: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 ( '82359' , '6629' , 'MIA PREGHIERA' , '100' , '-100' , '4' , '0.90' , '0.9' , '0' , '15' , '76.50' ) 18/03/2023 12:34:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '890' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-18') 18/03/2023 12:34:43 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' , '890' , '2023-03-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '17.30' , NOW() , NOW() ) 18/03/2023 12:34:43 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 = '82360' 18/03/2023 12:34:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '82360' 18/03/2023 12:34:43 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 ( '82360' , '15334' , 'CANDELA VOTIVA 20X40' , '5' , '-5' , '1' , '1' , '0.81967213114754' , '22' , '0' , '5.00' ) 18/03/2023 12:34:43 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 ( '82360' , '5461' , 'IO SONO IL PANE DELLA VITA' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 18/03/2023 12:34:43 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 ( '82360' , '13840' , 'NONNI SONO UN TESORO' , '2' , '-2' , '4' , '1.50' , '1.5' , '0' , '0' , '3.00' ) 18/03/2023 12:34:43 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 ( '82360' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 18/03/2023 12:50:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '891' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-18') 18/03/2023 12:50:32 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' , '891' , '2023-03-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.90' , '9.90' , NOW() , NOW() ) 18/03/2023 12:50:32 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 = '82361' 18/03/2023 12:50:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '82361' 18/03/2023 12:50:32 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 ( '82361' , '1090' , 'BIBBIA' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '0' , '9.90' )