08/01/2024 08:25:45 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831554756' AND id_product != '20993' AND ean13 != '' 08/01/2024 08:25:45 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/2', ean13 = '9788831554756', date_upd = NOW() WHERE id_product = '20993' 08/01/2024 08:25:45 am >> UPDATE ps_product_lang SET name = 'POWER BIBLE 1', description = '' WHERE id_product = '20993' 08/01/2024 08:25:45 am >> UPDATE ps_product SET wholesale_price = '9.10', on_sale = '0', price = '14.0000' WHERE id_product = '20993' 08/01/2024 08:25:45 am >> UPDATE ps_product_shop SET wholesale_price = '9.10', price = '14.0000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '40', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20993' 08/01/2024 08:25:45 am >> DELETE FROM ps_specific_price WHERE id_product = '20993' 08/01/2024 08:26:08 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831554732' AND id_product != '20994' AND ean13 != '' 08/01/2024 08:26:08 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/2', ean13 = '9788831554732', date_upd = NOW() WHERE id_product = '20994' 08/01/2024 08:26:08 am >> UPDATE ps_product_lang SET name = 'POWER BIBLE 2', description = '' WHERE id_product = '20994' 08/01/2024 08:26:08 am >> UPDATE ps_product SET wholesale_price = '9.10', on_sale = '0', price = '14.0000' WHERE id_product = '20994' 08/01/2024 08:26:09 am >> UPDATE ps_product_shop SET wholesale_price = '9.10', price = '14.0000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '40', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20994' 08/01/2024 08:26:09 am >> DELETE FROM ps_specific_price WHERE id_product = '20994' 08/01/2024 08:26:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831554749' AND id_product != '20995' AND ean13 != '' 08/01/2024 08:26:22 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/2', ean13 = '9788831554749', date_upd = NOW() WHERE id_product = '20995' 08/01/2024 08:26:22 am >> UPDATE ps_product_lang SET name = 'POWER BIBLE 3', description = '' WHERE id_product = '20995' 08/01/2024 08:26:22 am >> UPDATE ps_product SET wholesale_price = '9.10', on_sale = '0', price = '14.0000' WHERE id_product = '20995' 08/01/2024 08:26:22 am >> UPDATE ps_product_shop SET wholesale_price = '9.10', price = '14.0000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '40', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20995' 08/01/2024 08:26:22 am >> DELETE FROM ps_specific_price WHERE id_product = '20995' 08/01/2024 08:27:31 am >> SELECT document_num FROM ps_document WHERE document_num = '3484' AND id_document != '88774' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-07') 08/01/2024 08:27:31 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3484', document_date = '2023-11-07', 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 = '302.00', price_tax_excluded = '260.96', date_upd = NOW() WHERE id_document = '88774' 08/01/2024 08:27: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 = '88774' 08/01/2024 08:27:31 am >> DELETE FROM ps_document_detail WHERE id_document = '88774' 08/01/2024 08:27: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 ( '88774' , '16393' , 'GIOCA ANCORA CON GESU ' , '1' , '-1' , '4' , '9.8000' , '9.8' , '0' , '0' , '9.80' ) 08/01/2024 08:27: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 ( '88774' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '2' , '-2' , '1' , '39.9000' , '32.704918032787' , '22' , '0' , '79.80' ) 08/01/2024 08:27: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 ( '88774' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '112.80' ) 08/01/2024 08:27: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 ( '88774' , '21779' , 'CAMMINO DI UN POPOLO - C.M. MARTINI' , '1' , '-1' , '4' , '40.0000' , '40' , '0' , '5' , '38.00' ) 08/01/2024 08:27: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 ( '88774' , '21439' , 'NATUZZA EVOLO COME BIBBIA - R.I. ZANINI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 08/01/2024 08:27: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 ( '88774' , '21780' , 'FRATELLINO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 08/01/2024 08:27: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 ( '88774' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '17' , '13.934426229508' , '22' , '0' , '17.00' ) 08/01/2024 08:27: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 ( '88774' , '6322' , 'MEDAGLIA MIRACOLOSA BAGNO ORO 24KT MM22 - 064022MI ' , '2' , '-2' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '18.00' ) 08/01/2024 08:54:55 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892229747' AND id_product != '20421' AND ean13 != '' 08/01/2024 08:54:55 am >> UPDATE ps_product SET id_supplier = '', reference = '5/4', ean13 = '9788892229747', date_upd = NOW() WHERE id_product = '20421' 08/01/2024 08:54:55 am >> UPDATE ps_product_lang SET name = 'DECORAZIONI DI NATALE', description = '' WHERE id_product = '20421' 08/01/2024 08:54:55 am >> UPDATE ps_product SET wholesale_price = '2.93', on_sale = '0', price = '4.5000' WHERE id_product = '20421' 08/01/2024 08:54:55 am >> UPDATE ps_product_shop SET wholesale_price = '2.93', price = '4.5000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '40', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20421' 08/01/2024 08:54:55 am >> DELETE FROM ps_specific_price WHERE id_product = '20421' 08/01/2024 09:05:10 am >> SELECT document_num FROM ps_document WHERE document_num = '1/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-08') 08/01/2024 09:05: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 ( '24' , '1/A' , '2024-01-08' , 'A' , '206' , '0' , '4671015' , 'VIA N. BUONSERVIZI, 25 84135 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.00' , '25.00' , NOW() , NOW() ) 08/01/2024 09:05: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 = '89846' 08/01/2024 09:05:10 am >> DELETE FROM ps_document_detail WHERE id_document = '89846' 08/01/2024 09:05: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 ( '89846' , '22041' , 'SECONDO MARCO - P. RICCA' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '0' , '25.00' ) 08/01/2024 09:10:57 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892229860' AND id_product != '20100' AND ean13 != '' 08/01/2024 09:10:57 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/6', ean13 = '9788892229860', date_upd = NOW() WHERE id_product = '20100' 08/01/2024 09:10:57 am >> UPDATE ps_product_lang SET name = 'RE BAMBINO - S. FORNASARI', description = '' WHERE id_product = '20100' 08/01/2024 09:10:57 am >> UPDATE ps_product SET wholesale_price = '9.10', on_sale = '0', price = '14.0000' WHERE id_product = '20100' 08/01/2024 09:10:57 am >> UPDATE ps_product_shop SET wholesale_price = '9.10', price = '14.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20100' 08/01/2024 09:10:57 am >> DELETE FROM ps_specific_price WHERE id_product = '20100' 08/01/2024 09:11:28 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899571269' AND id_product != '14936' AND ean13 != '' 08/01/2024 09:11:28 am >> UPDATE ps_product SET id_supplier = '127', reference = '5/4', ean13 = '9788899571269', date_upd = NOW() WHERE id_product = '14936' 08/01/2024 09:11:28 am >> UPDATE ps_product_lang SET name = 'E\' NATO, ALBUM DA COLORARE', description = '' WHERE id_product = '14936' 08/01/2024 09:11:28 am >> UPDATE ps_product SET wholesale_price = '1.30', on_sale = '0', price = '2.0000' WHERE id_product = '14936' 08/01/2024 09:11:28 am >> UPDATE ps_product_shop SET wholesale_price = '1.30', price = '2.0000', id_tax_rules_group = '4', id_category_default = '37', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '14936' 08/01/2024 09:11:28 am >> DELETE FROM ps_specific_price WHERE id_product = '14936' 08/01/2024 09:12:14 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899571399' AND id_product != '21701' AND ean13 != '' 08/01/2024 09:12:14 am >> UPDATE ps_product SET id_supplier = '127', reference = '5/4', ean13 = '9788899571399', date_upd = NOW() WHERE id_product = '21701' 08/01/2024 09:12:14 am >> UPDATE ps_product_lang SET name = 'NASCITA DI GESU\'', description = '' WHERE id_product = '21701' 08/01/2024 09:12:14 am >> UPDATE ps_product SET wholesale_price = '1.63', on_sale = '0', price = '2.5000' WHERE id_product = '21701' 08/01/2024 09:12:14 am >> UPDATE ps_product_shop SET wholesale_price = '1.63', price = '2.5000', id_tax_rules_group = '4', id_category_default = '37', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21701' 08/01/2024 09:12:14 am >> DELETE FROM ps_specific_price WHERE id_product = '21701' 08/01/2024 09:12:23 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899571399' AND id_product != '21701' AND ean13 != '' 08/01/2024 09:12:23 am >> UPDATE ps_product SET id_supplier = '127', reference = '5/4', ean13 = '9788899571399', date_upd = NOW() WHERE id_product = '21701' 08/01/2024 09:12:23 am >> UPDATE ps_product_lang SET name = 'NASCITA DI GESU\'', description = '' WHERE id_product = '21701' 08/01/2024 09:12:23 am >> UPDATE ps_product SET wholesale_price = '1.63', on_sale = '0', price = '2.5000' WHERE id_product = '21701' 08/01/2024 09:12:23 am >> UPDATE ps_product_shop SET wholesale_price = '1.63', price = '2.5000', id_tax_rules_group = '4', id_category_default = '37', id_argoment_default = '39', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21701' 08/01/2024 09:12:23 am >> DELETE FROM ps_specific_price WHERE id_product = '21701' 08/01/2024 09:12:47 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831555302' AND id_product != '21662' AND ean13 != '' 08/01/2024 09:12:47 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/4', ean13 = '9788831555302', date_upd = NOW() WHERE id_product = '21662' 08/01/2024 09:12:47 am >> UPDATE ps_product_lang SET name = 'ANDIAMO VERSO GESU\'', description = '' WHERE id_product = '21662' 08/01/2024 09:12:47 am >> UPDATE ps_product SET wholesale_price = '4.49', on_sale = '0', price = '6.9000' WHERE id_product = '21662' 08/01/2024 09:12:47 am >> UPDATE ps_product_shop SET wholesale_price = '4.49', price = '6.9000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '39', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21662' 08/01/2024 09:12:47 am >> DELETE FROM ps_specific_price WHERE id_product = '21662' 08/01/2024 09:15:59 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831555296' AND id_product != '20309' AND ean13 != '' 08/01/2024 09:15:59 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/4', ean13 = '9788831555296', date_upd = NOW() WHERE id_product = '20309' 08/01/2024 09:15:59 am >> UPDATE ps_product_lang SET name = 'DISEGNIAMO LA NATIVITA\'', description = '' WHERE id_product = '20309' 08/01/2024 09:15:59 am >> UPDATE ps_product SET wholesale_price = '5.20', on_sale = '0', price = '8.0000' WHERE id_product = '20309' 08/01/2024 09:15:59 am >> UPDATE ps_product_shop SET wholesale_price = '5.20', price = '8.0000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '39', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20309' 08/01/2024 09:15:59 am >> DELETE FROM ps_specific_price WHERE id_product = '20309' 08/01/2024 09:29:43 am >> SELECT document_num FROM ps_document WHERE document_num = '66' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-08') 08/01/2024 09:29:43 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' , '66' , '2024-01-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.81' , '17.81' , NOW() , NOW() ) 08/01/2024 09:29: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 = '89847' 08/01/2024 09:29:43 am >> DELETE FROM ps_document_detail WHERE id_document = '89847' 08/01/2024 09:29: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 ( '89847' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '12' , '-12' , '4' , '0.70' , '0.7' , '0' , '0' , '8.40' ) 08/01/2024 09:29: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 ( '89847' , '6117' , 'MAESTRO INSEGNACI A PREGARE - A. GASPARINO' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '5' , '9.41' ) 08/01/2024 09:45:46 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892243095' AND id_product != '21743' AND ean13 != '' 08/01/2024 09:45:46 am >> UPDATE ps_product SET id_supplier = '7', reference = '6/6', ean13 = '9788892243095', date_upd = NOW() WHERE id_product = '21743' 08/01/2024 09:45:46 am >> UPDATE ps_product_lang SET name = 'CAMMINANDO VERSO IL PRESEPE - E. FORTUNATO', description = '' WHERE id_product = '21743' 08/01/2024 09:45:46 am >> UPDATE ps_product SET wholesale_price = '8.04', on_sale = '0', price = '12.0000' WHERE id_product = '21743' 08/01/2024 09:45:46 am >> UPDATE ps_product_shop SET wholesale_price = '8.04', price = '12.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21743' 08/01/2024 09:45:46 am >> DELETE FROM ps_specific_price WHERE id_product = '21743' 08/01/2024 09:46:18 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892229785' AND id_product != '20198' AND ean13 != '' 08/01/2024 09:46:18 am >> UPDATE ps_product SET id_supplier = '7', reference = '6/6', ean13 = '9788892229785', date_upd = NOW() WHERE id_product = '20198' 08/01/2024 09:46:18 am >> UPDATE ps_product_lang SET name = 'CON MARIA VERSO LA GROTTA DI BETLEMME - L. FANZAGA', description = '' WHERE id_product = '20198' 08/01/2024 09:46:18 am >> UPDATE ps_product SET wholesale_price = '8.04', on_sale = '0', price = '12.0000' WHERE id_product = '20198' 08/01/2024 09:46:18 am >> UPDATE ps_product_shop SET wholesale_price = '8.04', price = '12.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20198' 08/01/2024 09:46:18 am >> DELETE FROM ps_specific_price WHERE id_product = '20198' 08/01/2024 09:46:34 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831555876' AND id_product != '21659' AND ean13 != '' 08/01/2024 09:46:34 am >> UPDATE ps_product SET id_supplier = '7', reference = '6/6', ean13 = '9788831555876', date_upd = NOW() WHERE id_product = '21659' 08/01/2024 09:46:34 am >> UPDATE ps_product_lang SET name = 'MARIA RITRATTO DI UNA DONNA ', description = '' WHERE id_product = '21659' 08/01/2024 09:46:34 am >> UPDATE ps_product SET wholesale_price = '4.62', on_sale = '0', price = '6.9000' WHERE id_product = '21659' 08/01/2024 09:46:34 am >> UPDATE ps_product_shop SET wholesale_price = '4.62', price = '6.9000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '39', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21659' 08/01/2024 09:46:34 am >> DELETE FROM ps_specific_price WHERE id_product = '21659' 08/01/2024 09:47:41 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281253391' AND id_product != '21783' AND ean13 != '' 08/01/2024 09:47:41 am >> UPDATE ps_product SET id_supplier = '7', reference = '6/6', ean13 = '9791281253391', date_upd = NOW() WHERE id_product = '21783' 08/01/2024 09:47:41 am >> UPDATE ps_product_lang SET name = 'NATALE DEL CUORE - A.M. CANOPI', description = '' WHERE id_product = '21783' 08/01/2024 09:47:41 am >> UPDATE ps_product SET wholesale_price = '10.50', on_sale = '0', price = '15.0000' WHERE id_product = '21783' 08/01/2024 09:47:41 am >> UPDATE ps_product_shop SET wholesale_price = '10.50', price = '15.0000', id_tax_rules_group = '4', id_category_default = '518', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21783' 08/01/2024 09:47:41 am >> DELETE FROM ps_specific_price WHERE id_product = '21783' 08/01/2024 09:48:14 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892229655' AND id_product != '20098' AND ean13 != '' 08/01/2024 09:48:14 am >> UPDATE ps_product SET id_supplier = '7', reference = '6/6', ean13 = '9788892229655', date_upd = NOW() WHERE id_product = '20098' 08/01/2024 09:48:14 am >> UPDATE ps_product_lang SET name = 'PREPARA LA CULLA: E\' NATALE - A. COMASTRI', description = '' WHERE id_product = '20098' 08/01/2024 09:48:14 am >> UPDATE ps_product SET wholesale_price = '16.75', on_sale = '0', price = '25.0000' WHERE id_product = '20098' 08/01/2024 09:48:14 am >> UPDATE ps_product_shop SET wholesale_price = '16.75', price = '25.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20098' 08/01/2024 09:48:14 am >> DELETE FROM ps_specific_price WHERE id_product = '20098' 08/01/2024 09:49:31 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736215' AND id_product != '21417' AND ean13 != '' 08/01/2024 09:49:31 am >> UPDATE ps_product SET id_supplier = '145', reference = '13/3', ean13 = '9791280736215', date_upd = NOW() WHERE id_product = '21417' 08/01/2024 09:49:31 am >> UPDATE ps_product_lang SET name = 'VIENI, NON TARDARE SIGNORE, NOSTRA PACE!', description = '

La pace è il desiderio più profondo dell’essere umano, ma non sempre è chiaro il suo significato e purtroppo spesso le vie per ottenerla non coincidono con le vie di Dio. Tutta la Bibbia è percorsa da un anelito di pace.“Shalom” è la parola ebraica biblica che traduciamo i con “pace” che esprime un concetto molto più ampio, di armonia con gli altri e con la natura, con se stesso e con Dio, di benedizione e prosperità, di ricchezza e realizzazione, di vita piena, di giustizia in opposizione all’iniquità, di definitiva salvezza e felicità. L’uomo biblico si rende conto presto che questa pace, non può venire se non da Dio: da qui la preghiera per ottenere la pace; nello stesso tempo intuisce che Dio vuole la sua attiva cooperazione alla costruzione di questa pace sulla terra.Solo nella misura in cui faremo entrare il Signore nelle nostre vite, potremo avere lo “shalom” e potremo diffonderlo intorno a noi. Questo sussidio per l’Avvento e il Natale ci ispiri quotidianamente l’accorata preghiera: “Vieni, non tardare, Signore nostra Pace!” e ci prepari ad accoglierlo insieme nella verità e nella gioia.

' WHERE id_product = '21417' 08/01/2024 09:49:31 am >> UPDATE ps_product SET wholesale_price = '0.55', on_sale = '0', price = '2.5000' WHERE id_product = '21417' 08/01/2024 09:49:31 am >> UPDATE ps_product_shop SET wholesale_price = '0.55', price = '2.5000', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '39', id_internal_category = '4', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21417' 08/01/2024 09:49:31 am >> DELETE FROM ps_specific_price WHERE id_product = '21417' 08/01/2024 09:49:31 am >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '21417' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 08/01/2024 10:23:45 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '16336' 08/01/2024 10:23:45 am >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '16336' 08/01/2024 10:43:45 am >> SELECT document_num FROM ps_document WHERE document_num = '67' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-08') 08/01/2024 10:43:45 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '67' , '2024-01-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '258.95' , '228.94' , NOW() , NOW() ) 08/01/2024 10:43:45 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89848' 08/01/2024 10:43:45 am >> DELETE FROM ps_document_detail WHERE id_document = '89848' 08/01/2024 10:43:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89848' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 08/01/2024 10:43:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89848' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 08/01/2024 10:43:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89848' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 08/01/2024 10:43:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89848' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '120' , '-120' , '4' , '0.70' , '0.7' , '0' , '0' , '84.00' ) 08/01/2024 10:43:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89848' , '21760' , 'QUANDO LAMORE E PER SEMPRE - B. BAFFETTI' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 08/01/2024 11:02:56 am >> SELECT document_num FROM ps_document WHERE document_num = '68' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-08') 08/01/2024 11:02: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' , '68' , '2024-01-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.80' , '54.22' , NOW() , NOW() ) 08/01/2024 11:02: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 = '89849' 08/01/2024 11:02:56 am >> DELETE FROM ps_document_detail WHERE id_document = '89849' 08/01/2024 11:02: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 ( '89849' , '19997' , 'GESU BAMBINO CM 34 - BJ140-34E' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 08/01/2024 11:02: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 ( '89849' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 08/01/2024 11:02: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 ( '89849' , '11756' , 'VINO BIANCO SECCO - 14%' , '2' , '-2' , '1' , '6.90' , '5.655737704918' , '22' , '0' , '13.80' ) 08/01/2024 11:17:57 am >> SELECT document_num FROM ps_document WHERE document_num = '69' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-08') 08/01/2024 11:17:57 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' , '69' , '2024-01-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.40' , '49.40' , NOW() , NOW() ) 08/01/2024 11:17:57 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 = '89850' 08/01/2024 11:17:57 am >> DELETE FROM ps_document_detail WHERE id_document = '89850' 08/01/2024 11:17:57 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 ( '89850' , '17864' , 'MESSALE QUOTIDIANO GRANDE - N. E. ' , '1' , '-1' , '4' , '52.00' , '52' , '0' , '5' , '49.40' ) 08/01/2024 11:22:11 am >> SELECT document_num FROM ps_document WHERE document_num = '70' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-08') 08/01/2024 11:22:11 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' , '70' , '2024-01-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.50' , '29.92' , NOW() , NOW() ) 08/01/2024 11:22:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89851' 08/01/2024 11:22:11 am >> DELETE FROM ps_document_detail WHERE id_document = '89851' 08/01/2024 11:22:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89851' , '17956' , 'SAN GIUSEPPE DORMIENTE CM 30 - 4041' , '1' , '-1' , '1' , '36.50' , '29.918032786885' , '22' , '0' , '36.50' ) 08/01/2024 11:27:04 am >> SELECT document_num FROM ps_document WHERE document_num = '2/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-08') 08/01/2024 11:27: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 ( '24' , '2/A' , '2024-01-08' , 'A' , '357' , '0' , '4676034' , 'VIA TORRIONE 84100 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '169.56' , '169.56' , NOW() , NOW() ) 08/01/2024 11:27: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 = '89852' 08/01/2024 11:27:04 am >> DELETE FROM ps_document_detail WHERE id_document = '89852' 08/01/2024 11:27: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 ( '89852' , '2403' , 'CODICE DI DIRITTO CANONICO - 1' , '1' , '-1' , '4' , '59.50' , '59.5' , '0' , '5' , '56.52' ) 08/01/2024 11:27: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 ( '89852' , '2404' , 'CODICE DI DIRITTO CANONICO - 2' , '1' , '-1' , '4' , '59.50' , '59.5' , '0' , '5' , '56.52' ) 08/01/2024 11:27: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 ( '89852' , '2405' , 'CODICE DI DIRITTO CANONICO - 3' , '1' , '-1' , '4' , '59.50' , '59.5' , '0' , '5' , '56.52' ) 08/01/2024 11:45:10 am >> SELECT document_num FROM ps_document WHERE document_num = '3446' AND id_document != '88715' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-03') 08/01/2024 11:45:10 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3446', document_date = '2023-11-03', 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 = '207.00', price_tax_excluded = '199.43', date_upd = NOW() WHERE id_document = '88715' 08/01/2024 11:45: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 = '88715' 08/01/2024 11:45:10 am >> DELETE FROM ps_document_detail WHERE id_document = '88715' 08/01/2024 11:45: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 ( '88715' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '1' , '-1' , '1' , '42.0000' , '34.426229508197' , '22' , '0' , '42.00' ) 08/01/2024 11:45: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 ( '88715' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '80.78' , '80.78' , '0' , '0' , '80.78' ) 08/01/2024 11:45: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 ( '88715' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '14' , '-14' , '4' , '5.5000' , '5.5' , '0' , '5' , '73.22' ) 08/01/2024 11:45: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 ( '88715' , '21196' , 'CALENDARIO LITURGICO 2024' , '1' , '-1' , '4' , '0.5000' , '0.5' , '0' , '0' , '0.50' ) 08/01/2024 11:45: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 ( '88715' , '9017' , 'RITO DELLA PENITENZA' , '1' , '-1' , '4' , '10.50' , '10.5' , '0' , '0' , '10.50' ) 08/01/2024 11:45:44 am >> SELECT document_num FROM ps_document WHERE document_num = '3838' AND id_document != '89286' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-02') 08/01/2024 11:45:44 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3838', document_date = '2023-12-02', 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 = '200.00', price_tax_excluded = '174.93', date_upd = NOW() WHERE id_document = '89286' 08/01/2024 11:45:44 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 = '89286' 08/01/2024 11:45:45 am >> DELETE FROM ps_document_detail WHERE id_document = '89286' 08/01/2024 11:45:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89286' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 08/01/2024 11:45:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89286' , '18271' , 'FINTA CANDELA 3,2 X 25 - 131' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 08/01/2024 11:45:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89286' , '4205' , 'FINTA CANDELA 4X30 - 140 ' , '2' , '-2' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '24.00' ) 08/01/2024 11:45:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89286' , '18880' , 'COPRILEGGIO MORELLO' , '1' , '-1' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '65.00' ) 08/01/2024 11:45:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89286' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '61.0000' , '61' , '0' , '0' , '61.00' ) 08/01/2024 11:45:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89286' , '20644' , 'STOLA - PST022' , '1' , '-1' , '1' , '27' , '22.131147540984' , '22' , '0' , '27.00' ) 08/01/2024 11:51:39 am >> SELECT document_num FROM ps_document WHERE document_num = '3/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-08') 08/01/2024 11:51:39 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' , '3/A' , '2024-01-08' , 'A' , '292' , '0' , '4676365' , 'VIA IONIO 8/A 84091 BATTIPAGLIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '72.00' , '59.02' , NOW() , NOW() ) 08/01/2024 11:51:39 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 = '89853' 08/01/2024 11:51:39 am >> DELETE FROM ps_document_detail WHERE id_document = '89853' 08/01/2024 11:51:39 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 ( '89853' , '12814' , 'LIBRO DEI BATTEZZATI' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '10' , '36.00' ) 08/01/2024 11:51:39 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 ( '89853' , '12817' , 'LIBRO DEI MATRIMONI' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '10' , '36.00' ) 08/01/2024 11:59:46 am >> SELECT document_num FROM ps_document WHERE document_num = '52' AND id_document != '89371' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-12-06') 08/01/2024 11:59:46 am >> UPDATE ps_document SET id_document_type = '24', document_num = '52', document_date = '2023-12-06', document_letter = '', id_customer = '4068', id_supplier = '', id_address = '4679214', address1 = 'VIA DEI TRIBUNALI 316 80138 NAPOLI', address2 = 'Biblioteca del Convento dei Padri minimi di Santa Maria della Stella\r\nv. Stella 25 - 80137 Napoli \r\n', 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 = '2500.00', price_tax_excluded = '2500.00', date_upd = NOW() WHERE id_document = '89371' 08/01/2024 11:59:46 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 = '89371' 08/01/2024 11:59:46 am >> DELETE FROM ps_document_detail WHERE id_document = '89371' 08/01/2024 11:59:46 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 ( '89371' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 08/01/2024 11:59:46 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 ( '89371' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '1' , '-1' , '4' , '35.0000' , '35' , '0' , '0' , '35.00' ) 08/01/2024 11:59:46 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 ( '89371' , '18950' , 'DOV\'E\' FINITO IL CONCILIO? - F. CERRI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 08/01/2024 11:59:46 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 ( '89371' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 08/01/2024 11:59:46 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 ( '89371' , '18657' , 'HO DATO LORO LA TUA PAROLA - TEMPI FORTI- G. VALSECCHI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 08/01/2024 11:59:46 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 ( '89371' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 08/01/2024 11:59:46 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 ( '89371' , '19088' , 'TU SOLO IL SANTO - G. VALSECCHI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 08/01/2024 11:59:46 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 ( '89371' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 08/01/2024 11:59:46 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 ( '89371' , '17827' , 'ISTRUZIONI FAMILIARI VOL. I - IL CREDO ' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 08/01/2024 11:59:46 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 ( '89371' , '18717' , 'ISTRUZIONI FAMILIARI VOL. II - I DIECI COMANDAMENTI ' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 08/01/2024 11:59:46 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 ( '89371' , '19391' , 'ISTRUZIONI FAMILIARI VOL. III - I PRECETTI...' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 08/01/2024 11:59:47 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 ( '89371' , '21799' , 'ISTRUZIONI FAMILIARI VOL. IV - I VIZI E I SCARAMENTI' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 08/01/2024 11:59:47 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 ( '89371' , '19562' , 'SAN CESARE DE BUS. UNA VITA PER LA CATECHESI ' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 08/01/2024 11:59:47 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 ( '89371' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 08/01/2024 11:59:47 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 ( '89371' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 08/01/2024 11:59:47 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 ( '89371' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 08/01/2024 11:59:47 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 ( '89371' , '10645' , 'TI AMO PER SEMPRE' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 08/01/2024 11:59:47 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 ( '89371' , '3978' , 'EUCARISTIA: RITO E VITA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 08/01/2024 11:59:47 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 ( '89371' , '1883' , 'CELEBRAZIONI PER L\'ANNO PASTORALE' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '0' , '11.00' ) 08/01/2024 11:59:47 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 ( '89371' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 08/01/2024 11:59:47 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 ( '89371' , '14223' , 'PRONTUARIO BIBLICO - LITURGICO - F. GIGLIO' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 08/01/2024 11:59:47 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 ( '89371' , '14260' , 'CUORE CHE BATTE - TORNARE AD AMARE IL CREATO' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 08/01/2024 11:59:47 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 ( '89371' , '10364' , 'SULLA STRADA DEL MAESTRO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 08/01/2024 11:59:47 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 ( '89371' , '3511' , 'DIO PARLA ALL\'UOMO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 08/01/2024 11:59:47 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 ( '89371' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 08/01/2024 11:59:47 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 ( '89371' , '20951' , 'STORIE DEL NOSTRO TEMPO - F. CERRI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 08/01/2024 11:59:47 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 ( '89371' , '20954' , 'TEMPO DELL’APOCALISSE ' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 08/01/2024 11:59:47 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 ( '89371' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 08/01/2024 11:59:47 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 ( '89371' , '5644' , 'LEGGERE,... LA PAROLA - ANNO B' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 08/01/2024 11:59:47 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 ( '89371' , '5645' , 'LEGGERE,... LA PAROLA - ANNO C' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 08/01/2024 11:59:47 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 ( '89371' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 08/01/2024 11:59:47 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 ( '89371' , '1002' , 'BEATO CHI ASCOLTA... - ANNO B - B. PREVITALI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 08/01/2024 11:59:47 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 ( '89371' , '1003' , 'BEATO CHI ASCOLTA... - ANNO C - B. PREVITALI ' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 08/01/2024 11:59:47 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 ( '89371' , '18497' , 'BUONA DOMENICA - ANNO A - G. BAGET BOZZO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 08/01/2024 11:59:47 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 ( '89371' , '18498' , 'BUONA DOMENICA - ANNO B - G. BAGET BOZZO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 08/01/2024 11:59:47 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 ( '89371' , '18499' , 'BUONA DOMENICA - ANNO C - G. BAGET BOZZO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 08/01/2024 11:59:47 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 ( '89371' , '8974' , 'RIFORMA DELLA RIFORMA - A. SORRENTINO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 08/01/2024 11:59:47 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 ( '89371' , '1873' , 'CELEBRARE LA PAROLA - ANNO B' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 08/01/2024 11:59:47 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 ( '89371' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 08/01/2024 11:59:47 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 ( '89371' , '15115' , 'CONVERSIONE - G. CELENTANO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 08/01/2024 11:59:47 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 ( '89371' , '17630' , 'RACCONTI SOTTO L\'ALBERO - G. CELENTANO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 08/01/2024 11:59:47 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 ( '89371' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 08/01/2024 11:59:47 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 ( '89371' , '18718' , 'TUA VOCE IN ME - FRA F. MARIA REA' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 08/01/2024 11:59:48 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 ( '89371' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 08/01/2024 11:59:48 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 ( '89371' , '18036' , 'FERITE FERITOIE ' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 08/01/2024 11:59:48 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 ( '89371' , '13137' , 'CON LA BIBBIA E IL CATECHISMO - S. LA PEGNA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 08/01/2024 11:59:48 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 ( '89371' , '17828' , 'ANGELO STRUFFOLINI - A.G. DIBISCEGLIA' , '1' , '-1' , '4' , '26.0000' , '26' , '0' , '0' , '26.00' ) 08/01/2024 11:59:48 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 ( '89371' , '1379' , 'BRUGNOLI MUSICISTA E COMPOSITORE' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 08/01/2024 11:59:48 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 ( '89371' , '20721' , 'AVE MARIA - L. CALABRETTA' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '0' , '4.50' ) 08/01/2024 11:59:48 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 ( '89371' , '20720' , 'PADRE NOSTRO - L. CALABRETTA' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '0' , '4.50' ) 08/01/2024 11:59:48 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 ( '89371' , '21644' , 'INCONTRO AL DIO CHE VIENE' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 08/01/2024 11:59:48 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 ( '89371' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 08/01/2024 11:59:48 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 ( '89371' , '19050' , 'VENITE ADORIAMO - G. D\'AMORE' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 08/01/2024 11:59:48 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 ( '89371' , '20231' , 'PREGANDO NON SPRECATE PAROLE - G. D\'AMORE' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 08/01/2024 11:59:48 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 ( '89371' , '19119' , 'PSICOLOGIA PRATICA PER EDUCATORI' , '1' , '-1' , '4' , '10.5000' , '10.5' , '0' , '0' , '10.50' ) 08/01/2024 11:59:48 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 ( '89371' , '14330' , '100 GIORNI CON LO SPIRITO' , '1' , '-1' , '4' , '7.5000' , '7.5' , '0' , '0' , '7.50' ) 08/01/2024 11:59:48 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 ( '89371' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '1' , '-1' , '4' , '18.5000' , '18.5' , '0' , '0' , '18.50' ) 08/01/2024 11:59:48 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 ( '89371' , '9996' , 'SIGNORE, TI PREGO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 08/01/2024 11:59:48 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 ( '89371' , '20610' , 'SOLE ANCHE DI NOTTE - D. BLAIN' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 08/01/2024 11:59:48 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 ( '89371' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1714.5' , '1714.5' , '0' , '0' , '1714.50' ) 08/01/2024 12:03:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '71' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-08') 08/01/2024 12:03:11 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' , '71' , '2024-01-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.60' , '11.60' , NOW() , NOW() ) 08/01/2024 12:03:11 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 = '89854' 08/01/2024 12:03:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '89854' 08/01/2024 12:03:11 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 ( '89854' , '21809' , 'AMEN - GEN 24' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 08/01/2024 12:03:11 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 ( '89854' , '21810' , 'AMEN - FEB 24' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 08/01/2024 12:03:11 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 ( '89854' , '21919' , 'AMEN - APR 24' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 08/01/2024 12:03:11 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 ( '89854' , '21920' , 'AMEN - MAR 24' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 08/01/2024 12:41:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '72' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-08') 08/01/2024 12:41:29 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' , '72' , '2024-01-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '72.20' , '72.20' , NOW() , NOW() ) 08/01/2024 12:41:29 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 = '89855' 08/01/2024 12:41:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '89855' 08/01/2024 12:41:29 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 ( '89855' , '5892' , 'LITURGIA DELLE ORE II - FRANCESCANA' , '1' , '-1' , '4' , '38.00' , '38' , '0' , '5' , '36.10' ) 08/01/2024 12:41:29 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 ( '89855' , '5893' , 'LITURGIA DELLE ORE III - FRANCESCANA' , '1' , '-1' , '4' , '38.00' , '38' , '0' , '5' , '36.10' ) 08/01/2024 12:42:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '73' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-08') 08/01/2024 12:42:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '73' , '2024-01-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '52.88' , NOW() , NOW() ) 08/01/2024 12:42:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89856' 08/01/2024 12:42:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '89856' 08/01/2024 12:42:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89856' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 08/01/2024 12:42:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89856' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 08/01/2024 12:48:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '108/A' AND id_document != '75582' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-05') 08/01/2024 12:48:55 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '108/A', document_date = '2022-12-05', document_letter = 'A', id_customer = '1192', id_supplier = '', id_address = '1192', address1 = 'VIA ROMA 84020 RICIGLIANO', address2 = '', note = 'ACCONTO GIA\' VERSATO € 1350 - RESTA € 1000 A SALDO ', 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 = '2350.00', price_tax_excluded = '2350.00', date_upd = NOW() WHERE id_document = '75582' 08/01/2024 12:48:55 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 = '75582' 08/01/2024 12:48:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '75582' 08/01/2024 12:48: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 ( '75582' , '0' , 'CASULA MARIANA' , '1' , '-1' , '0' , '2350.0000' , '2350' , '0' , '0' , '2350.00' ) 08/01/2024 02:25:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '3284' AND id_document != '88470' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-23') 08/01/2024 02:25:36 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3284', document_date = '2023-10-23', 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 = '140.00', price_tax_excluded = '114.75', date_upd = NOW() WHERE id_document = '88470' 08/01/2024 02:25:36 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 = '88470' 08/01/2024 02:25:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '88470' 08/01/2024 02:25:36 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 ( '88470' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '101' , '82.786885245902' , '22' , '0' , '101.00' ) 08/01/2024 02:25:36 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 ( '88470' , '20504' , 'CROCE PLEX - 3886' , '1' , '-1' , '1' , '39.00' , '31.967213114754' , '22' , '0' , '39.00' ) 08/01/2024 03:13:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '4/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-08') 08/01/2024 03:13:09 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' , '4/A' , '2024-01-08' , 'A' , '204' , '0' , '4671483' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , '' , 'osp. battipaglia' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.80' , '16.80' , NOW() , NOW() ) 08/01/2024 03:13:09 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 = '89857' 08/01/2024 03:13:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '89857' 08/01/2024 03:13:09 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 ( '89857' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '24' , '-24' , '4' , '0.70' , '0.7' , '0' , '0' , '16.80' ) 08/01/2024 03:14:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '3878' AND id_document != '89344' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-05') 08/01/2024 03:14:07 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3878', document_date = '2023-12-05', 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 = '99.86', price_tax_excluded = '97.97', date_upd = NOW() WHERE id_document = '89344' 08/01/2024 03:14: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 = '89344' 08/01/2024 03:14:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '89344' 08/01/2024 03:14: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 ( '89344' , '5823' , 'LIBRO DORO' , '35' , '-35' , '4' , '0.6000' , '0.6' , '0' , '5' , '19.95' ) 08/01/2024 03:14: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 ( '89344' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '10.50' ) 08/01/2024 03:14: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 ( '89344' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '57.1' , '57.1' , '0' , '0' , '57.10' ) 08/01/2024 03:14: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 ( '89344' , '21744' , 'GIOCA CON SAN FRANCESCO' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '5' , '9.41' ) 08/01/2024 03:14: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 ( '89344' , '21809' , 'AMEN - GEN 24' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 08/01/2024 03:21:07 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3496' 08/01/2024 03:21:07 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 ( '3496' , '10' , '170' , '' , 'VALSECCHI' , 'P. GIUSEPPE' , 'VIA ALLA BASILICA 1' , '' , '23808' , 'VERCURAGO' , '' , '' , '' , '' , '' , NOW() , NOW() ) 08/01/2024 03:21:07 pm >> UPDATE ps_customer SET email = 'gi.val@tiscali.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3496' 08/01/2024 03:33:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '320' AND id_document != '89564' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-12-18') 08/01/2024 03:33:22 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '320', document_date = '2023-12-18', document_letter = '', id_customer = '1879', id_supplier = '0', id_address = '1879', address1 = 'VIA PARROCO PALI 39020 SLUDERNO', address2 = '', note = 'copie omaggio autore', price_shipping = '', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '17', id_causal = '0', price_tax_included = '0.00', price_tax_excluded = '0.00', date_upd = NOW() WHERE id_document = '89564' 08/01/2024 03:33:22 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 = '89564' 08/01/2024 03:33:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '89564' 08/01/2024 03:33:22 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 ( '89564' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '2' , '-2' , '4' , '25.00' , '25' , '0' , '100' , '0.00' ) 08/01/2024 04:25:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '74' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-08') 08/01/2024 04:25: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 ( '11' , '74' , '2024-01-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.10' , '14.09' , NOW() , NOW() ) 08/01/2024 04:25: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 = '89858' 08/01/2024 04:25:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '89858' 08/01/2024 04:25: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 ( '89858' , '13034' , 'STORIE DELLA BIBBIA IN 1000 ADESIVI - 8887' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 08/01/2024 04:25: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 ( '89858' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '2.8' , '2.2950819672131' , '22' , '0' , '5.60' ) 08/01/2024 04:26:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '75' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-08') 08/01/2024 04:26:11 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' , '75' , '2024-01-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.70' , '5.70' , NOW() , NOW() ) 08/01/2024 04:26:11 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 = '89859' 08/01/2024 04:26:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '89859' 08/01/2024 04:26:11 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 ( '89859' , '21751' , 'MESSALINO QUOTIDIANO - FEB-MAR-APR 2024' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 08/01/2024 04:32:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '76' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-08') 08/01/2024 04:32: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 ( '11' , '76' , '2024-01-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.20' , '15.20' , NOW() , NOW() ) 08/01/2024 04:32: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 = '89860' 08/01/2024 04:32:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '89860' 08/01/2024 04:32: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 ( '89860' , '21869' , 'MESSA MEDITAZIONE - MAR/APR 2024' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 08/01/2024 04:32: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 ( '89860' , '21868' , 'MESSA MEDITAZIONE - GEN/FEB 2024' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 08/01/2024 04:44:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '77' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-08') 08/01/2024 04:44:15 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' , '77' , '2024-01-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '4.92' , NOW() , NOW() ) 08/01/2024 04:44:15 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 = '89861' 08/01/2024 04:44:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '89861' 08/01/2024 04:44:15 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 ( '89861' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 08/01/2024 04:44:15 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 ( '89861' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '1.10' ) 08/01/2024 07:08:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '78' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-08') 08/01/2024 07:08:59 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' , '78' , '2024-01-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.50' , '15.16' , NOW() , NOW() ) 08/01/2024 07:08:59 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 = '89862' 08/01/2024 07:08:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '89862' 08/01/2024 07:08:59 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 ( '89862' , '19781' , 'BRACCIALE ARGENTO/EMATITE - 1793CAV' , '1' , '-1' , '1' , '18.50' , '15.16393442623' , '22' , '0' , '18.50' )