05/05/2023 09:14:31 am >> SELECT ean13 FROM ps_product WHERE ean13 = '70/1431' AND id_product != '21045' AND ean13 != '' 05/05/2023 09:14:31 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '70/1431', date_upd = NOW() WHERE id_product = '21045' 05/05/2023 09:14:31 am >> UPDATE ps_product_lang SET name = 'PALLA PURA SETA AGNELLO - 70/1431', description = '' WHERE id_product = '21045' 05/05/2023 09:14:31 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '270.4918032786885' WHERE id_product = '21045' 05/05/2023 09:14:31 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '270.4918032786885', id_tax_rules_group = '1', id_category_default = '450', id_argoment_default = '42', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21045' 05/05/2023 09:14:31 am >> DELETE FROM ps_specific_price WHERE id_product = '21045' 05/05/2023 09:14:32 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21045' 05/05/2023 09:14:32 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21046' , '1' , '' , 'nuovo-prodotto' ) 05/05/2023 09:14:32 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21046' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21045' 05/05/2023 09:14:32 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21046' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21045' 05/05/2023 09:15:12 am >> SELECT ean13 FROM ps_product WHERE ean13 = '70/1431' AND id_product != '21045' AND ean13 != '' 05/05/2023 09:15:12 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '70/1431', date_upd = NOW() WHERE id_product = '21045' 05/05/2023 09:15:12 am >> UPDATE ps_product_lang SET name = 'PALLA PURA SETA AGNELLO - 70/1431', description = '' WHERE id_product = '21045' 05/05/2023 09:15:12 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '274.59016393442624' WHERE id_product = '21045' 05/05/2023 09:15:12 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '274.59016393442624', id_tax_rules_group = '1', id_category_default = '450', id_argoment_default = '42', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21045' 05/05/2023 09:15:12 am >> DELETE FROM ps_specific_price WHERE id_product = '21045' 05/05/2023 09:17:33 am >> SELECT ean13 FROM ps_product WHERE ean13 = '50/63123' AND id_product != '21040' AND ean13 != '' 05/05/2023 09:17:33 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '50/63123', date_upd = NOW() WHERE id_product = '21040' 05/05/2023 09:17:33 am >> UPDATE ps_product_lang SET name = 'PALLA IN SETA CON CROCE - 50/63123', description = '' WHERE id_product = '21040' 05/05/2023 09:17:33 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '131.14754098360655' WHERE id_product = '21040' 05/05/2023 09:17:33 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '131.14754098360655', id_tax_rules_group = '1', id_category_default = '450', id_argoment_default = '42', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21040' 05/05/2023 09:17:33 am >> DELETE FROM ps_specific_price WHERE id_product = '21040' 05/05/2023 09:19:21 am >> SELECT ean13 FROM ps_product WHERE ean13 = '50/372' AND id_product != '21039' AND ean13 != '' 05/05/2023 09:19:21 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '50/372', date_upd = NOW() WHERE id_product = '21039' 05/05/2023 09:19:21 am >> UPDATE ps_product_lang SET name = 'PALLA IN SETA RICAMO MARIANO - 50/372', description = '' WHERE id_product = '21039' 05/05/2023 09:19:21 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '21039' 05/05/2023 09:19:21 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '450', id_argoment_default = '42', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21039' 05/05/2023 09:19:21 am >> DELETE FROM ps_specific_price WHERE id_product = '21039' 05/05/2023 09:19:44 am >> SELECT ean13 FROM ps_product WHERE ean13 = '50/372' AND id_product != '21039' AND ean13 != '' 05/05/2023 09:19:44 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '50/372', date_upd = NOW() WHERE id_product = '21039' 05/05/2023 09:19:44 am >> UPDATE ps_product_lang SET name = 'PALLA IN SETA RICAMO MARIANO - 50/372', description = '' WHERE id_product = '21039' 05/05/2023 09:19:44 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '221.31147540983608' WHERE id_product = '21039' 05/05/2023 09:19:44 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '221.31147540983608', id_tax_rules_group = '1', id_category_default = '450', id_argoment_default = '42', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21039' 05/05/2023 09:19:44 am >> DELETE FROM ps_specific_price WHERE id_product = '21039' 05/05/2023 09:19:45 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21039' 05/05/2023 09:19:45 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21047' , '1' , '' , 'nuovo-prodotto' ) 05/05/2023 09:19:45 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21047' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21039' 05/05/2023 09:19:45 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21047' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21039' 05/05/2023 09:22:14 am >> SELECT ean13 FROM ps_product WHERE ean13 = '60/1010' AND id_product != '21041' AND ean13 != '' 05/05/2023 09:22:15 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '60/1010', date_upd = NOW() WHERE id_product = '21041' 05/05/2023 09:22:15 am >> UPDATE ps_product_lang SET name = 'COMPLETO MESSA LINO RIC. A MANO - 60/1010', description = '' WHERE id_product = '21041' 05/05/2023 09:22:15 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '200.81967213114754' WHERE id_product = '21041' 05/05/2023 09:22:15 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '200.81967213114754', id_tax_rules_group = '1', id_category_default = '450', id_argoment_default = '42', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21041' 05/05/2023 09:22:15 am >> DELETE FROM ps_specific_price WHERE id_product = '21041' 05/05/2023 09:23:59 am >> SELECT ean13 FROM ps_product WHERE ean13 = '75/1633' AND id_product != '21043' AND ean13 != '' 05/05/2023 09:23:59 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '75/1633', date_upd = NOW() WHERE id_product = '21043' 05/05/2023 09:23:59 am >> UPDATE ps_product_lang SET name = 'STOLA IN LANA TESS. TELAIO - 75/1633', description = '' WHERE id_product = '21043' 05/05/2023 09:23:59 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '245.08196721311475' WHERE id_product = '21043' 05/05/2023 09:23:59 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '245.08196721311475', id_tax_rules_group = '1', id_category_default = '450', id_argoment_default = '42', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21043' 05/05/2023 09:23:59 am >> DELETE FROM ps_specific_price WHERE id_product = '21043' 05/05/2023 09:26:23 am >> SELECT ean13 FROM ps_product WHERE ean13 = '75/1602' AND id_product != '21044' AND ean13 != '' 05/05/2023 09:26:23 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '75/1602', date_upd = NOW() WHERE id_product = '21044' 05/05/2023 09:26:23 am >> UPDATE ps_product_lang SET name = 'STOLA IN LANA TESS. TELAIO - 75/1602', description = '' WHERE id_product = '21044' 05/05/2023 09:26:24 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '155.7377049180328' WHERE id_product = '21044' 05/05/2023 09:26:24 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '155.7377049180328', id_tax_rules_group = '1', id_category_default = '450', id_argoment_default = '42', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21044' 05/05/2023 09:26:24 am >> DELETE FROM ps_specific_price WHERE id_product = '21044' 05/05/2023 09:27:31 am >> SELECT ean13 FROM ps_product WHERE ean13 = '60/3113' AND id_product != '21042' AND ean13 != '' 05/05/2023 09:27:31 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '60/3113', date_upd = NOW() WHERE id_product = '21042' 05/05/2023 09:27:31 am >> UPDATE ps_product_lang SET name = 'AMITTO MISTO LANA - 60/3113', description = '' WHERE id_product = '21042' 05/05/2023 09:27:31 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '28.688524590163937' WHERE id_product = '21042' 05/05/2023 09:27:31 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '28.688524590163937', id_tax_rules_group = '1', id_category_default = '450', id_argoment_default = '42', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21042' 05/05/2023 09:27:31 am >> DELETE FROM ps_specific_price WHERE id_product = '21042' 05/05/2023 09:28: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 ( '31' , '3817/2023' , '2023-04-27' , '2023' , '0' , '129' , '4670237' , 'VIA ROMA, 10 54035 FOSDINOVO' , '' , '' , '12' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '785.63' , '643.96' , NOW() , NOW() ) 05/05/2023 09:28: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 = '84158' 05/05/2023 09:28:10 am >> DELETE FROM ps_document_detail WHERE id_document = '84158' 05/05/2023 09:28: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 ( '84158' , '21045' , 'PALLA PURA SETA AGNELLO - 70/1431' , '1' , '1' , '1' , '146' , '119.67213114754' , '22' , '3' , '172.7764' ) 05/05/2023 09:28:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '21045' AND id_supplier = '129' 05/05/2023 09:28:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21045' , '129' , '1' ) 05/05/2023 09:28: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 ( '84158' , '21040' , 'PALLA IN SETA CON CROCE - 50/63123' , '1' , '1' , '1' , '68' , '55.737704918033' , '22' , '3' , '80.4712' ) 05/05/2023 09:28:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '21040' AND id_supplier = '129' 05/05/2023 09:28:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21040' , '129' , '1' ) 05/05/2023 09:28: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 ( '84158' , '21039' , 'PALLA IN SETA RICAMO MARIANO - 50/372' , '1' , '1' , '1' , '113' , '92.622950819672' , '22' , '3' , '133.7242' ) 05/05/2023 09:28:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '21039' AND id_supplier = '129' 05/05/2023 09:28:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21039' , '129' , '1' ) 05/05/2023 09:28: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 ( '84158' , '21041' , 'COMPLETO MESSA LINO RIC. A MANO - 60/1010' , '1' , '1' , '1' , '101' , '82.786885245902' , '22' , '3' , '119.5234' ) 05/05/2023 09:28:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '21041' AND id_supplier = '129' 05/05/2023 09:28:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21041' , '129' , '1' ) 05/05/2023 09:28: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 ( '84158' , '21043' , 'STOLA IN LANA TESS. TELAIO - 75/1633' , '1' , '1' , '1' , '131' , '107.37704918033' , '22' , '3' , '155.0254' ) 05/05/2023 09:28:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '21043' AND id_supplier = '129' 05/05/2023 09:28:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21043' , '129' , '1' ) 05/05/2023 09:28: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 ( '84158' , '21044' , 'STOLA IN LANA TESS. TELAIO - 75/1602' , '1' , '1' , '1' , '78' , '63.934426229508' , '22' , '3' , '92.3052' ) 05/05/2023 09:28:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '21044' AND id_supplier = '129' 05/05/2023 09:28:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21044' , '129' , '1' ) 05/05/2023 09:28: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 ( '84158' , '21042' , 'AMITTO MISTO LANA - 60/3113' , '1' , '1' , '1' , '14.5' , '11.885245901639' , '22' , '3' , '17.1593' ) 05/05/2023 09:28:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '21042' AND id_supplier = '129' 05/05/2023 09:28:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21042' , '129' , '1' ) 05/05/2023 10:23:20 am >> SELECT document_num FROM ps_document WHERE document_num = '1519' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-05') 05/05/2023 10:23:20 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' , '1519' , '2023-05-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.50' , '1.23' , NOW() , NOW() ) 05/05/2023 10:23:20 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 = '84159' 05/05/2023 10:23:20 am >> DELETE FROM ps_document_detail WHERE id_document = '84159' 05/05/2023 10:23:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84159' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 05/05/2023 10:29:54 am >> SELECT document_num FROM ps_document WHERE document_num = '18/A' AND id_document != '81226' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-04') 05/05/2023 10:29:54 am >> UPDATE ps_document SET id_document_type = '24', document_num = '18/A', document_date = '2023-02-04', document_letter = 'A', id_customer = '3712', id_supplier = '', id_address = '4671443', address1 = 'VIA DALMAZIA 6 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 = '0', id_causal = '0', price_tax_included = '311.80', price_tax_excluded = '258.10', date_upd = NOW() WHERE id_document = '81226' 05/05/2023 10:29:54 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81226' 05/05/2023 10:29:54 am >> DELETE FROM ps_document_detail WHERE id_document = '81226' 05/05/2023 10:29:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81226' , '11384' , 'VINO BIANCO DOLCE - 102' , '5' , '-5' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '42.50' ) 05/05/2023 10:29:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81226' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '10' , '-10' , '4' , '0.7000' , '0.7' , '0' , '0' , '7.00' ) 05/05/2023 10:29:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81226' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 05/05/2023 10:29:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81226' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 05/05/2023 10:29:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81226' , '0' , 'BUSTE PER PALMA' , '5' , '-5' , '1' , '9.5000' , '7.7868852459016' , '22' , '0' , '47.50' ) 05/05/2023 10:29:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81226' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '3' , '-3' , '1' , '17.9000' , '14.672131147541' , '22' , '0' , '53.70' ) 05/05/2023 10:29:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81226' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '2' , '-2' , '1' , '1.4000' , '1.1475409836066' , '22' , '0' , '2.80' ) 05/05/2023 10:29:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81226' , '15332' , 'GRANI PER CERO' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 05/05/2023 10:29:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81226' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 05/05/2023 10:29:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81226' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '1.90' ) 05/05/2023 10:29:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81226' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '68.00' , '55.737704918033' , '22' , '0' , '68.00' ) 05/05/2023 10:30:32 am >> SELECT document_num FROM ps_document WHERE document_num = '1520' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-05') 05/05/2023 10:30:32 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' , '1520' , '2023-05-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '2.00' , NOW() , NOW() ) 05/05/2023 10:30:32 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84160' 05/05/2023 10:30:32 am >> DELETE FROM ps_document_detail WHERE id_document = '84160' 05/05/2023 10:30:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84160' , '8765' , 'QUINDICI ORAZIONI DI SANTA BRIGIDA - 8193' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 05/05/2023 11:04:33 am >> SELECT document_num FROM ps_document WHERE document_num = '84' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-05-05') 05/05/2023 11:04:33 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '84' , '2023-05-05' , '' , '618' , '0' , '4671023' , 'S. ANGELO 84085 MERCATO S. SEVERINO' , '' , 'sconto autore' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '30.00' , NOW() , NOW() ) 05/05/2023 11:04:33 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84161' 05/05/2023 11:04:33 am >> DELETE FROM ps_document_detail WHERE id_document = '84161' 05/05/2023 11:04:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84161' , '3978' , 'EUCARISTIA: RITO E VITA' , '5' , '-5' , '4' , '10.00' , '10' , '0' , '40' , '30.00' ) 05/05/2023 11:04:51 am >> SELECT document_num FROM ps_document WHERE document_num = '84' AND id_document != '84161' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-05-05') 05/05/2023 11:04:51 am >> UPDATE ps_document SET id_document_type = '21', document_num = '84', document_date = '2023-05-05', document_letter = '', id_customer = '618', id_supplier = '', id_address = '4671023', address1 = 'S. ANGELO 84085 MERCATO S. SEVERINO', address2 = '', note = 'sconto autore', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '30.00', price_tax_excluded = '30.00', date_upd = NOW() WHERE id_document = '84161' 05/05/2023 11:04:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84161' 05/05/2023 11:04:51 am >> DELETE FROM ps_document_detail WHERE id_document = '84161' 05/05/2023 11:04:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84161' , '3978' , 'EUCARISTIA: RITO E VITA' , '5' , '-5' , '4' , '10.0000' , '10' , '0' , '40' , '30.00' ) 05/05/2023 11:06:03 am >> SELECT document_num FROM ps_document WHERE document_num = '1521' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-05') 05/05/2023 11:06:03 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1521' , '2023-05-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.40' , '11.40' , NOW() , NOW() ) 05/05/2023 11:06:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84162' 05/05/2023 11:06:03 am >> DELETE FROM ps_document_detail WHERE id_document = '84162' 05/05/2023 11:06:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84162' , '17862' , 'DALLINFORMATICA AL CIELO C. ACUTIS - N. GORI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 05/05/2023 11:11:48 am >> SELECT document_num FROM ps_document WHERE document_num = '1522' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-05') 05/05/2023 11:11:48 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' , '1522' , '2023-05-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '10.62' , NOW() , NOW() ) 05/05/2023 11:11:48 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 = '84163' 05/05/2023 11:11:48 am >> DELETE FROM ps_document_detail WHERE id_document = '84163' 05/05/2023 11:11:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84163' , '11756' , 'VINO BIANCO SECCO - 14%' , '1' , '-1' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '6.50' ) 05/05/2023 11:11:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84163' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 05/05/2023 11:11:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84163' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 05/05/2023 11:49:51 am >> SELECT document_num FROM ps_document WHERE document_num = '1523' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-05') 05/05/2023 11:49:51 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1523' , '2023-05-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '31.15' , NOW() , NOW() ) 05/05/2023 11:49:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84164' 05/05/2023 11:49:51 am >> DELETE FROM ps_document_detail WHERE id_document = '84164' 05/05/2023 11:49:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84164' , '3074' , 'CROCE PRIMA COMUNIONE LEGNO CHIARO - 713/11' , '25' , '-25' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '32.50' ) 05/05/2023 11:49:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84164' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5.5' , '4.5081967213115' , '22' , '0' , '5.50' ) 05/05/2023 12:00:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '1524' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-05') 05/05/2023 12:00:54 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' , '1524' , '2023-05-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 05/05/2023 12:00:54 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 = '84165' 05/05/2023 12:00:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '84165' 05/05/2023 12:00:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84165' , '7202' , 'ARTICOLI RELIGIOSI' , '5' , '-5' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '17.50' ) 05/05/2023 12:00:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84165' , '1350' , 'BRACCIALETTO CON CROCE - 29002 03' , '2' , '-2' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '6.00' ) 05/05/2023 12:00:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84165' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '12' , '-12' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '3.00' ) 05/05/2023 12:00:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84165' , '14064' , 'STELLARIO PLEX CM 16' , '1' , '-1' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '13.50' ) 05/05/2023 12:05:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '1525' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-05') 05/05/2023 12:05: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' , '1525' , '2023-05-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '197.15' , '167.94' , NOW() , NOW() ) 05/05/2023 12:05:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84166' 05/05/2023 12:05:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '84166' 05/05/2023 12:05:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84166' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '108' , '-108' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '162.00' ) 05/05/2023 12:05:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84166' , '18907' , 'ANGELO MI DISSE - A. COMASTRI' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 05/05/2023 12:05: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 ( '84166' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 05/05/2023 12:24:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '1526' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-05') 05/05/2023 12:24:17 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1526' , '2023-05-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 05/05/2023 12:24:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84167' 05/05/2023 12:24:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '84167' 05/05/2023 12:24: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 ( '84167' , '21024' , 'SERVIZIO SANTO PER UN RINNOVAMENTO...' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 05/05/2023 12:26:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '1523' AND id_document != '84164' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-05') 05/05/2023 12:26:04 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1523', document_date = '2023-05-05', 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 = '38.00', price_tax_excluded = '31.15', date_upd = NOW() WHERE id_document = '84164' 05/05/2023 12:26:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84164' 05/05/2023 12:26:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '84164' 05/05/2023 12:26:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84164' , '20516' , 'CROCE COMUNIONE - 42/08' , '38' , '-38' , '1' , '1' , '0.81967213114754' , '22' , '0' , '38.00' ) 05/05/2023 12:46:36 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' , '6023230208' , '2023-04-30' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '2.12' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '71.00' , '71.00' , NOW() , NOW() ) 05/05/2023 12:46:36 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84168' 05/05/2023 12:46:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '84168' 05/05/2023 12:46:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84168' , '20939' , 'REGOLA DI FRANCESCO SPIEGATA - G. BUFFON' , '1' , '0' , '4' , '9.1' , '9.1' , '0' , '0' , '9.1000' ) 05/05/2023 12:46:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20939' AND id_supplier = '109' 05/05/2023 12:46:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20939' , '109' , '1' ) 05/05/2023 12:46:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84168' , '20938' , 'TU SEI UNA PROMESSA' , '1' , '0' , '4' , '10.4' , '10.4' , '0' , '0' , '10.4000' ) 05/05/2023 12:46:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20938' AND id_supplier = '109' 05/05/2023 12:46:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20938' , '109' , '1' ) 05/05/2023 12:46: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 ( '84168' , '20937' , 'STORIE #NOFILTER' , '1' , '0' , '4' , '5.85' , '5.85' , '0' , '0' , '5.8500' ) 05/05/2023 12:46:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20937' AND id_supplier = '109' 05/05/2023 12:46:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20937' , '109' , '1' ) 05/05/2023 12:46: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 ( '84168' , '20976' , 'CHIESA SACRAMENTO DI UNITA ' , '1' , '0' , '4' , '14.29' , '14.29' , '0' , '0' , '14.2900' ) 05/05/2023 12:46:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20976' AND id_supplier = '109' 05/05/2023 12:46:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20976' , '109' , '1' ) 05/05/2023 12:46: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 ( '84168' , '20974' , 'COSE E LA MESSA? R. CASTILLO' , '1' , '0' , '4' , '9.1' , '9.1' , '0' , '0' , '9.1000' ) 05/05/2023 12:46:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20974' AND id_supplier = '109' 05/05/2023 12:46:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20974' , '109' , '1' ) 05/05/2023 12:46: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 ( '84168' , '20975' , 'DOTTRINA SOCIALE DELLA CHIESA - G. COMOLLI' , '1' , '0' , '4' , '11.04' , '11.04' , '0' , '0' , '11.0400' ) 05/05/2023 12:46:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20975' AND id_supplier = '109' 05/05/2023 12:46:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20975' , '109' , '1' ) 05/05/2023 12:46: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 ( '84168' , '20972' , 'PADRE NOSTRO - P. STEFANI' , '1' , '0' , '4' , '9.1' , '9.1' , '0' , '0' , '9.1000' ) 05/05/2023 12:46:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20972' AND id_supplier = '109' 05/05/2023 12:46:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20972' , '109' , '1' ) 05/05/2023 12:49:03 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '1057' , '2023-04-29' , '' , '0' , '47' , '2642' , 'V.LE BACCHIGLIONE, 20 20139 MILANO' , '' , '' , '5.31' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '67.96' , '67.96' , NOW() , NOW() ) 05/05/2023 12:49:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84169' 05/05/2023 12:49:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '84169' 05/05/2023 12:49:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84169' , '21034' , 'DON DOLINDO RUOTOLO DEVOTO DELLE ANIME DEL PURGATORIO' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '30' , '8.40' ) 05/05/2023 12:49:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21034' AND id_supplier = '47' 05/05/2023 12:49:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21034' , '47' , '1' ) 05/05/2023 12:49:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84169' , '21035' , 'FILOCALIA - VOL.1' , '1' , '0' , '4' , '42.0000' , '42' , '0' , '30' , '29.40' ) 05/05/2023 12:49:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21035' AND id_supplier = '47' 05/05/2023 12:49:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21035' , '47' , '1' ) 05/05/2023 12:49:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84169' , '20880' , 'UN TEMPO PER DIO - J. PHILIPPE' , '2' , '0' , '4' , '10.0000' , '10' , '0' , '30' , '14.00' ) 05/05/2023 12:49:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20880' AND id_supplier = '47' 05/05/2023 12:49:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20880' , '47' , '1' ) 05/05/2023 12:49:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84169' , '19323' , 'PREGHIERE DI SANTA BRIGIDA' , '5' , '0' , '4' , '0.7000' , '0.7' , '0' , '30' , '2.45' ) 05/05/2023 12:49:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19323' AND id_supplier = '47' 05/05/2023 12:49:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19323' , '47' , '1' ) 05/05/2023 12:49:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84169' , '8368' , 'PREGHIERE DI LIBERAZIONE - DIVINA MISERICORDIA' , '8' , '0' , '4' , '1.5000' , '1.5' , '0' , '30' , '8.40' ) 05/05/2023 12:49:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8368' AND id_supplier = '47' 05/05/2023 12:49:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8368' , '47' , '1' ) 05/05/2023 12:53:26 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' , '6023230207' , '2023-04-30' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '3.59' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '124.76' , '124.76' , NOW() , NOW() ) 05/05/2023 12:53: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 = '84170' 05/05/2023 12:53:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '84170' 05/05/2023 12:53: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 ( '84170' , '20903' , 'CARITAS SPES FIDES - BENEDETTO XVI' , '1' , '0' , '4' , '12.97' , '12.97' , '0' , '0' , '12.9700' ) 05/05/2023 12:53:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20903' AND id_supplier = '109' 05/05/2023 12:53:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20903' , '109' , '1' ) 05/05/2023 12:53: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 ( '84170' , '20940' , 'PAPA MINISTERO E MISSIONE - G.L. MULLER' , '1' , '0' , '4' , '16.9' , '16.9' , '0' , '0' , '16.9000' ) 05/05/2023 12:53:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20940' AND id_supplier = '109' 05/05/2023 12:53:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20940' , '109' , '1' ) 05/05/2023 12:53: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 ( '84170' , '17875' , 'VITA COME FINE DEL MONDO - L. EPICOCO' , '1' , '0' , '4' , '12.97' , '12.97' , '0' , '0' , '12.9700' ) 05/05/2023 12:53:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17875' AND id_supplier = '109' 05/05/2023 12:53:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17875' , '109' , '1' ) 05/05/2023 12:53: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 ( '84170' , '20973' , 'OGGETTO PREDICA - ANNO A' , '1' , '0' , '4' , '10.4' , '10.4' , '0' , '0' , '10.4000' ) 05/05/2023 12:53:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20973' AND id_supplier = '109' 05/05/2023 12:53:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20973' , '109' , '1' ) 05/05/2023 12:53: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 ( '84170' , '18509' , 'MANUALE DEL PARROCO - L. CHIAPPETTA' , '1' , '0' , '4' , '67.93' , '67.93' , '0' , '0' , '67.9300' ) 05/05/2023 12:53:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18509' AND id_supplier = '109' 05/05/2023 12:53:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18509' , '109' , '1' ) 05/05/2023 03:34:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '22/A' AND id_document != '81317' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-10') 05/05/2023 03:34:53 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '22/A', document_date = '2023-02-10', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '118.90', price_tax_excluded = '118.90', date_upd = NOW() WHERE id_document = '81317' 05/05/2023 03:34:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81317' 05/05/2023 03:34:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '81317' 05/05/2023 03:34:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '20880' , 'UN TEMPO PER DIO - J. PHILIPPE' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 05/05/2023 03:34:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '20867' , 'PAROLA E PREGHIERA - GIU 23' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 05/05/2023 03:34:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '20893' , 'VANGELO E ATTI HEART UP' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 05/05/2023 03:34:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '20979' , 'BIBBIA' , '1' , '-1' , '4' , '38.0000' , '38' , '0' , '0' , '38.00' ) 05/05/2023 03:34:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '19650' , 'UNBOUND' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 05/05/2023 03:34:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '20988' , 'SIGNORE NON NE POSSO PIU - P. DESCOUVEMONT' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 05/05/2023 03:34:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '20810' , 'SAPIENZA DEL VANGELO - F. BERSINI' , '1' , '-1' , '4' , '23.00' , '23' , '0' , '0' , '23.00' ) 05/05/2023 03:36:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '1527' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-05') 05/05/2023 03:36:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1527' , '2023-05-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 05/05/2023 03:36:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84171' 05/05/2023 03:36:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '84171' 05/05/2023 03:36:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84171' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 05/05/2023 04:05:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '1528' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-05') 05/05/2023 04:05:18 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' , '1528' , '2023-05-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '130.00' , '119.00' , NOW() , NOW() ) 05/05/2023 04:05:18 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 = '84172' 05/05/2023 04:05:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '84172' 05/05/2023 04:05:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84172' , '7931' , 'PERGAMENE - CRESIMA MOD. A' , '50' , '-50' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '25.00' ) 05/05/2023 04:05:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84172' , '7907' , 'PERGAMENE' , '30' , '-30' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '15.00' ) 05/05/2023 04:05:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84172' , '15334' , 'CANDELA VOTIVA 20X40' , '30' , '-30' , '1' , '0.7' , '0.57377049180328' , '22' , '0' , '21.00' ) 05/05/2023 04:05:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84172' , '11151' , 'LIBRI' , '3' , '-3' , '4' , '10' , '10' , '0' , '0' , '30.00' ) 05/05/2023 04:05:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84172' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '10' , '10' , '0' , '0' , '20.00' ) 05/05/2023 04:05:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84172' , '20642' , 'CHE COSE IL CRISTIANESIMO - BENEDETTO XVI' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 05/05/2023 04:16:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '1529' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-05') 05/05/2023 04:16:44 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' , '1529' , '2023-05-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '28.56' , NOW() , NOW() ) 05/05/2023 04:16:44 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 = '84173' 05/05/2023 04:16:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '84173' 05/05/2023 04:16:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84173' , '17275' , 'TELA 18X25- 2963' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 05/05/2023 04:16:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84173' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '10' , '10' , '0' , '0' , '10.00' ) 05/05/2023 04:16:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84173' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 05/05/2023 04:16:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84173' , '11376' , 'VIENI SPIRITO SANTO' , '50' , '-50' , '4' , '0.20' , '0.2' , '0' , '0' , '10.00' ) 05/05/2023 04:22:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '1530' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-05') 05/05/2023 04:22: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' , '1530' , '2023-05-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.49' , '26.49' , NOW() , NOW() ) 05/05/2023 04:22: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 = '84174' 05/05/2023 04:22:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '84174' 05/05/2023 04:22: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 ( '84174' , '20949' , 'MARIA OMELIE E DISCORSI SCELTI - BENEDETTO XVI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 05/05/2023 04:22: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 ( '84174' , '8327' , 'PREGHIERE A CARATTERI GRANDI' , '1' , '-1' , '4' , '4.99' , '4.99' , '0' , '5' , '4.74' ) 05/05/2023 04:22: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 ( '84174' , '20958' , 'PER MARIA A GESU ' , '3' , '-3' , '4' , '1.50' , '1.5' , '0' , '0' , '4.50' ) 05/05/2023 04:22: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 ( '84174' , '18712' , 'NELLA FEDE IO VIVRO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 05/05/2023 04:56:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '19/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-05-05') 05/05/2023 04:56:45 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' , '19/E' , '2023-05-05' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'VENDUTO APRILE 2023' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '2078.52' , '2078.43' , NOW() , NOW() ) 05/05/2023 04:56:45 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 = '84175' 05/05/2023 04:56:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '84175' 05/05/2023 04:56:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84175' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '90' , '0' , '4' , '2.40' , '2.4' , '0' , '50' , '108.00' ) 05/05/2023 04:56:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84175' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '0' , '4' , '3' , '3' , '0' , '50' , '1.50' ) 05/05/2023 04:56:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84175' , '5457' , 'IO SONO CON VOI 1 PARTE' , '14' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '17.50' ) 05/05/2023 04:56:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84175' , '5458' , 'IO SONO CON VOI 2 PARTE' , '6' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '7.50' ) 05/05/2023 04:56:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84175' , '11191' , 'VENITE CON ME 1 PARTE' , '101' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '126.25' ) 05/05/2023 04:56:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84175' , '11192' , 'VENITE CON ME 2 PARTE' , '13' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '16.25' ) 05/05/2023 04:56:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84175' , '11312' , 'VIA CRUCIS PER RAGAZZI ' , '1' , '0' , '4' , '0.85' , '0.85' , '0' , '50' , '0.42' ) 05/05/2023 04:56:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84175' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '1' , '0' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 05/05/2023 04:56:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84175' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '1' , '0' , '4' , '3.40' , '3.4' , '0' , '50' , '1.70' ) 05/05/2023 04:56:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84175' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '2' , '0' , '4' , '8.00' , '8' , '0' , '50' , '8.00' ) 05/05/2023 04:56:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84175' , '6629' , 'MIA PREGHIERA' , '63' , '0' , '4' , '0.90' , '0.9' , '0' , '50' , '28.35' ) 05/05/2023 04:56:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84175' , '8408' , 'PRENDETE E MANGIATE' , '16' , '0' , '4' , '3.00' , '3' , '0' , '50' , '24.00' ) 05/05/2023 04:56:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84175' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '0' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 05/05/2023 04:56:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84175' , '4154' , 'FESTA DEL PERDONO' , '2' , '0' , '4' , '3.00' , '3' , '0' , '50' , '3.00' ) 05/05/2023 04:56:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84175' , '7824' , 'PER ILLUMINARE IL CAMMINO' , '30' , '0' , '4' , '0.90' , '0.9' , '0' , '50' , '13.50' ) 05/05/2023 04:56:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84175' , '2679' , 'CONOSCERE GESU' , '2' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '3.50' ) 05/05/2023 04:56:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84175' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '13' , '0' , '4' , '5.00' , '5' , '0' , '50' , '32.50' ) 05/05/2023 04:56:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84175' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '464' , '0' , '4' , '1.60' , '1.6' , '0' , '50' , '371.20' ) 05/05/2023 04:56:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84175' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '1' , '0' , '4' , '12.00' , '12' , '0' , '50' , '6.00' ) 05/05/2023 04:56:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84175' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '1' , '0' , '4' , '1.60' , '1.6' , '0' , '50' , '0.80' ) 05/05/2023 04:56:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84175' , '12819' , 'REGISTRO DEL CATECHISTA ' , '1' , '0' , '1' , '1.00' , '0.81967213114754' , '22' , '50' , '0.50' ) 05/05/2023 04:56: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 ( '84175' , '12253' , 'MIO LIBRO DI PREGHIERE' , '12' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '16.80' ) 05/05/2023 04:56: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 ( '84175' , '12813' , 'MARIA MADRE NOSTRA' , '5' , '0' , '4' , '3.00' , '3' , '0' , '50' , '7.50' ) 05/05/2023 04:56: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 ( '84175' , '12255' , 'IN CAMMINO CON GESU' , '130' , '0' , '4' , '3.80' , '3.8' , '0' , '50' , '247.00' ) 05/05/2023 04:56: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 ( '84175' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '3' , '0' , '4' , '6.00' , '6' , '0' , '50' , '9.00' ) 05/05/2023 04:56: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 ( '84175' , '13397' , 'MIO GESU' , '2' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '3.50' ) 05/05/2023 04:56: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 ( '84175' , '13956' , 'MIRACOLI DI GESU' , '1' , '0' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 05/05/2023 04:56: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 ( '84175' , '14032' , 'AVE MARIA' , '1' , '0' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 05/05/2023 04:56: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 ( '84175' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '17' , '0' , '4' , '1.00' , '1' , '0' , '50' , '8.50' ) 05/05/2023 04:56: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 ( '84175' , '15019' , 'PREGHIAMO CON MARIA' , '11' , '0' , '4' , '0.80' , '0.8' , '0' , '50' , '4.40' ) 05/05/2023 04:56: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 ( '84175' , '15020' , 'PREGARE OGNI GIORNO' , '6' , '0' , '4' , '1.00' , '1' , '0' , '50' , '3.00' ) 05/05/2023 04:56: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 ( '84175' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '1' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 05/05/2023 04:56: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 ( '84175' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '23' , '0' , '4' , '1.00' , '1' , '0' , '50' , '11.50' ) 05/05/2023 04:56: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 ( '84175' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '19' , '0' , '4' , '2.00' , '2' , '0' , '50' , '19.00' ) 05/05/2023 04:56: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 ( '84175' , '16667' , 'VIA CRUCIS' , '1' , '0' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 05/05/2023 04:56: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 ( '84175' , '16997' , 'PREGHIAMO IL PADRONE DELLA MESSE ' , '2' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 05/05/2023 04:56: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 ( '84175' , '17257' , 'IO TI BATTEZZO ' , '13' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '11.70' ) 05/05/2023 04:56: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 ( '84175' , '17827' , 'ISTRUZIONI FAMILIARI VOL. I - IL CREDO ' , '1' , '0' , '4' , '20.00' , '20' , '0' , '50' , '10.00' ) 05/05/2023 04:56: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 ( '84175' , '17695' , 'VIA LUCIS CON SAN CESARE DE BUS' , '2' , '0' , '4' , '3.80' , '3.8' , '0' , '50' , '3.80' ) 05/05/2023 04:56: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 ( '84175' , '17697' , 'SANTO ROSARIO CON SAN CESARE DE BUS' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 05/05/2023 04:56: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 ( '84175' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '4' , '0' , '4' , '12.00' , '12' , '0' , '50' , '24.00' ) 05/05/2023 04:56: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 ( '84175' , '18175' , 'VIA DI SAN GIUSEPPE - G. POLIDORO' , '1' , '0' , '4' , '4.80' , '4.8' , '0' , '50' , '2.40' ) 05/05/2023 04:56: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 ( '84175' , '18460' , 'CON CUORE DI PADRE - V. SALVOLDI' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 05/05/2023 04:56: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 ( '84175' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '54' , '0' , '4' , '1.90' , '1.9' , '0' , '50' , '51.30' ) 05/05/2023 04:56: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 ( '84175' , '17861' , 'CARTA DIDENTITA DELLA CHIESA - R. LUPI' , '10' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '12.50' ) 05/05/2023 04:56: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 ( '84175' , '18528' , 'CON GESU VERSO IL CALVARIO - G. VALSECCHI' , '4' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '3.00' ) 05/05/2023 04:56: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 ( '84175' , '18497' , 'BUONA DOMENICA - ANNO A - G. BAGET BOZZO' , '1' , '0' , '4' , '16.00' , '16' , '0' , '50' , '8.00' ) 05/05/2023 04:56: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 ( '84175' , '18527' , 'SOGNI DI PACE - V. SAVOLDI' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 05/05/2023 04:56: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 ( '84175' , '18717' , 'ISTRUZIONI FAMILIARI VOL. II - I DIECI COMANDAMENTI ' , '1' , '0' , '4' , '20.00' , '20' , '0' , '50' , '10.00' ) 05/05/2023 04:56: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 ( '84175' , '18657' , 'HO DATO LORO LA TUA PAROLA - G. VALSECCHI' , '2' , '0' , '4' , '16.00' , '16' , '0' , '50' , '16.00' ) 05/05/2023 04:56: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 ( '84175' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '4' , '0' , '4' , '7.00' , '7' , '0' , '50' , '14.00' ) 05/05/2023 04:56: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 ( '84175' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '3' , '0' , '4' , '2.00' , '2' , '0' , '50' , '3.00' ) 05/05/2023 04:56: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 ( '84175' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '1' , '0' , '4' , '9.00' , '9' , '0' , '50' , '4.50' ) 05/05/2023 04:56: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 ( '84175' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '2' , '0' , '4' , '10.00' , '10' , '0' , '50' , '10.00' ) 05/05/2023 04:56: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 ( '84175' , '19088' , 'TU SOLO IL SANTO - G. VALSECCHI' , '2' , '0' , '4' , '10.00' , '10' , '0' , '50' , '10.00' ) 05/05/2023 04:56: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 ( '84175' , '19391' , 'ISTRUZIONI FAMILIARI VOL. III - I PRECETTI...' , '1' , '0' , '4' , '20.00' , '20' , '0' , '50' , '10.00' ) 05/05/2023 04:56: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 ( '84175' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '6' , '0' , '4' , '12.00' , '12' , '0' , '50' , '36.00' ) 05/05/2023 04:56: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 ( '84175' , '19562' , 'SAN CESARE DE BUS. UNA VITA PER LA CATECHESI ' , '1' , '0' , '4' , '20.00' , '20' , '0' , '50' , '10.00' ) 05/05/2023 04:56: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 ( '84175' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '3' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 05/05/2023 04:56: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 ( '84175' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '7' , '0' , '4' , '4.50' , '4.5' , '0' , '50' , '15.75' ) 05/05/2023 04:56: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 ( '84175' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '6' , '0' , '4' , '35.00' , '35' , '0' , '50' , '105.00' ) 05/05/2023 04:56: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 ( '84175' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE' , '10' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '12.50' ) 05/05/2023 04:56: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 ( '84175' , '20231' , 'PREGANDO NON SPRECATE PAROLE - G. DAMORE' , '2' , '0' , '4' , '10.00' , '10' , '0' , '50' , '10.00' ) 05/05/2023 04:56: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 ( '84175' , '20719' , 'CORONA DELL’ADDOLORATA' , '26' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '23.40' ) 05/05/2023 04:56: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 ( '84175' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '42' , '0' , '4' , '2.00' , '2' , '0' , '50' , '42.00' ) 05/05/2023 04:56: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 ( '84175' , '20721' , 'AVE MARIA - L. CALABRETTA' , '15' , '0' , '4' , '4.50' , '4.5' , '0' , '50' , '33.75' ) 05/05/2023 04:56: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 ( '84175' , '20720' , 'PADRE NOSTRO - L. CALABRETTA' , '12' , '0' , '4' , '4.50' , '4.5' , '0' , '50' , '27.00' ) 05/05/2023 04:56: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 ( '84175' , '20722' , 'SEMINATORI DI GIOIA' , '94' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '117.50' ) 05/05/2023 04:56: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 ( '84175' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '188' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '235.00' ) 05/05/2023 04:56: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 ( '84175' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '11' , '0' , '4' , '10.00' , '10' , '0' , '50' , '55.00' ) 05/05/2023 04:56: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 ( '84175' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '2' , '0' , '4' , '20.00' , '20' , '0' , '50' , '20.00' ) 05/05/2023 04:56: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 ( '84175' , '20951' , 'STORIE DEL NOSTRO TEMPO - F. CERRI' , '1' , '0' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 05/05/2023 05:14:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '1531' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-05') 05/05/2023 05:14:14 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1531' , '2023-05-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.50' , '1.50' , NOW() , NOW() ) 05/05/2023 05:14: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 = '84176' 05/05/2023 05:14:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '84176' 05/05/2023 05:14: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 ( '84176' , '13574' , 'VIA LUCIS' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 05/05/2023 05:15:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '20/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-05-05') 05/05/2023 05:15: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 ( '25' , '20/E' , '2023-05-05' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '633.90' , '633.63' , NOW() , NOW() ) 05/05/2023 05:15: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 = '84177' 05/05/2023 05:15:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '84177' 05/05/2023 05:15: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 ( '84177' , '5446' , 'IO SONO CON VOI - GUIDA' , '3' , '3' , '4' , '6' , '6' , '0' , '50' , '9.00' ) 05/05/2023 05:15: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 ( '84177' , '11183' , 'VENITE CON ME - GUIDA' , '3' , '3' , '4' , '6.00' , '6' , '0' , '50' , '9.00' ) 05/05/2023 05:15: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 ( '84177' , '9675' , 'SARETE MIEI TESTIMONI' , '4' , '4' , '4' , '3' , '3' , '0' , '50' , '6.00' ) 05/05/2023 05:15: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 ( '84177' , '8254' , 'PREGHIAMO CON MARIA' , '3' , '3' , '4' , '0.65' , '0.65' , '0' , '50' , '0.98' ) 05/05/2023 05:15: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 ( '84177' , '5457' , 'IO SONO CON VOI 1 PARTE' , '22' , '22' , '4' , '2.50' , '2.5' , '0' , '50' , '27.50' ) 05/05/2023 05:15: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 ( '84177' , '5458' , 'IO SONO CON VOI 2 PARTE' , '35' , '35' , '4' , '2.50' , '2.5' , '0' , '50' , '43.75' ) 05/05/2023 05:15: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 ( '84177' , '11191' , 'VENITE CON ME 1 PARTE' , '48' , '48' , '4' , '2.50' , '2.5' , '0' , '50' , '60.00' ) 05/05/2023 05:15: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 ( '84177' , '11192' , 'VENITE CON ME 2 PARTE' , '68' , '68' , '4' , '2.50' , '2.5' , '0' , '50' , '85.00' ) 05/05/2023 05:15: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 ( '84177' , '11312' , 'VIA CRUCIS PER RAGAZZI ' , '3' , '3' , '4' , '0.85' , '0.85' , '0' , '50' , '1.27' ) 05/05/2023 05:15: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 ( '84177' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 05/05/2023 05:15: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 ( '84177' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '18' , '18' , '4' , '8.00' , '8' , '0' , '50' , '72.00' ) 05/05/2023 05:15: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 ( '84177' , '8408' , 'PRENDETE E MANGIATE' , '3' , '3' , '4' , '3.00' , '3' , '0' , '50' , '4.50' ) 05/05/2023 05:15: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 ( '84177' , '4154' , 'FESTA DEL PERDONO' , '4' , '4' , '4' , '3.00' , '3' , '0' , '50' , '6.00' ) 05/05/2023 05:15: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 ( '84177' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '2' , '2' , '4' , '12.00' , '12' , '0' , '50' , '12.00' ) 05/05/2023 05:15: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 ( '84177' , '1833' , 'CATECHISTA: VOCAZIONE E MISSIONE ' , '5' , '5' , '4' , '3.00' , '3' , '0' , '50' , '7.50' ) 05/05/2023 05:15: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 ( '84177' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '5' , '5' , '4' , '3.50' , '3.5' , '0' , '50' , '8.75' ) 05/05/2023 05:15: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 ( '84177' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '5' , '5' , '4' , '3.50' , '3.5' , '0' , '50' , '8.75' ) 05/05/2023 05:15: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 ( '84177' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 05/05/2023 05:15: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 ( '84177' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '6' , '6' , '4' , '3.50' , '3.5' , '0' , '50' , '10.50' ) 05/05/2023 05:15: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 ( '84177' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '1' , '1' , '4' , '1.60' , '1.6' , '0' , '50' , '0.80' ) 05/05/2023 05:15: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 ( '84177' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 05/05/2023 05:15: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 ( '84177' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 05/05/2023 05:15: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 ( '84177' , '12819' , 'REGISTRO DEL CATECHISTA ' , '3' , '3' , '1' , '1.00' , '0.81967213114754' , '22' , '50' , '1.50' ) 05/05/2023 05:15: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 ( '84177' , '12813' , 'MARIA MADRE NOSTRA' , '3' , '3' , '4' , '3.00' , '3' , '0' , '50' , '4.50' ) 05/05/2023 05:15: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 ( '84177' , '12255' , 'IN CAMMINO CON GESU' , '2' , '2' , '4' , '3.80' , '3.8' , '0' , '50' , '3.80' ) 05/05/2023 05:15: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 ( '84177' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '8' , '8' , '4' , '3.50' , '3.5' , '0' , '50' , '14.00' ) 05/05/2023 05:15: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 ( '84177' , '15115' , 'CONVERSIONE - G. CELENTANO' , '2' , '2' , '4' , '15.00' , '15' , '0' , '50' , '15.00' ) 05/05/2023 05:15: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 ( '84177' , '13137' , 'CON LA BIBBIA E IL CATECHISMO - S. LA PEGNA' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 05/05/2023 05:15: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 ( '84177' , '14031' , 'SEGNO DELLA CROCE' , '4' , '4' , '4' , '3.00' , '3' , '0' , '50' , '6.00' ) 05/05/2023 05:15: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 ( '84177' , '14030' , 'PADRE NOSTRO' , '3' , '3' , '4' , '3.00' , '3' , '0' , '50' , '4.50' ) 05/05/2023 05:15: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 ( '84177' , '14032' , 'AVE MARIA' , '4' , '4' , '4' , '3.00' , '3' , '0' , '50' , '6.00' ) 05/05/2023 05:15: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 ( '84177' , '14260' , 'CUORE CHE BATTE - TORNARE AD AMARE IL CREATO' , '1' , '1' , '4' , '8.00' , '8' , '0' , '50' , '4.00' ) 05/05/2023 05:15: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 ( '84177' , '14029' , 'ANGELO DI DIO' , '1' , '1' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 05/05/2023 05:15: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 ( '84177' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '2' , '2' , '4' , '3.50' , '3.5' , '0' , '50' , '3.50' ) 05/05/2023 05:15: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 ( '84177' , '16041' , 'PRIMI PASSI NEL CAMMINO DI FEDE - M. VIANI' , '1' , '1' , '4' , '6.00' , '6' , '0' , '50' , '3.00' ) 05/05/2023 05:15: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 ( '84177' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '67' , '67' , '4' , '1.00' , '1' , '0' , '50' , '33.50' ) 05/05/2023 05:15: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 ( '84177' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '3' , '3' , '4' , '2.00' , '2' , '0' , '50' , '3.00' ) 05/05/2023 05:15: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 ( '84177' , '16667' , 'VIA CRUCIS' , '3' , '3' , '4' , '3.00' , '3' , '0' , '50' , '4.50' ) 05/05/2023 05:15: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 ( '84177' , '17257' , 'IO TI BATTEZZO ' , '15' , '15' , '4' , '1.80' , '1.8' , '0' , '50' , '13.50' ) 05/05/2023 05:15: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 ( '84177' , '17274' , 'VENITE BENEDETTI DEL PADRE MIO' , '5' , '5' , '4' , '3.00' , '3' , '0' , '50' , '7.50' ) 05/05/2023 05:15: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 ( '84177' , '17582' , 'SAN CESARE DE BUS' , '1' , '1' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 05/05/2023 05:15: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 ( '84177' , '18036' , 'FERITE FERITOIE ' , '1' , '1' , '4' , '8.00' , '8' , '0' , '50' , '4.00' ) 05/05/2023 05:15: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 ( '84177' , '18175' , 'VIA DI SAN GIUSEPPE - G. POLIDORO' , '3' , '3' , '4' , '4.80' , '4.8' , '0' , '50' , '7.20' ) 05/05/2023 05:15: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 ( '84177' , '18176' , 'ANTIQUUM MINISTERIUM ' , '50' , '50' , '4' , '1.00' , '1' , '0' , '50' , '25.00' ) 05/05/2023 05:15: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 ( '84177' , '18460' , 'CON CUORE DI PADRE - V. SALVOLDI' , '4' , '4' , '4' , '2.00' , '2' , '0' , '50' , '4.00' ) 05/05/2023 05:15: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 ( '84177' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '13' , '13' , '4' , '1.90' , '1.9' , '0' , '50' , '12.35' ) 05/05/2023 05:15: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 ( '84177' , '17861' , 'CARTA DIDENTITA DELLA CHIESA - R. LUPI' , '5' , '5' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 05/05/2023 05:15: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 ( '84177' , '18497' , 'BUONA DOMENICA - ANNO A - G. BAGET BOZZO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '50' , '8.00' ) 05/05/2023 05:15: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 ( '84177' , '18498' , 'BUONA DOMENICA - ANNO B - G. BAGET BOZZO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '50' , '8.00' ) 05/05/2023 05:15: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 ( '84177' , '18499' , 'BUONA DOMENICA - ANNO C - G. BAGET BOZZO' , '2' , '2' , '4' , '16.00' , '16' , '0' , '50' , '16.00' ) 05/05/2023 05:15: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 ( '84177' , '18527' , 'SOGNI DI PACE - V. SAVOLDI' , '13' , '13' , '4' , '2.00' , '2' , '0' , '50' , '13.00' ) 05/05/2023 05:16:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '58/A' AND id_document != '84077' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-05-02') 05/05/2023 05:16:06 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '58/A', document_date = '2023-05-02', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'cappellania SAN LEONARDO', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '75.56', price_tax_excluded = '75.56', date_upd = NOW() WHERE id_document = '84077' 05/05/2023 05:16: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 = '84077' 05/05/2023 05:16:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '84077' 05/05/2023 05:16: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 ( '84077' , '20766' , 'AMEN - GIU 23' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 05/05/2023 05:16: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 ( '84077' , '20765' , 'AMEN - MAG 23' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 05/05/2023 05:16: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 ( '84077' , '20999' , 'AMEN - LUG 23' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 05/05/2023 05:16: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 ( '84077' , '' , 'SUPPLICA' , '2' , '-2' , '0' , '10' , '10' , '' , '0' , '20.00' ) 05/05/2023 05:16:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '1532' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-05') 05/05/2023 05:16:53 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1532' , '2023-05-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.00' , '27.05' , NOW() , NOW() ) 05/05/2023 05:16:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84178' 05/05/2023 05:16:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '84178' 05/05/2023 05:16:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84178' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '10' , '-10' , '1' , '3.3' , '2.7049180327869' , '22' , '0' , '33.00' ) 05/05/2023 05:21:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '20/E' AND id_document != '84177' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-05-05') 05/05/2023 05:21:21 pm >> UPDATE ps_document SET id_document_type = '25', document_num = '20/E', document_date = '2023-05-05', document_letter = 'E', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'RESA APRILE 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 = '984.85', price_tax_excluded = '984.58', date_upd = NOW() WHERE id_document = '84177' 05/05/2023 05:21:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84177' 05/05/2023 05:21:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '84177' 05/05/2023 05:21:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '5446' , 'IO SONO CON VOI - GUIDA' , '3' , '3' , '4' , '6.0000' , '6' , '0' , '50' , '9.00' ) 05/05/2023 05:21:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '11183' , 'VENITE CON ME - GUIDA' , '3' , '3' , '4' , '6.0000' , '6' , '0' , '50' , '9.00' ) 05/05/2023 05:21:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '9675' , 'SARETE MIEI TESTIMONI' , '4' , '4' , '4' , '3.0000' , '3' , '0' , '50' , '6.00' ) 05/05/2023 05:21:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '8254' , 'PREGHIAMO CON MARIA' , '3' , '3' , '4' , '0.6500' , '0.65' , '0' , '50' , '0.98' ) 05/05/2023 05:21:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '5457' , 'IO SONO CON VOI 1 PARTE' , '22' , '22' , '4' , '2.5000' , '2.5' , '0' , '50' , '27.50' ) 05/05/2023 05:21:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '5458' , 'IO SONO CON VOI 2 PARTE' , '35' , '35' , '4' , '2.5000' , '2.5' , '0' , '50' , '43.75' ) 05/05/2023 05:21:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '11191' , 'VENITE CON ME 1 PARTE' , '48' , '48' , '4' , '2.5000' , '2.5' , '0' , '50' , '60.00' ) 05/05/2023 05:21:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '11192' , 'VENITE CON ME 2 PARTE' , '68' , '68' , '4' , '2.5000' , '2.5' , '0' , '50' , '85.00' ) 05/05/2023 05:21:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '11312' , 'VIA CRUCIS PER RAGAZZI ' , '3' , '3' , '4' , '0.8500' , '0.85' , '0' , '50' , '1.27' ) 05/05/2023 05:21:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '1' , '1' , '4' , '10.0000' , '10' , '0' , '50' , '5.00' ) 05/05/2023 05:21:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '18' , '18' , '4' , '8.0000' , '8' , '0' , '50' , '72.00' ) 05/05/2023 05:21:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '8408' , 'PRENDETE E MANGIATE' , '3' , '3' , '4' , '3.0000' , '3' , '0' , '50' , '4.50' ) 05/05/2023 05:21:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '4154' , 'FESTA DEL PERDONO' , '4' , '4' , '4' , '3.0000' , '3' , '0' , '50' , '6.00' ) 05/05/2023 05:21:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '2' , '2' , '4' , '12.0000' , '12' , '0' , '50' , '12.00' ) 05/05/2023 05:21:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '1833' , 'CATECHISTA: VOCAZIONE E MISSIONE ' , '5' , '5' , '4' , '3.0000' , '3' , '0' , '50' , '7.50' ) 05/05/2023 05:21:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '5' , '5' , '4' , '3.5000' , '3.5' , '0' , '50' , '8.75' ) 05/05/2023 05:21:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '5' , '5' , '4' , '3.5000' , '3.5' , '0' , '50' , '8.75' ) 05/05/2023 05:21:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '1' , '4' , '10.0000' , '10' , '0' , '50' , '5.00' ) 05/05/2023 05:21:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '6' , '6' , '4' , '3.5000' , '3.5' , '0' , '50' , '10.50' ) 05/05/2023 05:21:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '1' , '1' , '4' , '1.6000' , '1.6' , '0' , '50' , '0.80' ) 05/05/2023 05:21:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '1' , '4' , '10.0000' , '10' , '0' , '50' , '5.00' ) 05/05/2023 05:21:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '1' , '4' , '10.0000' , '10' , '0' , '50' , '5.00' ) 05/05/2023 05:21:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '12819' , 'REGISTRO DEL CATECHISTA ' , '3' , '3' , '1' , '1.0000' , '0.81967213114754' , '22' , '50' , '1.50' ) 05/05/2023 05:21:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '12813' , 'MARIA MADRE NOSTRA' , '3' , '3' , '4' , '3.0000' , '3' , '0' , '50' , '4.50' ) 05/05/2023 05:21:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '12255' , 'IN CAMMINO CON GESU' , '2' , '2' , '4' , '3.8000' , '3.8' , '0' , '50' , '3.80' ) 05/05/2023 05:21:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '8' , '8' , '4' , '3.5000' , '3.5' , '0' , '50' , '14.00' ) 05/05/2023 05:21:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '15115' , 'CONVERSIONE - G. CELENTANO' , '2' , '2' , '4' , '15.0000' , '15' , '0' , '50' , '15.00' ) 05/05/2023 05:21:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '13137' , 'CON LA BIBBIA E IL CATECHISMO - S. LA PEGNA' , '1' , '1' , '4' , '10.0000' , '10' , '0' , '50' , '5.00' ) 05/05/2023 05:21:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '14031' , 'SEGNO DELLA CROCE' , '4' , '4' , '4' , '3.0000' , '3' , '0' , '50' , '6.00' ) 05/05/2023 05:21:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '14030' , 'PADRE NOSTRO' , '3' , '3' , '4' , '3.0000' , '3' , '0' , '50' , '4.50' ) 05/05/2023 05:21:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '14032' , 'AVE MARIA' , '4' , '4' , '4' , '3.0000' , '3' , '0' , '50' , '6.00' ) 05/05/2023 05:21:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '14260' , 'CUORE CHE BATTE - TORNARE AD AMARE IL CREATO' , '1' , '1' , '4' , '8.0000' , '8' , '0' , '50' , '4.00' ) 05/05/2023 05:21:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '14029' , 'ANGELO DI DIO' , '1' , '1' , '4' , '3.0000' , '3' , '0' , '50' , '1.50' ) 05/05/2023 05:21:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '2' , '2' , '4' , '3.5000' , '3.5' , '0' , '50' , '3.50' ) 05/05/2023 05:21:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '16041' , 'PRIMI PASSI NEL CAMMINO DI FEDE - M. VIANI' , '1' , '1' , '4' , '6.0000' , '6' , '0' , '50' , '3.00' ) 05/05/2023 05:21:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '67' , '67' , '4' , '1.0000' , '1' , '0' , '50' , '33.50' ) 05/05/2023 05:21:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '3' , '3' , '4' , '2.0000' , '2' , '0' , '50' , '3.00' ) 05/05/2023 05:21:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '16667' , 'VIA CRUCIS' , '3' , '3' , '4' , '3.0000' , '3' , '0' , '50' , '4.50' ) 05/05/2023 05:21:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '17257' , 'IO TI BATTEZZO ' , '15' , '15' , '4' , '1.8000' , '1.8' , '0' , '50' , '13.50' ) 05/05/2023 05:21:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '17274' , 'VENITE BENEDETTI DEL PADRE MIO' , '5' , '5' , '4' , '3.0000' , '3' , '0' , '50' , '7.50' ) 05/05/2023 05:21:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '17582' , 'SAN CESARE DE BUS' , '1' , '1' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 05/05/2023 05:21:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '18036' , 'FERITE FERITOIE ' , '1' , '1' , '4' , '8.0000' , '8' , '0' , '50' , '4.00' ) 05/05/2023 05:21:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '18175' , 'VIA DI SAN GIUSEPPE - G. POLIDORO' , '3' , '3' , '4' , '4.8000' , '4.8' , '0' , '50' , '7.20' ) 05/05/2023 05:21:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '18176' , 'ANTIQUUM MINISTERIUM ' , '50' , '50' , '4' , '1.0000' , '1' , '0' , '50' , '25.00' ) 05/05/2023 05:21:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '18460' , 'CON CUORE DI PADRE - V. SALVOLDI' , '4' , '4' , '4' , '2.0000' , '2' , '0' , '50' , '4.00' ) 05/05/2023 05:21:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '13' , '13' , '4' , '1.9000' , '1.9' , '0' , '50' , '12.35' ) 05/05/2023 05:21:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '17861' , 'CARTA DIDENTITA DELLA CHIESA - R. LUPI' , '5' , '5' , '4' , '2.5000' , '2.5' , '0' , '50' , '6.25' ) 05/05/2023 05:21:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '18497' , 'BUONA DOMENICA - ANNO A - G. BAGET BOZZO' , '1' , '1' , '4' , '16.0000' , '16' , '0' , '50' , '8.00' ) 05/05/2023 05:21:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '18498' , 'BUONA DOMENICA - ANNO B - G. BAGET BOZZO' , '1' , '1' , '4' , '16.0000' , '16' , '0' , '50' , '8.00' ) 05/05/2023 05:21:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '18499' , 'BUONA DOMENICA - ANNO C - G. BAGET BOZZO' , '2' , '2' , '4' , '16.0000' , '16' , '0' , '50' , '16.00' ) 05/05/2023 05:21:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '18527' , 'SOGNI DI PACE - V. SAVOLDI' , '13' , '13' , '4' , '2.0000' , '2' , '0' , '50' , '13.00' ) 05/05/2023 05:21:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '18529' , 'SAN CESARE DE BUS - FUMETTO' , '1' , '1' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 05/05/2023 05:21:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '18657' , 'HO DATO LORO LA TUA PAROLA - G. VALSECCHI' , '3' , '3' , '4' , '16.00' , '16' , '0' , '50' , '24.00' ) 05/05/2023 05:21:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '6' , '6' , '4' , '7.00' , '7' , '0' , '50' , '21.00' ) 05/05/2023 05:21:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '18423' , 'VIA DI SAN FRANCESCO - G. POLIDORO' , '3' , '3' , '4' , '4.80' , '4.8' , '0' , '50' , '7.20' ) 05/05/2023 05:21:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '3' , '3' , '4' , '2.00' , '2' , '0' , '50' , '3.00' ) 05/05/2023 05:21:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '5' , '5' , '4' , '9.00' , '9' , '0' , '50' , '22.50' ) 05/05/2023 05:21:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '4' , '4' , '4' , '9.00' , '9' , '0' , '50' , '18.00' ) 05/05/2023 05:21:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '5' , '5' , '4' , '9.00' , '9' , '0' , '50' , '22.50' ) 05/05/2023 05:21:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '4' , '4' , '4' , '10.00' , '10' , '0' , '50' , '20.00' ) 05/05/2023 05:21:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '18950' , 'DOVE FINITO IL CONCILIO? - F. CERRI' , '1' , '1' , '4' , '18.00' , '18' , '0' , '50' , '9.00' ) 05/05/2023 05:21:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '19088' , 'TU SOLO IL SANTO - G. VALSECCHI' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 05/05/2023 05:21:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '5' , '5' , '4' , '12.00' , '12' , '0' , '50' , '30.00' ) 05/05/2023 05:21:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '60' , '60' , '4' , '2.50' , '2.5' , '0' , '50' , '75.00' ) 05/05/2023 05:21:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '5' , '5' , '4' , '4.50' , '4.5' , '0' , '50' , '11.25' ) 05/05/2023 05:21:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE' , '35' , '35' , '4' , '2.50' , '2.5' , '0' , '50' , '43.75' ) 05/05/2023 05:21:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '20231' , 'PREGANDO NON SPRECATE PAROLE - G. DAMORE' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 05/05/2023 05:21:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '20640' , 'GESU, MOSSO A COMPASSIONE V. SALVOLDI' , '17' , '17' , '4' , '2.50' , '2.5' , '0' , '50' , '21.25' ) 05/05/2023 05:21:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84177' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '10' , '10' , '4' , '2.00' , '2' , '0' , '50' , '10.00' ) 05/05/2023 05:42:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '1533' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-05') 05/05/2023 05:42:16 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' , '1533' , '2023-05-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.00' , '3.85' , NOW() , NOW() ) 05/05/2023 05:42:16 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 = '84179' 05/05/2023 05:42:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '84179' 05/05/2023 05:42: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 ( '84179' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '4.00' ) 05/05/2023 05:46:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '1534' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-05') 05/05/2023 05:46:32 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1534' , '2023-05-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '5.00' , NOW() , NOW() ) 05/05/2023 05:46: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 = '84180' 05/05/2023 05:46:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '84180' 05/05/2023 05:46: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 ( '84180' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 05/05/2023 06:32:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '1535' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-05') 05/05/2023 06:32:24 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1535' , '2023-05-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 05/05/2023 06:32:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84181' 05/05/2023 06:32:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '84181' 05/05/2023 06:32:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84181' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '20' , '-20' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '10.00' ) 05/05/2023 06:48:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '1536' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-05') 05/05/2023 06:48:04 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1536' , '2023-05-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.90' , '11.34' , NOW() , NOW() ) 05/05/2023 06:48:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84182' 05/05/2023 06:48:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '84182' 05/05/2023 06:48:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84182' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 05/05/2023 06:48:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84182' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 05/05/2023 06:48:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84182' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '1.90' )