09/07/2022 10:12:00 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '2227' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-09') 
09/07/2022 10:12:00 am >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '2227' ,
                          '2022-07-09' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '23.00' ,
                          '19.03' ,
                          NOW() ,
                          NOW() ) 
09/07/2022 10:12:00 am >>  INSERT INTO ps_document_detail_backup
        ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
        SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59125' 
09/07/2022 10:12:00 am >>  DELETE FROM ps_document_detail WHERE id_document = '59125' 
09/07/2022 10:12:00 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '59125' , '8195' , 'GIGLER COMPLETO DORATO - 250 ' , '1' ,  '-1' , '1' ,
                               '4.00' , '3.2786885245902' , '22' , '0' , '4.00' ) 
09/07/2022 10:12:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '8195' AND id_supplier = '' 
09/07/2022 10:12:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8195' , '' , '1' ) 
09/07/2022 10:12:00 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '59125' , '564' , 'GIGLER COMPLETO PER ART. 534/536/537 - 249' , '1' ,  '-1' , '1' ,
                               '3.20' , '2.6229508196721' , '22' , '0' , '3.20' ) 
09/07/2022 10:12:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '564' AND id_supplier = '' 
09/07/2022 10:12:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '564' , '' , '1' ) 
09/07/2022 10:12:00 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '59125' , '1914' , 'CERA DELLA LITURGIA' , '1' ,  '-1' , '1' ,
                               '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 
09/07/2022 10:12:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 
09/07/2022 10:12:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 
09/07/2022 10:12:00 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '59125' , '18176' , 'ANTIQUUM MINISTERIUM - PAPA FRANCESCO' , '1' ,  '-1' , '4' ,
                               '1.00' , '1' , '0' , '0' , '1.00' ) 
09/07/2022 10:12:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '18176' AND id_supplier = '' 
09/07/2022 10:12:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18176' , '' , '1' ) 
09/07/2022 10:12:00 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '59125' , '7202' , 'ARTICOLI RELIGIOSI' , '1' ,  '-1' , '1' ,
                               '9.9' , '8.1147540983607' , '22' , '0' , '9.90' ) 
09/07/2022 10:12:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 
09/07/2022 10:12:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 
09/07/2022 10:34:20 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '2228' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-09') 
09/07/2022 10:34: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' ,
                          '2228' ,
                          '2022-07-09' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '45.30' ,
                          '37.22' ,
                          NOW() ,
                          NOW() ) 
09/07/2022 10:34: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 = '59126' 
09/07/2022 10:34:20 am >>  DELETE FROM ps_document_detail WHERE id_document = '59126' 
09/07/2022 10:34:20 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '59126' , '12467' , 'TAU PRIMA COMUNIONE' , '24' ,  '-24' , '1' ,
                               '1.60' , '1.3114754098361' , '22' , '0' , '38.40' ) 
09/07/2022 10:34:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '12467' AND id_supplier = '' 
09/07/2022 10:34:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12467' , '' , '1' ) 
09/07/2022 10:34:20 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '59126' , '7202' , 'ARTICOLI RELIGIOSI' , '1' ,  '-1' , '1' ,
                               '4.4' , '3.6065573770492' , '22' , '0' , '4.40' ) 
09/07/2022 10:34:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 
09/07/2022 10:34:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 
09/07/2022 10:34:20 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '59126' , '19693' , 'CALENDARIO LITURGICO 2023' , '1' ,  '-1' , '4' ,
                               '0.50' , '0.5' , '0' , '0' , '0.50' ) 
09/07/2022 10:34:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '19693' AND id_supplier = '' 
09/07/2022 10:34:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19693' , '' , '1' ) 
09/07/2022 10:34:20 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '59126' , '7202' , 'ARTICOLI RELIGIOSI' , '2' ,  '-2' , '1' ,
                               '1' , '0.81967213114754' , '22' , '0' , '2.00' ) 
09/07/2022 10:34:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 
09/07/2022 10:34:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 
09/07/2022 10:34:30 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '2229' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-09') 
09/07/2022 10:34:30 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' ,
                          '2229' ,
                          '2022-07-09' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '55.00' ,
                          '45.08' ,
                          NOW() ,
                          NOW() ) 
09/07/2022 10:34:30 am >>  INSERT INTO ps_document_detail_backup
        ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
        SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59127' 
09/07/2022 10:34:30 am >>  DELETE FROM ps_document_detail WHERE id_document = '59127' 
09/07/2022 10:34:30 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '59127' , '12659' , 'CAMICE BIANCO - MISTO COT. 140' , '1' ,  '-1' , '1' ,
                               '55.00' , '45.081967213115' , '22' , '0' , '55.00' ) 
09/07/2022 10:34:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '12659' AND id_supplier = '' 
09/07/2022 10:34:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12659' , '' , '1' ) 
09/07/2022 10:41:49 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '2230' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-09') 
09/07/2022 10:41:49 am >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '2230' ,
                          '2022-07-09' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '30.00' ,
                          '24.59' ,
                          NOW() ,
                          NOW() ) 
09/07/2022 10:41:49 am >>  INSERT INTO ps_document_detail_backup
        ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
        SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59128' 
09/07/2022 10:41:49 am >>  DELETE FROM ps_document_detail WHERE id_document = '59128' 
09/07/2022 10:41:49 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '59128' , '18760' , 'BRACCIALE ARG -1819' , '1' ,  '-1' , '1' ,
                               '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 
09/07/2022 10:41:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '18760' AND id_supplier = '' 
09/07/2022 10:41:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18760' , '' , '1' ) 
09/07/2022 10:43:47 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '2231' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-09') 
09/07/2022 10:43:48 am >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '2231' ,
                          '2022-07-09' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '11.50' ,
                          '10.28' ,
                          NOW() ,
                          NOW() ) 
09/07/2022 10:43:48 am >>  INSERT INTO ps_document_detail_backup
        ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
        SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59129' 
09/07/2022 10:43:48 am >>  DELETE FROM ps_document_detail WHERE id_document = '59129' 
09/07/2022 10:43:48 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '59129' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '1' ,  '-1' , '1' ,
                               '5.50' , '4.5081967213115' , '22' , '0' , '5.50' ) 
09/07/2022 10:43:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '17277' AND id_supplier = '' 
09/07/2022 10:43:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17277' , '' , '1' ) 
09/07/2022 10:43:48 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '59129' , '15922' , 'PARTICOLE 3MM - P3M' , '1' ,  '-1' , '3' ,
                               '6.00' , '5.7692307692308' , '4' , '0' , '6.00' ) 
09/07/2022 10:43:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '15922' AND id_supplier = '' 
09/07/2022 10:43:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15922' , '' , '1' ) 
09/07/2022 11:00:12 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '2232' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-09') 
09/07/2022 11:00:12 am >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '2232' ,
                          '2022-07-09' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '179.00' ,
                          '146.72' ,
                          NOW() ,
                          NOW() ) 
09/07/2022 11:00:12 am >>  INSERT INTO ps_document_detail_backup
        ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
        SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59130' 
09/07/2022 11:00:12 am >>  DELETE FROM ps_document_detail WHERE id_document = '59130' 
09/07/2022 11:00:12 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '59130' , '3073' , 'CROCE PRIMA COMUNIONE - LEGNO SCURO - 713/15' , '15' ,  '-15' , '1' ,
                               '1.20' , '0.98360655737705' , '22' , '0' , '18.00' ) 
09/07/2022 11:00:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '3073' AND id_supplier = '' 
09/07/2022 11:00:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3073' , '' , '1' ) 
09/07/2022 11:00:12 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '59130' , '15097' , 'CORONA MATRIMONIO - ORO' , '8' ,  '-8' , '1' ,
                               '7.50' , '6.1475409836066' , '22' , '0' , '60.00' ) 
09/07/2022 11:00:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '15097' AND id_supplier = '' 
09/07/2022 11:00:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15097' , '' , '1' ) 
09/07/2022 11:00:12 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '59130' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' ,  '-30' , '1' ,
                               '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 
09/07/2022 11:00:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 
09/07/2022 11:00:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 
09/07/2022 11:00:12 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '59130' , '2652' , 'CONFEZIONE CARTONCINO COMUNIONE - 2331/K126' , '5' ,  '-5' , '1' ,
                               '2.20' , '1.8032786885246' , '22' , '0' , '11.00' ) 
09/07/2022 11:00:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '2652' AND id_supplier = '' 
09/07/2022 11:00:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2652' , '' , '1' ) 
09/07/2022 11:05:26 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '2233' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-09') 
09/07/2022 11:05: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' ,
                          '2233' ,
                          '2022-07-09' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '13.35' ,
                          '13.17' ,
                          NOW() ,
                          NOW() ) 
09/07/2022 11:05: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 = '59131' 
09/07/2022 11:05:26 am >>  DELETE FROM ps_document_detail WHERE id_document = '59131' 
09/07/2022 11:05: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
                            ( '59131' , '19731' , 'ITINERARI CAT. PER LA VITA MATRIMONIALE' , '1' ,  '-1' , '4' ,
                               '3.00' , '3' , '0' , '5' , '2.85' ) 
09/07/2022 11:05:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '19731' AND id_supplier = '' 
09/07/2022 11:05:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19731' , '' , '1' ) 
09/07/2022 11:05: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
                            ( '59131' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '1' ,  '-1' , '4' ,
                               '5.00' , '5' , '0' , '5' , '4.75' ) 
09/07/2022 11:05:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 
09/07/2022 11:05:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 
09/07/2022 11:05: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
                            ( '59131' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '1' ,  '-1' , '4' ,
                               '5.00' , '5' , '0' , '5' , '4.75' ) 
09/07/2022 11:05:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 
09/07/2022 11:05:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 
09/07/2022 11:05: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
                            ( '59131' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' ,  '-1' , '1' ,
                               '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 
09/07/2022 11:05:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '17005' AND id_supplier = '' 
09/07/2022 11:05:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17005' , '' , '1' ) 
09/07/2022 11:07:37 am >> DELETE FROM ps_document WHERE id_document = '58489' 
09/07/2022 11:07:37 am >> DELETE FROM ps_document_detail WHERE id_document = '58489' 
09/07/2022 11:29:42 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '1105' AND id_document != '54718' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-12') 
09/07/2022 11:29:42 am >> UPDATE ps_document SET
                          id_document_type = '11',
                          document_num = '1105',
                          document_date = '2022-04-12',
                          document_letter = '',
                          id_customer = '0',
                          id_supplier = '',
                          id_address = '0',
                          address1 = '',
                          address2 = '',
                          note = '',
                          price_shipping = '0.00',
                          id_tax_shipping_rules = '4',
                          colli = '0',
                          peso = '0',
                          porto_e_imballo = '0',
                          mezzo_consegna = '',
                          id_payment = '0',
                          id_causal = '0',
                          price_tax_included = '198.94',
                          price_tax_excluded = '168.55',
                          date_upd = NOW()
                        WHERE id_document = '54718' 
09/07/2022 11:29:42 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 = '54718' 
09/07/2022 11:29:42 am >>  DELETE FROM ps_document_detail WHERE id_document = '54718' 
09/07/2022 11:29:42 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '54718' , '18120' , 'COPRILEGGIO AGNELLO ' , '1' ,  '-1' , '1' ,
                               '160.0000' , '131.14754098361' , '22' , '0' , '160.00' ) 
09/07/2022 11:29:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '18120' AND id_supplier = '' 
09/07/2022 11:29:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18120' , '' , '1' ) 
09/07/2022 11:29:42 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '54718' , '16309' , 'BRACCIALE LEGNO SANTI' , '4' ,  '-4' , '1' ,
                               '1.00' , '0.81967213114754' , '22' , '0' , '4.00' ) 
09/07/2022 11:29:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '16309' AND id_supplier = '' 
09/07/2022 11:29:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16309' , '' , '1' ) 
09/07/2022 11:29:42 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '54718' , '19303' , 'NOVENA AI PASTORELLI DI FATIMA - 8070' , '1' ,  '-1' , '4' ,
                               '3.0000' , '3' , '0' , '5' , '2.85' ) 
09/07/2022 11:29:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '19303' AND id_supplier = '' 
09/07/2022 11:29:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19303' , '' , '1' ) 
09/07/2022 11:29:42 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '54718' , '19301' , 'VERGINE DEL SILENZIO - 8068' , '1' ,  '-1' , '4' ,
                               '2.0000' , '2' , '0' , '5' , '1.90' ) 
09/07/2022 11:29:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '19301' AND id_supplier = '' 
09/07/2022 11:29:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19301' , '' , '1' ) 
09/07/2022 11:29:42 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '54718' , '19299' , 'SULLA TUA PAROLA - MAG/GIU 2022' , '1' ,  '-1' , '4' ,
                               '4.4800' , '4.48' , '0' , '0' , '4.48' ) 
09/07/2022 11:29:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '19299' AND id_supplier = '' 
09/07/2022 11:29:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19299' , '' , '1' ) 
09/07/2022 11:29:42 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '54718' , '14145' , 'CREDO SPIEGATO AI RAGAZZI' , '1' ,  '-1' , '4' ,
                               '2.5000' , '2.5' , '0' , '5' , '2.38' ) 
09/07/2022 11:29:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '14145' AND id_supplier = '' 
09/07/2022 11:29:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14145' , '' , '1' ) 
09/07/2022 11:29:42 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '54718' , '18049' , 'PADRE NOSTRO SPIEGATO AI BAMBINI' , '1' ,  '-1' , '4' ,
                               '2.5000' , '2.5' , '0' , '5' , '2.38' ) 
09/07/2022 11:29:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '18049' AND id_supplier = '' 
09/07/2022 11:29:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18049' , '' , '1' ) 
09/07/2022 11:29:42 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '54718' , '14929' , 'AVE MARIA, SPIEGATA AI BAMBINI' , '1' ,  '-1' , '4' ,
                               '1.5000' , '1.5' , '0' , '5' , '1.43' ) 
09/07/2022 11:29:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '14929' AND id_supplier = '' 
09/07/2022 11:29:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14929' , '' , '1' ) 
09/07/2022 11:29:43 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '54718' , '19184' , 'FARE LA STORIA 1' , '1' ,  '-1' , '4' ,
                               '7.0000' , '7' , '0' , '5' , '6.65' ) 
09/07/2022 11:29:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '19184' AND id_supplier = '' 
09/07/2022 11:29:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19184' , '' , '1' ) 
09/07/2022 11:29:43 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '54718' , '2777' , 'CORONCINA E NOVENA ALLA DIVINA MISERICORDIA' , '1' ,  '-1' , '4' ,
                               '1.4300' , '1.43' , '0' , '0' , '1.43' ) 
09/07/2022 11:29:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '2777' AND id_supplier = '' 
09/07/2022 11:29:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2777' , '' , '1' ) 
09/07/2022 11:29:43 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '54718' , '14935' , 'GESU E RISORTO' , '1' ,  '-1' , '4' ,
                               '2.0000' , '2' , '0' , '5' , '1.90' ) 
09/07/2022 11:29:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '14935' AND id_supplier = '' 
09/07/2022 11:29:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14935' , '' , '1' ) 
09/07/2022 11:29:43 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '54718' , '19281' , 'SE IL CHICCO DI GRANO - VIA CRUCIS' , '1' ,  '-1' , '4' ,
                               '2.8000' , '2.8' , '0' , '5' , '2.66' ) 
09/07/2022 11:29:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '19281' AND id_supplier = '' 
09/07/2022 11:29:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19281' , '' , '1' ) 
09/07/2022 11:29:43 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '54718' , '18597' , 'ROSARIO SPIEGATO AI BAMBINI' , '1' ,  '-1' , '4' ,
                               '2.5000' , '2.5' , '0' , '5' , '2.38' ) 
09/07/2022 11:29:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '18597' AND id_supplier = '' 
09/07/2022 11:29:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18597' , '' , '1' ) 
09/07/2022 11:29:43 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '54718' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '2' ,  '-2' , '1' ,
                               '2.0000' , '1.6393442622951' , '22' , '0' , '4.00' ) 
09/07/2022 11:29:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '18217' AND id_supplier = '' 
09/07/2022 11:29:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18217' , '' , '1' ) 
09/07/2022 11:29:43 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '54718' , '16309' , 'BRACCIALE LEGNO SANTI' , '1' ,  '-1' , '1' ,
                               '0.5' , '0.40983606557377' , '22' , '0' , '0.50' ) 
09/07/2022 11:29:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '16309' AND id_supplier = '' 
09/07/2022 11:29:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16309' , '' , '1' ) 
09/07/2022 11:37:01 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '51/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-09') 
09/07/2022 11:37:01 am >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '24' ,
                          '51/A' ,
                          '2022-07-09' ,
                          'A' ,
                          '3550' ,
                          '0' ,
                          '4671016' ,
                          'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' ,
                          '' ,
                          'p. enzo' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '18.00' ,
                          '18.00' ,
                          NOW() ,
                          NOW() ) 
09/07/2022 11:37:01 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 = '59132' 
09/07/2022 11:37:01 am >>  DELETE FROM ps_document_detail WHERE id_document = '59132' 
09/07/2022 11:37:01 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '59132' , '8340' , 'PREGHIERE AL PREZIOSISSIMO SANGUE - 8158' , '1' ,  '-1' , '4' ,
                               '8.00' , '8' , '0' , '0' , '8.00' ) 
09/07/2022 11:37:01 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '59132' , '15816' , 'CHI HA REDENTI CON IL TUO SANGUE - L. EPICOCO ' , '1' ,  '-1' , '4' ,
                               '10.00' , '10' , '0' , '0' , '10.00' ) 
09/07/2022 12:12:18 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '2234' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-09') 
09/07/2022 12:12: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' ,
                          '2234' ,
                          '2022-07-09' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '120.00' ,
                          '106.75' ,
                          NOW() ,
                          NOW() ) 
09/07/2022 12:12: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 = '59133' 
09/07/2022 12:12:18 pm >>  DELETE FROM ps_document_detail WHERE id_document = '59133' 
09/07/2022 12:12: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
                            ( '59133' , '12337' , 'LUMINI ART. ECO 2 ROSSO' , '3' ,  '-3' , '1' ,
                               '7.1' , '5.8196721311475' , '22' , '0' , '21.30' ) 
09/07/2022 12:12:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12337' AND id_supplier = '' 
09/07/2022 12:12:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12337' , '' , '1' ) 
09/07/2022 12:12: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
                            ( '59133' , '19429' , 'QUADRO DECORATO 35X29 - RC' , '1' ,  '-1' , '1' ,
                               '48.80' , '40' , '22' , '0' , '48.80' ) 
09/07/2022 12:12:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19429' AND id_supplier = '' 
09/07/2022 12:12:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19429' , '' , '1' ) 
09/07/2022 12:12: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
                            ( '59133' , '6058' , 'MADONNA DEL CARMINE - 117 BIS ' , '1' ,  '-1' , '1' ,
                               '3.35' , '2.7459016393443' , '22' , '0' , '3.35' ) 
09/07/2022 12:12:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6058' AND id_supplier = '' 
09/07/2022 12:12:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6058' , '' , '1' ) 
09/07/2022 12:12: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
                            ( '59133' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '1' ,  '-1' , '4' ,
                               '7.00' , '7' , '0' , '5' , '6.65' ) 
09/07/2022 12:12:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19050' AND id_supplier = '' 
09/07/2022 12:12:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19050' , '' , '1' ) 
09/07/2022 12:12: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
                            ( '59133' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '1' ,  '-1' , '4' ,
                               '12.00' , '12' , '0' , '5' , '11.40' ) 
09/07/2022 12:12:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19361' AND id_supplier = '' 
09/07/2022 12:12:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19361' , '' , '1' ) 
09/07/2022 12:12: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
                            ( '59133' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '1' ,  '-1' , '4' ,
                               '10.00' , '10' , '0' , '5' , '9.50' ) 
09/07/2022 12:12:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5643' AND id_supplier = '' 
09/07/2022 12:12:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5643' , '' , '1' ) 
09/07/2022 12:12: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
                            ( '59133' , '5644' , 'LEGGERE,... LA PAROLA - ANNO B' , '1' ,  '-1' , '4' ,
                               '10.00' , '10' , '0' , '5' , '9.50' ) 
09/07/2022 12:12:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5644' AND id_supplier = '' 
09/07/2022 12:12:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5644' , '' , '1' ) 
09/07/2022 12:12: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
                            ( '59133' , '5645' , 'LEGGERE,... LA PAROLA - ANNO C' , '1' ,  '-1' , '4' ,
                               '10.00' , '10' , '0' , '5' , '9.50' ) 
09/07/2022 12:12:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5645' AND id_supplier = '' 
09/07/2022 12:12:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5645' , '' , '1' ) 
09/07/2022 12:15:13 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '2235' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-09') 
09/07/2022 12:15:13 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' ,
                          '2235' ,
                          '2022-07-09' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '10.36' ,
                          '10.36' ,
                          NOW() ,
                          NOW() ) 
09/07/2022 12:15:13 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 = '59134' 
09/07/2022 12:15:13 pm >>  DELETE FROM ps_document_detail WHERE id_document = '59134' 
09/07/2022 12:15:13 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '59134' , '15785' , 'IN PREGHIERA CON MARIA - MADRE DECORO CARMELO' , '1' ,  '-1' , '4' ,
                               '10.90' , '10.9' , '0' , '5' , '10.36' ) 
09/07/2022 12:15:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15785' AND id_supplier = '' 
09/07/2022 12:15:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15785' , '' , '1' ) 
09/07/2022 12:19:58 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '2236' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-09') 
09/07/2022 12:19:58 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' ,
                          '2236' ,
                          '2022-07-09' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '2.80' ,
                          '2.30' ,
                          NOW() ,
                          NOW() ) 
09/07/2022 12:19:58 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 = '59135' 
09/07/2022 12:19:58 pm >>  DELETE FROM ps_document_detail WHERE id_document = '59135' 
09/07/2022 12:19:58 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '59135' , '15334' , 'CANDELA VOTIVA 20X40' , '4' ,  '-4' , '1' ,
                               '0.70' , '0.57377049180328' , '22' , '0' , '2.80' ) 
09/07/2022 12:19:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15334' AND id_supplier = '' 
09/07/2022 12:19:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15334' , '' , '1' ) 
09/07/2022 12:20:44 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '2237' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-09') 
09/07/2022 12:20:44 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '2237' ,
                          '2022-07-09' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '47.50' ,
                          '47.50' ,
                          NOW() ,
                          NOW() ) 
09/07/2022 12:20:44 pm >>  INSERT INTO ps_document_detail_backup
        ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
        SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59136' 
09/07/2022 12:20:44 pm >>  DELETE FROM ps_document_detail WHERE id_document = '59136' 
09/07/2022 12:20:44 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '59136' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '10' ,  '-10' , '4' ,
                               '5.00' , '5' , '0' , '5' , '47.50' ) 
09/07/2022 12:20:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 
09/07/2022 12:20:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 
09/07/2022 12:39:40 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '2238' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-09') 
09/07/2022 12:39:40 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' ,
                          '2238' ,
                          '2022-07-09' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '14.00' ,
                          '13.73' ,
                          NOW() ,
                          NOW() ) 
09/07/2022 12:39:40 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 = '59137' 
09/07/2022 12:39:40 pm >>  DELETE FROM ps_document_detail WHERE id_document = '59137' 
09/07/2022 12:39:40 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '59137' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '10' ,  '-10' , '4' ,
                               '0.70' , '0.7' , '0' , '0' , '7.00' ) 
09/07/2022 12:39:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 
09/07/2022 12:39:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 
09/07/2022 12:39:40 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '59137' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' ,  '-2' , '3' ,
                               '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 
09/07/2022 12:39:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 
09/07/2022 12:39:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' )