10/12/2024 08:33:24 am >> DELETE FROM ps_document WHERE id_document = '93792' 10/12/2024 08:33:24 am >> DELETE FROM ps_document_detail WHERE id_document = '93792' 10/12/2024 08:33:44 am >> DELETE FROM ps_document WHERE id_document = '94731' 10/12/2024 08:33:44 am >> DELETE FROM ps_document_detail WHERE id_document = '94731' 10/12/2024 09:32:30 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 10/12/2024 09:32:30 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23296' , '1' , '' , 'nuovo-prodotto' ) 10/12/2024 09:32:30 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23296' , '1' , '1' , '2' , NOW() , NOW() ) 10/12/2024 09:32:30 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23296' , '0' , '1' , '0' , '0' ) 10/12/2024 09:33:18 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259754301' AND id_product != '23296' AND ean13 != '' 10/12/2024 09:33:18 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791259754301', date_upd = NOW() WHERE id_product = '23296' 10/12/2024 09:33:18 am >> UPDATE ps_product_lang SET name = 'esercizi spirituali - o. de bortolis', description = '' WHERE id_product = '23296' 10/12/2024 09:33:18 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '23296' 10/12/2024 09:33:18 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '267', id_argoment_default = '39', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23296' 10/12/2024 09:33:18 am >> DELETE FROM ps_specific_price WHERE id_product = '23296' 10/12/2024 09:33: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 = '23296' 10/12/2024 09:33:19 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23297' , '1' , '' , 'nuovo-prodotto' ) 10/12/2024 09:33: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 '23297' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23296' 10/12/2024 09:33:19 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23297' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23296' 10/12/2024 09:34:04 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' , '684812' , '2024-12-06' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '4.7' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '158.86' , '158.86' , NOW() , NOW() ) 10/12/2024 09:34:04 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 = '94783' 10/12/2024 09:34:04 am >> DELETE FROM ps_document_detail WHERE id_document = '94783' 10/12/2024 09:34:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94783' , '23126' , 'DI PASQUA IN PASQUA ANNO C - F. ROSINI' , '2' , '2' , '4' , '16.00' , '16' , '0' , '33' , '21.4400' ) 10/12/2024 09:34:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '23126' AND id_supplier = '7' 10/12/2024 09:34:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23126' , '7' , '1' ) 10/12/2024 09:34:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94783' , '23296' , 'esercizi spirituali - o. de bortolis' , '1' , '1' , '4' , '18.00' , '18' , '0' , '30' , '12.6000' ) 10/12/2024 09:34:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '23296' AND id_supplier = '7' 10/12/2024 09:34:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23296' , '7' , '1' ) 10/12/2024 09:34:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94783' , '23169' , 'DILEXIT NOS ' , '84' , '84' , '4' , '2.20' , '2.2' , '0' , '35' , '120.1200' ) 10/12/2024 09:34:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '23169' AND id_supplier = '7' 10/12/2024 09:34:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23169' , '7' , '1' ) 10/12/2024 09:34:05 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 ( '94783' , '23169' , 'DILEXIT NOS ' , '7' , '7' , '4' , '2.20' , '2.2' , '0' , '100' , '0.0000' ) 10/12/2024 09:34:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '23169' AND id_supplier = '7' 10/12/2024 09:34:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23169' , '7' , '1' ) 10/12/2024 09:44:34 am >> SELECT document_num FROM ps_document WHERE document_num = '3882' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-10') 10/12/2024 09:44:34 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3882' , '2024-12-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '111.00' , '103.18' , NOW() , NOW() ) 10/12/2024 09:44:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94784' 10/12/2024 09:44:34 am >> DELETE FROM ps_document_detail WHERE id_document = '94784' 10/12/2024 09:44:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94784' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '20' , '-20' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '70.00' ) 10/12/2024 09:44:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94784' , '16689' , 'OSTIA PAN DI CENA mm80' , '8' , '-8' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '16.00' ) 10/12/2024 09:44:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94784' , '7921' , 'PERGAMENE - ANNIVERSARIO MATRIM. MOD. B' , '50' , '-50' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '25.00' ) 10/12/2024 09:55:16 am >> SELECT document_num FROM ps_document WHERE document_num = '3200' AND id_document != '93862' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-25') 10/12/2024 09:55:16 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3200', document_date = '2024-10-25', 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 = '57.00', price_tax_excluded = '57.00', date_upd = NOW() WHERE id_document = '93862' 10/12/2024 09:55: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 = '93862' 10/12/2024 09:55:16 am >> DELETE FROM ps_document_detail WHERE id_document = '93862' 10/12/2024 09:55: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 ( '93862' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '10' , '-10' , '4' , '4.5' , '4.5' , '0' , '' , '45.00' ) 10/12/2024 09:55: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 ( '93862' , '22876' , 'AMEN - NOV 24' , '1' , '-1' , '4' , '3.5' , '3.5' , '0' , '0' , '3.50' ) 10/12/2024 09:55: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 ( '93862' , '22875' , 'AMEN - DIC 24' , '1' , '-1' , '4' , '3.5' , '3.5' , '0' , '0' , '3.50' ) 10/12/2024 09:55: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 ( '93862' , '22854' , 'MESSALE FESTIVO 2025' , '1' , '-1' , '4' , '5' , '5' , '0' , '0' , '5.00' ) 10/12/2024 09:56:00 am >> SELECT document_num FROM ps_document WHERE document_num = '2939' AND id_document != '93488' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-07') 10/12/2024 09:56:00 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2939', document_date = '2024-10-07', 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 = '28.56', price_tax_excluded = '28.56', date_upd = NOW() WHERE id_document = '93488' 10/12/2024 09:56: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 = '93488' 10/12/2024 09:56:00 am >> DELETE FROM ps_document_detail WHERE id_document = '93488' 10/12/2024 09:56: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 ( '93488' , '22972' , 'MESSALINO QUOTIDIANO - NOV/DIC/GEN 2025' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 10/12/2024 09:56: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 ( '93488' , '14029' , 'ANGELO DI DIO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 10/12/2024 09:56: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 ( '93488' , '14032' , 'AVE MARIA' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 10/12/2024 09:56: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 ( '93488' , '13397' , 'MIO GESU' , '2' , '-2' , '4' , '3.5000' , '3.5' , '0' , '5' , '6.66' ) 10/12/2024 09:56: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 ( '93488' , '12813' , 'MARIA MADRE NOSTRA' , '2' , '-2' , '4' , '3.0000' , '3' , '0' , '5' , '5.70' ) 10/12/2024 09:56: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 ( '93488' , '22961' , 'UN BAMBINO E NATO PER NOI - G. VALSECCHI' , '2' , '-2' , '4' , '2.4' , '2.4' , '0' , '0' , '4.80' ) 10/12/2024 10:00:18 am >> SELECT document_num FROM ps_document WHERE document_num = '3685' AND id_document != '94541' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-27') 10/12/2024 10:00:18 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3685', document_date = '2024-11-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 = '68.00', price_tax_excluded = '55.74', date_upd = NOW() WHERE id_document = '94541' 10/12/2024 10:00: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 = '94541' 10/12/2024 10:00:18 am >> DELETE FROM ps_document_detail WHERE id_document = '94541' 10/12/2024 10:00: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 ( '94541' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '26.0000' , '21.311475409836' , '22' , '0' , '26.00' ) 10/12/2024 10:00: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 ( '94541' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3.6' , '2.9508196721311' , '22' , '0' , '3.60' ) 10/12/2024 10:00: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 ( '94541' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '4.90' ) 10/12/2024 10:00: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 ( '94541' , '5105' , 'IMMAGINI SACRE SERIE STELLA 20X25 ' , '50' , '-50' , '1' , '0.67' , '0.54918032786885' , '22' , '0' , '33.50' ) 10/12/2024 10:01:28 am >> SELECT document_num FROM ps_document WHERE document_num = '3883' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-10') 10/12/2024 10:01:28 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' , '3883' , '2024-12-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.50' , '14.34' , NOW() , NOW() ) 10/12/2024 10:01:28 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 = '94785' 10/12/2024 10:01:28 am >> DELETE FROM ps_document_detail WHERE id_document = '94785' 10/12/2024 10:01:28 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 ( '94785' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '5' , '-5' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '17.50' ) 10/12/2024 10:05:59 am >> SELECT document_num FROM ps_document WHERE document_num = '3534' AND id_document != '94339' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 10/12/2024 10:05:59 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3534', document_date = '2024-11-19', 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 = '90.00', price_tax_excluded = '73.77', date_upd = NOW() WHERE id_document = '94339' 10/12/2024 10:05: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 = '94339' 10/12/2024 10:05:59 am >> DELETE FROM ps_document_detail WHERE id_document = '94339' 10/12/2024 10:05: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 ( '94339' , '8047' , 'PISSIDE CM 14 INT. ORO CROCE + CONF. - OGGETTI' , '1' , '-1' , '1' , '60' , '49.180327868852' , '22' , '0' , '60.00' ) 10/12/2024 10:05: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 ( '94339' , '2164' , 'CLERGY BASIC EXTRA - ML - B&P' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 10/12/2024 10:07:30 am >> SELECT document_num FROM ps_document WHERE document_num = '3533' AND id_document != '94338' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 10/12/2024 10:07:30 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3533', document_date = '2024-11-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '53.40', price_tax_excluded = '45.33', date_upd = NOW() WHERE id_document = '94338' 10/12/2024 10:07:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94338' 10/12/2024 10:07:30 am >> DELETE FROM ps_document_detail WHERE id_document = '94338' 10/12/2024 10:07:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94338' , '18892' , 'BRACCIALE DECINA AZZURRO - BC822NP' , '12' , '-12' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '14.40' ) 10/12/2024 10:07:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94338' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 10/12/2024 10:07:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94338' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 10/12/2024 10:07:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94338' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '2' , '-2' , '1' , '14' , '11.475409836066' , '22' , '0' , '28.00' ) 10/12/2024 10:08:08 am >> SELECT document_num FROM ps_document WHERE document_num = '3749' AND id_document != '94613' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-30') 10/12/2024 10:08:08 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3749', document_date = '2024-11-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '368.60', price_tax_excluded = '305.94', date_upd = NOW() WHERE id_document = '94613' 10/12/2024 10:08: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 = '94613' 10/12/2024 10:08:08 am >> DELETE FROM ps_document_detail WHERE id_document = '94613' 10/12/2024 10:08: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 ( '94613' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '7.50' ) 10/12/2024 10:08: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 ( '94613' , '1616' , 'CANDELABRO MOD. 700 FINITURA ORO - CM 30 DM169R' , '2' , '-2' , '1' , '170.0000' , '139.34426229508' , '22' , '0' , '340.00' ) 10/12/2024 10:08: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 ( '94613' , '5444' , 'IO SONO CON VOI - CAT.' , '1' , '-1' , '4' , '5.5000' , '5.5' , '0' , '5' , '5.23' ) 10/12/2024 10:08: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 ( '94613' , '11193' , 'VENITE CON ME CAT.' , '1' , '-1' , '4' , '5.5000' , '5.5' , '0' , '5' , '5.23' ) 10/12/2024 10:08: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 ( '94613' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 10/12/2024 10:08: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 ( '94613' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 10/12/2024 10:08: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 ( '94613' , '11191' , 'VENITE CON ME 1 PARTE' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 10/12/2024 10:08: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 ( '94613' , '11192' , 'VENITE CON ME 2 PARTE' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 10/12/2024 10:08:34 am >> SELECT document_num FROM ps_document WHERE document_num = '3718' AND id_document != '94581' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-29') 10/12/2024 10:08:34 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3718', document_date = '2024-11-29', 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 = '49.55', price_tax_excluded = '43.24', date_upd = NOW() WHERE id_document = '94581' 10/12/2024 10:08:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94581' 10/12/2024 10:08:34 am >> DELETE FROM ps_document_detail WHERE id_document = '94581' 10/12/2024 10:08:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94581' , '19150' , 'MOCCOLO 70X200' , '2' , '-2' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '17.00' ) 10/12/2024 10:08:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94581' , '6811' , 'MOCCOLO 80X200' , '1' , '-1' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '9.00' ) 10/12/2024 10:08: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 ( '94581' , '23169' , 'DILEXIT NOS ' , '1' , '-1' , '4' , '2.2000' , '2.2' , '0' , '0' , '2.20' ) 10/12/2024 10:08: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 ( '94581' , '23249' , 'SPERANZA - G. CUCCI' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '5' , '12.35' ) 10/12/2024 10:08: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 ( '94581' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '9' , '7.3770491803279' , '22' , '0' , '9.00' ) 10/12/2024 10:09:17 am >> SELECT document_num FROM ps_document WHERE document_num = '3693' AND id_document != '94551' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-28') 10/12/2024 10:09:17 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3693', document_date = '2024-11-28', 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 = '84.50', price_tax_excluded = '71.60', date_upd = NOW() WHERE id_document = '94551' 10/12/2024 10:09:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94551' 10/12/2024 10:09:17 am >> DELETE FROM ps_document_detail WHERE id_document = '94551' 10/12/2024 10:09:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94551' , '22919' , 'STOLA GIUBILEO 2025' , '1' , '-1' , '1' , '38.0000' , '31.147540983607' , '22' , '0' , '38.00' ) 10/12/2024 10:09:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94551' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '3' , '-3' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '10.50' ) 10/12/2024 10:09:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94551' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '6.00' ) 10/12/2024 10:09:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94551' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '10' , '-10' , '1' , '3' , '2.4590163934426' , '22' , '0' , '30.00' ) 10/12/2024 10:09:44 am >> SELECT document_num FROM ps_document WHERE document_num = '3685' AND id_document != '94541' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-27') 10/12/2024 10:09:44 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3685', document_date = '2024-11-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 = '68.00', price_tax_excluded = '55.74', date_upd = NOW() WHERE id_document = '94541' 10/12/2024 10:09:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94541' 10/12/2024 10:09:44 am >> DELETE FROM ps_document_detail WHERE id_document = '94541' 10/12/2024 10:09:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94541' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '4.90' ) 10/12/2024 10:09:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94541' , '5105' , 'IMMAGINI SACRE SERIE STELLA 20X25 ' , '50' , '-50' , '1' , '0.6700' , '0.54918032786885' , '22' , '0' , '33.50' ) 10/12/2024 10:09:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94541' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '10' , '-10' , '1' , '2.96' , '2.4262295081967' , '22' , '0' , '29.60' ) 10/12/2024 10:10:01 am >> SELECT document_num FROM ps_document WHERE document_num = '3700' AND id_document != '94559' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-28') 10/12/2024 10:10:01 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3700', document_date = '2024-11-28', 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 = '26.00', price_tax_excluded = '21.31', date_upd = NOW() WHERE id_document = '94559' 10/12/2024 10:10:01 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 = '94559' 10/12/2024 10:10:01 am >> DELETE FROM ps_document_detail WHERE id_document = '94559' 10/12/2024 10:10: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 ( '94559' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '10' , '-10' , '1' , '2.6' , '2.1311475409836' , '22' , '0' , '26.00' ) 10/12/2024 10:10:52 am >> SELECT document_num FROM ps_document WHERE document_num = '3653' AND id_document != '94500' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-26') 10/12/2024 10:10:52 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3653', document_date = '2024-11-26', 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 = '130.00', price_tax_excluded = '107.41', date_upd = NOW() WHERE id_document = '94500' 10/12/2024 10:10: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 = '94500' 10/12/2024 10:10:52 am >> DELETE FROM ps_document_detail WHERE id_document = '94500' 10/12/2024 10:10: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 ( '94500' , '23093' , 'CONFEZIONE CAPANNA - P622-ITA' , '12' , '-12' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '14.40' ) 10/12/2024 10:10: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 ( '94500' , '14835' , 'STELLA COMETA - P581' , '12' , '-12' , '1' , '2.4000' , '1.9672131147541' , '22' , '0' , '28.80' ) 10/12/2024 10:10: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 ( '94500' , '23094' , 'CANDELA NATIVITA - P690' , '11' , '-11' , '1' , '2.8000' , '2.2950819672131' , '22' , '0' , '30.80' ) 10/12/2024 10:10: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 ( '94500' , '14957' , 'QUADRETTO NATIVITA 16X12 - P577' , '3' , '-3' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '13.50' ) 10/12/2024 10:10: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 ( '94500' , '6809' , 'MOCCOLO 60X165' , '1' , '-1' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '4.50' ) 10/12/2024 10:10: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 ( '94500' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 10/12/2024 10:10: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 ( '94500' , '1621' , 'CANDELE CONICHE 10 PZ' , '1' , '-1' , '1' , '7.9000' , '6.4754098360656' , '22' , '0' , '7.90' ) 10/12/2024 10:10: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 ( '94500' , '2168' , 'CLERGY BASIC - ML - B&P' , '1' , '-1' , '1' , '25.35' , '20.77868852459' , '22' , '0' , '25.35' ) 10/12/2024 10:11:39 am >> SELECT document_num FROM ps_document WHERE document_num = '3764' AND id_document != '94641' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-02') 10/12/2024 10:11:39 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3764', document_date = '2024-12-02', 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 = '75.00', price_tax_excluded = '61.76', date_upd = NOW() WHERE id_document = '94641' 10/12/2024 10:11:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94641' 10/12/2024 10:11:39 am >> DELETE FROM ps_document_detail WHERE id_document = '94641' 10/12/2024 10:11:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94641' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 10/12/2024 10:11:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94641' , '12317' , 'SCATOLA PORTA OSTIE IN ALLUMINIO - 1879' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 10/12/2024 10:11:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94641' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 10/12/2024 10:11:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94641' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.0000' , '18.852459016393' , '22' , '0' , '23.00' ) 10/12/2024 10:11:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94641' , '2168' , 'CLERGY BASIC - ML - B&P' , '1' , '-1' , '1' , '31.1' , '25.491803278689' , '22' , '0' , '31.10' ) 10/12/2024 10:12:32 am >> SELECT document_num FROM ps_document WHERE document_num = '3796' AND id_document != '94686' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-04') 10/12/2024 10:12:32 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3796', document_date = '2024-12-04', 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 = '84.00', price_tax_excluded = '68.85', date_upd = NOW() WHERE id_document = '94686' 10/12/2024 10:12:32 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94686' 10/12/2024 10:12:32 am >> DELETE FROM ps_document_detail WHERE id_document = '94686' 10/12/2024 10:12:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94686' , '1749' , 'CARTUCCIA TRASPARENTE DIAM. 5 - 456 ' , '2' , '-2' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '30.00' ) 10/12/2024 10:12:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94686' , '23082' , 'CAMICE RAGLAN CERNIERA DAVANTI - CA01' , '1' , '-1' , '1' , '54' , '44.262295081967' , '22' , '0' , '54.00' ) 10/12/2024 10:13:20 am >> SELECT document_num FROM ps_document WHERE document_num = '3570' AND id_document != '94393' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-21') 10/12/2024 10:13:20 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3570', document_date = '2024-11-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 = '9.00', price_tax_excluded = '9.00', date_upd = NOW() WHERE id_document = '94393' 10/12/2024 10:13:20 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 = '94393' 10/12/2024 10:13:20 am >> DELETE FROM ps_document_detail WHERE id_document = '94393' 10/12/2024 10:13:20 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 ( '94393' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '2' , '-2' , '4' , '4.5' , '4.5' , '0' , '0' , '9.00' ) 10/12/2024 10:13:43 am >> SELECT document_num FROM ps_document WHERE document_num = '3536' AND id_document != '94341' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 10/12/2024 10:13:43 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3536', document_date = '2024-11-19', 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 = '21.00', price_tax_excluded = '21.00', date_upd = NOW() WHERE id_document = '94341' 10/12/2024 10:13:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94341' 10/12/2024 10:13:44 am >> DELETE FROM ps_document_detail WHERE id_document = '94341' 10/12/2024 10:13:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94341' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '560' , '-560' , '4' , '0.0300' , '0.03' , '0' , '0' , '16.80' ) 10/12/2024 10:13:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94341' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '1' , '-1' , '4' , '4.2' , '4.2' , '0' , '0' , '4.20' ) 10/12/2024 10:14:07 am >> SELECT document_num FROM ps_document WHERE document_num = '3541' AND id_document != '94350' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 10/12/2024 10:14:07 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3541', document_date = '2024-11-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA CONVENTO 83025 MONTORO', 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 = '100.00', price_tax_excluded = '100.00', date_upd = NOW() WHERE id_document = '94350' 10/12/2024 10:14: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 = '94350' 10/12/2024 10:14:07 am >> DELETE FROM ps_document_detail WHERE id_document = '94350' 10/12/2024 10:14: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 ( '94350' , '5444' , 'IO SONO CON VOI - CAT.' , '4' , '-4' , '4' , '5.5000' , '5.5' , '0' , '5' , '20.90' ) 10/12/2024 10:14: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 ( '94350' , '11193' , 'VENITE CON ME CAT.' , '4' , '-4' , '4' , '5.5000' , '5.5' , '0' , '5' , '20.90' ) 10/12/2024 10:14: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 ( '94350' , '5446' , 'IO SONO CON VOI - GUIDA' , '4' , '-4' , '4' , '8.0000' , '8' , '0' , '15' , '27.20' ) 10/12/2024 10:14: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 ( '94350' , '11183' , 'VENITE CON ME - GUIDA' , '4' , '-4' , '4' , '8.0000' , '8' , '0' , '15' , '27.20' ) 10/12/2024 10:14: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 ( '94350' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '1' , '-1' , '4' , '3.8' , '3.8' , '0' , '0' , '3.80' ) 10/12/2024 10:14:37 am >> SELECT document_num FROM ps_document WHERE document_num = '3678' AND id_document != '94531' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-27') 10/12/2024 10:14:37 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3678', document_date = '2024-11-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 = '12.00', price_tax_excluded = '12.00', date_upd = NOW() WHERE id_document = '94531' 10/12/2024 10:14:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94531' 10/12/2024 10:14:37 am >> DELETE FROM ps_document_detail WHERE id_document = '94531' 10/12/2024 10:14:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94531' , '22961' , 'UN BAMBINO E NATO PER NOI - G. VALSECCHI' , '6' , '-6' , '4' , '2' , '2' , '0' , '0' , '12.00' ) 10/12/2024 10:15:09 am >> SELECT document_num FROM ps_document WHERE document_num = '3711' AND id_document != '94571' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-29') 10/12/2024 10:15:09 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3711', document_date = '2024-11-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '22.00', price_tax_excluded = '18.39', date_upd = NOW() WHERE id_document = '94571' 10/12/2024 10:15: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 = '94571' 10/12/2024 10:15:09 am >> DELETE FROM ps_document_detail WHERE id_document = '94571' 10/12/2024 10:15: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 ( '94571' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '80' , '-80' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '20.00' ) 10/12/2024 10:15: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 ( '94571' , '22961' , 'UN BAMBINO E NATO PER NOI - G. VALSECCHI' , '1' , '-1' , '4' , '2' , '2' , '0' , '0' , '2.00' ) 10/12/2024 10:16:02 am >> SELECT document_num FROM ps_document WHERE document_num = '3342' AND id_document != '94075' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-06') 10/12/2024 10:16:02 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3342', document_date = '2024-11-06', 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 = '42.80', price_tax_excluded = '39.72', date_upd = NOW() WHERE id_document = '94075' 10/12/2024 10:16:02 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94075' 10/12/2024 10:16:02 am >> DELETE FROM ps_document_detail WHERE id_document = '94075' 10/12/2024 10:16:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94075' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '6.00' ) 10/12/2024 10:16:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94075' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '7.9000' , '6.4754098360656' , '22' , '0' , '15.80' ) 10/12/2024 10:16:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94075' , '22961' , 'UN BAMBINO E NATO PER NOI - G. VALSECCHI' , '7' , '-7' , '4' , '3.00' , '3' , '0' , '0' , '21.00' ) 10/12/2024 11:03:51 am >> SELECT document_num FROM ps_document WHERE document_num = '3884' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-10') 10/12/2024 11:03:51 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3884' , '2024-12-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '4.92' , NOW() , NOW() ) 10/12/2024 11:03: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 = '94786' 10/12/2024 11:03:51 am >> DELETE FROM ps_document_detail WHERE id_document = '94786' 10/12/2024 11:03: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 ( '94786' , '20520' , 'QUADRETTO ANGELO DI DIO - 5024-AD' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 10/12/2024 11:09:28 am >> SELECT document_num FROM ps_document WHERE document_num = '3885' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-10') 10/12/2024 11:09:28 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' , '3885' , '2024-12-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.10' , '5.99' , NOW() , NOW() ) 10/12/2024 11:09:28 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 = '94787' 10/12/2024 11:09:28 am >> DELETE FROM ps_document_detail WHERE id_document = '94787' 10/12/2024 11:09:28 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 ( '94787' , '15846' , 'CARLO ACUTIS - F. OCCHETTA' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '0' , '5.50' ) 10/12/2024 11:09:28 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 ( '94787' , '20956' , 'BEATO CARLO ACUTIS - 64' , '3' , '-3' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '0.60' ) 10/12/2024 11:24:33 am >> SELECT document_num FROM ps_document WHERE document_num = '3886' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-10') 10/12/2024 11:24:33 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3886' , '2024-12-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.25' , '15.00' , NOW() , NOW() ) 10/12/2024 11:24: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 = '94788' 10/12/2024 11:24:33 am >> DELETE FROM ps_document_detail WHERE id_document = '94788' 10/12/2024 11:24: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 ( '94788' , '18009' , 'SCALA PIU CORTA PER SALIRE IN CIELO - 8011' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 10/12/2024 11:24: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 ( '94788' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '1' , '-1' , '1' , '12.50' , '10.245901639344' , '22' , '0' , '12.50' ) 10/12/2024 11:49:16 am >> SELECT document_num FROM ps_document WHERE document_num = '3887' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-10') 10/12/2024 11:49:16 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3887' , '2024-12-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 10/12/2024 11:49: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 = '94789' 10/12/2024 11:49:16 am >> DELETE FROM ps_document_detail WHERE id_document = '94789' 10/12/2024 11:49: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 ( '94789' , '23294' , 'FOLLEMENTE CORRETTO ' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 10/12/2024 04:00:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '26' AND id_document != '93680' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2024-10-17') 10/12/2024 04:00:31 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '26', document_date = '2024-10-17', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2633', address1 = 'VIA GALVANI, 1 60020 CAMERATA PICENA', address2 = '', note = 'RESA - N.C. RICEVUTA', 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 = '358.00', price_tax_excluded = '358.00', date_upd = NOW() WHERE id_document = '93680' 10/12/2024 04:00: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 = '93680' 10/12/2024 04:00:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '93680' 10/12/2024 04:00: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 ( '93680' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '46' , '-46' , '4' , '5.0000' , '5' , '0' , '0' , '230.00' ) 10/12/2024 04:00: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 ( '93680' , '22693' , 'SULLA TUA PAROLA - SET/OTT 2024' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 10/12/2024 04:00: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 ( '93680' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '6' , '-6' , '4' , '5.0000' , '5' , '0' , '0' , '30.00' ) 10/12/2024 04:00: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 ( '93680' , '15795' , 'CARLO ACUTIS - 8950' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 10/12/2024 04:00: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 ( '93680' , '19114' , 'GUARIGIONE DELLA FAMIGLIA FELICE - 8049' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 10/12/2024 04:00: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 ( '93680' , '8206' , 'POTENZE MALEFICHE' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 10/12/2024 04:00: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 ( '93680' , '15677' , 'SE CREDERAI VEDRAI LA GLORIA DI DIO - 8965' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 10/12/2024 04:00: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 ( '93680' , '16441' , 'PREGHIERE DEGLI OBLATI DI S. GIUSEPPE - 8633' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 10/12/2024 04:00:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93680' , '18328' , 'SANTA FAMIGLIA DI GESU - 8469 ' , '2' , '-2' , '4' , '3.0000' , '3' , '0' , '0' , '6.00' ) 10/12/2024 04:00:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93680' , '19115' , 'NOTTE DI PASSIONE - 8051' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 10/12/2024 04:00:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93680' , '17830' , 'VIA CARITATIS. VIA CRUCIS CON CARLO ACUTIS - 8010' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 10/12/2024 04:00:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93680' , '18010' , 'DISCEPOLO AMATO - 8012' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 10/12/2024 04:00:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93680' , '18804' , 'NOVENA AL NATALE - 8045' , '6' , '-6' , '4' , '3.0000' , '3' , '0' , '0' , '18.00' ) 10/12/2024 04:00:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93680' , '15962' , 'PREGHIERE AI DOLORI E ALLE LACRIME DELLA MADONNA - 8182' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 10/12/2024 04:00:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93680' , '20897' , 'ELISE BISSCHOP - 8470' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 10/12/2024 04:06:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000003659' AND id_product != '22931' AND ean13 != '' 10/12/2024 04:06:28 pm >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '1000000003659', date_upd = NOW() WHERE id_product = '22931' 10/12/2024 04:06:28 pm >> UPDATE ps_product_lang SET name = 'FINTA CANDELA CON CARTUCCIA 3,2 X 25 - 1131', description = '' WHERE id_product = '22931' 10/12/2024 04:06:28 pm >> UPDATE ps_product SET wholesale_price = '9.03', on_sale = '0', price = '18.8525' WHERE id_product = '22931' 10/12/2024 04:06:28 pm >> UPDATE ps_product_shop SET wholesale_price = '9.03', price = '18.8525', id_tax_rules_group = '1', id_category_default = '147', 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 = '22931' 10/12/2024 04:06:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '22931' 10/12/2024 04:19:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '3888' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-10') 10/12/2024 04:19: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' , '3888' , '2024-12-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '44.80' , '39.56' , NOW() , NOW() ) 10/12/2024 04:19: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 = '94790' 10/12/2024 04:19:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '94790' 10/12/2024 04:19: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 ( '94790' , '23155' , 'VITA CRISTIANA 2025' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 10/12/2024 04:19: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 ( '94790' , '22910' , 'AGENDA DEVOZIONALE 2025 - 40822' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '5' , '19.00' ) 10/12/2024 04:19: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 ( '94790' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 10/12/2024 04:19: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 ( '94790' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 10/12/2024 04:19: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 ( '94790' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 10/12/2024 04:19: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 ( '94790' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 10/12/2024 04:33:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '3889' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-10') 10/12/2024 04:33:32 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' , '3889' , '2024-12-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.90' , '40.85' , NOW() , NOW() ) 10/12/2024 04:33:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94791' 10/12/2024 04:33:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '94791' 10/12/2024 04:33:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94791' , '20157' , 'ALBERO DI NATALE - MIX' , '10' , '-10' , '1' , '2.30' , '1.8852459016393' , '22' , '0' , '23.00' ) 10/12/2024 04:33:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94791' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 10/12/2024 04:33:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94791' , '21991' , 'MIO PRESEPE - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.90' , '17.9' , '0' , '0' , '17.90' ) 10/12/2024 04:40:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '3890' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-10') 10/12/2024 04:40:35 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' , '3890' , '2024-12-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '45.00' , NOW() , NOW() ) 10/12/2024 04:40:35 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 = '94792' 10/12/2024 04:40:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '94792' 10/12/2024 04:40:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94792' , '1146' , 'BIBBIA DI GERUSALEMME X OCCASIONI ' , '1' , '-1' , '4' , '45.00' , '45' , '0' , '0' , '45.00' ) 10/12/2024 04:47:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '3891' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-10') 10/12/2024 04:47:02 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' , '3891' , '2024-12-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '14.75' , NOW() , NOW() ) 10/12/2024 04:47:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94793' 10/12/2024 04:47:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '94793' 10/12/2024 04:47:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94793' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '3' , '-3' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '18.00' ) 10/12/2024 05:18:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '3892' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2024-12-10') 10/12/2024 05:18:45 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' , '3892' , '2024-12-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '53.00' , '43.44' , NOW() , NOW() ) 10/12/2024 05:18:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94794' 10/12/2024 05:18:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '94794' 10/12/2024 05:18:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94794' , '22870' , 'AGENDA SAN PAOLO 2025' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 10/12/2024 05:18:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94794' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 10/12/2024 05:18:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94794' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 10/12/2024 05:28:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '3873' AND id_document != '94774' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-09') 10/12/2024 05:28:03 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3873', document_date = '2024-12-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '3.00', price_tax_excluded = '3.00', date_upd = NOW() WHERE id_document = '94774' 10/12/2024 05:28: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 = '94774' 10/12/2024 05:28:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '94774' 10/12/2024 05:28: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 ( '94774' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 10/12/2024 05:30:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '3893' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-10') 10/12/2024 05:30:16 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' , '3893' , '2024-12-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.50' , '6.15' , NOW() , NOW() ) 10/12/2024 05:30:16 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 = '94795' 10/12/2024 05:30:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '94795' 10/12/2024 05:30:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94795' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '25' , '-25' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '7.50' ) 10/12/2024 05:40:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '3894' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-10') 10/12/2024 05:40:16 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' , '3894' , '2024-12-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.90' , '18.03' , NOW() , NOW() ) 10/12/2024 05:40:16 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 = '94796' 10/12/2024 05:40:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '94796' 10/12/2024 05:40:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94796' , '16409' , 'RICAMBIO VETRO - 32/V' , '1' , '-1' , '1' , '15.90' , '13.032786885246' , '22' , '0' , '15.90' ) 10/12/2024 05:40:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94796' , '23253' , 'PAROLE CHIAVE PER LAVVENTO - R. LAURITA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 10/12/2024 06:20:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '3650' AND id_document != '94497' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-26') 10/12/2024 06:20:30 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3650', document_date = '2024-11-26', 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 = '149.70', price_tax_excluded = '124.45', date_upd = NOW() WHERE id_document = '94497' 10/12/2024 06:20: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 = '94497' 10/12/2024 06:20:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '94497' 10/12/2024 06:20: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 ( '94497' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.15' , '1.15' , '0' , '0' , '1.15' ) 10/12/2024 06:20: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 ( '94497' , '14354' , 'CAMICE BENEDETTINO LINO - 3010' , '1' , '-1' , '1' , '140.0000' , '114.75409836066' , '22' , '0' , '140.00' ) 10/12/2024 06:20: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 ( '94497' , '22749' , 'PAROLA E I GIORNI 2025' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 10/12/2024 06:40:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '3895' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-10') 10/12/2024 06:40: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' , '3895' , '2024-12-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.90' , '5.66' , NOW() , NOW() ) 10/12/2024 06:40: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 = '94797' 10/12/2024 06:40:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '94797' 10/12/2024 06:40: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 ( '94797' , '11756' , 'VINO BIANCO SECCO - 14%' , '1' , '-1' , '1' , '6.90' , '5.655737704918' , '22' , '0' , '6.90' ) 10/12/2024 06:50:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '3601' AND id_document != '94428' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-22') 10/12/2024 06:50:29 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3601', document_date = '2024-11-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '18.40', price_tax_excluded = '15.71', date_upd = NOW() WHERE id_document = '94428' 10/12/2024 06:50:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94428' 10/12/2024 06:50:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '94428' 10/12/2024 06:50:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94428' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 10/12/2024 06:50:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94428' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '8' , '6.5573770491803' , '22' , '0' , '8.00' ) 10/12/2024 06:50: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 ( '94428' , '11756' , 'VINO BIANCO SECCO - 14%' , '1' , '-1' , '1' , '6.90' , '5.655737704918' , '22' , '0' , '6.90' ) 10/12/2024 06:59:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '3781' AND id_document != '94667' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-03') 10/12/2024 06:59:09 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3781', document_date = '2024-12-03', 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 = '25.00', price_tax_excluded = '20.49', date_upd = NOW() WHERE id_document = '94667' 10/12/2024 06:59:09 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 = '94667' 10/12/2024 06:59:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '94667' 10/12/2024 06:59:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94667' , '21853' , 'CROCE MOGANO CON BASE - CLB263ARG ' , '1' , '-1' , '1' , '25' , '20.491803278689' , '22' , '0' , '25.00' ) 10/12/2024 06:59:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '3470' AND id_document != '94251' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-14') 10/12/2024 06:59:30 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3470', document_date = '2024-11-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '80.00', price_tax_excluded = '66.85', date_upd = NOW() WHERE id_document = '94251' 10/12/2024 06:59: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 = '94251' 10/12/2024 06:59:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '94251' 10/12/2024 06:59: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 ( '94251' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '10' , '-10' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '22.00' ) 10/12/2024 06:59: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 ( '94251' , '1936' , 'CERETTI DIAM 26X700 ART. 400' , '3' , '-3' , '1' , '3.9000' , '3.1967213114754' , '22' , '0' , '11.70' ) 10/12/2024 06:59: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 ( '94251' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 10/12/2024 06:59: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 ( '94251' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 10/12/2024 06:59: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 ( '94251' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 10/12/2024 06:59: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 ( '94251' , '12833' , 'BOTTONE RETROCOLLO - 21630' , '1' , '-1' , '1' , '2.3' , '1.8852459016393' , '22' , '0' , '2.30' ) 10/12/2024 06:59: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 ( '94251' , '23090' , 'ALBERO CON PRESEPE ' , '1' , '-1' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '25.00' ) 10/12/2024 07:00:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '3177' AND id_document != '93825' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-24') 10/12/2024 07:00:25 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3177', document_date = '2024-10-24', 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 = '58.72', price_tax_excluded = '58.72', date_upd = NOW() WHERE id_document = '93825' 10/12/2024 07:00:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93825' 10/12/2024 07:00:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '93825' 10/12/2024 07:00:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93825' , '3603' , 'DOCAT' , '1' , '-1' , '4' , '12.9000' , '12.9' , '0' , '5' , '12.26' ) 10/12/2024 07:00:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93825' , '22099' , 'YOUCAT' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 10/12/2024 07:00:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93825' , '15763' , 'YOUCAT FOR KIDS' , '1' , '-1' , '4' , '15.26' , '15.26' , '0' , '' , '15.26' ) 10/12/2024 07:00:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93825' , '10794' , 'TUTTI I SALMI A CARATTERI GRANDI' , '2' , '-2' , '4' , '7.0000' , '7' , '0' , '5' , '13.30' ) 10/12/2024 07:00:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93825' , '22698' , 'CALENDARIO LITURGICO 2025' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 10/12/2024 07:01:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '3434' AND id_document != '94197' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-12') 10/12/2024 07:01:02 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3434', document_date = '2024-11-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 = '3.30', price_tax_excluded = '3.30', date_upd = NOW() WHERE id_document = '94197' 10/12/2024 07:01:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94197' 10/12/2024 07:01:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '94197' 10/12/2024 07:01:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94197' , '13463' , 'PREGHIERE DEI RAGAZZI - N.E.' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 10/12/2024 07:01:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94197' , '23165' , 'DILEXIT NOS' , '1' , '-1' , '4' , '1.8' , '1.8' , '0' , '0' , '1.80' ) 10/12/2024 07:15:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000406' AND id_product != '6402' AND ean13 != '' 10/12/2024 07:15:02 pm >> UPDATE ps_product SET id_supplier = '31', reference = '2013', ean13 = '000406', date_upd = NOW() WHERE id_product = '6402' 10/12/2024 07:15:02 pm >> UPDATE ps_product_lang SET name = 'MENSA BIANCA 60X200 ', description = '' WHERE id_product = '6402' 10/12/2024 07:15:02 pm >> UPDATE ps_product SET wholesale_price = '2.82', on_sale = '0', price = '6.147540983606557' WHERE id_product = '6402' 10/12/2024 07:15:02 pm >> UPDATE ps_product_shop SET wholesale_price = '2.82', price = '6.147540983606557', id_tax_rules_group = '1', id_category_default = '169', 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 = '6402' 10/12/2024 07:15:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '6402' 10/12/2024 07:29:40 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'TRc2ClvKZ9s2Tk7T' , NOW() , NOW() ) 10/12/2024 07:29:40 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4148' , '1' ) 10/12/2024 07:29:40 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4148' , '2' ) 10/12/2024 07:29:40 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4148' , '3' ) 10/12/2024 07:32:22 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4148' 10/12/2024 07:32:22 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4148' , '10' , '210' , 'PROMETEO82 SOC. COOP. SOC.' , '' , '' , 'VIA TANAGRO 12' , '' , '84135' , 'salerno' , '' , '' , '' , '01732420656' , '' , NOW() , NOW() ) 10/12/2024 07:32:22 pm >> UPDATE ps_customer SET email = 'info@prometeo82.it', sdi = '5RU082D', pec = 'cooperativasocialeprometeo82@pec.confcooperative.it', date_upd = NOW() WHERE id_customer = '4148' 10/12/2024 07:33:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '21/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-10') 10/12/2024 07:33:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '21/L' , '2024-12-10' , 'L' , '4148' , '0' , '4679447' , 'VIA TANAGRO 12 84135 salerno' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '35.00' , '28.69' , NOW() , NOW() ) 10/12/2024 07:33:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94798' 10/12/2024 07:33:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '94798' 10/12/2024 07:33:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94798' , '' , 'presepe' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 10/12/2024 07:36:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '3896' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-10') 10/12/2024 07:36:00 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' , '3896' , '2024-12-10' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 10/12/2024 07:36:00 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 = '94799' 10/12/2024 07:36:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '94799' 10/12/2024 07:36:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94799' , '940' , 'BAMBINO CM 4 - FOSFORO - P1' , '100' , '-100' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '30.00' )