18/04/2023 08:12:32 am >> SELECT document_num FROM ps_document WHERE document_num = '/A' AND id_document != '82843' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-17') 18/04/2023 08:12:32 am >> UPDATE ps_document SET id_document_type = '24', document_num = '/A', document_date = '2023-04-17', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '415.00', price_tax_excluded = '415.00', date_upd = NOW() WHERE id_document = '82843' 18/04/2023 08:12:32 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 = '82843' 18/04/2023 08:12:32 am >> DELETE FROM ps_document_detail WHERE id_document = '82843' 18/04/2023 08:12:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '2' , '-2' , '4' , '12.0000' , '12' , '0' , '0' , '24.00' ) 18/04/2023 08:12:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '19615' , 'DOVE LA VITA NON VUOLE MORIRE - F. ACCROCCA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/04/2023 08:12:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '19941' , 'SEMINATORI DI SPERANZA - AAVV' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 18/04/2023 08:12:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20424' , 'ABBI CURA DI ME - S. CRISTICCHI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 18/04/2023 08:12:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '15464' , 'PRIMA DI GIUDICARE PENSA - S. NOE' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 08:12:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '16268' , 'NOSTRA MADRE TERRA - PAPA FRANCESCO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 18/04/2023 08:12: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 ( '82843' , '17578' , 'CIELO SULLA TERRA - PAPA FRANCESCO' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 18/04/2023 08:12: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 ( '82843' , '20237' , 'SIATE FELICI - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 18/04/2023 08:12: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 ( '82843' , '20654' , 'CONQUISTA LA PACE - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 18/04/2023 08:12: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 ( '82843' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '3' , '-3' , '4' , '15.0000' , '15' , '0' , '0' , '45.00' ) 18/04/2023 08:12: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 ( '82843' , '18036' , 'FERITE FERITOIE ' , '2' , '-2' , '4' , '8.0000' , '8' , '0' , '0' , '16.00' ) 18/04/2023 08:12: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 ( '82843' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '2' , '-2' , '4' , '12.0000' , '12' , '0' , '0' , '24.00' ) 18/04/2023 08:12: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 ( '82843' , '14260' , 'CUORE CHE BATTE - TORNARE AD AMARE IL CREATO' , '3' , '-3' , '4' , '8.0000' , '8' , '0' , '0' , '24.00' ) 18/04/2023 08:12: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 ( '82843' , '18261' , 'PIETRA SCARTATA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 18/04/2023 08:12: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 ( '82843' , '19588' , 'SCELTA DI ENEA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 18/04/2023 08:12: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 ( '82843' , '19360' , 'IN PRINCIPIO ERANO FRATELLI - L. EPICOCO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 18/04/2023 08:12: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 ( '82843' , '17001' , 'SPERANZA NON E MORTA - L. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 18/04/2023 08:12: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 ( '82843' , '20656' , 'PAURA COME DONO - PAPA FRANCESCO' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 18/04/2023 08:12: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 ( '82843' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 18/04/2023 08:12: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 ( '82843' , '16884' , 'ARTE DI GUARIRE - F. ROSINI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 18/04/2023 08:12: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 ( '82843' , '13432' , 'ARTE DI RICOMINCIARE - F. ROSINI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 18/04/2023 08:12: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 ( '82843' , '18751' , 'CAMMINARE INSIEME - A. LANDI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 18/04/2023 08:12: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 ( '82843' , '20745' , 'SPERANZA CHE CERCHI - F. CRISTOFARO' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 18/04/2023 09:09:56 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') 18/04/2023 09:09:56 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' 18/04/2023 09:09: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 = '82611' 18/04/2023 09:09:56 am >> DELETE FROM ps_document_detail WHERE id_document = '82611' 18/04/2023 09:09: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 ( '82611' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '10.50' ) 18/04/2023 09:09: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 ( '82611' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '3.80' ) 18/04/2023 09:09: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 ( '82611' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '5.55' , '5.55' , '0' , '0' , '5.55' ) 18/04/2023 09:09: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 ( '82611' , '8274' , 'PREGHIERA DEI FEDELI NEI GIORNI FERIALI - 1 - TEMPI FORTI' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '5' , '23.75' ) 18/04/2023 09:09: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 ( '82611' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 18/04/2023 09:11:50 am >> SELECT document_num FROM ps_document WHERE document_num = '1223' AND id_document != '82771' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-12') 18/04/2023 09:11:50 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1223', document_date = '2023-04-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 = '85.00', price_tax_excluded = '77.79', date_upd = NOW() WHERE id_document = '82771' 18/04/2023 09:11: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 = '82771' 18/04/2023 09:11:50 am >> DELETE FROM ps_document_detail WHERE id_document = '82771' 18/04/2023 09: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 ( '82771' , '20118' , 'FATIMA CM 44 - 1035' , '1' , '-1' , '1' , '38.0000' , '31.147540983607' , '22' , '0' , '38.00' ) 18/04/2023 09: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 ( '82771' , '15104' , 'ROSARIO BOTTIGLIA ' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 18/04/2023 09: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 ( '82771' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 18/04/2023 09: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 ( '82771' , '19914' , 'FORZA DELLE VIRTU - C.M. MARTINI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 18/04/2023 09: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 ( '82771' , '20641' , 'ENCICLICA SULLA PACE IN UCRAINA ' , '1' , '-1' , '4' , '13.65' , '13.65' , '0' , '' , '13.65' ) 18/04/2023 09:12:32 am >> SELECT document_num FROM ps_document WHERE document_num = '1137' AND id_document != '82658' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-04') 18/04/2023 09:12:32 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1137', document_date = '2023-04-04', 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 = '238.00', price_tax_excluded = '197.43', date_upd = NOW() WHERE id_document = '82658' 18/04/2023 09:12:32 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 = '82658' 18/04/2023 09:12:32 am >> DELETE FROM ps_document_detail WHERE id_document = '82658' 18/04/2023 09:12:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82658' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '135.0000' , '110.65573770492' , '22' , '0' , '135.00' ) 18/04/2023 09:12:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82658' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '5.4' , '5.4' , '0' , '0' , '5.40' ) 18/04/2023 09:12:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82658' , '1220' , 'BICCHIERI FLAMBEAUX - PZ. 50' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 18/04/2023 09:12:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82658' , '14163' , 'PARACERA OTTONE LUCIDO - Q120' , '1' , '-1' , '1' , '45.0000' , '36.885245901639' , '22' , '0' , '45.00' ) 18/04/2023 09:12:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82658' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 18/04/2023 09:12:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82658' , '18036' , 'FERITE FERITOIE ' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 18/04/2023 09:30:11 am >> SELECT document_num FROM ps_document WHERE document_num = '1282' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-18') 18/04/2023 09:30:11 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' , '1282' , '2023-04-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 18/04/2023 09:30:11 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 = '82850' 18/04/2023 09:30:11 am >> DELETE FROM ps_document_detail WHERE id_document = '82850' 18/04/2023 09:30:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82850' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 18/04/2023 10:54:16 am >> SELECT document_num FROM ps_document WHERE document_num = '1283' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-18') 18/04/2023 10:54: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' , '1283' , '2023-04-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.20' , '3.44' , NOW() , NOW() ) 18/04/2023 10:54: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 = '82851' 18/04/2023 10:54:16 am >> DELETE FROM ps_document_detail WHERE id_document = '82851' 18/04/2023 10:54: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 ( '82851' , '15085' , 'BRACCIALE DECINA COLORATA - BC506' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 18/04/2023 10:54: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 ( '82851' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 18/04/2023 11:22:37 am >> SELECT document_num FROM ps_document WHERE document_num = '/A' AND id_document != '82843' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-17') 18/04/2023 11:22:37 am >> UPDATE ps_document SET id_document_type = '24', document_num = '/A', document_date = '2023-04-17', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '745.50', price_tax_excluded = '745.50', date_upd = NOW() WHERE id_document = '82843' 18/04/2023 11:22:37 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 = '82843' 18/04/2023 11:22:37 am >> DELETE FROM ps_document_detail WHERE id_document = '82843' 18/04/2023 11:22:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '2' , '-2' , '4' , '12.0000' , '12' , '0' , '0' , '24.00' ) 18/04/2023 11:22:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '19615' , 'DOVE LA VITA NON VUOLE MORIRE - F. ACCROCCA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/04/2023 11:22:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '19941' , 'SEMINATORI DI SPERANZA - AAVV' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 18/04/2023 11:22:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20424' , 'ABBI CURA DI ME - S. CRISTICCHI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 18/04/2023 11:22:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '15464' , 'PRIMA DI GIUDICARE PENSA - S. NOE' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 11:22:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '16268' , 'NOSTRA MADRE TERRA - PAPA FRANCESCO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 18/04/2023 11:22:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '17578' , 'CIELO SULLA TERRA - PAPA FRANCESCO' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 18/04/2023 11:22:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20237' , 'SIATE FELICI - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 18/04/2023 11:22:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20654' , 'CONQUISTA LA PACE - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 18/04/2023 11:22:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '3' , '-3' , '4' , '15.0000' , '15' , '0' , '0' , '45.00' ) 18/04/2023 11:22:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '18036' , 'FERITE FERITOIE ' , '2' , '-2' , '4' , '8.0000' , '8' , '0' , '0' , '16.00' ) 18/04/2023 11:22:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '2' , '-2' , '4' , '12.0000' , '12' , '0' , '0' , '24.00' ) 18/04/2023 11:22:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '14260' , 'CUORE CHE BATTE - TORNARE AD AMARE IL CREATO' , '3' , '-3' , '4' , '8.0000' , '8' , '0' , '0' , '24.00' ) 18/04/2023 11:22:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '18261' , 'PIETRA SCARTATA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 11:22:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '19588' , 'SCELTA DI ENEA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 11:22:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '19360' , 'IN PRINCIPIO ERANO FRATELLI - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/04/2023 11:22:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '17001' , 'SPERANZA NON E MORTA - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/04/2023 11:22:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20656' , 'PAURA COME DONO - PAPA FRANCESCO' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 18/04/2023 11:22:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 18/04/2023 11:22:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '16884' , 'ARTE DI GUARIRE - F. ROSINI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 11:22:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '13432' , 'ARTE DI RICOMINCIARE - F. ROSINI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 11:22:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '18751' , 'CAMMINARE INSIEME - A. LANDI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 18/04/2023 11:22:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20745' , 'SPERANZA CHE CERCHI - F. CRISTOFARO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 18/04/2023 11:22:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '15816' , 'CI HA REDENTI CON IL TUO SANGUE - L. EPICOCO ' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 18/04/2023 11:22:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '10060' , 'SOLO I MALATI GUARISCONO - L. EPICOCO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 18/04/2023 11:22: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 ( '82843' , '16019' , 'MARTA, MARIA E LAZZARO - L. EPICOCO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 18/04/2023 11:22: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 ( '82843' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '3' , '-3' , '4' , '12.00' , '12' , '0' , '0' , '36.00' ) 18/04/2023 11:22: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 ( '82843' , '18920' , 'LUCE IN FONDO - L. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 18/04/2023 11:22: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 ( '82843' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 18/04/2023 11:22: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 ( '82843' , '17127' , 'STABILI E CREDIBILI - L. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 18/04/2023 11:22: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 ( '82843' , '10064' , 'SOLO LAMORE CREA - F. ROSINI' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 18/04/2023 11:22: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 ( '82843' , '12995' , 'SALE, NON MIELE - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 18/04/2023 11:22: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 ( '82843' , '15996' , 'TELEMACO NON SI SBAGLIAVA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 18/04/2023 11:22: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 ( '82843' , '20816' , 'FRANCESCANESIMO DI UN PAPA GESUITA - M. SEMERARO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 18/04/2023 11:22: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 ( '82843' , '20878' , 'PROCESSO A FRANCESCO - E. FORTUNATO' , '1' , '-1' , '4' , '17.50' , '17.5' , '0' , '0' , '17.50' ) 18/04/2023 11:22: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 ( '82843' , '20740' , 'MIA VITA AUTOBIOGRAFIA BENEDETTO XVI - J. RATZINGER' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 18/04/2023 11:22: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 ( '82843' , '20639' , 'CATECHISMO DELLA VITA SPIRITUALE - R. SARAH' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '0' , '25.00' ) 18/04/2023 11:22: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 ( '82843' , '20903' , 'CARITAS SPES FIDES - BENEDETTO XVI' , '1' , '-1' , '4' , '19.00' , '19' , '0' , '0' , '19.00' ) 18/04/2023 11:22: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 ( '82843' , '20625' , 'DIO E SEMPRE NUOVO - RATZINGER' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '0' , '13.00' ) 18/04/2023 11:22: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 ( '82843' , '14260' , 'CUORE CHE BATTE - TORNARE AD AMARE IL CREATO' , '5' , '-5' , '4' , '8.00' , '8' , '0' , '0' , '40.00' ) 18/04/2023 11:22: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 ( '82843' , '18657' , 'HO DATO LORO LA TUA PAROLA - G. VALSECCHI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 18/04/2023 11:22: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 ( '82843' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '0' , '20.00' ) 18/04/2023 11:28:33 am >> SELECT document_num FROM ps_document WHERE document_num = '70' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-04-18') 18/04/2023 11:28: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 ( '21' , '70' , '2023-04-18' , '' , '1122' , '0' , '4673712' , 'VIA MENEGAZZI 3 44022 COMACCHIO' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '15.91' , '15.91' , NOW() , NOW() ) 18/04/2023 11:28: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 = '82852' 18/04/2023 11:28:33 am >> DELETE FROM ps_document_detail WHERE id_document = '82852' 18/04/2023 11:28: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 ( '82852' , '2448' , 'COLUI IN CUI CREDO' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '15' , '2.13' ) 18/04/2023 11:28: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 ( '82852' , '1829' , 'CATECHISMO PRIMARIO DEI SACRAMENTI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '15' , '2.98' ) 18/04/2023 11:28: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 ( '82852' , '17861' , 'CARTA DIDENTITA DELLA CHIESA - R. LUPI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '15' , '2.13' ) 18/04/2023 11:28: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 ( '82852' , '7824' , 'PER ILLUMINARE IL CAMMINO' , '1' , '-1' , '4' , '0.90' , '0.9' , '0' , '15' , '0.77' ) 18/04/2023 11:28: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 ( '82852' , '' , 'contrassegno' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 18/04/2023 12:16:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '/A' AND id_document != '82843' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-17') 18/04/2023 12:16:43 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '/A', document_date = '2023-04-17', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '847.20', price_tax_excluded = '847.20', date_upd = NOW() WHERE id_document = '82843' 18/04/2023 12:16:43 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 = '82843' 18/04/2023 12:16:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '82843' 18/04/2023 12:16:43 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 ( '82843' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '2' , '-2' , '4' , '12.0000' , '12' , '0' , '0' , '24.00' ) 18/04/2023 12:16:43 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 ( '82843' , '19615' , 'DOVE LA VITA NON VUOLE MORIRE - F. ACCROCCA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/04/2023 12:16:43 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 ( '82843' , '19941' , 'SEMINATORI DI SPERANZA - AAVV' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 18/04/2023 12:16:43 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 ( '82843' , '20424' , 'ABBI CURA DI ME - S. CRISTICCHI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 18/04/2023 12:16:43 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 ( '82843' , '15464' , 'PRIMA DI GIUDICARE PENSA - S. NOE' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:16:43 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 ( '82843' , '16268' , 'NOSTRA MADRE TERRA - PAPA FRANCESCO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 18/04/2023 12:16:43 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 ( '82843' , '17578' , 'CIELO SULLA TERRA - PAPA FRANCESCO' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 18/04/2023 12:16:43 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 ( '82843' , '20237' , 'SIATE FELICI - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 18/04/2023 12:16:43 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 ( '82843' , '20654' , 'CONQUISTA LA PACE - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 18/04/2023 12:16:43 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 ( '82843' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '3' , '-3' , '4' , '15.0000' , '15' , '0' , '0' , '45.00' ) 18/04/2023 12:16:43 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 ( '82843' , '18036' , 'FERITE FERITOIE ' , '2' , '-2' , '4' , '8.0000' , '8' , '0' , '0' , '16.00' ) 18/04/2023 12:16:43 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 ( '82843' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '2' , '-2' , '4' , '12.0000' , '12' , '0' , '0' , '24.00' ) 18/04/2023 12:16:43 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 ( '82843' , '14260' , 'CUORE CHE BATTE - TORNARE AD AMARE IL CREATO' , '3' , '-3' , '4' , '8.0000' , '8' , '0' , '0' , '24.00' ) 18/04/2023 12:16:43 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 ( '82843' , '18261' , 'PIETRA SCARTATA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:16:43 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 ( '82843' , '19588' , 'SCELTA DI ENEA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:16:43 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 ( '82843' , '19360' , 'IN PRINCIPIO ERANO FRATELLI - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/04/2023 12:16:43 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 ( '82843' , '17001' , 'SPERANZA NON E MORTA - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/04/2023 12:16:43 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 ( '82843' , '20656' , 'PAURA COME DONO - PAPA FRANCESCO' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 18/04/2023 12:16:44 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 ( '82843' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 18/04/2023 12:16:44 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 ( '82843' , '16884' , 'ARTE DI GUARIRE - F. ROSINI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:16:44 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 ( '82843' , '13432' , 'ARTE DI RICOMINCIARE - F. ROSINI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:16:44 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 ( '82843' , '18751' , 'CAMMINARE INSIEME - A. LANDI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 18/04/2023 12:16:44 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 ( '82843' , '20745' , 'SPERANZA CHE CERCHI - F. CRISTOFARO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 18/04/2023 12:16:44 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 ( '82843' , '15816' , 'CI HA REDENTI CON IL TUO SANGUE - L. EPICOCO ' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/04/2023 12:16:44 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 ( '82843' , '10060' , 'SOLO I MALATI GUARISCONO - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/04/2023 12:16:44 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 ( '82843' , '16019' , 'MARTA, MARIA E LAZZARO - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/04/2023 12:16:44 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 ( '82843' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '3' , '-3' , '4' , '12.0000' , '12' , '0' , '0' , '36.00' ) 18/04/2023 12:16:44 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 ( '82843' , '18920' , 'LUCE IN FONDO - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/04/2023 12:16:44 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 ( '82843' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:16:44 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 ( '82843' , '17127' , 'STABILI E CREDIBILI - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/04/2023 12:16:44 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 ( '82843' , '10064' , 'SOLO LAMORE CREA - F. ROSINI' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 18/04/2023 12:16:44 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 ( '82843' , '12995' , 'SALE, NON MIELE - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:16:44 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 ( '82843' , '15996' , 'TELEMACO NON SI SBAGLIAVA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:16:44 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 ( '82843' , '20816' , 'FRANCESCANESIMO DI UN PAPA GESUITA - M. SEMERARO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/04/2023 12:16:44 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 ( '82843' , '20878' , 'PROCESSO A FRANCESCO - E. FORTUNATO' , '1' , '-1' , '4' , '17.5000' , '17.5' , '0' , '0' , '17.50' ) 18/04/2023 12:16:44 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 ( '82843' , '20740' , 'MIA VITA AUTOBIOGRAFIA BENEDETTO XVI - J. RATZINGER' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:16:44 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 ( '82843' , '20639' , 'CATECHISMO DELLA VITA SPIRITUALE - R. SARAH' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 18/04/2023 12:16:44 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 ( '82843' , '20903' , 'CARITAS SPES FIDES - BENEDETTO XVI' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 18/04/2023 12:16:44 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 ( '82843' , '20625' , 'DIO E SEMPRE NUOVO - RATZINGER' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 18/04/2023 12:16:44 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 ( '82843' , '14260' , 'CUORE CHE BATTE - TORNARE AD AMARE IL CREATO' , '5' , '-5' , '4' , '8.0000' , '8' , '0' , '0' , '40.00' ) 18/04/2023 12:16:44 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 ( '82843' , '18657' , 'HO DATO LORO LA TUA PAROLA - G. VALSECCHI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:16:44 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 ( '82843' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 18/04/2023 12:16:44 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 ( '82843' , '20494' , 'TI VOGLIO FELICE - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.90' , '16.9' , '0' , '0' , '16.90' ) 18/04/2023 12:16:44 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 ( '82843' , '20801' , 'PREGHIERA RESPIRO DELLANIMA - PAPA FRANCESCO' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '0' , '20.00' ) 18/04/2023 12:16:44 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 ( '82843' , '20856' , 'LASCIA CHE DIO TI ACCAREZZI - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:16:44 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 ( '82843' , '20794' , 'CERCA IL TUO ORIZZONTE ' , '1' , '-1' , '4' , '16.90' , '16.9' , '0' , '0' , '16.90' ) 18/04/2023 12:16:44 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 ( '82843' , '20654' , 'CONQUISTA LA PACE - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '0' , '17.00' ) 18/04/2023 12:16:44 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 ( '82843' , '19388' , 'NOI CREDIAMO - PAPA FRANCESCO' , '1' , '-1' , '4' , '14.90' , '14.9' , '0' , '0' , '14.90' ) 18/04/2023 12:18:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '/A' AND id_document != '82843' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-17') 18/04/2023 12:18:11 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '/A', document_date = '2023-04-17', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '828.20', price_tax_excluded = '828.20', date_upd = NOW() WHERE id_document = '82843' 18/04/2023 12:18:11 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 = '82843' 18/04/2023 12:18:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '82843' 18/04/2023 12:18:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '2' , '-2' , '4' , '12.0000' , '12' , '0' , '0' , '24.00' ) 18/04/2023 12:18:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '19615' , 'DOVE LA VITA NON VUOLE MORIRE - F. ACCROCCA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/04/2023 12:18:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '19941' , 'SEMINATORI DI SPERANZA - AAVV' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 18/04/2023 12:18:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20424' , 'ABBI CURA DI ME - S. CRISTICCHI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 18/04/2023 12:18:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '15464' , 'PRIMA DI GIUDICARE PENSA - S. NOE' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:18:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '16268' , 'NOSTRA MADRE TERRA - PAPA FRANCESCO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 18/04/2023 12:18:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '17578' , 'CIELO SULLA TERRA - PAPA FRANCESCO' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 18/04/2023 12:18:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20237' , 'SIATE FELICI - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 18/04/2023 12:18:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20654' , 'CONQUISTA LA PACE - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 18/04/2023 12:18:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '3' , '-3' , '4' , '15.0000' , '15' , '0' , '0' , '45.00' ) 18/04/2023 12:18:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '18036' , 'FERITE FERITOIE ' , '2' , '-2' , '4' , '8.0000' , '8' , '0' , '0' , '16.00' ) 18/04/2023 12:18:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '2' , '-2' , '4' , '12.0000' , '12' , '0' , '0' , '24.00' ) 18/04/2023 12:18:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '14260' , 'CUORE CHE BATTE - TORNARE AD AMARE IL CREATO' , '3' , '-3' , '4' , '8.0000' , '8' , '0' , '0' , '24.00' ) 18/04/2023 12:18:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '18261' , 'PIETRA SCARTATA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:18:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '19588' , 'SCELTA DI ENEA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:18:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '19360' , 'IN PRINCIPIO ERANO FRATELLI - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/04/2023 12:18:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '17001' , 'SPERANZA NON E MORTA - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/04/2023 12:18:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20656' , 'PAURA COME DONO - PAPA FRANCESCO' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 18/04/2023 12:18:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 18/04/2023 12:18:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '16884' , 'ARTE DI GUARIRE - F. ROSINI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:18:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '13432' , 'ARTE DI RICOMINCIARE - F. ROSINI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:18:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '18751' , 'CAMMINARE INSIEME - A. LANDI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 18/04/2023 12:18:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20745' , 'SPERANZA CHE CERCHI - F. CRISTOFARO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 18/04/2023 12:18:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '15816' , 'CI HA REDENTI CON IL TUO SANGUE - L. EPICOCO ' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/04/2023 12:18:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '10060' , 'SOLO I MALATI GUARISCONO - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/04/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '16019' , 'MARTA, MARIA E LAZZARO - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/04/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '3' , '-3' , '4' , '12.0000' , '12' , '0' , '0' , '36.00' ) 18/04/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '18920' , 'LUCE IN FONDO - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/04/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '17127' , 'STABILI E CREDIBILI - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/04/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '10064' , 'SOLO LAMORE CREA - F. ROSINI' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 18/04/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '12995' , 'SALE, NON MIELE - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '15996' , 'TELEMACO NON SI SBAGLIAVA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20816' , 'FRANCESCANESIMO DI UN PAPA GESUITA - M. SEMERARO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/04/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20878' , 'PROCESSO A FRANCESCO - E. FORTUNATO' , '1' , '-1' , '4' , '17.5000' , '17.5' , '0' , '0' , '17.50' ) 18/04/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20740' , 'MIA VITA AUTOBIOGRAFIA BENEDETTO XVI - J. RATZINGER' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20639' , 'CATECHISMO DELLA VITA SPIRITUALE - R. SARAH' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 18/04/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20625' , 'DIO E SEMPRE NUOVO - RATZINGER' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 18/04/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '14260' , 'CUORE CHE BATTE - TORNARE AD AMARE IL CREATO' , '5' , '-5' , '4' , '8.0000' , '8' , '0' , '0' , '40.00' ) 18/04/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '18657' , 'HO DATO LORO LA TUA PAROLA - G. VALSECCHI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 18/04/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20494' , 'TI VOGLIO FELICE - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.9000' , '16.9' , '0' , '0' , '16.90' ) 18/04/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20801' , 'PREGHIERA RESPIRO DELLANIMA - PAPA FRANCESCO' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 18/04/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20856' , 'LASCIA CHE DIO TI ACCAREZZI - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20794' , 'CERCA IL TUO ORIZZONTE ' , '1' , '-1' , '4' , '16.9000' , '16.9' , '0' , '0' , '16.90' ) 18/04/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20654' , 'CONQUISTA LA PACE - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 18/04/2023 12:18:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '19388' , 'NOI CREDIAMO - PAPA FRANCESCO' , '1' , '-1' , '4' , '14.9000' , '14.9' , '0' , '0' , '14.90' ) 18/04/2023 12:48:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '/A' AND id_document != '82843' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-17') 18/04/2023 12:48:39 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '/A', document_date = '2023-04-17', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '888.20', price_tax_excluded = '888.20', date_upd = NOW() WHERE id_document = '82843' 18/04/2023 12:48:39 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 = '82843' 18/04/2023 12:48:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '82843' 18/04/2023 12:48:39 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 ( '82843' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '2' , '-2' , '4' , '12.0000' , '12' , '0' , '0' , '24.00' ) 18/04/2023 12:48:39 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 ( '82843' , '19615' , 'DOVE LA VITA NON VUOLE MORIRE - F. ACCROCCA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/04/2023 12:48:39 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 ( '82843' , '19941' , 'SEMINATORI DI SPERANZA - AAVV' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 18/04/2023 12:48:39 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 ( '82843' , '20424' , 'ABBI CURA DI ME - S. CRISTICCHI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 18/04/2023 12:48:39 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 ( '82843' , '15464' , 'PRIMA DI GIUDICARE PENSA - S. NOE' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:48:39 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 ( '82843' , '16268' , 'NOSTRA MADRE TERRA - PAPA FRANCESCO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 18/04/2023 12:48:39 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 ( '82843' , '17578' , 'CIELO SULLA TERRA - PAPA FRANCESCO' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 18/04/2023 12:48:39 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 ( '82843' , '20237' , 'SIATE FELICI - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 18/04/2023 12:48:39 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 ( '82843' , '20654' , 'CONQUISTA LA PACE - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 18/04/2023 12:48:39 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 ( '82843' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '3' , '-3' , '4' , '15.0000' , '15' , '0' , '0' , '45.00' ) 18/04/2023 12:48:39 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 ( '82843' , '18036' , 'FERITE FERITOIE ' , '2' , '-2' , '4' , '8.0000' , '8' , '0' , '0' , '16.00' ) 18/04/2023 12:48:39 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 ( '82843' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '2' , '-2' , '4' , '12.0000' , '12' , '0' , '0' , '24.00' ) 18/04/2023 12:48:39 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 ( '82843' , '14260' , 'CUORE CHE BATTE - TORNARE AD AMARE IL CREATO' , '3' , '-3' , '4' , '8.0000' , '8' , '0' , '0' , '24.00' ) 18/04/2023 12:48:39 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 ( '82843' , '18261' , 'PIETRA SCARTATA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:48:39 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 ( '82843' , '19588' , 'SCELTA DI ENEA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:48:39 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 ( '82843' , '19360' , 'IN PRINCIPIO ERANO FRATELLI - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/04/2023 12:48:39 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 ( '82843' , '17001' , 'SPERANZA NON E MORTA - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/04/2023 12:48:39 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 ( '82843' , '20656' , 'PAURA COME DONO - PAPA FRANCESCO' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 18/04/2023 12:48:39 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 ( '82843' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 18/04/2023 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '16884' , 'ARTE DI GUARIRE - F. ROSINI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '13432' , 'ARTE DI RICOMINCIARE - F. ROSINI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '18751' , 'CAMMINARE INSIEME - A. LANDI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 18/04/2023 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20745' , 'SPERANZA CHE CERCHI - F. CRISTOFARO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 18/04/2023 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '15816' , 'CI HA REDENTI CON IL TUO SANGUE - L. EPICOCO ' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/04/2023 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '10060' , 'SOLO I MALATI GUARISCONO - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/04/2023 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '16019' , 'MARTA, MARIA E LAZZARO - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/04/2023 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '8' , '-8' , '4' , '12.0000' , '12' , '0' , '0' , '96.00' ) 18/04/2023 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '18920' , 'LUCE IN FONDO - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/04/2023 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '17127' , 'STABILI E CREDIBILI - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/04/2023 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '10064' , 'SOLO LAMORE CREA - F. ROSINI' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 18/04/2023 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '12995' , 'SALE, NON MIELE - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '15996' , 'TELEMACO NON SI SBAGLIAVA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20816' , 'FRANCESCANESIMO DI UN PAPA GESUITA - M. SEMERARO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/04/2023 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20878' , 'PROCESSO A FRANCESCO - E. FORTUNATO' , '1' , '-1' , '4' , '17.5000' , '17.5' , '0' , '0' , '17.50' ) 18/04/2023 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20740' , 'MIA VITA AUTOBIOGRAFIA BENEDETTO XVI - J. RATZINGER' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20639' , 'CATECHISMO DELLA VITA SPIRITUALE - R. SARAH' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 18/04/2023 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20625' , 'DIO E SEMPRE NUOVO - RATZINGER' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 18/04/2023 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '14260' , 'CUORE CHE BATTE - TORNARE AD AMARE IL CREATO' , '5' , '-5' , '4' , '8.0000' , '8' , '0' , '0' , '40.00' ) 18/04/2023 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '18657' , 'HO DATO LORO LA TUA PAROLA - G. VALSECCHI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 18/04/2023 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20494' , 'TI VOGLIO FELICE - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.9000' , '16.9' , '0' , '0' , '16.90' ) 18/04/2023 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20801' , 'PREGHIERA RESPIRO DELLANIMA - PAPA FRANCESCO' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 18/04/2023 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20856' , 'LASCIA CHE DIO TI ACCAREZZI - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20794' , 'CERCA IL TUO ORIZZONTE ' , '1' , '-1' , '4' , '16.9000' , '16.9' , '0' , '0' , '16.90' ) 18/04/2023 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20654' , 'CONQUISTA LA PACE - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 18/04/2023 12:48:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '19388' , 'NOI CREDIAMO - PAPA FRANCESCO' , '1' , '-1' , '4' , '14.9000' , '14.9' , '0' , '0' , '14.90' ) 18/04/2023 12:51:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '/A' AND id_document != '82843' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-17') 18/04/2023 12:51:38 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '/A', document_date = '2023-04-17', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '936.20', price_tax_excluded = '936.20', date_upd = NOW() WHERE id_document = '82843' 18/04/2023 12:51:38 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 = '82843' 18/04/2023 12:51:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '82843' 18/04/2023 12:51:38 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 ( '82843' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '2' , '-2' , '4' , '12.0000' , '12' , '0' , '0' , '24.00' ) 18/04/2023 12:51:38 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 ( '82843' , '19615' , 'DOVE LA VITA NON VUOLE MORIRE - F. ACCROCCA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/04/2023 12:51:38 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 ( '82843' , '19941' , 'SEMINATORI DI SPERANZA - AAVV' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 18/04/2023 12:51:38 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 ( '82843' , '20424' , 'ABBI CURA DI ME - S. CRISTICCHI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 18/04/2023 12:51:38 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 ( '82843' , '15464' , 'PRIMA DI GIUDICARE PENSA - S. NOE' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:51:38 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 ( '82843' , '16268' , 'NOSTRA MADRE TERRA - PAPA FRANCESCO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 18/04/2023 12:51:38 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 ( '82843' , '17578' , 'CIELO SULLA TERRA - PAPA FRANCESCO' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 18/04/2023 12:51:38 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 ( '82843' , '20237' , 'SIATE FELICI - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 18/04/2023 12:51:38 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 ( '82843' , '20654' , 'CONQUISTA LA PACE - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 18/04/2023 12:51:38 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 ( '82843' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '3' , '-3' , '4' , '15.0000' , '15' , '0' , '0' , '45.00' ) 18/04/2023 12:51:38 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 ( '82843' , '18036' , 'FERITE FERITOIE ' , '2' , '-2' , '4' , '8.0000' , '8' , '0' , '0' , '16.00' ) 18/04/2023 12:51:38 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 ( '82843' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '2' , '-2' , '4' , '12.0000' , '12' , '0' , '0' , '24.00' ) 18/04/2023 12:51:38 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 ( '82843' , '14260' , 'CUORE CHE BATTE - TORNARE AD AMARE IL CREATO' , '3' , '-3' , '4' , '8.0000' , '8' , '0' , '0' , '24.00' ) 18/04/2023 12:51:38 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 ( '82843' , '18261' , 'PIETRA SCARTATA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:51:38 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 ( '82843' , '19588' , 'SCELTA DI ENEA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:51:38 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 ( '82843' , '19360' , 'IN PRINCIPIO ERANO FRATELLI - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/04/2023 12:51:38 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 ( '82843' , '17001' , 'SPERANZA NON E MORTA - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/04/2023 12:51:38 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 ( '82843' , '20656' , 'PAURA COME DONO - PAPA FRANCESCO' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 18/04/2023 12:51:38 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 ( '82843' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 18/04/2023 12:51:38 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 ( '82843' , '16884' , 'ARTE DI GUARIRE - F. ROSINI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:51:38 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 ( '82843' , '13432' , 'ARTE DI RICOMINCIARE - F. ROSINI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:51:38 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 ( '82843' , '18751' , 'CAMMINARE INSIEME - A. LANDI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 18/04/2023 12:51:38 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 ( '82843' , '20745' , 'SPERANZA CHE CERCHI - F. CRISTOFARO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 18/04/2023 12:51:38 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 ( '82843' , '15816' , 'CI HA REDENTI CON IL TUO SANGUE - L. EPICOCO ' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/04/2023 12:51:38 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 ( '82843' , '10060' , 'SOLO I MALATI GUARISCONO - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/04/2023 12:51:39 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 ( '82843' , '16019' , 'MARTA, MARIA E LAZZARO - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/04/2023 12:51:39 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 ( '82843' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '8' , '-8' , '4' , '12.0000' , '12' , '0' , '0' , '96.00' ) 18/04/2023 12:51:39 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 ( '82843' , '18920' , 'LUCE IN FONDO - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/04/2023 12:51:39 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 ( '82843' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:51:39 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 ( '82843' , '17127' , 'STABILI E CREDIBILI - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/04/2023 12:51:39 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 ( '82843' , '10064' , 'SOLO LAMORE CREA - F. ROSINI' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 18/04/2023 12:51:39 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 ( '82843' , '12995' , 'SALE, NON MIELE - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:51:39 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 ( '82843' , '15996' , 'TELEMACO NON SI SBAGLIAVA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:51:39 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 ( '82843' , '20816' , 'FRANCESCANESIMO DI UN PAPA GESUITA - M. SEMERARO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/04/2023 12:51:39 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 ( '82843' , '20878' , 'PROCESSO A FRANCESCO - E. FORTUNATO' , '1' , '-1' , '4' , '17.5000' , '17.5' , '0' , '0' , '17.50' ) 18/04/2023 12:51:39 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 ( '82843' , '20740' , 'MIA VITA AUTOBIOGRAFIA BENEDETTO XVI - J. RATZINGER' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:51:39 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 ( '82843' , '20639' , 'CATECHISMO DELLA VITA SPIRITUALE - R. SARAH' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 18/04/2023 12:51:39 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 ( '82843' , '20625' , 'DIO E SEMPRE NUOVO - RATZINGER' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 18/04/2023 12:51:39 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 ( '82843' , '14260' , 'CUORE CHE BATTE - TORNARE AD AMARE IL CREATO' , '5' , '-5' , '4' , '8.0000' , '8' , '0' , '0' , '40.00' ) 18/04/2023 12:51:39 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 ( '82843' , '18657' , 'HO DATO LORO LA TUA PAROLA - G. VALSECCHI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:51:39 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 ( '82843' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 18/04/2023 12:51:39 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 ( '82843' , '20494' , 'TI VOGLIO FELICE - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.9000' , '16.9' , '0' , '0' , '16.90' ) 18/04/2023 12:51:39 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 ( '82843' , '20801' , 'PREGHIERA RESPIRO DELLANIMA - PAPA FRANCESCO' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 18/04/2023 12:51:39 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 ( '82843' , '20856' , 'LASCIA CHE DIO TI ACCAREZZI - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 12:51:39 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 ( '82843' , '20794' , 'CERCA IL TUO ORIZZONTE ' , '1' , '-1' , '4' , '16.9000' , '16.9' , '0' , '0' , '16.90' ) 18/04/2023 12:51:39 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 ( '82843' , '20654' , 'CONQUISTA LA PACE - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 18/04/2023 12:51:39 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 ( '82843' , '19388' , 'NOI CREDIAMO - PAPA FRANCESCO' , '1' , '-1' , '4' , '14.9000' , '14.9' , '0' , '0' , '14.90' ) 18/04/2023 12:51:39 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 ( '82843' , '15816' , 'CI HA REDENTI CON IL TUO SANGUE - L. EPICOCO ' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 18/04/2023 12:51:39 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 ( '82843' , '12705' , 'QUELLO CHE SEI PER ME - L. EPICOCO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 18/04/2023 12:51:39 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 ( '82843' , '17127' , 'STABILI E CREDIBILI - L. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 18/04/2023 12:51:39 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 ( '82843' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 18/04/2023 01:04:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '1284' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-18') 18/04/2023 01:04:24 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' , '1284' , '2023-04-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '110.00' , '91.17' , NOW() , NOW() ) 18/04/2023 01:04:24 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 = '82853' 18/04/2023 01:04:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '82853' 18/04/2023 01:04:24 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 ( '82853' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 18/04/2023 01:04:24 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 ( '82853' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8' , '6.5573770491803' , '22' , '0' , '48.00' ) 18/04/2023 01:04:24 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 ( '82853' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '1' , '-1' , '4' , '5.6' , '5.6' , '0' , '' , '5.60' ) 18/04/2023 02:42:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '/A' AND id_document != '82843' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-17') 18/04/2023 02:42:27 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '/A', document_date = '2023-04-17', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '717.20', price_tax_excluded = '717.20', date_upd = NOW() WHERE id_document = '82843' 18/04/2023 02:42:27 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 = '82843' 18/04/2023 02:42:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '82843' 18/04/2023 02:42:27 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 ( '82843' , '19615' , 'DOVE LA VITA NON VUOLE MORIRE - F. ACCROCCA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/04/2023 02:42:27 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 ( '82843' , '19941' , 'SEMINATORI DI SPERANZA - AAVV' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 18/04/2023 02:42:27 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 ( '82843' , '15464' , 'PRIMA DI GIUDICARE PENSA - S. NOE' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 02:42:27 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 ( '82843' , '17578' , 'CIELO SULLA TERRA - PAPA FRANCESCO' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 18/04/2023 02:42:27 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 ( '82843' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '3' , '-3' , '4' , '15.0000' , '15' , '0' , '0' , '45.00' ) 18/04/2023 02:42:27 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 ( '82843' , '18036' , 'FERITE FERITOIE ' , '2' , '-2' , '4' , '8.0000' , '8' , '0' , '0' , '16.00' ) 18/04/2023 02:42:27 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 ( '82843' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '2' , '-2' , '4' , '12.0000' , '12' , '0' , '0' , '24.00' ) 18/04/2023 02:42:27 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 ( '82843' , '16884' , 'ARTE DI GUARIRE - F. ROSINI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 02:42:27 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 ( '82843' , '13432' , 'ARTE DI RICOMINCIARE - F. ROSINI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 02:42:27 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 ( '82843' , '18751' , 'CAMMINARE INSIEME - A. LANDI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 18/04/2023 02:42:27 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 ( '82843' , '15816' , 'CI HA REDENTI CON IL TUO SANGUE - L. EPICOCO ' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/04/2023 02:42:27 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 ( '82843' , '10060' , 'SOLO I MALATI GUARISCONO - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/04/2023 02:42:27 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 ( '82843' , '16019' , 'MARTA, MARIA E LAZZARO - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/04/2023 02:42:27 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 ( '82843' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '8' , '-8' , '4' , '12.0000' , '12' , '0' , '0' , '96.00' ) 18/04/2023 02:42:27 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 ( '82843' , '18920' , 'LUCE IN FONDO - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/04/2023 02:42:27 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 ( '82843' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 02:42:27 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 ( '82843' , '17127' , 'STABILI E CREDIBILI - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/04/2023 02:42:27 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 ( '82843' , '10064' , 'SOLO LAMORE CREA - F. ROSINI' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 18/04/2023 02:42:27 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 ( '82843' , '12995' , 'SALE, NON MIELE - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 02:42:27 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 ( '82843' , '15996' , 'TELEMACO NON SI SBAGLIAVA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 02:42:27 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 ( '82843' , '20816' , 'FRANCESCANESIMO DI UN PAPA GESUITA - M. SEMERARO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/04/2023 02:42:27 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 ( '82843' , '20878' , 'PROCESSO A FRANCESCO - E. FORTUNATO' , '1' , '-1' , '4' , '17.5000' , '17.5' , '0' , '0' , '17.50' ) 18/04/2023 02:42: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 ( '82843' , '20740' , 'MIA VITA AUTOBIOGRAFIA BENEDETTO XVI - J. RATZINGER' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 02:42: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 ( '82843' , '20639' , 'CATECHISMO DELLA VITA SPIRITUALE - R. SARAH' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 18/04/2023 02:42: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 ( '82843' , '20625' , 'DIO E SEMPRE NUOVO - RATZINGER' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 18/04/2023 02:42: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 ( '82843' , '14260' , 'CUORE CHE BATTE - TORNARE AD AMARE IL CREATO' , '5' , '-5' , '4' , '8.0000' , '8' , '0' , '0' , '40.00' ) 18/04/2023 02:42: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 ( '82843' , '18657' , 'HO DATO LORO LA TUA PAROLA - G. VALSECCHI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 02:42: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 ( '82843' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 18/04/2023 02:42: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 ( '82843' , '20494' , 'TI VOGLIO FELICE - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.9000' , '16.9' , '0' , '0' , '16.90' ) 18/04/2023 02:42: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 ( '82843' , '20801' , 'PREGHIERA RESPIRO DELLANIMA - PAPA FRANCESCO' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 18/04/2023 02:42: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 ( '82843' , '20856' , 'LASCIA CHE DIO TI ACCAREZZI - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 02:42: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 ( '82843' , '20794' , 'CERCA IL TUO ORIZZONTE ' , '1' , '-1' , '4' , '16.9000' , '16.9' , '0' , '0' , '16.90' ) 18/04/2023 02:42: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 ( '82843' , '20654' , 'CONQUISTA LA PACE - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 18/04/2023 02:42: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 ( '82843' , '19388' , 'NOI CREDIAMO - PAPA FRANCESCO' , '1' , '-1' , '4' , '14.9000' , '14.9' , '0' , '0' , '14.90' ) 18/04/2023 02:42: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 ( '82843' , '15816' , 'CI HA REDENTI CON IL TUO SANGUE - L. EPICOCO ' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/04/2023 02:42: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 ( '82843' , '12705' , 'QUELLO CHE SEI PER ME - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/04/2023 02:42: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 ( '82843' , '17127' , 'STABILI E CREDIBILI - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/04/2023 02:42: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 ( '82843' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/04/2023 02:45:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '1285' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-18') 18/04/2023 02:45:52 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' , '1285' , '2023-04-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '219.00' , '219.00' , NOW() , NOW() ) 18/04/2023 02:45:52 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 = '82854' 18/04/2023 02:45:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '82854' 18/04/2023 02:45:52 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 ( '82854' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '2' , '-2' , '4' , '12.00' , '12' , '0' , '0' , '24.00' ) 18/04/2023 02:45:52 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 ( '82854' , '20424' , 'ABBI CURA DI ME - S. CRISTICCHI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 18/04/2023 02:45:52 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 ( '82854' , '16268' , 'NOSTRA MADRE TERRA - PAPA FRANCESCO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 18/04/2023 02:45:52 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 ( '82854' , '20237' , 'SIATE FELICI - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '0' , '17.00' ) 18/04/2023 02:45:52 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 ( '82854' , '20654' , 'CONQUISTA LA PACE - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '0' , '17.00' ) 18/04/2023 02:45:52 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 ( '82854' , '14260' , 'CUORE CHE BATTE - TORNARE AD AMARE IL CREATO' , '3' , '-3' , '4' , '8.00' , '8' , '0' , '0' , '24.00' ) 18/04/2023 02:45:52 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 ( '82854' , '18261' , 'PIETRA SCARTATA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 18/04/2023 02:45:52 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 ( '82854' , '19588' , 'SCELTA DI ENEA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 18/04/2023 02:45:52 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 ( '82854' , '19360' , 'IN PRINCIPIO ERANO FRATELLI - L. EPICOCO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 18/04/2023 02:45:52 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 ( '82854' , '17001' , 'SPERANZA NON E MORTA - L. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 18/04/2023 02:45:52 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 ( '82854' , '20656' , 'PAURA COME DONO - PAPA FRANCESCO' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 18/04/2023 02:45:52 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 ( '82854' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 18/04/2023 02:45:52 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 ( '82854' , '20745' , 'SPERANZA CHE CERCHI - F. CRISTOFARO' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 18/04/2023 02:46:10 pm >> DELETE FROM ps_document WHERE id_document = '82854' 18/04/2023 02:46:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '82854' 18/04/2023 03:03:02 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 18/04/2023 03:03:02 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20958' , '1' , '' , 'nuovo-prodotto' ) 18/04/2023 03:03:02 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20958' , '1' , '1' , '2' , NOW() , NOW() ) 18/04/2023 03:03:02 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20958' , '0' , '1' , '0' , '0' ) 18/04/2023 03:03:40 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892241800' AND id_product != '20958' AND ean13 != '' 18/04/2023 03:03:40 pm >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE SAN PAOLO', ean13 = '9788892241800', date_upd = NOW() WHERE id_product = '20958' 18/04/2023 03:03:40 pm >> UPDATE ps_product_lang SET name = 'PER MARIA A GESU\' ', description = '' WHERE id_product = '20958' 18/04/2023 03:03:40 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.5' WHERE id_product = '20958' 18/04/2023 03:03:40 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.5', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20958' 18/04/2023 03:03:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '20958' 18/04/2023 03:03:41 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20958' 18/04/2023 03:03:41 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20959' , '1' , '' , 'nuovo-prodotto' ) 18/04/2023 03:03:41 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20959' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20958' 18/04/2023 03:03:41 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20959' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20958' 18/04/2023 03:05:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '1285' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-18') 18/04/2023 03:05:15 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' , '1285' , '2023-04-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.00' , '17.21' , NOW() , NOW() ) 18/04/2023 03:05:15 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 = '82855' 18/04/2023 03:05:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '82855' 18/04/2023 03:05:15 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 ( '82855' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '6' , '-6' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '21.00' ) 18/04/2023 03:05:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '1285' AND id_document != '82855' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-18') 18/04/2023 03:05:37 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1285', document_date = '2023-04-18', 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 = '21.00', price_tax_excluded = '17.21', date_upd = NOW() WHERE id_document = '82855' 18/04/2023 03:05:37 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 = '82855' 18/04/2023 03:05:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '82855' 18/04/2023 03:05:37 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 ( '82855' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '6' , '-6' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '21.00' ) 18/04/2023 03:05:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '1285' AND id_document != '82855' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-18') 18/04/2023 03:05:56 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1285', document_date = '2023-04-18', 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 = '21.00', price_tax_excluded = '17.21', date_upd = NOW() WHERE id_document = '82855' 18/04/2023 03:05:56 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 = '82855' 18/04/2023 03:05:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '82855' 18/04/2023 03:05:56 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 ( '82855' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '6' , '-6' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '21.00' ) 18/04/2023 03:07:12 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892241817' AND id_product != '20959' AND ean13 != '' 18/04/2023 03:07:12 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/1', ean13 = '9788892241817', date_upd = NOW() WHERE id_product = '20959' 18/04/2023 03:07:12 pm >> UPDATE ps_product_lang SET name = 'VERITA\' E NORME DI VITA CRISTIANA', description = '' WHERE id_product = '20959' 18/04/2023 03:07:12 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.5' WHERE id_product = '20959' 18/04/2023 03:07:12 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.5', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20959' 18/04/2023 03:07:12 pm >> DELETE FROM ps_specific_price WHERE id_product = '20959' 18/04/2023 03:07:14 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20959' 18/04/2023 03:07:14 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20960' , '1' , '' , 'nuovo-prodotto' ) 18/04/2023 03:07:14 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20960' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20959' 18/04/2023 03:07:14 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20960' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20959' 18/04/2023 03:10:33 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831530880' AND id_product != '20960' AND ean13 != '' 18/04/2023 03:10:33 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/5', ean13 = '9788831530880', date_upd = NOW() WHERE id_product = '20960' 18/04/2023 03:10:33 pm >> UPDATE ps_product_lang SET name = 'CUORE DEL MONDO - A. CENCINI', description = '' WHERE id_product = '20960' 18/04/2023 03:10:33 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5' WHERE id_product = '20960' 18/04/2023 03:10:33 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20960' 18/04/2023 03:10:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '20960' 18/04/2023 03:10:34 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20960' 18/04/2023 03:10:34 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20961' , '1' , '' , 'nuovo-prodotto' ) 18/04/2023 03:10:34 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20961' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20960' 18/04/2023 03:10:34 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20961' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20960' 18/04/2023 03:11:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884244352' AND id_product != '13256' AND ean13 != '' 18/04/2023 03:11:36 pm >> UPDATE ps_product SET id_supplier = '7', reference = '4/1', ean13 = '9788884244352', date_upd = NOW() WHERE id_product = '13256' 18/04/2023 03:11:36 pm >> UPDATE ps_product_lang SET name = 'SINAI: VIAGGIO CON MOSE\' - GIOCO', description = '' WHERE id_product = '13256' 18/04/2023 03:11:36 pm >> UPDATE ps_product SET wholesale_price = '12.53', on_sale = '0', price = '19.9' WHERE id_product = '13256' 18/04/2023 03:11:36 pm >> UPDATE ps_product_shop SET wholesale_price = '12.53', price = '19.9', id_tax_rules_group = '4', id_category_default = '83', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '13256' 18/04/2023 03:11:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '13256' 18/04/2023 03:12: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 ( '33' , '628764' , '2023-04-17' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '8.02' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '284.76' , '284.76' , NOW() , NOW() ) 18/04/2023 03:12: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 = '82856' 18/04/2023 03:12:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '82856' 18/04/2023 03:12: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 ( '82856' , '20958' , 'PER MARIA A GESU ' , '12' , '12' , '4' , '1.50' , '1.5' , '0' , '33' , '12.0600' ) 18/04/2023 03:12:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20958' AND id_supplier = '7' 18/04/2023 03:12:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20958' , '7' , '1' ) 18/04/2023 03:12: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 ( '82856' , '20958' , 'PER MARIA A GESU ' , '1' , '1' , '4' , '1.50' , '1.5' , '0' , '100' , '0.0000' ) 18/04/2023 03:12:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20958' AND id_supplier = '7' 18/04/2023 03:12:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20958' , '7' , '1' ) 18/04/2023 03:12: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 ( '82856' , '20959' , 'VERITA E NORME DI VITA CRISTIANA' , '12' , '12' , '4' , '1.50' , '1.5' , '0' , '33' , '12.0600' ) 18/04/2023 03:12:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20959' AND id_supplier = '7' 18/04/2023 03:12:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20959' , '7' , '1' ) 18/04/2023 03:12: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 ( '82856' , '20959' , 'VERITA E NORME DI VITA CRISTIANA' , '1' , '1' , '4' , '1.50' , '1.5' , '0' , '100' , '0.0000' ) 18/04/2023 03:12:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20959' AND id_supplier = '7' 18/04/2023 03:12:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20959' , '7' , '1' ) 18/04/2023 03:12: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 ( '82856' , '20864' , 'MESSALINO QUOTIDIANO - MAG/GIU/LUG 23' , '2' , '2' , '4' , '6.00' , '6' , '0' , '30' , '8.4000' ) 18/04/2023 03:12:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20864' AND id_supplier = '7' 18/04/2023 03:12:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20864' , '7' , '1' ) 18/04/2023 03:12: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 ( '82856' , '20765' , 'AMEN - MAG 23' , '8' , '8' , '4' , '3.90' , '3.9' , '0' , '33' , '20.9040' ) 18/04/2023 03:12:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20765' AND id_supplier = '7' 18/04/2023 03:12:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20765' , '7' , '1' ) 18/04/2023 03:12: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 ( '82856' , '20766' , 'AMEN - GIU 23' , '8' , '8' , '4' , '3.90' , '3.9' , '0' , '33' , '20.9040' ) 18/04/2023 03:12:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20766' AND id_supplier = '7' 18/04/2023 03:12:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20766' , '7' , '1' ) 18/04/2023 03:12: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 ( '82856' , '20869' , 'CARA MAMMA - TONINO BELLO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 18/04/2023 03:12:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20869' AND id_supplier = '7' 18/04/2023 03:12:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20869' , '7' , '1' ) 18/04/2023 03:12: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 ( '82856' , '10532' , 'TEMPO PASQUALE - LECTIO BREVIS ' , '1' , '1' , '4' , '13.50' , '13.5' , '0' , '30' , '9.4500' ) 18/04/2023 03:12:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10532' AND id_supplier = '7' 18/04/2023 03:12:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10532' , '7' , '1' ) 18/04/2023 03:12: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 ( '82856' , '8274' , 'PREGHIERA DEI FEDELI NEI GIORNI FERIALI - 1 - TEMPI FORTI' , '1' , '1' , '4' , '25.00' , '25' , '0' , '30' , '17.5000' ) 18/04/2023 03:12:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8274' AND id_supplier = '7' 18/04/2023 03:12:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8274' , '7' , '1' ) 18/04/2023 03:12: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 ( '82856' , '8275' , 'PREGHIERA DEI FEDELI NEI GIORNI FERIALI - 2 - TEMPO ORDINARIO' , '1' , '1' , '4' , '35.00' , '35' , '0' , '30' , '24.5000' ) 18/04/2023 03:12:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8275' AND id_supplier = '7' 18/04/2023 03:12:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8275' , '7' , '1' ) 18/04/2023 03:12: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 ( '82856' , '20960' , 'CUORE DEL MONDO - A. CENCINI' , '1' , '1' , '4' , '3.50' , '3.5' , '0' , '33' , '2.3450' ) 18/04/2023 03:12:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20960' AND id_supplier = '7' 18/04/2023 03:12:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20960' , '7' , '1' ) 18/04/2023 03:12: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 ( '82856' , '16686' , 'EVANGELIARIO' , '1' , '1' , '4' , '150.00' , '150' , '0' , '30' , '105.0000' ) 18/04/2023 03:12:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16686' AND id_supplier = '7' 18/04/2023 03:12:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16686' , '7' , '1' ) 18/04/2023 03:12:05 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 ( '82856' , '3216' , 'CUORE - E. DE AMICIS' , '1' , '1' , '4' , '9.90' , '9.9' , '0' , '35' , '6.4350' ) 18/04/2023 03:12:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3216' AND id_supplier = '7' 18/04/2023 03:12:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3216' , '7' , '1' ) 18/04/2023 03:12:05 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 ( '82856' , '10430' , 'TABOR' , '1' , '1' , '4' , '17.90' , '17.9' , '0' , '30' , '12.5300' ) 18/04/2023 03:12:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10430' AND id_supplier = '7' 18/04/2023 03:12:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10430' , '7' , '1' ) 18/04/2023 03:12:05 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 ( '82856' , '13256' , 'SINAI: VIAGGIO CON MOSE - GIOCO' , '1' , '1' , '4' , '19.90' , '19.9' , '0' , '30' , '13.9300' ) 18/04/2023 03:12:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13256' AND id_supplier = '7' 18/04/2023 03:12:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13256' , '7' , '1' ) 18/04/2023 05:05:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '1286' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-18') 18/04/2023 05:05: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' , '1286' , '2023-04-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '390.00' , '319.67' , NOW() , NOW() ) 18/04/2023 05:05: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 = '82857' 18/04/2023 05:05:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '82857' 18/04/2023 05:05: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 ( '82857' , '13160' , 'CASULA MOD. CRISTOGRAMMA - cs12271' , '1' , '-1' , '1' , '390' , '319.67213114754' , '22' , '0' , '390.00' ) 18/04/2023 05:08:51 pm >> DELETE FROM ps_document WHERE id_document = '82734' 18/04/2023 05:08:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '82734' 18/04/2023 05:25:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '1287' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-18') 18/04/2023 05:25:52 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' , '1287' , '2023-04-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 18/04/2023 05:25:52 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 = '82858' 18/04/2023 05:25:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '82858' 18/04/2023 05:25:52 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 ( '82858' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 18/04/2023 05:38:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '71' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-04-18') 18/04/2023 05:38:38 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' , '71' , '2023-04-18' , '' , '3931' , '0' , '4677720' , 'VIALE DELLA LIBERA 11 80079 PROCIDA' , '' , '' , '10' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '180.00' , '180.00' , NOW() , NOW() ) 18/04/2023 05:38:38 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 = '82859' 18/04/2023 05:38:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '82859' 18/04/2023 05:38:38 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 ( '82859' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '40' , '-40' , '4' , '5.00' , '5' , '0' , '15' , '170.00' ) 18/04/2023 05:51:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '1288' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-18') 18/04/2023 05:51: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' , '1288' , '2023-04-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 18/04/2023 05:51: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 = '82860' 18/04/2023 05:51:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '82860' 18/04/2023 05:51: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 ( '82860' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 18/04/2023 05:55:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '1289' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2023-04-18') 18/04/2023 05:55:10 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1289' , '2023-04-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '3.50' , NOW() , NOW() ) 18/04/2023 05:55: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 = '82861' 18/04/2023 05:55:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '82861' 18/04/2023 05:55: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 ( '82861' , '20960' , 'CUORE DEL MONDO - A. CENCINI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 18/04/2023 05:56:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '1290' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-18') 18/04/2023 05:56: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' , '1290' , '2023-04-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '208.05' , '208.05' , NOW() , NOW() ) 18/04/2023 05:56: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 = '82862' 18/04/2023 05:56:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '82862' 18/04/2023 05:56: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 ( '82862' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '2' , '-2' , '4' , '12.00' , '12' , '0' , '5' , '22.80' ) 18/04/2023 05:56: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 ( '82862' , '20424' , 'ABBI CURA DI ME - S. CRISTICCHI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 18/04/2023 05:56: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 ( '82862' , '16268' , 'NOSTRA MADRE TERRA - PAPA FRANCESCO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 18/04/2023 05:56: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 ( '82862' , '20237' , 'SIATE FELICI - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 18/04/2023 05:56: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 ( '82862' , '20654' , 'CONQUISTA LA PACE - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 18/04/2023 05:56: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 ( '82862' , '14260' , 'CUORE CHE BATTE - TORNARE AD AMARE IL CREATO' , '3' , '-3' , '4' , '8.00' , '8' , '0' , '5' , '22.80' ) 18/04/2023 05:56: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 ( '82862' , '18261' , 'PIETRA SCARTATA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 18/04/2023 05:56: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 ( '82862' , '19588' , 'SCELTA DI ENEA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 18/04/2023 05:56:15 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 ( '82862' , '19360' , 'IN PRINCIPIO ERANO FRATELLI - L. EPICOCO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 18/04/2023 05:56:15 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 ( '82862' , '17001' , 'SPERANZA NON E MORTA - L. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 18/04/2023 05:56:15 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 ( '82862' , '20656' , 'PAURA COME DONO - PAPA FRANCESCO' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 18/04/2023 05:56:15 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 ( '82862' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 18/04/2023 05:56:15 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 ( '82862' , '20745' , 'SPERANZA CHE CERCHI - F. CRISTOFARO' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 18/04/2023 06:11:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '1003' AND id_document != '82504' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-28') 18/04/2023 06:11:13 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1003', document_date = '2023-03-28', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '9.00', price_tax_excluded = '7.38', date_upd = NOW() WHERE id_document = '82504' 18/04/2023 06:11:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82504' 18/04/2023 06:11:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '82504' 18/04/2023 06:11:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82504' , '18223' , 'CORONA MISSIONARIA - R102' , '3' , '-3' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '3.00' ) 18/04/2023 06:11:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82504' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '1' , '-1' , '1' , '6' , '4.9180327868852' , '22' , '0' , '6.00' ) 18/04/2023 07:11:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '1291' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-18') 18/04/2023 07:11: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' , '1291' , '2023-04-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 18/04/2023 07:11: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 = '82863' 18/04/2023 07:11:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '82863' 18/04/2023 07:11: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 ( '82863' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' )