04/04/2023 08:34:07 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872984093' AND id_product != '20893' AND ean13 != '' 04/04/2023 08:34:07 am >> UPDATE ps_product SET id_supplier = '7', reference = '7/4', ean13 = '9788872984093', date_upd = NOW() WHERE id_product = '20893' 04/04/2023 08:34:07 am >> UPDATE ps_product_lang SET name = 'VANGELO E ATTI HEART UP', description = '' WHERE id_product = '20893' 04/04/2023 08:34:07 am >> UPDATE ps_product SET wholesale_price = '7.00', on_sale = '0', price = '10.0000' WHERE id_product = '20893' 04/04/2023 08:34:07 am >> UPDATE ps_product_shop SET wholesale_price = '7.00', price = '10.0000', id_tax_rules_group = '4', id_category_default = '29', 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 = '20893' 04/04/2023 08:34:07 am >> DELETE FROM ps_specific_price WHERE id_product = '20893' 04/04/2023 09:06:10 am >> SELECT document_num FROM ps_document WHERE document_num = '22/A' AND id_document != '81317' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-10') 04/04/2023 09:06:10 am >> UPDATE ps_document SET id_document_type = '24', document_num = '22/A', document_date = '2023-02-10', 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 = '22.90', price_tax_excluded = '22.90', date_upd = NOW() WHERE id_document = '81317' 04/04/2023 09:06:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81317' 04/04/2023 09:06:10 am >> DELETE FROM ps_document_detail WHERE id_document = '81317' 04/04/2023 09:06:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '20880' , 'UN TEMPO PER DIO - J. PHILIPPE' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 04/04/2023 09:06:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '20867' , 'PAROLA E PREGHIERA - GIU 23' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 04/04/2023 09:06:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '20893' , 'VANGELO E ATTI HEART UP' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 04/04/2023 10:12:02 am >> SELECT document_num FROM ps_document WHERE document_num = '1118' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-04') 04/04/2023 10:12:02 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1118' , '2023-04-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.20' , '19.02' , NOW() , NOW() ) 04/04/2023 10:12:02 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82633' 04/04/2023 10:12:02 am >> DELETE FROM ps_document_detail WHERE id_document = '82633' 04/04/2023 10:12:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82633' , '14063' , 'STELLARIO PLEX CM 10 / 12' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 04/04/2023 10:12:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82633' , '13844' , 'COLLANINA IN ACCIAIO MADONNA - 1984/M14' , '2' , '-2' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '7.60' ) 04/04/2023 10:12:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82633' , '17276' , 'CONFEZIONE COLLANINA CON MIRACOLOSA E STRASS - 1911' , '1' , '-1' , '1' , '4.60' , '3.7704918032787' , '22' , '0' , '4.60' ) 04/04/2023 10:37:13 am >> SELECT document_num FROM ps_document WHERE document_num = '1119' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-04') 04/04/2023 10:37:13 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' , '1119' , '2023-04-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.10' , '3.10' , NOW() , NOW() ) 04/04/2023 10:37:13 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 = '82634' 04/04/2023 10:37:13 am >> DELETE FROM ps_document_detail WHERE id_document = '82634' 04/04/2023 10:37:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82634' , '2083' , 'CINQUE PRIMI SABATI DEL MESE' , '1' , '-1' , '4' , '3.1' , '3.1' , '0' , '0' , '3.10' ) 04/04/2023 10:43:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '89/23' , '2023-03-23' , '23' , '0' , '0' , '4671003' , 'VIA TORQUATO TASSO, 10 24020 GORLE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '60.00' , '60.00' , NOW() , NOW() ) 04/04/2023 10:43:05 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 = '82635' 04/04/2023 10:43:05 am >> DELETE FROM ps_document_detail WHERE id_document = '82635' 04/04/2023 10:43:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82635' , '17861' , 'CARTA D\'IDENTITA\' DELLA CHIESA - R. LUPI' , '100' , '100' , '4' , '0.6' , '0.6' , '0' , '0' , '60.0000' ) 04/04/2023 10:51:34 am >> SELECT document_num FROM ps_document WHERE document_num = '1120' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-04') 04/04/2023 10:51:34 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1120' , '2023-04-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.50' , '28.50' , NOW() , NOW() ) 04/04/2023 10:51:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82636' 04/04/2023 10:51:34 am >> DELETE FROM ps_document_detail WHERE id_document = '82636' 04/04/2023 10:51:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82636' , '20464' , 'TI RACCONTO IL VANGELO MATTEO - PAPA FRANCESCO' , '2' , '-2' , '4' , '15.00' , '15' , '0' , '5' , '28.50' ) 04/04/2023 10:57:49 am >> SELECT document_num FROM ps_document WHERE document_num = '1121' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-04') 04/04/2023 10:57:49 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' , '1121' , '2023-04-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '38.00' , NOW() , NOW() ) 04/04/2023 10:57:49 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 = '82637' 04/04/2023 10:57:49 am >> DELETE FROM ps_document_detail WHERE id_document = '82637' 04/04/2023 10:57:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82637' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '8' , '-8' , '4' , '5.00' , '5' , '0' , '5' , '38.00' ) 04/04/2023 11:02:22 am >> SELECT document_num FROM ps_document WHERE document_num = '1122' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-04') 04/04/2023 11:02:22 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' , '1122' , '2023-04-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.50' , '5.29' , NOW() , NOW() ) 04/04/2023 11:02:22 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82638' 04/04/2023 11:02:22 am >> DELETE FROM ps_document_detail WHERE id_document = '82638' 04/04/2023 11:02: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 ( '82638' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 04/04/2023 11:02: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 ( '82638' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 04/04/2023 11:16:03 am >> SELECT document_num FROM ps_document WHERE document_num = '1123' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-04') 04/04/2023 11:16: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' , '1123' , '2023-04-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '78.00' , '63.93' , NOW() , NOW() ) 04/04/2023 11:16: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 = '82639' 04/04/2023 11:16:04 am >> DELETE FROM ps_document_detail WHERE id_document = '82639' 04/04/2023 11:16: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 ( '82639' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 04/04/2023 11:16: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 ( '82639' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '20' , '-20' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '28.00' ) 04/04/2023 11:17:48 am >> SELECT document_num FROM ps_document WHERE document_num = '1124' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-04') 04/04/2023 11:17:49 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' , '1124' , '2023-04-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.08' , '22.08' , NOW() , NOW() ) 04/04/2023 11:17:49 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 = '82640' 04/04/2023 11:17:49 am >> DELETE FROM ps_document_detail WHERE id_document = '82640' 04/04/2023 11:17:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82640' , '18383' , 'TALENTO DI VIVERE TUTTO - E. HILLESUM' , '3' , '-3' , '4' , '2.90' , '2.9' , '0' , '5' , '8.28' ) 04/04/2023 11:17:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82640' , '18384' , 'SULLE TRACCE DI GESU - C. MARTINI' , '2' , '-2' , '4' , '2.90' , '2.9' , '0' , '5' , '5.52' ) 04/04/2023 11:17:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82640' , '18385' , 'LETTERA A GESU NEL DESERTO - T. BELLO' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 04/04/2023 11:17:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82640' , '18381' , 'DIREZIONE PER CUI SI AVANZA - A. CANOPI' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 04/04/2023 11:17:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82640' , '18380' , 'BELLEZZA DELLORDINE - S. WEIL' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 04/04/2023 11:23:05 am >> SELECT document_num FROM ps_document WHERE document_num = '1125' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-04') 04/04/2023 11:23:05 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' , '1125' , '2023-04-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '12.26' , NOW() , NOW() ) 04/04/2023 11:23:05 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 = '82641' 04/04/2023 11:23:05 am >> DELETE FROM ps_document_detail WHERE id_document = '82641' 04/04/2023 11:23:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82641' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 04/04/2023 11:23:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82641' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 04/04/2023 11:23:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82641' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '8.50' ) 04/04/2023 11:32:49 am >> SELECT document_num FROM ps_document WHERE document_num = '1126' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2023-04-04') 04/04/2023 11:32:49 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' , '1126' , '2023-04-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.60' , '17.70' , NOW() , NOW() ) 04/04/2023 11:32:49 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 = '82642' 04/04/2023 11:32:49 am >> DELETE FROM ps_document_detail WHERE id_document = '82642' 04/04/2023 11:32:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82642' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '12' , '-12' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '21.60' ) 04/04/2023 11:35:43 am >> SELECT document_num FROM ps_document WHERE document_num = '1127' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-04') 04/04/2023 11:35:43 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' , '1127' , '2023-04-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '141.00' , '115.57' , NOW() , NOW() ) 04/04/2023 11:35:43 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 = '82643' 04/04/2023 11:35:43 am >> DELETE FROM ps_document_detail WHERE id_document = '82643' 04/04/2023 11:35:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82643' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.85' , '14.631147540984' , '22' , '0' , '35.70' ) 04/04/2023 11:35:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82643' , '19104' , 'LUMINELLI A OLIO' , '2' , '-2' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '3.00' ) 04/04/2023 11:35:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82643' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '3' , '-3' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '3.30' ) 04/04/2023 11:35:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82643' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '30' , '-30' , '1' , '3.3' , '2.7049180327869' , '22' , '0' , '99.00' ) 04/04/2023 11:37:08 am >> SELECT document_num FROM ps_document WHERE document_num = '1128' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-04') 04/04/2023 11:37:08 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1128' , '2023-04-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 04/04/2023 11:37:08 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82644' 04/04/2023 11:37:08 am >> DELETE FROM ps_document_detail WHERE id_document = '82644' 04/04/2023 11:37:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82644' , '11960' , 'PASSIO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 04/04/2023 11:43:50 am >> SELECT document_num FROM ps_document WHERE document_num = '45/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-04') 04/04/2023 11:43:50 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 ( '24' , '45/A' , '2023-04-04' , 'A' , '559' , '0' , '4677368' , 'VIA TAVERNA DELLE ROSE 84091 BATTIPAGLIA' , '' , 'ACCONTO € 500,00' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '962.00' , '962.00' , NOW() , NOW() ) 04/04/2023 11:43:50 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 = '82645' 04/04/2023 11:43:50 am >> DELETE FROM ps_document_detail WHERE id_document = '82645' 04/04/2023 11:43:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82645' , '19656' , 'VIA CRUCIS 15 STAZIONI - 37X28' , '1' , '-1' , '0' , '962.00' , '962' , '' , '0' , '962.00' ) 04/04/2023 11:44:48 am >> SELECT document_num FROM ps_document WHERE document_num = '1129' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-04') 04/04/2023 11:44:48 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1129' , '2023-04-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.60' , '9.51' , NOW() , NOW() ) 04/04/2023 11:44: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 = '82646' 04/04/2023 11:44:48 am >> DELETE FROM ps_document_detail WHERE id_document = '82646' 04/04/2023 11:44: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 ( '82646' , '19717' , 'ROSARIO LEGNO SAN BENEDETTO - RE5042NAT' , '2' , '-2' , '1' , '5.80' , '4.7540983606557' , '22' , '0' , '11.60' ) 04/04/2023 11:48:14 am >> SELECT document_num FROM ps_document WHERE document_num = '1130' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-04') 04/04/2023 11:48:14 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' , '1130' , '2023-04-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '79.80' , '65.41' , NOW() , NOW() ) 04/04/2023 11:48:14 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 = '82647' 04/04/2023 11:48:14 am >> DELETE FROM ps_document_detail WHERE id_document = '82647' 04/04/2023 11:48:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82647' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '1' , '22.00' , '18.032786885246' , '22' , '0' , '44.00' ) 04/04/2023 11:48:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82647' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '35.80' ) 04/04/2023 11:57:04 am >> SELECT document_num FROM ps_document WHERE document_num = '1131' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2023-04-04') 04/04/2023 11:57: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' , '1131' , '2023-04-04' , '' , '371' , '0' , '4670910' , 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '7.69' , NOW() , NOW() ) 04/04/2023 11:57: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 = '82648' 04/04/2023 11:57:04 am >> DELETE FROM ps_document_detail WHERE id_document = '82648' 04/04/2023 11:57: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 ( '82648' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '2' , '1.9230769230769' , '4' , '0' , '8.00' ) 04/04/2023 11:59:29 am >> SELECT document_num FROM ps_document WHERE document_num = '1132' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2023-04-04') 04/04/2023 11:59:29 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' , '1132' , '2023-04-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.90' , '32.70' , NOW() , NOW() ) 04/04/2023 11:59:29 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 = '82649' 04/04/2023 11:59:29 am >> DELETE FROM ps_document_detail WHERE id_document = '82649' 04/04/2023 11:59:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82649' , '20080' , 'ROSARIO ARGENTO/ULIVO' , '1' , '-1' , '1' , '39.90' , '32.704918032787' , '22' , '0' , '39.90' ) 04/04/2023 11:59:52 am >> SELECT document_num FROM ps_document WHERE document_num = '1133' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-04') 04/04/2023 11:59:52 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1133' , '2023-04-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '225.00' , '198.57' , NOW() , NOW() ) 04/04/2023 11:59:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82650' 04/04/2023 11:59:52 am >> DELETE FROM ps_document_detail WHERE id_document = '82650' 04/04/2023 11:59:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82650' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '16.7' , '13.688524590164' , '22' , '0' , '16.70' ) 04/04/2023 11:59:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82650' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '960' , '-960' , '4' , '0.0400' , '0.04' , '0' , '0' , '38.40' ) 04/04/2023 11:59:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82650' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '30' , '-30' , '4' , '1.0000' , '1' , '0' , '15' , '25.50' ) 04/04/2023 11:59:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82650' , '13712' , 'SERIE VIA CRUCIS - 22X30 ' , '1' , '-1' , '1' , '16.0000' , '13.1148' , '22' , '0' , '16.00' ) 04/04/2023 11:59:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82650' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.0000' , '8.1967' , '22' , '0' , '20.00' ) 04/04/2023 11:59:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82650' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.0000' , '9.8361' , '22' , '0' , '12.00' ) 04/04/2023 11:59:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82650' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.9000' , '14.6721' , '22' , '0' , '17.90' ) 04/04/2023 11:59:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82650' , '19107' , 'INCENSO GRANI 3A' , '2' , '-2' , '1' , '30.0000' , '24.5902' , '22' , '0' , '60.00' ) 04/04/2023 11:59:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82650' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '4' , '-4' , '3' , '3.5000' , '3.3654' , '4' , '0' , '14.00' ) 04/04/2023 11:59:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82650' , '17710' , 'OSTIA MAGNA CM 14 - OM 140' , '1' , '-1' , '3' , '4.5000' , '4.3269' , '4' , '0' , '4.50' ) 04/04/2023 12:00:41 pm >> DELETE FROM ps_document WHERE id_document = '74912' 04/04/2023 12:00:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '74912' 04/04/2023 12:06:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '46/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-04') 04/04/2023 12:06:32 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '46/A' , '2023-04-04' , 'A' , '371' , '0' , '4670910' , 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '76.50' , '69.20' , NOW() , NOW() ) 04/04/2023 12:06:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82651' 04/04/2023 12:06:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '82651' 04/04/2023 12:06:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82651' , '4418' , 'GESÙ CROCIFISSO - 200 ' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 04/04/2023 12:06:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82651' , '8928' , 'RESURREZIONE - 353 ' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 04/04/2023 12:06:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82651' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '4' , '-4' , '0' , '9' , '9' , '' , '0' , '36.00' ) 04/04/2023 12:06:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82651' , '12337' , 'LUMINI ART. ECO 2 ROSSO' , '4' , '-4' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '30.00' ) 04/04/2023 12:07:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '717' AND id_document != '82134' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-04') 04/04/2023 12:07:17 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '717', document_date = '2023-03-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 = '52.50', price_tax_excluded = '43.03', date_upd = NOW() WHERE id_document = '82134' 04/04/2023 12:07: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 = '82134' 04/04/2023 12:07:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '82134' 04/04/2023 12:07: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 ( '82134' , '18213' , 'BRACCIALE CROCI COLORATO - BC569' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 04/04/2023 12:07: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 ( '82134' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 04/04/2023 12:07: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 ( '82134' , '19071' , 'BAMBINELLO CM 32 - PB9941' , '1' , '-1' , '1' , '50.00' , '40.983606557377' , '22' , '0' , '50.00' ) 04/04/2023 12:23:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '1131' AND id_document != '82648' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-04') 04/04/2023 12:23:20 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1131', document_date = '2023-04-04', document_letter = '', id_customer = '', id_supplier = '', id_address = '', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', 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 = '8.00', price_tax_excluded = '7.69', date_upd = NOW() WHERE id_document = '82648' 04/04/2023 12:23: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 = '82648' 04/04/2023 12:23:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '82648' 04/04/2023 12:23: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 ( '82648' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '8.00' ) 04/04/2023 12:32:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '746' AND id_document != '82178' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-07') 04/04/2023 12:32:37 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '746', document_date = '2023-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 = '13.00', price_tax_excluded = '13.00', date_upd = NOW() WHERE id_document = '82178' 04/04/2023 12:32:37 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 = '82178' 04/04/2023 12:32:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '82178' 04/04/2023 12:32:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82178' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.55' , '2.55' , '0' , '0' , '2.55' ) 04/04/2023 12:32:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82178' , '17072' , 'S. ALFONSO M. DE LIGUORI E LE MISSIONI POPOLARI - R. DADDIO' , '1' , '-1' , '4' , '11.00' , '11' , '0' , '5' , '10.45' ) 04/04/2023 12:36:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280192257' AND id_product != '5759' AND ean13 != '' 04/04/2023 12:36:07 pm >> UPDATE ps_product SET id_supplier = '79', reference = '', ean13 = '9791280192257', date_upd = NOW() WHERE id_product = '5759' 04/04/2023 12:36:07 pm >> UPDATE ps_product_lang SET name = 'LEZIONARIO DOMENICALE E FESTIVO ANNO A', description = '' WHERE id_product = '5759' 04/04/2023 12:36:07 pm >> UPDATE ps_product SET wholesale_price = '42.00', on_sale = '0', price = '60.0000' WHERE id_product = '5759' 04/04/2023 12:36:07 pm >> UPDATE ps_product_shop SET wholesale_price = '42.00', price = '60.0000', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '89', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '5759' 04/04/2023 12:36:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '5759' 04/04/2023 12:36:14 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '1070' , '2023-04-03' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '203.00' , '203.00' , NOW() , NOW() ) 04/04/2023 12:36:14 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 = '82652' 04/04/2023 12:36:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '82652' 04/04/2023 12:36:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82652' , '5759' , 'LEZIONARIO DOMENICALE E FESTIVO - ANNO A' , '2' , '2' , '4' , '60.00' , '60' , '0' , '30' , '84.0000' ) 04/04/2023 12:36:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5759' AND id_supplier = '79' 04/04/2023 12:36:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5759' , '79' , '1' ) 04/04/2023 12:36:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82652' , '18956' , 'LEZIONARIO DOMENICALE E FESTIVO ANNO B' , '1' , '1' , '4' , '60.00' , '60' , '0' , '30' , '42.0000' ) 04/04/2023 12:36:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18956' AND id_supplier = '79' 04/04/2023 12:36:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18956' , '79' , '1' ) 04/04/2023 12:36:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82652' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '1' , '4' , '110.00' , '110' , '0' , '30' , '77.0000' ) 04/04/2023 12:36:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '79' 04/04/2023 12:36:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '79' , '1' ) 04/04/2023 12:41:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '1134' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-04') 04/04/2023 12:41: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' , '1134' , '2023-04-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '57.38' , NOW() , NOW() ) 04/04/2023 12:41: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 = '82653' 04/04/2023 12:41:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '82653' 04/04/2023 12:41: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 ( '82653' , '1938' , 'CERO PASQUALE API 80X100' , '1' , '-1' , '1' , '70' , '57.377049180328' , '22' , '0' , '70.00' ) 04/04/2023 12:42:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '18/A' AND id_document != '81226' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-04') 04/04/2023 12:42:55 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '18/A', document_date = '2023-02-04', document_letter = 'A', id_customer = '3712', id_supplier = '', id_address = '4671443', address1 = 'VIA DALMAZIA 6 84121 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '204.90', price_tax_excluded = '169.21', date_upd = NOW() WHERE id_document = '81226' 04/04/2023 12:42:55 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 = '81226' 04/04/2023 12:42:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '81226' 04/04/2023 12:42:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81226' , '11384' , 'VINO BIANCO DOLCE - 102' , '3' , '-3' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '25.50' ) 04/04/2023 12:42:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81226' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '10' , '-10' , '4' , '0.7000' , '0.7' , '0' , '0' , '7.00' ) 04/04/2023 12:42:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81226' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 04/04/2023 12:42:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81226' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 04/04/2023 12:42:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81226' , '0' , 'BUSTE PER PALMA' , '5' , '-5' , '1' , '9.5000' , '7.7868852459016' , '22' , '0' , '47.50' ) 04/04/2023 12:42:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81226' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '3' , '-3' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '53.70' ) 04/04/2023 12:42:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81226' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '2' , '-2' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '2.80' ) 04/04/2023 12:55:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '1135' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-04') 04/04/2023 12:55:20 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' , '1135' , '2023-04-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '43.00' , '36.87' , NOW() , NOW() ) 04/04/2023 12:55: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 = '82654' 04/04/2023 12:55:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '82654' 04/04/2023 12:55: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 ( '82654' , '13711' , 'ULTIMA CENA - 363' , '4' , '-4' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '14.00' ) 04/04/2023 12:55: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 ( '82654' , '6629' , 'MIA PREGHIERA' , '10' , '-10' , '4' , '0.90' , '0.9' , '0' , '0' , '9.00' ) 04/04/2023 12:55: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 ( '82654' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '40' , '-40' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '20.00' ) 04/04/2023 02:59:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '872' AND id_document != '82335' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-16') 04/04/2023 02:59:31 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '872', document_date = '2023-03-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 = '135.00', price_tax_excluded = '110.66', date_upd = NOW() WHERE id_document = '82335' 04/04/2023 02:59:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82335' 04/04/2023 02:59:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '82335' 04/04/2023 02:59:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82335' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 04/04/2023 02:59:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82335' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '5' , '-5' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '100.00' ) 04/04/2023 02:59:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82335' , '20824' , 'BRUCIA INCENSO CM 14' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 04/04/2023 03:21:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '5/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-04') 04/04/2023 03:21:40 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '22' , '5/S' , '2023-04-04' , 'S' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'VENDUTO MARZO 2023' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '1784.75' , '1784.75' , NOW() , NOW() ) 04/04/2023 03:21: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 = '11061' 04/04/2023 03:21:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '11061' 04/04/2023 03:21: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 ( '11061' , '6' , 'I miracoli da colorare. Il figlio della vedova' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 04/04/2023 03:21: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 ( '11061' , '9' , 'PSICOLOGIA PRATICA PER EDUCATORI' , '1' , '0' , '4' , '10.50' , '10.5' , '0' , '50' , '5.25' ) 04/04/2023 03:21: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 ( '11061' , '11' , 'COME PREPARARSI ALLA CONFESSIONE' , '1' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 04/04/2023 03:21: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 ( '11061' , '13' , 'BUSSATE E VI SARÀ APERTO' , '20' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '15.00' ) 04/04/2023 03:21: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 ( '11061' , '17' , 'LA FEDE NELLO ZAINETTO' , '11' , '0' , '4' , '6.00' , '6' , '0' , '50' , '33.00' ) 04/04/2023 03:21: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 ( '11061' , '20' , 'GIOVEDÌ SANTO' , '4' , '0' , '4' , '1.5' , '1.5' , '0' , '50' , '3.00' ) 04/04/2023 03:21: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 ( '11061' , '21' , 'LA COMUNIONE' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 04/04/2023 03:21: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 ( '11061' , '134' , 'AVE MARIA SPIEGATA AI BAMBINI - N.E.' , '22' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '19.80' ) 04/04/2023 03:21: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 ( '11061' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '70' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '52.50' ) 04/04/2023 03:21: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 ( '11061' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '96' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '120.00' ) 04/04/2023 03:21: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 ( '11061' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '50' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '62.50' ) 04/04/2023 03:21: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 ( '11061' , '25' , 'PICCOLO DIZIONARIO DEL CRISTIANO' , '2' , '0' , '4' , '3.00' , '3' , '0' , '50' , '3.00' ) 04/04/2023 03:21: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 ( '11061' , '121' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '30' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '37.50' ) 04/04/2023 03:21: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 ( '11061' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '16' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '20.00' ) 04/04/2023 03:21: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 ( '11061' , '125' , 'MIE PREGHIERINE - N. E.' , '294' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '220.50' ) 04/04/2023 03:21: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 ( '11061' , '33' , '100 GIORNI CON LO SPIRITO' , '55' , '0' , '4' , '7.50' , '7.5' , '0' , '50' , '206.25' ) 04/04/2023 03:21: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 ( '11061' , '38' , 'MADRE TERESA, UNA MISSIONARIA' , '1' , '0' , '4' , '2.60' , '2.6' , '0' , '50' , '1.30' ) 04/04/2023 03:21: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 ( '11061' , '50' , 'PERDONAMI SIGNORE' , '117' , '0' , '4' , '2' , '2' , '0' , '50' , '117.00' ) 04/04/2023 03:21: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 ( '11061' , '55' , 'AVE MARIA ,SPIEGATA AI BAMBINI' , '2' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '1.50' ) 04/04/2023 03:21: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 ( '11061' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '44' , '0' , '4' , '2.00' , '2' , '0' , '50' , '44.00' ) 04/04/2023 03:21: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 ( '11061' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '4' , '0' , '4' , '30.00' , '30' , '0' , '50' , '60.00' ) 04/04/2023 03:21: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 ( '11061' , '59' , 'CATECHISTI DI QUALITÀ' , '3' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 04/04/2023 03:21: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 ( '11061' , '67' , 'CON GESU\' SULLA VIA DELLA CROCE - VIA CRUCIS ' , '52' , '0' , '4' , '2.00' , '2' , '0' , '50' , '52.00' ) 04/04/2023 03:21: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 ( '11061' , '73' , 'FRANCESCO AI GIOVANI' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 04/04/2023 03:21: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 ( '11061' , '75' , 'IL SEGNO DELLA CROCE' , '14' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '10.50' ) 04/04/2023 03:21: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 ( '11061' , '89' , 'COMUNIONE SPIEGATA AI RAGAZZI' , '12' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '10.80' ) 04/04/2023 03:21: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 ( '11061' , '92' , 'LA PREGHIERA DEL ROSARIO' , '12' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '15.00' ) 04/04/2023 03:21: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 ( '11061' , '94' , 'IL BATTESIMO' , '12' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '9.00' ) 04/04/2023 03:21: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 ( '11061' , '99' , 'AVE MARIA PREGHIERE MARIANE' , '30' , '0' , '4' , '2.00' , '2' , '0' , '50' , '30.00' ) 04/04/2023 03:21: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 ( '11061' , '101' , 'GESU\' BENEDICI LA NOSTRA FAMIGLIA' , '5' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '3.75' ) 04/04/2023 03:21: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 ( '11061' , '104' , 'TEMPO DI QUARESIMA' , '5' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 04/04/2023 03:21: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 ( '11061' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '43' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '53.75' ) 04/04/2023 03:21: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 ( '11061' , '110' , 'SE MI AMI NON PIANGERE' , '12' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '10.80' ) 04/04/2023 03:21: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 ( '11061' , '111' , 'I NONNI SONO UN TESORO' , '1' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '0.90' ) 04/04/2023 03:21: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 ( '11061' , '123' , 'DIO E\' IN DIECI PAROLE - COMANDAMENTI' , '28' , '0' , '4' , '3.00' , '3' , '0' , '50' , '42.00' ) 04/04/2023 03:21: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 ( '11061' , '114' , 'Le preghiere dei ragazzi' , '1' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 04/04/2023 03:21: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 ( '11061' , '116' , 'DIZIONARIO DEI SIMBOLI DEL PICCOLO CRISTIANO NE' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 04/04/2023 03:21: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 ( '11061' , '117' , 'La preghiera delle cinque dita n.e.' , '41' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '36.90' ) 04/04/2023 03:21: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 ( '11061' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '44' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '55.00' ) 04/04/2023 03:21: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 ( '11061' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '47' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '58.75' ) 04/04/2023 03:21: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 ( '11061' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '3' , '0' , '4' , '3.00' , '3' , '0' , '50' , '4.50' ) 04/04/2023 03:21: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 ( '11061' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '14' , '0' , '4' , '18.00' , '18' , '0' , '50' , '126.00' ) 04/04/2023 03:21: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 ( '11061' , '126' , 'SACRAMENTO DEL PERDONO' , '227' , '0' , '4' , '2.00' , '2' , '0' , '50' , '227.00' ) 04/04/2023 03:32:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '6/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-04') 04/04/2023 03:32:27 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '25' , '6/S' , '2023-04-04' , 'S' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RESA MARZO 2023' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '554.70' , '554.70' , NOW() , NOW() ) 04/04/2023 03:32: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 = '11062' 04/04/2023 03:32:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '11062' 04/04/2023 03:32: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 ( '11062' , '17' , 'LA FEDE NELLO ZAINETTO' , '1' , '1' , '4' , '6.00' , '6' , '0' , '50' , '3.00' ) 04/04/2023 03:32: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 ( '11062' , '19' , 'CHIERICHETTI IERI OGGI DOMANI' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 04/04/2023 03:32: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 ( '11062' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '7' , '7' , '4' , '2.50' , '2.5' , '0' , '50' , '8.75' ) 04/04/2023 03:32: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 ( '11062' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 04/04/2023 03:32: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 ( '11062' , '121' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 04/04/2023 03:32: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 ( '11062' , '125' , 'MIE PREGHIERINE - N. E.' , '1' , '1' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 04/04/2023 03:32: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 ( '11062' , '33' , '100 GIORNI CON LO SPIRITO' , '3' , '3' , '4' , '7.50' , '7.5' , '0' , '50' , '11.25' ) 04/04/2023 03:32: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 ( '11062' , '38' , 'MADRE TERESA, UNA MISSIONARIA' , '1' , '1' , '4' , '2.60' , '2.6' , '0' , '50' , '1.30' ) 04/04/2023 03:32: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 ( '11062' , '42' , 'ALLA SCOPERTA DELLA CASA DI GESU\'' , '10' , '10' , '4' , '3.00' , '3' , '0' , '50' , '15.00' ) 04/04/2023 03:32: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 ( '11062' , '59' , 'CATECHISTI DI QUALITÀ' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 04/04/2023 03:32: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 ( '11062' , '67' , 'CON GESU\' SULLA VIA DELLA CROCE - VIA CRUCIS ' , '5' , '5' , '4' , '2.00' , '2' , '0' , '50' , '5.00' ) 04/04/2023 03:32: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 ( '11062' , '89' , 'COMUNIONE SPIEGATA AI RAGAZZI' , '1' , '1' , '4' , '1.80' , '1.8' , '0' , '50' , '0.90' ) 04/04/2023 03:32: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 ( '11062' , '97' , '\"IL NATALE \"\"CHE MERAVIGLIA\"\"\"' , '3' , '3' , '4' , '1.50' , '1.5' , '0' , '50' , '2.25' ) 04/04/2023 03:32: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 ( '11062' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '3' , '3' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 04/04/2023 03:32: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 ( '11062' , '110' , 'SE MI AMI NON PIANGERE' , '7' , '7' , '4' , '1.80' , '1.8' , '0' , '50' , '6.30' ) 04/04/2023 03:32: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 ( '11062' , '111' , 'I NONNI SONO UN TESORO' , '21' , '21' , '4' , '1.80' , '1.8' , '0' , '50' , '18.90' ) 04/04/2023 03:32: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 ( '11062' , '112' , 'SEMPRE CON TE -VANGELO TASCABILE' , '12' , '12' , '4' , '2.50' , '2.5' , '0' , '50' , '15.00' ) 04/04/2023 03:32: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 ( '11062' , '123' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '1' , '1' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 04/04/2023 03:32: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 ( '11062' , '115' , 'SAN FRANCESCO DASSISI RACCONTATO AI RAGAZZI N.E.' , '1' , '1' , '4' , '4.00' , '4' , '0' , '50' , '2.00' ) 04/04/2023 03:32: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 ( '11062' , '117' , 'La preghiera delle cinque dita n.e.' , '2' , '2' , '4' , '1.80' , '1.8' , '0' , '50' , '1.80' ) 04/04/2023 03:32: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 ( '11062' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '6' , '6' , '4' , '2.50' , '2.5' , '0' , '50' , '7.50' ) 04/04/2023 03:32:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11062' , '119' , 'Rosario spiegato ai bambini ' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 04/04/2023 03:32:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11062' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '49' , '49' , '4' , '3.00' , '3' , '0' , '50' , '73.50' ) 04/04/2023 03:32:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11062' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '41' , '41' , '4' , '18.00' , '18' , '0' , '50' , '369.00' ) 04/04/2023 03:32:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11062' , '126' , 'SACRAMENTO DEL PERDONO' , '1' , '1' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 04/04/2023 03:45:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '1127' AND id_document != '82643' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-04') 04/04/2023 03:45:51 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1127', document_date = '2023-04-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 = '141.00', price_tax_excluded = '115.57', date_upd = NOW() WHERE id_document = '82643' 04/04/2023 03:45:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82643' 04/04/2023 03:45:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '82643' 04/04/2023 03:45: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 ( '82643' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.8500' , '14.631147540984' , '22' , '0' , '35.70' ) 04/04/2023 03:45: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 ( '82643' , '19104' , 'LUMINELLI A OLIO' , '3' , '-3' , '1' , '1' , '0.81967213114754' , '22' , '0' , '3.00' ) 04/04/2023 03:45: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 ( '82643' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '3' , '-3' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '3.30' ) 04/04/2023 03:45: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 ( '82643' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '30' , '-30' , '1' , '3.3000' , '2.7049180327869' , '22' , '0' , '99.00' ) 04/04/2023 03:54:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '1136' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-04') 04/04/2023 03:54:52 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' , '1136' , '2023-04-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.30' , '24.33' , NOW() , NOW() ) 04/04/2023 03:54:52 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 = '82655' 04/04/2023 03:54:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '82655' 04/04/2023 03:54: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 ( '82655' , '7311' , 'OSTIA SOTTILE 74MM' , '6' , '-6' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '11.40' ) 04/04/2023 03:54: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 ( '82655' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '3' , '-3' , '3' , '3.30' , '3.1730769230769' , '4' , '0' , '9.90' ) 04/04/2023 03:54: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 ( '82655' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '4.00' ) 04/04/2023 04:20:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '14/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-04') 04/04/2023 04:20:34 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 ( '22' , '14/E' , '2023-04-04' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '5709.70' , '5700.68' , NOW() , NOW() ) 04/04/2023 04:20: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 = '82656' 04/04/2023 04:20:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '82656' 04/04/2023 04:20: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 ( '82656' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '193' , '0' , '4' , '2.40' , '2.4' , '0' , '50' , '231.60' ) 04/04/2023 04:20: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 ( '82656' , '9675' , 'SARETE MIEI TESTIMONI' , '25' , '0' , '4' , '3' , '3' , '0' , '50' , '37.50' ) 04/04/2023 04:20: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 ( '82656' , '8254' , 'PREGHIAMO CON MARIA' , '2' , '0' , '4' , '0.65' , '0.65' , '0' , '50' , '0.65' ) 04/04/2023 04:20: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 ( '82656' , '5457' , 'IO SONO CON VOI 1 PARTE' , '59' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '73.75' ) 04/04/2023 04:20: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 ( '82656' , '5458' , 'IO SONO CON VOI 2 PARTE' , '29' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '36.25' ) 04/04/2023 04:20: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 ( '82656' , '11191' , 'VENITE CON ME 1 PARTE' , '91' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '113.75' ) 04/04/2023 04:20: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 ( '82656' , '11192' , 'VENITE CON ME 2 PARTE' , '54' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '67.50' ) 04/04/2023 04:20: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 ( '82656' , '11312' , 'VIA CRUCIS PER RAGAZZI ' , '52' , '0' , '4' , '0.85' , '0.85' , '0' , '50' , '22.10' ) 04/04/2023 04:20: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 ( '82656' , '523' , 'AMORE VINCE LA MORTE - VIA CRUCIS' , '6' , '0' , '4' , '0.85' , '0.85' , '0' , '50' , '2.55' ) 04/04/2023 04:20: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 ( '82656' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '12' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '21.00' ) 04/04/2023 04:20: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 ( '82656' , '9996' , 'SIGNORE, TI PREGO' , '2' , '0' , '4' , '6.00' , '6' , '0' , '50' , '6.00' ) 04/04/2023 04:20: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 ( '82656' , '11308' , 'VIA CRUCIS ' , '2' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '1.50' ) 04/04/2023 04:20: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 ( '82656' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '12' , '0' , '4' , '8.00' , '8' , '0' , '50' , '48.00' ) 04/04/2023 04:20: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 ( '82656' , '6629' , 'MIA PREGHIERA' , '432' , '0' , '4' , '0.90' , '0.9' , '0' , '50' , '194.40' ) 04/04/2023 04:20: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 ( '82656' , '8408' , 'PRENDETE E MANGIATE' , '83' , '0' , '4' , '3.00' , '3' , '0' , '50' , '124.50' ) 04/04/2023 04:20: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 ( '82656' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '2' , '0' , '4' , '5.00' , '5' , '0' , '50' , '5.00' ) 04/04/2023 04:20: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 ( '82656' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '2' , '0' , '4' , '5.00' , '5' , '0' , '50' , '5.00' ) 04/04/2023 04:20: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 ( '82656' , '4154' , 'FESTA DEL PERDONO' , '114' , '0' , '4' , '3.00' , '3' , '0' , '50' , '171.00' ) 04/04/2023 04:20: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 ( '82656' , '7824' , 'PER ILLUMINARE IL CAMMINO' , '25' , '0' , '4' , '0.90' , '0.9' , '0' , '50' , '11.25' ) 04/04/2023 04:20: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 ( '82656' , '2679' , 'CONOSCERE GESU\'' , '32' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '56.00' ) 04/04/2023 04:20: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 ( '82656' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '3' , '0' , '4' , '6.00' , '6' , '0' , '50' , '9.00' ) 04/04/2023 04:20: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 ( '82656' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '40' , '0' , '4' , '5.00' , '5' , '0' , '50' , '100.00' ) 04/04/2023 04:20: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 ( '82656' , '11102' , 'VANGELO E ATTI DEGLI APOSTOLI - RIL.' , '2' , '0' , '4' , '8.50' , '8.5' , '0' , '50' , '8.50' ) 04/04/2023 04:20: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 ( '82656' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '547' , '0' , '4' , '1.60' , '1.6' , '0' , '50' , '437.60' ) 04/04/2023 04:20: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 ( '82656' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '1' , '0' , '4' , '12.00' , '12' , '0' , '50' , '6.00' ) 04/04/2023 04:20: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 ( '82656' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '4' , '0' , '4' , '1.60' , '1.6' , '0' , '50' , '3.20' ) 04/04/2023 04:20: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 ( '82656' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '7' , '0' , '4' , '1.60' , '1.6' , '0' , '50' , '5.60' ) 04/04/2023 04:20: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 ( '82656' , '12819' , 'REGISTRO DEL CATECHISTA ' , '100' , '0' , '1' , '1.00' , '0.81967213114754' , '22' , '50' , '50.00' ) 04/04/2023 04:20: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 ( '82656' , '12253' , 'MIO LIBRO DI PREGHIERE' , '20' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '28.00' ) 04/04/2023 04:20: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 ( '82656' , '12813' , 'MARIA MADRE NOSTRA' , '25' , '0' , '4' , '3.00' , '3' , '0' , '50' , '37.50' ) 04/04/2023 04:20: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 ( '82656' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '32' , '0' , '4' , '6.00' , '6' , '0' , '50' , '96.00' ) 04/04/2023 04:20: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 ( '82656' , '15115' , 'CONVERSIONE - G. CELENTANO' , '2' , '0' , '4' , '15.00' , '15' , '0' , '50' , '15.00' ) 04/04/2023 04:20: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 ( '82656' , '13397' , 'MIO GESU' , '8' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '14.00' ) 04/04/2023 04:20: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 ( '82656' , '14030' , 'PADRE NOSTRO' , '3' , '0' , '4' , '3.00' , '3' , '0' , '50' , '4.50' ) 04/04/2023 04:20: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 ( '82656' , '14032' , 'AVE MARIA' , '6' , '0' , '4' , '3.00' , '3' , '0' , '50' , '9.00' ) 04/04/2023 04:20: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 ( '82656' , '14029' , 'ANGELO DI DIO' , '3' , '0' , '4' , '3.00' , '3' , '0' , '50' , '4.50' ) 04/04/2023 04:20: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 ( '82656' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '7' , '0' , '4' , '1.00' , '1' , '0' , '50' , '3.50' ) 04/04/2023 04:20: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 ( '82656' , '15019' , 'PREGHIAMO CON MARIA' , '65' , '0' , '4' , '0.80' , '0.8' , '0' , '50' , '26.00' ) 04/04/2023 04:20: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 ( '82656' , '15020' , 'PREGARE OGNI GIORNO' , '14' , '0' , '4' , '1.00' , '1' , '0' , '50' , '7.00' ) 04/04/2023 04:20: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 ( '82656' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '981' , '0' , '4' , '1.00' , '1' , '0' , '50' , '490.50' ) 04/04/2023 04:20: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 ( '82656' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '7' , '0' , '4' , '2.00' , '2' , '0' , '50' , '7.00' ) 04/04/2023 04:20: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 ( '82656' , '16667' , 'VIA CRUCIS' , '10' , '0' , '4' , '3.00' , '3' , '0' , '50' , '15.00' ) 04/04/2023 04:20: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 ( '82656' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '3' , '0' , '4' , '15.00' , '15' , '0' , '50' , '22.50' ) 04/04/2023 04:20: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 ( '82656' , '17257' , 'IO TI BATTEZZO ' , '8' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '7.20' ) 04/04/2023 04:20: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 ( '82656' , '17695' , 'VIA LUCIS CON SAN CESARE DE BUS' , '4' , '0' , '4' , '3.80' , '3.8' , '0' , '50' , '7.60' ) 04/04/2023 04:20: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 ( '82656' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '1' , '0' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 04/04/2023 04:20: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 ( '82656' , '17696' , 'VIA CRUCIS CON SAN CESARE DE BUS' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 04/04/2023 04:20: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 ( '82656' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '28' , '0' , '4' , '1.90' , '1.9' , '0' , '50' , '26.60' ) 04/04/2023 04:20: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 ( '82656' , '17861' , 'CARTA DIDENTITA DELLA CHIESA - R. LUPI' , '33' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '41.25' ) 04/04/2023 04:20: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 ( '82656' , '18528' , 'CON GESU\' VERSO IL CALVARIO - G. VALSECCHI' , '93' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '69.75' ) 04/04/2023 04:20: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 ( '82656' , '19050' , 'VENITE ADORIAMO - G. D\'AMORE' , '26' , '0' , '4' , '7.00' , '7' , '0' , '50' , '91.00' ) 04/04/2023 04:20: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 ( '82656' , '18423' , 'VIA DI SAN FRANCESCO - G. POLIDORO' , '1' , '0' , '4' , '4.80' , '4.8' , '0' , '50' , '2.40' ) 04/04/2023 04:20: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 ( '82656' , '19159' , 'VOLTI DELL\'AMORE - V. SALVOLDI' , '5' , '0' , '4' , '2.00' , '2' , '0' , '50' , '5.00' ) 04/04/2023 04:20: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 ( '82656' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '2' , '0' , '4' , '9.00' , '9' , '0' , '50' , '9.00' ) 04/04/2023 04:20: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 ( '82656' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '2' , '0' , '4' , '9.00' , '9' , '0' , '50' , '9.00' ) 04/04/2023 04:20: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 ( '82656' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '2' , '0' , '4' , '9.00' , '9' , '0' , '50' , '9.00' ) 04/04/2023 04:20: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 ( '82656' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '9' , '0' , '4' , '10.00' , '10' , '0' , '50' , '45.00' ) 04/04/2023 04:20: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 ( '82656' , '19088' , 'TU SOLO IL SANTO - G. VALSECCHI' , '1' , '0' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 04/04/2023 04:20: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 ( '82656' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '10' , '0' , '4' , '12.00' , '12' , '0' , '50' , '60.00' ) 04/04/2023 04:20: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 ( '82656' , '19562' , 'SAN CESARE DE BUS. UNA VITA PER LA CATECHESI ' , '3' , '0' , '4' , '20.00' , '20' , '0' , '50' , '30.00' ) 04/04/2023 04:20: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 ( '82656' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '14' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '17.50' ) 04/04/2023 04:20: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 ( '82656' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '44' , '0' , '4' , '4.50' , '4.5' , '0' , '50' , '99.00' ) 04/04/2023 04:20: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 ( '82656' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '16' , '0' , '4' , '35.00' , '35' , '0' , '50' , '280.00' ) 04/04/2023 04:20: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 ( '82656' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE' , '2' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 04/04/2023 04:20: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 ( '82656' , '20231' , 'PREGANDO NON SPRECATE PAROLE - G. D\'AMORE' , '5' , '0' , '4' , '10.00' , '10' , '0' , '50' , '25.00' ) 04/04/2023 04:20: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 ( '82656' , '20640' , 'GESU\', MOSSO A COMPASSIONE V. SALVOLDI' , '54' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '67.50' ) 04/04/2023 04:20: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 ( '82656' , '20719' , 'CORONA DELL’ADDOLORATA' , '158' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '142.20' ) 04/04/2023 04:20: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 ( '82656' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '288' , '0' , '4' , '2.00' , '2' , '0' , '50' , '288.00' ) 04/04/2023 04:20: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 ( '82656' , '20721' , 'AVE MARIA - L. CALABRETTA' , '137' , '0' , '4' , '4.50' , '4.5' , '0' , '50' , '308.25' ) 04/04/2023 04:20: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 ( '82656' , '20720' , 'PADRE NOSTRO - L. CALABRETTA' , '149' , '0' , '4' , '4.50' , '4.5' , '0' , '50' , '335.25' ) 04/04/2023 04:20: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 ( '82656' , '20722' , 'SEMINATORI DI GIOIA' , '336' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '420.00' ) 04/04/2023 04:20: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 ( '82656' , '20785' , 'CARTA D\'IDENTITA\' DEL CREATO - R. LUPI' , '207' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '258.75' ) 04/04/2023 04:20: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 ( '82656' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '80' , '0' , '4' , '10.00' , '10' , '0' , '50' , '400.00' ) 04/04/2023 04:20: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 ( '82656' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '1' , '0' , '4' , '20.00' , '20' , '0' , '50' , '10.00' ) 04/04/2023 04:59:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '14/E' AND id_document != '82656' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-04') 04/04/2023 04:59:15 pm >> UPDATE ps_document SET id_document_type = '22', document_num = '14/E', document_date = '2023-04-04', document_letter = 'E', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '14', id_causal = '0', price_tax_included = '5705.20', price_tax_excluded = '5696.18', date_upd = NOW() WHERE id_document = '82656' 04/04/2023 04:59:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82656' 04/04/2023 04:59:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '82656' 04/04/2023 04:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '193' , '0' , '4' , '2.4000' , '2.4' , '0' , '50' , '231.60' ) 04/04/2023 04:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '9675' , 'SARETE MIEI TESTIMONI' , '25' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '37.50' ) 04/04/2023 04:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '8254' , 'PREGHIAMO CON MARIA' , '2' , '0' , '4' , '0.6500' , '0.65' , '0' , '50' , '0.65' ) 04/04/2023 04:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '5457' , 'IO SONO CON VOI 1 PARTE' , '59' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '73.75' ) 04/04/2023 04:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '5458' , 'IO SONO CON VOI 2 PARTE' , '29' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '36.25' ) 04/04/2023 04:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '11191' , 'VENITE CON ME 1 PARTE' , '91' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '113.75' ) 04/04/2023 04:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '11192' , 'VENITE CON ME 2 PARTE' , '54' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '67.50' ) 04/04/2023 04:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '11312' , 'VIA CRUCIS PER RAGAZZI ' , '52' , '0' , '4' , '0.8500' , '0.85' , '0' , '50' , '22.10' ) 04/04/2023 04:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '523' , 'AMORE VINCE LA MORTE - VIA CRUCIS' , '6' , '0' , '4' , '0.8500' , '0.85' , '0' , '50' , '2.55' ) 04/04/2023 04:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '12' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '21.00' ) 04/04/2023 04:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '9996' , 'SIGNORE, TI PREGO' , '2' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '6.00' ) 04/04/2023 04:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '11308' , 'VIA CRUCIS ' , '2' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '1.50' ) 04/04/2023 04:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '12' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '48.00' ) 04/04/2023 04:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '6629' , 'MIA PREGHIERA' , '432' , '0' , '4' , '0.9000' , '0.9' , '0' , '50' , '194.40' ) 04/04/2023 04:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '8408' , 'PRENDETE E MANGIATE' , '83' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '124.50' ) 04/04/2023 04:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '2' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 04/04/2023 04:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '2' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 04/04/2023 04:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '4154' , 'FESTA DEL PERDONO' , '114' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '171.00' ) 04/04/2023 04:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '7824' , 'PER ILLUMINARE IL CAMMINO' , '25' , '0' , '4' , '0.9000' , '0.9' , '0' , '50' , '11.25' ) 04/04/2023 04:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '2679' , 'CONOSCERE GESU\'' , '32' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '56.00' ) 04/04/2023 04:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '3' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '9.00' ) 04/04/2023 04:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '40' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '100.00' ) 04/04/2023 04:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '11102' , 'VANGELO E ATTI DEGLI APOSTOLI - RIL.' , '2' , '0' , '4' , '8.5000' , '8.5' , '0' , '50' , '8.50' ) 04/04/2023 04:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '547' , '0' , '4' , '1.6000' , '1.6' , '0' , '50' , '437.60' ) 04/04/2023 04:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '50' , '6.00' ) 04/04/2023 04:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '4' , '0' , '4' , '1.6000' , '1.6' , '0' , '50' , '3.20' ) 04/04/2023 04:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '7' , '0' , '4' , '1.6000' , '1.6' , '0' , '50' , '5.60' ) 04/04/2023 04:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '12819' , 'REGISTRO DEL CATECHISTA ' , '100' , '0' , '1' , '1.0000' , '0.81967213114754' , '22' , '50' , '50.00' ) 04/04/2023 04:59:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '12253' , 'MIO LIBRO DI PREGHIERE' , '20' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '28.00' ) 04/04/2023 04:59: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 ( '82656' , '12813' , 'MARIA MADRE NOSTRA' , '25' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '37.50' ) 04/04/2023 04:59: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 ( '82656' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '32' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '96.00' ) 04/04/2023 04:59: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 ( '82656' , '15115' , 'CONVERSIONE - G. CELENTANO' , '2' , '0' , '4' , '15.0000' , '15' , '0' , '50' , '15.00' ) 04/04/2023 04:59: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 ( '82656' , '13397' , 'MIO GESU' , '8' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '14.00' ) 04/04/2023 04:59: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 ( '82656' , '14032' , 'AVE MARIA' , '6' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '9.00' ) 04/04/2023 04:59: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 ( '82656' , '14029' , 'ANGELO DI DIO' , '3' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '4.50' ) 04/04/2023 04:59: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 ( '82656' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '7' , '0' , '4' , '1.0000' , '1' , '0' , '50' , '3.50' ) 04/04/2023 04:59: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 ( '82656' , '15019' , 'PREGHIAMO CON MARIA' , '65' , '0' , '4' , '0.8000' , '0.8' , '0' , '50' , '26.00' ) 04/04/2023 04:59: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 ( '82656' , '15020' , 'PREGARE OGNI GIORNO' , '14' , '0' , '4' , '1.0000' , '1' , '0' , '50' , '7.00' ) 04/04/2023 04:59: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 ( '82656' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '981' , '0' , '4' , '1.0000' , '1' , '0' , '50' , '490.50' ) 04/04/2023 04:59: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 ( '82656' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '7' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '7.00' ) 04/04/2023 04:59: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 ( '82656' , '16667' , 'VIA CRUCIS' , '10' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '15.00' ) 04/04/2023 04:59: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 ( '82656' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '3' , '0' , '4' , '15.0000' , '15' , '0' , '50' , '22.50' ) 04/04/2023 04:59: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 ( '82656' , '17257' , 'IO TI BATTEZZO ' , '8' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '7.20' ) 04/04/2023 04:59: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 ( '82656' , '17695' , 'VIA LUCIS CON SAN CESARE DE BUS' , '4' , '0' , '4' , '3.8000' , '3.8' , '0' , '50' , '7.60' ) 04/04/2023 04:59: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 ( '82656' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '50' , '7.50' ) 04/04/2023 04:59: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 ( '82656' , '17696' , 'VIA CRUCIS CON SAN CESARE DE BUS' , '1' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 04/04/2023 04:59: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 ( '82656' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '28' , '0' , '4' , '1.9000' , '1.9' , '0' , '50' , '26.60' ) 04/04/2023 04:59: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 ( '82656' , '17861' , 'CARTA DIDENTITA DELLA CHIESA - R. LUPI' , '33' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '41.25' ) 04/04/2023 04:59: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 ( '82656' , '18528' , 'CON GESU\' VERSO IL CALVARIO - G. VALSECCHI' , '93' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '69.75' ) 04/04/2023 04:59: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 ( '82656' , '19050' , 'VENITE ADORIAMO - G. D\'AMORE' , '26' , '0' , '4' , '7.0000' , '7' , '0' , '50' , '91.00' ) 04/04/2023 04:59: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 ( '82656' , '18423' , 'VIA DI SAN FRANCESCO - G. POLIDORO' , '1' , '0' , '4' , '4.8000' , '4.8' , '0' , '50' , '2.40' ) 04/04/2023 04:59: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 ( '82656' , '19159' , 'VOLTI DELL\'AMORE - V. SALVOLDI' , '5' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '5.00' ) 04/04/2023 04:59: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 ( '82656' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '2' , '0' , '4' , '9.0000' , '9' , '0' , '50' , '9.00' ) 04/04/2023 04:59: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 ( '82656' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '2' , '0' , '4' , '9.0000' , '9' , '0' , '50' , '9.00' ) 04/04/2023 04:59: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 ( '82656' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '2' , '0' , '4' , '9.0000' , '9' , '0' , '50' , '9.00' ) 04/04/2023 04:59: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 ( '82656' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '9' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '45.00' ) 04/04/2023 04:59: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 ( '82656' , '19088' , 'TU SOLO IL SANTO - G. VALSECCHI' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '5.00' ) 04/04/2023 04:59: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 ( '82656' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '10' , '0' , '4' , '12.0000' , '12' , '0' , '50' , '60.00' ) 04/04/2023 04:59: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 ( '82656' , '19562' , 'SAN CESARE DE BUS. UNA VITA PER LA CATECHESI ' , '3' , '0' , '4' , '20.0000' , '20' , '0' , '50' , '30.00' ) 04/04/2023 04:59: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 ( '82656' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '14' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '17.50' ) 04/04/2023 04:59: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 ( '82656' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '44' , '0' , '4' , '4.5000' , '4.5' , '0' , '50' , '99.00' ) 04/04/2023 04:59: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 ( '82656' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '16' , '0' , '4' , '35.0000' , '35' , '0' , '50' , '280.00' ) 04/04/2023 04:59: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 ( '82656' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE' , '2' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '2.50' ) 04/04/2023 04:59: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 ( '82656' , '20231' , 'PREGANDO NON SPRECATE PAROLE - G. D\'AMORE' , '5' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '25.00' ) 04/04/2023 04:59: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 ( '82656' , '20640' , 'GESU\', MOSSO A COMPASSIONE V. SALVOLDI' , '54' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '67.50' ) 04/04/2023 04:59: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 ( '82656' , '20719' , 'CORONA DELL’ADDOLORATA' , '158' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '142.20' ) 04/04/2023 04:59: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 ( '82656' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '288' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '288.00' ) 04/04/2023 04:59: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 ( '82656' , '20721' , 'AVE MARIA - L. CALABRETTA' , '137' , '0' , '4' , '4.5000' , '4.5' , '0' , '50' , '308.25' ) 04/04/2023 04:59: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 ( '82656' , '20720' , 'PADRE NOSTRO - L. CALABRETTA' , '149' , '0' , '4' , '4.5000' , '4.5' , '0' , '50' , '335.25' ) 04/04/2023 04:59: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 ( '82656' , '20722' , 'SEMINATORI DI GIOIA' , '336' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '420.00' ) 04/04/2023 04:59: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 ( '82656' , '20785' , 'CARTA D\'IDENTITA\' DEL CREATO - R. LUPI' , '207' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '258.75' ) 04/04/2023 04:59: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 ( '82656' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '80' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '400.00' ) 04/04/2023 04:59: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 ( '82656' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '50' , '10.00' ) 04/04/2023 04:59:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '14/E' AND id_document != '82656' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-04') 04/04/2023 04:59:42 pm >> UPDATE ps_document SET id_document_type = '22', document_num = '14/E', document_date = '2023-04-04', document_letter = 'E', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'VENDUTO MARZO 2023', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '14', id_causal = '0', price_tax_included = '5705.20', price_tax_excluded = '5696.18', date_upd = NOW() WHERE id_document = '82656' 04/04/2023 04:59: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 = '82656' 04/04/2023 04:59:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '82656' 04/04/2023 04:59: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 ( '82656' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '193' , '0' , '4' , '2.4000' , '2.4' , '0' , '50' , '231.60' ) 04/04/2023 04:59: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 ( '82656' , '9675' , 'SARETE MIEI TESTIMONI' , '25' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '37.50' ) 04/04/2023 04:59: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 ( '82656' , '8254' , 'PREGHIAMO CON MARIA' , '2' , '0' , '4' , '0.6500' , '0.65' , '0' , '50' , '0.65' ) 04/04/2023 04:59: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 ( '82656' , '5457' , 'IO SONO CON VOI 1 PARTE' , '59' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '73.75' ) 04/04/2023 04:59: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 ( '82656' , '5458' , 'IO SONO CON VOI 2 PARTE' , '29' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '36.25' ) 04/04/2023 04:59: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 ( '82656' , '11191' , 'VENITE CON ME 1 PARTE' , '91' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '113.75' ) 04/04/2023 04:59: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 ( '82656' , '11192' , 'VENITE CON ME 2 PARTE' , '54' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '67.50' ) 04/04/2023 04:59: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 ( '82656' , '11312' , 'VIA CRUCIS PER RAGAZZI ' , '52' , '0' , '4' , '0.8500' , '0.85' , '0' , '50' , '22.10' ) 04/04/2023 04:59: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 ( '82656' , '523' , 'AMORE VINCE LA MORTE - VIA CRUCIS' , '6' , '0' , '4' , '0.8500' , '0.85' , '0' , '50' , '2.55' ) 04/04/2023 04:59: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 ( '82656' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '12' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '21.00' ) 04/04/2023 04:59: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 ( '82656' , '9996' , 'SIGNORE, TI PREGO' , '2' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '6.00' ) 04/04/2023 04:59: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 ( '82656' , '11308' , 'VIA CRUCIS ' , '2' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '1.50' ) 04/04/2023 04:59: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 ( '82656' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '12' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '48.00' ) 04/04/2023 04:59: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 ( '82656' , '6629' , 'MIA PREGHIERA' , '432' , '0' , '4' , '0.9000' , '0.9' , '0' , '50' , '194.40' ) 04/04/2023 04:59: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 ( '82656' , '8408' , 'PRENDETE E MANGIATE' , '83' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '124.50' ) 04/04/2023 04:59: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 ( '82656' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '2' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 04/04/2023 04:59: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 ( '82656' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '2' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 04/04/2023 04:59: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 ( '82656' , '4154' , 'FESTA DEL PERDONO' , '114' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '171.00' ) 04/04/2023 04:59: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 ( '82656' , '7824' , 'PER ILLUMINARE IL CAMMINO' , '25' , '0' , '4' , '0.9000' , '0.9' , '0' , '50' , '11.25' ) 04/04/2023 04:59: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 ( '82656' , '2679' , 'CONOSCERE GESU\'' , '32' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '56.00' ) 04/04/2023 04:59: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 ( '82656' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '3' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '9.00' ) 04/04/2023 04:59: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 ( '82656' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '40' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '100.00' ) 04/04/2023 04:59: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 ( '82656' , '11102' , 'VANGELO E ATTI DEGLI APOSTOLI - RIL.' , '2' , '0' , '4' , '8.5000' , '8.5' , '0' , '50' , '8.50' ) 04/04/2023 04:59: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 ( '82656' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '547' , '0' , '4' , '1.6000' , '1.6' , '0' , '50' , '437.60' ) 04/04/2023 04:59: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 ( '82656' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '50' , '6.00' ) 04/04/2023 04:59: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 ( '82656' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '4' , '0' , '4' , '1.6000' , '1.6' , '0' , '50' , '3.20' ) 04/04/2023 04:59: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 ( '82656' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '7' , '0' , '4' , '1.6000' , '1.6' , '0' , '50' , '5.60' ) 04/04/2023 04:59: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 ( '82656' , '12819' , 'REGISTRO DEL CATECHISTA ' , '100' , '0' , '1' , '1.0000' , '0.81967213114754' , '22' , '50' , '50.00' ) 04/04/2023 04:59: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 ( '82656' , '12253' , 'MIO LIBRO DI PREGHIERE' , '20' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '28.00' ) 04/04/2023 04:59: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 ( '82656' , '12813' , 'MARIA MADRE NOSTRA' , '25' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '37.50' ) 04/04/2023 04:59: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 ( '82656' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '32' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '96.00' ) 04/04/2023 04:59: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 ( '82656' , '15115' , 'CONVERSIONE - G. CELENTANO' , '2' , '0' , '4' , '15.0000' , '15' , '0' , '50' , '15.00' ) 04/04/2023 04:59: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 ( '82656' , '13397' , 'MIO GESU' , '8' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '14.00' ) 04/04/2023 04:59: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 ( '82656' , '14032' , 'AVE MARIA' , '6' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '9.00' ) 04/04/2023 04:59: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 ( '82656' , '14029' , 'ANGELO DI DIO' , '3' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '4.50' ) 04/04/2023 04:59: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 ( '82656' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '7' , '0' , '4' , '1.0000' , '1' , '0' , '50' , '3.50' ) 04/04/2023 04:59: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 ( '82656' , '15019' , 'PREGHIAMO CON MARIA' , '65' , '0' , '4' , '0.8000' , '0.8' , '0' , '50' , '26.00' ) 04/04/2023 04:59: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 ( '82656' , '15020' , 'PREGARE OGNI GIORNO' , '14' , '0' , '4' , '1.0000' , '1' , '0' , '50' , '7.00' ) 04/04/2023 04:59: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 ( '82656' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '981' , '0' , '4' , '1.0000' , '1' , '0' , '50' , '490.50' ) 04/04/2023 04:59: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 ( '82656' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '7' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '7.00' ) 04/04/2023 04:59: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 ( '82656' , '16667' , 'VIA CRUCIS' , '10' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '15.00' ) 04/04/2023 04:59: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 ( '82656' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '3' , '0' , '4' , '15.0000' , '15' , '0' , '50' , '22.50' ) 04/04/2023 04:59: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 ( '82656' , '17257' , 'IO TI BATTEZZO ' , '8' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '7.20' ) 04/04/2023 04:59: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 ( '82656' , '17695' , 'VIA LUCIS CON SAN CESARE DE BUS' , '4' , '0' , '4' , '3.8000' , '3.8' , '0' , '50' , '7.60' ) 04/04/2023 04:59: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 ( '82656' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '50' , '7.50' ) 04/04/2023 04:59: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 ( '82656' , '17696' , 'VIA CRUCIS CON SAN CESARE DE BUS' , '1' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 04/04/2023 04:59: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 ( '82656' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '28' , '0' , '4' , '1.9000' , '1.9' , '0' , '50' , '26.60' ) 04/04/2023 04:59: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 ( '82656' , '17861' , 'CARTA DIDENTITA DELLA CHIESA - R. LUPI' , '33' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '41.25' ) 04/04/2023 04:59: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 ( '82656' , '18528' , 'CON GESU\' VERSO IL CALVARIO - G. VALSECCHI' , '93' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '69.75' ) 04/04/2023 04:59: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 ( '82656' , '19050' , 'VENITE ADORIAMO - G. D\'AMORE' , '26' , '0' , '4' , '7.0000' , '7' , '0' , '50' , '91.00' ) 04/04/2023 04:59: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 ( '82656' , '18423' , 'VIA DI SAN FRANCESCO - G. POLIDORO' , '1' , '0' , '4' , '4.8000' , '4.8' , '0' , '50' , '2.40' ) 04/04/2023 04:59: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 ( '82656' , '19159' , 'VOLTI DELL\'AMORE - V. SALVOLDI' , '5' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '5.00' ) 04/04/2023 04:59: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 ( '82656' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '2' , '0' , '4' , '9.0000' , '9' , '0' , '50' , '9.00' ) 04/04/2023 04:59: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 ( '82656' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '2' , '0' , '4' , '9.0000' , '9' , '0' , '50' , '9.00' ) 04/04/2023 04:59: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 ( '82656' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '2' , '0' , '4' , '9.0000' , '9' , '0' , '50' , '9.00' ) 04/04/2023 04:59: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 ( '82656' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '9' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '45.00' ) 04/04/2023 04:59: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 ( '82656' , '19088' , 'TU SOLO IL SANTO - G. VALSECCHI' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '5.00' ) 04/04/2023 04:59: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 ( '82656' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '10' , '0' , '4' , '12.0000' , '12' , '0' , '50' , '60.00' ) 04/04/2023 04:59: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 ( '82656' , '19562' , 'SAN CESARE DE BUS. UNA VITA PER LA CATECHESI ' , '3' , '0' , '4' , '20.0000' , '20' , '0' , '50' , '30.00' ) 04/04/2023 04:59: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 ( '82656' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '14' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '17.50' ) 04/04/2023 04:59: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 ( '82656' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '44' , '0' , '4' , '4.5000' , '4.5' , '0' , '50' , '99.00' ) 04/04/2023 04:59: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 ( '82656' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '16' , '0' , '4' , '35.0000' , '35' , '0' , '50' , '280.00' ) 04/04/2023 04:59: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 ( '82656' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE' , '2' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '2.50' ) 04/04/2023 04:59: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 ( '82656' , '20231' , 'PREGANDO NON SPRECATE PAROLE - G. D\'AMORE' , '5' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '25.00' ) 04/04/2023 04:59: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 ( '82656' , '20640' , 'GESU\', MOSSO A COMPASSIONE V. SALVOLDI' , '54' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '67.50' ) 04/04/2023 04:59: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 ( '82656' , '20719' , 'CORONA DELL’ADDOLORATA' , '158' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '142.20' ) 04/04/2023 04:59: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 ( '82656' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '288' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '288.00' ) 04/04/2023 04:59: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 ( '82656' , '20721' , 'AVE MARIA - L. CALABRETTA' , '137' , '0' , '4' , '4.5000' , '4.5' , '0' , '50' , '308.25' ) 04/04/2023 04:59: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 ( '82656' , '20720' , 'PADRE NOSTRO - L. CALABRETTA' , '149' , '0' , '4' , '4.5000' , '4.5' , '0' , '50' , '335.25' ) 04/04/2023 04:59:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '20722' , 'SEMINATORI DI GIOIA' , '336' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '420.00' ) 04/04/2023 04:59:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '20785' , 'CARTA D\'IDENTITA\' DEL CREATO - R. LUPI' , '207' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '258.75' ) 04/04/2023 04:59:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '80' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '400.00' ) 04/04/2023 04:59:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82656' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '50' , '10.00' ) 04/04/2023 05:17:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '15/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-04') 04/04/2023 05:17:54 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 ( '25' , '15/E' , '2023-04-04' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RESA MARZO 2023' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2144.39' , '2140.33' , NOW() , NOW() ) 04/04/2023 05:17:54 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 = '82657' 04/04/2023 05:17:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '82657' 04/04/2023 05:17:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82657' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '25' , '25' , '4' , '2.40' , '2.4' , '0' , '50' , '30.00' ) 04/04/2023 05:17:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82657' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '11' , '11' , '4' , '2.50' , '2.5' , '0' , '50' , '13.75' ) 04/04/2023 05:17:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82657' , '5446' , 'IO SONO CON VOI - GUIDA' , '3' , '3' , '4' , '6' , '6' , '0' , '50' , '9.00' ) 04/04/2023 05:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82657' , '11183' , 'VENITE CON ME - GUIDA' , '5' , '5' , '4' , '6.00' , '6' , '0' , '50' , '15.00' ) 04/04/2023 05:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82657' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '8' , '8' , '4' , '6.20' , '6.2' , '0' , '50' , '24.80' ) 04/04/2023 05:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82657' , '106' , 'A MESSA SALTANDO DI GIOIA - GUIDA' , '3' , '3' , '4' , '5.16' , '5.16' , '0' , '50' , '7.74' ) 04/04/2023 05:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82657' , '9675' , 'SARETE MIEI TESTIMONI' , '79' , '79' , '4' , '3' , '3' , '0' , '50' , '118.50' ) 04/04/2023 05:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82657' , '5457' , 'IO SONO CON VOI 1 PARTE' , '5' , '5' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 04/04/2023 05:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82657' , '5458' , 'IO SONO CON VOI 2 PARTE' , '212' , '212' , '4' , '2.50' , '2.5' , '0' , '50' , '265.00' ) 04/04/2023 05:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82657' , '11191' , 'VENITE CON ME 1 PARTE' , '32' , '32' , '4' , '2.50' , '2.5' , '0' , '50' , '40.00' ) 04/04/2023 05:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82657' , '11192' , 'VENITE CON ME 2 PARTE' , '170' , '170' , '4' , '2.50' , '2.5' , '0' , '50' , '212.50' ) 04/04/2023 05:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82657' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '24' , '24' , '4' , '3.50' , '3.5' , '0' , '50' , '42.00' ) 04/04/2023 05:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82657' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '3' , '3' , '4' , '10.00' , '10' , '0' , '50' , '15.00' ) 04/04/2023 05:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82657' , '5251' , 'INCONTRI EUCARISTICI' , '1' , '1' , '4' , '4.50' , '4.5' , '0' , '50' , '2.25' ) 04/04/2023 05:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82657' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '58' , '58' , '4' , '3.40' , '3.4' , '0' , '50' , '98.60' ) 04/04/2023 05:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82657' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '4' , '4' , '4' , '5.00' , '5' , '0' , '50' , '10.00' ) 04/04/2023 05:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82657' , '3978' , 'EUCARISTIA: RITO E VITA' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 04/04/2023 05:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82657' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '2' , '2' , '4' , '8.00' , '8' , '0' , '50' , '8.00' ) 04/04/2023 05:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82657' , '6629' , 'MIA PREGHIERA' , '20' , '20' , '4' , '0.90' , '0.9' , '0' , '50' , '9.00' ) 04/04/2023 05:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82657' , '8408' , 'PRENDETE E MANGIATE' , '10' , '10' , '4' , '3.00' , '3' , '0' , '50' , '15.00' ) 04/04/2023 05:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82657' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '1' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 04/04/2023 05:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82657' , '4154' , 'FESTA DEL PERDONO' , '22' , '22' , '4' , '3.00' , '3' , '0' , '50' , '33.00' ) 04/04/2023 05:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82657' , '2679' , 'CONOSCERE GESU' , '27' , '27' , '4' , '3.50' , '3.5' , '0' , '50' , '47.25' ) 04/04/2023 05:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82657' , '2680' , 'CONOSCERE GESU - GUIDA' , '5' , '5' , '4' , '6.00' , '6' , '0' , '50' , '15.00' ) 04/04/2023 05:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82657' , '11102' , 'VANGELO E ATTI DEGLI APOSTOLI - RIL.' , '1' , '1' , '4' , '8.50' , '8.5' , '0' , '50' , '4.25' ) 04/04/2023 05:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82657' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '1' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 04/04/2023 05:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82657' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '2' , '2' , '4' , '1.60' , '1.6' , '0' , '50' , '1.60' ) 04/04/2023 05:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82657' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '4' , '4' , '4' , '12.00' , '12' , '0' , '50' , '24.00' ) 04/04/2023 05:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82657' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '4' , '4' , '4' , '1.60' , '1.6' , '0' , '50' , '3.20' ) 04/04/2023 05:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82657' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '11' , '11' , '4' , '3.50' , '3.5' , '0' , '50' , '19.25' ) 04/04/2023 05:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82657' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '14' , '14' , '4' , '3.50' , '3.5' , '0' , '50' , '24.50' ) 04/04/2023 05:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82657' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '7' , '7' , '4' , '1.60' , '1.6' , '0' , '50' , '5.60' ) 04/04/2023 05:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82657' , '12819' , 'REGISTRO DEL CATECHISTA ' , '45' , '45' , '1' , '1.00' , '0.81967213114754' , '22' , '50' , '22.50' ) 04/04/2023 05:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82657' , '12813' , 'MARIA MADRE NOSTRA' , '2' , '2' , '4' , '3.00' , '3' , '0' , '50' , '3.00' ) 04/04/2023 05:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82657' , '12255' , 'IN CAMMINO CON GESU' , '1' , '1' , '4' , '3.80' , '3.8' , '0' , '50' , '1.90' ) 04/04/2023 05:17:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82657' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '1' , '1' , '4' , '6.00' , '6' , '0' , '50' , '3.00' ) 04/04/2023 05:17: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 ( '82657' , '15115' , 'CONVERSIONE - G. CELENTANO' , '1' , '1' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 04/04/2023 05:17: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 ( '82657' , '14223' , 'PRONTUARIO BIBLICO - LITURGICO - F. GIGLIO' , '1' , '1' , '4' , '9.00' , '9' , '0' , '50' , '4.50' ) 04/04/2023 05:17: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 ( '82657' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '4' , '4' , '4' , '3.50' , '3.5' , '0' , '50' , '7.00' ) 04/04/2023 05:17: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 ( '82657' , '16041' , 'PRIMI PASSI NEL CAMMINO DI FEDE - M. VIANI' , '4' , '4' , '4' , '6.00' , '6' , '0' , '50' , '12.00' ) 04/04/2023 05:17: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 ( '82657' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '1' , '1' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 04/04/2023 05:17: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 ( '82657' , '17257' , 'IO TI BATTEZZO ' , '2' , '2' , '4' , '1.80' , '1.8' , '0' , '50' , '1.80' ) 04/04/2023 05:17: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 ( '82657' , '17274' , 'VENITE BENEDETTI DEL PADRE MIO' , '2' , '2' , '4' , '3.00' , '3' , '0' , '50' , '3.00' ) 04/04/2023 05:17: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 ( '82657' , '17695' , 'VIA LUCIS CON SAN CESARE DE BUS' , '1' , '1' , '4' , '3.80' , '3.8' , '0' , '50' , '1.90' ) 04/04/2023 05:17: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 ( '82657' , '18036' , 'FERITE FERITOIE ' , '2' , '2' , '4' , '8.00' , '8' , '0' , '50' , '8.00' ) 04/04/2023 05:17: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 ( '82657' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '1' , '1' , '4' , '12.00' , '12' , '0' , '50' , '6.00' ) 04/04/2023 05:17: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 ( '82657' , '18175' , 'VIA DI SAN GIUSEPPE - G. POLIDORO' , '1' , '1' , '4' , '4.80' , '4.8' , '0' , '50' , '2.40' ) 04/04/2023 05:17: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 ( '82657' , '18176' , 'ANTIQUUM MINISTERIUM ' , '5' , '5' , '4' , '1.00' , '1' , '0' , '50' , '2.50' ) 04/04/2023 05:17: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 ( '82657' , '18460' , 'CON CUORE DI PADRE - V. SALVOLDI' , '23' , '23' , '4' , '2.00' , '2' , '0' , '50' , '23.00' ) 04/04/2023 05:17: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 ( '82657' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '3' , '3' , '4' , '15.00' , '15' , '0' , '50' , '22.50' ) 04/04/2023 05:17: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 ( '82657' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '5' , '5' , '4' , '1.90' , '1.9' , '0' , '50' , '4.75' ) 04/04/2023 05:17: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 ( '82657' , '17861' , 'CARTA DIDENTITA DELLA CHIESA - R. LUPI' , '4' , '4' , '4' , '2.50' , '2.5' , '0' , '50' , '5.00' ) 04/04/2023 05:17: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 ( '82657' , '18499' , 'BUONA DOMENICA - ANNO C - G. BAGET BOZZO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '50' , '8.00' ) 04/04/2023 05:17: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 ( '82657' , '18527' , 'SOGNI DI PACE - V. SAVOLDI' , '34' , '34' , '4' , '2.00' , '2' , '0' , '50' , '34.00' ) 04/04/2023 05:17: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 ( '82657' , '18718' , 'TUA VOCE IN ME + CD - FRA F. MARIA REA' , '2' , '2' , '4' , '15.00' , '15' , '0' , '50' , '15.00' ) 04/04/2023 05:17: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 ( '82657' , '18657' , 'HO DATO LORO LA TUA PAROLA - G. VALSECCHI' , '2' , '2' , '4' , '16.00' , '16' , '0' , '50' , '16.00' ) 04/04/2023 05:17: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 ( '82657' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '1' , '1' , '4' , '7.00' , '7' , '0' , '50' , '3.50' ) 04/04/2023 05:17: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 ( '82657' , '18423' , 'VIA DI SAN FRANCESCO - G. POLIDORO' , '4' , '4' , '4' , '4.80' , '4.8' , '0' , '50' , '9.60' ) 04/04/2023 05:17: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 ( '82657' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '28' , '28' , '4' , '2.00' , '2' , '0' , '50' , '28.00' ) 04/04/2023 05:17: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 ( '82657' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '7' , '7' , '4' , '9.00' , '9' , '0' , '50' , '31.50' ) 04/04/2023 05:17: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 ( '82657' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '7' , '7' , '4' , '9.00' , '9' , '0' , '50' , '31.50' ) 04/04/2023 05:17: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 ( '82657' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '6' , '6' , '4' , '9.00' , '9' , '0' , '50' , '27.00' ) 04/04/2023 05:17: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 ( '82657' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '7' , '7' , '4' , '10.00' , '10' , '0' , '50' , '35.00' ) 04/04/2023 05:17: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 ( '82657' , '18950' , 'DOVE FINITO IL CONCILIO? - F. CERRI' , '4' , '4' , '4' , '18.00' , '18' , '0' , '50' , '36.00' ) 04/04/2023 05:17: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 ( '82657' , '19088' , 'TU SOLO IL SANTO - G. VALSECCHI' , '5' , '5' , '4' , '10.00' , '10' , '0' , '50' , '25.00' ) 04/04/2023 05:17: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 ( '82657' , '19160' , 'PERCHE IL DESERTO TORNI A FIORIRE - A. SALVOLDI' , '2' , '2' , '4' , '2.00' , '2' , '0' , '50' , '2.00' ) 04/04/2023 05:17: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 ( '82657' , '19391' , 'ISTRUZIONI FAMILIARI VOL. III - I PRECETTI...' , '2' , '2' , '4' , '20.00' , '20' , '0' , '50' , '20.00' ) 04/04/2023 05:17: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 ( '82657' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '4' , '4' , '4' , '12.00' , '12' , '0' , '50' , '24.00' ) 04/04/2023 05:17: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 ( '82657' , '19562' , 'SAN CESARE DE BUS. UNA VITA PER LA CATECHESI ' , '2' , '2' , '4' , '20.00' , '20' , '0' , '50' , '20.00' ) 04/04/2023 05:17: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 ( '82657' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '140' , '140' , '4' , '2.50' , '2.5' , '0' , '50' , '175.00' ) 04/04/2023 05:17: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 ( '82657' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '11' , '11' , '4' , '4.50' , '4.5' , '0' , '50' , '24.75' ) 04/04/2023 05:17: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 ( '82657' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '7' , '7' , '4' , '35.00' , '35' , '0' , '50' , '122.50' ) 04/04/2023 05:17: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 ( '82657' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE' , '117' , '117' , '4' , '2.50' , '2.5' , '0' , '50' , '146.25' ) 04/04/2023 05:17: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 ( '82657' , '20231' , 'PREGANDO NON SPRECATE PAROLE - G. DAMORE' , '6' , '6' , '4' , '10.00' , '10' , '0' , '50' , '30.00' ) 04/04/2023 05:25:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '1137' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-04') 04/04/2023 05:25:57 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' , '1137' , '2023-04-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '238.00' , '197.43' , NOW() , NOW() ) 04/04/2023 05:25:57 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 = '82658' 04/04/2023 05:25:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '82658' 04/04/2023 05:25: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 ( '82658' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '135' , '110.65573770492' , '22' , '0' , '135.00' ) 04/04/2023 05:25: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 ( '82658' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '13' , '13' , '0' , '0' , '13.00' ) 04/04/2023 05:25: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 ( '82658' , '1220' , 'BICCHIERI FLAMBEAUX - PZ. 50' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 04/04/2023 05:25: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 ( '82658' , '14163' , 'PARACERA OTTONE LUCIDO - Q120' , '1' , '-1' , '1' , '45.00' , '36.885245901639' , '22' , '0' , '45.00' ) 04/04/2023 05:25: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 ( '82658' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 04/04/2023 05:41:34 pm >> DELETE FROM ps_document WHERE id_document = '82554' 04/04/2023 05:41:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '82554' 04/04/2023 05:43:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '1138' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-04') 04/04/2023 05:43: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' , '1138' , '2023-04-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.00' , '41.68' , NOW() , NOW() ) 04/04/2023 05:43: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 = '82659' 04/04/2023 05:43:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '82659' 04/04/2023 05:43: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 ( '82659' , '20707' , 'LUME LEGNO' , '1' , '-1' , '1' , '29.5' , '24.180327868852' , '22' , '0' , '29.50' ) 04/04/2023 05:43: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 ( '82659' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '25' , '-25' , '4' , '0.70' , '0.7' , '0' , '0' , '17.50' ) 04/04/2023 05:55:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '19' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-03-23') 04/04/2023 05:55:11 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' , '19' , '2023-03-23' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'EDIZIONI - SPEDITI DA VELAR' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '250.00' , '250.00' , NOW() , NOW() ) 04/04/2023 05:55: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 = '82660' 04/04/2023 05:55:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '82660' 04/04/2023 05:55: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 ( '82660' , '17861' , 'CARTA D\'IDENTITA\' DELLA CHIESA - R. LUPI' , '100' , '-100' , '4' , '2.5' , '2.5' , '0' , '0' , '250.00' ) 04/04/2023 06:27:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '17/A' AND id_document != '81217' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-03') 04/04/2023 06:27:10 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '17/A', document_date = '2023-02-03', document_letter = 'A', id_customer = '31', id_supplier = '', id_address = '4670717', address1 = 'VIA LOURDES, 21 14015 SAN DAMIANO D\\\'ASTI', address2 = '', note = 'spedito il 6/2 (ricordarsi fattura 5/E)', 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 = '834.00', price_tax_excluded = '759.34', date_upd = NOW() WHERE id_document = '81217' 04/04/2023 06:27:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81217' 04/04/2023 06:27:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '81217' 04/04/2023 06:27:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81217' , '1041' , 'BENEDIZIONI' , '500' , '-500' , '1' , '0.1800' , '0.14754098360656' , '22' , '40' , '54.00' ) 04/04/2023 06:27:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81217' , '0' , 'spediti il 21/03/2023' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 04/04/2023 06:27:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81217' , '12816' , 'LIBRO DEI DEFUNTI' , '2' , '-2' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '48.00' ) 04/04/2023 06:27: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 ( '81217' , '12815' , 'LIBRO DEI CRESIMATI' , '4' , '-4' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '96.00' ) 04/04/2023 06:27: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 ( '81217' , '12818' , 'LIBRO DELLE PRIME COMUNIONI' , '4' , '-4' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '96.00' ) 04/04/2023 06:27: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 ( '81217' , '12849' , 'LIBRO DELLE SS. MESSE' , '6' , '-6' , '1' , '20.0000' , '16.393442622951' , '22' , '40' , '72.00' ) 04/04/2023 06:27: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 ( '81217' , '12814' , 'LIBRO DEI BATTEZZATI' , '2' , '-2' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '48.00' ) 04/04/2023 06:27: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 ( '81217' , '' , 'spedito il 05/04/2023' , '0' , '0' , '0' , '0' , '0' , '' , '0' , '0.00' ) 04/04/2023 06:27: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 ( '81217' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '200' , '-200' , '4' , '3.50' , '3.5' , '0' , '40' , '420.00' ) 04/04/2023 06:32:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '1139' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-04') 04/04/2023 06:32:46 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' , '1139' , '2023-04-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.50' , '47.13' , NOW() , NOW() ) 04/04/2023 06:32:46 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 = '82661' 04/04/2023 06:32:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '82661' 04/04/2023 06:32:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82661' , '11686' , 'CORONA ROSARIO E PORTACORONA - 388' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 04/04/2023 06:32:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82661' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 04/04/2023 06:34:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '1096' AND id_document != '82606' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-03') 04/04/2023 06:34:42 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1096', document_date = '2023-04-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 = '12.70', price_tax_excluded = '10.41', date_upd = NOW() WHERE id_document = '82606' 04/04/2023 06:34: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 = '82606' 04/04/2023 06:34:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '82606' 04/04/2023 06:34: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 ( '82606' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '12.7' , '10.409836065574' , '22' , '0' , '12.70' ) 04/04/2023 07:53:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '1140' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-04') 04/04/2023 07:53: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' , '1140' , '2023-04-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.30' , '6.80' , NOW() , NOW() ) 04/04/2023 07:53: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 = '82662' 04/04/2023 07:53:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '82662' 04/04/2023 07:53: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 ( '82662' , '13711' , 'ULTIMA CENA - 363' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 04/04/2023 07:53: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 ( '82662' , '20519' , 'CROCE ANGELO DI DIO - 693/02-AD5' , '1' , '-1' , '1' , '4.80' , '3.9344262295082' , '22' , '0' , '4.80' ) 04/04/2023 08:12:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '1141' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-04') 04/04/2023 08:12:42 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' , '1141' , '2023-04-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '53.00' , '43.44' , NOW() , NOW() ) 04/04/2023 08:12: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 = '82663' 04/04/2023 08:12:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '82663' 04/04/2023 08:12: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 ( '82663' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '53' , '43.44262295082' , '22' , '0' , '53.00' )