05/12/2024 09:09:06 am >> SELECT document_num FROM ps_document WHERE document_num = '3806' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-05') 05/12/2024 09:09:06 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' , '3806' , '2024-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 05/12/2024 09:09:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94697' 05/12/2024 09:09:06 am >> DELETE FROM ps_document_detail WHERE id_document = '94697' 05/12/2024 09:09:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94697' , '22870' , 'AGENDA SAN PAOLO 2025' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 05/12/2024 09:14:03 am >> SELECT document_num FROM ps_document WHERE document_num = '3807' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-05') 05/12/2024 09:14: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' , '3807' , '2024-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '3.00' , NOW() , NOW() ) 05/12/2024 09:14: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 = '94698' 05/12/2024 09:14:03 am >> DELETE FROM ps_document_detail WHERE id_document = '94698' 05/12/2024 09:14: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 ( '94698' , '2777' , 'CORONCINA E NOVENA ALLA DIVINA MISERICORDIA - 8189' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 05/12/2024 09:21:43 am >> SELECT document_num FROM ps_document WHERE document_num = '3808' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-05') 05/12/2024 09:21:43 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' , '3808' , '2024-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1700.00' , '1393.44' , NOW() , NOW() ) 05/12/2024 09:21:43 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 = '94699' 05/12/2024 09:21:43 am >> DELETE FROM ps_document_detail WHERE id_document = '94699' 05/12/2024 09:21:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94699' , '14351' , 'CASULA IN SETA - 132DKW' , '1' , '-1' , '1' , '1700' , '1393.4426229508' , '22' , '0' , '1700.00' ) 05/12/2024 09:29:27 am >> DELETE FROM ps_document WHERE id_document = '94699' 05/12/2024 09:29:27 am >> DELETE FROM ps_document_detail WHERE id_document = '94699' 05/12/2024 09:29:40 am >> SELECT document_num FROM ps_document WHERE document_num = '3808' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-05') 05/12/2024 09:29:40 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' , '3808' , '2024-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '4.10' , NOW() , NOW() ) 05/12/2024 09:29:40 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 = '94700' 05/12/2024 09:29:40 am >> DELETE FROM ps_document_detail WHERE id_document = '94700' 05/12/2024 09:29:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94700' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 05/12/2024 09:34:47 am >> SELECT document_num FROM ps_document WHERE document_num = '3808' AND id_document != '94700' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-05') 05/12/2024 09:34:47 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3808', document_date = '2024-12-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 = '5.00', price_tax_excluded = '4.10', date_upd = NOW() WHERE id_document = '94700' 05/12/2024 09:34:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94700' 05/12/2024 09:34:47 am >> DELETE FROM ps_document_detail WHERE id_document = '94700' 05/12/2024 09:34:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94700' , '16329' , 'GRUPPO NATIVITA CM 11' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 05/12/2024 09:40:10 am >> SELECT document_num FROM ps_document WHERE document_num = '3809' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-05') 05/12/2024 09:40:10 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3809' , '2024-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1500.00' , '1229.51' , NOW() , NOW() ) 05/12/2024 09:40: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 = '94701' 05/12/2024 09:40:10 am >> DELETE FROM ps_document_detail WHERE id_document = '94701' 05/12/2024 09:40: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 ( '94701' , '14351' , 'CASULA IN SETA - 132DKW' , '1' , '-1' , '1' , '1500' , '1229.5081967213' , '22' , '0' , '1500.00' ) 05/12/2024 09:50:28 am >> SELECT document_num FROM ps_document WHERE document_num = '3810' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-05') 05/12/2024 09:50:28 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' , '3810' , '2024-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.25' , '52.25' , NOW() , NOW() ) 05/12/2024 09:50:28 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 = '94702' 05/12/2024 09:50:28 am >> DELETE FROM ps_document_detail WHERE id_document = '94702' 05/12/2024 09:50:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94702' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '11' , '-11' , '4' , '5.00' , '5' , '0' , '5' , '52.25' ) 05/12/2024 10:13:46 am >> SELECT document_num FROM ps_document WHERE document_num = '261' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-12-05') 05/12/2024 10:13:46 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' , '261' , '2024-12-05' , '' , '276' , '0' , '4679313' , 'P.ZZA DON GIUSTINO RUSSOLILLO 84045 ALTAVILLA SILENTINA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '59.50' , '59.50' , NOW() , NOW() ) 05/12/2024 10:13:46 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 = '94703' 05/12/2024 10:13:46 am >> DELETE FROM ps_document_detail WHERE id_document = '94703' 05/12/2024 10:13:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94703' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '25' , '-25' , '4' , '2.80' , '2.8' , '0' , '15' , '59.50' ) 05/12/2024 10:54:46 am >> SELECT document_num FROM ps_document WHERE document_num = '3811' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-05') 05/12/2024 10:54:46 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' , '3811' , '2024-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 05/12/2024 10:54:46 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 = '94704' 05/12/2024 10:54:46 am >> DELETE FROM ps_document_detail WHERE id_document = '94704' 05/12/2024 10:54:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94704' , '17400' , 'STATUA MIRACOLOSA CM 40 - 805' , '1' , '-1' , '1' , '80' , '65.573770491803' , '22' , '0' , '80.00' ) 05/12/2024 10:54:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94704' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 05/12/2024 11:27:44 am >> SELECT document_num FROM ps_document WHERE document_num = '3812' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-05') 05/12/2024 11:27:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3812' , '2024-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.75' , '48.75' , NOW() , NOW() ) 05/12/2024 11:27:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94705' 05/12/2024 11:27:44 am >> DELETE FROM ps_document_detail WHERE id_document = '94705' 05/12/2024 11:27:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94705' , '12104' , 'MINISTERO ORDINATO - E. CASTELLUCCI' , '1' , '-1' , '4' , '26.00' , '26' , '0' , '5' , '24.70' ) 05/12/2024 11:27:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94705' , '23014' , 'GIUBILEO 2025 - SUSSIDIO RAGAZZI' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 05/12/2024 11:27:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94705' , '9767' , 'SCUOLA PER CATECHISTI N.E.' , '1' , '-1' , '4' , '19.90' , '19.9' , '0' , '5' , '18.91' ) 05/12/2024 11:27:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94705' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 05/12/2024 12:04:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '3813' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-05') 05/12/2024 12:04:00 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3813' , '2024-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '290.00' , '237.70' , NOW() , NOW() ) 05/12/2024 12:04:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94706' 05/12/2024 12:04:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '94706' 05/12/2024 12:04:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94706' , '20263' , 'PIZZO IHS UVA - PIZ0M420' , '2' , '-2' , '1' , '145.00' , '118.85245901639' , '22' , '0' , '290.00' ) 05/12/2024 12:12:23 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 05/12/2024 12:12:23 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23291' , '1' , '' , 'nuovo-prodotto' ) 05/12/2024 12:12:23 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23291' , '1' , '1' , '2' , NOW() , NOW() ) 05/12/2024 12:12:23 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23291' , '0' , '1' , '0' , '0' ) 05/12/2024 12:14:13 pm >> INSERT INTO ps_category ( id_parent , `date_add` , `date_upd` , level_depth ) VALUES ( '4' , NOW() , NOW() , '3' ) 05/12/2024 12:14:13 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '548' , '1' ) 05/12/2024 12:14:13 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '548' , '2' ) 05/12/2024 12:14:13 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '548' , '3' ) 05/12/2024 12:14:13 pm >> INSERT INTO ps_category_lang ( id_category , id_lang , name , link_rewrite ) VALUES ( '548' , '1' , 'ELECTAJUNIOR' , LOWER('ELECTAJUNIOR') ) 05/12/2024 12:14:13 pm >> INSERT INTO ps_category_shop ( id_category , id_shop , position ) VALUES ( '548' , '1' , '0' ) 05/12/2024 12:14:20 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788891842091' AND id_product != '23291' AND ean13 != '' 05/12/2024 12:14:20 pm >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 2', ean13 = '9788891842091', date_upd = NOW() WHERE id_product = '23291' 05/12/2024 12:14:20 pm >> UPDATE ps_product_lang SET name = 'PEZZO DI CIELO SOLO PER TE - D. BANZATO', description = '' WHERE id_product = '23291' 05/12/2024 12:14:20 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.9' WHERE id_product = '23291' 05/12/2024 12:14:20 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.9', id_tax_rules_group = '4', id_category_default = '548', id_argoment_default = '72', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23291' 05/12/2024 12:14:20 pm >> DELETE FROM ps_specific_price WHERE id_product = '23291' 05/12/2024 12:14:44 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23291' 05/12/2024 12:14:44 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23292' , '1' , '' , 'nuovo-prodotto' ) 05/12/2024 12:14:44 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23292' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23291' 05/12/2024 12:14:44 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23292' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23291' 05/12/2024 12:15:44 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788856696912' AND id_product != '23292' AND ean13 != '' 05/12/2024 12:15:44 pm >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 1', ean13 = '9788856696912', date_upd = NOW() WHERE id_product = '23292' 05/12/2024 12:15:44 pm >> UPDATE ps_product_lang SET name = 'SPERANZA NON DELUDE - PAPA FRANCESCO', description = '' WHERE id_product = '23292' 05/12/2024 12:15:44 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '17.9' WHERE id_product = '23292' 05/12/2024 12:15:44 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '17.9', id_tax_rules_group = '4', id_category_default = '70', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23292' 05/12/2024 12:15:44 pm >> DELETE FROM ps_specific_price WHERE id_product = '23292' 05/12/2024 12:29: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 ( '33' , '1512496' , '2024-12-04' , '' , '0' , '177' , '4679057' , 'VIA G. VERDI 8 20057 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '123.50' , '123.50' , NOW() , NOW() ) 05/12/2024 12:29: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 = '94707' 05/12/2024 12:29:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '94707' 05/12/2024 12:29: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 ( '94707' , '22432' , 'IN SINU JESU' , '2' , '2' , '4' , '18.00' , '18' , '0' , '0' , '36.0000' ) 05/12/2024 12:29:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22432' AND id_supplier = '177' 05/12/2024 12:29:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22432' , '177' , '1' ) 05/12/2024 12:29: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 ( '94707' , '23291' , 'PEZZO DI CIELO SOLO PER TE - D. BANZATO' , '1' , '1' , '4' , '16.90' , '16.9' , '0' , '0' , '16.90' ) 05/12/2024 12:29:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23291' AND id_supplier = '177' 05/12/2024 12:29:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23291' , '177' , '1' ) 05/12/2024 12:29: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 ( '94707' , '23292' , 'SPERANZA NON DELUDE - PAPA FRANCESCO' , '3' , '3' , '4' , '17.90' , '17.9' , '0' , '0' , '53.7000' ) 05/12/2024 12:29:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23292' AND id_supplier = '177' 05/12/2024 12:29:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23292' , '177' , '1' ) 05/12/2024 12:29: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 ( '94707' , '21934' , 'TI VOGLIO BENE - PAPA FRANCESCO' , '1' , '1' , '4' , '16.90' , '16.9' , '0' , '0' , '16.90' ) 05/12/2024 12:29:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21934' AND id_supplier = '177' 05/12/2024 12:29:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21934' , '177' , '1' ) 05/12/2024 12:31:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '3814' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-05') 05/12/2024 12:31: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 ( '11' , '3814' , '2024-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.40' , '9.58' , NOW() , NOW() ) 05/12/2024 12:31: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 = '94708' 05/12/2024 12:31:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '94708' 05/12/2024 12:31: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 ( '94708' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3.4' , '2.7868852459016' , '22' , '0' , '3.40' ) 05/12/2024 12:31: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 ( '94708' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 05/12/2024 12:31: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 ( '94708' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 05/12/2024 12:31: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 ( '94708' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.5' , '1.5' , '0' , '0' , '1.50' ) 05/12/2024 12:31:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '3815' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-05') 05/12/2024 12:31:12 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' , '3815' , '2024-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 05/12/2024 12:31:12 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 = '94709' 05/12/2024 12:31:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '94709' 05/12/2024 12:31:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94709' , '19997' , 'GESU BAMBINO CM 34 - BJ140-34E' , '1' , '-1' , '1' , '55.00' , '45.081967213115' , '22' , '0' , '55.00' ) 05/12/2024 12:56:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '124/A' AND id_document != '94256' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-11-14') 05/12/2024 12:56:23 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '124/A', document_date = '2024-11-14', document_letter = 'A', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', address2 = '', note = 'acconto 05/12 € 260,00', 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 = '752.72', price_tax_excluded = '735.41', date_upd = NOW() WHERE id_document = '94256' 05/12/2024 12:56:23 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 = '94256' 05/12/2024 12:56:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '94256' 05/12/2024 12:56: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 ( '94256' , '2679' , 'CONOSCERE GESU\'' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '15' , '59.50' ) 05/12/2024 12:56: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 ( '94256' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '30' , '-30' , '4' , '3.4000' , '3.4' , '0' , '15' , '86.70' ) 05/12/2024 12:56: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 ( '94256' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '48' , '-48' , '4' , '3.8000' , '3.8' , '0' , '15' , '155.04' ) 05/12/2024 12:56: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 ( '94256' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '51' , '-51' , '4' , '3.8000' , '3.8' , '0' , '15' , '164.73' ) 05/12/2024 12:56: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 ( '94256' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '25' , '-25' , '4' , '3.8000' , '3.8' , '0' , '15' , '80.75' ) 05/12/2024 12:56: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 ( '94256' , '0' , 'natività campana ' , '1' , '-1' , '4' , '110.0000' , '110' , '0' , '0' , '110.00' ) 05/12/2024 12:56: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 ( '94256' , '19071' , 'BAMBINELLO CM 32 - PB9941' , '1' , '-1' , '1' , '60.0000' , '49.180327868852' , '22' , '0' , '60.00' ) 05/12/2024 12:56: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 ( '94256' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '36.00' ) 05/12/2024 12:57:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '3816' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-05') 05/12/2024 12:57:43 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' , '3816' , '2024-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.61' , '5.61' , NOW() , NOW() ) 05/12/2024 12:57:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94710' 05/12/2024 12:57:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '94710' 05/12/2024 12:57:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94710' , '3991' , 'EVANGELII GAUDIUM - RILEGATO ' , '1' , '-1' , '4' , '5.9' , '5.9' , '0' , '5' , '5.61' ) 05/12/2024 01:12:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '3817' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-05') 05/12/2024 01:12:04 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3817' , '2024-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '115.00' , '94.26' , NOW() , NOW() ) 05/12/2024 01:12:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94711' 05/12/2024 01:12:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '94711' 05/12/2024 01:12:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94711' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 05/12/2024 01:12:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94711' , '1220' , 'BICCHIERI FLAMBEAUX - PZ. 50' , '3' , '-3' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '45.00' ) 05/12/2024 02:52:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '240' AND id_document != '94327' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-18') 05/12/2024 02:52:23 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '240', document_date = '2024-11-18', document_letter = '', id_customer = '65', id_supplier = '', id_address = '4679378', address1 = 'VIA SAN MARCO 1 81016 CASTELLO DEL MATESE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '111.44', price_tax_excluded = '111.44', date_upd = NOW() WHERE id_document = '94327' 05/12/2024 02:52:23 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 = '94327' 05/12/2024 02:52:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '94327' 05/12/2024 02:52: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 ( '94327' , '23043' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '5' , '12.35' ) 05/12/2024 02:52: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 ( '94327' , '1833' , 'CATECHISTA: VOCAZIONE E MISSIONE ' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 05/12/2024 02:52: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 ( '94327' , '23199' , 'VERBUM CARO FACTUM EST' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 05/12/2024 02:52: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 ( '94327' , '21659' , 'MARIA RITRATTO DI UNA DONNA ' , '1' , '-1' , '4' , '6.9000' , '6.9' , '0' , '5' , '6.56' ) 05/12/2024 02:52: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 ( '94327' , '23156' , 'ACCOGLIAMO GESU' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 05/12/2024 02:52: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 ( '94327' , '23134' , 'AVVENTO E NATALE 2024/25' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.75' ) 05/12/2024 02:52: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 ( '94327' , '23051' , 'PREGHIERE A MARIA - PAPA FRANCESCO' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '5' , '10.45' ) 05/12/2024 02:52: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 ( '94327' , '23200' , 'VANGELO AL CONTRARIO ANNO C- S. RESCA' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 05/12/2024 02:52: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 ( '94327' , '23126' , 'DI PASQUA IN PASQUA ANNO C - F. ROSINI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 05/12/2024 02:52: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 ( '94327' , '18740' , 'VENITE E PRONTO - ANNO C - A. VITALI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 05/12/2024 02:52: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 ( '94327' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '0.9500' , '0.95' , '0' , '0' , '0.95' ) 05/12/2024 02:52: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 ( '94327' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '2' , '-2' , '4' , '9.5000' , '9.5' , '0' , '0' , '19.00' ) 05/12/2024 03:38:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '3818' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-05') 05/12/2024 03:38:15 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3818' , '2024-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '9.02' , NOW() , NOW() ) 05/12/2024 03:38:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94712' 05/12/2024 03:38:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '94712' 05/12/2024 03:38:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94712' , '14063' , 'STELLARIO PLEX CM 10 / 12' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 05/12/2024 03:39:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '3819' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-05') 05/12/2024 03:39:34 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3819' , '2024-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '85.00' , '69.67' , NOW() , NOW() ) 05/12/2024 03:39:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94713' 05/12/2024 03:39:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '94713' 05/12/2024 03:39:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94713' , '22921' , 'CASULA GIUBILEO 2025' , '1' , '-1' , '1' , '85.00' , '69.672131147541' , '22' , '0' , '85.00' ) 05/12/2024 03:46:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '26/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-05') 05/12/2024 03:46:41 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '22' , '26/S' , '2024-12-05' , 'S' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'VENDUTO NOVEMBRE 2024' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '845.45' , '845.45' , NOW() , NOW() ) 05/12/2024 03:46:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14776' 05/12/2024 03:46:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '14776' 05/12/2024 03:46:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14776' , '17' , 'LA FEDE NELLO ZAINETTO' , '72' , '0' , '4' , '6.00' , '6' , '0' , '50' , '216.00' ) 05/12/2024 03:46:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14776' , '134' , 'AVE MARIA SPIEGATA AI BAMBINI - N.E.' , '21' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '18.90' ) 05/12/2024 03:46:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14776' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '17' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '12.75' ) 05/12/2024 03:46:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14776' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '23' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '28.75' ) 05/12/2024 03:46:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14776' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '12' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '15.00' ) 05/12/2024 03:46:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14776' , '25' , 'PICCOLO DIZIONARIO DEL CRISTIANO' , '1' , '0' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 05/12/2024 03:46:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14776' , '121' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 05/12/2024 03:46:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14776' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '19' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '23.75' ) 05/12/2024 03:46:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14776' , '45' , 'UN ANGELO DI NOME AMADEUS' , '1' , '0' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 05/12/2024 03:46:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14776' , '48' , 'I SANTI E GLI ANIMALI' , '24' , '0' , '4' , '3.00' , '3' , '0' , '50' , '36.00' ) 05/12/2024 03:46:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14776' , '50' , 'PERDONAMI SIGNORE' , '2' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 05/12/2024 03:46:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14776' , '55' , 'AVE MARIA ,SPIEGATA AI BAMBINI' , '5' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '3.75' ) 05/12/2024 03:46:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14776' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '4' , '0' , '4' , '2.00' , '2' , '0' , '50' , '4.00' ) 05/12/2024 03:46:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14776' , '92' , 'LA PREGHIERA DEL ROSARIO' , '10' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '12.50' ) 05/12/2024 03:46:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14776' , '97' , '\"IL NATALE \"\"CHE MERAVIGLIA\"\"\"' , '6' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '4.50' ) 05/12/2024 03:46:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14776' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '12' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '15.00' ) 05/12/2024 03:46:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14776' , '110' , 'SE MI AMI NON PIANGERE' , '110' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '99.00' ) 05/12/2024 03:46:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14776' , '123' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '1' , '0' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 05/12/2024 03:46:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14776' , '115' , 'SAN FRANCESCO DASSISI RACCONTATO AI RAGAZZI N.E.' , '15' , '0' , '4' , '4.00' , '4' , '0' , '50' , '30.00' ) 05/12/2024 03:46:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14776' , '117' , 'La preghiera delle cinque dita n.e.' , '17' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '15.30' ) 05/12/2024 03:46:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14776' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '27' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '33.75' ) 05/12/2024 03:46:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14776' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '139' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '173.75' ) 05/12/2024 03:46:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14776' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '21' , '0' , '4' , '3.00' , '3' , '0' , '50' , '31.50' ) 05/12/2024 03:46:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14776' , '138' , 'LA NASCITA DI GESU' , '5' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 05/12/2024 03:46:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14776' , '139' , 'E NATO - n.e.' , '32' , '0' , '4' , '2.00' , '2' , '0' , '50' , '32.00' ) 05/12/2024 03:46:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14776' , '136' , 'ANGELO DI DIO N.E.' , '15' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '13.50' ) 05/12/2024 03:46:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14776' , '137' , 'AVVENTO' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 05/12/2024 03:46:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14776' , '126' , 'SACRAMENTO DEL PERDONO' , '4' , '0' , '4' , '2.00' , '2' , '0' , '50' , '4.00' ) 05/12/2024 03:48:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '27/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-05') 05/12/2024 03:48:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '25' , '27/S' , '2024-12-05' , 'S' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RESA NOVEMBRE 2024' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.75' , '12.75' , NOW() , NOW() ) 05/12/2024 03:48:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14777' 05/12/2024 03:48:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '14777' 05/12/2024 03:48:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14777' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '4' , '4' , '4' , '2.00' , '2' , '0' , '50' , '4.00' ) 05/12/2024 03:48:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14777' , '99' , 'AVE MARIA PREGHIERE MARIANE' , '5' , '5' , '4' , '2.00' , '2' , '0' , '50' , '5.00' ) 05/12/2024 03:48:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14777' , '104' , 'TEMPO DI QUARESIMA' , '3' , '3' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 05/12/2024 04:06:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '57/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-05') 05/12/2024 04:06:55 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' , '57/E' , '2024-12-05' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'VENDUTO NOVEMBRE 2024' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '10482.18' , '10465.23' , NOW() , NOW() ) 05/12/2024 04:06:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94714' 05/12/2024 04:06:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '94714' 05/12/2024 04:06:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '505' , '0' , '4' , '2.40' , '2.4' , '0' , '50' , '606.00' ) 05/12/2024 04:06:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '55' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '68.75' ) 05/12/2024 04:06:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '5446' , 'IO SONO CON VOI - GUIDA' , '7' , '0' , '4' , '8.00' , '8' , '0' , '50' , '28.00' ) 05/12/2024 04:06:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '11183' , 'VENITE CON ME - GUIDA' , '4' , '0' , '4' , '8.00' , '8' , '0' , '50' , '16.00' ) 05/12/2024 04:06:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '15' , '0' , '4' , '6.20' , '6.2' , '0' , '50' , '46.50' ) 05/12/2024 04:06:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '106' , 'A MESSA SALTANDO DI GIOIA - GUIDA' , '1' , '0' , '4' , '5.16' , '5.16' , '0' , '50' , '2.58' ) 05/12/2024 04:06:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '2448' , 'COLUI IN CUI CREDO' , '25' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '31.25' ) 05/12/2024 04:06:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '9675' , 'SARETE MIEI TESTIMONI' , '369' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '645.75' ) 05/12/2024 04:06:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1008' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '1411.20' ) 05/12/2024 04:06:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '5458' , 'IO SONO CON VOI 2 PARTE' , '743' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '1040.20' ) 05/12/2024 04:06:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '11191' , 'VENITE CON ME 1 PARTE' , '560' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '784.00' ) 05/12/2024 04:06:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '11192' , 'VENITE CON ME 2 PARTE' , '404' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '565.60' ) 05/12/2024 04:06:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '2' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '3.50' ) 05/12/2024 04:06:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '6' , '0' , '4' , '8.00' , '8' , '0' , '50' , '24.00' ) 05/12/2024 04:06:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '3443' , 'DIECI PAROLE DAMORE' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 05/12/2024 04:06:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '5251' , 'INCONTRI EUCARISTICI' , '2' , '0' , '4' , '4.50' , '4.5' , '0' , '50' , '4.50' ) 05/12/2024 04:06:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '418' , '0' , '4' , '3.40' , '3.4' , '0' , '50' , '710.60' ) 05/12/2024 04:06:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '18' , '0' , '4' , '5.00' , '5' , '0' , '50' , '45.00' ) 05/12/2024 04:06:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '5645' , 'LEGGERE,... LA PAROLA - ANNO C' , '2' , '0' , '4' , '10.00' , '10' , '0' , '50' , '10.00' ) 05/12/2024 04:06:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '3978' , 'EUCARISTIA: RITO E VITA' , '3' , '0' , '4' , '10.00' , '10' , '0' , '50' , '15.00' ) 05/12/2024 04:06:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '4' , '0' , '4' , '8.00' , '8' , '0' , '50' , '16.00' ) 05/12/2024 04:06:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '6629' , 'MIA PREGHIERA' , '81' , '0' , '4' , '0.90' , '0.9' , '0' , '50' , '36.45' ) 05/12/2024 04:06:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '8408' , 'PRENDETE E MANGIATE' , '535' , '0' , '4' , '3.00' , '3' , '0' , '50' , '802.50' ) 05/12/2024 04:06:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '9' , '0' , '4' , '5.00' , '5' , '0' , '50' , '22.50' ) 05/12/2024 04:06:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '9' , '0' , '4' , '5.00' , '5' , '0' , '50' , '22.50' ) 05/12/2024 04:06:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '4154' , 'FESTA DEL PERDONO' , '334' , '0' , '4' , '3.00' , '3' , '0' , '50' , '501.00' ) 05/12/2024 04:06:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '7824' , 'PER ILLUMINARE IL CAMMINO' , '1' , '0' , '4' , '0.90' , '0.9' , '0' , '50' , '0.45' ) 05/12/2024 04:06:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '2679' , 'CONOSCERE GESU' , '349' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '610.75' ) 05/12/2024 04:06:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '2680' , 'CONOSCERE GESU - GUIDA' , '9' , '0' , '4' , '6.00' , '6' , '0' , '50' , '27.00' ) 05/12/2024 04:06:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '35' , '0' , '4' , '5.00' , '5' , '0' , '50' , '87.50' ) 05/12/2024 04:06:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '11102' , 'VANGELO E ATTI DEGLI APOSTOLI - RIL.' , '12' , '0' , '4' , '8.50' , '8.5' , '0' , '50' , '51.00' ) 05/12/2024 04:06:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '1' , '0' , '4' , '1.60' , '1.6' , '0' , '50' , '0.80' ) 05/12/2024 04:06:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '1833' , 'CATECHISTA: VOCAZIONE E MISSIONE ' , '1' , '0' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 05/12/2024 04:06:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '1' , '0' , '4' , '25.00' , '25' , '0' , '50' , '12.50' ) 05/12/2024 04:06:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '7543' , 'PARABOLE DI GESÙ' , '21' , '0' , '4' , '3.00' , '3' , '0' , '50' , '31.50' ) 05/12/2024 04:06:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '49' , '0' , '4' , '3.80' , '3.8' , '0' , '50' , '93.10' ) 05/12/2024 04:06:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '35' , '0' , '4' , '3.80' , '3.8' , '0' , '50' , '66.50' ) 05/12/2024 04:06:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '0' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 05/12/2024 04:06:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '12819' , 'REGISTRO DEL CATECHISTA ' , '188' , '0' , '1' , '1.00' , '0.81967213114754' , '22' , '50' , '94.00' ) 05/12/2024 04:06:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '12813' , 'MARIA MADRE NOSTRA' , '1' , '0' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 05/12/2024 04:06:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 05/12/2024 04:06:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '1' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 05/12/2024 04:06:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '44' , '0' , '4' , '6.00' , '6' , '0' , '50' , '132.00' ) 05/12/2024 04:06:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '13397' , 'MIO GESU' , '47' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '82.25' ) 05/12/2024 04:06:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '13956' , 'MIRACOLI DI GESU' , '20' , '0' , '4' , '3.00' , '3' , '0' , '50' , '30.00' ) 05/12/2024 04:06:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '14223' , 'PRONTUARIO BIBLICO - LITURGICO - F. GIGLIO' , '1' , '0' , '4' , '9.00' , '9' , '0' , '50' , '4.50' ) 05/12/2024 04:06:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '10' , '0' , '4' , '1.00' , '1' , '0' , '50' , '5.00' ) 05/12/2024 04:06:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '15019' , 'PREGHIAMO CON MARIA' , '2' , '0' , '4' , '0.80' , '0.8' , '0' , '50' , '0.80' ) 05/12/2024 04:06:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '15020' , 'PREGARE OGNI GIORNO' , '53' , '0' , '4' , '1.00' , '1' , '0' , '50' , '26.50' ) 05/12/2024 04:06:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '1' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 05/12/2024 04:06:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 05/12/2024 04:06:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '17630' , 'RACCONTI SOTTO LALBERO - G. CELENTANO' , '1' , '0' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 05/12/2024 04:06:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '18175' , 'VIA DI SAN GIUSEPPE - G. POLIDORO' , '2' , '0' , '4' , '4.80' , '4.8' , '0' , '50' , '4.80' ) 05/12/2024 04:06:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '18176' , 'ANTIQUUM MINISTERIUM ' , '15' , '0' , '4' , '1.00' , '1' , '0' , '50' , '7.50' ) 05/12/2024 04:06:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '18460' , 'CON CUORE DI PADRE - V. SALVOLDI' , '4' , '0' , '4' , '2.00' , '2' , '0' , '50' , '4.00' ) 05/12/2024 04:06:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '108' , '0' , '4' , '1.90' , '1.9' , '0' , '50' , '102.60' ) 05/12/2024 04:06:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '18499' , 'BUONA DOMENICA - ANNO C - G. BAGET BOZZO' , '1' , '0' , '4' , '16.00' , '16' , '0' , '50' , '8.00' ) 05/12/2024 04:06:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '18527' , 'SOGNI DI PACE - V. SALVOLDI' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 05/12/2024 04:06:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '2' , '0' , '4' , '7.00' , '7' , '0' , '50' , '7.00' ) 05/12/2024 04:06:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '18423' , 'VIA DI SAN FRANCESCO - G. POLIDORO' , '1' , '0' , '4' , '4.80' , '4.8' , '0' , '50' , '2.40' ) 05/12/2024 04:06:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '1' , '0' , '4' , '9.00' , '9' , '0' , '50' , '4.50' ) 05/12/2024 04:06:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '2' , '0' , '4' , '9.00' , '9' , '0' , '50' , '9.00' ) 05/12/2024 04:06:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '1' , '0' , '4' , '9.00' , '9' , '0' , '50' , '4.50' ) 05/12/2024 04:06:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '12' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '15.00' ) 05/12/2024 04:06:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '2' , '0' , '4' , '35.00' , '35' , '0' , '50' , '35.00' ) 05/12/2024 04:06:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE - SALVOLDI' , '12' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '15.00' ) 05/12/2024 04:06:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '20720' , 'PADRE NOSTRO - L. CALABRETTA' , '2' , '0' , '4' , '4.50' , '4.5' , '0' , '50' , '4.50' ) 05/12/2024 04:06:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '20722' , 'SEMINATORI DI GIOIA' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 05/12/2024 04:06:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '1' , '0' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 05/12/2024 04:06:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '21417' , 'VIENI, NON TARDARE SIGNORE, NOSTRA PACE!' , '12' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '15.00' ) 05/12/2024 04:06:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '21644' , 'INCONTRO AL DIO CHE VIENE' , '2' , '0' , '4' , '8.00' , '8' , '0' , '50' , '8.00' ) 05/12/2024 04:06:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '253' , '0' , '4' , '3.00' , '3' , '0' , '50' , '379.50' ) 05/12/2024 04:06:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '22030' , 'PREPARIAMOCI ALLA PRIMA COMUNIONE - POSTER' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 05/12/2024 04:06:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '10' , '0' , '4' , '8.00' , '8' , '0' , '50' , '40.00' ) 05/12/2024 04:06:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '21418' , 'CRISTO NOSTRA PACE - V. SALVORDI' , '2' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 05/12/2024 04:06:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '22034' , 'MISTERI DEL ROSARIO - M. DE ROSA' , '3' , '0' , '4' , '8.00' , '8' , '0' , '50' , '12.00' ) 05/12/2024 04:06:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '20954' , 'TEMPO DELL’APOCALISSE ' , '1' , '0' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 05/12/2024 04:06:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '22' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '30.80' ) 05/12/2024 04:06:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '254' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '355.60' ) 05/12/2024 04:06:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '22152' , 'A TE RICORRIAMO' , '13' , '0' , '4' , '3.00' , '3' , '0' , '50' , '19.50' ) 05/12/2024 04:06:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '23092' , 'SPERANZA CHE E IN NOI' , '135' , '0' , '4' , '3.00' , '3' , '0' , '50' , '202.50' ) 05/12/2024 04:06:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '22871' , 'SPERANZA NON DELUDE - M. DE ROSA' , '19' , '0' , '4' , '8.00' , '8' , '0' , '50' , '76.00' ) 05/12/2024 04:06:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '22961' , 'UN BAMBINO E NATO PER NOI - G. VALSECCHI' , '79' , '0' , '4' , '3.00' , '3' , '0' , '50' , '118.50' ) 05/12/2024 04:06:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94714' , '23032' , 'MIO LIBRO DI PREGHIERE - N. E. ' , '103' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '144.20' ) 05/12/2024 04:11:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '58/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-05') 05/12/2024 04:11:48 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '25' , '58/E' , '2024-12-05' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.90' , '14.90' , NOW() , NOW() ) 05/12/2024 04:11:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94715' 05/12/2024 04:11:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '94715' 05/12/2024 04:11:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '6' , '6' , '4' , '2.40' , '2.4' , '0' , '50' , '7.20' ) 05/12/2024 04:11:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '4' , '4' , '4' , '3.40' , '3.4' , '0' , '50' , '6.80' ) 05/12/2024 04:11:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '6629' , 'MIA PREGHIERA' , '2' , '2' , '4' , '0.90' , '0.9' , '0' , '50' , '0.90' ) 05/12/2024 04:16:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '95/A' AND id_document != '93084' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-09-10') 05/12/2024 04:16:21 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '95/A', document_date = '2024-09-10', document_letter = 'A', id_customer = '2757', id_supplier = '', id_address = '4679343', address1 = 'VIA CIRILLO 84085 MERCATO SAN SEVERINO', 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 = '1339.50', price_tax_excluded = '1107.17', date_upd = NOW() WHERE id_document = '93084' 05/12/2024 04:16: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 = '93084' 05/12/2024 04:16:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '93084' 05/12/2024 04:16:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93084' , '16796' , 'LUMINO 5F BIANCO' , '672' , '-672' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '134.40' ) 05/12/2024 04:16:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93084' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '270.00' ) 05/12/2024 04:16:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93084' , '16796' , 'LUMINO 5B BIANCO' , '2688' , '-2688' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '537.60' ) 05/12/2024 04:16:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93084' , '0' , 'supplca' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 05/12/2024 04:16:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93084' , '15387' , 'VESTINA BATTESIMALE ' , '5' , '-5' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '15.00' ) 05/12/2024 04:16:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93084' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '5' , '-5' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '7.50' ) 05/12/2024 04:16:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93084' , '17160' , 'CARBONCINI ROSSI - CARRO' , '5' , '-5' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '50.00' ) 05/12/2024 04:16:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93084' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '3' , '-3' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '90.00' ) 05/12/2024 04:16:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93084' , '6809' , 'MOCCOLO 60X165' , '4' , '-4' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '18.00' ) 05/12/2024 04:16: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 ( '93084' , '6811' , 'MOCCOLO 80X200' , '8' , '-8' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '72.00' ) 05/12/2024 04:16: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 ( '93084' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 05/12/2024 04:16: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 ( '93084' , '16689' , 'OSTIA PAN DI CENA mm80' , '11' , '-11' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '22.00' ) 05/12/2024 04:16: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 ( '93084' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '11' , '-11' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '38.50' ) 05/12/2024 04:16: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 ( '93084' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 05/12/2024 04:18:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '58/E' AND id_document != '94715' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-05') 05/12/2024 04:18:49 pm >> UPDATE ps_document SET id_document_type = '25', document_num = '58/E', document_date = '2024-12-05', document_letter = 'E', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '29.70', price_tax_excluded = '29.70', date_upd = NOW() WHERE id_document = '94715' 05/12/2024 04:18:49 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 = '94715' 05/12/2024 04:18:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '94715' 05/12/2024 04:18:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '6' , '6' , '4' , '2.4000' , '2.4' , '0' , '50' , '7.20' ) 05/12/2024 04:18:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '4' , '4' , '4' , '3.4000' , '3.4' , '0' , '50' , '6.80' ) 05/12/2024 04:18:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '6629' , 'MIA PREGHIERA' , '2' , '2' , '4' , '0.9000' , '0.9' , '0' , '50' , '0.90' ) 05/12/2024 04:18:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '1' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 05/12/2024 04:18:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '4154' , 'FESTA DEL PERDONO' , '1' , '1' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 05/12/2024 04:18:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '7824' , 'PER ILLUMINARE IL CAMMINO' , '4' , '4' , '4' , '0.90' , '0.9' , '0' , '50' , '1.80' ) 05/12/2024 04:18:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '1' , '1' , '4' , '12.00' , '12' , '0' , '50' , '6.00' ) 05/12/2024 04:18:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '1' , '1' , '4' , '6.00' , '6' , '0' , '50' , '3.00' ) 05/12/2024 04:21:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '95/A' AND id_document != '93084' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-09-10') 05/12/2024 04:21:44 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '95/A', document_date = '2024-09-10', document_letter = 'A', id_customer = '2757', id_supplier = '', id_address = '4679343', address1 = 'VIA CIRILLO 84085 MERCATO SAN SEVERINO', 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 = '1367.50', price_tax_excluded = '1130.12', date_upd = NOW() WHERE id_document = '93084' 05/12/2024 04:21: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 = '93084' 05/12/2024 04:21:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '93084' 05/12/2024 04:21: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 ( '93084' , '16796' , 'LUMINO 5F BIANCO' , '672' , '-672' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '134.40' ) 05/12/2024 04:21: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 ( '93084' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '270.00' ) 05/12/2024 04:21: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 ( '93084' , '16796' , 'LUMINO 5B BIANCO' , '2688' , '-2688' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '537.60' ) 05/12/2024 04:21: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 ( '93084' , '0' , 'supplca' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 05/12/2024 04:21: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 ( '93084' , '15387' , 'VESTINA BATTESIMALE ' , '5' , '-5' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '15.00' ) 05/12/2024 04:21: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 ( '93084' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '5' , '-5' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '7.50' ) 05/12/2024 04:21: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 ( '93084' , '17160' , 'CARBONCINI ROSSI - CARRO' , '5' , '-5' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '50.00' ) 05/12/2024 04:21: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 ( '93084' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '3' , '-3' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '90.00' ) 05/12/2024 04:21: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 ( '93084' , '6809' , 'MOCCOLO 60X165' , '4' , '-4' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '18.00' ) 05/12/2024 04:21: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 ( '93084' , '6811' , 'MOCCOLO 80X200' , '8' , '-8' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '72.00' ) 05/12/2024 04:21: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 ( '93084' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 05/12/2024 04:21: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 ( '93084' , '16689' , 'OSTIA PAN DI CENA mm80' , '11' , '-11' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '22.00' ) 05/12/2024 04:21: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 ( '93084' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '11' , '-11' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '38.50' ) 05/12/2024 04:21: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 ( '93084' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 05/12/2024 04:21: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 ( '93084' , '9716' , 'SCATOLA PORTA OSTIE INOX IHS - CM 9,5 X 12,5 - 682' , '1' , '-1' , '1' , '28' , '22.950819672131' , '22' , '0' , '28.00' ) 05/12/2024 04:27:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '58/E' AND id_document != '94715' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-05') 05/12/2024 04:27:14 pm >> UPDATE ps_document SET id_document_type = '25', document_num = '58/E', document_date = '2024-12-05', document_letter = 'E', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'RESA NOVEMBRE 2024', 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 = '243.95', price_tax_excluded = '243.95', date_upd = NOW() WHERE id_document = '94715' 05/12/2024 04:27: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 = '94715' 05/12/2024 04:27:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '94715' 05/12/2024 04:27: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 ( '94715' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '6' , '6' , '4' , '2.4000' , '2.4' , '0' , '50' , '7.20' ) 05/12/2024 04:27:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '4' , '4' , '4' , '3.4000' , '3.4' , '0' , '50' , '6.80' ) 05/12/2024 04:27:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '6629' , 'MIA PREGHIERA' , '2' , '2' , '4' , '0.9000' , '0.9' , '0' , '50' , '0.90' ) 05/12/2024 04:27:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '1' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 05/12/2024 04:27:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '4154' , 'FESTA DEL PERDONO' , '1' , '1' , '4' , '3.0000' , '3' , '0' , '50' , '1.50' ) 05/12/2024 04:27:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '7824' , 'PER ILLUMINARE IL CAMMINO' , '4' , '4' , '4' , '0.9000' , '0.9' , '0' , '50' , '1.80' ) 05/12/2024 04:27:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '1' , '1' , '4' , '12.0000' , '12' , '0' , '50' , '6.00' ) 05/12/2024 04:27:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '1' , '1' , '4' , '6.0000' , '6' , '0' , '50' , '3.00' ) 05/12/2024 04:27:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '1' , '4' , '1.00' , '1' , '0' , '50' , '0.50' ) 05/12/2024 04:27:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '11' , '11' , '4' , '1.00' , '1' , '0' , '50' , '5.50' ) 05/12/2024 04:27:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '16667' , 'VIA CRUCIS' , '6' , '6' , '4' , '3.00' , '3' , '0' , '50' , '9.00' ) 05/12/2024 04:27:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '16997' , 'PREGHIAMO IL PADRONE DELLE MESSE ' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 05/12/2024 04:27:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '17274' , 'VENITE BENEDETTI DEL PADRE MIO' , '1' , '1' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 05/12/2024 04:27:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '18036' , 'FERITE FERITOIE ' , '1' , '1' , '4' , '8.00' , '8' , '0' , '50' , '4.00' ) 05/12/2024 04:27:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '18528' , 'CON GESU VERSO IL CALVARIO - G. VALSECCHI' , '6' , '6' , '4' , '1.50' , '1.5' , '0' , '50' , '4.50' ) 05/12/2024 04:27:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '1' , '1' , '4' , '7.00' , '7' , '0' , '50' , '3.50' ) 05/12/2024 04:27:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '1' , '1' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 05/12/2024 04:27:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '1' , '1' , '4' , '35.00' , '35' , '0' , '50' , '17.50' ) 05/12/2024 04:27:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '20640' , 'GESU, MOSSO A COMPASSIONE V. SALVOLDI' , '7' , '7' , '4' , '2.50' , '2.5' , '0' , '50' , '8.75' ) 05/12/2024 04:27:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '6' , '6' , '4' , '2.00' , '2' , '0' , '50' , '6.00' ) 05/12/2024 04:27:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '20722' , 'SEMINATORI DI GIOIA' , '2' , '2' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 05/12/2024 04:27:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '4' , '4' , '4' , '3.00' , '3' , '0' , '50' , '6.00' ) 05/12/2024 04:27:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '22031' , 'GLI ULTIMI SARANNO PRIMI - R. LUPI' , '27' , '27' , '4' , '2.50' , '2.5' , '0' , '50' , '33.75' ) 05/12/2024 04:27:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '2' , '2' , '4' , '8.00' , '8' , '0' , '50' , '8.00' ) 05/12/2024 04:27:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '22032' , 'ECCO ORA IL MOMENTO FAVOREVOLE ' , '4' , '4' , '4' , '10.00' , '10' , '0' , '50' , '20.00' ) 05/12/2024 04:27:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '22034' , 'MISTERI DEL ROSARIO - M. DE ROSA' , '3' , '3' , '4' , '8.00' , '8' , '0' , '50' , '12.00' ) 05/12/2024 04:27:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '3' , '3' , '4' , '2.80' , '2.8' , '0' , '50' , '4.20' ) 05/12/2024 04:27:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '2' , '2' , '4' , '2.80' , '2.8' , '0' , '50' , '2.80' ) 05/12/2024 04:27:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '20951' , 'STORIE DEL NOSTRO TEMPO - F. CERRI' , '1' , '1' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 05/12/2024 04:27:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '22053' , 'AMO IL SIGNORE, PERCHÉ ASCOLTA IL GRIDO DELLA MIA PREGHIERA' , '28' , '28' , '4' , '2.50' , '2.5' , '0' , '50' , '35.00' ) 05/12/2024 04:27:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '22153' , 'UNA VITA CONSUMATA NELLAMORE' , '1' , '1' , '4' , '6.00' , '6' , '0' , '50' , '3.00' ) 05/12/2024 04:27:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '22152' , 'A TE RICORRIAMO' , '1' , '1' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 05/12/2024 04:27:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94715' , '22151' , 'MA DIO LO HA RISUSCITATO' , '3' , '3' , '4' , '10.00' , '10' , '0' , '50' , '15.00' ) 05/12/2024 05:01:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '3820' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-05') 05/12/2024 05:01:06 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3820' , '2024-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '3.00' , NOW() , NOW() ) 05/12/2024 05:01: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 = '94716' 05/12/2024 05:01:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '94716' 05/12/2024 05:01: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 ( '94716' , '19414' , 'AVE PIENA DI GRAZIA' , '2' , '-2' , '4' , '1.50' , '1.5' , '0' , '0' , '3.00' ) 05/12/2024 05:25:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '3821' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-05') 05/12/2024 05:25: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' , '3821' , '2024-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.50' , '6.15' , NOW() , NOW() ) 05/12/2024 05:25: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 = '94717' 05/12/2024 05:25:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '94717' 05/12/2024 05:25: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 ( '94717' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '30' , '-30' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '7.50' ) 05/12/2024 06:50:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '3822' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-05') 05/12/2024 06:50:08 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' , '3822' , '2024-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.00' , '17.57' , NOW() , NOW() ) 05/12/2024 06:50:08 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 = '94718' 05/12/2024 06:50:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '94718' 05/12/2024 06:50:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94718' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '7.00' ) 05/12/2024 06:50:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94718' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 05/12/2024 06:50:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94718' , '7202' , 'ARTICOLI RELIGIOSI' , '3' , '-3' , '1' , '3' , '2.4590163934426' , '22' , '0' , '9.00' ) 05/12/2024 06:50:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94718' , '7108' , 'NOVENA AL SANTO NATALE - 8521' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 05/12/2024 06:58:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '262' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-12-05') 05/12/2024 06:58: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 ( '21' , '262' , '2024-12-05' , '' , '100' , '0' , '4677718' , 'P. ZZA GIUSEPPE D\\\'AIUTOLO 2 84090 MONTECORVINO PUGLIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '53.72' , '53.72' , NOW() , NOW() ) 05/12/2024 06:58: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 = '94719' 05/12/2024 06:58:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '94719' 05/12/2024 06:58: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 ( '94719' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '15' , '8.50' ) 05/12/2024 06:58: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 ( '94719' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '14' , '-14' , '4' , '3.80' , '3.8' , '0' , '15' , '45.22' ) 05/12/2024 07:43:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '3823' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-05') 05/12/2024 07:43:46 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3823' , '2024-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.80' , '14.59' , NOW() , NOW() ) 05/12/2024 07:43:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94720' 05/12/2024 07:43:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '94720' 05/12/2024 07:43: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 ( '94720' , '11389' , 'VINO ROSSO DOLCE - 103' , '2' , '-2' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '17.80' ) 05/12/2024 07:46:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '3824' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-05') 05/12/2024 07:46:12 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' , '3824' , '2024-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.80' , '3.11' , NOW() , NOW() ) 05/12/2024 07:46:12 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 = '94721' 05/12/2024 07:46:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '94721' 05/12/2024 07:46:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94721' , '19600' , 'ROSARIO SPIRITO SANTO' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 05/12/2024 07:55:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '3825' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-05') 05/12/2024 07:55: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' , '3825' , '2024-12-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.70' , '7.39' , NOW() , NOW() ) 05/12/2024 07:55: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 = '94722' 05/12/2024 07:55:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '94722' 05/12/2024 07:55: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 ( '94722' , '17052' , 'CROCETTA S. BENEDETTO METALLO OX CM5X3,3 - PG382' , '1' , '-1' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '0.70' ) 05/12/2024 07:55: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 ( '94722' , '18619' , 'MEDAGLIA MIRACOLOSA BLU GRANDE - OV40M/SM' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 05/12/2024 07:55: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 ( '94722' , '13498' , 'CUORE DI SAN FILIPPO NERI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 05/12/2024 07:55: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 ( '94722' , '18636' , 'DIECI COMANDAMENTI - 8941' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' )