07/10/2023 08:19:07 am >> SELECT document_num FROM ps_document WHERE document_num = '2797' AND id_document != '87264' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-12') 07/10/2023 08:19:07 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2797', document_date = '2023-09-12', 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 = '75.80', price_tax_excluded = '62.13', date_upd = NOW() WHERE id_document = '87264' 07/10/2023 08:19:08 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87264' 07/10/2023 08:19:08 am >> DELETE FROM ps_document_detail WHERE id_document = '87264' 07/10/2023 08:19:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87264' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '5' , '-5' , '1' , '3' , '2.4590163934426' , '22' , '0' , '15.00' ) 07/10/2023 08:19:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87264' , '17006' , 'SEGNALIBRO PR' , '1' , '-1' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '0.30' ) 07/10/2023 08:19:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87264' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '1' , '-1' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '0.50' ) 07/10/2023 08:19:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87264' , '20078' , 'ROSARIO ARGENTO' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 07/10/2023 08:19:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87264' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 07/10/2023 08:37:58 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9128286423427' AND id_product != '106' AND ean13 != '' 07/10/2023 08:37:58 am >> UPDATE ps_product SET id_supplier = '', reference = '4/2', ean13 = '9128286423427', date_upd = NOW() WHERE id_product = '106' 07/10/2023 08:37:58 am >> UPDATE ps_product_lang SET name = 'A MESSA SALTANDO DI GIOIA - GUIDA', description = '' WHERE id_product = '106' 07/10/2023 08:37:58 am >> UPDATE ps_product SET wholesale_price = '0.95', on_sale = '0', price = '5.1600' WHERE id_product = '106' 07/10/2023 08:37:58 am >> UPDATE ps_product_shop SET wholesale_price = '0.95', price = '5.1600', id_tax_rules_group = '4', id_category_default = '', id_argoment_default = '56', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '106' 07/10/2023 08:37:58 am >> DELETE FROM ps_specific_price WHERE id_product = '106' 07/10/2023 08:37:58 am >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '106' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 07/10/2023 08:38:32 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886423427' AND id_product != '106' AND ean13 != '' 07/10/2023 08:38:32 am >> UPDATE ps_product SET id_supplier = '', reference = '4/2', ean13 = '9788886423427', date_upd = NOW() WHERE id_product = '106' 07/10/2023 08:38:32 am >> UPDATE ps_product_lang SET name = 'A MESSA SALTANDO DI GIOIA - GUIDA', description = '' WHERE id_product = '106' 07/10/2023 08:38:32 am >> UPDATE ps_product SET wholesale_price = '0.95', on_sale = '0', price = '5.1600' WHERE id_product = '106' 07/10/2023 08:38:32 am >> UPDATE ps_product_shop SET wholesale_price = '0.95', price = '5.1600', id_tax_rules_group = '4', id_category_default = '', id_argoment_default = '56', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '106' 07/10/2023 08:38:32 am >> DELETE FROM ps_specific_price WHERE id_product = '106' 07/10/2023 08:38:32 am >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '106' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 07/10/2023 08:50:02 am >> SELECT document_num FROM ps_document WHERE document_num = '45/E' AND id_document != '87627' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-06') 07/10/2023 08:50:02 am >> UPDATE ps_document SET id_document_type = '25', document_num = '45/E', document_date = '2023-10-06', document_letter = 'E', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'RESA SETTEMBRE 2023', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '14', id_causal = '0', price_tax_included = '556.61', price_tax_excluded = '556.16', date_upd = NOW() WHERE id_document = '87627' 07/10/2023 08:50: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 = '87627' 07/10/2023 08:50:02 am >> DELETE FROM ps_document_detail WHERE id_document = '87627' 07/10/2023 08:50: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 ( '87627' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '5' , '0' , '4' , '2.4000' , '2.4' , '0' , '50' , '6.00' ) 07/10/2023 08:50: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 ( '87627' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '1' , '0' , '4' , '6.20' , '6.2' , '0' , '50' , '3.10' ) 07/10/2023 08:50: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 ( '87627' , '106' , 'A MESSA SALTANDO DI GIOIA - GUIDA' , '1' , '0' , '4' , '5.16' , '5.16' , '0' , '50' , '2.58' ) 07/10/2023 08:50: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 ( '87627' , '8254' , 'PREGHIAMO CON MARIA' , '1' , '0' , '4' , '0.65' , '0.65' , '0' , '50' , '0.33' ) 07/10/2023 08:50: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 ( '87627' , '5457' , 'IO SONO CON VOI 1 PARTE' , '17' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '23.80' ) 07/10/2023 08:50: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 ( '87627' , '5458' , 'IO SONO CON VOI 2 PARTE' , '14' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '19.60' ) 07/10/2023 08:50: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 ( '87627' , '11191' , 'VENITE CON ME 1 PARTE' , '9' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '12.60' ) 07/10/2023 08:50: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 ( '87627' , '11192' , 'VENITE CON ME 2 PARTE' , '6' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '8.40' ) 07/10/2023 08:50: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 ( '87627' , '3443' , 'DIECI PAROLE DAMORE' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 07/10/2023 08:50: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 ( '87627' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '1' , '0' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 07/10/2023 08:50: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 ( '87627' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '1' , '0' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 07/10/2023 08:50: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 ( '87627' , '6629' , 'MIA PREGHIERA' , '3' , '0' , '4' , '0.90' , '0.9' , '0' , '50' , '1.35' ) 07/10/2023 08:50: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 ( '87627' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '2' , '0' , '4' , '12.00' , '12' , '0' , '50' , '12.00' ) 07/10/2023 08:50: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 ( '87627' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '36' , '0' , '4' , '1.60' , '1.6' , '0' , '50' , '28.80' ) 07/10/2023 08:50: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 ( '87627' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '1' , '0' , '4' , '25.00' , '25' , '0' , '50' , '12.50' ) 07/10/2023 08:50: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 ( '87627' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '31' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '54.25' ) 07/10/2023 08:50: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 ( '87627' , '12819' , 'REGISTRO DEL CATECHISTA ' , '5' , '0' , '1' , '1.00' , '0.81967213114754' , '22' , '50' , '2.50' ) 07/10/2023 08:50: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 ( '87627' , '12253' , 'MIO LIBRO DI PREGHIERE' , '3' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '4.20' ) 07/10/2023 08:50: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 ( '87627' , '12255' , 'IN CAMMINO CON GESU' , '23' , '0' , '4' , '3.80' , '3.8' , '0' , '50' , '43.70' ) 07/10/2023 08:50: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 ( '87627' , '15115' , 'CONVERSIONE - G. CELENTANO' , '1' , '0' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 07/10/2023 08:50: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 ( '87627' , '14223' , 'PRONTUARIO BIBLICO - LITURGICO - F. GIGLIO' , '1' , '0' , '4' , '9.00' , '9' , '0' , '50' , '4.50' ) 07/10/2023 08:50: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 ( '87627' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '4' , '0' , '4' , '1.00' , '1' , '0' , '50' , '2.00' ) 07/10/2023 08:50: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 ( '87627' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '2' , '0' , '4' , '1.00' , '1' , '0' , '50' , '1.00' ) 07/10/2023 08:50: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 ( '87627' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '2' , '0' , '4' , '15.00' , '15' , '0' , '50' , '15.00' ) 07/10/2023 08:50: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 ( '87627' , '17257' , 'IO TI BATTEZZO ' , '1' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '0.90' ) 07/10/2023 08:50: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 ( '87627' , '17695' , 'VIA LUCIS CON SAN CESARE DE BUS' , '1' , '0' , '4' , '3.80' , '3.8' , '0' , '50' , '1.90' ) 07/10/2023 08:50: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 ( '87627' , '17828' , 'ANGELO STRUFFOLINI - A.G. DIBISCEGLIA' , '1' , '0' , '4' , '26.00' , '26' , '0' , '50' , '13.00' ) 07/10/2023 08:50: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 ( '87627' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '1' , '0' , '4' , '12.00' , '12' , '0' , '50' , '6.00' ) 07/10/2023 08:50: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 ( '87627' , '18175' , 'VIA DI SAN GIUSEPPE - G. POLIDORO' , '3' , '0' , '4' , '4.80' , '4.8' , '0' , '50' , '7.20' ) 07/10/2023 08:50: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 ( '87627' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '3' , '0' , '4' , '15.00' , '15' , '0' , '50' , '22.50' ) 07/10/2023 08:50: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 ( '87627' , '17696' , 'VIA CRUCIS CON SAN CESARE DE BUS' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 07/10/2023 08:50: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 ( '87627' , '18528' , 'CON GESU VERSO IL CALVARIO - G. VALSECCHI' , '2' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '1.50' ) 07/10/2023 08:50: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 ( '87627' , '18497' , 'BUONA DOMENICA - ANNO A - G. BAGET BOZZO' , '2' , '0' , '4' , '16.00' , '16' , '0' , '50' , '16.00' ) 07/10/2023 08:50: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 ( '87627' , '18498' , 'BUONA DOMENICA - ANNO B - G. BAGET BOZZO' , '1' , '0' , '4' , '16.00' , '16' , '0' , '50' , '8.00' ) 07/10/2023 08:50: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 ( '87627' , '18499' , 'BUONA DOMENICA - ANNO C - G. BAGET BOZZO' , '1' , '0' , '4' , '16.00' , '16' , '0' , '50' , '8.00' ) 07/10/2023 08:50: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 ( '87627' , '18529' , 'SAN CESARE DE BUS - FUMETTO' , '3' , '0' , '4' , '5.00' , '5' , '0' , '50' , '7.50' ) 07/10/2023 08:50: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 ( '87627' , '18717' , 'ISTRUZIONI FAMILIARI VOL. II - I DIECI COMANDAMENTI ' , '2' , '0' , '4' , '20.00' , '20' , '0' , '50' , '20.00' ) 07/10/2023 08:50: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 ( '87627' , '18718' , 'TUA VOCE IN ME + CD - FRA F. MARIA REA' , '1' , '0' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 07/10/2023 08:50: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 ( '87627' , '18657' , 'HO DATO LORO LA TUA PAROLA - G. VALSECCHI' , '2' , '0' , '4' , '16.00' , '16' , '0' , '50' , '16.00' ) 07/10/2023 08:50: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 ( '87627' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '1' , '0' , '4' , '7.00' , '7' , '0' , '50' , '3.50' ) 07/10/2023 08:50: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 ( '87627' , '18423' , 'VIA DI SAN FRANCESCO - G. POLIDORO' , '1' , '0' , '4' , '4.80' , '4.8' , '0' , '50' , '2.40' ) 07/10/2023 08:50: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 ( '87627' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '5' , '0' , '4' , '9.00' , '9' , '0' , '50' , '22.50' ) 07/10/2023 08:50: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 ( '87627' , '18950' , 'DOVE FINITO IL CONCILIO? - F. CERRI' , '2' , '0' , '4' , '18.00' , '18' , '0' , '50' , '18.00' ) 07/10/2023 08:50: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 ( '87627' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '2' , '0' , '4' , '4.50' , '4.5' , '0' , '50' , '4.50' ) 07/10/2023 08:50: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 ( '87627' , '20231' , 'PREGANDO NON SPRECATE PAROLE - G. DAMORE' , '2' , '0' , '4' , '10.00' , '10' , '0' , '50' , '10.00' ) 07/10/2023 08:50: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 ( '87627' , '20640' , 'GESU, MOSSO A COMPASSIONE V. SALVOLDI' , '8' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '10.00' ) 07/10/2023 08:50:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87627' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '7' , '0' , '4' , '2.00' , '2' , '0' , '50' , '7.00' ) 07/10/2023 08:50:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87627' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '5' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '7.00' ) 07/10/2023 08:50:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87627' , '20951' , 'STORIE DEL NOSTRO TEMPO - F. CERRI' , '8' , '0' , '4' , '15.00' , '15' , '0' , '50' , '60.00' ) 07/10/2023 09:28:58 am >> SELECT document_num FROM ps_document WHERE document_num = '3063' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-07') 07/10/2023 09:28: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 ( '11' , '3063' , '2023-10-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.25' , '33.25' , NOW() , NOW() ) 07/10/2023 09:28: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 = '87628' 07/10/2023 09:28:58 am >> DELETE FROM ps_document_detail WHERE id_document = '87628' 07/10/2023 09:28: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 ( '87628' , '21507' , 'LITURGIA DELLE ORE VOL. I N.E.' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 07/10/2023 09:30:55 am >> SELECT document_num FROM ps_document WHERE document_num = '3063' AND id_document != '87628' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-07') 07/10/2023 09:30:55 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3063', document_date = '2023-10-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 = '3', id_causal = '0', price_tax_included = '33.25', price_tax_excluded = '33.25', date_upd = NOW() WHERE id_document = '87628' 07/10/2023 09:30:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87628' 07/10/2023 09:30:55 am >> DELETE FROM ps_document_detail WHERE id_document = '87628' 07/10/2023 09:30:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87628' , '21507' , 'LITURGIA DELLE ORE VOL. I N.E.' , '1' , '-1' , '4' , '35.0000' , '35' , '0' , '5' , '33.25' ) 07/10/2023 09:33:56 am >> SELECT document_num FROM ps_document WHERE document_num = '127' AND id_document != '87515' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-02') 07/10/2023 09:33:56 am >> UPDATE ps_document SET id_document_type = '21', document_num = '127', document_date = '2023-10-02', document_letter = '', id_customer = '3984', id_supplier = '', id_address = '4677546', address1 = 'P. ZZA SAN PAOLO, 14 12051 ALBA', address2 = '', note = 'RITIRA SEMINARISTA ROCCO', 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 = '167.87', price_tax_excluded = '167.87', date_upd = NOW() WHERE id_document = '87515' 07/10/2023 09:33:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87515' 07/10/2023 09:33:56 am >> DELETE FROM ps_document_detail WHERE id_document = '87515' 07/10/2023 09:33:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87515' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '4' , '-4' , '4' , '10.0000' , '10' , '0' , '15' , '34.00' ) 07/10/2023 09:33:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87515' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '8' , '-8' , '4' , '3.5000' , '3.5' , '0' , '15' , '23.80' ) 07/10/2023 09:33:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87515' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '7' , '-7' , '4' , '3.5000' , '3.5' , '0' , '15' , '20.82' ) 07/10/2023 09:33:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87515' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '2' , '-2' , '4' , '10.0000' , '10' , '0' , '15' , '17.00' ) 07/10/2023 09:33:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87515' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '5' , '-5' , '4' , '10.0000' , '10' , '0' , '15' , '42.50' ) 07/10/2023 09:33:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87515' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '10' , '-10' , '4' , '3.5000' , '3.5' , '0' , '15' , '29.75' ) 07/10/2023 09:34:43 am >> SELECT document_num FROM ps_document WHERE document_num = '3064' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-07') 07/10/2023 09:34:43 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' , '3064' , '2023-10-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.70' , '5.70' , NOW() , NOW() ) 07/10/2023 09:34:43 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 = '87629' 07/10/2023 09:34:43 am >> DELETE FROM ps_document_detail WHERE id_document = '87629' 07/10/2023 09:34:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87629' , '21645' , 'LAUDATE DEUM' , '3' , '-3' , '4' , '1.90' , '1.9' , '0' , '0' , '5.70' ) 07/10/2023 09:35:19 am >> SELECT document_num FROM ps_document WHERE document_num = '3065' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-07') 07/10/2023 09:35:19 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' , '3065' , '2023-10-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.50' , '1.50' , NOW() , NOW() ) 07/10/2023 09:35: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 = '87630' 07/10/2023 09:35:19 am >> DELETE FROM ps_document_detail WHERE id_document = '87630' 07/10/2023 09:35: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 ( '87630' , '21196' , 'CALENDARIO LITURGICO 2024' , '3' , '-3' , '4' , '0.50' , '0.5' , '0' , '0' , '1.50' ) 07/10/2023 09:35:53 am >> SELECT document_num FROM ps_document WHERE document_num = '3066' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-07') 07/10/2023 09:35:53 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' , '3066' , '2023-10-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.80' , '22.80' , NOW() , NOW() ) 07/10/2023 09:35:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87631' 07/10/2023 09:35:53 am >> DELETE FROM ps_document_detail WHERE id_document = '87631' 07/10/2023 09:35: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 ( '87631' , '12809' , 'SEDOTTI DALLA PAROLA - P. SCALABRINI' , '1' , '-1' , '4' , '24.00' , '24' , '0' , '5' , '22.80' ) 07/10/2023 10:22:09 am >> SELECT document_num FROM ps_document WHERE document_num = '3067' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-07') 07/10/2023 10:22: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 ( '11' , '3067' , '2023-10-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.80' , '14.59' , NOW() , NOW() ) 07/10/2023 10:22: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 = '87632' 07/10/2023 10:22:09 am >> DELETE FROM ps_document_detail WHERE id_document = '87632' 07/10/2023 10:22: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 ( '87632' , '11389' , 'VINO ROSSO DOLCE - 103' , '2' , '-2' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '17.80' ) 07/10/2023 10:30:29 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '221/23' , '2023-09-30' , '23' , '0' , '145' , '4670978' , 'VIA TORQUATO TASSO 10 24020 GORLE' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '457.60' , '440.00' , NOW() , NOW() ) 07/10/2023 10:30:29 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87633' 07/10/2023 10:30:29 am >> DELETE FROM ps_document_detail WHERE id_document = '87633' 07/10/2023 10:30: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 ( '87633' , '21418' , 'CRISTO NOSTRA PACE - V. SALVORDI' , '800' , '0' , '3' , '0.55' , '0.52884615384615' , '4' , '0' , '457.6000' ) 07/10/2023 10:30:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '21418' AND id_supplier = '145' 07/10/2023 10:30:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21418' , '145' , '1' ) 07/10/2023 11:43:38 am >> SELECT document_num FROM ps_document WHERE document_num = '3068' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-07') 07/10/2023 11:43: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' , '3068' , '2023-10-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.90' , '4.90' , NOW() , NOW() ) 07/10/2023 11:43: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 = '87634' 07/10/2023 11:43:38 am >> DELETE FROM ps_document_detail WHERE id_document = '87634' 07/10/2023 11:43: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 ( '87634' , '18667' , 'SCOPRIAMO LA CRESIMA' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '0' , '4.90' ) 07/10/2023 11:47:33 am >> SELECT document_num FROM ps_document WHERE document_num = '3069' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-07') 07/10/2023 11:47:33 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' , '3069' , '2023-10-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.80' , '3.11' , NOW() , NOW() ) 07/10/2023 11:47:33 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87635' 07/10/2023 11:47:33 am >> DELETE FROM ps_document_detail WHERE id_document = '87635' 07/10/2023 11:47:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87635' , '1290' , 'BRACCIALE 7 DONI - 820/07' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 07/10/2023 11:58:05 am >> SELECT document_num FROM ps_document WHERE document_num = '137' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-07') 07/10/2023 11:58:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '137' , '2023-10-07' , '' , '2843' , '0' , '4673405' , 'V. PICENZA, 63 BIS 84131 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '285.60' , '285.60' , NOW() , NOW() ) 07/10/2023 11:58:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87636' 07/10/2023 11:58:05 am >> DELETE FROM ps_document_detail WHERE id_document = '87636' 07/10/2023 11:58:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87636' , '5457' , 'IO SONO CON VOI 1 PARTE' , '30' , '-30' , '4' , '2.80' , '2.8' , '0' , '15' , '71.40' ) 07/10/2023 11:58:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87636' , '5458' , 'IO SONO CON VOI 2 PARTE' , '30' , '-30' , '4' , '2.80' , '2.8' , '0' , '15' , '71.40' ) 07/10/2023 11:58:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87636' , '11191' , 'VENITE CON ME 1 PARTE' , '30' , '-30' , '4' , '2.80' , '2.8' , '0' , '15' , '71.40' ) 07/10/2023 11:58:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87636' , '11192' , 'VENITE CON ME 2 PARTE' , '30' , '-30' , '4' , '2.80' , '2.8' , '0' , '15' , '71.40' ) 07/10/2023 12:01:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '3070' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-07') 07/10/2023 12:01:47 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' , '3070' , '2023-10-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.65' , '27.65' , NOW() , NOW() ) 07/10/2023 12:01:47 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 = '87637' 07/10/2023 12:01:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '87637' 07/10/2023 12:01:47 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 ( '87637' , '21645' , 'LAUDATE DEUM' , '10' , '-10' , '4' , '1.90' , '1.9' , '0' , '0' , '19.00' ) 07/10/2023 12:01:47 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 ( '87637' , '19301' , 'VERGINE DEL SILENZIO - 8068' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '' , '2.00' ) 07/10/2023 12:01:47 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 ( '87637' , '13633' , 'SAN LUIGI MARIA DI MONTFORT' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 07/10/2023 12:04:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '3071' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-07') 07/10/2023 12:04: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' , '3071' , '2023-10-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.90' , '27.82' , NOW() , NOW() ) 07/10/2023 12:04: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 = '87638' 07/10/2023 12:04:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '87638' 07/10/2023 12:04: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 ( '87638' , '13005' , 'PASSAPORTO DEL CATECHISTA' , '15' , '-15' , '4' , '1.20' , '1.2' , '0' , '0' , '18.00' ) 07/10/2023 12:04: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 ( '87638' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '7' , '-7' , '4' , '0.70' , '0.7' , '0' , '0' , '4.90' ) 07/10/2023 12:04: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 ( '87638' , '12819' , 'REGISTRO DEL CATECHISTA ' , '6' , '-6' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '6.00' ) 07/10/2023 12:10:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '3072' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-07') 07/10/2023 12:10:03 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3072' , '2023-10-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.50' , '15.16' , NOW() , NOW() ) 07/10/2023 12:10:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87639' 07/10/2023 12:10:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '87639' 07/10/2023 12:10:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87639' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '37' , '-37' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '18.50' ) 07/10/2023 12:10:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '3073' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-07') 07/10/2023 12:10:20 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' , '3073' , '2023-10-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.20' , '4.20' , NOW() , NOW() ) 07/10/2023 12:10:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87640' 07/10/2023 12:10:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '87640' 07/10/2023 12:10:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87640' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '6' , '-6' , '4' , '0.70' , '0.7' , '0' , '0' , '4.20' ) 07/10/2023 12:22:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '3074' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-07') 07/10/2023 12:22:28 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3074' , '2023-10-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.50' , '34.94' , NOW() , NOW() ) 07/10/2023 12:22:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87641' 07/10/2023 12:22:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '87641' 07/10/2023 12:22:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87641' , '9181' , 'ROSARIO S. BENEDETTO LEGNO - 0341870BR' , '1' , '-1' , '1' , '4.00' , '3.2786885245902' , '22' , '0' , '4.00' ) 07/10/2023 12:22:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87641' , '20067' , 'CATENINA CON MED. SAN BENEDETTO - NS047' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 07/10/2023 12:22:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87641' , '4402' , 'GESÙ CONFIDO IN TE - 111' , '1' , '-1' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '0.15' ) 07/10/2023 12:22:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87641' , '17734' , 'VANGELO E ATTI BAMBINI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 07/10/2023 12:22:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87641' , '21529' , 'PREGHIERE PER IL CATECHISMO' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 07/10/2023 12:22:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87641' , '8855' , 'REGISTRO DEL CATECHISTA' , '2' , '-2' , '1' , '0.75' , '0.61475409836066' , '22' , '0' , '1.50' ) 07/10/2023 12:22:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87641' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 07/10/2023 12:22:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87641' , '18647' , 'SCOPRIAMO INSIEME AVVENTO E NATALE' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 07/10/2023 12:22:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87641' , '2679' , 'CONOSCERE GESU' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 07/10/2023 12:22:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87641' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '1' , '-1' , '4' , '3.40' , '3.4' , '0' , '5' , '3.23' ) 07/10/2023 12:22:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87641' , '4154' , 'FESTA DEL PERDONO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 07/10/2023 12:22:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87641' , '8408' , 'PRENDETE E MANGIATE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 07/10/2023 12:22:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87641' , '21594' , 'CARTONCINO 16X23' , '1' , '-1' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '0.50' ) 07/10/2023 12:33:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '3075' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-07') 07/10/2023 12:33:14 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3075' , '2023-10-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.10' , '7.29' , NOW() , NOW() ) 07/10/2023 12:33:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87642' 07/10/2023 12:33:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '87642' 07/10/2023 12:33:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87642' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '3' , '-3' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '4.50' ) 07/10/2023 12:33:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87642' , '11151' , 'LIBRI' , '3' , '-3' , '4' , '1.2' , '1.2' , '0' , '0' , '3.60' ) 07/10/2023 12:43:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '3076' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-07') 07/10/2023 12:43:07 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' , '3076' , '2023-10-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.00' , '18.85' , NOW() , NOW() ) 07/10/2023 12:43:07 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 = '87643' 07/10/2023 12:43:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '87643' 07/10/2023 12:43:08 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 ( '87643' , '3193' , 'CROCIFISSO ULIVO SMUSSATO CM 21' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 07/10/2023 12:43:08 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 ( '87643' , '3058' , 'CROCE MURRINA ' , '2' , '-2' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '6.00' ) 07/10/2023 12:43:08 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 ( '87643' , '20066' , 'CATENINA IN ACCIAIO - NS055' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 07/10/2023 12:46:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '43' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-10-07') 07/10/2023 12:46:20 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' , '43' , '2023-10-07' , '' , '0' , '43' , '2638' , 'VIA COSTABIANCA, 43 60025 LORETO' , '' , 'RESA MATERIALE NON CONFORME ALL\'ORDINE' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 07/10/2023 12:46:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87644' 07/10/2023 12:46:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '87644' 07/10/2023 12:46:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87644' , '21649' , 'MEDAGLIA DORATA - VOLPICELLI' , '1000' , '-1000' , '1' , '0' , '0' , '22' , '0' , '0.00' ) 07/10/2023 12:46:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21649' AND id_supplier = '43' 07/10/2023 12:46:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21649' , '43' , '1' ) 07/10/2023 01:01:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '3077' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-07') 07/10/2023 01:01:04 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' , '3077' , '2023-10-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '94.00' , '77.05' , NOW() , NOW() ) 07/10/2023 01:01:04 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 = '87645' 07/10/2023 01:01:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '87645' 07/10/2023 01:01:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87645' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '1' , '-1' , '1' , '36' , '29.508196721311' , '22' , '0' , '36.00' ) 07/10/2023 01:01:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87645' , '16461' , 'CLERGY NIDO DAPE ML - C 22' , '1' , '-1' , '1' , '58.00' , '47.540983606557' , '22' , '0' , '58.00' )