19/06/2024 09:10:44 am >> SELECT document_num FROM ps_document WHERE document_num = '2026' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-19') 19/06/2024 09:10:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2026' , '2024-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.80' , '6.39' , NOW() , NOW() ) 19/06/2024 09:10: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 = '92333' 19/06/2024 09:10:44 am >> DELETE FROM ps_document_detail WHERE id_document = '92333' 19/06/2024 09:10: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 ( '92333' , '1936' , 'CERETTI DIAM 26X700 ART. 400' , '2' , '-2' , '1' , '3.90' , '3.1967213114754' , '22' , '0' , '7.80' ) 19/06/2024 09:32:05 am >> DELETE FROM ps_product WHERE id_product = '7836' 19/06/2024 09:32:05 am >> DELETE FROM ps_product_shop WHERE id_product = '7836' 19/06/2024 09:32:05 am >> DELETE FROM ps_product_lang WHERE id_product = '7836' 19/06/2024 09:32:05 am >> DELETE FROM ps_stock_available WHERE id_product = '7836' 19/06/2024 09:34:18 am >> DELETE FROM ps_product WHERE id_product = '10383' 19/06/2024 09:34:18 am >> DELETE FROM ps_product_shop WHERE id_product = '10383' 19/06/2024 09:34:18 am >> DELETE FROM ps_product_lang WHERE id_product = '10383' 19/06/2024 09:34:18 am >> DELETE FROM ps_stock_available WHERE id_product = '10383' 19/06/2024 09:34:33 am >> DELETE FROM ps_product WHERE id_product = '6107' 19/06/2024 09:34:33 am >> DELETE FROM ps_product_shop WHERE id_product = '6107' 19/06/2024 09:34:33 am >> DELETE FROM ps_product_lang WHERE id_product = '6107' 19/06/2024 09:34:33 am >> DELETE FROM ps_stock_available WHERE id_product = '6107' 19/06/2024 09:34:49 am >> DELETE FROM ps_product WHERE id_product = '5508' 19/06/2024 09:34:49 am >> DELETE FROM ps_product_shop WHERE id_product = '5508' 19/06/2024 09:34:49 am >> DELETE FROM ps_product_lang WHERE id_product = '5508' 19/06/2024 09:34:49 am >> DELETE FROM ps_stock_available WHERE id_product = '5508' 19/06/2024 09:35:02 am >> DELETE FROM ps_product WHERE id_product = '559' 19/06/2024 09:35:02 am >> DELETE FROM ps_product_shop WHERE id_product = '559' 19/06/2024 09:35:02 am >> DELETE FROM ps_product_lang WHERE id_product = '559' 19/06/2024 09:35:02 am >> DELETE FROM ps_stock_available WHERE id_product = '559' 19/06/2024 09:35:17 am >> DELETE FROM ps_product WHERE id_product = '2563' 19/06/2024 09:35:17 am >> DELETE FROM ps_product_shop WHERE id_product = '2563' 19/06/2024 09:35:17 am >> DELETE FROM ps_product_lang WHERE id_product = '2563' 19/06/2024 09:35:18 am >> DELETE FROM ps_stock_available WHERE id_product = '2563' 19/06/2024 09:40:20 am >> DELETE FROM ps_product WHERE id_product = '8753' 19/06/2024 09:40:20 am >> DELETE FROM ps_product_shop WHERE id_product = '8753' 19/06/2024 09:40:20 am >> DELETE FROM ps_product_lang WHERE id_product = '8753' 19/06/2024 09:40:20 am >> DELETE FROM ps_stock_available WHERE id_product = '8753' 19/06/2024 09:42:29 am >> DELETE FROM ps_product WHERE id_product = '10522' 19/06/2024 09:42:29 am >> DELETE FROM ps_product_shop WHERE id_product = '10522' 19/06/2024 09:42:29 am >> DELETE FROM ps_product_lang WHERE id_product = '10522' 19/06/2024 09:42:29 am >> DELETE FROM ps_stock_available WHERE id_product = '10522' 19/06/2024 09:42:46 am >> DELETE FROM ps_product WHERE id_product = '2637' 19/06/2024 09:42:46 am >> DELETE FROM ps_product_shop WHERE id_product = '2637' 19/06/2024 09:42:46 am >> DELETE FROM ps_product_lang WHERE id_product = '2637' 19/06/2024 09:42:46 am >> DELETE FROM ps_stock_available WHERE id_product = '2637' 19/06/2024 09:47:46 am >> DELETE FROM ps_product WHERE id_product = '11116' 19/06/2024 09:47:46 am >> DELETE FROM ps_product_shop WHERE id_product = '11116' 19/06/2024 09:47:46 am >> DELETE FROM ps_product_lang WHERE id_product = '11116' 19/06/2024 09:47:46 am >> DELETE FROM ps_stock_available WHERE id_product = '11116' 19/06/2024 09:48:10 am >> DELETE FROM ps_product WHERE id_product = '9349' 19/06/2024 09:48:10 am >> DELETE FROM ps_product_shop WHERE id_product = '9349' 19/06/2024 09:48:10 am >> DELETE FROM ps_product_lang WHERE id_product = '9349' 19/06/2024 09:48:10 am >> DELETE FROM ps_stock_available WHERE id_product = '9349' 19/06/2024 09:48:43 am >> DELETE FROM ps_product WHERE id_product = '871' 19/06/2024 09:48:43 am >> DELETE FROM ps_product_shop WHERE id_product = '871' 19/06/2024 09:48:43 am >> DELETE FROM ps_product_lang WHERE id_product = '871' 19/06/2024 09:48:43 am >> DELETE FROM ps_stock_available WHERE id_product = '871' 19/06/2024 09:49:02 am >> DELETE FROM ps_product WHERE id_product = '10714' 19/06/2024 09:49:02 am >> DELETE FROM ps_product_shop WHERE id_product = '10714' 19/06/2024 09:49:02 am >> DELETE FROM ps_product_lang WHERE id_product = '10714' 19/06/2024 09:49:02 am >> DELETE FROM ps_stock_available WHERE id_product = '10714' 19/06/2024 09:50:15 am >> DELETE FROM ps_product WHERE id_product = '10357' 19/06/2024 09:50:15 am >> DELETE FROM ps_product_shop WHERE id_product = '10357' 19/06/2024 09:50:15 am >> DELETE FROM ps_product_lang WHERE id_product = '10357' 19/06/2024 09:50:15 am >> DELETE FROM ps_stock_available WHERE id_product = '10357' 19/06/2024 09:50:30 am >> DELETE FROM ps_product WHERE id_product = '9810' 19/06/2024 09:50:30 am >> DELETE FROM ps_product_shop WHERE id_product = '9810' 19/06/2024 09:50:30 am >> DELETE FROM ps_product_lang WHERE id_product = '9810' 19/06/2024 09:50:30 am >> DELETE FROM ps_stock_available WHERE id_product = '9810' 19/06/2024 09:50:46 am >> DELETE FROM ps_product WHERE id_product = '7076' 19/06/2024 09:50:46 am >> DELETE FROM ps_product_shop WHERE id_product = '7076' 19/06/2024 09:50:46 am >> DELETE FROM ps_product_lang WHERE id_product = '7076' 19/06/2024 09:50:46 am >> DELETE FROM ps_stock_available WHERE id_product = '7076' 19/06/2024 09:51:34 am >> DELETE FROM ps_product WHERE id_product = '7744' 19/06/2024 09:51:34 am >> DELETE FROM ps_product_shop WHERE id_product = '7744' 19/06/2024 09:51:34 am >> DELETE FROM ps_product_lang WHERE id_product = '7744' 19/06/2024 09:51:34 am >> DELETE FROM ps_stock_available WHERE id_product = '7744' 19/06/2024 09:51:49 am >> DELETE FROM ps_product WHERE id_product = '10725' 19/06/2024 09:51:49 am >> DELETE FROM ps_product_shop WHERE id_product = '10725' 19/06/2024 09:51:49 am >> DELETE FROM ps_product_lang WHERE id_product = '10725' 19/06/2024 09:51:49 am >> DELETE FROM ps_stock_available WHERE id_product = '10725' 19/06/2024 09:57:09 am >> DELETE FROM ps_product WHERE id_product = '11835' 19/06/2024 09:57:09 am >> DELETE FROM ps_product_shop WHERE id_product = '11835' 19/06/2024 09:57:09 am >> DELETE FROM ps_product_lang WHERE id_product = '11835' 19/06/2024 09:57:09 am >> DELETE FROM ps_stock_available WHERE id_product = '11835' 19/06/2024 09:58:52 am >> DELETE FROM ps_product WHERE id_product = '1447' 19/06/2024 09:58:52 am >> DELETE FROM ps_product_shop WHERE id_product = '1447' 19/06/2024 09:58:52 am >> DELETE FROM ps_product_lang WHERE id_product = '1447' 19/06/2024 09:58:52 am >> DELETE FROM ps_stock_available WHERE id_product = '1447' 19/06/2024 10:05:05 am >> DELETE FROM ps_product WHERE id_product = '3404' 19/06/2024 10:05:05 am >> DELETE FROM ps_product_shop WHERE id_product = '3404' 19/06/2024 10:05:05 am >> DELETE FROM ps_product_lang WHERE id_product = '3404' 19/06/2024 10:05:05 am >> DELETE FROM ps_stock_available WHERE id_product = '3404' 19/06/2024 10:27:48 am >> SELECT document_num FROM ps_document WHERE document_num = '1590' AND id_document != '91805' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-15') 19/06/2024 10:27:48 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1590', document_date = '2024-05-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '70.00', price_tax_excluded = '61.67', date_upd = NOW() WHERE id_document = '91805' 19/06/2024 10:27:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91805' 19/06/2024 10:27:48 am >> DELETE FROM ps_document_detail WHERE id_document = '91805' 19/06/2024 10:27:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91805' , '20026' , 'CANDELA VOTIVA 20X40' , '4' , '-4' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '6.00' ) 19/06/2024 10:27:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91805' , '18357' , 'MIE PREGHIERINE N.E.' , '6' , '-6' , '4' , '1.5000' , '1.5' , '0' , '5' , '8.58' ) 19/06/2024 10:27:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91805' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '5' , '-5' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '3.50' ) 19/06/2024 10:27:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91805' , '13830' , 'VANGELO E ATTI - ECOPELLE BIANCA - 8592' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '5' , '3.80' ) 19/06/2024 10:27:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91805' , '21407' , 'GIORNO DELLA PRIMA COMUNIONE' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 19/06/2024 10:27:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91805' , '15932' , 'PORTAFOTO' , '1' , '-1' , '1' , '36.7200' , '30.098360655738' , '22' , '0' , '36.72' ) 19/06/2024 10:48:04 am >> SELECT document_num FROM ps_document WHERE document_num = '2027' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-19') 19/06/2024 10:48: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 ( '11' , '2027' , '2024-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.90' , '14.67' , NOW() , NOW() ) 19/06/2024 10:48: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 = '92334' 19/06/2024 10:48:04 am >> DELETE FROM ps_document_detail WHERE id_document = '92334' 19/06/2024 10:48: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 ( '92334' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 19/06/2024 10:48: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 ( '92334' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 19/06/2024 11:30:40 am >> SELECT document_num FROM ps_document WHERE document_num = '2028' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2024-06-19') 19/06/2024 11:30:40 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2028' , '2024-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '46.85' , '38.40' , NOW() , NOW() ) 19/06/2024 11:30:40 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92335' 19/06/2024 11:30:40 am >> DELETE FROM ps_document_detail WHERE id_document = '92335' 19/06/2024 11:30:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92335' , '16244' , 'QUADRO 10X10' , '1' , '-1' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '13.50' ) 19/06/2024 11:30:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92335' , '19015' , 'BRACCIALI MULTICOLOR CON DECINA' , '2' , '-2' , '1' , '4.00' , '3.2786885245902' , '22' , '0' , '8.00' ) 19/06/2024 11:30:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92335' , '18391' , 'CATENINA ACCIAIO 10 ESSENZE' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 19/06/2024 11:30:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92335' , '16022' , 'PREGHIERA DI UNA MAMMA IN ATTESA' , '1' , '-1' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '0.20' ) 19/06/2024 11:30:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92335' , '9799' , 'SEGNALIBRO M. TERESA - 126' , '1' , '-1' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '0.15' ) 19/06/2024 11:34:27 am >> SELECT document_num FROM ps_document WHERE document_num = '2029' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2024-06-19') 19/06/2024 11:34:27 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2029' , '2024-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.00' , '34.43' , NOW() , NOW() ) 19/06/2024 11:34:27 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92336' 19/06/2024 11:34:27 am >> DELETE FROM ps_document_detail WHERE id_document = '92336' 19/06/2024 11:34:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92336' , '22257' , 'QUADRO DECORATO 36X22' , '1' , '-1' , '1' , '42.00' , '34.426229508197' , '22' , '0' , '42.00' ) 19/06/2024 11:37:21 am >> SELECT document_num FROM ps_document WHERE document_num = '2030' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-19') 19/06/2024 11:37:21 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' , '2030' , '2024-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '41.38' , '41.38' , NOW() , NOW() ) 19/06/2024 11:37:21 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 = '92337' 19/06/2024 11:37:21 am >> DELETE FROM ps_document_detail WHERE id_document = '92337' 19/06/2024 11:37:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92337' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 19/06/2024 11:37:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92337' , '22557' , 'PAROLA E PREGHIERA - AGO 2024' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 19/06/2024 11:37:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92337' , '22474' , 'PAROLA E PREGHIERA - LUG 2024' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 19/06/2024 11:37:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92337' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 19/06/2024 11:37:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92337' , '22448' , 'PREGHIERA DI MARIA - 7' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 19/06/2024 11:37:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92337' , '22111' , 'PREGARE OGGI - 1' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 19/06/2024 11:39:58 am >> SELECT document_num FROM ps_document WHERE document_num = '2031' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-19') 19/06/2024 11:39:58 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2031' , '2024-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.80' , '8.57' , NOW() , NOW() ) 19/06/2024 11:39:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92338' 19/06/2024 11:39:58 am >> DELETE FROM ps_document_detail WHERE id_document = '92338' 19/06/2024 11:39:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92338' , '17423' , 'CARLO ACUTIS' , '1' , '-1' , '4' , '7.50' , '7.5' , '0' , '0' , '7.50' ) 19/06/2024 11:39:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92338' , '22547' , 'ROSARIO LEGNO COLORATO - R07' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 19/06/2024 12:00:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '2032' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-19') 19/06/2024 12:00:21 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' , '2032' , '2024-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.26' , '12.26' , NOW() , NOW() ) 19/06/2024 12:00:21 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 = '92339' 19/06/2024 12:00:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '92339' 19/06/2024 12:00:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92339' , '5832' , 'LIBRO DEI SANTI' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '5' , '12.26' ) 19/06/2024 12:07:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '78/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-06-19') 19/06/2024 12:07:56 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 ( '24' , '78/A' , '2024-06-19' , 'A' , '922' , '0' , '4671011' , 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3215.40' , '3215.40' , NOW() , NOW() ) 19/06/2024 12:07:56 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 = '92340' 19/06/2024 12:07:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '92340' 19/06/2024 12:07:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92340' , '15869' , 'CASULA SATIN RAYE CON RICAMO ' , '1' , '-1' , '0' , '350.00' , '350' , '' , '0' , '350.00' ) 19/06/2024 12:07:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92340' , '19821' , 'CASULA RIGHE - 65/1909' , '1' , '-1' , '0' , '335.00' , '335' , '' , '0' , '335.00' ) 19/06/2024 12:07:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92340' , '19659' , 'CASULA POLIESTERE - 65/18355' , '1' , '-1' , '0' , '355.00' , '355' , '' , '0' , '355.00' ) 19/06/2024 12:07:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92340' , '22233' , 'CAMICE MISTO LANA - 70/000150' , '3' , '-3' , '0' , '225.00' , '225' , '' , '0' , '675.00' ) 19/06/2024 12:07:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92340' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '3' , '-3' , '0' , '42.00' , '42' , '' , '0' , '126.00' ) 19/06/2024 12:07:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92340' , '' , 'calice ' , '1' , '-1' , '0' , '390' , '390' , '' , '0' , '390.00' ) 19/06/2024 12:07:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92340' , '19844' , 'CALICE OTTONE - 131' , '1' , '-1' , '0' , '325.00' , '325' , '' , '0' , '325.00' ) 19/06/2024 12:07:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92340' , '1523' , 'CALICE PELTRO - CM 20 - 698' , '1' , '-1' , '0' , '430.00' , '430' , '' , '0' , '430.00' ) 19/06/2024 12:07:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92340' , '19606' , 'CAMICIA SOTTOTALARE MISTO COTONE- C15' , '5' , '-5' , '0' , '39.00' , '39' , '' , '0' , '195.00' ) 19/06/2024 12:07:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92340' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '5' , '-5' , '4' , '5.00' , '5' , '0' , '0' , '25.00' ) 19/06/2024 12:07:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92340' , '22503' , 'ROSARIO PROFUMATO ROSA MIRACOLOSA - 192/RP6' , '1' , '-1' , '0' , '4.90' , '4.9' , '' , '0' , '4.90' ) 19/06/2024 12:07:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92340' , '2764' , 'CORONA EMATITE TONDA ' , '1' , '-1' , '0' , '4.50' , '4.5' , '' , '0' , '4.50' ) 19/06/2024 12:15:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '1344' AND id_document != '91509' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-30') 19/06/2024 12:15:36 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1344', document_date = '2024-04-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 = '330.00', price_tax_excluded = '270.49', date_upd = NOW() WHERE id_document = '91509' 19/06/2024 12:15:36 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 = '91509' 19/06/2024 12:15:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '91509' 19/06/2024 12:15:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91509' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 19/06/2024 12:15:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91509' , '15869' , 'CASULA SATIN RAYE CON RICAMO ' , '1' , '-1' , '1' , '300' , '245.90163934426' , '22' , '0' , '300.00' ) 19/06/2024 12:16:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '1417' AND id_document != '91594' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-03') 19/06/2024 12:16:27 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1417', document_date = '2024-05-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 = '90.00', price_tax_excluded = '73.77', date_upd = NOW() WHERE id_document = '91594' 19/06/2024 12:16:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91594' 19/06/2024 12:16:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '91594' 19/06/2024 12:16:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91594' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '2' , '-2' , '1' , '40' , '32.786885245902' , '22' , '0' , '80.00' ) 19/06/2024 12:16:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91594' , '22503' , 'ROSARIO PROFUMATO ROSA MIRACOLOSA - 192/RP6' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 19/06/2024 12:16:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91594' , '2764' , 'CORONA EMATITE TONDA ' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 19/06/2024 12:17:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '1420' AND id_document != '91598' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-03') 19/06/2024 12:17:17 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1420', document_date = '2024-05-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 = '4.70', price_tax_excluded = '3.85', date_upd = NOW() WHERE id_document = '91598' 19/06/2024 12:17:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91598' 19/06/2024 12:17:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '91598' 19/06/2024 12:17:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91598' , '15387' , 'VESTINA BATTESIMALE ' , '2' , '-2' , '1' , '2.35' , '1.9262295081967' , '22' , '0' , '4.70' ) 19/06/2024 12:17:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '1427' AND id_document != '91609' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-04') 19/06/2024 12:17:40 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1427', document_date = '2024-05-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 = '560.00', price_tax_excluded = '461.41', date_upd = NOW() WHERE id_document = '91609' 19/06/2024 12:17: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 = '91609' 19/06/2024 12:17:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '91609' 19/06/2024 12:17: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 ( '91609' , '16834' , 'LITURGICO CARTA 8GG' , '24' , '-24' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '72.00' ) 19/06/2024 12:17: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 ( '91609' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '188.7000' , '154.67213114754' , '22' , '0' , '188.70' ) 19/06/2024 12:17: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 ( '91609' , '7202' , 'ARTICOLI RELIGIOSI' , '4' , '-4' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '280.00' ) 19/06/2024 12:17: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 ( '91609' , '22129' , 'PADRE NOSTRO - L. EPICOCO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 19/06/2024 12:17: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 ( '91609' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '3' , '2.4590163934426' , '22' , '0' , '6.00' ) 19/06/2024 12:18:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '1489' AND id_document != '91684' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08') 19/06/2024 12:18:05 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1489', document_date = '2024-05-08', 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 = '95.00', price_tax_excluded = '77.87', date_upd = NOW() WHERE id_document = '91684' 19/06/2024 12:18:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91684' 19/06/2024 12:18:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '91684' 19/06/2024 12:18:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91684' , '22199' , 'VINO LIQUOROSO ROSSO ' , '6' , '-6' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '45.00' ) 19/06/2024 12:18:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91684' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 19/06/2024 12:19:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '1489' AND id_document != '91684' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-08') 19/06/2024 12:19:03 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1489', document_date = '2024-05-08', 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 = '95.00', price_tax_excluded = '77.87', date_upd = NOW() WHERE id_document = '91684' 19/06/2024 12:19: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 = '91684' 19/06/2024 12:19:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '91684' 19/06/2024 12:19:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91684' , '22199' , 'VINO LIQUOROSO ROSSO ' , '6' , '-6' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '45.00' ) 19/06/2024 12:19:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91684' , '16834' , 'LITURGICO CARTA 8GG' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 19/06/2024 12:19:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '1419' AND id_document != '91597' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-03') 19/06/2024 12:19:35 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1419', document_date = '2024-05-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 = '53.00', price_tax_excluded = '43.44', date_upd = NOW() WHERE id_document = '91597' 19/06/2024 12:19: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 = '91597' 19/06/2024 12:19:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '91597' 19/06/2024 12:19: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 ( '91597' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '39' , '31.967213114754' , '22' , '0' , '39.00' ) 19/06/2024 12:19: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 ( '91597' , '16834' , 'LITURGICO CARTA 8GG' , '4' , '-4' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '14.00' ) 19/06/2024 12:20:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '1427' AND id_document != '91609' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-04') 19/06/2024 12:20:03 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1427', document_date = '2024-05-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 = '560.00', price_tax_excluded = '461.41', date_upd = NOW() WHERE id_document = '91609' 19/06/2024 12:20: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 = '91609' 19/06/2024 12:20:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '91609' 19/06/2024 12:20:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91609' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '188.7000' , '154.67213114754' , '22' , '0' , '188.70' ) 19/06/2024 12:20:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91609' , '7202' , 'ARTICOLI RELIGIOSI' , '4' , '-4' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '280.00' ) 19/06/2024 12:20:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91609' , '22129' , 'PADRE NOSTRO - L. EPICOCO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 19/06/2024 12:20:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91609' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '6.00' ) 19/06/2024 12:20:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91609' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '72' , '59.016393442623' , '22' , '0' , '72.00' ) 19/06/2024 12:20:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '2033' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-19') 19/06/2024 12:20:58 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' , '2033' , '2024-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.80' , '1.48' , NOW() , NOW() ) 19/06/2024 12:20:58 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 = '92341' 19/06/2024 12:20:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '92341' 19/06/2024 12:20:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92341' , '22658' , 'CROCE PADRE NOSTRO - 646/PN' , '1' , '-1' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '1.80' ) 19/06/2024 12:22:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '1427' AND id_document != '91609' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-04') 19/06/2024 12:22:43 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1427', document_date = '2024-05-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 = '560.00', price_tax_excluded = '461.41', date_upd = NOW() WHERE id_document = '91609' 19/06/2024 12:22:43 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 = '91609' 19/06/2024 12:22:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '91609' 19/06/2024 12:22:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91609' , '22129' , 'PADRE NOSTRO - L. EPICOCO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 19/06/2024 12:22:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91609' , '19821' , 'CASULA RIGHE - 65/1909' , '1' , '-1' , '1' , '273.35' , '224.05737704918' , '22' , '0' , '273.35' ) 19/06/2024 12:22:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91609' , '19659' , 'CASULA POLIESTERE - 65/18355' , '1' , '-1' , '1' , '273.35' , '224.05737704918' , '22' , '0' , '273.35' ) 19/06/2024 12:23:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '1457' AND id_document != '91647' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-06') 19/06/2024 12:23:11 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1457', document_date = '2024-05-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 = '116.00', price_tax_excluded = '95.08', date_upd = NOW() WHERE id_document = '91647' 19/06/2024 12:23:11 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 = '91647' 19/06/2024 12:23:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '91647' 19/06/2024 12:23:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91647' , '13562' , 'CORONCINA IN STOFFA CON ROSE E FOGLIOLINE - 3311' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 19/06/2024 12:23:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91647' , '22233' , 'CAMICE MISTO LANA - 70/000150' , '1' , '-1' , '1' , '110' , '90.16393442623' , '22' , '0' , '110.00' ) 19/06/2024 12:23:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '1438' AND id_document != '91620' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-06') 19/06/2024 12:23:27 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1438', document_date = '2024-05-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 = '115.50', price_tax_excluded = '95.66', date_upd = NOW() WHERE id_document = '91620' 19/06/2024 12:23:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91620' 19/06/2024 12:23:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '91620' 19/06/2024 12:23:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91620' , '15251' , 'FATE QUESTO IN MEMORIA DI ME' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '0' , '2.50' ) 19/06/2024 12:23:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91620' , '15317' , 'SACRAMENTI SPIEGATI AI RAGAZZI - LA COMUNIONE' , '1' , '-1' , '4' , '1.8000' , '1.8' , '0' , '0' , '1.80' ) 19/06/2024 12:23:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91620' , '5823' , 'LIBRO DORO' , '2' , '-2' , '4' , '0.6000' , '0.6' , '0' , '0' , '1.20' ) 19/06/2024 12:23:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91620' , '22233' , 'CAMICE MISTO LANA - 70/000150' , '1' , '-1' , '1' , '110' , '90.16393442623' , '22' , '0' , '110.00' ) 19/06/2024 12:23:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '1640' AND id_document != '91868' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-17') 19/06/2024 12:23:53 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1640', document_date = '2024-05-17', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '105.60', price_tax_excluded = '86.56', date_upd = NOW() WHERE id_document = '91868' 19/06/2024 12:23:53 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 = '91868' 19/06/2024 12:23:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '91868' 19/06/2024 12:23:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91868' , '22233' , 'CAMICE MISTO LANA - 70/000150' , '1' , '-1' , '1' , '105.6' , '86.55737704918' , '22' , '0' , '105.60' ) 19/06/2024 12:25:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '1858' AND id_document != '92136' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-03') 19/06/2024 12:25:45 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1858', document_date = '2024-06-03', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '-1.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 = '275.00', price_tax_excluded = '225.23', date_upd = NOW() WHERE id_document = '92136' 19/06/2024 12:25: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 = '92136' 19/06/2024 12:25:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '92136' 19/06/2024 12:25: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 ( '92136' , '19844' , 'CALICE OTTONE - 131' , '1' , '-1' , '1' , '276' , '226.22950819672' , '22' , '0' , '276.00' ) 19/06/2024 12:27:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '1988' AND id_document != '92293' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-14') 19/06/2024 12:27:56 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1988', document_date = '2024-06-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '35.00', price_tax_excluded = '35.00', date_upd = NOW() WHERE id_document = '92293' 19/06/2024 12:27:56 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 = '92293' 19/06/2024 12:27:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '92293' 19/06/2024 12:27:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92293' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '10' , '10' , '0' , '0' , '10.00' ) 19/06/2024 12:27:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92293' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '5' , '-5' , '4' , '5.00' , '5' , '0' , '' , '25.00' ) 19/06/2024 12:28:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '1417' AND id_document != '91594' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-03') 19/06/2024 12:28:56 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1417', document_date = '2024-05-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 = '90.00', price_tax_excluded = '73.77', date_upd = NOW() WHERE id_document = '91594' 19/06/2024 12:28:56 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 = '91594' 19/06/2024 12:28:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '91594' 19/06/2024 12:28:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91594' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '2' , '-2' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '80.00' ) 19/06/2024 12:28:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91594' , '22503' , 'ROSARIO PROFUMATO ROSA MIRACOLOSA - 192/RP6' , '1' , '-1' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '5.00' ) 19/06/2024 12:28:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91594' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 19/06/2024 12:29:13 pm >> DELETE FROM ps_document WHERE id_document = '92340' 19/06/2024 12:29:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '92340' 19/06/2024 12:38:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '1419' AND id_document != '91597' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-03') 19/06/2024 12:38:42 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1419', document_date = '2024-05-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 = '53.00', price_tax_excluded = '43.44', date_upd = NOW() WHERE id_document = '91597' 19/06/2024 12:38:42 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 = '91597' 19/06/2024 12:38:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '91597' 19/06/2024 12:38:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91597' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '5.00' ) 19/06/2024 12:38:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91597' , '16834' , 'LITURGICO CARTA 8GG' , '4' , '-4' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '14.00' ) 19/06/2024 12:38:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91597' , '20705' , 'CANDELA CUBO' , '2' , '-2' , '1' , '17.00' , '13.934426229508' , '22' , '0' , '34.00' ) 19/06/2024 03:27:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '2034' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-19') 19/06/2024 03:27:01 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' , '2034' , '2024-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.20' , '20.38' , NOW() , NOW() ) 19/06/2024 03:27:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92342' 19/06/2024 03:27:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '92342' 19/06/2024 03:27:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92342' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '4' , '-4' , '3' , '3.30' , '3.1730769230769' , '4' , '0' , '13.20' ) 19/06/2024 03:27:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92342' , '16689' , 'OSTIA PAN DI CENA mm80' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 19/06/2024 03:31:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '2035' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-19') 19/06/2024 03:31:22 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2035' , '2024-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '1.64' , NOW() , NOW() ) 19/06/2024 03:31:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92343' 19/06/2024 03:31:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '92343' 19/06/2024 03:31:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92343' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '8' , '-8' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '2.00' ) 19/06/2024 04:08:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '2036' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-19') 19/06/2024 04:08:04 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2036' , '2024-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.90' , '4.02' , NOW() , NOW() ) 19/06/2024 04:08:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92344' 19/06/2024 04:08:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '92344' 19/06/2024 04:08: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 ( '92344' , '7942' , 'PERGAMENE - OCCASIONI MOD. B' , '7' , '-7' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '4.90' ) 19/06/2024 04:31:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '2037' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-19') 19/06/2024 04:31:18 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2037' , '2024-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '180.00' , '147.54' , NOW() , NOW() ) 19/06/2024 04:31:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92345' 19/06/2024 04:31:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '92345' 19/06/2024 04:31:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92345' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '80' , '65.573770491803' , '22' , '0' , '80.00' ) 19/06/2024 04:31:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92345' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '100' , '81.967213114754' , '22' , '0' , '100.00' ) 19/06/2024 04:42:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831553346' AND id_product != '17733' AND ean13 != '' 19/06/2024 04:42:27 pm >> UPDATE ps_product SET id_supplier = '7', reference = '4/3', ean13 = '9788831553346', date_upd = NOW() WHERE id_product = '17733' 19/06/2024 04:42:27 pm >> UPDATE ps_product_lang SET name = 'VANGELO E ATTI', description = '' WHERE id_product = '17733' 19/06/2024 04:42:27 pm >> UPDATE ps_product SET wholesale_price = '1.34', on_sale = '0', price = '3' WHERE id_product = '17733' 19/06/2024 04:42:27 pm >> UPDATE ps_product_shop SET wholesale_price = '1.34', price = '3', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '170', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17733' 19/06/2024 04:42:27 pm >> DELETE FROM ps_specific_price WHERE id_product = '17733' 19/06/2024 04:46:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '18' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2024-06-19') 19/06/2024 04:46:19 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 ( '24' , '18' , '2024-06-19' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '774.30' , '773.78' , NOW() , NOW() ) 19/06/2024 04:46:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92346' 19/06/2024 04:46:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '92346' 19/06/2024 04:46:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22068' , 'PAROLA E PREGHIERA - MAR 2024' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 19/06/2024 04:46:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22068' AND id_supplier = '7' 19/06/2024 04:46:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22068' , '7' , '1' ) 19/06/2024 04:46:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22069' , 'PAROLA E PREGHIERA - APR 2024' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 19/06/2024 04:46:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22069' AND id_supplier = '7' 19/06/2024 04:46:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22069' , '7' , '1' ) 19/06/2024 04:46:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21920' , 'AMEN - MAR 24' , '2' , '-2' , '4' , '2.90' , '2.9' , '0' , '0' , '5.80' ) 19/06/2024 04:46:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21920' AND id_supplier = '7' 19/06/2024 04:46:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21920' , '7' , '1' ) 19/06/2024 04:46:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22167' , 'AMEN - MAG. 2024' , '3' , '-3' , '4' , '3.90' , '3.9' , '0' , '0' , '11.70' ) 19/06/2024 04:46:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22167' AND id_supplier = '7' 19/06/2024 04:46:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22167' , '7' , '1' ) 19/06/2024 04:46:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21919' , 'AMEN - APR 24' , '5' , '-5' , '4' , '2.90' , '2.9' , '0' , '0' , '14.50' ) 19/06/2024 04:46:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21919' AND id_supplier = '7' 19/06/2024 04:46:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21919' , '7' , '1' ) 19/06/2024 04:46:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22168' , 'AMEN - GIU. 2024' , '4' , '-4' , '4' , '3.90' , '3.9' , '0' , '0' , '15.60' ) 19/06/2024 04:46:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22168' AND id_supplier = '7' 19/06/2024 04:46:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22168' , '7' , '1' ) 19/06/2024 04:46:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22505' , 'DALLALBA AL TRAMONTO - GIU 24' , '1' , '-1' , '4' , '3.20' , '3.2' , '0' , '0' , '3.20' ) 19/06/2024 04:46:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22505' AND id_supplier = '7' 19/06/2024 04:46:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22505' , '7' , '1' ) 19/06/2024 04:46:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22120' , 'DALLALBA AL TRAMONTO - MAR 2024' , '1' , '-1' , '4' , '3.20' , '3.2' , '0' , '0' , '3.20' ) 19/06/2024 04:46:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22120' AND id_supplier = '7' 19/06/2024 04:46:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22120' , '7' , '1' ) 19/06/2024 04:46:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22085' , 'FATICA DEL CAMMINO - S. DI BENEDETTO' , '3' , '-3' , '4' , '3.00' , '3' , '0' , '0' , '9.00' ) 19/06/2024 04:46:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22085' AND id_supplier = '7' 19/06/2024 04:46:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22085' , '7' , '1' ) 19/06/2024 04:46:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '20748' , 'VERSO LA PASQUA' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 19/06/2024 04:46:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20748' AND id_supplier = '7' 19/06/2024 04:46:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20748' , '7' , '1' ) 19/06/2024 04:46:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22140' , 'QUARESIMA PER I FANNULLONI' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '0' , '6.00' ) 19/06/2024 04:46:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22140' AND id_supplier = '7' 19/06/2024 04:46:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22140' , '7' , '1' ) 19/06/2024 04:46:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22064' , 'QUARESIMA 2024' , '1' , '-1' , '4' , '3.60' , '3.6' , '0' , '0' , '3.60' ) 19/06/2024 04:46:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22064' AND id_supplier = '7' 19/06/2024 04:46:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22064' , '7' , '1' ) 19/06/2024 04:46:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22122' , 'CON TUTTO TE STESSO' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '0' , '2.80' ) 19/06/2024 04:46:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22122' AND id_supplier = '7' 19/06/2024 04:46:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22122' , '7' , '1' ) 19/06/2024 04:46:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22121' , 'CON TE IN PIENEZZA DI VITA ' , '3' , '-3' , '4' , '3.50' , '3.5' , '0' , '0' , '10.50' ) 19/06/2024 04:46:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22121' AND id_supplier = '7' 19/06/2024 04:46:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22121' , '7' , '1' ) 19/06/2024 04:46:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22078' , 'CHICCO DI GRANO - QUARESIMA BAMBINI 2024' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '0' , '5.00' ) 19/06/2024 04:46:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22078' AND id_supplier = '7' 19/06/2024 04:46:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22078' , '7' , '1' ) 19/06/2024 04:46:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22077' , 'QUARESIMA E PASQUA 2024' , '2' , '-2' , '4' , '2.90' , '2.9' , '0' , '0' , '5.80' ) 19/06/2024 04:46:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22077' AND id_supplier = '7' 19/06/2024 04:46:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22077' , '7' , '1' ) 19/06/2024 04:46:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22135' , 'PIEDI IN CAMMINO - 2024' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '0' , '9.90' ) 19/06/2024 04:46:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22135' AND id_supplier = '7' 19/06/2024 04:46:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22135' , '7' , '1' ) 19/06/2024 04:46:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21394' , 'LIBRO DORO DEI PROVERBI DI GESU ' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 19/06/2024 04:46:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21394' AND id_supplier = '7' 19/06/2024 04:46:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21394' , '7' , '1' ) 19/06/2024 04:46:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '4134' , 'FELICI DI CREDERE - ANNO DELLA FEDE' , '2' , '-2' , '4' , '1.50' , '1.5' , '0' , '0' , '3.00' ) 19/06/2024 04:46:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4134' AND id_supplier = '7' 19/06/2024 04:46:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4134' , '7' , '1' ) 19/06/2024 04:46:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '16790' , 'MAMMA E PAPA' , '12' , '-12' , '4' , '1.80' , '1.8' , '0' , '0' , '21.60' ) 19/06/2024 04:46:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16790' AND id_supplier = '7' 19/06/2024 04:46:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16790' , '7' , '1' ) 19/06/2024 04:46:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '17504' , 'O MARIA MAMMA DOLCISSIMA P. PIO - L. REGOLO' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '0' , '7.90' ) 19/06/2024 04:46:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17504' AND id_supplier = '7' 19/06/2024 04:46:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17504' , '7' , '1' ) 19/06/2024 04:46:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '17458' , 'MADONNA REGINA DELLA PACE' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '0' , '7.90' ) 19/06/2024 04:46:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17458' AND id_supplier = '7' 19/06/2024 04:46:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17458' , '7' , '1' ) 19/06/2024 04:46:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '17064' , 'ASSUNTA' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '0' , '7.90' ) 19/06/2024 04:46:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17064' AND id_supplier = '7' 19/06/2024 04:46:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17064' , '7' , '1' ) 19/06/2024 04:46:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '16885' , 'MADONNA DEL ROSARIO' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '0' , '7.90' ) 19/06/2024 04:46:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16885' AND id_supplier = '7' 19/06/2024 04:46:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16885' , '7' , '1' ) 19/06/2024 04:46:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '16896' , 'CUORE IMMACOLATO' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '0' , '7.90' ) 19/06/2024 04:46:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16896' AND id_supplier = '7' 19/06/2024 04:46:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16896' , '7' , '1' ) 19/06/2024 04:46:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '16084' , 'MARIA CHE SCIOGLIE I NODI' , '2' , '-2' , '4' , '7.90' , '7.9' , '0' , '0' , '15.80' ) 19/06/2024 04:46:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16084' AND id_supplier = '7' 19/06/2024 04:46:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16084' , '7' , '1' ) 19/06/2024 04:46:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '17062' , 'MADRE DI DIO E DELLA CHIESA' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '0' , '7.90' ) 19/06/2024 04:46:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17062' AND id_supplier = '7' 19/06/2024 04:46:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17062' , '7' , '1' ) 19/06/2024 04:46:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '16907' , 'MARIA ADDOLORATA' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '0' , '7.90' ) 19/06/2024 04:46:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16907' AND id_supplier = '7' 19/06/2024 04:46:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16907' , '7' , '1' ) 19/06/2024 04:46:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21748' , 'DI PASQUA IN PASQUA - ANNO B - F. ROSINI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 19/06/2024 04:46:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21748' AND id_supplier = '7' 19/06/2024 04:46:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21748' , '7' , '1' ) 19/06/2024 04:46:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22324' , 'ESODO A CARATTERI GRANDI' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '0' , '9.00' ) 19/06/2024 04:46:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22324' AND id_supplier = '7' 19/06/2024 04:46:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22324' , '7' , '1' ) 19/06/2024 04:46:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21025' , 'UN ANNO CON MARIA - A. CANOPI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 19/06/2024 04:46:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21025' AND id_supplier = '7' 19/06/2024 04:46:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21025' , '7' , '1' ) 19/06/2024 04:46:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '19175' , 'OLTRE PIO V - A. GRILLO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 19/06/2024 04:46:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19175' AND id_supplier = '7' 19/06/2024 04:46:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19175' , '7' , '1' ) 19/06/2024 04:46:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '20103' , 'GESU IL COMPIMENTO DELLE SCRITTURE - A. GRASSO' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '0' , '13.00' ) 19/06/2024 04:46:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20103' AND id_supplier = '7' 19/06/2024 04:46:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20103' , '7' , '1' ) 19/06/2024 04:46:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '17128' , 'FAI VIVERE E SANTIFICHI LUNIVERSO' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '0' , '13.00' ) 19/06/2024 04:46:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17128' AND id_supplier = '7' 19/06/2024 04:46:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17128' , '7' , '1' ) 19/06/2024 04:46:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '15720' , 'EUCARISTIA E LARTE DI EDUCARE - E. BOLIS' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '0' , '13.00' ) 19/06/2024 04:46:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15720' AND id_supplier = '7' 19/06/2024 04:46:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15720' , '7' , '1' ) 19/06/2024 04:46:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '17237' , 'EUCARESTIA DOMENICALE - V. MIRACAPILLO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 19/06/2024 04:46:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17237' AND id_supplier = '7' 19/06/2024 04:46:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17237' , '7' , '1' ) 19/06/2024 04:46:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '17456' , 'VANGELO SECONDO MARCO - PAPA FRANCESCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 19/06/2024 04:46:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17456' AND id_supplier = '7' 19/06/2024 04:46:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17456' , '7' , '1' ) 19/06/2024 04:46:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '17759' , 'VANGELO SECONDO LUCA - PAPA FRANCESCO' , '2' , '-2' , '4' , '12.00' , '12' , '0' , '0' , '24.00' ) 19/06/2024 04:46:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17759' AND id_supplier = '7' 19/06/2024 04:46:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17759' , '7' , '1' ) 19/06/2024 04:46:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '11129' , 'VANGELO SECONDO LUCA' , '17' , '-17' , '4' , '0.90' , '0.9' , '0' , '0' , '15.30' ) 19/06/2024 04:46:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11129' AND id_supplier = '7' 19/06/2024 04:46:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11129' , '7' , '1' ) 19/06/2024 04:46:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '17656' , 'ATTI DEGLI APOSTOLI - PAPA FRANCESCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 19/06/2024 04:46:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17656' AND id_supplier = '7' 19/06/2024 04:46:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17656' , '7' , '1' ) 19/06/2024 04:46: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 ( '92346' , '17652' , 'LETTERA AGLI EBREI E LETTERE CATTOLICHE - PAPA FRANCESCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 19/06/2024 04:46:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17652' AND id_supplier = '7' 19/06/2024 04:46:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17652' , '7' , '1' ) 19/06/2024 04:46: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 ( '92346' , '8702' , 'QUANDO IL MAESTRO PARLA AL CUORE - G. COURTOIS' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 19/06/2024 04:46:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8702' AND id_supplier = '7' 19/06/2024 04:46:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8702' , '7' , '1' ) 19/06/2024 04:46: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 ( '92346' , '22689' , 'UN GIOCO DAMORE - D. DE CAROLIS' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '0' , '13.00' ) 19/06/2024 04:46:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22689' AND id_supplier = '7' 19/06/2024 04:46:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22689' , '7' , '1' ) 19/06/2024 04:46: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 ( '92346' , '18373' , 'COMMENTI AI VANGELI - BENEDETTO XVI' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '0' , '25.00' ) 19/06/2024 04:46:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18373' AND id_supplier = '7' 19/06/2024 04:46:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18373' , '7' , '1' ) 19/06/2024 04:46: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 ( '92346' , '19412' , 'FRANCESCO - COMMENTO AI VANGELI' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '0' , '25.00' ) 19/06/2024 04:46:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19412' AND id_supplier = '7' 19/06/2024 04:46:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19412' , '7' , '1' ) 19/06/2024 04:46: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 ( '92346' , '16895' , 'ANIMA MIA BENEDICI IL SIGNORE' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 19/06/2024 04:46:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16895' AND id_supplier = '7' 19/06/2024 04:46:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16895' , '7' , '1' ) 19/06/2024 04:46: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 ( '92346' , '22003' , 'IMPARARE A PREGARE - C.M. MARTINI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 19/06/2024 04:46:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22003' AND id_supplier = '7' 19/06/2024 04:46:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22003' , '7' , '1' ) 19/06/2024 04:46: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 ( '92346' , '21888' , 'FARE DELLA CHIESA - C.M. MARTINI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 19/06/2024 04:46:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21888' AND id_supplier = '7' 19/06/2024 04:46:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21888' , '7' , '1' ) 19/06/2024 04:46: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 ( '92346' , '21816' , 'MESSAGGIO AI GIOVANI - C.M. MARTINI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 19/06/2024 04:46:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21816' AND id_supplier = '7' 19/06/2024 04:46:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21816' , '7' , '1' ) 19/06/2024 04:46: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 ( '92346' , '21815' , 'FRUTTI DELLO SPIRITO - C.M. MARTINI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 19/06/2024 04:46:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21815' AND id_supplier = '7' 19/06/2024 04:46:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21815' , '7' , '1' ) 19/06/2024 04:46:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21887' , 'PAROLE SULLA CHIESA - C.M. MARTINI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 19/06/2024 04:46:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21887' AND id_supplier = '7' 19/06/2024 04:46:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21887' , '7' , '1' ) 19/06/2024 04:46:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21886' , 'PER UNA NUOVA PRIMAVERA - C.M. MARTINI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 19/06/2024 04:46:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21886' AND id_supplier = '7' 19/06/2024 04:46:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21886' , '7' , '1' ) 19/06/2024 04:46:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21885' , 'FARE DEL CRISTIANO - C.M. MARTINI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 19/06/2024 04:46:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21885' AND id_supplier = '7' 19/06/2024 04:46:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21885' , '7' , '1' ) 19/06/2024 04:46:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '20770' , 'MEMORY DI PASQUA' , '1' , '-1' , '1' , '2.90' , '2.3770491803279' , '22' , '0' , '2.90' ) 19/06/2024 04:46:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20770' AND id_supplier = '7' 19/06/2024 04:46:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20770' , '7' , '1' ) 19/06/2024 04:46:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21879' , 'ATTI DEGLI APOSTOLI COMMENTATI DA SEI BIBLISTE' , '1' , '-1' , '4' , '60.00' , '60' , '0' , '0' , '60.00' ) 19/06/2024 04:46:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21879' AND id_supplier = '7' 19/06/2024 04:46:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21879' , '7' , '1' ) 19/06/2024 04:46:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21931' , 'TI SONO PERDONATI I PECCATI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 19/06/2024 04:46:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21931' AND id_supplier = '7' 19/06/2024 04:46:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21931' , '7' , '1' ) 19/06/2024 04:46:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21918' , 'PARABOLE, CANTICI E DISCORSI' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '0' , '22.00' ) 19/06/2024 04:46:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21918' AND id_supplier = '7' 19/06/2024 04:46:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21918' , '7' , '1' ) 19/06/2024 04:46:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '17733' , 'VANGELO E ATTI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 19/06/2024 04:46:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17733' AND id_supplier = '7' 19/06/2024 04:46:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17733' , '7' , '1' ) 19/06/2024 04:46:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '4348' , 'GENITORI E NONNI' , '2' , '-2' , '4' , '2.00' , '2' , '0' , '0' , '4.00' ) 19/06/2024 04:46:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4348' AND id_supplier = '7' 19/06/2024 04:46:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4348' , '7' , '1' ) 19/06/2024 04:46:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '6596' , 'MI CONFESSO' , '2' , '-2' , '4' , '1.50' , '1.5' , '0' , '0' , '3.00' ) 19/06/2024 04:46:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6596' AND id_supplier = '7' 19/06/2024 04:46:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6596' , '7' , '1' ) 19/06/2024 04:46:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21634' , 'ORDO VIRGINUM, PROFEZIA E SINODALITA - D. VITALI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 19/06/2024 04:46:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21634' AND id_supplier = '7' 19/06/2024 04:46:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21634' , '7' , '1' ) 19/06/2024 04:46: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 ( '92346' , '21742' , 'MARIA, LA DONNA PIU BELLA - A. COMASTRI' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '0' , '25.00' ) 19/06/2024 04:46:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21742' AND id_supplier = '7' 19/06/2024 04:46:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21742' , '7' , '1' ) 19/06/2024 04:46: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 ( '92346' , '21805' , 'DIO SI E FATTO CARNE - AAVV' , '1' , '-1' , '4' , '28.00' , '28' , '0' , '0' , '28.00' ) 19/06/2024 04:46:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21805' AND id_supplier = '7' 19/06/2024 04:46:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21805' , '7' , '1' ) 19/06/2024 04:46: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 ( '92346' , '4762' , 'GRAZIE PAPÀ' , '4' , '-4' , '4' , '1.50' , '1.5' , '0' , '0' , '6.00' ) 19/06/2024 04:46:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4762' AND id_supplier = '7' 19/06/2024 04:46:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4762' , '7' , '1' ) 19/06/2024 04:46: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 ( '92346' , '4129' , 'FELICE ANNIVERSARIO' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 19/06/2024 04:46:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4129' AND id_supplier = '7' 19/06/2024 04:46:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4129' , '7' , '1' ) 19/06/2024 04:46: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 ( '92346' , '16156' , 'MAI DA SOLI - PREGHIERE ANGELI' , '2' , '-2' , '4' , '2.00' , '2' , '0' , '0' , '4.00' ) 19/06/2024 04:46:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16156' AND id_supplier = '7' 19/06/2024 04:46:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16156' , '7' , '1' ) 19/06/2024 04:46: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 ( '92346' , '19489' , 'ATTO DI CONSACRAZIONE A MARIA - PAPA FRANCESCO' , '10' , '-10' , '4' , '1.20' , '1.2' , '0' , '0' , '12.00' ) 19/06/2024 04:46:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19489' AND id_supplier = '7' 19/06/2024 04:46:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19489' , '7' , '1' ) 19/06/2024 04:46:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '18' AND id_document != '92346' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2024-06-19') 19/06/2024 04:46:50 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '18', document_date = '2024-06-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2602', address1 = 'P. ZZA SAN PAOLO, 14 12051 ALBA', address2 = '', note = 'RESA', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '9', price_tax_included = '774.30', price_tax_excluded = '773.78', date_upd = NOW() WHERE id_document = '92346' 19/06/2024 04:46:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92346' 19/06/2024 04:46:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '92346' 19/06/2024 04:46:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22068' , 'PAROLA E PREGHIERA - MAR 2024' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 19/06/2024 04:46:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22069' , 'PAROLA E PREGHIERA - APR 2024' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 19/06/2024 04:46:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21920' , 'AMEN - MAR 24' , '2' , '-2' , '4' , '2.9000' , '2.9' , '0' , '0' , '5.80' ) 19/06/2024 04:46:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22167' , 'AMEN - MAG. 2024' , '3' , '-3' , '4' , '3.9000' , '3.9' , '0' , '0' , '11.70' ) 19/06/2024 04:46:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21919' , 'AMEN - APR 24' , '5' , '-5' , '4' , '2.9000' , '2.9' , '0' , '0' , '14.50' ) 19/06/2024 04:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22168' , 'AMEN - GIU. 2024' , '4' , '-4' , '4' , '3.9000' , '3.9' , '0' , '0' , '15.60' ) 19/06/2024 04:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22505' , 'DALLALBA AL TRAMONTO - GIU 24' , '1' , '-1' , '4' , '3.2000' , '3.2' , '0' , '0' , '3.20' ) 19/06/2024 04:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22120' , 'DALLALBA AL TRAMONTO - MAR 2024' , '1' , '-1' , '4' , '3.2000' , '3.2' , '0' , '0' , '3.20' ) 19/06/2024 04:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22085' , 'FATICA DEL CAMMINO - S. DI BENEDETTO' , '3' , '-3' , '4' , '3.0000' , '3' , '0' , '0' , '9.00' ) 19/06/2024 04:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '20748' , 'VERSO LA PASQUA' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 19/06/2024 04:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22140' , 'QUARESIMA PER I FANNULLONI' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 19/06/2024 04:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22064' , 'QUARESIMA 2024' , '1' , '-1' , '4' , '3.6000' , '3.6' , '0' , '0' , '3.60' ) 19/06/2024 04:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22122' , 'CON TUTTO TE STESSO' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '0' , '2.80' ) 19/06/2024 04:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22121' , 'CON TE IN PIENEZZA DI VITA ' , '3' , '-3' , '4' , '3.5000' , '3.5' , '0' , '0' , '10.50' ) 19/06/2024 04:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22078' , 'CHICCO DI GRANO - QUARESIMA BAMBINI 2024' , '2' , '-2' , '4' , '2.5000' , '2.5' , '0' , '0' , '5.00' ) 19/06/2024 04:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22077' , 'QUARESIMA E PASQUA 2024' , '2' , '-2' , '4' , '2.9000' , '2.9' , '0' , '0' , '5.80' ) 19/06/2024 04:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22135' , 'PIEDI IN CAMMINO - 2024' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '0' , '9.90' ) 19/06/2024 04:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21394' , 'LIBRO DORO DEI PROVERBI DI GESU ' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 19/06/2024 04:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '4134' , 'FELICI DI CREDERE - ANNO DELLA FEDE' , '2' , '-2' , '4' , '1.5000' , '1.5' , '0' , '0' , '3.00' ) 19/06/2024 04:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '16790' , 'MAMMA E PAPA' , '12' , '-12' , '4' , '1.8000' , '1.8' , '0' , '0' , '21.60' ) 19/06/2024 04:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '17504' , 'O MARIA MAMMA DOLCISSIMA P. PIO - L. REGOLO' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '0' , '7.90' ) 19/06/2024 04:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '17458' , 'MADONNA REGINA DELLA PACE' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '0' , '7.90' ) 19/06/2024 04:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '17064' , 'ASSUNTA' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '0' , '7.90' ) 19/06/2024 04:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '16885' , 'MADONNA DEL ROSARIO' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '0' , '7.90' ) 19/06/2024 04:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '16896' , 'CUORE IMMACOLATO' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '0' , '7.90' ) 19/06/2024 04:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '16084' , 'MARIA CHE SCIOGLIE I NODI' , '2' , '-2' , '4' , '7.9000' , '7.9' , '0' , '0' , '15.80' ) 19/06/2024 04:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '17062' , 'MADRE DI DIO E DELLA CHIESA' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '0' , '7.90' ) 19/06/2024 04:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '16907' , 'MARIA ADDOLORATA' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '0' , '7.90' ) 19/06/2024 04:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21748' , 'DI PASQUA IN PASQUA - ANNO B - F. ROSINI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 19/06/2024 04:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22324' , 'ESODO A CARATTERI GRANDI' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 19/06/2024 04:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21025' , 'UN ANNO CON MARIA - A. CANOPI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 19/06/2024 04:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '19175' , 'OLTRE PIO V - A. GRILLO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 19/06/2024 04:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '20103' , 'GESU IL COMPIMENTO DELLE SCRITTURE - A. GRASSO' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 19/06/2024 04:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '17128' , 'FAI VIVERE E SANTIFICHI LUNIVERSO' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 19/06/2024 04:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '15720' , 'EUCARISTIA E LARTE DI EDUCARE - E. BOLIS' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 19/06/2024 04:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '17237' , 'EUCARESTIA DOMENICALE - V. MIRACAPILLO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 19/06/2024 04:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '17456' , 'VANGELO SECONDO MARCO - PAPA FRANCESCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 19/06/2024 04:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '17759' , 'VANGELO SECONDO LUCA - PAPA FRANCESCO' , '2' , '-2' , '4' , '12.0000' , '12' , '0' , '0' , '24.00' ) 19/06/2024 04:46:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '11129' , 'VANGELO SECONDO LUCA' , '17' , '-17' , '4' , '0.9000' , '0.9' , '0' , '0' , '15.30' ) 19/06/2024 04:46:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '17656' , 'ATTI DEGLI APOSTOLI - PAPA FRANCESCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 19/06/2024 04:46:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '17652' , 'LETTERA AGLI EBREI E LETTERE CATTOLICHE - PAPA FRANCESCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 19/06/2024 04:46:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '8702' , 'QUANDO IL MAESTRO PARLA AL CUORE - G. COURTOIS' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 19/06/2024 04:46:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22689' , 'UN GIOCO DAMORE - D. DE CAROLIS' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 19/06/2024 04:46:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '18373' , 'COMMENTI AI VANGELI - BENEDETTO XVI' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 19/06/2024 04:46:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '19412' , 'FRANCESCO - COMMENTO AI VANGELI' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 19/06/2024 04:46:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '16895' , 'ANIMA MIA BENEDICI IL SIGNORE' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 19/06/2024 04:46:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22003' , 'IMPARARE A PREGARE - C.M. MARTINI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 19/06/2024 04:46:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21888' , 'FARE DELLA CHIESA - C.M. MARTINI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 19/06/2024 04:46:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21816' , 'MESSAGGIO AI GIOVANI - C.M. MARTINI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 19/06/2024 04:46:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21815' , 'FRUTTI DELLO SPIRITO - C.M. MARTINI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 19/06/2024 04:46:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21887' , 'PAROLE SULLA CHIESA - C.M. MARTINI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 19/06/2024 04:46:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21886' , 'PER UNA NUOVA PRIMAVERA - C.M. MARTINI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 19/06/2024 04:46:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21885' , 'FARE DEL CRISTIANO - C.M. MARTINI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 19/06/2024 04:46:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '20770' , 'MEMORY DI PASQUA' , '1' , '-1' , '1' , '2.9000' , '2.3770491803279' , '22' , '0' , '2.90' ) 19/06/2024 04:46:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21879' , 'ATTI DEGLI APOSTOLI COMMENTATI DA SEI BIBLISTE' , '1' , '-1' , '4' , '60.0000' , '60' , '0' , '0' , '60.00' ) 19/06/2024 04:46:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21931' , 'TI SONO PERDONATI I PECCATI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 19/06/2024 04:46:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21918' , 'PARABOLE, CANTICI E DISCORSI' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 19/06/2024 04:46:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '17733' , 'VANGELO E ATTI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 19/06/2024 04:46:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '4348' , 'GENITORI E NONNI' , '2' , '-2' , '4' , '2.0000' , '2' , '0' , '0' , '4.00' ) 19/06/2024 04:46:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '6596' , 'MI CONFESSO' , '2' , '-2' , '4' , '1.5000' , '1.5' , '0' , '0' , '3.00' ) 19/06/2024 04:46:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21634' , 'ORDO VIRGINUM, PROFEZIA E SINODALITA - D. VITALI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 19/06/2024 04:46:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21742' , 'MARIA, LA DONNA PIU BELLA - A. COMASTRI' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 19/06/2024 04:46:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21805' , 'DIO SI E FATTO CARNE - AAVV' , '1' , '-1' , '4' , '28.0000' , '28' , '0' , '0' , '28.00' ) 19/06/2024 04:46:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '4762' , 'GRAZIE PAPÀ' , '4' , '-4' , '4' , '1.5000' , '1.5' , '0' , '0' , '6.00' ) 19/06/2024 04:46:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '4129' , 'FELICE ANNIVERSARIO' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 19/06/2024 04:46:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '16156' , 'MAI DA SOLI - PREGHIERE ANGELI' , '2' , '-2' , '4' , '2.0000' , '2' , '0' , '0' , '4.00' ) 19/06/2024 04:46:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '19489' , 'ATTO DI CONSACRAZIONE A MARIA - PAPA FRANCESCO' , '10' , '-10' , '4' , '1.2000' , '1.2' , '0' , '0' , '12.00' ) 19/06/2024 04:53:50 pm >> DELETE FROM ps_document WHERE id_document = '92021' 19/06/2024 04:53:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '92021' 19/06/2024 05:22:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '1/A' AND id_document != '89846' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-08') 19/06/2024 05:22:34 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '1/A', document_date = '2024-01-08', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '1.40', price_tax_excluded = '1.40', date_upd = NOW() WHERE id_document = '89846' 19/06/2024 05:22:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89846' 19/06/2024 05:22:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '89846' 19/06/2024 05:22:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.7000' , '0.7' , '0' , '0' , '1.40' ) 19/06/2024 05:26:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '347' AND id_document != '90212' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-02') 19/06/2024 05:26:18 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '347', document_date = '2024-02-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 = '91.40', price_tax_excluded = '91.15', date_upd = NOW() WHERE id_document = '90212' 19/06/2024 05:26:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90212' 19/06/2024 05:26:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '90212' 19/06/2024 05:26:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90212' , '9695' , 'SCAPOLARE SACRO CUORE - 1280 ' , '1' , '-1' , '1' , '1.4000' , '1.1475409836066' , '22' , '0' , '1.40' ) 19/06/2024 05:26:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90212' , '22474' , 'PAROLA E PREGHIERA - LUG 2024' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 19/06/2024 05:26:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90212' , '19892' , 'SALVE, REGINA - S. HAHN' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 19/06/2024 05:26:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90212' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 19/06/2024 05:26:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90212' , '22214' , 'VIE DI MARIA - F. DE CRISTOFARO' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '5' , '12.35' ) 19/06/2024 05:26:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90212' , '19512' , 'SGUARDO DI GESU - F. CRISTOFARO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 19/06/2024 05:26:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90212' , '22557' , 'PAROLA E PREGHIERA - AGO 2024' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 19/06/2024 05:26:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90212' , '22568' , 'CUORE EUCARISTICO DI GESU - S. LONGOBARDI' , '1' , '-1' , '4' , '3.20' , '3.2' , '0' , '0' , '3.20' ) 19/06/2024 05:26:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90212' , '22567' , 'CUORE DI CRISTO - L. TORRUSIO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 19/06/2024 05:26:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90212' , '22685' , 'LAZZARO VIENI FUORI - J. MARTIN' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 19/06/2024 05:26:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90212' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '0.95' , '0.95' , '0' , '0' , '0.95' ) 19/06/2024 05:27:37 pm >> DELETE FROM ps_document WHERE id_document = '90213' 19/06/2024 05:27:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '90213' 19/06/2024 05:28:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '321' AND id_document != '90176' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-31') 19/06/2024 05:28:33 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '321', document_date = '2024-01-31', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '119.00', price_tax_excluded = '115.57', date_upd = NOW() WHERE id_document = '90176' 19/06/2024 05:28:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90176' 19/06/2024 05:28:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '90176' 19/06/2024 05:28:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90176' , '9452' , 'SAN GIOVANNI BOSCO - 50' , '5' , '-5' , '1' , '3.8000' , '3.1147540983607' , '22' , '0' , '19.00' ) 19/06/2024 05:28:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90176' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '125' , '-125' , '4' , '0.8' , '0.8' , '0' , '0' , '100.00' ) 19/06/2024 05:29:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '418' AND id_document != '90313' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-09') 19/06/2024 05:29:00 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '418', document_date = '2024-02-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 = '41.60', price_tax_excluded = '41.27', date_upd = NOW() WHERE id_document = '90313' 19/06/2024 05:29: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 = '90313' 19/06/2024 05:29:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '90313' 19/06/2024 05:29: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 ( '90313' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '640' , '-640' , '4' , '0.0400' , '0.04' , '0' , '0' , '25.60' ) 19/06/2024 05:29: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 ( '90313' , '18749' , 'OSTIA MAGNA 200mm - OM 200' , '1' , '-1' , '3' , '8.5000' , '8.1730769230769' , '4' , '0' , '8.50' ) 19/06/2024 05:29: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 ( '90313' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 19/06/2024 05:29: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 ( '90313' , '18528' , 'CON GESU VERSO IL CALVARIO - G. VALSECCHI' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 19/06/2024 05:29: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 ( '90313' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '4' , '-4' , '4' , '1.00' , '1' , '0' , '0' , '4.00' ) 19/06/2024 05:29:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '454' AND id_document != '90358' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-15') 19/06/2024 05:29:20 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '454', document_date = '2024-02-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '16.50', price_tax_excluded = '13.70', date_upd = NOW() WHERE id_document = '90358' 19/06/2024 05:29:20 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 = '90358' 19/06/2024 05:29:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '90358' 19/06/2024 05:29:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90358' , '1375' , 'BRUCIAINCENSI LEGNO - BRUL' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 19/06/2024 05:29:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90358' , '6207' , 'MARCUS 25G - MENTA - EVE ' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 19/06/2024 05:29:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90358' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 19/06/2024 05:29:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90358' , '17005' , 'BIGLIETTO AUGURALE medio' , '4' , '-4' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '4.00' ) 19/06/2024 05:30:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '458' AND id_document != '90367' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-15') 19/06/2024 05:30:41 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '458', document_date = '2024-02-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '307.00', price_tax_excluded = '267.30', date_upd = NOW() WHERE id_document = '90367' 19/06/2024 05:30:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90367' 19/06/2024 05:30:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '90367' 19/06/2024 05:30:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90367' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '75.00' ) 19/06/2024 05:30:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90367' , '15330' , 'CERO PASQUALE 80X120 - DECORI PARTICOLARI' , '1' , '-1' , '1' , '139.0000' , '113.93442622951' , '22' , '0' , '139.00' ) 19/06/2024 05:30:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90367' , '22077' , 'QUARESIMA E PASQUA 2024' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.76' ) 19/06/2024 05:30:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90367' , '22073' , 'VIA CRUCIS PELLEGRINI DI SPERANZA' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 19/06/2024 05:30:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90367' , '22092' , 'VIA CRUCIS DI FRATERNITA - A. COMASTRI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 19/06/2024 05:30:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90367' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.4900' , '3.3557692307692' , '4' , '0' , '3.49' ) 19/06/2024 05:30:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90367' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 19/06/2024 05:30:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90367' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '10' , '-10' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '5.00' ) 19/06/2024 05:30:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90367' , '22151' , 'MA DIO LO HA RISUSCITATO' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 19/06/2024 05:30:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90367' , '20720' , 'PADRE NOSTRO - L. CALABRETTA' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '0' , '4.00' ) 19/06/2024 05:30:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90367' , '17453' , 'VANGELO SECONDO GIOVANNI - PAPA FRANCESCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 19/06/2024 05:30:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90367' , '21748' , 'DI PASQUA IN PASQUA - ANNO B - F. ROSINI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 19/06/2024 05:30:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90367' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 19/06/2024 05:30:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90367' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '43' , '-43' , '4' , '0.8' , '0.8' , '0' , '0' , '34.40' ) 19/06/2024 05:31:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '504' AND id_document != '90418' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-19') 19/06/2024 05:31:02 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '504', document_date = '2024-02-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.70', price_tax_excluded = '18.87', date_upd = NOW() WHERE id_document = '90418' 19/06/2024 05:31: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 = '90418' 19/06/2024 05:31:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '90418' 19/06/2024 05:31:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90418' , '6207' , 'MARCUS 25G - MENTA - EVE ' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 19/06/2024 05:31:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90418' , '5958' , 'LUCAS 25G - FIORI DARANCIO - EVE ' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 19/06/2024 05:31:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90418' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '4.90' ) 19/06/2024 05:31:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90418' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '6' , '-6' , '4' , '1.00' , '1' , '0' , '0' , '6.00' ) 19/06/2024 05:31:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90418' , '19561' , 'CARD SAN GIUDA TADDEO' , '3' , '-3' , '1' , '1.6000' , '1.3114754098361' , '22' , '0' , '4.80' ) 19/06/2024 05:31:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90418' , '1713' , 'CARD DELLA GUARIGIONE SAN GERARDO' , '1' , '-1' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '1.20' ) 19/06/2024 05:31:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90418' , '19561' , 'CARD SAN GIUDA TADDEO' , '1' , '-1' , '1' , '1.8000' , '1.4754098360656' , '22' , '0' , '1.80' ) 19/06/2024 05:32:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '560' AND id_document != '90502' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-26') 19/06/2024 05:32:05 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '560', document_date = '2024-02-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 = '54.00', price_tax_excluded = '54.00', date_upd = NOW() WHERE id_document = '90502' 19/06/2024 05:32:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90502' 19/06/2024 05:32:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '90502' 19/06/2024 05:32:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90502' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '67' , '-67' , '4' , '0.8' , '0.8' , '0' , '0' , '53.60' ) 19/06/2024 05:32:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90502' , '6629' , 'MIA PREGHIERA' , '1' , '-1' , '4' , '0.4' , '0.4' , '0' , '0' , '0.40' ) 19/06/2024 05:32:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '692' AND id_document != '90681' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-07') 19/06/2024 05:32:30 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '692', document_date = '2024-03-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 = '4.60', price_tax_excluded = '4.49', date_upd = NOW() WHERE id_document = '90681' 19/06/2024 05:32:30 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90681' 19/06/2024 05:32:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '90681' 19/06/2024 05:32:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90681' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '4' , '-4' , '4' , '1.00' , '1' , '0' , '0' , '4.00' ) 19/06/2024 05:32:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90681' , '18218' , 'DECINA LEGNO CHIARO - FR52' , '1' , '-1' , '1' , '0.6000' , '0.49180327868852' , '22' , '0' , '0.60' ) 19/06/2024 05:33:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '470' AND id_document != '90381' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-16') 19/06/2024 05:33:40 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '470', document_date = '2024-02-16', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '98.80', price_tax_excluded = '98.80', date_upd = NOW() WHERE id_document = '90381' 19/06/2024 05:33: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 = '90381' 19/06/2024 05:33:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '90381' 19/06/2024 05:33: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 ( '90381' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 19/06/2024 05:33:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90381' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '117' , '-117' , '4' , '0.8' , '0.8' , '0' , '0' , '93.60' ) 19/06/2024 05:33:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90381' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.45' , '0.45' , '0' , '0' , '0.45' ) 19/06/2024 05:34:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '639' AND id_document != '90614' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-05') 19/06/2024 05:34:02 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '639', document_date = '2024-03-05', 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 = '24.50', price_tax_excluded = '23.33', date_upd = NOW() WHERE id_document = '90614' 19/06/2024 05:34: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 = '90614' 19/06/2024 05:34:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '90614' 19/06/2024 05:34: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 ( '90614' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '15' , '-15' , '1' , '0.4000' , '0.32786885245902' , '22' , '0' , '6.00' ) 19/06/2024 05:34: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 ( '90614' , '9714' , 'SCATOLA OTTOGONALE - 7328' , '1' , '-1' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '0.50' ) 19/06/2024 05:34: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 ( '90614' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '18' , '-18' , '4' , '1.00' , '1' , '0' , '0' , '18.00' ) 19/06/2024 05:34:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '843' AND id_document != '90874' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-21') 19/06/2024 05:34:23 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '843', document_date = '2024-03-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 = '30.00', price_tax_excluded = '30.00', date_upd = NOW() WHERE id_document = '90874' 19/06/2024 05:34: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 = '90874' 19/06/2024 05:34:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '90874' 19/06/2024 05:34: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 ( '90874' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '30' , '-30' , '4' , '1.00' , '1' , '0' , '0' , '30.00' ) 19/06/2024 06:03:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '2038' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-19') 19/06/2024 06:03:53 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' , '2038' , '2024-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '155.00' , '127.05' , NOW() , NOW() ) 19/06/2024 06:03:53 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 = '92347' 19/06/2024 06:03:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '92347' 19/06/2024 06:03:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92347' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '155' , '127.04918032787' , '22' , '0' , '155.00' ) 19/06/2024 06:50:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '1/A' AND id_document != '89846' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-08') 19/06/2024 06:50:25 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '1/A', document_date = '2024-01-08', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '5.00', price_tax_excluded = '5.00', date_upd = NOW() WHERE id_document = '89846' 19/06/2024 06:50: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 = '89846' 19/06/2024 06:50:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '89846' 19/06/2024 06:50: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 ( '89846' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 19/06/2024 07:48:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '2039' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-19') 19/06/2024 07:48:47 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' , '2039' , '2024-06-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.40' , '30.40' , NOW() , NOW() ) 19/06/2024 07:48:47 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 = '92348' 19/06/2024 07:48:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '92348' 19/06/2024 07:48:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92348' , '4229' , 'FONTI FRANCESCANE - ED. MINOR' , '1' , '-1' , '4' , '32.00' , '32' , '0' , '5' , '30.40' )