21/12/2023 09:28:00 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '4097' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2023-12-21') 
21/12/2023 09:28: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' ,
                          '4097' ,
                          '2023-12-21' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '97.85' ,
                          '97.85' ,
                          NOW() ,
                          NOW() ) 
21/12/2023 09:28: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 = '89618' 
21/12/2023 09:28:00 am >>  DELETE FROM ps_document_detail WHERE id_document = '89618' 
21/12/2023 09:28: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
                            ( '89618' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '3' ,  '-3' , '4' ,
                               '5.00' , '5' , '0' , '5' , '14.25' ) 
21/12/2023 09:28: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
                            ( '89618' , '22007' , 'BELLEZZA NASCOSTA IN TE - G. DALYATA' , '4' ,  '-4' , '4' ,
                               '22.00' , '22' , '0' , '5' , '83.60' ) 
21/12/2023 09:31:35 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '4098' AND id_document != '' AND id_document_type LIKE '13' AND YEAR(document_date) = YEAR('2023-12-21') 
21/12/2023 09:31:35 am >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '4098' ,
                          '2023-12-21' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '112.00' ,
                          '91.80' ,
                          NOW() ,
                          NOW() ) 
21/12/2023 09:31: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 = '89619' 
21/12/2023 09:31:35 am >>  DELETE FROM ps_document_detail WHERE id_document = '89619' 
21/12/2023 09:31: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
                            ( '89619' , '17161' , 'CARBONCINI NERI - CARNE' , '1' ,  '-1' , '1' ,
                               '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 
21/12/2023 09:31: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
                            ( '89619' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' ,  '-1' , '1' ,
                               '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 
21/12/2023 09:31: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
                            ( '89619' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' ,  '-30' , '1' ,
                               '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 
21/12/2023 09:35:13 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '4099' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-21') 
21/12/2023 09:35:13 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' ,
                          '4099' ,
                          '2023-12-21' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '172.40' ,
                          '142.68' ,
                          NOW() ,
                          NOW() ) 
21/12/2023 09:35:13 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 = '89620' 
21/12/2023 09:35:13 am >>  DELETE FROM ps_document_detail WHERE id_document = '89620' 
21/12/2023 09:35:13 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89620' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' ,  '-30' , '1' ,
                               '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 
21/12/2023 09:35:13 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89620' , '17161' , 'CARBONCINI NERI - CARNE' , '1' ,  '-1' , '1' ,
                               '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 
21/12/2023 09:35:13 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89620' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' ,  '-1' , '1' ,
                               '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 
21/12/2023 09:35:13 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89620' , '18032' , 'BRUCIAINCENSO H 11' , '1' ,  '-1' , '1' ,
                               '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 
21/12/2023 09:35:13 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89620' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' ,  '-2' , '1' ,
                               '8.90' , '7.2950819672131' , '22' , '0' , '17.80' ) 
21/12/2023 09:35:13 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89620' , '21445' , 'PAROLA E I GIORNI 2024' , '1' ,  '-1' , '4' ,
                               '8.00' , '8' , '0' , '5' , '7.60' ) 
21/12/2023 09:45:14 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '4100' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-21') 
21/12/2023 09:45:14 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' ,
                          '4100' ,
                          '2023-12-21' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '119.76' ,
                          '103.08' ,
                          NOW() ,
                          NOW() ) 
21/12/2023 09:45:14 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 = '89621' 
21/12/2023 09:45:14 am >>  DELETE FROM ps_document_detail WHERE id_document = '89621' 
21/12/2023 09:45:14 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89621' , '18339' , 'CROCE SAN BENEDETTO -CZ10NIK - VARI COLORI' , '1' ,  '-1' , '1' ,
                               '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 
21/12/2023 09:45:14 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89621' , '15498' , 'CROCE SAN BENEDETTO SMALTATA - CZ5NIK' , '4' ,  '-4' , '1' ,
                               '17.50' , '14.344262295082' , '22' , '0' , '70.00' ) 
21/12/2023 09:45:14 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89621' , '7202' , 'ARTICOLI RELIGIOSI' , '1' ,  '-1' , '1' ,
                               '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 
21/12/2023 09:45:14 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89621' , '21513' , 'COMPENDIO DELLA DOTTRINA SOCIALE DELLA CHIESA' , '1' ,  '-1' , '4' ,
                               '15.00' , '15' , '0' , '5' , '14.25' ) 
21/12/2023 09:45:14 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89621' , '21926' , 'STORIA DI NATALE' , '1' ,  '-1' , '4' ,
                               '7.90' , '7.9' , '0' , '5' , '7.51' ) 
21/12/2023 09:45:14 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89621' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' ,  '-2' , '3' ,
                               '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 
21/12/2023 10:16:25 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '4101' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-21') 
21/12/2023 10:16:25 am >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '4101' ,
                          '2023-12-21' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '88.50' ,
                          '72.54' ,
                          NOW() ,
                          NOW() ) 
21/12/2023 10:16:25 am >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89622' 
21/12/2023 10:16:25 am >>  DELETE FROM ps_document_detail WHERE id_document = '89622' 
21/12/2023 10:16:25 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89622' , '21839' , 'NATIVITA IN RESINA CM 8 - P725' , '15' ,  '-15' , '1' ,
                               '4.5' , '3.6885245901639' , '22' , '0' , '67.50' ) 
21/12/2023 10:16:25 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89622' , '13054' , 'ADDOBBI LASER' , '14' ,  '-14' , '1' ,
                               '1.50' , '1.2295081967213' , '22' , '0' , '21.00' ) 
21/12/2023 10:23:02 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '4102' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-21') 
21/12/2023 10:23: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' ,
                          '4102' ,
                          '2023-12-21' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '16.80' ,
                          '13.95' ,
                          NOW() ,
                          NOW() ) 
21/12/2023 10:23: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 = '89623' 
21/12/2023 10:23:02 am >>  DELETE FROM ps_document_detail WHERE id_document = '89623' 
21/12/2023 10:23: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
                            ( '89623' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '20' ,  '-20' , '1' ,
                               '0.25' , '0.20491803278689' , '22' , '0' , '5.00' ) 
21/12/2023 10:23: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
                            ( '89623' , '20548' , 'MEDAGLIA SAN BENEDETTO -T18/SBB' , '6' ,  '-6' , '1' ,
                               '0.30' , '0.24590163934426' , '22' , '0' , '1.80' ) 
21/12/2023 10:23: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
                            ( '89623' , '9134' , 'ROSARIO LEGNO CHIARO E CORDA - 20519' , '6' ,  '-6' , '1' ,
                               '1.50' , '1.2295081967213' , '22' , '0' , '9.00' ) 
21/12/2023 10:23: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
                            ( '89623' , '15020' , 'PREGARE OGNI GIORNO' , '1' ,  '-1' , '4' ,
                               '1.00' , '1' , '0' , '0' , '1.00' ) 
21/12/2023 10:37:31 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886616898' AND id_product != '10299' AND ean13 != '' 
21/12/2023 10:37:31 am >> UPDATE ps_product SET
                  id_supplier = '38',
                  reference = 'ESPOSITORE SHALOM',
                  ean13 = '9788886616898',
                  date_upd = NOW()
                WHERE id_product = '10299' 
21/12/2023 10:37:31 am >> UPDATE ps_product_lang SET
                  name = 'STORIA DI UN\'ANIMA - 8203',
                  description = ''
                WHERE id_product = '10299' 
21/12/2023 10:37:31 am >> UPDATE ps_product SET
                  wholesale_price = '6.00',
                  on_sale = '0',
                  price = '12'
                WHERE id_product = '10299' 
21/12/2023 10:37:31 am >> UPDATE ps_product_shop SET
                  wholesale_price = '6.00',
                  price = '12',
                  id_tax_rules_group = '4',
                  id_category_default = '106',
                  id_argoment_default = '74',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '10299' 
21/12/2023 10:37:31 am >> DELETE FROM ps_specific_price WHERE id_product = '10299' 
21/12/2023 10:40:22 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 
21/12/2023 10:40:22 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22015' , '1' , '' , 'nuovo-prodotto' )
21/12/2023 10:40:22 am >> INSERT INTO ps_product_shop (
                      id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
                  ) VALUES (
                      '22015' , '1' , '1' , '2' , NOW() , NOW()
                  ) 
21/12/2023 10:40:22 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22015' , '0' , '1' , '0' , '0' )
21/12/2023 10:44:13 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048684' AND id_product != '22015' AND ean13 != '' 
21/12/2023 10:44:13 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = 'ESPOSITORE SHALOM',
                  ean13 = '9788884048684',
                  date_upd = NOW()
                WHERE id_product = '22015' 
21/12/2023 10:44:13 am >> UPDATE ps_product_lang SET
                  name = 'medjugorje - vera storia - 8953',
                  description = ''
                WHERE id_product = '22015' 
21/12/2023 10:44:13 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '9'
                WHERE id_product = '22015' 
21/12/2023 10:44:14 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '9',
                  id_tax_rules_group = '4',
                  id_category_default = '106',
                  id_argoment_default = '71',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '22015' 
21/12/2023 10:44:14 am >> DELETE FROM ps_specific_price WHERE id_product = '22015' 
21/12/2023 10:44:26 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048684' AND id_product != '22015' AND ean13 != '' 
21/12/2023 10:44:26 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = 'ESPOSITORE SHALOM',
                  ean13 = '9788884048684',
                  date_upd = NOW()
                WHERE id_product = '22015' 
21/12/2023 10:44:26 am >> UPDATE ps_product_lang SET
                  name = 'medjugorje - vera storia - 8953',
                  description = ''
                WHERE id_product = '22015' 
21/12/2023 10:44:26 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '9'
                WHERE id_product = '22015' 
21/12/2023 10:44:26 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '9',
                  id_tax_rules_group = '4',
                  id_category_default = '106',
                  id_argoment_default = '71',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '22015' 
21/12/2023 10:44:26 am >> DELETE FROM ps_specific_price WHERE id_product = '22015' 
21/12/2023 10:45:09 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048684' AND id_product != '22015' AND ean13 != '' 
21/12/2023 10:45:09 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = 'ESPOSITORE SHALOM',
                  ean13 = '9788884048684',
                  date_upd = NOW()
                WHERE id_product = '22015' 
21/12/2023 10:45:09 am >> UPDATE ps_product_lang SET
                  name = 'MEDJUGORJE VERA STORIA - 8593',
                  description = ''
                WHERE id_product = '22015' 
21/12/2023 10:45:09 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '9.0000'
                WHERE id_product = '22015' 
21/12/2023 10:45:09 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '9.0000',
                  id_tax_rules_group = '4',
                  id_category_default = '106',
                  id_argoment_default = '71',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '22015' 
21/12/2023 10:45:09 am >> DELETE FROM ps_specific_price WHERE id_product = '22015' 
21/12/2023 10:46: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  (
                          '31' ,
                          '20967/00/2023' ,
                          '2023-12-19' ,
                          '00' ,
                          '0' ,
                          '38' ,
                          '2633' ,
                          'VIA GALVANI, 1 60020 CAMERATA PICENA' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '6' ,
                          '0' ,
                          '213.60' ,
                          '211.44' ,
                          NOW() ,
                          NOW() ) 
21/12/2023 10:46: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 = '89624' 
21/12/2023 10:46:06 am >>  DELETE FROM ps_document_detail WHERE id_document = '89624' 
21/12/2023 10:46: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
                            ( '89624' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '60' ,  '60' , '4' ,
                               '5.00' , '5' , '0' , '40' , '180.0000' ) 
21/12/2023 10:46:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '21778' AND id_supplier = '38' 
21/12/2023 10:46:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21778' , '38' , '1' ) 
21/12/2023 10:46: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
                            ( '89624' , '9617' , 'SANTE PIAGHE DI NOSTRO SIGNORE GESÙ CRISTO - 8194' , '3' ,  '3' , '4' ,
                               '2.00' , '2' , '0' , '40' , '3.6000' ) 
21/12/2023 10:46:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '9617' AND id_supplier = '38' 
21/12/2023 10:46:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9617' , '38' , '1' ) 
21/12/2023 10:46: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
                            ( '89624' , '10299' , 'STORIA DI UNANIMA - 8203' , '1' ,  '1' , '4' ,
                               '12.00' , '12' , '0' , '40' , '7.2000' ) 
21/12/2023 10:46:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '10299' AND id_supplier = '38' 
21/12/2023 10:46:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10299' , '38' , '1' ) 
21/12/2023 10:46: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
                            ( '89624' , '22015' , 'MEDJUGORJE VERA STORIA - 8593' , '2' ,  '2' , '4' ,
                               '9.00' , '9' , '0' , '40' , '10.8000' ) 
21/12/2023 10:46:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '22015' AND id_supplier = '38' 
21/12/2023 10:46:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22015' , '38' , '1' ) 
21/12/2023 10:46: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
                            ( '89624' , '21653' , 'AGENDA DEVOZIONALE 2024' , '2' ,  '2' , '1' ,
                               '8.2' , '6.7213114754098' , '22' , '40' , '12.0048' ) 
21/12/2023 10:46:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '21653' AND id_supplier = '38' 
21/12/2023 10:46:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21653' , '38' , '1' ) 
21/12/2023 10:46:37 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '4081' AND id_document != '89600' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-20') 
21/12/2023 10:46:37 am >> UPDATE ps_document SET
                          id_document_type = '11',
                          document_num = '4081',
                          document_date = '2023-12-20',
                          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 = '21.80',
                          price_tax_excluded = '19.64',
                          date_upd = NOW()
                        WHERE id_document = '89600' 
21/12/2023 10:46:37 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 = '89600' 
21/12/2023 10:46:37 am >>  DELETE FROM ps_document_detail WHERE id_document = '89600' 
21/12/2023 10:46:37 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89600' , '11323' , 'VIA DELLAMORE - VINCENZO PAGLIA' , '1' ,  '-1' , '4' ,
                               '3.5000' , '3.5' , '0' , '0' , '3.50' ) 
21/12/2023 10:46:37 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89600' , '9815' , 'SEGNO DELLA CROCE' , '1' ,  '-1' , '4' ,
                               '1.5000' , '1.5' , '0' , '0' , '1.50' ) 
21/12/2023 10:46:37 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89600' , '9617' , 'SANTE PIAGHE DI NOSTRO SIGNORE GESÙ CRISTO - 8194' , '1' ,  '-1' , '4' ,
                               '1.8' , '1.8' , '0' , '0' , '1.80' ) 
21/12/2023 10:46:37 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89600' , '7202' , 'ARTICOLI RELIGIOSI' , '1' ,  '-1' , '1' ,
                               '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 
21/12/2023 10:46:37 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89600' , '20445' , 'MARIA GORETTI' , '1' ,  '-1' , '4' ,
                               '3.0000' , '3' , '0' , '0' , '3.00' ) 
21/12/2023 11:02:06 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '4103' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-21') 
21/12/2023 11:02:07 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' ,
                          '4103' ,
                          '2023-12-21' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '7.60' ,
                          '6.23' ,
                          NOW() ,
                          NOW() ) 
21/12/2023 11:02:07 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 = '89625' 
21/12/2023 11:02:07 am >>  DELETE FROM ps_document_detail WHERE id_document = '89625' 
21/12/2023 11:02:07 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89625' , '6872' , 'NASCITA DI GESÙ BAMBINO - 189' , '1' ,  '-1' , '1' ,
                               '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 
21/12/2023 11:02:07 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89625' , '17617' , 'IMMAGINI ISONZO X 100' , '1' ,  '-1' , '1' ,
                               '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 
21/12/2023 11:40:09 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '4104' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-21') 
21/12/2023 11:40:09 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' ,
                          '4104' ,
                          '2023-12-21' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '4.75' ,
                          '4.75' ,
                          NOW() ,
                          NOW() ) 
21/12/2023 11:40:09 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 = '89626' 
21/12/2023 11:40:09 am >>  DELETE FROM ps_document_detail WHERE id_document = '89626' 
21/12/2023 11:40:09 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89626' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '1' ,  '-1' , '4' ,
                               '5.00' , '5' , '0' , '5' , '4.75' ) 
21/12/2023 11:44:31 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 
21/12/2023 11:44:31 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22016' , '1' , '' , 'nuovo-prodotto' )
21/12/2023 11:44:31 am >> INSERT INTO ps_product_shop (
                      id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
                  ) VALUES (
                      '22016' , '1' , '1' , '2' , NOW() , NOW()
                  ) 
21/12/2023 11:44:31 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22016' , '0' , '1' , '0' , '0' )
21/12/2023 11:45:07 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788850256501' AND id_product != '22016' AND ean13 != '' 
21/12/2023 11:45:07 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '',
                  ean13 = '9788850256501',
                  date_upd = NOW()
                WHERE id_product = '22016' 
21/12/2023 11:45:07 am >> UPDATE ps_product_lang SET
                  name = 'COMANDANTE ALFA',
                  description = ''
                WHERE id_product = '22016' 
21/12/2023 11:45:07 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '12'
                WHERE id_product = '22016' 
21/12/2023 11:45:07 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '12',
                  id_tax_rules_group = '4',
                  id_category_default = '456',
                  id_argoment_default = '10',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '22016' 
21/12/2023 11:45:07 am >> DELETE FROM ps_specific_price WHERE id_product = '22016' 
21/12/2023 11:45:08 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 = '22016' 
21/12/2023 11:45:08 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22017' , '1' , '' , 'nuovo-prodotto' )
21/12/2023 11:45:08 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 '22017' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22016' 
21/12/2023 11:45:08 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '22017' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22016' 
21/12/2023 11:46:36 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791254781128' AND id_product != '22017' AND ean13 != '' 
21/12/2023 11:46:36 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '',
                  ean13 = '9791254781128',
                  date_upd = NOW()
                WHERE id_product = '22017' 
21/12/2023 11:46:36 am >> UPDATE ps_product_lang SET
                  name = 'UOMO DI DIO - A. SCHNEIDER',
                  description = ''
                WHERE id_product = '22017' 
21/12/2023 11:46:36 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '19'
                WHERE id_product = '22017' 
21/12/2023 11:46:36 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '19',
                  id_tax_rules_group = '4',
                  id_category_default = '100',
                  id_argoment_default = '36',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '22017' 
21/12/2023 11:46:36 am >> DELETE FROM ps_specific_price WHERE id_product = '22017' 
21/12/2023 11:46:39 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 = '22017' 
21/12/2023 11:46:39 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22018' , '1' , '' , 'nuovo-prodotto' )
21/12/2023 11:46:39 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 '22018' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22017' 
21/12/2023 11:46:39 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '22018' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22017' 
21/12/2023 11:47:59 am >> INSERT INTO ps_category ( id_parent , `date_add` , `date_upd` , level_depth ) VALUES ( '4' , NOW() , NOW() , '3' ) 
21/12/2023 11:47:59 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '537' , '1' )
21/12/2023 11:47:59 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '537' , '2' )
21/12/2023 11:47:59 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '537' , '3' )
21/12/2023 11:47:59 am >> INSERT INTO ps_category_lang ( id_category , id_lang , name , link_rewrite ) VALUES ( '537' , '1' , 'CAROCCI EDITORE' , LOWER('CAROCCI-EDITORE') )
21/12/2023 11:47:59 am >> INSERT INTO ps_category_shop ( id_category , id_shop , position ) VALUES ( '537' , '1' , '0' ) 
21/12/2023 11:48:06 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788829020058' AND id_product != '22018' AND ean13 != '' 
21/12/2023 11:48:06 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '',
                  ean13 = '9788829020058',
                  date_upd = NOW()
                WHERE id_product = '22018' 
21/12/2023 11:48:06 am >> UPDATE ps_product_lang SET
                  name = 'ANTICO TESTAMENTO INTRODUZIONE - B. EHRMAN',
                  description = ''
                WHERE id_product = '22018' 
21/12/2023 11:48:06 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '0.0000'
                WHERE id_product = '22018' 
21/12/2023 11:48:06 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '0.0000',
                  id_tax_rules_group = '4',
                  id_category_default = '537',
                  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 = '22018' 
21/12/2023 11:48:06 am >> DELETE FROM ps_specific_price WHERE id_product = '22018' 
21/12/2023 11:48:07 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 = '22018' 
21/12/2023 11:48:07 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22019' , '1' , '' , 'nuovo-prodotto' )
21/12/2023 11:48:07 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 '22019' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22018' 
21/12/2023 11:48:07 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '22019' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22018' 
21/12/2023 11:48:42 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788829020065' AND id_product != '22019' AND ean13 != '' 
21/12/2023 11:48:42 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '',
                  ean13 = '9788829020065',
                  date_upd = NOW()
                WHERE id_product = '22019' 
21/12/2023 11:48:42 am >> UPDATE ps_product_lang SET
                  name = 'NUOVO TESTAMENTO INTRODUZIONE - B. EHRMAN',
                  description = ''
                WHERE id_product = '22019' 
21/12/2023 11:48:42 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '24'
                WHERE id_product = '22019' 
21/12/2023 11:48:42 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '24',
                  id_tax_rules_group = '4',
                  id_category_default = '537',
                  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 = '22019' 
21/12/2023 11:48:42 am >> DELETE FROM ps_specific_price WHERE id_product = '22019' 
21/12/2023 11:48:43 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 = '22019' 
21/12/2023 11:48:43 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22020' , '1' , '' , 'nuovo-prodotto' )
21/12/2023 11:48:43 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 '22020' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22019' 
21/12/2023 11:48:43 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '22020' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22019' 
21/12/2023 11:51:07 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791254712344' AND id_product != '22020' AND ean13 != '' 
21/12/2023 11:51:07 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '5/5',
                  ean13 = '9791254712344',
                  date_upd = NOW()
                WHERE id_product = '22020' 
21/12/2023 11:51:07 am >> UPDATE ps_product_lang SET
                  name = 'STORIA DI FRANCESCO - G. NUCCI',
                  description = ''
                WHERE id_product = '22020' 
21/12/2023 11:51:07 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '18'
                WHERE id_product = '22020' 
21/12/2023 11:51:07 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '18',
                  id_tax_rules_group = '4',
                  id_category_default = '259',
                  id_argoment_default = '25',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '22020' 
21/12/2023 11:51:07 am >> DELETE FROM ps_specific_price WHERE id_product = '22020' 
21/12/2023 11:51:08 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 = '22020' 
21/12/2023 11:51:08 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22021' , '1' , '' , 'nuovo-prodotto' )
21/12/2023 11:51:08 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 '22021' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22020' 
21/12/2023 11:51:09 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '22021' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22020' 
21/12/2023 11:52:03 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788829020058' AND id_product != '22018' AND ean13 != '' 
21/12/2023 11:52:03 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '',
                  ean13 = '9788829020058',
                  date_upd = NOW()
                WHERE id_product = '22018' 
21/12/2023 11:52:03 am >> UPDATE ps_product_lang SET
                  name = 'ANTICO TESTAMENTO INTRODUZIONE - B. EHRMAN',
                  description = ''
                WHERE id_product = '22018' 
21/12/2023 11:52:04 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '18'
                WHERE id_product = '22018' 
21/12/2023 11:52:04 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '18',
                  id_tax_rules_group = '4',
                  id_category_default = '537',
                  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 = '22018' 
21/12/2023 11:52:04 am >> DELETE FROM ps_specific_price WHERE id_product = '22018' 
21/12/2023 11:56:18 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' ,
                          '01182520' ,
                          '2023-12-18' ,
                          '' ,
                          '0' ,
                          '109' ,
                          '4669106' ,
                          'VIA G. VERDI, 8 20090 ASSAGO' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '236.50' ,
                          '236.50' ,
                          NOW() ,
                          NOW() ) 
21/12/2023 11:56:18 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 = '89627' 
21/12/2023 11:56:18 am >>  DELETE FROM ps_document_detail WHERE id_document = '89627' 
21/12/2023 11:56:18 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89627' , '22020' , 'STORIA DI FRANCESCO - G. NUCCI' , '1' ,  '1' , '4' ,
                               '18.00' , '18' , '0' , '0' , '18.00' ) 
21/12/2023 11:56:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '22020' AND id_supplier = '109' 
21/12/2023 11:56:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22020' , '109' , '1' ) 
21/12/2023 11:56:18 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89627' , '21999' , 'PIU BELLA DEL MONDO' , '1' ,  '1' , '4' ,
                               '16.00' , '16' , '0' , '0' , '16.00' ) 
21/12/2023 11:56:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '21999' AND id_supplier = '109' 
21/12/2023 11:56:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21999' , '109' , '1' ) 
21/12/2023 11:56:18 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89627' , '22019' , 'NUOVO TESTAMENTO INTRODUZIONE - B. EHRMAN' , '1' ,  '1' , '4' ,
                               '24.00' , '24' , '0' , '0' , '24.00' ) 
21/12/2023 11:56:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '22019' AND id_supplier = '109' 
21/12/2023 11:56:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22019' , '109' , '1' ) 
21/12/2023 11:56:19 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89627' , '22018' , 'ANTICO TESTAMENTO INTRODUZIONE - B. EHRMAN' , '1' ,  '1' , '4' ,
                               '18.00' , '18' , '0' , '0' , '18.00' ) 
21/12/2023 11:56:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '22018' AND id_supplier = '109' 
21/12/2023 11:56:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22018' , '109' , '1' ) 
21/12/2023 11:56:19 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89627' , '5823' , 'LIBRO D\'ORO' , '50' ,  '50' , '4' ,
                               '0.60' , '0.6' , '0' , '0' , '30.0000' ) 
21/12/2023 11:56:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '5823' AND id_supplier = '109' 
21/12/2023 11:56:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5823' , '109' , '1' ) 
21/12/2023 11:56:19 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89627' , '21618' , 'TRASMETTERE LA FEDE - SALZANO/ACUTIS' , '1' ,  '1' , '4' ,
                               '14.00' , '14' , '0' , '0' , '14.00' ) 
21/12/2023 11:56:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '21618' AND id_supplier = '109' 
21/12/2023 11:56:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21618' , '109' , '1' ) 
21/12/2023 11:56:19 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89627' , '22000' , 'VENDETTA DELLE MUSE' , '1' ,  '1' , '4' ,
                               '18.00' , '18' , '0' , '0' , '18.00' ) 
21/12/2023 11:56:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '22000' AND id_supplier = '109' 
21/12/2023 11:56:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22000' , '109' , '1' ) 
21/12/2023 11:56:19 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89627' , '22016' , 'COMANDANTE ALFA' , '1' ,  '1' , '4' ,
                               '12.00' , '12' , '0' , '0' , '12.00' ) 
21/12/2023 11:56:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '22016' AND id_supplier = '109' 
21/12/2023 11:56:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22016' , '109' , '1' ) 
21/12/2023 11:56:19 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89627' , '22017' , 'UOMO DI DIO - A. SCHNEIDER' , '1' ,  '1' , '4' ,
                               '19.00' , '19' , '0' , '0' , '19.00' ) 
21/12/2023 11:56:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '22017' AND id_supplier = '109' 
21/12/2023 11:56:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22017' , '109' , '1' ) 
21/12/2023 11:56:19 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89627' , '21998' , 'VENTO SOFFIA DOVE VUOLE' , '1' ,  '1' , '4' ,
                               '17.00' , '17' , '0' , '0' , '17.00' ) 
21/12/2023 11:56:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '21998' AND id_supplier = '109' 
21/12/2023 11:56:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21998' , '109' , '1' ) 
21/12/2023 11:56:19 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89627' , '21997' , 'UNA GIORNATA PARTICOLARE' , '1' ,  '1' , '4' ,
                               '19.50' , '19.5' , '0' , '0' , '19.50' ) 
21/12/2023 11:56:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '21997' AND id_supplier = '109' 
21/12/2023 11:56:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21997' , '109' , '1' ) 
21/12/2023 11:56:19 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89627' , '12068' , 'VERA MISERICORDIA' , '1' ,  '1' , '4' ,
                               '6.00' , '6' , '0' , '0' , '6.00' ) 
21/12/2023 11:56:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '12068' AND id_supplier = '109' 
21/12/2023 11:56:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12068' , '109' , '1' ) 
21/12/2023 11:56:19 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89627' , '8314' , 'PREGHIERA QUOTIDIANA DI ISRAELE - L. CATTANI' , '1' ,  '1' , '4' ,
                               '25.00' , '25' , '0' , '0' , '25.00' ) 
21/12/2023 11:56:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '8314' AND id_supplier = '109' 
21/12/2023 11:56:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8314' , '109' , '1' ) 
21/12/2023 12:18:37 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '145/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-12-21') 
21/12/2023 12:18:37 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '24' ,
                          '145/A' ,
                          '2023-12-21' ,
                          'A' ,
                          '230' ,
                          '0' ,
                          '4668969' ,
                          'VIA G. NICOTERA, 66 84080 PELLEZZANO' ,
                          '' ,
                          'ACCONTO € 150' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '350.00' ,
                          '350.00' ,
                          NOW() ,
                          NOW() ) 
21/12/2023 12:18:37 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89628' 
21/12/2023 12:18:37 pm >>  DELETE FROM ps_document_detail WHERE id_document = '89628' 
21/12/2023 12:18:37 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89628' , '' , 'PRESEPE ANTICO' , '1' ,  '-1' , '0' ,
                               '350' , '350' , '' , '0' , '350.00' ) 
21/12/2023 12:24:26 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '4105' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-21') 
21/12/2023 12:24:26 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '4105' ,
                          '2023-12-21' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '53.00' ,
                          '43.44' ,
                          NOW() ,
                          NOW() ) 
21/12/2023 12:24:26 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89629' 
21/12/2023 12:24:26 pm >>  DELETE FROM ps_document_detail WHERE id_document = '89629' 
21/12/2023 12:24:26 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89629' , '21864' , 'BAMBINELLO CM 30 - PKS30-C' , '1' ,  '-1' , '1' ,
                               '53.00' , '43.44262295082' , '22' , '0' , '53.00' ) 
21/12/2023 12:41:11 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '138/A' AND id_document != '89312' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-12-04') 
21/12/2023 12:41:11 pm >> UPDATE ps_document SET
                          id_document_type = '24',
                          document_num = '138/A',
                          document_date = '2023-12-04',
                          document_letter = 'A',
                          id_customer = '4074',
                          id_supplier = '0',
                          id_address = '4679229',
                          address1 = 'OGLIARA 84100 OGLIARA',
                          address2 = '',
                          note = 'ACCONTO € 250 IN 7 ASSEGNI TOTALE € 1750 RESTA A SALDO € 550',
                          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 = '2300.00',
                          price_tax_excluded = '1885.25',
                          date_upd = NOW()
                        WHERE id_document = '89312' 
21/12/2023 12:41:11 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 = '89312' 
21/12/2023 12:41:11 pm >>  DELETE FROM ps_document_detail WHERE id_document = '89312' 
21/12/2023 12:41:11 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89312' , '20863' , 'CASULA ACETATO/VISCOSA - 65/19246' , '2' ,  '-2' , '1' ,
                               '1150.0000' , '942.62295081967' , '22' , '0' , '2300.00' ) 
21/12/2023 12:41:32 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '91/A' AND id_document != '87349' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-09-19') 
21/12/2023 12:41:32 pm >> UPDATE ps_document SET
                          id_document_type = '24',
                          document_num = '91/A',
                          document_date = '2023-09-19',
                          document_letter = 'A',
                          id_customer = '3892',
                          id_supplier = '0',
                          id_address = '4679228',
                          address1 = 'OGLIARA 84100 OGLIARA',
                          address2 = '',
                          note = 'ACCONTO € 220, 00 - € 150+ €240',
                          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 = '3800.00',
                          price_tax_excluded = '3114.75',
                          date_upd = NOW()
                        WHERE id_document = '87349' 
21/12/2023 12:41: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 = '87349' 
21/12/2023 12:41:32 pm >>  DELETE FROM ps_document_detail WHERE id_document = '87349' 
21/12/2023 12:41: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
                            ( '87349' , '20852' , 'CALICE OTTONE IN FUSIONE ARGENTATA - 099A' , '1' ,  '0' , '1' ,
                               '1495.0000' , '1225.4098360656' , '22' , '0' , '1495.00' ) 
21/12/2023 12:41: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
                            ( '87349' , '19848' , 'PATENA CON GRECA CM 19 - 999/7 A' , '1' ,  '0' , '1' ,
                               '110.0000' , '90.16393442623' , '22' , '0' , '110.00' ) 
21/12/2023 12:41: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
                            ( '87349' , '0' , 'PALLA MARIANA - 50/372' , '1' ,  '0' , '1' ,
                               '250.0000' , '204.91803278689' , '22' , '0' , '250.00' ) 
21/12/2023 12:41: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
                            ( '87349' , '19709' , 'COMPLETO MESSA LINO - 30/108' , '1' ,  '0' , '1' ,
                               '305.0000' , '250' , '22' , '0' , '305.00' ) 
21/12/2023 12:41: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
                            ( '87349' , '8166' , 'PORTACALICE - 18X35 - 726' , '1' ,  '0' , '1' ,
                               '20.0000' , '16.393442622951' , '22' , '0' , '20.00' ) 
21/12/2023 12:41: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
                            ( '87349' , '0' , 'PISSIDE 099PA' , '1' ,  '0' , '1' ,
                               '1600.0000' , '1311.4754098361' , '22' , '0' , '1600.00' ) 
21/12/2023 12:41: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
                            ( '87349' , '18349' , 'PORTACALICE - 18X28 - 720' , '1' ,  '0' , '1' ,
                               '20.0000' , '16.393442622951' , '22' , '0' , '20.00' ) 
21/12/2023 12:53:13 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '4106' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-21') 
21/12/2023 12:53: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' ,
                          '4106' ,
                          '2023-12-21' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '120.00' ,
                          '98.36' ,
                          NOW() ,
                          NOW() ) 
21/12/2023 12:53: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 = '89630' 
21/12/2023 12:53:13 pm >>  DELETE FROM ps_document_detail WHERE id_document = '89630' 
21/12/2023 12:53: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
                            ( '89630' , '13078' , 'LEGGIO IN LEGNO - 043' , '1' ,  '-1' , '1' ,
                               '120.00' , '98.360655737705' , '22' , '0' , '120.00' ) 
21/12/2023 03:31:47 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '4107' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-21') 
21/12/2023 03:31:47 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '4107' ,
                          '2023-12-21' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '50.90' ,
                          '49.30' ,
                          NOW() ,
                          NOW() ) 
21/12/2023 03:31:47 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89631' 
21/12/2023 03:31:47 pm >>  DELETE FROM ps_document_detail WHERE id_document = '89631' 
21/12/2023 03:31:47 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89631' , '21524' , 'LIBRO AGENDA CATTOLICO 2024' , '3' ,  '-3' , '4' ,
                               '14' , '14' , '0' , '0' , '42.00' ) 
21/12/2023 03:31:47 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89631' , '17872' , 'GIGLER PER LUMINELLO - 474/G' , '2' ,  '-2' , '1' ,
                               '3.90' , '3.1967213114754' , '22' , '0' , '7.80' ) 
21/12/2023 03:31:47 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89631' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' ,  '-1' , '1' ,
                               '1.10' , '0.9016393442623' , '22' , '0' , '1.10' ) 
21/12/2023 03:39:09 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '106/A' AND id_document != '88284' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-13') 
21/12/2023 03:39:09 pm >> UPDATE ps_document SET
                          id_document_type = '24',
                          document_num = '106/A',
                          document_date = '2023-10-13',
                          document_letter = 'A',
                          id_customer = '1656',
                          id_supplier = '',
                          id_address = '4677544',
                          address1 = 'VIA NAZIONALE 84060 OMIGNANO SCALO',
                          address2 = '',
                          note = 'RESTANO 83.30',
                          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 = '96.24',
                          price_tax_excluded = '96.24',
                          date_upd = NOW()
                        WHERE id_document = '88284' 
21/12/2023 03:39:09 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 = '88284' 
21/12/2023 03:39:09 pm >>  DELETE FROM ps_document_detail WHERE id_document = '88284' 
21/12/2023 03:39:09 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88284' , '4154' , 'FESTA DEL PERDONO' , '31' ,  '-31' , '4' ,
                               '3.0000' , '3' , '0' , '15' , '79.05' ) 
21/12/2023 03:39:09 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88284' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' ,  '-1' , '4' ,
                               '5.0000' , '5' , '0' , '15' , '4.25' ) 
21/12/2023 03:39:09 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88284' , '4154' , 'FESTA DEL PERDONO' , '1' ,  '-1' , '4' ,
                               '3.00' , '3' , '0' , '15' , '2.55' ) 
21/12/2023 03:39:09 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88284' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '1' ,  '-1' , '4' ,
                               '3.40' , '3.4' , '0' , '15' , '2.89' ) 
21/12/2023 03:39:09 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88284' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '15' ,  '-15' , '0' ,
                               '0.50' , '0.5' , '' , '0' , '7.50' ) 
21/12/2023 04:03:57 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '4108' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-21') 
21/12/2023 04:03:57 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' ,
                          '4108' ,
                          '2023-12-21' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '4.00' ,
                          '3.85' ,
                          NOW() ,
                          NOW() ) 
21/12/2023 04:03:57 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 = '89632' 
21/12/2023 04:03:57 pm >>  DELETE FROM ps_document_detail WHERE id_document = '89632' 
21/12/2023 04:03:57 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89632' , '7311' , 'OSTIA SOTTILE 74MM' , '2' ,  '-2' , '3' ,
                               '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 
21/12/2023 05:45:51 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '4109' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-21') 
21/12/2023 05:45:51 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' ,
                          '4109' ,
                          '2023-12-21' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '9.50' ,
                          '7.79' ,
                          NOW() ,
                          NOW() ) 
21/12/2023 05:45:51 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 = '89633' 
21/12/2023 05:45:51 pm >>  DELETE FROM ps_document_detail WHERE id_document = '89633' 
21/12/2023 05:45:51 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89633' , '21653' , 'AGENDA DEVOZIONALE 2024' , '1' ,  '-1' , '1' ,
                               '10.00' , '8.1967213114754' , '22' , '5' , '9.50' ) 
21/12/2023 05:53:46 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '4110' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-21') 
21/12/2023 05:53:46 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '4110' ,
                          '2023-12-21' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '27.00' ,
                          '22.13' ,
                          NOW() ,
                          NOW() ) 
21/12/2023 05:53:46 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89634' 
21/12/2023 05:53:46 pm >>  DELETE FROM ps_document_detail WHERE id_document = '89634' 
21/12/2023 05:53: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
                            ( '89634' , '20705' , 'CANDELA CUBO' , '2' ,  '-2' , '1' ,
                               '13.50' , '11.065573770492' , '22' , '0' , '27.00' ) 
21/12/2023 06:00:12 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '4111' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-21') 
21/12/2023 06:00:12 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '4111' ,
                          '2023-12-21' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '65.55' ,
                          '65.55' ,
                          NOW() ,
                          NOW() ) 
21/12/2023 06:00:12 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89635' 
21/12/2023 06:00:12 pm >>  DELETE FROM ps_document_detail WHERE id_document = '89635' 
21/12/2023 06:00:12 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89635' , '8314' , 'PREGHIERA QUOTIDIANA DI ISRAELE - L. CATTANI' , '1' ,  '-1' , '4' ,
                               '25.00' , '25' , '0' , '5' , '23.75' ) 
21/12/2023 06:00:12 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89635' , '12068' , 'VERA MISERICORDIA' , '1' ,  '-1' , '4' ,
                               '6.00' , '6' , '0' , '5' , '5.70' ) 
21/12/2023 06:00:12 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89635' , '5891' , 'LITURGIA DELLE ORE I -  FRANCESCANA' , '1' ,  '-1' , '4' ,
                               '38.00' , '38' , '0' , '5' , '36.10' ) 
21/12/2023 06:48:59 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '4112' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-21') 
21/12/2023 06:48:59 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' ,
                          '4112' ,
                          '2023-12-21' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '25.00' ,
                          '20.49' ,
                          NOW() ,
                          NOW() ) 
21/12/2023 06:48:59 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 = '89636' 
21/12/2023 06:48:59 pm >>  DELETE FROM ps_document_detail WHERE id_document = '89636' 
21/12/2023 06:48:59 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89636' , '19859' , 'CINGOLO - CING 29' , '1' ,  '-1' , '1' ,
                               '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 
21/12/2023 07:03:20 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '3944' AND id_document != '89436' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-12') 
21/12/2023 07:03:20 pm >> UPDATE ps_document SET
                          id_document_type = '11',
                          document_num = '3944',
                          document_date = '2023-12-12',
                          document_letter = '',
                          id_customer = '0',
                          id_supplier = '',
                          id_address = '0',
                          address1 = 'VIA TORRIONE 84100 SALERNO',
                          address2 = '',
                          note = '',
                          price_shipping = '0.00',
                          id_tax_shipping_rules = '4',
                          colli = '0',
                          peso = '0',
                          porto_e_imballo = '0',
                          mezzo_consegna = '',
                          id_payment = '0',
                          id_causal = '0',
                          price_tax_included = '161.44',
                          price_tax_excluded = '155.67',
                          date_upd = NOW()
                        WHERE id_document = '89436' 
21/12/2023 07:03:20 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89436' 
21/12/2023 07:03:20 pm >>  DELETE FROM ps_document_detail WHERE id_document = '89436' 
21/12/2023 07:03:20 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89436' , '13322' , 'IMMAGINI 70X100 GESU\' MISERICORDIOSO' , '1' ,  '-1' , '1' ,
                               '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 
21/12/2023 07:03:20 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89436' , '19742' , 'ENCICLICHE SOCIALI' , '1' ,  '-1' , '4' ,
                               '49.0000' , '49' , '0' , '5' , '46.55' ) 
21/12/2023 07:03:20 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89436' , '3978' , 'EUCARISTIA: RITO E VITA' , '1' ,  '-1' , '4' ,
                               '10.0000' , '10' , '0' , '5' , '9.50' ) 
21/12/2023 07:03:20 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89436' , '3419' , 'DIARIO LA MISERICORDIA DIVINA - S. FAUSTINA K.' , '1' ,  '-1' , '4' ,
                               '13.0000' , '13' , '0' , '5' , '12.35' ) 
21/12/2023 07:03:20 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89436' , '18047' , 'CUSTODIA LITURGIA DELLE ORE 4 VOL ECO PELLE - L100E' , '1' ,  '-1' , '1' ,
                               '19.0000' , '15.573770491803' , '22' , '0' , '19.00' ) 
21/12/2023 07:03:20 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89436' , '21166' , 'ENCICLICHE SOCIALI ' , '1' ,  '-1' , '4' ,
                               '26.0000' , '26' , '0' , '5' , '24.70' ) 
21/12/2023 07:03:20 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89436' , '13780' , 'RISCOPRIAMO LA BELLEZZA DEL BATTESIMO' , '1' ,  '-1' , '4' ,
                               '5.0000' , '5' , '0' , '5' , '4.75' ) 
21/12/2023 07:03:20 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89436' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' ,  '-1' , '4' ,
                               '6.0000' , '6' , '0' , '15' , '5.10' ) 
21/12/2023 07:03:20 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89436' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '1' ,  '-1' , '4' ,
                               '5.0000' , '5' , '0' , '15' , '4.25' ) 
21/12/2023 07:03:20 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89436' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' ,  '-1' , '4' ,
                               '5.0000' , '5' , '0' , '15' , '4.25' ) 
21/12/2023 07:03:20 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89436' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' ,  '-1' , '4' ,
                               '5.0000' , '5' , '0' , '15' , '4.25' ) 
21/12/2023 07:03:21 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89436' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '1' ,  '-1' , '4' ,
                               '3.4000' , '3.4' , '0' , '15' , '2.89' ) 
21/12/2023 07:03:21 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89436' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '1' ,  '-1' , '4' ,
                               '3.5000' , '3.5' , '0' , '15' , '2.98' ) 
21/12/2023 07:03:21 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89436' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '1' ,  '-1' , '4' ,
                               '3.4000' , '3.4' , '0' , '15' , '2.89' ) 
21/12/2023 07:03:21 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89436' , '2679' , 'CONOSCERE GESU' , '1' ,  '-1' , '4' ,
                               '3.5000' , '3.5' , '0' , '15' , '2.98' ) 
21/12/2023 07:03:21 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89436' , '2765' , 'CORONA FRANCESCANA' , '1' ,  '-1' , '4' ,
                               '2.0000' , '2' , '0' , '0' , '2.00' ) 
21/12/2023 07:03:21 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '89436' , '19786' , 'ROSARIO MADREPERLA MM5 - 10M5' , '1' ,  '-1' , '1' ,
                               '7' , '5.7377049180328' , '22' , '0' , '7.00' ) 
21/12/2023 07:31:55 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '145/A' AND id_document != '89628' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-12-21') 
21/12/2023 07:31:55 pm >> UPDATE ps_document SET
                          id_document_type = '24',
                          document_num = '145/A',
                          document_date = '2023-12-21',
                          document_letter = 'A',
                          id_customer = '230',
                          id_supplier = '',
                          id_address = '4668969',
                          address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO',
                          address2 = '',
                          note = 'ACCONTO € 150',
                          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 = '495.00',
                          price_tax_excluded = '495.00',
                          date_upd = NOW()
                        WHERE id_document = '89628' 
21/12/2023 07:31: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 = '89628' 
21/12/2023 07:31:55 pm >>  DELETE FROM ps_document_detail WHERE id_document = '89628' 
21/12/2023 07:31: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
                            ( '89628' , '0' , 'PRESEPE ANTICO' , '1' ,  '-1' , '0' ,
                               '350.0000' , '350' , '0' , '0' , '350.00' ) 
21/12/2023 07:31: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
                            ( '89628' , '' , 'CAMPANA IN VETRO' , '1' ,  '-1' , '0' ,
                               '145' , '145' , '' , '0' , '145.00' )