05/02/2024 09:48:03 am >> UPDATE ps_document SET id_document_type = '32', document_num = '2021/01/0002737', document_date = '2021-12-28', document_letter = '01', id_customer = '0', id_supplier = '107', id_address = '4669100', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = '', price_shipping = '6.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 = '76.20', price_tax_excluded = '76.20', date_upd = NOW() WHERE id_document = '49914' 05/02/2024 09:48: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 = '49914' 05/02/2024 09:48:03 am >> DELETE FROM ps_document_detail WHERE id_document = '49914' 05/02/2024 09:48: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 ( '49914' , '19082' , 'IPNOSI DEL SENSIBILE - D. ZANELLA' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '35' , '9.75' ) 05/02/2024 09:48:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '19082' AND id_supplier = '107' 05/02/2024 09:48:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19082' , '107' , '1' ) 05/02/2024 09:48: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 ( '49914' , '707' , 'APOSTOLI DI CRISTO PROTETTORI IN CAMPANIA' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '35' , '3.25' ) 05/02/2024 09:48:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '707' AND id_supplier = '107' 05/02/2024 09:48:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '707' , '107' , '1' ) 05/02/2024 09:48: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 ( '49914' , '19083' , 'TU ED IO - C. ROMAGNONI' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '35' , '7.80' ) 05/02/2024 09:48:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '19083' AND id_supplier = '107' 05/02/2024 09:48:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19083' , '107' , '1' ) 05/02/2024 09:48: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 ( '49914' , '19084' , 'OMELIE E PREDICAZIONE - CAVOLO/SODI' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '35' , '10.40' ) 05/02/2024 09:48:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '19084' AND id_supplier = '107' 05/02/2024 09:48:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19084' , '107' , '1' ) 05/02/2024 09:48: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 ( '49914' , '17673' , 'FUI CHIAMATO DOLINDO' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '35' , '22.75' ) 05/02/2024 09:48:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '17673' AND id_supplier = '107' 05/02/2024 09:48:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17673' , '107' , '1' ) 05/02/2024 09:48: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 ( '49914' , '19085' , 'POPOLO DI DIO NEL DIRITTO CANONICO' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '35' , '9.75' ) 05/02/2024 09:48:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '19085' AND id_supplier = '107' 05/02/2024 09:48:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19085' , '107' , '1' ) 05/02/2024 09:48: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 ( '49914' , '18810' , 'ANTIFONE - E. DELLA CORTE' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '35' , '6.50' ) 05/02/2024 09:48:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '18810' AND id_supplier = '107' 05/02/2024 09:48:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18810' , '107' , '1' ) 05/02/2024 09:48:13 am >> UPDATE ps_document SET id_document_type = '33', document_num = '2021/00/0007556', document_date = '2021-12-15', document_letter = '00', id_customer = '0', id_supplier = '107', id_address = '4669100', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = '', price_shipping = '6.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 = '76.20', price_tax_excluded = '76.20', date_upd = NOW() WHERE id_document = '49178' 05/02/2024 09:48: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 = '49178' 05/02/2024 09:48:13 am >> DELETE FROM ps_document_detail WHERE id_document = '49178' 05/02/2024 09:48: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 ( '49178' , '19082' , 'IPNOSI DEL SENSIBILE - D. ZANELLA' , '1' , '1' , '4' , '15.0000' , '15' , '0' , '35' , '9.75' ) 05/02/2024 09:48:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '19082' AND id_supplier = '107' 05/02/2024 09:48:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19082' , '107' , '1' ) 05/02/2024 09:48: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 ( '49178' , '707' , 'APOSTOLI DI CRISTO PROTETTORI IN CAMPANIA' , '1' , '1' , '4' , '5.0000' , '5' , '0' , '35' , '3.25' ) 05/02/2024 09:48:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '707' AND id_supplier = '107' 05/02/2024 09:48:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '707' , '107' , '1' ) 05/02/2024 09:48: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 ( '49178' , '19083' , 'TU ED IO - C. ROMAGNONI' , '1' , '1' , '4' , '12.0000' , '12' , '0' , '35' , '7.80' ) 05/02/2024 09:48:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '19083' AND id_supplier = '107' 05/02/2024 09:48:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19083' , '107' , '1' ) 05/02/2024 09:48: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 ( '49178' , '19084' , 'OMELIE E PREDICAZIONE - CAVOLO/SODI' , '1' , '1' , '4' , '16.0000' , '16' , '0' , '35' , '10.40' ) 05/02/2024 09:48:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '19084' AND id_supplier = '107' 05/02/2024 09:48:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19084' , '107' , '1' ) 05/02/2024 09:48: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 ( '49178' , '17673' , 'FUI CHIAMATO DOLINDO' , '1' , '1' , '4' , '35.0000' , '35' , '0' , '35' , '22.75' ) 05/02/2024 09:48:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '17673' AND id_supplier = '107' 05/02/2024 09:48:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17673' , '107' , '1' ) 05/02/2024 09:48:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '49178' , '19085' , 'POPOLO DI DIO NEL DIRITTO CANONICO' , '1' , '1' , '4' , '15.0000' , '15' , '0' , '35' , '9.75' ) 05/02/2024 09:48:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '19085' AND id_supplier = '107' 05/02/2024 09:48:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19085' , '107' , '1' ) 05/02/2024 09:48:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '49178' , '18810' , 'ANTIFONE - E. DELLA CORTE' , '1' , '1' , '4' , '10.0000' , '10' , '0' , '35' , '6.50' ) 05/02/2024 09:48:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '18810' AND id_supplier = '107' 05/02/2024 09:48:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18810' , '107' , '1' ) 05/02/2024 09:49:40 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') 05/02/2024 09:49:40 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' 05/02/2024 09:49: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 = '79914' 05/02/2024 09:49:40 am >> DELETE FROM ps_document_detail WHERE id_document = '79914' 05/02/2024 09:49: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 ( '79914' , '18698' , 'MESSALE ROMANO III EDIZIONE - G. RUPPI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 05/02/2024 09:49:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '18698' AND id_supplier = '107' 05/02/2024 09:49:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18698' , '107' , '1' ) 05/02/2024 09:49: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 ( '79914' , '17686' , 'MYSTERIUM ECCLESIAE NELLEUCOLOGIA DEL MESSALE ROMANO - V. PIERRI' , '2' , '-2' , '4' , '30.0000' , '30' , '0' , '0' , '60.00' ) 05/02/2024 09:49:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '17686' AND id_supplier = '107' 05/02/2024 09:49:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17686' , '107' , '1' ) 05/02/2024 09:49: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 ( '79914' , '707' , 'APOSTOLI DI CRISTO PROTETTORI IN CAMPANIA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 05/02/2024 09:49:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '707' AND id_supplier = '107' 05/02/2024 09:49:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '707' , '107' , '1' ) 05/02/2024 09:49: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 ( '79914' , '18570' , 'GIUSEPPE E I SUOI FRATELLI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 05/02/2024 09:49:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '18570' AND id_supplier = '107' 05/02/2024 09:49:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18570' , '107' , '1' ) 05/02/2024 09:49: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 ( '79914' , '16824' , 'ARCO DI LUCE - G. DE PONTI CONTI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 05/02/2024 09:49:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '16824' AND id_supplier = '107' 05/02/2024 09:49:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16824' , '107' , '1' ) 05/02/2024 09:49: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 ( '79914' , '19256' , 'SALUS ANIMARUM E COMMUNIO EUCHARISTICA - M. GIAVAZZI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 05/02/2024 09:49:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '19256' AND id_supplier = '107' 05/02/2024 09:49:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19256' , '107' , '1' ) 05/02/2024 09:49: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 ( '79914' , '19579' , 'FAMIGLIA PORTA DELLA FEDE' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 05/02/2024 09:49:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '19579' AND id_supplier = '107' 05/02/2024 09:49:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19579' , '107' , '1' ) 05/02/2024 09:49: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 ( '79914' , '18694' , 'BELLA LA MIA FAMIGLIA - SUSSIDIO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 05/02/2024 09:49:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '18694' AND id_supplier = '107' 05/02/2024 09:49:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18694' , '107' , '1' ) 05/02/2024 09:49: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 ( '79914' , '18695' , 'BELLA LA MIA FAMIGLIA - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 05/02/2024 09:49:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '18695' AND id_supplier = '107' 05/02/2024 09:49:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18695' , '107' , '1' ) 05/02/2024 09:52:28 am >> UPDATE ps_document SET id_document_type = '32', document_num = '2020/1/0000453', document_date = '2020-02-29', document_letter = '1', id_customer = '0', id_supplier = '107', id_address = '4669100', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', 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 = '365.15', price_tax_excluded = '362.81', date_upd = NOW() WHERE id_document = '23734' 05/02/2024 09:52:28 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 = '23734' 05/02/2024 09:52:28 am >> DELETE FROM ps_document_detail WHERE id_document = '23734' 05/02/2024 09:52:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '23734' , '16830' , 'AMORE SALVERA IL MONDO - PUGLISI - DVD' , '1' , '0' , '1' , '16.3900' , '13.434426229508' , '22' , '35' , '13.00' ) 05/02/2024 09:52:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '16830' AND id_supplier = '107' 05/02/2024 09:52:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16830' , '107' , '1' ) 05/02/2024 09:52:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '23734' , '16828' , 'INIZIAZIONE CRISTIANA - P.A. MURONI' , '1' , '0' , '4' , '13.8000' , '13.8' , '0' , '35' , '8.97' ) 05/02/2024 09:52:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '16828' AND id_supplier = '107' 05/02/2024 09:52:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16828' , '107' , '1' ) 05/02/2024 09:52:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '23734' , '16827' , 'PROFETI - G. SUMMA' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '35' , '7.80' ) 05/02/2024 09:52:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '16827' AND id_supplier = '107' 05/02/2024 09:52:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16827' , '107' , '1' ) 05/02/2024 09:52:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '23734' , '16829' , 'SUSSIDIO PER LANIMAZIONE PASTORALE - VOCAZIONI' , '5' , '0' , '4' , '3.5000' , '3.5' , '0' , '35' , '11.38' ) 05/02/2024 09:52:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '16829' AND id_supplier = '107' 05/02/2024 09:52:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16829' , '107' , '1' ) 05/02/2024 09:52: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 ( '23734' , '16825' , 'SCOPERTA CHE INCANTA - A. BUSETTO' , '1' , '0' , '4' , '13.0000' , '13' , '0' , '35' , '8.45' ) 05/02/2024 09:52:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '16825' AND id_supplier = '107' 05/02/2024 09:52:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16825' , '107' , '1' ) 05/02/2024 09:52: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 ( '23734' , '16823' , 'SANTO E UN UOMO - A. BELLANDI' , '10' , '0' , '4' , '13.0000' , '13' , '0' , '35' , '84.50' ) 05/02/2024 09:52:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '16823' AND id_supplier = '107' 05/02/2024 09:52:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16823' , '107' , '1' ) 05/02/2024 09:52: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 ( '23734' , '16641' , 'PREGHIERA - P. COLLINS' , '1' , '0' , '4' , '22.0000' , '22' , '0' , '35' , '14.30' ) 05/02/2024 09:52:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '16641' AND id_supplier = '107' 05/02/2024 09:52:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16641' , '107' , '1' ) 05/02/2024 09:52: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 ( '23734' , '16826' , 'DIRITTO LITURGICO - M. SCANDELLI' , '1' , '0' , '4' , '25.0000' , '25' , '0' , '35' , '16.25' ) 05/02/2024 09:52:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '16826' AND id_supplier = '107' 05/02/2024 09:52:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16826' , '107' , '1' ) 05/02/2024 09:52: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 ( '23734' , '16824' , 'ARCO DI LUCE - G. DE PONTI CONTI' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '35' , '11.70' ) 05/02/2024 09:52:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '16824' AND id_supplier = '107' 05/02/2024 09:52:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16824' , '107' , '1' ) 05/02/2024 09:52: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 ( '23734' , '16831' , 'CELEBRAZIONE DI CRISTO - CHIFARI/RUPPI' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '35' , '7.80' ) 05/02/2024 09:52:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '16831' AND id_supplier = '107' 05/02/2024 09:52:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16831' , '107' , '1' ) 05/02/2024 09:52: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 ( '23734' , '10133' , 'SPESE DI TRASPORTO' , '1' , '0' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 05/02/2024 09:52:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '10133' AND id_supplier = '107' 05/02/2024 09:52:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10133' , '107' , '1' ) 05/02/2024 09:52: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 ( '23734' , '16823' , 'SANTO E UN UOMO - A. BELLANDI' , '20' , '0' , '4' , '13.0000' , '13' , '0' , '35' , '169.00' ) 05/02/2024 09:52:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '16823' AND id_supplier = '107' 05/02/2024 09:52:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16823' , '107' , '1' ) 05/02/2024 09:52: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 ( '23734' , '10133' , 'SPESE DI TRASPORTO' , '1' , '0' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 05/02/2024 09:52:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '10133' AND id_supplier = '107' 05/02/2024 09:52:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10133' , '107' , '1' ) 05/02/2024 09:52:41 am >> UPDATE ps_document SET id_document_type = '33', document_num = '2020/00/0001393', document_date = '2020-02-28', document_letter = '00', id_customer = '0', id_supplier = '107', id_address = '4669100', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', 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 = '193.01', price_tax_excluded = '190.15', date_upd = NOW() WHERE id_document = '23699' 05/02/2024 09:52: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 = '23699' 05/02/2024 09:52:41 am >> DELETE FROM ps_document_detail WHERE id_document = '23699' 05/02/2024 09:52: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 ( '23699' , '16830' , 'AMORE SALVERA IL MONDO - PUGLISI - DVD' , '1' , '1' , '1' , '20.0000' , '16.393442622951' , '22' , '35' , '15.86' ) 05/02/2024 09:52:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '16830' AND id_supplier = '107' 05/02/2024 09:52:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16830' , '107' , '1' ) 05/02/2024 09:52: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 ( '23699' , '16828' , 'INIZIAZIONE CRISTIANA - P.A. MURONI' , '1' , '1' , '4' , '13.8000' , '13.8' , '0' , '35' , '8.97' ) 05/02/2024 09:52:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '16828' AND id_supplier = '107' 05/02/2024 09:52:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16828' , '107' , '1' ) 05/02/2024 09:52: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 ( '23699' , '16827' , 'PROFETI - G. SUMMA' , '1' , '1' , '4' , '12.0000' , '12' , '0' , '35' , '7.80' ) 05/02/2024 09:52:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '16827' AND id_supplier = '107' 05/02/2024 09:52:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16827' , '107' , '1' ) 05/02/2024 09:52: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 ( '23699' , '16829' , 'SUSSIDIO PER LANIMAZIONE PASTORALE - VOCAZIONI' , '5' , '5' , '4' , '3.5000' , '3.5' , '0' , '35' , '11.38' ) 05/02/2024 09:52:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '16829' AND id_supplier = '107' 05/02/2024 09:52:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16829' , '107' , '1' ) 05/02/2024 09:52: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 ( '23699' , '16825' , 'SCOPERTA CHE INCANTA - A. BUSETTO' , '1' , '1' , '4' , '13.0000' , '13' , '0' , '35' , '8.45' ) 05/02/2024 09:52:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '16825' AND id_supplier = '107' 05/02/2024 09:52:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16825' , '107' , '1' ) 05/02/2024 09:52: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 ( '23699' , '16823' , 'SANTO E UN UOMO - A. BELLANDI' , '10' , '10' , '4' , '13.0000' , '13' , '0' , '35' , '84.50' ) 05/02/2024 09:52:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '16823' AND id_supplier = '107' 05/02/2024 09:52:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16823' , '107' , '1' ) 05/02/2024 09:52: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 ( '23699' , '16641' , 'PREGHIERA - P. COLLINS' , '1' , '1' , '4' , '22.0000' , '22' , '0' , '35' , '14.30' ) 05/02/2024 09:52:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '16641' AND id_supplier = '107' 05/02/2024 09:52:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16641' , '107' , '1' ) 05/02/2024 09:52: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 ( '23699' , '16826' , 'DIRITTO LITURGICO - M. SCANDELLI' , '1' , '1' , '4' , '25.0000' , '25' , '0' , '35' , '16.25' ) 05/02/2024 09:52:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '16826' AND id_supplier = '107' 05/02/2024 09:52:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16826' , '107' , '1' ) 05/02/2024 09:52: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 ( '23699' , '16824' , 'ARCO DI LUCE - G. DE PONTI CONTI' , '1' , '1' , '4' , '18.0000' , '18' , '0' , '35' , '11.70' ) 05/02/2024 09:52:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '16824' AND id_supplier = '107' 05/02/2024 09:52:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16824' , '107' , '1' ) 05/02/2024 09:52: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 ( '23699' , '16831' , 'CELEBRAZIONE DI CRISTO - CHIFARI/RUPPI' , '1' , '1' , '4' , '12.0000' , '12' , '0' , '35' , '7.80' ) 05/02/2024 09:52:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '16831' AND id_supplier = '107' 05/02/2024 09:52:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16831' , '107' , '1' ) 05/02/2024 09:52: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 ( '23699' , '10133' , 'SPESE DI TRASPORTO' , '1' , '1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 05/02/2024 09:52:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '10133' AND id_supplier = '107' 05/02/2024 09:52:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10133' , '107' , '1' ) 05/02/2024 09:52:52 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') 05/02/2024 09:52:52 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' 05/02/2024 09:52:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '79914' 05/02/2024 09:52:53 am >> DELETE FROM ps_document_detail WHERE id_document = '79914' 05/02/2024 09:52: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 ( '79914' , '18698' , 'MESSALE ROMANO III EDIZIONE - G. RUPPI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 05/02/2024 09:52:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '18698' AND id_supplier = '107' 05/02/2024 09:52:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18698' , '107' , '1' ) 05/02/2024 09:52: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 ( '79914' , '17686' , 'MYSTERIUM ECCLESIAE NELLEUCOLOGIA DEL MESSALE ROMANO - V. PIERRI' , '2' , '-2' , '4' , '30.0000' , '30' , '0' , '0' , '60.00' ) 05/02/2024 09:52:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '17686' AND id_supplier = '107' 05/02/2024 09:52:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17686' , '107' , '1' ) 05/02/2024 09:52: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 ( '79914' , '707' , 'APOSTOLI DI CRISTO PROTETTORI IN CAMPANIA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 05/02/2024 09:52:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '707' AND id_supplier = '107' 05/02/2024 09:52:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '707' , '107' , '1' ) 05/02/2024 09:52: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 ( '79914' , '18570' , 'GIUSEPPE E I SUOI FRATELLI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 05/02/2024 09:52:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '18570' AND id_supplier = '107' 05/02/2024 09:52:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18570' , '107' , '1' ) 05/02/2024 09:52: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 ( '79914' , '16824' , 'ARCO DI LUCE - G. DE PONTI CONTI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 05/02/2024 09:52:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '16824' AND id_supplier = '107' 05/02/2024 09:52:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16824' , '107' , '1' ) 05/02/2024 09:52: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 ( '79914' , '19256' , 'SALUS ANIMARUM E COMMUNIO EUCHARISTICA - M. GIAVAZZI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 05/02/2024 09:52:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '19256' AND id_supplier = '107' 05/02/2024 09:52:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19256' , '107' , '1' ) 05/02/2024 09:52: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 ( '79914' , '19579' , 'FAMIGLIA PORTA DELLA FEDE' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 05/02/2024 09:52:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '19579' AND id_supplier = '107' 05/02/2024 09:52:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19579' , '107' , '1' ) 05/02/2024 09:52: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 ( '79914' , '18694' , 'BELLA LA MIA FAMIGLIA - SUSSIDIO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 05/02/2024 09:52:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '18694' AND id_supplier = '107' 05/02/2024 09:52:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18694' , '107' , '1' ) 05/02/2024 09:52: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 ( '79914' , '18695' , 'BELLA LA MIA FAMIGLIA - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 05/02/2024 09:52:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '18695' AND id_supplier = '107' 05/02/2024 09:52:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18695' , '107' , '1' ) 05/02/2024 09:54:48 am >> SELECT document_num FROM ps_document WHERE document_num = '4' AND id_document != '90225' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2024-02-03') 05/02/2024 09:54:48 am >> UPDATE ps_document SET id_document_type = '24', document_num = '4', document_date = '2024-02-03', document_letter = '', id_customer = '0', id_supplier = '107', id_address = '4669100', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'RESA', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '9', price_tax_included = '464.90', price_tax_excluded = '463.01', date_upd = NOW() WHERE id_document = '90225' 05/02/2024 09:54: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 = '90225' 05/02/2024 09:54:48 am >> DELETE FROM ps_document_detail WHERE id_document = '90225' 05/02/2024 09:54: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 ( '90225' , '17916' , 'VINCOLO DELLA FRATERNITA - S. FARI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 05/02/2024 09:54:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '17916' AND id_supplier = '107' 05/02/2024 09:54:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17916' , '107' , '1' ) 05/02/2024 09:54: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 ( '90225' , '20046' , 'PREGHIERE NEI VANGELI - G. DE VIRGILIO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 05/02/2024 09:54:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '20046' AND id_supplier = '107' 05/02/2024 09:54:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20046' , '107' , '1' ) 05/02/2024 09:54: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 ( '90225' , '14861' , 'BELLEZZA TUA VOGLIO CANTARE - ANNO C - E. RONCHI' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 05/02/2024 09:54:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '14861' AND id_supplier = '107' 05/02/2024 09:54:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14861' , '107' , '1' ) 05/02/2024 09:54: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 ( '90225' , '16823' , 'SANTO E UN UOMO - A. BELLANDI' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 05/02/2024 09:54:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '16823' AND id_supplier = '107' 05/02/2024 09:54:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16823' , '107' , '1' ) 05/02/2024 09:54: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 ( '90225' , '17668' , 'VERBA SCRIPTA - AAVV' , '1' , '-1' , '4' , '17.9000' , '17.9' , '0' , '0' , '17.90' ) 05/02/2024 09:54:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '17668' AND id_supplier = '107' 05/02/2024 09:54:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17668' , '107' , '1' ) 05/02/2024 09:54: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 ( '90225' , '15911' , 'SAN FRANCESCO SI RACCONTA - F. MARCHESI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 05/02/2024 09:54:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '15911' AND id_supplier = '107' 05/02/2024 09:54:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15911' , '107' , '1' ) 05/02/2024 09:54: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 ( '90225' , '18182' , 'DON BOSCO E LA SCUOLA - BORDIGNON/ MAURIZIO' , '1' , '-1' , '4' , '40.0000' , '40' , '0' , '0' , '40.00' ) 05/02/2024 09:54:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '18182' AND id_supplier = '107' 05/02/2024 09:54:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18182' , '107' , '1' ) 05/02/2024 09:54: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 ( '90225' , '13792' , 'LORENZO MILANI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 05/02/2024 09:54:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '13792' AND id_supplier = '107' 05/02/2024 09:54:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13792' , '107' , '1' ) 05/02/2024 09:54: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 ( '90225' , '15516' , 'GIOBBE' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 05/02/2024 09:54:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '15516' AND id_supplier = '107' 05/02/2024 09:54:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15516' , '107' , '1' ) 05/02/2024 09:54: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 ( '90225' , '17479' , 'BIBBIA INTRODUZIONE - G. SUMMA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 05/02/2024 09:54:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '17479' AND id_supplier = '107' 05/02/2024 09:54:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17479' , '107' , '1' ) 05/02/2024 09:54: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 ( '90225' , '19496' , 'DIACONI - A. STRAUCH' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 05/02/2024 09:54:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '19496' AND id_supplier = '107' 05/02/2024 09:54:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19496' , '107' , '1' ) 05/02/2024 09:54: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 ( '90225' , '19254' , 'PRESBITERI E DIACONI - L. GIRARDI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 05/02/2024 09:54:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '19254' AND id_supplier = '107' 05/02/2024 09:54:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19254' , '107' , '1' ) 05/02/2024 09:54: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 ( '90225' , '15358' , 'OMNIA VERBA - J. DALARUN' , '1' , '-1' , '4' , '29.0000' , '29' , '0' , '0' , '29.00' ) 05/02/2024 09:54:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '15358' AND id_supplier = '107' 05/02/2024 09:54:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15358' , '107' , '1' ) 05/02/2024 09:54: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 ( '90225' , '11815' , 'MARIOLOGIA DI SAN BERNARDO - M. AROSIO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 05/02/2024 09:54:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '11815' AND id_supplier = '107' 05/02/2024 09:54:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11815' , '107' , '1' ) 05/02/2024 09:54: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 ( '90225' , '18566' , 'IL DIACONATO PERMANENTE ' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 05/02/2024 09:54:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '18566' AND id_supplier = '107' 05/02/2024 09:54:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18566' , '107' , '1' ) 05/02/2024 09:54: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 ( '90225' , '16643' , 'GESU, COSCIENZA, LIBERTA - A. DUCAY' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 05/02/2024 09:54:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '16643' AND id_supplier = '107' 05/02/2024 09:54:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16643' , '107' , '1' ) 05/02/2024 09:54: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 ( '90225' , '19575' , 'DIMENSIONE REGALE ... - SCORRANO' , '1' , '-1' , '4' , '29.5000' , '29.5' , '0' , '0' , '29.50' ) 05/02/2024 09:54:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '19575' AND id_supplier = '107' 05/02/2024 09:54:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19575' , '107' , '1' ) 05/02/2024 09:54:50 am >> INSERT INTO ps_document_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.0000' , '20' , '0' , '0' , '20.00' ) 05/02/2024 09:54:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '20498' AND id_supplier = '107' 05/02/2024 09:54:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20498' , '107' , '1' ) 05/02/2024 09:54:50 am >> INSERT INTO ps_document_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.0000' , '12' , '0' , '0' , '12.00' ) 05/02/2024 09:54:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '19083' AND id_supplier = '107' 05/02/2024 09:54:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19083' , '107' , '1' ) 05/02/2024 09:54:50 am >> INSERT INTO ps_document_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.0000' , '10' , '0' , '0' , '20.00' ) 05/02/2024 09:54:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '16644' AND id_supplier = '107' 05/02/2024 09:54:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16644' , '107' , '1' ) 05/02/2024 09:54:50 am >> INSERT INTO ps_document_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.0000' , '20' , '0' , '0' , '20.00' ) 05/02/2024 09:54:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '19528' AND id_supplier = '107' 05/02/2024 09:54:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19528' , '107' , '1' ) 05/02/2024 09:54:50 am >> INSERT INTO ps_document_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.0000' , '18' , '0' , '0' , '18.00' ) 05/02/2024 09:54:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '20399' AND id_supplier = '107' 05/02/2024 09:54:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20399' , '107' , '1' ) 05/02/2024 09:54:50 am >> INSERT INTO ps_document_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.0000' , '9' , '0' , '0' , '9.00' ) 05/02/2024 09:54:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '20499' AND id_supplier = '107' 05/02/2024 09:54:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20499' , '107' , '1' ) 05/02/2024 09:54:50 am >> INSERT INTO ps_document_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.5000' , '2.5' , '0' , '0' , '2.50' ) 05/02/2024 09:54:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '14326' AND id_supplier = '107' 05/02/2024 09:54:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14326' , '107' , '1' ) 05/02/2024 09:54:50 am >> INSERT INTO ps_document_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.5000' , '2.8688524590164' , '22' , '0' , '10.50' ) 05/02/2024 09:54:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '21461' AND id_supplier = '107' 05/02/2024 09:54:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21461' , '107' , '1' ) 05/02/2024 09:54:50 am >> INSERT INTO ps_document_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.5000' , '18.5' , '0' , '0' , '18.50' ) 05/02/2024 09:54:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '17812' AND id_supplier = '107' 05/02/2024 09:54:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17812' , '107' , '1' ) 05/02/2024 09:54:50 am >> INSERT INTO ps_document_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.0000' , '8' , '0' , '0' , '8.00' ) 05/02/2024 09:54:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '16947' AND id_supplier = '107' 05/02/2024 09:54:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16947' , '107' , '1' ) 05/02/2024 09:54:50 am >> INSERT INTO ps_document_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.0000' , '15' , '0' , '0' , '15.00' ) 05/02/2024 09:54:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '17911' AND id_supplier = '107' 05/02/2024 09:54:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17911' , '107' , '1' ) 05/02/2024 10:47:57 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1553' 05/02/2024 10:47:57 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '1553' , '10' , '211' , 'PARROCCHIA SASEGADA' , 'PIRAS ' , 'DON LORENZO' , 'VIA NENNI 1' , '' , '07040' , 'PUTIFIGARI' , 'piras maria caterina via asproni 25 alghero 07040 ss' , '' , '3478552790' , '' , '' , NOW() , NOW() ) 05/02/2024 10:47:57 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1553' 05/02/2024 10:48:50 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1553' 05/02/2024 10:48:50 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '1553' , '10' , '211' , 'PARROCCHIA SA SEGADA' , 'PIRAS ' , 'DON LORENZO' , 'VIA NENNI 1' , '' , '07040' , 'PUTIFIGARI' , 'piras maria caterina via asproni 25 alghero 07040 ss' , '' , '3478552790' , '' , '' , NOW() , NOW() ) 05/02/2024 10:48:50 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1553' 05/02/2024 10:58:14 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1553' 05/02/2024 10:58:14 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '1553' , '10' , '211' , 'PARROCCHIA NOSTRA SIGNORA DI LORETO SA SEGANA' , 'PIRAS ' , 'DON LORENZO' , 'VIA LORETELLA' , '' , '07040' , 'ALGHERO' , 'piras maria caterina via asproni 25 alghero 07040 ss' , '' , '3478552790' , '' , '' , NOW() , NOW() ) 05/02/2024 10:58:14 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1553' 05/02/2024 11:00:02 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1553' 05/02/2024 11:00:02 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '1553' , '10' , '211' , 'PARROCCHIA NOSTRA SIGNORA DI LORETO SA SEGANA' , 'PIRAS ' , 'DON LORENZO' , 'VIA LORETELLA' , '' , '07041' , 'ALGHERO' , 'piras maria caterina via asproni 25 alghero 07040 ss' , '' , '3478552790' , '' , '' , NOW() , NOW() ) 05/02/2024 11:00:02 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1553' 05/02/2024 11:00:20 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1553' 05/02/2024 11:00:20 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '1553' , '10' , '211' , 'PARROCCHIA NOSTRA SIGNORA DI LORETO SA SEGANA' , 'PIRAS ' , 'DON LORENZO' , 'VIA LORETELLA' , '' , '07041' , 'ALGHERO' , 'piras maria caterina via asproni 25 alghero 07041 ss' , '' , '3478552790' , '' , '' , NOW() , NOW() ) 05/02/2024 11:00:20 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1553' 05/02/2024 11:01:58 am >> SELECT document_num FROM ps_document WHERE document_num = '29' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-02-05') 05/02/2024 11:01:58 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' , '29' , '2024-02-05' , '' , '1553' , '0' , '4679263' , 'VIA NENNI 1 07040 PUTIFIGARI' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '114.85' , '114.85' , NOW() , NOW() ) 05/02/2024 11:01:58 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 = '90234' 05/02/2024 11:01:58 am >> DELETE FROM ps_document_detail WHERE id_document = '90234' 05/02/2024 11:01:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90234' , '4154' , 'FESTA DEL PERDONO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 05/02/2024 11:01:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90234' , '8408' , 'PRENDETE E MANGIATE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 05/02/2024 11:01:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90234' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 05/02/2024 11:01:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90234' , '11191' , 'VENITE CON ME 1 PARTE' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '5' , '2.66' ) 05/02/2024 11:01:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90234' , '11192' , 'VENITE CON ME 2 PARTE' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '5' , '2.66' ) 05/02/2024 11:01:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90234' , '1041' , 'BENEDIZIONI' , '200' , '-200' , '4' , '0.18' , '0.18' , '0' , '0' , '36.00' ) 05/02/2024 11:01:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90234' , '' , 'BUSTE ULIVO' , '1' , '-1' , '4' , '9.5' , '9.5' , '0' , '0' , '9.50' ) 05/02/2024 11:01:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90234' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '4' , '25' , '25' , '0' , '0' , '50.00' ) 05/02/2024 11:02:21 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1553' 05/02/2024 11:02:21 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '1553' , '10' , '211' , 'PARROCCHIA NOSTRA SIGNORA DI LORETO SA SEGANA' , 'PIRAS ' , 'DON LORENZO' , 'VIA LORETELLA' , '' , '07041' , 'ALGHERO' , 'piras maria caterina via asproni 25 alghero 07041 ss' , '' , '3478552790' , '' , '' , NOW() , NOW() ) 05/02/2024 11:02:21 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1553' 05/02/2024 11:03:13 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1553' 05/02/2024 11:03:13 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '1553' , '10' , '211' , 'PARROCCHIA NOSTRA SIGNORA DI LORETO SA SEGANA' , 'PIRAS ' , 'DON LORENZO' , 'VIA LORETELLA' , '' , '07041' , 'ALGHERO' , 'piras maria caterina via asproni 25 alghero 07041 ss' , '' , '3478552790' , '' , '' , NOW() , NOW() ) 05/02/2024 11:03:13 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1553' 05/02/2024 11:03:19 am >> SELECT document_num FROM ps_document WHERE document_num = '29' AND id_document != '90234' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-02-05') 05/02/2024 11:03:19 am >> UPDATE ps_document SET id_document_type = '21', document_num = '29', document_date = '2024-02-05', document_letter = '', id_customer = '1553', id_supplier = '0', id_address = '4679268', address1 = 'VIA NENNI 1 07040 PUTIFIGARI', address2 = '', note = '', price_shipping = '5.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '114.85', price_tax_excluded = '114.85', date_upd = NOW() WHERE id_document = '90234' 05/02/2024 11:03: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 = '90234' 05/02/2024 11:03:19 am >> DELETE FROM ps_document_detail WHERE id_document = '90234' 05/02/2024 11:03: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 ( '90234' , '4154' , 'FESTA DEL PERDONO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 05/02/2024 11:03: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 ( '90234' , '8408' , 'PRENDETE E MANGIATE' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 05/02/2024 11:03: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 ( '90234' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 05/02/2024 11:03: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 ( '90234' , '11191' , 'VENITE CON ME 1 PARTE' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 05/02/2024 11:03: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 ( '90234' , '11192' , 'VENITE CON ME 2 PARTE' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 05/02/2024 11:03: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 ( '90234' , '1041' , 'BENEDIZIONI' , '200' , '-200' , '4' , '0.1800' , '0.18' , '0' , '0' , '36.00' ) 05/02/2024 11:03: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 ( '90234' , '0' , 'BUSTE ULIVO' , '1' , '-1' , '4' , '9.5000' , '9.5' , '0' , '0' , '9.50' ) 05/02/2024 11:03: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 ( '90234' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '4' , '25.0000' , '25' , '0' , '0' , '50.00' ) 05/02/2024 11:14:12 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1553' 05/02/2024 11:14:12 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '1553' , '10' , '211' , 'PARROCCHIA NOSTRA SIGNORA DI LORETO SA SEGANA' , 'PIRAS ' , 'DON LORENZO' , 'VIA LORETELLA' , '' , '07041' , 'ALGHERO' , 'piras maria caterina via asproni 25 alghero 07041 ss' , '' , '3478552790' , '' , '' , NOW() , NOW() ) 05/02/2024 11:14:12 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1553' 05/02/2024 11:16:38 am >> SELECT document_num FROM ps_document WHERE document_num = '363' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-05') 05/02/2024 11:16: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' , '363' , '2024-02-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.65' , '25.65' , NOW() , NOW() ) 05/02/2024 11:16: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 = '90235' 05/02/2024 11:16:38 am >> DELETE FROM ps_document_detail WHERE id_document = '90235' 05/02/2024 11:16: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 ( '90235' , '18312' , 'ANCORA NON AVETE FEDE? ANNO B - E. DELLA CORTE' , '1' , '-1' , '4' , '27.00' , '27' , '0' , '5' , '25.65' ) 05/02/2024 11:38:46 am >> SELECT document_num FROM ps_document WHERE document_num = '364' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-05') 05/02/2024 11:38:46 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '364' , '2024-02-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 05/02/2024 11:38:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90236' 05/02/2024 11:38:46 am >> DELETE FROM ps_document_detail WHERE id_document = '90236' 05/02/2024 11:38: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 ( '90236' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 05/02/2024 12:13:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '365' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-05') 05/02/2024 12:13:09 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' , '365' , '2024-02-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '600.00' , '491.80' , NOW() , NOW() ) 05/02/2024 12:13:09 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 = '90237' 05/02/2024 12:13:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '90237' 05/02/2024 12:13:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90237' , '18349' , 'PORTACALICE - 18X28 - 720' , '1' , '-1' , '1' , '39.00' , '31.967213114754' , '22' , '0' , '39.00' ) 05/02/2024 12:13:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90237' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '1' , '-1' , '1' , '41' , '33.606557377049' , '22' , '0' , '41.00' ) 05/02/2024 12:13:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90237' , '19205' , 'calice art. 1930' , '1' , '-1' , '1' , '520' , '426.22950819672' , '22' , '0' , '520.00' ) 05/02/2024 12:17:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '19/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-02-05') 05/02/2024 12:17:18 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '19/A' , '2024-02-05' , 'A' , '371' , '0' , '4679091' , 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '190.00' , '190.00' , NOW() , NOW() ) 05/02/2024 12:17: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 = '90238' 05/02/2024 12:17:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '90238' 05/02/2024 12:17: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 ( '90238' , '' , 'croce' , '1' , '-1' , '0' , '190' , '190' , '' , '0' , '190.00' ) 05/02/2024 02:26:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '7290000098791' AND id_product != '16792' AND ean13 != '' 05/02/2024 02:26:19 pm >> UPDATE ps_product SET id_supplier = '6', reference = '', ean13 = '7290000098791', date_upd = NOW() WHERE id_product = '16792' 05/02/2024 02:26:19 pm >> UPDATE ps_product_lang SET name = 'SOPRACULLA', description = '' WHERE id_product = '16792' 05/02/2024 02:26:19 pm >> UPDATE ps_product SET wholesale_price = '6.50', on_sale = '0', price = '14.754098360655737' WHERE id_product = '16792' 05/02/2024 02:26:19 pm >> UPDATE ps_product_shop SET wholesale_price = '6.50', price = '14.754098360655737', id_tax_rules_group = '1', id_category_default = '120', 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 = '16792' 05/02/2024 02:26:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '16792' 05/02/2024 02:27:10 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 ( '31' , 'FT 1/446' , '2024-02-05' , '446' , '0' , '6' , '2601' , 'ZONO ASI SUD - CENTRO ORAFO \\\"IL TARÍ\\\" 81025 MARCIANISE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '28.06' , '23.00' , NOW() , NOW() ) 05/02/2024 02:27:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90239' 05/02/2024 02:27:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '90239' 05/02/2024 02:27:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90239' , '18172' , 'CONFEZIONE SCATOLA PORTA CIUCCIO' , '1' , '1' , '1' , '9' , '7.3770491803279' , '22' , '0' , '10.9800' ) 05/02/2024 02:27:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18172' AND id_supplier = '6' 05/02/2024 02:27:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18172' , '6' , '1' ) 05/02/2024 02:27:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90239' , '16792' , 'SOPRACULLA' , '1' , '1' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '9.1500' ) 05/02/2024 02:27:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16792' AND id_supplier = '6' 05/02/2024 02:27:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16792' , '6' , '1' ) 05/02/2024 02:27:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90239' , '17287' , 'CAPOCULLA 7X9' , '1' , '1' , '1' , '6.5' , '5.327868852459' , '22' , '0' , '7.9300' ) 05/02/2024 02:27:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17287' AND id_supplier = '6' 05/02/2024 02:27:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17287' , '6' , '1' ) 05/02/2024 02:50:45 pm >> DELETE FROM ps_document WHERE id_document = '87331' 05/02/2024 02:50:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '87331' 05/02/2024 02:53: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 ( '31' , 'A372' , '2024-02-05' , '' , '0' , '28' , '2623' , 'VIA DEI MILLE 59 80121 NAPOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '188.43' , '154.45' , NOW() , NOW() ) 05/02/2024 02:53: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 = '90240' 05/02/2024 02:53:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '90240' 05/02/2024 02:53: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 ( '90240' , '19602' , 'QUADRETTO EFFETTO PIETRA - SACRA FAMIGLIA - 2952' , '5' , '5' , '1' , '1.61' , '1.3196721311475' , '22' , '0' , '9.8210' ) 05/02/2024 02:53:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19602' AND id_supplier = '28' 05/02/2024 02:53:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19602' , '28' , '1' ) 05/02/2024 02:53: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 ( '90240' , '15089' , 'QUADRETTO EFFETTO PIETRA - SACRA FAMIGLIA - 2950' , '10' , '10' , '1' , '2.62' , '2.1475409836066' , '22' , '0' , '31.9640' ) 05/02/2024 02:53:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15089' AND id_supplier = '28' 05/02/2024 02:53:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15089' , '28' , '1' ) 05/02/2024 02:53: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 ( '90240' , '13562' , 'CORONCINA IN STOFFA CON ROSE E FOGLIOLINE - 3311' , '10' , '10' , '1' , '2.1' , '1.7213114754098' , '22' , '0' , '25.6200' ) 05/02/2024 02:53:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13562' AND id_supplier = '28' 05/02/2024 02:53:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13562' , '28' , '1' ) 05/02/2024 02:53: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 ( '90240' , '21989' , 'MEDAGLIA MIRACOLOSA ARG. 2,7 CM - M060N' , '5' , '5' , '1' , '10.22' , '8.3770491803279' , '22' , '0' , '62.3420' ) 05/02/2024 02:53:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21989' AND id_supplier = '28' 05/02/2024 02:53:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21989' , '28' , '1' ) 05/02/2024 02:53: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 ( '90240' , '12040' , 'MEDAGLIA MIRACOLOSA GRANDE IN ARGENTO - M058' , '10' , '10' , '1' , '4.81' , '3.9426229508197' , '22' , '0' , '58.6820' ) 05/02/2024 02:53:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12040' AND id_supplier = '28' 05/02/2024 02:53:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12040' , '28' , '1' ) 05/02/2024 02:53:40 pm >> UPDATE ps_document SET id_document_type = '31', document_num = 'A372', document_date = '2024-02-05', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2623', address1 = 'VIA DEI MILLE 59 80121 NAPOLI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '188.42', price_tax_excluded = '154.44', date_upd = NOW() WHERE id_document = '90240' 05/02/2024 02:53: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 = '90240' 05/02/2024 02:53:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '90240' 05/02/2024 02:53: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 ( '90240' , '19602' , 'QUADRETTO EFFETTO PIETRA - SACRA FAMIGLIA - 2952' , '5' , '5' , '1' , '1.6100' , '1.3196721311475' , '22' , '0' , '9.82' ) 05/02/2024 02:53: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 ( '90240' , '15089' , 'QUADRETTO EFFETTO PIETRA - SACRA FAMIGLIA - 2950' , '10' , '10' , '1' , '2.6200' , '2.1475409836066' , '22' , '0' , '31.96' ) 05/02/2024 02:53: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 ( '90240' , '13562' , 'CORONCINA IN STOFFA CON ROSE E FOGLIOLINE - 3311' , '10' , '10' , '1' , '2.1000' , '1.7213114754098' , '22' , '0' , '25.62' ) 05/02/2024 02:53: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 ( '90240' , '21989' , 'MEDAGLIA MIRACOLOSA ARG. 2,7 CM - M060N' , '5' , '5' , '1' , '10.2200' , '8.3770491803279' , '22' , '0' , '62.34' ) 05/02/2024 02:53: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 ( '90240' , '12040' , 'MEDAGLIA MIRACOLOSA GRANDE IN ARGENTO - M058' , '10' , '10' , '1' , '4.8100' , '3.9426229508197' , '22' , '0' , '58.68' ) 05/02/2024 03:00:13 pm >> UPDATE ps_document SET id_document_type = '31', document_num = 'A372', document_date = '2024-02-05', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2623', address1 = 'VIA DEI MILLE 59 80121 NAPOLI', address2 = '', note = '', price_shipping = '0.01', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '188.43', price_tax_excluded = '154.45', date_upd = NOW() WHERE id_document = '90240' 05/02/2024 03:00:13 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 = '90240' 05/02/2024 03:00:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '90240' 05/02/2024 03:00:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90240' , '15089' , 'QUADRETTO EFFETTO PIETRA - SACRA FAMIGLIA - 2950' , '10' , '10' , '1' , '2.6200' , '2.1475409836066' , '22' , '0' , '31.96' ) 05/02/2024 03:00:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90240' , '13562' , 'CORONCINA IN STOFFA CON ROSE E FOGLIOLINE - 3311' , '10' , '10' , '1' , '2.1000' , '1.7213114754098' , '22' , '0' , '25.62' ) 05/02/2024 03:00:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90240' , '21989' , 'MEDAGLIA MIRACOLOSA ARG. 2,7 CM - M060N' , '5' , '5' , '1' , '10.2200' , '8.3770491803279' , '22' , '0' , '62.34' ) 05/02/2024 03:00:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90240' , '12040' , 'MEDAGLIA MIRACOLOSA GRANDE IN ARGENTO - M058' , '10' , '10' , '1' , '4.8100' , '3.9426229508197' , '22' , '0' , '58.68' ) 05/02/2024 03:00:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90240' , '17465' , 'QUADRETTO EFFETTO PIETRA MIRACOLOSA E MEDAGLIA 2952/M4' , '5' , '5' , '1' , '1.61' , '1.3196721311475' , '22' , '0' , '9.8210' ) 05/02/2024 03:17:59 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 05/02/2024 03:17:59 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22118' , '1' , '' , 'nuovo-prodotto' ) 05/02/2024 03:18:00 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22118' , '1' , '1' , '2' , NOW() , NOW() ) 05/02/2024 03:18:00 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22118' , '0' , '1' , '0' , '0' ) 05/02/2024 03:18:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788866712909' AND id_product != '22118' AND ean13 != '' 05/02/2024 03:18:32 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788866712909', date_upd = NOW() WHERE id_product = '22118' 05/02/2024 03:18:32 pm >> UPDATE ps_product_lang SET name = 'PIEGHEVOLE LA MEDAGLIA MIRACOLOSA', description = '' WHERE id_product = '22118' 05/02/2024 03:18:32 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.8' WHERE id_product = '22118' 05/02/2024 03:18:32 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.8', id_tax_rules_group = '4', id_category_default = '501', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22118' 05/02/2024 03:18:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '22118' 05/02/2024 03:18:34 pm >> 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 = '22118' 05/02/2024 03:18:34 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22119' , '1' , '' , 'nuovo-prodotto' ) 05/02/2024 03:18:34 pm >> 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 '22119' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22118' 05/02/2024 03:18:34 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22119' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22118' 05/02/2024 04:35:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '366' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-05') 05/02/2024 04:35:18 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '366' , '2024-02-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '235.00' , '207.05' , NOW() , NOW() ) 05/02/2024 04:35: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 = '90241' 05/02/2024 04:35:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '90241' 05/02/2024 04:35: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 ( '90241' , '13723' , 'CROCE GERUSALEMME CON BASE CM 12' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '14.00' ) 05/02/2024 04:35: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 ( '90241' , '3193' , 'CROCIFISSO ULIVO SMUSSATO CM 21' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 05/02/2024 04:35: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 ( '90241' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '14' , '11.475409836066' , '22' , '0' , '28.00' ) 05/02/2024 04:35: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 ( '90241' , '22118' , 'PIEGHEVOLE LA MEDAGLIA MIRACOLOSA' , '100' , '-100' , '4' , '0.80' , '0.8' , '0' , '0' , '80.00' ) 05/02/2024 04:35: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 ( '90241' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '100' , '-100' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '25.00' ) 05/02/2024 04:35: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 ( '90241' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '37.00' , '30.327868852459' , '22' , '0' , '37.00' ) 05/02/2024 04:35: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 ( '90241' , '19607' , 'CLERGY F/F ML - C03' , '1' , '-1' , '1' , '39' , '31.967213114754' , '22' , '0' , '39.00' ) 05/02/2024 05:03:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '367' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-05') 05/02/2024 05:03:01 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' , '367' , '2024-02-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.41' , '9.41' , NOW() , NOW() ) 05/02/2024 05:03:01 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 = '90242' 05/02/2024 05:03:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '90242' 05/02/2024 05:03:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90242' , '1090' , 'BIBBIA' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '5' , '9.41' ) 05/02/2024 05:31:13 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 ( '31' , '48' , '2024-02-05' , '' , '2765' , '0' , '11512' , 'C.SO UMBERTO I , 70 80034 MARIGLIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '84.00' , '84.00' , NOW() , NOW() ) 05/02/2024 05:31:13 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 = '90243' 05/02/2024 05:31:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '90243' 05/02/2024 05:31:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90243' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '3200' , '3200' , '4' , '0.035' , '0.035' , '0' , '25' , '84.0000' ) 05/02/2024 05:44:12 pm >> DELETE FROM ps_document WHERE id_document = '89980' 05/02/2024 05:44:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '89980' 05/02/2024 05:44:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '18/A' AND id_document != '90213' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-02-02') 05/02/2024 05:44:33 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '18/A', document_date = '2024-02-02', document_letter = 'A', id_customer = '0', id_supplier = '', id_address = '2606', address1 = 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE', address2 = '', note = 'merce pagata da scaricare', 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 = '684.00', price_tax_excluded = '627.74', date_upd = NOW() WHERE id_document = '90213' 05/02/2024 05:44: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 = '90213' 05/02/2024 05:44:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '90213' 05/02/2024 05:44:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90213' , '12815' , 'LIBRO DEI CRESIMATI' , '12' , '-12' , '1' , '40.0000' , '32.786885245902' , '22' , '35' , '312.00' ) 05/02/2024 05:44:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90213' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '600' , '-600' , '4' , '1.0000' , '1' , '0' , '38' , '372.00' ) 05/02/2024 06:45:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '368' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-05') 05/02/2024 06:45:54 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '368' , '2024-02-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '190.00' , '155.74' , NOW() , NOW() ) 05/02/2024 06:45: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 = '90244' 05/02/2024 06:45:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '90244' 05/02/2024 06:45: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 ( '90244' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '190' , '155.73770491803' , '22' , '0' , '190.00' ) 05/02/2024 07:04:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '368' AND id_document != '90244' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-05') 05/02/2024 07:04:59 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '368', document_date = '2024-02-05', 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 = '190.00', price_tax_excluded = '155.74', date_upd = NOW() WHERE id_document = '90244' 05/02/2024 07:04:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90244' 05/02/2024 07:04:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '90244' 05/02/2024 07:04:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90244' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '12.5' , '10.245901639344' , '22' , '0' , '12.50' ) 05/02/2024 07:04:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90244' , '12040' , 'MEDAGLIA MIRACOLOSA GRANDE IN ARGENTO - M058' , '9' , '-9' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '121.50' ) 05/02/2024 07:04:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90244' , '21989' , 'MEDAGLIA MIRACOLOSA ARG. 2,7 CM - M060N' , '2' , '-2' , '1' , '28.00' , '22.950819672131' , '22' , '0' , '56.00' )