10/06/2023 08:46:36 am >> SELECT document_num FROM ps_document WHERE document_num = '2013' AND id_document != '85785' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-09') 10/06/2023 08:46:36 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2013', document_date = '2023-06-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA ROMA 84020 RICIGLIANO', 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 = '195.00', price_tax_excluded = '195.00', date_upd = NOW() WHERE id_document = '85785' 10/06/2023 08:46:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85785' 10/06/2023 08:46:36 am >> DELETE FROM ps_document_detail WHERE id_document = '85785' 10/06/2023 08:46:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85785' , '16686' , 'EVANGELIARIO' , '1' , '-1' , '4' , '140.0000' , '140' , '0' , '5' , '133.00' ) 10/06/2023 08:46:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85785' , '5759' , 'LEZIONARIO DOMENICALE E FESTIVO ANNO A' , '1' , '-1' , '4' , '60.0000' , '60' , '0' , '5' , '57.00' ) 10/06/2023 08:46:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85785' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '5' , '5' , '0' , '0' , '5.00' ) 10/06/2023 08:50:59 am >> SELECT document_num FROM ps_document WHERE document_num = '10' AND id_document != '81357' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-02-14') 10/06/2023 08:50:59 am >> UPDATE ps_document SET id_document_type = '24', document_num = '10', document_date = '2023-02-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669106', address1 = 'VIA G. VERDI, 8 20090 ASSAGO', 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 = '424.30', price_tax_excluded = '424.30', date_upd = NOW() WHERE id_document = '81357' 10/06/2023 08:50:59 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 = '81357' 10/06/2023 08:51:00 am >> DELETE FROM ps_document_detail WHERE id_document = '81357' 10/06/2023 08:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '19764' , 'PRIMO PASSO - TACCUINO' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '0' , '10.00' ) 10/06/2023 08:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '15697' , 'RICCHEZZA DEL LIMITE - A. SCICCHITANO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 10/06/2023 08:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '5834' , 'LIBRO DEL CELEBRANTE - VOL 1 SLUZHEBNIK' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 10/06/2023 08:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '18466' , 'ETERNO ASSENTE SANTAGOSTINO - A. BISOGNO' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '0' , '30.00' ) 10/06/2023 08:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '18043' , 'MESSA INCONTRO CON IL RISORTO - A. ZIRONI' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 10/06/2023 08:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '19766' , 'WORK IN PROGRESS' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 10/06/2023 08:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '15525' , 'CASA DI CURIA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 10/06/2023 08:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '20240' , 'PRONTI PARTENZA A BETLEMME - 11-14 ANNI' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 10/06/2023 08:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '20241' , 'PRONTI PARTENZA A BETLEMME - 7-10 ANNI' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 10/06/2023 08:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '20242' , 'PRONTI PARTENZA A BETLEMME - 3-6 ANNI' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 10/06/2023 08:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '19380' , 'OGGETTO PREDICA' , '2' , '-2' , '4' , '16.0000' , '16' , '0' , '0' , '32.00' ) 10/06/2023 08:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '13914' , 'BAMBINI A MESSA ANNO C - AAVV' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 10/06/2023 08:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '20590' , 'PREGHIERA - PAPA FRANCESCO' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 10/06/2023 08:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '19491' , 'IN DIALOGO CON IL MONDO - PAPA FRANCESCO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 10/06/2023 08:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '20047' , 'AGENDA MISSIONARIA 2023' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 10/06/2023 08:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '6086' , 'MADRE DI MISERICORDIA - M.PAPPALARDO' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 10/06/2023 08:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '16049' , 'CINQUANTA GRANI DI CIELO -S. PROIETTI' , '2' , '-2' , '4' , '3.5000' , '3.5' , '0' , '0' , '7.00' ) 10/06/2023 08:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '8351' , 'PREGHIERE DEI PASTI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 10/06/2023 08:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '4774' , 'GRIDO DEL POVERO - M. MOSCA' , '1' , '-1' , '4' , '8.5000' , '8.5' , '0' , '0' , '8.50' ) 10/06/2023 08:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '9099' , 'ROSARIO DELLA TENEREZZA - MADONNA' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '0' , '2.80' ) 10/06/2023 08:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '19048' , 'CELIBATO E CONTINENZA ECCLESIALI - C. BONIVENTO' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 10/06/2023 08:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '18202' , 'COSTRUIRE UN MONDO NUOVO - AAVV' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 10/06/2023 08:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '17595' , 'STATUTO AZIONE CATTOLICA' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 10/06/2023 08:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '6642' , 'MIA PRIMA COMUNIONE - M. IASEVOLI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 10/06/2023 08:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '14334' , 'VIVIAMO INSIEME IL VANGELO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 10/06/2023 08:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '14433' , 'VIVIAMO IL VANGELO - BATTESIMO' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 10/06/2023 08:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '14432' , 'VIVIAMO IL VANGELO - ANNO 1 - FAMIGLIE' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '0' , '4.00' ) 10/06/2023 08:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '14335' , 'VIVIAMO INSIEME IL VANGELO - ANNO 2' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 10/06/2023 08:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '14429' , 'VIVIAMO IL VANGELO - ANNO 3 - FAMIGLIE' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '0' , '4.00' ) 10/06/2023 08:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '14697' , 'CREDI AMA SPERA - A. GRAZIANI' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 10/06/2023 08:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '18467' , 'INNAMORARSI OGNI GIORNO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 10/06/2023 08:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '19762' , 'PRIMO PASSO - GUIDA' , '1' , '-1' , '4' , '12.5000' , '12.5' , '0' , '0' , '12.50' ) 10/06/2023 08:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '19762' , 'PRIMO PASSO - GUIDA' , '1' , '-1' , '4' , '12.5000' , '12.5' , '0' , '0' , '12.50' ) 10/06/2023 08:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '20051' , 'ANDATE DUNQUE 2022/23 ANNO A' , '1' , '-1' , '4' , '10.5000' , '10.5' , '0' , '0' , '10.50' ) 10/06/2023 08:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '19767' , 'RAGAZZI CHE SQUADRA - CALENDARIO' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 10/06/2023 08:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '19761' , 'RAGAZZI CHE SQUADRA' , '1' , '-1' , '4' , '16.5000' , '16.5' , '0' , '0' , '16.50' ) 10/06/2023 08:51:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '19761' , 'RAGAZZI CHE SQUADRA' , '1' , '-1' , '4' , '16.5000' , '16.5' , '0' , '0' , '16.50' ) 10/06/2023 08:51:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '19759' , 'RAGAZZI CHE SQUADRA - 2' , '1' , '-1' , '4' , '16.5000' , '16.5' , '0' , '0' , '16.50' ) 10/06/2023 08:51:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '19758' , 'RAGAZZI CHE SQUADRA - 1' , '1' , '-1' , '4' , '16.5000' , '16.5' , '0' , '0' , '16.50' ) 10/06/2023 08:52:12 am >> SELECT document_num FROM ps_document WHERE document_num = '2008' AND id_document != '85780' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-09') 10/06/2023 08:52:12 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2008', document_date = '2023-06-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '6.60', price_tax_excluded = '5.41', date_upd = NOW() WHERE id_document = '85780' 10/06/2023 08:52:12 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85780' 10/06/2023 08:52:12 am >> DELETE FROM ps_document_detail WHERE id_document = '85780' 10/06/2023 08:52:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85780' , '6353' , 'MEDAGLIA S. BENEDETTO SMALTATA - M016' , '3' , '-3' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '3.30' ) 10/06/2023 08:52:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85780' , '7917' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. B' , '6' , '-6' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '3.00' ) 10/06/2023 08:52:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85780' , '7917' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. B' , '1' , '-1' , '1' , '0.3' , '0.24590163934426' , '22' , '0' , '0.30' ) 10/06/2023 08:53:21 am >> SELECT document_num FROM ps_document WHERE document_num = '1308' AND id_document != '82886' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-19') 10/06/2023 08:53:21 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1308', document_date = '2023-04-19', 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 = '237.32', price_tax_excluded = '237.32', date_upd = NOW() WHERE id_document = '82886' 10/06/2023 08:53:21 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 = '82886' 10/06/2023 08:53:21 am >> DELETE FROM ps_document_detail WHERE id_document = '82886' 10/06/2023 08:53:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82886' , '19615' , 'DOVE LA VITA NON VUOLE MORIRE - F. ACCROCCA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 10/06/2023 08:53:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82886' , '18498' , 'BUONA DOMENICA - ANNO B - G. BAGET BOZZO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 10/06/2023 08:53:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82886' , '18751' , 'CAMMINARE INSIEME - A. LANDI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 10/06/2023 08:53:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82886' , '15816' , 'CI HA REDENTI CON IL TUO SANGUE - L. EPICOCO ' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 10/06/2023 08:53:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82886' , '10060' , 'SOLO I MALATI GUARISCONO - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 10/06/2023 08:53:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82886' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '4' , '-4' , '4' , '12.0000' , '12' , '0' , '5' , '45.60' ) 10/06/2023 08:53:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82886' , '18920' , 'LUCE IN FONDO - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 10/06/2023 08:53:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82886' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 10/06/2023 08:53:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82886' , '17127' , 'STABILI E CREDIBILI - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 10/06/2023 08:53:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82886' , '12995' , 'SALE, NON MIELE - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 10/06/2023 08:53:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82886' , '15996' , 'TELEMACO NON SI SBAGLIAVA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 10/06/2023 08:53:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82886' , '20494' , 'TI VOGLIO FELICE - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.9000' , '16.9' , '0' , '5' , '16.06' ) 10/06/2023 08:53:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82886' , '19388' , 'NOI CREDIAMO - PAPA FRANCESCO' , '1' , '-1' , '4' , '14.9000' , '14.9' , '0' , '5' , '14.16' ) 10/06/2023 08:53:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82886' , '12705' , 'QUELLO CHE SEI PER ME - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 10/06/2023 08:53:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82886' , '17127' , 'STABILI E CREDIBILI - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 10/06/2023 08:53:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82886' , '20809' , 'PAROLE RITROVATE - G. ZURRA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 10/06/2023 09:03:09 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , 'FPR 45/23' , '2023-04-11' , '23' , '0' , '168' , '4676356' , 'VIA PALATUCCI 2 84048 CASTELLABATE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '1144.00' , '1100.00' , NOW() , NOW() ) 10/06/2023 09:03:09 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85792' 10/06/2023 09:03:09 am >> DELETE FROM ps_document_detail WHERE id_document = '85792' 10/06/2023 09:03:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85792' , '20908' , 'REPUBBLICA PARTENOPEA E MONS. MICHELE NATALE' , '110' , '110' , '3' , '5' , '4.8076923076923' , '4' , '0' , '572.0000' ) 10/06/2023 09:03:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '20908' AND id_supplier = '168' 10/06/2023 09:03:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20908' , '168' , '1' ) 10/06/2023 09:03:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85792' , '20909' , 'SAN GIOVANNI BATTISTA E SAN FRANCESCO DI PAOLA' , '110' , '110' , '3' , '5' , '4.8076923076923' , '4' , '0' , '572.0000' ) 10/06/2023 09:03:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '20909' AND id_supplier = '168' 10/06/2023 09:03:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20909' , '168' , '1' ) 10/06/2023 09:13:06 am >> SELECT document_num FROM ps_document WHERE document_num = '2020' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-10') 10/06/2023 09:13:06 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' , '2020' , '2023-06-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.00' , '28.33' , NOW() , NOW() ) 10/06/2023 09:13:06 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 = '85793' 10/06/2023 09:13:06 am >> DELETE FROM ps_document_detail WHERE id_document = '85793' 10/06/2023 09:13:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85793' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '17.00' ) 10/06/2023 09:13:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85793' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 10/06/2023 09:13:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85793' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 10/06/2023 09:13:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85793' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 10/06/2023 09:39:27 am >> SELECT document_num FROM ps_document WHERE document_num = '2021' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-10') 10/06/2023 09:39:27 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2021' , '2023-06-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '124.60' , '123.83' , NOW() , NOW() ) 10/06/2023 09:39:27 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85794' 10/06/2023 09:39:27 am >> DELETE FROM ps_document_detail WHERE id_document = '85794' 10/06/2023 09:39:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85794' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 10/06/2023 09:39:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85794' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 10/06/2023 09:39:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85794' , '5559' , 'LASCIATE CHE I BAMBINI VENGANO A ME' , '20' , '-20' , '4' , '5.50' , '5.5' , '0' , '5' , '104.60' ) 10/06/2023 09:43:41 am >> SELECT document_num FROM ps_document WHERE document_num = '2022' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-10') 10/06/2023 09:43:41 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2022' , '2023-06-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.80' , '14.53' , NOW() , NOW() ) 10/06/2023 09:43: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 = '85795' 10/06/2023 09:43:41 am >> DELETE FROM ps_document_detail WHERE id_document = '85795' 10/06/2023 09:43: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 ( '85795' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '6' , '-6' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '1.50' ) 10/06/2023 09:43: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 ( '85795' , '9420' , 'SAN FRANCESCO DASSISI' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 10/06/2023 09:43: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 ( '85795' , '9490' , 'SAN NICOLA - A. DURSO' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 10/06/2023 09:43: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 ( '85795' , '7385' , 'PADRE PIO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 10/06/2023 09:48:06 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831555791' AND id_product != '20871' AND ean13 != '' 10/06/2023 09:48:06 am >> UPDATE ps_product SET id_supplier = '7', reference = '7/5', ean13 = '9788831555791', date_upd = NOW() WHERE id_product = '20871' 10/06/2023 09:48:06 am >> UPDATE ps_product_lang SET name = 'NELLA STORIA ACCOMPAGNATI DA MARIA', description = '' WHERE id_product = '20871' 10/06/2023 09:48:06 am >> UPDATE ps_product SET wholesale_price = '4.02', on_sale = '0', price = '6.0000' WHERE id_product = '20871' 10/06/2023 09:48:06 am >> UPDATE ps_product_shop SET wholesale_price = '4.02', price = '6.0000', id_tax_rules_group = '4', id_category_default = '27', 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 = '20871' 10/06/2023 09:48:06 am >> DELETE FROM ps_specific_price WHERE id_product = '20871' 10/06/2023 10:09:47 am >> SELECT document_num FROM ps_document WHERE document_num = '2023' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-10') 10/06/2023 10:09:47 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' , '2023' , '2023-06-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.40' , '36.40' , NOW() , NOW() ) 10/06/2023 10:09:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85796' 10/06/2023 10:09:47 am >> DELETE FROM ps_document_detail WHERE id_document = '85796' 10/06/2023 10:09:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85796' , '370' , 'ALBUM DELLA MIA PRIMA COMUNIONE' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '5' , '12.26' ) 10/06/2023 10:09:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85796' , '4487' , 'GESÙ NEL CUORE - ALBUM PRIMA COMUNIONE' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '5' , '12.26' ) 10/06/2023 10:09:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85796' , '19654' , 'ALBUM RICORDO PRIMA COMUNIONE' , '1' , '-1' , '4' , '12.50' , '12.5' , '0' , '5' , '11.88' ) 10/06/2023 10:53:22 am >> SELECT document_num FROM ps_document WHERE document_num = '66/A' AND id_document != '85772' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-06-09') 10/06/2023 10:53:22 am >> UPDATE ps_document SET id_document_type = '24', document_num = '66/A', document_date = '2023-06-09', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'ospedale s. leonardo', 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 = '263.92', price_tax_excluded = '221.74', date_upd = NOW() WHERE id_document = '85772' 10/06/2023 10:53:22 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85772' 10/06/2023 10:53:22 am >> DELETE FROM ps_document_detail WHERE id_document = '85772' 10/06/2023 10:53:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85772' , '21067' , 'AMEN - AGO 23' , '3' , '-3' , '4' , '3.9000' , '3.9' , '0' , '5' , '11.12' ) 10/06/2023 10:53:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85772' , '17617' , 'IMMAGINI ISONZO X 100' , '4' , '-4' , '1' , '3.8000' , '3.1147540983607' , '22' , '0' , '15.20' ) 10/06/2023 10:53:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85772' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 10/06/2023 10:53:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85772' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '14.00' ) 10/06/2023 10:53:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85772' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '48.00' ) 10/06/2023 10:53:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85772' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 10/06/2023 10:53:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85772' , '16834' , 'LITURGICO CARTA 8GG' , '24' , '-24' , '1' , '3.3000' , '2.7049180327869' , '22' , '0' , '79.20' ) 10/06/2023 10:53:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85772' , '9124' , 'ROSARIO IN PLASTICA - MARRONE' , '20' , '-20' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '6.00' ) 10/06/2023 10:53:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85772' , '20825' , 'BRUCIA INCENSO STELLA' , '1' , '-1' , '1' , '24.00' , '19.672131147541' , '22' , '0' , '24.00' ) 10/06/2023 10:56:40 am >> SELECT document_num FROM ps_document WHERE document_num = '48/A' AND id_document != '82684' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-05') 10/06/2023 10:56:40 am >> UPDATE ps_document SET id_document_type = '24', document_num = '48/A', document_date = '2023-04-05', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '436.00', price_tax_excluded = '357.38', date_upd = NOW() WHERE id_document = '82684' 10/06/2023 10:56: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 = '82684' 10/06/2023 10:56:40 am >> DELETE FROM ps_document_detail WHERE id_document = '82684' 10/06/2023 10:56: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 ( '82684' , '16514' , 'CROCIFISSO 105X60 - 1015' , '1' , '-1' , '1' , '300.0000' , '245.90163934426' , '22' , '0' , '300.00' ) 10/06/2023 10:56: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 ( '82684' , '0' , '20/05/2022' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 10/06/2023 10:56: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 ( '82684' , '0' , 'ROSA' , '1' , '-1' , '1' , '85.0000' , '69.672131147541' , '22' , '0' , '85.00' ) 10/06/2023 10:56: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 ( '82684' , '15768' , 'RICAMBIO PER TORCIA ORO DIAM. 5 - 35' , '1' , '-1' , '1' , '43.00' , '35.245901639344' , '22' , '0' , '43.00' ) 10/06/2023 10:56: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 ( '82684' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '4' , '-4' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '8.00' ) 10/06/2023 11:03:10 am >> SELECT document_num FROM ps_document WHERE document_num = '66/A' AND id_document != '85772' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-06-09') 10/06/2023 11:03:10 am >> UPDATE ps_document SET id_document_type = '24', document_num = '66/A', document_date = '2023-06-09', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'ospedale s. leonardo', 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 = '263.92', price_tax_excluded = '221.74', date_upd = NOW() WHERE id_document = '85772' 10/06/2023 11:03:10 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 = '85772' 10/06/2023 11:03:10 am >> DELETE FROM ps_document_detail WHERE id_document = '85772' 10/06/2023 11:03:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85772' , '21067' , 'AMEN - AGO 23' , '3' , '-3' , '4' , '3.9000' , '3.9' , '0' , '5' , '11.12' ) 10/06/2023 11:03:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85772' , '17617' , 'IMMAGINI ISONZO X 100' , '4' , '-4' , '1' , '3.8000' , '3.1147540983607' , '22' , '0' , '15.20' ) 10/06/2023 11:03:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85772' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 10/06/2023 11:03:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85772' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '14.00' ) 10/06/2023 11:03:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85772' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '48.00' ) 10/06/2023 11:03:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85772' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 10/06/2023 11:03:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85772' , '16834' , 'LITURGICO CARTA 8GG' , '24' , '-24' , '1' , '3.3000' , '2.7049180327869' , '22' , '0' , '79.20' ) 10/06/2023 11:03:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85772' , '9124' , 'ROSARIO IN PLASTICA - MARRONE' , '20' , '-20' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '6.00' ) 10/06/2023 11:03:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85772' , '20825' , 'BRUCIA INCENSO STELLA' , '1' , '-1' , '1' , '24.0000' , '19.672131147541' , '22' , '0' , '24.00' ) 10/06/2023 11:03:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85772' , '5958' , 'omaggio' , '1' , '-1' , '1' , '0' , '0' , '22' , '0' , '0.00' ) 10/06/2023 11:03:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85772' , '5958' , 'LUCAS 25G - FIORI D\'ARANCIO - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '100' , '0.00' ) 10/06/2023 11:04:11 am >> DELETE FROM ps_document WHERE id_document = '84077' 10/06/2023 11:04:11 am >> DELETE FROM ps_document_detail WHERE id_document = '84077' 10/06/2023 11:09:17 am >> SELECT document_num FROM ps_document WHERE document_num = '2024' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-10') 10/06/2023 11:09:17 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' , '2024' , '2023-06-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.40' , '27.40' , NOW() , NOW() ) 10/06/2023 11:09:17 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 = '85797' 10/06/2023 11:09:17 am >> DELETE FROM ps_document_detail WHERE id_document = '85797' 10/06/2023 11:09:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85797' , '19655' , 'FESTA DELLA PRIMA COMUNIONE' , '1' , '-1' , '4' , '13.90' , '13.9' , '0' , '0' , '13.90' ) 10/06/2023 11:09:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85797' , '6640' , 'MIA PRIMA COMUNIONE' , '1' , '-1' , '4' , '13.50' , '13.5' , '0' , '0' , '13.50' ) 10/06/2023 11:10:57 am >> SELECT document_num FROM ps_document WHERE document_num = '1010' AND id_document != '82511' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-28') 10/06/2023 11:10:57 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1010', document_date = '2023-03-28', 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 = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '82511' 10/06/2023 11:10:57 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82511' 10/06/2023 11:10:57 am >> DELETE FROM ps_document_detail WHERE id_document = '82511' 10/06/2023 11:10:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82511' , '5538' , 'LACCIO MARRONE' , '2' , '-2' , '1' , '0.05' , '0.040983606557377' , '22' , '0' , '0.10' ) 10/06/2023 11:10:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82511' , '18762' , 'BRACCIALE ARG. - 1568/1570' , '1' , '-1' , '1' , '38.9000' , '31.885245901639' , '22' , '0' , '38.90' ) 10/06/2023 11:10:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82511' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '6' , '-6' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '6.00' ) 10/06/2023 11:11:26 am >> SELECT document_num FROM ps_document WHERE document_num = '1063' AND id_document != '82569' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-31') 10/06/2023 11:11:26 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1063', document_date = '2023-03-31', 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 = '74.00', price_tax_excluded = '60.66', date_upd = NOW() WHERE id_document = '82569' 10/06/2023 11:11:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82569' 10/06/2023 11:11:26 am >> DELETE FROM ps_document_detail WHERE id_document = '82569' 10/06/2023 11:11:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82569' , '12613' , 'TURIBOLO 10 CM' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 10/06/2023 11:11:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82569' , '11683' , 'CROCE CON COLOMBA E LACCIO - 0872/09' , '30' , '-30' , '1' , '1.8000' , '1.4754098360656' , '22' , '0' , '54.00' ) 10/06/2023 11:11:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82569' , '5473' , 'IOHANNES 25G - ROSA - EVE ' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 10/06/2023 11:11:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82569' , '7940' , 'PERGAMENE - OCCASIONI MOD. A' , '1' , '-1' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '0.50' ) 10/06/2023 11:11:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82569' , '18131' , 'TAU MEDIO CM3 - T6' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 10/06/2023 11:11:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82569' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 10/06/2023 11:11:46 am >> SELECT document_num FROM ps_document WHERE document_num = '1232' AND id_document != '82782' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-13') 10/06/2023 11:11:47 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1232', document_date = '2023-04-13', 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 = '10.00', price_tax_excluded = '8.20', date_upd = NOW() WHERE id_document = '82782' 10/06/2023 11:11:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82782' 10/06/2023 11:11:47 am >> DELETE FROM ps_document_detail WHERE id_document = '82782' 10/06/2023 11:11:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82782' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '10' , '-10' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '10.00' ) 10/06/2023 11:13:39 am >> SELECT document_num FROM ps_document WHERE document_num = '1096' AND id_document != '82606' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-03') 10/06/2023 11:13:39 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1096', document_date = '2023-04-03', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '12.70', price_tax_excluded = '10.41', date_upd = NOW() WHERE id_document = '82606' 10/06/2023 11:13:39 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 = '82606' 10/06/2023 11:13:39 am >> DELETE FROM ps_document_detail WHERE id_document = '82606' 10/06/2023 11:13:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82606' , '7923' , 'PERGAMENE - ANNIVERSARIO MATRIM. MOD. B' , '1' , '-1' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '0.30' ) 10/06/2023 11:13:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82606' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '7' , '-7' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '7.00' ) 10/06/2023 11:13:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82606' , '14772' , 'BRACCIALE SAN BENEDETTO 4 COLORI - 0818/3' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 10/06/2023 11:13:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82606' , '18215' , 'BRACCIALE DECINA VARI COL. - BC752' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 10/06/2023 11:13:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82606' , '18214' , 'BRACCIALE DECINA LEGNO CORDA - BC566' , '1' , '-1' , '1' , '1.9' , '1.5573770491803' , '22' , '0' , '1.90' ) 10/06/2023 11:15:02 am >> SELECT document_num FROM ps_document WHERE document_num = '1075' AND id_document != '82582' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-31') 10/06/2023 11:15:02 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1075', document_date = '2023-03-31', 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 = '16.00', price_tax_excluded = '13.11', date_upd = NOW() WHERE id_document = '82582' 10/06/2023 11:15:02 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82582' 10/06/2023 11:15:02 am >> DELETE FROM ps_document_detail WHERE id_document = '82582' 10/06/2023 11:15:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82582' , '18892' , 'BRACCIALE DECINA AZZURRO - BC822NP' , '1' , '-1' , '1' , '1' , '0.81967213114754' , '22' , '0' , '1.00' ) 10/06/2023 11:15:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82582' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '12' , '-12' , '1' , '1.25' , '1.0245901639344' , '22' , '0' , '15.00' ) 10/06/2023 11:16:26 am >> SELECT document_num FROM ps_document WHERE document_num = '1184' AND id_document != '82721' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-07') 10/06/2023 11:16:26 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1184', document_date = '2023-04-07', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '8.90', price_tax_excluded = '8.77', date_upd = NOW() WHERE id_document = '82721' 10/06/2023 11:16:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82721' 10/06/2023 11:16:26 am >> DELETE FROM ps_document_detail WHERE id_document = '82721' 10/06/2023 11:16:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82721' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 10/06/2023 11:16:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82721' , '2448' , 'COLUI IN CUI CREDO' , '3' , '-3' , '4' , '1.8' , '1.8' , '0' , '0' , '5.40' ) 10/06/2023 11:17:35 am >> SELECT document_num FROM ps_document WHERE document_num = '1421' AND id_document != '83024' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-28') 10/06/2023 11:17:35 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1421', document_date = '2023-04-28', 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 = '45.00', price_tax_excluded = '45.00', date_upd = NOW() WHERE id_document = '83024' 10/06/2023 11:17:35 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 = '83024' 10/06/2023 11:17:35 am >> DELETE FROM ps_document_detail WHERE id_document = '83024' 10/06/2023 11:17:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83024' , '20765' , 'AMEN - MAG 23' , '5' , '-5' , '4' , '3.90' , '3.9' , '0' , '5' , '18.55' ) 10/06/2023 11:17:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83024' , '20766' , 'AMEN - GIU 23' , '5' , '-5' , '4' , '3.90' , '3.9' , '0' , '5' , '18.55' ) 10/06/2023 11:17:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83024' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '7.9' , '7.9' , '0' , '0' , '7.90' ) 10/06/2023 11:18:19 am >> SELECT document_num FROM ps_document WHERE document_num = '1561' AND id_document != '84210' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-08') 10/06/2023 11:18:19 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1561', document_date = '2023-05-08', 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 = '20.00', price_tax_excluded = '20.00', date_upd = NOW() WHERE id_document = '84210' 10/06/2023 11:18: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 = '84210' 10/06/2023 11:18:19 am >> DELETE FROM ps_document_detail WHERE id_document = '84210' 10/06/2023 11:18: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 ( '84210' , '20719' , 'CORONA DELL’ADDOLORATA' , '1' , '-1' , '4' , '1.45' , '1.45' , '0' , '0' , '1.45' ) 10/06/2023 11:18: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 ( '84210' , '20999' , 'AMEN - LUG 23' , '5' , '-5' , '4' , '3.90' , '3.9' , '0' , '5' , '18.55' ) 10/06/2023 11:29:41 am >> SELECT document_num FROM ps_document WHERE document_num = '2025' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-10') 10/06/2023 11:29:41 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2025' , '2023-06-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 10/06/2023 11:29: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 = '85798' 10/06/2023 11:29:41 am >> DELETE FROM ps_document_detail WHERE id_document = '85798' 10/06/2023 11:29: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 ( '85798' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 10/06/2023 11:43:41 am >> SELECT document_num FROM ps_document WHERE document_num = '2026' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-10') 10/06/2023 11:43:41 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2026' , '2023-06-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.90' , '21.54' , NOW() , NOW() ) 10/06/2023 11:43: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 = '85799' 10/06/2023 11:43:41 am >> DELETE FROM ps_document_detail WHERE id_document = '85799' 10/06/2023 11:43: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 ( '85799' , '20892' , 'LEGGIAMO INSIEME LA BIBBIA' , '1' , '-1' , '4' , '14.2' , '14.2' , '0' , '0' , '14.20' ) 10/06/2023 11:43: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 ( '85799' , '1178' , 'BIBBIA PER I RAGAZZI - ECON.' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 10/06/2023 11:43: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 ( '85799' , '17005' , 'BIGLIETTO AUGURALE medio' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 10/06/2023 11:44:45 am >> SELECT document_num FROM ps_document WHERE document_num = '2027' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-10') 10/06/2023 11:44:45 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' , '2027' , '2023-06-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.71' , '5.71' , NOW() , NOW() ) 10/06/2023 11:44:45 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 = '85800' 10/06/2023 11:44:45 am >> DELETE FROM ps_document_detail WHERE id_document = '85800' 10/06/2023 11:44:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85800' , '20722' , 'SEMINATORI DI GIOIA' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 10/06/2023 11:44:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85800' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 10/06/2023 11:48:40 am >> SELECT document_num FROM ps_document WHERE document_num = '1366' AND id_document != '82959' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-26') 10/06/2023 11:48:40 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1366', document_date = '2023-04-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '130.00', price_tax_excluded = '106.56', date_upd = NOW() WHERE id_document = '82959' 10/06/2023 11:48: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 = '82959' 10/06/2023 11:48:40 am >> DELETE FROM ps_document_detail WHERE id_document = '82959' 10/06/2023 11:48: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 ( '82959' , '18618' , 'MEDAGLIA SAN MICHELE - OV22/MC' , '1' , '-1' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '0.20' ) 10/06/2023 11:48: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 ( '82959' , '20116' , 'FATIMA CM 70 - 1037' , '1' , '-1' , '1' , '120.0000' , '98.360655737705' , '22' , '0' , '120.00' ) 10/06/2023 11:48: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 ( '82959' , '20524' , 'CROCE SAN BENEDETTO SMALTATA - CZ4NIK' , '2' , '-2' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 10/06/2023 12:00:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '2028' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-10') 10/06/2023 12:00:00 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' , '2028' , '2023-06-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.90' , '24.51' , NOW() , NOW() ) 10/06/2023 12:00:00 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 = '85801' 10/06/2023 12:00:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '85801' 10/06/2023 12:00:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85801' , '20707' , 'LUME LEGNO' , '1' , '-1' , '1' , '29.90' , '24.508196721311' , '22' , '0' , '29.90' ) 10/06/2023 12:02:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '2029' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-10') 10/06/2023 12:02:00 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' , '2029' , '2023-06-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 10/06/2023 12:02:00 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 = '85802' 10/06/2023 12:02:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '85802' 10/06/2023 12:02:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85802' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 10/06/2023 12:28:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '2030' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-10') 10/06/2023 12:28:12 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2030' , '2023-06-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.00' , '13.93' , NOW() , NOW() ) 10/06/2023 12:28: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 = '85803' 10/06/2023 12:28:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '85803' 10/06/2023 12:28: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 ( '85803' , '11389' , 'VINO ROSSO DOLCE - 103' , '2' , '-2' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '17.00' ) 10/06/2023 12:54:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '2031' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-10') 10/06/2023 12:54:57 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' , '2031' , '2023-06-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '93.00' , '93.00' , NOW() , NOW() ) 10/06/2023 12:54:57 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 = '85804' 10/06/2023 12:54:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '85804' 10/06/2023 12:54:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85804' , '12255' , 'IN CAMMINO CON GESU' , '31' , '-31' , '4' , '3' , '3' , '0' , '0' , '93.00' ) 10/06/2023 12:55:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '2032' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-10') 10/06/2023 12:55:12 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2032' , '2023-06-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.70' , '5.70' , NOW() , NOW() ) 10/06/2023 12:55: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 = '85805' 10/06/2023 12:55:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '85805' 10/06/2023 12:55: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 ( '85805' , '21068' , 'MESSALINO AGO/SET/OTT 2023' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' )