31/07/2024 08:40:18 am >> SELECT document_num FROM ps_document WHERE document_num = '21' AND id_document != '92760' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2024-07-29') 31/07/2024 08:40:18 am >> UPDATE ps_document SET id_document_type = '24', document_num = '21', document_date = '2024-07-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4679306', address1 = 'VIA CHIESA MADRE 25 84018 SCAFATI', address2 = '', note = 'integra fattura 26/L del 14/12/2023', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '965.00', price_tax_excluded = '965.00', date_upd = NOW() WHERE id_document = '92760' 31/07/2024 08:40: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 = '92760' 31/07/2024 08:40:18 am >> DELETE FROM ps_document_detail WHERE id_document = '92760' 31/07/2024 08:40:19 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 ( '92760' , '21616' , 'CARTEGGIO 1925-1926' , '2' , '-2' , '4' , '29.0000' , '29' , '0' , '0' , '58.00' ) 31/07/2024 08:40:19 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 ( '92760' , '21725' , 'GIOVANNI AMENDOLA UNA VITA ....' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 31/07/2024 08:40:19 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 ( '92760' , '22786' , 'RASSEGNA STORICA SALERNITANA 81' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 31/07/2024 08:40:19 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 ( '92760' , '22787' , 'GIUSEPPE CASALE' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 31/07/2024 08:40:19 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 ( '92760' , '22788' , 'ALBERTA MARESCA' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 31/07/2024 08:40:19 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 ( '92760' , '22789' , 'GIUSEPPE CACCIATORE' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 31/07/2024 08:40:19 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 ( '92760' , '22790' , 'GRAS' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 31/07/2024 08:40:19 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 ( '92760' , '22792' , 'STUDIIS FLORENS' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '0' , '30.00' ) 31/07/2024 08:40:19 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 ( '92760' , '22793' , 'RINVENIMENTI MONETALI' , '1' , '-1' , '4' , '59.0000' , '59' , '0' , '0' , '59.00' ) 31/07/2024 08:40:19 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 ( '92760' , '22794' , 'PROFUMI NELLE SOCIETA ANTICHE' , '1' , '-1' , '4' , '36.0000' , '36' , '0' , '0' , '36.00' ) 31/07/2024 08:40:19 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 ( '92760' , '22795' , 'LONGO' , '1' , '-1' , '4' , '48.0000' , '48' , '0' , '0' , '48.00' ) 31/07/2024 08:40:19 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 ( '92760' , '22795' , 'POTRANDOLFO' , '1' , '-1' , '4' , '26.0000' , '26' , '0' , '0' , '26.00' ) 31/07/2024 08:40:19 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 ( '92760' , '22797' , 'FRATTE' , '1' , '-1' , '4' , '38.0000' , '38' , '0' , '0' , '38.00' ) 31/07/2024 08:40:19 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 ( '92760' , '22798' , 'FRATTE LE TERRECOTTE' , '1' , '-1' , '4' , '38.0000' , '38' , '0' , '0' , '38.00' ) 31/07/2024 08:40:19 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 ( '92760' , '22799' , 'CUOZZO' , '1' , '-1' , '4' , '65.0000' , '65' , '0' , '0' , '65.00' ) 31/07/2024 08:40:19 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 ( '92760' , '22800' , 'DIALOGHI SULL\'ARCHEOLOGIA' , '1' , '-1' , '4' , '120.0000' , '120' , '0' , '0' , '120.00' ) 31/07/2024 08:40:19 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 ( '92760' , '22801' , 'DIALOGHI SULLARCHEOLOGIA II' , '1' , '-1' , '4' , '180.0000' , '180' , '0' , '0' , '180.00' ) 31/07/2024 08:40:19 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 ( '92760' , '22802' , 'ETERNA CONTEMPORANEITA' , '1' , '-1' , '4' , '150.0000' , '150' , '0' , '0' , '150.00' ) 31/07/2024 09:13:19 am >> SELECT document_num FROM ps_document WHERE document_num = '2391' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-31') 31/07/2024 09:13:19 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' , '2391' , '2024-07-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.80' , '33.54' , NOW() , NOW() ) 31/07/2024 09:13:19 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 = '92776' 31/07/2024 09:13:19 am >> DELETE FROM ps_document_detail WHERE id_document = '92776' 31/07/2024 09:13:19 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 ( '92776' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 31/07/2024 09:13:19 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 ( '92776' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '6' , '-6' , '3' , '3.30' , '3.1730769230769' , '4' , '0' , '19.80' ) 31/07/2024 09:13:19 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 ( '92776' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 31/07/2024 09:33:00 am >> SELECT document_num FROM ps_document WHERE document_num = '2392' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-31') 31/07/2024 09:33:00 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' , '2392' , '2024-07-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.40' , '22.40' , NOW() , NOW() ) 31/07/2024 09:33:00 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 = '92777' 31/07/2024 09:33:00 am >> DELETE FROM ps_document_detail WHERE id_document = '92777' 31/07/2024 09:33:00 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 ( '92777' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '560' , '-560' , '4' , '0.04' , '0.04' , '0' , '0' , '22.40' ) 31/07/2024 09:37:00 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 31/07/2024 09:37:00 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22803' , '1' , '' , 'nuovo-prodotto' ) 31/07/2024 09:37:00 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22803' , '1' , '1' , '2' , NOW() , NOW() ) 31/07/2024 09:37:00 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22803' , '0' , '1' , '0' , '0' ) 31/07/2024 09:38:17 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801069174' AND id_product != '22803' AND ean13 != '' 31/07/2024 09:38:17 am >> UPDATE ps_product SET id_supplier = '', reference = '2/2', ean13 = '9788801069174', date_upd = NOW() WHERE id_product = '22803' 31/07/2024 09:38:17 am >> UPDATE ps_product_lang SET name = 'PANE E VINO - N.E. - GUIDA 3', description = '' WHERE id_product = '22803' 31/07/2024 09:38:17 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '22803' 31/07/2024 09:38:17 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '12', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22803' 31/07/2024 09:38:17 am >> DELETE FROM ps_specific_price WHERE id_product = '22803' 31/07/2024 09:38:19 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22803' 31/07/2024 09:38:19 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22804' , '1' , '' , 'nuovo-prodotto' ) 31/07/2024 09:38:19 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22804' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22803' 31/07/2024 09:38:19 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22804' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22803' 31/07/2024 09:39:01 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801069167' AND id_product != '22804' AND ean13 != '' 31/07/2024 09:39:01 am >> UPDATE ps_product SET id_supplier = '', reference = '2/2', ean13 = '9788801069167', date_upd = NOW() WHERE id_product = '22804' 31/07/2024 09:39:01 am >> UPDATE ps_product_lang SET name = 'PANE E VINO - N.E. - SUSSIDIO', description = '' WHERE id_product = '22804' 31/07/2024 09:39:01 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '22804' 31/07/2024 09:39:01 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '12', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22804' 31/07/2024 09:39:01 am >> DELETE FROM ps_specific_price WHERE id_product = '22804' 31/07/2024 09:39:31 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 31/07/2024 09:39:31 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22805' , '1' , '' , 'nuovo-prodotto' ) 31/07/2024 09:39:31 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22805' , '1' , '1' , '2' , NOW() , NOW() ) 31/07/2024 09:39:31 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22805' , '0' , '1' , '0' , '0' ) 31/07/2024 09:40:57 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280546111' AND id_product != '22805' AND ean13 != '' 31/07/2024 09:40:57 am >> UPDATE ps_product SET id_supplier = '', reference = '7/2', ean13 = '9791280546111', date_upd = NOW() WHERE id_product = '22805' 31/07/2024 09:40:57 am >> UPDATE ps_product_lang SET name = 'RESPIRO DELLA LODE - A. VENA', description = '' WHERE id_product = '22805' 31/07/2024 09:40:57 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13.5' WHERE id_product = '22805' 31/07/2024 09:40:57 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13.5', id_tax_rules_group = '4', id_category_default = '483', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22805' 31/07/2024 09:40:57 am >> DELETE FROM ps_specific_price WHERE id_product = '22805' 31/07/2024 09:42:16 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '670971' , '2024-07-29' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.07' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '70.02' , '70.02' , NOW() , NOW() ) 31/07/2024 09:42:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92778' 31/07/2024 09:42:16 am >> DELETE FROM ps_document_detail WHERE id_document = '92778' 31/07/2024 09:42:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92778' , '22805' , 'RESPIRO DELLA LODE - A. VENA' , '1' , '1' , '4' , '13.50' , '13.5' , '0' , '30' , '9.4500' ) 31/07/2024 09:42:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '22805' AND id_supplier = '7' 31/07/2024 09:42:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22805' , '7' , '1' ) 31/07/2024 09:42:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92778' , '22803' , 'PANE E VINO - N.E. - GUIDA 3' , '2' , '2' , '4' , '15.00' , '15' , '0' , '35' , '19.5000' ) 31/07/2024 09:42:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '22803' AND id_supplier = '7' 31/07/2024 09:42:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22803' , '7' , '1' ) 31/07/2024 09:42:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92778' , '22804' , 'PANE E VINO - N.E. - SUSSIDIO' , '12' , '12' , '4' , '5.00' , '5' , '0' , '35' , '39.0000' ) 31/07/2024 09:42:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '22804' AND id_supplier = '7' 31/07/2024 09:42:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22804' , '7' , '1' ) 31/07/2024 09:42:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92778' , '22804' , 'PANE E VINO - N.E. - SUSSIDIO' , '1' , '1' , '4' , '5.00' , '5' , '0' , '100' , '0.0000' ) 31/07/2024 09:42:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '22804' AND id_supplier = '7' 31/07/2024 09:42:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22804' , '7' , '1' ) 31/07/2024 09:47:36 am >> SELECT document_num FROM ps_document WHERE document_num = '82/A' AND id_document != '92610' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-07-12') 31/07/2024 09:47:36 am >> UPDATE ps_document SET id_document_type = '24', document_num = '82/A', document_date = '2024-07-12', document_letter = 'A', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', 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 = '550.00', price_tax_excluded = '450.82', date_upd = NOW() WHERE id_document = '92610' 31/07/2024 09:47:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92610' 31/07/2024 09:47:36 am >> DELETE FROM ps_document_detail WHERE id_document = '92610' 31/07/2024 09:47:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92610' , '12661' , 'CAMICE BIANCO - MISTO COT. 150' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 31/07/2024 09:47:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92610' , '15530' , 'TUNICA SVASATA COLLO ROTONDO - PTA001B00' , '1' , '-1' , '1' , '45.0000' , '36.885245901639' , '22' , '0' , '45.00' ) 31/07/2024 09:47:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92610' , '18368' , 'TUNICA PRIMA COMUNIONE BORDO ORO' , '10' , '-10' , '1' , '45.0000' , '36.885245901639' , '22' , '0' , '450.00' ) 31/07/2024 10:03:08 am >> SELECT document_num FROM ps_document WHERE document_num = '2393' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-31') 31/07/2024 10:03: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' , '2393' , '2024-07-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '38.00' , NOW() , NOW() ) 31/07/2024 10:03: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 = '92779' 31/07/2024 10:03:08 am >> DELETE FROM ps_document_detail WHERE id_document = '92779' 31/07/2024 10:03: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 ( '92779' , '22677' , 'LITURGIA MANOMESSA ' , '1' , '-1' , '4' , '30.00' , '30' , '0' , '5' , '28.50' ) 31/07/2024 10:03: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 ( '92779' , '22398' , 'CREDERE - R. MAGGI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 31/07/2024 10:11:09 am >> DELETE FROM ps_document WHERE id_document = '91942' 31/07/2024 10:11:09 am >> DELETE FROM ps_document_detail WHERE id_document = '91942' 31/07/2024 10:12:57 am >> SELECT document_num FROM ps_document WHERE document_num = '1559' AND id_document != '91768' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-13') 31/07/2024 10:12:57 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1559', document_date = '2024-05-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 = '11.00', price_tax_excluded = '9.02', date_upd = NOW() WHERE id_document = '91768' 31/07/2024 10:12:57 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91768' 31/07/2024 10:12:57 am >> DELETE FROM ps_document_detail WHERE id_document = '91768' 31/07/2024 10:12:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91768' , '18223' , 'CORONA MISSIONARIA - R102' , '1' , '-1' , '1' , '0.7' , '0.57377049180328' , '22' , '0' , '0.70' ) 31/07/2024 10:12:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91768' , '14773' , 'BRACCIALE RIGATO - 0825N' , '1' , '-1' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '1.30' ) 31/07/2024 10:12:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91768' , '16312' , 'DECINA LEGNO CHIARO' , '1' , '-1' , '1' , '0.6000' , '0.49180327868852' , '22' , '0' , '0.60' ) 31/07/2024 10:12:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91768' , '21103' , 'ROSARIO DECINA GIALLO - R333-32' , '12' , '-12' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '8.40' ) 31/07/2024 10:13:36 am >> SELECT document_num FROM ps_document WHERE document_num = '1598' AND id_document != '91819' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-15') 31/07/2024 10:13:36 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1598', document_date = '2024-05-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 = '106.00', price_tax_excluded = '86.89', date_upd = NOW() WHERE id_document = '91819' 31/07/2024 10:13:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91819' 31/07/2024 10:13:36 am >> DELETE FROM ps_document_detail WHERE id_document = '91819' 31/07/2024 10:13:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91819' , '15445' , 'QUADRO DECORATO 61X38' , '1' , '-1' , '1' , '85' , '69.672131147541' , '22' , '0' , '85.00' ) 31/07/2024 10:13:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91819' , '21103' , 'ROSARIO DECINA GIALLO - R333-32' , '30' , '-30' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '21.00' ) 31/07/2024 10:15:00 am >> SELECT document_num FROM ps_document WHERE document_num = '1605' AND id_document != '91829' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-16') 31/07/2024 10:15:00 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1605', document_date = '2024-05-16', 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 = '565.00', price_tax_excluded = '467.40', date_upd = NOW() WHERE id_document = '91829' 31/07/2024 10:15:00 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 = '91829' 31/07/2024 10:15:01 am >> DELETE FROM ps_document_detail WHERE id_document = '91829' 31/07/2024 10:15:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91829' , '5762' , 'LEZIONARIO E RITO DEL MATRIMONIO - KIT 2 VOL.' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '5' , '23.75' ) 31/07/2024 10:15:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91829' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '4.8500' , '3.9754098360656' , '22' , '0' , '4.85' ) 31/07/2024 10:15:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91829' , '21376' , 'CASULA POL. LEGGERO - CS25L' , '2' , '-2' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '130.00' ) 31/07/2024 10:15:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91829' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '2' , '-2' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '110.00' ) 31/07/2024 10:15:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91829' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 31/07/2024 10:15:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91829' , '14919' , 'CASULA - POLIESTERE - PCA022' , '2' , '-2' , '1' , '75.0000' , '61.475409836066' , '22' , '0' , '150.00' ) 31/07/2024 10:15:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91829' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 31/07/2024 10:15:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91829' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '40' , '-40' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '80.00' ) 31/07/2024 10:15:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91829' , '21103' , 'ROSARIO DECINA GIALLO - R333-32' , '10' , '-10' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '7.00' ) 31/07/2024 10:15:51 am >> SELECT document_num FROM ps_document WHERE document_num = '1625' AND id_document != '91850' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-16') 31/07/2024 10:15:51 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1625', document_date = '2024-05-16', 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 = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '91850' 31/07/2024 10:15:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91850' 31/07/2024 10:15:51 am >> DELETE FROM ps_document_detail WHERE id_document = '91850' 31/07/2024 10:15:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91850' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '1' , '-1' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '0.20' ) 31/07/2024 10:15:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91850' , '21103' , 'ROSARIO DECINA GIALLO - R333-32' , '64' , '-64' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '44.80' ) 31/07/2024 10:18:27 am >> SELECT document_num FROM ps_document WHERE document_num = '2394' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-31') 31/07/2024 10:18:27 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2394' , '2024-07-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 31/07/2024 10:18:27 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92780' 31/07/2024 10:18:27 am >> DELETE FROM ps_document_detail WHERE id_document = '92780' 31/07/2024 10:18:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92780' , '17141' , 'RICAMBIO VETRO - 34/V' , '2' , '-2' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '30.00' ) 31/07/2024 10:20:11 am >> SELECT document_num FROM ps_document WHERE document_num = '1624' AND id_document != '91849' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-16') 31/07/2024 10:20:11 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1624', document_date = '2024-05-16', 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 = '7.30', price_tax_excluded = '5.98', date_upd = NOW() WHERE id_document = '91849' 31/07/2024 10:20:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91849' 31/07/2024 10:20:11 am >> DELETE FROM ps_document_detail WHERE id_document = '91849' 31/07/2024 10:20:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91849' , '20537' , 'VESTINA BATTESIMALE - 101TCB' , '1' , '-1' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '4.50' ) 31/07/2024 10:20:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91849' , '21103' , 'ROSARIO DECINA GIALLO - R333-32' , '4' , '-4' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '2.80' ) 31/07/2024 10:21:12 am >> SELECT document_num FROM ps_document WHERE document_num = '1658' AND id_document != '91891' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-18') 31/07/2024 10:21:12 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1658', document_date = '2024-05-18', 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 = '10.50', price_tax_excluded = '8.61', date_upd = NOW() WHERE id_document = '91891' 31/07/2024 10:21:12 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 = '91891' 31/07/2024 10:21:12 am >> DELETE FROM ps_document_detail WHERE id_document = '91891' 31/07/2024 10:21:12 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 ( '91891' , '17276' , 'CONFEZIONE COLLANINA CON MIRACOLOSA E STRASS - 1911' , '1' , '-1' , '1' , '4.2' , '3.4426229508197' , '22' , '0' , '4.20' ) 31/07/2024 10:21:12 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 ( '91891' , '21103' , 'ROSARIO DECINA GIALLO - R333-32' , '9' , '-9' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '6.30' ) 31/07/2024 10:22:08 am >> SELECT document_num FROM ps_document WHERE document_num = '1671' AND id_document != '91904' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-18') 31/07/2024 10:22:09 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1671', document_date = '2024-05-18', 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 = '10.00', price_tax_excluded = '8.20', date_upd = NOW() WHERE id_document = '91904' 31/07/2024 10:22:09 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 = '91904' 31/07/2024 10:22:09 am >> DELETE FROM ps_document_detail WHERE id_document = '91904' 31/07/2024 10:22: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 ( '91904' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '2' , '-2' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '4.00' ) 31/07/2024 10:22: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 ( '91904' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.1' , '0.9016393442623' , '22' , '0' , '1.10' ) 31/07/2024 10:22: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 ( '91904' , '21103' , 'ROSARIO DECINA GIALLO - R333-32' , '7' , '-7' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '4.90' ) 31/07/2024 10:23:22 am >> SELECT document_num FROM ps_document WHERE document_num = '1698' AND id_document != '91932' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-21') 31/07/2024 10:23:22 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1698', document_date = '2024-05-21', 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 = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '91932' 31/07/2024 10:23:22 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91932' 31/07/2024 10:23:22 am >> DELETE FROM ps_document_detail WHERE id_document = '91932' 31/07/2024 10:23:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91932' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '1' , '-1' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '0.20' ) 31/07/2024 10:23:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91932' , '22441' , 'ROSARIO ARGENTO/CRISTALLO - 7693/50' , '1' , '-1' , '1' , '35.0000' , '28.688524590164' , '22' , '0' , '35.00' ) 31/07/2024 10:23:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91932' , '21103' , 'ROSARIO DECINA GIALLO - R333-32' , '14' , '-14' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '9.80' ) 31/07/2024 10:25:53 am >> SELECT document_num FROM ps_document WHERE document_num = '2336' AND id_document != '92708' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-23') 31/07/2024 10:25:53 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2336', document_date = '2024-07-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '80.00', price_tax_excluded = '74.72', date_upd = NOW() WHERE id_document = '92708' 31/07/2024 10:25:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92708' 31/07/2024 10:25:53 am >> DELETE FROM ps_document_detail WHERE id_document = '92708' 31/07/2024 10:25:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92708' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 31/07/2024 10:25:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92708' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '-1' , '4' , '1.68' , '1.68' , '0' , '0' , '1.68' ) 31/07/2024 10:25:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92708' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '2' , '-2' , '1' , '12.5000' , '10.245901639344' , '22' , '0' , '25.00' ) 31/07/2024 10:25:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92708' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '14' , '-14' , '4' , '2.38' , '2.38' , '0' , '0' , '33.32' ) 31/07/2024 10:27:42 am >> SELECT document_num FROM ps_document WHERE document_num = '1533' AND id_document != '91736' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-10') 31/07/2024 10:27:42 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1533', document_date = '2024-05-10', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '207.10', price_tax_excluded = '172.84', date_upd = NOW() WHERE id_document = '91736' 31/07/2024 10:27: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 = '91736' 31/07/2024 10:27:42 am >> DELETE FROM ps_document_detail WHERE id_document = '91736' 31/07/2024 10:27: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 ( '91736' , '22515' , 'BORSA PORTAELEMOSINA CON LUCCHETTO - 750/L' , '2' , '-2' , '1' , '95.0000' , '77.868852459016' , '22' , '0' , '190.00' ) 31/07/2024 10:27: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 ( '91736' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.44' , '0.44' , '0' , '0' , '0.44' ) 31/07/2024 10:27: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 ( '91736' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '7' , '-7' , '4' , '2.38' , '2.38' , '0' , '0' , '16.66' ) 31/07/2024 10:28:35 am >> SELECT document_num FROM ps_document WHERE document_num = '2247' AND id_document != '92602' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-12') 31/07/2024 10:28:35 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2247', document_date = '2024-07-12', 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 = '16.60', price_tax_excluded = '16.60', date_upd = NOW() WHERE id_document = '92602' 31/07/2024 10:28:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92602' 31/07/2024 10:28:35 am >> DELETE FROM ps_document_detail WHERE id_document = '92602' 31/07/2024 10:28:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92602' , '22698' , 'CALENDARIO LITURGICO 2025' , '2' , '-2' , '4' , '0.8000' , '0.8' , '0' , '0' , '1.60' ) 31/07/2024 10:28:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92602' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '6' , '-6' , '4' , '2.5' , '2.5' , '0' , '0' , '15.00' ) 31/07/2024 10:29:06 am >> SELECT document_num FROM ps_document WHERE document_num = '2259' AND id_document != '92615' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-12') 31/07/2024 10:29:06 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2259', document_date = '2024-07-12', 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 = '11.70', price_tax_excluded = '11.70', date_upd = NOW() WHERE id_document = '92615' 31/07/2024 10:29:07 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92615' 31/07/2024 10:29:07 am >> DELETE FROM ps_document_detail WHERE id_document = '92615' 31/07/2024 10:29:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92615' , '20697' , 'VOGLIO DONARMI COMPLETAMENTE A TE - C. GALATOLO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 31/07/2024 10:29:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92615' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '1' , '-1' , '4' , '2.2' , '2.2' , '0' , '0' , '2.20' ) 31/07/2024 10:42:53 am >> SELECT document_num FROM ps_document WHERE document_num = '2395' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-31') 31/07/2024 10:42:53 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2395' , '2024-07-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.71' , '47.15' , NOW() , NOW() ) 31/07/2024 10:42:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92781' 31/07/2024 10:42:53 am >> DELETE FROM ps_document_detail WHERE id_document = '92781' 31/07/2024 10:42:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92781' , '22617' , 'CROCE ARG. - CRSB-046' , '1' , '-1' , '1' , '35.00' , '28.688524590164' , '22' , '0' , '35.00' ) 31/07/2024 10:42:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92781' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '18' , '14.754098360656' , '22' , '0' , '18.00' ) 31/07/2024 10:42:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92781' , '22476' , 'AMEN - AGO 24' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 31/07/2024 10:46:12 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 ( '32' , '2024-FV 001184' , '2024-07-31' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '6.5' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.28' , '50.28' , NOW() , NOW() ) 31/07/2024 10:46:12 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 = '92782' 31/07/2024 10:46:12 am >> DELETE FROM ps_document_detail WHERE id_document = '92782' 31/07/2024 10:46:12 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 ( '92782' , '22111' , 'PREGARE OGGI - 1' , '1' , '0' , '4' , '8.5000' , '8.5' , '0' , '45' , '4.68' ) 31/07/2024 10:46:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '22111' AND id_supplier = '79' 31/07/2024 10:46:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22111' , '79' , '1' ) 31/07/2024 10:46:12 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 ( '92782' , '22758' , 'PICCOLO LESSICO DEL FINE VITA' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '45' , '6.60' ) 31/07/2024 10:46:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '22758' AND id_supplier = '79' 31/07/2024 10:46:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22758' , '79' , '1' ) 31/07/2024 10:46:12 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 ( '92782' , '5762' , 'LEZIONARIO E RITO DEL MATRIMONIO - KIT 2 VOL.' , '2' , '0' , '4' , '25.0000' , '25' , '0' , '35' , '32.50' ) 31/07/2024 10:46:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '5762' AND id_supplier = '79' 31/07/2024 10:46:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5762' , '79' , '1' ) 31/07/2024 10:53:33 am >> SELECT document_num FROM ps_document WHERE document_num = '1774' AND id_document != '92033' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-27') 31/07/2024 10:53:33 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1774', document_date = '2024-05-27', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '65.00', price_tax_excluded = '53.28', date_upd = NOW() WHERE id_document = '92033' 31/07/2024 10:53:33 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92033' 31/07/2024 10:53:33 am >> DELETE FROM ps_document_detail WHERE id_document = '92033' 31/07/2024 10:53:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92033' , '21691' , 'PENDENTE FF 10X11' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 31/07/2024 10:53:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92033' , '22286' , 'COLLETTO DOPPIO MISTO LINO - CD01/C' , '1' , '-1' , '1' , '17.5000' , '14.344262295082' , '22' , '0' , '17.50' ) 31/07/2024 10:53:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92033' , '12833' , 'BOTTONE RETROCOLLO - 21630' , '1' , '-1' , '1' , '2.8000' , '2.2950819672131' , '22' , '0' , '2.80' ) 31/07/2024 10:53:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92033' , '18128' , 'PETTORINA PER COLLETTI DOPPI - AEPE02N00' , '1' , '-1' , '1' , '11.7000' , '9.5901639344262' , '22' , '0' , '11.70' ) 31/07/2024 10:53:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92033' , '17005' , 'BIGLIETTO AUGURALE medio' , '3' , '-3' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '3.00' ) 31/07/2024 10:53:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92033' , '13142' , 'CERETTI DIAM 26X350 - 2635' , '5' , '-5' , '1' , '2' , '1.6393442622951' , '22' , '0' , '10.00' ) 31/07/2024 10:57:18 am >> SELECT document_num FROM ps_document WHERE document_num = '2394' AND id_document != '92780' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-31') 31/07/2024 10:57:18 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2394', document_date = '2024-07-31', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '30.00', price_tax_excluded = '24.59', date_upd = NOW() WHERE id_document = '92780' 31/07/2024 10:57: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 = '92780' 31/07/2024 10:57:18 am >> DELETE FROM ps_document_detail WHERE id_document = '92780' 31/07/2024 10:57: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 ( '92780' , '16409' , 'RICAMBIO VETRO - 32/V' , '2' , '-2' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '30.00' ) 31/07/2024 11:51:41 am >> SELECT document_num FROM ps_document WHERE document_num = '2396' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-31') 31/07/2024 11:51:41 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' , '2396' , '2024-07-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 31/07/2024 11:51:41 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 = '92783' 31/07/2024 11:51:41 am >> DELETE FROM ps_document_detail WHERE id_document = '92783' 31/07/2024 11:51:41 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 ( '92783' , '12202' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 4 - 73/40' , '2' , '-2' , '1' , '20.00' , '16.393442622951' , '22' , '0' , '40.00' ) 31/07/2024 12:17:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '2397' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-31') 31/07/2024 12:17: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 ( '11' , '2397' , '2024-07-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 31/07/2024 12:17: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 = '92784' 31/07/2024 12:17:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '92784' 31/07/2024 12:17: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 ( '92784' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '45.00' ) 31/07/2024 12:21:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '2398' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-31') 31/07/2024 12:21:06 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' , '2398' , '2024-07-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.78' , '65.78' , NOW() , NOW() ) 31/07/2024 12:21:06 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 = '92785' 31/07/2024 12:21:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '92785' 31/07/2024 12:21:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92785' , '22784' , 'ROSARIO CON PADRE PIO' , '46' , '-46' , '4' , '1.50' , '1.5' , '0' , '5' , '65.78' ) 31/07/2024 12:43:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '101' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-08-01') 31/07/2024 12:43: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 ( '21' , '101' , '2024-08-01' , '' , '161' , '0' , '4679291' , 'VIA G. MAZZINI VICO III, 8 81047 MACERATA CAMPANIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '142.50' , '142.50' , NOW() , NOW() ) 31/07/2024 12:43: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 = '92786' 31/07/2024 12:43:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '92786' 31/07/2024 12:43: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 ( '92786' , '21847' , 'UNDICESIMO: SALVA LA TESTA! - P. PELLEGRINO' , '50' , '-50' , '4' , '3.00' , '3' , '0' , '5' , '142.50' ) 31/07/2024 12:45:48 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 31/07/2024 12:45:48 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22806' , '1' , '' , 'nuovo-prodotto' ) 31/07/2024 12:45:48 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22806' , '1' , '1' , '2' , NOW() , NOW() ) 31/07/2024 12:45:48 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22806' , '0' , '1' , '0' , '0' ) 31/07/2024 12:47:26 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788830819344' AND id_product != '22806' AND ean13 != '' 31/07/2024 12:47:26 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/5', ean13 = '9788830819344', date_upd = NOW() WHERE id_product = '22806' 31/07/2024 12:47:26 pm >> UPDATE ps_product_lang SET name = 'SENSO DI COLPA E COSCIENZA DI PECCATO - A. GRANDI', description = '' WHERE id_product = '22806' 31/07/2024 12:47:26 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18.5' WHERE id_product = '22806' 31/07/2024 12:47:26 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18.5', id_tax_rules_group = '4', id_category_default = '11', 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 = '22806' 31/07/2024 12:47:26 pm >> DELETE FROM ps_specific_price WHERE id_product = '22806' 31/07/2024 12:47:53 pm >> 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 = '22806' 31/07/2024 12:47:53 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22807' , '1' , '' , 'nuovo-prodotto' ) 31/07/2024 12:47:53 pm >> 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 '22807' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22806' 31/07/2024 12:47:53 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22807' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22806' 31/07/2024 12:49:21 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873673347' AND id_product != '22807' AND ean13 != '' 31/07/2024 12:49:21 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/4', ean13 = '9788873673347', date_upd = NOW() WHERE id_product = '22807' 31/07/2024 12:49:21 pm >> UPDATE ps_product_lang SET name = 'SPIRITO SANTO BELLA VITA DI S. LUISA DE MARILLAC - E. PROFICO', description = '' WHERE id_product = '22807' 31/07/2024 12:49:21 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '22807' 31/07/2024 12:49:21 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '380', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22807' 31/07/2024 12:49:21 pm >> DELETE FROM ps_specific_price WHERE id_product = '22807' 31/07/2024 12:50:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832235234' AND id_product != '15515' AND ean13 != '' 31/07/2024 12:50:23 pm >> UPDATE ps_product SET id_supplier = '107', reference = '6/3', ean13 = '9788832235234', date_upd = NOW() WHERE id_product = '15515' 31/07/2024 12:50:23 pm >> UPDATE ps_product_lang SET name = 'ORIGINALI, NON FOTOCOPIE - D. SORRENTINO', description = '' WHERE id_product = '15515' 31/07/2024 12:50:23 pm >> UPDATE ps_product SET wholesale_price = '3.90', on_sale = '0', price = '6.0000' WHERE id_product = '15515' 31/07/2024 12:50:24 pm >> UPDATE ps_product_shop SET wholesale_price = '3.90', price = '6.0000', id_tax_rules_group = '4', id_category_default = '110', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15515' 31/07/2024 12:50:24 pm >> DELETE FROM ps_specific_price WHERE id_product = '15515' 31/07/2024 12:50:48 pm >> 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 = '22807' 31/07/2024 12:50:48 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22808' , '1' , '' , 'nuovo-prodotto' ) 31/07/2024 12:50:48 pm >> 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 '22808' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22807' 31/07/2024 12:50:48 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22808' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22807' 31/07/2024 12:51:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281553248' AND id_product != '22808' AND ean13 != '' 31/07/2024 12:51:41 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/7', ean13 = '9791281553248', date_upd = NOW() WHERE id_product = '22808' 31/07/2024 12:51:41 pm >> UPDATE ps_product_lang SET name = 'GIONA - L. SANDRIN', description = '' WHERE id_product = '22808' 31/07/2024 12:51:41 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12.5' WHERE id_product = '22808' 31/07/2024 12:51:41 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12.5', id_tax_rules_group = '4', id_category_default = '428', id_argoment_default = '8', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22808' 31/07/2024 12:51:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '22808' 31/07/2024 12:52:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '2024000003976' , '2024-07-29' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '6' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '144.97' , '144.97' , NOW() , NOW() ) 31/07/2024 12:52:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92787' 31/07/2024 12:52:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '92787' 31/07/2024 12:52:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92787' , '20150' , 'MANUALE PER APPRENDISTI GENITORI - P. PELLEGRINO' , '1' , '1' , '4' , '14.80' , '14.8' , '0' , '35' , '9.6200' ) 31/07/2024 12:52:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20150' AND id_supplier = '107' 31/07/2024 12:52:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20150' , '107' , '1' ) 31/07/2024 12:52:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92787' , '22806' , 'SENSO DI COLPA E COSCIENZA DI PECCATO - A. GRANDI' , '1' , '1' , '4' , '18.50' , '18.5' , '0' , '35' , '12.0250' ) 31/07/2024 12:52:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22806' AND id_supplier = '107' 31/07/2024 12:52:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22806' , '107' , '1' ) 31/07/2024 12:52:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92787' , '22807' , 'SPIRITO SANTO BELLA VITA DI S. LUISA DE MARILLAC - E. PROFICO' , '1' , '1' , '4' , '12.00' , '12' , '0' , '35' , '7.8000' ) 31/07/2024 12:52:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22807' AND id_supplier = '107' 31/07/2024 12:52:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22807' , '107' , '1' ) 31/07/2024 12:52:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92787' , '15515' , 'ORIGINALI, NON FOTOCOPIE - D. SORRENTINO' , '1' , '1' , '4' , '6.00' , '6' , '0' , '35' , '3.9000' ) 31/07/2024 12:52:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15515' AND id_supplier = '107' 31/07/2024 12:52:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15515' , '107' , '1' ) 31/07/2024 12:52:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92787' , '22808' , 'GIONA - L. SANDRIN' , '1' , '1' , '4' , '12.50' , '12.5' , '0' , '35' , '8.1250' ) 31/07/2024 12:52:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22808' AND id_supplier = '107' 31/07/2024 12:52:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22808' , '107' , '1' ) 31/07/2024 12:52:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92787' , '21847' , 'UNDICESIMO: SALVA LA TESTA! - P. PELLEGRINO' , '50' , '50' , '4' , '3.00' , '3' , '0' , '35' , '97.5000' ) 31/07/2024 12:52:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21847' AND id_supplier = '107' 31/07/2024 12:52:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21847' , '107' , '1' ) 31/07/2024 01:01:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '2399' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-31') 31/07/2024 01:01:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2399' , '2024-07-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 31/07/2024 01:01:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92788' 31/07/2024 01:01:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '92788' 31/07/2024 01:01:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92788' , '12578' , 'RICAMBIO VETRO PER ART. 486 - 65' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 31/07/2024 06:26:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '2400' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-31') 31/07/2024 06:26: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' , '2400' , '2024-07-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 31/07/2024 06:26: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 = '92789' 31/07/2024 06:26:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '92789' 31/07/2024 06:26: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 ( '92789' , '16409' , 'RICAMBIO VETRO - 32/V' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 31/07/2024 06:32:30 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 ( '32' , '2024010001385' , '2024-07-31' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '6' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '146.08' , '146.08' , NOW() , NOW() ) 31/07/2024 06:32:30 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 = '92790' 31/07/2024 06:32:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '92790' 31/07/2024 06:32:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92790' , '20150' , 'MANUALE PER APPRENDISTI GENITORI - P. PELLEGRINO' , '1' , '0' , '4' , '14.8000' , '14.8' , '0' , '35' , '9.62' ) 31/07/2024 06:32:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20150' AND id_supplier = '107' 31/07/2024 06:32:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20150' , '107' , '1' ) 31/07/2024 06:32:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92790' , '22806' , 'SENSO DI COLPA E COSCIENZA DI PECCATO - A. GRANDI' , '1' , '0' , '4' , '18.5000' , '18.5' , '0' , '35' , '12.03' ) 31/07/2024 06:32:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22806' AND id_supplier = '107' 31/07/2024 06:32:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22806' , '107' , '1' ) 31/07/2024 06:32:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92790' , '22807' , 'SPIRITO SANTO BELLA VITA DI S. LUISA DE MARILLAC - E. PROFICO' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '35' , '7.80' ) 31/07/2024 06:32:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22807' AND id_supplier = '107' 31/07/2024 06:32:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22807' , '107' , '1' ) 31/07/2024 06:32:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92790' , '15515' , 'ORIGINALI, NON FOTOCOPIE - D. SORRENTINO' , '1' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '3.0000' ) 31/07/2024 06:32:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15515' AND id_supplier = '107' 31/07/2024 06:32:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15515' , '107' , '1' ) 31/07/2024 06:32:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92790' , '22808' , 'GIONA - L. SANDRIN' , '1' , '0' , '4' , '12.5000' , '12.5' , '0' , '35' , '8.13' ) 31/07/2024 06:32:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22808' AND id_supplier = '107' 31/07/2024 06:32:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22808' , '107' , '1' ) 31/07/2024 06:32:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92790' , '21847' , 'UNDICESIMO: SALVA LA TESTA! - P. PELLEGRINO' , '50' , '0' , '4' , '3.0000' , '3' , '0' , '35' , '97.50' ) 31/07/2024 06:32:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21847' AND id_supplier = '107' 31/07/2024 06:32:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21847' , '107' , '1' ) 31/07/2024 06:32:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92790' , '' , 'BOLLI' , '1' , '0' , '4' , '2' , '2' , '0' , '0' , '2.0000' ) 31/07/2024 06:32:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '107' 31/07/2024 06:32:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '107' , '1' ) 31/07/2024 06:33:04 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '2024000003976', document_date = '2024-07-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669100', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = '', price_shipping = '6.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 = '146.08', price_tax_excluded = '146.08', date_upd = NOW() WHERE id_document = '92787' 31/07/2024 06:33: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 = '92787' 31/07/2024 06:33:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '92787' 31/07/2024 06:33: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 ( '92787' , '20150' , 'MANUALE PER APPRENDISTI GENITORI - P. PELLEGRINO' , '1' , '1' , '4' , '14.8000' , '14.8' , '0' , '35' , '9.62' ) 31/07/2024 06:33: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 ( '92787' , '22806' , 'SENSO DI COLPA E COSCIENZA DI PECCATO - A. GRANDI' , '1' , '1' , '4' , '18.5000' , '18.5' , '0' , '35' , '12.03' ) 31/07/2024 06:33: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 ( '92787' , '22807' , 'SPIRITO SANTO BELLA VITA DI S. LUISA DE MARILLAC - E. PROFICO' , '1' , '1' , '4' , '12.0000' , '12' , '0' , '35' , '7.80' ) 31/07/2024 06:33: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 ( '92787' , '15515' , 'ORIGINALI, NON FOTOCOPIE - D. SORRENTINO' , '1' , '1' , '4' , '6.0000' , '6' , '0' , '50' , '3.0000' ) 31/07/2024 06:33: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 ( '92787' , '22808' , 'GIONA - L. SANDRIN' , '1' , '1' , '4' , '12.5000' , '12.5' , '0' , '35' , '8.13' ) 31/07/2024 06:33: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 ( '92787' , '21847' , 'UNDICESIMO: SALVA LA TESTA! - P. PELLEGRINO' , '50' , '50' , '4' , '3.0000' , '3' , '0' , '35' , '97.50' ) 31/07/2024 06:33: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 ( '92787' , '' , 'BOLLI' , '1' , '1' , '4' , '2' , '2' , '0' , '0' , '2.0000' )