01/12/2025 08:49:20 am >> SELECT document_num FROM ps_document WHERE document_num = '147/A' AND id_document != '100175' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-29') 01/12/2025 08:49:20 am >> UPDATE ps_document SET id_document_type = '24', document_num = '147/A', document_date = '2025-11-29', document_letter = 'A', id_customer = '1178', id_supplier = '', id_address = '4679509', address1 = 'P. ZZA LINGUITI, 1 84095 GIFFONI VALLE PIANA', 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 = '95.00', price_tax_excluded = '77.87', date_upd = NOW() WHERE id_document = '100175' 01/12/2025 08:49:20 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 = '100175' 01/12/2025 08:49:20 am >> DELETE FROM ps_document_detail WHERE id_document = '100175' 01/12/2025 08:49:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100175' , '17571' , 'BAMBINO IN RESINA CM 23 - PB9422' , '1' , '-1' , '1' , '34.0000' , '27.868852459016' , '22' , '0' , '34.00' ) 01/12/2025 08:49:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100175' , '24193' , 'NATIVITA 21X25 - P802' , '1' , '-1' , '1' , '61.0000' , '50' , '22' , '0' , '61.00' ) 01/12/2025 08:51:40 am >> SELECT document_num FROM ps_document WHERE document_num = '3986' AND id_document != '100170' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-29') 01/12/2025 08:51:40 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3986', document_date = '2025-11-29', document_letter = '', id_customer = '', id_supplier = '', id_address = '', address1 = 'P.ZZA GIOVANNI PAOLO II, 4 84080 COPERCHIA', 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 = '120.90', price_tax_excluded = '107.32', date_upd = NOW() WHERE id_document = '100170' 01/12/2025 08:51:40 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 = '100170' 01/12/2025 08:51:40 am >> DELETE FROM ps_document_detail WHERE id_document = '100170' 01/12/2025 08:51:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100170' , '23131' , 'TEMPO DEL PERDONO - F. CRISTOFARO' , '3' , '-3' , '4' , '16.0000' , '16' , '0' , '5' , '45.60' ) 01/12/2025 08:51:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100170' , '23095' , 'PORTACHIAVI GIUBILEO - G1878' , '15' , '-15' , '1' , '2.3000' , '1.8852459016393' , '22' , '0' , '34.50' ) 01/12/2025 08:51:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100170' , '23425' , 'ROSARIO GIUBILEO - 198/1-G25' , '12' , '-12' , '1' , '3.4000' , '2.7868852459016' , '22' , '0' , '40.80' ) 01/12/2025 08:56:05 am >> DELETE FROM ps_document WHERE id_document = '96002' 01/12/2025 08:56:05 am >> DELETE FROM ps_document_detail WHERE id_document = '96002' 01/12/2025 09:34:04 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'v5U3d4Nuiu937fx9' , NOW() , NOW() ) 01/12/2025 09:34:04 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4293' , '1' ) 01/12/2025 09:34:04 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4293' , '2' ) 01/12/2025 09:34:04 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4293' , '3' ) 01/12/2025 09:35:04 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4293' 01/12/2025 09:35:04 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4293' , '10' , '210' , '' , 'STABILE' , 'ANTONELLA' , 'VIA DELLA PARROCCHIA 19' , '' , '84022' , 'CAMPAGNA' , '' , '' , '3274955416' , '' , '' , NOW() , NOW() ) 01/12/2025 09:35:04 am >> UPDATE ps_customer SET email = 'wosarp@virgilio.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4293' 01/12/2025 09:37:18 am >> SELECT document_num FROM ps_document WHERE document_num = '264' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-12-01') 01/12/2025 09:37:18 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '264' , '2025-12-01' , '' , '4293' , '0' , '4679667' , 'VIA DELLA PARROCCHIA 19 84022 CAMPAGNA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '123.36' , '123.36' , NOW() , NOW() ) 01/12/2025 09:37:18 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 = '100178' 01/12/2025 09:37:18 am >> DELETE FROM ps_document_detail WHERE id_document = '100178' 01/12/2025 09:37:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100178' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '6' , '-6' , '4' , '3.80' , '3.8' , '0' , '5' , '21.66' ) 01/12/2025 09:37:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100178' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '6' , '-6' , '4' , '3.80' , '3.8' , '0' , '5' , '21.66' ) 01/12/2025 09:37:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100178' , '5457' , 'IO SONO CON VOI 1 PARTE' , '13' , '-13' , '4' , '2.80' , '2.8' , '0' , '5' , '34.58' ) 01/12/2025 09:37:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100178' , '11191' , 'VENITE CON ME 1 PARTE' , '16' , '-16' , '4' , '2.80' , '2.8' , '0' , '5' , '42.56' ) 01/12/2025 09:37:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100178' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 01/12/2025 09:40:57 am >> SELECT document_num FROM ps_document WHERE document_num = '264' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-12-01') 01/12/2025 09:41:02 am >> SELECT document_num FROM ps_document WHERE document_num = '265' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-12-01') 01/12/2025 09:41:02 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '265' , '2025-12-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.55' , '47.55' , NOW() , NOW() ) 01/12/2025 09:41:02 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100179' 01/12/2025 09:41:02 am >> DELETE FROM ps_document_detail WHERE id_document = '100179' 01/12/2025 09:41:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100179' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '12' , '-12' , '4' , '3.50' , '3.5' , '0' , '5' , '39.90' ) 01/12/2025 09:41:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100179' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 01/12/2025 09:41:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100179' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 01/12/2025 09:41:20 am >> SELECT document_num FROM ps_document WHERE document_num = '265' AND id_document != '100179' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-12-01') 01/12/2025 09:41:20 am >> UPDATE ps_document SET id_document_type = '21', document_num = '265', document_date = '2025-12-01', document_letter = '', id_customer = '3998', id_supplier = '0', id_address = '4678094', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '47.55', price_tax_excluded = '47.55', date_upd = NOW() WHERE id_document = '100179' 01/12/2025 09:41:20 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 = '100179' 01/12/2025 09:41:20 am >> DELETE FROM ps_document_detail WHERE id_document = '100179' 01/12/2025 09:41:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100179' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '12' , '-12' , '4' , '3.5000' , '3.5' , '0' , '5' , '39.90' ) 01/12/2025 09:41:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100179' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 01/12/2025 09:41:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100179' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 01/12/2025 09:42:59 am >> SELECT document_num FROM ps_document WHERE document_num = '265' AND id_document != '100179' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-12-01') 01/12/2025 09:42:59 am >> UPDATE ps_document SET id_document_type = '21', document_num = '265', document_date = '2025-12-01', document_letter = '', id_customer = '3998', id_supplier = '', id_address = '4678094', address1 = '', address2 = '', note = '', price_shipping = '5', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '52.55', price_tax_excluded = '52.55', date_upd = NOW() WHERE id_document = '100179' 01/12/2025 09:42:59 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 = '100179' 01/12/2025 09:42:59 am >> DELETE FROM ps_document_detail WHERE id_document = '100179' 01/12/2025 09:42:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100179' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '12' , '-12' , '4' , '3.5000' , '3.5' , '0' , '5' , '39.90' ) 01/12/2025 09:42:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100179' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 01/12/2025 09:42:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100179' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 01/12/2025 10:25:35 am >> SELECT document_num FROM ps_document WHERE document_num = '3993' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-01') 01/12/2025 10:25:35 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' , '3993' , '2025-12-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '142.00' , '116.39' , NOW() , NOW() ) 01/12/2025 10:25:35 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 = '100180' 01/12/2025 10:25:35 am >> DELETE FROM ps_document_detail WHERE id_document = '100180' 01/12/2025 10:25:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100180' , '23189' , 'GRUPPO NATIVITA\' STILIZZATA - PB18073' , '71' , '-71' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '142.00' ) 01/12/2025 10:28:10 am >> SELECT document_num FROM ps_document WHERE document_num = '3994' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-01') 01/12/2025 10:28:10 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3994' , '2025-12-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.60' , '45.57' , NOW() , NOW() ) 01/12/2025 10:28: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 = '100181' 01/12/2025 10:28:10 am >> DELETE FROM ps_document_detail WHERE id_document = '100181' 01/12/2025 10:28: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 ( '100181' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '4' , '-4' , '1' , '13' , '10.655737704918' , '22' , '0' , '52.00' ) 01/12/2025 10:28: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 ( '100181' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '3.60' ) 01/12/2025 10:37:26 am >> SELECT document_num FROM ps_document WHERE document_num = '3995' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-01') 01/12/2025 10:37: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 ( '11' , '3995' , '2025-12-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '13.46' , NOW() , NOW() ) 01/12/2025 10:37: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 = '100182' 01/12/2025 10:37:26 am >> DELETE FROM ps_document_detail WHERE id_document = '100182' 01/12/2025 10:37: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 ( '100182' , '7311' , 'OSTIA SOTTILE 74MM' , '7' , '-7' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '14.00' ) 01/12/2025 10:53:42 am >> SELECT document_num FROM ps_document WHERE document_num = '3996' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-01') 01/12/2025 10:53:42 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' , '3996' , '2025-12-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '86.00' , '76.59' , NOW() , NOW() ) 01/12/2025 10:53: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 = '100183' 01/12/2025 10:53:42 am >> DELETE FROM ps_document_detail WHERE id_document = '100183' 01/12/2025 10:53: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 ( '100183' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 01/12/2025 10:53: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 ( '100183' , '17711' , 'OSTIA MAGNA CM 18 - OM 180' , '1' , '-1' , '3' , '8.50' , '8.1730769230769' , '4' , '0' , '8.50' ) 01/12/2025 10:53: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 ( '100183' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '3' , '-3' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '13.50' ) 01/12/2025 10:53: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 ( '100183' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 01/12/2025 10:53: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 ( '100183' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 01/12/2025 11:03:14 am >> SELECT document_num FROM ps_document WHERE document_num = '3997' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-01') 01/12/2025 11:03:14 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3997' , '2025-12-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '229.20' , '189.15' , NOW() , NOW() ) 01/12/2025 11:03:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100184' 01/12/2025 11:03:14 am >> DELETE FROM ps_document_detail WHERE id_document = '100184' 01/12/2025 11:03:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100184' , '918' , 'BALZA RICAMATA - VIOLA - CM 16 - KOM/030 ' , '1' , '-1' , '1' , '100' , '81.967213114754' , '22' , '0' , '100.00' ) 01/12/2025 11:03:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100184' , '14018' , 'BALZA ' , '1.9' , '-1.9' , '1' , '38' , '31.147540983607' , '22' , '0' , '72.20' ) 01/12/2025 11:03:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100184' , '23308' , 'FINTA CANDELA CON CARTUCCIA 3,2X30 - 1132' , '2' , '-2' , '1' , '24.00' , '19.672131147541' , '22' , '0' , '48.00' ) 01/12/2025 11:03:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100184' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '9.00' ) 01/12/2025 11:09:06 am >> SELECT document_num FROM ps_document WHERE document_num = '3998' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-01') 01/12/2025 11:09:06 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3998' , '2025-12-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.00' , '57.00' , NOW() , NOW() ) 01/12/2025 11:09:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100185' 01/12/2025 11:09:06 am >> DELETE FROM ps_document_detail WHERE id_document = '100185' 01/12/2025 11:09:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100185' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '12' , '-12' , '4' , '5.00' , '5' , '0' , '5' , '57.00' ) 01/12/2025 11:38:08 am >> SELECT document_num FROM ps_document WHERE document_num = '3999' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-01') 01/12/2025 11:38:09 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' , '3999' , '2025-12-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '2.46' , NOW() , NOW() ) 01/12/2025 11:38:09 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 = '100186' 01/12/2025 11:38:09 am >> DELETE FROM ps_document_detail WHERE id_document = '100186' 01/12/2025 11:38:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100186' , '1350' , 'BRACCIALETTO CON CROCE - 29002 03' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 01/12/2025 11:46:18 am >> SELECT document_num FROM ps_document WHERE document_num = '4000' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-01') 01/12/2025 11:46:18 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' , '4000' , '2025-12-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.90' , '4.02' , NOW() , NOW() ) 01/12/2025 11:46:18 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 = '100187' 01/12/2025 11:46:18 am >> DELETE FROM ps_document_detail WHERE id_document = '100187' 01/12/2025 11:46:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100187' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 01/12/2025 12:00:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '4001' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-01') 01/12/2025 12:00:05 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' , '4001' , '2025-12-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '95.00' , '77.87' , NOW() , NOW() ) 01/12/2025 12:00:05 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 = '100188' 01/12/2025 12:00:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '100188' 01/12/2025 12:00:05 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 ( '100188' , '17571' , 'BAMBINO IN RESINA CM 23 - PB9422' , '1' , '-1' , '1' , '34.00' , '27.868852459016' , '22' , '0' , '34.00' ) 01/12/2025 12:00:05 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 ( '100188' , '24193' , 'NATIVITA\' 21X25 - P802' , '1' , '-1' , '1' , '61' , '50' , '22' , '0' , '61.00' ) 01/12/2025 12:03:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '4002' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-01') 01/12/2025 12:03:14 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' , '4002' , '2025-12-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.00' , '42.62' , NOW() , NOW() ) 01/12/2025 12:03:14 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 = '100189' 01/12/2025 12:03:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '100189' 01/12/2025 12:03:14 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 ( '100189' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '4' , '-4' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '52.00' ) 01/12/2025 12:27:02 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3895' 01/12/2025 12:27:03 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 ( '3895' , '10' , '210' , 'Parrocchia S. Andrea Apostolo' , 'Porpora' , 'DON Antonio' , 'Piazza Duomo 1' , '' , '84011' , 'Amalfi' , '' , '' , '3387750032' , '' , '' , NOW() , NOW() ) 01/12/2025 12:27:03 pm >> UPDATE ps_customer SET email = 'amalfiparrocchia@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3895' 01/12/2025 03:42:01 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '2144' 01/12/2025 03:42:01 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 ( '2144' , '10' , '179' , '' , 'BELLA PAOLO' , '' , 'VIA UMBERTO I 69' , '' , '98046' , 'S. LUCIA DEL MELA' , '' , '090/9410490 ' , '3281036502' , '' , '' , NOW() , NOW() ) 01/12/2025 03:42:01 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '2144' 01/12/2025 03:42:22 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '2144' 01/12/2025 03:42:22 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 ( '2144' , '10' , '179' , '' , 'BELLA ' , 'PAOLO' , 'VIA UMBERTO I 69' , '' , '98046' , 'S. LUCIA DEL MELA' , '' , '090/9410490 ' , '3281036502' , '' , '' , NOW() , NOW() ) 01/12/2025 03:42:22 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '2144' 01/12/2025 03:44:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '266' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-12-01') 01/12/2025 03:44:25 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' , '266' , '2025-12-01' , '' , '2144' , '0' , '4679670' , 'VIA UMBERTO I 69 98046 S. LUCIA DEL MELA' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '31.60' , '26.80' , NOW() , NOW() ) 01/12/2025 03:44:25 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 = '100190' 01/12/2025 03:44:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '100190' 01/12/2025 03:44:25 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 ( '100190' , '24073' , 'AGENDA LITURGICO PASTORALE 2026 - 40830' , '2' , '-2' , '1' , '14.00' , '11.475409836066' , '22' , '5' , '26.60' ) 01/12/2025 03:52:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '4003' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-01') 01/12/2025 03:52:50 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' , '4003' , '2025-12-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 01/12/2025 03:52:50 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 = '100191' 01/12/2025 03:52:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '100191' 01/12/2025 03:52:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100191' , '8288' , 'PREGHIERA DEL MATTINO E DELLA SERA - GR - PER LAICI' , '1' , '-1' , '4' , '19' , '19' , '0' , '0' , '19.00' ) 01/12/2025 04:46:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '4004' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-01') 01/12/2025 04:46:23 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' , '4004' , '2025-12-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.50' , '9.43' , NOW() , NOW() ) 01/12/2025 04:46:23 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 = '100192' 01/12/2025 04:46:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '100192' 01/12/2025 04:46:23 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 ( '100192' , '24270' , 'SET 4 CANDELE AVVENTO - P764MUL' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 01/12/2025 04:46:23 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 ( '100192' , '6811' , 'MOCCOLO 80X200' , '1' , '-1' , '1' , '9.50' , '7.7868852459016' , '22' , '0' , '9.50' ) 01/12/2025 04:55:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '4005' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-01') 01/12/2025 04:55:54 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4005' , '2025-12-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.21' , '14.21' , NOW() , NOW() ) 01/12/2025 04:55:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100193' 01/12/2025 04:55:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '100193' 01/12/2025 04:55:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100193' , '24096' , 'AVVENTO E NATALE 2025/26' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 01/12/2025 04:55:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100193' , '24232' , 'MESSA MEDITAZIONE - GEN/FEB 26' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 01/12/2025 04:55:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100193' , '23988' , 'AMEN - DIC 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 01/12/2025 06:45:37 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '979' 01/12/2025 06:45:38 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 ( '979' , '10' , '210' , 'PARROCCHIA SS. FELICE E GIOVANNI B. ' , 'DELLA ROCCA' , 'DON MASSIMO' , 'VIA ROBERTO MAZZETTI, 5/A' , '' , '84135' , 'SALERNO' , '' , '' , '' , '' , '95019510650' , NOW() , NOW() ) 01/12/2025 06:45:38 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '979' 01/12/2025 06:47:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '267' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-12-01') 01/12/2025 06:47: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 ( '21' , '267' , '2025-12-01' , '' , '979' , '0' , '4679671' , 'VIA ROBERTO MAZZETTI, 5/A 84135 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.60' , '47.60' , NOW() , NOW() ) 01/12/2025 06:47: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 = '100194' 01/12/2025 06:47:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '100194' 01/12/2025 06:47:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100194' , '2679' , 'CONOSCERE GESU\'' , '16' , '-16' , '4' , '3.50' , '3.5' , '0' , '15' , '47.60' ) 01/12/2025 06:48:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '4006' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-01') 01/12/2025 06:48:03 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4006' , '2025-12-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '0.82' , NOW() , NOW() ) 01/12/2025 06:48:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100195' 01/12/2025 06:48:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '100195' 01/12/2025 06:48:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100195' , '12819' , 'REGISTRO DEL CATECHISTA ' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 01/12/2025 06:52:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '267' AND id_document != '100194' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-12-01') 01/12/2025 06:52:36 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '267', document_date = '2025-12-01', document_letter = '', id_customer = '979', id_supplier = '', id_address = '4679671', address1 = 'VIA ROBERTO MAZZETTI, 5/A 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '47.60', price_tax_excluded = '47.60', date_upd = NOW() WHERE id_document = '100194' 01/12/2025 06:52: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 = '100194' 01/12/2025 06:52:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '100194' 01/12/2025 06:52:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100194' , '2679' , 'CONOSCERE GESU\'' , '16' , '-16' , '4' , '3.5000' , '3.5' , '0' , '15' , '47.60' ) 01/12/2025 07:14:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '4007' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-01') 01/12/2025 07:14:48 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' , '4007' , '2025-12-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '1.64' , NOW() , NOW() ) 01/12/2025 07:14:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100196' 01/12/2025 07:14:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '100196' 01/12/2025 07:14:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100196' , '24270' , 'SET 4 CANDELE AVVENTO - P764MUL' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 01/12/2025 07:34:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '185' AND id_document != '99619' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-03') 01/12/2025 07:34:17 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '185', document_date = '2025-11-03', document_letter = '', id_customer = '1155', id_supplier = '', id_address = '4672061', address1 = 'C.SO DIAZ, 83 84085 MERCATO S. SEVERINO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '57.00', price_tax_excluded = '57.00', date_upd = NOW() WHERE id_document = '99619' 01/12/2025 07:34:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99619' 01/12/2025 07:34:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '99619' 01/12/2025 07:34:17 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 ( '99619' , '11192' , 'VENITE CON ME 2 PARTE' , '24' , '-24' , '4' , '2.8000' , '2.8' , '0' , '15' , '57.12' ) 01/12/2025 07:34:17 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 ( '99619' , '0' , 'ARROTONDAMENTO' , '1' , '-1' , '0' , '-0.1200' , '-0.12' , '0' , '0' , '-0.12' ) 01/12/2025 07:35:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '187' AND id_document != '99624' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-03') 01/12/2025 07:35:31 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '187', document_date = '2025-11-03', document_letter = '', id_customer = '3980', id_supplier = '', id_address = '4679588', address1 = 'P. ZZA RISORGIMENTO 1 80047 S. GIUSEPPE VESUVIANO', 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 = '95.00', price_tax_excluded = '95.00', date_upd = NOW() WHERE id_document = '99624' 01/12/2025 07:35:31 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 = '99624' 01/12/2025 07:35:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '99624' 01/12/2025 07:35:31 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 ( '99624' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '30' , '-30' , '4' , '3.50' , '3.5' , '0' , '15' , '89.25' ) 01/12/2025 07:35:31 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 ( '99624' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' , '5.75' , '5.75' , '0' , '0' , '5.75' ) 01/12/2025 07:37:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '190' AND id_document != '99628' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-03') 01/12/2025 07:37:52 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '190', document_date = '2025-11-03', document_letter = '', id_customer = '3983', id_supplier = '', id_address = '4679455', address1 = 'P. ZZA ANNUNZIATA 03037 PONTECORVO', 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 = '391.68', price_tax_excluded = '391.68', date_upd = NOW() WHERE id_document = '99628' 01/12/2025 07:37:52 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 = '99628' 01/12/2025 07:37:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '99628' 01/12/2025 07:37:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99628' , '5458' , 'IO SONO CON VOI 2 PARTE' , '16' , '-16' , '4' , '2.8000' , '2.8' , '0' , '15' , '38.08' ) 01/12/2025 07:37:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99628' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '15' , '59.50' ) 01/12/2025 07:37:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99628' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '15' , '8.50' ) 01/12/2025 07:37:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99628' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '23' , '-23' , '4' , '5.5000' , '5.5' , '0' , '0' , '126.50' ) 01/12/2025 07:37:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99628' , '11193' , 'VENITE CON ME CAT.' , '28' , '-28' , '4' , '5.5000' , '5.5' , '0' , '0' , '154.00' ) 01/12/2025 07:37:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99628' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '2' , '-2' , '4' , '2.55' , '2.55' , '0' , '0' , '5.10' ) 01/12/2025 07:41:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '207' AND id_document != '99740' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-06') 01/12/2025 07:41:14 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '207', document_date = '2025-11-06', document_letter = '', id_customer = '284', id_supplier = '', id_address = '4671723', address1 = 'VIA GUIDO D\\\'AREZZO snc 92027 LICATA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '476.00', price_tax_excluded = '476.00', date_upd = NOW() WHERE id_document = '99740' 01/12/2025 07:41:14 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 = '99740' 01/12/2025 07:41:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '99740' 01/12/2025 07:41:14 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 ( '99740' , '5458' , 'IO SONO CON VOI 2 PARTE' , '100' , '-100' , '4' , '2.8000' , '2.8' , '0' , '15' , '238.00' ) 01/12/2025 07:41:14 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 ( '99740' , '11192' , 'VENITE CON ME 2 PARTE' , '100' , '-100' , '4' , '2.8000' , '2.8' , '0' , '15' , '238.00' ) 01/12/2025 07:43:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '219' AND id_document != '99811' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-10') 01/12/2025 07:43:51 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '219', document_date = '2025-11-10', document_letter = '', id_customer = '371', id_supplier = '', id_address = '4679589', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '386.69', price_tax_excluded = '386.69', date_upd = NOW() WHERE id_document = '99811' 01/12/2025 07:43:51 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 = '99811' 01/12/2025 07:43:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '99811' 01/12/2025 07:43:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99811' , '2679' , 'CONOSCERE GESU\'' , '10' , '-10' , '4' , '3.5000' , '3.5' , '0' , '15' , '29.75' ) 01/12/2025 07:43:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99811' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '50' , '-50' , '4' , '3.8000' , '3.8' , '0' , '15' , '161.50' ) 01/12/2025 07:43:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99811' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '18' , '-18' , '4' , '3.8000' , '3.8' , '0' , '15' , '58.14' ) 01/12/2025 07:43:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99811' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '25' , '-25' , '4' , '3.8000' , '3.8' , '0' , '15' , '80.75' ) 01/12/2025 07:43:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99811' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '3' , '-3' , '4' , '10.0000' , '10' , '0' , '15' , '25.50' ) 01/12/2025 07:43:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99811' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '3' , '-3' , '4' , '10.0000' , '10' , '0' , '15' , '25.50' ) 01/12/2025 07:43:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99811' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '15' , '2.55' ) 01/12/2025 07:43:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99811' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 01/12/2025 07:45:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '224' AND id_document != '99838' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-11') 01/12/2025 07:45:41 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '224', document_date = '2025-11-11', document_letter = '', id_customer = '65', id_supplier = '', id_address = '4679517', address1 = 'VIA SAN MARCO 1 81016 CASTELLO DEL MATESE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '72.75', price_tax_excluded = '72.75', date_upd = NOW() WHERE id_document = '99838' 01/12/2025 07:45:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99838' 01/12/2025 07:45:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '99838' 01/12/2025 07:45:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99838' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '16' , '-16' , '4' , '2.5000' , '2.5' , '0' , '5' , '38.00' ) 01/12/2025 07:45:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99838' , '24129' , 'DIECI COMANDAMENTI - M. DE ROSA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 01/12/2025 07:45:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99838' , '5193' , 'IN PREGHIERA CON SAN MASSIMILIANO KOLBE - 8646' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 01/12/2025 07:45:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99838' , '24220' , 'SIATE SANTI SIATE FELICI - 8404' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 01/12/2025 07:45:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99838' , '6317' , 'MEDAGLIA MIRACOLOSA - 8332' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 01/12/2025 07:45:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99838' , '0' , 'spese di contrassegno' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 01/12/2025 07:45:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99838' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 01/12/2025 07:46:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '225' AND id_document != '99841' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-12') 01/12/2025 07:46:10 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '225', document_date = '2025-11-12', document_letter = '', id_customer = '3974', id_supplier = '', id_address = '4679637', address1 = 'BORGO SAN GIOVANNI 754 30015 CHIOGGIA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '211.40', price_tax_excluded = '211.40', date_upd = NOW() WHERE id_document = '99841' 01/12/2025 07:46:10 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 = '99841' 01/12/2025 07:46:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '99841' 01/12/2025 07:46:10 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 ( '99841' , '13397' , 'MIO GESU\'' , '25' , '-25' , '4' , '3.5000' , '3.5' , '0' , '15' , '74.38' ) 01/12/2025 07:46:10 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 ( '99841' , '2679' , 'CONOSCERE GESU\'' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '15' , '59.50' ) 01/12/2025 07:46:10 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 ( '99841' , '4154' , 'FESTA DEL PERDONO' , '25' , '-25' , '4' , '3.0000' , '3' , '0' , '15' , '63.75' ) 01/12/2025 07:46:10 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 ( '99841' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '2' , '-2' , '4' , '2.5' , '2.5' , '0' , '0' , '5.00' ) 01/12/2025 07:46:10 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 ( '99841' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '15' , '2.98' ) 01/12/2025 07:46:10 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 ( '99841' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '1' , '-1' , '4' , '3.4000' , '3.4' , '0' , '15' , '2.89' ) 01/12/2025 07:46:10 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 ( '99841' , '22028' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 01/12/2025 07:47:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '226' AND id_document != '99848' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-12') 01/12/2025 07:47:04 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '226', document_date = '2025-11-12', document_letter = '', id_customer = '357', id_supplier = '', id_address = '4676034', address1 = 'VIA TORRIONE 84100 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '441.33', price_tax_excluded = '441.33', date_upd = NOW() WHERE id_document = '99848' 01/12/2025 07:47:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99848' 01/12/2025 07:47:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '99848' 01/12/2025 07:47:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99848' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '30' , '-30' , '4' , '3.8000' , '3.8' , '0' , '15' , '96.90' ) 01/12/2025 07:47:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99848' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '15' , '-15' , '4' , '3.8000' , '3.8' , '0' , '15' , '48.45' ) 01/12/2025 07:47:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99848' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '2' , '-2' , '4' , '10.0000' , '10' , '0' , '15' , '17.00' ) 01/12/2025 07:47:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99848' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '4' , '-4' , '4' , '10.0000' , '10' , '0' , '15' , '34.00' ) 01/12/2025 07:47:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99848' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '45' , '-45' , '4' , '2.8000' , '2.8' , '0' , '15' , '107.10' ) 01/12/2025 07:47:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99848' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '2' , '-2' , '4' , '2' , '2' , '0' , '0' , '4.00' ) 01/12/2025 07:47:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99848' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '45' , '-45' , '4' , '3.5000' , '3.5' , '0' , '15' , '133.88' ) 01/12/2025 07:48:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '227' AND id_document != '99857' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-12') 01/12/2025 07:48:59 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '227', document_date = '2025-11-12', document_letter = '', id_customer = '114', id_supplier = '', id_address = '4679640', address1 = 'VIA ROMA 2 11013 COURMAYEUR', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '154.14', price_tax_excluded = '154.14', date_upd = NOW() WHERE id_document = '99857' 01/12/2025 07:48: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 = '99857' 01/12/2025 07:48:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '99857' 01/12/2025 07:48: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 ( '99857' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '40' , '-40' , '4' , '3.0000' , '3' , '0' , '5' , '114.00' ) 01/12/2025 07:48: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 ( '99857' , '22029' , 'PREPARIAMOCI ALLA PRIMA CONFESSIONE - POSTER' , '3' , '-3' , '4' , '2.0000' , '2' , '0' , '5' , '5.70' ) 01/12/2025 07:48: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 ( '99857' , '22030' , 'PREPARIAMOCI ALLA PRIMA COMUNIONE - POSTER' , '3' , '-3' , '4' , '2.0000' , '2' , '0' , '5' , '5.70' ) 01/12/2025 07:48: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 ( '99857' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '3' , '-3' , '4' , '8.0000' , '8' , '0' , '5' , '22.80' ) 01/12/2025 07:48: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 ( '99857' , '0' , 'ARROTONDAMENTO' , '1' , '-1' , '4' , '-0.0300' , '-0.03' , '0' , '0' , '-0.03' ) 01/12/2025 07:48: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 ( '99857' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '-1' , '4' , '2.97' , '2.97' , '0' , '0' , '2.97' ) 01/12/2025 07:48: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 ( '99857' , '1833' , 'CATECHISTA: VOCAZIONE E MISSIONE ' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 01/12/2025 07:49:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '4008' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-01') 01/12/2025 07:49:23 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' , '4008' , '2025-12-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.50' , '5.29' , NOW() , NOW() ) 01/12/2025 07:49:23 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 = '100197' 01/12/2025 07:49:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '100197' 01/12/2025 07:49:23 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 ( '100197' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 01/12/2025 07:49:23 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 ( '100197' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 01/12/2025 07:51:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '228' AND id_document != '99860' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-12') 01/12/2025 07:51:49 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '228', document_date = '2025-11-12', document_letter = '', id_customer = '4141', id_supplier = '', id_address = '4679424', address1 = 'VIA SAN GIOVANNI - FRAZ. FERRARI 83020 SERINO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '61.88', price_tax_excluded = '61.88', date_upd = NOW() WHERE id_document = '99860' 01/12/2025 07:51: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 = '99860' 01/12/2025 07:51:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '99860' 01/12/2025 07:51: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 ( '99860' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '-1' , '4' , '1.78' , '1.78' , '0' , '0' , '1.78' ) 01/12/2025 07:51: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 ( '99860' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '14' , '-14' , '4' , '2.8000' , '2.8' , '0' , '15' , '33.32' ) 01/12/2025 07:51: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 ( '99860' , '2679' , 'CONOSCERE GESU\'' , '9' , '-9' , '4' , '3.50' , '3.5' , '0' , '15' , '26.78' ) 01/12/2025 07:53:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '232' AND id_document != '99910' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-14') 01/12/2025 07:53:38 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '232', document_date = '2025-11-14', document_letter = '', id_customer = '3770', id_supplier = '', id_address = '4671727', address1 = 'VIALE MARCONI 2 65020 ROSCIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '92.10', price_tax_excluded = '92.10', date_upd = NOW() WHERE id_document = '99910' 01/12/2025 07:53:38 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 = '99910' 01/12/2025 07:53:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '99910' 01/12/2025 07:53:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99910' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '-1' , '4' , '2.12' , '2.12' , '0' , '0' , '2.12' ) 01/12/2025 07:53:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99910' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '15' , '2.55' ) 01/12/2025 07:53:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99910' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '10' , '-10' , '4' , '2.5000' , '2.5' , '0' , '15' , '21.25' ) 01/12/2025 07:53:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99910' , '11193' , 'VENITE CON ME CAT.' , '5' , '-5' , '4' , '5.5000' , '5.5' , '0' , '0' , '27.50' ) 01/12/2025 07:53:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99910' , '2679' , 'CONOSCERE GESU\'' , '13' , '-13' , '4' , '3.50' , '3.5' , '0' , '15' , '38.68' ) 01/12/2025 07:54:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '233' AND id_document != '99914' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-14') 01/12/2025 07:54:19 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '233', document_date = '2025-11-14', document_letter = '', id_customer = '3266', id_supplier = '', id_address = '4679452', address1 = 'VIA DANTE 35 07010 MARA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '136.00', price_tax_excluded = '136.00', date_upd = NOW() WHERE id_document = '99914' 01/12/2025 07:54:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99914' 01/12/2025 07:54:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '99914' 01/12/2025 07:54:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99914' , '5457' , 'IO SONO CON VOI 1 PARTE' , '6' , '-6' , '4' , '2.8000' , '2.8' , '0' , '5' , '15.96' ) 01/12/2025 07:54:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99914' , '5458' , 'IO SONO CON VOI 2 PARTE' , '6' , '-6' , '4' , '2.8000' , '2.8' , '0' , '5' , '15.96' ) 01/12/2025 07:54:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99914' , '5444' , 'IO SONO CON VOI - CAT.' , '6' , '-6' , '4' , '5.5000' , '5.5' , '0' , '0' , '33.00' ) 01/12/2025 07:54:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99914' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '8' , '-8' , '4' , '5.5000' , '5.5' , '0' , '0' , '44.00' ) 01/12/2025 07:54:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99914' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '2' , '-2' , '4' , '2.1' , '2.1' , '0' , '0' , '4.20' ) 01/12/2025 07:54:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99914' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '6' , '-6' , '4' , '3.5000' , '3.5' , '0' , '5' , '19.95' ) 01/12/2025 07:54:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99914' , '0' , 'SPESE DI CONTRASSEGNO' , '1' , '-1' , '4' , '2.9300' , '2.93' , '0' , '0' , '2.93' ) 01/12/2025 07:56:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '239' AND id_document != '99952' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-17') 01/12/2025 07:56:42 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '239', document_date = '2025-11-17', document_letter = '', id_customer = '4285', id_supplier = '', id_address = '4679650', address1 = 'BORGO ARTINOVA 24 71121 FOGGIA', address2 = '', note = '', price_shipping = '5.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '13.00', price_tax_excluded = '13.00', date_upd = NOW() WHERE id_document = '99952' 01/12/2025 07:56:42 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 = '99952' 01/12/2025 07:56:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '99952' 01/12/2025 07:56:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99952' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '4' , '-4' , '4' , '2' , '2' , '0' , '0' , '8.00' ) 01/12/2025 07:58:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '242' AND id_document != '99959' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-18') 01/12/2025 07:58:47 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '242', document_date = '2025-11-18', document_letter = '', id_customer = '3030', id_supplier = '', id_address = '4671709', address1 = 'VIA SAN FELICE IN FELLINE, 10 84134 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '46.92', price_tax_excluded = '46.92', date_upd = NOW() WHERE id_document = '99959' 01/12/2025 07:58:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99959' 01/12/2025 07:58:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '99959' 01/12/2025 07:58:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99959' , '2679' , 'CONOSCERE GESU\'' , '15' , '-15' , '4' , '3.50' , '3.5' , '0' , '15' , '44.63' ) 01/12/2025 07:58:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99959' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '-1' , '4' , '2.29' , '2.29' , '0' , '0' , '2.29' )