20/11/2024 09:03:14 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256450299' AND id_product != '23206' AND ean13 != '' 
20/11/2024 09:03:14 am >> UPDATE ps_product SET
                  id_supplier = '7',
                  reference = 'GONDOLA 2',
                  ean13 = '9791256450299',
                  date_upd = NOW()
                WHERE id_product = '23206' 
20/11/2024 09:03:14 am >> UPDATE ps_product_lang SET
                  name = 'GIUBILEO DELLA SPERANZA - U. TERRINONI',
                  description = ''
                WHERE id_product = '23206' 
20/11/2024 09:03:14 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '10.0000'
                WHERE id_product = '23206' 
20/11/2024 09:03:14 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '10.0000',
                  id_tax_rules_group = '4',
                  id_category_default = '518',
                  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 = '23206' 
20/11/2024 09:03:14 am >> DELETE FROM ps_specific_price WHERE id_product = '23206' 
20/11/2024 09:12:24 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '3532' AND id_document != '94337' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 
20/11/2024 09:12:24 am >> UPDATE ps_document SET
                          id_document_type = '11',
                          document_num = '3532',
                          document_date = '2024-11-19',
                          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 = '139.42',
                          price_tax_excluded = '121.84',
                          date_upd = NOW()
                        WHERE id_document = '94337' 
20/11/2024 09:12:24 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 = '94337' 
20/11/2024 09:12:24 am >>  DELETE FROM ps_document_detail WHERE id_document = '94337' 
20/11/2024 09:12: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
                            ( '94337' , '18898' , 'BRACCIALE DECINA LEGNO - BC1745' , '46' ,  '-46' , '1' ,
                               '1.6000' , '1.3114754098361' , '22' , '0' , '73.60' ) 
20/11/2024 09:12: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
                            ( '94337' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '6' ,  '-6' , '1' ,
                               '1.6000' , '1.3114754098361' , '22' , '0' , '9.60' ) 
20/11/2024 09:12: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
                            ( '94337' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '2' ,  '-2' , '4' ,
                               '3.8000' , '3.8' , '0' , '5' , '7.22' ) 
20/11/2024 09:12: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
                            ( '94337' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '2' ,  '-2' , '4' ,
                               '10.0000' , '10' , '0' , '5' , '19.00' ) 
20/11/2024 09:12: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
                            ( '94337' , '7938' , 'PERGAMENE - MATRIMONIO-B' , '20' ,  '-20' , '1' ,
                               '0.5000' , '0.40983606557377' , '22' , '0' , '10.00' ) 
20/11/2024 09:12: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
                            ( '94337' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' ,  '-10' , '3' ,
                               '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 
20/11/2024 09:22:44 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886616157' AND id_product != '10712' AND ean13 != '' 
20/11/2024 09:22:44 am >> UPDATE ps_product SET
                  id_supplier = '38',
                  reference = 'ESPOSITORE SHALOM',
                  ean13 = '9788886616157',
                  date_upd = NOW()
                WHERE id_product = '10712' 
20/11/2024 09:22:44 am >> UPDATE ps_product_lang SET
                  name = 'TRATTATO DELLA VERA DEVOZIONE A MARIA - 8113',
                  description = ''
                WHERE id_product = '10712' 
20/11/2024 09:22:44 am >> UPDATE ps_product SET
                  wholesale_price = '5.40',
                  on_sale = '0',
                  price = '10'
                WHERE id_product = '10712' 
20/11/2024 09:22:44 am >> UPDATE ps_product_shop SET
                  wholesale_price = '5.40',
                  price = '10',
                  id_tax_rules_group = '4',
                  id_category_default = '106',
                  id_argoment_default = '73',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '10712' 
20/11/2024 09:22:44 am >> DELETE FROM ps_specific_price WHERE id_product = '10712' 
20/11/2024 09:36:39 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '3555' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-20') 
20/11/2024 09:36:39 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' ,
                          '3555' ,
                          '2024-11-20' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '75.20' ,
                          '64.31' ,
                          NOW() ,
                          NOW() ) 
20/11/2024 09:36:39 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 = '94367' 
20/11/2024 09:36:39 am >>  DELETE FROM ps_document_detail WHERE id_document = '94367' 
20/11/2024 09:36:39 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94367' , '1914' , 'CERA DELLA LITURGIA' , '12' ,  '-12' , '1' ,
                               '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 
20/11/2024 09:36:39 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94367' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' ,  '-3' , '3' ,
                               '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 
20/11/2024 09:36:39 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94367' , '7311' , 'OSTIA SOTTILE 74MM' , '2' ,  '-2' , '3' ,
                               '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 
20/11/2024 09:36:39 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94367' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' ,  '-1' , '3' ,
                               '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 
20/11/2024 09:41:47 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '3556' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-20') 
20/11/2024 09:41:47 am >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '3556' ,
                          '2024-11-20' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '57.00' ,
                          '57.00' ,
                          NOW() ,
                          NOW() ) 
20/11/2024 09:41:47 am >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94368' 
20/11/2024 09:41:47 am >>  DELETE FROM ps_document_detail WHERE id_document = '94368' 
20/11/2024 09:41:47 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94368' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '12' ,  '-12' , '4' ,
                               '5.00' , '5' , '0' , '5' , '57.00' ) 
20/11/2024 09:53:58 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '126/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-11-20') 
20/11/2024 09:53:58 am >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '24' ,
                          '126/A' ,
                          '2024-11-20' ,
                          'A' ,
                          '292' ,
                          '0' ,
                          '4676365' ,
                          'VIA IONIO 8/A 84091 BATTIPAGLIA' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '405.80' ,
                          '405.80' ,
                          NOW() ,
                          NOW() ) 
20/11/2024 09:53:58 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 = '94369' 
20/11/2024 09:53:58 am >>  DELETE FROM ps_document_detail WHERE id_document = '94369' 
20/11/2024 09:53:58 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94369' , '22804' , 'PANE E VINO - N.E. - SUSSIDIO' , '10' ,  '-10' , '4' ,
                               '4.5' , '4.5' , '0' , '0' , '45.00' ) 
20/11/2024 09:53:58 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94369' , '21437' , 'IMPRONTE DI MISERICORDIA - CALENDALBUM 2 - N.E.' , '5' ,  '-5' , '4' ,
                               '4.5' , '4.5' , '0' , '0' , '22.50' ) 
20/11/2024 09:53:58 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94369' , '21436' , 'MIA IMPRONTA NELLA TUA - CALENDALBUM 1 - N.E.' , '5' ,  '-5' , '4' ,
                               '4.5' , '4.5' , '0' , '0' , '22.50' ) 
20/11/2024 09:53:58 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94369' , '15927' , 'COMUNITA’ SEGNI DI BELLEZZA - 4 GUIDA' , '1' ,  '-1' , '4' ,
                               '13.5' , '13.5' , '0' , '0' , '13.50' ) 
20/11/2024 09:53:58 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94369' , '22803' , 'PANE E VINO - N.E. - GUIDA 3' , '1' ,  '-1' , '4' ,
                               '13.5' , '13.5' , '0' , '0' , '13.50' ) 
20/11/2024 09:53:58 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94369' , '21484' , 'MIA IMPRONTA NELLA TUA - GUIDA 1 - N.E.' , '2' ,  '-2' , '4' ,
                               '13.5' , '13.5' , '0' , '0' , '27.00' ) 
20/11/2024 09:53:58 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94369' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '110' ,  '-110' , '4' ,
                               '2.80' , '2.8' , '0' , '15' , '261.80' ) 
20/11/2024 10:36:34 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '33' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2024-11-20') 
20/11/2024 10:36:34 am >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '24' ,
                          '33' ,
                          '2024-11-20' ,
                          '' ,
                          '3000' ,
                          '0' ,
                          '4669629' ,
                          'VIA DEI CASTANI, 116 00172 ROMA' ,
                          '' ,
                          'EDIZIONI' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '3' ,
                          '16454.00' ,
                          '16454.00' ,
                          NOW() ,
                          NOW() ) 
20/11/2024 10:36:34 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 = '94370' 
20/11/2024 10:36:34 am >>  DELETE FROM ps_document_detail WHERE id_document = '94370' 
20/11/2024 10:36:34 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94370' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '360' ,  '-360' , '4' ,
                               '2.40' , '2.4' , '0' , '0' , '864.00' ) 
20/11/2024 10:36: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
                            ( '94370' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '200' ,  '-200' , '4' ,
                               '3.40' , '3.4' , '0' , '0' , '680.00' ) 
20/11/2024 10:36: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
                            ( '94370' , '8408' , 'PRENDETE E MANGIATE' , '400' ,  '-400' , '4' ,
                               '3.00' , '3' , '0' , '0' , '1200.00' ) 
20/11/2024 10:36: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
                            ( '94370' , '4154' , 'FESTA DEL PERDONO' , '400' ,  '-400' , '4' ,
                               '3.00' , '3' , '0' , '0' , '1200.00' ) 
20/11/2024 10:36: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
                            ( '94370' , '2679' , 'CONOSCERE GESU\'' , '400' ,  '-400' , '4' ,
                               '3.50' , '3.5' , '0' , '0' , '1400.00' ) 
20/11/2024 10:36: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
                            ( '94370' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '500' ,  '-500' , '4' ,
                               '1.90' , '1.9' , '0' , '0' , '950.00' ) 
20/11/2024 10:36: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
                            ( '94370' , '12813' , 'MARIA MADRE NOSTRA' , '120' ,  '-120' , '4' ,
                               '3.00' , '3' , '0' , '0' , '360.00' ) 
20/11/2024 10:36: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
                            ( '94370' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1750' ,  '-1750' , '4' ,
                               '2.80' , '2.8' , '0' , '0' , '4900.00' ) 
20/11/2024 10:36: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
                            ( '94370' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1750' ,  '-1750' , '4' ,
                               '2.80' , '2.8' , '0' , '0' , '4900.00' ) 
20/11/2024 10:42:55 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '3557' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-20') 
20/11/2024 10:42:55 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' ,
                          '3557' ,
                          '2024-11-20' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '4.30' ,
                          '4.13' ,
                          NOW() ,
                          NOW() ) 
20/11/2024 10:42:55 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 = '94371' 
20/11/2024 10:42:55 am >>  DELETE FROM ps_document_detail WHERE id_document = '94371' 
20/11/2024 10:42:55 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94371' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' ,  '-1' , '3' ,
                               '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 
20/11/2024 10:48:24 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '55/E' AND id_document != '94348' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-11-19') 
20/11/2024 10:48:25 am >> UPDATE ps_document SET
                          id_document_type = '23',
                          document_num = '55/E',
                          document_date = '2024-11-19',
                          document_letter = 'E',
                          id_customer = '189',
                          id_supplier = '',
                          id_address = '4679063',
                          address1 = 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE',
                          address2 = '',
                          note = '',
                          price_shipping = '',
                          id_tax_shipping_rules = '4',
                          colli = '0',
                          peso = '0',
                          porto_e_imballo = '0',
                          mezzo_consegna = '',
                          id_payment = '3',
                          id_causal = '0',
                          price_tax_included = '282.00',
                          price_tax_excluded = '282.00',
                          date_upd = NOW()
                        WHERE id_document = '94348' 
20/11/2024 10:48: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 = '94348' 
20/11/2024 10:48:25 am >>  DELETE FROM ps_document_detail WHERE id_document = '94348' 
20/11/2024 10:48: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
                            ( '94348' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '70' ,  '-70' , '4' ,
                               '3.4000' , '3.4' , '0' , '38' , '147.56' ) 
20/11/2024 10:48: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
                            ( '94348' , '11191' , 'VENITE CON ME 1 PARTE' , '70' ,  '-70' , '4' ,
                               '2.8000' , '2.8' , '0' , '38' , '121.52' ) 
20/11/2024 10:48: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
                            ( '94348' , '10133' , 'SPESE DI TRASPORTO' , '1' ,  '-1' , '4' ,
                               '12.92' , '12.92' , '0' , '0' , '12.92' ) 
20/11/2024 11:03:22 am >> UPDATE ps_document SET
                          id_document_type = '31',
                          document_num = '1115/EL',
                          document_date = '2024-11-14',
                          document_letter = 'EL',
                          id_customer = '0',
                          id_supplier = '',
                          id_address = '4679060',
                          address1 = 'CONTRADA MANCA snc 89040 CIRELLA ',
                          address2 = '',
                          note = '',
                          price_shipping = '-0.485',
                          id_tax_shipping_rules = '1',
                          colli = '0',
                          peso = '0',
                          porto_e_imballo = '0',
                          mezzo_consegna = '',
                          id_payment = '9',
                          id_causal = '0',
                          price_tax_included = '1143.28',
                          price_tax_excluded = '938.58',
                          date_upd = NOW()
                        WHERE id_document = '94346' 
20/11/2024 11:03:23 am >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94346' 
20/11/2024 11:03:23 am >>  DELETE FROM ps_document_detail WHERE id_document = '94346' 
20/11/2024 11:03:23 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94346' , '21376' , 'CASULA POL. LEGGERO - CS25L' , '8' ,  '8' , '1' ,
                               '33.0000' , '27.049180327869' , '22' , '3' , '312.42' ) 
20/11/2024 11:03:23 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94346' , '23223' , 'COPRILEGGIO - CL10' , '4' ,  '4' , '1' ,
                               '22.0000' , '18.032786885246' , '22' , '3' , '104.14' ) 
20/11/2024 11:03:23 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94346' , '23224' , 'STOLA MARIANA - ST07' , '1' ,  '1' , '1' ,
                               '33.0000' , '27.049180327869' , '22' , '3' , '39.05' ) 
20/11/2024 11:03:23 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94346' , '23225' , 'STOLA MARIANA - ST08' , '1' ,  '1' , '1' ,
                               '49.5000' , '40.573770491803' , '22' , '3' , '58.58' ) 
20/11/2024 11:03:23 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94346' , '23226' , 'STOLA GIUBILEO RICAMATA - ST15GBR' , '4' ,  '4' , '1' ,
                               '14.0000' , '11.475409836066' , '22' , '10' , '61.49' ) 
20/11/2024 11:03:23 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94346' , '23228' , 'CASULA GIUBILEO RICAMATA - CS64' , '2' ,  '2' , '1' ,
                               '28.0000' , '22.950819672131' , '22' , '10' , '61.49' ) 
20/11/2024 11:03:23 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94346' , '23229' , 'COPRILEGGIO GIUBILEO RICAMATO - CL18GBR' , '1' ,  '1' , '1' ,
                               '23.0000' , '18.852459016393' , '22' , '10' , '25.25' ) 
20/11/2024 11:03:23 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94346' , '23227' , 'STOLA GIUBILEO STAMPATA - ST16GBR' , '4' ,  '4' , '1' ,
                               '10.0000' , '8.1967213114754' , '22' , '10' , '43.92' ) 
20/11/2024 11:03:23 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94346' , '23230' , 'COPRILEGGIO GIUBILEO STAMPATO - CL19GBS' , '1' ,  '1' , '1' ,
                               '18.0000' , '14.754098360656' , '22' , '10' , '19.76' ) 
20/11/2024 11:03:23 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94346' , '23231' , 'CLERGY MISTO ML' , '32' ,  '32' , '1' ,
                               '9.9000' , '8.1147540983607' , '22' , '' , '386.4960' ) 
20/11/2024 11:03:23 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94346' , '10133' , 'SPESE DI TRASPORTO' , '1' ,  '1' , '1' ,
                               '17.2000' , '14.098360655738' , '22' , '0' , '20.98' ) 
20/11/2024 11:03:23 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94346' , '23231' , 'CLERGY MISTO ML' , '1' ,  '1' , '3' ,
                               '9.9' , '9.5192307692308' , '4' , '0' , '10.2960' ) 
20/11/2024 11:06:21 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '125/A' AND id_document != '94315' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-11-18') 
20/11/2024 11:06:21 am >> UPDATE ps_document SET
                          id_document_type = '24',
                          document_num = '125/A',
                          document_date = '2024-11-18',
                          document_letter = 'A',
                          id_customer = '333',
                          id_supplier = '',
                          id_address = '4671072',
                          address1 = 'P.ZZA S. MICHELE 84135 RUFOLI',
                          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 = '114.50',
                          price_tax_excluded = '95.24',
                          date_upd = NOW()
                        WHERE id_document = '94315' 
20/11/2024 11:06:21 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 = '94315' 
20/11/2024 11:06:21 am >>  DELETE FROM ps_document_detail WHERE id_document = '94315' 
20/11/2024 11:06:21 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94315' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' ,  '-1' , '3' ,
                               '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 
20/11/2024 11:06:21 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94315' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' ,  '-1' , '3' ,
                               '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 
20/11/2024 11:06:21 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94315' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' ,  '-1' , '3' ,
                               '4.3000' , '4.1346153846154' , '4' , '0' , '4.30' ) 
20/11/2024 11:06:21 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94315' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' ,  '-30' , '1' ,
                               '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 
20/11/2024 11:06:21 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94315' , '1914' , 'CERA DELLA LITURGIA' , '3' ,  '-3' , '1' ,
                               '4.90' , '4.016393442623' , '22' , '0' , '14.70' ) 
20/11/2024 11:15:00 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '3558' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-20') 
20/11/2024 11:15: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' ,
                          '3558' ,
                          '2024-11-20' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '54.90' ,
                          '45.00' ,
                          NOW() ,
                          NOW() ) 
20/11/2024 11:15: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 = '94372' 
20/11/2024 11:15:00 am >>  DELETE FROM ps_document_detail WHERE id_document = '94372' 
20/11/2024 11:15:01 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94372' , '23182' , 'GRUPPO NATIVITA ALBERO CM 10 - PB16997' , '5' ,  '-5' , '1' ,
                               '8.50' , '6.9672131147541' , '22' , '0' , '42.50' ) 
20/11/2024 11:15:01 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94372' , '23189' , 'GRUPPO NATIVITA\' STILIZZATA - PB18073' , '5' ,  '-5' , '1' ,
                               '2.00' , '1.6393442622951' , '22' , '0' , '10.00' ) 
20/11/2024 11:15:01 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94372' , '23095' , 'PORTACHIAVI GIUBILEO - G1878' , '1' ,  '-1' , '1' ,
                               '2.40' , '1.9672131147541' , '22' , '0' , '2.40' ) 
20/11/2024 11:23:17 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' ,
                          '00330134' ,
                          '2024-11-19' ,
                          '' ,
                          '0' ,
                          '109' ,
                          '4669106' ,
                          'VIA G. VERDI, 8 20090 ASSAGO' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '560.00' ,
                          '560.00' ,
                          NOW() ,
                          NOW() ) 
20/11/2024 11:23:17 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 = '94373' 
20/11/2024 11:23:17 am >>  DELETE FROM ps_document_detail WHERE id_document = '94373' 
20/11/2024 11:23:17 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94373' , '20085' , 'CARTA FORBICI E ... - D. MAZZOLI' , '40' ,  '40' , '4' ,
                               '14.00' , '14' , '0' , '0' , '560.0000' ) 
20/11/2024 11:23:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '20085' AND id_supplier = '109' 
20/11/2024 11:23:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20085' , '109' , '1' ) 
20/11/2024 11:24:20 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 
20/11/2024 11:24:20 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23233' , '1' , '' , 'nuovo-prodotto' )
20/11/2024 11:24:20 am >> INSERT INTO ps_product_shop (
                      id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
                  ) VALUES (
                      '23233' , '1' , '1' , '2' , NOW() , NOW()
                  ) 
20/11/2024 11:24:20 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23233' , '0' , '1' , '0' , '0' )
20/11/2024 11:25:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256270644' AND id_product != '23233' AND ean13 != '' 
20/11/2024 11:25:11 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '13/6',
                  ean13 = '9791256270644',
                  date_upd = NOW()
                WHERE id_product = '23233' 
20/11/2024 11:25:11 am >> UPDATE ps_product_lang SET
                  name = 'AD THEOLOGIAM PROMOVENDAM',
                  description = ''
                WHERE id_product = '23233' 
20/11/2024 11:25:11 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '13'
                WHERE id_product = '23233' 
20/11/2024 11:25:11 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '13',
                  id_tax_rules_group = '4',
                  id_category_default = '137',
                  id_argoment_default = '65',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '23233' 
20/11/2024 11:25:11 am >> DELETE FROM ps_specific_price WHERE id_product = '23233' 
20/11/2024 11:25:12 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 = '23233' 
20/11/2024 11:25:12 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23234' , '1' , '' , 'nuovo-prodotto' )
20/11/2024 11:25:12 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 '23234' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23233' 
20/11/2024 11:25:12 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '23234' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23233' 
20/11/2024 11:25:53 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788830725775' AND id_product != '23234' AND ean13 != '' 
20/11/2024 11:25:53 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '',
                  ean13 = '9788830725775',
                  date_upd = NOW()
                WHERE id_product = '23234' 
20/11/2024 11:25:53 am >> UPDATE ps_product_lang SET
                  name = 'AGENDA MISSIONARIA 2025',
                  description = ''
                WHERE id_product = '23234' 
20/11/2024 11:25:53 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '13.5'
                WHERE id_product = '23234' 
20/11/2024 11:25:53 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '13.5',
                  id_tax_rules_group = '4',
                  id_category_default = '85',
                  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 = '23234' 
20/11/2024 11:25:53 am >> DELETE FROM ps_specific_price WHERE id_product = '23234' 
20/11/2024 11:25:55 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 = '23234' 
20/11/2024 11:25:55 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23235' , '1' , '' , 'nuovo-prodotto' )
20/11/2024 11:25:55 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 '23235' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23234' 
20/11/2024 11:25:55 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '23235' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23234' 
20/11/2024 11:27:32 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259624208' AND id_product != '23235' AND ean13 != '' 
20/11/2024 11:27:32 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '',
                  ean13 = '9791259624208',
                  date_upd = NOW()
                WHERE id_product = '23235' 
20/11/2024 11:27:32 am >> UPDATE ps_product_lang SET
                  name = 'DIO ESISTE? - ROBERT SARAH',
                  description = ''
                WHERE id_product = '23235' 
20/11/2024 11:27:32 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '25'
                WHERE id_product = '23235' 
20/11/2024 11:27:32 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '25',
                  id_tax_rules_group = '4',
                  id_category_default = '143',
                  id_argoment_default = '145',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '23235' 
20/11/2024 11:27:32 am >> DELETE FROM ps_specific_price WHERE id_product = '23235' 
20/11/2024 11:27:33 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 = '23235' 
20/11/2024 11:27:33 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23236' , '1' , '' , 'nuovo-prodotto' )
20/11/2024 11:27:33 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 '23236' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23235' 
20/11/2024 11:27:33 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '23236' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23235' 
20/11/2024 11:29:49 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899833183' AND id_product != '23236' AND ean13 != '' 
20/11/2024 11:29:49 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '',
                  ean13 = '9788899833183',
                  date_upd = NOW()
                WHERE id_product = '23236' 
20/11/2024 11:29:49 am >> UPDATE ps_product_lang SET
                  name = 'REGOLA DI SAN BENEDETTO',
                  description = ''
                WHERE id_product = '23236' 
20/11/2024 11:29:50 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '12.9'
                WHERE id_product = '23236' 
20/11/2024 11:29:50 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '12.9',
                  id_tax_rules_group = '4',
                  id_category_default = '143',
                  id_argoment_default = '41',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '23236' 
20/11/2024 11:29:50 am >> DELETE FROM ps_specific_price WHERE id_product = '23236' 
20/11/2024 11:30:31 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899833183' AND id_product != '23236' AND ean13 != '' 
20/11/2024 11:30:31 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '',
                  ean13 = '9788899833183',
                  date_upd = NOW()
                WHERE id_product = '23236' 
20/11/2024 11:30:31 am >> UPDATE ps_product_lang SET
                  name = 'REGOLA DI SAN BENEDETTO',
                  description = ''
                WHERE id_product = '23236' 
20/11/2024 11:30:31 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '12.9'
                WHERE id_product = '23236' 
20/11/2024 11:30:31 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '12.9',
                  id_tax_rules_group = '4',
                  id_category_default = '143',
                  id_argoment_default = '41',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '23236' 
20/11/2024 11:30:31 am >> DELETE FROM ps_specific_price WHERE id_product = '23236' 
20/11/2024 11:31:58 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '3559' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-20') 
20/11/2024 11:31:58 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' ,
                          '3559' ,
                          '2024-11-20' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '37.51' ,
                          '32.10' ,
                          NOW() ,
                          NOW() ) 
20/11/2024 11:31:58 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 = '94374' 
20/11/2024 11:31:58 am >>  DELETE FROM ps_document_detail WHERE id_document = '94374' 
20/11/2024 11:31:58 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94374' , '23196' , 'DILEXIT NOS' , '1' ,  '-1' , '4' ,
                               '2.90' , '2.9' , '0' , '5' , '2.76' ) 
20/11/2024 11:31:58 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94374' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '1' ,  '-1' , '4' ,
                               '5.00' , '5' , '0' , '5' , '4.75' ) 
20/11/2024 11:31:58 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94374' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '5' ,  '-5' , '1' ,
                               '6.00' , '4.9180327868852' , '22' , '0' , '30.00' ) 
20/11/2024 11:32:23 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899833183' AND id_product != '23236' AND ean13 != '' 
20/11/2024 11:32:23 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '',
                  ean13 = '9788899833183',
                  date_upd = NOW()
                WHERE id_product = '23236' 
20/11/2024 11:32:23 am >> UPDATE ps_product_lang SET
                  name = 'REGOLA DI SAN BENEDETTO',
                  description = ''
                WHERE id_product = '23236' 
20/11/2024 11:32:23 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '12.9'
                WHERE id_product = '23236' 
20/11/2024 11:32:23 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '12.9',
                  id_tax_rules_group = '4',
                  id_category_default = '143',
                  id_argoment_default = '41',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '23236' 
20/11/2024 11:32:23 am >> DELETE FROM ps_specific_price WHERE id_product = '23236' 
20/11/2024 11:32:24 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 = '23236' 
20/11/2024 11:32:24 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23237' , '1' , '' , 'nuovo-prodotto' )
20/11/2024 11:32:24 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 '23237' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23236' 
20/11/2024 11:32:24 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '23237' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23236' 
20/11/2024 11:32:56 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810440360' AND id_product != '23237' AND ean13 != '' 
20/11/2024 11:32:56 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '',
                  ean13 = '9788810440360',
                  date_upd = NOW()
                WHERE id_product = '23237' 
20/11/2024 11:32:56 am >> UPDATE ps_product_lang SET
                  name = 'MARIA ALL\'ALBA DELL\'OTTAVO GIORNO',
                  description = ''
                WHERE id_product = '23237' 
20/11/2024 11:32:56 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '5'
                WHERE id_product = '23237' 
20/11/2024 11:32:56 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '5',
                  id_tax_rules_group = '4',
                  id_category_default = '9',
                  id_argoment_default = '150',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '23237' 
20/11/2024 11:32:56 am >> DELETE FROM ps_specific_price WHERE id_product = '23237' 
20/11/2024 11:32:58 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 = '23237' 
20/11/2024 11:32:58 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23238' , '1' , '' , 'nuovo-prodotto' )
20/11/2024 11:32:58 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 '23238' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23237' 
20/11/2024 11:32:58 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '23238' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23237' 
20/11/2024 11:33:28 am >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '33' ,
                          '00329624' ,
                          '2024-11-19' ,
                          '' ,
                          '0' ,
                          '109' ,
                          '4669106' ,
                          'VIA G. VERDI, 8 20090 ASSAGO' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '173.40' ,
                          '173.40' ,
                          NOW() ,
                          NOW() ) 
20/11/2024 11:33:28 am >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94375' 
20/11/2024 11:33:28 am >>  DELETE FROM ps_document_detail WHERE id_document = '94375' 
20/11/2024 11:33:28 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94375' , '21617' , 'SINFONIA DELLA PAROLA - F. MANNS' , '1' ,  '1' , '4' ,
                               '18.00' , '18' , '0' , '0' , '18.00' ) 
20/11/2024 11:33:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '21617' AND id_supplier = '109' 
20/11/2024 11:33:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21617' , '109' , '1' ) 
20/11/2024 11:33:28 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94375' , '23233' , 'AD THEOLOGIAM PROMOVENDAM' , '1' ,  '1' , '4' ,
                               '13.00' , '13' , '0' , '0' , '13.00' ) 
20/11/2024 11:33:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '23233' AND id_supplier = '109' 
20/11/2024 11:33:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23233' , '109' , '1' ) 
20/11/2024 11:33:28 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94375' , '23234' , 'AGENDA MISSIONARIA 2025' , '1' ,  '1' , '4' ,
                               '13.50' , '13.5' , '0' , '0' , '13.50' ) 
20/11/2024 11:33:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '23234' AND id_supplier = '109' 
20/11/2024 11:33:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23234' , '109' , '1' ) 
20/11/2024 11:33:28 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94375' , '23235' , 'DIO ESISTE? - ROBERT SARAH' , '1' ,  '1' , '4' ,
                               '25.00' , '25' , '0' , '0' , '25.00' ) 
20/11/2024 11:33:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '23235' AND id_supplier = '109' 
20/11/2024 11:33:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23235' , '109' , '1' ) 
20/11/2024 11:33:28 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94375' , '23045' , 'DIO DEI NOSTRI PADRI - A. CAZZULLO' , '1' ,  '1' , '4' ,
                               '19.50' , '19.5' , '0' , '0' , '19.50' ) 
20/11/2024 11:33:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '23045' AND id_supplier = '109' 
20/11/2024 11:33:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23045' , '109' , '1' ) 
20/11/2024 11:33:28 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94375' , '23236' , 'REGOLA DI SAN BENEDETTO' , '1' ,  '1' , '4' ,
                               '12.90' , '12.9' , '0' , '0' , '12.90' ) 
20/11/2024 11:33:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '23236' AND id_supplier = '109' 
20/11/2024 11:33:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23236' , '109' , '1' ) 
20/11/2024 11:33:28 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94375' , '20587' , 'CATECHESI CREATIVA - A. QUEIROLO' , '1' ,  '1' , '4' ,
                               '14.00' , '14' , '0' , '0' , '14.00' ) 
20/11/2024 11:33:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '20587' AND id_supplier = '109' 
20/11/2024 11:33:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20587' , '109' , '1' ) 
20/11/2024 11:33:28 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94375' , '16204' , 'PREGHIERE DEI FEDELI - FESTIVI' , '1' ,  '1' , '4' ,
                               '19.50' , '19.5' , '0' , '0' , '19.50' ) 
20/11/2024 11:33:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '16204' AND id_supplier = '109' 
20/11/2024 11:33:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16204' , '109' , '1' ) 
20/11/2024 11:33:29 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94375' , '23237' , 'MARIA ALLALBA DELLOTTAVO GIORNO' , '1' ,  '1' , '4' ,
                               '5.00' , '5' , '0' , '0' , '5.00' ) 
20/11/2024 11:33:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '23237' AND id_supplier = '109' 
20/11/2024 11:33:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23237' , '109' , '1' ) 
20/11/2024 11:33:29 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94375' , '22862' , 'E LA TUA PARTE 1 - 6/8 ANNI' , '2' ,  '2' , '4' ,
                               '16.50' , '16.5' , '0' , '0' , '33.0000' ) 
20/11/2024 11:33:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '22862' AND id_supplier = '109' 
20/11/2024 11:33:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22862' , '109' , '1' ) 
20/11/2024 11:58:03 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '3560' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-20') 
20/11/2024 11:58:03 am >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '3560' ,
                          '2024-11-20' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '9.00' ,
                          '7.38' ,
                          NOW() ,
                          NOW() ) 
20/11/2024 11:58:03 am >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94376' 
20/11/2024 11:58:03 am >>  DELETE FROM ps_document_detail WHERE id_document = '94376' 
20/11/2024 11:58:03 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94376' , '940' , 'BAMBINO CM 4 - FOSFORO - P1' , '30' ,  '-30' , '1' ,
                               '0.30' , '0.24590163934426' , '22' , '0' , '9.00' ) 
20/11/2024 12:01:35 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '3561' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-20') 
20/11/2024 12:01:35 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' ,
                          '3561' ,
                          '2024-11-20' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '30.40' ,
                          '30.40' ,
                          NOW() ,
                          NOW() ) 
20/11/2024 12:01:35 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 = '94377' 
20/11/2024 12:01:35 pm >>  DELETE FROM ps_document_detail WHERE id_document = '94377' 
20/11/2024 12:01:35 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94377' , '22283' , 'BIBBIA DI GERUSALEMME VERDE' , '1' ,  '-1' , '4' ,
                               '32.00' , '32' , '0' , '5' , '30.40' ) 
20/11/2024 12:05:15 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '3562' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-20') 
20/11/2024 12:05:16 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '3562' ,
                          '2024-11-20' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '4.40' ,
                          '4.40' ,
                          NOW() ,
                          NOW() ) 
20/11/2024 12:05:16 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94378' 
20/11/2024 12:05:16 pm >>  DELETE FROM ps_document_detail WHERE id_document = '94378' 
20/11/2024 12:05:16 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94378' , '23135' , 'SUSSIDIO AVVENTO E NATALE 2024/25 RAGAZZI' , '1' ,  '-1' , '4' ,
                               '2.50' , '2.5' , '0' , '0' , '2.50' ) 
20/11/2024 12:05:16 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94378' , '23125' , 'IN CAMMINO VERSO IL NATALE -POSTER' , '1' ,  '-1' , '4' ,
                               '1.90' , '1.9' , '0' , '0' , '1.90' ) 
20/11/2024 12:24:07 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '3563' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-20') 
20/11/2024 12:24:07 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '3563' ,
                          '2024-11-20' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '18.60' ,
                          '18.60' ,
                          NOW() ,
                          NOW() ) 
20/11/2024 12:24:07 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94379' 
20/11/2024 12:24:07 pm >>  DELETE FROM ps_document_detail WHERE id_document = '94379' 
20/11/2024 12:24:07 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94379' , '23045' , 'DIO DEI NOSTRI PADRI - A. CAZZULLO' , '1' ,  '-1' , '4' ,
                               '18.6' , '18.6' , '0' , '0' , '18.60' ) 
20/11/2024 12:40:01 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '3564' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-20') 
20/11/2024 12:40:01 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' ,
                          '3564' ,
                          '2024-11-20' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '6.00' ,
                          '6.00' ,
                          NOW() ,
                          NOW() ) 
20/11/2024 12:40:01 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 = '94380' 
20/11/2024 12:40:01 pm >>  DELETE FROM ps_document_detail WHERE id_document = '94380' 
20/11/2024 12:40:01 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94380' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '2' ,  '-2' , '4' ,
                               '3.00' , '3' , '0' , '0' , '6.00' ) 
20/11/2024 12:42:51 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '27' AND id_document != '93681' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2024-10-17') 
20/11/2024 12:42:51 pm >> UPDATE ps_document SET
                          id_document_type = '24',
                          document_num = '27',
                          document_date = '2024-10-17',
                          document_letter = '',
                          id_customer = '0',
                          id_supplier = '',
                          id_address = '4669100',
                          address1 = 'VIA DEI CASTANI, 116 00172 ROMA',
                          address2 = '',
                          note = 'RESA - N. C. RICEVUTA',
                          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 = '260.00',
                          price_tax_excluded = '260.00',
                          date_upd = NOW()
                        WHERE id_document = '93681' 
20/11/2024 12:42: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 = '93681' 
20/11/2024 12:42:51 pm >>  DELETE FROM ps_document_detail WHERE id_document = '93681' 
20/11/2024 12:42: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
                            ( '93681' , '22056' , 'E IO VI RISTORERO - M. ZUPPI' , '1' ,  '-1' , '4' ,
                               '10.0000' , '10' , '0' , '0' , '10.00' ) 
20/11/2024 12:42: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
                            ( '93681' , '13464' , 'VITA BREVE DI SAN FRANCESCO DASSISI' , '1' ,  '-1' , '4' ,
                               '14.0000' , '14' , '0' , '0' , '14.00' ) 
20/11/2024 12:42: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
                            ( '93681' , '20859' , 'VOI CHI DITE CHE IO SIA - C. SOLMONESE ' , '1' ,  '-1' , '4' ,
                               '10.0000' , '10' , '0' , '0' , '10.00' ) 
20/11/2024 12:42: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
                            ( '93681' , '22022' , 'ADAMO DOVE SEI? R. COLIZZI' , '1' ,  '-1' , '4' ,
                               '10.0000' , '10' , '0' , '0' , '10.00' ) 
20/11/2024 12:42: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
                            ( '93681' , '20776' , 'PREGARE I SALMI CON FRANCESCO DASSISI - L. BERGAMASCHI' , '1' ,  '-1' , '4' ,
                               '14.0000' , '14' , '0' , '0' , '14.00' ) 
20/11/2024 12:42: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
                            ( '93681' , '22062' , 'SOSTENERE LE RAGIONI DELLA FEDE - S. GUSTAVSSON' , '1' ,  '-1' , '4' ,
                               '15.0000' , '15' , '0' , '0' , '15.00' ) 
20/11/2024 12:42: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
                            ( '93681' , '21079' , 'RALLEGRATI IL SIGNORE E QUI - MADRE M. DELLANNUNCIAZIONE' , '2' ,  '-2' , '4' ,
                               '5.0000' , '5' , '0' , '0' , '10.00' ) 
20/11/2024 12:42: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
                            ( '93681' , '22059' , 'CREARE CASA - SUSSIDIO' , '3' ,  '-3' , '4' ,
                               '4.0000' , '4' , '0' , '0' , '12.00' ) 
20/11/2024 12:42: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
                            ( '93681' , '20756' , 'COMMENTARIO BIBLICO' , '1' ,  '-1' , '4' ,
                               '50.0000' , '50' , '0' , '0' , '50.00' ) 
20/11/2024 12:42: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
                            ( '93681' , '20860' , 'BREVE STORIA DEL SEGNO DELLA CROCE - G. PASSARELLI' , '1' ,  '-1' , '4' ,
                               '8.0000' , '8' , '0' , '0' , '8.00' ) 
20/11/2024 12:42: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
                            ( '93681' , '18179' , 'BELLEZZA DELLA FEDE' , '1' ,  '-1' , '4' ,
                               '11.9000' , '11.9' , '0' , '0' , '11.90' ) 
20/11/2024 12:42: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
                            ( '93681' , '17682' , 'DONI DI SAN NICOLA - G. RECALCATI' , '1' ,  '-1' , '4' ,
                               '5.0000' , '5' , '0' , '0' , '5.00' ) 
20/11/2024 12:42: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
                            ( '93681' , '19257' , 'DUNS SCOTO IN ITALIA ' , '1' ,  '-1' , '4' ,
                               '35.0000' , '35' , '0' , '0' , '35.00' ) 
20/11/2024 12:42: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
                            ( '93681' , '19259' , 'SACERDOZIO MINISTERIALE SEGNO ESCATOLOGICO - G. FAZIO' , '1' ,  '-1' , '4' ,
                               '22.5000' , '22.5' , '0' , '0' , '22.50' ) 
20/11/2024 12:42:52 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '93681' , '17920' , 'DIO PELLEGRINO' , '1' ,  '-1' , '4' ,
                               '22.9000' , '22.9' , '0' , '0' , '22.90' ) 
20/11/2024 12:42:52 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '93681' , '22060' , 'CREARE CASA - IMMAGINETTE' , '97' ,  '-97' , '4' ,
                               '0.1000' , '0.1' , '0' , '0' , '9.70' ) 
20/11/2024 12:47:18 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '244' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-20') 
20/11/2024 12:47:18 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '21' ,
                          '244' ,
                          '2024-11-20' ,
                          '' ,
                          '292' ,
                          '0' ,
                          '4676365' ,
                          'VIA IONIO 8/A 84091 BATTIPAGLIA' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '15' ,
                          '0' ,
                          '261.80' ,
                          '261.80' ,
                          NOW() ,
                          NOW() ) 
20/11/2024 12:47:18 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94381' 
20/11/2024 12:47:18 pm >>  DELETE FROM ps_document_detail WHERE id_document = '94381' 
20/11/2024 12:47:18 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94381' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '110' ,  '-110' , '4' ,
                               '2.80' , '2.8' , '0' , '15' , '261.80' ) 
20/11/2024 12:48:22 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '126/A' AND id_document != '94369' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-11-20') 
20/11/2024 12:48:22 pm >> UPDATE ps_document SET
                          id_document_type = '24',
                          document_num = '126/A',
                          document_date = '2024-11-20',
                          document_letter = 'A',
                          id_customer = '292',
                          id_supplier = '',
                          id_address = '4676365',
                          address1 = 'VIA IONIO 8/A 84091 BATTIPAGLIA',
                          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 = '144.00',
                          price_tax_excluded = '144.00',
                          date_upd = NOW()
                        WHERE id_document = '94369' 
20/11/2024 12:48:22 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94369' 
20/11/2024 12:48:22 pm >>  DELETE FROM ps_document_detail WHERE id_document = '94369' 
20/11/2024 12:48:22 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94369' , '22804' , 'PANE E VINO - N.E. - SUSSIDIO' , '10' ,  '-10' , '4' ,
                               '4.5000' , '4.5' , '0' , '0' , '45.00' ) 
20/11/2024 12:48:22 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94369' , '21437' , 'IMPRONTE DI MISERICORDIA - CALENDALBUM 2 - N.E.' , '5' ,  '-5' , '4' ,
                               '4.5000' , '4.5' , '0' , '0' , '22.50' ) 
20/11/2024 12:48:22 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94369' , '21436' , 'MIA IMPRONTA NELLA TUA - CALENDALBUM 1 - N.E.' , '5' ,  '-5' , '4' ,
                               '4.5000' , '4.5' , '0' , '0' , '22.50' ) 
20/11/2024 12:48:22 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94369' , '15927' , 'COMUNITA’ SEGNI DI BELLEZZA - 4 GUIDA' , '1' ,  '-1' , '4' ,
                               '13.5000' , '13.5' , '0' , '0' , '13.50' ) 
20/11/2024 12:48:22 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94369' , '22803' , 'PANE E VINO - N.E. - GUIDA 3' , '1' ,  '-1' , '4' ,
                               '13.5000' , '13.5' , '0' , '0' , '13.50' ) 
20/11/2024 12:48:23 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94369' , '21484' , 'MIA IMPRONTA NELLA TUA - GUIDA 1 - N.E.' , '2' ,  '-2' , '4' ,
                               '13.5000' , '13.5' , '0' , '0' , '27.00' ) 
20/11/2024 12:49:50 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '244' AND id_document != '94381' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-20') 
20/11/2024 12:49:50 pm >> UPDATE ps_document SET
                          id_document_type = '21',
                          document_num = '244',
                          document_date = '2024-11-20',
                          document_letter = '',
                          id_customer = '292',
                          id_supplier = '',
                          id_address = '4676365',
                          address1 = 'VIA IONIO 8/A 84091 BATTIPAGLIA',
                          address2 = '',
                          note = '',
                          price_shipping = '0.00',
                          id_tax_shipping_rules = '4',
                          colli = '0',
                          peso = '0',
                          porto_e_imballo = '0',
                          mezzo_consegna = '',
                          id_payment = '15',
                          id_causal = '0',
                          price_tax_included = '285.60',
                          price_tax_excluded = '285.60',
                          date_upd = NOW()
                        WHERE id_document = '94381' 
20/11/2024 12:49: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 = '94381' 
20/11/2024 12:49:51 pm >>  DELETE FROM ps_document_detail WHERE id_document = '94381' 
20/11/2024 12:49: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
                            ( '94381' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '120' ,  '-120' , '4' ,
                               '2.8000' , '2.8' , '0' , '15' , '285.60' ) 
20/11/2024 12:51:37 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '3565' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-20') 
20/11/2024 12:51:37 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '3565' ,
                          '2024-11-20' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          'VIA IONIO 8/A 84091 BATTIPAGLIA' ,
                          '' ,
                          '' ,
                          '0.00' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '144.00' ,
                          '144.00' ,
                          NOW() ,
                          NOW() ) 
20/11/2024 12:51: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 = '94382' 
20/11/2024 12:51:37 pm >>  DELETE FROM ps_document_detail WHERE id_document = '94382' 
20/11/2024 12:52:05 pm >> DELETE FROM ps_document WHERE id_document = '94382' 
20/11/2024 12:52:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '94382' 
20/11/2024 12:52:33 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '3565' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-20') 
20/11/2024 12:52:33 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '3565' ,
                          '2024-11-20' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          'VIA IONIO 8/A 84091 BATTIPAGLIA' ,
                          '' ,
                          '' ,
                          '0.00' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '146.90' ,
                          '146.90' ,
                          NOW() ,
                          NOW() ) 
20/11/2024 12:52:33 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94383' 
20/11/2024 12:52:33 pm >>  DELETE FROM ps_document_detail WHERE id_document = '94383' 
20/11/2024 12:52:33 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94383' , '22804' , 'PANE E VINO - N.E. - SUSSIDIO' , '10' ,  '-10' , '4' ,
                               '4.5000' , '4.5' , '0' , '0' , '45.00' ) 
20/11/2024 12:52:33 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94383' , '21437' , 'IMPRONTE DI MISERICORDIA - CALENDALBUM 2 - N.E.' , '5' ,  '-5' , '4' ,
                               '4.5000' , '4.5' , '0' , '0' , '22.50' ) 
20/11/2024 12:52:33 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94383' , '21436' , 'MIA IMPRONTA NELLA TUA - CALENDALBUM 1 - N.E.' , '5' ,  '-5' , '4' ,
                               '4.5000' , '4.5' , '0' , '0' , '22.50' ) 
20/11/2024 12:52:33 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94383' , '15927' , 'COMUNITA’ SEGNI DI BELLEZZA - 4 GUIDA' , '1' ,  '-1' , '4' ,
                               '13.5000' , '13.5' , '0' , '0' , '13.50' ) 
20/11/2024 12:52:33 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94383' , '22803' , 'PANE E VINO - N.E. - GUIDA 3' , '1' ,  '-1' , '4' ,
                               '13.5000' , '13.5' , '0' , '0' , '13.50' ) 
20/11/2024 12:52:33 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94383' , '21484' , 'MIA IMPRONTA NELLA TUA - GUIDA 1 - N.E.' , '2' ,  '-2' , '4' ,
                               '13.5000' , '13.5' , '0' , '0' , '27.00' ) 
20/11/2024 12:52:33 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94383' , '23134' , 'AVVENTO E NATALE 2024/25' , '1' ,  '-1' , '4' ,
                               '2.90' , '2.9' , '0' , '0' , '2.90' ) 
20/11/2024 02:16:41 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '31' ,
                          '588' ,
                          '2024-11-19' ,
                          '' ,
                          '0' ,
                          '81' ,
                          '2696' ,
                          'C.SO UMBERTO I , 70 80034 MARIGLIANO' ,
                          '' ,
                          '' ,
                          '0.3' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '3' ,
                          '0' ,
                          '67.50' ,
                          '67.50' ,
                          NOW() ,
                          NOW() ) 
20/11/2024 02:16:41 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94384' 
20/11/2024 02:16:41 pm >>  DELETE FROM ps_document_detail WHERE id_document = '94384' 
20/11/2024 02:16:41 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94384' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '2560' ,  '2560' , '4' ,
                               '0.035' , '0.035' , '0' , '25' , '67.2000' ) 
20/11/2024 02:16:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11858' AND id_supplier = '81' 
20/11/2024 02:16:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11858' , '81' , '1' ) 
20/11/2024 02:22:25 pm >> INSERT INTO ps_category ( id_parent , `date_add` , `date_upd` , level_depth ) VALUES ( '4' , NOW() , NOW() , '3' ) 
20/11/2024 02:22:25 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '547' , '1' )
20/11/2024 02:22:25 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '547' , '2' )
20/11/2024 02:22:25 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '547' , '3' )
20/11/2024 02:22:25 pm >> INSERT INTO ps_category_lang ( id_category , id_lang , name , link_rewrite ) VALUES ( '547' , '1' , 'TRECCANI' , LOWER('TRECCANI') )
20/11/2024 02:22:25 pm >> INSERT INTO ps_category_shop ( id_category , id_shop , position ) VALUES ( '547' , '1' , '0' ) 
20/11/2024 02:22:33 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788812010684' AND id_product != '23238' AND ean13 != '' 
20/11/2024 02:22:33 pm >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '',
                  ean13 = '9788812010684',
                  date_upd = NOW()
                WHERE id_product = '23238' 
20/11/2024 02:22:33 pm >> UPDATE ps_product_lang SET
                  name = 'MANIFESTO DEL CAMBIAMENTO - G. CACCAMO',
                  description = ''
                WHERE id_product = '23238' 
20/11/2024 02:22:33 pm >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '22'
                WHERE id_product = '23238' 
20/11/2024 02:22:33 pm >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '22',
                  id_tax_rules_group = '4',
                  id_category_default = '547',
                  id_argoment_default = '75',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '23238' 
20/11/2024 02:22:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '23238' 
20/11/2024 02:22:35 pm >> INSERT INTO ps_product (
                  id_tax_rules_group , `date_add` , `date_upd`
                ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23238' 
20/11/2024 02:22:35 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23239' , '1' , '' , 'nuovo-prodotto' )
20/11/2024 02:22:35 pm >> INSERT INTO ps_product_shop (
                    id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd`
                ) SELECT '23239' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23238' 
20/11/2024 02:22:35 pm >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '23239' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23238' 
20/11/2024 02:23:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788856689440' AND id_product != '23239' AND ean13 != '' 
20/11/2024 02:23:23 pm >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '6/7',
                  ean13 = '9788856689440',
                  date_upd = NOW()
                WHERE id_product = '23239' 
20/11/2024 02:23:23 pm >> UPDATE ps_product_lang SET
                  name = 'TU SEI AMATO - P. CURTAZ',
                  description = ''
                WHERE id_product = '23239' 
20/11/2024 02:23:23 pm >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '18.9'
                WHERE id_product = '23239' 
20/11/2024 02:23:23 pm >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '18.9',
                  id_tax_rules_group = '4',
                  id_category_default = '70',
                  id_argoment_default = '23',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '23239' 
20/11/2024 02:23:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '23239' 
20/11/2024 02:23:24 pm >> INSERT INTO ps_product (
                  id_tax_rules_group , `date_add` , `date_upd`
                ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23239' 
20/11/2024 02:23:24 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23240' , '1' , '' , 'nuovo-prodotto' )
20/11/2024 02:23:24 pm >> INSERT INTO ps_product_shop (
                    id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd`
                ) SELECT '23240' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23239' 
20/11/2024 02:23:24 pm >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '23240' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23239' 
20/11/2024 02:23:44 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '33' ,
                          '1499314' ,
                          '2024-11-20' ,
                          '' ,
                          '0' ,
                          '177' ,
                          '4679057' ,
                          'VIA G. VERDI 8 20057 ASSAGO' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '101.90' ,
                          '101.90' ,
                          NOW() ,
                          NOW() ) 
20/11/2024 02:23:44 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94385' 
20/11/2024 02:23:44 pm >>  DELETE FROM ps_document_detail WHERE id_document = '94385' 
20/11/2024 02:23:44 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94385' , '23005' , 'FORZA DELLA MITEZZA - L. EPICOCO' , '1' ,  '1' , '4' ,
                               '17.00' , '17' , '0' , '0' , '17.00' ) 
20/11/2024 02:23:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23005' AND id_supplier = '177' 
20/11/2024 02:23:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23005' , '177' , '1' ) 
20/11/2024 02:23:45 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94385' , '23238' , 'MANIFESTO DEL CAMBIAMENTO - G. CACCAMO' , '3' ,  '3' , '4' ,
                               '22.00' , '22' , '0' , '0' , '66.0000' ) 
20/11/2024 02:23:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23238' AND id_supplier = '177' 
20/11/2024 02:23:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23238' , '177' , '1' ) 
20/11/2024 02:23:45 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94385' , '23239' , 'TU SEI AMATO - P. CURTAZ' , '1' ,  '1' , '4' ,
                               '18.90' , '18.9' , '0' , '0' , '18.90' ) 
20/11/2024 02:23:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23239' AND id_supplier = '177' 
20/11/2024 02:23:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23239' , '177' , '1' ) 
20/11/2024 03:12:45 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '245' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-20') 
20/11/2024 03:12:45 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '21' ,
                          '245' ,
                          '2024-11-20' ,
                          '' ,
                          '232' ,
                          '0' ,
                          '4671450' ,
                          'VIA V. LASPRO, 8/A 84126 SALERNO' ,
                          '' ,
                          '' ,
                          '0.00' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '1' ,
                          '0' ,
                          '80.70' ,
                          '79.80' ,
                          NOW() ,
                          NOW() ) 
20/11/2024 03:12:45 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94386' 
20/11/2024 03:12:45 pm >>  DELETE FROM ps_document_detail WHERE id_document = '94386' 
20/11/2024 03:12:45 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94386' , '12819' , 'REGISTRO DEL CATECHISTA ' , '5' ,  '-5' , '1' ,
                               '1.0000' , '0.8197' , '22' , '0' , '5.00' ) 
20/11/2024 03:12:45 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94386' , '2679' , 'CONOSCERE GESU\'' , '1' ,  '-1' , '4' ,
                               '3.5000' , '3.5' , '0' , '0' , '3.50' ) 
20/11/2024 03:12:45 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94386' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '5' ,  '-5' , '4' ,
                               '3.8000' , '3.8' , '0' , '0' , '19.00' ) 
20/11/2024 03:12:45 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94386' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '8' ,  '-8' , '4' ,
                               '3.8000' , '3.8' , '0' , '0' , '30.40' ) 
20/11/2024 03:12:45 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94386' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '6' ,  '-6' , '4' ,
                               '3.8000' , '3.8' , '0' , '0' , '22.80' ) 
20/11/2024 03:12:52 pm >> DELETE FROM ps_document WHERE id_document = '93562' 
20/11/2024 03:12:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '93562' 
20/11/2024 03:16:01 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '3566' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-20') 
20/11/2024 03:16:01 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' ,
                          '3566' ,
                          '2024-11-20' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '36.00' ,
                          '29.51' ,
                          NOW() ,
                          NOW() ) 
20/11/2024 03:16:01 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 = '94387' 
20/11/2024 03:16:01 pm >>  DELETE FROM ps_document_detail WHERE id_document = '94387' 
20/11/2024 03:16:02 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94387' , '6811' , 'MOCCOLO 80X200' , '4' ,  '-4' , '1' ,
                               '9.00' , '7.3770491803279' , '22' , '0' , '36.00' ) 
20/11/2024 03:16:17 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '3567' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-20') 
20/11/2024 03:16:17 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '3567' ,
                          '2024-11-20' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '18.00' ,
                          '14.75' ,
                          NOW() ,
                          NOW() ) 
20/11/2024 03:16:17 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94388' 
20/11/2024 03:16:17 pm >>  DELETE FROM ps_document_detail WHERE id_document = '94388' 
20/11/2024 03:16:17 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94388' , '6809' , 'MOCCOLO 60X165' , '4' ,  '-4' , '1' ,
                               '4.50' , '3.6885245901639' , '22' , '0' , '18.00' ) 
20/11/2024 04:41:11 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '246' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-20') 
20/11/2024 04:41:11 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '21' ,
                          '246' ,
                          '2024-11-20' ,
                          '' ,
                          '1798' ,
                          '0' ,
                          '4670804' ,
                          'VIA M. GANGEMI, 42 95016 MASCALI' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '1' ,
                          '0' ,
                          '102.17' ,
                          '102.17' ,
                          NOW() ,
                          NOW() ) 
20/11/2024 04: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 = '94389' 
20/11/2024 04:41:11 pm >>  DELETE FROM ps_document_detail WHERE id_document = '94389' 
20/11/2024 04: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
                            ( '94389' , '5444' , 'IO SONO CON VOI - CAT.' , '19' ,  '-19' , '4' ,
                               '5.50' , '5.5' , '0' , '5' , '99.27' ) 
20/11/2024 04: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
                            ( '94389' , '' , 'CONTRASSEGNO' , '1' ,  '-1' , '4' ,
                               '2.9' , '2.9' , '0' , '0' , '2.90' ) 
20/11/2024 04:42:09 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '246' AND id_document != '94389' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-20') 
20/11/2024 04:42:09 pm >> UPDATE ps_document SET
                          id_document_type = '21',
                          document_num = '246',
                          document_date = '2024-11-20',
                          document_letter = '',
                          id_customer = '1798',
                          id_supplier = '',
                          id_address = '4670804',
                          address1 = 'VIA M. GANGEMI, 42 95016 MASCALI',
                          address2 = '',
                          note = '',
                          price_shipping = '0.00',
                          id_tax_shipping_rules = '4',
                          colli = '0',
                          peso = '0',
                          porto_e_imballo = '0',
                          mezzo_consegna = '',
                          id_payment = '6',
                          id_causal = '0',
                          price_tax_included = '102.17',
                          price_tax_excluded = '102.17',
                          date_upd = NOW()
                        WHERE id_document = '94389' 
20/11/2024 04:42: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 = '94389' 
20/11/2024 04:42:09 pm >>  DELETE FROM ps_document_detail WHERE id_document = '94389' 
20/11/2024 04:42: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
                            ( '94389' , '5444' , 'IO SONO CON VOI - CAT.' , '19' ,  '-19' , '4' ,
                               '5.5000' , '5.5' , '0' , '5' , '99.27' ) 
20/11/2024 04:42: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
                            ( '94389' , '0' , 'CONTRASSEGNO' , '1' ,  '-1' , '4' ,
                               '2.9000' , '2.9' , '0' , '0' , '2.90' ) 
20/11/2024 04:46:11 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '83/A' AND id_document != '92691' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-07-22') 
20/11/2024 04:46:11 pm >> UPDATE ps_document SET
                          id_document_type = '24',
                          document_num = '83/A',
                          document_date = '2024-07-22',
                          document_letter = 'A',
                          id_customer = '3812',
                          id_supplier = '',
                          id_address = '4678843',
                          address1 = 'LARGO PLEBISCITO 12 84121 SALERNO ',
                          address2 = '',
                          note = '',
                          price_shipping = '0.00',
                          id_tax_shipping_rules = '4',
                          colli = '0',
                          peso = '0',
                          porto_e_imballo = '0',
                          mezzo_consegna = '',
                          id_payment = '0',
                          id_causal = '0',
                          price_tax_included = '188.05',
                          price_tax_excluded = '181.89',
                          date_upd = NOW()
                        WHERE id_document = '92691' 
20/11/2024 04:46: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 = '92691' 
20/11/2024 04:46:11 pm >>  DELETE FROM ps_document_detail WHERE id_document = '92691' 
20/11/2024 04:46: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
                            ( '92691' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '5' ,  '-5' , '4' ,
                               '0.7000' , '0.7' , '0' , '0' , '3.50' ) 
20/11/2024 04:46: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
                            ( '92691' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '7' ,  '-7' , '3' ,
                               '3.5000' , '3.3653846153846' , '4' , '0' , '24.50' ) 
20/11/2024 04:46: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
                            ( '92691' , '7311' , 'OSTIA SOTTILE 74MM' , '7' ,  '-7' , '3' ,
                               '2.0000' , '1.9230769230769' , '4' , '0' , '14.00' ) 
20/11/2024 04:46: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
                            ( '92691' , '17005' , 'BIGLIETTO AUGURALE medio' , '6' ,  '-6' , '1' ,
                               '1.0000' , '0.81967213114754' , '22' , '0' , '6.00' ) 
20/11/2024 04:46: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
                            ( '92691' , '19089' , 'OSTIA MAGNA 150 - OM 150' , '1' ,  '-1' , '3' ,
                               '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 
20/11/2024 04:46: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
                            ( '92691' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '5' ,  '-5' , '4' ,
                               '0.7000' , '0.7' , '0' , '0' , '3.50' ) 
20/11/2024 04:46: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
                            ( '92691' , '17533' , 'CINGOLO ORO/COL - CING06' , '1' ,  '-1' , '1' ,
                               '19.00' , '15.573770491803' , '22' , '0' , '19.00' ) 
20/11/2024 04:46: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
                            ( '92691' , '17030' , 'MARIA - UN CAMMINO - A. DEHO' , '1' ,  '-1' , '4' ,
                               '9.00' , '9' , '0' , '5' , '8.55' ) 
20/11/2024 04:46: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
                            ( '92691' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' ,  '-1' , '4' ,
                               '110.00' , '110' , '0' , '5' , '104.50' ) 
20/11/2024 04:50:58 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '83/A' AND id_document != '92691' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-07-22') 
20/11/2024 04:50:58 pm >> UPDATE ps_document SET
                          id_document_type = '24',
                          document_num = '83/A',
                          document_date = '2024-07-22',
                          document_letter = 'A',
                          id_customer = '3812',
                          id_supplier = '',
                          id_address = '4678843',
                          address1 = 'LARGO PLEBISCITO 12 84121 SALERNO ',
                          address2 = '',
                          note = '',
                          price_shipping = '0.00',
                          id_tax_shipping_rules = '4',
                          colli = '0',
                          peso = '0',
                          porto_e_imballo = '0',
                          mezzo_consegna = '',
                          id_payment = '0',
                          id_causal = '0',
                          price_tax_included = '224.05',
                          price_tax_excluded = '211.40',
                          date_upd = NOW()
                        WHERE id_document = '92691' 
20/11/2024 04:50:58 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92691' 
20/11/2024 04:50:58 pm >>  DELETE FROM ps_document_detail WHERE id_document = '92691' 
20/11/2024 04:50:58 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '92691' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '5' ,  '-5' , '4' ,
                               '0.7000' , '0.7' , '0' , '0' , '3.50' ) 
20/11/2024 04:50:58 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '92691' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '7' ,  '-7' , '3' ,
                               '3.5000' , '3.3653846153846' , '4' , '0' , '24.50' ) 
20/11/2024 04:50:58 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '92691' , '7311' , 'OSTIA SOTTILE 74MM' , '7' ,  '-7' , '3' ,
                               '2.0000' , '1.9230769230769' , '4' , '0' , '14.00' ) 
20/11/2024 04:50:58 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '92691' , '17005' , 'BIGLIETTO AUGURALE medio' , '6' ,  '-6' , '1' ,
                               '1.0000' , '0.81967213114754' , '22' , '0' , '6.00' ) 
20/11/2024 04:50:58 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '92691' , '19089' , 'OSTIA MAGNA 150 - OM 150' , '1' ,  '-1' , '3' ,
                               '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 
20/11/2024 04:50:58 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '92691' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '5' ,  '-5' , '4' ,
                               '0.7000' , '0.7' , '0' , '0' , '3.50' ) 
20/11/2024 04:50:58 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '92691' , '17533' , 'CINGOLO ORO/COL - CING06' , '1' ,  '-1' , '1' ,
                               '19.0000' , '15.573770491803' , '22' , '0' , '19.00' ) 
20/11/2024 04:50:58 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '92691' , '17030' , 'MARIA - UN CAMMINO - A. DEHO' , '1' ,  '-1' , '4' ,
                               '9.0000' , '9' , '0' , '5' , '8.55' ) 
20/11/2024 04:50:58 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '92691' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' ,  '-1' , '4' ,
                               '110.0000' , '110' , '0' , '5' , '104.50' ) 
20/11/2024 04:50: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
                            ( '92691' , '6809' , 'MOCCOLO 60X165' , '8' ,  '-8' , '1' ,
                               '4.50' , '3.6885245901639' , '22' , '0' , '36.00' ) 
20/11/2024 06:27:54 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '3568' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-20') 
20/11/2024 06:27:54 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '3568' ,
                          '2024-11-20' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '23.50' ,
                          '19.89' ,
                          NOW() ,
                          NOW() ) 
20/11/2024 06:27:54 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94390' 
20/11/2024 06:27:54 pm >>  DELETE FROM ps_document_detail WHERE id_document = '94390' 
20/11/2024 06:27:54 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94390' , '23088' , 'CAMPANA DEL GIUBILEO' , '1' ,  '-1' , '1' ,
                               '20.00' , '16.393442622951' , '22' , '0' , '20.00' ) 
20/11/2024 06:27:54 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94390' , '23106' , 'DILEXIT NOS' , '1' ,  '-1' , '4' ,
                               '3.50' , '3.5' , '0' , '0' , '3.50' ) 
20/11/2024 07:42:23 pm >> INSERT INTO ps_customer
                          ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` )
                                VALUES
                          ( '1' , '' , '' , '' , 'hji03AQsgczXCkGw' , NOW() , NOW() ) 
20/11/2024 07:42:23 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7114' , '1' )
20/11/2024 07:42:23 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7114' , '2' )
20/11/2024 07:42:23 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7114' , '3' )
20/11/2024 07:52:08 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '127/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-11-20') 
20/11/2024 07:52:08 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '24' ,
                          '127/A' ,
                          '2024-11-20' ,
                          'A' ,
                          '177' ,
                          '0' ,
                          '4670959' ,
                          'VIA S. FELICE IN FELLINE 84133 SALERNO' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '220.00' ,
                          '186.68' ,
                          NOW() ,
                          NOW() ) 
20/11/2024 07:52:08 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94391' 
20/11/2024 07:52:08 pm >>  DELETE FROM ps_document_detail WHERE id_document = '94391' 
20/11/2024 07:52:08 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94391' , '14791' , 'NATIVITA GROTTA 12 CM' , '1' ,  '-1' , '1' ,
                               '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 
20/11/2024 07:52:08 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94391' , '16319' , 'NATIVITA CM 8X8' , '1' ,  '-1' , '1' ,
                               '8' , '6.5573770491803' , '22' , '0' , '8.00' ) 
20/11/2024 07:52:08 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94391' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '150' ,  '-150' , '1' ,
                               '0.28' , '0.22950819672131' , '22' , '0' , '42.00' ) 
20/11/2024 07:52:08 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94391' , '19072' , 'BAMBINELLO CON AUREOLA CM 37 - PB9257' , '1' ,  '-1' , '1' ,
                               '87.00' , '71.311475409836' , '22' , '0' , '87.00' ) 
20/11/2024 07:52:08 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94391' , '7202' , 'ARTICOLI RELIGIOSI' , '1' ,  '-1' , '1' ,
                               '13' , '10.655737704918' , '22' , '0' , '13.00' ) 
20/11/2024 07:52:08 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94391' , '19748' , 'CORONA DAVVENTO STELLE' , '1' ,  '-1' , '1' ,
                               '23.8' , '19.508196721311' , '22' , '0' , '23.80' ) 
20/11/2024 07:52:08 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94391' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '880' ,  '-880' , '4' ,
                               '0.04' , '0.04' , '0' , '0' , '35.20' ) 
20/11/2024 07:54:41 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '3569' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-20') 
20/11/2024 07:54:41 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '3569' ,
                          '2024-11-20' ,
                          '' ,
                          '177' ,
                          '0' ,
                          '4670959' ,
                          'VIA S. FELICE IN FELLINE 84133 SALERNO' ,
                          '' ,
                          '' ,
                          '0.00' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '228.00' ,
                          '194.41' ,
                          NOW() ,
                          NOW() ) 
20/11/2024 07:54:41 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94392' 
20/11/2024 07:54:41 pm >>  DELETE FROM ps_document_detail WHERE id_document = '94392' 
20/11/2024 07:54:41 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94392' , '14791' , 'NATIVITA GROTTA 12 CM' , '1' ,  '-1' , '1' ,
                               '11.0000' , '9.0164' , '22' , '0' , '11.00' ) 
20/11/2024 07:54:41 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94392' , '16319' , 'NATIVITA CM 8X8' , '1' ,  '-1' , '1' ,
                               '8.0000' , '6.5574' , '22' , '0' , '8.00' ) 
20/11/2024 07:54:41 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94392' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '150' ,  '-150' , '1' ,
                               '0.2800' , '0.2295' , '22' , '0' , '42.00' ) 
20/11/2024 07:54:41 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94392' , '19072' , 'BAMBINELLO CON AUREOLA CM 37 - PB9257' , '1' ,  '-1' , '1' ,
                               '87.0000' , '71.3115' , '22' , '0' , '87.00' ) 
20/11/2024 07:54:41 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94392' , '7202' , 'ARTICOLI RELIGIOSI' , '1' ,  '-1' , '1' ,
                               '13.0000' , '10.6557' , '22' , '0' , '13.00' ) 
20/11/2024 07:54:41 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94392' , '19748' , 'CORONA DAVVENTO STELLE' , '1' ,  '-1' , '1' ,
                               '23.5' , '19.262295081967' , '22' , '0' , '23.50' ) 
20/11/2024 07:54:41 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94392' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '880' ,  '-880' , '4' ,
                               '0.0400' , '0.04' , '0' , '0' , '35.20' ) 
20/11/2024 07:54:41 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94392' , '7311' , 'OSTIA SOTTILE 74MM' , '2' ,  '-2' , '3' ,
                               '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 
20/11/2024 07:54:41 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94392' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' ,  '-1' , '3' ,
                               '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 
20/11/2024 08:02:07 pm >> DELETE FROM ps_document WHERE id_document = '94391' 
20/11/2024 08:02:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '94391' 
20/11/2024 08:02:41 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '3569' AND id_document != '94392' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-20') 
20/11/2024 08:02:41 pm >> UPDATE ps_document SET
                          id_document_type = '11',
                          document_num = '3569',
                          document_date = '2024-11-20',
                          document_letter = '',
                          id_customer = '',
                          id_supplier = '',
                          id_address = '',
                          address1 = 'VIA S. FELICE IN FELLINE 84133 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 = '228.00',
                          price_tax_excluded = '194.41',
                          date_upd = NOW()
                        WHERE id_document = '94392' 
20/11/2024 08:02:41 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94392' 
20/11/2024 08:02:42 pm >>  DELETE FROM ps_document_detail WHERE id_document = '94392' 
20/11/2024 08:02:42 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94392' , '14791' , 'NATIVITA GROTTA 12 CM' , '1' ,  '-1' , '1' ,
                               '11.0000' , '9.016393442623' , '22' , '0' , '11.00' ) 
20/11/2024 08:02:42 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94392' , '16319' , 'NATIVITA CM 8X8' , '1' ,  '-1' , '1' ,
                               '8.0000' , '6.5573770491803' , '22' , '0' , '8.00' ) 
20/11/2024 08:02:42 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94392' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '150' ,  '-150' , '1' ,
                               '0.2800' , '0.22950819672131' , '22' , '0' , '42.00' ) 
20/11/2024 08:02:42 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94392' , '19072' , 'BAMBINELLO CON AUREOLA CM 37 - PB9257' , '1' ,  '-1' , '1' ,
                               '87.0000' , '71.311475409836' , '22' , '0' , '87.00' ) 
20/11/2024 08:02:42 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94392' , '7202' , 'ARTICOLI RELIGIOSI' , '1' ,  '-1' , '1' ,
                               '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 
20/11/2024 08:02:42 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94392' , '19748' , 'CORONA DAVVENTO STELLE' , '1' ,  '-1' , '1' ,
                               '23.5000' , '19.262295081967' , '22' , '0' , '23.50' ) 
20/11/2024 08:02:42 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94392' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '880' ,  '-880' , '4' ,
                               '0.0400' , '0.04' , '0' , '0' , '35.20' ) 
20/11/2024 08:02:42 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94392' , '7311' , 'OSTIA SOTTILE 74MM' , '2' ,  '-2' , '3' ,
                               '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 
20/11/2024 08:02:42 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '94392' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' ,  '-1' , '3' ,
                               '4.3000' , '4.1346153846154' , '4' , '0' , '4.30' ) 
20/11/2024 08:03:01 pm >> DELETE FROM ps_document WHERE id_document = '94369' 
20/11/2024 08:03:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '94369'