27/04/2023 08:24:33 am >> SELECT document_num FROM ps_document WHERE document_num = '22' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-04-27') 27/04/2023 08:24: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 ( '24' , '22' , '2023-04-27' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , 'resa c/deposito' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '778.00' , '778.00' , NOW() , NOW() ) 27/04/2023 08:24: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 = '82966' 27/04/2023 08:24:33 am >> DELETE FROM ps_document_detail WHERE id_document = '82966' 27/04/2023 08:24: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 ( '82966' , '20911' , 'SOGNO DA VIVERE INSIEME' , '4' , '-4' , '4' , '9.0000' , '9' , '0' , '0' , '36.00' ) 27/04/2023 08:24:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '20911' AND id_supplier = '109' 27/04/2023 08:24:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20911' , '109' , '1' ) 27/04/2023 08:24: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 ( '82966' , '20912' , 'FALSI MITI' , '5' , '-5' , '4' , '10.0000' , '10' , '0' , '0' , '50.00' ) 27/04/2023 08:24:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '20912' AND id_supplier = '109' 27/04/2023 08:24:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20912' , '109' , '1' ) 27/04/2023 08:24: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 ( '82966' , '20913' , 'RIFARSI UNA VITA' , '5' , '-5' , '4' , '10.0000' , '10' , '0' , '0' , '50.00' ) 27/04/2023 08:24:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '20913' AND id_supplier = '109' 27/04/2023 08:24:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20913' , '109' , '1' ) 27/04/2023 08:24: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 ( '82966' , '13152' , 'RAGAZZI IN PANCHINA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 27/04/2023 08:24:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '13152' AND id_supplier = '109' 27/04/2023 08:24:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13152' , '109' , '1' ) 27/04/2023 08:24: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 ( '82966' , '20914' , 'CI VUOLE UN FIORE' , '7' , '-7' , '4' , '10.0000' , '10' , '0' , '0' , '70.00' ) 27/04/2023 08:24:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '20914' AND id_supplier = '109' 27/04/2023 08:24:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20914' , '109' , '1' ) 27/04/2023 08:24: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 ( '82966' , '20915' , 'PER PICCINA CHE TU SIA' , '7' , '-7' , '4' , '10.0000' , '10' , '0' , '0' , '70.00' ) 27/04/2023 08:24:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '20915' AND id_supplier = '109' 27/04/2023 08:24:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20915' , '109' , '1' ) 27/04/2023 08:24: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 ( '82966' , '20916' , 'ZAINO DA RIEMPIRE' , '2' , '-2' , '4' , '10.0000' , '10' , '0' , '0' , '20.00' ) 27/04/2023 08:24:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '20916' AND id_supplier = '109' 27/04/2023 08:24:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20916' , '109' , '1' ) 27/04/2023 08:24: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 ( '82966' , '20903' , 'CARITAS SPES FIDES - BENEDETTO XVI' , '6' , '-6' , '4' , '19.0000' , '19' , '0' , '0' , '114.00' ) 27/04/2023 08:24:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '20903' AND id_supplier = '109' 27/04/2023 08:24:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20903' , '109' , '1' ) 27/04/2023 08:24:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82966' , '20917' , 'GESU E IL CREATO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 27/04/2023 08:24:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '20917' AND id_supplier = '109' 27/04/2023 08:24:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20917' , '109' , '1' ) 27/04/2023 08:24:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82966' , '19382' , 'REGNO DEI CIELI E PIENO COMPIMENTO - E. MANICARDI' , '1' , '-1' , '4' , '21.0000' , '21' , '0' , '0' , '21.00' ) 27/04/2023 08:24:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '19382' AND id_supplier = '109' 27/04/2023 08:24:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19382' , '109' , '1' ) 27/04/2023 08:24:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82966' , '20918' , 'TOTUM AMORIS EST' , '7' , '-7' , '4' , '4.0000' , '4' , '0' , '0' , '28.00' ) 27/04/2023 08:24:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '20918' AND id_supplier = '109' 27/04/2023 08:24:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20918' , '109' , '1' ) 27/04/2023 08:24:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82966' , '20919' , 'GESU DI NAZARET NELLE CULTURE DEL SUO TEMPO' , '3' , '-3' , '4' , '22.0000' , '22' , '0' , '0' , '66.00' ) 27/04/2023 08:24:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '20919' AND id_supplier = '109' 27/04/2023 08:24:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20919' , '109' , '1' ) 27/04/2023 08:24:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82966' , '20921' , 'ESODO DELLA PAROLA - P. STEFANI' , '5' , '-5' , '4' , '32.0000' , '32' , '0' , '0' , '160.00' ) 27/04/2023 08:24:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '20921' AND id_supplier = '109' 27/04/2023 08:24:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20921' , '109' , '1' ) 27/04/2023 08:24:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82966' , '20922' , 'TRASMETTERE UN VANGELO DI LIBERTA - C. THEOBALD' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 27/04/2023 08:24:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '20922' AND id_supplier = '109' 27/04/2023 08:24:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20922' , '109' , '1' ) 27/04/2023 08:24:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82966' , '20417' , 'NON SARA SUBITO LA FINE - G. ZANCHI' , '4' , '-4' , '4' , '12.0000' , '12' , '0' , '0' , '48.00' ) 27/04/2023 08:24:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '20417' AND id_supplier = '109' 27/04/2023 08:24:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20417' , '109' , '1' ) 27/04/2023 09:02:31 am >> SELECT document_num FROM ps_document WHERE document_num = '1372' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-27') 27/04/2023 09:02:31 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1372' , '2023-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.90' , '3.36' , NOW() , NOW() ) 27/04/2023 09:02:31 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82967' 27/04/2023 09:02:31 am >> DELETE FROM ps_document_detail WHERE id_document = '82967' 27/04/2023 09:02:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82967' , '18213' , 'BRACCIALE CROCI COLORATO - BC569' , '3' , '-3' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '3.00' ) 27/04/2023 09:02:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82967' , '6629' , 'MIA PREGHIERA' , '1' , '-1' , '4' , '0.90' , '0.9' , '0' , '0' , '0.90' ) 27/04/2023 09:25:19 am >> SELECT document_num FROM ps_document WHERE document_num = '1100' AND id_document != '82611' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-03') 27/04/2023 09:25:19 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1100', document_date = '2023-04-03', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '55.00', price_tax_excluded = '54.45', date_upd = NOW() WHERE id_document = '82611' 27/04/2023 09:25: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 = '82611' 27/04/2023 09:25:19 am >> DELETE FROM ps_document_detail WHERE id_document = '82611' 27/04/2023 09:25: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 ( '82611' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '10.50' ) 27/04/2023 09:25: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 ( '82611' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '3.80' ) 27/04/2023 09:25: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 ( '82611' , '15020' , 'PREGARE OGNI GIORNO' , '2' , '-2' , '4' , '0.92' , '0.92' , '0' , '0' , '1.84' ) 27/04/2023 09:25: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 ( '82611' , '8274' , 'PREGHIERA DEI FEDELI NEI GIORNI FERIALI - 1 - TEMPI FORTI' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '5' , '23.75' ) 27/04/2023 09:25:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82611' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 27/04/2023 09:25:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82611' , '20766' , 'AMEN - GIU 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 27/04/2023 09:35:04 am >> SELECT document_num FROM ps_document WHERE document_num = '1373' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-27') 27/04/2023 09:35:04 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' , '1373' , '2023-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '54.80' , '46.45' , NOW() , NOW() ) 27/04/2023 09:35:04 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 = '82968' 27/04/2023 09:35:04 am >> DELETE FROM ps_document_detail WHERE id_document = '82968' 27/04/2023 09:35: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 ( '82968' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 27/04/2023 09:35: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 ( '82968' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 27/04/2023 09:35: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 ( '82968' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '3.80' ) 27/04/2023 09:35: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 ( '82968' , '7911' , 'PERGAMENE - 1A COMUNIONE MOD. B' , '48' , '-48' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '24.00' ) 27/04/2023 09:57:47 am >> SELECT document_num FROM ps_document WHERE document_num = '1374' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-27') 27/04/2023 09:57: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' , '1374' , '2023-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.65' , '34.85' , NOW() , NOW() ) 27/04/2023 09:57: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 = '82969' 27/04/2023 09:57:47 am >> DELETE FROM ps_document_detail WHERE id_document = '82969' 27/04/2023 09:57: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 ( '82969' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '12' , '12' , '0' , '0' , '12.00' ) 27/04/2023 09:57: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 ( '82969' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '4' , '-4' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '16.00' ) 27/04/2023 09:57: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 ( '82969' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 27/04/2023 09:57: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 ( '82969' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '1' , '-1' , '1' , '1' , '0.81967213114754' , '22' , '0' , '1.00' ) 27/04/2023 10:01:22 am >> SELECT document_num FROM ps_document WHERE document_num = '1375' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-27') 27/04/2023 10:01:22 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1375' , '2023-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.50' , '46.86' , NOW() , NOW() ) 27/04/2023 10:01: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 = '82970' 27/04/2023 10:01:22 am >> DELETE FROM ps_document_detail WHERE id_document = '82970' 27/04/2023 10:01: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 ( '82970' , '11384' , 'VINO BIANCO DOLCE - 102' , '3' , '-3' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '25.50' ) 27/04/2023 10:01: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 ( '82970' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 27/04/2023 10:01: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 ( '82970' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 27/04/2023 10:03:36 am >> SELECT document_num FROM ps_document WHERE document_num = '1376' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-27') 27/04/2023 10:03:36 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' , '1376' , '2023-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.55' , '8.55' , NOW() , NOW() ) 27/04/2023 10:03: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 = '82971' 27/04/2023 10:03:36 am >> DELETE FROM ps_document_detail WHERE id_document = '82971' 27/04/2023 10:03: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 ( '82971' , '10712' , 'TRATTATO DELLA VERA DEVOZIONE A MARIA - 8113' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 27/04/2023 10:11:10 am >> SELECT document_num FROM ps_document WHERE document_num = '1377' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-27') 27/04/2023 10:11:10 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' , '1377' , '2023-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.85' , '23.97' , NOW() , NOW() ) 27/04/2023 10:11: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 = '82972' 27/04/2023 10:11:10 am >> DELETE FROM ps_document_detail WHERE id_document = '82972' 27/04/2023 10:11: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 ( '82972' , '19560' , 'PERGAMENA 17X25' , '7' , '-7' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '4.90' ) 27/04/2023 10:11: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 ( '82972' , '17734' , 'VANGELO E ATTI BAMBINI' , '7' , '-7' , '4' , '3.00' , '3' , '0' , '5' , '19.95' ) 27/04/2023 10:20:33 am >> SELECT document_num FROM ps_document WHERE document_num = '1378' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-27') 27/04/2023 10:20: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' , '1378' , '2023-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '304.00' , '249.18' , NOW() , NOW() ) 27/04/2023 10:20: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 = '82973' 27/04/2023 10:20:33 am >> DELETE FROM ps_document_detail WHERE id_document = '82973' 27/04/2023 10:20: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 ( '82973' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.3' , '2.7049180327869' , '22' , '0' , '99.00' ) 27/04/2023 10:20: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 ( '82973' , '15666' , 'MIRACOLOSA CM 60 - PA602' , '1' , '-1' , '1' , '205.00' , '168.03278688525' , '22' , '0' , '205.00' ) 27/04/2023 10:21:07 am >> SELECT document_num FROM ps_document WHERE document_num = '1379' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-27') 27/04/2023 10:21:07 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' , '1379' , '2023-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.25' , '14.25' , NOW() , NOW() ) 27/04/2023 10:21:07 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 = '82974' 27/04/2023 10:21:07 am >> DELETE FROM ps_document_detail WHERE id_document = '82974' 27/04/2023 10:21:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82974' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '5' , '14.25' ) 27/04/2023 10:25:39 am >> SELECT document_num FROM ps_document WHERE document_num = '1380' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-27') 27/04/2023 10:25:39 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' , '1380' , '2023-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.70' , '30.90' , NOW() , NOW() ) 27/04/2023 10:25: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 = '82975' 27/04/2023 10:25:39 am >> DELETE FROM ps_document_detail WHERE id_document = '82975' 27/04/2023 10:25: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 ( '82975' , '13799' , 'CROCETTA CONFESSIONE - 2370/J44' , '13' , '-13' , '1' , '2.90' , '2.3770491803279' , '22' , '0' , '37.70' ) 27/04/2023 10:25:52 am >> SELECT document_num FROM ps_document WHERE document_num = '1381' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-27') 27/04/2023 10:25:52 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' , '1381' , '2023-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.90' , '4.02' , NOW() , NOW() ) 27/04/2023 10:25:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82976' 27/04/2023 10:25:52 am >> DELETE FROM ps_document_detail WHERE id_document = '82976' 27/04/2023 10:25:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82976' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 27/04/2023 10:26:50 am >> SELECT document_num FROM ps_document WHERE document_num = '1382' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-27') 27/04/2023 10:26:50 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' , '1382' , '2023-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.85' , '24.65' , NOW() , NOW() ) 27/04/2023 10:26:50 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 = '82977' 27/04/2023 10:26:50 am >> DELETE FROM ps_document_detail WHERE id_document = '82977' 27/04/2023 10:26:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82977' , '18373' , 'COMMENTI AI VANGELI - BENEDETTO XVI' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 27/04/2023 10:26:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82977' , '5536' , 'LACCIO' , '1' , '-1' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '0.70' ) 27/04/2023 10:26:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82977' , '3028' , 'CROCE MET. 3T.OX CM 4,5 - G299 ' , '1' , '-1' , '1' , '0.40' , '0.32786885245902' , '22' , '0' , '0.40' ) 27/04/2023 10:36:53 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '7911' 27/04/2023 10:36:53 am >> UPDATE ps_stock_available SET quantity = quantity + '-587' WHERE id_product = '7911' 27/04/2023 10:38:36 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '9073' 27/04/2023 10:38:36 am >> UPDATE ps_stock_available SET quantity = quantity + '-3' WHERE id_product = '9073' 27/04/2023 11:04:49 am >> SELECT document_num FROM ps_document WHERE document_num = '1383' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-27') 27/04/2023 11:04:49 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' , '1383' , '2023-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '94.53' , '94.53' , NOW() , NOW() ) 27/04/2023 11:04:49 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 = '82978' 27/04/2023 11:04:49 am >> DELETE FROM ps_document_detail WHERE id_document = '82978' 27/04/2023 11:04:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82978' , '18509' , 'MANUALE DEL PARROCO - L. CHIAPPETTA' , '1' , '-1' , '4' , '99.50' , '99.5' , '0' , '5' , '94.53' ) 27/04/2023 11:07:56 am >> SELECT document_num FROM ps_document WHERE document_num = '53/A' AND id_document != '82763' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-12') 27/04/2023 11:07:56 am >> UPDATE ps_document SET id_document_type = '24', document_num = '53/A', document_date = '2023-04-12', document_letter = 'A', id_customer = '357', id_supplier = '', id_address = '4676034', address1 = 'VIA TORRIONE 84100 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '118.40', price_tax_excluded = '111.55', date_upd = NOW() WHERE id_document = '82763' 27/04/2023 11:07: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 = '82763' 27/04/2023 11:07:56 am >> DELETE FROM ps_document_detail WHERE id_document = '82763' 27/04/2023 11:07: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 ( '82763' , '13322' , 'IMMAGINI 70X100 GESU\' MISERICORDIOSO' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 27/04/2023 11:07: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 ( '82763' , '19742' , 'ENCICLICHE SOCIALI' , '1' , '-1' , '4' , '49.0000' , '49' , '0' , '5' , '46.55' ) 27/04/2023 11:07: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 ( '82763' , '3978' , 'EUCARISTIA: RITO E VITA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 27/04/2023 11:07: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 ( '82763' , '3419' , 'DIARIO LA MISERICORDIA DIVINA - S. FAUSTINA K.' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '5' , '12.35' ) 27/04/2023 11:07: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 ( '82763' , '11151' , 'LIBRI immagini misericordioso' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 27/04/2023 11:07: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 ( '82763' , '0' , '27/03/2023' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 27/04/2023 11:07: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 ( '82763' , '19106' , 'FRAGRANZA NARDO' , '2' , '-2' , '1' , '16.0000' , '13.114754098361' , '22' , '0' , '32.00' ) 27/04/2023 11:09:03 am >> SELECT document_num FROM ps_document WHERE document_num = '77' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-04-27') 27/04/2023 11:09:03 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '77' , '2023-04-27' , '' , '357' , '0' , '4676034' , 'VIA TORRIONE 84100 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '34.50' , '34.50' , NOW() , NOW() ) 27/04/2023 11:09:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82979' 27/04/2023 11:09:03 am >> DELETE FROM ps_document_detail WHERE id_document = '82979' 27/04/2023 11:09: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 ( '82979' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '15' , '8.50' ) 27/04/2023 11:09: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 ( '82979' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '15' , '8.50' ) 27/04/2023 11:09: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 ( '82979' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '15' , '8.50' ) 27/04/2023 11:09: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 ( '82979' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3' , '3' , '0' , '' , '3.00' ) 27/04/2023 11:09: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 ( '82979' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 27/04/2023 11:09: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 ( '82979' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 27/04/2023 11:11:51 am >> SELECT document_num FROM ps_document WHERE document_num = '1384' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-27') 27/04/2023 11:11:51 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' , '1384' , '2023-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.40' , '11.80' , NOW() , NOW() ) 27/04/2023 11:11:51 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 = '82980' 27/04/2023 11:11:51 am >> DELETE FROM ps_document_detail WHERE id_document = '82980' 27/04/2023 11:11:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82980' , '15085' , 'BRACCIALE DECINA COLORATA - BC506' , '12' , '-12' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '14.40' ) 27/04/2023 11:40:16 am >> SELECT document_num FROM ps_document WHERE document_num = '1385' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-27') 27/04/2023 11:40:16 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' , '1385' , '2023-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '270.00' , '225.21' , NOW() , NOW() ) 27/04/2023 11:40:16 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 = '82981' 27/04/2023 11:40:16 am >> DELETE FROM ps_document_detail WHERE id_document = '82981' 27/04/2023 11:40:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82981' , '17400' , 'MIRACOLOSA CM 40 - 805' , '1' , '-1' , '1' , '80.5' , '65.983606557377' , '22' , '0' , '80.50' ) 27/04/2023 11:40:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82981' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '108' , '-108' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '162.00' ) 27/04/2023 11:40:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82981' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 27/04/2023 11:40:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82981' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 27/04/2023 12:10:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '1386' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-27') 27/04/2023 12:10:31 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' , '1386' , '2023-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.50' , '11.07' , NOW() , NOW() ) 27/04/2023 12:10:31 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 = '82982' 27/04/2023 12:10:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '82982' 27/04/2023 12:10:31 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 ( '82982' , '20705' , 'CANDELA CUBO' , '1' , '-1' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '13.50' ) 27/04/2023 12:58:31 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '7934' 27/04/2023 12:58:31 pm >> UPDATE ps_stock_available SET quantity = quantity + '-5' WHERE id_product = '7934' 27/04/2023 12:58:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '1387' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-27') 27/04/2023 12:58:48 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' , '1387' , '2023-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '92.50' , '75.82' , NOW() , NOW() ) 27/04/2023 12:58:48 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 = '82983' 27/04/2023 12:58:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '82983' 27/04/2023 12:58:48 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 ( '82983' , '15334' , 'CANDELA VOTIVA 20X40' , '20' , '-20' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '16.00' ) 27/04/2023 12:58:48 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 ( '82983' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 27/04/2023 12:58:48 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 ( '82983' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 27/04/2023 12:58:48 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 ( '82983' , '7931' , 'PERGAMENE - CRESIMA MOD. A' , '27' , '-27' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '13.50' ) 27/04/2023 01:00:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '1388' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-27') 27/04/2023 01:00:17 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' , '1388' , '2023-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '117.00' , '117.00' , NOW() , NOW() ) 27/04/2023 01:00:17 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 = '82984' 27/04/2023 01:00:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '82984' 27/04/2023 01:00:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82984' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '26' , '-26' , '4' , '4.5' , '4.5' , '0' , '0' , '117.00' ) 27/04/2023 01:00:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '1389' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-27') 27/04/2023 01:00:34 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' , '1389' , '2023-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 27/04/2023 01:00:34 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 = '82985' 27/04/2023 01:00:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '82985' 27/04/2023 01:00:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82985' , '20801' , 'PREGHIERA RESPIRO DELLANIMA - PAPA FRANCESCO' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 27/04/2023 02:13:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '1021' AND id_document != '82523' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-29') 27/04/2023 02:13:35 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1021', document_date = '2023-03-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '8.50', price_tax_excluded = '6.97', date_upd = NOW() WHERE id_document = '82523' 27/04/2023 02:13:35 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82523' 27/04/2023 02:13:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '82523' 27/04/2023 02:13:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82523' , '16190' , 'VESTINA BATTESIMALE CANDELA/FONTE' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 27/04/2023 02:13:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82523' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '4' , '-4' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '1.00' ) 27/04/2023 02:13:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82523' , '16311' , 'DECINA MISSIONARIA' , '3' , '-3' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '1.50' ) 27/04/2023 03:27:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '1390' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-27') 27/04/2023 03:27:17 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' , '1390' , '2023-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.48' , '19.48' , NOW() , NOW() ) 27/04/2023 03:27:17 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 = '82986' 27/04/2023 03:27:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '82986' 27/04/2023 03:27:17 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 ( '82986' , '18444' , 'ORDINAMENTO GENERALE DEL NUOVO MESSALE ROMANO - N.E.' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 27/04/2023 03:27:17 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 ( '82986' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 27/04/2023 03:35:42 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1889' 27/04/2023 03:35:43 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '1889' , '10' , '176' , 'PARR. SAN FRANCESCO' , 'CAPPÉ ' , 'DON CESARE' , 'VIA VERDI, 43' , '' , '54033' , 'CARRARA' , '' , '0585/71884' , '' , '' , '' , NOW() , NOW() ) 27/04/2023 03:35:43 pm >> UPDATE ps_customer SET email = 'cesare.cappe@alice.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1889' 27/04/2023 03:36:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '15' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-04-27') 27/04/2023 03:36:53 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '15' , '2023-04-27' , '' , '1889' , '0' , '130686727' , 'VIA VERDI, 43 54033 CARRARA' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '87.18' , '87.18' , NOW() , NOW() ) 27/04/2023 03:36:53 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 = '11065' 27/04/2023 03:36:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '11065' 27/04/2023 03:36:53 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 ( '11065' , '125' , 'MIE PREGHIERINE - N. E.' , '25' , '-25' , '4' , '1.50' , '1.5' , '0' , '5' , '35.63' ) 27/04/2023 03:36:53 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 ( '11065' , '126' , 'SACRAMENTO DEL PERDONO' , '10' , '-10' , '4' , '2.00' , '2' , '0' , '5' , '19.00' ) 27/04/2023 03:36:53 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 ( '11065' , '89' , 'COMUNIONE SPIEGATA AI RAGAZZI' , '15' , '-15' , '4' , '1.80' , '1.8' , '0' , '5' , '25.65' ) 27/04/2023 03:49:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '1391' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-27') 27/04/2023 03:49:19 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' , '1391' , '2023-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.20' , '15.20' , NOW() , NOW() ) 27/04/2023 03:49:19 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 = '82987' 27/04/2023 03:49:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '82987' 27/04/2023 03:49:19 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 ( '82987' , '20928' , 'CHI E MARIA? - C. MAGGIONI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 27/04/2023 04:02:11 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1889' 27/04/2023 04:02:11 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '1889' , '10' , '176' , 'PARROCCHIA SAN FRANCESCO' , 'CAPPÉ ' , 'DON CESARE' , 'VIA VERDI, 43' , '' , '54033' , 'CARRARA' , '' , '0585/71884' , '' , '' , '' , NOW() , NOW() ) 27/04/2023 04:02:11 pm >> UPDATE ps_customer SET email = 'cesare.cappe@alice.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1889' 27/04/2023 04:14:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '1392' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-27') 27/04/2023 04:14:41 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' , '1392' , '2023-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.00' , '39.34' , NOW() , NOW() ) 27/04/2023 04:14:41 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 = '82988' 27/04/2023 04:14:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '82988' 27/04/2023 04:14:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82988' , '15406' , 'CROCE IN POLIMERO - CRESIMA - 2381/K0161' , '16' , '-16' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '48.00' ) 27/04/2023 04:36:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '1393' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-27') 27/04/2023 04:36:31 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' , '1393' , '2023-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.25' , '14.25' , NOW() , NOW() ) 27/04/2023 04:36:31 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 = '82989' 27/04/2023 04:36:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '82989' 27/04/2023 04:36:31 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 ( '82989' , '18197' , 'COME SALE E LIEVITO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 27/04/2023 05:15:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '1394' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-27') 27/04/2023 05:15: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' , '1394' , '2023-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.25' , '52.25' , NOW() , NOW() ) 27/04/2023 05:15: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 = '82990' 27/04/2023 05:15:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '82990' 27/04/2023 05:15: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 ( '82990' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '11' , '-11' , '4' , '5' , '5' , '0' , '5' , '52.25' ) 27/04/2023 05:29:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '1395' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-27') 27/04/2023 05:29:21 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' , '1395' , '2023-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.40' , '46.23' , NOW() , NOW() ) 27/04/2023 05:29:21 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 = '82991' 27/04/2023 05:29:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '82991' 27/04/2023 05:29:21 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 ( '82991' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 27/04/2023 06:01:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '1355' AND id_document != '82941' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-26') 27/04/2023 06:01:29 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1355', 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 = '15.60', price_tax_excluded = '14.23', date_upd = NOW() WHERE id_document = '82941' 27/04/2023 06:01:29 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 = '82941' 27/04/2023 06:01:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '82941' 27/04/2023 06:01:30 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 ( '82941' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '0.58' , '0.58' , '0' , '0' , '0.58' ) 27/04/2023 06:01:30 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 ( '82941' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.8000' , '3.1147540983607' , '22' , '0' , '7.60' ) 27/04/2023 06:01:30 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 ( '82941' , '20765' , 'AMEN - MAG 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 27/04/2023 06:01:30 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 ( '82941' , '20766' , 'AMEN - GIU 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 27/04/2023 06:02:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '1368' AND id_document != '82962' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-26') 27/04/2023 06:02:09 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1368', 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 = '73.00', price_tax_excluded = '61.10', date_upd = NOW() WHERE id_document = '82962' 27/04/2023 06:02:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82962' 27/04/2023 06:02:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '82962' 27/04/2023 06:02:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82962' , '1350' , 'BRACCIALETTO CON CROCE - 29002 03' , '22' , '-22' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '66.00' ) 27/04/2023 06:02:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82962' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '1' , '-1' , '4' , '2.25' , '2.25' , '0' , '' , '2.25' ) 27/04/2023 06:02:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82962' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 27/04/2023 06:37:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '1396' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-27') 27/04/2023 06:37:51 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' , '1396' , '2023-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '142.00' , '116.39' , NOW() , NOW() ) 27/04/2023 06:37:51 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 = '82992' 27/04/2023 06:37:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '82992' 27/04/2023 06:37:51 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 ( '82992' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 27/04/2023 06:37:51 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 ( '82992' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '40' , '-40' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '56.00' ) 27/04/2023 06:37:51 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 ( '82992' , '12817' , 'LIBRO DEI MATRIMONI' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '10' , '36.00' ) 27/04/2023 07:06:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '1397' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-27') 27/04/2023 07:06:32 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' , '1397' , '2023-04-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '45.00' , NOW() , NOW() ) 27/04/2023 07:06:32 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 = '82993' 27/04/2023 07:06:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '82993' 27/04/2023 07:06:32 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 ( '82993' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '45' , '45' , '0' , '0' , '45.00' )