04/09/2023 09:46:06 am >> SELECT document_num FROM ps_document WHERE document_num = '2718' AND id_document != '87165' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-02') 04/09/2023 09:46:06 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2718', document_date = '2023-09-02', 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 = '36.00', price_tax_excluded = '32.84', date_upd = NOW() WHERE id_document = '87165' 04/09/2023 09:46:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87165' 04/09/2023 09:46:07 am >> DELETE FROM ps_document_detail WHERE id_document = '87165' 04/09/2023 09:46:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87165' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '5' , '-5' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '17.50' ) 04/09/2023 09:46:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87165' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '1' , '-1' , '4' , '18.5' , '18.5' , '0' , '0' , '18.50' ) 04/09/2023 10:14:54 am >> SELECT document_num FROM ps_document WHERE document_num = '52' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-09-04') 04/09/2023 10:14:54 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' , '52' , '2023-09-04' , '' , '3385' , '0' , '37343286' , 'VIA MONS. MENEGAZZI, 3 44022 COMACCHIO' , '' , '' , '2.9' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '20.00' , '20.00' , NOW() , NOW() ) 04/09/2023 10:14:54 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 = '12139' 04/09/2023 10:14:54 am >> DELETE FROM ps_document_detail WHERE id_document = '12139' 04/09/2023 10:14:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '12139' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 04/09/2023 10:38:44 am >> SELECT document_num FROM ps_document WHERE document_num = '2722' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-04') 04/09/2023 10:38:44 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' , '2722' , '2023-09-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '81.09' , '81.09' , NOW() , NOW() ) 04/09/2023 10:38:44 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 = '87169' 04/09/2023 10:38:44 am >> DELETE FROM ps_document_detail WHERE id_document = '87169' 04/09/2023 10:38:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87169' , '17581' , 'MESSALE QUOTIDIANO N.E. ' , '1' , '-1' , '4' , '39.00' , '39' , '0' , '5' , '37.05' ) 04/09/2023 10:38:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87169' , '15952' , 'A CENTRO TAVOLA - G. COTICHELLA' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 04/09/2023 10:38:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87169' , '21076' , 'RACCONTARE LA FEDE AI GIOVANI ' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 04/09/2023 10:38:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87169' , '12270' , 'NUOVO ABC DEL CATECHISTA' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '5' , '4.28' ) 04/09/2023 10:38:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87169' , '21171' , 'CATECHESI IN PARROCCHIA' , '1' , '-1' , '4' , '14.90' , '14.9' , '0' , '5' , '14.16' ) 04/09/2023 10:38:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87169' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '2' , '-2' , '4' , '2.80' , '2.8' , '0' , '50' , '2.80' ) 04/09/2023 11:25:00 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '23V604035' , '2023-08-31' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '1.40' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.11' , '36.11' , NOW() , NOW() ) 04/09/2023 11:25:00 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 = '87170' 04/09/2023 11:25:00 am >> DELETE FROM ps_document_detail WHERE id_document = '87170' 04/09/2023 11:25:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87170' , '21483' , 'BIBBIA - SCRUTATE - TELATA' , '2' , '0' , '4' , '35.0000' , '35' , '0' , '33+26' , '34.71' ) 04/09/2023 11:25:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '21483' AND id_supplier = '7' 04/09/2023 11:25:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21483' , '7' , '1' ) 04/09/2023 11:32:02 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '23V604034' , '2023-08-31' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '240.24' , '240.24' , NOW() , NOW() ) 04/09/2023 11:32:02 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87171' 04/09/2023 11:32:02 am >> DELETE FROM ps_document_detail WHERE id_document = '87171' 04/09/2023 11:32:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21500' , 'CAMMINO DI NAZARET - ARVALLI/VISENTINI' , '1' , '0' , '4' , '14.9000' , '14.9' , '0' , '30' , '10.43' ) 04/09/2023 11:32:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '21500' AND id_supplier = '7' 04/09/2023 11:32:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21500' , '7' , '1' ) 04/09/2023 11:32:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21491' , 'ANCHE TU ALLA CENA DEL GESU - T. LASCONI' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '33' , '6.70' ) 04/09/2023 11:32:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '21491' AND id_supplier = '7' 04/09/2023 11:32:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21491' , '7' , '1' ) 04/09/2023 11:32:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21494' , 'CAMMINAVA CON LORO ' , '1' , '0' , '4' , '3.5000' , '3.5' , '0' , '30' , '2.45' ) 04/09/2023 11:32:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '21494' AND id_supplier = '7' 04/09/2023 11:32:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21494' , '7' , '1' ) 04/09/2023 11:32:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21502' , 'SALMI PER PICCOLI CUORI' , '2' , '0' , '4' , '4.9000' , '4.9' , '0' , '35' , '6.37' ) 04/09/2023 11:32:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '21502' AND id_supplier = '7' 04/09/2023 11:32:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21502' , '7' , '1' ) 04/09/2023 11:32:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21492' , 'PASCI LE MIE PECORE - F. SALVI' , '1' , '0' , '4' , '13.0000' , '13' , '0' , '30' , '9.10' ) 04/09/2023 11:32:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '21492' AND id_supplier = '7' 04/09/2023 11:32:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21492' , '7' , '1' ) 04/09/2023 11:32:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21495' , 'AMARE ED ESSERE AMATI - J. TOWEY' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '33' , '12.06' ) 04/09/2023 11:32:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '21495' AND id_supplier = '7' 04/09/2023 11:32:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21495' , '7' , '1' ) 04/09/2023 11:32:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21496' , 'PAROLA CHE RISANA - ANNO B - A. SANSONE' , '1' , '0' , '4' , '22.0000' , '22' , '0' , '33' , '14.74' ) 04/09/2023 11:32:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '21496' AND id_supplier = '7' 04/09/2023 11:32:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21496' , '7' , '1' ) 04/09/2023 11:32:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21497' , 'FIORETTI - SAN FRANCESCO' , '1' , '0' , '4' , '9.0000' , '9' , '0' , '33' , '6.03' ) 04/09/2023 11:32:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '21497' AND id_supplier = '7' 04/09/2023 11:32:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21497' , '7' , '1' ) 04/09/2023 11:32:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21498' , 'DON PINO PUGLISI - A MANI NUDE - V. CERUSO' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '33' , '10.72' ) 04/09/2023 11:32:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '21498' AND id_supplier = '7' 04/09/2023 11:32:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21498' , '7' , '1' ) 04/09/2023 11:32:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21499' , 'PADRE PINO PUGLISI - CAVADI/SCORDATO' , '2' , '0' , '4' , '18.0000' , '18' , '0' , '30' , '25.20' ) 04/09/2023 11:32:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '21499' AND id_supplier = '7' 04/09/2023 11:32:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21499' , '7' , '1' ) 04/09/2023 11:32:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21501' , 'PAPA MI FACCIO PRETE! - S. RINDONE' , '1' , '0' , '4' , '17.0000' , '17' , '0' , '30' , '11.90' ) 04/09/2023 11:32:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '21501' AND id_supplier = '7' 04/09/2023 11:32:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21501' , '7' , '1' ) 04/09/2023 11:32:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21493' , 'LUISA PICCARRETTA - LO SPLENDORE DELLA DIVINA VOLONTA - M. STANZIONE' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '30' , '7.00' ) 04/09/2023 11:32:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '21493' AND id_supplier = '7' 04/09/2023 11:32:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21493' , '7' , '1' ) 04/09/2023 11:32:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21484' , 'MIA IMPRONTA NELLA TUA - GUIDA 1' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '35' , '9.75' ) 04/09/2023 11:32:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '21484' AND id_supplier = '7' 04/09/2023 11:32:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21484' , '7' , '1' ) 04/09/2023 11:32:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21485' , 'MIA IMPRONTA NELLA TUA - GUIDA 2' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '35' , '9.75' ) 04/09/2023 11:32:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '21485' AND id_supplier = '7' 04/09/2023 11:32:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21485' , '7' , '1' ) 04/09/2023 11:32:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21485' , 'MIO GRANDE LIBRO DA COLORARE' , '2' , '0' , '4' , '7.9000' , '7.9' , '0' , '30' , '11.06' ) 04/09/2023 11:32:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '21485' AND id_supplier = '7' 04/09/2023 11:32:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21485' , '7' , '1' ) 04/09/2023 11:32:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21487' , 'SEI UN MITO - L. GALBIATI' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '30' , '8.40' ) 04/09/2023 11:32:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '21487' AND id_supplier = '7' 04/09/2023 11:32:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21487' , '7' , '1' ) 04/09/2023 11:32:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21506' , 'PANE QUOTIDIANO NOV/DIC 2023' , '1' , '0' , '4' , '3.9000' , '3.9' , '0' , '30' , '2.73' ) 04/09/2023 11:32:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '21506' AND id_supplier = '7' 04/09/2023 11:32:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21506' , '7' , '1' ) 04/09/2023 11:32:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21505' , 'VITA DEL SANTO CURATO DARS' , '1' , '0' , '4' , '4.9000' , '4.9' , '0' , '35' , '3.19' ) 04/09/2023 11:32:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '21505' AND id_supplier = '7' 04/09/2023 11:32:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21505' , '7' , '1' ) 04/09/2023 11:32:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '33' , '12.06' ) 04/09/2023 11:32:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '20655' AND id_supplier = '7' 04/09/2023 11:32:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20655' , '7' , '1' ) 04/09/2023 11:32:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '17713' , 'FARSI SANTI CON CIO CHE CE - L. EPICOCO' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '30' , '8.40' ) 04/09/2023 11:32:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '17713' AND id_supplier = '7' 04/09/2023 11:32:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17713' , '7' , '1' ) 04/09/2023 11:32:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '8702' , 'QUANDO IL MAESTRO PARLA AL CUORE - G. COURTOIS' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '33' , '9.38' ) 04/09/2023 11:32:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '8702' AND id_supplier = '7' 04/09/2023 11:32:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8702' , '7' , '1' ) 04/09/2023 11:32:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21198' , 'AMEN - SET 2023' , '3' , '0' , '4' , '3.9000' , '3.9' , '0' , '33' , '7.84' ) 04/09/2023 11:32:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '21198' AND id_supplier = '7' 04/09/2023 11:32:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21198' , '7' , '1' ) 04/09/2023 11:32:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21199' , 'AMEN - OTT 23' , '2' , '0' , '4' , '3.9000' , '3.9' , '0' , '33' , '5.23' ) 04/09/2023 11:32:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '21199' AND id_supplier = '7' 04/09/2023 11:32:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21199' , '7' , '1' ) 04/09/2023 11:32:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '6658' , 'MIE NOTTI INSONNI - TONINO BELLO' , '1' , '0' , '4' , '9.5000' , '9.5' , '0' , '33' , '6.37' ) 04/09/2023 11:32:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '6658' AND id_supplier = '7' 04/09/2023 11:32:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6658' , '7' , '1' ) 04/09/2023 11:32:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '10128' , 'SPERANZA A CARO PREZZO - T. BELLO' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '33' , '9.38' ) 04/09/2023 11:32:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '10128' AND id_supplier = '7' 04/09/2023 11:32:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10128' , '7' , '1' ) 04/09/2023 11:32:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '10133' , 'SPESE DI TRASPORTO' , '1' , '0' , '4' , '14' , '14' , '0' , '0' , '14.0000' ) 04/09/2023 11:32:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '10133' AND id_supplier = '7' 04/09/2023 11:32:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10133' , '7' , '1' ) 04/09/2023 11:41:33 am >> SELECT document_num FROM ps_document WHERE document_num = '2723' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-04') 04/09/2023 11:41:33 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2723' , '2023-09-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '114.38' , '113.21' , NOW() , NOW() ) 04/09/2023 11:41: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 = '87172' 04/09/2023 11:41:33 am >> DELETE FROM ps_document_detail WHERE id_document = '87172' 04/09/2023 11:41: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 ( '87172' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '49' , '49' , '0' , '0' , '49.00' ) 04/09/2023 11:41: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 ( '87172' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 04/09/2023 11:41: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 ( '87172' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 04/09/2023 11:41: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 ( '87172' , '21196' , 'CALENDARIO LITURGICO 2024' , '4' , '-4' , '4' , '0.50' , '0.5' , '0' , '0' , '2.00' ) 04/09/2023 11:41: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 ( '87172' , '21490' , 'CALENDARIO LITURGICO 2024 - 8478' , '2' , '-2' , '4' , '1.00' , '1' , '0' , '0' , '2.00' ) 04/09/2023 11:41: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 ( '87172' , '816' , 'ATTI DEGLI APOSTOLI' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 04/09/2023 11:41:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87172' , '21136' , 'REGOLA DI BENEDETTO - J. CHITTISTER' , '1' , '-1' , '4' , '24.00' , '24' , '0' , '5' , '22.80' ) 04/09/2023 11:42:36 am >> SELECT document_num FROM ps_document WHERE document_num = '2724' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-04') 04/09/2023 11:42:36 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2724' , '2023-09-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 04/09/2023 11:42:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87173' 04/09/2023 11:42:36 am >> DELETE FROM ps_document_detail WHERE id_document = '87173' 04/09/2023 11:42:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87173' , '21192' , 'SULLA TUA PAROLA - SET/OTT 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 04/09/2023 11:51:21 am >> SELECT document_num FROM ps_document WHERE document_num = '2718' AND id_document != '87165' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-02') 04/09/2023 11:51:21 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2718', document_date = '2023-09-02', 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 = '36.00', price_tax_excluded = '32.84', date_upd = NOW() WHERE id_document = '87165' 04/09/2023 11:51:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87165' 04/09/2023 11:51:21 am >> DELETE FROM ps_document_detail WHERE id_document = '87165' 04/09/2023 11:51:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87165' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '5' , '-5' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '17.50' ) 04/09/2023 11:51:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87165' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '1' , '-1' , '4' , '18.50' , '18.5' , '0' , '0' , '18.50' ) 04/09/2023 11:54:49 am >> SELECT document_num FROM ps_document WHERE document_num = '2725' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-04') 04/09/2023 11:54:49 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2725' , '2023-09-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '129.30' , '107.70' , NOW() , NOW() ) 04/09/2023 11:54:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87174' 04/09/2023 11:54:49 am >> DELETE FROM ps_document_detail WHERE id_document = '87174' 04/09/2023 11:54:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87174' , '21145' , 'ANNO LITURGICO COME ITINERARIO - A. LAMERI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 04/09/2023 11:54:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87174' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '39.90' , '32.704918032787' , '22' , '0' , '39.90' ) 04/09/2023 11:54:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87174' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '39.90' , '32.704918032787' , '22' , '0' , '39.90' ) 04/09/2023 11:54:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87174' , '20983' , 'CLERGY MM LIMITED 80/20' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 04/09/2023 11:59:12 am >> SELECT document_num FROM ps_document WHERE document_num = '70/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-28') 04/09/2023 11:59:12 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '70/A' , '2023-10-28' , 'A' , '371' , '0' , '4670910' , 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '113.00' , '92.62' , NOW() , NOW() ) 04/09/2023 11:59:12 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87175' 04/09/2023 11:59:12 am >> DELETE FROM ps_document_detail WHERE id_document = '87175' 04/09/2023 11:59:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87175' , '19362' , 'LUMINO DIAMANTE VARI COLORI' , '226' , '-226' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '113.00' ) 04/09/2023 11:59:22 am >> DELETE FROM ps_document WHERE id_document = '87175' 04/09/2023 11:59:22 am >> DELETE FROM ps_document_detail WHERE id_document = '87175' 04/09/2023 12:11:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '2726' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-04') 04/09/2023 12:11: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 ( '11' , '2726' , '2023-09-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.20' , '15.20' , NOW() , NOW() ) 04/09/2023 12:11: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 = '87176' 04/09/2023 12:11:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '87176' 04/09/2023 12:11: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 ( '87176' , '18331' , 'TRATTENIMENTI SPIRITUALI - B. SILVESTRELLI - 8752' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 04/09/2023 12:11: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 ( '87176' , '19503' , 'UN MESE CON MARIA - 8064' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 04/09/2023 12:21:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '2727' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-04') 04/09/2023 12:21:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2727' , '2023-09-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '600.00' , '491.80' , NOW() , NOW() ) 04/09/2023 12:21:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87177' 04/09/2023 12:21:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '87177' 04/09/2023 12:21:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87177' , '19659' , 'CASULA POLIESTERE - 65/18355' , '1' , '-1' , '1' , '365' , '299.18032786885' , '22' , '0' , '365.00' ) 04/09/2023 12:21:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87177' , '18401' , 'CAMICE CON TRAMEZZO - 406TPACQ' , '1' , '-1' , '1' , '200' , '163.93442622951' , '22' , '0' , '200.00' ) 04/09/2023 12:21:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87177' , '19710' , 'CINGOLO ORO - 55/8898' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 04/09/2023 12:24:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '2679' AND id_document != '87120' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-31') 04/09/2023 12:24:10 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2679', document_date = '2023-08-31', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '315.00', price_tax_excluded = '277.13', date_upd = NOW() WHERE id_document = '87120' 04/09/2023 12:24: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 = '87120' 04/09/2023 12:24:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '87120' 04/09/2023 12:24: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 ( '87120' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 04/09/2023 12:24: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 ( '87120' , '7311' , 'OSTIA SOTTILE 74MM' , '6' , '-6' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '12.00' ) 04/09/2023 12:24: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 ( '87120' , '19101' , 'INCENSO C' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 04/09/2023 12:24: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 ( '87120' , '14362' , 'CAMICE SVASATO - 434/TPA' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 04/09/2023 12:24: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 ( '87120' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45.0000' , '36.885245901639' , '22' , '0' , '45.00' ) 04/09/2023 12:24: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 ( '87120' , '1544' , 'CAMICE RAGLAN - CM 150 - ART.54' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 04/09/2023 12:24: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 ( '87120' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.45' , '2.45' , '0' , '0' , '2.45' ) 04/09/2023 12:24: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 ( '87120' , '21468' , 'BIBBIA E CATECHESI - G. DE VIRGILIO' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 04/09/2023 12:24: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 ( '87120' , '21385' , 'DIO DEGLI EBREI - A. MELLO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 04/09/2023 12:24: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 ( '87120' , '21339' , 'FIUME DELLA VITA - G. RAVASI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 04/09/2023 12:24:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '2713' AND id_document != '87159' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-01') 04/09/2023 12:24:46 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2713', document_date = '2023-09-01', 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 = '48.00', price_tax_excluded = '43.31', date_upd = NOW() WHERE id_document = '87159' 04/09/2023 12:24:46 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 = '87159' 04/09/2023 12:24:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '87159' 04/09/2023 12:24:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87159' , '15801' , 'ARGENTO A PESO' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 04/09/2023 12:24:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87159' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '5.85' , '5.85' , '0' , '0' , '5.85' ) 04/09/2023 12:24:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87159' , '17961' , 'CATENINA ARG. CM 40' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 04/09/2023 12:24:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87159' , '21338' , 'DIO DI ABRAMO - A. MELLO' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 04/09/2023 12:37:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '44/A' AND id_document != '82607' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-03') 04/09/2023 12:37:55 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '44/A', document_date = '2023-04-03', document_letter = 'A', id_customer = '371', id_supplier = '', id_address = '4670910', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', address2 = '', note = 'acconto € 15,00 4/9/23', 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 = '250.00', price_tax_excluded = '204.92', date_upd = NOW() WHERE id_document = '82607' 04/09/2023 12:37:55 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 = '82607' 04/09/2023 12:37:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '82607' 04/09/2023 12:37:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82607' , '18372' , 'CASULA LANA LUREX - 65/001909' , '1' , '-1' , '1' , '250.0000' , '204.91803278689' , '22' , '0' , '250.00' ) 04/09/2023 12:45:29 pm >> UPDATE ps_document SET id_document_type = '32', document_num = '23V604034', document_date = '2023-08-31', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2602', address1 = 'P. ZZA SAN PAOLO, 14 12051 ALBA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '11', id_causal = '0', price_tax_included = '232.90', price_tax_excluded = '232.90', date_upd = NOW() WHERE id_document = '87171' 04/09/2023 12:45:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87171' 04/09/2023 12:45:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '87171' 04/09/2023 12:45:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21500' , 'CAMMINO DI NAZARET - ARVALLI/VISENTINI' , '1' , '0' , '4' , '14.9000' , '14.9' , '0' , '30' , '10.43' ) 04/09/2023 12:45:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21491' , 'ANCHE TU ALLA CENA DEL GESU - T. LASCONI' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '33' , '6.70' ) 04/09/2023 12:45:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21494' , 'CAMMINAVA CON LORO ' , '1' , '0' , '4' , '3.5000' , '3.5' , '0' , '30' , '2.45' ) 04/09/2023 12:45:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21502' , 'SALMI PER PICCOLI CUORI' , '2' , '0' , '4' , '4.9000' , '4.9' , '0' , '35' , '6.37' ) 04/09/2023 12:45:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21492' , 'PASCI LE MIE PECORE - F. SALVI' , '1' , '0' , '4' , '13.0000' , '13' , '0' , '30' , '9.10' ) 04/09/2023 12:45:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21495' , 'AMARE ED ESSERE AMATI - J. TOWEY' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '33' , '12.06' ) 04/09/2023 12:45:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21496' , 'PAROLA CHE RISANA - ANNO B - A. SANSONE' , '1' , '0' , '4' , '22.0000' , '22' , '0' , '33' , '14.74' ) 04/09/2023 12:45:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21497' , 'FIORETTI - SAN FRANCESCO' , '1' , '0' , '4' , '9.0000' , '9' , '0' , '33' , '6.03' ) 04/09/2023 12:45:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21498' , 'DON PINO PUGLISI - A MANI NUDE - V. CERUSO' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '33' , '10.72' ) 04/09/2023 12:45:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21499' , 'PADRE PINO PUGLISI - CAVADI/SCORDATO' , '2' , '0' , '4' , '18.0000' , '18' , '0' , '30' , '25.20' ) 04/09/2023 12:45:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21501' , 'PAPA MI FACCIO PRETE! - S. RINDONE' , '1' , '0' , '4' , '17.0000' , '17' , '0' , '30' , '11.90' ) 04/09/2023 12:45:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21493' , 'LUISA PICCARRETTA - LO SPLENDORE DELLA DIVINA VOLONTA - M. STANZIONE' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '30' , '7.00' ) 04/09/2023 12:45:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21484' , 'MIA IMPRONTA NELLA TUA - GUIDA 1' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '35' , '9.75' ) 04/09/2023 12:45:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21485' , 'MIA IMPRONTA NELLA TUA - GUIDA 2' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '35' , '9.75' ) 04/09/2023 12:45:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21485' , 'MIO GRANDE LIBRO DA COLORARE' , '2' , '0' , '4' , '7.9000' , '7.9' , '0' , '30' , '11.06' ) 04/09/2023 12:45:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21487' , 'SEI UN MITO - L. GALBIATI' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '30' , '8.40' ) 04/09/2023 12:45:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21506' , 'PANE QUOTIDIANO NOV/DIC 2023' , '1' , '0' , '4' , '3.9000' , '3.9' , '0' , '30' , '2.73' ) 04/09/2023 12:45:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21505' , 'VITA DEL SANTO CURATO DARS' , '1' , '0' , '4' , '4.9000' , '4.9' , '0' , '35' , '3.19' ) 04/09/2023 12:45:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '33' , '12.06' ) 04/09/2023 12:45:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '17713' , 'FARSI SANTI CON CIO CHE CE - L. EPICOCO' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '30' , '8.40' ) 04/09/2023 12:45:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '8702' , 'QUANDO IL MAESTRO PARLA AL CUORE - G. COURTOIS' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '33' , '9.38' ) 04/09/2023 12:45:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21198' , 'AMEN - SET 2023' , '3' , '0' , '4' , '3.9000' , '3.9' , '0' , '33' , '7.84' ) 04/09/2023 12:45:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '21199' , 'AMEN - OTT 23' , '2' , '0' , '4' , '3.9000' , '3.9' , '0' , '33' , '5.23' ) 04/09/2023 12:45:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '6658' , 'MIE NOTTI INSONNI - TONINO BELLO' , '1' , '0' , '4' , '9.5000' , '9.5' , '0' , '33' , '6.37' ) 04/09/2023 12:45:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '10128' , 'SPERANZA A CARO PREZZO - T. BELLO' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '33' , '9.38' ) 04/09/2023 12:45:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87171' , '10133' , 'SPESE DI TRASPORTO' , '1' , '0' , '4' , '6.66' , '6.66' , '0' , '0' , '6.6600' ) 04/09/2023 02:39:29 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 ( '32' , '73' , '2023-05-30' , '' , '0' , '126' , '4669995' , 'VIA DELLE INDUSTRIE, 75 06083 BASTIA UMBRA' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '750.30' , '615.00' , NOW() , NOW() ) 04/09/2023 02:39:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87178' 04/09/2023 02:39:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '87178' 04/09/2023 02:39:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87178' , '16955' , 'STOLA MARIANA - 8005' , '1' , '0' , '1' , '60' , '49.180327868852' , '22' , '0' , '73.2000' ) 04/09/2023 02:39:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16955' AND id_supplier = '126' 04/09/2023 02:39:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16955' , '126' , '1' ) 04/09/2023 02:39:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87178' , '19190' , 'STOLA MARIANA - 7335' , '1' , '0' , '1' , '70' , '57.377049180328' , '22' , '0' , '85.4000' ) 04/09/2023 02:39:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19190' AND id_supplier = '126' 04/09/2023 02:39:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19190' , '126' , '1' ) 04/09/2023 02:39:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87178' , '16958' , 'SERVIZIO MESSA M/LINO MARIANO - 6990' , '1' , '0' , '1' , '20' , '16.393442622951' , '22' , '0' , '24.4000' ) 04/09/2023 02:39:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16958' AND id_supplier = '126' 04/09/2023 02:39:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16958' , '126' , '1' ) 04/09/2023 02:39:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87178' , '18239' , 'SERVIZIO MESSA - MARIANO M/L - 7051' , '1' , '0' , '1' , '25' , '20.491803278689' , '22' , '0' , '30.5000' ) 04/09/2023 02:39:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18239' AND id_supplier = '126' 04/09/2023 02:39:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18239' , '126' , '1' ) 04/09/2023 02:39:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87178' , '20901' , 'CASULA P/LANA AGNUS DEI - 8219-8249L' , '1' , '0' , '1' , '440' , '360.65573770492' , '22' , '0' , '536.8000' ) 04/09/2023 02:39:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20901' AND id_supplier = '126' 04/09/2023 02:39:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20901' , '126' , '1' ) 04/09/2023 02:40:13 pm >> DELETE FROM ps_document WHERE id_document = '85635' 04/09/2023 02:40:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '85635' 04/09/2023 02:58:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '2722' AND id_document != '87169' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-04') 04/09/2023 02:58:50 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2722', document_date = '2023-09-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 = '81.09', price_tax_excluded = '81.09', date_upd = NOW() WHERE id_document = '87169' 04/09/2023 02:58:50 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 = '87169' 04/09/2023 02:58:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '87169' 04/09/2023 02:58:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87169' , '17581' , 'MESSALE QUOTIDIANO N.E. ' , '1' , '-1' , '4' , '39.0000' , '39' , '0' , '5' , '37.05' ) 04/09/2023 02:58:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87169' , '15952' , 'A CENTRO TAVOLA - G. COTICHELLA' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '5' , '8.55' ) 04/09/2023 02:58:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87169' , '21076' , 'RACCONTARE LA FEDE AI GIOVANI ' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 04/09/2023 02:58:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87169' , '12270' , 'NUOVO ABC DEL CATECHISTA' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '5' , '4.28' ) 04/09/2023 02:58:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87169' , '21171' , 'CATECHESI IN PARROCCHIA' , '1' , '-1' , '4' , '14.9000' , '14.9' , '0' , '5' , '14.16' ) 04/09/2023 02:58:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87169' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '0' , '2.80' ) 04/09/2023 03:00:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '2718' AND id_document != '87165' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-02') 04/09/2023 03:00:02 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2718', document_date = '2023-09-02', 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 = '36.00', price_tax_excluded = '32.84', date_upd = NOW() WHERE id_document = '87165' 04/09/2023 03:00:02 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 = '87165' 04/09/2023 03:00:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '87165' 04/09/2023 03:00:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87165' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '5' , '-5' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '17.50' ) 04/09/2023 03:00:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87165' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '1' , '-1' , '4' , '18.5' , '18.5' , '0' , '0' , '18.50' ) 04/09/2023 03:13:08 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001826' AND id_product != '18881' AND ean13 != '' 04/09/2023 03:13:09 pm >> UPDATE ps_product SET id_supplier = '122', reference = '', ean13 = '001826', date_upd = NOW() WHERE id_product = '18881' 04/09/2023 03:13:09 pm >> UPDATE ps_product_lang SET name = 'STOLA POLIESTERE - PST020', description = '' WHERE id_product = '18881' 04/09/2023 03:13:09 pm >> UPDATE ps_product SET wholesale_price = '8.20', on_sale = '0', price = 'NaN' WHERE id_product = '18881' 04/09/2023 03:13:09 pm >> UPDATE ps_product_shop SET wholesale_price = '8.20', price = 'NaN', id_tax_rules_group = '1', id_category_default = '440', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18881' 04/09/2023 03:13:09 pm >> DELETE FROM ps_specific_price WHERE id_product = '18881' 04/09/2023 03:32:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '2728' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-04') 04/09/2023 03:32: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' , '2728' , '2023-09-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.50' , '14.34' , NOW() , NOW() ) 04/09/2023 03:32: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 = '87179' 04/09/2023 03:32:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '87179' 04/09/2023 03:32: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 ( '87179' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '5' , '-5' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '17.50' ) 04/09/2023 04:32:27 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 ( '32' , '6023281199' , '2023-08-31' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '3.65' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '129.82' , '129.82' , NOW() , NOW() ) 04/09/2023 04:32: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 = '87180' 04/09/2023 04:32:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '87180' 04/09/2023 04:32: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 ( '87180' , '21469' , 'REGOLE MORALI' , '1' , '0' , '4' , '9.68' , '9.68' , '0' , '0' , '9.6800' ) 04/09/2023 04:32:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21469' AND id_supplier = '109' 04/09/2023 04:32:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21469' , '109' , '1' ) 04/09/2023 04:32: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 ( '87180' , '21470' , 'UN GIORNO UNA PAROLA 2024' , '1' , '0' , '4' , '9.75' , '9.75' , '0' , '0' , '9.7500' ) 04/09/2023 04:32:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21470' AND id_supplier = '109' 04/09/2023 04:32:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21470' , '109' , '1' ) 04/09/2023 04:32: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 ( '87180' , '21472' , 'EFFETTO DOMINO - 15/18 ANNI' , '1' , '0' , '4' , '3.5' , '3.5' , '0' , '0' , '3.5000' ) 04/09/2023 04:32:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21472' AND id_supplier = '109' 04/09/2023 04:32:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21472' , '109' , '1' ) 04/09/2023 04:32: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 ( '87180' , '21475' , 'EFFETTO DOMINO GUIDA GIOVANI - 15/18 ANNI' , '1' , '0' , '4' , '10.84' , '10.84' , '0' , '0' , '10.8400' ) 04/09/2023 04:32:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21475' AND id_supplier = '109' 04/09/2023 04:32:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21475' , '109' , '1' ) 04/09/2023 04:32: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 ( '87180' , '21474' , 'QUESTA CASA E TUA PICCOLISSIMI - 3/5 ANNI' , '2' , '0' , '4' , '11.55' , '11.55' , '0' , '0' , '23.1000' ) 04/09/2023 04:32:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21474' AND id_supplier = '109' 04/09/2023 04:32:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21474' , '109' , '1' ) 04/09/2023 04:32: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 ( '87180' , '21473' , 'QUESTA CASA E TUA 1 - 6/8 ANNI' , '2' , '0' , '4' , '11.55' , '11.55' , '0' , '0' , '23.1000' ) 04/09/2023 04:32:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21473' AND id_supplier = '109' 04/09/2023 04:32:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21473' , '109' , '1' ) 04/09/2023 04:32: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 ( '87180' , '21471' , 'QUESTA CASA E TUA 2 - 9/11 ANNI' , '2' , '0' , '4' , '11.55' , '11.55' , '0' , '0' , '23.1000' ) 04/09/2023 04:32:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21471' AND id_supplier = '109' 04/09/2023 04:32:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21471' , '109' , '1' ) 04/09/2023 04:32: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 ( '87180' , '21476' , 'QUESTA CASA E TUA 3 - 12/14 ANNI' , '2' , '0' , '4' , '11.55' , '11.55' , '0' , '0' , '23.1000' ) 04/09/2023 04:32:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21476' AND id_supplier = '109' 04/09/2023 04:32:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21476' , '109' , '1' ) 04/09/2023 04:53:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '2228' AND id_document != '86551' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-28') 04/09/2023 04:53:36 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2228', document_date = '2023-06-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 = '49.00', price_tax_excluded = '40.16', date_upd = NOW() WHERE id_document = '86551' 04/09/2023 04:53:36 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 = '86551' 04/09/2023 04:53:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '86551' 04/09/2023 04:53:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86551' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '28' , '22.950819672131' , '22' , '0' , '28.00' ) 04/09/2023 04:53:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86551' , '11681' , 'CROCE TRAFORATA CON LACCIO' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 04/09/2023 04:53:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86551' , '18838' , 'CAPOCULLA ' , '1' , '-1' , '1' , '19.0000' , '15.573770491803' , '22' , '0' , '19.00' ) 04/09/2023 05:17:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '2672' AND id_document != '87113' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-31') 04/09/2023 05:17:37 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2672', document_date = '2023-08-31', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '111.54', price_tax_excluded = '103.43', date_upd = NOW() WHERE id_document = '87113' 04/09/2023 05:17: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 = '87113' 04/09/2023 05:17:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '87113' 04/09/2023 05:17: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 ( '87113' , '14163' , 'PARACERA OTTONE LUCIDO - Q120' , '1' , '-1' , '1' , '45.0000' , '36.885245901639' , '22' , '0' , '45.00' ) 04/09/2023 05:17: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 ( '87113' , '21146' , 'PARROCCHIE: MEMORIA E CAMBIAMENTO - F. ZACCARIA' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 04/09/2023 05:17: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 ( '87113' , '18176' , 'ANTIQUUM MINISTERIUM ' , '2' , '-2' , '4' , '1.0000' , '1' , '0' , '0' , '2.00' ) 04/09/2023 05:17: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 ( '87113' , '21410' , 'IO E CARLO - M. PAPPALARDO' , '1' , '-1' , '4' , '11.9000' , '11.9' , '0' , '5' , '11.31' ) 04/09/2023 05:17: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 ( '87113' , '12895' , 'PASSI VERSO LA CRESIMA' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '5' , '7.51' ) 04/09/2023 05:17: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 ( '87113' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.85' , '2.85' , '0' , '0' , '2.85' ) 04/09/2023 05:17: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 ( '87113' , '16129' , 'TU MI DONI IL TUO SPIRITO' , '1' , '-1' , '4' , '5.9000' , '5.9' , '0' , '5' , '5.61' ) 04/09/2023 05:17: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 ( '87113' , '14719' , 'TU MI AMI DAVVERO' , '1' , '-1' , '4' , '5.9000' , '5.9' , '0' , '5' , '5.61' ) 04/09/2023 05:17: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 ( '87113' , '10751' , 'TU MI PERDONI' , '1' , '-1' , '4' , '5.9000' , '5.9' , '0' , '5' , '5.61' ) 04/09/2023 05:17: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 ( '87113' , '10748' , 'TU MI CHIAMI PER NOME' , '1' , '-1' , '4' , '5.9000' , '5.9' , '0' , '5' , '5.61' ) 04/09/2023 05:17: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 ( '87113' , '13397' , 'MIO GESU' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 04/09/2023 05:17: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 ( '87113' , '12813' , 'MARIA MADRE NOSTRA' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 04/09/2023 05:19:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '2713' AND id_document != '87159' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-01') 04/09/2023 05:19:27 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2713', document_date = '2023-09-01', 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 = '48.00', price_tax_excluded = '43.31', date_upd = NOW() WHERE id_document = '87159' 04/09/2023 05:19: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 = '87159' 04/09/2023 05:19:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '87159' 04/09/2023 05:19: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 ( '87159' , '15801' , 'ARGENTO A PESO' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 04/09/2023 05:19: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 ( '87159' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '5.8500' , '5.85' , '0' , '0' , '5.85' ) 04/09/2023 05:19: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 ( '87159' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '13' , '10.655737704918' , '22' , '0' , '13.00' ) 04/09/2023 05:19: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 ( '87159' , '21338' , 'DIO DI ABRAMO - A. MELLO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '5' , '16.15' ) 04/09/2023 05:19:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '1772' AND id_document != '84465' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-22') 04/09/2023 05:19:55 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1772', document_date = '2023-05-22', 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 = '105.00', price_tax_excluded = '86.07', date_upd = NOW() WHERE id_document = '84465' 04/09/2023 05:19:55 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 = '84465' 04/09/2023 05:19:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '84465' 04/09/2023 05:19:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84465' , '19598' , 'MEDAGLIA SPILLA SPIRITO SANTO - G24OX' , '38' , '-38' , '1' , '1.4000' , '1.1475409836066' , '22' , '0' , '53.20' ) 04/09/2023 05:19:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84465' , '7933' , 'PERGAMENE - CRESIMA MOD. B' , '40' , '-40' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '20.00' ) 04/09/2023 05:19:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84465' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '30.8' , '25.245901639344' , '22' , '0' , '30.80' ) 04/09/2023 05:19:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84465' , '1231' , 'BIGLIETTO BATTESIMO - ROSA - 598-P.G.1' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 04/09/2023 05:20:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '2632' AND id_document != '87065' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-28') 04/09/2023 05:20:19 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2632', document_date = '2023-08-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 = '4.76', price_tax_excluded = '4.76', date_upd = NOW() WHERE id_document = '87065' 04/09/2023 05:20:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87065' 04/09/2023 05:20:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '87065' 04/09/2023 05:20:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87065' , '19264' , 'UN PAPA PER TUTTI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 04/09/2023 05:20:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87065' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.38' , '2.38' , '0' , '0' , '2.38' ) 04/09/2023 05:39:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '2729' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-04') 04/09/2023 05:39:05 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' , '2729' , '2023-09-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 04/09/2023 05:39:05 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 = '87181' 04/09/2023 05:39:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '87181' 04/09/2023 05:39: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 ( '87181' , '21192' , 'SULLA TUA PAROLA - SET/OTT 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 04/09/2023 06:00:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '2730' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-04') 04/09/2023 06:00: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' , '2730' , '2023-09-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.60' , '3.77' , NOW() , NOW() ) 04/09/2023 06:00: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 = '87182' 04/09/2023 06:00:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '87182' 04/09/2023 06:00: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 ( '87182' , '17276' , 'CONFEZIONE COLLANINA CON MIRACOLOSA E STRASS - 1911' , '1' , '-1' , '1' , '4.60' , '3.7704918032787' , '22' , '0' , '4.60' ) 04/09/2023 06:15:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '2731' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-04') 04/09/2023 06:15: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' , '2731' , '2023-09-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.00' , '17.39' , NOW() , NOW() ) 04/09/2023 06:15: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 = '87183' 04/09/2023 06:15:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '87183' 04/09/2023 06:15: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 ( '87183' , '20515' , 'DECINA ULIVO - 04/7-D' , '40' , '-40' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '20.00' ) 04/09/2023 06:15: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 ( '87183' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1' , '1' , '0' , '0' , '1.00' ) 04/09/2023 06:54:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '2732' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-04') 04/09/2023 06:54:33 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' , '2732' , '2023-09-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '97.00' , '79.51' , NOW() , NOW() ) 04/09/2023 06:54:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87184' 04/09/2023 06:54:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '87184' 04/09/2023 06:54:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87184' , '21504' , 'CUSTODIA PELLE BIBBIA SCRUTATE - 3732' , '2' , '-2' , '1' , '35' , '28.688524590164' , '22' , '0' , '70.00' ) 04/09/2023 06:54:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87184' , '3260' , 'CUSTODIA LITURGIA DELLE ORE IN PELLE - 4 VOL ' , '1' , '-1' , '1' , '27.00' , '22.131147540984' , '22' , '0' , '27.00' ) 04/09/2023 06:56:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '2632' AND id_document != '87065' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-28') 04/09/2023 06:56:09 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2632', document_date = '2023-08-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 = '4.76', price_tax_excluded = '4.76', date_upd = NOW() WHERE id_document = '87065' 04/09/2023 06:56:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87065' 04/09/2023 06:56:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '87065' 04/09/2023 06:56: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 ( '87065' , '19264' , 'UN PAPA PER TUTTI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 04/09/2023 06:56: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 ( '87065' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.88' , '1.88' , '0' , '0' , '1.88' ) 04/09/2023 06:56: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 ( '87065' , '21196' , 'CALENDARIO LITURGICO 2024' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 04/09/2023 06:57:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '2733' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-04') 04/09/2023 06:57:20 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2733' , '2023-09-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 04/09/2023 06:57:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87185' 04/09/2023 06:57:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '87185' 04/09/2023 06:57:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87185' , '21192' , 'SULLA TUA PAROLA - SET/OTT 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' )