15/06/2022 08:48:03 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 15/06/2022 08:48:03 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19652' , '1' , '' , 'nuovo-prodotto' ) 15/06/2022 08:48:03 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19652' , '1' , '1' , '2' , NOW() , NOW() ) 15/06/2022 08:48:03 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19652' , '0' , '1' , '0' , '0' ) 15/06/2022 08:48:43 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892229037' AND id_product != '19652' AND ean13 != '' 15/06/2022 08:48:43 am >> UPDATE ps_product SET id_supplier = '', reference = '4/3', ean13 = '9788892229037', date_upd = NOW() WHERE id_product = '19652' 15/06/2022 08:48:43 am >> UPDATE ps_product_lang SET name = 'vangelo in famiglia', description = '' WHERE id_product = '19652' 15/06/2022 08:48:43 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.9' WHERE id_product = '19652' 15/06/2022 08:48:43 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.9', 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 = '19652' 15/06/2022 08:48:43 am >> DELETE FROM ps_specific_price WHERE id_product = '19652' 15/06/2022 08:48:44 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 = '19652' 15/06/2022 08:48:44 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19653' , '1' , '' , 'nuovo-prodotto' ) 15/06/2022 08:48:44 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 '19653' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19652' 15/06/2022 08:48:44 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19653' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19652' 15/06/2022 08:51:26 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788862448055' AND id_product != '16019' AND ean13 != '' 15/06/2022 08:51:26 am >> UPDATE ps_product SET id_supplier = '7', reference = '7/3', ean13 = '9788862448055', date_upd = NOW() WHERE id_product = '16019' 15/06/2022 08:51:26 am >> UPDATE ps_product_lang SET name = 'MARTA, MARIA E LAZZARO - L.M. EPICOCO', description = '' WHERE id_product = '16019' 15/06/2022 08:51:26 am >> UPDATE ps_product SET wholesale_price = '5.60', on_sale = '0', price = '10' WHERE id_product = '16019' 15/06/2022 08:51:26 am >> UPDATE ps_product_shop SET wholesale_price = '5.60', price = '10', id_tax_rules_group = '4', id_category_default = '267', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16019' 15/06/2022 08:51:26 am >> DELETE FROM ps_specific_price WHERE id_product = '16019' 15/06/2022 08:53: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 ( '33' , '602313' , '2022-06-13' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '4.18' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '147.75' , '147.75' , NOW() , NOW() ) 15/06/2022 08:53:08 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58764' 15/06/2022 08:53:08 am >> DELETE FROM ps_document_detail WHERE id_document = '58764' 15/06/2022 08:53:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58764' , '19512' , 'SGUARDO DI GESU - F. CRISTOFARO' , '2' , '2' , '4' , '16.00' , '16' , '0' , '30' , '22.4000' ) 15/06/2022 08:53:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '19512' AND id_supplier = '7' 15/06/2022 08:53:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19512' , '7' , '1' ) 15/06/2022 08:53:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58764' , '19652' , 'vangelo in famiglia' , '2' , '2' , '4' , '2.90' , '2.9' , '0' , '33' , '3.8860' ) 15/06/2022 08:53:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '19652' AND id_supplier = '7' 15/06/2022 08:53:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19652' , '7' , '1' ) 15/06/2022 08:53:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58764' , '17647' , 'VANGELI E ATTI ' , '9' , '9' , '4' , '3.00' , '3' , '0' , '30' , '18.9000' ) 15/06/2022 08:53:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '17647' AND id_supplier = '7' 15/06/2022 08:53:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17647' , '7' , '1' ) 15/06/2022 08:53:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58764' , '8966' , 'RIDERE CON IL CUORE - VALERIO ALBISETTI' , '1' , '1' , '4' , '11.00' , '11' , '0' , '33' , '7.3700' ) 15/06/2022 08:53:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '8966' AND id_supplier = '7' 15/06/2022 08:53:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8966' , '7' , '1' ) 15/06/2022 08:53:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58764' , '14459' , 'VITA AL RITMO DELLA PAROLA' , '1' , '1' , '4' , '7.90' , '7.9' , '0' , '33' , '5.2930' ) 15/06/2022 08:53:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '14459' AND id_supplier = '7' 15/06/2022 08:53:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14459' , '7' , '1' ) 15/06/2022 08:53:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58764' , '16884' , 'ARTE DI GUARIRE - F. ROSINI' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 15/06/2022 08:53:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '16884' AND id_supplier = '7' 15/06/2022 08:53:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16884' , '7' , '1' ) 15/06/2022 08:53:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58764' , '6005' , 'LUMEN GENTIUM' , '1' , '1' , '4' , '3.00' , '3' , '0' , '33' , '2.0100' ) 15/06/2022 08:53:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '6005' AND id_supplier = '7' 15/06/2022 08:53:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6005' , '7' , '1' ) 15/06/2022 08:53:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58764' , '5283' , 'INFELICITÀ - V. M. FERNANDEZ' , '1' , '1' , '4' , '4.90' , '4.9' , '0' , '33' , '3.2830' ) 15/06/2022 08:53:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '5283' AND id_supplier = '7' 15/06/2022 08:53:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5283' , '7' , '1' ) 15/06/2022 08:53:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58764' , '10415' , 'SUPERFICIALITÀ - V. M. FERNANDEZ' , '1' , '1' , '4' , '4.90' , '4.9' , '0' , '33' , '3.2830' ) 15/06/2022 08:53:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '10415' AND id_supplier = '7' 15/06/2022 08:53:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10415' , '7' , '1' ) 15/06/2022 08:53:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58764' , '19360' , 'IN PRINCIPIO ERANO FRATELLI - L. EPICOCO' , '2' , '2' , '4' , '10.00' , '10' , '0' , '30' , '14.0000' ) 15/06/2022 08:53:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '19360' AND id_supplier = '7' 15/06/2022 08:53:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19360' , '7' , '1' ) 15/06/2022 08:53:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58764' , '16019' , 'MARTA, MARIA E LAZZARO - L.M. EPICOCO' , '1' , '1' , '4' , '10' , '10' , '0' , '30' , '7.0000' ) 15/06/2022 08:53:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '16019' AND id_supplier = '7' 15/06/2022 08:53:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16019' , '7' , '1' ) 15/06/2022 08:53:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58764' , '3977' , 'EUCARISTIA: LA MIA AUTOSTRADA...' , '1' , '1' , '4' , '15.00' , '15' , '0' , '33' , '10.0500' ) 15/06/2022 08:53:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '3977' AND id_supplier = '7' 15/06/2022 08:53:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3977' , '7' , '1' ) 15/06/2022 08:53:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58764' , '17553' , 'GRANDI SANTE AMICHE DI GESU' , '1' , '1' , '4' , '9.90' , '9.9' , '0' , '30' , '6.9300' ) 15/06/2022 08:53:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '17553' AND id_supplier = '7' 15/06/2022 08:53:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17553' , '7' , '1' ) 15/06/2022 08:53:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58764' , '15939' , 'AMORE CHE DECIDE - L. EPICOCO' , '1' , '1' , '4' , '10.00' , '10' , '0' , '30' , '7.0000' ) 15/06/2022 08:53:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '15939' AND id_supplier = '7' 15/06/2022 08:53:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15939' , '7' , '1' ) 15/06/2022 08:53:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58764' , '15996' , 'TELEMACO NON SI SBAGLIAVA - L. EPICOCO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 15/06/2022 08:53:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '15996' AND id_supplier = '7' 15/06/2022 08:53:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15996' , '7' , '1' ) 15/06/2022 08:53:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58764' , '12995' , 'SALE, NON MIELE - L. EPICOCO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 15/06/2022 08:53:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '12995' AND id_supplier = '7' 15/06/2022 08:53:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12995' , '7' , '1' ) 15/06/2022 09:23:32 am >> SELECT document_num FROM ps_document WHERE document_num = '1921' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-15') 15/06/2022 09:23:32 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1921' , '2022-06-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.80' , '21.31' , NOW() , NOW() ) 15/06/2022 09:23:32 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58765' 15/06/2022 09:23:32 am >> DELETE FROM ps_document_detail WHERE id_document = '58765' 15/06/2022 09:23:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58765' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '1' , '-1' , '1' , '12.20' , '10' , '22' , '0' , '12.20' ) 15/06/2022 09:23:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '19431' AND id_supplier = '' 15/06/2022 09:23:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19431' , '' , '1' ) 15/06/2022 09:23:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58765' , '8391' , 'PREGHIERE GUARIGIONE LIBERAZIONE CONSOLAZIONE - 8169' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '' , '10.00' ) 15/06/2022 09:23:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '8391' AND id_supplier = '' 15/06/2022 09:23:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8391' , '' , '1' ) 15/06/2022 09:23:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58765' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '2' , '-2' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '1.60' ) 15/06/2022 09:23:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '17004' AND id_supplier = '' 15/06/2022 09:23:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17004' , '' , '1' ) 15/06/2022 09:30:32 am >> SELECT document_num FROM ps_document WHERE document_num = '1922' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-15') 15/06/2022 09:30:32 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1922' , '2022-06-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '108.30' , '93.37' , NOW() , NOW() ) 15/06/2022 09:30:32 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58766' 15/06/2022 09:30:32 am >> DELETE FROM ps_document_detail WHERE id_document = '58766' 15/06/2022 09:30:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58766' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 15/06/2022 09:30:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 15/06/2022 09:30:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 15/06/2022 09:30:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58766' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '3' , '-3' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '19.50' ) 15/06/2022 09:30:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '11757' AND id_supplier = '' 15/06/2022 09:30:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11757' , '' , '1' ) 15/06/2022 09:30:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58766' , '7673' , 'PARTICOLE MM38' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 15/06/2022 09:30:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '7673' AND id_supplier = '' 15/06/2022 09:30:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7673' , '' , '1' ) 15/06/2022 09:30:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58766' , '7311' , 'OSTIA SOTTILE 74MM' , '6' , '-6' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '11.40' ) 15/06/2022 09:30:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 15/06/2022 09:30:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 15/06/2022 10:31:39 am >> SELECT document_num FROM ps_document WHERE document_num = '1923' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-15') 15/06/2022 10:31:39 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1923' , '2022-06-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.00' , '13.11' , NOW() , NOW() ) 15/06/2022 10:31:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58767' 15/06/2022 10:31:39 am >> DELETE FROM ps_document_detail WHERE id_document = '58767' 15/06/2022 10:31:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58767' , '18840' , 'CAPOCULLA ' , '1' , '-1' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '16.00' ) 15/06/2022 10:31:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '18840' AND id_supplier = '' 15/06/2022 10:31:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18840' , '' , '1' ) 15/06/2022 10:34:02 am >> SELECT document_num FROM ps_document WHERE document_num = '1924' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-15') 15/06/2022 10:34:02 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' , '1924' , '2022-06-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.30' , '2.70' , NOW() , NOW() ) 15/06/2022 10:34:02 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58768' 15/06/2022 10:34:02 am >> DELETE FROM ps_document_detail WHERE id_document = '58768' 15/06/2022 10:34:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58768' , '15403' , 'CROCE IN RESINA CM 9 - 3806/G052' , '1' , '-1' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '3.30' ) 15/06/2022 10:34:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '15403' AND id_supplier = '' 15/06/2022 10:34:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15403' , '' , '1' ) 15/06/2022 10:47:03 am >> SELECT document_num FROM ps_document WHERE document_num = '1925' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-15') 15/06/2022 10:47: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' , '1925' , '2022-06-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.10' , '3.58' , NOW() , NOW() ) 15/06/2022 10:47: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 = '58769' 15/06/2022 10:47:03 am >> DELETE FROM ps_document_detail WHERE id_document = '58769' 15/06/2022 10:47: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 ( '58769' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 15/06/2022 10:47:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 15/06/2022 10:47:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 15/06/2022 10:47: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 ( '58769' , '19629' , 'SEGNALIBRO sacro cuore - 109' , '1' , '-1' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '0.15' ) 15/06/2022 10:47:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '19629' AND id_supplier = '' 15/06/2022 10:47:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19629' , '' , '1' ) 15/06/2022 10:47: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 ( '58769' , '17006' , 'SEGNALIBRO PR' , '5' , '-5' , '1' , '0.35' , '0.28688524590164' , '22' , '0' , '1.75' ) 15/06/2022 10:47:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '17006' AND id_supplier = '' 15/06/2022 10:47:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17006' , '' , '1' ) 15/06/2022 10:47: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 ( '58769' , '19629' , 'SEGNALIBRO sacro cuore - 109' , '1' , '-1' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '0.15' ) 15/06/2022 10:47:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '19629' AND id_supplier = '' 15/06/2022 10:47:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19629' , '' , '1' ) 15/06/2022 10:47:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58769' , '19468' , 'CORONA DELLE ROSE BIGLIETTO - 31111' , '1' , '-1' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '0.20' ) 15/06/2022 10:47:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '19468' AND id_supplier = '' 15/06/2022 10:47:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19468' , '' , '1' ) 15/06/2022 10:47:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58769' , '9797' , 'SEGNALIBRO CRESIMA - 95-26 - OGGETTI' , '2' , '-2' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '0.50' ) 15/06/2022 10:47:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '9797' AND id_supplier = '' 15/06/2022 10:47:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9797' , '' , '1' ) 15/06/2022 10:47:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58769' , '4402' , 'GESÙ CONFIDO IN TE - 111' , '1' , '-1' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '0.15' ) 15/06/2022 10:47:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '4402' AND id_supplier = '' 15/06/2022 10:47:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4402' , '' , '1' ) 15/06/2022 10:47:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58769' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '0.5' , '0.5' , '0' , '0' , '0.50' ) 15/06/2022 10:47:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 15/06/2022 10:47:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 15/06/2022 10:48:08 am >> SELECT document_num FROM ps_document WHERE document_num = '1926' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-15') 15/06/2022 10:48: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' , '1926' , '2022-06-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.80' , '2.30' , NOW() , NOW() ) 15/06/2022 10:48: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 = '58770' 15/06/2022 10:48:08 am >> DELETE FROM ps_document_detail WHERE id_document = '58770' 15/06/2022 10:48: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 ( '58770' , '9695' , 'SCAPOLARE IN STOFFA ROSSA - 1280 ' , '2' , '-2' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '2.80' ) 15/06/2022 10:48:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '9695' AND id_supplier = '' 15/06/2022 10:48:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9695' , '' , '1' ) 15/06/2022 10:50:18 am >> SELECT document_num FROM ps_document WHERE document_num = '1927' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-15') 15/06/2022 10:50:18 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' , '1927' , '2022-06-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '8.17' , NOW() , NOW() ) 15/06/2022 10:50:18 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 = '58771' 15/06/2022 10:50:18 am >> DELETE FROM ps_document_detail WHERE id_document = '58771' 15/06/2022 10:50: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 ( '58771' , '19090' , 'OSTIA MAGNA 170 - OM170' , '1' , '-1' , '3' , '8.50' , '8.1730769230769' , '4' , '0' , '8.50' ) 15/06/2022 10:50:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '19090' AND id_supplier = '' 15/06/2022 10:50:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19090' , '' , '1' ) 15/06/2022 10:57:10 am >> SELECT document_num FROM ps_document WHERE document_num = '1928' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-15') 15/06/2022 10:57:10 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' , '1928' , '2022-06-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.20' , '10.00' , NOW() , NOW() ) 15/06/2022 10:57:10 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 = '58772' 15/06/2022 10:57:10 am >> DELETE FROM ps_document_detail WHERE id_document = '58772' 15/06/2022 10:57:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58772' , '16252' , 'CUORE PENDENTE' , '1' , '-1' , '1' , '12.20' , '10' , '22' , '0' , '12.20' ) 15/06/2022 10:57:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '16252' AND id_supplier = '' 15/06/2022 10:57:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16252' , '' , '1' ) 15/06/2022 10:58:34 am >> SELECT document_num FROM ps_document WHERE document_num = '1929' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-15') 15/06/2022 10:58:34 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' , '1929' , '2022-06-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.40' , '46.23' , NOW() , NOW() ) 15/06/2022 10:58:34 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 = '58773' 15/06/2022 10:58:34 am >> DELETE FROM ps_document_detail WHERE id_document = '58773' 15/06/2022 10:58:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58773' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 15/06/2022 10:58:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 15/06/2022 10:58:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 15/06/2022 11:02:48 am >> SELECT document_num FROM ps_document WHERE document_num = '1930' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-15') 15/06/2022 11:02:48 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' , '1930' , '2022-06-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.61' , '40.58' , NOW() , NOW() ) 15/06/2022 11:02:48 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 = '58774' 15/06/2022 11:02:48 am >> DELETE FROM ps_document_detail WHERE id_document = '58774' 15/06/2022 11:02:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58774' , '18012' , 'NOVENA AL SACRO CUORE DI GESU - 8020' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 15/06/2022 11:02:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '18012' AND id_supplier = '' 15/06/2022 11:02:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18012' , '' , '1' ) 15/06/2022 11:02:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58774' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '1' , '-1' , '1' , '36.00' , '29.508196721311' , '22' , '0' , '36.00' ) 15/06/2022 11:02:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '19396' AND id_supplier = '' 15/06/2022 11:02:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19396' , '' , '1' ) 15/06/2022 11:02:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58774' , '19636' , 'PREGHIAMO CON I SALMI' , '1' , '-1' , '4' , '5.90' , '5.9' , '0' , '5' , '5.61' ) 15/06/2022 11:02:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '19636' AND id_supplier = '' 15/06/2022 11:02:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19636' , '' , '1' ) 15/06/2022 11:02:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58774' , '18138' , 'PORTACHIAVI DECINA CROCE - S46' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 15/06/2022 11:02:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '18138' AND id_supplier = '' 15/06/2022 11:02:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18138' , '' , '1' ) 15/06/2022 11:05:30 am >> SELECT document_num FROM ps_document WHERE document_num = '1931' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-15') 15/06/2022 11:05:30 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' , '1931' , '2022-06-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.23' , NOW() , NOW() ) 15/06/2022 11:05:30 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 = '58775' 15/06/2022 11:05:30 am >> DELETE FROM ps_document_detail WHERE id_document = '58775' 15/06/2022 11:05:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58775' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 15/06/2022 11:05:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '4697' AND id_supplier = '' 15/06/2022 11:05:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4697' , '' , '1' ) 15/06/2022 11:05:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58775' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1' , '1' , '0' , '0' , '1.00' ) 15/06/2022 11:05:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 15/06/2022 11:05:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 15/06/2022 11:17:42 am >> SELECT document_num FROM ps_document WHERE document_num = '1932' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-15') 15/06/2022 11:17:42 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' , '1932' , '2022-06-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '1.64' , NOW() , NOW() ) 15/06/2022 11:17:42 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 = '58776' 15/06/2022 11:17:42 am >> DELETE FROM ps_document_detail WHERE id_document = '58776' 15/06/2022 11:17:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58776' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2' , '1.6393442622951' , '22' , '0' , '2.00' ) 15/06/2022 11:17:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 15/06/2022 11:17:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 15/06/2022 11:18:17 am >> SELECT document_num FROM ps_document WHERE document_num = '1933' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-15') 15/06/2022 11:18:17 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1933' , '2022-06-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.05' , NOW() , NOW() ) 15/06/2022 11:18:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58777' 15/06/2022 11:18:17 am >> DELETE FROM ps_document_detail WHERE id_document = '58777' 15/06/2022 11:18:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58777' , '15335' , 'CANDELA VOTIVA 20X40 DECORATA' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 15/06/2022 11:18:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '15335' AND id_supplier = '' 15/06/2022 11:18:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15335' , '' , '1' ) 15/06/2022 11:38:31 am >> SELECT document_num FROM ps_document WHERE document_num = '1934' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-15') 15/06/2022 11:38:31 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' , '1934' , '2022-06-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '10.66' , NOW() , NOW() ) 15/06/2022 11:38:31 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 = '58778' 15/06/2022 11:38:31 am >> DELETE FROM ps_document_detail WHERE id_document = '58778' 15/06/2022 11:38:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58778' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '13' , '10.655737704918' , '22' , '0' , '13.00' ) 15/06/2022 11:38:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 15/06/2022 11:38:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 15/06/2022 11:46:30 am >> SELECT document_num FROM ps_document WHERE document_num = '1935' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-15') 15/06/2022 11:46:30 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' , '1935' , '2022-06-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '109.50' , '91.76' , NOW() , NOW() ) 15/06/2022 11:46:30 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 = '58779' 15/06/2022 11:46:30 am >> DELETE FROM ps_document_detail WHERE id_document = '58779' 15/06/2022 11:46:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58779' , '11151' , 'LIBRI' , '3' , '-3' , '4' , '3.7' , '3.7' , '0' , '0' , '11.10' ) 15/06/2022 11:46:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 15/06/2022 11:46:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 15/06/2022 11:46:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58779' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '7' , '5.7377049180328' , '22' , '0' , '42.00' ) 15/06/2022 11:46:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 15/06/2022 11:46:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 15/06/2022 11:46:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58779' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 15/06/2022 11:46:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 15/06/2022 11:46:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 15/06/2022 11:54:39 am >> SELECT document_num FROM ps_document WHERE document_num = '1936' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-15') 15/06/2022 11:54:39 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1936' , '2022-06-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '269.50' , '230.50' , NOW() , NOW() ) 15/06/2022 11:54:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58780' 15/06/2022 11:54:39 am >> DELETE FROM ps_document_detail WHERE id_document = '58780' 15/06/2022 11:54:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58780' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 15/06/2022 11:54:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 15/06/2022 11:54:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 15/06/2022 11:54:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58780' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 15/06/2022 11:54:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 15/06/2022 11:54:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 15/06/2022 11:54:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58780' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '5' , '-5' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '20.00' ) 15/06/2022 11:54:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 15/06/2022 11:54:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 15/06/2022 11:54:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58780' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '7' , '5.7377049180328' , '22' , '0' , '42.00' ) 15/06/2022 11:54:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 15/06/2022 11:54:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 15/06/2022 11:54:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58780' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 15/06/2022 11:54:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 15/06/2022 11:54:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 15/06/2022 11:54:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58780' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 15/06/2022 11:54:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 15/06/2022 11:54:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 15/06/2022 11:54:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58780' , '12685' , 'SACRO CUORE - 209' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 15/06/2022 11:54:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '12685' AND id_supplier = '' 15/06/2022 11:54:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12685' , '' , '1' ) 15/06/2022 11:54:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58780' , '9333' , 'SACRO CUORE DI GESÙ - 208 ' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 15/06/2022 11:54:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '9333' AND id_supplier = '' 15/06/2022 11:54:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9333' , '' , '1' ) 15/06/2022 11:54:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58780' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '3' , '-3' , '4' , '0.70' , '0.7' , '0' , '0' , '2.10' ) 15/06/2022 11:54:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 15/06/2022 11:54:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 15/06/2022 12:11:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '1937' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-15') 15/06/2022 12:11:04 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1937' , '2022-06-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '115.00' , '96.61' , NOW() , NOW() ) 15/06/2022 12:11:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58781' 15/06/2022 12:11:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '58781' 15/06/2022 12:11: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 ( '58781' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '1' , '-1' , '1' , '36.00' , '29.508196721311' , '22' , '0' , '36.00' ) 15/06/2022 12:11:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19396' AND id_supplier = '' 15/06/2022 12:11:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19396' , '' , '1' ) 15/06/2022 12:11: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 ( '58781' , '2177' , 'CLERGY BASIC - MM - B&P' , '2' , '-2' , '1' , '33.00' , '27.049180327869' , '22' , '0' , '66.00' ) 15/06/2022 12:11:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2177' AND id_supplier = '' 15/06/2022 12:11:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2177' , '' , '1' ) 15/06/2022 12:11: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 ( '58781' , '8368' , 'PREGHIERE DI LIBERAZIONE - DIVINA MISERICORDIA' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 15/06/2022 12:11:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8368' AND id_supplier = '' 15/06/2022 12:11:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8368' , '' , '1' ) 15/06/2022 12:11: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 ( '58781' , '19526' , 'POSTA DELLANIMA - R. CANTALAMESSA' , '1' , '-1' , '4' , '11.5' , '11.5' , '0' , '0' , '11.50' ) 15/06/2022 12:11:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19526' AND id_supplier = '' 15/06/2022 12:11:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19526' , '' , '1' ) 15/06/2022 12:13:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '1938' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-15') 15/06/2022 12:13:10 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1938' , '2022-06-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.69' , '20.69' , NOW() , NOW() ) 15/06/2022 12:13:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58782' 15/06/2022 12:13:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '58782' 15/06/2022 12:13:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58782' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 15/06/2022 12:13:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16050' AND id_supplier = '' 15/06/2022 12:13:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16050' , '' , '1' ) 15/06/2022 12:13:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58782' , '15251' , 'FATE QUESTO IN MEMORIA DI ME' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 15/06/2022 12:13:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15251' AND id_supplier = '' 15/06/2022 12:13:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15251' , '' , '1' ) 15/06/2022 12:13:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58782' , '16425' , 'IO HO SCELTO VOI - CAT. GIOVANI 1' , '1' , '-1' , '4' , '6.46' , '6.46' , '0' , '5' , '6.14' ) 15/06/2022 12:13:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16425' AND id_supplier = '' 15/06/2022 12:13:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16425' , '' , '1' ) 15/06/2022 12:13:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58782' , '11202' , 'VENITE E VEDRETE CAT.' , '1' , '-1' , '4' , '9.30' , '9.3' , '0' , '5' , '8.84' ) 15/06/2022 12:13:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11202' AND id_supplier = '' 15/06/2022 12:13:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11202' , '' , '1' ) 15/06/2022 12:27:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '1939' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-15') 15/06/2022 12:27:51 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1939' , '2022-06-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '140.00' , '123.32' , NOW() , NOW() ) 15/06/2022 12:27:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58783' 15/06/2022 12:27:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '58783' 15/06/2022 12:27:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58783' , '3074' , 'CROCE PRIMA COMUNIONE LEGNO CHIARO - 713/11' , '10' , '-10' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '12.00' ) 15/06/2022 12:27:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3074' AND id_supplier = '' 15/06/2022 12:27:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3074' , '' , '1' ) 15/06/2022 12:27:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58783' , '6058' , 'MADONNA DEL CARMINE - 117 BIS ' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 15/06/2022 12:27:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6058' AND id_supplier = '' 15/06/2022 12:27:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6058' , '' , '1' ) 15/06/2022 12:27:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58783' , '6353' , 'MEDAGLIA S. BENEDETTO SMALTATA - M016' , '20' , '-20' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '22.00' ) 15/06/2022 12:27:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6353' AND id_supplier = '' 15/06/2022 12:27:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6353' , '' , '1' ) 15/06/2022 12:27: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 ( '58783' , '19644' , 'CHIESA CHE VERRA - A. MATTEO' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 15/06/2022 12:27:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19644' AND id_supplier = '' 15/06/2022 12:27:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19644' , '' , '1' ) 15/06/2022 12:27: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 ( '58783' , '19334' , 'INSEGNACI A PREGARE - J. MARTIN' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 15/06/2022 12:27:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19334' AND id_supplier = '' 15/06/2022 12:27:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19334' , '' , '1' ) 15/06/2022 12:27: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 ( '58783' , '19131' , 'VIVI CRESCI AMA - M. DANIELI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 15/06/2022 12:27:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19131' AND id_supplier = '' 15/06/2022 12:27:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19131' , '' , '1' ) 15/06/2022 12:27: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 ( '58783' , '19597' , 'MEDAGLIA SAN BENEDETTO ARG. RA631' , '1' , '-1' , '1' , '15.8' , '12.950819672131' , '22' , '0' , '15.80' ) 15/06/2022 12:27:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19597' AND id_supplier = '' 15/06/2022 12:27:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19597' , '' , '1' ) 15/06/2022 12:27: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 ( '58783' , '19596' , 'MEDAGLIA SAN BENEDETTO ARG. RA630' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 15/06/2022 12:27:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19596' AND id_supplier = '' 15/06/2022 12:27:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19596' , '' , '1' ) 15/06/2022 12:27: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 ( '58783' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 15/06/2022 12:27:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17161' AND id_supplier = '' 15/06/2022 12:27:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17161' , '' , '1' ) 15/06/2022 12:27: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 ( '58783' , '19301' , 'VERGINE DEL SILENZIO - 8068' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 15/06/2022 12:27:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19301' AND id_supplier = '' 15/06/2022 12:27:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19301' , '' , '1' ) 15/06/2022 12:27: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 ( '58783' , '19629' , 'SEGNALIBRO sacro cuore - 109' , '78' , '-78' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '11.70' ) 15/06/2022 12:27:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19629' AND id_supplier = '' 15/06/2022 12:27:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19629' , '' , '1' ) 15/06/2022 12:31:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '1940' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-15') 15/06/2022 12:31:05 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' , '1940' , '2022-06-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.75' , '23.75' , NOW() , NOW() ) 15/06/2022 12:31:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58784' 15/06/2022 12:31:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '58784' 15/06/2022 12:31:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58784' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 15/06/2022 12:31:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 15/06/2022 12:31:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 15/06/2022 12:31:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58784' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '5' , '14.25' ) 15/06/2022 12:31:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 15/06/2022 12:31:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 15/06/2022 12:39:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '1941' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-15') 15/06/2022 12:39:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1941' , '2022-06-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 15/06/2022 12:39:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58785' 15/06/2022 12:39:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '58785' 15/06/2022 12:39:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58785' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 15/06/2022 12:39:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15387' AND id_supplier = '' 15/06/2022 12:39:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15387' , '' , '1' ) 15/06/2022 12:39:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58785' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 15/06/2022 12:39:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 15/06/2022 12:39:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 15/06/2022 12:39:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58785' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 15/06/2022 12:39:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19107' AND id_supplier = '' 15/06/2022 12:39:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19107' , '' , '1' ) 15/06/2022 12:42:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '1111' AND id_document != '54724' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-13') 15/06/2022 12:42:34 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1111', document_date = '2022-04-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 = '85.00', price_tax_excluded = '69.67', date_upd = NOW() WHERE id_document = '54724' 15/06/2022 12:42:34 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 = '54724' 15/06/2022 12:42:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '54724' 15/06/2022 12:42:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54724' , '13873' , 'CLERGY TESS. BOSTON - BLU - MISTO ML 44' , '1' , '-1' , '1' , '50.0000' , '40.983606557377' , '22' , '0' , '50.00' ) 15/06/2022 12:42:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13873' AND id_supplier = '' 15/06/2022 12:42:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13873' , '' , '1' ) 15/06/2022 12:42:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54724' , '18620' , 'MEDAGLIA MIRACOLOSA BLU PICCOLA - 022M/SM' , '6' , '-6' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '3.00' ) 15/06/2022 12:42:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18620' AND id_supplier = '' 15/06/2022 12:42:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18620' , '' , '1' ) 15/06/2022 12:42:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '54724' , '3136' , 'CROCE TAU MURANO DOPPIA FOGLIA ARG. CM 25' , '1' , '-1' , '1' , '32.00' , '26.229508196721' , '22' , '0' , '32.00' ) 15/06/2022 12:42:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3136' AND id_supplier = '' 15/06/2022 12:42:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3136' , '' , '1' ) 15/06/2022 03:10:31 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400032833' AND id_product != '9695' AND ean13 != '' 15/06/2022 03:10:31 pm >> UPDATE ps_product SET id_supplier = '28', reference = '2013', ean13 = '8058400032833', date_upd = NOW() WHERE id_product = '9695' 15/06/2022 03:10:31 pm >> UPDATE ps_product_lang SET name = 'SCAPOLARE SACRO CUORE - 1280 ', description = '' WHERE id_product = '9695' 15/06/2022 03:10:32 pm >> UPDATE ps_product SET wholesale_price = '0.52', on_sale = '0', price = '1.1475' WHERE id_product = '9695' 15/06/2022 03:10:32 pm >> UPDATE ps_product_shop SET wholesale_price = '0.52', price = '1.1475', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9695' 15/06/2022 03:10:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '9695' 15/06/2022 03:11:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '1922' AND id_document != '58766' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-15') 15/06/2022 03:11:32 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1922', document_date = '2022-06-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '108.30', price_tax_excluded = '93.37', date_upd = NOW() WHERE id_document = '58766' 15/06/2022 03:11:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58766' 15/06/2022 03:11:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '58766' 15/06/2022 03:11:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58766' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 15/06/2022 03:11:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 15/06/2022 03:11:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 15/06/2022 03:11:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58766' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '3' , '-3' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '19.50' ) 15/06/2022 03:11:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11757' AND id_supplier = '' 15/06/2022 03:11:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11757' , '' , '1' ) 15/06/2022 03:11:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58766' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 15/06/2022 03:11:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 15/06/2022 03:11:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 15/06/2022 03:11:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58766' , '7311' , 'OSTIA SOTTILE 74MM' , '6' , '-6' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '11.40' ) 15/06/2022 03:11:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 15/06/2022 03:11:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 15/06/2022 03:14:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '1918' AND id_document != '58761' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-14') 15/06/2022 03:14:12 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1918', document_date = '2022-06-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '18.75', price_tax_excluded = '16.35', date_upd = NOW() WHERE id_document = '58761' 15/06/2022 03:14: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 = '58761' 15/06/2022 03:14:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '58761' 15/06/2022 03:14: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 ( '58761' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '9.80' ) 15/06/2022 03:14:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 15/06/2022 03:14:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 15/06/2022 03:14: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 ( '58761' , '12685' , 'SACRO CUORE - 209' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 15/06/2022 03:14:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12685' AND id_supplier = '' 15/06/2022 03:14:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12685' , '' , '1' ) 15/06/2022 03:14: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 ( '58761' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.7000' , '0.7' , '0' , '0' , '0.70' ) 15/06/2022 03:14:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 15/06/2022 03:14:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 15/06/2022 03:14: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 ( '58761' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 15/06/2022 03:14:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 15/06/2022 03:14:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 15/06/2022 03:54:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001954' AND id_product != '19398' AND ean13 != '' 15/06/2022 03:54:59 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001954', date_upd = NOW() WHERE id_product = '19398' 15/06/2022 03:54:59 pm >> UPDATE ps_product_lang SET name = 'CLERGY COTONE 100% MM - C02', description = '' WHERE id_product = '19398' 15/06/2022 03:54:59 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '31.557377049180328' WHERE id_product = '19398' 15/06/2022 03:54:59 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '31.557377049180328', id_tax_rules_group = '1', id_category_default = '462', 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 = '19398' 15/06/2022 03:54:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '19398' 15/06/2022 03:59:44 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001951' AND id_product != '19395' AND ean13 != '' 15/06/2022 03:59:44 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001951', date_upd = NOW() WHERE id_product = '19395' 15/06/2022 03:59:44 pm >> UPDATE ps_product_lang SET name = 'CLERGY MISTO COTONE ML - C01', description = '' WHERE id_product = '19395' 15/06/2022 03:59:44 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '29.508196721311474' WHERE id_product = '19395' 15/06/2022 03:59:44 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '29.508196721311474', id_tax_rules_group = '1', id_category_default = '462', 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 = '19395' 15/06/2022 03:59:44 pm >> DELETE FROM ps_specific_price WHERE id_product = '19395' 15/06/2022 04:01:18 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001951' AND id_product != '19395' AND ean13 != '' 15/06/2022 04:01:18 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001951', date_upd = NOW() WHERE id_product = '19395' 15/06/2022 04:01:18 pm >> UPDATE ps_product_lang SET name = 'CLERGY MISTO COTONE ML - C01', description = '' WHERE id_product = '19395' 15/06/2022 04:01:18 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '30.327868852459016' WHERE id_product = '19395' 15/06/2022 04:01:18 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '30.327868852459016', id_tax_rules_group = '1', id_category_default = '462', 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 = '19395' 15/06/2022 04:01:18 pm >> DELETE FROM ps_specific_price WHERE id_product = '19395' 15/06/2022 04:01:57 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001859' AND id_product != '18984' AND ean13 != '' 15/06/2022 04:01:57 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001859', date_upd = NOW() WHERE id_product = '18984' 15/06/2022 04:01:57 pm >> UPDATE ps_product_lang SET name = 'POLO FELPATO ML ', description = '' WHERE id_product = '18984' 15/06/2022 04:01:57 pm >> UPDATE ps_product SET wholesale_price = '24.30', on_sale = '0', price = '48.3607' WHERE id_product = '18984' 15/06/2022 04:01:57 pm >> UPDATE ps_product_shop SET wholesale_price = '24.30', price = '48.3607', id_tax_rules_group = '1', id_category_default = '462', 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 = '18984' 15/06/2022 04:01:57 pm >> DELETE FROM ps_specific_price WHERE id_product = '18984' 15/06/2022 04:03:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001653' AND id_product != '19606' AND ean13 != '' 15/06/2022 04:03:07 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001653', date_upd = NOW() WHERE id_product = '19606' 15/06/2022 04:03:07 pm >> UPDATE ps_product_lang SET name = 'SOTTOTALARE MISTO COTONE- C15', description = '' WHERE id_product = '19606' 15/06/2022 04:03:07 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '31.147540983606557' WHERE id_product = '19606' 15/06/2022 04:03:07 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '31.147540983606557', id_tax_rules_group = '1', id_category_default = '462', 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 = '19606' 15/06/2022 04:03:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '19606' 15/06/2022 04:03:20 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001761' AND id_product != '18368' AND ean13 != '' 15/06/2022 04:03:21 pm >> UPDATE ps_product SET id_supplier = '137', reference = '', ean13 = '001761', date_upd = NOW() WHERE id_product = '18368' 15/06/2022 04:03:21 pm >> UPDATE ps_product_lang SET name = 'TUNICA PRIMA COMUNIONE BORDO ORO', description = '' WHERE id_product = '18368' 15/06/2022 04:03:21 pm >> UPDATE ps_product SET wholesale_price = '19.50', on_sale = '0', price = '40.98360655737705' WHERE id_product = '18368' 15/06/2022 04:03:21 pm >> UPDATE ps_product_shop SET wholesale_price = '19.50', price = '40.98360655737705', id_tax_rules_group = '1', id_category_default = '462', 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 = '18368' 15/06/2022 04:03:21 pm >> DELETE FROM ps_specific_price WHERE id_product = '18368' 15/06/2022 04:05:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001653' AND id_product != '19606' AND ean13 != '' 15/06/2022 04:05:27 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001653', date_upd = NOW() WHERE id_product = '19606' 15/06/2022 04:05:27 pm >> UPDATE ps_product_lang SET name = 'CAMICIA SOTTOTALARE MISTO COTONE- C15', description = '' WHERE id_product = '19606' 15/06/2022 04:05:27 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '31.1475' WHERE id_product = '19606' 15/06/2022 04:05:27 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '31.1475', id_tax_rules_group = '1', id_category_default = '462', 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 = '19606' 15/06/2022 04:05:27 pm >> DELETE FROM ps_specific_price WHERE id_product = '19606' 15/06/2022 04:33:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '1942' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-15') 15/06/2022 04:33:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1942' , '2022-06-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '258.00' , '211.48' , NOW() , NOW() ) 15/06/2022 04:33:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58786' 15/06/2022 04:33:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '58786' 15/06/2022 04:33:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58786' , '16494' , 'CLERGY JEANSATA ML MISTO - C01/J' , '3' , '-3' , '1' , '39.4' , '32.295081967213' , '22' , '0' , '118.20' ) 15/06/2022 04:33:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16494' AND id_supplier = '' 15/06/2022 04:33:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16494' , '' , '1' ) 15/06/2022 04:33:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58786' , '17101' , 'CASULA POLIESTERE CROCE ORO - AECU04' , '2' , '-2' , '1' , '69.9' , '57.295081967213' , '22' , '0' , '139.80' ) 15/06/2022 04:33:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17101' AND id_supplier = '' 15/06/2022 04:33:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17101' , '' , '1' ) 15/06/2022 04:57:38 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '3127/00' , '2022-05-30' , '00' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RIENTRO' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2960.00' , '2960.00' , NOW() , NOW() ) 15/06/2022 04:57:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '5370' 15/06/2022 04:57:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '5370' 15/06/2022 04:57:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5370' , '131' , 'LIBRO AGENDA CATTOLICO 2022' , '185' , '185' , '4' , '16.00' , '16' , '0' , '0' , '2960.0000' ) 15/06/2022 05:03:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '18/A' AND id_document != '53221' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-03-12') 15/06/2022 05:03:13 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '18/A', document_date = '2022-03-12', document_letter = 'A', id_customer = '3812', id_supplier = '', id_address = '4672633', address1 = 'LARGO PLEBISCITO 12 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 = '607.70', price_tax_excluded = '503.40', date_upd = NOW() WHERE id_document = '53221' 15/06/2022 05:03: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 = '53221' 15/06/2022 05:03:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '53221' 15/06/2022 05:03: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 ( '53221' , '17161' , 'CARBONCINI NERI - CARNE' , '3' , '-3' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '33.00' ) 15/06/2022 05:03:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17161' AND id_supplier = '' 15/06/2022 05:03:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17161' , '' , '1' ) 15/06/2022 05:03: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 ( '53221' , '19102' , 'CARBONCINI MM 40' , '2' , '-2' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '26.00' ) 15/06/2022 05:03:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19102' AND id_supplier = '' 15/06/2022 05:03:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19102' , '' , '1' ) 15/06/2022 05:03: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 ( '53221' , '7311' , 'OSTIA SOTTILE 74MM' , '15' , '-15' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '28.50' ) 15/06/2022 05:03:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 15/06/2022 05:03:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 15/06/2022 05:03: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 ( '53221' , '7673' , 'PARTICOLE MM38' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 15/06/2022 05:03:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7673' AND id_supplier = '' 15/06/2022 05:03:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7673' , '' , '1' ) 15/06/2022 05:03: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 ( '53221' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 15/06/2022 05:03:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 15/06/2022 05:03:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 15/06/2022 05:03: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 ( '53221' , '18095' , 'CROCE IN ULIVO - 2882' , '5' , '-5' , '1' , '24.8000' , '20.327868852459' , '22' , '0' , '124.00' ) 15/06/2022 05:03:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18095' AND id_supplier = '' 15/06/2022 05:03:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18095' , '' , '1' ) 15/06/2022 05:03: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 ( '53221' , '17005' , 'BIGLIETTO AUGURALE medio' , '13' , '-13' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '13.00' ) 15/06/2022 05:03:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17005' AND id_supplier = '' 15/06/2022 05:03:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17005' , '' , '1' ) 15/06/2022 05:03: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 ( '53221' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '270.00' ) 15/06/2022 05:03:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 15/06/2022 05:03:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 15/06/2022 05:03: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 ( '53221' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '46.0000' , '37.704918032787' , '22' , '0' , '46.00' ) 15/06/2022 05:03:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19099' AND id_supplier = '' 15/06/2022 05:03:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19099' , '' , '1' ) 15/06/2022 05:03: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 ( '53221' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '3' , '-3' , '1' , '0.8000' , '0.65573770491803' , '22' , '0' , '2.40' ) 15/06/2022 05:03:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17004' AND id_supplier = '' 15/06/2022 05:03:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17004' , '' , '1' ) 15/06/2022 05:03: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 ( '53221' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.70' , '0.7' , '0' , '0' , '1.40' ) 15/06/2022 05:03:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 15/06/2022 05:03:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 15/06/2022 05:10:27 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '3126/00' , '2022-05-30' , '00' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RIENTRO' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '711.30' , '711.30' , NOW() , NOW() ) 15/06/2022 05:10:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '5371' 15/06/2022 05:10:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '5371' 15/06/2022 05:10:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5371' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 15/06/2022 05:10:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5371' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 15/06/2022 05:10:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5371' , '126' , 'SACRAMENTO DEL PERDONO' , '1' , '1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 15/06/2022 05:10:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5371' , '38' , 'MADRE TERESA, UNA MISSIONARIA' , '1' , '1' , '4' , '2.60' , '2.6' , '0' , '0' , '2.60' ) 15/06/2022 05:10:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5371' , '71' , 'San Francesco dAssisi raccontato ai ragazzi + DVD' , '1' , '1' , '4' , '13.00' , '13' , '0' , '0' , '13.00' ) 15/06/2022 05:10:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5371' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '4' , '4' , '4' , '2.00' , '2' , '0' , '0' , '8.0000' ) 15/06/2022 05:10:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5371' , '116' , 'DIZIONARIO DEI SIMBOLI DEL PICCOLO CRISTIANO NE' , '19' , '19' , '4' , '2.50' , '2.5' , '0' , '0' , '47.5000' ) 15/06/2022 05:10:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5371' , '52' , 'Il Padre Nostro spiegato ai bambini' , '43' , '43' , '4' , '2.00' , '2' , '0' , '0' , '86.0000' ) 15/06/2022 05:10:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5371' , '49' , 'GUARDALIBRI:DVD VANGELO PICCOLI' , '1' , '1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 15/06/2022 05:10:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5371' , '66' , 'BEATI GLI INVITATI ALLA CENA DEL SIGNORE' , '5' , '5' , '4' , '6.50' , '6.5' , '0' , '0' , '32.5000' ) 15/06/2022 05:10:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5371' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 15/06/2022 05:10:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5371' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '13' , '13' , '4' , '2.50' , '2.5' , '0' , '0' , '32.5000' ) 15/06/2022 05:10:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5371' , '34' , 'LE MIE PREGHIERINE' , '25' , '25' , '4' , '1.50' , '1.5' , '0' , '0' , '37.5000' ) 15/06/2022 05:10:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5371' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '62' , '62' , '4' , '2.50' , '2.5' , '0' , '0' , '155.0000' ) 15/06/2022 05:10:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5371' , '25' , 'PICCOLO DIZIONARIO DEL CRISTIANO' , '7' , '7' , '4' , '3.00' , '3' , '0' , '0' , '21.0000' ) 15/06/2022 05:10:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5371' , '21' , 'LA COMUNIONE' , '4' , '4' , '4' , '2.00' , '2' , '0' , '0' , '8.0000' ) 15/06/2022 05:10:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5371' , '44' , 'GUARDALIBRI: DVD IL CREDO' , '8' , '8' , '4' , '9.90' , '9.9' , '0' , '0' , '79.2000' ) 15/06/2022 05:10:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5371' , '114' , 'Le preghiere dei ragazzi' , '18' , '18' , '4' , '1.50' , '1.5' , '0' , '0' , '27.0000' ) 15/06/2022 05:10:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5371' , '89' , 'COMUNIONE SPIEGATA AI RAGAZZI' , '1' , '1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 15/06/2022 05:10:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5371' , '74' , 'DIO È , IN DIECI PAROLE' , '1' , '1' , '4' , '4.50' , '4.5' , '0' , '0' , '4.50' ) 15/06/2022 05:10:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5371' , '13' , 'BUSSATE E VI SARÀ APERTO' , '1' , '1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 15/06/2022 05:10:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5371' , '17' , 'LA FEDE NELLO ZAINETTO' , '3' , '3' , '4' , '5.00' , '5' , '0' , '0' , '15.0000' ) 15/06/2022 05:10:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5371' , '20' , 'GIOVEDÌ SANTO' , '2' , '2' , '4' , '1.50' , '1.5' , '0' , '0' , '3.0000' ) 15/06/2022 05:10:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5371' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '1' , '1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 15/06/2022 05:10:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5371' , '113' , 'E\' NATO, ALBUM DA COLORARE' , '1' , '1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 15/06/2022 05:10:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5371' , '103' , 'Lo Spirito Santo raccontato ai ragazzi N.E.' , '3' , '3' , '4' , '2.00' , '2' , '0' , '0' , '6.0000' ) 15/06/2022 05:10:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5371' , '60' , 'IL NATALE SPIEGATO AI BAMBINI' , '31' , '31' , '4' , '2.00' , '2' , '0' , '0' , '62.0000' ) 15/06/2022 05:10:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5371' , '123' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '2' , '2' , '4' , '3.00' , '3' , '0' , '0' , '6.0000' ) 15/06/2022 05:10:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5371' , '117' , 'La preghiera delle cinque dita n.e.' , '2' , '2' , '4' , '1.50' , '1.5' , '0' , '0' , '3.0000' ) 15/06/2022 05:10:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5371' , '47' , 'IL ROSARIO SPIEGATO AI BAMBINI ' , '12' , '12' , '4' , '2.50' , '2.5' , '0' , '0' , '30.0000' ) 15/06/2022 05:10:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5371' , '119' , 'Rosario spiegato ai bambini ' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 15/06/2022 07:06:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '1943' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-15') 15/06/2022 07:06:49 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1943' , '2022-06-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '73.06' , '73.06' , NOW() , NOW() ) 15/06/2022 07:06:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58787' 15/06/2022 07:06:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '58787' 15/06/2022 07:06:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58787' , '12995' , 'SALE, NON MIELE - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 15/06/2022 07:06:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12995' AND id_supplier = '' 15/06/2022 07:06:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12995' , '' , '1' ) 15/06/2022 07:06:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58787' , '16823' , 'SANTO E UN UOMO - A. BELLANDI' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '5' , '12.35' ) 15/06/2022 07:06:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16823' AND id_supplier = '' 15/06/2022 07:06:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16823' , '' , '1' ) 15/06/2022 07:06:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58787' , '19588' , 'SCELTA DI ENEA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 15/06/2022 07:06:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19588' AND id_supplier = '' 15/06/2022 07:06:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19588' , '' , '1' ) 15/06/2022 07:06:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58787' , '18261' , 'PIETRA SCARTATA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 15/06/2022 07:06:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18261' AND id_supplier = '' 15/06/2022 07:06:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18261' , '' , '1' ) 15/06/2022 07:06:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58787' , '19228' , 'DIO CE ED E BELLISSIMO - P. CURTAZ' , '1' , '-1' , '4' , '15.90' , '15.9' , '0' , '5' , '15.11' ) 15/06/2022 07:06:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19228' AND id_supplier = '' 15/06/2022 07:06:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19228' , '' , '1' )