07/02/2023 08:30:12 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 
07/02/2023 08:30:12 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20723' , '1' , '' , 'nuovo-prodotto' )
07/02/2023 08:30:12 am >> INSERT INTO ps_product_shop (
                      id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
                  ) VALUES (
                      '20723' , '1' , '1' , '2' , NOW() , NOW()
                  ) 
07/02/2023 08:30:12 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20723' , '0' , '1' , '0' , '0' )
07/02/2023 08:31:04 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892229952' AND id_product != '20723' AND ean13 != '' 
07/02/2023 08:31:04 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '11/4',
                  ean13 = '9788892229952',
                  date_upd = NOW()
                WHERE id_product = '20723' 
07/02/2023 08:31:04 am >> UPDATE ps_product_lang SET
                  name = 'VIA DELLA VITA - A. GRAPPONE',
                  description = ''
                WHERE id_product = '20723' 
07/02/2023 08:31:04 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '12'
                WHERE id_product = '20723' 
07/02/2023 08:31:04 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '12',
                  id_tax_rules_group = '4',
                  id_category_default = '30',
                  id_argoment_default = '20',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '20723' 
07/02/2023 08:31:04 am >> DELETE FROM ps_specific_price WHERE id_product = '20723' 
07/02/2023 08:31:05 am >> INSERT INTO ps_product (
                  id_tax_rules_group , `date_add` , `date_upd`
                ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20723' 
07/02/2023 08:31:05 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20724' , '1' , '' , 'nuovo-prodotto' )
07/02/2023 08:31:05 am >> INSERT INTO ps_product_shop (
                    id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd`
                ) SELECT '20724' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20723' 
07/02/2023 08:31:05 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '20724' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20723' 
07/02/2023 08:32:56 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  (
                          '33' ,
                          '622072' ,
                          '2023-02-03' ,
                          '' ,
                          '0' ,
                          '7' ,
                          '2602' ,
                          'P. ZZA SAN PAOLO, 14 12051 ALBA' ,
                          '' ,
                          '' ,
                          '3.4' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '117.94' ,
                          '117.94' ,
                          NOW() ,
                          NOW() ) 
07/02/2023 08:32:56 am >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81254' 
07/02/2023 08:32:56 am >>  DELETE FROM ps_document_detail WHERE id_document = '81254' 
07/02/2023 08:32:56 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81254' , '20723' , 'VIA DELLA VITA - A. GRAPPONE' , '2' ,  '2' , '4' ,
                               '12.00' , '12' , '0' , '33' , '16.0800' ) 
07/02/2023 08:32:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '20723' AND id_supplier = '7' 
07/02/2023 08:32:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20723' , '7' , '1' ) 
07/02/2023 08:32:56 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81254' , '15276' , 'SCOLLINARE O SRADICARE - VIA CRUCIS' , '12' ,  '12' , '4' ,
                               '2.00' , '2' , '0' , '30' , '16.8000' ) 
07/02/2023 08:32:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '15276' AND id_supplier = '7' 
07/02/2023 08:32:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15276' , '7' , '1' ) 
07/02/2023 08:32:56 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81254' , '15276' , 'SCOLLINARE O SRADICARE - VIA CRUCIS' , '1' ,  '1' , '4' ,
                               '2.00' , '2' , '0' , '100' , '0.0000' ) 
07/02/2023 08:32:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '15276' AND id_supplier = '7' 
07/02/2023 08:32:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15276' , '7' , '1' ) 
07/02/2023 08:32:56 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81254' , '20659' , 'CORSO FONDAMENTALE SULLA FEDE - K. RAHNER' , '1' ,  '1' , '4' ,
                               '38.00' , '38' , '0' , '33' , '25.4600' ) 
07/02/2023 08:32:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '20659' AND id_supplier = '7' 
07/02/2023 08:32:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20659' , '7' , '1' ) 
07/02/2023 08:32:56 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81254' , '20674' , 'GESU VOLTO DI DIO - L. MONTI' , '1' ,  '1' , '4' ,
                               '17.00' , '17' , '0' , '30' , '11.9000' ) 
07/02/2023 08:32:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '20674' AND id_supplier = '7' 
07/02/2023 08:32:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20674' , '7' , '1' ) 
07/02/2023 08:32:56 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81254' , '2073' , 'CINQUE LINGUAGGI DELLAMORE DEI BAMBINI - PER GENITORI E EDUCATORI' , '4' ,  '4' , '4' ,
                               '13.00' , '13' , '0' , '35' , '33.8000' ) 
07/02/2023 08:32:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '2073' AND id_supplier = '7' 
07/02/2023 08:32:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2073' , '7' , '1' ) 
07/02/2023 08:32:56 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81254' , '20675' , 'SULLA VIA DELLA CROCE CON PAPA FRANCESCO' , '5' ,  '5' , '4' ,
                               '3.00' , '3' , '0' , '30' , '10.5000' ) 
07/02/2023 08:32:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '20675' AND id_supplier = '7' 
07/02/2023 08:32:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20675' , '7' , '1' ) 
07/02/2023 09:24:44 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '3/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-07') 
07/02/2023 09:24: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  (
                          '22' ,
                          '3/E' ,
                          '2023-02-07' ,
                          'E' ,
                          '3000' ,
                          '0' ,
                          '4669629' ,
                          'VIA DEI CASTANI, 116 00172 ROMA' ,
                          '' ,
                          'VENDUTO GENNAIO 2023' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '14' ,
                          '0' ,
                          '3375.19' ,
                          '3375.10' ,
                          NOW() ,
                          NOW() ) 
07/02/2023 09:24: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 = '81255' 
07/02/2023 09:24:44 am >>  DELETE FROM ps_document_detail WHERE id_document = '81255' 
07/02/2023 09:24: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
                            ( '81255' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '152' ,  '0' , '4' ,
                               '2.40' , '2.4' , '0' , '50' , '182.40' ) 
07/02/2023 09:24: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
                            ( '81255' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '18' ,  '0' , '4' ,
                               '2.50' , '2.5' , '0' , '50' , '22.50' ) 
07/02/2023 09:24: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
                            ( '81255' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '7' ,  '0' , '4' ,
                               '6.20' , '6.2' , '0' , '50' , '21.70' ) 
07/02/2023 09:24: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
                            ( '81255' , '106' , 'A MESSA SALTANDO DI GIOIA - GUIDA' , '3' ,  '0' , '4' ,
                               '5.16' , '5.16' , '0' , '50' , '7.74' ) 
07/02/2023 09:24: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
                            ( '81255' , '9675' , 'SARETE MIEI TESTIMONI' , '45' ,  '0' , '4' ,
                               '3.50' , '3.5' , '0' , '50' , '78.75' ) 
07/02/2023 09:24: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
                            ( '81255' , '8254' , 'PREGHIAMO CON MARIA' , '12' ,  '0' , '4' ,
                               '0.65' , '0.65' , '0' , '50' , '3.90' ) 
07/02/2023 09:24: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
                            ( '81255' , '5457' , 'IO SONO CON VOI 1 PARTE' , '158' ,  '0' , '4' ,
                               '2.50' , '2.5' , '0' , '50' , '197.50' ) 
07/02/2023 09:24: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
                            ( '81255' , '5458' , 'IO SONO CON VOI 2 PARTE' , '54' ,  '0' , '4' ,
                               '2.50' , '2.5' , '0' , '50' , '67.50' ) 
07/02/2023 09:24: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
                            ( '81255' , '11191' , 'VENITE CON ME 1 PARTE' , '49' ,  '0' , '4' ,
                               '2.50' , '2.5' , '0' , '50' , '61.25' ) 
07/02/2023 09:24: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
                            ( '81255' , '11192' , 'VENITE CON ME 2 PARTE' , '108' ,  '0' , '4' ,
                               '2.50' , '2.5' , '0' , '50' , '135.00' ) 
07/02/2023 09:24: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
                            ( '81255' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '39' ,  '0' , '4' ,
                               '3.50' , '3.5' , '0' , '50' , '68.25' ) 
07/02/2023 09:24: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
                            ( '81255' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '1' ,  '0' , '4' ,
                               '10.00' , '10' , '0' , '50' , '5.00' ) 
07/02/2023 09:24: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
                            ( '81255' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '1' ,  '0' , '4' ,
                               '3.40' , '3.4' , '0' , '50' , '1.70' ) 
07/02/2023 09:24: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
                            ( '81255' , '11308' , 'VIA CRUCIS ' , '5' ,  '0' , '4' ,
                               '1.50' , '1.5' , '0' , '50' , '3.75' ) 
07/02/2023 09:24:45 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
                            ( '81255' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '5' ,  '0' , '4' ,
                               '8.00' , '8' , '0' , '50' , '20.00' ) 
07/02/2023 09:24:45 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
                            ( '81255' , '6629' , 'MIA PREGHIERA' , '32' ,  '0' , '4' ,
                               '0.90' , '0.9' , '0' , '50' , '14.40' ) 
07/02/2023 09:24:45 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
                            ( '81255' , '8408' , 'PRENDETE E MANGIATE' , '73' ,  '0' , '4' ,
                               '3.00' , '3' , '0' , '50' , '109.50' ) 
07/02/2023 09:24:45 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
                            ( '81255' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' ,  '0' , '4' ,
                               '5.00' , '5' , '0' , '50' , '2.50' ) 
07/02/2023 09:24:45 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
                            ( '81255' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '2' ,  '0' , '4' ,
                               '5.00' , '5' , '0' , '50' , '5.00' ) 
07/02/2023 09:24:45 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
                            ( '81255' , '4154' , 'FESTA DEL PERDONO' , '165' ,  '0' , '4' ,
                               '3.00' , '3' , '0' , '50' , '247.50' ) 
07/02/2023 09:24:45 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
                            ( '81255' , '7824' , 'PER ILLUMINARE IL CAMMINO' , '4' ,  '0' , '4' ,
                               '0.90' , '0.9' , '0' , '50' , '1.80' ) 
07/02/2023 09:24:45 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
                            ( '81255' , '2679' , 'CONOSCERE GESU' , '170' ,  '0' , '4' ,
                               '3.50' , '3.5' , '0' , '50' , '297.50' ) 
07/02/2023 09:24:45 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
                            ( '81255' , '11102' , 'VANGELO E ATTI DEGLI APOSTOLI - RIL.' , '1' ,  '0' , '4' ,
                               '8.50' , '8.5' , '0' , '50' , '4.25' ) 
07/02/2023 09:24:45 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
                            ( '81255' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '3' ,  '0' , '4' ,
                               '5.00' , '5' , '0' , '50' , '7.50' ) 
07/02/2023 09:24:45 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
                            ( '81255' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '650' ,  '0' , '4' ,
                               '1.60' , '1.6' , '0' , '50' , '520.00' ) 
07/02/2023 09:24:45 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
                            ( '81255' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '2' ,  '0' , '4' ,
                               '12.00' , '12' , '0' , '50' , '12.00' ) 
07/02/2023 09:24:45 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
                            ( '81255' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '210' ,  '0' , '4' ,
                               '1.60' , '1.6' , '0' , '50' , '168.00' ) 
07/02/2023 09:24:45 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
                            ( '81255' , '7543' , 'PARABOLE DI GESÙ' , '3' ,  '0' , '4' ,
                               '3.00' , '3' , '0' , '50' , '4.50' ) 
07/02/2023 09:24:45 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
                            ( '81255' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '5' ,  '0' , '4' ,
                               '3.50' , '3.5' , '0' , '50' , '8.75' ) 
07/02/2023 09:24:45 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
                            ( '81255' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '20' ,  '0' , '4' ,
                               '3.50' , '3.5' , '0' , '50' , '35.00' ) 
07/02/2023 09:24:45 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
                            ( '81255' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '19' ,  '0' , '4' ,
                               '1.60' , '1.6' , '0' , '50' , '15.20' ) 
07/02/2023 09:24:45 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
                            ( '81255' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' ,  '0' , '4' ,
                               '10.00' , '10' , '0' , '50' , '5.00' ) 
07/02/2023 09:24:45 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
                            ( '81255' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' ,  '0' , '4' ,
                               '10.00' , '10' , '0' , '50' , '5.00' ) 
07/02/2023 09:24:45 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
                            ( '81255' , '12819' , 'REGISTRO DEL CATECHISTA ' , '1' ,  '0' , '1' ,
                               '1.00' , '0.81967213114754' , '22' , '50' , '0.50' ) 
07/02/2023 09:24:45 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
                            ( '81255' , '12253' , 'MIO LIBRO DI PREGHIERE' , '11' ,  '0' , '4' ,
                               '2.80' , '2.8' , '0' , '50' , '15.40' ) 
07/02/2023 09:24:45 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
                            ( '81255' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' ,  '0' , '4' ,
                               '3.50' , '3.5' , '0' , '50' , '1.75' ) 
07/02/2023 09:24:45 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
                            ( '81255' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '1' ,  '0' , '4' ,
                               '3.50' , '3.5' , '0' , '50' , '1.75' ) 
07/02/2023 09:24:45 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
                            ( '81255' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '8' ,  '0' , '4' ,
                               '6.00' , '6' , '0' , '50' , '24.00' ) 
07/02/2023 09:24:45 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
                            ( '81255' , '15115' , 'CONVERSIONE - G. CELENTANO' , '2' ,  '0' , '4' ,
                               '15.00' , '15' , '0' , '50' , '15.00' ) 
07/02/2023 09:24:45 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
                            ( '81255' , '13397' , 'MIO GESU' , '30' ,  '0' , '4' ,
                               '3.50' , '3.5' , '0' , '50' , '52.50' ) 
07/02/2023 09:24:45 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
                            ( '81255' , '13956' , 'MIRACOLI DI GESU' , '2' ,  '0' , '4' ,
                               '3.00' , '3' , '0' , '50' , '3.00' ) 
07/02/2023 09:24:45 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
                            ( '81255' , '14032' , 'AVE MARIA' , '3' ,  '0' , '4' ,
                               '3.00' , '3' , '0' , '50' , '4.50' ) 
07/02/2023 09:24:45 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
                            ( '81255' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '70' ,  '0' , '4' ,
                               '1.00' , '1' , '0' , '50' , '35.00' ) 
07/02/2023 09:24:45 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
                            ( '81255' , '15019' , 'PREGHIAMO CON MARIA' , '10' ,  '0' , '4' ,
                               '0.80' , '0.8' , '0' , '50' , '4.00' ) 
07/02/2023 09:24:45 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
                            ( '81255' , '15020' , 'PREGARE OGNI GIORNO' , '11' ,  '0' , '4' ,
                               '1.00' , '1' , '0' , '50' , '5.50' ) 
07/02/2023 09:24:45 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
                            ( '81255' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '5' ,  '0' , '4' ,
                               '3.50' , '3.5' , '0' , '50' , '8.75' ) 
07/02/2023 09:24:45 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
                            ( '81255' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '98' ,  '0' , '4' ,
                               '1.00' , '1' , '0' , '50' , '49.00' ) 
07/02/2023 09:24:45 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
                            ( '81255' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '30' ,  '0' , '4' ,
                               '2.00' , '2' , '0' , '50' , '30.00' ) 
07/02/2023 09:24:45 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
                            ( '81255' , '16667' , 'VIA CRUCIS' , '37' ,  '0' , '4' ,
                               '3.00' , '3' , '0' , '50' , '55.50' ) 
07/02/2023 09:24:45 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
                            ( '81255' , '16997' , 'PREGHIAMO IL PADRONE DELLA MESSE ' , '5' ,  '0' , '4' ,
                               '2.50' , '2.5' , '0' , '50' , '6.25' ) 
07/02/2023 09:24: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
                            ( '81255' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '3' ,  '0' , '4' ,
                               '15.00' , '15' , '0' , '50' , '22.50' ) 
07/02/2023 09:24: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
                            ( '81255' , '17257' , 'IO TI BATTEZZO ' , '2' ,  '0' , '4' ,
                               '1.80' , '1.8' , '0' , '50' , '1.80' ) 
07/02/2023 09:24: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
                            ( '81255' , '17582' , 'SAN CESARE DE BUS' , '2' ,  '0' , '4' ,
                               '5.00' , '5' , '0' , '50' , '5.00' ) 
07/02/2023 09:24: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
                            ( '81255' , '17695' , 'VIA LUCIS CON SAN CESARE DE BUS' , '5' ,  '0' , '4' ,
                               '3.80' , '3.8' , '0' , '50' , '9.50' ) 
07/02/2023 09:24: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
                            ( '81255' , '17697' , 'SANTO ROSARIO CON SAN CESARE DE BUS' , '1' ,  '0' , '4' ,
                               '2.50' , '2.5' , '0' , '50' , '1.25' ) 
07/02/2023 09:24: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
                            ( '81255' , '18036' , 'FERITE FERITOIE ' , '2' ,  '0' , '4' ,
                               '8.00' , '8' , '0' , '50' , '8.00' ) 
07/02/2023 09:24: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
                            ( '81255' , '18175' , 'VIA DI SAN GIUSEPPE - G. POLIDORO' , '5' ,  '0' , '4' ,
                               '4.80' , '4.8' , '0' , '50' , '12.00' ) 
07/02/2023 09:24: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
                            ( '81255' , '18460' , 'CON CUORE DI PADRE - V. SALVOLDI' , '3' ,  '0' , '4' ,
                               '2.00' , '2' , '0' , '50' , '3.00' ) 
07/02/2023 09:24: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
                            ( '81255' , '17696' , 'VIA CRUCIS CON SAN CESARE DE BUS' , '1' ,  '0' , '4' ,
                               '2.50' , '2.5' , '0' , '50' , '1.25' ) 
07/02/2023 09:24: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
                            ( '81255' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '152' ,  '0' , '4' ,
                               '1.90' , '1.9' , '0' , '50' , '144.40' ) 
07/02/2023 09:24: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
                            ( '81255' , '17861' , 'CARTA DIDENTITA DELLA CHIESA - R. LUPI' , '21' ,  '0' , '4' ,
                               '2.50' , '2.5' , '0' , '50' , '26.25' ) 
07/02/2023 09:24: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
                            ( '81255' , '18528' , 'CON GESU VERSO IL CALVARIO - P. G. VALSECCHI' , '43' ,  '0' , '4' ,
                               '1.50' , '1.5' , '0' , '50' , '32.25' ) 
07/02/2023 09:24: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
                            ( '81255' , '18527' , 'SOGNI DI PACE - V. SAVOLDI' , '1' ,  '0' , '4' ,
                               '2.00' , '2' , '0' , '50' , '1.00' ) 
07/02/2023 09:24: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
                            ( '81255' , '18718' , 'TUA VOCE IN ME + CD - FRA F. MARIA REA' , '1' ,  '0' , '4' ,
                               '15.00' , '15' , '0' , '50' , '7.50' ) 
07/02/2023 09:24: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
                            ( '81255' , '18657' , 'HO DATO LORO LA TUA PAROLA - P. VALSECCHI' , '2' ,  '0' , '4' ,
                               '16.00' , '16' , '0' , '50' , '16.00' ) 
07/02/2023 09:24: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
                            ( '81255' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '21' ,  '0' , '4' ,
                               '7.00' , '7' , '0' , '50' , '73.50' ) 
07/02/2023 09:24: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
                            ( '81255' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '3' ,  '0' , '4' ,
                               '2.00' , '2' , '0' , '50' , '3.00' ) 
07/02/2023 09:24: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
                            ( '81255' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '1' ,  '0' , '4' ,
                               '9.00' , '9' , '0' , '50' , '4.50' ) 
07/02/2023 09:24: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
                            ( '81255' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '2' ,  '0' , '4' ,
                               '9.00' , '9' , '0' , '50' , '9.00' ) 
07/02/2023 09:24: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
                            ( '81255' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '1' ,  '0' , '4' ,
                               '9.00' , '9' , '0' , '50' , '4.50' ) 
07/02/2023 09:24: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
                            ( '81255' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '11' ,  '0' , '4' ,
                               '12.00' , '12' , '0' , '50' , '66.00' ) 
07/02/2023 09:24: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
                            ( '81255' , '19562' , 'SAN CESARE DE BUS. UNA VITA PER LA CATECHESI ' , '3' ,  '0' , '4' ,
                               '20.00' , '20' , '0' , '50' , '30.00' ) 
07/02/2023 09:24: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
                            ( '81255' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '10' ,  '0' , '4' ,
                               '2.50' , '2.5' , '0' , '50' , '12.50' ) 
07/02/2023 09:24: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
                            ( '81255' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '9' ,  '0' , '4' ,
                               '4.50' , '4.5' , '0' , '50' , '20.25' ) 
07/02/2023 09:24: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
                            ( '81255' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '5' ,  '0' , '4' ,
                               '35.00' , '35' , '0' , '50' , '87.50' ) 
07/02/2023 09:24: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
                            ( '81255' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE' , '10' ,  '0' , '4' ,
                               '2.50' , '2.5' , '0' , '50' , '12.50' ) 
07/02/2023 09:24: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
                            ( '81255' , '20231' , 'PREGANDO NON SPRECATE PAROLE - G. DAMORE' , '1' ,  '0' , '4' ,
                               '10.00' , '10' , '0' , '50' , '5.00' ) 
07/02/2023 09:24: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
                            ( '81255' , '20640' , 'GESU, MOSSO A COMPASSIONE V. SALVOLDI' , '82' ,  '0' , '4' ,
                               '2.50' , '2.5' , '0' , '50' , '102.50' ) 
07/02/2023 09:28:03 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '3/E' AND id_document != '81255' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-07') 
07/02/2023 09:28:03 am >> UPDATE ps_document SET
                          id_document_type = '22',
                          document_num = '3/E',
                          document_date = '2023-02-07',
                          document_letter = 'E',
                          id_customer = '3000',
                          id_supplier = '',
                          id_address = '4669629',
                          address1 = 'VIA DEI CASTANI, 116 00172 ROMA',
                          address2 = '',
                          note = 'VENDUTO GENNAIO 2023',
                          price_shipping = '0.00',
                          id_tax_shipping_rules = '4',
                          colli = '0',
                          peso = '0',
                          porto_e_imballo = '0',
                          mezzo_consegna = '',
                          id_payment = '14',
                          id_causal = '0',
                          price_tax_included = '3363.94',
                          price_tax_excluded = '3363.85',
                          date_upd = NOW()
                        WHERE id_document = '81255' 
07/02/2023 09:28: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 = '81255' 
07/02/2023 09:28:04 am >>  DELETE FROM ps_document_detail WHERE id_document = '81255' 
07/02/2023 09:28:04 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81255' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '152' ,  '0' , '4' ,
                               '2.4000' , '2.4' , '0' , '50' , '182.40' ) 
07/02/2023 09:28:04 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81255' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '18' ,  '0' , '4' ,
                               '2.5000' , '2.5' , '0' , '50' , '22.50' ) 
07/02/2023 09:28:04 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81255' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '7' ,  '0' , '4' ,
                               '6.2000' , '6.2' , '0' , '50' , '21.70' ) 
07/02/2023 09:28:04 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81255' , '106' , 'A MESSA SALTANDO DI GIOIA - GUIDA' , '3' ,  '0' , '4' ,
                               '5.1600' , '5.16' , '0' , '50' , '7.74' ) 
07/02/2023 09:28:04 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81255' , '9675' , 'SARETE MIEI TESTIMONI' , '45' ,  '0' , '4' ,
                               '3' , '3' , '0' , '50' , '67.50' ) 
07/02/2023 09:28:04 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81255' , '8254' , 'PREGHIAMO CON MARIA' , '12' ,  '0' , '4' ,
                               '0.6500' , '0.65' , '0' , '50' , '3.90' ) 
07/02/2023 09:28:04 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81255' , '5457' , 'IO SONO CON VOI 1 PARTE' , '158' ,  '0' , '4' ,
                               '2.5000' , '2.5' , '0' , '50' , '197.50' ) 
07/02/2023 09:28:04 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81255' , '5458' , 'IO SONO CON VOI 2 PARTE' , '54' ,  '0' , '4' ,
                               '2.5000' , '2.5' , '0' , '50' , '67.50' ) 
07/02/2023 09:28:04 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81255' , '11191' , 'VENITE CON ME 1 PARTE' , '49' ,  '0' , '4' ,
                               '2.5000' , '2.5' , '0' , '50' , '61.25' ) 
07/02/2023 09:28:04 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81255' , '11192' , 'VENITE CON ME 2 PARTE' , '108' ,  '0' , '4' ,
                               '2.5000' , '2.5' , '0' , '50' , '135.00' ) 
07/02/2023 09:28:04 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81255' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '39' ,  '0' , '4' ,
                               '3.5000' , '3.5' , '0' , '50' , '68.25' ) 
07/02/2023 09:28:04 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81255' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '1' ,  '0' , '4' ,
                               '10.0000' , '10' , '0' , '50' , '5.00' ) 
07/02/2023 09:28:04 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81255' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '1' ,  '0' , '4' ,
                               '3.4000' , '3.4' , '0' , '50' , '1.70' ) 
07/02/2023 09:28:04 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81255' , '11308' , 'VIA CRUCIS ' , '5' ,  '0' , '4' ,
                               '1.5000' , '1.5' , '0' , '50' , '3.75' ) 
07/02/2023 09:28:04 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81255' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '5' ,  '0' , '4' ,
                               '8.0000' , '8' , '0' , '50' , '20.00' ) 
07/02/2023 09:28:04 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81255' , '6629' , 'MIA PREGHIERA' , '32' ,  '0' , '4' ,
                               '0.9000' , '0.9' , '0' , '50' , '14.40' ) 
07/02/2023 09:28:04 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81255' , '8408' , 'PRENDETE E MANGIATE' , '73' ,  '0' , '4' ,
                               '3.0000' , '3' , '0' , '50' , '109.50' ) 
07/02/2023 09:28:04 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81255' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' ,  '0' , '4' ,
                               '5.0000' , '5' , '0' , '50' , '2.50' ) 
07/02/2023 09:28:04 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81255' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '2' ,  '0' , '4' ,
                               '5.0000' , '5' , '0' , '50' , '5.00' ) 
07/02/2023 09:28:04 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81255' , '4154' , 'FESTA DEL PERDONO' , '165' ,  '0' , '4' ,
                               '3.0000' , '3' , '0' , '50' , '247.50' ) 
07/02/2023 09:28:04 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81255' , '7824' , 'PER ILLUMINARE IL CAMMINO' , '4' ,  '0' , '4' ,
                               '0.9000' , '0.9' , '0' , '50' , '1.80' ) 
07/02/2023 09:28:04 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81255' , '2679' , 'CONOSCERE GESU' , '170' ,  '0' , '4' ,
                               '3.5000' , '3.5' , '0' , '50' , '297.50' ) 
07/02/2023 09:28:04 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81255' , '11102' , 'VANGELO E ATTI DEGLI APOSTOLI - RIL.' , '1' ,  '0' , '4' ,
                               '8.5000' , '8.5' , '0' , '50' , '4.25' ) 
07/02/2023 09:28:04 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81255' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '3' ,  '0' , '4' ,
                               '5.0000' , '5' , '0' , '50' , '7.50' ) 
07/02/2023 09:28:04 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81255' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '650' ,  '0' , '4' ,
                               '1.6000' , '1.6' , '0' , '50' , '520.00' ) 
07/02/2023 09:28:04 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81255' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '2' ,  '0' , '4' ,
                               '12.0000' , '12' , '0' , '50' , '12.00' ) 
07/02/2023 09:28:04 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81255' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '210' ,  '0' , '4' ,
                               '1.6000' , '1.6' , '0' , '50' , '168.00' ) 
07/02/2023 09:28:04 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81255' , '7543' , 'PARABOLE DI GESÙ' , '3' ,  '0' , '4' ,
                               '3.0000' , '3' , '0' , '50' , '4.50' ) 
07/02/2023 09:28:04 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81255' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '5' ,  '0' , '4' ,
                               '3.5000' , '3.5' , '0' , '50' , '8.75' ) 
07/02/2023 09:28:04 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81255' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '20' ,  '0' , '4' ,
                               '3.5000' , '3.5' , '0' , '50' , '35.00' ) 
07/02/2023 09:28:04 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81255' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '19' ,  '0' , '4' ,
                               '1.6000' , '1.6' , '0' , '50' , '15.20' ) 
07/02/2023 09:28:05 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
                            ( '81255' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' ,  '0' , '4' ,
                               '10.0000' , '10' , '0' , '50' , '5.00' ) 
07/02/2023 09:28:05 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
                            ( '81255' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' ,  '0' , '4' ,
                               '10.0000' , '10' , '0' , '50' , '5.00' ) 
07/02/2023 09:28:05 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
                            ( '81255' , '12819' , 'REGISTRO DEL CATECHISTA ' , '1' ,  '0' , '1' ,
                               '1.0000' , '0.81967213114754' , '22' , '50' , '0.50' ) 
07/02/2023 09:28:05 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
                            ( '81255' , '12253' , 'MIO LIBRO DI PREGHIERE' , '11' ,  '0' , '4' ,
                               '2.8000' , '2.8' , '0' , '50' , '15.40' ) 
07/02/2023 09:28:05 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
                            ( '81255' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' ,  '0' , '4' ,
                               '3.5000' , '3.5' , '0' , '50' , '1.75' ) 
07/02/2023 09:28:05 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
                            ( '81255' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '1' ,  '0' , '4' ,
                               '3.5000' , '3.5' , '0' , '50' , '1.75' ) 
07/02/2023 09:28:05 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
                            ( '81255' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '8' ,  '0' , '4' ,
                               '6.0000' , '6' , '0' , '50' , '24.00' ) 
07/02/2023 09:28:05 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
                            ( '81255' , '15115' , 'CONVERSIONE - G. CELENTANO' , '2' ,  '0' , '4' ,
                               '15.0000' , '15' , '0' , '50' , '15.00' ) 
07/02/2023 09:28:05 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
                            ( '81255' , '13397' , 'MIO GESU' , '30' ,  '0' , '4' ,
                               '3.5000' , '3.5' , '0' , '50' , '52.50' ) 
07/02/2023 09:28:05 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
                            ( '81255' , '13956' , 'MIRACOLI DI GESU' , '2' ,  '0' , '4' ,
                               '3.0000' , '3' , '0' , '50' , '3.00' ) 
07/02/2023 09:28:05 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
                            ( '81255' , '14032' , 'AVE MARIA' , '3' ,  '0' , '4' ,
                               '3.0000' , '3' , '0' , '50' , '4.50' ) 
07/02/2023 09:28:05 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
                            ( '81255' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '70' ,  '0' , '4' ,
                               '1.0000' , '1' , '0' , '50' , '35.00' ) 
07/02/2023 09:28:05 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
                            ( '81255' , '15019' , 'PREGHIAMO CON MARIA' , '10' ,  '0' , '4' ,
                               '0.8000' , '0.8' , '0' , '50' , '4.00' ) 
07/02/2023 09:28:05 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
                            ( '81255' , '15020' , 'PREGARE OGNI GIORNO' , '11' ,  '0' , '4' ,
                               '1.0000' , '1' , '0' , '50' , '5.50' ) 
07/02/2023 09:28:05 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
                            ( '81255' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '5' ,  '0' , '4' ,
                               '3.5000' , '3.5' , '0' , '50' , '8.75' ) 
07/02/2023 09:28:05 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
                            ( '81255' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '98' ,  '0' , '4' ,
                               '1.0000' , '1' , '0' , '50' , '49.00' ) 
07/02/2023 09:28:05 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
                            ( '81255' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '30' ,  '0' , '4' ,
                               '2.0000' , '2' , '0' , '50' , '30.00' ) 
07/02/2023 09:28:05 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
                            ( '81255' , '16667' , 'VIA CRUCIS' , '37' ,  '0' , '4' ,
                               '3.0000' , '3' , '0' , '50' , '55.50' ) 
07/02/2023 09:28:05 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
                            ( '81255' , '16997' , 'PREGHIAMO IL PADRONE DELLA MESSE ' , '5' ,  '0' , '4' ,
                               '2.5000' , '2.5' , '0' , '50' , '6.25' ) 
07/02/2023 09:28:05 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
                            ( '81255' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '3' ,  '0' , '4' ,
                               '15.0000' , '15' , '0' , '50' , '22.50' ) 
07/02/2023 09:28:05 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
                            ( '81255' , '17257' , 'IO TI BATTEZZO ' , '2' ,  '0' , '4' ,
                               '1.8000' , '1.8' , '0' , '50' , '1.80' ) 
07/02/2023 09:28:05 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
                            ( '81255' , '17582' , 'SAN CESARE DE BUS' , '2' ,  '0' , '4' ,
                               '5.0000' , '5' , '0' , '50' , '5.00' ) 
07/02/2023 09:28:05 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
                            ( '81255' , '17695' , 'VIA LUCIS CON SAN CESARE DE BUS' , '5' ,  '0' , '4' ,
                               '3.8000' , '3.8' , '0' , '50' , '9.50' ) 
07/02/2023 09:28:05 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
                            ( '81255' , '17697' , 'SANTO ROSARIO CON SAN CESARE DE BUS' , '1' ,  '0' , '4' ,
                               '2.5000' , '2.5' , '0' , '50' , '1.25' ) 
07/02/2023 09:28:05 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
                            ( '81255' , '18036' , 'FERITE FERITOIE ' , '2' ,  '0' , '4' ,
                               '8.0000' , '8' , '0' , '50' , '8.00' ) 
07/02/2023 09:28:05 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
                            ( '81255' , '18175' , 'VIA DI SAN GIUSEPPE - G. POLIDORO' , '5' ,  '0' , '4' ,
                               '4.8000' , '4.8' , '0' , '50' , '12.00' ) 
07/02/2023 09:28:05 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
                            ( '81255' , '18460' , 'CON CUORE DI PADRE - V. SALVOLDI' , '3' ,  '0' , '4' ,
                               '2.0000' , '2' , '0' , '50' , '3.00' ) 
07/02/2023 09:28:05 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
                            ( '81255' , '17696' , 'VIA CRUCIS CON SAN CESARE DE BUS' , '1' ,  '0' , '4' ,
                               '2.5000' , '2.5' , '0' , '50' , '1.25' ) 
07/02/2023 09:28:05 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
                            ( '81255' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '152' ,  '0' , '4' ,
                               '1.9000' , '1.9' , '0' , '50' , '144.40' ) 
07/02/2023 09:28:05 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
                            ( '81255' , '17861' , 'CARTA DIDENTITA DELLA CHIESA - R. LUPI' , '21' ,  '0' , '4' ,
                               '2.5000' , '2.5' , '0' , '50' , '26.25' ) 
07/02/2023 09:28:05 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
                            ( '81255' , '18528' , 'CON GESU VERSO IL CALVARIO - P. G. VALSECCHI' , '43' ,  '0' , '4' ,
                               '1.5000' , '1.5' , '0' , '50' , '32.25' ) 
07/02/2023 09:28:05 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
                            ( '81255' , '18527' , 'SOGNI DI PACE - V. SAVOLDI' , '1' ,  '0' , '4' ,
                               '2.0000' , '2' , '0' , '50' , '1.00' ) 
07/02/2023 09:28:05 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
                            ( '81255' , '18718' , 'TUA VOCE IN ME + CD - FRA F. MARIA REA' , '1' ,  '0' , '4' ,
                               '15.0000' , '15' , '0' , '50' , '7.50' ) 
07/02/2023 09:28:05 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
                            ( '81255' , '18657' , 'HO DATO LORO LA TUA PAROLA - P. VALSECCHI' , '2' ,  '0' , '4' ,
                               '16.0000' , '16' , '0' , '50' , '16.00' ) 
07/02/2023 09:28: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
                            ( '81255' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '21' ,  '0' , '4' ,
                               '7.0000' , '7' , '0' , '50' , '73.50' ) 
07/02/2023 09:28: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
                            ( '81255' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '3' ,  '0' , '4' ,
                               '2.0000' , '2' , '0' , '50' , '3.00' ) 
07/02/2023 09:28: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
                            ( '81255' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '1' ,  '0' , '4' ,
                               '9.0000' , '9' , '0' , '50' , '4.50' ) 
07/02/2023 09:28: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
                            ( '81255' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '2' ,  '0' , '4' ,
                               '9.0000' , '9' , '0' , '50' , '9.00' ) 
07/02/2023 09:28: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
                            ( '81255' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '1' ,  '0' , '4' ,
                               '9.0000' , '9' , '0' , '50' , '4.50' ) 
07/02/2023 09:28: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
                            ( '81255' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '11' ,  '0' , '4' ,
                               '12.0000' , '12' , '0' , '50' , '66.00' ) 
07/02/2023 09:28: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
                            ( '81255' , '19562' , 'SAN CESARE DE BUS. UNA VITA PER LA CATECHESI ' , '3' ,  '0' , '4' ,
                               '20.0000' , '20' , '0' , '50' , '30.00' ) 
07/02/2023 09:28: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
                            ( '81255' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '10' ,  '0' , '4' ,
                               '2.5000' , '2.5' , '0' , '50' , '12.50' ) 
07/02/2023 09:28: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
                            ( '81255' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '9' ,  '0' , '4' ,
                               '4.5000' , '4.5' , '0' , '50' , '20.25' ) 
07/02/2023 09:28: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
                            ( '81255' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '5' ,  '0' , '4' ,
                               '35.0000' , '35' , '0' , '50' , '87.50' ) 
07/02/2023 09:28: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
                            ( '81255' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE' , '10' ,  '0' , '4' ,
                               '2.5000' , '2.5' , '0' , '50' , '12.50' ) 
07/02/2023 09:28: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
                            ( '81255' , '20231' , 'PREGANDO NON SPRECATE PAROLE - G. DAMORE' , '1' ,  '0' , '4' ,
                               '10.0000' , '10' , '0' , '50' , '5.00' ) 
07/02/2023 09:28: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
                            ( '81255' , '20640' , 'GESU, MOSSO A COMPASSIONE V. SALVOLDI' , '82' ,  '0' , '4' ,
                               '2.5000' , '2.5' , '0' , '50' , '102.50' ) 
07/02/2023 09:40:35 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '4/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-07') 
07/02/2023 09:40:35 am >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '25' ,
                          '4/E' ,
                          '2023-02-07' ,
                          'E' ,
                          '3000' ,
                          '0' ,
                          '4669629' ,
                          'VIA DEI CASTANI, 116 00172 ROMA' ,
                          '' ,
                          'RESA GENNAIO 2023' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '525.02' ,
                          '524.93' ,
                          NOW() ,
                          NOW() ) 
07/02/2023 09:40:35 am >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81256' 
07/02/2023 09:40:35 am >>  DELETE FROM ps_document_detail WHERE id_document = '81256' 
07/02/2023 09:40:35 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '7' ,  '7' , '4' ,
                               '2.40' , '2.4' , '0' , '50' , '8.40' ) 
07/02/2023 09:40:35 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' ,  '1' , '4' ,
                               '6' , '6' , '0' , '50' , '3.00' ) 
07/02/2023 09:40:35 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '11183' , 'VENITE CON ME - GUIDA' , '1' ,  '1' , '4' ,
                               '6.00' , '6' , '0' , '50' , '3.00' ) 
07/02/2023 09:40:35 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '9675' , 'SARETE MIEI TESTIMONI' , '14' ,  '14' , '4' ,
                               '3' , '3' , '0' , '50' , '21.00' ) 
07/02/2023 09:40:35 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '5457' , 'IO SONO CON VOI 1 PARTE' , '14' ,  '14' , '4' ,
                               '2.50' , '2.5' , '0' , '50' , '17.50' ) 
07/02/2023 09:40:35 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '5458' , 'IO SONO CON VOI 2 PARTE' , '18' ,  '18' , '4' ,
                               '2.50' , '2.5' , '0' , '50' , '22.50' ) 
07/02/2023 09:40:35 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '11191' , 'VENITE CON ME 1 PARTE' , '31' ,  '31' , '4' ,
                               '2.50' , '2.5' , '0' , '50' , '38.75' ) 
07/02/2023 09:40:35 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '11192' , 'VENITE CON ME 2 PARTE' , '21' ,  '21' , '4' ,
                               '2.50' , '2.5' , '0' , '50' , '26.25' ) 
07/02/2023 09:40:35 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '11312' , 'VIA CRUCIS PER RAGAZZI ' , '2' ,  '2' , '4' ,
                               '0.85' , '0.85' , '0' , '50' , '0.85' ) 
07/02/2023 09:40:35 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '523' , 'AMORE VINCE LA MORTE - VIA CRUCIS' , '3' ,  '3' , '4' ,
                               '0.85' , '0.85' , '0' , '50' , '1.27' ) 
07/02/2023 09:40:35 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '1' ,  '1' , '4' ,
                               '8.00' , '8' , '0' , '50' , '4.00' ) 
07/02/2023 09:40:35 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '1' ,  '1' , '4' ,
                               '10.00' , '10' , '0' , '50' , '5.00' ) 
07/02/2023 09:40:35 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '2' ,  '2' , '4' ,
                               '5.00' , '5' , '0' , '50' , '5.00' ) 
07/02/2023 09:40:35 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '11308' , 'VIA CRUCIS ' , '1' ,  '1' , '4' ,
                               '1.50' , '1.5' , '0' , '50' , '0.75' ) 
07/02/2023 09:40:35 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '8408' , 'PRENDETE E MANGIATE' , '7' ,  '7' , '4' ,
                               '3.00' , '3' , '0' , '50' , '10.50' ) 
07/02/2023 09:40:35 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '4' ,  '4' , '4' ,
                               '5.00' , '5' , '0' , '50' , '10.00' ) 
07/02/2023 09:40:35 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '4154' , 'FESTA DEL PERDONO' , '8' ,  '8' , '4' ,
                               '3.00' , '3' , '0' , '50' , '12.00' ) 
07/02/2023 09:40:35 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '4' ,  '4' , '4' ,
                               '1.60' , '1.6' , '0' , '50' , '3.20' ) 
07/02/2023 09:40:35 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '5' ,  '5' , '4' ,
                               '1.60' , '1.6' , '0' , '50' , '4.00' ) 
07/02/2023 09:40:36 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '12819' , 'REGISTRO DEL CATECHISTA ' , '1' ,  '1' , '1' ,
                               '1.00' , '0.81967213114754' , '22' , '50' , '0.50' ) 
07/02/2023 09:40:36 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '2' ,  '2' , '4' ,
                               '3.50' , '3.5' , '0' , '50' , '3.50' ) 
07/02/2023 09:40:36 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '1' ,  '1' , '4' ,
                               '3.50' , '3.5' , '0' , '50' , '1.75' ) 
07/02/2023 09:40:36 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '15115' , 'CONVERSIONE - G. CELENTANO' , '1' ,  '1' , '4' ,
                               '15.00' , '15' , '0' , '50' , '7.50' ) 
07/02/2023 09:40:36 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '13137' , 'CON LA BIBBIA E IL CATECHISMO - S. LA PEGNA' , '1' ,  '1' , '4' ,
                               '10.00' , '10' , '0' , '50' , '5.00' ) 
07/02/2023 09:40:36 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '16041' , 'PRIMI PASSI NEL CAMMINO DI FEDE - M. VIANI' , '2' ,  '2' , '4' ,
                               '6.00' , '6' , '0' , '50' , '6.00' ) 
07/02/2023 09:40:36 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '17827' , 'ISTRUZIONI FAMILIARI VOL. I - IL CREDO ' , '1' ,  '1' , '4' ,
                               '20.00' , '20' , '0' , '50' , '10.00' ) 
07/02/2023 09:40:36 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '18176' , 'ANTIQUUM MINISTERIUM - PAPA FRANCESCO' , '54' ,  '54' , '4' ,
                               '1.00' , '1' , '0' , '50' , '27.00' ) 
07/02/2023 09:40:36 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '18460' , 'CON CUORE DI PADRE - V. SALVOLDI' , '12' ,  '12' , '4' ,
                               '2.00' , '2' , '0' , '50' , '12.00' ) 
07/02/2023 09:40:36 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '1' ,  '1' , '4' ,
                               '15.00' , '15' , '0' , '50' , '7.50' ) 
07/02/2023 09:40:36 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '44' ,  '44' , '4' ,
                               '1.90' , '1.9' , '0' , '50' , '41.80' ) 
07/02/2023 09:40:36 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '17861' , 'CARTA DIDENTITA DELLA CHIESA - R. LUPI' , '6' ,  '6' , '4' ,
                               '2.50' , '2.5' , '0' , '50' , '7.50' ) 
07/02/2023 09:40:36 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '18497' , 'BUONA DOMENICA - ANNO A - G. BAGET BOZZO' , '1' ,  '1' , '4' ,
                               '16.00' , '16' , '0' , '50' , '8.00' ) 
07/02/2023 09:40:36 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '18498' , 'BUONA DOMENICA - ANNO B - G. BAGET BOZZO' , '1' ,  '1' , '4' ,
                               '16.00' , '16' , '0' , '50' , '8.00' ) 
07/02/2023 09:40:36 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '18499' , 'BUONA DOMENICA - ANNO C - G. BAGET BOZZO' , '1' ,  '1' , '4' ,
                               '16.00' , '16' , '0' , '50' , '8.00' ) 
07/02/2023 09:40:36 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '18527' , 'SOGNI DI PACE - V. SAVOLDI' , '8' ,  '8' , '4' ,
                               '2.00' , '2' , '0' , '50' , '8.00' ) 
07/02/2023 09:40:36 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '18717' , 'ISTRUZIONI FAMILIARI VOL. II - I DIECI COMANDAMENTI ' , '1' ,  '1' , '4' ,
                               '20.00' , '20' , '0' , '50' , '10.00' ) 
07/02/2023 09:40:36 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '18657' , 'HO DATO LORO LA TUA PAROLA - P. VALSECCHI' , '2' ,  '2' , '4' ,
                               '16.00' , '16' , '0' , '50' , '16.00' ) 
07/02/2023 09:40:36 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '18950' , 'DOVE FINITO IL CONCILIO? - F. CERRI' , '3' ,  '3' , '4' ,
                               '18.00' , '18' , '0' , '50' , '27.00' ) 
07/02/2023 09:40:36 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '19160' , 'PERCHE IL DESERTO TORNI A FIORIRE - A. SALVOLDI' , '4' ,  '4' , '4' ,
                               '2.00' , '2' , '0' , '50' , '4.00' ) 
07/02/2023 09:40:36 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '19391' , 'ISTRUZIONI FAMILIARI VOL. III - I PRECETTI...' , '1' ,  '1' , '4' ,
                               '20.00' , '20' , '0' , '50' , '10.00' ) 
07/02/2023 09:40:36 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '19562' , 'SAN CESARE DE BUS. UNA VITA PER LA CATECHESI ' , '1' ,  '1' , '4' ,
                               '20.00' , '20' , '0' , '50' , '10.00' ) 
07/02/2023 09:40:36 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '30' ,  '30' , '4' ,
                               '2.50' , '2.5' , '0' , '50' , '37.50' ) 
07/02/2023 09:40:36 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '4' ,  '4' , '4' ,
                               '4.50' , '4.5' , '0' , '50' , '9.00' ) 
07/02/2023 09:40:36 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '1' ,  '1' , '4' ,
                               '35.00' , '35' , '0' , '50' , '17.50' ) 
07/02/2023 09:40:36 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81256' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE' , '20' ,  '20' , '4' ,
                               '2.50' , '2.5' , '0' , '50' , '25.00' ) 
07/02/2023 09:50:23 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '1/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-07') 
07/02/2023 09:50:23 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  (
                          '22' ,
                          '1/S' ,
                          '2023-02-07' ,
                          'S' ,
                          '3000' ,
                          '0' ,
                          '4669629' ,
                          'VIA DEI CASTANI, 116 00172 ROMA' ,
                          '' ,
                          'VENDUTO GENNAIO 2023' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '14' ,
                          '0' ,
                          '1496.70' ,
                          '1496.70' ,
                          NOW() ,
                          NOW() ) 
07/02/2023 09:50:23 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 = '9512' 
07/02/2023 09:50:23 am >>  DELETE FROM ps_document_detail WHERE id_document = '9512' 
07/02/2023 09:50:23 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
                            ( '9512' , '6' , 'I miracoli da colorare. Il figlio della vedova' , '1' ,  '0' , '4' ,
                               '2.00' , '2' , '0' , '50' , '1.00' ) 
07/02/2023 09:50:23 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
                            ( '9512' , '7' , 'I miracoli da colorare. La pesca miracolosa' , '1' ,  '0' , '4' ,
                               '1.50' , '1.5' , '0' , '50' , '0.75' ) 
07/02/2023 09:50:23 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
                            ( '9512' , '10' , 'I miracoli da colorare. Gesù cammina sulle acque' , '1' ,  '0' , '4' ,
                               '2.00' , '2' , '0' , '50' , '1.00' ) 
07/02/2023 09:50:23 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
                            ( '9512' , '17' , 'LA FEDE NELLO ZAINETTO' , '10' ,  '0' , '4' ,
                               '5.00' , '5' , '0' , '50' , '25.00' ) 
07/02/2023 09:50:23 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
                            ( '9512' , '20' , 'GIOVEDÌ SANTO' , '6' ,  '0' , '4' ,
                               '1.50' , '1.5' , '0' , '50' , '4.50' ) 
07/02/2023 09:50:23 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
                            ( '9512' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '37' ,  '0' , '4' ,
                               '1.50' , '1.5' , '0' , '50' , '27.75' ) 
07/02/2023 09:50:23 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
                            ( '9512' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '192' ,  '0' , '4' ,
                               '2.50' , '2.5' , '0' , '50' , '240.00' ) 
07/02/2023 09:50:23 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
                            ( '9512' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '34' ,  '0' , '4' ,
                               '2.50' , '2.5' , '0' , '50' , '42.50' ) 
07/02/2023 09:50:23 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
                            ( '9512' , '25' , 'PICCOLO DIZIONARIO DEL CRISTIANO' , '2' ,  '0' , '4' ,
                               '3.00' , '3' , '0' , '50' , '3.00' ) 
07/02/2023 09:50:23 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
                            ( '9512' , '121' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '2' ,  '0' , '4' ,
                               '2.50' , '2.5' , '0' , '50' , '2.50' ) 
07/02/2023 09:50:23 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
                            ( '9512' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '22' ,  '0' , '4' ,
                               '2.50' , '2.5' , '0' , '50' , '27.50' ) 
07/02/2023 09:50:23 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
                            ( '9512' , '125' , 'MIE PREGHIERINE - N. E.' , '57' ,  '0' , '4' ,
                               '1.50' , '1.5' , '0' , '50' , '42.75' ) 
07/02/2023 09:50:23 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
                            ( '9512' , '33' , '100 GIORNI CON LO SPIRITO' , '71' ,  '0' , '4' ,
                               '7.50' , '7.5' , '0' , '50' , '266.25' ) 
07/02/2023 09:50:23 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
                            ( '9512' , '34' , 'LE MIE PREGHIERINE' , '1' ,  '0' , '4' ,
                               '1.50' , '1.5' , '0' , '50' , '0.75' ) 
07/02/2023 09:50:23 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
                            ( '9512' , '35' , 'ANGELI - I NOSTRI MIGLIORI AMICI' , '3' ,  '0' , '4' ,
                               '2.50' , '2.5' , '0' , '50' , '3.75' ) 
07/02/2023 09:50:23 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
                            ( '9512' , '54' , 'BENEDETTO XVI ° ..... UNA PAGINA DI STORIA' , '1' ,  '0' , '4' ,
                               '2.50' , '2.5' , '0' , '50' , '1.25' ) 
07/02/2023 09:50:23 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
                            ( '9512' , '55' , 'AVE MARIA ,SPIEGATA AI BAMBINI' , '1' ,  '0' , '4' ,
                               '1.50' , '1.5' , '0' , '50' , '0.75' ) 
07/02/2023 09:50:23 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
                            ( '9512' , '57' , 'ALBUM + BUSTINA  AMICO GESÙ' , '5' ,  '0' , '4' ,
                               '2.00' , '2' , '0' , '50' , '5.00' ) 
07/02/2023 09:50:23 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
                            ( '9512' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '18' ,  '0' , '4' ,
                               '30.00' , '30' , '0' , '50' , '270.00' ) 
07/02/2023 09:50:23 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
                            ( '9512' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '15' ,  '0' , '4' ,
                               '2.00' , '2' , '0' , '50' , '15.00' ) 
07/02/2023 09:50:23 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
                            ( '9512' , '77' , 'LA SACRA SINDONE SPIEGATA  AI RAGAZZI' , '2' ,  '0' , '4' ,
                               '1.00' , '1' , '0' , '50' , '1.00' ) 
07/02/2023 09:50:23 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
                            ( '9512' , '92' , 'LA PREGHIERA DEL ROSARIO' , '10' ,  '0' , '4' ,
                               '2.50' , '2.5' , '0' , '50' , '12.50' ) 
07/02/2023 09:50:24 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
                            ( '9512' , '96' , 'LA PREGHIERA  - MEDICINA DELLANIMA' , '2' ,  '0' , '4' ,
                               '1.50' , '1.5' , '0' , '50' , '1.50' ) 
07/02/2023 09:50:24 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
                            ( '9512' , '99' , 'AVE MARIA PREGHIERE MARIANE' , '10' ,  '0' , '4' ,
                               '2.00' , '2' , '0' , '50' , '10.00' ) 
07/02/2023 09:50:24 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
                            ( '9512' , '102' , 'LE BEATITUDINI  N.EDIZ.' , '10' ,  '0' , '4' ,
                               '2.00' , '2' , '0' , '50' , '10.00' ) 
07/02/2023 09:50:24 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
                            ( '9512' , '104' , 'TEMPO DI QUARESIMA' , '22' ,  '0' , '4' ,
                               '2.50' , '2.5' , '0' , '50' , '27.50' ) 
07/02/2023 09:50:24 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
                            ( '9512' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '42' ,  '0' , '4' ,
                               '2.50' , '2.5' , '0' , '50' , '52.50' ) 
07/02/2023 09:50:24 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
                            ( '9512' , '110' , 'SE MI AMI NON PIANGERE' , '51' ,  '0' , '4' ,
                               '1.5' , '1.5' , '0' , '50' , '38.25' ) 
07/02/2023 09:50:24 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
                            ( '9512' , '111' , 'I NONNI SONO UN TESORO' , '15' ,  '0' , '4' ,
                               '1.80' , '1.8' , '0' , '50' , '13.50' ) 
07/02/2023 09:50:24 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
                            ( '9512' , '112' , 'SEMPRE CON TE -VANGELO TASCABILE' , '4' ,  '0' , '4' ,
                               '2.50' , '2.5' , '0' , '50' , '5.00' ) 
07/02/2023 09:50:24 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
                            ( '9512' , '123' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '1' ,  '0' , '4' ,
                               '3.00' , '3' , '0' , '50' , '1.50' ) 
07/02/2023 09:50:24 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
                            ( '9512' , '115' , 'SAN FRANCESCO DASSISI RACCONTATO AI RAGAZZI N.E.' , '24' ,  '0' , '4' ,
                               '4.00' , '4' , '0' , '50' , '48.00' ) 
07/02/2023 09:50:24 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
                            ( '9512' , '117' , 'La preghiera delle cinque dita n.e.' , '3' ,  '0' , '4' ,
                               '1.80' , '1.8' , '0' , '50' , '2.70' ) 
07/02/2023 09:50:24 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
                            ( '9512' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '32' ,  '0' , '4' ,
                               '2.50' , '2.5' , '0' , '50' , '40.00' ) 
07/02/2023 09:50:24 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
                            ( '9512' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '73' ,  '0' , '4' ,
                               '2.50' , '2.5' , '0' , '50' , '91.25' ) 
07/02/2023 09:50:24 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
                            ( '9512' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '5' ,  '0' , '4' ,
                               '3.00' , '3' , '0' , '50' , '7.50' ) 
07/02/2023 09:50:24 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
                            ( '9512' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '16' ,  '0' , '4' ,
                               '18.00' , '18' , '0' , '50' , '144.00' ) 
07/02/2023 09:50:24 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
                            ( '9512' , '126' , 'SACRAMENTO DEL PERDONO' , '9' ,  '0' , '4' ,
                               '2.00' , '2' , '0' , '50' , '9.00' ) 
07/02/2023 09:54:11 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '2/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-07') 
07/02/2023 09:54:11 am >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '25' ,
                          '2/S' ,
                          '2023-02-07' ,
                          'S' ,
                          '3000' ,
                          '0' ,
                          '4669629' ,
                          'VIA DEI CASTANI, 116 00172 ROMA' ,
                          '' ,
                          'RESA GENNAIO 2023' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '101.00' ,
                          '101.00' ,
                          NOW() ,
                          NOW() ) 
07/02/2023 09:54:11 am >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '9513' 
07/02/2023 09:54:11 am >>  DELETE FROM ps_document_detail WHERE id_document = '9513' 
07/02/2023 09:54:11 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '9513' , '20' , 'GIOVEDÌ SANTO' , '1' ,  '1' , '4' ,
                               '1.50' , '1.5' , '0' , '50' , '0.75' ) 
07/02/2023 09:54:11 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '9513' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '3' ,  '3' , '4' ,
                               '1.50' , '1.5' , '0' , '50' , '2.25' ) 
07/02/2023 09:54:11 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '9513' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '1' ,  '1' , '4' ,
                               '2.50' , '2.5' , '0' , '50' , '1.25' ) 
07/02/2023 09:54:11 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '9513' , '63' , 'STORIA D.SALVEZZA  1°ADAMO ED EVA' , '1' ,  '1' , '4' ,
                               '2.00' , '2' , '0' , '50' , '1.00' ) 
07/02/2023 09:54:11 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '9513' , '70' , 'La storia della salvezza raccontata ai bambini. 2 Caino e Abele' , '1' ,  '1' , '4' ,
                               '2.00' , '2' , '0' , '50' , '1.00' ) 
07/02/2023 09:54:11 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '9513' , '75' , 'IL SEGNO DELLA CROCE' , '2' ,  '2' , '4' ,
                               '1.50' , '1.5' , '0' , '50' , '1.50' ) 
07/02/2023 09:54:11 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '9513' , '84' , 'LAVVENTO' , '2' ,  '2' , '4' ,
                               '2.00' , '2' , '0' , '50' , '2.00' ) 
07/02/2023 09:54:11 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '9513' , '91' , 'I 10 COMANDAMENTI' , '1' ,  '1' , '4' ,
                               '2.00' , '2' , '0' , '50' , '1.00' ) 
07/02/2023 09:54:11 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '9513' , '97' , '\"IL NATALE  \"\"CHE MERAVIGLIA\"\"\"' , '1' ,  '1' , '4' ,
                               '1.50' , '1.5' , '0' , '50' , '0.75' ) 
07/02/2023 09:54:11 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '9513' , '102' , 'LE BEATITUDINI  N.EDIZ.' , '25' ,  '25' , '4' ,
                               '2.00' , '2' , '0' , '50' , '25.00' ) 
07/02/2023 09:54:11 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '9513' , '103' , 'Lo Spirito Santo raccontato ai ragazzi N.E.' , '6' ,  '6' , '4' ,
                               '2.00' , '2' , '0' , '50' , '6.00' ) 
07/02/2023 09:54:11 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '9513' , '111' , 'I NONNI SONO UN TESORO' , '5' ,  '5' , '4' ,
                               '1.80' , '1.8' , '0' , '50' , '4.50' ) 
07/02/2023 09:54:11 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '9513' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '12' ,  '12' , '4' ,
                               '3.00' , '3' , '0' , '50' , '18.00' ) 
07/02/2023 09:54:11 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '9513' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '4' ,  '4' , '4' ,
                               '18.00' , '18' , '0' , '50' , '36.00' ) 
07/02/2023 10:27:47 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '434' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-07') 
07/02/2023 10:27:47 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' ,
                          '434' ,
                          '2023-02-07' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '68.00' ,
                          '55.74' ,
                          NOW() ,
                          NOW() ) 
07/02/2023 10:27: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 = '81257' 
07/02/2023 10:27:47 am >>  DELETE FROM ps_document_detail WHERE id_document = '81257' 
07/02/2023 10:27: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
                            ( '81257' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '17' ,  '-17' , '1' ,
                               '3.00' , '2.4590163934426' , '22' , '0' , '51.00' ) 
07/02/2023 10:27: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
                            ( '81257' , '16308' , 'PORTACHIAVI TAU' , '17' ,  '-17' , '1' ,
                               '1.00' , '0.81967213114754' , '22' , '0' , '17.00' ) 
07/02/2023 10:42:54 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '435' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-07') 
07/02/2023 10:42:54 am >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '435' ,
                          '2023-02-07' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '6.05' ,
                          '5.82' ,
                          NOW() ,
                          NOW() ) 
07/02/2023 10:42:54 am >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81258' 
07/02/2023 10:42:54 am >>  DELETE FROM ps_document_detail WHERE id_document = '81258' 
07/02/2023 10:42:54 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81258' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '1' ,  '-1' , '4' ,
                               '5.00' , '5' , '0' , '5' , '4.75' ) 
07/02/2023 10:42:54 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81258' , '19598' , 'MEDAGLIA SPILLA SPIRITO SANTO - G24OX' , '1' ,  '-1' , '1' ,
                               '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 
07/02/2023 11:46:20 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '436' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-07') 
07/02/2023 11:46:20 am >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '436' ,
                          '2023-02-07' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '42.75' ,
                          '42.75' ,
                          NOW() ,
                          NOW() ) 
07/02/2023 11:46:20 am >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81259' 
07/02/2023 11:46:20 am >>  DELETE FROM ps_document_detail WHERE id_document = '81259' 
07/02/2023 11:46:21 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81259' , '20653' , 'INTRODUZIONE AL CRISTIANESIMO - J. RATZINGER' , '1' ,  '-1' , '4' ,
                               '20.00' , '20' , '0' , '5' , '19.00' ) 
07/02/2023 11:46:21 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81259' , '18373' , 'COMMENTI AI VANGELI - BENEDETTO XVI' , '1' ,  '-1' , '4' ,
                               '25.00' , '25' , '0' , '5' , '23.75' ) 
07/02/2023 11:48:26 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '437' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-07') 
07/02/2023 11:48:26 am >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '437' ,
                          '2023-02-07' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '27.00' ,
                          '22.13' ,
                          NOW() ,
                          NOW() ) 
07/02/2023 11:48:26 am >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81260' 
07/02/2023 11:48:26 am >>  DELETE FROM ps_document_detail WHERE id_document = '81260' 
07/02/2023 11:48:26 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81260' , '8938' , 'RICAMBIO VETRO PER ART. 1045/1046/675 - 90 - OGGETTI' , '3' ,  '-3' , '1' ,
                               '9' , '7.3770491803279' , '22' , '0' , '27.00' ) 
07/02/2023 11:53:02 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '438' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-07') 
07/02/2023 11:53:02 am >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '438' ,
                          '2023-02-07' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '59.55' ,
                          '53.78' ,
                          NOW() ,
                          NOW() ) 
07/02/2023 11:53:02 am >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81261' 
07/02/2023 11:53:02 am >>  DELETE FROM ps_document_detail WHERE id_document = '81261' 
07/02/2023 11:53:02 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81261' , '16758' , 'CUSTODIA BIBBIA TOB - L104' , '1' ,  '-1' , '1' ,
                               '32.00' , '26.229508196721' , '22' , '0' , '32.00' ) 
07/02/2023 11:53:02 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81261' , '17415' , 'BIBBIA - SCRUTATE LE SCRITTURE' , '1' ,  '-1' , '4' ,
                               '29.00' , '29' , '0' , '5' , '27.55' ) 
07/02/2023 11:53:38 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '439' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-07') 
07/02/2023 11:53:38 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' ,
                          '439' ,
                          '2023-02-07' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '30.00' ,
                          '24.59' ,
                          NOW() ,
                          NOW() ) 
07/02/2023 11:53:38 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 = '81262' 
07/02/2023 11:53:38 am >>  DELETE FROM ps_document_detail WHERE id_document = '81262' 
07/02/2023 11:53:38 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81262' , '3256' , 'CUSTODIA LEZIONARIO ECON. DIPINTA - OGGETTI' , '1' ,  '-1' , '1' ,
                               '30' , '24.590163934426' , '22' , '0' , '30.00' ) 
07/02/2023 11:56:06 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '440' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-07') 
07/02/2023 11:56: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' ,
                          '440' ,
                          '2023-02-07' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '68.13' ,
                          '68.13' ,
                          NOW() ,
                          NOW() ) 
07/02/2023 11:56: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 = '81263' 
07/02/2023 11:56:06 am >>  DELETE FROM ps_document_detail WHERE id_document = '81263' 
07/02/2023 11:56: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
                            ( '81263' , '19636' , 'PREGHIAMO CON I SALMI' , '3' ,  '-3' , '4' ,
                               '5.90' , '5.9' , '0' , '5' , '16.83' ) 
07/02/2023 11:56: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
                            ( '81263' , '16174' , 'SACRAMENTI SEGNI DI DIO NEL MONDO - J. RATZINGER' , '1' ,  '-1' , '4' ,
                               '16.00' , '16' , '0' , '5' , '15.20' ) 
07/02/2023 11:56: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
                            ( '81263' , '20659' , 'CORSO FONDAMENTALE SULLA FEDE - K. RAHNER' , '1' ,  '-1' , '4' ,
                               '38.00' , '38' , '0' , '5' , '36.10' ) 
07/02/2023 12:06:34 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '441' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-07') 
07/02/2023 12:06: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' ,
                          '441' ,
                          '2023-02-07' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '30.00' ,
                          '24.59' ,
                          NOW() ,
                          NOW() ) 
07/02/2023 12:06: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 = '81264' 
07/02/2023 12:06:34 pm >>  DELETE FROM ps_document_detail WHERE id_document = '81264' 
07/02/2023 12:06: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
                            ( '81264' , '19107' , 'INCENSO GRANI 3A' , '1' ,  '-1' , '1' ,
                               '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 
07/02/2023 12:38:07 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '442' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-07') 
07/02/2023 12:38:07 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' ,
                          '442' ,
                          '2023-02-07' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '3.00' ,
                          '2.46' ,
                          NOW() ,
                          NOW() ) 
07/02/2023 12:38:07 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 = '81265' 
07/02/2023 12:38:07 pm >>  DELETE FROM ps_document_detail WHERE id_document = '81265' 
07/02/2023 12:38:07 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81265' , '3104' , 'CROCE SAN BENEDETTO - CARTONCINO' , '2' ,  '-2' , '1' ,
                               '1.50' , '1.2295081967213' , '22' , '0' , '3.00' ) 
07/02/2023 12:52:22 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '443' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-07') 
07/02/2023 12:52:22 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' ,
                          '443' ,
                          '2023-02-07' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '650.00' ,
                          '532.79' ,
                          NOW() ,
                          NOW() ) 
07/02/2023 12:52:22 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 = '81266' 
07/02/2023 12:52:22 pm >>  DELETE FROM ps_document_detail WHERE id_document = '81266' 
07/02/2023 12:52: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
                            ( '81266' , '20509' , 'BAMBINO PASTA DI LEGNO CM40 - AC289N/40' , '1' ,  '-1' , '1' ,
                               '630' , '516.39344262295' , '22' , '0' , '630.00' ) 
07/02/2023 12:52: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
                            ( '81266' , '20510' , 'CULLA CM 35' , '1' ,  '-1' , '1' ,
                               '20' , '16.393442622951' , '22' , '0' , '20.00' ) 
07/02/2023 01:07:00 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '444' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-07') 
07/02/2023 01:07: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' ,
                          '444' ,
                          '2023-02-07' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '46.50' ,
                          '44.61' ,
                          NOW() ,
                          NOW() ) 
07/02/2023 01:07: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 = '81267' 
07/02/2023 01:07:00 pm >>  DELETE FROM ps_document_detail WHERE id_document = '81267' 
07/02/2023 01:07: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
                            ( '81267' , '17941' , 'LOURDES - ISONZO 119 bis' , '3' ,  '-3' , '1' ,
                               '3.50' , '2.8688524590164' , '22' , '0' , '10.50' ) 
07/02/2023 01:07: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
                            ( '81267' , '14529' , 'PANE E VINO - SUSSIDIO' , '1' ,  '-1' , '4' ,
                               '4.5' , '4.5' , '0' , '0' , '4.50' ) 
07/02/2023 01:07: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
                            ( '81267' , '12864' , 'IMPRONTE DI MISERICORDIA E DI PERDONO - SUSSIDIO' , '5' ,  '-5' , '4' ,
                               '4.5' , '4.5' , '0' , '0' , '22.50' ) 
07/02/2023 01:07: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
                            ( '81267' , '6619' , 'MIA IMPRONTA È TUA - 1 QUADERNO' , '2' ,  '-2' , '4' ,
                               '4.5' , '4.5' , '0' , '0' , '9.00' ) 
07/02/2023 01:07:18 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '445' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-07') 
07/02/2023 01:07:18 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '445' ,
                          '2023-02-07' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '4.00' ,
                          '3.85' ,
                          NOW() ,
                          NOW() ) 
07/02/2023 01:07:18 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81268' 
07/02/2023 01:07:18 pm >>  DELETE FROM ps_document_detail WHERE id_document = '81268' 
07/02/2023 01:07:18 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81268' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' ,  '-2' , '3' ,
                               '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 
07/02/2023 01:19:25 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '446' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-07') 
07/02/2023 01:19:25 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '446' ,
                          '2023-02-07' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '40.00' ,
                          '32.79' ,
                          NOW() ,
                          NOW() ) 
07/02/2023 01:19:25 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81269' 
07/02/2023 01:19:25 pm >>  DELETE FROM ps_document_detail WHERE id_document = '81269' 
07/02/2023 01:19:25 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81269' , '19099' , 'INCENSO A' , '1' ,  '-1' , '1' ,
                               '40' , '32.786885245902' , '22' , '0' , '40.00' ) 
07/02/2023 03:52:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892240650' AND id_product != '20683' AND ean13 != '' 
07/02/2023 03:52:07 pm >> UPDATE ps_product SET
                  id_supplier = '7',
                  reference = 'GONDOLA 2',
                  ean13 = '9788892240650',
                  date_upd = NOW()
                WHERE id_product = '20683' 
07/02/2023 03:52:07 pm >> UPDATE ps_product_lang SET
                  name = 'TI RACCONTO LA PASQUA',
                  description = ''
                WHERE id_product = '20683' 
07/02/2023 03:52:07 pm >> UPDATE ps_product SET
                  wholesale_price = '1.63',
                  on_sale = '0',
                  price = '2.5'
                WHERE id_product = '20683' 
07/02/2023 03:52:07 pm >> UPDATE ps_product_shop SET
                  wholesale_price = '1.63',
                  price = '2.5',
                  id_tax_rules_group = '4',
                  id_category_default = '30',
                  id_argoment_default = '50',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '20683' 
07/02/2023 03:52:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '20683' 
07/02/2023 03:52:55 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '28' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-02-07') 
07/02/2023 03:52: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  (
                          '21' ,
                          '28' ,
                          '2023-02-07' ,
                          '' ,
                          '2755' ,
                          '0' ,
                          '4677545' ,
                          'VIA PRINCIPE DI PIEMONTE 04026 MINTURNO' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '7' ,
                          '0' ,
                          '99.33' ,
                          '99.33' ,
                          NOW() ,
                          NOW() ) 
07/02/2023 03:52: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 = '81270' 
07/02/2023 03:52:55 pm >>  DELETE FROM ps_document_detail WHERE id_document = '81270' 
07/02/2023 03:52: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
                            ( '81270' , '20661' , 'LASCIATI AMARE - P. CURTAZ' , '1' ,  '-1' , '4' ,
                               '4.00' , '4' , '0' , '5' , '3.80' ) 
07/02/2023 03:52: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
                            ( '81270' , '19376' , 'INCONTRARE IL CROCIFISSO - T. HALIK' , '1' ,  '-1' , '4' ,
                               '3.00' , '3' , '0' , '5' , '2.85' ) 
07/02/2023 03:52: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
                            ( '81270' , '20675' , 'SULLA VIA DELLA CROCE CON PAPA FRANCESCO' , '1' ,  '-1' , '4' ,
                               '3.00' , '3' , '0' , '5' , '2.85' ) 
07/02/2023 03:52: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
                            ( '81270' , '20658' , 'CON GESU DALLA MORTE ALLA VITA - M. TELLAN' , '1' ,  '-1' , '4' ,
                               '5.90' , '5.9' , '0' , '5' , '5.61' ) 
07/02/2023 03:52: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
                            ( '81270' , '20710' , 'VIA CRUCIS DELLA PACE' , '1' ,  '-1' , '4' ,
                               '2.00' , '2' , '0' , '5' , '1.90' ) 
07/02/2023 03:52: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
                            ( '81270' , '20711' , 'VIA CRUCIS IN CAMMINO CON LA CHIESA ' , '1' ,  '-1' , '4' ,
                               '2.00' , '2' , '0' , '5' , '1.90' ) 
07/02/2023 03:52: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
                            ( '81270' , '19266' , 'VOLGERANNO LO SGUARDO' , '1' ,  '-1' , '4' ,
                               '2.00' , '2' , '0' , '5' , '1.90' ) 
07/02/2023 03:52: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
                            ( '81270' , '523' , 'AMORE VINCE LA MORTE - VIA CRUCIS' , '1' ,  '-1' , '4' ,
                               '0.85' , '0.85' , '0' , '5' , '0.81' ) 
07/02/2023 03:52: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
                            ( '81270' , '15276' , 'SCOLLINARE O SRADICARE - VIA CRUCIS' , '12' ,  '-12' , '4' ,
                               '2.00' , '2' , '0' , '5' , '22.80' ) 
07/02/2023 03:52: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
                            ( '81270' , '20723' , 'VIA DELLA VITA - A. GRAPPONE' , '1' ,  '-1' , '4' ,
                               '12.00' , '12' , '0' , '5' , '11.40' ) 
07/02/2023 03:52: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
                            ( '81270' , '20462' , 'ASCOLTARLO ERA RIMANERE ACCESI - E. RONCHI' , '1' ,  '-1' , '4' ,
                               '20.00' , '20' , '0' , '5' , '19.00' ) 
07/02/2023 03:52: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
                            ( '81270' , '20451' , 'BISACCIA DEL PELLEGRINO - T. BELLO' , '1' ,  '-1' , '4' ,
                               '15.00' , '15' , '0' , '5' , '14.25' ) 
07/02/2023 03:52: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
                            ( '81270' , '20660' , 'QUARESIMA E PASQUA ' , '2' ,  '-2' , '4' ,
                               '2.90' , '2.9' , '0' , '5' , '5.51' ) 
07/02/2023 03:52: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
                            ( '81270' , '20683' , 'TI RACCONTO LA PASQUA' , '2' ,  '-2' , '4' ,
                               '2.50' , '2.5' , '0' , '5' , '4.75' ) 
07/02/2023 04:13:32 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '447' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-07') 
07/02/2023 04:13:32 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '447' ,
                          '2023-02-07' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '7.60' ,
                          '7.60' ,
                          NOW() ,
                          NOW() ) 
07/02/2023 04:13:32 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81271' 
07/02/2023 04:13:32 pm >>  DELETE FROM ps_document_detail WHERE id_document = '81271' 
07/02/2023 04:13:32 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '81271' , '19161' , 'CAREZZA DI DIO - TONINO BELLO' , '1' ,  '-1' , '4' ,
                               '8.00' , '8' , '0' , '5' , '7.60' ) 
07/02/2023 04:37:07 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '119/A' AND id_document != '77503' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-23') 
07/02/2023 04:37:07 pm >> UPDATE ps_document SET
                          id_document_type = '24',
                          document_num = '119/A',
                          document_date = '2022-12-23',
                          document_letter = 'A',
                          id_customer = '3843',
                          id_supplier = '',
                          id_address = '4673209',
                          address1 = 'RIONE PIOMBINO 84080 PELLEZZANO',
                          address2 = '',
                          note = '12/01 € 300,00 + 07/02 € 250,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 = '879.00',
                          price_tax_excluded = '720.49',
                          date_upd = NOW()
                        WHERE id_document = '77503' 
07/02/2023 04:37:07 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 = '77503' 
07/02/2023 04:37:07 pm >>  DELETE FROM ps_document_detail WHERE id_document = '77503' 
07/02/2023 04:37:07 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '77503' , '15679' , 'CAMICE LANA/POL. SFILATURE A MANO' , '1' ,  '-1' , '1' ,
                               '800.0000' , '655.73770491803' , '22' , '0' , '800.00' ) 
07/02/2023 04:37:07 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '77503' , '19607' , 'CLERGY F/F COTONE ML ' , '2' ,  '-2' , '1' ,
                               '39.5000' , '32.377049180328' , '22' , '0' , '79.00' ) 
07/02/2023 04:52:45 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '448' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-07') 
07/02/2023 04:52:45 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '448' ,
                          '2023-02-07' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '12.00' ,
                          '10.62' ,
                          NOW() ,
                          NOW() ) 
07/02/2023 04:52:45 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81272' 
07/02/2023 04:52:45 pm >>  DELETE FROM ps_document_detail WHERE id_document = '81272' 
07/02/2023 04:52: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
                            ( '81272' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' ,  '-1' , '3' ,
                               '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 
07/02/2023 04:52: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
                            ( '81272' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' ,  '-1' , '3' ,
                               '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 
07/02/2023 04:52: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
                            ( '81272' , '15089' , 'QUADRETTO EFFETTO PIETRA - SACRA FAMIGLIA - 2950' , '1' ,  '-1' , '1' ,
                               '6.50' , '5.327868852459' , '22' , '0' , '6.50' ) 
07/02/2023 05:27:41 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '21/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-07') 
07/02/2023 05:27: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  (
                          '24' ,
                          '21/A' ,
                          '2023-02-07' ,
                          'A' ,
                          '1148' ,
                          '0' ,
                          '1148' ,
                          'P.ZZA GIOVANNI PAOLO II, 4 84080 COPERCHIA' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '52.00' ,
                          '52.00' ,
                          NOW() ,
                          NOW() ) 
07/02/2023 05:27: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 = '81273' 
07/02/2023 05:27:41 pm >>  DELETE FROM ps_document_detail WHERE id_document = '81273' 
07/02/2023 05:27: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
                            ( '81273' , '2073' , 'CINQUE LINGUAGGI DELLAMORE DEI BAMBINI - PER GENITORI E EDUCATORI' , '4' ,  '-4' , '4' ,
                               '13.00' , '13' , '0' , '0' , '52.00' ) 
07/02/2023 07:24:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736024' AND id_product != '19088' AND ean13 != '' 
07/02/2023 07:24:23 pm >> UPDATE ps_product SET
                  id_supplier = '53',
                  reference = '7/3',
                  ean13 = '9791280736024',
                  date_upd = NOW()
                WHERE id_product = '19088' 
07/02/2023 07:24:23 pm >> UPDATE ps_product_lang SET
                  name = 'TU SOLO IL SANTO - G. VALSECCHI',
                  description = '<p>Il volume offre delle riflessioni per la meditazione della parola di Dio per le feste del Signore.</p>'
                WHERE id_product = '19088' 
07/02/2023 07:24:23 pm >> UPDATE ps_product SET
                  wholesale_price = '1.42',
                  on_sale = '0',
                  price = '10.0000'
                WHERE id_product = '19088' 
07/02/2023 07:24:23 pm >> UPDATE ps_product_shop SET
                  wholesale_price = '1.42',
                  price = '10.0000',
                  id_tax_rules_group = '4',
                  id_category_default = '395',
                  id_argoment_default = '64',
                  id_internal_category = '4',
                  on_sale = '0',
                  on_showcase = '1',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '19088' 
07/02/2023 07:24:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '19088' 
07/02/2023 07:24:23 pm >> INSERT INTO ps_specific_price
                    ( 	id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`)
                  VALUES
                    ( '0' , '0' , '19088' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
07/02/2023 07:28:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983936' AND id_product != '18657' AND ean13 != '' 
07/02/2023 07:28:56 pm >> UPDATE ps_product SET
                  id_supplier = '53',
                  reference = '7/2',
                  ean13 = '9788895983936',
                  date_upd = NOW()
                WHERE id_product = '18657' 
07/02/2023 07:28:56 pm >> UPDATE ps_product_lang SET
                  name = 'HO DATO LORO LA TUA PAROLA - P. VALSECCHI',
                  description = ''
                WHERE id_product = '18657' 
07/02/2023 07:28:56 pm >> UPDATE ps_product SET
                  wholesale_price = '3.80',
                  on_sale = '0',
                  price = '16.0000'
                WHERE id_product = '18657' 
07/02/2023 07:28:56 pm >> UPDATE ps_product_shop SET
                  wholesale_price = '3.80',
                  price = '16.0000',
                  id_tax_rules_group = '4',
                  id_category_default = '395',
                  id_argoment_default = '64',
                  id_internal_category = '4',
                  on_sale = '0',
                  on_showcase = '1',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '18657' 
07/02/2023 07:28:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '18657' 
07/02/2023 07:28:56 pm >> INSERT INTO ps_specific_price
                    ( 	id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`)
                  VALUES
                    ( '0' , '0' , '18657' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
07/02/2023 07:29:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736055' AND id_product != '19361' AND ean13 != '' 
07/02/2023 07:29:51 pm >> UPDATE ps_product SET
                  id_supplier = '159',
                  reference = '7/5',
                  ean13 = '9791280736055',
                  date_upd = NOW()
                WHERE id_product = '19361' 
07/02/2023 07:29:51 pm >> UPDATE ps_product_lang SET
                  name = 'LITANIE LAURETANE - M. DE ROSA',
                  description = '<p>Le litanie della Madonna assumono un valore non piccolo se si riesce a vederle come l’occasione di una contempla-zione della figura di Maria.</p><p>Nel piano di salvezza, Maria ha un ruolo particolare. Maria non è santa per tutto ciò che ha ricevuto gratuitamente, ma perché ha fatto il suo cammino di santità ascoltando la parola del figlio Gesù e mettendola in pratica ogni giorno. “La vera devozione alla Madonna consiste nell’imitazione delle sue virtù” (Lumen Gentium n. 67).</p>'
                WHERE id_product = '19361' 
07/02/2023 07:29:51 pm >> UPDATE ps_product SET
                  wholesale_price = '2.14',
                  on_sale = '0',
                  price = '12.0000'
                WHERE id_product = '19361' 
07/02/2023 07:29:51 pm >> UPDATE ps_product_shop SET
                  wholesale_price = '2.14',
                  price = '12.0000',
                  id_tax_rules_group = '4',
                  id_category_default = '395',
                  id_argoment_default = '28',
                  id_internal_category = '4',
                  on_sale = '0',
                  on_showcase = '1',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '19361' 
07/02/2023 07:29:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '19361' 
07/02/2023 07:29:51 pm >> INSERT INTO ps_specific_price
                    ( 	id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`)
                  VALUES
                    ( '0' , '0' , '19361' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )