27/06/2022 09:11:31 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 27/06/2022 09:11:31 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19671' , '1' , '' , 'nuovo-prodotto' ) 27/06/2022 09:11:31 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19671' , '1' , '1' , '2' , NOW() , NOW() ) 27/06/2022 09:11:31 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19671' , '0' , '1' , '0' , '0' ) 27/06/2022 09:12:15 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884047762' AND id_product != '19671' AND ean13 != '' 27/06/2022 09:12:15 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788884047762', date_upd = NOW() WHERE id_product = '19671' 27/06/2022 09:12:15 am >> UPDATE ps_product_lang SET name = 'UN MESE CON IL PREZIOSISSIMO SANGUE - 8074', description = '' WHERE id_product = '19671' 27/06/2022 09:12:15 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7' WHERE id_product = '19671' 27/06/2022 09:12:15 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19671' 27/06/2022 09:12:15 am >> DELETE FROM ps_specific_price WHERE id_product = '19671' 27/06/2022 09:12: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 = '19671' 27/06/2022 09:12:16 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19672' , '1' , '' , 'nuovo-prodotto' ) 27/06/2022 09:12: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 '19672' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19671' 27/06/2022 09:12:16 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19672' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19671' 27/06/2022 09:13:07 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884047830' AND id_product != '19672' AND ean13 != '' 27/06/2022 09:13:07 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788884047830', date_upd = NOW() WHERE id_product = '19672' 27/06/2022 09:13:07 am >> UPDATE ps_product_lang SET name = 'NOVENE AL PREZIOSISSIMO SANGUE - 8075', description = '' WHERE id_product = '19672' 27/06/2022 09:13:07 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3' WHERE id_product = '19672' 27/06/2022 09:13:07 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19672' 27/06/2022 09:13:07 am >> DELETE FROM ps_specific_price WHERE id_product = '19672' 27/06/2022 09:13: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 = '19672' 27/06/2022 09:13:08 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19673' , '1' , '' , 'nuovo-prodotto' ) 27/06/2022 09:13: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 '19673' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19672' 27/06/2022 09:13:08 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19673' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19672' 27/06/2022 09:14:26 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886616157' AND id_product != '10712' AND ean13 != '' 27/06/2022 09:14:26 am >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788886616157', date_upd = NOW() WHERE id_product = '10712' 27/06/2022 09:14:26 am >> UPDATE ps_product_lang SET name = 'TRATTATO DELLA VERA DEVOZIONE A MARIA - 8113', description = '' WHERE id_product = '10712' 27/06/2022 09:14:26 am >> UPDATE ps_product SET wholesale_price = '4.20', on_sale = '0', price = '9' WHERE id_product = '10712' 27/06/2022 09:14:26 am >> UPDATE ps_product_shop SET wholesale_price = '4.20', price = '9', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '73', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '10712' 27/06/2022 09:14:26 am >> DELETE FROM ps_specific_price WHERE id_product = '10712' 27/06/2022 09:16: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 ( '31' , '10862/00/2022' , '2022-06-22' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '7.50' , '1' , '0' , '0' , '0' , '' , '1' , '0' , '124.95' , '123.30' , NOW() , NOW() ) 27/06/2022 09:16: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 = '58909' 27/06/2022 09:16:17 am >> DELETE FROM ps_document_detail WHERE id_document = '58909' 27/06/2022 09:16: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 ( '58909' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '15' , '15' , '4' , '5.00' , '5' , '0' , '40' , '45.0000' ) 27/06/2022 09:16:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '38' 27/06/2022 09:16:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '38' , '1' ) 27/06/2022 09:16: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 ( '58909' , '18805' , 'FASCINO DELLE PARABOLE - 8016' , '1' , '1' , '4' , '7.00' , '7' , '0' , '40' , '4.2000' ) 27/06/2022 09:16:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '18805' AND id_supplier = '38' 27/06/2022 09:16:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18805' , '38' , '1' ) 27/06/2022 09:16:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58909' , '19671' , 'UN MESE CON IL PREZIOSISSIMO SANGUE - 8074' , '2' , '2' , '4' , '7.00' , '7' , '0' , '40' , '8.4000' ) 27/06/2022 09:16:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '19671' AND id_supplier = '38' 27/06/2022 09:16:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19671' , '38' , '1' ) 27/06/2022 09:16:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58909' , '19672' , 'NOVENE AL PREZIOSISSIMO SANGUE - 8075' , '3' , '3' , '4' , '3.00' , '3' , '0' , '40' , '5.4000' ) 27/06/2022 09:16:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '19672' AND id_supplier = '38' 27/06/2022 09:16:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19672' , '38' , '1' ) 27/06/2022 09:16:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58909' , '16968' , 'AFFIDAMENTO AI TRE CUORI - 8995' , '2' , '2' , '4' , '2.00' , '2' , '0' , '40' , '2.4000' ) 27/06/2022 09:16:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '16968' AND id_supplier = '38' 27/06/2022 09:16:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16968' , '38' , '1' ) 27/06/2022 09:16:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58909' , '10712' , 'TRATTATO DELLA VERA DEVOZIONE A MARIA - 8113' , '2' , '2' , '4' , '9.00' , '9' , '0' , '40' , '10.8000' ) 27/06/2022 09:16:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '10712' AND id_supplier = '38' 27/06/2022 09:16:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10712' , '38' , '1' ) 27/06/2022 09:16:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58909' , '7395' , 'PADRE PIO - UN PENSIERO PER OGNI GIORNO - 8142' , '2' , '2' , '4' , '5.00' , '5' , '0' , '40' , '6.0000' ) 27/06/2022 09:16:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '7395' AND id_supplier = '38' 27/06/2022 09:16:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7395' , '38' , '1' ) 27/06/2022 09:16:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58909' , '8383' , 'PREGHIERE PER LADORAZIONE EUCARISTICA - 8141' , '1' , '1' , '4' , '12.00' , '12' , '0' , '40' , '7.2000' ) 27/06/2022 09:16:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '8383' AND id_supplier = '38' 27/06/2022 09:16:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8383' , '38' , '1' ) 27/06/2022 09:16:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58909' , '8391' , 'PREGHIERE GUARIGIONE LIBERAZIONE CONSOLAZIONE - 8169' , '1' , '1' , '4' , '10.00' , '10' , '0' , '40' , '6.0000' ) 27/06/2022 09:16:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '8391' AND id_supplier = '38' 27/06/2022 09:16:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8391' , '38' , '1' ) 27/06/2022 09:16:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58909' , '4699' , 'GLORIE DI MARIA - 8243' , '1' , '1' , '4' , '10.00' , '10' , '0' , '40' , '6.0000' ) 27/06/2022 09:16:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '4699' AND id_supplier = '38' 27/06/2022 09:16:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4699' , '38' , '1' ) 27/06/2022 09:16:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58909' , '11452' , 'VITA E BRANI SCELTI - S. VERONICA - 8588' , '1' , '1' , '4' , '7.00' , '7' , '0' , '40' , '4.2000' ) 27/06/2022 09:16:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '11452' AND id_supplier = '38' 27/06/2022 09:16:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11452' , '38' , '1' ) 27/06/2022 09:16:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58909' , '8865' , 'REGOLA DI SAN BENEDETTO' , '2' , '2' , '4' , '5.00' , '5' , '0' , '40' , '6.0000' ) 27/06/2022 09:16:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '8865' AND id_supplier = '38' 27/06/2022 09:16:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8865' , '38' , '1' ) 27/06/2022 09:16:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58909' , '4948' , 'IMITAZIONE DI CRISTO - TASC - 8818' , '1' , '1' , '4' , '7.00' , '7' , '0' , '40' , '4.2000' ) 27/06/2022 09:16:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '4948' AND id_supplier = '38' 27/06/2022 09:16:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4948' , '38' , '1' ) 27/06/2022 09:33:07 am >> SELECT document_num FROM ps_document WHERE document_num = '2052' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-27') 27/06/2022 09:33:07 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' , '2052' , '2022-06-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1150.00' , '942.62' , NOW() , NOW() ) 27/06/2022 09:33:07 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 = '58910' 27/06/2022 09:33:07 am >> DELETE FROM ps_document_detail WHERE id_document = '58910' 27/06/2022 09:33:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58910' , '19346' , 'CASULA MARIANA LANA LUREX - 65/002005-M' , '1' , '-1' , '1' , '300' , '245.90163934426' , '22' , '0' , '300.00' ) 27/06/2022 09:33:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '19346' AND id_supplier = '' 27/06/2022 09:33:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19346' , '' , '1' ) 27/06/2022 09:33:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58910' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '850' , '696.72131147541' , '22' , '0' , '850.00' ) 27/06/2022 09:33:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 27/06/2022 09:33:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 27/06/2022 09:40:57 am >> SELECT document_num FROM ps_document WHERE document_num = '2053' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-27') 27/06/2022 09:40:57 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' , '2053' , '2022-06-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 27/06/2022 09:40:57 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 = '58911' 27/06/2022 09:40:57 am >> DELETE FROM ps_document_detail WHERE id_document = '58911' 27/06/2022 09:40:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58911' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 27/06/2022 09:40:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 27/06/2022 09:40:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 27/06/2022 09:48:37 am >> SELECT document_num FROM ps_document WHERE document_num = '2054' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-27') 27/06/2022 09:48:37 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' , '2054' , '2022-06-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '15.00' , NOW() , NOW() ) 27/06/2022 09:48:37 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 = '58912' 27/06/2022 09:48:37 am >> DELETE FROM ps_document_detail WHERE id_document = '58912' 27/06/2022 09:48: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 ( '58912' , '19202' , 'LETTERA AGLI SPOSI' , '5' , '-5' , '4' , '3.00' , '3' , '0' , '0' , '15.00' ) 27/06/2022 09:48:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '19202' AND id_supplier = '' 27/06/2022 09:48:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19202' , '' , '1' ) 27/06/2022 09:54:42 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892217560' AND id_product != '19673' AND ean13 != '' 27/06/2022 09:54:42 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788892217560', date_upd = NOW() WHERE id_product = '19673' 27/06/2022 09:54:42 am >> UPDATE ps_product_lang SET name = 'GESU\' UN PELLEGRINO - J. MARTIN', description = '' WHERE id_product = '19673' 27/06/2022 09:54:42 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '25' WHERE id_product = '19673' 27/06/2022 09:54:42 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '25', id_tax_rules_group = '4', id_category_default = '30', 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 = '19673' 27/06/2022 09:54:42 am >> DELETE FROM ps_specific_price WHERE id_product = '19673' 27/06/2022 09:54:43 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 = '19673' 27/06/2022 09:54:43 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19674' , '1' , '' , 'nuovo-prodotto' ) 27/06/2022 09:54:43 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 '19674' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19673' 27/06/2022 09:54:43 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19674' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19673' 27/06/2022 09:55:14 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892216396' AND id_product != '19674' AND ean13 != '' 27/06/2022 09:55:14 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788892216396', date_upd = NOW() WHERE id_product = '19674' 27/06/2022 09:55:14 am >> UPDATE ps_product_lang SET name = 'GESU\' UN PELLEGRINAGGIO - J. MARTIN', description = '' WHERE id_product = '19674' 27/06/2022 09:55:14 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '25' WHERE id_product = '19674' 27/06/2022 09:55:14 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '25', id_tax_rules_group = '4', id_category_default = '30', 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 = '19674' 27/06/2022 09:55:14 am >> DELETE FROM ps_specific_price WHERE id_product = '19674' 27/06/2022 09:55:15 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 = '19674' 27/06/2022 09:55:15 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19675' , '1' , '' , 'nuovo-prodotto' ) 27/06/2022 09:55:15 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 '19675' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19674' 27/06/2022 09:55:15 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19675' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19674' 27/06/2022 09:56:01 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892213166' AND id_product != '19675' AND ean13 != '' 27/06/2022 09:56:01 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788892213166', date_upd = NOW() WHERE id_product = '19675' 27/06/2022 09:56:01 am >> UPDATE ps_product_lang SET name = 'GUIDA DEL GESUITA - J. MARTIN', description = '' WHERE id_product = '19675' 27/06/2022 09:56:01 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '25' WHERE id_product = '19675' 27/06/2022 09:56:01 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '25', id_tax_rules_group = '4', id_category_default = '30', 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 = '19675' 27/06/2022 09:56:01 am >> DELETE FROM ps_specific_price WHERE id_product = '19675' 27/06/2022 09:56:03 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 = '19675' 27/06/2022 09:56:03 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19676' , '1' , '' , 'nuovo-prodotto' ) 27/06/2022 09:56:03 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 '19676' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19675' 27/06/2022 09:56:03 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19676' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19675' 27/06/2022 09:56:35 am >> SELECT document_num FROM ps_document WHERE document_num = '2/A' AND id_document != '50074' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-01-12') 27/06/2022 09:56:35 am >> UPDATE ps_document SET id_document_type = '24', document_num = '2/A', document_date = '2022-01-12', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '80.00', price_tax_excluded = '80.00', date_upd = NOW() WHERE id_document = '50074' 27/06/2022 09:56:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '50074' 27/06/2022 09:56:35 am >> DELETE FROM ps_document_detail WHERE id_document = '50074' 27/06/2022 09:56:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '50074' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 27/06/2022 09:56:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 27/06/2022 09:56:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 27/06/2022 09:56:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '50074' , '19675' , 'GUIDA DEL GESUITA - J. MARTIN' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '0' , '25.00' ) 27/06/2022 09:56:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '19675' AND id_supplier = '' 27/06/2022 09:56:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19675' , '' , '1' ) 27/06/2022 09:56:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '50074' , '19674' , 'GESU UN PELLEGRINAGGIO - J. MARTIN' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '0' , '25.00' ) 27/06/2022 09:56:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '19674' AND id_supplier = '' 27/06/2022 09:56:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19674' , '' , '1' ) 27/06/2022 09:56:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '50074' , '19673' , 'GESU UN PELLEGRINO - J. MARTIN' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '0' , '25.00' ) 27/06/2022 09:56:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '19673' AND id_supplier = '' 27/06/2022 09:56:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19673' , '' , '1' ) 27/06/2022 09:57:26 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788821594779' AND id_product != '1671' AND ean13 != '' 27/06/2022 09:57:26 am >> UPDATE ps_product SET id_supplier = '7', reference = '11/4', ean13 = '9788821594779', date_upd = NOW() WHERE id_product = '1671' 27/06/2022 09:57:26 am >> UPDATE ps_product_lang SET name = 'CANTICO DEI CANTICI - RIL.', description = '' WHERE id_product = '1671' 27/06/2022 09:57:26 am >> UPDATE ps_product SET wholesale_price = '22.78', on_sale = '0', price = '39' WHERE id_product = '1671' 27/06/2022 09:57:26 am >> UPDATE ps_product_shop SET wholesale_price = '22.78', price = '39', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '170', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '1671' 27/06/2022 09:57:26 am >> DELETE FROM ps_specific_price WHERE id_product = '1671' 27/06/2022 09:58:19 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8053853003386' AND id_product != '19676' AND ean13 != '' 27/06/2022 09:58:19 am >> UPDATE ps_product SET id_supplier = '', reference = '8/3', ean13 = '8053853003386', date_upd = NOW() WHERE id_product = '19676' 27/06/2022 09:58:19 am >> UPDATE ps_product_lang SET name = 'TUTTI FRATELLI - CD', description = '' WHERE id_product = '19676' 27/06/2022 09:58:19 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12.9' WHERE id_product = '19676' 27/06/2022 09:58:19 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12.9', id_tax_rules_group = '4', id_category_default = '76', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19676' 27/06/2022 09:58:19 am >> DELETE FROM ps_specific_price WHERE id_product = '19676' 27/06/2022 09:58: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 = '19676' 27/06/2022 09:58:19 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19677' , '1' , '' , 'nuovo-prodotto' ) 27/06/2022 09:58: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 '19677' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19676' 27/06/2022 09:58:19 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19677' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19676' 27/06/2022 10:00:57 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' , '603321' , '2022-06-23' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '4.28' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '148.17' , '144.66' , NOW() , NOW() ) 27/06/2022 10:00:57 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 = '58913' 27/06/2022 10:00:57 am >> DELETE FROM ps_document_detail WHERE id_document = '58913' 27/06/2022 10:00:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58913' , '1671' , 'CANTICO DEI CANTICI - RIL.' , '1' , '1' , '4' , '39.00' , '39' , '0' , '33' , '26.1300' ) 27/06/2022 10:00:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '1671' AND id_supplier = '7' 27/06/2022 10:00:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1671' , '7' , '1' ) 27/06/2022 10:00:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58913' , '19676' , 'TUTTI FRATELLI - CD' , '2' , '2' , '4' , '12.90' , '12.9' , '0' , '30' , '18.0600' ) 27/06/2022 10:00:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '19676' AND id_supplier = '7' 27/06/2022 10:00:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19676' , '7' , '1' ) 27/06/2022 10:00:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58913' , '12995' , 'SALE, NON MIELE - L. EPICOCO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 27/06/2022 10:00:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '12995' AND id_supplier = '7' 27/06/2022 10:00:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12995' , '7' , '1' ) 27/06/2022 10:00:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58913' , '10064' , 'SOLO LAMORE CREA - F. ROSINI' , '1' , '1' , '4' , '12.00' , '12' , '0' , '33' , '8.0400' ) 27/06/2022 10:00:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '10064' AND id_supplier = '7' 27/06/2022 10:00:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10064' , '7' , '1' ) 27/06/2022 10:00:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58913' , '19512' , 'SGUARDO DI GESU - F. CRISTOFARO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '30' , '11.2000' ) 27/06/2022 10:00:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '19512' AND id_supplier = '7' 27/06/2022 10:00:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19512' , '7' , '1' ) 27/06/2022 10:00:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58913' , '19675' , 'GUIDA DEL GESUITA - J. MARTIN' , '1' , '1' , '4' , '25.00' , '25' , '0' , '33' , '16.7500' ) 27/06/2022 10:00:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '19675' AND id_supplier = '7' 27/06/2022 10:00:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19675' , '7' , '1' ) 27/06/2022 10:00:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58913' , '19673' , 'GESU UN PELLEGRINO - J. MARTIN' , '1' , '1' , '4' , '25.00' , '25' , '0' , '33' , '16.7500' ) 27/06/2022 10:00:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '19673' AND id_supplier = '7' 27/06/2022 10:00:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19673' , '7' , '1' ) 27/06/2022 10:00:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58913' , '19674' , 'GESU UN PELLEGRINAGGIO - J. MARTIN' , '1' , '1' , '4' , '25.00' , '25' , '0' , '33' , '16.7500' ) 27/06/2022 10:00:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '19674' AND id_supplier = '7' 27/06/2022 10:00:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19674' , '7' , '1' ) 27/06/2022 10:00:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58913' , '1737' , 'CARTA DI IDENTITÀ - RP66' , '20' , '20' , '1' , '1.229' , '1.0073770491803' , '22' , '35' , '19.4919' ) 27/06/2022 10:00:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '1737' AND id_supplier = '7' 27/06/2022 10:00:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1737' , '7' , '1' ) 27/06/2022 10:22:33 am >> SELECT document_num FROM ps_document WHERE document_num = '2055' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-27') 27/06/2022 10:22:33 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' , '2055' , '2022-06-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '72.00' , '59.02' , NOW() , NOW() ) 27/06/2022 10:22:33 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58914' 27/06/2022 10:22:33 am >> DELETE FROM ps_document_detail WHERE id_document = '58914' 27/06/2022 10:22: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 ( '58914' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '2' , '-2' , '1' , '36.00' , '29.508196721311' , '22' , '0' , '72.00' ) 27/06/2022 10:22:33 am >> DELETE FROM ps_product_supplier WHERE id_product = '19396' AND id_supplier = '' 27/06/2022 10:22:33 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19396' , '' , '1' ) 27/06/2022 10:37:58 am >> SELECT document_num FROM ps_document WHERE document_num = '2056' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-27') 27/06/2022 10:37:58 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2056' , '2022-06-27' , '' , '' , '' , '' , 'P.ZZA GIOVANNI PAOLO II, 4 84080 COPERCHIA' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '225.00' , '185.51' , NOW() , NOW() ) 27/06/2022 10:37:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58915' 27/06/2022 10:37:58 am >> DELETE FROM ps_document_detail WHERE id_document = '58915' 27/06/2022 10:37:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58915' , '16744' , 'MIA NOTTE NON CONOSCE TENEBRE - K. RAHNER' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 27/06/2022 10:37:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '16744' AND id_supplier = '' 27/06/2022 10:37:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16744' , '' , '1' ) 27/06/2022 10:37:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58915' , '18131' , 'TAU MEDIO CM3 - T6' , '199' , '-199' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '199.00' ) 27/06/2022 10:37:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '18131' AND id_supplier = '' 27/06/2022 10:37:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18131' , '' , '1' ) 27/06/2022 10:37:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58915' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '100' , '-100' , '1' , '0.2000' , '0.1639' , '22' , '0' , '20.00' ) 27/06/2022 10:37:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '18617' AND id_supplier = '' 27/06/2022 10:37:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18617' , '' , '1' ) 27/06/2022 10:38:45 am >> DELETE FROM ps_document WHERE id_document = '53970' 27/06/2022 10:38:45 am >> DELETE FROM ps_document_detail WHERE id_document = '53970' 27/06/2022 10:55:45 am >> SELECT document_num FROM ps_document WHERE document_num = '2057' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-27') 27/06/2022 10:55: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' , '2057' , '2022-06-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 27/06/2022 10:55: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 = '58916' 27/06/2022 10:55:45 am >> DELETE FROM ps_document_detail WHERE id_document = '58916' 27/06/2022 10:55: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 ( '58916' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 27/06/2022 10:55:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 27/06/2022 10:55:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 27/06/2022 11:13:03 am >> SELECT document_num FROM ps_document WHERE document_num = '2058' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-27') 27/06/2022 11:13:03 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2058' , '2022-06-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.80' , '7.21' , NOW() , NOW() ) 27/06/2022 11:13:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58917' 27/06/2022 11:13:03 am >> DELETE FROM ps_document_detail WHERE id_document = '58917' 27/06/2022 11:13:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58917' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '8' , '-8' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '8.80' ) 27/06/2022 11:13:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '18122' AND id_supplier = '' 27/06/2022 11:13:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18122' , '' , '1' ) 27/06/2022 11:16:08 am >> SELECT document_num FROM ps_document WHERE document_num = '2059' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-27') 27/06/2022 11:16:08 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' , '2059' , '2022-06-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '76.00' , '76.00' , NOW() , NOW() ) 27/06/2022 11:16:08 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58918' 27/06/2022 11:16:08 am >> DELETE FROM ps_document_detail WHERE id_document = '58918' 27/06/2022 11:16:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58918' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '16' , '-16' , '4' , '5.00' , '5' , '0' , '5' , '76.00' ) 27/06/2022 11:16:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 27/06/2022 11:16:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 27/06/2022 11:25:52 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826607283' AND id_product != '19677' AND ean13 != '' 27/06/2022 11:25:52 am >> UPDATE ps_product SET id_supplier = '', reference = '7/4', ean13 = '9788826607283', date_upd = NOW() WHERE id_product = '19677' 27/06/2022 11:25:52 am >> UPDATE ps_product_lang SET name = 'PADRE PIO E I DONI DELLO SPIRITO SANTO - G. ANTONACCI', description = '' WHERE id_product = '19677' 27/06/2022 11:25:52 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '25' WHERE id_product = '19677' 27/06/2022 11:25:52 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '25', id_tax_rules_group = '4', id_category_default = '104', 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 = '19677' 27/06/2022 11:25:52 am >> DELETE FROM ps_specific_price WHERE id_product = '19677' 27/06/2022 11:25:53 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 = '19677' 27/06/2022 11:25:53 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19678' , '1' , '' , 'nuovo-prodotto' ) 27/06/2022 11:25:53 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 '19678' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19677' 27/06/2022 11:25:53 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19678' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19677' 27/06/2022 11:27:36 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826607498' AND id_product != '19678' AND ean13 != '' 27/06/2022 11:27:36 am >> UPDATE ps_product SET id_supplier = '', reference = '13/2', ean13 = '9788826607498', date_upd = NOW() WHERE id_product = '19678' 27/06/2022 11:27:36 am >> UPDATE ps_product_lang SET name = 'SANTITA\' NELLE FAMIGLIE DEL MONDO ', description = '' WHERE id_product = '19678' 27/06/2022 11:27:36 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '19678' 27/06/2022 11:27:36 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '69', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19678' 27/06/2022 11:27:36 am >> DELETE FROM ps_specific_price WHERE id_product = '19678' 27/06/2022 11:27:38 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 = '19678' 27/06/2022 11:27:38 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19679' , '1' , '' , 'nuovo-prodotto' ) 27/06/2022 11:27:38 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 '19679' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19678' 27/06/2022 11:27:38 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19679' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19678' 27/06/2022 11:28:23 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826607573' AND id_product != '19679' AND ean13 != '' 27/06/2022 11:28:23 am >> UPDATE ps_product SET id_supplier = '', reference = '14', ean13 = '9788826607573', date_upd = NOW() WHERE id_product = '19679' 27/06/2022 11:28:23 am >> UPDATE ps_product_lang SET name = 'ITINERARI CAT. PER LA VITA MATRIMONIALE', description = '' WHERE id_product = '19679' 27/06/2022 11:28:23 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '19679' 27/06/2022 11:28:23 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '69', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19679' 27/06/2022 11:28:23 am >> DELETE FROM ps_specific_price WHERE id_product = '19679' 27/06/2022 11:28:24 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19679' 27/06/2022 11:28:24 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19680' , '1' , '' , 'nuovo-prodotto' ) 27/06/2022 11:28:24 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19680' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19679' 27/06/2022 11:28:24 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19680' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19679' 27/06/2022 11:29:24 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826607450' AND id_product != '19680' AND ean13 != '' 27/06/2022 11:29:24 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788826607450', date_upd = NOW() WHERE id_product = '19680' 27/06/2022 11:29:24 am >> UPDATE ps_product_lang SET name = 'SANTA MESSA - J.J. SILVESTRE VALOR', description = '' WHERE id_product = '19680' 27/06/2022 11:29:24 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '28' WHERE id_product = '19680' 27/06/2022 11:29:24 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '28', id_tax_rules_group = '4', id_category_default = '104', 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 = '19680' 27/06/2022 11:29:24 am >> DELETE FROM ps_specific_price WHERE id_product = '19680' 27/06/2022 11:29:24 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19680' 27/06/2022 11:29:24 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19681' , '1' , '' , 'nuovo-prodotto' ) 27/06/2022 11:29:24 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19681' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19680' 27/06/2022 11:29:24 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19681' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19680' 27/06/2022 11:29:44 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' , '002096' , '2022-06-24' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '199.59' , '199.59' , NOW() , NOW() ) 27/06/2022 11:29:44 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 = '58919' 27/06/2022 11:29:44 am >> DELETE FROM ps_document_detail WHERE id_document = '58919' 27/06/2022 11:29:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58919' , '19677' , 'PADRE PIO E I DONI DELLO SPIRITO SANTO - G. ANTONACCI' , '1' , '1' , '4' , '25.00' , '25' , '0' , '45' , '13.7500' ) 27/06/2022 11:29:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '19677' AND id_supplier = '79' 27/06/2022 11:29:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19677' , '79' , '1' ) 27/06/2022 11:29:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58919' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '1' , '4' , '110.00' , '110' , '0' , '30' , '77.0000' ) 27/06/2022 11:29:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '79' 27/06/2022 11:29:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '79' , '1' ) 27/06/2022 11:29:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58919' , '9313' , 'SACRAMENTO DELLUNZIONE E CURA PASTORALE DEGLI INFERMI' , '2' , '2' , '4' , '15.49' , '15.49' , '0' , '30' , '21.6860' ) 27/06/2022 11:29:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '9313' AND id_supplier = '79' 27/06/2022 11:29:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9313' , '79' , '1' ) 27/06/2022 11:29:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58919' , '9017' , 'RITO DELLA PENITENZA' , '2' , '2' , '4' , '10.50' , '10.5' , '0' , '30' , '14.7000' ) 27/06/2022 11:29:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '9017' AND id_supplier = '79' 27/06/2022 11:29:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9017' , '79' , '1' ) 27/06/2022 11:29:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58919' , '9020' , 'RITO DELLE ESEQUIE - MIN' , '2' , '2' , '4' , '27.00' , '27' , '0' , '30' , '37.8000' ) 27/06/2022 11:29:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '9020' AND id_supplier = '79' 27/06/2022 11:29:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9020' , '79' , '1' ) 27/06/2022 11:29:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58919' , '19678' , 'SANTITA NELLE FAMIGLIE DEL MONDO ' , '1' , '1' , '4' , '15.00' , '15' , '0' , '45' , '8.2500' ) 27/06/2022 11:29:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '19678' AND id_supplier = '79' 27/06/2022 11:29:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19678' , '79' , '1' ) 27/06/2022 11:29:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58919' , '19679' , 'ITINERARI CAT. PER LA VITA MATRIMONIALE' , '2' , '2' , '4' , '10' , '10' , '0' , '45' , '11.0000' ) 27/06/2022 11:29:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '19679' AND id_supplier = '79' 27/06/2022 11:29:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19679' , '79' , '1' ) 27/06/2022 11:29:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58919' , '19680' , 'SANTA MESSA - J.J. SILVESTRE VALOR' , '1' , '1' , '4' , '28.00' , '28' , '0' , '45' , '15.4000' ) 27/06/2022 11:29:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '19680' AND id_supplier = '79' 27/06/2022 11:29:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19680' , '79' , '1' ) 27/06/2022 11:37:27 am >> SELECT document_num FROM ps_document WHERE document_num = '2060' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-27') 27/06/2022 11:37: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' , '2060' , '2022-06-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.20' , '28.28' , NOW() , NOW() ) 27/06/2022 11:37: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 = '58920' 27/06/2022 11:37:27 am >> DELETE FROM ps_document_detail WHERE id_document = '58920' 27/06/2022 11:37: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 ( '58920' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '5.70' ) 27/06/2022 11:37:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 27/06/2022 11:37:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 27/06/2022 11:37: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 ( '58920' , '11151' , 'LIBRI' , '3' , '-3' , '4' , '3.5' , '3.5' , '0' , '0' , '10.50' ) 27/06/2022 11:37:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 27/06/2022 11:37:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 27/06/2022 11:37: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 ( '58920' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '15.00' ) 27/06/2022 11:37:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 27/06/2022 11:37:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 27/06/2022 11:39:29 am >> SELECT document_num FROM ps_document WHERE document_num = '2061' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-27') 27/06/2022 11:39: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' , '2061' , '2022-06-27' , '' , '3712' , '' , '4671443' , 'VIA DALMAZIA 6 84121 SALERNO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '71.12' , '60.95' , NOW() , NOW() ) 27/06/2022 11:39: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 = '58921' 27/06/2022 11:39:29 am >> DELETE FROM ps_document_detail WHERE id_document = '58921' 27/06/2022 11:39: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 ( '58921' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8525' , '22' , '0' , '56.40' ) 27/06/2022 11:39:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 27/06/2022 11:39:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 27/06/2022 11:39: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 ( '58921' , '9015' , 'RITO DELLA CONFERMAZIONE' , '1' , '-1' , '4' , '15.5000' , '15.5' , '0' , '5' , '14.72' ) 27/06/2022 11:39:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '9015' AND id_supplier = '' 27/06/2022 11:39:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9015' , '' , '1' ) 27/06/2022 11:39:58 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') 27/06/2022 11:39:58 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 = '', 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 = '46.60', price_tax_excluded = '42.75', date_upd = NOW() WHERE id_document = '57793' 27/06/2022 11:39:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57793' 27/06/2022 11:39:58 am >> DELETE FROM ps_document_detail WHERE id_document = '57793' 27/06/2022 11:39:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57793' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '7.60' ) 27/06/2022 11:39:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 27/06/2022 11:39:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 27/06/2022 11:39:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57793' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '7' , '-7' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '24.50' ) 27/06/2022 11:39:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 27/06/2022 11:39:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 27/06/2022 11:39:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57793' , '7935' , 'PERGAMENE - CRESIMA MOD. B' , '15' , '-15' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '4.50' ) 27/06/2022 11:39:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '7935' AND id_supplier = '' 27/06/2022 11:39:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7935' , '' , '1' ) 27/06/2022 11:39:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57793' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 27/06/2022 11:39:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 27/06/2022 11:39:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 27/06/2022 11:44:53 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' , '666' , '2022-06-23' , '' , '0' , '122' , '4669556' , 'VIA XXV APRILE, 17 24050 GRASSOBBIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '296.70' , '243.20' , NOW() , NOW() ) 27/06/2022 11:44:53 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 = '58922' 27/06/2022 11:44:53 am >> DELETE FROM ps_document_detail WHERE id_document = '58922' 27/06/2022 11:44:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58922' , '18881' , 'STOLA POLIESTERE - PST020' , '32' , '32' , '1' , '7.6' , '6.2295081967213' , '22' , '0' , '296.7040' ) 27/06/2022 11:44:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '18881' AND id_supplier = '122' 27/06/2022 11:44:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18881' , '122' , '1' ) 27/06/2022 12:37:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '2061' AND id_document != '58921' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-27') 27/06/2022 12:37:02 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2061', document_date = '2022-06-27', document_letter = '', id_customer = '', id_supplier = '', id_address = '', address1 = 'VIA DALMAZIA 6 84121 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '71.12', price_tax_excluded = '60.95', date_upd = NOW() WHERE id_document = '58921' 27/06/2022 12:37:02 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 = '58921' 27/06/2022 12:37:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '58921' 27/06/2022 12:37: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 ( '58921' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 27/06/2022 12:37:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 27/06/2022 12:37:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 27/06/2022 12:37:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58921' , '9015' , 'RITO DELLA CONFERMAZIONE' , '1' , '-1' , '4' , '15.5000' , '15.5' , '0' , '5' , '14.72' ) 27/06/2022 12:37:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9015' AND id_supplier = '' 27/06/2022 12:37:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9015' , '' , '1' ) 27/06/2022 12:38:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '1866' AND id_document != '58704' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-10') 27/06/2022 12:38:33 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1866', document_date = '2022-06-10', 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 = '80.00', price_tax_excluded = '65.57', date_upd = NOW() WHERE id_document = '58704' 27/06/2022 12:38: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 = '58704' 27/06/2022 12:38:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '58704' 27/06/2022 12:38: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 ( '58704' , '5999' , 'LUME VETRO SOFFIATO MELOGRANO - 1021' , '1' , '-1' , '1' , '14.0000' , '11.475409836066' , '22' , '0' , '14.00' ) 27/06/2022 12:38:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5999' AND id_supplier = '' 27/06/2022 12:38:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5999' , '' , '1' ) 27/06/2022 12:38: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 ( '58704' , '19109' , 'LUCERNA IN VETRO TRASPARENTE - DIAM. 10 - 1492' , '2' , '-2' , '1' , '14.5000' , '11.885245901639' , '22' , '0' , '29.00' ) 27/06/2022 12:38:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19109' AND id_supplier = '' 27/06/2022 12:38:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19109' , '' , '1' ) 27/06/2022 12:38: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 ( '58704' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '37' , '30.327868852459' , '22' , '0' , '37.00' ) 27/06/2022 12:38:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 27/06/2022 12:38:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 27/06/2022 02:36:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '1988' AND id_document != '58840' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-22') 27/06/2022 02:36:45 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1988', document_date = '2022-06-22', 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 = '35.15', price_tax_excluded = '35.15', date_upd = NOW() WHERE id_document = '58840' 27/06/2022 02:36:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58840' 27/06/2022 02:36:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '58840' 27/06/2022 02:36:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58840' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 27/06/2022 02:36:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 27/06/2022 02:36:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 27/06/2022 02:36:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58840' , '4699' , 'GLORIE DI MARIA - 8243' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 27/06/2022 02:36:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4699' AND id_supplier = '' 27/06/2022 02:36:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4699' , '' , '1' ) 27/06/2022 02:36:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58840' , '15983' , 'BIBBIA IN 365 GIORNI' , '1' , '-1' , '4' , '18.9000' , '18.9' , '0' , '5' , '17.96' ) 27/06/2022 02:36:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15983' AND id_supplier = '' 27/06/2022 02:36:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15983' , '' , '1' ) 27/06/2022 02:36:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58840' , '2776' , 'CORONCINA E NOVENA AL PREZIOSISSIMO SANGUE' , '1' , '-1' , '4' , '1.0400' , '1.04' , '0' , '0' , '1.04' ) 27/06/2022 02:36:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2776' AND id_supplier = '' 27/06/2022 02:36:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2776' , '' , '1' ) 27/06/2022 02:36:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58840' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '-1' , '4' , '1.9' , '1.9' , '0' , '0' , '1.90' ) 27/06/2022 02:36:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 27/06/2022 02:36:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 27/06/2022 02:42:01 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '76/22', document_date = '2022-06-24', document_letter = '22', id_customer = '0', id_supplier = '0', id_address = '4671003', address1 = 'VIA TORQUATO TASSO, 10 24020 GORLE', address2 = '', note = 'CAMBIARE NUMERO', 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.75', price_tax_excluded = '58.75', date_upd = NOW() WHERE id_document = '58889' 27/06/2022 02:42: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 = '58889' 27/06/2022 02:42:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '58889' 27/06/2022 02:42: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 ( '58889' , '9490' , 'SAN NICOLA - A.DURSO' , '1' , '1' , '4' , '4.0000' , '4' , '0' , '50' , '2.00' ) 27/06/2022 02:42: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 ( '58889' , '6088' , 'MADRE SPERANZA - V.SALVOLDI' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 27/06/2022 02:42: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 ( '58889' , '3631' , 'DON BOSCO - T. BOSCO' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 27/06/2022 02:42: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 ( '58889' , '9499' , 'SAN PIETRO - A.GOVERNALE' , '2' , '2' , '4' , '4.0000' , '4' , '0' , '50' , '4.00' ) 27/06/2022 02:42: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 ( '58889' , '9399' , 'SAN CAMILLO DE LELLIS - F.RUFFINI' , '1' , '1' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 27/06/2022 02:42: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 ( '58889' , '9533' , 'SANTANNA - F.DI STASIO' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 27/06/2022 02:42: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 ( '58889' , '19664' , 'ANTONIO ROSMINI - V. SALVOLDI' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 27/06/2022 02:42: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 ( '58889' , '19665' , 'SAN MATTIA AP. - SIMEONE/TESTI' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 27/06/2022 02:42: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 ( '58889' , '9473' , 'SAN LUIGI GONZAGA - G. ARLEDLER' , '2' , '2' , '4' , '4.0000' , '4' , '0' , '50' , '4.00' ) 27/06/2022 02:42: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 ( '58889' , '9450' , 'SAN GIOVANNI BATTISTA - G. PESENTI' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 27/06/2022 02:42: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 ( '58889' , '9475' , 'SAN MARCO EV. - G.PESENTI' , '2' , '2' , '4' , '3.5000' , '3.5' , '0' , '50' , '3.50' ) 27/06/2022 02:42: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 ( '58889' , '19666' , 'DON TONINO BELLO - A. GIORGIO' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 27/06/2022 02:42: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 ( '58889' , '19667' , 'SAN BERNARDO DI CHIARAVALLE - G. PESENTI' , '1' , '1' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 27/06/2022 02:42: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 ( '58889' , '19668' , 'LUIGI MARIA PALAZZOLO - E. PLATI' , '2' , '2' , '4' , '6.0000' , '6' , '0' , '50' , '6.00' ) 27/06/2022 02:42: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 ( '58889' , '19669' , 'SAN VITO MARTIRE - D. BOLOGNINI' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 27/06/2022 02:42: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 ( '58889' , '9579' , 'SANTA MARGHERITA MARIA ALACOQUE - M.TARONI' , '2' , '2' , '4' , '4.0000' , '4' , '0' , '50' , '4.00' ) 27/06/2022 02:42:15 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '76/22', document_date = '2022-06-24', document_letter = '22', id_customer = '0', id_supplier = '17', id_address = '2612', address1 = 'VIA TORQUATO TASSO, 10 24020 GORLE', address2 = '', note = 'CAMBIARE NUMERO', 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.75', price_tax_excluded = '58.75', date_upd = NOW() WHERE id_document = '58889' 27/06/2022 02:42:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58889' 27/06/2022 02:42:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '58889' 27/06/2022 02:42:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58889' , '9490' , 'SAN NICOLA - A.DURSO' , '1' , '1' , '4' , '4.0000' , '4' , '0' , '50' , '2.00' ) 27/06/2022 02:42:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9490' AND id_supplier = '17' 27/06/2022 02:42:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9490' , '17' , '1' ) 27/06/2022 02:42:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58889' , '6088' , 'MADRE SPERANZA - V.SALVOLDI' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 27/06/2022 02:42:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6088' AND id_supplier = '17' 27/06/2022 02:42:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6088' , '17' , '1' ) 27/06/2022 02:42:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58889' , '3631' , 'DON BOSCO - T. BOSCO' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 27/06/2022 02:42:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3631' AND id_supplier = '17' 27/06/2022 02:42:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3631' , '17' , '1' ) 27/06/2022 02:42:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58889' , '9499' , 'SAN PIETRO - A.GOVERNALE' , '2' , '2' , '4' , '4.0000' , '4' , '0' , '50' , '4.00' ) 27/06/2022 02:42:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9499' AND id_supplier = '17' 27/06/2022 02:42:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9499' , '17' , '1' ) 27/06/2022 02:42:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58889' , '9399' , 'SAN CAMILLO DE LELLIS - F.RUFFINI' , '1' , '1' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 27/06/2022 02:42:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9399' AND id_supplier = '17' 27/06/2022 02:42:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9399' , '17' , '1' ) 27/06/2022 02:42:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58889' , '9533' , 'SANTANNA - F.DI STASIO' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 27/06/2022 02:42:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9533' AND id_supplier = '17' 27/06/2022 02:42:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9533' , '17' , '1' ) 27/06/2022 02:42:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58889' , '19664' , 'ANTONIO ROSMINI - V. SALVOLDI' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 27/06/2022 02:42:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19664' AND id_supplier = '17' 27/06/2022 02:42:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19664' , '17' , '1' ) 27/06/2022 02:42:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58889' , '19665' , 'SAN MATTIA AP. - SIMEONE/TESTI' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 27/06/2022 02:42:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19665' AND id_supplier = '17' 27/06/2022 02:42:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19665' , '17' , '1' ) 27/06/2022 02:42:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58889' , '9473' , 'SAN LUIGI GONZAGA - G. ARLEDLER' , '2' , '2' , '4' , '4.0000' , '4' , '0' , '50' , '4.00' ) 27/06/2022 02:42:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9473' AND id_supplier = '17' 27/06/2022 02:42:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9473' , '17' , '1' ) 27/06/2022 02:42:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58889' , '9450' , 'SAN GIOVANNI BATTISTA - G. PESENTI' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 27/06/2022 02:42:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9450' AND id_supplier = '17' 27/06/2022 02:42:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9450' , '17' , '1' ) 27/06/2022 02:42:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58889' , '9475' , 'SAN MARCO EV. - G.PESENTI' , '2' , '2' , '4' , '3.5000' , '3.5' , '0' , '50' , '3.50' ) 27/06/2022 02:42:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9475' AND id_supplier = '17' 27/06/2022 02:42:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9475' , '17' , '1' ) 27/06/2022 02:42:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58889' , '19666' , 'DON TONINO BELLO - A. GIORGIO' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 27/06/2022 02:42:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19666' AND id_supplier = '17' 27/06/2022 02:42:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19666' , '17' , '1' ) 27/06/2022 02:42:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58889' , '19667' , 'SAN BERNARDO DI CHIARAVALLE - G. PESENTI' , '1' , '1' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 27/06/2022 02:42:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19667' AND id_supplier = '17' 27/06/2022 02:42:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19667' , '17' , '1' ) 27/06/2022 02:42:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58889' , '19668' , 'LUIGI MARIA PALAZZOLO - E. PLATI' , '2' , '2' , '4' , '6.0000' , '6' , '0' , '50' , '6.00' ) 27/06/2022 02:42:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19668' AND id_supplier = '17' 27/06/2022 02:42:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19668' , '17' , '1' ) 27/06/2022 02:42:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58889' , '19669' , 'SAN VITO MARTIRE - D. BOLOGNINI' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 27/06/2022 02:42:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19669' AND id_supplier = '17' 27/06/2022 02:42:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19669' , '17' , '1' ) 27/06/2022 02:42:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58889' , '9579' , 'SANTA MARGHERITA MARIA ALACOQUE - M.TARONI' , '2' , '2' , '4' , '4.0000' , '4' , '0' , '50' , '4.00' ) 27/06/2022 02:42:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9579' AND id_supplier = '17' 27/06/2022 02:42:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9579' , '17' , '1' ) 27/06/2022 02:55:41 pm >> DELETE FROM ps_product WHERE id_product = '9346' 27/06/2022 02:55:41 pm >> DELETE FROM ps_product_shop WHERE id_product = '9346' 27/06/2022 02:55:41 pm >> DELETE FROM ps_product_lang WHERE id_product = '9346' 27/06/2022 02:55:41 pm >> DELETE FROM ps_stock_available WHERE id_product = '9346' 27/06/2022 03:27:50 pm >> DELETE FROM ps_product WHERE id_product = '8946' 27/06/2022 03:27:50 pm >> DELETE FROM ps_product_shop WHERE id_product = '8946' 27/06/2022 03:27:50 pm >> DELETE FROM ps_product_lang WHERE id_product = '8946' 27/06/2022 03:27:50 pm >> DELETE FROM ps_stock_available WHERE id_product = '8946' 27/06/2022 03:59:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '1846' AND id_document != '58679' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-09') 27/06/2022 03:59:02 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1846', document_date = '2022-06-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 = '18.00', price_tax_excluded = '14.75', date_upd = NOW() WHERE id_document = '58679' 27/06/2022 03:59:02 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 = '58679' 27/06/2022 03:59:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '58679' 27/06/2022 03:59: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 ( '58679' , '12047' , 'MAXI CARD - M0107/K131' , '8' , '-8' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '9.60' ) 27/06/2022 03:59:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12047' AND id_supplier = '' 27/06/2022 03:59:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12047' , '' , '1' ) 27/06/2022 03:59: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 ( '58679' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 27/06/2022 03:59:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 27/06/2022 03:59:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 27/06/2022 03:59: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 ( '58679' , '9719' , 'SCATOLINA CON PERGAMENA IN POLIMERO - COMUNIONE - 2301 ' , '1' , '-1' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '1.20' ) 27/06/2022 03:59:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9719' AND id_supplier = '' 27/06/2022 03:59:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9719' , '' , '1' ) 27/06/2022 03:59: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 ( '58679' , '16969' , 'CORONA DELLE ROSE - 10974' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 27/06/2022 03:59:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16969' AND id_supplier = '' 27/06/2022 03:59:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16969' , '' , '1' ) 27/06/2022 03:59: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 ( '58679' , '19560' , 'PERGAMENA 17X25' , '1' , '-1' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '0.70' ) 27/06/2022 03:59:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19560' AND id_supplier = '' 27/06/2022 03:59:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19560' , '' , '1' ) 27/06/2022 04:00:11 pm >> DELETE FROM ps_product WHERE id_product = '912' 27/06/2022 04:00:11 pm >> DELETE FROM ps_product_shop WHERE id_product = '912' 27/06/2022 04:00:11 pm >> DELETE FROM ps_product_lang WHERE id_product = '912' 27/06/2022 04:00:11 pm >> DELETE FROM ps_stock_available WHERE id_product = '912' 27/06/2022 04:43:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '2062' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-27') 27/06/2022 04:43:03 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' , '2062' , '2022-06-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '100.00' , NOW() , NOW() ) 27/06/2022 04:43:03 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 = '58923' 27/06/2022 04:43:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '58923' 27/06/2022 04:43:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58923' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '20' , '-20' , '4' , '5.00' , '5' , '0' , '0' , '100.00' ) 27/06/2022 04:43:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 27/06/2022 04:43:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 27/06/2022 04:43:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '2063' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-27') 27/06/2022 04:43:26 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' , '2063' , '2022-06-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.00' , '35.00' , NOW() , NOW() ) 27/06/2022 04:43:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58924' 27/06/2022 04:43:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '58924' 27/06/2022 04:43:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58924' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '7' , '-7' , '4' , '5.00' , '5' , '0' , '0' , '35.00' ) 27/06/2022 04:43:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 27/06/2022 04:43:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 27/06/2022 04:43:53 pm >> DELETE FROM ps_document WHERE id_document = '58924' 27/06/2022 04:43:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '58924' 27/06/2022 04:43:57 pm >> DELETE FROM ps_document WHERE id_document = '58923' 27/06/2022 04:43:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '58923' 27/06/2022 04:53:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '2062' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-27') 27/06/2022 04:53:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2062' , '2022-06-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '95.00' , '95.00' , NOW() , NOW() ) 27/06/2022 04:53:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58925' 27/06/2022 04:53:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '58925' 27/06/2022 04:53:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58925' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '20' , '-20' , '4' , '5.00' , '5' , '0' , '5' , '95.00' ) 27/06/2022 04:53:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 27/06/2022 04:53:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 27/06/2022 05:10:06 pm >> DELETE FROM ps_document WHERE id_document = '58707' 27/06/2022 05:10:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '58707' 27/06/2022 05:14:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '2063' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-27') 27/06/2022 05:14: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' , '2063' , '2022-06-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '41.60' , '34.10' , NOW() , NOW() ) 27/06/2022 05:14: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 = '58926' 27/06/2022 05:14:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '58926' 27/06/2022 05:14: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 ( '58926' , '3073' , 'CROCE PRIMA COMUNIONE - LEGNO SCURO - 713/15' , '3' , '-3' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '3.60' ) 27/06/2022 05:14:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3073' AND id_supplier = '' 27/06/2022 05:14:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3073' , '' , '1' ) 27/06/2022 05:14: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 ( '58926' , '13113' , 'GUADALUPE BABY - 023 GUA 9 BB' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 27/06/2022 05:14:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13113' AND id_supplier = '' 27/06/2022 05:14:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13113' , '' , '1' ) 27/06/2022 05:14: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 ( '58926' , '14623' , 'BAMBINO DI PRAGA BABY - 023 IP/9 BB' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 27/06/2022 05:14:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14623' AND id_supplier = '' 27/06/2022 05:14:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14623' , '' , '1' ) 27/06/2022 05:14: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 ( '58926' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 27/06/2022 05:14:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 27/06/2022 05:14:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 27/06/2022 05:37:00 pm >> DELETE FROM ps_product WHERE id_product = '643' 27/06/2022 05:37:01 pm >> DELETE FROM ps_product_shop WHERE id_product = '643' 27/06/2022 05:37:01 pm >> DELETE FROM ps_product_lang WHERE id_product = '643' 27/06/2022 05:37:01 pm >> DELETE FROM ps_stock_available WHERE id_product = '643' 27/06/2022 05:37:20 pm >> DELETE FROM ps_product WHERE id_product = '1722' 27/06/2022 05:37:20 pm >> DELETE FROM ps_product_shop WHERE id_product = '1722' 27/06/2022 05:37:20 pm >> DELETE FROM ps_product_lang WHERE id_product = '1722' 27/06/2022 05:37:20 pm >> DELETE FROM ps_stock_available WHERE id_product = '1722' 27/06/2022 05:38:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '2016' AND id_document != '58869' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-23') 27/06/2022 05:38:41 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2016', document_date = '2022-06-23', 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 = '1200.00', price_tax_excluded = '983.61', date_upd = NOW() WHERE id_document = '58869' 27/06/2022 05:38:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58869' 27/06/2022 05:38:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '58869' 27/06/2022 05:38:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58869' , '19352' , 'CASULA LANA S/MOIRE AGNELLO - 8219' , '1' , '-1' , '1' , '870.0000' , '713.11475409836' , '22' , '0' , '870.00' ) 27/06/2022 05:38:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19352' AND id_supplier = '' 27/06/2022 05:38:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19352' , '' , '1' ) 27/06/2022 05:38:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58869' , '19101' , 'INCENSO C' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '100' , '0.00' ) 27/06/2022 05:38:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19101' AND id_supplier = '' 27/06/2022 05:38:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19101' , '' , '1' ) 27/06/2022 05:38:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58869' , '18560' , 'STOLA ROMANA S/MOIRE - 7289S' , '1' , '-1' , '1' , '330' , '270.49180327869' , '22' , '0' , '330.00' ) 27/06/2022 05:38:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18560' AND id_supplier = '' 27/06/2022 05:38:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18560' , '' , '1' ) 27/06/2022 05:39:09 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '7899S' AND id_product != '15409' AND ean13 != '' 27/06/2022 05:39:09 pm >> UPDATE ps_product SET id_supplier = '126', reference = '', ean13 = '7899S', date_upd = NOW() WHERE id_product = '15409' 27/06/2022 05:39:09 pm >> UPDATE ps_product_lang SET name = 'STOLA ROMANA S/MOIRE\' - 7899S', description = '' WHERE id_product = '15409' 27/06/2022 05:39:09 pm >> UPDATE ps_product SET wholesale_price = '160.00', on_sale = '0', price = '319.6700' WHERE id_product = '15409' 27/06/2022 05:39:09 pm >> UPDATE ps_product_shop SET wholesale_price = '160.00', price = '319.6700', id_tax_rules_group = '1', id_category_default = '448', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15409' 27/06/2022 05:39:09 pm >> DELETE FROM ps_specific_price WHERE id_product = '15409' 27/06/2022 05:44:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '2064' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-27') 27/06/2022 05:44:54 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2064' , '2022-06-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.58' , '17.58' , NOW() , NOW() ) 27/06/2022 05:44:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58927' 27/06/2022 05:44:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '58927' 27/06/2022 05:44:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58927' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '1' , '-1' , '4' , '18.50' , '18.5' , '0' , '5' , '17.58' ) 27/06/2022 05:44:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9253' AND id_supplier = '' 27/06/2022 05:44:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9253' , '' , '1' ) 27/06/2022 06:52:29 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001917' AND id_product != '19190' AND ean13 != '' 27/06/2022 06:52:30 pm >> UPDATE ps_product SET id_supplier = '126', reference = '', ean13 = '001917', date_upd = NOW() WHERE id_product = '19190' 27/06/2022 06:52:30 pm >> UPDATE ps_product_lang SET name = 'STOLA MARIANA - 7335', description = '' WHERE id_product = '19190' 27/06/2022 06:52:30 pm >> UPDATE ps_product SET wholesale_price = '70.00', on_sale = '0', price = '139.3443' WHERE id_product = '19190' 27/06/2022 06:52:30 pm >> UPDATE ps_product_shop SET wholesale_price = '70.00', price = '139.3443', id_tax_rules_group = '1', id_category_default = '448', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19190' 27/06/2022 06:52:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '19190' 27/06/2022 07:23:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '2065' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-27') 27/06/2022 07:23:22 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' , '2065' , '2022-06-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '44.50' , '36.48' , NOW() , NOW() ) 27/06/2022 07:23:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58928' 27/06/2022 07:23:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '58928' 27/06/2022 07:23:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58928' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '33' , '27.049180327869' , '22' , '0' , '33.00' ) 27/06/2022 07:23:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 27/06/2022 07:23:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 27/06/2022 07:23:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58928' , '1375' , 'BRUCIAINCENSI LEGNO - BRUL' , '1' , '-1' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '8.50' ) 27/06/2022 07:23:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1375' AND id_supplier = '' 27/06/2022 07:23:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1375' , '' , '1' ) 27/06/2022 07:23:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58928' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 27/06/2022 07:23:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4697' AND id_supplier = '' 27/06/2022 07:23:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4697' , '' , '1' ) 27/06/2022 07:23:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58928' , '5473' , 'IOHANNES 25G - ROSA - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 27/06/2022 07:23:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5473' AND id_supplier = '' 27/06/2022 07:23:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5473' , '' , '1' ) 27/06/2022 07:26:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '2066' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-27') 27/06/2022 07:26:13 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2066' , '2022-06-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '105.00' , '86.07' , NOW() , NOW() ) 27/06/2022 07:26: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 = '58929' 27/06/2022 07:26:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '58929' 27/06/2022 07:26: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 ( '58929' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '105' , '86.065573770492' , '22' , '0' , '105.00' ) 27/06/2022 07:26:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 27/06/2022 07:26:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 27/06/2022 07:29:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '12/A' AND id_document != '51968' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-02-28') 27/06/2022 07:29:12 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '12/A', document_date = '2022-02-28', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'cappellania s. leonardo ', 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 = '304.74', price_tax_excluded = '263.41', date_upd = NOW() WHERE id_document = '51968' 27/06/2022 07:29:12 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 = '51968' 27/06/2022 07:29:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '51968' 27/06/2022 07:29:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '17402' , 'BRACCIALE ELASTICO ' , '6' , '-6' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '12.00' ) 27/06/2022 07:29:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17402' AND id_supplier = '' 27/06/2022 07:29:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17402' , '' , '1' ) 27/06/2022 07:29: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 ( '51968' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '36' , '-36' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '46.80' ) 27/06/2022 07:29:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = '' 27/06/2022 07:29:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' ) 27/06/2022 07:29: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 ( '51968' , '0' , 'sacro cuore' , '1' , '-1' , '1' , '39.0000' , '31.967213114754' , '22' , '0' , '39.00' ) 27/06/2022 07:29:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 27/06/2022 07:29:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 27/06/2022 07:29: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 ( '51968' , '0' , 'MIRACOLOSA' , '1' , '-1' , '0' , '12.0000' , '12' , '0' , '0' , '12.00' ) 27/06/2022 07:29:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 27/06/2022 07:29:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 27/06/2022 07:29: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 ( '51968' , '0' , 'SUPPLICA' , '1' , '-1' , '0' , '10.0000' , '10' , '0' , '0' , '10.00' ) 27/06/2022 07:29:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 27/06/2022 07:29:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 27/06/2022 07:29: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 ( '51968' , '9128' , 'ROSARIO LEGNO - RLE5896/5812***oggetti' , '12' , '-12' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '14.40' ) 27/06/2022 07:29:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9128' AND id_supplier = '' 27/06/2022 07:29:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9128' , '' , '1' ) 27/06/2022 07:29: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 ( '51968' , '6353' , 'MEDAGLIA S. BENEDETTO SMALTATA - M016' , '10' , '-10' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '11.00' ) 27/06/2022 07:29:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6353' AND id_supplier = '' 27/06/2022 07:29:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6353' , '' , '1' ) 27/06/2022 07:29: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 ( '51968' , '1312' , 'BRACCIALE DECINA' , '10' , '-10' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '13.00' ) 27/06/2022 07:29:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1312' AND id_supplier = '' 27/06/2022 07:29:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1312' , '' , '1' ) 27/06/2022 07:29: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 ( '51968' , '11678' , '30/05/2022' , '0' , '0' , '1' , '0.0000' , '0' , '22' , '0' , '0.00' ) 27/06/2022 07:29:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11678' AND id_supplier = '' 27/06/2022 07:29:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11678' , '' , '1' ) 27/06/2022 07:29: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 ( '51968' , '1319' , 'BRACCIALE DECINA TAU' , '10' , '-10' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '12.00' ) 27/06/2022 07:29:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1319' AND id_supplier = '' 27/06/2022 07:29:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1319' , '' , '1' ) 27/06/2022 07:29: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 ( '51968' , '18838' , 'CAPOCULLA PICCOLO' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 27/06/2022 07:29:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18838' AND id_supplier = '' 27/06/2022 07:29:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18838' , '' , '1' ) 27/06/2022 07:29: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 ( '51968' , '16689' , 'OSTIA PAN DI CENA mm80' , '7' , '-7' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '14.00' ) 27/06/2022 07:29:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 27/06/2022 07:29:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 27/06/2022 07:29:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 27/06/2022 07:29:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 27/06/2022 07:29:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 27/06/2022 07:29:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '15387' , 'VESTINA BATTESIMALE ' , '5' , '-5' , '1' , '2.8000' , '2.2950819672131' , '22' , '0' , '14.00' ) 27/06/2022 07:29:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15387' AND id_supplier = '' 27/06/2022 07:29:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15387' , '' , '1' ) 27/06/2022 07:29:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '5' , '-5' , '1' , '1.4000' , '1.1475409836066' , '22' , '0' , '7.00' ) 27/06/2022 07:29:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '791' AND id_supplier = '' 27/06/2022 07:29:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '791' , '' , '1' ) 27/06/2022 07:29:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '12' , '-12' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '18.00' ) 27/06/2022 07:29:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = '' 27/06/2022 07:29:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' ) 27/06/2022 07:29:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '18890' , 'ROSARIO LEGNO - R980' , '12' , '-12' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '12.00' ) 27/06/2022 07:29:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18890' AND id_supplier = '' 27/06/2022 07:29:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18890' , '' , '1' ) 27/06/2022 07:29:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '19515' , 'AMEN - LUG 2022' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 27/06/2022 07:29:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19515' AND id_supplier = '' 27/06/2022 07:29:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19515' , '' , '1' ) 27/06/2022 07:29:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '19516' , 'AMEN - AGO 2022' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 27/06/2022 07:29:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19516' AND id_supplier = '' 27/06/2022 07:29:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19516' , '' , '1' ) 27/06/2022 07:29:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '11678' , 'SOPRACULLA - 1132' , '4' , '-4' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '10.00' ) 27/06/2022 07:29:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11678' AND id_supplier = '' 27/06/2022 07:29:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11678' , '' , '1' ) 27/06/2022 07:29:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '5' , '-5' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '2.50' ) 27/06/2022 07:29:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7924' AND id_supplier = '' 27/06/2022 07:29:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7924' , '' , '1' ) 27/06/2022 07:38:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '2066' AND id_document != '58929' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-27') 27/06/2022 07:38:17 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2066', document_date = '2022-06-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 = '105.00', price_tax_excluded = '86.07', date_upd = NOW() WHERE id_document = '58929' 27/06/2022 07:38:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58929' 27/06/2022 07:38:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '58929' 27/06/2022 07:38:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58929' , '11678' , 'SOPRACULLA ROSA - 1132' , '4' , '-4' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '10.00' ) 27/06/2022 07:38:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11678' AND id_supplier = '' 27/06/2022 07:38:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11678' , '' , '1' ) 27/06/2022 07:38:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58929' , '17402' , 'BRACCIALE ELASTICO ' , '6' , '-6' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '12.00' ) 27/06/2022 07:38:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17402' AND id_supplier = '' 27/06/2022 07:38:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17402' , '' , '1' ) 27/06/2022 07:38:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58929' , '6353' , 'MEDAGLIA S. BENEDETTO SMALTATA - M016' , '10' , '-10' , '1' , '1.1' , '0.9016393442623' , '22' , '0' , '11.00' ) 27/06/2022 07:38:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6353' AND id_supplier = '' 27/06/2022 07:38:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6353' , '' , '1' ) 27/06/2022 07:38:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58929' , '1312' , 'BRACCIALE DECINA' , '10' , '-10' , '1' , '1' , '0.81967213114754' , '22' , '0' , '10.00' ) 27/06/2022 07:38:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1312' AND id_supplier = '' 27/06/2022 07:38:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1312' , '' , '1' ) 27/06/2022 07:38:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58929' , '1319' , 'BRACCIALE DECINA TAU' , '9' , '-9' , '1' , '1' , '0.81967213114754' , '22' , '0' , '9.00' ) 27/06/2022 07:38:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1319' AND id_supplier = '' 27/06/2022 07:38:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1319' , '' , '1' ) 27/06/2022 07:38:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58929' , '18838' , 'CAPOCULLA PICCOLO' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 27/06/2022 07:38:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18838' AND id_supplier = '' 27/06/2022 07:38:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18838' , '' , '1' ) 27/06/2022 07:38:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58929' , '15387' , 'VESTINA BATTESIMALE ' , '5' , '-5' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '12.50' ) 27/06/2022 07:38:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15387' AND id_supplier = '' 27/06/2022 07:38:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15387' , '' , '1' ) 27/06/2022 07:38:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58929' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '5' , '-5' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '7.00' ) 27/06/2022 07:38:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '791' AND id_supplier = '' 27/06/2022 07:38:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '791' , '' , '1' ) 27/06/2022 07:38:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58929' , '18890' , 'ROSARIO LEGNO - R980' , '14' , '-14' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '14.00' ) 27/06/2022 07:38:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18890' AND id_supplier = '' 27/06/2022 07:38:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18890' , '' , '1' ) 27/06/2022 07:38:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58929' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '13' , '-13' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '6.50' ) 27/06/2022 07:38:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7924' AND id_supplier = '' 27/06/2022 07:38:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7924' , '' , '1' ) 27/06/2022 07:42:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '12/A' AND id_document != '51968' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-02-28') 27/06/2022 07:42:52 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '12/A', document_date = '2022-02-28', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'cappellania s. leonardo ', 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 = '86.74', price_tax_excluded = '74.25', date_upd = NOW() WHERE id_document = '51968' 27/06/2022 07:42:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '51968' 27/06/2022 07:42:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '51968' 27/06/2022 07:42:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '36' , '-36' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '46.80' ) 27/06/2022 07:42:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = '' 27/06/2022 07:42:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' ) 27/06/2022 07:42:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '16689' , 'OSTIA PAN DI CENA mm80' , '7' , '-7' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '14.00' ) 27/06/2022 07:42:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 27/06/2022 07:42:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 27/06/2022 07:42:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 27/06/2022 07:42:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 27/06/2022 07:42:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 27/06/2022 07:42:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '12' , '-12' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '18.00' ) 27/06/2022 07:42:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14247' AND id_supplier = '' 27/06/2022 07:42:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14247' , '' , '1' ) 27/06/2022 07:42:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '' , 'SOMMA PER ARRIVARE AL RESIDUO' , '1' , '-1' , '0' , '0.94' , '0.94' , '' , '0' , '0.94' ) 27/06/2022 07:42:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '' 27/06/2022 07:42:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '' , '1' ) 27/06/2022 07:42:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '51968' , '' , 'ACCONTO € 218 SCALATI, RESIDUO AL 27/06/2022 ' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 27/06/2022 07:42:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '' 27/06/2022 07:42:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '' , '1' ) 27/06/2022 07:44:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '1695' AND id_document != '58493' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-30') 27/06/2022 07:44:12 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1695', document_date = '2022-05-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '54.80', price_tax_excluded = '53.45', date_upd = NOW() WHERE id_document = '58493' 27/06/2022 07:44:12 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 = '58493' 27/06/2022 07:44:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '58493' 27/06/2022 07:44:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58493' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 27/06/2022 07:44:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 27/06/2022 07:44:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 27/06/2022 07:44:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58493' , '19515' , 'AMEN - LUG 2022' , '5' , '-5' , '4' , '3.90' , '3.9' , '0' , '5' , '18.55' ) 27/06/2022 07:44:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19515' AND id_supplier = '' 27/06/2022 07:44:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19515' , '' , '1' ) 27/06/2022 07:44:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58493' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '-1' , '4' , '1.25' , '1.25' , '0' , '0' , '1.25' ) 27/06/2022 07:44:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 27/06/2022 07:44:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 27/06/2022 07:45:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '1897' AND id_document != '58738' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-13') 27/06/2022 07:45:57 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1897', document_date = '2022-06-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '53.20', price_tax_excluded = '52.98', date_upd = NOW() WHERE id_document = '58738' 27/06/2022 07:45:57 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 = '58738' 27/06/2022 07:45:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '58738' 27/06/2022 07:45:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58738' , '19501' , 'PACE INTERIORE - CHIARA AMIRANTE' , '1' , '-1' , '4' , '12.9000' , '12.9' , '0' , '5' , '12.26' ) 27/06/2022 07:45:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19501' AND id_supplier = '' 27/06/2022 07:45:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19501' , '' , '1' ) 27/06/2022 07:45:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58738' , '18907' , 'ANGELO MI DISSE - A. COMASTRI' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '5' , '23.75' ) 27/06/2022 07:45:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18907' AND id_supplier = '' 27/06/2022 07:45:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18907' , '' , '1' ) 27/06/2022 07:45:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58738' , '1319' , 'BRACCIALE DECINA TAU' , '1' , '-1' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '1.20' ) 27/06/2022 07:45:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1319' AND id_supplier = '' 27/06/2022 07:45:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1319' , '' , '1' ) 27/06/2022 07:45:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58738' , '19516' , 'AMEN - AGO 2022' , '4' , '-4' , '4' , '3.90' , '3.9' , '0' , '5' , '14.84' ) 27/06/2022 07:45:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19516' AND id_supplier = '' 27/06/2022 07:45:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19516' , '' , '1' ) 27/06/2022 07:45:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58738' , '6629' , 'MIA PREGHIERA' , '1' , '-1' , '4' , '0.57' , '0.57' , '0' , '0' , '0.57' ) 27/06/2022 07:45:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6629' AND id_supplier = '' 27/06/2022 07:45:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6629' , '' , '1' ) 27/06/2022 07:45:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58738' , '6629' , 'MIA PREGHIERA' , '1' , '-1' , '4' , '0.58' , '0.58' , '0' , '0' , '0.58' ) 27/06/2022 07:45:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6629' AND id_supplier = '' 27/06/2022 07:45:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6629' , '' , '1' ) 27/06/2022 07:53:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '2060' AND id_document != '58920' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-27') 27/06/2022 07:53:03 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2060', document_date = '2022-06-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 = '31.20', price_tax_excluded = '28.28', date_upd = NOW() WHERE id_document = '58920' 27/06/2022 07:53:03 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 = '58920' 27/06/2022 07:53:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '58920' 27/06/2022 07:53:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58920' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '5.70' ) 27/06/2022 07:53:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 27/06/2022 07:53:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 27/06/2022 07:53: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 ( '58920' , '15020' , 'PREGARE OGNI GIORNO' , '3' , '-3' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 27/06/2022 07:53:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 27/06/2022 07:53:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 27/06/2022 07:53: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 ( '58920' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '15.00' ) 27/06/2022 07:53:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 27/06/2022 07:53:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 27/06/2022 07:53: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 ( '58920' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 27/06/2022 07:53:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 27/06/2022 07:53:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' )