07/05/2025 08:32:49 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048523' AND id_product != '20895' AND ean13 != '' 
07/05/2025 08:32:49 am >> UPDATE ps_product SET
                  id_supplier = '38',
                  reference = 'ESPOSITORE SHALOM',
                  ean13 = '9788884048523',
                  date_upd = NOW()
                WHERE id_product = '20895' 
07/05/2025 08:32:49 am >> UPDATE ps_product_lang SET
                  name = 'NOVE MARTEDI\' DELL\'ANGELO CUSTODE - 8458',
                  description = ''
                WHERE id_product = '20895' 
07/05/2025 08:32:49 am >> UPDATE ps_product SET
                  wholesale_price = '1.80',
                  on_sale = '0',
                  price = '3.0000'
                WHERE id_product = '20895' 
07/05/2025 08:32:49 am >> UPDATE ps_product_shop SET
                  wholesale_price = '1.80',
                  price = '3.0000',
                  id_tax_rules_group = '4',
                  id_category_default = '106',
                  id_argoment_default = '28',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '20895' 
07/05/2025 08:32:49 am >> DELETE FROM ps_specific_price WHERE id_product = '20895' 
07/05/2025 09:13:57 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '10/S' AND id_document != '14806' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-04-28') 
07/05/2025 09:14:31 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '10/S' AND id_document != '14806' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-04-28') 
07/05/2025 09:15:08 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '10/S' AND id_document != '14806' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-04-17') 
07/05/2025 09:16:50 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '11/S' AND id_document != '14806' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-04-17') 
07/05/2025 09:16:50 am >> UPDATE ps_document SET
                          id_document_type = '23',
                          document_num = '11/S',
                          document_date = '2025-04-17',
                          document_letter = 'S',
                          id_customer = '3487',
                          id_supplier = '',
                          id_address = '177359088',
                          address1 = 'VIA RIGLA 44 24010 PONTERANICA',
                          address2 = '',
                          note = '',
                          price_shipping = '0.00',
                          id_tax_shipping_rules = '4',
                          colli = '0',
                          peso = '0',
                          porto_e_imballo = '0',
                          mezzo_consegna = '',
                          id_payment = '3',
                          id_causal = '0',
                          price_tax_included = '18.75',
                          price_tax_excluded = '18.75',
                          date_upd = NOW()
                        WHERE id_document = '14806' 
07/05/2025 09:16:50 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 = '14806' 
07/05/2025 09:16:50 am >>  DELETE FROM ps_document_detail WHERE id_document = '14806' 
07/05/2025 09:16:50 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14806' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '15' ,  '-15' , '4' ,
                               '2.5000' , '2.5' , '0' , '50' , '18.75' ) 
07/05/2025 09:17:09 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '8/S' AND id_document != '14809' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-05-05') 
07/05/2025 09:17:09 am >> UPDATE ps_document SET
                          id_document_type = '22',
                          document_num = '8/S',
                          document_date = '2025-05-05',
                          document_letter = 'S',
                          id_customer = '3000',
                          id_supplier = '',
                          id_address = '4669629',
                          address1 = 'VIA DEI CASTANI, 116 00172 ROMA',
                          address2 = '',
                          note = 'VENDUTO APRILE 2025',
                          price_shipping = '0.00',
                          id_tax_shipping_rules = '4',
                          colli = '0',
                          peso = '0',
                          porto_e_imballo = '0',
                          mezzo_consegna = '',
                          id_payment = '14',
                          id_causal = '0',
                          price_tax_included = '1147.70',
                          price_tax_excluded = '1147.70',
                          date_upd = NOW()
                        WHERE id_document = '14809' 
07/05/2025 09:17:09 am >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14809' 
07/05/2025 09:17:09 am >>  DELETE FROM ps_document_detail WHERE id_document = '14809' 
07/05/2025 09:17:09 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14809' , '17' , 'LA FEDE NELLO ZAINETTO' , '4' ,  '0' , '4' ,
                               '6.0000' , '6' , '0' , '50' , '12.00' ) 
07/05/2025 09:17:09 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14809' , '134' , 'AVE MARIA SPIEGATA AI BAMBINI - N.E.' , '1' ,  '0' , '4' ,
                               '1.8000' , '1.8' , '0' , '50' , '0.90' ) 
07/05/2025 09:17:09 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14809' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '30' ,  '0' , '4' ,
                               '1.5000' , '1.5' , '0' , '50' , '22.50' ) 
07/05/2025 09:17:09 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14809' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '10' ,  '0' , '4' ,
                               '2.5000' , '2.5' , '0' , '50' , '12.50' ) 
07/05/2025 09:17:09 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14809' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '257' ,  '0' , '4' ,
                               '2.5000' , '2.5' , '0' , '50' , '321.25' ) 
07/05/2025 09:17:09 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14809' , '121' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '6' ,  '0' , '4' ,
                               '2.5000' , '2.5' , '0' , '50' , '7.50' ) 
07/05/2025 09:17:09 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14809' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '208' ,  '0' , '4' ,
                               '2.5000' , '2.5' , '0' , '50' , '260.00' ) 
07/05/2025 09:17:09 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14809' , '125' , 'MIE PREGHIERINE - N. E.' , '32' ,  '0' , '4' ,
                               '1.5000' , '1.5' , '0' , '50' , '24.00' ) 
07/05/2025 09:17:09 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14809' , '33' , '100 GIORNI CON LO SPIRITO' , '13' ,  '0' , '4' ,
                               '7.5000' , '7.5' , '0' , '50' , '48.75' ) 
07/05/2025 09:17:09 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14809' , '50' , 'PERDONAMI SIGNORE' , '104' ,  '0' , '4' ,
                               '2.5000' , '2.5' , '0' , '50' , '130.00' ) 
07/05/2025 09:17:09 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14809' , '55' , 'AVE MARIA ,SPIEGATA AI BAMBINI' , '4' ,  '0' , '4' ,
                               '1.5000' , '1.5' , '0' , '50' , '3.00' ) 
07/05/2025 09:17:09 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14809' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '11' ,  '0' , '4' ,
                               '2.0000' , '2' , '0' , '50' , '11.00' ) 
07/05/2025 09:17:09 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14809' , '75' , 'IL SEGNO DELLA CROCE' , '1' ,  '0' , '4' ,
                               '1.5000' , '1.5' , '0' , '50' , '0.75' ) 
07/05/2025 09:17:09 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14809' , '88' , 'GESÙ È RISORTO' , '1' ,  '0' , '4' ,
                               '2.0000' , '2' , '0' , '50' , '1.00' ) 
07/05/2025 09:17:09 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14809' , '89' , 'COMUNIONE SPIEGATA AI RAGAZZI' , '12' ,  '0' , '4' ,
                               '1.8000' , '1.8' , '0' , '50' , '10.80' ) 
07/05/2025 09:17:09 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14809' , '92' , 'LA PREGHIERA DEL ROSARIO' , '2' ,  '0' , '4' ,
                               '2.5000' , '2.5' , '0' , '50' , '2.50' ) 
07/05/2025 09:17:09 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14809' , '99' , 'AVE MARIA PREGHIERE MARIANE' , '2' ,  '0' , '4' ,
                               '2.0000' , '2' , '0' , '50' , '2.00' ) 
07/05/2025 09:17:09 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14809' , '104' , 'TEMPO DI QUARESIMA' , '1' ,  '0' , '4' ,
                               '2.5000' , '2.5' , '0' , '50' , '1.25' ) 
07/05/2025 09:17:09 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14809' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '5' ,  '0' , '4' ,
                               '2.5000' , '2.5' , '0' , '50' , '6.25' ) 
07/05/2025 09:17:09 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14809' , '110' , 'SE MI AMI NON PIANGERE' , '212' ,  '0' , '4' ,
                               '1.8000' , '1.8' , '0' , '50' , '190.80' ) 
07/05/2025 09:17:09 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14809' , '111' , 'I NONNI SONO UN TESORO' , '14' ,  '0' , '4' ,
                               '1.8000' , '1.8' , '0' , '50' , '12.60' ) 
07/05/2025 09:17:09 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14809' , '123' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '1' ,  '0' , '4' ,
                               '3.0000' , '3' , '0' , '50' , '1.50' ) 
07/05/2025 09:17:09 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14809' , '115' , 'SAN FRANCESCO DASSISI RACCONTATO AI RAGAZZI N.E.' , '8' ,  '0' , '4' ,
                               '4.0000' , '4' , '0' , '50' , '16.00' ) 
07/05/2025 09:17:10 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14809' , '117' , 'La preghiera delle cinque dita n.e.' , '2' ,  '0' , '4' ,
                               '1.8000' , '1.8' , '0' , '50' , '1.80' ) 
07/05/2025 09:17:10 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14809' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '5' ,  '0' , '4' ,
                               '2.5000' , '2.5' , '0' , '50' , '6.25' ) 
07/05/2025 09:17:10 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14809' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '4' ,  '0' , '4' ,
                               '2.5000' , '2.5' , '0' , '50' , '5.00' ) 
07/05/2025 09:17:10 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14809' , '138' , 'LA NASCITA DI GESU' , '2' ,  '0' , '4' ,
                               '2.5000' , '2.5' , '0' , '50' , '2.50' ) 
07/05/2025 09:17:10 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14809' , '139' , 'E NATO - n.e.' , '2' ,  '0' , '4' ,
                               '2.0000' , '2' , '0' , '50' , '2.00' ) 
07/05/2025 09:17:10 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14809' , '136' , 'ANGELO DI DIO N.E.' , '2' ,  '0' , '4' ,
                               '1.8000' , '1.8' , '0' , '50' , '1.80' ) 
07/05/2025 09:17:10 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14809' , '137' , 'AVVENTO' , '2' ,  '0' , '4' ,
                               '2.5000' , '2.5' , '0' , '50' , '2.50' ) 
07/05/2025 09:17:10 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14809' , '126' , 'SACRAMENTO DEL PERDONO' , '27' ,  '0' , '4' ,
                               '2.0000' , '2' , '0' , '50' , '27.00' ) 
07/05/2025 09:17:45 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '9/S' AND id_document != '14810' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-05-05') 
07/05/2025 09:17:45 am >> UPDATE ps_document SET
                          id_document_type = '25',
                          document_num = '9/S',
                          document_date = '2025-05-05',
                          document_letter = 'S',
                          id_customer = '3000',
                          id_supplier = '',
                          id_address = '4669629',
                          address1 = 'VIA DEI CASTANI, 116 00172 ROMA',
                          address2 = '',
                          note = 'RESA APRILE 2025',
                          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 = '112.70',
                          price_tax_excluded = '112.70',
                          date_upd = NOW()
                        WHERE id_document = '14810' 
07/05/2025 09:17:45 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 = '14810' 
07/05/2025 09:17:45 am >>  DELETE FROM ps_document_detail WHERE id_document = '14810' 
07/05/2025 09:17:45 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14810' , '11' , 'COME PREPARARSI ALLA CONFESSIONE' , '1' ,  '1' , '4' ,
                               '1.5000' , '1.5' , '0' , '50' , '0.75' ) 
07/05/2025 09:17:45 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14810' , '17' , 'LA FEDE NELLO ZAINETTO' , '10' ,  '10' , '4' ,
                               '6.0000' , '6' , '0' , '50' , '30.00' ) 
07/05/2025 09:17:45 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14810' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '1' ,  '1' , '4' ,
                               '1.5000' , '1.5' , '0' , '50' , '0.75' ) 
07/05/2025 09:17:45 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14810' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '8' ,  '8' , '4' ,
                               '2.5000' , '2.5' , '0' , '50' , '10.00' ) 
07/05/2025 09:17:45 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14810' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '2' ,  '2' , '4' ,
                               '2.5000' , '2.5' , '0' , '50' , '2.50' ) 
07/05/2025 09:17:45 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14810' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '1' ,  '1' , '4' ,
                               '2.5000' , '2.5' , '0' , '50' , '1.25' ) 
07/05/2025 09:17:45 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14810' , '30' , 'LA BIBBIA: ANTICO TESTAMENTO' , '1' ,  '1' , '4' ,
                               '9.0000' , '9' , '0' , '50' , '4.50' ) 
07/05/2025 09:17:45 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14810' , '33' , '100 GIORNI CON LO SPIRITO' , '2' ,  '2' , '4' ,
                               '7.5000' , '7.5' , '0' , '50' , '7.50' ) 
07/05/2025 09:17:45 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14810' , '35' , 'ANGELI - I NOSTRI MIGLIORI AMICI' , '1' ,  '1' , '4' ,
                               '2.5000' , '2.5' , '0' , '50' , '1.25' ) 
07/05/2025 09:17:45 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14810' , '50' , 'PERDONAMI SIGNORE' , '3' ,  '3' , '4' ,
                               '2.5000' , '2.5' , '0' , '50' , '3.75' ) 
07/05/2025 09:17:45 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14810' , '72' , 'FEDE, SPERANZA  E CARITA' , '2' ,  '2' , '4' ,
                               '6.0000' , '6' , '0' , '50' , '6.00' ) 
07/05/2025 09:17:45 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14810' , '89' , 'COMUNIONE SPIEGATA AI RAGAZZI' , '3' ,  '3' , '4' ,
                               '1.8000' , '1.8' , '0' , '50' , '2.70' ) 
07/05/2025 09:17:45 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14810' , '96' , 'LA PREGHIERA  - MEDICINA DELLANIMA' , '8' ,  '8' , '4' ,
                               '1.5000' , '1.5' , '0' , '50' , '6.00' ) 
07/05/2025 09:17:45 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14810' , '97' , '\"IL NATALE  \"\"CHE MERAVIGLIA\"\"\"' , '2' ,  '2' , '4' ,
                               '1.5000' , '1.5' , '0' , '50' , '1.50' ) 
07/05/2025 09:17:45 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14810' , '99' , 'AVE MARIA PREGHIERE MARIANE' , '1' ,  '1' , '4' ,
                               '2.0000' , '2' , '0' , '50' , '1.00' ) 
07/05/2025 09:17:45 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14810' , '101' , 'GESU BENEDICI LA NOSTRA FAMIGLIA' , '8' ,  '8' , '4' ,
                               '1.5000' , '1.5' , '0' , '50' , '6.00' ) 
07/05/2025 09:17:45 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14810' , '104' , 'TEMPO DI QUARESIMA' , '1' ,  '1' , '4' ,
                               '2.5000' , '2.5' , '0' , '50' , '1.25' ) 
07/05/2025 09:17:45 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14810' , '111' , 'I NONNI SONO UN TESORO' , '20' ,  '20' , '4' ,
                               '1.8000' , '1.8' , '0' , '50' , '18.00' ) 
07/05/2025 09:17:45 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14810' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '1' ,  '1' , '4' ,
                               '2.5000' , '2.5' , '0' , '50' , '1.25' ) 
07/05/2025 09:17:45 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14810' , '139' , 'E NATO - n.e.' , '3' ,  '3' , '4' ,
                               '2.0000' , '2' , '0' , '50' , '3.00' ) 
07/05/2025 09:17:45 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14810' , '137' , 'AVVENTO' , '3' ,  '3' , '4' ,
                               '2.5000' , '2.5' , '0' , '50' , '3.75' ) 
07/05/2025 09:19:24 am >> DELETE FROM ps_document WHERE id_document = '14806' 
07/05/2025 09:19:24 am >> DELETE FROM ps_document_detail WHERE id_document = '14806' 
07/05/2025 09:19:44 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '10/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-05-07') 
07/05/2025 09:19:45 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  (
                          '23' ,
                          '10/S' ,
                          '2025-05-07' ,
                          'S' ,
                          '3487' ,
                          '0' ,
                          '177359088' ,
                          'VIA RIGLA 44 24010 PONTERANICA' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '3' ,
                          '0' ,
                          '18.75' ,
                          '18.75' ,
                          NOW() ,
                          NOW() ) 
07/05/2025 09:19:45 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 = '14812' 
07/05/2025 09:19:45 am >>  DELETE FROM ps_document_detail WHERE id_document = '14812' 
07/05/2025 09:19:45 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14812' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '15' ,  '-15' , '4' ,
                               '2.5000' , '2.5' , '0' , '50' , '18.75' ) 
07/05/2025 09:21:35 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '10/S' AND id_document != '14812' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-04-28') 
07/05/2025 09:21:35 am >> UPDATE ps_document SET
                          id_document_type = '23',
                          document_num = '10/S',
                          document_date = '2025-04-28',
                          document_letter = 'S',
                          id_customer = '3487',
                          id_supplier = '',
                          id_address = '177359088',
                          address1 = 'VIA RIGLA 44 24010 PONTERANICA',
                          address2 = '',
                          note = '',
                          price_shipping = '0.00',
                          id_tax_shipping_rules = '4',
                          colli = '0',
                          peso = '0',
                          porto_e_imballo = '0',
                          mezzo_consegna = '',
                          id_payment = '3',
                          id_causal = '0',
                          price_tax_included = '18.75',
                          price_tax_excluded = '18.75',
                          date_upd = NOW()
                        WHERE id_document = '14812' 
07/05/2025 09:21:35 am >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14812' 
07/05/2025 09:21:35 am >>  DELETE FROM ps_document_detail WHERE id_document = '14812' 
07/05/2025 09:21: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
                            ( '14812' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '15' ,  '-15' , '4' ,
                               '2.5000' , '2.5' , '0' , '50' , '18.75' ) 
07/05/2025 09:25:46 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '13' AND id_document != '14807' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-04-24') 
07/05/2025 09:25:46 am >> UPDATE ps_document SET
                          id_document_type = '21',
                          document_num = '13',
                          document_date = '2025-04-24',
                          document_letter = '',
                          id_customer = '2173',
                          id_supplier = '',
                          id_address = '88682004',
                          address1 = 'VIA ROMA 32 67030 BARREA',
                          address2 = '',
                          note = '',
                          price_shipping = '6.90',
                          id_tax_shipping_rules = '4',
                          colli = '0',
                          peso = '0',
                          porto_e_imballo = '0',
                          mezzo_consegna = '',
                          id_payment = '6',
                          id_causal = '0',
                          price_tax_included = '45.90',
                          price_tax_excluded = '45.90',
                          date_upd = NOW()
                        WHERE id_document = '14807' 
07/05/2025 09:25:46 am >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14807' 
07/05/2025 09:25:46 am >>  DELETE FROM ps_document_detail WHERE id_document = '14807' 
07/05/2025 09:25:46 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14807' , '126' , 'SACRAMENTO DEL PERDONO' , '15' ,  '-15' , '4' ,
                               '2.0000' , '2' , '0' , '5' , '28.50' ) 
07/05/2025 09:25:46 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14807' , '125' , 'MIE PREGHIERINE - N. E.' , '7' ,  '-7' , '4' ,
                               '1.5' , '1.5' , '0' , '5' , '9.97' ) 
07/05/2025 09:25:46 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14807' , '75' , 'IL SEGNO DELLA CROCE' , '1' ,  '-1' , '4' ,
                               '0.53' , '0.53' , '0' , '0' , '0.53' ) 
07/05/2025 09:49:33 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '10/S' AND id_document != '14812' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-05-02') 
07/05/2025 09:49:33 am >> UPDATE ps_document SET
                          id_document_type = '23',
                          document_num = '10/S',
                          document_date = '2025-05-02',
                          document_letter = 'S',
                          id_customer = '3487',
                          id_supplier = '',
                          id_address = '177359088',
                          address1 = 'VIA RIGLA 44 24010 PONTERANICA',
                          address2 = '',
                          note = '',
                          price_shipping = '0.00',
                          id_tax_shipping_rules = '4',
                          colli = '0',
                          peso = '0',
                          porto_e_imballo = '0',
                          mezzo_consegna = '',
                          id_payment = '3',
                          id_causal = '0',
                          price_tax_included = '18.75',
                          price_tax_excluded = '18.75',
                          date_upd = NOW()
                        WHERE id_document = '14812' 
07/05/2025 09:49:33 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 = '14812' 
07/05/2025 09:49:33 am >>  DELETE FROM ps_document_detail WHERE id_document = '14812' 
07/05/2025 09:49:33 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '14812' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '15' ,  '-15' , '4' ,
                               '2.5000' , '2.5' , '0' , '50' , '18.75' ) 
07/05/2025 10:21:41 am >> SELECT ean13 FROM ps_product WHERE ean13 = '86/D16418' AND id_product != '23335' AND ean13 != '' 
07/05/2025 10:21:41 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '',
                  ean13 = '86/D16418',
                  date_upd = NOW()
                WHERE id_product = '23335' 
07/05/2025 10:21:41 am >> UPDATE ps_product_lang SET
                  name = 'DALMATICA - 86/D16418',
                  description = ''
                WHERE id_product = '23335' 
07/05/2025 10:21:41 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '229.5082'
                WHERE id_product = '23335' 
07/05/2025 10:21:41 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '229.5082',
                  id_tax_rules_group = '1',
                  id_category_default = '468',
                  id_argoment_default = '42',
                  id_internal_category = '3',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '23335' 
07/05/2025 10:21:41 am >> DELETE FROM ps_specific_price WHERE id_product = '23335' 
07/05/2025 10:34:57 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 
07/05/2025 10:34:57 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23716' , '1' , '' , 'nuovo-prodotto' )
07/05/2025 10:34:57 am >> INSERT INTO ps_product_shop (
                      id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
                  ) VALUES (
                      '23716' , '1' , '1' , '2' , NOW() , NOW()
                  ) 
07/05/2025 10:34:57 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23716' , '0' , '1' , '0' , '0' )
07/05/2025 10:40:20 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '1537' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 
07/05/2025 10:40:20 am >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '1537' ,
                          '2025-05-07' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '28.50' ,
                          '24.98' ,
                          NOW() ,
                          NOW() ) 
07/05/2025 10:40:20 am >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97031' 
07/05/2025 10:40:20 am >>  DELETE FROM ps_document_detail WHERE id_document = '97031' 
07/05/2025 10:40:20 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '97031' , '20516' , 'CROCE COMUNIONE - 42/08' , '10' ,  '-10' , '1' ,
                               '1.3' , '1.0655737704918' , '22' , '0' , '13.00' ) 
07/05/2025 10:40:20 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '97031' , '18357' , 'MIE PREGHIERINE N.E.' , '6' ,  '-6' , '4' ,
                               '1.50' , '1.5' , '0' , '0' , '9.00' ) 
07/05/2025 10:40:20 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '97031' , '16311' , 'DECINA MISSIONARIA - FR17-2' , '13' ,  '-13' , '1' ,
                               '0.50' , '0.40983606557377' , '22' , '0' , '6.50' ) 
07/05/2025 10:41:49 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002376' AND id_product != '23716' AND ean13 != '' 
07/05/2025 10:41:49 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '',
                  ean13 = '002376',
                  date_upd = NOW()
                WHERE id_product = '23716' 
07/05/2025 10:41:49 am >> UPDATE ps_product_lang SET
                  name = 'DALMATICA MARIANA - 86/DAL15236',
                  description = ''
                WHERE id_product = '23716' 
07/05/2025 10:41:49 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '385.24590163934425'
                WHERE id_product = '23716' 
07/05/2025 10:41:49 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '385.24590163934425',
                  id_tax_rules_group = '1',
                  id_category_default = '468',
                  id_argoment_default = '42',
                  id_internal_category = '3',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '23716' 
07/05/2025 10:41:49 am >> DELETE FROM ps_specific_price WHERE id_product = '23716' 
07/05/2025 10:42:36 am >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '31' ,
                          '153' ,
                          '2025-04-24' ,
                          '' ,
                          '0' ,
                          '143' ,
                          '4670947' ,
                          'VIA DELLE SELVETTE 324 55018 SEGROMIGNO IN MONTE CAPANNORI' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '3' ,
                          '0' ,
                          '231.95' ,
                          '190.12' ,
                          NOW() ,
                          NOW() ) 
07/05/2025 10:42:36 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 = '97032' 
07/05/2025 10:42:36 am >>  DELETE FROM ps_document_detail WHERE id_document = '97032' 
07/05/2025 10:42:36 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '97032' , '23716' , 'DALMATICA MARIANA - 86/DAL15236' , '1' ,  '1' , '1' ,
                               '196' , '160.65573770492' , '22' , '3' , '231.9464' ) 
07/05/2025 10:42:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '23716' AND id_supplier = '143' 
07/05/2025 10:42:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23716' , '143' , '1' ) 
07/05/2025 10:43:15 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '1538' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 
07/05/2025 10:43:15 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' ,
                          '1538' ,
                          '2025-05-07' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '28.00' ,
                          '22.95' ,
                          NOW() ,
                          NOW() ) 
07/05/2025 10:43:15 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 = '97033' 
07/05/2025 10:43:15 am >>  DELETE FROM ps_document_detail WHERE id_document = '97033' 
07/05/2025 10:43:15 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '97033' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' ,  '-1' , '1' ,
                               '28.00' , '22.950819672131' , '22' , '0' , '28.00' ) 
07/05/2025 10:44:14 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '1539' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 
07/05/2025 10:44:14 am >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '1539' ,
                          '2025-05-07' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '27.00' ,
                          '22.13' ,
                          NOW() ,
                          NOW() ) 
07/05/2025 10:44:14 am >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97034' 
07/05/2025 10:44:14 am >>  DELETE FROM ps_document_detail WHERE id_document = '97034' 
07/05/2025 10:44:14 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '97034' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' ,  '-1' , '1' ,
                               '27' , '22.131147540984' , '22' , '0' , '27.00' ) 
07/05/2025 10:45:20 am >> DELETE FROM ps_document WHERE id_document = '96866' 
07/05/2025 10:45:20 am >> DELETE FROM ps_document_detail WHERE id_document = '96866' 
07/05/2025 10:45:31 am >> DELETE FROM ps_document WHERE id_document = '96800' 
07/05/2025 10:45:31 am >> DELETE FROM ps_document_detail WHERE id_document = '96800' 
07/05/2025 10:47:04 am >> DELETE FROM ps_document WHERE id_document = '96966' 
07/05/2025 10:47:04 am >> DELETE FROM ps_document_detail WHERE id_document = '96966' 
07/05/2025 10:47:52 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '47/A' AND id_document != '96002' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-03-03') 
07/05/2025 10:47:52 am >> UPDATE ps_document SET
                          id_document_type = '24',
                          document_num = '47/A',
                          document_date = '2025-03-03',
                          document_letter = 'A',
                          id_customer = '1148',
                          id_supplier = '',
                          id_address = '1148',
                          address1 = 'P.ZZA GIOVANNI PAOLO II, 4 84080 COPERCHIA',
                          address2 = '',
                          note = '9',
                          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 = '236.00',
                          price_tax_excluded = '221.93',
                          date_upd = NOW()
                        WHERE id_document = '96002' 
07/05/2025 10:47:52 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 = '96002' 
07/05/2025 10:47:52 am >>  DELETE FROM ps_document_detail WHERE id_document = '96002' 
07/05/2025 10:47:52 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '96002' , '22871' , 'SPERANZA NON DELUDE - M. DE ROSA' , '10' ,  '-10' , '4' ,
                               '8.0000' , '8' , '0' , '0' , '80.00' ) 
07/05/2025 10:47:52 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '96002' , '23131' , 'TEMPO DEL PERDONO - F. CRISTOFARO' , '3' ,  '-3' , '4' ,
                               '16.0000' , '16' , '0' , '0' , '48.00' ) 
07/05/2025 10:47:52 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '96002' , '23095' , 'PORTACHIAVI GIUBILEO - G1878' , '15' ,  '-15' , '1' ,
                               '2.4000' , '1.9672131147541' , '22' , '0' , '36.00' ) 
07/05/2025 10:47:53 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '96002' , '23425' , 'ROSARIO GIUBILEO - 198/1-G25' , '12' ,  '-12' , '1' ,
                               '3.5000' , '2.8688524590164' , '22' , '0' , '42.00' ) 
07/05/2025 10:47:53 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '96002' , '' , 'BUONO A  RUSSO' , '1' ,  '-1' , '0' ,
                               '30' , '30' , '' , '0' , '30.00' ) 
07/05/2025 10:48:25 am >> DELETE FROM ps_document WHERE id_document = '94924' 
07/05/2025 10:48:25 am >> DELETE FROM ps_document_detail WHERE id_document = '94924' 
07/05/2025 10:52:05 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '1408' AND id_document != '96877' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-28') 
07/05/2025 10:52:05 am >> UPDATE ps_document SET
                          id_document_type = '11',
                          document_num = '1408',
                          document_date = '2025-04-28',
                          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 = '3',
                          id_causal = '0',
                          price_tax_included = '160.00',
                          price_tax_excluded = '131.15',
                          date_upd = NOW()
                        WHERE id_document = '96877' 
07/05/2025 10:52:05 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 = '96877' 
07/05/2025 10:52:05 am >>  DELETE FROM ps_document_detail WHERE id_document = '96877' 
07/05/2025 10:52:05 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '96877' , '18371' , 'CAMICE MISTO LANA - 70/000403' , '1' ,  '-1' , '1' ,
                               '160' , '131.14754098361' , '22' , '0' , '160.00' ) 
07/05/2025 10:53:08 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '1302' AND id_document != '96753' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-17') 
07/05/2025 10:53:08 am >> UPDATE ps_document SET
                          id_document_type = '11',
                          document_num = '1302',
                          document_date = '2025-04-17',
                          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 = '3',
                          id_causal = '0',
                          price_tax_included = '111.00',
                          price_tax_excluded = '90.98',
                          date_upd = NOW()
                        WHERE id_document = '96753' 
07/05/2025 10:53:08 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 = '96753' 
07/05/2025 10:53:08 am >>  DELETE FROM ps_document_detail WHERE id_document = '96753' 
07/05/2025 10:53:08 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '96753' , '17991' , 'STOLA LINO/POL GIGLIUCCIO A MANO' , '1' ,  '-1' , '1' ,
                               '111' , '90.983606557377' , '22' , '0' , '111.00' ) 
07/05/2025 11:12:36 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '1540' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 
07/05/2025 11:12:36 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' ,
                          '1540' ,
                          '2025-05-07' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '31.70' ,
                          '25.98' ,
                          NOW() ,
                          NOW() ) 
07/05/2025 11:12:36 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 = '97035' 
07/05/2025 11:12:36 am >>  DELETE FROM ps_document_detail WHERE id_document = '97035' 
07/05/2025 11:12:36 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '97035' , '13799' , 'CROCETTA CONFESSIONE - 2370/J44' , '1' ,  '-1' , '1' ,
                               '2.90' , '2.3770491803279' , '22' , '0' , '2.90' ) 
07/05/2025 11:12:36 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '97035' , '22502' , 'CONFEZIONE ROSARIO MISSIONARIO - 08/4MK' , '16' ,  '-16' , '1' ,
                               '1.80' , '1.4754098360656' , '22' , '0' , '28.80' ) 
07/05/2025 12:04:37 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1541' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 
07/05/2025 12:04: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' ,
                          '1541' ,
                          '2025-05-07' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '23.70' ,
                          '19.43' ,
                          NOW() ,
                          NOW() ) 
07/05/2025 12:04: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 = '97036' 
07/05/2025 12:04:37 pm >>  DELETE FROM ps_document_detail WHERE id_document = '97036' 
07/05/2025 12:04:37 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '97036' , '20515' , 'DECINA ULIVO - 04/7-D' , '5' ,  '-5' , '1' ,
                               '0.50' , '0.40983606557377' , '22' , '0' , '2.50' ) 
07/05/2025 12:04:37 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '97036' , '22500' , 'DECINA LEGNO' , '2' ,  '-2' , '1' ,
                               '1.60' , '1.3114754098361' , '22' , '0' , '3.20' ) 
07/05/2025 12:04:37 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '97036' , '12490' , 'CROCE SAN BENEDETTO ULIVO - CZ6NIK' , '1' ,  '-1' , '1' ,
                               '18.00' , '14.754098360656' , '22' , '0' , '18.00' ) 
07/05/2025 12:36:09 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1542' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 
07/05/2025 12:36:09 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' ,
                          '1542' ,
                          '2025-05-07' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '207.90' ,
                          '179.99' ,
                          NOW() ,
                          NOW() ) 
07/05/2025 12:36: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 = '97037' 
07/05/2025 12:36:09 pm >>  DELETE FROM ps_document_detail WHERE id_document = '97037' 
07/05/2025 12:36: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
                            ( '97037' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' ,  '-6' , '1' ,
                               '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 
07/05/2025 12:36: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
                            ( '97037' , '1914' , 'CERA DELLA LITURGIA' , '12' ,  '-12' , '1' ,
                               '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 
07/05/2025 12:36: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
                            ( '97037' , '17160' , 'CARBONCINI ROSSI - CARRO' , '3' ,  '-3' , '1' ,
                               '11.00' , '9.016393442623' , '22' , '0' , '33.00' ) 
07/05/2025 12:36: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
                            ( '97037' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' ,  '-10' , '3' ,
                               '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 
07/05/2025 12:36: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
                            ( '97037' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' ,  '-5' , '3' ,
                               '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 
07/05/2025 12:36: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
                            ( '97037' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '5' ,  '-5' , '3' ,
                               '4.50' , '4.3269230769231' , '4' , '0' , '22.50' ) 
07/05/2025 12:37:10 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1543' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 
07/05/2025 12:37:10 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' ,
                          '1543' ,
                          '2025-05-07' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '90.00' ,
                          '73.77' ,
                          NOW() ,
                          NOW() ) 
07/05/2025 12:37:10 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 = '97038' 
07/05/2025 12:37:10 pm >>  DELETE FROM ps_document_detail WHERE id_document = '97038' 
07/05/2025 12:37:10 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '97038' , '22199' , 'VINO LIQUOROSO ROSSO ' , '12' ,  '-12' , '1' ,
                               '7.5' , '6.1475409836066' , '22' , '0' , '90.00' ) 
07/05/2025 12:49:35 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1544' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 
07/05/2025 12:49: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' ,
                          '1544' ,
                          '2025-05-07' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '5.20' ,
                          '4.26' ,
                          NOW() ,
                          NOW() ) 
07/05/2025 12:49: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 = '97039' 
07/05/2025 12:49:35 pm >>  DELETE FROM ps_document_detail WHERE id_document = '97039' 
07/05/2025 12:49: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
                            ( '97039' , '22501' , 'BRACCIALE COLORATO PRIMA COMUNIONE' , '1' ,  '-1' , '1' ,
                               '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 
07/05/2025 12:49: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
                            ( '97039' , '22499' , 'BRACCIALE PRIMA COMUNIONE' , '1' ,  '-1' , '1' ,
                               '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 
07/05/2025 12:49: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
                            ( '97039' , '7922' , 'PERGAMENE - ANNIVERSARIO MATRIM. MOD. B' , '5' ,  '-5' , '1' ,
                               '0.50' , '0.40983606557377' , '22' , '0' , '2.50' ) 
07/05/2025 12:49:48 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1545' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 
07/05/2025 12:49:48 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '1545' ,
                          '2025-05-07' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '7.90' ,
                          '6.48' ,
                          NOW() ,
                          NOW() ) 
07/05/2025 12:49:48 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97040' 
07/05/2025 12:49:48 pm >>  DELETE FROM ps_document_detail WHERE id_document = '97040' 
07/05/2025 12:49:48 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '97040' , '1621' , 'CANDELE CONICHE 10 PZ' , '1' ,  '-1' , '1' ,
                               '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 
07/05/2025 12:50:52 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1546' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 
07/05/2025 12:50:52 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' ,
                          '1546' ,
                          '2025-05-07' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '65.00' ,
                          '53.28' ,
                          NOW() ,
                          NOW() ) 
07/05/2025 12:50:52 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 = '97041' 
07/05/2025 12:50:52 pm >>  DELETE FROM ps_document_detail WHERE id_document = '97041' 
07/05/2025 12:50: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
                            ( '97041' , '18239' , 'SERVIZIO MESSA - MARIANO M/L - 7051' , '1' ,  '-1' , '1' ,
                               '65.00' , '53.27868852459' , '22' , '0' , '65.00' ) 
07/05/2025 12:55:31 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1547' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 
07/05/2025 12:55:31 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' ,
                          '1547' ,
                          '2025-05-07' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '11.00' ,
                          '9.02' ,
                          NOW() ,
                          NOW() ) 
07/05/2025 12:55:31 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 = '97042' 
07/05/2025 12:55:31 pm >>  DELETE FROM ps_document_detail WHERE id_document = '97042' 
07/05/2025 12:55:31 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '97042' , '7940' , 'PERGAMENE - OCCASIONI MOD. A' , '11' ,  '-11' , '1' ,
                               '0.50' , '0.40983606557377' , '22' , '0' , '5.50' ) 
07/05/2025 12:55:31 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '97042' , '16311' , 'DECINA MISSIONARIA - FR17-2' , '11' ,  '-11' , '1' ,
                               '0.50' , '0.40983606557377' , '22' , '0' , '5.50' ) 
07/05/2025 12:55:46 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1548' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 
07/05/2025 12:55:46 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '1548' ,
                          '2025-05-07' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '18.00' ,
                          '18.00' ,
                          NOW() ,
                          NOW() ) 
07/05/2025 12:55:46 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97043' 
07/05/2025 12:55:46 pm >>  DELETE FROM ps_document_detail WHERE id_document = '97043' 
07/05/2025 12:55:46 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '97043' , '11151' , 'LIBRI' , '1' ,  '-1' , '4' ,
                               '18' , '18' , '0' , '0' , '18.00' ) 
07/05/2025 03:28:53 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1549' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 
07/05/2025 03:28:53 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' ,
                          '1549' ,
                          '2025-05-07' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '90.00' ,
                          '73.77' ,
                          NOW() ,
                          NOW() ) 
07/05/2025 03:28:53 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 = '97044' 
07/05/2025 03:28:53 pm >>  DELETE FROM ps_document_detail WHERE id_document = '97044' 
07/05/2025 03:28:53 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '97044' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' ,  '-1' , '1' ,
                               '12.5' , '10.245901639344' , '22' , '0' , '12.50' ) 
07/05/2025 03:28:53 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '97044' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '15' ,  '-15' , '1' ,
                               '0.70' , '0.57377049180328' , '22' , '0' , '10.50' ) 
07/05/2025 03:28:53 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '97044' , '20516' , 'CROCE COMUNIONE - 42/08' , '11' ,  '-11' , '1' ,
                               '1.20' , '0.98360655737705' , '22' , '0' , '13.20' ) 
07/05/2025 03:28:53 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '97044' , '22354' , 'CROCE SACRAMENTI VARI - 646' , '11' ,  '-11' , '1' ,
                               '1.80' , '1.4754098360656' , '22' , '0' , '19.80' ) 
07/05/2025 03:28:53 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '97044' , '17617' , 'IMMAGINI ISONZO X 100' , '10' ,  '-10' , '1' ,
                               '3.4' , '2.7868852459016' , '22' , '0' , '34.00' ) 
07/05/2025 03:41:23 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1550' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 
07/05/2025 03:41:23 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' ,
                          '1550' ,
                          '2025-05-07' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '249.00' ,
                          '204.10' ,
                          NOW() ,
                          NOW() ) 
07/05/2025 03:41:23 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97045' 
07/05/2025 03:41:23 pm >>  DELETE FROM ps_document_detail WHERE id_document = '97045' 
07/05/2025 03:41: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
                            ( '97045' , '14920' , 'CASULA AVE MARIA - PCA032' , '1' ,  '-1' , '1' ,
                               '88' , '72.131147540984' , '22' , '0' , '88.00' ) 
07/05/2025 03:41: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
                            ( '97045' , '18239' , 'SERVIZIO MESSA - MARIANO M/L - 7051' , '1' ,  '-1' , '1' ,
                               '62' , '50.819672131148' , '22' , '0' , '62.00' ) 
07/05/2025 03:41: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
                            ( '97045' , '16958' , 'SERVIZIO MESSA M/LINO MARIANO - 6990' , '1' ,  '-1' , '1' ,
                               '50' , '40.983606557377' , '22' , '0' , '50.00' ) 
07/05/2025 03:41: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
                            ( '97045' , '19099' , 'INCENSO A' , '1' ,  '-1' , '1' ,
                               '49.00' , '40.16393442623' , '22' , '0' , '49.00' ) 
07/05/2025 03:43:04 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1550' AND id_document != '97045' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 
07/05/2025 03:43:05 pm >> UPDATE ps_document SET
                          id_document_type = '11',
                          document_num = '1550',
                          document_date = '2025-05-07',
                          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 = '249.00',
                          price_tax_excluded = '204.10',
                          date_upd = NOW()
                        WHERE id_document = '97045' 
07/05/2025 03:43:05 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 = '97045' 
07/05/2025 03:43:05 pm >>  DELETE FROM ps_document_detail WHERE id_document = '97045' 
07/05/2025 03:43:05 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '97045' , '14920' , 'CASULA AVE MARIA - PCA032' , '1' ,  '-1' , '1' ,
                               '90' , '73.770491803279' , '22' , '0' , '90.00' ) 
07/05/2025 03:43:05 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '97045' , '18239' , 'SERVIZIO MESSA - MARIANO M/L - 7051' , '1' ,  '-1' , '1' ,
                               '64' , '52.459016393443' , '22' , '0' , '64.00' ) 
07/05/2025 03:43:05 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '97045' , '16958' , 'SERVIZIO MESSA M/LINO MARIANO - 6990' , '1' ,  '-1' , '1' ,
                               '50.0000' , '40.983606557377' , '22' , '0' , '50.00' ) 
07/05/2025 03:43:05 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '97045' , '19099' , 'INCENSO A' , '1' ,  '-1' , '1' ,
                               '45' , '36.885245901639' , '22' , '0' , '45.00' ) 
07/05/2025 05:59:44 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1551' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 
07/05/2025 05:59:45 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '1551' ,
                          '2025-05-07' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '2.30' ,
                          '2.25' ,
                          NOW() ,
                          NOW() ) 
07/05/2025 05:59: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 = '97046' 
07/05/2025 05:59:45 pm >>  DELETE FROM ps_document_detail WHERE id_document = '97046' 
07/05/2025 05:59: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
                            ( '97046' , '16059' , 'MEDAGLIA S. PELLEGRINO - FM022' , '1' ,  '-1' , '1' ,
                               '0.30' , '0.24590163934426' , '22' , '0' , '0.30' ) 
07/05/2025 05:59: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
                            ( '97046' , '11151' , 'LIBRI' , '1' ,  '-1' , '4' ,
                               '2' , '2' , '0' , '0' , '2.00' ) 
07/05/2025 06:19:44 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1552' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 
07/05/2025 06:19:44 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '1552' ,
                          '2025-05-07' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '8.00' ,
                          '6.56' ,
                          NOW() ,
                          NOW() ) 
07/05/2025 06:19: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 = '97047' 
07/05/2025 06:19:44 pm >>  DELETE FROM ps_document_detail WHERE id_document = '97047' 
07/05/2025 06:19: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
                            ( '97047' , '22198' , 'CORONCINA PRIMA COMUNIONE - 3313' , '1' ,  '-1' , '1' ,
                               '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 
07/05/2025 06:27:58 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1553' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 
07/05/2025 06:27:58 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '1553' ,
                          '2025-05-07' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '10.00' ,
                          '10.00' ,
                          NOW() ,
                          NOW() ) 
07/05/2025 06:27: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 = '97048' 
07/05/2025 06:27:58 pm >>  DELETE FROM ps_document_detail WHERE id_document = '97048' 
07/05/2025 06:27: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
                            ( '97048' , '11151' , 'LIBRI' , '1' ,  '-1' , '4' ,
                               '10' , '10' , '0' , '0' , '10.00' ) 
07/05/2025 06:28:18 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1554' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 
07/05/2025 06:28:18 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '1554' ,
                          '2025-05-07' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '4.75' ,
                          '4.75' ,
                          NOW() ,
                          NOW() ) 
07/05/2025 06:28: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 = '97049' 
07/05/2025 06:28:18 pm >>  DELETE FROM ps_document_detail WHERE id_document = '97049' 
07/05/2025 06:28:19 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '97049' , '23536' , 'SULLA TUA PAROLA - MAG/GIU 25' , '1' ,  '-1' , '4' ,
                               '5.00' , '5' , '0' , '5' , '4.75' ) 
07/05/2025 06:58:59 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1555' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 
07/05/2025 06:58:59 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '1555' ,
                          '2025-05-07' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '123.90' ,
                          '102.26' ,
                          NOW() ,
                          NOW() ) 
07/05/2025 06:58:59 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97050' 
07/05/2025 06:58:59 pm >>  DELETE FROM ps_document_detail WHERE id_document = '97050' 
07/05/2025 06:58: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
                            ( '97050' , '23225' , 'STOLA MARIANA - ST08' , '1' ,  '-1' , '1' ,
                               '120.00' , '98.360655737705' , '22' , '0' , '120.00' ) 
07/05/2025 06:58: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
                            ( '97050' , '22813' , 'GIUBILEO SPIEGATO AI BAMBINI' , '1' ,  '-1' , '4' ,
                               '3.90' , '3.9' , '0' , '0' , '3.90' ) 
07/05/2025 07:43:09 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1556' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 
07/05/2025 07:43:09 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' ,
                          '1556' ,
                          '2025-05-07' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '51.00' ,
                          '41.80' ,
                          NOW() ,
                          NOW() ) 
07/05/2025 07:43: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 = '97051' 
07/05/2025 07:43:09 pm >>  DELETE FROM ps_document_detail WHERE id_document = '97051' 
07/05/2025 07:43: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
                            ( '97051' , '7202' , 'ARTICOLI RELIGIOSI' , '1' ,  '-1' , '1' ,
                               '45' , '36.885245901639' , '22' , '0' , '45.00' ) 
07/05/2025 07:43: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
                            ( '97051' , '13562' , 'CORONCINA IN STOFFA CON ROSE E FOGLIOLINE - 3311' , '1' ,  '-1' , '1' ,
                               '6.00' , '4.9180327868852' , '22' , '0' , '6.00' )