22/03/2025 09:34:03 am >> SELECT document_num FROM ps_document WHERE document_num = '952' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-22') 22/03/2025 09:34:03 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' , '952' , '2025-03-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '16.39' , NOW() , NOW() ) 22/03/2025 09:34:03 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 = '96336' 22/03/2025 09:34:03 am >> DELETE FROM ps_document_detail WHERE id_document = '96336' 22/03/2025 09:34:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96336' , '22286' , 'COLLETTO DOPPIO MISTO LINO - CD01/C' , '1' , '-1' , '1' , '17' , '13.934426229508' , '22' , '0' , '17.00' ) 22/03/2025 09:34:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96336' , '12833' , 'BOTTONE RETROCOLLO - 21630' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 22/03/2025 09:45:31 am >> SELECT document_num FROM ps_document WHERE document_num = '953' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-22') 22/03/2025 09:45:31 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' , '953' , '2025-03-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.20' , '10.00' , NOW() , NOW() ) 22/03/2025 09:45:31 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96337' 22/03/2025 09:45:31 am >> DELETE FROM ps_document_detail WHERE id_document = '96337' 22/03/2025 09:45:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96337' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '1' , '-1' , '1' , '12.20' , '10' , '22' , '0' , '12.20' ) 22/03/2025 10:10:51 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 22/03/2025 10:10:51 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23594' , '1' , '' , 'nuovo-prodotto' ) 22/03/2025 10:10:51 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23594' , '1' , '1' , '2' , NOW() , NOW() ) 22/03/2025 10:10:51 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23594' , '0' , '1' , '0' , '0' ) 22/03/2025 10:11:53 am >> SELECT document_num FROM ps_document WHERE document_num = '586' AND id_document != '95870' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-22') 22/03/2025 10:11:53 am >> UPDATE ps_document SET id_document_type = '11', document_num = '586', document_date = '2025-02-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '64.84', price_tax_excluded = '55.82', date_upd = NOW() WHERE id_document = '95870' 22/03/2025 10:11:53 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 = '95870' 22/03/2025 10:11:53 am >> DELETE FROM ps_document_detail WHERE id_document = '95870' 22/03/2025 10:11:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95870' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '4' , '-4' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '1.00' ) 22/03/2025 10:11:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95870' , '23492' , 'AMEN - GIU 25' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 22/03/2025 10:11:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95870' , '23491' , 'AMEN - MAG 25' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 22/03/2025 10:11:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95870' , '23279' , 'AMEN - APR 25' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 22/03/2025 10:11:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95870' , '23278' , 'AMEN - MAR 25' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 22/03/2025 10:11:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95870' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '49.00' , '40.16393442623' , '22' , '0' , '49.00' ) 22/03/2025 10:34:22 am >> SELECT document_num FROM ps_document WHERE document_num = '954' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-22') 22/03/2025 10:34:22 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' , '954' , '2025-03-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.50' , '14.34' , NOW() , NOW() ) 22/03/2025 10:34:22 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96338' 22/03/2025 10:34:22 am >> DELETE FROM ps_document_detail WHERE id_document = '96338' 22/03/2025 10:34:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96338' , '539' , 'AMPOLLA RICAMBIO PER ART. 506 - 17' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 22/03/2025 10:34:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96338' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '7.00' ) 22/03/2025 10:34:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96338' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 22/03/2025 11:01:26 am >> SELECT document_num FROM ps_document WHERE document_num = '955' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-22') 22/03/2025 11:01: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' , '955' , '2025-03-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.60' , '38.08' , NOW() , NOW() ) 22/03/2025 11:01: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 = '96339' 22/03/2025 11:01:26 am >> DELETE FROM ps_document_detail WHERE id_document = '96339' 22/03/2025 11:01: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 ( '96339' , '5411' , 'INVITO ALLAMORE - 8251' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 22/03/2025 11:01: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 ( '96339' , '4943' , 'IMITAZIONE DI CRISTO - 8123' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 22/03/2025 11:01: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 ( '96339' , '11152' , 'VARIE - OSTIE - PARTICOLE' , '1' , '-1' , '3' , '13.5' , '12.980769230769' , '4' , '0' , '13.50' ) 22/03/2025 11:01: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 ( '96339' , '978' , 'BEATA VERGINE MARIA CHE SCIOGLIE I NODI - ALBERO GENEALOGICO' , '1' , '-1' , '4' , '2.20' , '2.2' , '0' , '0' , '2.20' ) 22/03/2025 11:01: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 ( '96339' , '8765' , 'QUINDICI ORAZIONI DI SANTA BRIGIDA - 8193' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 22/03/2025 11:04:15 am >> SELECT document_num FROM ps_document WHERE document_num = '956' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-22') 22/03/2025 11:04:15 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' , '956' , '2025-03-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '85.00' , '69.67' , NOW() , NOW() ) 22/03/2025 11:04:15 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 = '96340' 22/03/2025 11:04:15 am >> DELETE FROM ps_document_detail WHERE id_document = '96340' 22/03/2025 11:04:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96340' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '36.00' ) 22/03/2025 11:04:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96340' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '24.5' , '20.081967213115' , '22' , '0' , '49.00' ) 22/03/2025 11:25:48 am >> SELECT document_num FROM ps_document WHERE document_num = '50' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-03-22') 22/03/2025 11:25:48 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '50' , '2025-03-22' , '' , '3826' , '0' , '4672780' , 'P. ZZA UMBERTO I 35 - PREPEZZANO 84090 GIFFONI SEI CASALI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.30' , '32.30' , NOW() , NOW() ) 22/03/2025 11:25:48 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 = '96341' 22/03/2025 11:25:48 am >> DELETE FROM ps_document_detail WHERE id_document = '96341' 22/03/2025 11:25:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96341' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '20' , '-20' , '4' , '1.90' , '1.9' , '0' , '15' , '32.30' ) 22/03/2025 11:27:02 am >> SELECT document_num FROM ps_document WHERE document_num = '957' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-22') 22/03/2025 11:27: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' , '957' , '2025-03-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.04' , '15.04' , NOW() , NOW() ) 22/03/2025 11:27: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 = '96342' 22/03/2025 11:27:02 am >> DELETE FROM ps_document_detail WHERE id_document = '96342' 22/03/2025 11:27: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 ( '96342' , '20872' , 'CON TE GESU ' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 22/03/2025 11:27: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 ( '96342' , '23452' , 'TUTTO RICOMINCIA ' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '5' , '2.66' ) 22/03/2025 11:27: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 ( '96342' , '18163' , 'GIOCO DELLE PAROLE DI DIO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 22/03/2025 11:45:09 am >> SELECT document_num FROM ps_document WHERE document_num = '40/A' AND id_document != '95744' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-02-14') 22/03/2025 11:45:09 am >> UPDATE ps_document SET id_document_type = '24', document_num = '40/A', document_date = '2025-02-14', document_letter = 'A', id_customer = '2757', id_supplier = '', id_address = '4679344', address1 = 'VIA CIRILLO 84085 MERCATO SAN SEVERINO', 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 = '1934.70', price_tax_excluded = '1594.69', date_upd = NOW() WHERE id_document = '95744' 22/03/2025 11:45:09 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95744' 22/03/2025 11:45:09 am >> DELETE FROM ps_document_detail WHERE id_document = '95744' 22/03/2025 11:45: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 ( '95744' , '16796' , 'LUMINO 5B BIANCO' , '2016' , '-2016' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '403.20' ) 22/03/2025 11:45: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 ( '95744' , '1041' , 'BENEDIZIONI' , '1000' , '-1000' , '1' , '0.1800' , '0.14754098360656' , '22' , '0' , '180.00' ) 22/03/2025 11:45: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 ( '95744' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '7' , '-7' , '1' , '24.0000' , '19.672131147541' , '22' , '0' , '168.00' ) 22/03/2025 11:45: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 ( '95744' , '15210' , 'CERO PASQUALE API 80X120' , '2' , '-2' , '1' , '145.0000' , '118.85245901639' , '22' , '0' , '290.00' ) 22/03/2025 11:45: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 ( '95744' , '23531' , 'COPRI LEZIONARIO PLACCA ARG. - 082' , '1' , '-1' , '1' , '146.0000' , '119.67213114754' , '22' , '0' , '146.00' ) 22/03/2025 11:45: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 ( '95744' , '16796' , 'LUMINO 5B BIANCO' , '3360' , '-3360' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '672.00' ) 22/03/2025 11:45: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 ( '95744' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 22/03/2025 11:45: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 ( '95744' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '8' , '-8' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '28.00' ) 22/03/2025 11:45: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 ( '95744' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 22/03/2025 11:45: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 ( '95744' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '7' , '-7' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '24.50' ) 22/03/2025 11:45: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 ( '95744' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 22/03/2025 11:46:05 am >> SELECT document_num FROM ps_document WHERE document_num = '958' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-22') 22/03/2025 11:46:05 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' , '958' , '2025-03-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '69.00' , '59.98' , NOW() , NOW() ) 22/03/2025 11:46:05 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 = '96343' 22/03/2025 11:46:05 am >> DELETE FROM ps_document_detail WHERE id_document = '96343' 22/03/2025 11:46:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96343' , '23443' , 'MA COME SI FA?' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 22/03/2025 11:46:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96343' , '23407' , 'PROCESSO AL PROCESSETTO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 22/03/2025 11:46:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96343' , '22410' , 'CONFEZIONE COLLANINA PADRE NOSTRO - 4300-T07' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 22/03/2025 11:59:33 am >> SELECT document_num FROM ps_document WHERE document_num = '50' AND id_document != '96341' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-03-22') 22/03/2025 11:59:33 am >> UPDATE ps_document SET id_document_type = '21', document_num = '50', document_date = '2025-03-22', document_letter = '', id_customer = '3826', id_supplier = '', id_address = '4672780', address1 = 'P. ZZA UMBERTO I 35 - PREPEZZANO 84090 GIFFONI SEI CASALI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '32.30', price_tax_excluded = '32.30', date_upd = NOW() WHERE id_document = '96341' 22/03/2025 11:59:33 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 = '96341' 22/03/2025 11:59:34 am >> DELETE FROM ps_document_detail WHERE id_document = '96341' 22/03/2025 11:59:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96341' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '20' , '-20' , '4' , '1.9000' , '1.9' , '0' , '15' , '32.30' ) 22/03/2025 12:01:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '955' AND id_document != '96339' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-22') 22/03/2025 12:01:40 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '955', document_date = '2025-03-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '38.60', price_tax_excluded = '38.08', date_upd = NOW() WHERE id_document = '96339' 22/03/2025 12:01:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96339' 22/03/2025 12:01:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '96339' 22/03/2025 12:01:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96339' , '5411' , 'INVITO ALLAMORE - 8251' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 22/03/2025 12:01:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96339' , '4943' , 'IMITAZIONE DI CRISTO - 8123' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 22/03/2025 12:01: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 ( '96339' , '978' , 'BEATA VERGINE MARIA CHE SCIOGLIE I NODI - ALBERO GENEALOGICO' , '1' , '-1' , '4' , '2.2000' , '2.2' , '0' , '0' , '2.20' ) 22/03/2025 12:01: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 ( '96339' , '8765' , 'QUINDICI ORAZIONI DI SANTA BRIGIDA - 8193' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 22/03/2025 12:01: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 ( '96339' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 22/03/2025 12:01: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 ( '96339' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 22/03/2025 12:16:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '40/A' AND id_document != '95744' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-02-14') 22/03/2025 12:16:54 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '40/A', document_date = '2025-02-14', document_letter = 'A', id_customer = '2757', id_supplier = '', id_address = '4679344', address1 = 'VIA CIRILLO 84085 MERCATO SAN SEVERINO', 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 = '1960.70', price_tax_excluded = '1616.00', date_upd = NOW() WHERE id_document = '95744' 22/03/2025 12:16: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 = '95744' 22/03/2025 12:16:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '95744' 22/03/2025 12:16: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 ( '95744' , '16796' , 'LUMINO 5B BIANCO' , '2016' , '-2016' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '403.20' ) 22/03/2025 12:16: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 ( '95744' , '1041' , 'BENEDIZIONI' , '1000' , '-1000' , '1' , '0.1800' , '0.14754098360656' , '22' , '0' , '180.00' ) 22/03/2025 12:16: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 ( '95744' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '7' , '-7' , '1' , '24.0000' , '19.672131147541' , '22' , '0' , '168.00' ) 22/03/2025 12:16: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 ( '95744' , '15210' , 'CERO PASQUALE API 80X120' , '2' , '-2' , '1' , '145.0000' , '118.85245901639' , '22' , '0' , '290.00' ) 22/03/2025 12:16: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 ( '95744' , '23531' , 'COPRI LEZIONARIO PLACCA ARG. - 082' , '1' , '-1' , '1' , '146.0000' , '119.67213114754' , '22' , '0' , '146.00' ) 22/03/2025 12:16: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 ( '95744' , '16796' , 'LUMINO 5B BIANCO' , '3360' , '-3360' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '672.00' ) 22/03/2025 12:16: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 ( '95744' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '6.00' ) 22/03/2025 12:16: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 ( '95744' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '8' , '-8' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '28.00' ) 22/03/2025 12:16: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 ( '95744' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 22/03/2025 12:16: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 ( '95744' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '7' , '-7' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '24.50' ) 22/03/2025 12:16: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 ( '95744' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 22/03/2025 12:16: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 ( '95744' , '15332' , 'GRANI PER CERO' , '2' , '-2' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '26.00' ) 22/03/2025 12:28:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '959' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-22') 22/03/2025 12:28: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' , '959' , '2025-03-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.30' , '7.98' , NOW() , NOW() ) 22/03/2025 12:28: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 = '96344' 22/03/2025 12:28:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '96344' 22/03/2025 12:28: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 ( '96344' , '11152' , 'VARIE - OSTIE - PARTICOLE' , '1' , '-1' , '3' , '8.3' , '7.9807692307692' , '4' , '0' , '8.30' ) 22/03/2025 12:48:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '959' AND id_document != '96344' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-22') 22/03/2025 12:48:14 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '959', document_date = '2025-03-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '8.30', price_tax_excluded = '7.98', date_upd = NOW() WHERE id_document = '96344' 22/03/2025 12:48: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 = '96344' 22/03/2025 12:48:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '96344' 22/03/2025 12:48: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 ( '96344' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.3' , '1.25' , '4' , '0' , '1.30' ) 22/03/2025 12:48: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 ( '96344' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 22/03/2025 12:48:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '960' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-22') 22/03/2025 12:48:35 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' , '960' , '2025-03-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.50' , '10.10' , NOW() , NOW() ) 22/03/2025 12:48:35 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 = '96345' 22/03/2025 12:48:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '96345' 22/03/2025 12:48:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96345' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' )