06/06/2023 08:57:35 am >> SELECT document_num FROM ps_document WHERE document_num = '1953' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-06') 06/06/2023 08:57:35 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' , '1953' , '2023-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.75' , '23.75' , NOW() , NOW() ) 06/06/2023 08:57:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85706' 06/06/2023 08:57:35 am >> DELETE FROM ps_document_detail WHERE id_document = '85706' 06/06/2023 08:57:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85706' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '5' , '-5' , '4' , '5.00' , '5' , '0' , '5' , '23.75' ) 06/06/2023 09:27:31 am >> SELECT document_num FROM ps_document WHERE document_num = '1954' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-06') 06/06/2023 09:27:31 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1954' , '2023-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.00' , '46.72' , NOW() , NOW() ) 06/06/2023 09:27:31 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85707' 06/06/2023 09:27:31 am >> DELETE FROM ps_document_detail WHERE id_document = '85707' 06/06/2023 09:27:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85707' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 06/06/2023 09:27:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85707' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '1' , '-1' , '1' , '0.6' , '0.49180327868852' , '22' , '0' , '0.60' ) 06/06/2023 09:55:35 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' , '247/23' , '2023-05-31' , '23' , '0' , '159' , '4673403' , 'VIA PANNOSE 45 83025 MONTORO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '450.32' , '433.00' , NOW() , NOW() ) 06/06/2023 09:55:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85708' 06/06/2023 09:55:35 am >> DELETE FROM ps_document_detail WHERE id_document = '85708' 06/06/2023 09:55:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85708' , '20954' , 'TEMPO DELL’APOCALISSE ' , '250' , '0' , '3' , '1.732' , '1.6653846153846' , '4' , '0' , '450.3200' ) 06/06/2023 09:55:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '20954' AND id_supplier = '159' 06/06/2023 09:55:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20954' , '159' , '1' ) 06/06/2023 10:05:19 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '6023267506' , '2023-05-31' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '3.22' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '109.28' , '109.28' , NOW() , NOW() ) 06/06/2023 10:05:19 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85709' 06/06/2023 10:05:19 am >> DELETE FROM ps_document_detail WHERE id_document = '85709' 06/06/2023 10:05:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85709' , '21060' , 'PREPARARSI ALL\'AMORE - L. DUMOULIN' , '1' , '0' , '4' , '12.35' , '12.35' , '0' , '0' , '12.3500' ) 06/06/2023 10:05:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '21060' AND id_supplier = '109' 06/06/2023 10:05:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21060' , '109' , '1' ) 06/06/2023 10:05:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85709' , '17864' , 'MESSALE QUOTIDIANO GRANDE - N. E. ' , '2' , '0' , '4' , '34.5' , '34.5' , '0' , '0' , '69.0000' ) 06/06/2023 10:05:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '17864' AND id_supplier = '109' 06/06/2023 10:05:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17864' , '109' , '1' ) 06/06/2023 10:05:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85709' , '21136' , 'REGOLA DI BENEDETTO - J. CHITTISTER' , '1' , '0' , '4' , '15.61' , '15.61' , '0' , '0' , '15.6100' ) 06/06/2023 10:05:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '21136' AND id_supplier = '109' 06/06/2023 10:05:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21136' , '109' , '1' ) 06/06/2023 10:05:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85709' , '21135' , 'PIENAMENTE VIVI - J. MAIN' , '1' , '0' , '4' , '9.1' , '9.1' , '0' , '0' , '9.1000' ) 06/06/2023 10:05:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '21135' AND id_supplier = '109' 06/06/2023 10:05:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21135' , '109' , '1' ) 06/06/2023 10:07:25 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' , '6023267507' , '2023-05-31' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '4.42' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '159.53' , '159.53' , NOW() , NOW() ) 06/06/2023 10:07:25 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 = '85710' 06/06/2023 10:07:25 am >> DELETE FROM ps_document_detail WHERE id_document = '85710' 06/06/2023 10:07:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85710' , '20941' , 'PASSIONE DI GESU - E. BERNARDI' , '1' , '0' , '4' , '12.6' , '12.6' , '0' , '0' , '12.6000' ) 06/06/2023 10:07:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '20941' AND id_supplier = '109' 06/06/2023 10:07:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20941' , '109' , '1' ) 06/06/2023 10:07:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85710' , '21061' , 'ALLE SORGENTI DELLA FEDE IN TERRA SANTA - F. VOLTAGGIO' , '1' , '0' , '4' , '12.6' , '12.6' , '0' , '0' , '12.6000' ) 06/06/2023 10:07:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '21061' AND id_supplier = '109' 06/06/2023 10:07:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21061' , '109' , '1' ) 06/06/2023 10:07:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85710' , '21059' , 'PADRONE DEL MONDO - R. H. BENSON' , '10' , '0' , '4' , '10.15' , '10.15' , '0' , '0' , '101.5000' ) 06/06/2023 10:07:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '21059' AND id_supplier = '109' 06/06/2023 10:07:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21059' , '109' , '1' ) 06/06/2023 10:07:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85710' , '17702' , 'BENEDETTO XVI - P. SEEWALD' , '1' , '0' , '4' , '28.41' , '28.41' , '0' , '0' , '28.4100' ) 06/06/2023 10:07:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '17702' AND id_supplier = '109' 06/06/2023 10:07:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17702' , '109' , '1' ) 06/06/2023 10:07:49 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801106480' AND id_product != '10062' AND ean13 != '' 06/06/2023 10:07:49 am >> UPDATE ps_product SET id_supplier = '', reference = '5/5', ean13 = '9788801106480', date_upd = NOW() WHERE id_product = '10062' 06/06/2023 10:07:50 am >> UPDATE ps_product_lang SET name = 'SOLO IL VENTO LO SA - BRUNO FERRERO', description = '' WHERE id_product = '10062' 06/06/2023 10:07:50 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5.0000' WHERE id_product = '10062' 06/06/2023 10:07:50 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5.0000', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '10062' 06/06/2023 10:07:50 am >> DELETE FROM ps_specific_price WHERE id_product = '10062' 06/06/2023 10:18:49 am >> SELECT document_num FROM ps_document WHERE document_num = '1894' AND id_document != '85631' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-30') 06/06/2023 10:18:49 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1894', document_date = '2023-05-30', 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 = '42.00', price_tax_excluded = '42.00', date_upd = NOW() WHERE id_document = '85631' 06/06/2023 10:18:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85631' 06/06/2023 10:18:50 am >> DELETE FROM ps_document_detail WHERE id_document = '85631' 06/06/2023 10:18:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85631' , '1146' , 'BIBBIA DI GERUSALEMME X OCCASIONI ' , '1' , '-1' , '4' , '42' , '42' , '0' , '0' , '42.00' ) 06/06/2023 10:19:04 am >> SELECT document_num FROM ps_document WHERE document_num = '1955' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-06') 06/06/2023 10:19:04 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1955' , '2023-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '11.48' , NOW() , NOW() ) 06/06/2023 10:19:04 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85711' 06/06/2023 10:19:04 am >> DELETE FROM ps_document_detail WHERE id_document = '85711' 06/06/2023 10:19: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 ( '85711' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '4' , '-4' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '14.00' ) 06/06/2023 10:41:12 am >> SELECT document_num FROM ps_document WHERE document_num = '1956' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-06') 06/06/2023 10:41: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 ( '11' , '1956' , '2023-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.80' , '6.39' , NOW() , NOW() ) 06/06/2023 10:41: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 = '85712' 06/06/2023 10:41:12 am >> DELETE FROM ps_document_detail WHERE id_document = '85712' 06/06/2023 10:41: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 ( '85712' , '17276' , 'CONFEZIONE COLLANINA CON MIRACOLOSA E STRASS - 1911' , '1' , '-1' , '1' , '4.60' , '3.7704918032787' , '22' , '0' , '4.60' ) 06/06/2023 10:41: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 ( '85712' , '13357' , 'PORTACHIAVI DEVOZIONALI' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 06/06/2023 10:41: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 ( '85712' , '16308' , 'PORTACHIAVI COLOMBA - KP039' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 06/06/2023 10:43:16 am >> SELECT document_num FROM ps_document WHERE document_num = '1956' AND id_document != '85712' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-06') 06/06/2023 10:43:16 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1956', document_date = '2023-06-06', 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 = '7.80', price_tax_excluded = '6.39', date_upd = NOW() WHERE id_document = '85712' 06/06/2023 10:43:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85712' 06/06/2023 10:43:16 am >> DELETE FROM ps_document_detail WHERE id_document = '85712' 06/06/2023 10:43:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85712' , '17276' , 'CONFEZIONE COLLANINA CON MIRACOLOSA E STRASS - 1911' , '1' , '-1' , '1' , '4.6000' , '3.7704918032787' , '22' , '0' , '4.60' ) 06/06/2023 10:43:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85712' , '13357' , 'PORTACHIAVI DEVOZIONALI' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 06/06/2023 10:43:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85712' , '16308' , 'PORTACHIAVI COLOMBA - KP039' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 06/06/2023 10:58:10 am >> SELECT document_num FROM ps_document WHERE document_num = '1957' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-06') 06/06/2023 10:58:10 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1957' , '2023-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.50' , '10.25' , NOW() , NOW() ) 06/06/2023 10:58:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85713' 06/06/2023 10:58:10 am >> DELETE FROM ps_document_detail WHERE id_document = '85713' 06/06/2023 10:58:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85713' , '15093' , 'BRACCIALE PAX - GOMMA' , '16' , '-16' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '11.20' ) 06/06/2023 10:58:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85713' , '20516' , 'CROCE COMUNIONE - 42/08' , '1' , '-1' , '1' , '1.3' , '1.0655737704918' , '22' , '0' , '1.30' ) 06/06/2023 11:11:30 am >> SELECT document_num FROM ps_document WHERE document_num = '24/E' AND id_document != '85694' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-06-05') 06/06/2023 11:11:30 am >> UPDATE ps_document SET id_document_type = '23', document_num = '24/E', document_date = '2023-06-05', document_letter = 'E', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '55.00', price_tax_excluded = '45.08', date_upd = NOW() WHERE id_document = '85694' 06/06/2023 11:11:30 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 = '85694' 06/06/2023 11:11:30 am >> DELETE FROM ps_document_detail WHERE id_document = '85694' 06/06/2023 11:11:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85694' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '2' , '-2' , '1' , '27.5000' , '22.540983606557' , '22' , '' , '55.00' ) 06/06/2023 11:30:04 am >> SELECT document_num FROM ps_document WHERE document_num = '1958' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-06') 06/06/2023 11:30:04 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1958' , '2023-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '104.80' , '98.99' , NOW() , NOW() ) 06/06/2023 11:30:04 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85714' 06/06/2023 11:30:04 am >> DELETE FROM ps_document_detail WHERE id_document = '85714' 06/06/2023 11:30: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 ( '85714' , '6812' , 'MOCCOLO 80X300 ' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 06/06/2023 11:30: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 ( '85714' , '20941' , 'PASSIONE DI GESU - E. BERNARDI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 06/06/2023 11:30: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 ( '85714' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '7.2' , '7.2' , '0' , '0' , '7.20' ) 06/06/2023 11:30: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 ( '85714' , '5461' , 'IO SONO IL PANE DELLA VITA - 8391' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 06/06/2023 11:30: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 ( '85714' , '19138' , 'ATTO DI ABBANDONO - D. D. RUOTOLO' , '3' , '-3' , '4' , '1.00' , '1' , '0' , '0' , '3.00' ) 06/06/2023 11:30: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 ( '85714' , '7395' , 'PADRE PIO - UN PENSIERO PER OGNI GIORNO - 8142' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 06/06/2023 11:30: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 ( '85714' , '19871' , 'LUCE DELLA VITA' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 06/06/2023 11:30: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 ( '85714' , '8383' , 'PREGHIERE PER LADORAZIONE EUCARISTICA - 8141' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 06/06/2023 11:30: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 ( '85714' , '10071' , 'SONO ANZIANO SIGNORE, AIUTAMI A PREGARE' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '0' , '5.00' ) 06/06/2023 11:30: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 ( '85714' , '15020' , 'PREGARE OGNI GIORNO' , '3' , '-3' , '4' , '1.00' , '1' , '0' , '0' , '3.00' ) 06/06/2023 11:30: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 ( '85714' , '978' , 'BEATA VERGINE MARIA CHE SCIOGLIE I NODI - ALBERO GENEALOGICO' , '1' , '-1' , '4' , '2.20' , '2.2' , '0' , '0' , '2.20' ) 06/06/2023 11:30: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 ( '85714' , '19487' , 'ROSARIO - R. LUPI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 06/06/2023 11:30: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 ( '85714' , '7134' , 'NOZIONI E PRECI' , '1' , '-1' , '4' , '1.30' , '1.3' , '0' , '0' , '1.30' ) 06/06/2023 11:30: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 ( '85714' , '13084' , 'PRIMI VENERDI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 06/06/2023 11:30: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 ( '85714' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 06/06/2023 11:30: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 ( '85714' , '15387' , 'VESTINA BATTESIMALE ' , '5' , '-5' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '15.00' ) 06/06/2023 11:34:26 am >> SELECT document_num FROM ps_document WHERE document_num = '1959' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-06') 06/06/2023 11:34:26 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' , '1959' , '2023-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '11.54' , NOW() , NOW() ) 06/06/2023 11:34:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85715' 06/06/2023 11:34:26 am >> DELETE FROM ps_document_detail WHERE id_document = '85715' 06/06/2023 11:34:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85715' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '3' , '-3' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '12.00' ) 06/06/2023 11:50:22 am >> SELECT document_num FROM ps_document WHERE document_num = '1960' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-06') 06/06/2023 11:50:22 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1960' , '2023-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '187.80' , '153.93' , NOW() , NOW() ) 06/06/2023 11:50:22 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85716' 06/06/2023 11:50:22 am >> DELETE FROM ps_document_detail WHERE id_document = '85716' 06/06/2023 11:50:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85716' , '1621' , 'CANDELE CONICHE 10 PZ' , '2' , '-2' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '15.80' ) 06/06/2023 11:50:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85716' , '8935' , 'RICAMBIO PER TORCIA NIKEL - DIAM. 4 - 32' , '2' , '-2' , '1' , '37.00' , '30.327868852459' , '22' , '0' , '74.00' ) 06/06/2023 11:50:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85716' , '20438' , 'CANDELE VOTIVE 20X40 3B' , '1' , '-1' , '1' , '68' , '55.737704918033' , '22' , '0' , '68.00' ) 06/06/2023 11:50:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85716' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 06/06/2023 11:54:22 am >> SELECT document_num FROM ps_document WHERE document_num = '1961' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-06') 06/06/2023 11:54:22 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1961' , '2023-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.00' , '20.49' , NOW() , NOW() ) 06/06/2023 11:54:22 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85717' 06/06/2023 11:54:22 am >> DELETE FROM ps_document_detail WHERE id_document = '85717' 06/06/2023 11:54:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85717' , '7915' , 'PERGAMENE - 1A COMUNIONE MOD. D' , '50' , '-50' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '25.00' ) 06/06/2023 12:41:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '1962' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-06') 06/06/2023 12:41:46 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' , '1962' , '2023-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.50' , '9.71' , NOW() , NOW() ) 06/06/2023 12:41: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 = '85718' 06/06/2023 12:41:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '85718' 06/06/2023 12:41: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 ( '85718' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '8.50' ) 06/06/2023 12:41: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 ( '85718' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 06/06/2023 12:41: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 ( '85718' , '6019' , 'LUMINO ROSSO - 10B' , '2' , '-2' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '1.00' ) 06/06/2023 12:46:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '1963' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-06') 06/06/2023 12:46:06 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' , '1963' , '2023-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.35' , '12.35' , NOW() , NOW() ) 06/06/2023 12:46:06 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 = '85719' 06/06/2023 12:46:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '85719' 06/06/2023 12:46:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85719' , '21048' , 'MESSA MEDITAZIONE - LUG/AGO 2023' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 06/06/2023 12:46:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85719' , '9690' , 'SCAPOLARE DEL CARMELO - 8339' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 06/06/2023 12:51:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '5902689355479' AND id_product != '16308' AND ean13 != '' 06/06/2023 12:51:07 pm >> UPDATE ps_product SET id_supplier = '123', reference = '', ean13 = '5902689355479', date_upd = NOW() WHERE id_product = '16308' 06/06/2023 12:51:07 pm >> UPDATE ps_product_lang SET name = 'PORTACHIAVI SAN BENEDETTO', description = '' WHERE id_product = '16308' 06/06/2023 12:51:07 pm >> UPDATE ps_product SET wholesale_price = '0.39', on_sale = '0', price = '0.9836' WHERE id_product = '16308' 06/06/2023 12:51:07 pm >> UPDATE ps_product_shop SET wholesale_price = '0.39', price = '0.9836', id_tax_rules_group = '1', id_category_default = '443', 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 = '16308' 06/06/2023 12:51:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '16308' 06/06/2023 12:51:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '1956' AND id_document != '85712' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-06') 06/06/2023 12:51:33 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1956', document_date = '2023-06-06', 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 = '7.80', price_tax_excluded = '6.39', date_upd = NOW() WHERE id_document = '85712' 06/06/2023 12:51: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 = '85712' 06/06/2023 12:51:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '85712' 06/06/2023 12:51:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85712' , '17276' , 'CONFEZIONE COLLANINA CON MIRACOLOSA E STRASS - 1911' , '1' , '-1' , '1' , '4.6000' , '3.7704918032787' , '22' , '0' , '4.60' ) 06/06/2023 12:51:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85712' , '13357' , 'PORTACHIAVI DEVOZIONALI' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 06/06/2023 12:51:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85712' , '16308' , 'PORTACHIAVI SAN BENEDETTO' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 06/06/2023 02:42:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '9/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-06-06') 06/06/2023 02:42:25 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 ( '22' , '9/S' , '2023-06-06' , 'S' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'VENDUTO MAGGIO 2023' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '1609.25' , '1609.25' , NOW() , NOW() ) 06/06/2023 02:42:25 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 = '11336' 06/06/2023 02:42:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '11336' 06/06/2023 02:42:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '9' , 'PSICOLOGIA PRATICA PER EDUCATORI' , '2' , '0' , '4' , '10.50' , '10.5' , '0' , '50' , '10.50' ) 06/06/2023 02:42:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '17' , 'LA FEDE NELLO ZAINETTO' , '109' , '0' , '4' , '6.00' , '6' , '0' , '50' , '327.00' ) 06/06/2023 02:42:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '20' , 'GIOVEDÌ SANTO' , '3' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '2.25' ) 06/06/2023 02:42:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '21' , 'LA COMUNIONE' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 06/06/2023 02:42:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '134' , 'AVE MARIA SPIEGATA AI BAMBINI - N.E.' , '5' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '4.50' ) 06/06/2023 02:42:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '117' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '87.75' ) 06/06/2023 02:42:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '73' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '91.25' ) 06/06/2023 02:42:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '57' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '71.25' ) 06/06/2023 02:42:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '121' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '3' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 06/06/2023 02:42:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '97' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '121.25' ) 06/06/2023 02:42:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '125' , 'MIE PREGHIERINE - N. E.' , '48' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '36.00' ) 06/06/2023 02:42:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '33' , '100 GIORNI CON LO SPIRITO' , '41' , '0' , '4' , '7.50' , '7.5' , '0' , '50' , '153.75' ) 06/06/2023 02:42:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '35' , 'ANGELI - I NOSTRI MIGLIORI AMICI' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 06/06/2023 02:42:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '38' , 'MADRE TERESA, UNA MISSIONARIA' , '2' , '0' , '4' , '2.60' , '2.6' , '0' , '50' , '2.60' ) 06/06/2023 02:42:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '42' , 'ALLA SCOPERTA DELLA CASA DI GESU' , '3' , '0' , '4' , '3.00' , '3' , '0' , '50' , '4.50' ) 06/06/2023 02:42:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '50' , 'PERDONAMI SIGNORE' , '10' , '0' , '4' , '2' , '2' , '0' , '50' , '10.00' ) 06/06/2023 02:42:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '55' , 'AVE MARIA ,SPIEGATA AI BAMBINI' , '3' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '2.25' ) 06/06/2023 02:42:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 06/06/2023 02:42:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '2' , '0' , '4' , '30.00' , '30' , '0' , '50' , '30.00' ) 06/06/2023 02:42:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '66' , 'BEATI GLI INVITATI ALLA CENA DEL SIGNORE' , '11' , '0' , '4' , '6.50' , '6.5' , '0' , '50' , '35.75' ) 06/06/2023 02:42:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '8' , '0' , '4' , '2.00' , '2' , '0' , '50' , '8.00' ) 06/06/2023 02:42:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '74' , 'DIO È , IN DIECI PAROLE' , '2' , '0' , '4' , '4.50' , '4.5' , '0' , '50' , '4.50' ) 06/06/2023 02:42:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '75' , 'IL SEGNO DELLA CROCE' , '2' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '1.50' ) 06/06/2023 02:42:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '92' , 'LA PREGHIERA DEL ROSARIO' , '23' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '28.75' ) 06/06/2023 02:42:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '99' , 'AVE MARIA PREGHIERE MARIANE' , '6' , '0' , '4' , '2.00' , '2' , '0' , '50' , '6.00' ) 06/06/2023 02:42:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '101' , 'GESU BENEDICI LA NOSTRA FAMIGLIA' , '1' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 06/06/2023 02:42:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '103' , 'Lo Spirito Santo raccontato ai ragazzi N.E.' , '14' , '0' , '4' , '2.00' , '2' , '0' , '50' , '14.00' ) 06/06/2023 02:42:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '104' , 'TEMPO DI QUARESIMA' , '2' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 06/06/2023 02:42:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '46' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '57.50' ) 06/06/2023 02:42:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '110' , 'SE MI AMI NON PIANGERE' , '19' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '17.10' ) 06/06/2023 02:42:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '111' , 'I NONNI SONO UN TESORO' , '50' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '45.00' ) 06/06/2023 02:42:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '123' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '2' , '0' , '4' , '3.00' , '3' , '0' , '50' , '3.00' ) 06/06/2023 02:42:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '115' , 'SAN FRANCESCO DASSISI RACCONTATO AI RAGAZZI N.E.' , '12' , '0' , '4' , '4.00' , '4' , '0' , '50' , '24.00' ) 06/06/2023 02:42:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '117' , 'La preghiera delle cinque dita n.e.' , '67' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '60.30' ) 06/06/2023 02:42:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '52' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '65.00' ) 06/06/2023 02:42:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '119' , 'Rosario spiegato ai bambini ' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 06/06/2023 02:42:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '98' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '122.50' ) 06/06/2023 02:42:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '8' , '0' , '4' , '3.00' , '3' , '0' , '50' , '12.00' ) 06/06/2023 02:42:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '7' , '0' , '4' , '18.00' , '18' , '0' , '50' , '63.00' ) 06/06/2023 02:42:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '126' , 'SACRAMENTO DEL PERDONO' , '75' , '0' , '4' , '2.00' , '2' , '0' , '50' , '75.00' ) 06/06/2023 02:50:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '10/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-06-06') 06/06/2023 02:50:15 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '25' , '10/S' , '2023-06-06' , 'S' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RESA MAGGIO 2023' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '181.30' , '181.30' , NOW() , NOW() ) 06/06/2023 02:50:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '11337' 06/06/2023 02:50:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '11337' 06/06/2023 02:50:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11337' , '9' , 'PSICOLOGIA PRATICA PER EDUCATORI' , '3' , '3' , '4' , '10.50' , '10.5' , '0' , '50' , '15.75' ) 06/06/2023 02:50:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11337' , '20' , 'GIOVEDÌ SANTO' , '4' , '4' , '4' , '1.50' , '1.5' , '0' , '50' , '3.00' ) 06/06/2023 02:50:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11337' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '7' , '7' , '4' , '2.50' , '2.5' , '0' , '50' , '8.75' ) 06/06/2023 02:50:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11337' , '55' , 'AVE MARIA ,SPIEGATA AI BAMBINI' , '1' , '1' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 06/06/2023 02:50:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11337' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '8' , '8' , '4' , '2.00' , '2' , '0' , '50' , '8.00' ) 06/06/2023 02:50:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11337' , '75' , 'IL SEGNO DELLA CROCE' , '1' , '1' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 06/06/2023 02:50:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11337' , '92' , 'LA PREGHIERA DEL ROSARIO' , '4' , '4' , '4' , '2.50' , '2.5' , '0' , '50' , '5.00' ) 06/06/2023 02:50:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11337' , '96' , 'LA PREGHIERA - MEDICINA DELLANIMA' , '1' , '1' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 06/06/2023 02:50:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11337' , '99' , 'AVE MARIA PREGHIERE MARIANE' , '1' , '1' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 06/06/2023 02:50:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11337' , '103' , 'Lo Spirito Santo raccontato ai ragazzi N.E.' , '8' , '8' , '4' , '2.00' , '2' , '0' , '50' , '8.00' ) 06/06/2023 02:50:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11337' , '104' , 'TEMPO DI QUARESIMA' , '25' , '25' , '4' , '2.50' , '2.5' , '0' , '50' , '31.25' ) 06/06/2023 02:50:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11337' , '111' , 'I NONNI SONO UN TESORO' , '11' , '11' , '4' , '1.80' , '1.8' , '0' , '50' , '9.90' ) 06/06/2023 02:50:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11337' , '114' , 'Le preghiere dei ragazzi' , '11' , '11' , '4' , '1.50' , '1.5' , '0' , '50' , '8.25' ) 06/06/2023 02:50:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11337' , '117' , 'La preghiera delle cinque dita n.e.' , '1' , '1' , '4' , '1.80' , '1.8' , '0' , '50' , '0.90' ) 06/06/2023 02:50:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11337' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 06/06/2023 02:50:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11337' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '2' , '2' , '4' , '18.00' , '18' , '0' , '50' , '18.00' ) 06/06/2023 02:50:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11337' , '126' , 'SACRAMENTO DEL PERDONO' , '60' , '60' , '4' , '2.00' , '2' , '0' , '50' , '60.00' ) 06/06/2023 03:05:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '25/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-06-06') 06/06/2023 03:05: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 ( '22' , '25/E' , '2023-06-06' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '794.07' , '793.44' , NOW() , NOW() ) 06/06/2023 03:05: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 = '85720' 06/06/2023 03:05:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '85720' 06/06/2023 03:05: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 ( '85720' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '41' , '0' , '4' , '2.40' , '2.4' , '0' , '50' , '49.20' ) 06/06/2023 03:05: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 ( '85720' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 06/06/2023 03:05: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 ( '85720' , '5446' , 'IO SONO CON VOI - GUIDA' , '2' , '0' , '4' , '8.00' , '8' , '0' , '50' , '8.00' ) 06/06/2023 03:05: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 ( '85720' , '11183' , 'VENITE CON ME - GUIDA' , '1' , '0' , '4' , '6.00' , '6' , '0' , '50' , '3.00' ) 06/06/2023 03:05: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 ( '85720' , '2448' , 'COLUI IN CUI CREDO' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 06/06/2023 03:05: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 ( '85720' , '9675' , 'SARETE MIEI TESTIMONI' , '3' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '5.25' ) 06/06/2023 03:05: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 ( '85720' , '8254' , 'PREGHIAMO CON MARIA' , '3' , '0' , '4' , '0.65' , '0.65' , '0' , '50' , '0.98' ) 06/06/2023 03:05: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 ( '85720' , '5457' , 'IO SONO CON VOI 1 PARTE' , '13' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '16.25' ) 06/06/2023 03:05: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 ( '85720' , '5458' , 'IO SONO CON VOI 2 PARTE' , '3' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 06/06/2023 03:05: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 ( '85720' , '11191' , 'VENITE CON ME 1 PARTE' , '4' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '5.00' ) 06/06/2023 03:05: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 ( '85720' , '11192' , 'VENITE CON ME 2 PARTE' , '3' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 06/06/2023 03:05:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '11312' , 'VIA CRUCIS PER RAGAZZI ' , '1' , '0' , '4' , '0.85' , '0.85' , '0' , '50' , '0.42' ) 06/06/2023 03:05:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '523' , 'AMORE VINCE LA MORTE - VIA CRUCIS' , '1' , '0' , '4' , '0.85' , '0.85' , '0' , '50' , '0.42' ) 06/06/2023 03:05:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '1' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 06/06/2023 03:05:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '2' , '0' , '4' , '10.00' , '10' , '0' , '50' , '10.00' ) 06/06/2023 03:05:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '8243' , 'PREGARE OGNI GIORNO' , '3' , '0' , '4' , '1.00' , '1' , '0' , '50' , '1.50' ) 06/06/2023 03:05:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '2' , '0' , '4' , '3.40' , '3.4' , '0' , '50' , '3.40' ) 06/06/2023 03:05:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '1' , '0' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 06/06/2023 03:05:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '9996' , 'SIGNORE, TI PREGO' , '1' , '0' , '4' , '6.00' , '6' , '0' , '50' , '3.00' ) 06/06/2023 03:05:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '11308' , 'VIA CRUCIS ' , '2' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '1.50' ) 06/06/2023 03:05:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '1' , '0' , '4' , '8.00' , '8' , '0' , '50' , '4.00' ) 06/06/2023 03:05:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '6629' , 'MIA PREGHIERA' , '83' , '0' , '4' , '0.90' , '0.9' , '0' , '50' , '37.35' ) 06/06/2023 03:05:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '8408' , 'PRENDETE E MANGIATE' , '3' , '0' , '4' , '3.00' , '3' , '0' , '50' , '4.50' ) 06/06/2023 03:05:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '0' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 06/06/2023 03:05:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '0' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 06/06/2023 03:05:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '4154' , 'FESTA DEL PERDONO' , '4' , '0' , '4' , '3.00' , '3' , '0' , '50' , '6.00' ) 06/06/2023 03:05:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '7824' , 'PER ILLUMINARE IL CAMMINO' , '1' , '0' , '4' , '0.90' , '0.9' , '0' , '50' , '0.45' ) 06/06/2023 03:05:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '2679' , 'CONOSCERE GESU' , '8' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '14.00' ) 06/06/2023 03:05:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '2680' , 'CONOSCERE GESU - GUIDA' , '1' , '0' , '4' , '6.00' , '6' , '0' , '50' , '3.00' ) 06/06/2023 03:05:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '76' , '0' , '4' , '5.00' , '5' , '0' , '50' , '190.00' ) 06/06/2023 03:05:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '11102' , 'VANGELO E ATTI DEGLI APOSTOLI - RIL.' , '4' , '0' , '4' , '8.50' , '8.5' , '0' , '50' , '17.00' ) 06/06/2023 03:05:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '62' , '0' , '4' , '1.60' , '1.6' , '0' , '50' , '49.60' ) 06/06/2023 03:05:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '4' , '0' , '4' , '12.00' , '12' , '0' , '50' , '24.00' ) 06/06/2023 03:05:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '70' , '0' , '4' , '1.60' , '1.6' , '0' , '50' , '56.00' ) 06/06/2023 03:05:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '7543' , 'PARABOLE DI GESÙ' , '1' , '0' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 06/06/2023 03:05:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 06/06/2023 03:05:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 06/06/2023 03:05:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 06/06/2023 03:05:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '63' , '0' , '4' , '1.60' , '1.6' , '0' , '50' , '50.40' ) 06/06/2023 03:05:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '12819' , 'REGISTRO DEL CATECHISTA ' , '7' , '0' , '1' , '1.00' , '0.81967213114754' , '22' , '50' , '3.50' ) 06/06/2023 03:05:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '12253' , 'MIO LIBRO DI PREGHIERE' , '64' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '89.60' ) 06/06/2023 03:05:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '12813' , 'MARIA MADRE NOSTRA' , '3' , '0' , '4' , '3.00' , '3' , '0' , '50' , '4.50' ) 06/06/2023 03:05:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '3' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '5.25' ) 06/06/2023 03:05:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '26' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '45.50' ) 06/06/2023 03:05:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '2' , '0' , '4' , '6.00' , '6' , '0' , '50' , '6.00' ) 06/06/2023 03:05: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 ( '85720' , '15115' , 'CONVERSIONE - G. CELENTANO' , '1' , '0' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 06/06/2023 03:05: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 ( '85720' , '13137' , 'CON LA BIBBIA E IL CATECHISMO - S. LA PEGNA' , '1' , '0' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 06/06/2023 03:05: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 ( '85720' , '13397' , 'MIO GESU' , '16' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '28.00' ) 06/06/2023 03:05: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 ( '85720' , '13956' , 'MIRACOLI DI GESU' , '6' , '0' , '4' , '3.00' , '3' , '0' , '50' , '9.00' ) 06/06/2023 03:05: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 ( '85720' , '14031' , 'SEGNO DELLA CROCE' , '1' , '0' , '4' , '3.00' , '3' , '0' , '50' , '+' ) 06/06/2023 03:23:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '25/E' AND id_document != '85720' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-06-06') 06/06/2023 03:23:14 pm >> UPDATE ps_document SET id_document_type = '22', document_num = '25/E', document_date = '2023-06-06', document_letter = 'E', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'VENDUTO MAGGIO 2023', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '14', id_causal = '0', price_tax_included = '3529.47', price_tax_excluded = '3528.84', date_upd = NOW() WHERE id_document = '85720' 06/06/2023 03:23: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 = '85720' 06/06/2023 03:23:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '85720' 06/06/2023 03:23: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 ( '85720' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '41' , '0' , '4' , '2.4000' , '2.4' , '0' , '50' , '49.20' ) 06/06/2023 03:23: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 ( '85720' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '1' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 06/06/2023 03:23: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 ( '85720' , '5446' , 'IO SONO CON VOI - GUIDA' , '2' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '8.00' ) 06/06/2023 03:23: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 ( '85720' , '11183' , 'VENITE CON ME - GUIDA' , '1' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '3.00' ) 06/06/2023 03:23: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 ( '85720' , '2448' , 'COLUI IN CUI CREDO' , '1' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 06/06/2023 03:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '9675' , 'SARETE MIEI TESTIMONI' , '3' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '5.25' ) 06/06/2023 03:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '8254' , 'PREGHIAMO CON MARIA' , '3' , '0' , '4' , '0.6500' , '0.65' , '0' , '50' , '0.98' ) 06/06/2023 03:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '5457' , 'IO SONO CON VOI 1 PARTE' , '13' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '16.25' ) 06/06/2023 03:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '5458' , 'IO SONO CON VOI 2 PARTE' , '3' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '3.75' ) 06/06/2023 03:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '11191' , 'VENITE CON ME 1 PARTE' , '4' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '5.00' ) 06/06/2023 03:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '11192' , 'VENITE CON ME 2 PARTE' , '3' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '3.75' ) 06/06/2023 03:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '11312' , 'VIA CRUCIS PER RAGAZZI ' , '1' , '0' , '4' , '0.8500' , '0.85' , '0' , '50' , '0.42' ) 06/06/2023 03:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '523' , 'AMORE VINCE LA MORTE - VIA CRUCIS' , '1' , '0' , '4' , '0.8500' , '0.85' , '0' , '50' , '0.42' ) 06/06/2023 03:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '1' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 06/06/2023 03:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '2' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '10.00' ) 06/06/2023 03:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '8243' , 'PREGARE OGNI GIORNO' , '3' , '0' , '4' , '1.0000' , '1' , '0' , '50' , '1.50' ) 06/06/2023 03:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '2' , '0' , '4' , '3.4000' , '3.4' , '0' , '50' , '3.40' ) 06/06/2023 03:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 06/06/2023 03:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '9996' , 'SIGNORE, TI PREGO' , '1' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '3.00' ) 06/06/2023 03:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '11308' , 'VIA CRUCIS ' , '2' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '1.50' ) 06/06/2023 03:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '1' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '4.00' ) 06/06/2023 03:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '6629' , 'MIA PREGHIERA' , '83' , '0' , '4' , '0.9000' , '0.9' , '0' , '50' , '37.35' ) 06/06/2023 03:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '8408' , 'PRENDETE E MANGIATE' , '3' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '4.50' ) 06/06/2023 03:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 06/06/2023 03:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 06/06/2023 03:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '4154' , 'FESTA DEL PERDONO' , '4' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '6.00' ) 06/06/2023 03:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '7824' , 'PER ILLUMINARE IL CAMMINO' , '1' , '0' , '4' , '0.9000' , '0.9' , '0' , '50' , '0.45' ) 06/06/2023 03:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '2679' , 'CONOSCERE GESU' , '8' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '14.00' ) 06/06/2023 03:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '2680' , 'CONOSCERE GESU - GUIDA' , '1' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '3.00' ) 06/06/2023 03:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '76' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '190.00' ) 06/06/2023 03:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '11102' , 'VANGELO E ATTI DEGLI APOSTOLI - RIL.' , '4' , '0' , '4' , '8.5000' , '8.5' , '0' , '50' , '17.00' ) 06/06/2023 03:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '62' , '0' , '4' , '1.6000' , '1.6' , '0' , '50' , '49.60' ) 06/06/2023 03:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '4' , '0' , '4' , '12.0000' , '12' , '0' , '50' , '24.00' ) 06/06/2023 03:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '70' , '0' , '4' , '1.6000' , '1.6' , '0' , '50' , '56.00' ) 06/06/2023 03:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '7543' , 'PARABOLE DI GESÙ' , '1' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '1.50' ) 06/06/2023 03:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 06/06/2023 03:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 06/06/2023 03:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 06/06/2023 03:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '63' , '0' , '4' , '1.6000' , '1.6' , '0' , '50' , '50.40' ) 06/06/2023 03:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '12819' , 'REGISTRO DEL CATECHISTA ' , '7' , '0' , '1' , '1.0000' , '0.81967213114754' , '22' , '50' , '3.50' ) 06/06/2023 03:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '12253' , 'MIO LIBRO DI PREGHIERE' , '64' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '89.60' ) 06/06/2023 03:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '12813' , 'MARIA MADRE NOSTRA' , '3' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '4.50' ) 06/06/2023 03:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '3' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '5.25' ) 06/06/2023 03:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '26' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '45.50' ) 06/06/2023 03:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '2' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '6.00' ) 06/06/2023 03:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '15115' , 'CONVERSIONE - G. CELENTANO' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '50' , '7.50' ) 06/06/2023 03:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '13137' , 'CON LA BIBBIA E IL CATECHISMO - S. LA PEGNA' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '5.00' ) 06/06/2023 03:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '13397' , 'MIO GESU' , '16' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '28.00' ) 06/06/2023 03:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '13956' , 'MIRACOLI DI GESU' , '6' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '9.00' ) 06/06/2023 03:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '14031' , 'SEGNO DELLA CROCE' , '1' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '0.00' ) 06/06/2023 03:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '14030' , 'PADRE NOSTRO' , '8' , '0' , '4' , '3.00' , '3' , '0' , '50' , '12.00' ) 06/06/2023 03:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '14032' , 'AVE MARIA' , '7' , '0' , '4' , '3.00' , '3' , '0' , '50' , '10.50' ) 06/06/2023 03:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '14260' , 'CUORE CHE BATTE - TORNARE AD AMARE IL CREATO' , '1' , '0' , '4' , '8.00' , '8' , '0' , '50' , '4.00' ) 06/06/2023 03:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '14029' , 'ANGELO DI DIO' , '9' , '0' , '4' , '3.00' , '3' , '0' , '50' , '13.50' ) 06/06/2023 03:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '163' , '0' , '4' , '1.00' , '1' , '0' , '50' , '81.50' ) 06/06/2023 03:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '15019' , 'PREGHIAMO CON MARIA' , '8' , '0' , '4' , '0.80' , '0.8' , '0' , '50' , '3.20' ) 06/06/2023 03:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '15020' , 'PREGARE OGNI GIORNO' , '76' , '0' , '4' , '1.00' , '1' , '0' , '50' , '38.00' ) 06/06/2023 03:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '4' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '7.00' ) 06/06/2023 03:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '16041' , 'PRIMI PASSI NEL CAMMINO DI FEDE - M. VIANI' , '1' , '0' , '4' , '6.00' , '6' , '0' , '50' , '3.00' ) 06/06/2023 03:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '19' , '0' , '4' , '1.00' , '1' , '0' , '50' , '9.50' ) 06/06/2023 03:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '34' , '0' , '4' , '2.00' , '2' , '0' , '50' , '34.00' ) 06/06/2023 03:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '16667' , 'VIA CRUCIS' , '6' , '0' , '4' , '3.00' , '3' , '0' , '50' , '9.00' ) 06/06/2023 03:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '16997' , 'PREGHIAMO IL PADRONE DELLA MESSE ' , '2' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 06/06/2023 03:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '17257' , 'IO TI BATTEZZO ' , '51' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '45.90' ) 06/06/2023 03:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '17274' , 'VENITE BENEDETTI DEL PADRE MIO' , '5' , '0' , '4' , '3.00' , '3' , '0' , '50' , '7.50' ) 06/06/2023 03:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '17695' , 'VIA LUCIS CON SAN CESARE DE BUS' , '4' , '0' , '4' , '3.80' , '3.8' , '0' , '50' , '7.60' ) 06/06/2023 03:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '17697' , 'SANTO ROSARIO CON SAN CESARE DE BUS' , '2' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 06/06/2023 03:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '3' , '0' , '4' , '12.00' , '12' , '0' , '50' , '18.00' ) 06/06/2023 03:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '18176' , 'ANTIQUUM MINISTERIUM ' , '10' , '0' , '4' , '1.00' , '1' , '0' , '50' , '5.00' ) 06/06/2023 03:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '18460' , 'CON CUORE DI PADRE - V. SALVOLDI' , '7' , '0' , '4' , '2.00' , '2' , '0' , '50' , '7.00' ) 06/06/2023 03:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '17696' , 'VIA CRUCIS CON SAN CESARE DE BUS' , '2' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 06/06/2023 03:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '33' , '0' , '4' , '1.90' , '1.9' , '0' , '50' , '31.35' ) 06/06/2023 03:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '17861' , 'CARTA DIDENTITA DELLA CHIESA - R. LUPI' , '5' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 06/06/2023 03:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '18528' , 'CON GESU VERSO IL CALVARIO - G. VALSECCHI' , '7' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '5.25' ) 06/06/2023 03:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '18497' , 'BUONA DOMENICA - ANNO A - G. BAGET BOZZO' , '2' , '0' , '4' , '16.00' , '16' , '0' , '50' , '16.00' ) 06/06/2023 03:23:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '18527' , 'SOGNI DI PACE - V. SAVOLDI' , '8' , '0' , '4' , '2.00' , '2' , '0' , '50' , '8.00' ) 06/06/2023 03:23:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '18718' , 'TUA VOCE IN ME + CD - FRA F. MARIA REA' , '1' , '0' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 06/06/2023 03:23:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '18657' , 'HO DATO LORO LA TUA PAROLA - G. VALSECCHI' , '2' , '0' , '4' , '16.00' , '16' , '0' , '50' , '16.00' ) 06/06/2023 03:23:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '13' , '0' , '4' , '7.00' , '7' , '0' , '50' , '45.50' ) 06/06/2023 03:23:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '18423' , 'VIA DI SAN FRANCESCO - G. POLIDORO' , '1' , '0' , '4' , '4.80' , '4.8' , '0' , '50' , '2.40' ) 06/06/2023 03:23:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '5' , '0' , '4' , '2.00' , '2' , '0' , '50' , '5.00' ) 06/06/2023 03:23:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '3' , '0' , '4' , '9.00' , '9' , '0' , '50' , '13.50' ) 06/06/2023 03:23:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '7' , '0' , '4' , '9.00' , '9' , '0' , '50' , '31.50' ) 06/06/2023 03:23:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '1' , '0' , '4' , '9.00' , '9' , '0' , '50' , '4.50' ) 06/06/2023 03:23:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '4' , '0' , '4' , '10.00' , '10' , '0' , '50' , '20.00' ) 06/06/2023 03:23:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '18950' , 'DOVE FINITO IL CONCILIO? - F. CERRI' , '1' , '0' , '4' , '18.00' , '18' , '0' , '50' , '9.00' ) 06/06/2023 03:23:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '19088' , 'TU SOLO IL SANTO - G. VALSECCHI' , '3' , '0' , '4' , '10.00' , '10' , '0' , '50' , '15.00' ) 06/06/2023 03:23:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '19160' , 'PERCHE IL DESERTO TORNI A FIORIRE - A. SALVOLDI' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 06/06/2023 03:23:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '8' , '0' , '4' , '12.00' , '12' , '0' , '50' , '48.00' ) 06/06/2023 03:23:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '20' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '25.00' ) 06/06/2023 03:23:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '16' , '0' , '4' , '4.50' , '4.5' , '0' , '50' , '36.00' ) 06/06/2023 03:23:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '11' , '0' , '4' , '35.00' , '35' , '0' , '50' , '192.50' ) 06/06/2023 03:23:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE' , '24' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '30.00' ) 06/06/2023 03:23:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '20231' , 'PREGANDO NON SPRECATE PAROLE - G. DAMORE' , '9' , '0' , '4' , '10.00' , '10' , '0' , '50' , '45.00' ) 06/06/2023 03:23:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '20640' , 'GESU\', MOSSO A COMPASSIONE V. SALVOLDI' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 06/06/2023 03:23:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '20719' , 'CORONA DELL’ADDOLORATA' , '10' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '9.00' ) 06/06/2023 03:23:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '6' , '0' , '4' , '2.00' , '2' , '0' , '50' , '6.00' ) 06/06/2023 03:23:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '20721' , 'AVE MARIA - L. CALABRETTA' , '11' , '0' , '4' , '4.50' , '4.5' , '0' , '50' , '24.75' ) 06/06/2023 03:23:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '20720' , 'PADRE NOSTRO - L. CALABRETTA' , '6' , '0' , '4' , '4.50' , '4.5' , '0' , '50' , '13.50' ) 06/06/2023 03:23:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '20722' , 'SEMINATORI DI GIOIA' , '90' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '112.50' ) 06/06/2023 03:23:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '20785' , 'CARTA D\'IDENTITA\' DEL CREATO - R. LUPI' , '63' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '78.75' ) 06/06/2023 03:23:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '1' , '0' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 06/06/2023 03:23:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '56' , '0' , '4' , '20.00' , '20' , '0' , '50' , '560.00' ) 06/06/2023 03:23:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '20954' , 'TEMPO DELL’APOCALISSE ' , '2' , '0' , '4' , '15.00' , '15' , '0' , '50' , '15.00' ) 06/06/2023 03:23:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '192' , '0' , '4' , '2.8' , '2.8' , '0' , '50' , '268.80' ) 06/06/2023 03:23:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '336' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '470.40' ) 06/06/2023 03:23:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85720' , '20951' , 'STORIE DEL NOSTRO TEMPO - F. CERRI' , '31' , '0' , '4' , '15.00' , '15' , '0' , '50' , '232.50' ) 06/06/2023 03:25:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '1660' AND id_document != '84332' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-15') 06/06/2023 03:25:26 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1660', document_date = '2023-05-15', 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 = '118.00', price_tax_excluded = '96.72', date_upd = NOW() WHERE id_document = '84332' 06/06/2023 03:25:26 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 = '84332' 06/06/2023 03:25:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '84332' 06/06/2023 03:25:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84332' , '17161' , 'CARBONCINI NERI - CARNE' , '2' , '-2' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '24.00' ) 06/06/2023 03:25:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84332' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 06/06/2023 03:25:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84332' , '9535' , 'SANTANTONIO DA PADOVA - 381 ' , '2' , '-2' , '1' , '3.8000' , '3.1147540983607' , '22' , '0' , '7.60' ) 06/06/2023 03:25: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 ( '84332' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' , '3.8000' , '3.1147540983607' , '22' , '0' , '11.40' ) 06/06/2023 03:25: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 ( '84332' , '8935' , 'RICAMBIO PER TORCIA NIKEL - DIAM. 4 - 32' , '1' , '-1' , '1' , '37.00' , '30.327868852459' , '22' , '0' , '37.00' ) 06/06/2023 03:25: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 ( '84332' , '15392' , 'TELA 18X25 - CROCE' , '1' , '-1' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '8.00' ) 06/06/2023 03:26:39 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '7915' 06/06/2023 03:26:39 pm >> UPDATE ps_stock_available SET quantity = quantity + '-150' WHERE id_product = '7915' 06/06/2023 03:46:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '1964' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-06') 06/06/2023 03:46:25 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' , '1964' , '2023-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '46.10' , '45.43' , NOW() , NOW() ) 06/06/2023 03:46:25 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 = '85721' 06/06/2023 03:46:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '85721' 06/06/2023 03:46:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85721' , '13463' , 'PREGHIERE DEI RAGAZZI - N.E.' , '20' , '-20' , '4' , '1.50' , '1.5' , '0' , '5' , '28.60' ) 06/06/2023 03:46:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85721' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 06/06/2023 03:57:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '26/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-06-06') 06/06/2023 03:57: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 ( '25' , '26/E' , '2023-06-06' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RESA MAGGIO 2023' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '490.93' , '490.21' , NOW() , NOW() ) 06/06/2023 03:57: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 = '85722' 06/06/2023 03:57:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '85722' 06/06/2023 03:57: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 ( '85722' , '106' , 'A MESSA SALTANDO DI GIOIA - GUIDA' , '1' , '1' , '4' , '5.16' , '5.16' , '0' , '50' , '2.58' ) 06/06/2023 03:57: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 ( '85722' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '1' , '4' , '3' , '3' , '0' , '50' , '1.50' ) 06/06/2023 03:57: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 ( '85722' , '11191' , 'VENITE CON ME 1 PARTE' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 06/06/2023 03:57: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 ( '85722' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '5' , '5' , '4' , '3.40' , '3.4' , '0' , '50' , '8.50' ) 06/06/2023 03:57: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 ( '85722' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '2' , '2' , '4' , '5.00' , '5' , '0' , '50' , '5.00' ) 06/06/2023 03:57: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 ( '85722' , '6629' , 'MIA PREGHIERA' , '60' , '60' , '4' , '0.90' , '0.9' , '0' , '50' , '27.00' ) 06/06/2023 03:57: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 ( '85722' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '3' , '3' , '4' , '5.00' , '5' , '0' , '50' , '7.50' ) 06/06/2023 03:57: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 ( '85722' , '2680' , 'CONOSCERE GESU - GUIDA' , '2' , '2' , '4' , '6.00' , '6' , '0' , '50' , '6.00' ) 06/06/2023 03:57: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 ( '85722' , '10364' , 'SULLA STRADA DEL MAESTRO' , '1' , '1' , '4' , '14.00' , '14' , '0' , '50' , '7.00' ) 06/06/2023 03:57: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 ( '85722' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '5' , '5' , '4' , '1.60' , '1.6' , '0' , '50' , '4.00' ) 06/06/2023 03:57: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 ( '85722' , '7543' , 'PARABOLE DI GESÙ' , '1' , '1' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 06/06/2023 03:57: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 ( '85722' , '12819' , 'REGISTRO DEL CATECHISTA ' , '8' , '8' , '1' , '1.00' , '0.81967213114754' , '22' , '50' , '4.00' ) 06/06/2023 03:57: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 ( '85722' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '6' , '6' , '4' , '3.50' , '3.5' , '0' , '50' , '10.50' ) 06/06/2023 03:57: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 ( '85722' , '13137' , 'CON LA BIBBIA E IL CATECHISMO - S. LA PEGNA' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 06/06/2023 03:57: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 ( '85722' , '15019' , 'PREGHIAMO CON MARIA' , '8' , '8' , '4' , '0.80' , '0.8' , '0' , '50' , '3.20' ) 06/06/2023 03:57: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 ( '85722' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '18' , '18' , '4' , '1.00' , '1' , '0' , '50' , '9.00' ) 06/06/2023 03:57: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 ( '85722' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '10' , '10' , '4' , '2.00' , '2' , '0' , '50' , '10.00' ) 06/06/2023 03:57: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 ( '85722' , '16667' , 'VIA CRUCIS' , '11' , '11' , '4' , '3.00' , '3' , '0' , '50' , '16.50' ) 06/06/2023 03:57: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 ( '85722' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '2' , '2' , '4' , '15.00' , '15' , '0' , '50' , '15.00' ) 06/06/2023 03:57: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 ( '85722' , '17827' , 'ISTRUZIONI FAMILIARI VOL. I - IL CREDO ' , '3' , '3' , '4' , '20.00' , '20' , '0' , '50' , '30.00' ) 06/06/2023 03:57: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 ( '85722' , '17695' , 'VIA LUCIS CON SAN CESARE DE BUS' , '9' , '9' , '4' , '3.80' , '3.8' , '0' , '50' , '17.10' ) 06/06/2023 03:57: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 ( '85722' , '17697' , 'SANTO ROSARIO CON SAN CESARE DE BUS' , '4' , '4' , '4' , '2.50' , '2.5' , '0' , '50' , '5.00' ) 06/06/2023 03:57: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 ( '85722' , '18175' , 'VIA DI SAN GIUSEPPE - G. POLIDORO' , '4' , '4' , '4' , '4.80' , '4.8' , '0' , '50' , '9.60' ) 06/06/2023 03:57: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 ( '85722' , '18460' , 'CON CUORE DI PADRE - V. SALVOLDI' , '1' , '1' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 06/06/2023 03:57: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 ( '85722' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '2' , '2' , '4' , '15.00' , '15' , '0' , '50' , '15.00' ) 06/06/2023 03:57: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 ( '85722' , '17696' , 'VIA CRUCIS CON SAN CESARE DE BUS' , '2' , '2' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 06/06/2023 03:57: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 ( '85722' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '1' , '1' , '4' , '1.90' , '1.9' , '0' , '50' , '0.95' ) 06/06/2023 03:57: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 ( '85722' , '18528' , 'CON GESU VERSO IL CALVARIO - G. VALSECCHI' , '8' , '8' , '4' , '1.50' , '1.5' , '0' , '50' , '6.00' ) 06/06/2023 03:57: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 ( '85722' , '18717' , 'ISTRUZIONI FAMILIARI VOL. II - I DIECI COMANDAMENTI ' , '2' , '2' , '4' , '20.00' , '20' , '0' , '50' , '20.00' ) 06/06/2023 03:57: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 ( '85722' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '2' , '2' , '4' , '7.00' , '7' , '0' , '50' , '7.00' ) 06/06/2023 03:57: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 ( '85722' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '1' , '1' , '4' , '9.00' , '9' , '0' , '50' , '4.50' ) 06/06/2023 03:57: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 ( '85722' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 06/06/2023 03:57: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 ( '85722' , '18950' , 'DOVE FINITO IL CONCILIO? - F. CERRI' , '1' , '1' , '4' , '18.00' , '18' , '0' , '50' , '9.00' ) 06/06/2023 03:57: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 ( '85722' , '19088' , 'TU SOLO IL SANTO - G. VALSECCHI' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 06/06/2023 03:57: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 ( '85722' , '19391' , 'ISTRUZIONI FAMILIARI VOL. III - I PRECETTI...' , '1' , '1' , '4' , '20.00' , '20' , '0' , '50' , '10.00' ) 06/06/2023 03:57: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 ( '85722' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 06/06/2023 03:57: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 ( '85722' , '20231' , 'PREGANDO NON SPRECATE PAROLE - G. DAMORE' , '7' , '7' , '4' , '10.00' , '10' , '0' , '50' , '35.00' ) 06/06/2023 03:57: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 ( '85722' , '20640' , 'GESU, MOSSO A COMPASSIONE V. SALVOLDI' , '36' , '36' , '4' , '2.50' , '2.5' , '0' , '50' , '45.00' ) 06/06/2023 03:57: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 ( '85722' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '35' , '35' , '4' , '2.00' , '2' , '0' , '50' , '35.00' ) 06/06/2023 03:57: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 ( '85722' , '20720' , 'PADRE NOSTRO - L. CALABRETTA' , '12' , '12' , '4' , '4.50' , '4.5' , '0' , '50' , '27.00' ) 06/06/2023 03:57: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 ( '85722' , '20722' , 'SEMINATORI DI GIOIA' , '5' , '5' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 06/06/2023 03:57: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 ( '85722' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '7' , '7' , '4' , '2.50' , '2.5' , '0' , '50' , '8.75' ) 06/06/2023 03:57: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 ( '85722' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '8' , '8' , '4' , '10.00' , '10' , '0' , '50' , '40.00' ) 06/06/2023 04:10:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '1965' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-06') 06/06/2023 04:10:39 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' , '1965' , '2023-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '15.00' , NOW() , NOW() ) 06/06/2023 04:10:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85723' 06/06/2023 04:10:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '85723' 06/06/2023 04:10:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85723' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '15' , '15' , '0' , '0' , '15.00' ) 06/06/2023 04:14:00 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '223' , '2023-05-22' , '' , '0' , '0' , '2648' , '' , '' , '' , '-0.62' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '23424.34' , '22523.38' , NOW() , NOW() ) 06/06/2023 04:14:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85724' 06/06/2023 04:14:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '85724' 06/06/2023 04:14:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85724' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '13917' , '0' , '3' , '0.7508' , '0.72192307692308' , '4' , '0' , '10866.8389' ) 06/06/2023 04:14:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85724' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '15000' , '0' , '3' , '0.7508' , '0.72192307692308' , '4' , '0' , '11712.4800' ) 06/06/2023 04:14:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85724' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '1083' , '0' , '3' , '0.7508' , '0.72192307692308' , '4' , '0' , '845.6411' ) 06/06/2023 04:15:32 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '234/A', document_date = '2023-05-18', document_letter = 'A', id_customer = '0', id_supplier = '', id_address = '2648', address1 = '', address2 = '', note = '18/05/2023- CONSEGNATI 2800 X TITOLO - 22/05/2023 consegnati 3100 x titolo - 16/05/2023 CONSEGNATI 3100 X TITOLO - 30/05/2023 cons. 3100 x tipo - 05/06 CONSEGNATI: 1981 ADULTI - 2810 BAMBINI', 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 = '0.00', price_tax_excluded = '0.00', date_upd = NOW() WHERE id_document = '84403' 06/06/2023 04:15:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84403' 06/06/2023 04:15:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '84403' 06/06/2023 04:15:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84403' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '13917' , '13917' , '4' , '0' , '0' , '0' , '0' , '0.0000' ) 06/06/2023 04:15:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84403' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '15000' , '15000' , '4' , '0' , '0' , '0' , '0' , '0.0000' ) 06/06/2023 04:15:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84403' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '1083' , '1083' , '4' , '0' , '0' , '0' , '0' , '0.0000' ) 06/06/2023 04:19:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '9/S' AND id_document != '11336' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-06-06') 06/06/2023 04:19:38 pm >> UPDATE ps_document SET id_document_type = '22', document_num = '9/S', document_date = '2023-06-06', document_letter = 'S', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'VENDUTO MAGGIO 2023', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '14', id_causal = '0', price_tax_included = '1611.75', price_tax_excluded = '1611.75', date_upd = NOW() WHERE id_document = '11336' 06/06/2023 04:19: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 = '11336' 06/06/2023 04:19:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '11336' 06/06/2023 04:19: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 ( '11336' , '9' , 'PSICOLOGIA PRATICA PER EDUCATORI' , '2' , '0' , '4' , '10.5000' , '10.5' , '0' , '50' , '10.50' ) 06/06/2023 04:19: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 ( '11336' , '17' , 'LA FEDE NELLO ZAINETTO' , '109' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '327.00' ) 06/06/2023 04:19: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 ( '11336' , '20' , 'GIOVEDÌ SANTO' , '3' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '2.25' ) 06/06/2023 04:19: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 ( '11336' , '21' , 'LA COMUNIONE' , '1' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '1.00' ) 06/06/2023 04:19: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 ( '11336' , '134' , 'AVE MARIA SPIEGATA AI BAMBINI - N.E.' , '5' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '4.50' ) 06/06/2023 04:19: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 ( '11336' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '117' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '87.75' ) 06/06/2023 04:19: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 ( '11336' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '73' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '91.25' ) 06/06/2023 04:19: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 ( '11336' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '57' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '71.25' ) 06/06/2023 04:19: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 ( '11336' , '121' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '3' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '3.75' ) 06/06/2023 04:19: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 ( '11336' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '97' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '121.25' ) 06/06/2023 04:19: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 ( '11336' , '125' , 'MIE PREGHIERINE - N. E.' , '48' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '36.00' ) 06/06/2023 04:19: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 ( '11336' , '33' , '100 GIORNI CON LO SPIRITO' , '41' , '0' , '4' , '7.5000' , '7.5' , '0' , '50' , '153.75' ) 06/06/2023 04:19: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 ( '11336' , '35' , 'ANGELI - I NOSTRI MIGLIORI AMICI' , '1' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 06/06/2023 04:19: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 ( '11336' , '38' , 'MADRE TERESA, UNA MISSIONARIA' , '2' , '0' , '4' , '2.6000' , '2.6' , '0' , '50' , '2.60' ) 06/06/2023 04:19: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 ( '11336' , '42' , 'ALLA SCOPERTA DELLA CASA DI GESU' , '3' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '4.50' ) 06/06/2023 04:19: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 ( '11336' , '50' , 'PERDONAMI SIGNORE' , '10' , '0' , '4' , '2.5' , '2.5' , '0' , '50' , '12.50' ) 06/06/2023 04:19: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 ( '11336' , '55' , 'AVE MARIA ,SPIEGATA AI BAMBINI' , '3' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '2.25' ) 06/06/2023 04:19: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 ( '11336' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '1' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '1.00' ) 06/06/2023 04:19: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 ( '11336' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '2' , '0' , '4' , '30.0000' , '30' , '0' , '50' , '30.00' ) 06/06/2023 04:19: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 ( '11336' , '66' , 'BEATI GLI INVITATI ALLA CENA DEL SIGNORE' , '11' , '0' , '4' , '6.5000' , '6.5' , '0' , '50' , '35.75' ) 06/06/2023 04:19: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 ( '11336' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '8' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '8.00' ) 06/06/2023 04:19: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 ( '11336' , '74' , 'DIO È , IN DIECI PAROLE' , '2' , '0' , '4' , '4.5000' , '4.5' , '0' , '50' , '4.50' ) 06/06/2023 04:19: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 ( '11336' , '75' , 'IL SEGNO DELLA CROCE' , '2' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '1.50' ) 06/06/2023 04:19:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '92' , 'LA PREGHIERA DEL ROSARIO' , '23' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '28.75' ) 06/06/2023 04:19:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '99' , 'AVE MARIA PREGHIERE MARIANE' , '6' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '6.00' ) 06/06/2023 04:19:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '101' , 'GESU BENEDICI LA NOSTRA FAMIGLIA' , '1' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '0.75' ) 06/06/2023 04:19:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '103' , 'Lo Spirito Santo raccontato ai ragazzi N.E.' , '14' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '14.00' ) 06/06/2023 04:19:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '104' , 'TEMPO DI QUARESIMA' , '2' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '2.50' ) 06/06/2023 04:19:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '46' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '57.50' ) 06/06/2023 04:19:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '110' , 'SE MI AMI NON PIANGERE' , '19' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '17.10' ) 06/06/2023 04:19:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '111' , 'I NONNI SONO UN TESORO' , '50' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '45.00' ) 06/06/2023 04:19:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '123' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '2' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '3.00' ) 06/06/2023 04:19:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '115' , 'SAN FRANCESCO DASSISI RACCONTATO AI RAGAZZI N.E.' , '12' , '0' , '4' , '4.0000' , '4' , '0' , '50' , '24.00' ) 06/06/2023 04:19:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '117' , 'La preghiera delle cinque dita n.e.' , '67' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '60.30' ) 06/06/2023 04:19:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '52' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '65.00' ) 06/06/2023 04:19:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '119' , 'Rosario spiegato ai bambini ' , '1' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 06/06/2023 04:19:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '98' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '122.50' ) 06/06/2023 04:19:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '8' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '12.00' ) 06/06/2023 04:19:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '7' , '0' , '4' , '18.0000' , '18' , '0' , '50' , '63.00' ) 06/06/2023 04:19:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11336' , '126' , 'SACRAMENTO DEL PERDONO' , '75' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '75.00' ) 06/06/2023 04:21:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '1966' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-06') 06/06/2023 04:21: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' , '1966' , '2023-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.40' , '14.81' , NOW() , NOW() ) 06/06/2023 04:21: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 = '85725' 06/06/2023 04:21:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '85725' 06/06/2023 04:21: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 ( '85725' , '11151' , 'LIBRI' , '4' , '-4' , '4' , '1.9' , '1.9' , '0' , '0' , '7.60' ) 06/06/2023 04:21: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 ( '85725' , '7928' , 'PERGAMENE - BATTESIMO MOD. C' , '10' , '-10' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '5.00' ) 06/06/2023 04:21: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 ( '85725' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 06/06/2023 04:26:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8057829100338' AND id_product != '16691' AND ean13 != '' 06/06/2023 04:26:51 pm >> UPDATE ps_product SET id_supplier = '22', reference = '', ean13 = '8057829100338', date_upd = NOW() WHERE id_product = '16691' 06/06/2023 04:26:51 pm >> UPDATE ps_product_lang SET name = 'PARTICOLE PER CELIACI 25pz', description = '' WHERE id_product = '16691' 06/06/2023 04:26:51 pm >> UPDATE ps_product SET wholesale_price = '1.70', on_sale = '0', price = '4.134615384615384' WHERE id_product = '16691' 06/06/2023 04:26:51 pm >> UPDATE ps_product_shop SET wholesale_price = '1.70', price = '4.134615384615384', id_tax_rules_group = '3', id_category_default = '342', id_argoment_default = '10', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16691' 06/06/2023 04:26:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '16691' 06/06/2023 04:27:54 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8057829100109' AND id_product != '7311' AND ean13 != '' 06/06/2023 04:27:54 pm >> UPDATE ps_product SET id_supplier = '22', reference = '2014', ean13 = '8057829100109', date_upd = NOW() WHERE id_product = '7311' 06/06/2023 04:27:54 pm >> UPDATE ps_product_lang SET name = 'OSTIA SOTTILE 74MM', description = '' WHERE id_product = '7311' 06/06/2023 04:27:54 pm >> UPDATE ps_product SET wholesale_price = '1.08', on_sale = '0', price = '1.923076923076923' WHERE id_product = '7311' 06/06/2023 04:27:54 pm >> UPDATE ps_product_shop SET wholesale_price = '1.08', price = '1.923076923076923', id_tax_rules_group = '3', id_category_default = '342', 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 = '7311' 06/06/2023 04:27:54 pm >> DELETE FROM ps_specific_price WHERE id_product = '7311' 06/06/2023 05:39:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '1967' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-06') 06/06/2023 05:39: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' , '1967' , '2023-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.30' , '13.61' , NOW() , NOW() ) 06/06/2023 05:39: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 = '85726' 06/06/2023 05:39:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '85726' 06/06/2023 05:39: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 ( '85726' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 06/06/2023 05:39: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 ( '85726' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 06/06/2023 05:39: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 ( '85726' , '21008' , 'GIONA E LA BALENA' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 06/06/2023 05:39:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85726' , '21009' , 'DANIELE E I LEONI' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 06/06/2023 05:39:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85726' , '21016' , 'DAVIDE E GOLIA' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 06/06/2023 05:39:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85726' , '21004' , 'CREAZIONE' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 06/06/2023 05:39:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85726' , '21005' , 'ARCA DI NOE' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 06/06/2023 06:30:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '1968' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-06') 06/06/2023 06:30:47 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1968' , '2023-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.20' , '0.98' , NOW() , NOW() ) 06/06/2023 06:30:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85727' 06/06/2023 06:30:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '85727' 06/06/2023 06:30:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85727' , '20516' , 'CROCE COMUNIONE - 42/08' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 06/06/2023 07:34:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '1969' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-06') 06/06/2023 07:34:37 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' , '1969' , '2023-06-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '45.00' , NOW() , NOW() ) 06/06/2023 07:34: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 = '85728' 06/06/2023 07:34:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '85728' 06/06/2023 07:34: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 ( '85728' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '45' , '45' , '0' , '0' , '45.00' )