02/01/2026 09:13:33 am >> DELETE FROM ps_product WHERE id_product = '1141' 02/01/2026 09:13:33 am >> DELETE FROM ps_product_shop WHERE id_product = '1141' 02/01/2026 09:13:33 am >> DELETE FROM ps_product_lang WHERE id_product = '1141' 02/01/2026 09:13:33 am >> DELETE FROM ps_stock_available WHERE id_product = '1141' 02/01/2026 09:13:38 am >> DELETE FROM ps_product WHERE id_product = '1161' 02/01/2026 09:13:38 am >> DELETE FROM ps_product_shop WHERE id_product = '1161' 02/01/2026 09:13:38 am >> DELETE FROM ps_product_lang WHERE id_product = '1161' 02/01/2026 09:13:38 am >> DELETE FROM ps_stock_available WHERE id_product = '1161' 02/01/2026 10:31:52 am >> SELECT document_num FROM ps_document WHERE document_num = '1' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-02') 02/01/2026 10:31:52 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1' , '2026-01-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '240.00' , '199.63' , NOW() , NOW() ) 02/01/2026 10:31:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100748' 02/01/2026 10:31:52 am >> DELETE FROM ps_document_detail WHERE id_document = '100748' 02/01/2026 10:31:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100748' , '3159' , 'CROCE ULIVO SAN BENEDETTO - GRANDE - 741' , '5' , '-5' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '22.50' ) 02/01/2026 10:31:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100748' , '23892' , 'CROCE S. BENEDETTO - 730' , '5' , '-5' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '22.50' ) 02/01/2026 10:31:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100748' , '18135' , 'CROCE SAN BENEDETTO PICCOLA - CSB4' , '10' , '-10' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '25.00' ) 02/01/2026 10:31:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100748' , '17052' , 'CROCETTA S. BENEDETTO METALLO OX CM5X3,3 - PG382' , '20' , '-20' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '14.00' ) 02/01/2026 10:31:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100748' , '3104' , 'CROCE SAN BENEDETTO - CARTONCINO' , '10' , '-10' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '15.00' ) 02/01/2026 10:31:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100748' , '20526' , 'MEDAGLIA SAN BENEDETTO 36MM - M275/A' , '10' , '-10' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '12.00' ) 02/01/2026 10:31:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100748' , '20525' , 'MEDAGLIA SAN BENEDETTO 36MM - M275/A SM' , '3' , '-3' , '1' , '4' , '3.2786885245902' , '22' , '0' , '12.00' ) 02/01/2026 10:31:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100748' , '3103' , 'CROCE SAN BENEDETTO' , '10' , '-10' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '13.00' ) 02/01/2026 10:31:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100748' , '13364' , 'CORONA MM 6 ' , '22' , '-22' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '55.00' ) 02/01/2026 10:31:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100748' , '22650' , 'QUADRETTO S. FAMIGLIA ARG. - 25/101-15' , '1' , '-1' , '1' , '5.39' , '4.4180327868852' , '22' , '0' , '5.39' ) 02/01/2026 10:31:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100748' , '24400' , 'MATER POPULI FIDELIS' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 02/01/2026 10:31:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100748' , '24298' , 'DISEGNARE NUOVE MAPPE DI SPERANZA' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 02/01/2026 10:31:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100748' , '23949' , 'UN BUON CONFESSORE - C.E. COMMENTZ' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 02/01/2026 10:31:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100748' , '23807' , 'CALENDARIO LITURGICO 2026' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 02/01/2026 10:31:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100748' , '24463' , 'PACE SIA CON TUTTI VOI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 02/01/2026 10:31:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100748' , '15387' , 'VESTINA BATTESIMALE ' , '11' , '-11' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '27.50' ) 02/01/2026 10:40:54 am >> SELECT document_num FROM ps_document WHERE document_num = '2' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-02') 02/01/2026 10:40:54 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2' , '2026-01-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '46.00' , '41.67' , NOW() , NOW() ) 02/01/2026 10:40:54 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100749' 02/01/2026 10:40:54 am >> DELETE FROM ps_document_detail WHERE id_document = '100749' 02/01/2026 10:40:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100749' , '21561' , 'QUADRO PIASTRELLA 20X20 - 2189' , '1' , '-1' , '1' , '24.00' , '19.672131147541' , '22' , '0' , '24.00' ) 02/01/2026 10:40:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100749' , '20043' , 'FOLLOWERS 2.0 - GUIDA' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 02/01/2026 10:40:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100749' , '20137' , 'FOLLOWERS 2.0 - QUADERNO' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '0' , '8.00' ) 02/01/2026 10:58:30 am >> SELECT document_num FROM ps_document WHERE document_num = '3' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-02') 02/01/2026 10:58:30 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' , '3' , '2026-01-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '489.20' , '405.51' , NOW() , NOW() ) 02/01/2026 10:58:30 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 = '100750' 02/01/2026 10:58:30 am >> DELETE FROM ps_document_detail WHERE id_document = '100750' 02/01/2026 10:58:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100750' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '270.00' ) 02/01/2026 10:58:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100750' , '16603' , 'LIBRO INTENZIONI SANTE MESSE' , '3' , '-3' , '1' , '12.00' , '9.8360655737705' , '22' , '5' , '34.20' ) 02/01/2026 10:58:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100750' , '18748' , 'OSTIA MAGNA 125 - OM 125' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 02/01/2026 10:58:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100750' , '19089' , 'OSTIA MAGNA 150 - OM 150' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 02/01/2026 10:58:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100750' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '3' , '-3' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '39.00' ) 02/01/2026 10:58:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100750' , '19100' , 'INCENSO B' , '2' , '-2' , '1' , '35.00' , '28.688524590164' , '22' , '0' , '70.00' ) 02/01/2026 10:58: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 ( '100750' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '49.00' , '40.16393442623' , '22' , '0' , '49.00' ) 02/01/2026 10:58: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 ( '100750' , '24463' , 'PACE SIA CON TUTTI VOI' , '9' , '-9' , '4' , '2.00' , '2' , '0' , '0' , '18.00' ) 02/01/2026 11:00:27 am >> SELECT document_num FROM ps_document WHERE document_num = '4' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-02') 02/01/2026 11:00:27 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4' , '2026-01-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.25' , '90.25' , NOW() , NOW() ) 02/01/2026 11:00:27 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100751' 02/01/2026 11:00:27 am >> DELETE FROM ps_document_detail WHERE id_document = '100751' 02/01/2026 11:00:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100751' , '15124' , 'SEGRETO MERAVIGLIOSO DEL SANTO ROSARIO - 8285' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 02/01/2026 11:00:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100751' , '16837' , 'PORTA IL TUO CUORE AL LARGO! - 8993' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 02/01/2026 11:00:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100751' , '17831' , '24 PASSI NEL QUOTIDIANO - SAN . F. SALES - 8299' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 02/01/2026 11:00:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100751' , '6317' , 'MEDAGLIA MIRACOLOSA - 8332' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 02/01/2026 11:00:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100751' , '23964' , 'CONFESSIONE MEDICINA DEL CUORE - 8313' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 02/01/2026 11:00:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100751' , '23752' , 'TUTTA LA MESSA MINUTO PER MINUTO - V. ANGELUCCI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 02/01/2026 11:00:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100751' , '23271' , 'OMELIA, ECO DELLA PAROLA DI DIO - R. RAMPOLLA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 02/01/2026 11:00:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100751' , '24019' , 'PERCHE LA MADONNA APPARE - 8267' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 02/01/2026 11:00:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100751' , '24187' , 'QUALE VITA DOPO LA MORTE? BILLON/RAMOND' , '1' , '-1' , '4' , '23.00' , '23' , '0' , '5' , '21.85' ) 02/01/2026 11:00:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100751' , '23805' , 'COMANDAMENTI - G. RAVASI' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 02/01/2026 11:03:32 am >> SELECT document_num FROM ps_document WHERE document_num = '5' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-02') 02/01/2026 11:03:32 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' , '5' , '2026-01-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '51.00' , '41.80' , NOW() , NOW() ) 02/01/2026 11:03:32 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 = '100752' 02/01/2026 11:03:32 am >> DELETE FROM ps_document_detail WHERE id_document = '100752' 02/01/2026 11:03: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 ( '100752' , '11389' , 'VINO ROSSO DOLCE - 103' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 02/01/2026 11:13:47 am >> SELECT document_num FROM ps_document WHERE document_num = '1' AND id_document != '100748' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-02') 02/01/2026 11:13:47 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1', document_date = '2026-01-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 = '240.00', price_tax_excluded = '199.63', date_upd = NOW() WHERE id_document = '100748' 02/01/2026 11:13:47 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 = '100748' 02/01/2026 11:13:47 am >> DELETE FROM ps_document_detail WHERE id_document = '100748' 02/01/2026 11:13: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 ( '100748' , '3159' , 'CROCE ULIVO SAN BENEDETTO - GRANDE - 741' , '5' , '-5' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '22.50' ) 02/01/2026 11:13: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 ( '100748' , '23892' , 'CROCE S. BENEDETTO - 730' , '5' , '-5' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '22.50' ) 02/01/2026 11:13: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 ( '100748' , '18135' , 'CROCE SAN BENEDETTO PICCOLA - CSB4' , '10' , '-10' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '25.00' ) 02/01/2026 11:13: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 ( '100748' , '17052' , 'CROCETTA S. BENEDETTO METALLO OX CM5X3,3 - PG382' , '20' , '-20' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '14.00' ) 02/01/2026 11:13: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 ( '100748' , '3104' , 'CROCE SAN BENEDETTO - CARTONCINO' , '10' , '-10' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '15.00' ) 02/01/2026 11:13: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 ( '100748' , '20526' , 'MEDAGLIA SAN BENEDETTO 36MM - M275/A' , '8' , '-8' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '9.60' ) 02/01/2026 11:13: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 ( '100748' , '20525' , 'MEDAGLIA SAN BENEDETTO 36MM - M275/A SM' , '3' , '-3' , '1' , '4.0000' , '3.2786885245902' , '22' , '0' , '12.00' ) 02/01/2026 11:13: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 ( '100748' , '3103' , 'CROCE SAN BENEDETTO' , '10' , '-10' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '13.00' ) 02/01/2026 11:13: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 ( '100748' , '13364' , 'CORONA MM 6 ' , '22' , '-22' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '55.00' ) 02/01/2026 11:13: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 ( '100748' , '22650' , 'QUADRETTO S. FAMIGLIA ARG. - 25/101-15' , '1' , '-1' , '1' , '6.69' , '5.483606557377' , '22' , '0' , '6.69' ) 02/01/2026 11:13: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 ( '100748' , '24400' , 'MATER POPULI FIDELIS' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 02/01/2026 11:13: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 ( '100748' , '24298' , 'DISEGNARE NUOVE MAPPE DI SPERANZA' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 02/01/2026 11:13: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 ( '100748' , '23949' , 'UN BUON CONFESSORE - C.E. COMMENTZ' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '5' , '7.60' ) 02/01/2026 11:13: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 ( '100748' , '23807' , 'CALENDARIO LITURGICO 2026' , '1' , '-1' , '4' , '0.8000' , '0.8' , '0' , '0' , '0.80' ) 02/01/2026 11:13: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 ( '100748' , '24463' , 'PACE SIA CON TUTTI VOI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 02/01/2026 11:13: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 ( '100748' , '15387' , 'VESTINA BATTESIMALE ' , '11' , '-11' , '1' , '2.6' , '2.1311475409836' , '22' , '0' , '28.60' ) 02/01/2026 11:19:28 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256392674' AND id_product != '23964' AND ean13 != '' 02/01/2026 11:19:28 am >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9791256392674', date_upd = NOW() WHERE id_product = '23964' 02/01/2026 11:19:28 am >> UPDATE ps_product_lang SET name = 'CONFESSIONE MEDICINA DEL CUORE - 8313', description = '' WHERE id_product = '23964' 02/01/2026 11:19:28 am >> UPDATE ps_product SET wholesale_price = '5.40', on_sale = '0', price = '9.0000' WHERE id_product = '23964' 02/01/2026 11:19:28 am >> UPDATE ps_product_shop SET wholesale_price = '5.40', price = '9.0000', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '78', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23964' 02/01/2026 11:19:28 am >> DELETE FROM ps_specific_price WHERE id_product = '23964' 02/01/2026 11:20:23 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892247031' AND id_product != '23752' AND ean13 != '' 02/01/2026 11:20:23 am >> UPDATE ps_product SET id_supplier = '7', reference = '14', ean13 = '9788892247031', date_upd = NOW() WHERE id_product = '23752' 02/01/2026 11:20:23 am >> UPDATE ps_product_lang SET name = 'TUTTA LA MESSA MINUTO PER MINUTO - V. ANGELUCCI', description = '' WHERE id_product = '23752' 02/01/2026 11:20:23 am >> UPDATE ps_product SET wholesale_price = '10.05', on_sale = '0', price = '15.0000' WHERE id_product = '23752' 02/01/2026 11:20:23 am >> UPDATE ps_product_shop SET wholesale_price = '10.05', price = '15.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23752' 02/01/2026 11:20:23 am >> DELETE FROM ps_specific_price WHERE id_product = '23752' 02/01/2026 11:21:54 am >> SELECT document_num FROM ps_document WHERE document_num = '4230' AND id_document != '100472' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-15') 02/01/2026 11:21:54 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4230', document_date = '2025-12-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '50.00', price_tax_excluded = '40.98', date_upd = NOW() WHERE id_document = '100472' 02/01/2026 11:21:55 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 = '100472' 02/01/2026 11:21:55 am >> DELETE FROM ps_document_detail WHERE id_document = '100472' 02/01/2026 11:21:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100472' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 02/01/2026 11:22:34 am >> SELECT document_num FROM ps_document WHERE document_num = '3898' AND id_document != '100052' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-22') 02/01/2026 11:22:34 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3898', document_date = '2025-11-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '27.60', price_tax_excluded = '26.95', date_upd = NOW() WHERE id_document = '100052' 02/01/2026 11:22:34 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 = '100052' 02/01/2026 11:22:35 am >> DELETE FROM ps_document_detail WHERE id_document = '100052' 02/01/2026 11:22: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 ( '100052' , '17434' , 'STORIA DI SAN NICOLA' , '2' , '-2' , '4' , '1.9000' , '1.9' , '0' , '0' , '3.80' ) 02/01/2026 11:22: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 ( '100052' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.6000' , '2.9508196721311' , '22' , '0' , '3.60' ) 02/01/2026 11:22: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 ( '100052' , '21614' , 'RITO DEL BATTESIMO DEI BAMBINI N.E.' , '1' , '-1' , '4' , '20.2' , '20.2' , '0' , '0' , '20.20' ) 02/01/2026 11:31:46 am >> SELECT document_num FROM ps_document WHERE document_num = '6' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-02') 02/01/2026 11:31:46 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' , '6' , '2026-01-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.00' , '40.42' , NOW() , NOW() ) 02/01/2026 11:31: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 = '100753' 02/01/2026 11:31:46 am >> DELETE FROM ps_document_detail WHERE id_document = '100753' 02/01/2026 11:31: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 ( '100753' , '24279' , 'GRUPPO NATIVITA CM 14 - PB19860' , '1' , '-1' , '1' , '9.50' , '7.7868852459016' , '22' , '0' , '9.50' ) 02/01/2026 11:31: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 ( '100753' , '23188' , 'GRUPPO NATIVITA CAMPANA CON LUCI - PB20515' , '1' , '-1' , '1' , '27.00' , '22.131147540984' , '22' , '0' , '27.00' ) 02/01/2026 11:31: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 ( '100753' , '9017' , 'RITO DELLA PENITENZA' , '1' , '-1' , '4' , '10.50' , '10.5' , '0' , '0' , '10.50' ) 02/01/2026 11:33:14 am >> DELETE FROM ps_document WHERE id_document = '99397' 02/01/2026 11:33:14 am >> DELETE FROM ps_document_detail WHERE id_document = '99397' 02/01/2026 12:00:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '7' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-02') 02/01/2026 12:00:49 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '7' , '2026-01-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '141.25' , '131.12' , NOW() , NOW() ) 02/01/2026 12:00: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 = '100754' 02/01/2026 12:00:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '100754' 02/01/2026 12:00: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 ( '100754' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '17' , '-17' , '4' , '5.00' , '5' , '0' , '5' , '80.75' ) 02/01/2026 12:00: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 ( '100754' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 02/01/2026 12:00: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 ( '100754' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 02/01/2026 12:00: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 ( '100754' , '23186' , 'PRESEPE CON CAPANNA E LUCE - PB18544' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 02/01/2026 12:15:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '8' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-02') 02/01/2026 12:15:34 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' , '8' , '2026-01-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.90' , '4.02' , NOW() , NOW() ) 02/01/2026 12:15:34 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 = '100755' 02/01/2026 12:15:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '100755' 02/01/2026 12:15:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100755' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 02/01/2026 12:20:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '9' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-02') 02/01/2026 12:20:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '9' , '2026-01-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.52' , '5.52' , NOW() , NOW() ) 02/01/2026 12:20: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 = '100756' 02/01/2026 12:20:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '100756' 02/01/2026 12:20: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 ( '100756' , '24349' , 'PAROLA E PREGHIERA - GEN 26' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 02/01/2026 12:20: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 ( '100756' , '24350' , 'PAROLA E PREGHIERA - FEB 26' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 02/01/2026 12:20:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '10' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-02') 02/01/2026 12:20:53 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' , '10' , '2026-01-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.90' , '6.48' , NOW() , NOW() ) 02/01/2026 12:20:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100757' 02/01/2026 12:20:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '100757' 02/01/2026 12:20: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 ( '100757' , '1621' , 'CANDELE CONICHE 10 PZ' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 02/01/2026 12:39:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '11' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-02') 02/01/2026 12:39:41 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '11' , '2026-01-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 02/01/2026 12:39: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 = '100758' 02/01/2026 12:39:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '100758' 02/01/2026 12:39: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 ( '100758' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 02/01/2026 12:44:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '10' AND id_document != '100757' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-02') 02/01/2026 12:44:37 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '10', document_date = '2026-01-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 = '7.90', price_tax_excluded = '6.48', date_upd = NOW() WHERE id_document = '100757' 02/01/2026 12:44:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100757' 02/01/2026 12:44:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '100757' 02/01/2026 12:44: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 ( '100757' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '7.9' , '6.4754098360656' , '22' , '0' , '7.90' ) 02/01/2026 12:52:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '3830' AND id_document != '99965' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-18') 02/01/2026 12:52:11 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3830', document_date = '2025-11-18', 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 = '349.00', price_tax_excluded = '289.49', date_upd = NOW() WHERE id_document = '99965' 02/01/2026 12:52: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 = '99965' 02/01/2026 12:52:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '99965' 02/01/2026 12:52: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 ( '99965' , '17986' , 'PATENA 15,5 - 1900' , '1' , '-1' , '1' , '50.0000' , '40.983606557377' , '22' , '0' , '50.00' ) 02/01/2026 12:52: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 ( '99965' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '210' , '172.13114754098' , '22' , '0' , '210.00' ) 02/01/2026 12:52: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 ( '99965' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '5' , '9.50' ) 02/01/2026 12:52: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 ( '99965' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '5' , '9.50' ) 02/01/2026 12:52: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 ( '99965' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 02/01/2026 03:50:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '12' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-02') 02/01/2026 03:50:42 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' , '12' , '2026-01-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.50' , '10.52' , NOW() , NOW() ) 02/01/2026 03:50: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 = '100759' 02/01/2026 03:50:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '100759' 02/01/2026 03:50: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 ( '100759' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '11' , '9.016393442623' , '22' , '0' , '11.00' ) 02/01/2026 03:50: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 ( '100759' , '8368' , 'PREGHIERE DI LIBERAZIONE - DIVINA MISERICORDIA' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 02/01/2026 04:20:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '266' AND id_document != '100190' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-12-01') 02/01/2026 04:20:06 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '266', document_date = '2025-12-01', document_letter = '', id_customer = '2144', id_supplier = '', id_address = '4679670', address1 = 'VIA UMBERTO I 69 98046 S. LUCIA DEL MELA', address2 = '', note = '', price_shipping = '5.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 = '31.60', price_tax_excluded = '31.60', date_upd = NOW() WHERE id_document = '100190' 02/01/2026 04:20:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100190' 02/01/2026 04:20:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '100190' 02/01/2026 04:20:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100190' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '10' , '-10' , '4' , '2.66' , '2.66' , '0' , '0' , '26.60' ) 02/01/2026 04:22:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '13' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-02') 02/01/2026 04:22:58 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' , '13' , '2026-01-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.55' , '8.55' , NOW() , NOW() ) 02/01/2026 04:22:58 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 = '100760' 02/01/2026 04:22:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '100760' 02/01/2026 04:22:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100760' , '8219' , 'PRATICA DI AMAR GESÙ CRISTO - 8464' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 02/01/2026 04:24:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '271' AND id_document != '100344' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-12-09') 02/01/2026 04:24:53 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '271', document_date = '2025-12-09', document_letter = '', id_customer = '2755', id_supplier = '', id_address = '4679629', address1 = 'VIA APPIA 1425 04026 MINTURNO', 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 = '92.73', price_tax_excluded = '92.73', date_upd = NOW() WHERE id_document = '100344' 02/01/2026 04:24:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100344' 02/01/2026 04:24:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '100344' 02/01/2026 04:24: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 ( '100344' , '23467' , 'VIA CRUCIS CAMMINO DI REDENZIONE - R. LUPI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 02/01/2026 04:24: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 ( '100344' , '18357' , 'MIE PREGHIERINE N.E.' , '2' , '-2' , '4' , '1.5000' , '1.5' , '0' , '5' , '2.85' ) 02/01/2026 04:24: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 ( '100344' , '18597' , 'ROSARIO SPIEGATO AI BAMBINI' , '2' , '-2' , '4' , '2.5000' , '2.5' , '0' , '5' , '4.75' ) 02/01/2026 04:24: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 ( '100344' , '18049' , 'PADRE NOSTRO SPIEGATO AI BAMBINI' , '2' , '-2' , '4' , '2.5000' , '2.5' , '0' , '5' , '4.75' ) 02/01/2026 04:24: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 ( '100344' , '23347' , 'PREGHIERA DEL ROSARIO' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 02/01/2026 04:24: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 ( '100344' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '1' , '-1' , '4' , '1.9000' , '1.9' , '0' , '5' , '1.80' ) 02/01/2026 04:24: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 ( '100344' , '16065' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 02/01/2026 04:24: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 ( '100344' , '18658' , 'PICCOLO DIZIONARIO DEL CRISTIANO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 02/01/2026 04:24: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 ( '100344' , '17163' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 02/01/2026 04:24: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 ( '100344' , '16199' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 02/01/2026 04:24: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 ( '100344' , '14145' , 'CREDO SPIEGATO AI RAGAZZI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 02/01/2026 04:24: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 ( '100344' , '24097' , 'AVVENTO E NATALE 2025 - BAMBINI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 02/01/2026 04:24: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 ( '100344' , '24096' , 'AVVENTO E NATALE 2025/26' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.75' ) 02/01/2026 04:24: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 ( '100344' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 02/01/2026 04:24: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 ( '100344' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.8000' , '3.8' , '0' , '5' , '3.61' ) 02/01/2026 04:24: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 ( '100344' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.8000' , '3.8' , '0' , '5' , '3.61' ) 02/01/2026 04:24: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 ( '100344' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.8000' , '3.8' , '0' , '5' , '3.61' ) 02/01/2026 04:24: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 ( '100344' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 02/01/2026 04:24: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 ( '100344' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 02/01/2026 04:24: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 ( '100344' , '11192' , 'VENITE CON ME 2 PARTE' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 02/01/2026 04:24: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 ( '100344' , '11191' , 'VENITE CON ME 1 PARTE' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 02/01/2026 04:24: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 ( '100344' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 02/01/2026 04:24: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 ( '100344' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 02/01/2026 04:24: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 ( '100344' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '10' , '-10' , '4' , '2.25' , '2.25' , '0' , '0' , '22.50' ) 02/01/2026 04:25:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '275' AND id_document != '100477' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-12-15') 02/01/2026 04:25:56 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '275', document_date = '2025-12-15', document_letter = '', id_customer = '3728', id_supplier = '', id_address = '4671524', address1 = 'C.SO DELLA REPUBBLICA 29 00060 CANALE MONTERANO', 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 = '119.73', price_tax_excluded = '119.73', date_upd = NOW() WHERE id_document = '100477' 02/01/2026 04:25:56 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100477' 02/01/2026 04:25:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '100477' 02/01/2026 04:25:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100477' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '16' , '-16' , '4' , '3.8000' , '3.8' , '0' , '15' , '51.68' ) 02/01/2026 04:25:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100477' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '15' , '-15' , '4' , '2.8000' , '2.8' , '0' , '15' , '35.70' ) 02/01/2026 04:25:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100477' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '10' , '-10' , '4' , '2.8000' , '2.8' , '0' , '15' , '23.80' ) 02/01/2026 04:25:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100477' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' , '8.55' , '8.55' , '0' , '0' , '8.55' ) 02/01/2026 04:27:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '278' AND id_document != '100497' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-12-16') 02/01/2026 04:27:55 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '278', document_date = '2025-12-16', document_letter = '', id_customer = '2755', id_supplier = '', id_address = '4679629', address1 = 'VIA APPIA 1425 04026 MINTURNO', 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 = '46.75', price_tax_excluded = '46.75', date_upd = NOW() WHERE id_document = '100497' 02/01/2026 04:27: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 = '100497' 02/01/2026 04:27:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '100497' 02/01/2026 04:27: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 ( '100497' , '23721' , 'BEATITUDINI - M. DE ROSA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '5' , '7.60' ) 02/01/2026 04:27: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 ( '100497' , '23870' , 'RAGAZZO DEL LENZUOLO - M. VIANI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 02/01/2026 04:27: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 ( '100497' , '24201' , 'PORTA IL DONO' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 02/01/2026 04:27: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 ( '100497' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '2' , '-2' , '4' , '3.09' , '3.09' , '0' , '0' , '6.18' ) 02/01/2026 04:27: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 ( '100497' , '24414' , 'AGENDA DELLA FAMIGLIA 2026' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '5' , '9.41' ) 02/01/2026 04:27: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 ( '100497' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 02/01/2026 04:42:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '4410' AND id_document != '100693' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-24') 02/01/2026 04:42:22 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4410', document_date = '2025-12-24', 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 = '12.00', price_tax_excluded = '9.84', date_upd = NOW() WHERE id_document = '100693' 02/01/2026 04:42: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 = '100693' 02/01/2026 04:42:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '100693' 02/01/2026 04:42: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 ( '100693' , '24073' , 'AGENDA LITURGICO PASTORALE 2026 - 40830' , '1' , '-1' , '1' , '12' , '9.8360655737705' , '22' , '0' , '12.00' ) 02/01/2026 04:43:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '4415' AND id_document != '100698' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-29') 02/01/2026 04:43:23 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4415', document_date = '2025-12-29', 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 = '70.00', price_tax_excluded = '57.38', date_upd = NOW() WHERE id_document = '100698' 02/01/2026 04:43: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 = '100698' 02/01/2026 04:43:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '100698' 02/01/2026 04:43: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 ( '100698' , '18682' , 'CLERGY ROMANO ML - C17' , '1' , '-1' , '1' , '37.0000' , '30.327868852459' , '22' , '0' , '37.00' ) 02/01/2026 04:43: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 ( '100698' , '12833' , 'BOTTONE RETROCOLLO - 21630' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 02/01/2026 04:43: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 ( '100698' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5.1' , '4.1803278688525' , '22' , '0' , '5.10' ) 02/01/2026 04:43: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 ( '100698' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '4' , '-4' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '4.40' ) 02/01/2026 04:43: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 ( '100698' , '24073' , 'AGENDA LITURGICO PASTORALE 2026 - 40830' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '14.00' ) 02/01/2026 04:43: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 ( '100698' , '24413' , 'SOTTO QUESTO CIELO' , '1' , '-1' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '6.50' ) 02/01/2026 04:55:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '129/A' AND id_document != '99403' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-10-23') 02/01/2026 04:55:02 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '129/A', document_date = '2025-10-23', document_letter = 'A', id_customer = '2739', id_supplier = '', id_address = '4671014', address1 = 'VIA F. WENNER, 37 84080 PELLEZZANO', 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 = '39.00', price_tax_excluded = '38.71', date_upd = NOW() WHERE id_document = '99403' 02/01/2026 04:55:02 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 = '99403' 02/01/2026 04:55:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '99403' 02/01/2026 04:55:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99403' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 02/01/2026 04:55:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99403' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 02/01/2026 04:55:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99403' , '14642' , 'FIDES ET RATIO - GIOVANNI PAOLO II' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '0' , '4.50' ) 02/01/2026 04:55:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99403' , '24043' , 'MESSALE FESTIVO 2026' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 02/01/2026 04:55:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99403' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '0' , '15.00' ) 02/01/2026 04:58: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 ( '32' , '6225762619' , '2025-12-31' , '' , '0' , '177' , '4679057' , 'VIA G. VERDI 8 20057 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '94.40' , '94.40' , NOW() , NOW() ) 02/01/2026 04:58: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 = '100761' 02/01/2026 04:58:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '100761' 02/01/2026 04:58: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 ( '100761' , '24412' , 'CORAGGIO DI SCELIERE - D. BANZATO' , '1' , '0' , '4' , '14.53' , '14.53' , '0' , '0' , '14.5300' ) 02/01/2026 04:58:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24412' AND id_supplier = '177' 02/01/2026 04:58:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24412' , '177' , '1' ) 02/01/2026 04:58: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 ( '100761' , '23919' , 'CE SPAZIO PER TE 2026 - 12-14 ANNI' , '1' , '0' , '4' , '13.03' , '13.03' , '0' , '0' , '13.0300' ) 02/01/2026 04:58:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23919' AND id_supplier = '177' 02/01/2026 04:58:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23919' , '177' , '1' ) 02/01/2026 04:58: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 ( '100761' , '23045' , 'DIO DEI NOSTRI PADRI - A. CAZZULLO' , '1' , '0' , '4' , '14.98' , '14.98' , '0' , '0' , '14.9800' ) 02/01/2026 04:58:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23045' AND id_supplier = '177' 02/01/2026 04:58:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23045' , '177' , '1' ) 02/01/2026 04:58: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 ( '100761' , '24079' , 'FRANCESCO IL PRIMO ITALIANO - A. CAZZULLO' , '1' , '0' , '4' , '14.98' , '14.98' , '0' , '0' , '14.9800' ) 02/01/2026 04:58:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24079' AND id_supplier = '177' 02/01/2026 04:58:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24079' , '177' , '1' ) 02/01/2026 04:58: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 ( '100761' , '21697' , 'ORME SUL CUORE - A. ROMANO' , '4' , '0' , '4' , '9.22' , '9.22' , '0' , '0' , '36.8800' ) 02/01/2026 04:58:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21697' AND id_supplier = '177' 02/01/2026 04:58:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21697' , '177' , '1' ) 02/01/2026 05:47:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '14' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-02') 02/01/2026 05:47:18 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' , '14' , '2026-01-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '2.87' , NOW() , NOW() ) 02/01/2026 05:47:18 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 = '100762' 02/01/2026 05:47:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '100762' 02/01/2026 05:47:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100762' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 02/01/2026 05:51:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '15' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-02') 02/01/2026 05:51:27 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' , '15' , '2026-01-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '2.46' , NOW() , NOW() ) 02/01/2026 05:51:27 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 = '100763' 02/01/2026 05:51:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '100763' 02/01/2026 05:51:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100763' , '24016' , 'UN ANNO CON GESU - DA TAVOLO' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 02/01/2026 06:07:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '16' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-02') 02/01/2026 06:07:39 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' , '16' , '2026-01-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.00' , '16.35' , NOW() , NOW() ) 02/01/2026 06:07:39 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 = '100764' 02/01/2026 06:07:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '100764' 02/01/2026 06:07:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100764' , '11152' , 'VARIE - OSTIE - PARTICOLE' , '2' , '-2' , '3' , '2.8' , '2.6923076923077' , '4' , '0' , '5.60' ) 02/01/2026 06:07:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100764' , '11152' , 'VARIE - OSTIE - PARTICOLE' , '3' , '-3' , '3' , '3.8' , '3.6538461538462' , '4' , '0' , '11.40' ) 02/01/2026 06:10:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '16' AND id_document != '100764' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-02') 02/01/2026 06:10:56 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '16', document_date = '2026-01-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 = '17.00', price_tax_excluded = '16.35', date_upd = NOW() WHERE id_document = '100764' 02/01/2026 06:10:56 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100764' 02/01/2026 06:10:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '100764' 02/01/2026 06:10:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100764' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 02/01/2026 06:10:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100764' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 02/01/2026 06:10:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100764' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 02/01/2026 06:10:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100764' , '11152' , 'VARIE - OSTIE - PARTICOLE' , '1' , '-1' , '3' , '5' , '4.8076923076923' , '4' , '0' , '5.00' ) 02/01/2026 06:40:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '17' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-02') 02/01/2026 06:40:49 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '17' , '2026-01-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 02/01/2026 06:40: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 = '100765' 02/01/2026 06:40:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '100765' 02/01/2026 06:40: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 ( '100765' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 02/01/2026 07:18:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '18' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-02') 02/01/2026 07:18: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' , '18' , '2026-01-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '2.46' , NOW() , NOW() ) 02/01/2026 07:18: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 = '100766' 02/01/2026 07:18:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '100766' 02/01/2026 07:18: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 ( '100766' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' )