12/12/2025 12:10:33 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'Ep22TimhQbfCCEtq' , NOW() , NOW() ) 12/12/2025 12:10:34 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4295' , '1' ) 12/12/2025 12:10:34 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4295' , '2' ) 12/12/2025 12:10:34 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4295' , '3' ) 12/12/2025 08:08:36 am >> SELECT document_num FROM ps_document WHERE document_num = '3953' AND id_document != '100132' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-27') 12/12/2025 08:08:36 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3953', document_date = '2025-11-27', 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 = '36.20', price_tax_excluded = '29.67', date_upd = NOW() WHERE id_document = '100132' 12/12/2025 08:08:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100132' 12/12/2025 08:08:36 am >> DELETE FROM ps_document_detail WHERE id_document = '100132' 12/12/2025 08:08:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100132' , '20516' , 'CROCE COMUNIONE - 42/08' , '6' , '-6' , '1' , '0.7' , '0.57377049180328' , '22' , '0' , '4.20' ) 12/12/2025 08:08:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100132' , '20156' , 'PALLA E STELLE CON CARTONCINO - 23' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 12/12/2025 08:08:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100132' , '22419' , 'CROCE LINES CM 21' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 12/12/2025 08:09:13 am >> SELECT document_num FROM ps_document WHERE document_num = '3928' AND id_document != '100097' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-26') 12/12/2025 08:09:13 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3928', document_date = '2025-11-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '99.20', price_tax_excluded = '81.76', date_upd = NOW() WHERE id_document = '100097' 12/12/2025 08:09:13 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 = '100097' 12/12/2025 08:09:13 am >> DELETE FROM ps_document_detail WHERE id_document = '100097' 12/12/2025 08:09:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100097' , '24194' , 'PRESEPE NATIVITA\' - P780' , '1' , '-1' , '1' , '16' , '13.114754098361' , '22' , '0' , '16.00' ) 12/12/2025 08:09:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100097' , '17872' , 'GIGLER PER LUMINELLO - 474/G' , '1' , '-1' , '1' , '3.9000' , '3.1967213114754' , '22' , '0' , '3.90' ) 12/12/2025 08:09:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100097' , '7553' , 'PARAFIAMMA PIREX PER CARTUCCIA 3.2 - 474/25' , '1' , '-1' , '1' , '11.5000' , '9.4262295081967' , '22' , '0' , '11.50' ) 12/12/2025 08:09:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100097' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 12/12/2025 08:09:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100097' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '9.80' ) 12/12/2025 08:09:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100097' , '24097' , 'AVVENTO E NATALE 2025 - BAMBINI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '0' , '2.50' ) 12/12/2025 08:09:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100097' , '6811' , 'MOCCOLO 80X200' , '5' , '-5' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '42.50' ) 12/12/2025 08:11:02 am >> SELECT document_num FROM ps_document WHERE document_num = '4130' AND id_document != '100354' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-09') 12/12/2025 08:11:02 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4130', document_date = '2025-12-09', 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 = '60.00', price_tax_excluded = '50.30', date_upd = NOW() WHERE id_document = '100354' 12/12/2025 08:11: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 = '100354' 12/12/2025 08:11:02 am >> DELETE FROM ps_document_detail WHERE id_document = '100354' 12/12/2025 08:11: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 ( '100354' , '18276' , 'CINGOLO CON NODI - 3280' , '2' , '-2' , '1' , '4.9' , '4.016393442623' , '22' , '0' , '9.80' ) 12/12/2025 08:11: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 ( '100354' , '21417' , 'VIENI, NON TARDARE SIGNORE, NOSTRA PACE!' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '0' , '2.50' ) 12/12/2025 08:11: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 ( '100354' , '20156' , 'PALLA E STELLE CON CARTONCINO - 23' , '4' , '-4' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '8.00' ) 12/12/2025 08:11: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 ( '100354' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '10' , '-10' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '11.00' ) 12/12/2025 08:11: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 ( '100354' , '17432' , 'SANTA LUCIA' , '1' , '-1' , '4' , '3.7000' , '3.7' , '0' , '0' , '3.70' ) 12/12/2025 08:11: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 ( '100354' , '23090' , 'ALBERO CON PRESEPE ' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 12/12/2025 08:11:55 am >> SELECT document_num FROM ps_document WHERE document_num = '4035' AND id_document != '100234' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-03') 12/12/2025 08:11:55 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4035', document_date = '2025-12-03', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '38.00', price_tax_excluded = '31.15', date_upd = NOW() WHERE id_document = '100234' 12/12/2025 08:11: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 = '100234' 12/12/2025 08:11:55 am >> DELETE FROM ps_document_detail WHERE id_document = '100234' 12/12/2025 08:11: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 ( '100234' , '23090' , 'ALBERO CON PRESEPE ' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 12/12/2025 08:11: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 ( '100234' , '20516' , 'CROCE COMUNIONE - 42/08' , '3' , '-3' , '1' , '1' , '0.81967213114754' , '22' , '0' , '3.00' ) 12/12/2025 08:11: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 ( '100234' , '18276' , 'CINGOLO CON NODI - 3280' , '2' , '-2' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '10.00' ) 12/12/2025 09:55:49 am >> SELECT document_num FROM ps_document WHERE document_num = '4181' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-12') 12/12/2025 09:55:49 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' , '4181' , '2025-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 12/12/2025 09:55:49 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 = '100415' 12/12/2025 09:55:49 am >> DELETE FROM ps_document_detail WHERE id_document = '100415' 12/12/2025 09:55:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100415' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 12/12/2025 09:57:38 am >> SELECT document_num FROM ps_document WHERE document_num = '4182' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-12') 12/12/2025 09:57:38 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' , '4182' , '2025-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.45' , '5.45' , NOW() , NOW() ) 12/12/2025 09:57:38 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 = '100416' 12/12/2025 09:57:38 am >> DELETE FROM ps_document_detail WHERE id_document = '100416' 12/12/2025 09:57:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100416' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 12/12/2025 09:57:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100416' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 12/12/2025 10:14:56 am >> SELECT document_num FROM ps_document WHERE document_num = '144/A' AND id_document != '100087' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-26') 12/12/2025 10:14:56 am >> UPDATE ps_document SET id_document_type = '24', document_num = '144/A', document_date = '2025-11-26', document_letter = 'A', id_customer = '333', id_supplier = '', id_address = '4679537', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', 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 = '484.70', price_tax_excluded = '426.10', date_upd = NOW() WHERE id_document = '100087' 12/12/2025 10:14:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100087' 12/12/2025 10:14:56 am >> DELETE FROM ps_document_detail WHERE id_document = '100087' 12/12/2025 10:14:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100087' , '12531' , 'LAMPADA A SFERA ROSSA' , '4' , '-4' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '100.00' ) 12/12/2025 10:14:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100087' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 12/12/2025 10:14:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100087' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.5000' , '7.7868852459016' , '22' , '0' , '38.00' ) 12/12/2025 10:14:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100087' , '21137' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '30.00' ) 12/12/2025 10:14:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100087' , '5759' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO A' , '1' , '-1' , '4' , '65.0000' , '65' , '0' , '0' , '65.00' ) 12/12/2025 10:14:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100087' , '5775' , 'LEZIONARIO PER LE MESSE RITUALI' , '1' , '-1' , '4' , '90.00' , '90' , '0' , '0' , '90.00' ) 12/12/2025 10:14:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100087' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 12/12/2025 10:14:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100087' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 12/12/2025 10:14:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100087' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '14.70' ) 12/12/2025 10:14:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100087' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 12/12/2025 10:23:01 am >> SELECT document_num FROM ps_document WHERE document_num = '4183' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-12') 12/12/2025 10:23: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 ( '11' , '4183' , '2025-12-12' , '' , '0' , '0' , '0' , 'P.ZZA S. MICHELE 84135 RUFOLI' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '484.00' , '425.42' , NOW() , NOW() ) 12/12/2025 10:23: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 = '100417' 12/12/2025 10:23:02 am >> DELETE FROM ps_document_detail WHERE id_document = '100417' 12/12/2025 10:23: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 ( '100417' , '12531' , 'LAMPADA A SFERA ROSSA' , '4' , '-4' , '1' , '25.0000' , '20.4918' , '22' , '0' , '100.00' ) 12/12/2025 10:23: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 ( '100417' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9231' , '4' , '0' , '4.00' ) 12/12/2025 10:23: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 ( '100417' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.5000' , '7.7869' , '22' , '0' , '38.00' ) 12/12/2025 10:23: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 ( '100417' , '21137' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '7.5000' , '6.1475' , '22' , '0' , '30.00' ) 12/12/2025 10:23: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 ( '100417' , '5759' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO A' , '1' , '-1' , '4' , '65.0000' , '65' , '0' , '0' , '65.00' ) 12/12/2025 10:23: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 ( '100417' , '5775' , 'LEZIONARIO PER LE MESSE RITUALI' , '1' , '-1' , '4' , '90.0000' , '90' , '0' , '0' , '90.00' ) 12/12/2025 10:23: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 ( '100417' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.459' , '22' , '0' , '90.00' ) 12/12/2025 10:23: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 ( '100417' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5000' , '6.9672' , '22' , '0' , '51.00' ) 12/12/2025 10:23: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 ( '100417' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '4.9000' , '4.0164' , '22' , '0' , '14.70' ) 12/12/2025 10:23: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 ( '100417' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '1.3' , '1.25' , '4' , '0' , '1.30' ) 12/12/2025 10:24:53 am >> DELETE FROM ps_document WHERE id_document = '100087' 12/12/2025 10:24:53 am >> DELETE FROM ps_document_detail WHERE id_document = '100087' 12/12/2025 10:26:26 am >> SELECT document_num FROM ps_document WHERE document_num = '4184' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-12') 12/12/2025 10:26: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' , '4184' , '2025-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.10' , '0.90' , NOW() , NOW() ) 12/12/2025 10:26: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 = '100418' 12/12/2025 10:26:26 am >> DELETE FROM ps_document_detail WHERE id_document = '100418' 12/12/2025 10:26: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 ( '100418' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '1.10' ) 12/12/2025 10:41:12 am >> SELECT document_num FROM ps_document WHERE document_num = '4185' AND id_document != '' AND id_document_type LIKE '13' AND YEAR(document_date) = YEAR('2025-12-12') 12/12/2025 10:41:12 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4185' , '2025-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 12/12/2025 10:41:12 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100419' 12/12/2025 10:41:12 am >> DELETE FROM ps_document_detail WHERE id_document = '100419' 12/12/2025 10:41:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100419' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 12/12/2025 10:44:40 am >> SELECT document_num FROM ps_document WHERE document_num = '4186' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-12') 12/12/2025 10:44:40 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' , '4186' , '2025-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '241.70' , '209.94' , NOW() , NOW() ) 12/12/2025 10:44: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 = '100420' 12/12/2025 10:44:40 am >> DELETE FROM ps_document_detail WHERE id_document = '100420' 12/12/2025 10:44: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 ( '100420' , '16689' , 'OSTIA PAN DI CENA mm80' , '15' , '-15' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '30.00' ) 12/12/2025 10:44: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 ( '100420' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 12/12/2025 10:44: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 ( '100420' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '3' , '-3' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '13.50' ) 12/12/2025 10:44: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 ( '100420' , '23807' , 'CALENDARIO LITURGICO 2026' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 12/12/2025 10:44: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 ( '100420' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 12/12/2025 10:44: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 ( '100420' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 12/12/2025 10:44: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 ( '100420' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '45.00' ) 12/12/2025 10:44: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 ( '100420' , '18804' , 'NOVENA AL NATALE - 8045' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 12/12/2025 10:44: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 ( '100420' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '100' , '-100' , '1' , '0.35' , '0.28688524590164' , '22' , '0' , '35.00' ) 12/12/2025 11:01:12 am >> SELECT document_num FROM ps_document WHERE document_num = '4187' AND id_document != '' AND id_document_type LIKE '13' AND YEAR(document_date) = YEAR('2025-12-12') 12/12/2025 11:01:12 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4187' , '2025-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.00' , '19.67' , NOW() , NOW() ) 12/12/2025 11:01:12 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100421' 12/12/2025 11:01:12 am >> DELETE FROM ps_document_detail WHERE id_document = '100421' 12/12/2025 11:01:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100421' , '18129' , 'TAU COLORATO - T56' , '20' , '-20' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '24.00' ) 12/12/2025 11:06:57 am >> SELECT document_num FROM ps_document WHERE document_num = '4188' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-12') 12/12/2025 11:06:57 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4188' , '2025-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 12/12/2025 11:06:57 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100422' 12/12/2025 11:06:57 am >> DELETE FROM ps_document_detail WHERE id_document = '100422' 12/12/2025 11:06:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100422' , '19100' , 'INCENSO B' , '1' , '-1' , '1' , '35.00' , '28.688524590164' , '22' , '0' , '35.00' ) 12/12/2025 11:06:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100422' , '23984' , 'AGENDA 2026' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 12/12/2025 11:16:40 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 12/12/2025 11:16:40 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24404' , '1' , '' , 'nuovo-prodotto' ) 12/12/2025 11:16:40 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '24404' , '1' , '1' , '2' , NOW() , NOW() ) 12/12/2025 11:16:40 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '24404' , '0' , '1' , '0' , '0' ) 12/12/2025 11:17:45 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000247' AND id_product != '24404' AND ean13 != '' 12/12/2025 11:17:45 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000247', date_upd = NOW() WHERE id_product = '24404' 12/12/2025 11:17:45 am >> UPDATE ps_product_lang SET name = 'CASULA ROSA - C1P146', description = '' WHERE id_product = '24404' 12/12/2025 11:17:46 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '64.75409836065575' WHERE id_product = '24404' 12/12/2025 11:17:46 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '64.75409836065575', id_tax_rules_group = '1', id_category_default = '539', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24404' 12/12/2025 11:17:46 am >> DELETE FROM ps_specific_price WHERE id_product = '24404' 12/12/2025 11:17:47 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24404' 12/12/2025 11:17:47 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24405' , '1' , '' , 'nuovo-prodotto' ) 12/12/2025 11:17:47 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24405' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24404' 12/12/2025 11:17:47 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24405' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24404' 12/12/2025 11:20:15 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000246' AND id_product != '24405' AND ean13 != '' 12/12/2025 11:20:15 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000246', date_upd = NOW() WHERE id_product = '24405' 12/12/2025 11:20:15 am >> UPDATE ps_product_lang SET name = 'CASULA ROSA - C2P170', description = '' WHERE id_product = '24405' 12/12/2025 11:20:15 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '68.0327868852459' WHERE id_product = '24405' 12/12/2025 11:20:15 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '68.0327868852459', id_tax_rules_group = '1', id_category_default = '539', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24405' 12/12/2025 11:20:15 am >> DELETE FROM ps_specific_price WHERE id_product = '24405' 12/12/2025 11:21:52 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000246' AND id_product != '24405' AND ean13 != '' 12/12/2025 11:21:52 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000246', date_upd = NOW() WHERE id_product = '24405' 12/12/2025 11:21:52 am >> UPDATE ps_product_lang SET name = 'CASULA ROSA - C2P170', description = '' WHERE id_product = '24405' 12/12/2025 11:21:52 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '68.0327868852459' WHERE id_product = '24405' 12/12/2025 11:21:52 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '68.0327868852459', id_tax_rules_group = '1', id_category_default = '539', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24405' 12/12/2025 11:21:52 am >> DELETE FROM ps_specific_price WHERE id_product = '24405' 12/12/2025 11:21:53 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24405' 12/12/2025 11:21:53 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24406' , '1' , '' , 'nuovo-prodotto' ) 12/12/2025 11:21:53 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24406' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24405' 12/12/2025 11:21:53 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24406' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24405' 12/12/2025 11:22:15 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000142' AND id_product != '24406' AND ean13 != '' 12/12/2025 11:22:15 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000142', date_upd = NOW() WHERE id_product = '24406' 12/12/2025 11:22:15 am >> UPDATE ps_product_lang SET name = 'PIVIALE - P1P841', description = '' WHERE id_product = '24406' 12/12/2025 11:22:15 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '258.1967213114754' WHERE id_product = '24406' 12/12/2025 11:22:15 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '258.1967213114754', id_tax_rules_group = '1', id_category_default = '539', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24406' 12/12/2025 11:22:15 am >> DELETE FROM ps_specific_price WHERE id_product = '24406' 12/12/2025 11:22:16 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24406' 12/12/2025 11:22:16 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24407' , '1' , '' , 'nuovo-prodotto' ) 12/12/2025 11:22:16 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24407' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24406' 12/12/2025 11:22:16 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24407' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24406' 12/12/2025 11:24:08 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , 'FAR/478' , '2025-12-10' , '478' , '0' , '187' , '4679290' , 'VIA G. B. STUCCHI 62/27 20900 MONZA' , '' , '' , '13' , '1' , '0' , '0' , '0' , '' , '3' , '0' , '650.87' , '533.50' , NOW() , NOW() ) 12/12/2025 11:24:08 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 = '100423' 12/12/2025 11:24:08 am >> DELETE FROM ps_document_detail WHERE id_document = '100423' 12/12/2025 11:24:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100423' , '24404' , 'CASULA ROSA - C1P146' , '1' , '1' , '1' , '32.5' , '26.639344262295' , '22' , '0' , '39.6500' ) 12/12/2025 11:24:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '24404' AND id_supplier = '187' 12/12/2025 11:24:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24404' , '187' , '1' ) 12/12/2025 11:24:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100423' , '24405' , 'CASULA ROSA - C2P170' , '1' , '1' , '1' , '34' , '27.868852459016' , '22' , '0' , '41.4800' ) 12/12/2025 11:24:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '24405' AND id_supplier = '187' 12/12/2025 11:24:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24405' , '187' , '1' ) 12/12/2025 11:24:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100423' , '22316' , 'PIVIALE - P1P858' , '1' , '1' , '1' , '129' , '105.73770491803' , '22' , '0' , '157.3800' ) 12/12/2025 11:24:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '22316' AND id_supplier = '187' 12/12/2025 11:24:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22316' , '187' , '1' ) 12/12/2025 11:24: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 ( '100423' , '24406' , 'PIVIALE - P1P841' , '2' , '2' , '1' , '129' , '105.73770491803' , '22' , '0' , '314.7600' ) 12/12/2025 11:24:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '24406' AND id_supplier = '187' 12/12/2025 11:24:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24406' , '187' , '1' ) 12/12/2025 11:24: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 ( '100423' , '22312' , 'CASULA SPIRITO SANTO - C1P820' , '1' , '1' , '1' , '67' , '54.918032786885' , '22' , '0' , '81.7400' ) 12/12/2025 11:24:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '22312' AND id_supplier = '187' 12/12/2025 11:24:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22312' , '187' , '1' ) 12/12/2025 11:40:56 am >> SELECT document_num FROM ps_document WHERE document_num = '4189' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-12') 12/12/2025 11:40:56 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4189' , '2025-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.84' , '14.84' , NOW() , NOW() ) 12/12/2025 11:40:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100424' 12/12/2025 11:40:56 am >> DELETE FROM ps_document_detail WHERE id_document = '100424' 12/12/2025 11:40:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100424' , '24352' , 'AMEN - FEB 26' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 12/12/2025 11:40:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100424' , '24351' , 'AMEN - GEN 26' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 12/12/2025 11:53:00 am >> SELECT document_num FROM ps_document WHERE document_num = '4190' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-12') 12/12/2025 11:53:00 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' , '4190' , '2025-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.50' , '32.38' , NOW() , NOW() ) 12/12/2025 11:53:00 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 = '100425' 12/12/2025 11:53:00 am >> DELETE FROM ps_document_detail WHERE id_document = '100425' 12/12/2025 11:53:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100425' , '6339' , 'MEDAGLIA OVALE DORATA/SMALTINO' , '46' , '-46' , '1' , '0.75' , '0.61475409836066' , '22' , '0' , '34.50' ) 12/12/2025 11:53:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100425' , '7202' , 'ARTICOLI RELIGIOSI' , '5' , '-5' , '1' , '1' , '0.81967213114754' , '22' , '0' , '5.00' ) 12/12/2025 11:57:56 am >> SELECT document_num FROM ps_document WHERE document_num = '4191' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-12') 12/12/2025 11:57:56 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4191' , '2025-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 12/12/2025 11:57:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100426' 12/12/2025 11:57:56 am >> DELETE FROM ps_document_detail WHERE id_document = '100426' 12/12/2025 11:57:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100426' , '20156' , 'PALLA E STELLE CON CARTONCINO - 23' , '20' , '-20' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '40.00' ) 12/12/2025 12:07:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '4192' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-12') 12/12/2025 12:07: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' , '4192' , '2025-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '4.10' , NOW() , NOW() ) 12/12/2025 12:07: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 = '100427' 12/12/2025 12:07:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '100427' 12/12/2025 12:07:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100427' , '3159' , 'CROCE ULIVO SAN BENEDETTO - GRANDE - 741' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 12/12/2025 12:15:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '3916' AND id_document != '100079' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-25') 12/12/2025 12:15:18 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3916', document_date = '2025-11-25', 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 = '129.70', price_tax_excluded = '110.21', date_upd = NOW() WHERE id_document = '100079' 12/12/2025 12:15: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 = '100079' 12/12/2025 12:15:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '100079' 12/12/2025 12:15: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 ( '100079' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 12/12/2025 12:15: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 ( '100079' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 12/12/2025 12:15: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 ( '100079' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '11.00' ) 12/12/2025 12:15: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 ( '100079' , '16796' , 'LUMINO 5B BIANCO' , '104' , '-104' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '31.20' ) 12/12/2025 12:15: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 ( '100079' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '60' , '49.180327868852' , '22' , '0' , '60.00' ) 12/12/2025 12:40:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '36' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2025-12-15') 12/12/2025 12: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 ( '24' , '36' , '2025-12-15' , '' , '0' , '144' , '4670971' , 'VIA DELLE FRATTE, 3 84080 PELLEZZANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3548.60' , '3548.60' , NOW() , NOW() ) 12/12/2025 12: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 = '100428' 12/12/2025 12:40:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '100428' 12/12/2025 12: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 ( '100428' , '24357' , 'A TAVOLA CON GESU' , '25' , '-25' , '4' , '2.50' , '2.5' , '0' , '0' , '62.50' ) 12/12/2025 12:40:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24357' AND id_supplier = '144' 12/12/2025 12:40:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24357' , '144' , '1' ) 12/12/2025 12: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 ( '100428' , '24391' , 'AMADEUS' , '16' , '-16' , '4' , '15.00' , '15' , '0' , '0' , '240.00' ) 12/12/2025 12:40:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24391' AND id_supplier = '144' 12/12/2025 12:40:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24391' , '144' , '1' ) 12/12/2025 12: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 ( '100428' , '24358' , 'ANGELO DI DIO PREGHIERE' , '16' , '-16' , '4' , '1.50' , '1.5' , '0' , '0' , '24.00' ) 12/12/2025 12:40:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24358' AND id_supplier = '144' 12/12/2025 12:40:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24358' , '144' , '1' ) 12/12/2025 12: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 ( '100428' , '15013' , 'AVVENTO' , '10' , '-10' , '4' , '2.00' , '2' , '0' , '0' , '20.00' ) 12/12/2025 12:40:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15013' AND id_supplier = '144' 12/12/2025 12:40:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15013' , '144' , '1' ) 12/12/2025 12: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 ( '100428' , '24361' , 'BENEDETTO XVI' , '45' , '-45' , '4' , '2.50' , '2.5' , '0' , '0' , '112.50' ) 12/12/2025 12:40:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24361' AND id_supplier = '144' 12/12/2025 12:40:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24361' , '144' , '1' ) 12/12/2025 12: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 ( '100428' , '14494' , 'BIBBIA - ANTICO TESTAMENTO' , '4' , '-4' , '4' , '9.00' , '9' , '0' , '0' , '36.00' ) 12/12/2025 12:40:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14494' AND id_supplier = '144' 12/12/2025 12:40:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14494' , '144' , '1' ) 12/12/2025 12: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 ( '100428' , '14496' , 'BIBBIA - ANTICO TESTAMENTO' , '8' , '-8' , '4' , '12.00' , '12' , '0' , '0' , '96.00' ) 12/12/2025 12:40:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14496' AND id_supplier = '144' 12/12/2025 12:40:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14496' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '14495' , 'BIBBIA - NUOVO TESTAMENTO' , '6' , '-6' , '4' , '7.90' , '7.9' , '0' , '0' , '47.40' ) 12/12/2025 12:40:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14495' AND id_supplier = '144' 12/12/2025 12:40:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14495' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '14932' , 'BUON SAMARITANO' , '8' , '-8' , '4' , '1.50' , '1.5' , '0' , '0' , '12.00' ) 12/12/2025 12:40:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14932' AND id_supplier = '144' 12/12/2025 12:40:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14932' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '24375' , 'CANTICO DEI CANTICI' , '34' , '-34' , '4' , '2.50' , '2.5' , '0' , '0' , '85.00' ) 12/12/2025 12:40:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24375' AND id_supplier = '144' 12/12/2025 12:40:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24375' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '1753' , 'CASA DEI RAGAZZI' , '48' , '-48' , '4' , '7.00' , '7' , '0' , '0' , '336.00' ) 12/12/2025 12:40:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1753' AND id_supplier = '144' 12/12/2025 12:40:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1753' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '24363' , 'dio e in dieci parole' , '3' , '-3' , '4' , '4.50' , '4.5' , '0' , '0' , '13.50' ) 12/12/2025 12:40:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24363' AND id_supplier = '144' 12/12/2025 12:40:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24363' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '24364' , 'DON CARLO GNOCCHI' , '38' , '-38' , '4' , '2.00' , '2' , '0' , '0' , '76.00' ) 12/12/2025 12:40:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24364' AND id_supplier = '144' 12/12/2025 12:40:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24364' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '14936' , 'E NATO, ALBUM DA COLORARE' , '79' , '-79' , '4' , '2.00' , '2' , '0' , '0' , '158.00' ) 12/12/2025 12:40:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14936' AND id_supplier = '144' 12/12/2025 12:40:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14936' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '24365' , 'fede e salvezza' , '16' , '-16' , '4' , '2.00' , '2' , '0' , '0' , '32.00' ) 12/12/2025 12:40:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24365' AND id_supplier = '144' 12/12/2025 12:40:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24365' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '14490' , 'FEDE, SPERANZA E CARITA - LE VIRTU TEOLOGALI' , '27' , '-27' , '4' , '7.00' , '7' , '0' , '0' , '189.00' ) 12/12/2025 12:40:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14490' AND id_supplier = '144' 12/12/2025 12:40:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14490' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '14933' , 'FIGLIOL PRODIGO' , '9' , '-9' , '4' , '1.50' , '1.5' , '0' , '0' , '13.50' ) 12/12/2025 12:40:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14933' AND id_supplier = '144' 12/12/2025 12:40:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14933' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '24367' , 'GIOVANNI PAOLO II' , '49' , '-49' , '4' , '2.50' , '2.5' , '0' , '0' , '122.50' ) 12/12/2025 12:40:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24367' AND id_supplier = '144' 12/12/2025 12:40:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24367' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '24368' , 'GIOVANNI XXIII' , '50' , '-50' , '4' , '2.50' , '2.5' , '0' , '0' , '125.00' ) 12/12/2025 12:40:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24368' AND id_supplier = '144' 12/12/2025 12:40:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24368' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '24369' , 'I 10 COMANDAMENTI' , '75' , '-75' , '4' , '2.00' , '2' , '0' , '0' , '150.00' ) 12/12/2025 12:40:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24369' AND id_supplier = '144' 12/12/2025 12:40:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24369' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '24371' , 'I MIRACOLI DA COLORARE GESU E LA TEMPESTA' , '24' , '-24' , '4' , '1.50' , '1.5' , '0' , '0' , '36.00' ) 12/12/2025 12:40:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24371' AND id_supplier = '144' 12/12/2025 12:40:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24371' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '24372' , 'I MIRACOLI DA COLORARE GESU IL FIGLIO' , '25' , '-25' , '4' , '2.00' , '2' , '0' , '0' , '50.00' ) 12/12/2025 12:40:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24372' AND id_supplier = '144' 12/12/2025 12:40:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24372' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '24370' , 'I MIRACOLI DA COLORARE GESU CAMMINA' , '15' , '-15' , '4' , '2.00' , '2' , '0' , '0' , '30.00' ) 12/12/2025 12:40:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24370' AND id_supplier = '144' 12/12/2025 12:40:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24370' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '24373' , 'I MIRACOLI DA COLORARE LE NOZZE' , '22' , '-22' , '4' , '2.00' , '2' , '0' , '0' , '44.00' ) 12/12/2025 12:40:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24373' AND id_supplier = '144' 12/12/2025 12:40:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24373' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '24374' , 'I SANTI E GLI ANIMALI' , '30' , '-30' , '4' , '3.00' , '3' , '0' , '0' , '90.00' ) 12/12/2025 12:40:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24374' AND id_supplier = '144' 12/12/2025 12:40:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24374' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '24381' , 'LE BEATITUDINI' , '34' , '-34' , '4' , '2.00' , '2' , '0' , '0' , '68.00' ) 12/12/2025 12:40:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24381' AND id_supplier = '144' 12/12/2025 12:40:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24381' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '14493' , 'LETTERE DI SAN PAOLO' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 12/12/2025 12:40:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14493' AND id_supplier = '144' 12/12/2025 12:40:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14493' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '24382' , 'LO SPIRITO SANTO RACCONTATO' , '17' , '-17' , '4' , '2.00' , '2' , '0' , '0' , '34.00' ) 12/12/2025 12:40:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24382' AND id_supplier = '144' 12/12/2025 12:40:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24382' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '24383' , 'MADRE TERESA' , '44' , '-44' , '4' , '2.50' , '2.5' , '0' , '0' , '110.00' ) 12/12/2025 12:40:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24383' AND id_supplier = '144' 12/12/2025 12:40:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24383' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '24384' , 'MARIA DALLA NASCITA' , '78' , '-78' , '4' , '2.50' , '2.5' , '0' , '0' , '195.00' ) 12/12/2025 12:40:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24384' AND id_supplier = '144' 12/12/2025 12:40:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24384' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '14930' , 'MARIA LA MAMMA DI GESU' , '47' , '-47' , '4' , '2.50' , '2.5' , '0' , '0' , '117.50' ) 12/12/2025 12:40:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14930' AND id_supplier = '144' 12/12/2025 12:40:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14930' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '24356' , 'NATALE CHE MERAVIGLIA' , '13' , '-13' , '4' , '1.50' , '1.5' , '0' , '0' , '19.50' ) 12/12/2025 12:40:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24356' AND id_supplier = '144' 12/12/2025 12:40:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24356' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '24380' , 'PICCOLA MATITA' , '95' , '-95' , '4' , '1.50' , '1.5' , '0' , '0' , '142.50' ) 12/12/2025 12:40:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24380' AND id_supplier = '144' 12/12/2025 12:40:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24380' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '14928' , 'PICCOLI CRISTIANI' , '34' , '-34' , '4' , '1.80' , '1.8' , '0' , '0' , '61.20' ) 12/12/2025 12:40:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14928' AND id_supplier = '144' 12/12/2025 12:40:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14928' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '14931' , 'SACRA SINDONE SPIEGATA AI RAGAZZI' , '14' , '-14' , '4' , '1.00' , '1' , '0' , '0' , '14.00' ) 12/12/2025 12:40:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14931' AND id_supplier = '144' 12/12/2025 12:40:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14931' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '15012' , 'SALMI ANATOMIA DELLANIMA' , '12' , '-12' , '4' , '2.50' , '2.5' , '0' , '0' , '30.00' ) 12/12/2025 12:40:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15012' AND id_supplier = '144' 12/12/2025 12:40:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15012' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '14489' , 'SAN FRANCESCO + DVD' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '0' , '13.00' ) 12/12/2025 12:40:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14489' AND id_supplier = '144' 12/12/2025 12:40:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14489' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '24387' , 'SAN PAOLO' , '15' , '-15' , '4' , '2.50' , '2.5' , '0' , '0' , '37.50' ) 12/12/2025 12:40:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24387' AND id_supplier = '144' 12/12/2025 12:40:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24387' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '24388' , 'SANTA CATERINA' , '27' , '-27' , '4' , '2.00' , '2' , '0' , '0' , '54.00' ) 12/12/2025 12:40:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24388' AND id_supplier = '144' 12/12/2025 12:40:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24388' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '14934' , 'SEMINATORE' , '9' , '-9' , '4' , '1.50' , '1.5' , '0' , '0' , '13.50' ) 12/12/2025 12:40:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14934' AND id_supplier = '144' 12/12/2025 12:40:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14934' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '10278' , 'STORIA DELLA SALVEZZA RACCONTATA AI BAMBINI - 1 ADAMO ED EVA' , '80' , '-80' , '4' , '2.00' , '2' , '0' , '0' , '160.00' ) 12/12/2025 12:40:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10278' AND id_supplier = '144' 12/12/2025 12:40:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10278' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '10279' , 'STORIA DELLA SALVEZZA RACCONTATA AI BAMBINI 2' , '84' , '-84' , '4' , '2.00' , '2' , '0' , '0' , '168.00' ) 12/12/2025 12:40:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10279' AND id_supplier = '144' 12/12/2025 12:40:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10279' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '24389' , 'TU SEI PIETRO' , '37' , '-37' , '4' , '2.50' , '2.5' , '0' , '0' , '92.50' ) 12/12/2025 12:40:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24389' AND id_supplier = '144' 12/12/2025 12:40:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24389' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '24390' , 'TU SOLO HAI PAROLE' , '3' , '-3' , '4' , '1.50' , '1.5' , '0' , '0' , '4.50' ) 12/12/2025 12:40:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24390' AND id_supplier = '144' 12/12/2025 12:40:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24390' , '144' , '1' ) 12/12/2025 12:40: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 ( '100428' , '14497' , 'VIAGGIO IN TERRA SANTA' , '1' , '-1' , '4' , '9.50' , '9.5' , '0' , '0' , '9.50' ) 12/12/2025 12:40:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14497' AND id_supplier = '144' 12/12/2025 12:40:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14497' , '144' , '1' ) 12/12/2025 12:50:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '4193' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-12') 12/12/2025 12:50:33 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' , '4193' , '2025-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.50' , '15.98' , NOW() , NOW() ) 12/12/2025 12:50:33 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 = '100429' 12/12/2025 12:50:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '100429' 12/12/2025 12:50:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100429' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '3' , '-3' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '19.50' ) 12/12/2025 03:06:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '4183' AND id_document != '100417' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-12') 12/12/2025 03:06:16 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4183', document_date = '2025-12-12', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', 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 = '484.00', price_tax_excluded = '425.42', date_upd = NOW() WHERE id_document = '100417' 12/12/2025 03:06:16 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 = '100417' 12/12/2025 03:06:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '100417' 12/12/2025 03:06:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100417' , '12527' , 'LAMPADA A SFERA VIOLA' , '4' , '-4' , '1' , '25' , '20.491803278689' , '22' , '0' , '100.00' ) 12/12/2025 03:06:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100417' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 12/12/2025 03:06:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100417' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.5000' , '7.7868852459016' , '22' , '0' , '38.00' ) 12/12/2025 03:06:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100417' , '21137' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '30.00' ) 12/12/2025 03:06: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 ( '100417' , '5759' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO A' , '1' , '-1' , '4' , '65.0000' , '65' , '0' , '0' , '65.00' ) 12/12/2025 03:06: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 ( '100417' , '5775' , 'LEZIONARIO PER LE MESSE RITUALI' , '1' , '-1' , '4' , '90.0000' , '90' , '0' , '0' , '90.00' ) 12/12/2025 03:06: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 ( '100417' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 12/12/2025 03:06: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 ( '100417' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '51.00' ) 12/12/2025 03:06: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 ( '100417' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '14.70' ) 12/12/2025 03:06: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 ( '100417' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '1.3000' , '1.25' , '4' , '0' , '1.30' ) 12/12/2025 03:31:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '4194' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-12') 12/12/2025 03:31:32 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4194' , '2025-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.00' , '27.87' , NOW() , NOW() ) 12/12/2025 03:31:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100430' 12/12/2025 03:31:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '100430' 12/12/2025 03:31:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100430' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 12/12/2025 03:31:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100430' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 12/12/2025 03:45:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '4195' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-12') 12/12/2025 03:45:56 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' , '4195' , '2025-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.60' , '6.23' , NOW() , NOW() ) 12/12/2025 03:45: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 = '100431' 12/12/2025 03:45:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '100431' 12/12/2025 03:45: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 ( '100431' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '1' , '-1' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '6.50' ) 12/12/2025 03:45: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 ( '100431' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '1.10' ) 12/12/2025 03:47:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '4196' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-12') 12/12/2025 03:47:52 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' , '4196' , '2025-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '1.64' , NOW() , NOW() ) 12/12/2025 03:47: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 = '100432' 12/12/2025 03:47:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '100432' 12/12/2025 03:47: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 ( '100432' , '24270' , 'SET 4 CANDELE AVVENTO - P764MUL' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 12/12/2025 03:57:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '35/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-12') 12/12/2025 03:57: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 ( '23' , '35/L' , '2025-12-12' , 'L' , '204' , '0' , '4671483' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , 'CAMPOLONGO HOSPITAL' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '223.00' , '182.79' , NOW() , NOW() ) 12/12/2025 03:57: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 = '100433' 12/12/2025 03:57:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '100433' 12/12/2025 03:57: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 ( '100433' , '5976' , 'LUCERNA VETRO - 1493' , '2' , '-2' , '1' , '21.0000' , '17.2131' , '22' , '0' , '42.00' ) 12/12/2025 03:57: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 ( '100433' , '24092' , 'PORTAOSTIE - SC 291-COM' , '1' , '-1' , '1' , '15.0000' , '12.2951' , '22' , '0' , '15.00' ) 12/12/2025 03:57: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 ( '100433' , '24090' , 'PORTAOSTIE - SC 291-CAL' , '1' , '-1' , '1' , '15.0000' , '12.2951' , '22' , '0' , '15.00' ) 12/12/2025 03:57: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 ( '100433' , '8197' , 'PORTATECA - 059' , '2' , '-2' , '1' , '8.5000' , '6.9672' , '22' , '0' , '17.00' ) 12/12/2025 03:57: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 ( '100433' , '2436' , 'COLORANTE PER CERA LIQUIDA - 1002' , '2' , '-2' , '1' , '2.0000' , '1.6393' , '22' , '0' , '4.00' ) 12/12/2025 03:57: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 ( '100433' , '16731' , 'COPRILEGGIO CROCE ORO - AVCL01' , '2' , '-2' , '1' , '65.0000' , '53.2787' , '22' , '0' , '130.00' ) 12/12/2025 04:02:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '36/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-12') 12/12/2025 04:02:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '36/L' , '2025-12-12' , 'L' , '204' , '0' , '4671483' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , 'CAPPELLANIA UNIVERSITA\'' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '159.50' , '134.50' , NOW() , NOW() ) 12/12/2025 04:02:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100434' 12/12/2025 04:02:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '100434' 12/12/2025 04:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100434' , '24021' , 'CALENDARIO LITURGICO 2026 - 8164' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 12/12/2025 04:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100434' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.7000' , '0.7' , '0' , '0' , '0.70' ) 12/12/2025 04:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100434' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9231' , '4' , '0' , '4.00' ) 12/12/2025 04:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100434' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.5000' , '4.3269' , '4' , '0' , '4.50' ) 12/12/2025 04:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100434' , '22809' , 'O LUCE BEATISSIMA' , '5' , '-5' , '4' , '2.5000' , '2.5' , '0' , '0' , '12.50' ) 12/12/2025 04:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100434' , '18046' , 'TECA PLACCA SMALTATA - 504' , '1' , '-1' , '1' , '33.5000' , '27.459' , '22' , '0' , '33.50' ) 12/12/2025 04:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100434' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.459' , '22' , '0' , '90.00' ) 12/12/2025 04:02:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100434' , '24073' , 'AGENDA LITURGICO PASTORALE 2026 - 40830' , '1' , '-1' , '1' , '14.0000' , '11.4754' , '22' , '5' , '13.30' ) 12/12/2025 04:03:26 pm >> DELETE FROM ps_document WHERE id_document = '99347' 12/12/2025 04:03:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '99347' 12/12/2025 04:03:31 pm >> DELETE FROM ps_document WHERE id_document = '100227' 12/12/2025 04:03:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '100227' 12/12/2025 04:06:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '4197' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-12') 12/12/2025 04:06:31 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' , '4197' , '2025-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.50' , '11.06' , NOW() , NOW() ) 12/12/2025 04:06: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 = '100435' 12/12/2025 04:06:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '100435' 12/12/2025 04:06: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 ( '100435' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 12/12/2025 04:06: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 ( '100435' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 12/12/2025 04:17:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '37/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-12') 12/12/2025 04:17: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 ( '23' , '37/L' , '2025-12-12' , 'L' , '204' , '0' , '4671483' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , 'CAPPELLANIA OSP. BATTIPAGLIA' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '71.70' , '64.41' , NOW() , NOW() ) 12/12/2025 04:17: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 = '100436' 12/12/2025 04:17:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '100436' 12/12/2025 04:17: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 ( '100436' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '25' , '-25' , '4' , '0.7000' , '0.7' , '0' , '0' , '17.50' ) 12/12/2025 04:17: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 ( '100436' , '16689' , 'OSTIA PAN DI CENA mm80' , '4' , '-4' , '3' , '2.0000' , '1.9231' , '4' , '0' , '8.00' ) 12/12/2025 04:17: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 ( '100436' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3654' , '4' , '0' , '7.00' ) 12/12/2025 04:17: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 ( '100436' , '24021' , 'CALENDARIO LITURGICO 2026 - 8164' , '2' , '-2' , '4' , '1.0000' , '1' , '0' , '0' , '2.00' ) 12/12/2025 04:17: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 ( '100436' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.6000' , '2.9508' , '22' , '0' , '7.20' ) 12/12/2025 04:17: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 ( '100436' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '2' , '-2' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '30.00' ) 12/12/2025 04:18:12 pm >> DELETE FROM ps_document WHERE id_document = '99322' 12/12/2025 04:18:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '99322' 12/12/2025 04:30:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '4198' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-12') 12/12/2025 04:30: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' , '4198' , '2025-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.52' , '20.52' , NOW() , NOW() ) 12/12/2025 04:30: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 = '100437' 12/12/2025 04:30:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '100437' 12/12/2025 04:30: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 ( '100437' , '24188' , 'MA ANCHE NO - F. ROSINI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 12/12/2025 04:30: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 ( '100437' , '24346' , 'INSIEME NELLA MESSA - GEN 26' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '5' , '1.71' ) 12/12/2025 04:30: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 ( '100437' , '24347' , 'INSIEME NELLA MESSA - FEB 26' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '5' , '1.71' ) 12/12/2025 04:38:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '4199' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-12') 12/12/2025 04:38:22 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' , '4199' , '2025-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.50' , '18.44' , NOW() , NOW() ) 12/12/2025 04:38: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 = '100438' 12/12/2025 04:38:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '100438' 12/12/2025 04:38: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 ( '100438' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '50' , '-50' , '1' , '0.45' , '0.36885245901639' , '22' , '0' , '22.50' ) 12/12/2025 05:24:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '4200' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-12') 12/12/2025 05:24:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4200' , '2025-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '39.23' , NOW() , NOW() ) 12/12/2025 05:24:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100439' 12/12/2025 05:24:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '100439' 12/12/2025 05:24:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100439' , '20061' , 'BRACCIALE DECINA - BC528' , '8' , '-8' , '1' , '1.60' , '1.3114754098361' , '22' , '0' , '12.80' ) 12/12/2025 05:24:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100439' , '18214' , 'BRACCIALE DECINA LEGNO CORDA - BC566' , '1' , '-1' , '1' , '1.8' , '1.4754098360656' , '22' , '0' , '1.80' ) 12/12/2025 05:24:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100439' , '7202' , 'ARTICOLI RELIGIOSI' , '4' , '-4' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '6.00' ) 12/12/2025 05:24:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100439' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 12/12/2025 05:24:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100439' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 12/12/2025 05:24:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100439' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 12/12/2025 05:27:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '4201' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-12') 12/12/2025 05:27:52 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' , '4201' , '2025-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '4.92' , NOW() , NOW() ) 12/12/2025 05:27: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 = '100440' 12/12/2025 05:27:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '100440' 12/12/2025 05:27: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 ( '100440' , '18884' , 'BAMBINELLO CM 10 - PB13627' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 12/12/2025 05:28:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '4202' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-12') 12/12/2025 05:28:21 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' , '4202' , '2025-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '11.48' , NOW() , NOW() ) 12/12/2025 05:28:21 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 = '100441' 12/12/2025 05:28:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '100441' 12/12/2025 05:28:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100441' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '35' , '-35' , '1' , '0.4' , '0.32786885245902' , '22' , '0' , '14.00' ) 12/12/2025 05:59:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '4203' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-12') 12/12/2025 05:59: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' , '4203' , '2025-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.80' , '0.80' , NOW() , NOW() ) 12/12/2025 05:59: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 = '100442' 12/12/2025 05:59:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '100442' 12/12/2025 05:59: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 ( '100442' , '23807' , 'CALENDARIO LITURGICO 2026' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 12/12/2025 06:46:11 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '1823' 12/12/2025 06:46:11 pm >> UPDATE ps_stock_available SET quantity = quantity + '-2' WHERE id_product = '1823' 12/12/2025 07:01:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '4204' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-12') 12/12/2025 07:01:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4204' , '2025-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.80' , '19.91' , NOW() , NOW() ) 12/12/2025 07:01:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100443' 12/12/2025 07:01:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '100443' 12/12/2025 07:01:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100443' , '22968' , 'TURIBOLO H10' , '1' , '-1' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '16.00' ) 12/12/2025 07:01:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100443' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 12/12/2025 07:01:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100443' , '23807' , 'CALENDARIO LITURGICO 2026' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 12/12/2025 07:01:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100443' , '24021' , 'CALENDARIO LITURGICO 2026 - 8164' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 12/12/2025 07:07:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '4205' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-12') 12/12/2025 07:07: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' , '4205' , '2025-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 12/12/2025 07:07: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 = '100444' 12/12/2025 07:07:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '100444' 12/12/2025 07:07: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 ( '100444' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 12/12/2025 07:07: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 ( '100444' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 12/12/2025 07:27:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '4206' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-12') 12/12/2025 07:27: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' , '4206' , '2025-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.99' , '8.19' , NOW() , NOW() ) 12/12/2025 07:27: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 = '100445' 12/12/2025 07:27:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '100445' 12/12/2025 07:27: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 ( '100445' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' , '3.33' , '2.7295081967213' , '22' , '0' , '9.99' ) 12/12/2025 07:31:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '4207' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-12') 12/12/2025 07:31: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' , '4207' , '2025-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '141.42' , '141.42' , NOW() , NOW() ) 12/12/2025 07:31: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 = '100446' 12/12/2025 07:31:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '100446' 12/12/2025 07:31: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 ( '100446' , '1826' , 'CATECHISMO DELLA CHIESA CATTOLICA COMPENDIO' , '10' , '-10' , '4' , '12.00' , '12' , '0' , '5' , '114.00' ) 12/12/2025 07:31: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 ( '100446' , '1823' , 'CATECHISMO DELLA CHIESA CATTOLICA - COMPENDIO' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '0' , '20.00' ) 12/12/2025 07:31: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 ( '100446' , '24400' , 'MATER POPULI FIDELIS' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' )