15/11/2023 08:42:09 am >> INSERT INTO ps_customer
                          ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` )
                                VALUES
                          ( '1' , '' , '' , '' , 'zXjKYbcBNXHqdD0S' , NOW() , NOW() ) 
15/11/2023 08:42:09 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4055' , '1' )
15/11/2023 08:42:09 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4055' , '2' )
15/11/2023 08:42:09 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4055' , '3' )
15/11/2023 08:45:33 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4055' 
15/11/2023 08:45:33 am >> INSERT INTO ps_address
            ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd )
            VALUES (
              '4055' ,
              '10' ,
              '145' ,
              'PARR. SS. ANNUNZIATA' ,
              'LUCCA' ,
              'DON VALERIO' ,
              'VIA ANNUNZIATA 56' ,
              '' ,
              '81046' ,
              'GRAZZANISE' ,
              'ORDINE E SPEDIZIONE: : Palazzo Angelica, via Cesare Battisti, 65 cap.81046 Grazzanise Ce\r\nTEL. 3381678325 EMAIL angelicapalazzo@virgilio.it' ,
              '' ,
              '' ,
              '' ,
              '93011810616' ,
              NOW()  ,
              NOW()  ) 
15/11/2023 08:45:33 am >> UPDATE ps_customer SET
                email = '',
                sdi = '',
                pec = '',
                date_upd = NOW()
          WHERE id_customer = '4055' 
15/11/2023 08:47:12 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '268' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-15') 
15/11/2023 08:47:12 am >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '21' ,
                          '268' ,
                          '2023-11-15' ,
                          '' ,
                          '4055' ,
                          '0' ,
                          '4679189' ,
                          'VIA ANNUNZIATA 56 81046 GRAZZANISE' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '6' ,
                          '0' ,
                          '81.95' ,
                          '81.95' ,
                          NOW() ,
                          NOW() ) 
15/11/2023 08:47:12 am >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88961' 
15/11/2023 08:47:12 am >>  DELETE FROM ps_document_detail WHERE id_document = '88961' 
15/11/2023 08:47:12 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88961' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '18' ,  '-18' , '4' ,
                               '3.50' , '3.5' , '0' , '15' , '53.55' ) 
15/11/2023 08:47:12 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88961' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' ,  '-1' , '4' ,
                               '10.00' , '10' , '0' , '15' , '8.50' ) 
15/11/2023 08:47:12 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88961' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' ,  '-1' , '4' ,
                               '10.00' , '10' , '0' , '15' , '8.50' ) 
15/11/2023 08:47:12 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88961' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' ,  '-1' , '4' ,
                               '10.00' , '10' , '0' , '15' , '8.50' ) 
15/11/2023 08:47:12 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88961' , '' , 'SPESE DI CONTRASEGNO' , '1' ,  '-1' , '4' ,
                               '2.9' , '2.9' , '0' , '0' , '2.90' ) 
15/11/2023 09:35:16 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '3611' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-15') 
15/11/2023 09:35:16 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' ,
                          '3611' ,
                          '2023-11-15' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '19.00' ,
                          '15.57' ,
                          NOW() ,
                          NOW() ) 
15/11/2023 09:35:16 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 = '88962' 
15/11/2023 09:35:16 am >>  DELETE FROM ps_document_detail WHERE id_document = '88962' 
15/11/2023 09:35:16 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88962' , '17617' , 'IMMAGINI ISONZO X 100' , '5' ,  '-5' , '1' ,
                               '3.80' , '3.1147540983607' , '22' , '0' , '19.00' ) 
15/11/2023 10:18:59 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 
15/11/2023 10:18:59 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21827' , '1' , '' , 'nuovo-prodotto' )
15/11/2023 10:18:59 am >> INSERT INTO ps_product_shop (
                      id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
                  ) VALUES (
                      '21827' , '1' , '1' , '2' , NOW() , NOW()
                  ) 
15/11/2023 10:18:59 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21827' , '0' , '1' , '0' , '0' )
15/11/2023 10:24:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868946616' AND id_product != '21827' AND ean13 != '' 
15/11/2023 10:24:11 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '7/6',
                  ean13 = '9788868946616',
                  date_upd = NOW()
                WHERE id_product = '21827' 
15/11/2023 10:24:11 am >> UPDATE ps_product_lang SET
                  name = 'GIOIA DEL CUORE - C. STERCAL',
                  description = ''
                WHERE id_product = '21827' 
15/11/2023 10:24:11 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '10'
                WHERE id_product = '21827' 
15/11/2023 10:24:11 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '10',
                  id_tax_rules_group = '4',
                  id_category_default = '103',
                  id_argoment_default = '23',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '21827' 
15/11/2023 10:24:11 am >> DELETE FROM ps_specific_price WHERE id_product = '21827' 
15/11/2023 10:24:13 am >> INSERT INTO ps_product (
                  id_tax_rules_group , `date_add` , `date_upd`
                ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21827' 
15/11/2023 10:24:13 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21828' , '1' , '' , 'nuovo-prodotto' )
15/11/2023 10:24:13 am >> INSERT INTO ps_product_shop (
                    id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd`
                ) SELECT '21828' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21827' 
15/11/2023 10:24:13 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '21828' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21827' 
15/11/2023 10:25:35 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886833059' AND id_product != '21828' AND ean13 != '' 
15/11/2023 10:25:35 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '11/3',
                  ean13 = '9788886833059',
                  date_upd = NOW()
                WHERE id_product = '21828' 
15/11/2023 10:25:35 am >> UPDATE ps_product_lang SET
                  name = 'VANGELO DI GESU\' ',
                  description = ''
                WHERE id_product = '21828' 
15/11/2023 10:25:35 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '3.1'
                WHERE id_product = '21828' 
15/11/2023 10:25:35 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '3.1',
                  id_tax_rules_group = '4',
                  id_category_default = '246',
                  id_argoment_default = '170',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '21828' 
15/11/2023 10:25:35 am >> DELETE FROM ps_specific_price WHERE id_product = '21828' 
15/11/2023 10:33:36 am >> INSERT INTO ps_product (
                  id_tax_rules_group , `date_add` , `date_upd`
                ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21828' 
15/11/2023 10:33:36 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21829' , '1' , '' , 'nuovo-prodotto' )
15/11/2023 10:33:36 am >> INSERT INTO ps_product_shop (
                    id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd`
                ) SELECT '21829' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21828' 
15/11/2023 10:33:36 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '21829' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21828' 
15/11/2023 10:34:21 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788821595400' AND id_product != '21829' AND ean13 != '' 
15/11/2023 10:34:21 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '6/2',
                  ean13 = '9788821595400',
                  date_upd = NOW()
                WHERE id_product = '21829' 
15/11/2023 10:34:21 am >> UPDATE ps_product_lang SET
                  name = 'ANIMA DI OGNI APOSTOLATO - D. CHAUTARD',
                  description = ''
                WHERE id_product = '21829' 
15/11/2023 10:34:21 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '9.9'
                WHERE id_product = '21829' 
15/11/2023 10:34:21 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '9.9',
                  id_tax_rules_group = '4',
                  id_category_default = '30',
                  id_argoment_default = '74',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '21829' 
15/11/2023 10:34:21 am >> DELETE FROM ps_specific_price WHERE id_product = '21829' 
15/11/2023 10:37:29 am >> INSERT INTO ps_product (
                  id_tax_rules_group , `date_add` , `date_upd`
                ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21829' 
15/11/2023 10:37:29 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21830' , '1' , '' , 'nuovo-prodotto' )
15/11/2023 10:37:29 am >> INSERT INTO ps_product_shop (
                    id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd`
                ) SELECT '21830' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21829' 
15/11/2023 10:37:29 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '21830' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21829' 
15/11/2023 10:38:15 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839912749' AND id_product != '21830' AND ean13 != '' 
15/11/2023 10:38:15 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '',
                  ean13 = '9788839912749',
                  date_upd = NOW()
                WHERE id_product = '21830' 
15/11/2023 10:38:15 am >> UPDATE ps_product_lang SET
                  name = 'GESU\' VIA ALLA LIBERTA\' - A. GRUN',
                  description = ''
                WHERE id_product = '21830' 
15/11/2023 10:38:15 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '11'
                WHERE id_product = '21830' 
15/11/2023 10:38:15 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '11',
                  id_tax_rules_group = '4',
                  id_category_default = '111',
                  id_argoment_default = '20',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '21830' 
15/11/2023 10:38:15 am >> DELETE FROM ps_specific_price WHERE id_product = '21830' 
15/11/2023 10:38:40 am >> INSERT INTO ps_product (
                  id_tax_rules_group , `date_add` , `date_upd`
                ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21830' 
15/11/2023 10:38:40 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21831' , '1' , '' , 'nuovo-prodotto' )
15/11/2023 10:38:40 am >> INSERT INTO ps_product_shop (
                    id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd`
                ) SELECT '21831' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21830' 
15/11/2023 10:38:40 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '21831' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21830' 
15/11/2023 10:39:14 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839928337' AND id_product != '21831' AND ean13 != '' 
15/11/2023 10:39:14 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '',
                  ean13 = '9788839928337',
                  date_upd = NOW()
                WHERE id_product = '21831' 
15/11/2023 10:39:14 am >> UPDATE ps_product_lang SET
                  name = 'GUIDA PER L\'AVVENTO - A. GRUN',
                  description = ''
                WHERE id_product = '21831' 
15/11/2023 10:39:14 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '17'
                WHERE id_product = '21831' 
15/11/2023 10:39:14 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '17',
                  id_tax_rules_group = '4',
                  id_category_default = '111',
                  id_argoment_default = '39',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '21831' 
15/11/2023 10:39:14 am >> DELETE FROM ps_specific_price WHERE id_product = '21831' 
15/11/2023 10:39:33 am >> INSERT INTO ps_product (
                  id_tax_rules_group , `date_add` , `date_upd`
                ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21831' 
15/11/2023 10:39:33 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21832' , '1' , '' , 'nuovo-prodotto' )
15/11/2023 10:39:33 am >> INSERT INTO ps_product_shop (
                    id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd`
                ) SELECT '21832' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21831' 
15/11/2023 10:39:33 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '21832' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21831' 
15/11/2023 10:42:40 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '3612' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-15') 
15/11/2023 10:42:40 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' ,
                          '3612' ,
                          '2023-11-15' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '50.80' ,
                          '41.64' ,
                          NOW() ,
                          NOW() ) 
15/11/2023 10:42:40 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 = '88963' 
15/11/2023 10:42:40 am >>  DELETE FROM ps_document_detail WHERE id_document = '88963' 
15/11/2023 10:42:40 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88963' , '21137' , 'MOCCOLO 70X200' , '5' ,  '-5' , '1' ,
                               '7' , '5.7377049180328' , '22' , '0' , '35.00' ) 
15/11/2023 10:42:40 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88963' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' ,  '-2' , '1' ,
                               '7.90' , '6.4754098360656' , '22' , '0' , '15.80' ) 
15/11/2023 10:43:44 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892243231' AND id_product != '21832' AND ean13 != '' 
15/11/2023 10:43:44 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '7/6',
                  ean13 = '9788892243231',
                  date_upd = NOW()
                WHERE id_product = '21832' 
15/11/2023 10:43:44 am >> UPDATE ps_product_lang SET
                  name = 'PICCOLO LIBRO DELLA PREGHIERA DI QUIETE - P. DYCKHOFF',
                  description = ''
                WHERE id_product = '21832' 
15/11/2023 10:43:44 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '15'
                WHERE id_product = '21832' 
15/11/2023 10:43:44 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '15',
                  id_tax_rules_group = '4',
                  id_category_default = '30',
                  id_argoment_default = '23',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '21832' 
15/11/2023 10:43:44 am >> DELETE FROM ps_specific_price WHERE id_product = '21832' 
15/11/2023 10:44:47 am >> INSERT INTO ps_product (
                  id_tax_rules_group , `date_add` , `date_upd`
                ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21832' 
15/11/2023 10:44:47 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21833' , '1' , '' , 'nuovo-prodotto' )
15/11/2023 10:44:47 am >> INSERT INTO ps_product_shop (
                    id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd`
                ) SELECT '21833' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21832' 
15/11/2023 10:44:48 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '21833' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21832' 
15/11/2023 10:45:21 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801068573' AND id_product != '21833' AND ean13 != '' 
15/11/2023 10:45:21 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '',
                  ean13 = '9788801068573',
                  date_upd = NOW()
                WHERE id_product = '21833' 
15/11/2023 10:45:21 am >> UPDATE ps_product_lang SET
                  name = '5 CIOTTOLI DI DAVIDE ',
                  description = ''
                WHERE id_product = '21833' 
15/11/2023 10:45:21 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '7.9'
                WHERE id_product = '21833' 
15/11/2023 10:45:21 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '7.9',
                  id_tax_rules_group = '4',
                  id_category_default = '19',
                  id_argoment_default = '23',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '21833' 
15/11/2023 10:45:21 am >> DELETE FROM ps_specific_price WHERE id_product = '21833' 
15/11/2023 10:45:46 am >> INSERT INTO ps_product (
                  id_tax_rules_group , `date_add` , `date_upd`
                ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21833' 
15/11/2023 10:45:46 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21834' , '1' , '' , 'nuovo-prodotto' )
15/11/2023 10:45:47 am >> INSERT INTO ps_product_shop (
                    id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd`
                ) SELECT '21834' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21833' 
15/11/2023 10:45:47 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '21834' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21833' 
15/11/2023 10:46:24 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886242431' AND id_product != '21834' AND ean13 != '' 
15/11/2023 10:46:24 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '',
                  ean13 = '9788886242431',
                  date_upd = NOW()
                WHERE id_product = '21834' 
15/11/2023 10:46:24 am >> UPDATE ps_product_lang SET
                  name = 'PAPIA ',
                  description = ''
                WHERE id_product = '21834' 
15/11/2023 10:46:24 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '7.8'
                WHERE id_product = '21834' 
15/11/2023 10:46:24 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '7.8',
                  id_tax_rules_group = '4',
                  id_category_default = '83',
                  id_argoment_default = '23',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '21834' 
15/11/2023 10:46:24 am >> DELETE FROM ps_specific_price WHERE id_product = '21834' 
15/11/2023 10:47:01 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886242431' AND id_product != '21834' AND ean13 != '' 
15/11/2023 10:47:01 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '',
                  ean13 = '9788886242431',
                  date_upd = NOW()
                WHERE id_product = '21834' 
15/11/2023 10:47:01 am >> UPDATE ps_product_lang SET
                  name = 'PAPIA ',
                  description = ''
                WHERE id_product = '21834' 
15/11/2023 10:47:01 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '7.8'
                WHERE id_product = '21834' 
15/11/2023 10:47:01 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '7.8',
                  id_tax_rules_group = '4',
                  id_category_default = '83',
                  id_argoment_default = '23',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '21834' 
15/11/2023 10:47:01 am >> DELETE FROM ps_specific_price WHERE id_product = '21834' 
15/11/2023 10:47:04 am >> INSERT INTO ps_product (
                  id_tax_rules_group , `date_add` , `date_upd`
                ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21834' 
15/11/2023 10:47:04 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21835' , '1' , '' , 'nuovo-prodotto' )
15/11/2023 10:47:04 am >> INSERT INTO ps_product_shop (
                    id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd`
                ) SELECT '21835' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21834' 
15/11/2023 10:47:04 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '21835' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21834' 
15/11/2023 10:47:47 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831522854' AND id_product != '21835' AND ean13 != '' 
15/11/2023 10:47:47 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '',
                  ean13 = '9788831522854',
                  date_upd = NOW()
                WHERE id_product = '21835' 
15/11/2023 10:47:47 am >> UPDATE ps_product_lang SET
                  name = 'DIDACHE\' ',
                  description = ''
                WHERE id_product = '21835' 
15/11/2023 10:47:47 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '7.5'
                WHERE id_product = '21835' 
15/11/2023 10:47:47 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '7.5',
                  id_tax_rules_group = '4',
                  id_category_default = '27',
                  id_argoment_default = '23',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '21835' 
15/11/2023 10:47:47 am >> DELETE FROM ps_specific_price WHERE id_product = '21835' 
15/11/2023 10:48:09 am >> INSERT INTO ps_product (
                  id_tax_rules_group , `date_add` , `date_upd`
                ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21835' 
15/11/2023 10:48:09 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21836' , '1' , '' , 'nuovo-prodotto' )
15/11/2023 10:48:09 am >> INSERT INTO ps_product_shop (
                    id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd`
                ) SELECT '21836' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21835' 
15/11/2023 10:48:09 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '21836' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21835' 
15/11/2023 10:48:56 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868946326' AND id_product != '21836' AND ean13 != '' 
15/11/2023 10:48:56 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '13/4',
                  ean13 = '9788868946326',
                  date_upd = NOW()
                WHERE id_product = '21836' 
15/11/2023 10:48:57 am >> UPDATE ps_product_lang SET
                  name = 'DONO PER TUTTI',
                  description = ''
                WHERE id_product = '21836' 
15/11/2023 10:48:57 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '2.7'
                WHERE id_product = '21836' 
15/11/2023 10:48:57 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '2.7',
                  id_tax_rules_group = '4',
                  id_category_default = '103',
                  id_argoment_default = '39',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '21836' 
15/11/2023 10:48:57 am >> DELETE FROM ps_specific_price WHERE id_product = '21836' 
15/11/2023 10:50:11 am >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '33' ,
                          '648385' ,
                          '2023-11-13' ,
                          '' ,
                          '0' ,
                          '7' ,
                          '2602' ,
                          'P. ZZA SAN PAOLO, 14 12051 ALBA' ,
                          '' ,
                          '' ,
                          '19.22' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '11' ,
                          '0' ,
                          '638.63' ,
                          '635.44' ,
                          NOW() ,
                          NOW() ) 
15/11/2023 10:50:11 am >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88964' 
15/11/2023 10:50:11 am >>  DELETE FROM ps_document_detail WHERE id_document = '88964' 
15/11/2023 10:50:11 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88964' , '21827' , 'GIOIA DEL CUORE - C. STERCAL' , '1' ,  '1' , '4' ,
                               '10.00' , '10' , '0' , '30' , '7.0000' ) 
15/11/2023 10:50:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '21827' AND id_supplier = '7' 
15/11/2023 10:50:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21827' , '7' , '1' ) 
15/11/2023 10:50:11 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88964' , '21828' , 'VANGELO DI GESU ' , '9' ,  '9' , '4' ,
                               '3.10' , '3.1' , '0' , '30' , '19.5300' ) 
15/11/2023 10:50:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '21828' AND id_supplier = '7' 
15/11/2023 10:50:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21828' , '7' , '1' ) 
15/11/2023 10:50:11 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88964' , '21569' , 'DOMENICHE DA COLORARE - ANNO B ' , '1' ,  '1' , '4' ,
                               '9.90' , '9.9' , '0' , '30' , '6.9300' ) 
15/11/2023 10:50:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '21569' AND id_supplier = '7' 
15/11/2023 10:50:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21569' , '7' , '1' ) 
15/11/2023 10:50:11 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88964' , '18703' , 'IN_SEGUENDO GESU A CAFARNAO' , '65' ,  '65' , '4' ,
                               '5.00' , '5' , '0' , '33+7' , '202.5075' ) 
15/11/2023 10:50:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '18703' AND id_supplier = '7' 
15/11/2023 10:50:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18703' , '7' , '1' ) 
15/11/2023 10:50:11 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88964' , '19805' , 'DESIDERIO DESIDERAVI' , '40' ,  '40' , '4' ,
                               '2.00' , '2' , '0' , '33+7' , '49.8480' ) 
15/11/2023 10:50:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '19805' AND id_supplier = '7' 
15/11/2023 10:50:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19805' , '7' , '1' ) 
15/11/2023 10:50:11 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88964' , '10751' , 'TU MI PERDONI' , '13' ,  '13' , '4' ,
                               '6.90' , '6.9' , '0' , '30+7' , '58.3947' ) 
15/11/2023 10:50:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '10751' AND id_supplier = '7' 
15/11/2023 10:50:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10751' , '7' , '1' ) 
15/11/2023 10:50:11 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88964' , '9680' , 'SARETE MIEI TESTIMONI - GUIDA 1 - MAGNIFICAT' , '2' ,  '2' , '4' ,
                               '12.00' , '12' , '0' , '35+7' , '14.5080' ) 
15/11/2023 10:50:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '9680' AND id_supplier = '7' 
15/11/2023 10:50:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9680' , '7' , '1' ) 
15/11/2023 10:50:11 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88964' , '11187' , 'VENITE CON ME - GUIDA 1 - MAGNIFICAT' , '2' ,  '2' , '4' ,
                               '12.00' , '12' , '0' , '35+7' , '14.5080' ) 
15/11/2023 10:50:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '11187' AND id_supplier = '7' 
15/11/2023 10:50:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11187' , '7' , '1' ) 
15/11/2023 10:50:11 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88964' , '21003' , 'FARE CATECHESI OGGI - U. MONTISCI' , '1' ,  '1' , '4' ,
                               '38.00' , '38' , '0' , '33+7' , '23.6778' ) 
15/11/2023 10:50:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '21003' AND id_supplier = '7' 
15/11/2023 10:50:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21003' , '7' , '1' ) 
15/11/2023 10:50:11 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88964' , '21751' , 'MESSALINO QUOTIDIANO - FEB-MAR-APR 2024' , '8' ,  '8' , '4' ,
                               '6.00' , '6' , '0' , '30+7' , '31.2480' ) 
15/11/2023 10:50:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '21751' AND id_supplier = '7' 
15/11/2023 10:50:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21751' , '7' , '1' ) 
15/11/2023 10:50:11 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88964' , '21629' , 'MANUALE DI AMMINISTRAZIONE DELLE PARROCCHIE' , '1' ,  '1' , '4' ,
                               '25.00' , '25' , '0' , '33+7' , '15.5775' ) 
15/11/2023 10:50:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '21629' AND id_supplier = '7' 
15/11/2023 10:50:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21629' , '7' , '1' ) 
15/11/2023 10:50:12 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88964' , '21829' , 'ANIMA DI OGNI APOSTOLATO - D. CHAUTARD' , '1' ,  '1' , '4' ,
                               '9.90' , '9.9' , '0' , '33+7' , '6.1687' ) 
15/11/2023 10:50:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '21829' AND id_supplier = '7' 
15/11/2023 10:50:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21829' , '7' , '1' ) 
15/11/2023 10:50:12 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88964' , '18692' , 'IN_SEGUENDO GESU - GUIDA' , '1' ,  '1' , '4' ,
                               '12.00' , '12' , '0' , '33+7' , '7.4772' ) 
15/11/2023 10:50:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '18692' AND id_supplier = '7' 
15/11/2023 10:50:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18692' , '7' , '1' ) 
15/11/2023 10:50:12 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88964' , '21410' , 'IO E CARLO - M. PAPPALARDO' , '3' ,  '3' , '4' ,
                               '11.90' , '11.9' , '0' , '35+7' , '21.5806' ) 
15/11/2023 10:50:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '21410' AND id_supplier = '7' 
15/11/2023 10:50:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21410' , '7' , '1' ) 
15/11/2023 10:50:12 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88964' , '21563' , 'AGENDA SAN PAOLO 2024' , '3' ,  '3' , '1' ,
                               '4.83' , '3.9590163934426' , '22' , '0' , '17.6778' ) 
15/11/2023 10:50:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '21563' AND id_supplier = '7' 
15/11/2023 10:50:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21563' , '7' , '1' ) 
15/11/2023 10:50:12 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88964' , '21755' , 'PAROLA DI DIO OGNI GIORNO 2024 - V. PAGLIA' , '1' ,  '1' , '4' ,
                               '22.00' , '22' , '0' , '33' , '14.7400' ) 
15/11/2023 10:50:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '21755' AND id_supplier = '7' 
15/11/2023 10:50:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21755' , '7' , '1' ) 
15/11/2023 10:50:12 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88964' , '21830' , 'GESU VIA ALLA LIBERTA - A. GRUN' , '1' ,  '1' , '4' ,
                               '11.00' , '11' , '0' , '30' , '7.7000' ) 
15/11/2023 10:50:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '21830' AND id_supplier = '7' 
15/11/2023 10:50:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21830' , '7' , '1' ) 
15/11/2023 10:50:12 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88964' , '21831' , 'GUIDA PER LAVVENTO - A. GRUN' , '1' ,  '1' , '4' ,
                               '17.00' , '17' , '0' , '30' , '11.9000' ) 
15/11/2023 10:50:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '21831' AND id_supplier = '7' 
15/11/2023 10:50:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21831' , '7' , '1' ) 
15/11/2023 10:50:12 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88964' , '21832' , 'PICCOLO LIBRO DELLA PREGHIERA DI QUIETE - P. DYCKHOFF' , '1' ,  '1' , '4' ,
                               '15.00' , '15' , '0' , '33' , '10.0500' ) 
15/11/2023 10:50:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '21832' AND id_supplier = '7' 
15/11/2023 10:50:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21832' , '7' , '1' ) 
15/11/2023 10:50:12 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88964' , '21798' , 'ENCICLICA DEI BAMBINI - FORTUNATO / CAGNOLI' , '1' ,  '1' , '4' ,
                               '9.90' , '9.9' , '0' , '35' , '6.4350' ) 
15/11/2023 10:50:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '21798' AND id_supplier = '7' 
15/11/2023 10:50:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21798' , '7' , '1' ) 
15/11/2023 10:50:12 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88964' , '19550' , 'PAROLA AI GIOVANI - L. AMENDOLAGINE' , '1' ,  '1' , '4' ,
                               '16.00' , '16' , '0' , '35' , '10.4000' ) 
15/11/2023 10:50:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '19550' AND id_supplier = '7' 
15/11/2023 10:50:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19550' , '7' , '1' ) 
15/11/2023 10:50:12 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88964' , '21833' , '5 CIOTTOLI DI DAVIDE ' , '1' ,  '1' , '4' ,
                               '7.90' , '7.9' , '0' , '35' , '5.1350' ) 
15/11/2023 10:50:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '21833' AND id_supplier = '7' 
15/11/2023 10:50:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21833' , '7' , '1' ) 
15/11/2023 10:50:12 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88964' , '21834' , 'PAPIA ' , '4' ,  '4' , '4' ,
                               '7.80' , '7.8' , '0' , '30' , '21.8400' ) 
15/11/2023 10:50:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '21834' AND id_supplier = '7' 
15/11/2023 10:50:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21834' , '7' , '1' ) 
15/11/2023 10:50:13 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88964' , '21835' , 'DIDACHE ' , '5' ,  '5' , '4' ,
                               '7.50' , '7.5' , '0' , '33' , '25.1250' ) 
15/11/2023 10:50:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '21835' AND id_supplier = '7' 
15/11/2023 10:50:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21835' , '7' , '1' ) 
15/11/2023 10:50:13 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88964' , '21836' , 'DONO PER TUTTI' , '5' ,  '5' , '4' ,
                               '2.70' , '2.7' , '0' , '30' , '9.4500' ) 
15/11/2023 10:50:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '21836' AND id_supplier = '7' 
15/11/2023 10:50:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21836' , '7' , '1' ) 
15/11/2023 11:01:49 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '3613' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-15') 
15/11/2023 11:01:49 am >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '3613' ,
                          '2023-11-15' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '42.75' ,
                          '42.75' ,
                          NOW() ,
                          NOW() ) 
15/11/2023 11:01:49 am >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88965' 
15/11/2023 11:01:49 am >>  DELETE FROM ps_document_detail WHERE id_document = '88965' 
15/11/2023 11:01:49 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88965' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '9' ,  '-9' , '4' ,
                               '5.00' , '5' , '0' , '5' , '42.75' ) 
15/11/2023 11:28:46 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '269' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-15') 
15/11/2023 11:28:46 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  (
                          '21' ,
                          '269' ,
                          '2023-11-15' ,
                          '' ,
                          '1138' ,
                          '0' ,
                          '4672220' ,
                          'P. ZZA AMENDOLA - LANZARA 84083 CASTEL SAN GIORGIO' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '1' ,
                          '0' ,
                          '363.38' ,
                          '363.38' ,
                          NOW() ,
                          NOW() ) 
15/11/2023 11:28: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 = '88966' 
15/11/2023 11:28:46 am >>  DELETE FROM ps_document_detail WHERE id_document = '88966' 
15/11/2023 11:28: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
                            ( '88966' , '2679' , 'CONOSCERE GESU\'' , '42' ,  '-42' , '4' ,
                               '3.50' , '3.5' , '0' , '15' , '124.95' ) 
15/11/2023 11:28: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
                            ( '88966' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' ,  '-1' , '4' ,
                               '5.00' , '5' , '0' , '15' , '4.25' ) 
15/11/2023 11:28: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
                            ( '88966' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '38' ,  '-38' , '4' ,
                               '3.50' , '3.5' , '0' , '15' , '113.05' ) 
15/11/2023 11:28: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
                            ( '88966' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '2' ,  '-2' , '4' ,
                               '10.00' , '10' , '0' , '15' , '17.00' ) 
15/11/2023 11:28: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
                            ( '88966' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '35' ,  '-35' , '4' ,
                               '3.50' , '3.5' , '0' , '15' , '104.13' ) 
15/11/2023 11:36:41 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '3614' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-15') 
15/11/2023 11:36:41 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' ,
                          '3614' ,
                          '2023-11-15' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '299.73' ,
                          '299.73' ,
                          NOW() ,
                          NOW() ) 
15/11/2023 11:36:41 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 = '88967' 
15/11/2023 11:36:41 am >>  DELETE FROM ps_document_detail WHERE id_document = '88967' 
15/11/2023 11:36:41 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88967' , '19805' , 'DESIDERIO DESIDERAVI' , '30' ,  '-30' , '4' ,
                               '2.00' , '2' , '0' , '5' , '57.00' ) 
15/11/2023 11:36:41 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88967' , '21826' , 'NATALE DI FRANCESCO A GRECCIO - A. CACCIOTTI' , '1' ,  '-1' , '4' ,
                               '26.00' , '26' , '0' , '5' , '24.70' ) 
15/11/2023 11:36:42 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88967' , '18703' , 'IN_SEGUENDO GESU A CAFARNAO' , '40' ,  '-40' , '4' ,
                               '5.00' , '5' , '0' , '5' , '190.00' ) 
15/11/2023 11:36:42 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88967' , '21626' , 'MISSIONE NATALE' , '1' ,  '-1' , '4' ,
                               '2.50' , '2.5' , '0' , '5' , '2.38' ) 
15/11/2023 11:36:42 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88967' , '21817' , 'SI RITIRO A PREGARE - A. GRAPPONE' , '1' ,  '-1' , '4' ,
                               '12.00' , '12' , '0' , '5' , '11.40' ) 
15/11/2023 11:36:42 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88967' , '21467' , 'ADOLESCENTI INAFFERRABILI - BOTTA / LONARDO' , '1' ,  '-1' , '4' ,
                               '15.00' , '15' , '0' , '5' , '14.25' ) 
15/11/2023 11:42:50 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 
15/11/2023 11:42:50 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21837' , '1' , '' , 'nuovo-prodotto' )
15/11/2023 11:42:50 am >> INSERT INTO ps_product_shop (
                      id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
                  ) VALUES (
                      '21837' , '1' , '1' , '2' , NOW() , NOW()
                  ) 
15/11/2023 11:42:50 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21837' , '0' , '1' , '0' , '0' )
15/11/2023 11:44:19 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048646' AND id_product != '21837' AND ean13 != '' 
15/11/2023 11:44:19 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = 'ESPOSITORE SHALOM',
                  ean13 = '9788884048646',
                  date_upd = NOW()
                WHERE id_product = '21837' 
15/11/2023 11:44:19 am >> UPDATE ps_product_lang SET
                  name = 'CAMMINO DELLA PREGHIERA - P. SCIADINI - 8484',
                  description = ''
                WHERE id_product = '21837' 
15/11/2023 11:44:19 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '7'
                WHERE id_product = '21837' 
15/11/2023 11:44:19 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '7',
                  id_tax_rules_group = '4',
                  id_category_default = '106',
                  id_argoment_default = '41',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '21837' 
15/11/2023 11:44:19 am >> DELETE FROM ps_specific_price WHERE id_product = '21837' 
15/11/2023 11:46:21 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '3615' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-15') 
15/11/2023 11:46:21 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' ,
                          '3615' ,
                          '2023-11-15' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '24.50' ,
                          '20.08' ,
                          NOW() ,
                          NOW() ) 
15/11/2023 11:46:21 am >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88968' 
15/11/2023 11:46:21 am >>  DELETE FROM ps_document_detail WHERE id_document = '88968' 
15/11/2023 11:46:21 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88968' , '9257' , 'SACRA FAMIGLIA' , '1' ,  '-1' , '1' ,
                               '3.5' , '2.8688524590164' , '22' , '0' , '3.50' ) 
15/11/2023 11:46:21 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88968' , '17617' , 'IMMAGINI ISONZO X 100' , '6' ,  '-6' , '1' ,
                               '3.5' , '2.8688524590164' , '22' , '0' , '21.00' ) 
15/11/2023 11:50:52 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '269' AND id_document != '88966' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-15') 
15/11/2023 11:50:52 am >> UPDATE ps_document SET
                          id_document_type = '21',
                          document_num = '269',
                          document_date = '2023-11-15',
                          document_letter = '',
                          id_customer = '1138',
                          id_supplier = '',
                          id_address = '4672220',
                          address1 = 'P. ZZA AMENDOLA - LANZARA 84083 CASTEL SAN GIORGIO',
                          address2 = '',
                          note = '',
                          price_shipping = '0.00',
                          id_tax_shipping_rules = '4',
                          colli = '0',
                          peso = '0',
                          porto_e_imballo = '0',
                          mezzo_consegna = '',
                          id_payment = '1',
                          id_causal = '0',
                          price_tax_included = '554.97',
                          price_tax_excluded = '554.97',
                          date_upd = NOW()
                        WHERE id_document = '88966' 
15/11/2023 11:50: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 = '88966' 
15/11/2023 11:50:52 am >>  DELETE FROM ps_document_detail WHERE id_document = '88966' 
15/11/2023 11:50: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
                            ( '88966' , '2679' , 'CONOSCERE GESU\'' , '42' ,  '-42' , '4' ,
                               '3.5000' , '3.5' , '0' , '15' , '124.95' ) 
15/11/2023 11:50: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
                            ( '88966' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' ,  '-1' , '4' ,
                               '5.0000' , '5' , '0' , '15' , '4.25' ) 
15/11/2023 11:50: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
                            ( '88966' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '38' ,  '-38' , '4' ,
                               '3.5000' , '3.5' , '0' , '15' , '113.05' ) 
15/11/2023 11:50: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
                            ( '88966' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '2' ,  '-2' , '4' ,
                               '10.0000' , '10' , '0' , '15' , '17.00' ) 
15/11/2023 11:50: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
                            ( '88966' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '35' ,  '-35' , '4' ,
                               '3.5000' , '3.5' , '0' , '15' , '104.13' ) 
15/11/2023 11:50: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
                            ( '88966' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '35' ,  '-35' , '4' ,
                               '3.40' , '3.4' , '0' , '15' , '101.15' ) 
15/11/2023 11:50: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
                            ( '88966' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '4' ,  '-4' , '4' ,
                               '10.00' , '10' , '0' , '15' , '34.00' ) 
15/11/2023 11:50: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
                            ( '88966' , '5457' , 'IO SONO CON VOI 1 PARTE' , '18' ,  '-18' , '4' ,
                               '2.80' , '2.8' , '0' , '15' , '42.84' ) 
15/11/2023 11:50: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
                            ( '88966' , '5446' , 'IO SONO CON VOI - GUIDA' , '2' ,  '-2' , '4' ,
                               '8.00' , '8' , '0' , '15' , '13.60' ) 
15/11/2023 12:17:53 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 
15/11/2023 12:17:53 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21838' , '1' , '' , 'nuovo-prodotto' )
15/11/2023 12:17:53 pm >> INSERT INTO ps_product_shop (
                      id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
                  ) VALUES (
                      '21838' , '1' , '1' , '2' , NOW() , NOW()
                  ) 
15/11/2023 12:17:53 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21838' , '0' , '1' , '0' , '0' )
15/11/2023 12:19:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8024823232839' AND id_product != '21838' AND ean13 != '' 
15/11/2023 12:19:42 pm >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '',
                  ean13 = '8024823232839',
                  date_upd = NOW()
                WHERE id_product = '21838' 
15/11/2023 12:19:42 pm >> UPDATE ps_product_lang SET
                  name = 'CARTOLINA CARLO ACUTIS',
                  description = ''
                WHERE id_product = '21838' 
15/11/2023 12:19:42 pm >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '0.12295081967213115'
                WHERE id_product = '21838' 
15/11/2023 12:19:42 pm >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '0.12295081967213115',
                  id_tax_rules_group = '1',
                  id_category_default = '106',
                  id_argoment_default = '234',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '21838' 
15/11/2023 12:19:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '21838' 
15/11/2023 12:22:33 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '31' ,
                          '18254' ,
                          '2023-11-13' ,
                          '' ,
                          '0' ,
                          '38' ,
                          '2633' ,
                          'VIA GALVANI, 1 60020 CAMERATA PICENA' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '6' ,
                          '0' ,
                          '123.31' ,
                          '119.03' ,
                          NOW() ,
                          NOW() ) 
15/11/2023 12:22:33 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88969' 
15/11/2023 12:22:33 pm >>  DELETE FROM ps_document_detail WHERE id_document = '88969' 
15/11/2023 12:22:33 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88969' , '21519' , 'SULLA TUA PAROLA  - NOV/DIC 23' , '2' ,  '2' , '4' ,
                               '5.00' , '5' , '0' , '40' , '6.0000' ) 
15/11/2023 12:22:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21519' AND id_supplier = '38' 
15/11/2023 12:22:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21519' , '38' , '1' ) 
15/11/2023 12:22:33 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88969' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '10' ,  '10' , '4' ,
                               '5.00' , '5' , '0' , '40' , '30.0000' ) 
15/11/2023 12:22:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21778' AND id_supplier = '38' 
15/11/2023 12:22:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21778' , '38' , '1' ) 
15/11/2023 12:22:33 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88969' , '8250' , 'PREGATE, PREGATE, PREGATE - 8001' , '1' ,  '1' , '4' ,
                               '19.00' , '19' , '0' , '40' , '11.4000' ) 
15/11/2023 12:22:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8250' AND id_supplier = '38' 
15/11/2023 12:22:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8250' , '38' , '1' ) 
15/11/2023 12:22:33 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88969' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '3' ,  '3' , '4' ,
                               '10.00' , '10' , '0' , '40' , '18.0000' ) 
15/11/2023 12:22:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8247' AND id_supplier = '38' 
15/11/2023 12:22:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8247' , '38' , '1' ) 
15/11/2023 12:22:33 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88969' , '8383' , 'PREGHIERE PER LADORAZIONE EUCARISTICA - 8141' , '1' ,  '1' , '4' ,
                               '12.00' , '12' , '0' , '40' , '7.2000' ) 
15/11/2023 12:22:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8383' AND id_supplier = '38' 
15/11/2023 12:22:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8383' , '38' , '1' ) 
15/11/2023 12:22:33 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88969' , '10299' , 'STORIA DI UNANIMA - 8203' , '1' ,  '1' , '4' ,
                               '10.00' , '10' , '0' , '40' , '6.0000' ) 
15/11/2023 12:22:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10299' AND id_supplier = '38' 
15/11/2023 12:22:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10299' , '38' , '1' ) 
15/11/2023 12:22:33 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88969' , '4310' , 'FRATICELLO CHE GIOCAVA CON DIO - S. GERARDO - 8328' , '1' ,  '1' , '4' ,
                               '7.00' , '7' , '0' , '40' , '4.2000' ) 
15/11/2023 12:22:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4310' AND id_supplier = '38' 
15/11/2023 12:22:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4310' , '38' , '1' ) 
15/11/2023 12:22:34 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88969' , '8219' , 'PRATICA DI AMAR GESÙ CRISTO - 8464' , '1' ,  '1' , '4' ,
                               '9.00' , '9' , '0' , '40' , '5.4000' ) 
15/11/2023 12:22:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8219' AND id_supplier = '38' 
15/11/2023 12:22:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8219' , '38' , '1' ) 
15/11/2023 12:22:34 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88969' , '21837' , 'CAMMINO DELLA PREGHIERA - P. SCIADINI - 8484' , '1' ,  '1' , '4' ,
                               '7.00' , '7' , '0' , '40' , '4.2000' ) 
15/11/2023 12:22:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21837' AND id_supplier = '38' 
15/11/2023 12:22:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21837' , '38' , '1' ) 
15/11/2023 12:22:34 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88969' , '11223' , 'VERGINE DI GUADALUPE - 8590' , '1' ,  '1' , '4' ,
                               '12.00' , '12' , '0' , '40' , '7.2000' ) 
15/11/2023 12:22:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11223' AND id_supplier = '38' 
15/11/2023 12:22:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11223' , '38' , '1' ) 
15/11/2023 12:22:34 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88969' , '21838' , 'CARTOLINA CARLO ACUTIS' , '50' ,  '50' , '1' ,
                               '0.12295' , '0.10077868852459' , '22' , '40' , '4.5000' ) 
15/11/2023 12:22:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21838' AND id_supplier = '38' 
15/11/2023 12:22:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21838' , '38' , '1' ) 
15/11/2023 12:22:34 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88969' , '21652' , 'AGENDA LITURGICO PASTORALE 2024' , '1' ,  '1' , '1' ,
                               '9.84' , '8.0655737704918' , '22' , '40' , '7.2029' ) 
15/11/2023 12:22:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21652' AND id_supplier = '38' 
15/11/2023 12:22:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21652' , '38' , '1' ) 
15/11/2023 12:22:34 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88969' , '21653' , 'AGENDA DEVOZIONALE 2024' , '2' ,  '2' , '1' ,
                               '8.2' , '6.7213114754098' , '22' , '40' , '12.0048' ) 
15/11/2023 12:22:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21653' AND id_supplier = '38' 
15/11/2023 12:22:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21653' , '38' , '1' ) 
15/11/2023 12:23:37 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '52/E' AND id_document != '88683' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-02') 
15/11/2023 12:23:37 pm >> UPDATE ps_document SET
                          id_document_type = '23',
                          document_num = '52/E',
                          document_date = '2023-11-02',
                          document_letter = 'E',
                          id_customer = '189',
                          id_supplier = '',
                          id_address = '4679063',
                          address1 = 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE',
                          address2 = '',
                          note = '',
                          price_shipping = '0.00',
                          id_tax_shipping_rules = '4',
                          colli = '0',
                          peso = '0',
                          porto_e_imballo = '0',
                          mezzo_consegna = '',
                          id_payment = '1',
                          id_causal = '0',
                          price_tax_included = '98.00',
                          price_tax_excluded = '98.00',
                          date_upd = NOW()
                        WHERE id_document = '88683' 
15/11/2023 12:23: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 = '88683' 
15/11/2023 12:23:37 pm >>  DELETE FROM ps_document_detail WHERE id_document = '88683' 
15/11/2023 12:23: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
                            ( '88683' , '8408' , 'PRENDETE E MANGIATE' , '50' ,  '-50' , '4' ,
                               '3.0000' , '3' , '0' , '38' , '93.00' ) 
15/11/2023 12:23: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
                            ( '88683' , '10133' , 'SPESE DI TRASPORTO' , '1' ,  '-1' , '4' ,
                               '5.0000' , '5' , '0' , '0' , '5.00' ) 
15/11/2023 12:41:04 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '90/A' AND id_document != '87306' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-09-15') 
15/11/2023 12:41:04 pm >> UPDATE ps_document SET
                          id_document_type = '24',
                          document_num = '90/A',
                          document_date = '2023-09-15',
                          document_letter = 'A',
                          id_customer = '371',
                          id_supplier = '',
                          id_address = '4670910',
                          address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO',
                          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 = '142.00',
                          price_tax_excluded = '126.22',
                          date_upd = NOW()
                        WHERE id_document = '87306' 
15/11/2023 12:41:04 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 = '87306' 
15/11/2023 12:41:04 pm >>  DELETE FROM ps_document_detail WHERE id_document = '87306' 
15/11/2023 12:41:04 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
                            ( '87306' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '250' ,  '-250' , '1' ,
                               '0.3500' , '0.28688524590164' , '22' , '0' , '87.50' ) 
15/11/2023 12:41:04 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
                            ( '87306' , '17229' , 'FELICI SUI PASSI DI GESU - 5 - SUSSIDIO' , '1' ,  '-1' , '4' ,
                               '5.0000' , '5' , '0' , '5' , '4.75' ) 
15/11/2023 12:41:04 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
                            ( '87306' , '18564' , 'CONNESSI CON GESU’ - AGENDUM 2' , '1' ,  '-1' , '4' ,
                               '5.0000' , '5' , '0' , '5' , '4.75' ) 
15/11/2023 12:41:04 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
                            ( '87306' , '18565' , 'CONNESSI CON GESU  - GUIDA 6' , '1' ,  '-1' , '4' ,
                               '15.0000' , '15' , '0' , '5' , '14.25' ) 
15/11/2023 12:41:04 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
                            ( '87306' , '4120' , 'FEDE NELLO ZAINETTO' , '1' ,  '-1' , '4' ,
                               '6.0000' , '6' , '0' , '5' , '5.70' ) 
15/11/2023 12:41:04 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
                            ( '87306' , '17230' , 'FELICI SUI PASSI DI GESU - 5 - GUIDA' , '1' ,  '-1' , '4' ,
                               '15.0000' , '15' , '0' , '5' , '14.25' ) 
15/11/2023 12:41:04 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
                            ( '87306' , '8601' , 'SARETE MIEI TESTIMONI 2 - MAGNIFICAT' , '1' ,  '-1' , '4' ,
                               '3.0000' , '3' , '0' , '5' , '2.85' ) 
15/11/2023 12:41:04 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
                            ( '87306' , '8600' , 'SARETE MIEI TESTIMONI 1 - MAGNIFICAT' , '1' ,  '-1' , '4' ,
                               '3.0000' , '3' , '0' , '5' , '2.85' ) 
15/11/2023 12:41:04 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
                            ( '87306' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' ,  '-1' , '4' ,
                               '6.00' , '6' , '0' , '15' , '5.10' ) 
15/11/2023 12:41:57 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '90/A' AND id_document != '87306' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-09-15') 
15/11/2023 12:41:58 pm >> UPDATE ps_document SET
                          id_document_type = '24',
                          document_num = '90/A',
                          document_date = '2023-09-15',
                          document_letter = 'A',
                          id_customer = '371',
                          id_supplier = '',
                          id_address = '4670910',
                          address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO',
                          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 = '145.50',
                          price_tax_excluded = '129.72',
                          date_upd = NOW()
                        WHERE id_document = '87306' 
15/11/2023 12:41: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 = '87306' 
15/11/2023 12:41:58 pm >>  DELETE FROM ps_document_detail WHERE id_document = '87306' 
15/11/2023 12:41: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
                            ( '87306' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '250' ,  '-250' , '1' ,
                               '0.3500' , '0.28688524590164' , '22' , '0' , '87.50' ) 
15/11/2023 12:41: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
                            ( '87306' , '17229' , 'FELICI SUI PASSI DI GESU - 5 - SUSSIDIO' , '1' ,  '-1' , '4' ,
                               '5.0000' , '5' , '0' , '' , '5.00' ) 
15/11/2023 12:41: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
                            ( '87306' , '18564' , 'CONNESSI CON GESU’ - AGENDUM 2' , '1' ,  '-1' , '4' ,
                               '5.0000' , '5' , '0' , '' , '5.00' ) 
15/11/2023 12:41: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
                            ( '87306' , '18565' , 'CONNESSI CON GESU  - GUIDA 6' , '1' ,  '-1' , '4' ,
                               '15.0000' , '15' , '0' , '' , '15.00' ) 
15/11/2023 12:41: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
                            ( '87306' , '4120' , 'FEDE NELLO ZAINETTO' , '1' ,  '-1' , '4' ,
                               '6.0000' , '6' , '0' , '' , '6.00' ) 
15/11/2023 12:41: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
                            ( '87306' , '17230' , 'FELICI SUI PASSI DI GESU - 5 - GUIDA' , '1' ,  '-1' , '4' ,
                               '15.0000' , '15' , '0' , '' , '15.00' ) 
15/11/2023 12:41: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
                            ( '87306' , '8601' , 'SARETE MIEI TESTIMONI 2 - MAGNIFICAT' , '1' ,  '-1' , '4' ,
                               '3.0000' , '3' , '0' , '' , '3.00' ) 
15/11/2023 12:41: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
                            ( '87306' , '8600' , 'SARETE MIEI TESTIMONI 1 - MAGNIFICAT' , '1' ,  '-1' , '4' ,
                               '3.0000' , '3' , '0' , '' , '3.00' ) 
15/11/2023 12:41: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
                            ( '87306' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' ,  '-1' , '4' ,
                               '6.0000' , '6' , '0' , '' , '6.00' ) 
15/11/2023 12:46:43 pm >> DELETE FROM ps_document WHERE id_document = '87306' 
15/11/2023 12:46:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '87306' 
15/11/2023 12:47:38 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '3580' AND id_document != '88918' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-13') 
15/11/2023 12:47:38 pm >> UPDATE ps_document SET
                          id_document_type = '11',
                          document_num = '3580',
                          document_date = '2023-11-13',
                          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 = '172.65',
                          price_tax_excluded = '145.89',
                          date_upd = NOW()
                        WHERE id_document = '88918' 
15/11/2023 12:47:38 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 = '88918' 
15/11/2023 12:47:38 pm >>  DELETE FROM ps_document_detail WHERE id_document = '88918' 
15/11/2023 12:47:38 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
                            ( '88918' , '12527' , 'LAMPADA A SFERA VIOLA' , '2' ,  '-2' , '1' ,
                               '20.0000' , '16.393442622951' , '22' , '0' , '40.00' ) 
15/11/2023 12:47:38 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
                            ( '88918' , '7202' , 'ARTICOLI RELIGIOSI' , '1' ,  '-1' , '1' ,
                               '65.9000' , '54.016393442623' , '22' , '0' , '65.90' ) 
15/11/2023 12:47:38 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
                            ( '88918' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' ,  '-1' , '1' ,
                               '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 
15/11/2023 12:47:38 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
                            ( '88918' , '21467' , 'ADOLESCENTI INAFFERRABILI - BOTTA / LONARDO' , '1' ,  '-1' , '4' ,
                               '15.0000' , '15' , '0' , '5' , '14.25' ) 
15/11/2023 12:47:38 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
                            ( '88918' , '16243' , 'QUADRO 10X10' , '1' ,  '-1' , '1' ,
                               '12.5000' , '10.245901639344' , '22' , '0' , '12.50' ) 
15/11/2023 12:47:38 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
                            ( '88918' , '17229' , 'FELICI SUI PASSI DI GESU - 5 - SUSSIDIO' , '1' ,  '-1' , '4' ,
                               '5.00' , '5' , '0' , '0' , '5.00' ) 
15/11/2023 12:47:38 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
                            ( '88918' , '18564' , 'CONNESSI CON GESU’ - AGENDUM 2' , '1' ,  '-1' , '4' ,
                               '5.00' , '5' , '0' , '0' , '5.00' ) 
15/11/2023 12:48:10 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '3569' AND id_document != '88904' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-11') 
15/11/2023 12:48:10 pm >> UPDATE ps_document SET
                          id_document_type = '11',
                          document_num = '3569',
                          document_date = '2023-11-11',
                          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 = '15.00',
                          price_tax_excluded = '15.00',
                          date_upd = NOW()
                        WHERE id_document = '88904' 
15/11/2023 12:48: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 = '88904' 
15/11/2023 12:48:10 pm >>  DELETE FROM ps_document_detail WHERE id_document = '88904' 
15/11/2023 12:48: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
                            ( '88904' , '18565' , 'CONNESSI CON GESU  - GUIDA 6' , '1' ,  '-1' , '4' ,
                               '15.00' , '15' , '0' , '0' , '15.00' ) 
15/11/2023 12:49:13 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '3603' AND id_document != '88948' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-14') 
15/11/2023 12:49:13 pm >> UPDATE ps_document SET
                          id_document_type = '11',
                          document_num = '3603',
                          document_date = '2023-11-14',
                          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 = '54.00',
                          price_tax_excluded = '47.51',
                          date_upd = NOW()
                        WHERE id_document = '88948' 
15/11/2023 12:49:13 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88948' 
15/11/2023 12:49:13 pm >>  DELETE FROM ps_document_detail WHERE id_document = '88948' 
15/11/2023 12:49:13 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88948' , '12202' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 4 - 73/40' , '2' ,  '-2' , '1' ,
                               '18.0000' , '14.754098360656' , '22' , '0' , '36.00' ) 
15/11/2023 12:49:13 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88948' , '8601' , 'SARETE MIEI TESTIMONI 2 - MAGNIFICAT' , '1' ,  '-1' , '4' ,
                               '3.00' , '3' , '0' , '0' , '3.00' ) 
15/11/2023 12:49:13 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88948' , '17230' , 'FELICI SUI PASSI DI GESU - 5 - GUIDA' , '1' ,  '-1' , '4' ,
                               '15' , '15' , '0' , '0' , '15.00' ) 
15/11/2023 12:49:32 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '3523' AND id_document != '88843' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-09') 
15/11/2023 12:49:33 pm >> UPDATE ps_document SET
                          id_document_type = '11',
                          document_num = '3523',
                          document_date = '2023-11-09',
                          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 = '2.00',
                          price_tax_excluded = '2.00',
                          date_upd = NOW()
                        WHERE id_document = '88843' 
15/11/2023 12:49:33 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88843' 
15/11/2023 12:49:33 pm >>  DELETE FROM ps_document_detail WHERE id_document = '88843' 
15/11/2023 12:49:33 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88843' , '8600' , 'SARETE MIEI TESTIMONI 1 - MAGNIFICAT' , '1' ,  '-1' , '4' ,
                               '2' , '2' , '0' , '0' , '2.00' ) 
15/11/2023 12:50:16 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '3407' AND id_document != '88652' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-31') 
15/11/2023 12:50:16 pm >> UPDATE ps_document SET
                          id_document_type = '11',
                          document_num = '3407',
                          document_date = '2023-10-31',
                          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 = '271.00',
                          price_tax_excluded = '222.13',
                          date_upd = NOW()
                        WHERE id_document = '88652' 
15/11/2023 12:50:16 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88652' 
15/11/2023 12:50:16 pm >>  DELETE FROM ps_document_detail WHERE id_document = '88652' 
15/11/2023 12:50:16 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88652' , '19602' , 'QUADRETTO EFFETTO PIETRA - SACRA FAMIGLIA - 2952' , '2' ,  '-2' , '1' ,
                               '4.0000' , '3.2786885245902' , '22' , '0' , '8.00' ) 
15/11/2023 12:50:16 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88652' , '922' , 'BALZA RICAMATA CM 9,6 - VERDE - KOM/030 - OGGETTI' , '3' ,  '-3' , '1' ,
                               '20.0000' , '16.393442622951' , '22' , '0' , '60.00' ) 
15/11/2023 12:50:16 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88652' , '20466' , 'PIZZO MACRAME  CM 10 - P529' , '6' ,  '-6' , '1' ,
                               '30.0000' , '24.590163934426' , '22' , '0' , '171.00' ) 
15/11/2023 12:50:16 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88652' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '100' ,  '-100' , '1' ,
                               '0.32' , '0.26229508196721' , '22' , '0' , '32.00' ) 
15/11/2023 12:50:58 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '3170' AND id_document != '88297' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-14') 
15/11/2023 12:50:58 pm >> UPDATE ps_document SET
                          id_document_type = '11',
                          document_num = '3170',
                          document_date = '2023-10-14',
                          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 = '49.00',
                          price_tax_excluded = '40.16',
                          date_upd = NOW()
                        WHERE id_document = '88297' 
15/11/2023 12:50:58 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88297' 
15/11/2023 12:50:58 pm >>  DELETE FROM ps_document_detail WHERE id_document = '88297' 
15/11/2023 12:50:59 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88297' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '140' ,  '-140' , '1' ,
                               '0.3500' , '0.28688524590164' , '22' , '0' , '49.00' ) 
15/11/2023 12:52:16 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '3534' AND id_document != '88855' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-09') 
15/11/2023 12:52:16 pm >> UPDATE ps_document SET
                          id_document_type = '11',
                          document_num = '3534',
                          document_date = '2023-11-09',
                          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 = '132.65',
                          price_tax_excluded = '131.28',
                          date_upd = NOW()
                        WHERE id_document = '88855' 
15/11/2023 12:52:16 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88855' 
15/11/2023 12:52:16 pm >>  DELETE FROM ps_document_detail WHERE id_document = '88855' 
15/11/2023 12:52:16 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88855' , '10965' , 'UNZIONE DEGLI INFERMI E IL VIATICO' , '2' ,  '-2' , '4' ,
                               '2.5000' , '2.5' , '0' , '5' , '4.76' ) 
15/11/2023 12:52:16 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88855' , '12819' , 'REGISTRO DEL CATECHISTA ' , '8' ,  '-8' , '1' ,
                               '1.0000' , '0.81967213114754' , '22' , '5' , '7.60' ) 
15/11/2023 12:52:16 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88855' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '3' ,  '-3' , '4' ,
                               '3.0000' , '3' , '0' , '5' , '8.55' ) 
15/11/2023 12:52:16 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88855' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '10' ,  '-10' , '4' ,
                               '3.0000' , '3' , '0' , '5' , '28.50' ) 
15/11/2023 12:52:16 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88855' , '9680' , 'SARETE MIEI TESTIMONI - GUIDA 1 - MAGNIFICAT' , '1' ,  '-1' , '4' ,
                               '12.0000' , '12' , '0' , '5' , '11.40' ) 
15/11/2023 12:52:16 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88855' , '9681' , 'SARETE MIEI TESTIMONI - GUIDA 2 - MAGNIFICAT' , '1' ,  '-1' , '4' ,
                               '12.0000' , '12' , '0' , '5' , '11.40' ) 
15/11/2023 12:52:16 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88855' , '5451' , 'IO SONO CON VOI - GUIDA 2 - MAGNIFICAT' , '1' ,  '-1' , '4' ,
                               '12.0000' , '12' , '0' , '5' , '11.40' ) 
15/11/2023 12:52:16 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88855' , '5450' , 'IO SONO CON VOI - GUIDA 1 - MAGNIFICAT' , '1' ,  '-1' , '4' ,
                               '12.0000' , '12' , '0' , '5' , '11.40' ) 
15/11/2023 12:52:16 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88855' , '11188' , 'VENITE CON ME - GUIDA 2 - MAGNIFICAT' , '1' ,  '-1' , '4' ,
                               '12.0000' , '12' , '0' , '5' , '11.40' ) 
15/11/2023 12:52:16 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88855' , '11187' , 'VENITE CON ME - GUIDA 1 - MAGNIFICAT' , '1' ,  '-1' , '4' ,
                               '12.0000' , '12' , '0' , '5' , '11.40' ) 
15/11/2023 12:52:16 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88855' , '11151' , 'LIBRI' , '1' ,  '-1' , '4' ,
                               '3.44' , '3.44' , '0' , '0' , '3.44' ) 
15/11/2023 12:52:16 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88855' , '11281' , 'VI PARLO DI ME - S. GEMMA GALGANI - 8581' , '1' ,  '-1' , '4' ,
                               '12.00' , '12' , '0' , '5' , '11.40' ) 
15/11/2023 03:18:11 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 
15/11/2023 03:18:11 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21839' , '1' , '' , 'nuovo-prodotto' )
15/11/2023 03:18:12 pm >> INSERT INTO ps_product_shop (
                      id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
                  ) VALUES (
                      '21839' , '1' , '1' , '2' , NOW() , NOW()
                  ) 
15/11/2023 03:18:12 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21839' , '0' , '1' , '0' , '0' )
15/11/2023 03:21:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002004' AND id_product != '21839' AND ean13 != '' 
15/11/2023 03:21:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002204' AND id_product != '21839' AND ean13 != '' 
15/11/2023 03:21:41 pm >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '',
                  ean13 = '002204',
                  date_upd = NOW()
                WHERE id_product = '21839' 
15/11/2023 03:21:41 pm >> UPDATE ps_product_lang SET
                  name = 'NATIVITA\' IN RESINA CM 8 - P725',
                  description = ''
                WHERE id_product = '21839' 
15/11/2023 03:21:41 pm >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '3.8524590163934427'
                WHERE id_product = '21839' 
15/11/2023 03:21:41 pm >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '3.8524590163934427',
                  id_tax_rules_group = '1',
                  id_category_default = '95',
                  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 = '21839' 
15/11/2023 03:21:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '21839' 
15/11/2023 03:22:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002204' AND id_product != '21839' AND ean13 != '' 
15/11/2023 03:22:23 pm >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '',
                  ean13 = '002204',
                  date_upd = NOW()
                WHERE id_product = '21839' 
15/11/2023 03:22:23 pm >> UPDATE ps_product_lang SET
                  name = 'NATIVITA\' IN RESINA CM 8 - P725',
                  description = ''
                WHERE id_product = '21839' 
15/11/2023 03:22:23 pm >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '3.8524590163934427'
                WHERE id_product = '21839' 
15/11/2023 03:22:23 pm >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '3.8524590163934427',
                  id_tax_rules_group = '1',
                  id_category_default = '95',
                  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 = '21839' 
15/11/2023 03:22:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '21839' 
15/11/2023 03:23:45 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 
15/11/2023 03:23:45 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21840' , '1' , '' , 'nuovo-prodotto' )
15/11/2023 03:23:45 pm >> INSERT INTO ps_product_shop (
                      id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
                  ) VALUES (
                      '21840' , '1' , '1' , '2' , NOW() , NOW()
                  ) 
15/11/2023 03:23:45 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21840' , '0' , '1' , '0' , '0' )
15/11/2023 03:27:18 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002205' AND id_product != '21840' AND ean13 != '' 
15/11/2023 03:27:18 pm >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '',
                  ean13 = '002205',
                  date_upd = NOW()
                WHERE id_product = '21840' 
15/11/2023 03:27:18 pm >> UPDATE ps_product_lang SET
                  name = 'TAVOLA IN LEGNO 20X25 - 1223',
                  description = ''
                WHERE id_product = '21840' 
15/11/2023 03:27:18 pm >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '10.655737704918034'
                WHERE id_product = '21840' 
15/11/2023 03:27:18 pm >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '10.655737704918034',
                  id_tax_rules_group = '1',
                  id_category_default = '2',
                  id_argoment_default = '',
                  id_internal_category = '',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '21840' 
15/11/2023 03:27:18 pm >> DELETE FROM ps_specific_price WHERE id_product = '21840' 
15/11/2023 03:27:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002205' AND id_product != '21840' AND ean13 != '' 
15/11/2023 03:27:30 pm >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '',
                  ean13 = '002205',
                  date_upd = NOW()
                WHERE id_product = '21840' 
15/11/2023 03:27:30 pm >> UPDATE ps_product_lang SET
                  name = 'TAVOLA IN LEGNO 20X25 - 1223',
                  description = ''
                WHERE id_product = '21840' 
15/11/2023 03:27:30 pm >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '10.655737704918034'
                WHERE id_product = '21840' 
15/11/2023 03:27:30 pm >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '10.655737704918034',
                  id_tax_rules_group = '1',
                  id_category_default = '95',
                  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 = '21840' 
15/11/2023 03:27:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '21840' 
15/11/2023 03:27:35 pm >> INSERT INTO ps_product (
                  id_tax_rules_group , `date_add` , `date_upd`
                ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21840' 
15/11/2023 03:27:35 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21841' , '1' , '' , 'nuovo-prodotto' )
15/11/2023 03:27:35 pm >> INSERT INTO ps_product_shop (
                    id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd`
                ) SELECT '21841' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21840' 
15/11/2023 03:27:35 pm >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '21841' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21840' 
15/11/2023 03:28:29 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '202206' AND id_product != '4889' AND ean13 != '' 
15/11/2023 03:28:29 pm >> UPDATE ps_product SET
                  id_supplier = '28',
                  reference = '2014',
                  ean13 = '202206',
                  date_upd = NOW()
                WHERE id_product = '4889' 
15/11/2023 03:28:29 pm >> UPDATE ps_product_lang SET
                  name = 'ICONA LEGNO 30X40 - 1224',
                  description = ''
                WHERE id_product = '4889' 
15/11/2023 03:28:29 pm >> UPDATE ps_product SET
                  wholesale_price = '9.19',
                  on_sale = '0',
                  price = '22.13114754098361'
                WHERE id_product = '4889' 
15/11/2023 03:28:29 pm >> UPDATE ps_product_shop SET
                  wholesale_price = '9.19',
                  price = '22.13114754098361',
                  id_tax_rules_group = '1',
                  id_category_default = '95',
                  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 = '4889' 
15/11/2023 03:28:29 pm >> DELETE FROM ps_specific_price WHERE id_product = '4889' 
15/11/2023 03:36:52 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000623' AND id_product != '4887' AND ean13 != '' 
15/11/2023 03:36:52 pm >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '2014',
                  ean13 = '000623',
                  date_upd = NOW()
                WHERE id_product = '4887' 
15/11/2023 03:36:52 pm >> UPDATE ps_product_lang SET
                  name = 'ICONA LEGNO 10X15  - 1222 ',
                  description = ''
                WHERE id_product = '4887' 
15/11/2023 03:36:52 pm >> UPDATE ps_product SET
                  wholesale_price = '1.40',
                  on_sale = '0',
                  price = '2.8689'
                WHERE id_product = '4887' 
15/11/2023 03:36:52 pm >> UPDATE ps_product_shop SET
                  wholesale_price = '1.40',
                  price = '2.8689',
                  id_tax_rules_group = '1',
                  id_category_default = '95',
                  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 = '4887' 
15/11/2023 03:36:52 pm >> DELETE FROM ps_specific_price WHERE id_product = '4887' 
15/11/2023 03:42:20 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002207' AND id_product != '21841' AND ean13 != '' 
15/11/2023 03:42:20 pm >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '',
                  ean13 = '002207',
                  date_upd = NOW()
                WHERE id_product = '21841' 
15/11/2023 03:42:20 pm >> UPDATE ps_product_lang SET
                  name = 'QUADRETTO SMUSSATO - 1269',
                  description = ''
                WHERE id_product = '21841' 
15/11/2023 03:42:20 pm >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '2.0491803278688523'
                WHERE id_product = '21841' 
15/11/2023 03:42:20 pm >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '2.0491803278688523',
                  id_tax_rules_group = '1',
                  id_category_default = '95',
                  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 = '21841' 
15/11/2023 03:42:20 pm >> DELETE FROM ps_specific_price WHERE id_product = '21841' 
15/11/2023 03:42:21 pm >> INSERT INTO ps_product (
                  id_tax_rules_group , `date_add` , `date_upd`
                ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21841' 
15/11/2023 03:42:21 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21842' , '1' , '' , 'nuovo-prodotto' )
15/11/2023 03:42:21 pm >> INSERT INTO ps_product_shop (
                    id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd`
                ) SELECT '21842' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21841' 
15/11/2023 03:42:21 pm >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '21842' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21841' 
15/11/2023 03:42:41 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '31' ,
                          'A4493' ,
                          '2023-11-15' ,
                          '' ,
                          '0' ,
                          '28' ,
                          '2623' ,
                          'VIA DEI MILLE 59 80121 NAPOLI' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '9' ,
                          '0' ,
                          '517.56' ,
                          '424.23' ,
                          NOW() ,
                          NOW() ) 
15/11/2023 03:42:41 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88970' 
15/11/2023 03:42:41 pm >>  DELETE FROM ps_document_detail WHERE id_document = '88970' 
15/11/2023 03:42:41 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88970' , '19602' , 'QUADRETTO EFFETTO PIETRA - SACRA FAMIGLIA - 2952' , '10' ,  '10' , '1' ,
                               '1.61' , '1.3196721311475' , '22' , '0' , '19.6420' ) 
15/11/2023 03:42:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19602' AND id_supplier = '28' 
15/11/2023 03:42:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19602' , '28' , '1' ) 
15/11/2023 03:42:41 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88970' , '4889' , 'ICONA LEGNO 30X40 - 1224' , '1' ,  '1' , '1' ,
                               '9.65' , '7.9098360655738' , '22' , '0' , '11.7730' ) 
15/11/2023 03:42:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4889' AND id_supplier = '28' 
15/11/2023 03:42:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4889' , '28' , '1' ) 
15/11/2023 03:42:41 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88970' , '21840' , 'TAVOLA IN LEGNO 20X25 - 1223' , '4' ,  '4' , '1' ,
                               '4.77' , '3.9098360655738' , '22' , '0' , '23.2776' ) 
15/11/2023 03:42:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21840' AND id_supplier = '28' 
15/11/2023 03:42:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21840' , '28' , '1' ) 
15/11/2023 03:42:41 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88970' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '1000' ,  '1000' , '1' ,
                               '0.12' , '0.098360655737705' , '22' , '0' , '146.4000' ) 
15/11/2023 03:42:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '939' AND id_supplier = '28' 
15/11/2023 03:42:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '939' , '28' , '1' ) 
15/11/2023 03:42:41 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88970' , '940' , 'BAMBINO CM 4 - FOSFORO - P1' , '500' ,  '500' , '1' ,
                               '0.12' , '0.098360655737705' , '22' , '0' , '73.2000' ) 
15/11/2023 03:42:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '940' AND id_supplier = '28' 
15/11/2023 03:42:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '940' , '28' , '1' ) 
15/11/2023 03:42:41 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88970' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '300' ,  '300' , '1' ,
                               '0.17' , '0.13934426229508' , '22' , '0' , '62.2200' ) 
15/11/2023 03:42:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '941' AND id_supplier = '28' 
15/11/2023 03:42:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '941' , '28' , '1' ) 
15/11/2023 03:42:41 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88970' , '21558' , 'ANELLO DECINA ARG - M043' , '3' ,  '3' , '1' ,
                               '4.55' , '3.7295081967213' , '22' , '0' , '16.6530' ) 
15/11/2023 03:42:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21558' AND id_supplier = '28' 
15/11/2023 03:42:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21558' , '28' , '1' ) 
15/11/2023 03:42:41 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88970' , '21839' , 'NATIVITA\' IN RESINA CM 8 - P725' , '60' ,  '60' , '1' ,
                               '1.73' , '1.4180327868852' , '22' , '0' , '126.6360' ) 
15/11/2023 03:42:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21839' AND id_supplier = '28' 
15/11/2023 03:42:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21839' , '28' , '1' ) 
15/11/2023 03:42:41 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88970' , '4887' , 'ICONA LEGNO 10X15  - 1222 ' , '5' ,  '5' , '1' ,
                               '1.59' , '1.3032786885246' , '22' , '0' , '9.6990' ) 
15/11/2023 03:42:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4887' AND id_supplier = '28' 
15/11/2023 03:42:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4887' , '28' , '1' ) 
15/11/2023 03:42:41 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88970' , '21841' , 'QUADRETTO SMUSSATO - 1269' , '25' ,  '25' , '1' ,
                               '0.92' , '0.75409836065574' , '22' , '0' , '28.0600' ) 
15/11/2023 03:42:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21841' AND id_supplier = '28' 
15/11/2023 03:42:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21841' , '28' , '1' ) 
15/11/2023 04:34:40 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '48' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-11-15') 
15/11/2023 04:34:40 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '24' ,
                          '48' ,
                          '2023-11-15' ,
                          '' ,
                          '3000' ,
                          '0' ,
                          '4669629' ,
                          'VIA DEI CASTANI, 116 00172 ROMA' ,
                          '' ,
                          'EDIZIONI' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '3465.00' ,
                          '3465.00' ,
                          NOW() ,
                          NOW() ) 
15/11/2023 04:34:40 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88971' 
15/11/2023 04:34:40 pm >>  DELETE FROM ps_document_detail WHERE id_document = '88971' 
15/11/2023 04:34:40 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88971' , '2679' , 'CONOSCERE GESU\'' , '640' ,  '-640' , '4' ,
                               '3.50' , '3.5' , '0' , '0' , '2240.00' ) 
15/11/2023 04:34:40 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88971' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '50' ,  '-50' , '4' ,
                               '6.00' , '6' , '0' , '0' , '300.00' ) 
15/11/2023 04:34:40 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88971' , '21417' , 'VIENI, NON TARDARE SIGNORE, NOSTRA PACE!' , '175' ,  '-175' , '4' ,
                               '2.50' , '2.5' , '0' , '0' , '437.50' ) 
15/11/2023 04:34:40 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88971' , '21418' , 'CRISTO NOSTRA PACE - V. SALVORDI' , '75' ,  '-75' , '4' ,
                               '2.50' , '2.5' , '0' , '0' , '187.50' ) 
15/11/2023 04:34:40 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88971' , '5644' , 'LEGGERE,... LA PAROLA - ANNO B' , '30' ,  '-30' , '4' ,
                               '10.00' , '10' , '0' , '0' , '300.00' ) 
15/11/2023 04:35:29 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '19' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-11-15') 
15/11/2023 04:35:29 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '24' ,
                          '19' ,
                          '2023-11-15' ,
                          '' ,
                          '3000' ,
                          '0' ,
                          '4669629' ,
                          'VIA DEI CASTANI, 116 00172 ROMA' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '1460.00' ,
                          '1460.00' ,
                          NOW() ,
                          NOW() ) 
15/11/2023 04:35:29 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 = '13240' 
15/11/2023 04:35:29 pm >>  DELETE FROM ps_document_detail WHERE id_document = '13240' 
15/11/2023 04:35:29 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
                            ( '13240' , '138' , 'LA NASCITA DI GESU\'' , '200' ,  '-200' , '4' ,
                               '2.50' , '2.5' , '0' , '0' , '500.00' ) 
15/11/2023 04:35:29 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
                            ( '13240' , '17' , 'LA FEDE NELLO ZAINETTO' , '160' ,  '-160' , '4' ,
                               '6.00' , '6' , '0' , '0' , '960.00' ) 
15/11/2023 04:36:32 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '49' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-11-15') 
15/11/2023 04:36:32 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '24' ,
                          '49' ,
                          '2023-11-15' ,
                          '' ,
                          '540' ,
                          '0' ,
                          '4673023' ,
                          'CORSO GARIBALDI, 6 84025 EBOLI' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '580.00' ,
                          '475.41' ,
                          NOW() ,
                          NOW() ) 
15/11/2023 04:36:32 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88972' 
15/11/2023 04:36:32 pm >>  DELETE FROM ps_document_detail WHERE id_document = '88972' 
15/11/2023 04:36:32 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88972' , '20481' , 'NATIVITA\' 50CM - PB8940 + PB8942' , '1' ,  '-1' , '1' ,
                               '580' , '475.40983606557' , '22' , '0' , '580.00' ) 
15/11/2023 04:38:15 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '49' AND id_document != '88972' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-11-15') 
15/11/2023 04:38:15 pm >> UPDATE ps_document SET
                          id_document_type = '24',
                          document_num = '49',
                          document_date = '2023-11-15',
                          document_letter = '',
                          id_customer = '540',
                          id_supplier = '',
                          id_address = '4673023',
                          address1 = 'CORSO GARIBALDI, 6 84025 EBOLI',
                          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 = '550.00',
                          price_tax_excluded = '450.82',
                          date_upd = NOW()
                        WHERE id_document = '88972' 
15/11/2023 04:38:15 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 = '88972' 
15/11/2023 04:38:15 pm >>  DELETE FROM ps_document_detail WHERE id_document = '88972' 
15/11/2023 04:38:15 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
                            ( '88972' , '20481' , 'NATIVITA\' 50CM - PB8940 + PB8942' , '1' ,  '-1' , '1' ,
                               '550' , '450.81967213115' , '22' , '0' , '550.00' ) 
15/11/2023 04:42:13 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '3616' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-15') 
15/11/2023 04:42:13 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '3616' ,
                          '2023-11-15' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '20.00' ,
                          '19.23' ,
                          NOW() ,
                          NOW() ) 
15/11/2023 04:42:13 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88973' 
15/11/2023 04:42:13 pm >>  DELETE FROM ps_document_detail WHERE id_document = '88973' 
15/11/2023 04:42:13 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88973' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '10' ,  '-10' , '3' ,
                               '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 
15/11/2023 04:46:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'PB8942' AND id_product != '21842' AND ean13 != '' 
15/11/2023 04:46:06 pm >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '',
                  ean13 = 'PB8942',
                  date_upd = NOW()
                WHERE id_product = '21842' 
15/11/2023 04:46:06 pm >> UPDATE ps_product_lang SET
                  name = 'NATIVITA\' CM 50',
                  description = ''
                WHERE id_product = '21842' 
15/11/2023 04:46:06 pm >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '244.2622950819672'
                WHERE id_product = '21842' 
15/11/2023 04:46:06 pm >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '244.2622950819672',
                  id_tax_rules_group = '1',
                  id_category_default = '458',
                  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 = '21842' 
15/11/2023 04:46:06 pm >> DELETE FROM ps_specific_price WHERE id_product = '21842' 
15/11/2023 04:46:51 pm >> UPDATE ps_document SET
                          id_document_type = '31',
                          document_num = '5961',
                          document_date = '2022-11-29',
                          document_letter = '',
                          id_customer = '0',
                          id_supplier = '',
                          id_address = '4670785',
                          address1 = 'VIA ROMA 44 00053 CIVITAVECCHIA',
                          address2 = '',
                          note = '',
                          price_shipping = '22.87',
                          id_tax_shipping_rules = '1',
                          colli = '0',
                          peso = '0',
                          porto_e_imballo = '0',
                          mezzo_consegna = '',
                          id_payment = '9',
                          id_causal = '0',
                          price_tax_included = '958.13',
                          price_tax_excluded = '785.35',
                          date_upd = NOW()
                        WHERE id_document = '75513' 
15/11/2023 04:46:51 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75513' 
15/11/2023 04:46:51 pm >>  DELETE FROM ps_document_detail WHERE id_document = '75513' 
15/11/2023 04:46:51 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '75513' , '20481' , 'NATIVITA 50CM - PB8940 + PB8942' , '1' ,  '1' , '1' ,
                               '149' , '122.13114754098' , '22' , '20+5' , '138.1528' ) 
15/11/2023 04:46:51 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '75513' , '20482' , 'NATIVITA 56CM - PB13874 + PB13875' , '1' ,  '1' , '1' ,
                               '273.0000' , '223.77049180328' , '22' , '20+5' , '253.13' ) 
15/11/2023 04:46:51 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '75513' , '20483' , 'NATIVITA 43CM - 11 PEZZI - PB0494' , '1' ,  '1' , '1' ,
                               '248.0000' , '203.27868852459' , '22' , '20+5' , '229.95' ) 
15/11/2023 04:46:51 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '75513' , '20484' , 'PRESEPE GROTTA - PB18540' , '2' ,  '2' , '1' ,
                               '78.5000' , '64.344262295082' , '22' , '20+5' , '145.57' ) 
15/11/2023 04:46:51 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '75513' , '20485' , 'NATIVITA MADONNA SDRAIATA - PB18139' , '1' ,  '1' , '1' ,
                               '21.8000' , '17.868852459016' , '22' , '5' , '25.27' ) 
15/11/2023 04:46: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
                            ( '75513' , '21842' , 'NATIVITA CM 50' , '1' ,  '1' , '1' ,
                               '149' , '122.13114754098' , '22' , '20+5' , '138.1528' ) 
15/11/2023 04:47:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002077' AND id_product != '20481' AND ean13 != '' 
15/11/2023 04:47:17 pm >> UPDATE ps_product SET
                  id_supplier = '134',
                  reference = '',
                  ean13 = '002077',
                  date_upd = NOW()
                WHERE id_product = '20481' 
15/11/2023 04:47:17 pm >> UPDATE ps_product_lang SET
                  name = 'NATIVITA\' 50CM - PB8940 + PB8942',
                  description = '<p>DA ORDINARE PB8941 BUE ASINO</p>'
                WHERE id_product = '20481' 
15/11/2023 04:47:17 pm >> UPDATE ps_product SET
                  wholesale_price = '238.40',
                  on_sale = '0',
                  price = '245.9016393442623'
                WHERE id_product = '20481' 
15/11/2023 04:47:17 pm >> UPDATE ps_product_shop SET
                  wholesale_price = '238.40',
                  price = '245.9016393442623',
                  id_tax_rules_group = '1',
                  id_category_default = '458',
                  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 = '20481' 
15/11/2023 04:47:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '20481' 
15/11/2023 04:47:54 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '2336' AND id_document != '86689' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-08') 
15/11/2023 04:47:54 pm >> UPDATE ps_document SET
                          id_document_type = '11',
                          document_num = '2336',
                          document_date = '2023-07-08',
                          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 = '298.00',
                          price_tax_excluded = '245.70',
                          date_upd = NOW()
                        WHERE id_document = '86689' 
15/11/2023 04:47:54 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86689' 
15/11/2023 04:47:54 pm >>  DELETE FROM ps_document_detail WHERE id_document = '86689' 
15/11/2023 04:47:54 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '86689' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' ,  '-1' , '3' ,
                               '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 
15/11/2023 04:47:54 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '86689' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '3' ,  '-3' , '3' ,
                               '2.0000' , '1.9230769230769' , '4' , '0' , '6.00' ) 
15/11/2023 04:47:54 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '86689' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' ,  '-6' , '1' ,
                               '8.0000' , '6.5573770491803' , '22' , '0' , '48.00' ) 
15/11/2023 04:47:54 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '86689' , '21196' , 'CALENDARIO LITURGICO 2024' , '1' ,  '-1' , '4' ,
                               '0.5000' , '0.5' , '0' , '0' , '0.50' ) 
15/11/2023 04:47:54 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '86689' , '20481' , 'NATIVITA\' 50CM - PB8940 + PB8942' , '1' ,  '-1' , '1' ,
                               '240' , '196.72131147541' , '22' , '0' , '240.00' ) 
15/11/2023 04:48:48 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '2108' AND id_document != '86416' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-19') 
15/11/2023 04:48:48 pm >> UPDATE ps_document SET
                          id_document_type = '11',
                          document_num = '2108',
                          document_date = '2023-06-19',
                          document_letter = '',
                          id_customer = '0',
                          id_supplier = '',
                          id_address = '0',
                          address1 = '',
                          address2 = '',
                          note = '',
                          price_shipping = '0.00',
                          id_tax_shipping_rules = '4',
                          colli = '0',
                          peso = '0',
                          porto_e_imballo = '0',
                          mezzo_consegna = '',
                          id_payment = '0',
                          id_causal = '0',
                          price_tax_included = '197.08',
                          price_tax_excluded = '166.42',
                          date_upd = NOW()
                        WHERE id_document = '86416' 
15/11/2023 04:48: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 = '86416' 
15/11/2023 04:48:48 pm >>  DELETE FROM ps_document_detail WHERE id_document = '86416' 
15/11/2023 04:48: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
                            ( '86416' , '15746' , 'ADORIAMO IL SS SACRAMENTO - VOL 1 -  8958' , '1' ,  '-1' , '4' ,
                               '3.0000' , '3' , '0' , '5' , '2.85' ) 
15/11/2023 04:48: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
                            ( '86416' , '17626' , 'ADORIAMO IL SS SACRAMENTO - QUARESIMA - 8202' , '1' ,  '-1' , '4' ,
                               '3.0000' , '3' , '0' , '5' , '2.85' ) 
15/11/2023 04:48: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
                            ( '86416' , '17629' , 'ADORIAMO IL SS SACRAMENTO - PASQUA - 8207' , '1' ,  '-1' , '4' ,
                               '3.0000' , '3' , '0' , '5' , '2.85' ) 
15/11/2023 04:48: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
                            ( '86416' , '17624' , 'ADORIAMO IL SS SACRAMENTO - AVVENTO E NATALE' , '1' ,  '-1' , '4' ,
                               '3.0000' , '3' , '0' , '5' , '2.85' ) 
15/11/2023 04:48: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
                            ( '86416' , '8383' , 'PREGHIERE PER LADORAZIONE EUCARISTICA - 8141' , '1' ,  '-1' , '4' ,
                               '12.0000' , '12' , '0' , '5' , '11.40' ) 
15/11/2023 04:48: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
                            ( '86416' , '5251' , 'INCONTRI EUCARISTICI' , '1' ,  '-1' , '4' ,
                               '4.5000' , '4.5' , '0' , '5' , '4.28' ) 
15/11/2023 04:48: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
                            ( '86416' , '21842' , 'NATIVITA CM 50' , '1' ,  '-1' , '1' ,
                               '170' , '139.34426229508' , '22' , '0' , '170.00' ) 
15/11/2023 04:49:00 pm >> DELETE FROM ps_document WHERE id_document = '88972' 
15/11/2023 04:49:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '88972' 
15/11/2023 05:06:04 pm >> INSERT INTO ps_customer
                          ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` )
                                VALUES
                          ( '1' , '' , '' , '' , 'SYPdzlgspua1hK7L' , NOW() , NOW() ) 
15/11/2023 05:06:04 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4056' , '1' )
15/11/2023 05:06:04 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4056' , '2' )
15/11/2023 05:06:04 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4056' , '3' )
15/11/2023 05:07:15 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4056' 
15/11/2023 05:07:15 pm >> INSERT INTO ps_address
            ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd )
            VALUES (
              '4056' ,
              '10' ,
              '139' ,
              '' ,
              'LANDRINI' ,
              'GLISENTE' ,
              'VIA ROMA 8' ,
              '' ,
              '25050' ,
              'PASPARDO' ,
              '' ,
              '' ,
              '' ,
              '' ,
              '' ,
              NOW()  ,
              NOW()  ) 
15/11/2023 05:07:15 pm >> UPDATE ps_customer SET
                email = 'glisente@glisente.it',
                sdi = '',
                pec = '',
                date_upd = NOW()
          WHERE id_customer = '4056' 
15/11/2023 05:08:08 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '270' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-15') 
15/11/2023 05:08:08 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '21' ,
                          '270' ,
                          '2023-11-15' ,
                          '' ,
                          '4056' ,
                          '0' ,
                          '4679190' ,
                          'VIA ROMA 8 25050 PASPARDO' ,
                          '' ,
                          '' ,
                          '5' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '9' ,
                          '0' ,
                          '54.88' ,
                          '54.88' ,
                          NOW() ,
                          NOW() ) 
15/11/2023 05:08:08 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88974' 
15/11/2023 05:08:08 pm >>  DELETE FROM ps_document_detail WHERE id_document = '88974' 
15/11/2023 05:08:08 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88974' , '2679' , 'CONOSCERE GESU\'' , '15' ,  '-15' , '4' ,
                               '3.5' , '3.5' , '0' , '5' , '49.88' ) 
15/11/2023 05:19: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  (
                          '33' ,
                          '235' ,
                          '2023-11-15' ,
                          '' ,
                          '0' ,
                          '126' ,
                          '4669995' ,
                          'VIA DELLE INDUSTRIE, 75 06083 BASTIA UMBRA' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '390.00' ,
                          '319.67' ,
                          NOW() ,
                          NOW() ) 
15/11/2023 05:19: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 = '88975' 
15/11/2023 05:19:59 pm >>  DELETE FROM ps_document_detail WHERE id_document = '88975' 
15/11/2023 05:19: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
                            ( '88975' , '21424' , 'STOLA ROMANA S. MOIRE - 7248S' , '1' ,  '1' , '1' ,
                               '390.00' , '319.67213114754' , '22' , '0' , '390.00' ) 
15/11/2023 05:19:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21424' AND id_supplier = '126' 
15/11/2023 05:19:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21424' , '126' , '1' ) 
15/11/2023 05:34:44 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '3617' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-15') 
15/11/2023 05:34: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' ,
                          '3617' ,
                          '2023-11-15' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '65.00' ,
                          '65.00' ,
                          NOW() ,
                          NOW() ) 
15/11/2023 05:34: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 = '88976' 
15/11/2023 05:34:44 pm >>  DELETE FROM ps_document_detail WHERE id_document = '88976' 
15/11/2023 05:34: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
                            ( '88976' , '11151' , 'LIBRI' , '1' ,  '-1' , '4' ,
                               '65' , '65' , '0' , '0' , '65.00' ) 
15/11/2023 05:46:06 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '128/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-15') 
15/11/2023 05:46:06 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '24' ,
                          '128/A' ,
                          '2023-11-15' ,
                          'A' ,
                          '3544' ,
                          '0' ,
                          '4674054' ,
                          'VIA SAN MARCO 53 - FRAZ. MONTICELLI 84062 OLEVANO SUL TUSCIANO' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '68.00' ,
                          '68.00' ,
                          NOW() ,
                          NOW() ) 
15/11/2023 05:46:06 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 = '88977' 
15/11/2023 05:46:06 pm >>  DELETE FROM ps_document_detail WHERE id_document = '88977' 
15/11/2023 05:46:06 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
                            ( '88977' , '17617' , 'IMMAGINI ISONZO X 100' , '4' ,  '-4' , '0' ,
                               '3.5' , '3.5' , '' , '0' , '14.00' ) 
15/11/2023 05:46:06 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
                            ( '88977' , '21838' , 'CARTOLINA CARLO ACUTIS' , '30' ,  '-30' , '0' ,
                               '0.15' , '0.15' , '' , '0' , '4.50' ) 
15/11/2023 05:46:06 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
                            ( '88977' , '20512' , 'ROSARIO BEATO CARLO ACUTIS - 195/51' , '11' ,  '-11' , '0' ,
                               '4.50' , '4.5' , '' , '0' , '49.50' ) 
15/11/2023 05:53:15 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '3618' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2023-11-15') 
15/11/2023 05:53:15 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' ,
                          '3618' ,
                          '2023-11-15' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '260.00' ,
                          '213.11' ,
                          NOW() ,
                          NOW() ) 
15/11/2023 05:53:15 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 = '88978' 
15/11/2023 05:53:15 pm >>  DELETE FROM ps_document_detail WHERE id_document = '88978' 
15/11/2023 05:53:15 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
                            ( '88978' , '7202' , 'ARTICOLI RELIGIOSI' , '1' ,  '-1' , '1' ,
                               '260' , '213.11475409836' , '22' , '0' , '260.00' ) 
15/11/2023 06:01:42 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '3619' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-15') 
15/11/2023 06:01:42 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' ,
                          '3619' ,
                          '2023-11-15' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '38.90' ,
                          '35.30' ,
                          NOW() ,
                          NOW() ) 
15/11/2023 06:01:42 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 = '88979' 
15/11/2023 06:01:42 pm >>  DELETE FROM ps_document_detail WHERE id_document = '88979' 
15/11/2023 06:01:42 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88979' , '21653' , 'AGENDA DEVOZIONALE 2024' , '1' ,  '-1' , '1' ,
                               '10.00' , '8.1967213114754' , '22' , '5' , '9.50' ) 
15/11/2023 06:01:42 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88979' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '1' ,  '-1' , '4' ,
                               '5.00' , '5' , '0' , '5' , '4.75' ) 
15/11/2023 06:01:42 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88979' , '21519' , 'SULLA TUA PAROLA  - NOV/DIC 23' , '1' ,  '-1' , '4' ,
                               '5.00' , '5' , '0' , '5' , '4.75' ) 
15/11/2023 06:01:42 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88979' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' ,  '-1' , '3' ,
                               '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 
15/11/2023 06:01:42 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88979' , '17711' , 'OSTIA MAGNA CM 18 - OM 180' , '1' ,  '-1' , '3' ,
                               '8.50' , '8.1730769230769' , '4' , '0' , '8.50' ) 
15/11/2023 06:01:42 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88979' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' ,  '-1' , '1' ,
                               '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 
15/11/2023 06:27:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886616683' AND id_product != '8391' AND ean13 != '' 
15/11/2023 06:27:35 pm >> UPDATE ps_product SET
                  id_supplier = '38',
                  reference = 'ESPOSITORE SHALOM',
                  ean13 = '9788886616683',
                  date_upd = NOW()
                WHERE id_product = '8391' 
15/11/2023 06:27:35 pm >> UPDATE ps_product_lang SET
                  name = 'PREGHIERE GUARIGIONE LIBERAZIONE CONSOLAZIONE - 8169',
                  description = ''
                WHERE id_product = '8391' 
15/11/2023 06:27:35 pm >> UPDATE ps_product SET
                  wholesale_price = '6.00',
                  on_sale = '0',
                  price = '12'
                WHERE id_product = '8391' 
15/11/2023 06:27:35 pm >> UPDATE ps_product_shop SET
                  wholesale_price = '6.00',
                  price = '12',
                  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 = '8391' 
15/11/2023 06:27:35 pm >> DELETE FROM ps_specific_price WHERE id_product = '8391' 
15/11/2023 06:35:30 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '129/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-15') 
15/11/2023 06:35:30 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '24' ,
                          '129/A' ,
                          '2023-11-15' ,
                          'A' ,
                          '2757' ,
                          '0' ,
                          '4671725' ,
                          'VIA CIRILLO 84085 MERCATO SAN SEVERINO' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '63.46' ,
                          '63.46' ,
                          NOW() ,
                          NOW() ) 
15/11/2023 06:35:30 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 = '88980' 
15/11/2023 06:35:30 pm >>  DELETE FROM ps_document_detail WHERE id_document = '88980' 
15/11/2023 06:35:30 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
                            ( '88980' , '18704' , 'IN_SEGUENDO GESU A NAZARET' , '6' ,  '-6' , '4' ,
                               '5.00' , '5' , '0' , '5' , '28.50' ) 
15/11/2023 06:35:30 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
                            ( '88980' , '18691' , 'IN_SEGUENDO GESU a emmaus - QUADERNO' , '6' ,  '-6' , '4' ,
                               '5.00' , '5' , '0' , '5' , '28.50' ) 
15/11/2023 06:35:30 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
                            ( '88980' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '2' ,  '-2' , '4' ,
                               '3.40' , '3.4' , '0' , '5' , '6.46' ) 
15/11/2023 06:51:28 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '3620' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-15') 
15/11/2023 06:51:28 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' ,
                          '3620' ,
                          '2023-11-15' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '10.00' ,
                          '8.20' ,
                          NOW() ,
                          NOW() ) 
15/11/2023 06:51:28 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 = '88981' 
15/11/2023 06:51:28 pm >>  DELETE FROM ps_document_detail WHERE id_document = '88981' 
15/11/2023 06:51:28 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
                            ( '88981' , '15007' , 'PRESEPE LEGNO CON LUCI CM 20 - 31130' , '1' ,  '-1' , '1' ,
                               '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 
15/11/2023 07:53:51 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '3621' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2023-11-15') 
15/11/2023 07:53:51 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '3621' ,
                          '2023-11-15' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '53.00' ,
                          '50.96' ,
                          NOW() ,
                          NOW() ) 
15/11/2023 07:53:51 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88982' 
15/11/2023 07:53:51 pm >>  DELETE FROM ps_document_detail WHERE id_document = '88982' 
15/11/2023 07:53:51 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88982' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '10' ,  '-10' , '3' ,
                               '3.30' , '3.1730769230769' , '4' , '0' , '33.00' ) 
15/11/2023 07:53:51 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88982' , '7311' , 'OSTIA SOTTILE 74MM' , '10' ,  '-10' , '3' ,
                               '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 
15/11/2023 07:56:09 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '3182' AND id_document != '88321' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-16') 
15/11/2023 07:56:09 pm >> UPDATE ps_document SET
                          id_document_type = '11',
                          document_num = '3182',
                          document_date = '2023-10-16',
                          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 = '11.00',
                          price_tax_excluded = '9.38',
                          date_upd = NOW()
                        WHERE id_document = '88321' 
15/11/2023 07:56: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 = '88321' 
15/11/2023 07:56:09 pm >>  DELETE FROM ps_document_detail WHERE id_document = '88321' 
15/11/2023 07:56: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
                            ( '88321' , '11151' , 'LIBRI' , '1' ,  '-1' , '4' ,
                               '2.0000' , '2' , '0' , '0' , '2.00' ) 
15/11/2023 07:56: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
                            ( '88321' , '9113' , 'ROSARIO FRANCESCANO DA COLLO - 2516' , '2' ,  '-2' , '1' ,
                               '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 
15/11/2023 07:56: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
                            ( '88321' , '14772' , 'BRACCIALE SAN BENEDETTO 4 COLORI - 0818/3' , '1' ,  '-1' , '1' ,
                               '2' , '1.6393442622951' , '22' , '0' , '2.00' ) 
15/11/2023 07:56:26 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '3333' AND id_document != '88544' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-26') 
15/11/2023 07:56:26 pm >> UPDATE ps_document SET
                          id_document_type = '11',
                          document_num = '3333',
                          document_date = '2023-10-26',
                          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 = '132.80',
                          price_tax_excluded = '123.42',
                          date_upd = NOW()
                        WHERE id_document = '88544' 
15/11/2023 07:56:26 pm >>  INSERT INTO ps_document_detail_backup
                                ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
                            SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88544' 
15/11/2023 07:56:26 pm >>  DELETE FROM ps_document_detail WHERE id_document = '88544' 
15/11/2023 07:56:26 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88544' , '9113' , 'ROSARIO FRANCESCANO DA COLLO - 2516' , '1' ,  '-1' , '1' ,
                               '2.3' , '1.8852459016393' , '22' , '0' , '2.30' ) 
15/11/2023 07:56:26 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88544' , '21196' , 'CALENDARIO LITURGICO 2024' , '2' ,  '-2' , '4' ,
                               '0.5000' , '0.5' , '0' , '0' , '1.00' ) 
15/11/2023 07:56:26 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88544' , '21682' , 'ORDO VIRGINUM' , '6' ,  '-6' , '4' ,
                               '14.0000' , '14' , '0' , '5' , '79.80' ) 
15/11/2023 07:56:26 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88544' , '21763' , 'BUSSOLOTTO OTTONE - 161' , '2' ,  '-2' , '1' ,
                               '17.5000' , '14.344262295082' , '22' , '0' , '35.00' ) 
15/11/2023 07:56:26 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '88544' , '1914' , 'CERA DELLA LITURGIA' , '3' ,  '-3' , '1' ,
                               '4.9000' , '4.016393442623' , '22' , '0' , '14.70' )