19/06/2023 08:42:23 am >> SELECT document_num FROM ps_document WHERE document_num = '29/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-06-19') 19/06/2023 08:42:23 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 ( '23' , '29/E' , '2023-06-19' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '288.00' , '236.07' , NOW() , NOW() ) 19/06/2023 08:42:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86405' 19/06/2023 08:42:24 am >> DELETE FROM ps_document_detail WHERE id_document = '86405' 19/06/2023 08:42:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86405' , '12816' , 'LIBRO DEI DEFUNTI' , '12' , '-12' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '288.00' ) 19/06/2023 09:56:59 am >> SELECT document_num FROM ps_document WHERE document_num = '2100' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-19') 19/06/2023 09:56:59 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' , '2100' , '2023-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 19/06/2023 09:56:59 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 = '86406' 19/06/2023 09:56:59 am >> DELETE FROM ps_document_detail WHERE id_document = '86406' 19/06/2023 09:56:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86406' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 19/06/2023 10:09:12 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 19/06/2023 10:09:12 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21181' , '1' , '' , 'nuovo-prodotto' ) 19/06/2023 10:09:12 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21181' , '1' , '1' , '2' , NOW() , NOW() ) 19/06/2023 10:09:12 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21181' , '0' , '1' , '0' , '0' ) 19/06/2023 10:11:52 am >> SELECT document_num FROM ps_document WHERE document_num = '2101' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-19') 19/06/2023 10:11:52 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' , '2101' , '2023-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.50' , '17.05' , NOW() , NOW() ) 19/06/2023 10:11:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86407' 19/06/2023 10:11:52 am >> DELETE FROM ps_document_detail WHERE id_document = '86407' 19/06/2023 10:11:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86407' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 19/06/2023 10:11:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86407' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 19/06/2023 10:11:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86407' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 19/06/2023 10:12:26 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873577065' AND id_product != '21181' AND ean13 != '' 19/06/2023 10:12:26 am >> UPDATE ps_product SET id_supplier = '', reference = '1/2', ean13 = '9788873577065', date_upd = NOW() WHERE id_product = '21181' 19/06/2023 10:12:26 am >> UPDATE ps_product_lang SET name = 'CAMMINO DI FORMAZIONE - R. COLIZZI', description = '' WHERE id_product = '21181' 19/06/2023 10:12:26 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '21181' 19/06/2023 10:12:26 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', id_tax_rules_group = '4', id_category_default = '178', id_argoment_default = '86', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21181' 19/06/2023 10:12:26 am >> DELETE FROM ps_specific_price WHERE id_product = '21181' 19/06/2023 10:13:20 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788852606090' AND id_product != '16107' AND ean13 != '' 19/06/2023 10:13:20 am >> UPDATE ps_product SET id_supplier = '107', reference = 'GONDOLA 1', ean13 = '9788852606090', date_upd = NOW() WHERE id_product = '16107' 19/06/2023 10:13:20 am >> UPDATE ps_product_lang SET name = 'VERGINE MADRE, FIGLIA DEL TUO FIGLIO - L. EPICOCO', description = '' WHERE id_product = '16107' 19/06/2023 10:13:20 am >> UPDATE ps_product SET wholesale_price = '3.90', on_sale = '0', price = '6.0000' WHERE id_product = '16107' 19/06/2023 10:13:20 am >> UPDATE ps_product_shop SET wholesale_price = '3.90', price = '6.0000', id_tax_rules_group = '4', id_category_default = '285', 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 = '16107' 19/06/2023 10:13:20 am >> DELETE FROM ps_specific_price WHERE id_product = '16107' 19/06/2023 10:14:40 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '2023000003346' , '2023-06-16' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '6' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '58.95' , '58.95' , NOW() , NOW() ) 19/06/2023 10:14:40 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86408' 19/06/2023 10:14:40 am >> DELETE FROM ps_document_detail WHERE id_document = '86408' 19/06/2023 10:14: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 ( '86408' , '21181' , 'CAMMINO DI FORMAZIONE - R. COLIZZI' , '1' , '1' , '4' , '5.00' , '5' , '0' , '35' , '3.2500' ) 19/06/2023 10:14:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '21181' AND id_supplier = '107' 19/06/2023 10:14:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21181' , '107' , '1' ) 19/06/2023 10:14: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 ( '86408' , '18810' , 'ANTIFONE - E. DELLA CORTE' , '1' , '1' , '4' , '10.00' , '10' , '0' , '35' , '6.5000' ) 19/06/2023 10:14:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '18810' AND id_supplier = '107' 19/06/2023 10:14:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18810' , '107' , '1' ) 19/06/2023 10:14: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 ( '86408' , '19366' , 'DAL CENACOLO AL GIARDINO .. - E. DELLA CORTE' , '1' , '1' , '4' , '10.00' , '10' , '0' , '35' , '6.5000' ) 19/06/2023 10:14:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '19366' AND id_supplier = '107' 19/06/2023 10:14:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19366' , '107' , '1' ) 19/06/2023 10:14: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 ( '86408' , '16107' , 'VERGINE MADRE, FIGLIA DEL TUO FIGLIO - L. EPICOCO' , '2' , '2' , '4' , '6.00' , '6' , '0' , '35' , '7.8000' ) 19/06/2023 10:14:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '16107' AND id_supplier = '107' 19/06/2023 10:14:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16107' , '107' , '1' ) 19/06/2023 10:14: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 ( '86408' , '4229' , 'FONTI FRANCESCANE - ED. MINOR' , '1' , '1' , '4' , '32.00' , '32' , '0' , '30' , '22.4000' ) 19/06/2023 10:14:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '4229' AND id_supplier = '107' 19/06/2023 10:14:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4229' , '107' , '1' ) 19/06/2023 10:14: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 ( '86408' , '19138' , 'ATTO DI ABBANDONO - D. D. RUOTOLO' , '10' , '10' , '4' , '1.00' , '1' , '0' , '35' , '6.5000' ) 19/06/2023 10:14:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '19138' AND id_supplier = '107' 19/06/2023 10:14:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19138' , '107' , '1' ) 19/06/2023 11:02:43 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002148' AND id_product != '21132' AND ean13 != '' 19/06/2023 11:02:43 am >> UPDATE ps_product SET id_supplier = '137', reference = '', ean13 = '002148', date_upd = NOW() WHERE id_product = '21132' 19/06/2023 11:02:43 am >> UPDATE ps_product_lang SET name = 'CLERGY F/F MC - C03', description = '' WHERE id_product = '21132' 19/06/2023 11:02:43 am >> UPDATE ps_product SET wholesale_price = '17.48', on_sale = '0', price = '32.3770' WHERE id_product = '21132' 19/06/2023 11:02:43 am >> UPDATE ps_product_shop SET wholesale_price = '17.48', price = '32.3770', 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 = '21132' 19/06/2023 11:02:43 am >> DELETE FROM ps_specific_price WHERE id_product = '21132' 19/06/2023 11:03:44 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001410' AND id_product != '19607' AND ean13 != '' 19/06/2023 11:03:44 am >> UPDATE ps_product SET id_supplier = '137', reference = '', ean13 = '001410', date_upd = NOW() WHERE id_product = '19607' 19/06/2023 11:03:44 am >> UPDATE ps_product_lang SET name = 'CLERGY F/F ML - C03', description = '' WHERE id_product = '19607' 19/06/2023 11:03:44 am >> UPDATE ps_product SET wholesale_price = '17.77', on_sale = '0', price = '32.7049' WHERE id_product = '19607' 19/06/2023 11:03:44 am >> UPDATE ps_product_shop SET wholesale_price = '17.77', price = '32.7049', 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 = '19607' 19/06/2023 11:03:44 am >> DELETE FROM ps_specific_price WHERE id_product = '19607' 19/06/2023 11:09:20 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000378' AND id_product != '12925' AND ean13 != '' 19/06/2023 11:09:20 am >> UPDATE ps_product SET id_supplier = '20', reference = '', ean13 = '000378', date_upd = NOW() WHERE id_product = '12925' 19/06/2023 11:09:20 am >> UPDATE ps_product_lang SET name = 'CAMICIA PER TALARE - POLSO GEMELLI - C15PG', description = '' WHERE id_product = '12925' 19/06/2023 11:09:20 am >> UPDATE ps_product SET wholesale_price = '17.85', on_sale = '0', price = '36.8852' WHERE id_product = '12925' 19/06/2023 11:09:20 am >> UPDATE ps_product_shop SET wholesale_price = '17.85', price = '36.8852', 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 = '12925' 19/06/2023 11:09:20 am >> DELETE FROM ps_specific_price WHERE id_product = '12925' 19/06/2023 11:11:05 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 = '12925' 19/06/2023 11:11:05 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21182' , '1' , '' , 'nuovo-prodotto' ) 19/06/2023 11:11:05 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 '21182' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '12925' 19/06/2023 11:11:05 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21182' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '12925' 19/06/2023 11:11:17 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 = '12925' 19/06/2023 11:11:17 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21183' , '1' , '' , 'nuovo-prodotto' ) 19/06/2023 11:11:17 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 '21183' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '12925' 19/06/2023 11:11:17 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21183' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '12925' 19/06/2023 11:11:32 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 = '12925' 19/06/2023 11:11:32 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21184' , '1' , '' , 'nuovo-prodotto' ) 19/06/2023 11:11:32 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 '21184' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '12925' 19/06/2023 11:11:32 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21184' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '12925' 19/06/2023 11:12:26 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000374' AND id_product != '21184' AND ean13 != '' 19/06/2023 11:12:26 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000374', date_upd = NOW() WHERE id_product = '21184' 19/06/2023 11:12:26 am >> UPDATE ps_product_lang SET name = 'POLO FILO SCOZIA - M03', description = '' WHERE id_product = '21184' 19/06/2023 11:12:26 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '43.442622950819676' WHERE id_product = '21184' 19/06/2023 11:12:26 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '43.442622950819676', 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 = '21184' 19/06/2023 11:12:26 am >> DELETE FROM ps_specific_price WHERE id_product = '21184' 19/06/2023 11:15:46 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '143' , '2023-06-16' , '' , '0' , '137' , '4670816' , 'VIA G. BATTISTA VICO 73 80010 VILLARICCA' , '' , '' , '18' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '564.15' , '462.42' , NOW() , NOW() ) 19/06/2023 11:15:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86409' 19/06/2023 11:15:46 am >> DELETE FROM ps_document_detail WHERE id_document = '86409' 19/06/2023 11:15:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86409' , '16494' , 'CLERGY JEANSATA ML MISTO - C01/J' , '1' , '1' , '1' , '18.9' , '15.491803278689' , '22' , '6' , '21.6745' ) 19/06/2023 11:15:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '16494' AND id_supplier = '137' 19/06/2023 11:15:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16494' , '137' , '1' ) 19/06/2023 11:15:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86409' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '1' , '1' , '17.5' , '14.344262295082' , '22' , '8' , '19.6420' ) 19/06/2023 11:15:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '19395' AND id_supplier = '137' 19/06/2023 11:15:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19395' , '137' , '1' ) 19/06/2023 11:15:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86409' , '19607' , 'CLERGY F/F ML - C03' , '3' , '3' , '1' , '18.9' , '15.491803278689' , '22' , '6' , '65.0236' ) 19/06/2023 11:15:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '19607' AND id_supplier = '137' 19/06/2023 11:15:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19607' , '137' , '1' ) 19/06/2023 11:15:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86409' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '2' , '2' , '1' , '17.2' , '14.098360655738' , '22' , '8' , '38.6106' ) 19/06/2023 11:15:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '19396' AND id_supplier = '137' 19/06/2023 11:15:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19396' , '137' , '1' ) 19/06/2023 11:15:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86409' , '19605' , 'CLERGY SU MISURA - COCOCLER' , '4' , '4' , '1' , '18.95' , '15.532786885246' , '22' , '8' , '85.0779' ) 19/06/2023 11:15:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '19605' AND id_supplier = '137' 19/06/2023 11:15:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19605' , '137' , '1' ) 19/06/2023 11:15:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86409' , '21132' , 'CLERGY F/F MC - C03' , '11' , '11' , '1' , '18.6' , '15.245901639344' , '22' , '6' , '234.6353' ) 19/06/2023 11:15:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '21132' AND id_supplier = '137' 19/06/2023 11:15:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21132' , '137' , '1' ) 19/06/2023 11:15:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86409' , '12925' , 'CAMICIA PER TALARE - POLSO GEMELLI - C15PG' , '1' , '1' , '1' , '19.6' , '16.065573770492' , '22' , '6' , '22.4773' ) 19/06/2023 11:15:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '12925' AND id_supplier = '137' 19/06/2023 11:15:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12925' , '137' , '1' ) 19/06/2023 11:15:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86409' , '16535' , 'CLERGY MARANGEL ML - C20' , '1' , '1' , '1' , '21' , '17.213114754098' , '22' , '5' , '24.3390' ) 19/06/2023 11:15:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '16535' AND id_supplier = '137' 19/06/2023 11:15:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16535' , '137' , '1' ) 19/06/2023 11:15:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86409' , '21184' , 'POLO FILO SCOZIA - M03' , '1' , '1' , '1' , '26.5' , '21.72131147541' , '22' , '5' , '30.7135' ) 19/06/2023 11:15:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '21184' AND id_supplier = '137' 19/06/2023 11:15:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21184' , '137' , '1' ) 19/06/2023 11:55:42 am >> SELECT document_num FROM ps_document WHERE document_num = '2102' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-19') 19/06/2023 11:55: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' , '2102' , '2023-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.40' , '49.40' , NOW() , NOW() ) 19/06/2023 11:55: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 = '86410' 19/06/2023 11:55:42 am >> DELETE FROM ps_document_detail WHERE id_document = '86410' 19/06/2023 11:55:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86410' , '17864' , 'MESSALE QUOTIDIANO GRANDE - N. E. ' , '1' , '-1' , '4' , '52.00' , '52' , '0' , '5' , '49.40' ) 19/06/2023 12:27:10 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810204733' AND id_product != '17864' AND ean13 != '' 19/06/2023 12:27:10 pm >> UPDATE ps_product SET id_supplier = '109', reference = '7/4', ean13 = '9788810204733', date_upd = NOW() WHERE id_product = '17864' 19/06/2023 12:27:10 pm >> UPDATE ps_product_lang SET name = 'MESSALE QUOTIDIANO GRANDE - N. E. ', description = '' WHERE id_product = '17864' 19/06/2023 12:27:10 pm >> UPDATE ps_product SET wholesale_price = '34.50', on_sale = '0', price = '52.0000' WHERE id_product = '17864' 19/06/2023 12:27:10 pm >> UPDATE ps_product_shop SET wholesale_price = '34.50', price = '52.0000', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '89', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17864' 19/06/2023 12:27:10 pm >> DELETE FROM ps_specific_price WHERE id_product = '17864' 19/06/2023 12:34:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '2103' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-19') 19/06/2023 12:34:41 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2103' , '2023-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.00' , '27.87' , NOW() , NOW() ) 19/06/2023 12:34:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86411' 19/06/2023 12:34:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '86411' 19/06/2023 12:34:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86411' , '14114' , 'CINGOLO ORO - CING08ORO' , '1' , '-1' , '1' , '34.00' , '27.868852459016' , '22' , '0' , '34.00' ) 19/06/2023 12:37:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '2104' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-19') 19/06/2023 12:37:50 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2104' , '2023-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '74.50' , '71.34' , NOW() , NOW() ) 19/06/2023 12:37:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86412' 19/06/2023 12:37:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '86412' 19/06/2023 12:37: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 ( '86412' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '12' , '-12' , '4' , '5.00' , '5' , '0' , '5' , '57.00' ) 19/06/2023 12:37: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 ( '86412' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 19/06/2023 12:37: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 ( '86412' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '3' , '-3' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '10.50' ) 19/06/2023 12:51:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '2105' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-19') 19/06/2023 12:51:41 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2105' , '2023-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '75.00' , '61.48' , NOW() , NOW() ) 19/06/2023 12:51:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86413' 19/06/2023 12:51:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '86413' 19/06/2023 12:51:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86413' , '19594' , 'POLO JERSEY COTONE 100%' , '2' , '-2' , '1' , '37.5' , '30.737704918033' , '22' , '0' , '75.00' ) 19/06/2023 03:10:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '2106' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-19') 19/06/2023 03:10:26 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2106' , '2023-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.00' , '39.34' , NOW() , NOW() ) 19/06/2023 03:10:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86414' 19/06/2023 03:10:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '86414' 19/06/2023 03:10:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86414' , '18128' , 'PETTORINA PER COLLETTI DOPPI - AEPE02N00' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 19/06/2023 03:10:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86414' , '12833' , 'BOTTONE RETROCOLLO - 21630' , '2' , '-2' , '1' , '2.80' , '2.2950819672131' , '22' , '0' , '5.60' ) 19/06/2023 03:10:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86414' , '2425' , 'COLLETTO DOPPIO CM 3,5 IN LINO' , '1' , '-1' , '1' , '22' , '18.032786885246' , '22' , '0' , '22.00' ) 19/06/2023 03:10:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86414' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '7.4' , '6.0655737704918' , '22' , '0' , '7.40' ) 19/06/2023 05:03:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '2107' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-19') 19/06/2023 05:03:48 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' , '2107' , '2023-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.42' , '7.42' , NOW() , NOW() ) 19/06/2023 05:03:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86415' 19/06/2023 05:03:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '86415' 19/06/2023 05:03:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86415' , '20999' , 'AMEN - LUG 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 19/06/2023 05:03:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86415' , '21067' , 'AMEN - AGO 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 19/06/2023 06:17:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '2108' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-19') 19/06/2023 06:17:26 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2108' , '2023-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '197.08' , '166.42' , NOW() , NOW() ) 19/06/2023 06:17:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86416' 19/06/2023 06:17:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '86416' 19/06/2023 06:17:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86416' , '15746' , 'ADORIAMO IL SS SACRAMENTO - VOL 1 - 8958' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 19/06/2023 06:17:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86416' , '17626' , 'ADORIAMO IL SS SACRAMENTO - QUARESIMA - 8202' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 19/06/2023 06:17:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86416' , '17629' , 'ADORIAMO IL SS SACRAMENTO - PASQUA - 8207' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 19/06/2023 06:17:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86416' , '17624' , 'ADORIAMO IL SS SACRAMENTO - AVVENTO E NATALE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 19/06/2023 06:17:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86416' , '8383' , 'PREGHIERE PER LADORAZIONE EUCARISTICA - 8141' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 19/06/2023 06:17:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86416' , '5251' , 'INCONTRI EUCARISTICI' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '5' , '4.28' ) 19/06/2023 06:17:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86416' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '170' , '139.34426229508' , '22' , '0' , '170.00' ) 19/06/2023 06:33:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '2109' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-19') 19/06/2023 06:33:28 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2109' , '2023-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 19/06/2023 06:33:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86417' 19/06/2023 06:33:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '86417' 19/06/2023 06:33: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 ( '86417' , '12467' , 'TAU PRIMA COMUNIONE' , '20' , '-20' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '30.00' ) 19/06/2023 06:39:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '1204' AND id_document != '82748' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-11') 19/06/2023 06:39:18 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1204', document_date = '2023-04-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '15.00', price_tax_excluded = '12.30', date_upd = NOW() WHERE id_document = '82748' 19/06/2023 06:39:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82748' 19/06/2023 06:39:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '82748' 19/06/2023 06:39:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82748' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '15' , '12.295081967213' , '22' , '0' , '15.00' ) 19/06/2023 06:46:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '1919' AND id_document != '85665' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-01') 19/06/2023 06:46:03 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1919', document_date = '2023-06-01', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '85.00', price_tax_excluded = '69.67', date_upd = NOW() WHERE id_document = '85665' 19/06/2023 06:46:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85665' 19/06/2023 06:46:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '85665' 19/06/2023 06:46:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85665' , '14063' , 'STELLARIO PLEX CM 10 / 12' , '1' , '-1' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '11.00' ) 19/06/2023 06:46:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85665' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '1' , '-1' , '1' , '59.0000' , '48.360655737705' , '22' , '0' , '59.00' ) 19/06/2023 06:46:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85665' , '17895' , 'ANELLO FEDI DI SANTA RITA' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 19/06/2023 06:46:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85665' , '20072' , 'BRACCIALE - BC1759N' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 19/06/2023 06:49:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '2110' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-19') 19/06/2023 06:49:40 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2110' , '2023-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '4.92' , NOW() , NOW() ) 19/06/2023 06:49:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86418' 19/06/2023 06:49:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '86418' 19/06/2023 06:49:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86418' , '17005' , 'BIGLIETTO AUGURALE medio' , '3' , '-3' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '3.00' ) 19/06/2023 06:49:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86418' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 19/06/2023 06:49:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86418' , '18619' , 'MEDAGLIA MIRACOLOSA BLU GRANDE - OV40M/SM' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 19/06/2023 06:49:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86418' , '11677' , 'MEDAGLIA MIRACOLOSA - 1311L' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 19/06/2023 07:02:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '2111' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-19') 19/06/2023 07:02:18 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' , '2111' , '2023-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.30' , '17.06' , NOW() , NOW() ) 19/06/2023 07:02:18 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 = '86419' 19/06/2023 07:02:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '86419' 19/06/2023 07:02:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86419' , '11837' , 'MIA PRIMA COMUNIONE' , '2' , '-2' , '4' , '1.50' , '1.5' , '0' , '0' , '3.00' ) 19/06/2023 07:02:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86419' , '21055' , 'MIA PRIMA EUCARISTIA ' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 19/06/2023 07:02:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86419' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '2' , '-2' , '1' , '6.20' , '5.0819672131148' , '22' , '0' , '12.40' )