03/02/2024 09:08:24 am >> SELECT document_num FROM ps_document WHERE document_num = '9/A' AND id_document != '89917' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-12') 03/02/2024 09:08:24 am >> UPDATE ps_document SET id_document_type = '24', document_num = '9/A', document_date = '2024-01-12', document_letter = 'A', id_customer = '3712', id_supplier = '', id_address = '4671443', address1 = 'VIA DALMAZIA 6 84121 SALERNO', 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 = '110.30', price_tax_excluded = '97.84', date_upd = NOW() WHERE id_document = '89917' 03/02/2024 09:08:24 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 = '89917' 03/02/2024 09:08:24 am >> DELETE FROM ps_document_detail WHERE id_document = '89917' 03/02/2024 09:08:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '0' , 'rimanenza vecchio conto ' , '1' , '-1' , '0' , '6.2000' , '6.2' , '0' , '0' , '6.20' ) 03/02/2024 09:08:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 03/02/2024 09:08:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.7000' , '0.7' , '0' , '0' , '35.00' ) 03/02/2024 09:08:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 03/02/2024 09:08:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 03/02/2024 09:11:47 am >> SELECT document_num FROM ps_document WHERE document_num = '9/A' AND id_document != '89917' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-12') 03/02/2024 09:11:47 am >> UPDATE ps_document SET id_document_type = '24', document_num = '9/A', document_date = '2024-01-12', document_letter = 'A', id_customer = '3712', id_supplier = '', id_address = '4671443', address1 = 'VIA DALMAZIA 6 84121 SALERNO', 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 = '116.30', price_tax_excluded = '102.76', date_upd = NOW() WHERE id_document = '89917' 03/02/2024 09:11:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89917' 03/02/2024 09:11:47 am >> DELETE FROM ps_document_detail WHERE id_document = '89917' 03/02/2024 09:11:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '0' , 'rimanenza vecchio conto ' , '1' , '-1' , '0' , '6.2000' , '6.2' , '0' , '0' , '6.20' ) 03/02/2024 09:11:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 03/02/2024 09:11:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.7000' , '0.7' , '0' , '0' , '35.00' ) 03/02/2024 09:11:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 03/02/2024 09:11:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.8000' , '3.1147540983607' , '22' , '0' , '3.80' ) 03/02/2024 09:11:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89917' , '15387' , 'VESTINA BATTESIMALE ' , '2' , '-2' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '6.00' ) 03/02/2024 09:21:19 am >> SELECT document_num FROM ps_document WHERE document_num = '3' AND id_document != '79914' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-01-19') 03/02/2024 09:21:19 am >> UPDATE ps_document SET id_document_type = '24', document_num = '3', document_date = '2023-01-19', document_letter = '', id_customer = '0', id_supplier = '107', id_address = '4669100', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'RESA - N. C. RICEVUTA', 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 = '138.00', price_tax_excluded = '138.00', date_upd = NOW() WHERE id_document = '79914' 03/02/2024 09:21:19 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 = '79914' 03/02/2024 09:21:19 am >> DELETE FROM ps_document_detail WHERE id_document = '79914' 03/02/2024 09:21:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '79914' , '18698' , 'MESSALE ROMANO III EDIZIONE - G. RUPPI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 03/02/2024 09:21:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '18698' AND id_supplier = '107' 03/02/2024 09:21:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18698' , '107' , '1' ) 03/02/2024 09:21:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '79914' , '17686' , 'MYSTERIUM ECCLESIAE NELLEUCOLOGIA DEL MESSALE ROMANO - V. PIERRI' , '2' , '-2' , '4' , '30.0000' , '30' , '0' , '0' , '60.00' ) 03/02/2024 09:21:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '17686' AND id_supplier = '107' 03/02/2024 09:21:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17686' , '107' , '1' ) 03/02/2024 09:21:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '79914' , '707' , 'APOSTOLI DI CRISTO PROTETTORI IN CAMPANIA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 03/02/2024 09:21:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '707' AND id_supplier = '107' 03/02/2024 09:21:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '707' , '107' , '1' ) 03/02/2024 09:21:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '79914' , '18570' , 'GIUSEPPE E I SUOI FRATELLI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 03/02/2024 09:21:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '18570' AND id_supplier = '107' 03/02/2024 09:21:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18570' , '107' , '1' ) 03/02/2024 09:21:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '79914' , '16824' , 'ARCO DI LUCE - G. DE PONTI CONTI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 03/02/2024 09:21:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '16824' AND id_supplier = '107' 03/02/2024 09:21:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16824' , '107' , '1' ) 03/02/2024 09:21:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '79914' , '19256' , 'SALUS ANIMARUM E COMMUNIO EUCHARISTICA - M. GIAVAZZI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 03/02/2024 09:21:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '19256' AND id_supplier = '107' 03/02/2024 09:21:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19256' , '107' , '1' ) 03/02/2024 09:21:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '79914' , '19579' , 'FAMIGLIA PORTA DELLA FEDE' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 03/02/2024 09:21:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '19579' AND id_supplier = '107' 03/02/2024 09:21:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19579' , '107' , '1' ) 03/02/2024 09:21:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '79914' , '18694' , 'BELLA LA MIA FAMIGLIA - SUSSIDIO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 03/02/2024 09:21:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '18694' AND id_supplier = '107' 03/02/2024 09:21:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18694' , '107' , '1' ) 03/02/2024 09:21:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '79914' , '18695' , 'BELLA LA MIA FAMIGLIA - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 03/02/2024 09:21:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '18695' AND id_supplier = '107' 03/02/2024 09:21:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18695' , '107' , '1' ) 03/02/2024 10:20:44 am >> SELECT document_num FROM ps_document WHERE document_num = '4' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2024-02-03') 03/02/2024 10:20:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '4' , '2024-02-03' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RESA' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '9' , '464.90' , '463.01' , NOW() , NOW() ) 03/02/2024 10:20:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90225' 03/02/2024 10:20:44 am >> DELETE FROM ps_document_detail WHERE id_document = '90225' 03/02/2024 10:20:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90225' , '17916' , 'VINCOLO DELLA FRATERNITA - S. FARI' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '0' , '20.00' ) 03/02/2024 10:20:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '17916' AND id_supplier = '107' 03/02/2024 10:20:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17916' , '107' , '1' ) 03/02/2024 10:20:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90225' , '20046' , 'PREGHIERE NEI VANGELI - G. DE VIRGILIO' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '0' , '17.00' ) 03/02/2024 10:20:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '20046' AND id_supplier = '107' 03/02/2024 10:20:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20046' , '107' , '1' ) 03/02/2024 10:20:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90225' , '14861' , 'BELLEZZA TUA VOGLIO CANTARE - ANNO C - E. RONCHI' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '0' , '17.00' ) 03/02/2024 10:20:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '14861' AND id_supplier = '107' 03/02/2024 10:20:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14861' , '107' , '1' ) 03/02/2024 10:20:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90225' , '16823' , 'SANTO E UN UOMO - A. BELLANDI' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '0' , '13.00' ) 03/02/2024 10:20:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '16823' AND id_supplier = '107' 03/02/2024 10:20:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16823' , '107' , '1' ) 03/02/2024 10:20:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90225' , '17668' , 'VERBA SCRIPTA - AAVV' , '1' , '-1' , '4' , '17.90' , '17.9' , '0' , '0' , '17.90' ) 03/02/2024 10:20:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '17668' AND id_supplier = '107' 03/02/2024 10:20:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17668' , '107' , '1' ) 03/02/2024 10:20:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90225' , '15911' , 'SAN FRANCESCO SI RACCONTA - F. MARCHESI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 03/02/2024 10:20:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '15911' AND id_supplier = '107' 03/02/2024 10:20:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15911' , '107' , '1' ) 03/02/2024 10:20:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90225' , '18182' , 'DON BOSCO E LA SCUOLA - BORDIGNON/ MAURIZIO' , '1' , '-1' , '4' , '40.00' , '40' , '0' , '0' , '40.00' ) 03/02/2024 10:20:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '18182' AND id_supplier = '107' 03/02/2024 10:20:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18182' , '107' , '1' ) 03/02/2024 10:20:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90225' , '13792' , 'LORENZO MILANI' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '0' , '20.00' ) 03/02/2024 10:20:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '13792' AND id_supplier = '107' 03/02/2024 10:20:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13792' , '107' , '1' ) 03/02/2024 10:20:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90225' , '15516' , 'GIOBBE' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 03/02/2024 10:20:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '15516' AND id_supplier = '107' 03/02/2024 10:20:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15516' , '107' , '1' ) 03/02/2024 10:20:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90225' , '17479' , 'BIBBIA INTRODUZIONE - G. SUMMA' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 03/02/2024 10:20:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '17479' AND id_supplier = '107' 03/02/2024 10:20:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17479' , '107' , '1' ) 03/02/2024 10:20:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90225' , '19496' , 'DIACONI - A. STRAUCH' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 03/02/2024 10:20:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '19496' AND id_supplier = '107' 03/02/2024 10:20:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19496' , '107' , '1' ) 03/02/2024 10:20:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90225' , '19254' , 'PRESBITERI E DIACONI - L. GIRARDI' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '0' , '20.00' ) 03/02/2024 10:20:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '19254' AND id_supplier = '107' 03/02/2024 10:20:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19254' , '107' , '1' ) 03/02/2024 10:20:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90225' , '15358' , 'OMNIA VERBA - J. DALARUN' , '1' , '-1' , '4' , '29.00' , '29' , '0' , '0' , '29.00' ) 03/02/2024 10:20:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '15358' AND id_supplier = '107' 03/02/2024 10:20:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15358' , '107' , '1' ) 03/02/2024 10:20:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90225' , '11815' , 'MARIOLOGIA DI SAN BERNARDO - M. AROSIO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 03/02/2024 10:20:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '11815' AND id_supplier = '107' 03/02/2024 10:20:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11815' , '107' , '1' ) 03/02/2024 10:20:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90225' , '18566' , 'IL DIACONATO PERMANENTE ' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '0' , '8.00' ) 03/02/2024 10:20:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '18566' AND id_supplier = '107' 03/02/2024 10:20:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18566' , '107' , '1' ) 03/02/2024 10:20:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90225' , '16643' , 'GESU, COSCIENZA, LIBERTA - A. DUCAY' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 03/02/2024 10:20:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '16643' AND id_supplier = '107' 03/02/2024 10:20:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16643' , '107' , '1' ) 03/02/2024 10:20:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90225' , '19575' , 'DIMENSIONE REGALE ... - SCORRANO' , '1' , '-1' , '4' , '29.50' , '29.5' , '0' , '0' , '29.50' ) 03/02/2024 10:20:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '19575' AND id_supplier = '107' 03/02/2024 10:20:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19575' , '107' , '1' ) 03/02/2024 10:20:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90225' , '20498' , 'RIFORMA DELLA LITURGIA E RIFORMA DELLA CHIESA - P. SORCI' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '0' , '20.00' ) 03/02/2024 10:20:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '20498' AND id_supplier = '107' 03/02/2024 10:20:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20498' , '107' , '1' ) 03/02/2024 10:20:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90225' , '19083' , 'TU ED IO - C. ROMAGNONI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 03/02/2024 10:20:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '19083' AND id_supplier = '107' 03/02/2024 10:20:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19083' , '107' , '1' ) 03/02/2024 10:20:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90225' , '16644' , 'TU ED IO - C. ROMAGNONI' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '0' , '20.00' ) 03/02/2024 10:20:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '16644' AND id_supplier = '107' 03/02/2024 10:20:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16644' , '107' , '1' ) 03/02/2024 10:20:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90225' , '19528' , 'CATECHISTI OGGI IN ITALIA' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '0' , '20.00' ) 03/02/2024 10:20:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '19528' AND id_supplier = '107' 03/02/2024 10:20:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19528' , '107' , '1' ) 03/02/2024 10:20:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90225' , '20399' , 'NATALE GRANDE GIOIA - M. BORRELLI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 03/02/2024 10:20:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '20399' AND id_supplier = '107' 03/02/2024 10:20:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20399' , '107' , '1' ) 03/02/2024 10:20:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90225' , '20499' , 'SEGRETO SOTTILE - SUSSIDIO 2023' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '0' , '9.00' ) 03/02/2024 10:20:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '20499' AND id_supplier = '107' 03/02/2024 10:20:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20499' , '107' , '1' ) 03/02/2024 10:20:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90225' , '14326' , 'RELIGIOCANDO - GESU BAMBINO' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 03/02/2024 10:20:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '14326' AND id_supplier = '107' 03/02/2024 10:20:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14326' , '107' , '1' ) 03/02/2024 10:20:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90225' , '21461' , 'PAROLA PER OGGI 2024' , '3' , '-3' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '10.50' ) 03/02/2024 10:20:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '21461' AND id_supplier = '107' 03/02/2024 10:20:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21461' , '107' , '1' ) 03/02/2024 10:20:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90225' , '17812' , 'GUARDA: FACCIO NUOVE TUTTE LE COSE - G. BARBIERI' , '1' , '-1' , '4' , '18.50' , '18.5' , '0' , '0' , '18.50' ) 03/02/2024 10:20:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '17812' AND id_supplier = '107' 03/02/2024 10:20:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17812' , '107' , '1' ) 03/02/2024 10:20:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90225' , '16947' , 'GIACOMO' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '0' , '8.00' ) 03/02/2024 10:20:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '16947' AND id_supplier = '107' 03/02/2024 10:20:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16947' , '107' , '1' ) 03/02/2024 10:20:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90225' , '17911' , 'VIA LUCIS - E. DAGOSTINO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 03/02/2024 10:20:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '17911' AND id_supplier = '107' 03/02/2024 10:20:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17911' , '107' , '1' ) 03/02/2024 11:07:29 am >> SELECT document_num FROM ps_document WHERE document_num = '356' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-03') 03/02/2024 11:07:29 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' , '356' , '2024-02-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '495.00' , '405.74' , NOW() , NOW() ) 03/02/2024 11:07:29 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 = '90226' 03/02/2024 11:07:29 am >> DELETE FROM ps_document_detail WHERE id_document = '90226' 03/02/2024 11:07:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90226' , '19706' , 'PALLA 75/1634' , '1' , '-1' , '1' , '89.00' , '72.950819672131' , '22' , '0' , '89.00' ) 03/02/2024 11:07:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90226' , '13159' , 'CASULA MOD. 3 CROCI' , '1' , '-1' , '1' , '240.00' , '196.72131147541' , '22' , '0' , '240.00' ) 03/02/2024 11:07:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90226' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '129.7' , '106.31147540984' , '22' , '0' , '129.70' ) 03/02/2024 11:07:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90226' , '13544' , 'SCATOLINA CORONCINA CONFESSIONE - 2361/J10' , '11' , '-11' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '36.30' ) 03/02/2024 11:15:25 am >> SELECT document_num FROM ps_document WHERE document_num = '357' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-03') 03/02/2024 11:15:25 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' , '357' , '2024-02-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.50' , '48.50' , NOW() , NOW() ) 03/02/2024 11:15:25 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 = '90227' 03/02/2024 11:15:25 am >> DELETE FROM ps_document_detail WHERE id_document = '90227' 03/02/2024 11:15:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90227' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '14' , '-14' , '4' , '1.90' , '1.9' , '0' , '0' , '26.60' ) 03/02/2024 11:15:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90227' , '21917' , 'ASCOLTARE PER SERVIRE' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '5' , '20.90' ) 03/02/2024 11:15:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90227' , '22115' , 'ATTRAVERSO IL DESERTO - MESSAGGIO QUARESIMA 2024' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 03/02/2024 11:36:48 am >> SELECT document_num FROM ps_document WHERE document_num = '358' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-03') 03/02/2024 11:36: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 ( '11' , '358' , '2024-02-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '71.61' , '69.00' , NOW() , NOW() ) 03/02/2024 11:36: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 = '90228' 03/02/2024 11:36:48 am >> DELETE FROM ps_document_detail WHERE id_document = '90228' 03/02/2024 11:36: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 ( '90228' , '21934' , 'TI VOGLIO BENE - PAPA FRANCESCO' , '3' , '-3' , '4' , '16.90' , '16.9' , '0' , '5' , '48.18' ) 03/02/2024 11:36: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 ( '90228' , '21751' , 'MESSALINO QUOTIDIANO - FEB-MAR-APR 2024' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 03/02/2024 11:36: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 ( '90228' , '15096' , 'CORONA MATRIMONIO - ARG ' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 03/02/2024 11:36: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 ( '90228' , '18222' , 'ROSARIO COLORATO - R316' , '10' , '-10' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '7.00' ) 03/02/2024 11:36: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 ( '90228' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '1' , '-1' , '4' , '3.40' , '3.4' , '0' , '5' , '3.23' ) 03/02/2024 11:38:42 am >> SELECT document_num FROM ps_document WHERE document_num = '359' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-03') 03/02/2024 11:38:42 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '359' , '2024-02-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '1.00' , NOW() , NOW() ) 03/02/2024 11:38:42 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90229' 03/02/2024 11:38:42 am >> DELETE FROM ps_document_detail WHERE id_document = '90229' 03/02/2024 11:38:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90229' , '22115' , 'ATTRAVERSO IL DESERTO - MESSAGGIO QUARESIMA 2024' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 03/02/2024 11:40:02 am >> SELECT document_num FROM ps_document WHERE document_num = '290' AND id_document != '90136' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-29') 03/02/2024 11:40:02 am >> UPDATE ps_document SET id_document_type = '11', document_num = '290', document_date = '2024-01-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '14.60', price_tax_excluded = '12.42', date_upd = NOW() WHERE id_document = '90136' 03/02/2024 11:40: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 = '90136' 03/02/2024 11:40:02 am >> DELETE FROM ps_document_detail WHERE id_document = '90136' 03/02/2024 11:40: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 ( '90136' , '20184' , 'ANGELO SU CONCHIGLIA - AR111' , '1' , '-1' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '4.70' ) 03/02/2024 11:40: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 ( '90136' , '21490' , 'CALENDARIO LITURGICO 2024 - 8478' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 03/02/2024 11:40: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 ( '90136' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '1' , '-1' , '1' , '6.2000' , '5.0819672131148' , '22' , '0' , '6.20' ) 03/02/2024 11:40: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 ( '90136' , '18218' , 'DECINA LEGNO CHIARO - FR52' , '1' , '-1' , '1' , '0.6000' , '0.49180327868852' , '22' , '0' , '0.60' ) 03/02/2024 11:40: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 ( '90136' , '18218' , 'DECINA LEGNO CHIARO - FR52' , '1' , '-1' , '1' , '0.6000' , '0.49180327868852' , '22' , '0' , '0.60' ) 03/02/2024 11:40: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 ( '90136' , '22115' , 'ATTRAVERSO IL DESERTO - MESSAGGIO QUARESIMA 2024' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '5' , '0.95' ) 03/02/2024 11:40: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 ( '90136' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '0.55' , '0.55' , '0' , '0' , '0.55' ) 03/02/2024 11:56:41 am >> SELECT document_num FROM ps_document WHERE document_num = '360' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2024-02-03') 03/02/2024 11:56:41 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' , '360' , '2024-02-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.90' , '20.90' , NOW() , NOW() ) 03/02/2024 11:56:41 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 = '90230' 03/02/2024 11:56:41 am >> DELETE FROM ps_document_detail WHERE id_document = '90230' 03/02/2024 11:56:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90230' , '9394' , 'SAN BIAGIO - G.PESENTI' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 03/02/2024 11:56:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90230' , '21883' , 'MEMORIA CHE EDUCA AL BENE - SEGRE/DELPINI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 03/02/2024 11:56:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90230' , '20959' , 'VERITA E NORME DI VITA CRISTIANA' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 03/02/2024 11:56:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90230' , '14649' , 'COMPENDIO AL CATECHISMO DI PIO X' , '1' , '-1' , '4' , '1.60' , '1.6' , '0' , '' , '1.60' ) 03/02/2024 11:56:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90230' , '14649' , 'COMPENDIO AL CATECHISMO DI PIO X' , '1' , '-1' , '4' , '1.60' , '1.6' , '0' , '' , '1.60' ) 03/02/2024 11:56:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90230' , '22115' , 'ATTRAVERSO IL DESERTO - MESSAGGIO QUARESIMA 2024' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 03/02/2024 12:04:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '361' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-03') 03/02/2024 12:04:03 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '361' , '2024-02-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.90' , '29.43' , NOW() , NOW() ) 03/02/2024 12:04:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90231' 03/02/2024 12:04:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '90231' 03/02/2024 12:04:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90231' , '9183' , 'ROSARIO S. MICHELE - LEGNO RL 753 ' , '1' , '-1' , '1' , '4.80' , '3.9344262295082' , '22' , '0' , '4.80' ) 03/02/2024 12:04:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90231' , '9691' , 'SCAPOLARE DEL CARMELO - PICCOLO - 1215/ITA' , '1' , '-1' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '1.10' ) 03/02/2024 12:04:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90231' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 03/02/2024 12:09:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '362' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-03') 03/02/2024 12:09:12 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' , '362' , '2024-02-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.85' , '2.85' , NOW() , NOW() ) 03/02/2024 12:09:12 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 = '90232' 03/02/2024 12:09:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '90232' 03/02/2024 12:09:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90232' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 03/02/2024 12:45:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '28' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-02-03') 03/02/2024 12:45:28 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '28' , '2024-02-03' , '' , '2214' , '0' , '4671715' , 'P.ZZA S. FRANCESCO 84124 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '71.40' , '71.40' , NOW() , NOW() ) 03/02/2024 12:45:28 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 = '90233' 03/02/2024 12:45:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '90233' 03/02/2024 12:45:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90233' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '30' , '-30' , '4' , '2.80' , '2.8' , '0' , '15' , '71.40' ) 03/02/2024 12:49:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '28' AND id_document != '90233' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-02-03') 03/02/2024 12:49:20 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '28', document_date = '2024-02-03', document_letter = '', id_customer = '2214', id_supplier = '', id_address = '4671715', address1 = 'P.ZZA S. FRANCESCO 84124 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '71.40', price_tax_excluded = '71.40', date_upd = NOW() WHERE id_document = '90233' 03/02/2024 12:49:20 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 = '90233' 03/02/2024 12:49:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '90233' 03/02/2024 12:49: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 ( '90233' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '30' , '-30' , '4' , '2.8000' , '2.8' , '0' , '15' , '71.40' )