14/06/2022 08:38:00 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 
14/06/2022 08:38:00 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19638' , '1' , '' , 'nuovo-prodotto' )
14/06/2022 08:38:00 am >> INSERT INTO ps_product_shop (
                      id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd`
                  ) VALUES (
                      '19638' , '1' , '1' , '2' , NOW() , NOW()
                  ) 
14/06/2022 08:38:00 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19638' , '0' , '1' , '0' , '0' )
14/06/2022 08:38:35 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867571895' AND id_product != '19638' AND ean13 != '' 
14/06/2022 08:38:35 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '5/4',
                  ean13 = '9788867571895',
                  date_upd = NOW()
                WHERE id_product = '19638' 
14/06/2022 08:38:35 am >> UPDATE ps_product_lang SET
                  name = 'storia di carlo acutis',
                  description = ''
                WHERE id_product = '19638' 
14/06/2022 08:38:35 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '1.9'
                WHERE id_product = '19638' 
14/06/2022 08:38:35 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '1.9',
                  id_tax_rules_group = '4',
                  id_category_default = '51',
                  id_argoment_default = '25',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '19638' 
14/06/2022 08:38:35 am >> DELETE FROM ps_specific_price WHERE id_product = '19638' 
14/06/2022 08:38: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 = '19638' 
14/06/2022 08:38:36 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19639' , '1' , '' , 'nuovo-prodotto' )
14/06/2022 08:38: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 '19639' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19638' 
14/06/2022 08:38:36 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '19639' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19638' 
14/06/2022 08:40:10 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831278591' AND id_product != '19639' AND ean13 != '' 
14/06/2022 08:40:10 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '7/3',
                  ean13 = '9788831278591',
                  date_upd = NOW()
                WHERE id_product = '19639' 
14/06/2022 08:40:10 am >> UPDATE ps_product_lang SET
                  name = 'MORTE MAESTRA DI VITA - NEGRI/GUGLIELMONI',
                  description = ''
                WHERE id_product = '19639' 
14/06/2022 08:40:10 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '9.5'
                WHERE id_product = '19639' 
14/06/2022 08:40:11 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '9.5',
                  id_tax_rules_group = '4',
                  id_category_default = '97',
                  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 = '19639' 
14/06/2022 08:40:11 am >> DELETE FROM ps_specific_price WHERE id_product = '19639' 
14/06/2022 08:40:11 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 = '19639' 
14/06/2022 08:40:11 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19640' , '1' , '' , 'nuovo-prodotto' )
14/06/2022 08:40:11 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 '19640' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19639' 
14/06/2022 08:40:11 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '19640' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19639' 
14/06/2022 08:41:08 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788827012192' AND id_product != '19640' AND ean13 != '' 
14/06/2022 08:41:08 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '6/2',
                  ean13 = '9788827012192',
                  date_upd = NOW()
                WHERE id_product = '19640' 
14/06/2022 08:41:08 am >> UPDATE ps_product_lang SET
                  name = 'CHIARA E FRANCESCO D\'ASSISI - P. MESSA',
                  description = ''
                WHERE id_product = '19640' 
14/06/2022 08:41:08 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '9'
                WHERE id_product = '19640' 
14/06/2022 08:41:08 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '9',
                  id_tax_rules_group = '4',
                  id_category_default = '186',
                  id_argoment_default = '71',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '19640' 
14/06/2022 08:41:08 am >> DELETE FROM ps_specific_price WHERE id_product = '19640' 
14/06/2022 08:41:08 am >> INSERT INTO ps_product (
                  id_tax_rules_group , `date_add` , `date_upd`
                ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19640' 
14/06/2022 08:41:08 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19641' , '1' , '' , 'nuovo-prodotto' )
14/06/2022 08:41:08 am >> INSERT INTO ps_product_shop (
                    id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd`
                ) SELECT '19641' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19640' 
14/06/2022 08:41:08 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '19641' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19640' 
14/06/2022 08:43:12 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872985083' AND id_product != '19641' AND ean13 != '' 
14/06/2022 08:43:12 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '13/3',
                  ean13 = '9788872985083',
                  date_upd = NOW()
                WHERE id_product = '19641' 
14/06/2022 08:43:12 am >> UPDATE ps_product_lang SET
                  name = 'PREGHIERA SEMINA VITA - O. MARRAFFA',
                  description = ''
                WHERE id_product = '19641' 
14/06/2022 08:43:12 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '2.5'
                WHERE id_product = '19641' 
14/06/2022 08:43:12 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '2.5',
                  id_tax_rules_group = '4',
                  id_category_default = '29',
                  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 = '19641' 
14/06/2022 08:43:12 am >> DELETE FROM ps_specific_price WHERE id_product = '19641' 
14/06/2022 08:43:16 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 = '19641' 
14/06/2022 08:43:16 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19642' , '1' , '' , 'nuovo-prodotto' )
14/06/2022 08:43:16 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 '19642' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19641' 
14/06/2022 08:43:16 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '19642' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19641' 
14/06/2022 08:44:18 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839934444' AND id_product != '19642' AND ean13 != '' 
14/06/2022 08:44:18 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '13/6',
                  ean13 = '9788839934444',
                  date_upd = NOW()
                WHERE id_product = '19642' 
14/06/2022 08:44:18 am >> UPDATE ps_product_lang SET
                  name = 'RIFORMA - M. SEEWALD',
                  description = ''
                WHERE id_product = '19642' 
14/06/2022 08:44:18 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '24'
                WHERE id_product = '19642' 
14/06/2022 08:44:18 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '24',
                  id_tax_rules_group = '4',
                  id_category_default = '111',
                  id_argoment_default = '349',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '19642' 
14/06/2022 08:44:18 am >> DELETE FROM ps_specific_price WHERE id_product = '19642' 
14/06/2022 08:44:19 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 = '19642' 
14/06/2022 08:44:19 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19643' , '1' , '' , 'nuovo-prodotto' )
14/06/2022 08:44:19 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 '19643' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19642' 
14/06/2022 08:44:19 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '19643' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19642' 
14/06/2022 08:45:13 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839932334' AND id_product != '19643' AND ean13 != '' 
14/06/2022 08:45:13 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '11/4',
                  ean13 = '9788839932334',
                  date_upd = NOW()
                WHERE id_product = '19643' 
14/06/2022 08:45:13 am >> UPDATE ps_product_lang SET
                  name = 'ENIGMI DELLA BIBBIA - A.A. VALDES',
                  description = ''
                WHERE id_product = '19643' 
14/06/2022 08:45:13 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '28'
                WHERE id_product = '19643' 
14/06/2022 08:45:13 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '28',
                  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 = '19643' 
14/06/2022 08:45:13 am >> DELETE FROM ps_specific_price WHERE id_product = '19643' 
14/06/2022 08:45:14 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 = '19643' 
14/06/2022 08:45:14 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19644' , '1' , '' , 'nuovo-prodotto' )
14/06/2022 08:45:14 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 '19644' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19643' 
14/06/2022 08:45:14 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '19644' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19643' 
14/06/2022 08:46:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892228832' AND id_product != '19644' AND ean13 != '' 
14/06/2022 08:46:11 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '7/6',
                  ean13 = '9788892228832',
                  date_upd = NOW()
                WHERE id_product = '19644' 
14/06/2022 08:46:11 am >> UPDATE ps_product_lang SET
                  name = 'CHIESA CHE VERRA\' - A. MATTEO',
                  description = ''
                WHERE id_product = '19644' 
14/06/2022 08:46:11 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '18'
                WHERE id_product = '19644' 
14/06/2022 08:46:11 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '18',
                  id_tax_rules_group = '4',
                  id_category_default = '30',
                  id_argoment_default = '78',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '19644' 
14/06/2022 08:46:11 am >> DELETE FROM ps_specific_price WHERE id_product = '19644' 
14/06/2022 08:46:12 am >> INSERT INTO ps_product (
                  id_tax_rules_group , `date_add` , `date_upd`
                ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19644' 
14/06/2022 08:46:12 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19645' , '1' , '' , 'nuovo-prodotto' )
14/06/2022 08:46:12 am >> INSERT INTO ps_product_shop (
                    id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd`
                ) SELECT '19645' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19644' 
14/06/2022 08:46:12 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '19645' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19644' 
14/06/2022 08:47:07 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892226913' AND id_product != '19645' AND ean13 != '' 
14/06/2022 08:47:07 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '7/7',
                  ean13 = '9788892226913',
                  date_upd = NOW()
                WHERE id_product = '19645' 
14/06/2022 08:47:07 am >> UPDATE ps_product_lang SET
                  name = 'CUSTODI DEL CREATO - F. GIANSOLDATI',
                  description = ''
                WHERE id_product = '19645' 
14/06/2022 08:47:07 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '12'
                WHERE id_product = '19645' 
14/06/2022 08:47:07 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '12',
                  id_tax_rules_group = '4',
                  id_category_default = '30',
                  id_argoment_default = '10',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '19645' 
14/06/2022 08:47:07 am >> DELETE FROM ps_specific_price WHERE id_product = '19645' 
14/06/2022 08:47:08 am >> INSERT INTO ps_product (
                  id_tax_rules_group , `date_add` , `date_upd`
                ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19645' 
14/06/2022 08:47:08 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19646' , '1' , '' , 'nuovo-prodotto' )
14/06/2022 08:47:08 am >> INSERT INTO ps_product_shop (
                    id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd`
                ) SELECT '19646' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19645' 
14/06/2022 08:47:08 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '19646' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19645' 
14/06/2022 08:48:04 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259751171' AND id_product != '19646' AND ean13 != '' 
14/06/2022 08:48:04 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '13/6',
                  ean13 = '9791259751171',
                  date_upd = NOW()
                WHERE id_product = '19646' 
14/06/2022 08:48:04 am >> UPDATE ps_product_lang SET
                  name = 'LUCI E OMBRE DELLA RELIGIOSITA\' - D.GOMEZ',
                  description = ''
                WHERE id_product = '19646' 
14/06/2022 08:48:04 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '18'
                WHERE id_product = '19646' 
14/06/2022 08:48:04 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '18',
                  id_tax_rules_group = '4',
                  id_category_default = '267',
                  id_argoment_default = '65',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '19646' 
14/06/2022 08:48:04 am >> DELETE FROM ps_specific_price WHERE id_product = '19646' 
14/06/2022 08:48:06 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 = '19646' 
14/06/2022 08:48:06 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19647' , '1' , '' , 'nuovo-prodotto' )
14/06/2022 08:48:06 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 '19647' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19646' 
14/06/2022 08:48:06 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '19647' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19646' 
14/06/2022 08:49:12 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892229006' AND id_product != '19647' AND ean13 != '' 
14/06/2022 08:49:12 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '6/5',
                  ean13 = '9788892229006',
                  date_upd = NOW()
                WHERE id_product = '19647' 
14/06/2022 08:49:12 am >> UPDATE ps_product_lang SET
                  name = 'ANTICORPI DI PACE - TONONO BELLO',
                  description = ''
                WHERE id_product = '19647' 
14/06/2022 08:49:12 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '15'
                WHERE id_product = '19647' 
14/06/2022 08:49:12 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 = '19647' 
14/06/2022 08:49:12 am >> DELETE FROM ps_specific_price WHERE id_product = '19647' 
14/06/2022 08:49: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 = '19647' 
14/06/2022 08:49:13 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19648' , '1' , '' , 'nuovo-prodotto' )
14/06/2022 08:49: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 '19648' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19647' 
14/06/2022 08:49:13 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '19648' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19647' 
14/06/2022 08:50:38 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259751348' AND id_product != '19648' AND ean13 != '' 
14/06/2022 08:50:38 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '5/5',
                  ean13 = '9791259751348',
                  date_upd = NOW()
                WHERE id_product = '19648' 
14/06/2022 08:50:38 am >> UPDATE ps_product_lang SET
                  name = 'TALITHA KUM - F.M. MARINO',
                  description = ''
                WHERE id_product = '19648' 
14/06/2022 08:50:38 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '16'
                WHERE id_product = '19648' 
14/06/2022 08:50:38 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '16',
                  id_tax_rules_group = '4',
                  id_category_default = '267',
                  id_argoment_default = '10',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '19648' 
14/06/2022 08:50:38 am >> DELETE FROM ps_specific_price WHERE id_product = '19648' 
14/06/2022 08:50:39 am >> INSERT INTO ps_product (
                  id_tax_rules_group , `date_add` , `date_upd`
                ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19648' 
14/06/2022 08:50:39 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19649' , '1' , '' , 'nuovo-prodotto' )
14/06/2022 08:50:39 am >> INSERT INTO ps_product_shop (
                    id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd`
                ) SELECT '19649' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19648' 
14/06/2022 08:50:39 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '19649' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19648' 
14/06/2022 08:51:27 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892228979' AND id_product != '19649' AND ean13 != '' 
14/06/2022 08:51:27 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '13/7',
                  ean13 = '9788892228979',
                  date_upd = NOW()
                WHERE id_product = '19649' 
14/06/2022 08:51:27 am >> UPDATE ps_product_lang SET
                  name = 'MEMORIA VIVA - R. FISICHELLA ',
                  description = ''
                WHERE id_product = '19649' 
14/06/2022 08:51:27 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '25'
                WHERE id_product = '19649' 
14/06/2022 08:51:27 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '25',
                  id_tax_rules_group = '4',
                  id_category_default = '30',
                  id_argoment_default = '349',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '19649' 
14/06/2022 08:51:27 am >> DELETE FROM ps_specific_price WHERE id_product = '19649' 
14/06/2022 08:51:28 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 = '19649' 
14/06/2022 08:51:28 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19650' , '1' , '' , 'nuovo-prodotto' )
14/06/2022 08:51:28 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 '19650' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19649' 
14/06/2022 08:51:28 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '19650' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19649' 
14/06/2022 08:51:58 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892228696' AND id_product != '19650' AND ean13 != '' 
14/06/2022 08:51:58 am >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '6/6',
                  ean13 = '9788892228696',
                  date_upd = NOW()
                WHERE id_product = '19650' 
14/06/2022 08:51:58 am >> UPDATE ps_product_lang SET
                  name = 'UNBOUND',
                  description = ''
                WHERE id_product = '19650' 
14/06/2022 08:51:58 am >> UPDATE ps_product SET
                  wholesale_price = '0.00',
                  on_sale = '0',
                  price = '20'
                WHERE id_product = '19650' 
14/06/2022 08:51:58 am >> UPDATE ps_product_shop SET
                  wholesale_price = '0.00',
                  price = '20',
                  id_tax_rules_group = '4',
                  id_category_default = '30',
                  id_argoment_default = '10',
                  id_internal_category = '7',
                  on_sale = '0',
                  on_showcase = '0',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '19650' 
14/06/2022 08:51:58 am >> DELETE FROM ps_specific_price WHERE id_product = '19650' 
14/06/2022 08:51:59 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 = '19650' 
14/06/2022 08:51:59 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19651' , '1' , '' , 'nuovo-prodotto' )
14/06/2022 08:51:59 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 '19651' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19650' 
14/06/2022 08:51:59 am >> INSERT INTO `ps_stock_available` (
                  id_product , id_product_attribute , id_shop , id_shop_group , quantity
                ) SELECT '19651' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19650' 
14/06/2022 08:52:32 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' ,
                          '601910' ,
                          '2022-06-08' ,
                          '' ,
                          '0' ,
                          '7' ,
                          '2602' ,
                          'P. ZZA SAN PAOLO, 14 12051 ALBA' ,
                          '' ,
                          '' ,
                          '4.02' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '141.88' ,
                          '141.88' ,
                          NOW() ,
                          NOW() ) 
14/06/2022 08:52:32 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 = '58750' 
14/06/2022 08:52:32 am >>  DELETE FROM ps_document_detail WHERE id_document = '58750' 
14/06/2022 08:52:32 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58750' , '19638' , 'storia di carlo acutis' , '2' ,  '2' , '4' ,
                               '1.90' , '1.9' , '0' , '30' , '2.6600' ) 
14/06/2022 08:52:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '19638' AND id_supplier = '7' 
14/06/2022 08:52:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19638' , '7' , '1' ) 
14/06/2022 08:52:33 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58750' , '19639' , 'MORTE MAESTRA DI VITA - NEGRI/GUGLIELMONI' , '1' ,  '1' , '4' ,
                               '9.50' , '9.5' , '0' , '30' , '6.6500' ) 
14/06/2022 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '19639' AND id_supplier = '7' 
14/06/2022 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19639' , '7' , '1' ) 
14/06/2022 08:52:33 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58750' , '19640' , 'CHIARA E FRANCESCO DASSISI - P. MESSA' , '1' ,  '1' , '4' ,
                               '9.00' , '9' , '0' , '30' , '6.3000' ) 
14/06/2022 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '19640' AND id_supplier = '7' 
14/06/2022 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19640' , '7' , '1' ) 
14/06/2022 08:52:33 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58750' , '19641' , 'PREGHIERA SEMINA VITA - O. MARRAFFA' , '1' ,  '1' , '4' ,
                               '2.50' , '2.5' , '0' , '30' , '1.7500' ) 
14/06/2022 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '19641' AND id_supplier = '7' 
14/06/2022 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19641' , '7' , '1' ) 
14/06/2022 08:52:33 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58750' , '19642' , 'RIFORMA - M. SEEWALD' , '1' ,  '1' , '4' ,
                               '24.00' , '24' , '0' , '30' , '16.8000' ) 
14/06/2022 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '19642' AND id_supplier = '7' 
14/06/2022 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19642' , '7' , '1' ) 
14/06/2022 08:52:33 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58750' , '19643' , 'ENIGMI DELLA BIBBIA - A.A. VALDES' , '1' ,  '1' , '4' ,
                               '28.00' , '28' , '0' , '30' , '19.6000' ) 
14/06/2022 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '19643' AND id_supplier = '7' 
14/06/2022 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19643' , '7' , '1' ) 
14/06/2022 08:52:33 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58750' , '19644' , 'CHIESA CHE VERRA - A. MATTEO' , '1' ,  '1' , '4' ,
                               '18.00' , '18' , '0' , '33' , '12.0600' ) 
14/06/2022 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '19644' AND id_supplier = '7' 
14/06/2022 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19644' , '7' , '1' ) 
14/06/2022 08:52:33 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58750' , '19645' , 'CUSTODI DEL CREATO - F. GIANSOLDATI' , '1' ,  '1' , '4' ,
                               '12.00' , '12' , '0' , '33' , '8.0400' ) 
14/06/2022 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '19645' AND id_supplier = '7' 
14/06/2022 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19645' , '7' , '1' ) 
14/06/2022 08:52:33 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58750' , '19646' , 'LUCI E OMBRE DELLA RELIGIOSITA - D.GOMEZ' , '1' ,  '1' , '4' ,
                               '18.00' , '18' , '0' , '30' , '12.6000' ) 
14/06/2022 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '19646' AND id_supplier = '7' 
14/06/2022 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19646' , '7' , '1' ) 
14/06/2022 08:52:33 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58750' , '19647' , 'ANTICORPI DI PACE - TONONO BELLO' , '1' ,  '1' , '4' ,
                               '15.00' , '15' , '0' , '33' , '10.0500' ) 
14/06/2022 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '19647' AND id_supplier = '7' 
14/06/2022 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19647' , '7' , '1' ) 
14/06/2022 08:52:33 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58750' , '19648' , 'TALITHA KUM - F.M. MARINO' , '1' ,  '1' , '4' ,
                               '16.00' , '16' , '0' , '30' , '11.2000' ) 
14/06/2022 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '19648' AND id_supplier = '7' 
14/06/2022 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19648' , '7' , '1' ) 
14/06/2022 08:52:33 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58750' , '19649' , 'MEMORIA VIVA - R. FISICHELLA ' , '1' ,  '1' , '4' ,
                               '25.00' , '25' , '0' , '33' , '16.7500' ) 
14/06/2022 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '19649' AND id_supplier = '7' 
14/06/2022 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19649' , '7' , '1' ) 
14/06/2022 08:52:33 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58750' , '19650' , 'UNBOUND' , '1' ,  '1' , '4' ,
                               '20.00' , '20' , '0' , '33' , '13.4000' ) 
14/06/2022 08:52:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '19650' AND id_supplier = '7' 
14/06/2022 08:52:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19650' , '7' , '1' ) 
14/06/2022 09:51:32 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '37/A' AND id_document != '57793' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-16') 
14/06/2022 09:51:32 am >> UPDATE ps_document SET
                          id_document_type = '24',
                          document_num = '37/A',
                          document_date = '2022-05-16',
                          document_letter = 'A',
                          id_customer = '3712',
                          id_supplier = '',
                          id_address = '4671443',
                          address1 = 'VIA DALMAZIA 6 84121 SALERNO',
                          address2 = '',
                          note = 'ACCONTO € 4,00',
                          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 = '117.72',
                          price_tax_excluded = '103.70',
                          date_upd = NOW()
                        WHERE id_document = '57793' 
14/06/2022 09:51:32 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 = '57793' 
14/06/2022 09:51:32 am >>  DELETE FROM ps_document_detail WHERE id_document = '57793' 
14/06/2022 09:51:32 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '57793' , '7311' , 'OSTIA SOTTILE 74MM' , '4' ,  '-4' , '3' ,
                               '1.9000' , '1.8269230769231' , '4' , '0' , '7.60' ) 
14/06/2022 09:51:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 
14/06/2022 09:51:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 
14/06/2022 09:51:33 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '57793' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '7' ,  '-7' , '3' ,
                               '3.50' , '3.3653846153846' , '4' , '0' , '24.50' ) 
14/06/2022 09:51:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 
14/06/2022 09:51:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 
14/06/2022 09:51:33 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '57793' , '7935' , 'PERGAMENE - CRESIMA MOD. B' , '15' ,  '-15' , '1' ,
                               '0.3000' , '0.24590163934426' , '22' , '0' , '4.50' ) 
14/06/2022 09:51:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '7935' AND id_supplier = '' 
14/06/2022 09:51:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7935' , '' , '1' ) 
14/06/2022 09:51:33 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '57793' , '1914' , 'CERA DELLA LITURGIA' , '12' ,  '-12' , '1' ,
                               '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 
14/06/2022 09:51:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 
14/06/2022 09:51:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 
14/06/2022 09:51:33 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '57793' , '9015' , 'RITO DELLA CONFERMAZIONE' , '1' ,  '-1' , '4' ,
                               '15.5000' , '15.5' , '0' , '5' , '14.72' ) 
14/06/2022 09:51:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '9015' AND id_supplier = '' 
14/06/2022 09:51:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9015' , '' , '1' ) 
14/06/2022 09:51:33 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '57793' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' ,  '-1' , '1' ,
                               '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 
14/06/2022 09:51:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 
14/06/2022 09:51:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 
14/06/2022 09:52:01 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '1258' AND id_document != '56431' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-27') 
14/06/2022 09:52:01 am >> UPDATE ps_document SET
                          id_document_type = '11',
                          document_num = '1258',
                          document_date = '2022-04-27',
                          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 = '74.20',
                          price_tax_excluded = '64.39',
                          date_upd = NOW()
                        WHERE id_document = '56431' 
14/06/2022 09:52:01 am >>  INSERT INTO ps_document_detail_backup
        ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
        SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56431' 
14/06/2022 09:52:01 am >>  DELETE FROM ps_document_detail WHERE id_document = '56431' 
14/06/2022 09:52:01 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '56431' , '14163' , 'PARACERA OTTONE LUCIDO - Q120' , '1' ,  '-1' , '1' ,
                               '49.0000' , '40.16393442623' , '22' , '0' , '49.00' ) 
14/06/2022 09:52:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '14163' AND id_supplier = '' 
14/06/2022 09:52:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14163' , '' , '1' ) 
14/06/2022 09:52:02 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '56431' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '5' ,  '-5' , '3' ,
                               '3' , '2.8846153846154' , '4' , '0' , '15.00' ) 
14/06/2022 09:52:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 
14/06/2022 09:52:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 
14/06/2022 09:52:02 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '56431' , '7311' , 'OSTIA SOTTILE 74MM' , '6' ,  '-6' , '3' ,
                               '1.7000' , '1.6346153846154' , '4' , '0' , '10.20' ) 
14/06/2022 09:52:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 
14/06/2022 09:52:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 
14/06/2022 09:52:49 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '1062' AND id_document != '54665' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-09') 
14/06/2022 09:52:49 am >> UPDATE ps_document SET
                          id_document_type = '11',
                          document_num = '1062',
                          document_date = '2022-04-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 = '445.00',
                          price_tax_excluded = '411.60',
                          date_upd = NOW()
                        WHERE id_document = '54665' 
14/06/2022 09:52: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 = '54665' 
14/06/2022 09:52:49 am >>  DELETE FROM ps_document_detail WHERE id_document = '54665' 
14/06/2022 09:52: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
                            ( '54665' , '7311' , 'OSTIA SOTTILE 74MM' , '14' ,  '-14' , '3' ,
                               '1.5000' , '1.4423076923077' , '4' , '0' , '21.00' ) 
14/06/2022 09:52:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 
14/06/2022 09:52:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 
14/06/2022 09:52: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
                            ( '54665' , '11264' , 'VESTINA BATTESIMALE' , '20' ,  '-20' , '1' ,
                               '2.0000' , '1.6393442622951' , '22' , '0' , '40.00' ) 
14/06/2022 09:52:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '11264' AND id_supplier = '' 
14/06/2022 09:52:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11264' , '' , '1' ) 
14/06/2022 09:52: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
                            ( '54665' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '20' ,  '-20' , '1' ,
                               '1.2000' , '0.98360655737705' , '22' , '0' , '24.00' ) 
14/06/2022 09:52:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '791' AND id_supplier = '' 
14/06/2022 09:52:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '791' , '' , '1' ) 
14/06/2022 09:52: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
                            ( '54665' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' ,  '-2' , '1' ,
                               '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 
14/06/2022 09:52:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 
14/06/2022 09:52:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 
14/06/2022 09:52: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
                            ( '54665' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '3' ,  '-3' , '1' ,
                               '6.5000' , '5.327868852459' , '22' , '0' , '19.50' ) 
14/06/2022 09:52:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '11757' AND id_supplier = '' 
14/06/2022 09:52:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11757' , '' , '1' ) 
14/06/2022 09:52: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
                            ( '54665' , '7673' , 'PARTICOLE MM38' , '14' ,  '-14' , '3' ,
                               '2.8000' , '2.6923076923077' , '4' , '0' , '39.20' ) 
14/06/2022 09:52:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '7673' AND id_supplier = '' 
14/06/2022 09:52:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7673' , '' , '1' ) 
14/06/2022 09:52: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
                            ( '54665' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '25' ,  '-25' , '1' ,
                               '0.2000' , '0.16393442622951' , '22' , '0' , '5.00' ) 
14/06/2022 09:52:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '18617' AND id_supplier = '' 
14/06/2022 09:52:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18617' , '' , '1' ) 
14/06/2022 09:52: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
                            ( '54665' , '17940' , 'MIRACOLOSA - ISONZO 152bis' , '1' ,  '-1' , '1' ,
                               '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 
14/06/2022 09:52:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '17940' AND id_supplier = '' 
14/06/2022 09:52:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17940' , '' , '1' ) 
14/06/2022 09:52:50 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '54665' , '7096' , 'NOVE PRIMI VENERDÍ DEL MESE - 8247' , '30' ,  '-30' , '4' ,
                               '2.0000' , '2' , '0' , '5' , '57.00' ) 
14/06/2022 09:52:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '7096' AND id_supplier = '' 
14/06/2022 09:52:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7096' , '' , '1' ) 
14/06/2022 09:52:50 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '54665' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '1' ,  '-1' , '4' ,
                               '7.0000' , '7' , '0' , '5' , '6.65' ) 
14/06/2022 09:52:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '8247' AND id_supplier = '' 
14/06/2022 09:52:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8247' , '' , '1' ) 
14/06/2022 09:52:50 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '54665' , '11151' , 'LIBRI' , '1' ,  '-1' , '4' ,
                               '2.4200' , '2.42' , '0' , '0' , '2.42' ) 
14/06/2022 09:52:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 
14/06/2022 09:52:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 
14/06/2022 09:52:50 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '54665' , '9333' , 'SACRO CUORE DI GESÙ - 208 ' , '1' ,  '-1' , '1' ,
                               '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 
14/06/2022 09:52:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '9333' AND id_supplier = '' 
14/06/2022 09:52:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9333' , '' , '1' ) 
14/06/2022 09:52:50 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '54665' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '1' ,  '-1' , '4' ,
                               '7.0000' , '7' , '0' , '5' , '6.65' ) 
14/06/2022 09:52:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '8247' AND id_supplier = '' 
14/06/2022 09:52:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8247' , '' , '1' ) 
14/06/2022 09:52:50 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '54665' , '4372' , 'GESÙ BAMBINO - 265 ' , '1' ,  '-1' , '1' ,
                               '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 
14/06/2022 09:52:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '4372' AND id_supplier = '' 
14/06/2022 09:52:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4372' , '' , '1' ) 
14/06/2022 09:52:50 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '54665' , '6872' , 'NASCITA DI GESÙ BAMBINO - 189' , '1' ,  '-1' , '1' ,
                               '3.6000' , '2.9508196721311' , '22' , '0' , '3.60' ) 
14/06/2022 09:52:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '6872' AND id_supplier = '' 
14/06/2022 09:52:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6872' , '' , '1' ) 
14/06/2022 09:52:50 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '54665' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' ,  '-1' , '4' ,
                               '110.0000' , '110' , '0' , '5' , '104.50' ) 
14/06/2022 09:52:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '' 
14/06/2022 09:52:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '' , '1' ) 
14/06/2022 09:52:50 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '54665' , '16464' , 'CLERGY BLU NIDO DAPE  ML 43 - C22' , '1' ,  '-1' , '1' ,
                               '45.0000' , '36.885245901639' , '22' , '0' , '45.00' ) 
14/06/2022 09:52:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '16464' AND id_supplier = '' 
14/06/2022 09:52:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16464' , '' , '1' ) 
14/06/2022 09:52:51 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '54665' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '1' ,  '-1' , '4' ,
                               '18.5000' , '18.5' , '0' , '5' , '17.58' ) 
14/06/2022 09:52:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '9253' AND id_supplier = '' 
14/06/2022 09:52:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9253' , '' , '1' ) 
14/06/2022 09:52:51 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '54665' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '8' ,  '-8' , '3' ,
                               '2.8' , '2.6923076923077' , '4' , '0' , '22.40' ) 
14/06/2022 09:52:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 
14/06/2022 09:52:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 
14/06/2022 09:53:40 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '763' AND id_document != '53263' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-03-15') 
14/06/2022 09:53:40 am >> UPDATE ps_document SET
                          id_document_type = '11',
                          document_num = '763',
                          document_date = '2022-03-15',
                          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 = '195.00',
                          price_tax_excluded = '159.84',
                          date_upd = NOW()
                        WHERE id_document = '53263' 
14/06/2022 09:53: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 = '53263' 
14/06/2022 09:53:40 am >>  DELETE FROM ps_document_detail WHERE id_document = '53263' 
14/06/2022 09:53: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
                            ( '53263' , '15331' , 'CERO PASQUALE 80X120 - RILIEVO IN CERA' , '1' ,  '-1' , '1' ,
                               '135.0000' , '110.65573770492' , '22' , '0' , '135.00' ) 
14/06/2022 09:53:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '15331' AND id_supplier = '' 
14/06/2022 09:53:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15331' , '' , '1' ) 
14/06/2022 09:53: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
                            ( '53263' , '19107' , 'INCENSO GRANI 3A' , '1' ,  '-1' , '1' ,
                               '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 
14/06/2022 09:53:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '19107' AND id_supplier = '' 
14/06/2022 09:53:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19107' , '' , '1' ) 
14/06/2022 09:53: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
                            ( '53263' , '2177' , 'CLERGY BASIC - MM - B&P' , '1' ,  '-1' , '1' ,
                               '30' , '24.590163934426' , '22' , '0' , '30.00' ) 
14/06/2022 09:53:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '2177' AND id_supplier = '' 
14/06/2022 09:53:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2177' , '' , '1' ) 
14/06/2022 09:54:36 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '814' AND id_document != '53337' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-03-19') 
14/06/2022 09:54:36 am >> UPDATE ps_document SET
                          id_document_type = '11',
                          document_num = '814',
                          document_date = '2022-03-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 = '100.00',
                          price_tax_excluded = '81.97',
                          date_upd = NOW()
                        WHERE id_document = '53337' 
14/06/2022 09:54:36 am >>  INSERT INTO ps_document_detail_backup
        ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
        SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '53337' 
14/06/2022 09:54:36 am >>  DELETE FROM ps_document_detail WHERE id_document = '53337' 
14/06/2022 09:54:36 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '53337' , '15407' , 'AMITTO F/LANA CON CROCE - 6799' , '2' ,  '-2' , '1' ,
                               '20' , '16.393442622951' , '22' , '0' , '40.00' ) 
14/06/2022 09:54:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '15407' AND id_supplier = '' 
14/06/2022 09:54:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15407' , '' , '1' ) 
14/06/2022 09:54:37 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '53337' , '18682' , 'CLERGY ROMANO ML  - C17' , '2' ,  '-2' , '1' ,
                               '30' , '24.590163934426' , '22' , '0' , '60.00' ) 
14/06/2022 09:54:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '18682' AND id_supplier = '' 
14/06/2022 09:54:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18682' , '' , '1' ) 
14/06/2022 09:55:27 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '892' AND id_document != '53430' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-03-28') 
14/06/2022 09:55:27 am >> UPDATE ps_document SET
                          id_document_type = '11',
                          document_num = '892',
                          document_date = '2022-03-28',
                          document_letter = '',
                          id_customer = '0',
                          id_supplier = '',
                          id_address = '0',
                          address1 = '',
                          address2 = '',
                          note = '',
                          price_shipping = '0.00',
                          id_tax_shipping_rules = '4',
                          colli = '0',
                          peso = '0',
                          porto_e_imballo = '0',
                          mezzo_consegna = '',
                          id_payment = '0',
                          id_causal = '0',
                          price_tax_included = '50.00',
                          price_tax_excluded = '40.98',
                          date_upd = NOW()
                        WHERE id_document = '53430' 
14/06/2022 09:55:27 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 = '53430' 
14/06/2022 09:55:27 am >>  DELETE FROM ps_document_detail WHERE id_document = '53430' 
14/06/2022 09:55:27 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '53430' , '16456' , 'CINGOLO  - CING03' , '2' ,  '-2' , '1' ,
                               '10' , '8.1967213114754' , '22' , '0' , '20.00' ) 
14/06/2022 09:55:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '16456' AND id_supplier = '' 
14/06/2022 09:55:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16456' , '' , '1' ) 
14/06/2022 09:55:28 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '53430' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '1' ,  '-1' , '1' ,
                               '30' , '24.590163934426' , '22' , '0' , '30.00' ) 
14/06/2022 09:55:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '19396' AND id_supplier = '' 
14/06/2022 09:55:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19396' , '' , '1' ) 
14/06/2022 09:56:00 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '899' AND id_document != '53438' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-03-28') 
14/06/2022 09:56:01 am >> UPDATE ps_document SET
                          id_document_type = '11',
                          document_num = '899',
                          document_date = '2022-03-28',
                          document_letter = '',
                          id_customer = '0',
                          id_supplier = '',
                          id_address = '0',
                          address1 = '',
                          address2 = '',
                          note = '',
                          price_shipping = '0.00',
                          id_tax_shipping_rules = '4',
                          colli = '0',
                          peso = '0',
                          porto_e_imballo = '0',
                          mezzo_consegna = '',
                          id_payment = '0',
                          id_causal = '0',
                          price_tax_included = '58.30',
                          price_tax_excluded = '47.79',
                          date_upd = NOW()
                        WHERE id_document = '53438' 
14/06/2022 09:56:01 am >>  INSERT INTO ps_document_detail_backup
        ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
        SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '53438' 
14/06/2022 09:56:01 am >>  DELETE FROM ps_document_detail WHERE id_document = '53438' 
14/06/2022 09:56:01 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '53438' , '7202' , 'ARTICOLI RELIGIOSI' , '1' ,  '-1' , '1' ,
                               '28.3' , '23.196721311475' , '22' , '0' , '28.30' ) 
14/06/2022 09:56:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 
14/06/2022 09:56:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 
14/06/2022 09:56:01 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '53438' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '1' ,  '-1' , '1' ,
                               '30' , '24.590163934426' , '22' , '0' , '30.00' ) 
14/06/2022 09:56:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '19396' AND id_supplier = '' 
14/06/2022 09:56:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19396' , '' , '1' ) 
14/06/2022 09:56:24 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '894' AND id_document != '53432' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-03-28') 
14/06/2022 09:56:24 am >> UPDATE ps_document SET
                          id_document_type = '11',
                          document_num = '894',
                          document_date = '2022-03-28',
                          document_letter = '',
                          id_customer = '0',
                          id_supplier = '',
                          id_address = '0',
                          address1 = '',
                          address2 = '',
                          note = '',
                          price_shipping = '0.00',
                          id_tax_shipping_rules = '4',
                          colli = '0',
                          peso = '0',
                          porto_e_imballo = '0',
                          mezzo_consegna = '',
                          id_payment = '0',
                          id_causal = '0',
                          price_tax_included = '164.00',
                          price_tax_excluded = '136.98',
                          date_upd = NOW()
                        WHERE id_document = '53432' 
14/06/2022 09:56:24 am >>  INSERT INTO ps_document_detail_backup
        ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
        SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '53432' 
14/06/2022 09:56:24 am >>  DELETE FROM ps_document_detail WHERE id_document = '53432' 
14/06/2022 09:56:24 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '53432' , '17988' , 'BACILE PALLADIO CM 24 - 688' , '1' ,  '-1' , '1' ,
                               '61' , '50' , '22' , '0' , '61.00' ) 
14/06/2022 09:56:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '17988' AND id_supplier = '' 
14/06/2022 09:56:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17988' , '' , '1' ) 
14/06/2022 09:56:24 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '53432' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '6' ,  '-6' , '3' ,
                               '3.0000' , '2.8846153846154' , '4' , '0' , '18.00' ) 
14/06/2022 09:56:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 
14/06/2022 09:56:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 
14/06/2022 09:56:24 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '53432' , '15210' , 'CERO PASQUALE API 80X120' , '1' ,  '-1' , '1' ,
                               '85.0000' , '69.672131147541' , '22' , '0' , '85.00' ) 
14/06/2022 09:56:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '15210' AND id_supplier = '' 
14/06/2022 09:56:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15210' , '' , '1' ) 
14/06/2022 09:57:22 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '1174' AND id_document != '55307' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-19') 
14/06/2022 09:57:22 am >> UPDATE ps_document SET
                          id_document_type = '11',
                          document_num = '1174',
                          document_date = '2022-04-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 = '200.00',
                          price_tax_excluded = '163.93',
                          date_upd = NOW()
                        WHERE id_document = '55307' 
14/06/2022 09:57:22 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 = '55307' 
14/06/2022 09:57:22 am >>  DELETE FROM ps_document_detail WHERE id_document = '55307' 
14/06/2022 09:57:22 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '55307' , '7202' , 'ARTICOLI RELIGIOSI' , '1' ,  '-1' , '1' ,
                               '50' , '40.983606557377' , '22' , '0' , '50.00' ) 
14/06/2022 09:57:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 
14/06/2022 09:57:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 
14/06/2022 09:57:22 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '55307' , '1364' , 'BROCCA E PIATTINO - CM 23 PALLADIATI - 680' , '1' ,  '-1' , '1' ,
                               '150' , '122.95081967213' , '22' , '0' , '150.00' ) 
14/06/2022 09:57:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '1364' AND id_supplier = '' 
14/06/2022 09:57:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1364' , '' , '1' ) 
14/06/2022 09:58:02 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '1743' AND id_document != '58556' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-01') 
14/06/2022 09:58:02 am >> UPDATE ps_document SET
                          id_document_type = '11',
                          document_num = '1743',
                          document_date = '2022-06-01',
                          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 = '30.00',
                          price_tax_excluded = '30.00',
                          date_upd = NOW()
                        WHERE id_document = '58556' 
14/06/2022 09:58:02 am >>  INSERT INTO ps_document_detail_backup
        ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
        SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58556' 
14/06/2022 09:58:02 am >>  DELETE FROM ps_document_detail WHERE id_document = '58556' 
14/06/2022 09:58:02 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58556' , '17528' , 'PREGHIERE EUCARISTICHE PER LA CONCELEBRAZIONE' , '10' ,  '-10' , '4' ,
                               '3' , '3' , '0' , '0' , '30.00' ) 
14/06/2022 09:58:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '17528' AND id_supplier = '' 
14/06/2022 09:58:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17528' , '' , '1' ) 
14/06/2022 09:58:25 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '1666' AND id_document != '58461' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-26') 
14/06/2022 09:58:25 am >> UPDATE ps_document SET
                          id_document_type = '11',
                          document_num = '1666',
                          document_date = '2022-05-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 = '38.00',
                          price_tax_excluded = '38.00',
                          date_upd = NOW()
                        WHERE id_document = '58461' 
14/06/2022 09:58:25 am >>  INSERT INTO ps_document_detail_backup
        ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
        SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58461' 
14/06/2022 09:58:25 am >>  DELETE FROM ps_document_detail WHERE id_document = '58461' 
14/06/2022 09:58:25 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58461' , '17528' , 'PREGHIERE EUCARISTICHE PER LA CONCELEBRAZIONE' , '10' ,  '-10' , '4' ,
                               '3.8' , '3.8' , '0' , '0' , '38.00' ) 
14/06/2022 09:58:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '17528' AND id_supplier = '' 
14/06/2022 09:58:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17528' , '' , '1' ) 
14/06/2022 09:58:54 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '46/A' AND id_document != '58735' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-06-11') 
14/06/2022 09:58:55 am >> UPDATE ps_document SET
                          id_document_type = '24',
                          document_num = '46/A',
                          document_date = '2022-06-11',
                          document_letter = 'A',
                          id_customer = '3550',
                          id_supplier = '',
                          id_address = '4671016',
                          address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA',
                          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 = '659.00',
                          price_tax_excluded = '559.47',
                          date_upd = NOW()
                        WHERE id_document = '58735' 
14/06/2022 09:58:55 am >>  INSERT INTO ps_document_detail_backup
        ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
        SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58735' 
14/06/2022 09:58:55 am >>  DELETE FROM ps_document_detail WHERE id_document = '58735' 
14/06/2022 09:58:55 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58735' , '16689' , 'OSTIA PAN DI CENA mm80' , '20' ,  '-20' , '3' ,
                               '2.0000' , '1.9230769230769' , '4' , '0' , '40.00' ) 
14/06/2022 09:58:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 
14/06/2022 09:58:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 
14/06/2022 09:58:55 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58735' , '0' , 'OSTIA 70MM' , '1' ,  '-1' , '3' ,
                               '1.9000' , '1.8269230769231' , '4' , '0' , '1.90' ) 
14/06/2022 09:58:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 
14/06/2022 09:58:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 
14/06/2022 09:58:55 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58735' , '15407' , 'AMITTO F/LANA CON CROCE - 6799' , '2' ,  '-2' , '1' ,
                               '25.0000' , '20.491803278689' , '22' , '0' , '50.00' ) 
14/06/2022 09:58:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '15407' AND id_supplier = '' 
14/06/2022 09:58:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15407' , '' , '1' ) 
14/06/2022 09:58:55 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58735' , '18682' , 'CLERGY ROMANO ML  - C17' , '2' ,  '-2' , '1' ,
                               '49.0000' , '40.16393442623' , '22' , '0' , '98.00' ) 
14/06/2022 09:58:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '18682' AND id_supplier = '' 
14/06/2022 09:58:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18682' , '' , '1' ) 
14/06/2022 09:58:55 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58735' , '2177' , 'CLERGY BASIC - MM - B&P' , '1' ,  '-1' , '1' ,
                               '33.0000' , '27.049180327869' , '22' , '0' , '33.00' ) 
14/06/2022 09:58:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '2177' AND id_supplier = '' 
14/06/2022 09:58:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2177' , '' , '1' ) 
14/06/2022 09:58:55 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58735' , '16456' , 'CINGOLO  - CING03' , '2' ,  '-2' , '1' ,
                               '13.5000' , '11.065573770492' , '22' , '0' , '27.00' ) 
14/06/2022 09:58:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '16456' AND id_supplier = '' 
14/06/2022 09:58:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16456' , '' , '1' ) 
14/06/2022 09:58:55 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58735' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '2' ,  '-2' , '1' ,
                               '36.0000' , '29.508196721311' , '22' , '0' , '72.00' ) 
14/06/2022 09:58:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '19396' AND id_supplier = '' 
14/06/2022 09:58:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19396' , '' , '1' ) 
14/06/2022 09:58:55 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58735' , '1364' , 'BROCCA E PIATTINO - CM 23 PALLADIATI - 680' , '1' ,  '-1' , '1' ,
                               '190.0000' , '155.73770491803' , '22' , '0' , '190.00' ) 
14/06/2022 09:58:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '1364' AND id_supplier = '' 
14/06/2022 09:58:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1364' , '' , '1' ) 
14/06/2022 09:58:55 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58735' , '17528' , 'PREGHIERE EUCARISTICHE PER LA CONCELEBRAZIONE' , '20' ,  '-20' , '4' ,
                               '3.9000' , '3.9' , '0' , '5' , '74.10' ) 
14/06/2022 09:58:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '17528' AND id_supplier = '' 
14/06/2022 09:58:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17528' , '' , '1' ) 
14/06/2022 09:58:55 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58735' , '17988' , 'BACILE PALLADIO CM 24 - 688' , '1' ,  '-1' , '1' ,
                               '73.0000' , '59.83606557377' , '22' , '0' , '73.00' ) 
14/06/2022 09:58:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '17988' AND id_supplier = '' 
14/06/2022 09:58:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17988' , '' , '1' ) 
14/06/2022 09:59:09 am >> DELETE FROM ps_document WHERE id_document = '58735' 
14/06/2022 09:59:09 am >> DELETE FROM ps_document_detail WHERE id_document = '58735' 
14/06/2022 10:23:22 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '46/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-06-14') 
14/06/2022 10:23:22 am >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '24' ,
                          '46/A' ,
                          '2022-06-14' ,
                          'A' ,
                          '3575' ,
                          '0' ,
                          '4671084' ,
                          'PIAZZA MATTEOTTI 2 84121 SALERNO' ,
                          '' ,
                          'ACCONTO € 100,00' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '420.00' ,
                          '420.00' ,
                          NOW() ,
                          NOW() ) 
14/06/2022 10:23:22 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 = '58751' 
14/06/2022 10:23:22 am >>  DELETE FROM ps_document_detail WHERE id_document = '58751' 
14/06/2022 10:23:22 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58751' , '12899' , 'LODE A TE, SIGNORE' , '100' ,  '-100' , '4' ,
                               '4.20' , '4.2' , '0' , '0' , '420.00' ) 
14/06/2022 10:35:22 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '1909' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-14') 
14/06/2022 10:35:22 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' ,
                          '1909' ,
                          '2022-06-14' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '2.40' ,
                          '1.97' ,
                          NOW() ,
                          NOW() ) 
14/06/2022 10:35:22 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 = '58752' 
14/06/2022 10:35:22 am >>  DELETE FROM ps_document_detail WHERE id_document = '58752' 
14/06/2022 10:35:22 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58752' , '1319' , 'BRACCIALE DECINA TAU' , '2' ,  '-2' , '1' ,
                               '1.20' , '0.98360655737705' , '22' , '0' , '2.40' ) 
14/06/2022 10:35:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '1319' AND id_supplier = '' 
14/06/2022 10:35:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1319' , '' , '1' ) 
14/06/2022 11:08:29 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '1910' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-14') 
14/06/2022 11:08:29 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' ,
                          '1910' ,
                          '2022-06-14' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '13.50' ,
                          '13.50' ,
                          NOW() ,
                          NOW() ) 
14/06/2022 11:08:29 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 = '58753' 
14/06/2022 11:08:29 am >>  DELETE FROM ps_document_detail WHERE id_document = '58753' 
14/06/2022 11:08:29 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58753' , '18163' , 'GIOCO DELLE PAROLE DI DIO' , '1' ,  '-1' , '4' ,
                               '10.00' , '10' , '0' , '0' , '10.00' ) 
14/06/2022 11:08:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '18163' AND id_supplier = '' 
14/06/2022 11:08:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18163' , '' , '1' ) 
14/06/2022 11:08:29 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58753' , '9475' , 'SAN MARCO EV. - G.PESENTI' , '1' ,  '-1' , '4' ,
                               '3.50' , '3.5' , '0' , '0' , '3.50' ) 
14/06/2022 11:08:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '9475' AND id_supplier = '' 
14/06/2022 11:08:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9475' , '' , '1' ) 
14/06/2022 11:42:49 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '46/A' AND id_document != '58751' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-06-14') 
14/06/2022 11:42:49 am >> UPDATE ps_document SET
                          id_document_type = '24',
                          document_num = '46/A',
                          document_date = '2022-06-14',
                          document_letter = 'A',
                          id_customer = '3575',
                          id_supplier = '',
                          id_address = '4671084',
                          address1 = 'PIAZZA MATTEOTTI 2 84121 SALERNO',
                          address2 = '',
                          note = 'ACCONTO € 100,00',
                          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 = '420.00',
                          price_tax_excluded = '420.00',
                          date_upd = NOW()
                        WHERE id_document = '58751' 
14/06/2022 11:42: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 = '58751' 
14/06/2022 11:42:49 am >>  DELETE FROM ps_document_detail WHERE id_document = '58751' 
14/06/2022 11:42: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
                            ( '58751' , '12899' , 'LODE A TE, SIGNORE' , '100' ,  '-100' , '4' ,
                               '4.2000' , '4.2' , '0' , '0' , '420.00' ) 
14/06/2022 11:42:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '12899' AND id_supplier = '' 
14/06/2022 11:42:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12899' , '' , '1' ) 
14/06/2022 11:42: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
                            ( '58751' , '' , '3,70 a copia scontato' , '1' ,  '-1' , '0' ,
                               '0' , '0' , '' , '0' , '0' ) 
14/06/2022 11:42:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '' 
14/06/2022 11:42:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '' , '1' ) 
14/06/2022 11:53:27 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '1911' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-14') 
14/06/2022 11:53:27 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' ,
                          '1911' ,
                          '2022-06-14' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '110.40' ,
                          '91.12' ,
                          NOW() ,
                          NOW() ) 
14/06/2022 11:53:27 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 = '58754' 
14/06/2022 11:53:27 am >>  DELETE FROM ps_document_detail WHERE id_document = '58754' 
14/06/2022 11:53:27 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58754' , '19594' , 'POLO JERSEY COTONE 100%' , '1' ,  '-1' , '1' ,
                               '36.90' , '30.245901639344' , '22' , '0' , '36.90' ) 
14/06/2022 11:53:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '19594' AND id_supplier = '' 
14/06/2022 11:53:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19594' , '' , '1' ) 
14/06/2022 11:53:28 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58754' , '1220' , 'BICCHIERI FLAMBEAUX - PZ. 50' , '3' ,  '-3' , '1' ,
                               '15.00' , '12.295081967213' , '22' , '0' , '45.00' ) 
14/06/2022 11:53:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '1220' AND id_supplier = '' 
14/06/2022 11:53:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1220' , '' , '1' ) 
14/06/2022 11:53:28 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58754' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '5' ,  '-5' , '4' ,
                               '0.70' , '0.7' , '0' , '0' , '3.50' ) 
14/06/2022 11:53:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 
14/06/2022 11:53:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 
14/06/2022 11:53:28 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58754' , '7912' , 'PERGAMENE - 1A COMUNIONE MOD. C' , '14' ,  '-14' , '1' ,
                               '0.5' , '0.40983606557377' , '22' , '0' , '7.00' ) 
14/06/2022 11:53:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '7912' AND id_supplier = '' 
14/06/2022 11:53:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7912' , '' , '1' ) 
14/06/2022 11:53:28 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58754' , '7911' , 'PERGAMENE - 1A COMUNIONE MOD. B' , '36' ,  '-36' , '1' ,
                               '0.5' , '0.40983606557377' , '22' , '0' , '18.00' ) 
14/06/2022 11:53:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '7911' AND id_supplier = '' 
14/06/2022 11:53:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7911' , '' , '1' ) 
14/06/2022 11:56:55 am >> SELECT document_num FROM ps_document
                            WHERE document_num = '1912' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-14') 
14/06/2022 11:56:55 am >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '1912' ,
                          '2022-06-14' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '63.00' ,
                          '54.13' ,
                          NOW() ,
                          NOW() ) 
14/06/2022 11:56:55 am >>  INSERT INTO ps_document_detail_backup
        ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
        SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58755' 
14/06/2022 11:56:55 am >>  DELETE FROM ps_document_detail WHERE id_document = '58755' 
14/06/2022 11:56:55 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58755' , '17802' , 'CAMICE SVASATO - POL.' , '1' ,  '-1' , '1' ,
                               '49.21' , '40.33606557377' , '22' , '0' , '49.21' ) 
14/06/2022 11:56:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '17802' AND id_supplier = '' 
14/06/2022 11:56:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17802' , '' , '1' ) 
14/06/2022 11:56:55 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58755' , '9473' , 'SAN LUIGI GONZAGA - G. ARLEDLER' , '1' ,  '-1' , '4' ,
                               '4.00' , '4' , '0' , '5' , '3.80' ) 
14/06/2022 11:56:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '9473' AND id_supplier = '' 
14/06/2022 11:56:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9473' , '' , '1' ) 
14/06/2022 11:56:55 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58755' , '9450' , 'SAN GIOVANNI BATTISTA - G. PESENTI' , '1' ,  '-1' , '4' ,
                               '3.50' , '3.5' , '0' , '5' , '3.33' ) 
14/06/2022 11:56:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '9450' AND id_supplier = '' 
14/06/2022 11:56:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9450' , '' , '1' ) 
14/06/2022 11:56:55 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58755' , '9579' , 'SANTA MARGHERITA MARIA ALACOQUE - M.TARONI' , '1' ,  '-1' , '4' ,
                               '3.50' , '3.5' , '0' , '5' , '3.33' ) 
14/06/2022 11:56:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '9579' AND id_supplier = '' 
14/06/2022 11:56:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9579' , '' , '1' ) 
14/06/2022 11:56:55 am >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58755' , '9454' , 'SAN GIOVANNI DELLA CROCE - G.PESENTI' , '1' ,  '-1' , '4' ,
                               '3.50' , '3.5' , '0' , '5' , '3.33' ) 
14/06/2022 11:56:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '9454' AND id_supplier = '' 
14/06/2022 11:56:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9454' , '' , '1' ) 
14/06/2022 12:14:01 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1913' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-14') 
14/06/2022 12:14:01 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '1913' ,
                          '2022-06-14' ,
                          '' ,
                          '371' ,
                          '' ,
                          '4670910' ,
                          'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO' ,
                          '' ,
                          '' ,
                          '0.00' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '214.80' ,
                          '176.43' ,
                          NOW() ,
                          NOW() ) 
14/06/2022 12:14:01 pm >>  INSERT INTO ps_document_detail_backup
        ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
        SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58756' 
14/06/2022 12:14:01 pm >>  DELETE FROM ps_document_detail WHERE id_document = '58756' 
14/06/2022 12:14:01 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58756' , '7911' , 'PERGAMENE - 1A COMUNIONE MOD. B' , '50' ,  '-50' , '1' ,
                               '0.5000' , '0.4098' , '22' , '0' , '25.00' ) 
14/06/2022 12:14:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7911' AND id_supplier = '' 
14/06/2022 12:14:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7911' , '' , '1' ) 
14/06/2022 12:14:01 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58756' , '3074' , 'CROCE PRIMA COMUNIONE LEGNO CHIARO - 713/11' , '3' ,  '-3' , '1' ,
                               '1.0000' , '0.8197' , '22' , '0' , '3.00' ) 
14/06/2022 12:14:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3074' AND id_supplier = '' 
14/06/2022 12:14:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3074' , '' , '1' ) 
14/06/2022 12:14:01 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58756' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '30' ,  '-30' , '1' ,
                               '0.2000' , '0.1639' , '22' , '0' , '6.00' ) 
14/06/2022 12:14:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18617' AND id_supplier = '' 
14/06/2022 12:14:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18617' , '' , '1' ) 
14/06/2022 12:14:01 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58756' , '15085' , 'BRACCIALE DECINA COLORATA - BC506' , '36' ,  '-36' , '1' ,
                               '1.2000' , '0.9836' , '22' , '0' , '43.20' ) 
14/06/2022 12:14:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15085' AND id_supplier = '' 
14/06/2022 12:14:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15085' , '' , '1' ) 
14/06/2022 12:14:01 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58756' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '20' ,  '-20' , '1' ,
                               '0.5000' , '0.4098' , '22' , '0' , '10.00' ) 
14/06/2022 12:14:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7936' AND id_supplier = '' 
14/06/2022 12:14:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7936' , '' , '1' ) 
14/06/2022 12:14:01 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58756' , '12817' , 'LIBRO DEI MATRIMONI' , '1' ,  '-1' , '1' ,
                               '38.0000' , '31.1475' , '22' , '15' , '32.30' ) 
14/06/2022 12:14:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12817' AND id_supplier = '' 
14/06/2022 12:14:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12817' , '' , '1' ) 
14/06/2022 12:14:01 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58756' , '7939' , 'PERGAMENE - MATRIMONIO-C' , '50' ,  '-50' , '1' ,
                               '0.5000' , '0.4098' , '22' , '0' , '25.00' ) 
14/06/2022 12:14:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7939' AND id_supplier = '' 
14/06/2022 12:14:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7939' , '' , '1' ) 
14/06/2022 12:14:02 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58756' , '7929' , 'PERGAMENE - BATTESIMO MOD. C' , '50' ,  '-50' , '1' ,
                               '0.3000' , '0.2459' , '22' , '0' , '15.00' ) 
14/06/2022 12:14:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7929' AND id_supplier = '' 
14/06/2022 12:14:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7929' , '' , '1' ) 
14/06/2022 12:14:02 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58756' , '11376' , 'VIENI SPIRITO SANTO' , '10' ,  '-10' , '4' ,
                               '0.2000' , '0.2' , '0' , '0' , '2.00' ) 
14/06/2022 12:14:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11376' AND id_supplier = '' 
14/06/2022 12:14:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11376' , '' , '1' ) 
14/06/2022 12:14:02 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58756' , '3045' , 'CROCE METALLO BUON PASTORE CM 3,8 - G352' , '30' ,  '-30' , '1' ,
                               '0.7000' , '0.5738' , '22' , '0' , '21.00' ) 
14/06/2022 12:14:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3045' AND id_supplier = '' 
14/06/2022 12:14:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3045' , '' , '1' ) 
14/06/2022 12:14:02 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58756' , '12818' , 'LIBRO DELLE PRIME COMUNIONI' , '1' ,  '-1' , '1' ,
                               '38.0000' , '31.1475' , '22' , '15' , '32.30' ) 
14/06/2022 12:14:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12818' AND id_supplier = '' 
14/06/2022 12:14:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12818' , '' , '1' ) 
14/06/2022 12:15:08 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '35/A' AND id_document != '56634' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-06') 
14/06/2022 12:15:08 pm >> UPDATE ps_document SET
                          id_document_type = '24',
                          document_num = '35/A',
                          document_date = '2022-05-06',
                          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 = '78.00',
                          price_tax_excluded = '63.93',
                          date_upd = NOW()
                        WHERE id_document = '56634' 
14/06/2022 12:15: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 = '56634' 
14/06/2022 12:15:08 pm >>  DELETE FROM ps_document_detail WHERE id_document = '56634' 
14/06/2022 12:15: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
                            ( '56634' , '14920' , 'CASULA AVE MARIA - PCA032' , '1' ,  '-1' , '1' ,
                               '78.0000' , '63.934426229508' , '22' , '0' , '78.00' ) 
14/06/2022 12:15:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14920' AND id_supplier = '' 
14/06/2022 12:15:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14920' , '' , '1' ) 
14/06/2022 12:19:49 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1914' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-14') 
14/06/2022 12:19:49 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' ,
                          '1914' ,
                          '2022-06-14' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '40.85' ,
                          '40.85' ,
                          NOW() ,
                          NOW() ) 
14/06/2022 12:19:49 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 = '58757' 
14/06/2022 12:19:49 pm >>  DELETE FROM ps_document_detail WHERE id_document = '58757' 
14/06/2022 12:19:49 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58757' , '19355' , 'PANE E LA GRAZIA - G. BASSETTI' , '1' ,  '-1' , '4' ,
                               '13.00' , '13' , '0' , '5' , '12.35' ) 
14/06/2022 12:19:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19355' AND id_supplier = '' 
14/06/2022 12:19:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19355' , '' , '1' ) 
14/06/2022 12:19:49 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58757' , '19610' , 'CHIESA E LIBERTA - B. SESBOUE' , '1' ,  '-1' , '4' ,
                               '30.00' , '30' , '0' , '5' , '28.50' ) 
14/06/2022 12:19:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19610' AND id_supplier = '' 
14/06/2022 12:19:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19610' , '' , '1' ) 
14/06/2022 12:24:01 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1915' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-14') 
14/06/2022 12:24:01 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '1915' ,
                          '2022-06-14' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '10.50' ,
                          '8.61' ,
                          NOW() ,
                          NOW() ) 
14/06/2022 12:24:01 pm >>  INSERT INTO ps_document_detail_backup
        ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
        SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58758' 
14/06/2022 12:24:01 pm >>  DELETE FROM ps_document_detail WHERE id_document = '58758' 
14/06/2022 12:24:01 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58758' , '5000' , 'SANTISSIMO SACRAMENTO - 217' , '2' ,  '-2' , '1' ,
                               '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 
14/06/2022 12:24:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5000' AND id_supplier = '' 
14/06/2022 12:24:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5000' , '' , '1' ) 
14/06/2022 12:24:01 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58758' , '17617' , 'IMMAGINI ISONZO X 100' , '1' ,  '-1' , '1' ,
                               '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 
14/06/2022 12:24:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17617' AND id_supplier = '' 
14/06/2022 12:24:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17617' , '' , '1' ) 
14/06/2022 12:29:21 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1916' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-14') 
14/06/2022 12:29:21 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' ,
                          '1916' ,
                          '2022-06-14' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '396.00' ,
                          '324.59' ,
                          NOW() ,
                          NOW() ) 
14/06/2022 12:29:21 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 = '58759' 
14/06/2022 12:29:21 pm >>  DELETE FROM ps_document_detail WHERE id_document = '58759' 
14/06/2022 12:29:21 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58759' , '7202' , 'ARTICOLI RELIGIOSI' , '1' ,  '-1' , '1' ,
                               '396' , '324.59016393443' , '22' , '0' , '396.00' ) 
14/06/2022 12:29:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 
14/06/2022 12:29:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 
14/06/2022 12:33:13 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '35/A' AND id_document != '56634' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-06') 
14/06/2022 12:33:13 pm >> UPDATE ps_document SET
                          id_document_type = '24',
                          document_num = '35/A',
                          document_date = '2022-05-06',
                          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 = '78.00',
                          price_tax_excluded = '63.93',
                          date_upd = NOW()
                        WHERE id_document = '56634' 
14/06/2022 12:33: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 = '56634' 
14/06/2022 12:33:13 pm >>  DELETE FROM ps_document_detail WHERE id_document = '56634' 
14/06/2022 12:33: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
                            ( '56634' , '14920' , 'CASULA AVE MARIA - PCA032' , '1' ,  '-1' , '1' ,
                               '78.0000' , '63.934426229508' , '22' , '0' , '78.00' ) 
14/06/2022 12:33:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14920' AND id_supplier = '' 
14/06/2022 12:33:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14920' , '' , '1' ) 
14/06/2022 12:33: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
                            ( '56634' , '' , '€ 40,85 libri già scontrinati' , '1' ,  '-1' , '0' ,
                               '0' , '0' , '' , '0' , '0' ) 
14/06/2022 12:33:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '' 
14/06/2022 12:33:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '' , '1' ) 
14/06/2022 12:41:46 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1913' AND id_document != '58756' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-14') 
14/06/2022 12:41:47 pm >> UPDATE ps_document SET
                          id_document_type = '11',
                          document_num = '1913',
                          document_date = '2022-06-14',
                          document_letter = '',
                          id_customer = '',
                          id_supplier = '',
                          id_address = '',
                          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 = '214.80',
                          price_tax_excluded = '176.43',
                          date_upd = NOW()
                        WHERE id_document = '58756' 
14/06/2022 12:41:47 pm >>  INSERT INTO ps_document_detail_backup
        ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
        SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58756' 
14/06/2022 12:41:47 pm >>  DELETE FROM ps_document_detail WHERE id_document = '58756' 
14/06/2022 12:41:47 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58756' , '7911' , 'PERGAMENE - 1A COMUNIONE MOD. B' , '50' ,  '-50' , '1' ,
                               '0.5000' , '0.40983606557377' , '22' , '0' , '25.00' ) 
14/06/2022 12:41:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7911' AND id_supplier = '' 
14/06/2022 12:41:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7911' , '' , '1' ) 
14/06/2022 12:41:47 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58756' , '3074' , 'CROCE PRIMA COMUNIONE LEGNO CHIARO - 713/11' , '3' ,  '-3' , '1' ,
                               '1.0000' , '0.81967213114754' , '22' , '0' , '3.00' ) 
14/06/2022 12:41:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3074' AND id_supplier = '' 
14/06/2022 12:41:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3074' , '' , '1' ) 
14/06/2022 12:41:47 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58756' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '30' ,  '-30' , '1' ,
                               '0.2000' , '0.16393442622951' , '22' , '0' , '6.00' ) 
14/06/2022 12:41:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18617' AND id_supplier = '' 
14/06/2022 12:41:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18617' , '' , '1' ) 
14/06/2022 12:41:47 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58756' , '15085' , 'BRACCIALE DECINA COLORATA - BC506' , '36' ,  '-36' , '1' ,
                               '1.2000' , '0.98360655737705' , '22' , '0' , '43.20' ) 
14/06/2022 12:41:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15085' AND id_supplier = '' 
14/06/2022 12:41:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15085' , '' , '1' ) 
14/06/2022 12:41:47 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58756' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '20' ,  '-20' , '1' ,
                               '0.5000' , '0.40983606557377' , '22' , '0' , '10.00' ) 
14/06/2022 12:41:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7936' AND id_supplier = '' 
14/06/2022 12:41:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7936' , '' , '1' ) 
14/06/2022 12:41:47 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58756' , '12817' , 'LIBRO DEI MATRIMONI' , '1' ,  '-1' , '1' ,
                               '38.0000' , '31.147540983607' , '22' , '15' , '32.30' ) 
14/06/2022 12:41:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12817' AND id_supplier = '' 
14/06/2022 12:41:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12817' , '' , '1' ) 
14/06/2022 12:41:47 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58756' , '7939' , 'PERGAMENE - MATRIMONIO-C' , '50' ,  '-50' , '1' ,
                               '0.5000' , '0.40983606557377' , '22' , '0' , '25.00' ) 
14/06/2022 12:41:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7939' AND id_supplier = '' 
14/06/2022 12:41:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7939' , '' , '1' ) 
14/06/2022 12:41:47 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58756' , '7929' , 'PERGAMENE - BATTESIMO MOD. C' , '50' ,  '-50' , '1' ,
                               '0.3000' , '0.24590163934426' , '22' , '0' , '15.00' ) 
14/06/2022 12:41:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7929' AND id_supplier = '' 
14/06/2022 12:41:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7929' , '' , '1' ) 
14/06/2022 12:41: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
                            ( '58756' , '11376' , 'VIENI SPIRITO SANTO' , '10' ,  '-10' , '4' ,
                               '0.2000' , '0.2' , '0' , '0' , '2.00' ) 
14/06/2022 12:41:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11376' AND id_supplier = '' 
14/06/2022 12:41:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11376' , '' , '1' ) 
14/06/2022 12:41: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
                            ( '58756' , '3045' , 'CROCE METALLO BUON PASTORE CM 3,8 - G352' , '30' ,  '-30' , '1' ,
                               '0.7000' , '0.57377049180328' , '22' , '0' , '21.00' ) 
14/06/2022 12:41:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3045' AND id_supplier = '' 
14/06/2022 12:41:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3045' , '' , '1' ) 
14/06/2022 12:41: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
                            ( '58756' , '12818' , 'LIBRO DELLE PRIME COMUNIONI' , '1' ,  '-1' , '1' ,
                               '38.0000' , '31.147540983607' , '22' , '15' , '32.30' ) 
14/06/2022 12:41:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12818' AND id_supplier = '' 
14/06/2022 12:41:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12818' , '' , '1' ) 
14/06/2022 12:57:31 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1909' AND id_document != '58752' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-14') 
14/06/2022 12:57:31 pm >> UPDATE ps_document SET
                          id_document_type = '11',
                          document_num = '1909',
                          document_date = '2022-06-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 = '2.40',
                          price_tax_excluded = '1.97',
                          date_upd = NOW()
                        WHERE id_document = '58752' 
14/06/2022 12:57:31 pm >>  INSERT INTO ps_document_detail_backup
        ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
        SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58752' 
14/06/2022 12:57:31 pm >>  DELETE FROM ps_document_detail WHERE id_document = '58752' 
14/06/2022 12:57:31 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58752' , '1312' , 'BRACCIALE DECINA' , '2' ,  '-2' , '1' ,
                               '1.2' , '0.98360655737705' , '22' , '0' , '2.40' ) 
14/06/2022 12:57:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1312' AND id_supplier = '' 
14/06/2022 12:57:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1312' , '' , '1' ) 
14/06/2022 05:08:36 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1917' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-14') 
14/06/2022 05:08:36 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' ,
                          '1917' ,
                          '2022-06-14' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '26.00' ,
                          '21.31' ,
                          NOW() ,
                          NOW() ) 
14/06/2022 05:08:36 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 = '58760' 
14/06/2022 05:08:36 pm >>  DELETE FROM ps_document_detail WHERE id_document = '58760' 
14/06/2022 05:08:36 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58760' , '7202' , 'ARTICOLI RELIGIOSI' , '10' ,  '-10' , '1' ,
                               '2.6' , '2.1311475409836' , '22' , '0' , '26.00' ) 
14/06/2022 05:08:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 
14/06/2022 05:08:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 
14/06/2022 06:27:46 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1918' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-14') 
14/06/2022 06:27:46 pm >> INSERT INTO ps_document (
                                id_document_type ,
                                document_num ,
                                document_date ,
                                document_letter ,
                                id_customer ,
                                id_supplier ,
                                id_address ,
                                address1 ,
                                address2 ,
                                note ,
                                price_shipping ,
                                id_tax_shipping_rules ,
                                colli ,
                                peso ,
                                porto_e_imballo ,
                                mezzo_consegna ,
                                id_payment ,
                                id_causal ,
                                price_tax_included ,
                                price_tax_excluded ,
                                date_add ,
                                date_upd
                )  VALUES  (
                          '11' ,
                          '1918' ,
                          '2022-06-14' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '18.75' ,
                          '16.35' ,
                          NOW() ,
                          NOW() ) 
14/06/2022 06:27:46 pm >>  INSERT INTO ps_document_detail_backup
        ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total )
        SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58761' 
14/06/2022 06:27:46 pm >>  DELETE FROM ps_document_detail WHERE id_document = '58761' 
14/06/2022 06:27:46 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58761' , '1914' , 'CERA DELLA LITURGIA' , '2' ,  '-2' , '1' ,
                               '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 
14/06/2022 06:27:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 
14/06/2022 06:27:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 
14/06/2022 06:27:46 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58761' , '12685' , 'SACRO CUORE - 209' , '1' ,  '-1' , '1' ,
                               '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 
14/06/2022 06:27:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12685' AND id_supplier = '' 
14/06/2022 06:27:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12685' , '' , '1' ) 
14/06/2022 06:27:47 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58761' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' ,  '-1' , '4' ,
                               '0.70' , '0.7' , '0' , '0' , '0.70' ) 
14/06/2022 06:27:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 
14/06/2022 06:27:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 
14/06/2022 06:27:47 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58761' , '19375' , 'MESSALINO QUOTIDIANO - MAG/GIU/LUG 2022' , '1' ,  '-1' , '4' ,
                               '5.00' , '5' , '0' , '5' , '4.75' ) 
14/06/2022 06:27:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19375' AND id_supplier = '' 
14/06/2022 06:27:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19375' , '' , '1' ) 
14/06/2022 06:32:04 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1919' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-14') 
14/06/2022 06:32:04 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' ,
                          '1919' ,
                          '2022-06-14' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '13.00' ,
                          '13.00' ,
                          NOW() ,
                          NOW() ) 
14/06/2022 06:32: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 = '58762' 
14/06/2022 06:32:04 pm >>  DELETE FROM ps_document_detail WHERE id_document = '58762' 
14/06/2022 06:32: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
                            ( '58762' , '9654' , 'SANTO STEFANO PROTOMARTIRE - G. PESENTI' , '1' ,  '-1' , '4' ,
                               '3.50' , '3.5' , '0' , '0' , '3.50' ) 
14/06/2022 06:32:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9654' AND id_supplier = '' 
14/06/2022 06:32:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9654' , '' , '1' ) 
14/06/2022 06:32: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
                            ( '58762' , '17582' , 'SAN CESARE DE BUS' , '2' ,  '-2' , '4' ,
                               '5.00' , '5' , '0' , '5' , '9.50' ) 
14/06/2022 06:32:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17582' AND id_supplier = '' 
14/06/2022 06:32:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17582' , '' , '1' ) 
14/06/2022 06:40:27 pm >> SELECT document_num FROM ps_document
                            WHERE document_num = '1920' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-14') 
14/06/2022 06:40:27 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' ,
                          '1920' ,
                          '2022-06-14' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '' ,
                          '0' ,
                          '4' ,
                          '0' ,
                          '0' ,
                          '0' ,
                          '' ,
                          '0' ,
                          '0' ,
                          '16.00' ,
                          '16.00' ,
                          NOW() ,
                          NOW() ) 
14/06/2022 06:40:27 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 = '58763' 
14/06/2022 06:40:27 pm >>  DELETE FROM ps_document_detail WHERE id_document = '58763' 
14/06/2022 06:40:27 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58763' , '19057' , 'CARLO ACUTIS - 15 ANNI DI AMORE E FEDE' , '1' ,  '-1' , '4' ,
                               '6.00' , '6' , '0' , '0' , '6.00' ) 
14/06/2022 06:40:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19057' AND id_supplier = '' 
14/06/2022 06:40:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19057' , '' , '1' ) 
14/06/2022 06:40:27 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58763' , '19584' , 'UN MESE CON IL SACRO CUORE - 8065' , '1' ,  '-1' , '4' ,
                               '5.00' , '5' , '0' , '0' , '5.00' ) 
14/06/2022 06:40:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19584' AND id_supplier = '' 
14/06/2022 06:40:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19584' , '' , '1' ) 
14/06/2022 06:40:27 pm >> INSERT INTO ps_document_detail
                            ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group ,
                                 price_tax_included , price_tax_excluded , tax , discount , price_total )
                      VALUES
                            ( '58763' , '11151' , 'LIBRI' , '1' ,  '-1' , '4' ,
                               '5' , '5' , '0' , '0' , '5.00' ) 
14/06/2022 06:40:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 
14/06/2022 06:40:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 
14/06/2022 07:12:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899571313' AND id_product != '117' AND ean13 != '' 
14/06/2022 07:12:05 pm >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '',
                  ean13 = '9788899571313',
                  date_upd = NOW()
                WHERE id_product = '117' 
14/06/2022 07:12:05 pm >> UPDATE ps_product_lang SET
                  name = 'La preghiera delle cinque dita n.e.',
                  description = '<p class=\"MsoNormal\" style=\"margin-top:7.55pt;margin-right:37.7pt;margin-bottom:\r\n0cm;margin-left:.5pt;margin-bottom:.0001pt;text-align:justify;text-justify:\r\ninter-ideograph;text-indent:.2pt;line-height:9.95pt;mso-line-height-rule:exactly\"><span style=\"font-weight: normal;\"><font face=\"Verdana\"><span style=\"font-size: 7pt;\">Un piccolo testo sulla preghiera \"delle cinque </span><span style=\"font-size: 7pt;\">dita\"di Papa Francesco, per avvicinare i più&nbsp;</span><span style=\"font-size: 7pt;\">piccoli alla\r\npreghiera.</span></font></span></p><p class=\"MsoNormal\" style=\"margin-top:7.55pt;margin-right:37.7pt;margin-bottom:\r\n0cm;margin-left:.5pt;margin-bottom:.0001pt;text-align:justify;text-justify:\r\ninter-ideograph;text-indent:.2pt;line-height:9.95pt;mso-line-height-rule:exactly\"><span style=\"font-weight: normal;\"><font face=\"Verdana\"><span style=\"font-size: 7pt;\">Pregare, secondo le</span>&nbsp;<span style=\"text-indent: 0.2pt; font-size: 7pt;\">intenzioni che ci suggerisce Papa Francesco,\r\nti </span><span style=\"text-indent: 0.2pt; font-size: 7pt;\">aiuterà a comprendere meglio l\'importanza </span><span style=\"text-indent: 0.2pt;\"><span style=\"font-size: 7pt;\">degli altri nella\r\ntua vita, </span></span><span style=\"text-indent: 0.2pt; font-size: 7pt;\">ad aiutare gli altri </span><span style=\"text-indent: 0.2pt; font-size: 7pt;\">attraverso la preghiera.</span></font></span></p><p class=\"MsoNormal\" style=\"margin-top:.1pt;margin-right:34.55pt;margin-bottom:\r\n0cm;margin-left:.5pt;margin-bottom:.0001pt;text-indent:.2pt;line-height:10.0pt;\r\nmso-line-height-rule:exactly\"><o:p></o:p></p>'
                WHERE id_product = '117' 
14/06/2022 07:12:05 pm >> UPDATE ps_product SET
                  wholesale_price = '0.32',
                  on_sale = '0',
                  price = '1.50'
                WHERE id_product = '117' 
14/06/2022 07:12:05 pm >> UPDATE ps_product_shop SET
                  wholesale_price = '0.32',
                  price = '1.50',
                  id_tax_rules_group = '4',
                  id_category_default = '2',
                  id_argoment_default = '',
                  id_internal_category = '',
                  on_sale = '0',
                  on_showcase = '1',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '117' 
14/06/2022 07:12:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '117' 
14/06/2022 07:12:05 pm >> INSERT INTO ps_specific_price
                    ( 	id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`)
                  VALUES
                    ( '0' , '0' , '117' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )
14/06/2022 07:29:11 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899571030' AND id_product != '131' AND ean13 != '' 
14/06/2022 07:29:11 pm >> UPDATE ps_product SET
                  id_supplier = '',
                  reference = '',
                  ean13 = '9788899571030',
                  date_upd = NOW()
                WHERE id_product = '131' 
14/06/2022 07:29:11 pm >> UPDATE ps_product_lang SET
                  name = 'LIBRO AGENDA CATTOLICO 2022',
                  description = '<p>Questa agenda risponde alle esigenze ecumeniche della società di oggi.</p><p>Nell’agenda potete trovare:</p><p>• le pagine riservate ai dati personali;</p><p>• i calendari del 2021 e 2022;</p><p>• il calendario annuale per appuntamenti;</p><p>• le solennità e le feste del rito romano e ambrosiano;</p><p>• la tabella delle principali celebrazioni dell’anno liturgico;</p><p>• le abbreviazioni dei libri biblici.</p><p>In più tante altre notizie per l\'anno liturgico.</p>'
                WHERE id_product = '131' 
14/06/2022 07:29:11 pm >> UPDATE ps_product SET
                  wholesale_price = '3.80',
                  on_sale = '0',
                  price = '16'
                WHERE id_product = '131' 
14/06/2022 07:29:11 pm >> UPDATE ps_product_shop SET
                  wholesale_price = '3.80',
                  price = '16',
                  id_tax_rules_group = '4',
                  id_category_default = '2',
                  id_argoment_default = '',
                  id_internal_category = '448',
                  on_sale = '0',
                  on_showcase = '1',
                  on_offer = '00',
                  on_most = '00',
                  date_upd = NOW()
                WHERE id_product = '131' 
14/06/2022 07:29:11 pm >> DELETE FROM ps_specific_price WHERE id_product = '131' 
14/06/2022 07:29:11 pm >> INSERT INTO ps_specific_price
                    ( 	id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`)
                  VALUES
                    ( '0' , '0' , '131' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' )