09/03/2023 08:29:57 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 09/03/2023 08:29:57 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20800' , '1' , '' , 'nuovo-prodotto' ) 09/03/2023 08:29:57 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20800' , '1' , '1' , '2' , NOW() , NOW() ) 09/03/2023 08:29:57 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20800' , '0' , '1' , '0' , '0' ) 09/03/2023 08:30:48 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839929259' AND id_product != '20800' AND ean13 != '' 09/03/2023 08:30:48 am >> UPDATE ps_product SET id_supplier = '', reference = '11/4', ean13 = '9788839929259', date_upd = NOW() WHERE id_product = '20800' 09/03/2023 08:30:48 am >> UPDATE ps_product_lang SET name = 'AI PIEDI DELLA CROCE - A. LEVINE', description = '' WHERE id_product = '20800' 09/03/2023 08:30:48 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '24' WHERE id_product = '20800' 09/03/2023 08:30:48 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '24', 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 = '20800' 09/03/2023 08:30:48 am >> DELETE FROM ps_specific_price WHERE id_product = '20800' 09/03/2023 08:30:49 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 = '20800' 09/03/2023 08:30:49 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20801' , '1' , '' , 'nuovo-prodotto' ) 09/03/2023 08:30:49 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 '20801' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20800' 09/03/2023 08:30:49 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20801' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20800' 09/03/2023 08:32:10 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831554664' AND id_product != '20801' AND ean13 != '' 09/03/2023 08:32:10 am >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 2', ean13 = '9788831554664', date_upd = NOW() WHERE id_product = '20801' 09/03/2023 08:32:10 am >> UPDATE ps_product_lang SET name = 'PREGHIERA RESPIRO DELL\'ANIMA - PAPA FRANCESCO', description = '' WHERE id_product = '20801' 09/03/2023 08:32:10 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20' WHERE id_product = '20801' 09/03/2023 08:32:10 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20801' 09/03/2023 08:32:10 am >> DELETE FROM ps_specific_price WHERE id_product = '20801' 09/03/2023 08:32: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 = '20801' 09/03/2023 08:32:11 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20802' , '1' , '' , 'nuovo-prodotto' ) 09/03/2023 08:32: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 '20802' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20801' 09/03/2023 08:32:11 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20802' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20801' 09/03/2023 08:33:19 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892240872' AND id_product != '20802' AND ean13 != '' 09/03/2023 08:33:19 am >> UPDATE ps_product SET id_supplier = '', reference = '11/7', ean13 = '9788892240872', date_upd = NOW() WHERE id_product = '20802' 09/03/2023 08:33:19 am >> UPDATE ps_product_lang SET name = 'FUOCO DELLA PAROLA - AAVV', description = '' WHERE id_product = '20802' 09/03/2023 08:33:19 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '36' WHERE id_product = '20802' 09/03/2023 08:33:19 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '36', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '16', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20802' 09/03/2023 08:33:19 am >> DELETE FROM ps_specific_price WHERE id_product = '20802' 09/03/2023 08:33:21 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 = '20802' 09/03/2023 08:33:21 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20803' , '1' , '' , 'nuovo-prodotto' ) 09/03/2023 08:33:21 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 '20803' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20802' 09/03/2023 08:33:21 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20803' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20802' 09/03/2023 08:33:43 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892240872' AND id_product != '20802' AND ean13 != '' 09/03/2023 08:33:44 am >> UPDATE ps_product SET id_supplier = '', reference = '11/7', ean13 = '9788892240872', date_upd = NOW() WHERE id_product = '20802' 09/03/2023 08:33:44 am >> UPDATE ps_product_lang SET name = 'FUOCO DELLA PAROLA - AAVV', description = '' WHERE id_product = '20802' 09/03/2023 08:33:44 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '38' WHERE id_product = '20802' 09/03/2023 08:33:44 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '38', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '16', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20802' 09/03/2023 08:33:44 am >> DELETE FROM ps_specific_price WHERE id_product = '20802' 09/03/2023 08:36:19 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868945633' AND id_product != '20803' AND ean13 != '' 09/03/2023 08:36:19 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788868945633', date_upd = NOW() WHERE id_product = '20803' 09/03/2023 08:36:19 am >> UPDATE ps_product_lang SET name = 'ALLA SCUOLA DELLA PAROLA - 2022-2023', description = '' WHERE id_product = '20803' 09/03/2023 08:36:19 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.8' WHERE id_product = '20803' 09/03/2023 08:36:20 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.8', id_tax_rules_group = '4', id_category_default = '103', id_argoment_default = '107', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20803' 09/03/2023 08:36:20 am >> DELETE FROM ps_specific_price WHERE id_product = '20803' 09/03/2023 08:36:20 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 = '20803' 09/03/2023 08:36:20 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20804' , '1' , '' , 'nuovo-prodotto' ) 09/03/2023 08:36:20 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 '20804' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20803' 09/03/2023 08:36:20 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20804' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20803' 09/03/2023 08:37:27 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259752444' AND id_product != '20804' AND ean13 != '' 09/03/2023 08:37:27 am >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 2', ean13 = '9791259752444', date_upd = NOW() WHERE id_product = '20804' 09/03/2023 08:37:27 am >> UPDATE ps_product_lang SET name = 'AFFIDABILI STORIE DI DONNE - L. M. EPICOCO', description = '' WHERE id_product = '20804' 09/03/2023 08:37:27 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '20804' 09/03/2023 08:37:27 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '267', 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 = '20804' 09/03/2023 08:37:27 am >> DELETE FROM ps_specific_price WHERE id_product = '20804' 09/03/2023 08:37: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 = '20804' 09/03/2023 08:37:28 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20805' , '1' , '' , 'nuovo-prodotto' ) 09/03/2023 08:37: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 '20805' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20804' 09/03/2023 08:37:28 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20805' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20804' 09/03/2023 08:38:26 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788885589964' AND id_product != '20805' AND ean13 != '' 09/03/2023 08:38:26 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788885589964', date_upd = NOW() WHERE id_product = '20805' 09/03/2023 08:38:26 am >> UPDATE ps_product_lang SET name = 'PANE QUOTIDIANO MAG GIU 2023', description = '' WHERE id_product = '20805' 09/03/2023 08:38:26 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.9' WHERE id_product = '20805' 09/03/2023 08:38:26 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.9', id_tax_rules_group = '4', id_category_default = '343', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20805' 09/03/2023 08:38:26 am >> DELETE FROM ps_specific_price WHERE id_product = '20805' 09/03/2023 08:38:27 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 = '20805' 09/03/2023 08:38:27 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20806' , '1' , '' , 'nuovo-prodotto' ) 09/03/2023 08:38:27 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 '20806' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20805' 09/03/2023 08:38:27 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20806' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20805' 09/03/2023 08:39:24 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' , '625015' , '2023-03-07' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '9.14' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '326.36' , '325.88' , NOW() , NOW() ) 09/03/2023 08:39: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 = '82209' 09/03/2023 08:39:24 am >> DELETE FROM ps_document_detail WHERE id_document = '82209' 09/03/2023 08:39: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 ( '82209' , '20800' , 'AI PIEDI DELLA CROCE - A. LEVINE' , '1' , '1' , '4' , '24.00' , '24' , '0' , '30' , '16.8000' ) 09/03/2023 08:39:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '20800' AND id_supplier = '7' 09/03/2023 08:39:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20800' , '7' , '1' ) 09/03/2023 08:39: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 ( '82209' , '20801' , 'PREGHIERA RESPIRO DELLANIMA - PAPA FRANCESCO' , '1' , '1' , '4' , '20.00' , '20' , '0' , '33' , '13.4000' ) 09/03/2023 08:39:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '20801' AND id_supplier = '7' 09/03/2023 08:39:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20801' , '7' , '1' ) 09/03/2023 08:39: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 ( '82209' , '20802' , 'FUOCO DELLA PAROLA - AAVV' , '1' , '1' , '4' , '38.00' , '38' , '0' , '33' , '25.4600' ) 09/03/2023 08:39:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '20802' AND id_supplier = '7' 09/03/2023 08:39:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20802' , '7' , '1' ) 09/03/2023 08:39: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 ( '82209' , '20763' , 'ABBIAMO VISTO IL SIGNORE - SPARTITO' , '1' , '1' , '3' , '17.3' , '16.634615384615' , '4' , '30' , '12.5944' ) 09/03/2023 08:39:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '20763' AND id_supplier = '7' 09/03/2023 08:39:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20763' , '7' , '1' ) 09/03/2023 08:39: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 ( '82209' , '8416' , 'PREPARARE E CELEBRARE - TRIDUO PASQUALE' , '2' , '2' , '4' , '20.00' , '20' , '0' , '30' , '28.0000' ) 09/03/2023 08:39:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '8416' AND id_supplier = '7' 09/03/2023 08:39:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8416' , '7' , '1' ) 09/03/2023 08:39: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 ( '82209' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '12' , '12' , '4' , '2.00' , '2' , '0' , '33' , '16.0800' ) 09/03/2023 08:39:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '19157' AND id_supplier = '7' 09/03/2023 08:39:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19157' , '7' , '1' ) 09/03/2023 08:39: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 ( '82209' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '1' , '1' , '4' , '2.00' , '2' , '0' , '100' , '0.0000' ) 09/03/2023 08:39:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '19157' AND id_supplier = '7' 09/03/2023 08:39:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19157' , '7' , '1' ) 09/03/2023 08:39: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 ( '82209' , '20803' , 'ALLA SCUOLA DELLA PAROLA - 2022-2023' , '1' , '1' , '4' , '0.80' , '0.8' , '0' , '30' , '0.5600' ) 09/03/2023 08:39:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '20803' AND id_supplier = '7' 09/03/2023 08:39:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20803' , '7' , '1' ) 09/03/2023 08:39: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 ( '82209' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. M. EPICOCO' , '24' , '24' , '4' , '12.00' , '12' , '0' , '30' , '201.6000' ) 09/03/2023 08:39:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '20804' AND id_supplier = '7' 09/03/2023 08:39:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20804' , '7' , '1' ) 09/03/2023 08:39: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 ( '82209' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. M. EPICOCO' , '2' , '2' , '4' , '12.00' , '12' , '0' , '100' , '0.0000' ) 09/03/2023 08:39:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '20804' AND id_supplier = '7' 09/03/2023 08:39:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20804' , '7' , '1' ) 09/03/2023 08:39: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 ( '82209' , '20805' , 'PANE QUOTIDIANO MAG GIU 2023' , '1' , '1' , '4' , '3.90' , '3.9' , '0' , '30' , '2.7300' ) 09/03/2023 08:39:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '20805' AND id_supplier = '7' 09/03/2023 08:39:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20805' , '7' , '1' ) 09/03/2023 08:40:23 am >> SELECT document_num FROM ps_document WHERE document_num = '760' AND id_document != '82194' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-08') 09/03/2023 08:40:23 am >> UPDATE ps_document SET id_document_type = '11', document_num = '760', document_date = '2023-03-08', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '4.50', price_tax_excluded = '3.98', date_upd = NOW() WHERE id_document = '82194' 09/03/2023 08:40:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82194' 09/03/2023 08:40:23 am >> DELETE FROM ps_document_detail WHERE id_document = '82194' 09/03/2023 08:40:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82194' , '17747' , 'SEGNALIBRO - PR SP 100' , '4' , '-4' , '1' , '0.3500' , '0.28688524590164' , '22' , '0' , '1.40' ) 09/03/2023 08:40:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82194' , '17748' , 'SEGNALIBRO - PR 349' , '1' , '-1' , '1' , '0.3500' , '0.28688524590164' , '22' , '0' , '0.35' ) 09/03/2023 08:40:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82194' , '20758' , 'SEGNALIBRO 5X15' , '5' , '-5' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '1.00' ) 09/03/2023 08:40:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82194' , '5462' , 'IO SONO IL SIGNORE DIO TUO - 20' , '1' , '-1' , '1' , '0.1500' , '0.12295081967213' , '22' , '0' , '0.15' ) 09/03/2023 08:40:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82194' , '20803' , 'ALLA SCUOLA DELLA PAROLA - 2022-2023' , '1' , '-1' , '4' , '0.9' , '0.9' , '0' , '0' , '0.90' ) 09/03/2023 08:40:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82194' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.7000' , '0.7' , '0' , '0' , '0.70' ) 09/03/2023 09:13:51 am >> SELECT document_num FROM ps_document WHERE document_num = '772' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-09') 09/03/2023 09:13:51 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' , '772' , '2023-03-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.92' , NOW() , NOW() ) 09/03/2023 09:13:51 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 = '82210' 09/03/2023 09:13:51 am >> DELETE FROM ps_document_detail WHERE id_document = '82210' 09/03/2023 09:13: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 ( '82210' , '16190' , 'VESTINA BATTESIMALE CANDELA/FONTE' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 09/03/2023 09:13: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 ( '82210' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 09/03/2023 09:18:17 am >> SELECT document_num FROM ps_document WHERE document_num = '773' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-09') 09/03/2023 09:18:17 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '773' , '2023-03-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '5.00' , NOW() , NOW() ) 09/03/2023 09:18:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82211' 09/03/2023 09:18:17 am >> DELETE FROM ps_document_detail WHERE id_document = '82211' 09/03/2023 09:18:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82211' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 09/03/2023 09:18:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82211' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 09/03/2023 09:18:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82211' , '12441' , 'FINO ALLA FINE - VIA CRUCIS' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 09/03/2023 10:25:11 am >> SELECT document_num FROM ps_document WHERE document_num = '774' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-09') 09/03/2023 10:25:11 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '774' , '2023-03-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '92.37' , '92.37' , NOW() , NOW() ) 09/03/2023 10:25:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82212' 09/03/2023 10:25:11 am >> DELETE FROM ps_document_detail WHERE id_document = '82212' 09/03/2023 10:25:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82212' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.5' , '2.5' , '0' , '0' , '2.50' ) 09/03/2023 10:25:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82212' , '16677' , 'INDAGINI SU GESU - P. CURTAZ' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 09/03/2023 10:25:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82212' , '17734' , 'VANGELO E ATTI BAMBINI' , '17' , '-17' , '4' , '3.00' , '3' , '0' , '5' , '48.45' ) 09/03/2023 10:25:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82212' , '12253' , 'MIO LIBRO DI PREGHIERE' , '12' , '-12' , '4' , '2.80' , '2.8' , '0' , '5' , '31.92' ) 09/03/2023 10:26:39 am >> SELECT document_num FROM ps_document WHERE document_num = '775' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-09') 09/03/2023 10:26:39 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '775' , '2023-03-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '2.00' , NOW() , NOW() ) 09/03/2023 10:26:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82213' 09/03/2023 10:26:39 am >> DELETE FROM ps_document_detail WHERE id_document = '82213' 09/03/2023 10:26:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82213' , '16094' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 09/03/2023 10:34:16 am >> SELECT document_num FROM ps_document WHERE document_num = '776' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-09') 09/03/2023 10:34:16 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '776' , '2023-03-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.50' , '22.50' , NOW() , NOW() ) 09/03/2023 10:34:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82214' 09/03/2023 10:34:16 am >> DELETE FROM ps_document_detail WHERE id_document = '82214' 09/03/2023 10:34:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82214' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '15' , '-15' , '4' , '1.5' , '1.5' , '0' , '0' , '22.50' ) 09/03/2023 11:10:06 am >> SELECT document_num FROM ps_document WHERE document_num = '777' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-09') 09/03/2023 11:10:06 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '777' , '2023-03-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '148.70' , '123.98' , NOW() , NOW() ) 09/03/2023 11:10:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82215' 09/03/2023 11:10:06 am >> DELETE FROM ps_document_detail WHERE id_document = '82215' 09/03/2023 11:10:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82215' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '135' , '110.65573770492' , '22' , '0' , '135.00' ) 09/03/2023 11:10:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82215' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '3' , '-3' , '3' , '3.30' , '3.1730769230769' , '4' , '0' , '9.90' ) 09/03/2023 11:10:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82215' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '1.9' , '1.9' , '0' , '0' , '3.80' ) 09/03/2023 11:29:24 am >> SELECT document_num FROM ps_document WHERE document_num = '778' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-09') 09/03/2023 11:29:24 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' , '778' , '2023-03-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.48' , '14.48' , NOW() , NOW() ) 09/03/2023 11:29: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 = '82216' 09/03/2023 11:29:24 am >> DELETE FROM ps_document_detail WHERE id_document = '82216' 09/03/2023 11:29: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 ( '82216' , '20769' , 'SULLA STRADA DELLAMORE - V. ROSSI' , '8' , '-8' , '4' , '1.90' , '1.9' , '0' , '5' , '14.48' ) 09/03/2023 11:40:45 am >> SELECT document_num FROM ps_document WHERE document_num = '779' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-09') 09/03/2023 11:40:45 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '779' , '2023-03-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '4.10' , NOW() , NOW() ) 09/03/2023 11:40:45 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82217' 09/03/2023 11:40:45 am >> DELETE FROM ps_document_detail WHERE id_document = '82217' 09/03/2023 11:40:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82217' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 09/03/2023 11:40:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82217' , '1310' , 'BRACCIALE CORDA SAN BENEDETTO' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 09/03/2023 12:25:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '44' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-03-09') 09/03/2023 12:25:07 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '44' , '2023-03-09' , '' , '1246' , '0' , '4675590' , 'L.GO MARGHERITA DI SAVOIA 85021 AVIGLIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '169.25' , '160.45' , NOW() , NOW() ) 09/03/2023 12:25:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82218' 09/03/2023 12:25:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '82218' 09/03/2023 12:25:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82218' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '60' , '-60' , '4' , '1.60' , '1.6' , '0' , '5' , '91.20' ) 09/03/2023 12:25:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82218' , '' , 'PERGAMENE - COMUNIONE' , '65' , '-65' , '4' , '0.5' , '0.5' , '0' , '10' , '29.25' ) 09/03/2023 12:25:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82218' , '16603' , 'LIBRO INTENZIONI SANTE MESSE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '10' , '10.80' ) 09/03/2023 12:25:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82218' , '' , 'BUSTE ULIVO' , '4' , '-4' , '1' , '9.5' , '7.7868852459016' , '22' , '0' , '38.00' ) 09/03/2023 12:28:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '44' AND id_document != '82218' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-03-09') 09/03/2023 12:28:40 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '44', document_date = '2023-03-09', document_letter = '', id_customer = '1246', id_supplier = '', id_address = '4675590', address1 = 'L.GO MARGHERITA DI SAVOIA 85021 AVIGLIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '176.25', price_tax_excluded = '176.25', date_upd = NOW() WHERE id_document = '82218' 09/03/2023 12:28:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82218' 09/03/2023 12:28:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '82218' 09/03/2023 12:28:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82218' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '60' , '-60' , '4' , '1.6000' , '1.6' , '0' , '5' , '91.20' ) 09/03/2023 12:28:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82218' , '0' , 'PERGAMENE - COMUNIONE' , '65' , '-65' , '4' , '0.5000' , '0.5' , '0' , '10' , '29.25' ) 09/03/2023 12:28:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82218' , '16603' , 'LIBRO INTENZIONI SANTE MESSE' , '1' , '-1' , '0' , '12.0000' , '12' , '' , '10' , '10.80' ) 09/03/2023 12:28:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82218' , '0' , 'BUSTE ULIVO' , '4' , '-4' , '0' , '9.5000' , '9.5' , '' , '0' , '38.00' ) 09/03/2023 12:28:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82218' , '' , 'PARTICOLE' , '2' , '-2' , '0' , '3.5' , '3.5' , '' , '0' , '7.00' ) 09/03/2023 12:32:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '780' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-09') 09/03/2023 12:32:55 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' , '780' , '2023-03-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.95' , NOW() , NOW() ) 09/03/2023 12:32:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82219' 09/03/2023 12:32:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '82219' 09/03/2023 12:32:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82219' , '14623' , 'BAMBINO DI PRAGA BABY - 023 IP/9 BB' , '1' , '-1' , '1' , '9.50' , '7.7868852459016' , '22' , '0' , '9.50' ) 09/03/2023 12:32:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82219' , '9617' , 'SANTE PIAGHE DI NOSTRO SIGNORE GESÙ CRISTO - 8194' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 09/03/2023 12:32:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82219' , '17533' , 'CINGOLO ORO/COL - CING06' , '1' , '-1' , '1' , '18.5' , '15.16393442623' , '22' , '0' , '18.50' ) 09/03/2023 01:01:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '781' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-09') 09/03/2023 01:01:20 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' , '781' , '2023-03-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.10' , '9.10' , NOW() , NOW() ) 09/03/2023 01:01:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82220' 09/03/2023 01:01:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '82220' 09/03/2023 01:01:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82220' , '8368' , 'PREGHIERE DI LIBERAZIONE - DIVINA MISERICORDIA' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 09/03/2023 01:01:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82220' , '15433' , '33 PASSI VERSO IL SACRAMENTO DEL PERDONO - R. REYES' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 09/03/2023 03:27:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '776' AND id_document != '82214' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-09') 09/03/2023 03:27:19 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '776', document_date = '2023-03-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 = '22.50', price_tax_excluded = '22.50', date_upd = NOW() WHERE id_document = '82214' 09/03/2023 03:27:19 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 = '82214' 09/03/2023 03:27:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '82214' 09/03/2023 03:27:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82214' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '22.5' , '22.5' , '0' , '0' , '22.50' ) 09/03/2023 03:31:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '1/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-03-09') 09/03/2023 03:31:20 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 ( '23' , '1/L' , '2023-03-09' , 'L' , '204' , '0' , '4671483' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , '' , 'CAPPELLANIA OSPEDALE DA PROCIDA' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '129.00' , '108.04' , NOW() , NOW() ) 09/03/2023 03:31:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82221' 09/03/2023 03:31:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '82221' 09/03/2023 03:31:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82221' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '112.80' ) 09/03/2023 03:31:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82221' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.5000' , '3.3654' , '4' , '0' , '10.50' ) 09/03/2023 03:31:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82221' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '1.9000' , '1.8269' , '4' , '0' , '5.70' ) 09/03/2023 03:31:25 pm >> DELETE FROM ps_document WHERE id_document = '81467' 09/03/2023 03:31:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '81467' 09/03/2023 03:31:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '1/L' AND id_document != '82221' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-03-09') 09/03/2023 03:31:42 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '1/L', document_date = '2023-03-09', document_letter = 'L', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'CAPPELLANIA OSPEDALE DA PROCIDA', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '129.00', price_tax_excluded = '108.04', date_upd = NOW() WHERE id_document = '82221' 09/03/2023 03:31:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82221' 09/03/2023 03:31:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '82221' 09/03/2023 03:31:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82221' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '112.80' ) 09/03/2023 03:31:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82221' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '10.50' ) 09/03/2023 03:31:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82221' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '5.70' ) 09/03/2023 04:34:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '782' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-09') 09/03/2023 04:34:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '782' , '2023-03-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.10' , '3.99' , NOW() , NOW() ) 09/03/2023 04:34: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 = '82222' 09/03/2023 04:34:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '82222' 09/03/2023 04:34: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 ( '82222' , '19542' , 'LETTERA AGLI SPOSI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 09/03/2023 04:34: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 ( '82222' , '13506' , 'SANTO ROSARIO' , '2' , '-2' , '1' , '0.3' , '0.24590163934426' , '22' , '0' , '0.60' ) 09/03/2023 05:22:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '783' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-09') 09/03/2023 05:22:33 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '783' , '2023-03-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.65' , '47.63' , NOW() , NOW() ) 09/03/2023 05:22:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82223' 09/03/2023 05:22:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '82223' 09/03/2023 05:22:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82223' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 09/03/2023 05:22:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82223' , '18635' , 'NASCOSTO IN UN PEZZETTO DI PANE - 8038' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 09/03/2023 05:55:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '784' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-09') 09/03/2023 05:55:50 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' , '784' , '2023-03-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.40' , '34.66' , NOW() , NOW() ) 09/03/2023 05:55:50 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 = '82224' 09/03/2023 05:55:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '82224' 09/03/2023 05:55:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82224' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '9.50' ) 09/03/2023 05:55:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82224' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 09/03/2023 05:55:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82224' , '2708' , 'CONVERSARE CON DIO - 8452' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 09/03/2023 05:55:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82224' , '13576' , 'REGOLAMENTO DI VITA DI UN CRISTIANO E DUE SERMONI' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 09/03/2023 05:55:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82224' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '5' , '-5' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '5.50' ) 09/03/2023 05:59:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '785' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-09') 09/03/2023 05:59:25 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' , '785' , '2023-03-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.80' , '2.30' , NOW() , NOW() ) 09/03/2023 05:59:25 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 = '82225' 09/03/2023 05:59:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '82225' 09/03/2023 05:59:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82225' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '2.8' , '2.2950819672131' , '22' , '0' , '2.80' ) 09/03/2023 07:14:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '45' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-03-09') 09/03/2023 07:14:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '45' , '2023-03-09' , '' , '1178' , '0' , '4671042' , 'P. ZZA LINGUITI, 1 84095 GIFFONI VALLE PIANA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '306.00' , '306.00' , NOW() , NOW() ) 09/03/2023 07:14:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82226' 09/03/2023 07:14:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '82226' 09/03/2023 07:14:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82226' , '6629' , 'MIA PREGHIERA' , '400' , '-400' , '4' , '0.90' , '0.9' , '0' , '15' , '306.00' ) 09/03/2023 07:15:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '786' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-09') 09/03/2023 07:15:28 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '786' , '2023-03-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.40' , '3.13' , NOW() , NOW() ) 09/03/2023 07:15:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82227' 09/03/2023 07:15:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '82227' 09/03/2023 07:15:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82227' , '3104' , 'CROCE SAN BENEDETTO - CARTONCINO' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 09/03/2023 07:15:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82227' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.9' , '1.9' , '0' , '0' , '1.90' ) 09/03/2023 07:42:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '315' AND id_document != '74881' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-25') 09/03/2023 07:42:20 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '315', document_date = '2022-11-25', document_letter = '', id_customer = '3983', id_supplier = '', id_address = '4677540', address1 = 'P. ZZA ANNUNZIATA 03037 PONTECORVO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '352.34', price_tax_excluded = '352.34', date_upd = NOW() WHERE id_document = '74881' 09/03/2023 07:42:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74881' 09/03/2023 07:42:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '74881' 09/03/2023 07:42:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74881' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 09/03/2023 07:42:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74881' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 09/03/2023 07:42:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74881' , '5457' , 'IO SONO CON VOI 1 PARTE' , '27' , '-27' , '4' , '2.5000' , '2.5' , '0' , '15' , '57.38' ) 09/03/2023 07:42:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74881' , '5458' , 'IO SONO CON VOI 2 PARTE' , '27' , '-27' , '4' , '2.5000' , '2.5' , '0' , '15' , '57.38' ) 09/03/2023 07:42:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74881' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '15' , '6.80' ) 09/03/2023 07:42:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74881' , '11191' , 'VENITE CON ME 1 PARTE' , '15' , '-15' , '4' , '2.5000' , '2.5' , '0' , '15' , '31.88' ) 09/03/2023 07:42:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74881' , '11192' , 'VENITE CON ME 2 PARTE' , '15' , '-15' , '4' , '2.5000' , '2.5' , '0' , '15' , '31.88' ) 09/03/2023 07:42:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74881' , '11183' , 'VENITE CON ME - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 09/03/2023 07:42:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74881' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '23' , '-23' , '4' , '3.5000' , '3.5' , '0' , '15' , '68.42' )