23/05/2023 08:25:23 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861240322' AND id_product != '6538' AND ean13 != '' 23/05/2023 08:25:23 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/1', ean13 = '9788861240322', date_upd = NOW() WHERE id_product = '6538' 23/05/2023 08:25:24 am >> UPDATE ps_product_lang SET name = 'MESSA SPIEGATA AI BAMBINI', description = '' WHERE id_product = '6538' 23/05/2023 08:25:24 am >> UPDATE ps_product SET wholesale_price = '2.45', on_sale = '0', price = '3.9' WHERE id_product = '6538' 23/05/2023 08:25:24 am >> UPDATE ps_product_shop SET wholesale_price = '2.45', price = '3.9', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '25', id_internal_category = '', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '6538' 23/05/2023 08:25:24 am >> DELETE FROM ps_specific_price WHERE id_product = '6538' 23/05/2023 08:26:02 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861244764' AND id_product != '2555' AND ean13 != '' 23/05/2023 08:26:02 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/3', ean13 = '9788861244764', date_upd = NOW() WHERE id_product = '2555' 23/05/2023 08:26:02 am >> UPDATE ps_product_lang SET name = 'COMUNIONE SPIEGATA AI BAMBINI', description = '' WHERE id_product = '2555' 23/05/2023 08:26:02 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.9' WHERE id_product = '2555' 23/05/2023 08:26:02 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.9', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '2555' 23/05/2023 08:26:02 am >> DELETE FROM ps_specific_price WHERE id_product = '2555' 23/05/2023 08:26:25 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861244771' AND id_product != '2876' AND ean13 != '' 23/05/2023 08:26:25 am >> UPDATE ps_product SET id_supplier = '', reference = '5/1', ean13 = '9788861244771', date_upd = NOW() WHERE id_product = '2876' 23/05/2023 08:26:25 am >> UPDATE ps_product_lang SET name = 'CRESIMA SPIEGATA AI BAMBINI', description = '' WHERE id_product = '2876' 23/05/2023 08:26:25 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.9' WHERE id_product = '2876' 23/05/2023 08:26:25 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.9', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '2876' 23/05/2023 08:26:25 am >> DELETE FROM ps_specific_price WHERE id_product = '2876' 23/05/2023 08:31:26 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '2555' 23/05/2023 08:31:26 am >> UPDATE ps_stock_available SET quantity = quantity + '-5' WHERE id_product = '2555' 23/05/2023 08:33:38 am >> SELECT document_num FROM ps_document WHERE document_num = '25' AND id_document != '84471' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-05-22') 23/05/2023 08:33:38 am >> UPDATE ps_document SET id_document_type = '24', document_num = '25', document_date = '2023-05-22', document_letter = '', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = '2 PEDANE EPAL A RENDERE - EDIZIONI', 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 = '19160.00', price_tax_excluded = '19160.00', date_upd = NOW() WHERE id_document = '84471' 23/05/2023 08:33:38 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 = '84471' 23/05/2023 08:33:38 am >> DELETE FROM ps_document_detail WHERE id_document = '84471' 23/05/2023 08:33:38 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 ( '84471' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '3100' , '-3100' , '4' , '2.8000' , '2.8' , '0' , '0' , '8680.00' ) 23/05/2023 08:33:38 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 ( '84471' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '3100' , '-3100' , '4' , '2.8000' , '2.8' , '0' , '0' , '8680.00' ) 23/05/2023 08:33:38 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 ( '84471' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '90' , '-90' , '4' , '20.0000' , '20' , '0' , '0' , '1800.00' ) 23/05/2023 08:34:01 am >> SELECT document_num FROM ps_document WHERE document_num = '23' AND id_document != '84330' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-05-15') 23/05/2023 08:34:01 am >> UPDATE ps_document SET id_document_type = '24', document_num = '23', document_date = '2023-05-15', document_letter = '', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'EDIZIONI', 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 = '2950.00', price_tax_excluded = '2950.00', date_upd = NOW() WHERE id_document = '84330' 23/05/2023 08:34:01 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84330' 23/05/2023 08:34:01 am >> DELETE FROM ps_document_detail WHERE id_document = '84330' 23/05/2023 08:34:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84330' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '350' , '-350' , '4' , '1.0000' , '1' , '0' , '' , '350.00' ) 23/05/2023 08:34:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84330' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '20' , '-20' , '4' , '35.0000' , '35' , '0' , '' , '700.00' ) 23/05/2023 08:34:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84330' , '20722' , 'SEMINATORI DI GIOIA' , '200' , '-200' , '4' , '2.5000' , '2.5' , '0' , '0' , '500.00' ) 23/05/2023 08:34:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84330' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '200' , '-200' , '4' , '2.5000' , '2.5' , '0' , '0' , '500.00' ) 23/05/2023 08:34:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84330' , '20954' , 'TEMPO DELL’APOCALISSE ' , '60' , '-60' , '4' , '15.0000' , '15' , '0' , '0' , '900.00' ) 23/05/2023 08:44:34 am >> SELECT document_num FROM ps_document WHERE document_num = '1783' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-23') 23/05/2023 08:44:34 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1783' , '2023-05-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.50' , '19.26' , NOW() , NOW() ) 23/05/2023 08:44:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84478' 23/05/2023 08:44:34 am >> DELETE FROM ps_document_detail WHERE id_document = '84478' 23/05/2023 08:44:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84478' , '1220' , 'BICCHIERI FLAMBEAUX - PZ. 50' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 23/05/2023 08:44:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84478' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '8.50' ) 23/05/2023 08:45:22 am >> SELECT document_num FROM ps_document WHERE document_num = '1783' AND id_document != '84478' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-23') 23/05/2023 08:45:23 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1783', document_date = '2023-05-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '23.50', price_tax_excluded = '19.26', date_upd = NOW() WHERE id_document = '84478' 23/05/2023 08:45:23 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 = '84478' 23/05/2023 08:45:23 am >> DELETE FROM ps_document_detail WHERE id_document = '84478' 23/05/2023 08:45:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84478' , '1220' , 'BICCHIERI FLAMBEAUX - PZ. 50' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 23/05/2023 08:45:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84478' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '8.50' ) 23/05/2023 08:45:35 am >> SELECT document_num FROM ps_document WHERE document_num = '1783' AND id_document != '84478' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-23') 23/05/2023 08:45:35 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1783', document_date = '2023-05-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '23.50', price_tax_excluded = '19.26', date_upd = NOW() WHERE id_document = '84478' 23/05/2023 08:45:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84478' 23/05/2023 08:45:35 am >> DELETE FROM ps_document_detail WHERE id_document = '84478' 23/05/2023 08:45:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84478' , '1220' , 'BICCHIERI FLAMBEAUX - PZ. 50' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 23/05/2023 08:45:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84478' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '8.50' ) 23/05/2023 09:29:47 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '962/2023' , '2023-05-20' , '2023' , '0' , '43' , '2638' , 'VIA COSTABIANCA, 43 60025 LORETO' , '' , '' , '8' , '1' , '0' , '0' , '0' , '' , '0' , '0' , '110.27' , '90.39' , NOW() , NOW() ) 23/05/2023 09:29:47 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 = '84479' 23/05/2023 09:29:47 am >> DELETE FROM ps_document_detail WHERE id_document = '84479' 23/05/2023 09:29:47 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 ( '84479' , '16061' , 'MEDAGLIA S. RITA- FM022' , '100' , '0' , '1' , '0.1014' , '0.0831' , '22' , '5+5' , '11.16' ) 23/05/2023 09:29:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '16061' AND id_supplier = '43' 23/05/2023 09:29:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16061' , '43' , '1' ) 23/05/2023 09:29:47 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 ( '84479' , '19991' , 'MED. SCAPOLARE ARG. - RA661' , '1' , '0' , '1' , '7.3200' , '6' , '22' , '5+5' , '8.06' ) 23/05/2023 09:29:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '19991' AND id_supplier = '43' 23/05/2023 09:29:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19991' , '43' , '1' ) 23/05/2023 09:29:47 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 ( '84479' , '20968' , 'CROCE SAN BENEDETTO - PG598' , '6' , '0' , '1' , '5.7000' , '4.6721' , '22' , '5+5' , '37.66' ) 23/05/2023 09:29:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '20968' AND id_supplier = '43' 23/05/2023 09:29:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20968' , '43' , '1' ) 23/05/2023 09:29:47 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 ( '84479' , '21124' , 'MED. SCAPOLARE ARG. - RA662' , '1' , '0' , '1' , '10.6300' , '8.7131' , '22' , '5+5' , '11.70' ) 23/05/2023 09:29:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '21124' AND id_supplier = '43' 23/05/2023 09:29:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21124' , '43' , '1' ) 23/05/2023 09:29:47 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 ( '84479' , '19598' , 'MEDAGLIA SPILLA SPIRITO SANTO - G24OX' , '50' , '0' , '1' , '0.5800' , '0.4754' , '22' , '5+5' , '31.93' ) 23/05/2023 09:29:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '19598' AND id_supplier = '43' 23/05/2023 09:29:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19598' , '43' , '1' ) 23/05/2023 09:31:20 am >> SELECT document_num FROM ps_document WHERE document_num = '1268' AND id_document != '82829' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-15') 23/05/2023 09:31:20 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1268', document_date = '2023-04-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '86.49', price_tax_excluded = '85.97', date_upd = NOW() WHERE id_document = '82829' 23/05/2023 09:31:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82829' 23/05/2023 09:31:20 am >> DELETE FROM ps_document_detail WHERE id_document = '82829' 23/05/2023 09:31:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82829' , '10430' , 'TABOR' , '1' , '-1' , '4' , '17.9000' , '17.9' , '0' , '0' , '17.90' ) 23/05/2023 09:31:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82829' , '13256' , 'SINAI: VIAGGIO CON MOSE - GIOCO' , '1' , '-1' , '4' , '17.9000' , '17.9' , '0' , '0' , '17.90' ) 23/05/2023 09:31:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82829' , '20258' , 'COLORIAMO I MIRACOLI' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 23/05/2023 09:31:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82829' , '18924' , 'TI RACCONTO LA VITA DI GESU' , '2' , '-2' , '4' , '2.5000' , '2.5' , '0' , '0' , '5.00' ) 23/05/2023 09:31:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82829' , '13799' , 'CROCETTA CONFESSIONE - 2370/J44' , '1' , '-1' , '1' , '2.9000' , '2.3770491803279' , '22' , '0' , '2.90' ) 23/05/2023 09:31:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82829' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 23/05/2023 09:31:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82829' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '1' , '-1' , '4' , '18.5000' , '18.5' , '0' , '5' , '17.58' ) 23/05/2023 09:31:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82829' , '11880' , 'ANNO CON LA BIBBIA - 8829' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 23/05/2023 09:31:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82829' , '18049' , 'PADRE NOSTRO SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 23/05/2023 09:31:50 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '523' 23/05/2023 09:31:50 am >> UPDATE ps_stock_available SET quantity = quantity + '1' WHERE id_product = '523' 23/05/2023 09:32:10 am >> SELECT document_num FROM ps_document WHERE document_num = '10' AND id_document != '81357' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-02-14') 23/05/2023 09:32:10 am >> UPDATE ps_document SET id_document_type = '24', document_num = '10', document_date = '2023-02-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669106', address1 = 'VIA G. VERDI, 8 20090 ASSAGO', address2 = '', note = 'RESA - n. c. ricevuta', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '428.20', price_tax_excluded = '428.20', date_upd = NOW() WHERE id_document = '81357' 23/05/2023 09:32: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 = '81357' 23/05/2023 09:32:10 am >> DELETE FROM ps_document_detail WHERE id_document = '81357' 23/05/2023 09:32: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 ( '81357' , '19764' , 'PRIMO PASSO - TACCUINO' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '0' , '10.00' ) 23/05/2023 09:32: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 ( '81357' , '15697' , 'RICCHEZZA DEL LIMITE - A. SCICCHITANO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 23/05/2023 09:32: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 ( '81357' , '5834' , 'LIBRO DEL CELEBRANTE - VOL 1 SLUZHEBNIK' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 23/05/2023 09:32: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 ( '81357' , '18466' , 'ETERNO ASSENTE SANTAGOSTINO - A. BISOGNO' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '0' , '30.00' ) 23/05/2023 09:32: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 ( '81357' , '18043' , 'MESSA INCONTRO CON IL RISORTO - A. ZIRONI' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 23/05/2023 09:32: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 ( '81357' , '19766' , 'WORK IN PROGRESS' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 23/05/2023 09:32: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 ( '81357' , '15525' , 'CASA DI CURIA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 23/05/2023 09:32: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 ( '81357' , '20240' , 'PRONTI PARTENZA A BETLEMME - 11-14 ANNI' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 23/05/2023 09:32: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 ( '81357' , '20241' , 'PRONTI PARTENZA A BETLEMME - 7-10 ANNI' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 23/05/2023 09:32: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 ( '81357' , '20242' , 'PRONTI PARTENZA A BETLEMME - 3-6 ANNI' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '0' , '8.00' ) 23/05/2023 09:32: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 ( '81357' , '19380' , 'OGGETTO PREDICA' , '2' , '-2' , '4' , '16.0000' , '16' , '0' , '0' , '32.00' ) 23/05/2023 09:32: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 ( '81357' , '13914' , 'BAMBINI A MESSA ANNO C - AAVV' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 23/05/2023 09:32: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 ( '81357' , '20590' , 'PREGHIERA - PAPA FRANCESCO' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 23/05/2023 09:32: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 ( '81357' , '19491' , 'IN DIALOGO CON IL MONDO - PAPA FRANCESCO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 23/05/2023 09:32:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '20047' , 'AGENDA MISSIONARIA 2023' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 23/05/2023 09:32:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '6086' , 'MADRE DI MISERICORDIA - M.PAPPALARDO' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 23/05/2023 09:32:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '16049' , 'CINQUANTA GRANI DI CIELO -S. PROIETTI' , '2' , '-2' , '4' , '3.5000' , '3.5' , '0' , '0' , '7.00' ) 23/05/2023 09:32:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '8351' , 'PREGHIERE DEI PASTI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 23/05/2023 09:32:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '4774' , 'GRIDO DEL POVERO - M. MOSCA' , '1' , '-1' , '4' , '8.5000' , '8.5' , '0' , '0' , '8.50' ) 23/05/2023 09:32:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '9099' , 'ROSARIO DELLA TENEREZZA - MADONNA' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '0' , '2.80' ) 23/05/2023 09:32:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '19048' , 'CELIBATO E CONTINENZA ECCLESIALI - C. BONIVENTO' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 23/05/2023 09:32:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '18202' , 'COSTRUIRE UN MONDO NUOVO - AAVV' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 23/05/2023 09:32:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '17595' , 'STATUTO AZIONE CATTOLICA' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 23/05/2023 09:32:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '6642' , 'MIA PRIMA COMUNIONE - M. IASEVOLI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 23/05/2023 09:32:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '14334' , 'VIVIAMO INSIEME IL VANGELO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 23/05/2023 09:32:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '14433' , 'VIVIAMO IL VANGELO - BATTESIMO' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 23/05/2023 09:32:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '14432' , 'VIVIAMO IL VANGELO - ANNO 1 - FAMIGLIE' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '0' , '4.00' ) 23/05/2023 09:32:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '14335' , 'VIVIAMO INSIEME IL VANGELO - ANNO 2' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 23/05/2023 09:32:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '14429' , 'VIVIAMO IL VANGELO - ANNO 3 - FAMIGLIE' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '0' , '4.00' ) 23/05/2023 09:32:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '14340' , 'IO SONO CON VOI - QUADERNO' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 23/05/2023 09:32:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '14697' , 'CREDI AMA SPERA - A. GRAZIANI' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 23/05/2023 09:32:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '18467' , 'INNAMORARSI OGNI GIORNO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 23/05/2023 09:32:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '19762' , 'PRIMO PASSO - GUIDA' , '1' , '-1' , '4' , '12.5000' , '12.5' , '0' , '0' , '12.50' ) 23/05/2023 09:32:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '19762' , 'PRIMO PASSO - GUIDA' , '1' , '-1' , '4' , '12.5000' , '12.5' , '0' , '0' , '12.50' ) 23/05/2023 09:32:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '20051' , 'ANDATE DUNQUE 2022/23 ANNO A' , '1' , '-1' , '4' , '10.5000' , '10.5' , '0' , '0' , '10.50' ) 23/05/2023 09:32:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '19767' , 'RAGAZZI CHE SQUADRA - CALENDARIO' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 23/05/2023 09:32:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '19761' , 'RAGAZZI CHE SQUADRA' , '1' , '-1' , '4' , '16.5000' , '16.5' , '0' , '0' , '16.50' ) 23/05/2023 09:32:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '19761' , 'RAGAZZI CHE SQUADRA' , '1' , '-1' , '4' , '16.5000' , '16.5' , '0' , '0' , '16.50' ) 23/05/2023 09:32:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '19759' , 'RAGAZZI CHE SQUADRA - 2' , '1' , '-1' , '4' , '16.5000' , '16.5' , '0' , '0' , '16.50' ) 23/05/2023 09:32:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81357' , '19758' , 'RAGAZZI CHE SQUADRA - 1' , '1' , '-1' , '4' , '16.5000' , '16.5' , '0' , '0' , '16.50' ) 23/05/2023 09:33:07 am >> SELECT document_num FROM ps_document WHERE document_num = '1771' AND id_document != '84464' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-22') 23/05/2023 09:33:07 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1771', document_date = '2023-05-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '75.60', price_tax_excluded = '65.66', date_upd = NOW() WHERE id_document = '84464' 23/05/2023 09:33: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 = '84464' 23/05/2023 09:33:08 am >> DELETE FROM ps_document_detail WHERE id_document = '84464' 23/05/2023 09:33: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 ( '84464' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 23/05/2023 09:33: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 ( '84464' , '1914' , 'CERA DELLA LITURGIA' , '4' , '-4' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '19.60' ) 23/05/2023 09:33: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 ( '84464' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '18' , '14.754098360656' , '22' , '0' , '18.00' ) 23/05/2023 09:33: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 ( '84464' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '14.00' ) 23/05/2023 09:33: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 ( '84464' , '16689' , 'OSTIA PAN DI CENA mm80' , '6' , '-6' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '12.00' ) 23/05/2023 09:33:23 am >> SELECT document_num FROM ps_document WHERE document_num = '1709' AND id_document != '84389' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-17') 23/05/2023 09:33:23 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1709', document_date = '2023-05-17', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '30.00', price_tax_excluded = '24.59', date_upd = NOW() WHERE id_document = '84389' 23/05/2023 09:33:23 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 = '84389' 23/05/2023 09:33:23 am >> DELETE FROM ps_document_detail WHERE id_document = '84389' 23/05/2023 09:33:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84389' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 23/05/2023 09:33:54 am >> SELECT document_num FROM ps_document WHERE document_num = '1356' AND id_document != '82943' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-26') 23/05/2023 09:33:54 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1356', document_date = '2023-04-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', 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 = '353.50', price_tax_excluded = '290.61', date_upd = NOW() WHERE id_document = '82943' 23/05/2023 09:33:54 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 = '82943' 23/05/2023 09:33:54 am >> DELETE FROM ps_document_detail WHERE id_document = '82943' 23/05/2023 09:33:54 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 ( '82943' , '15331' , 'CERO PASQUALE 80X120 - RILIEVO IN CERA' , '1' , '-1' , '1' , '135.0000' , '110.65573770492' , '22' , '0' , '135.00' ) 23/05/2023 09:33:54 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 ( '82943' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '3' , '-3' , '1' , '22.0000' , '18.032786885246' , '22' , '0' , '66.00' ) 23/05/2023 09:33:54 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 ( '82943' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '84' , '68.852459016393' , '22' , '0' , '84.00' ) 23/05/2023 09:33:54 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 ( '82943' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '1' , '-1' , '1' , '29.0000' , '23.770491803279' , '22' , '0' , '29.00' ) 23/05/2023 09:33:54 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 ( '82943' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '9.80' ) 23/05/2023 09:33:54 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 ( '82943' , '11756' , 'VINO BIANCO SECCO - 14%' , '1' , '-1' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '6.50' ) 23/05/2023 09:33:54 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 ( '82943' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 23/05/2023 09:33:54 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 ( '82943' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '4.00' ) 23/05/2023 09:33:54 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 ( '82943' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '2.20' ) 23/05/2023 09:33:54 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 ( '82943' , '15097' , 'CORONA MATRIMONIO - ORO' , '2' , '-2' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '15.00' ) 23/05/2023 09:35:22 am >> SELECT document_num FROM ps_document WHERE document_num = '1784' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-23') 23/05/2023 09:35: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' , '1784' , '2023-05-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.60' , '4.59' , NOW() , NOW() ) 23/05/2023 09:35: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 = '84480' 23/05/2023 09:35:22 am >> DELETE FROM ps_document_detail WHERE id_document = '84480' 23/05/2023 09:35: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 ( '84480' , '19560' , 'PERGAMENA 17X25' , '8' , '-8' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '5.60' ) 23/05/2023 09:43:16 am >> SELECT document_num FROM ps_document WHERE document_num = '1785' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-23') 23/05/2023 09:43:16 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1785' , '2023-05-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '79.90' , '65.49' , NOW() , NOW() ) 23/05/2023 09:43:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84481' 23/05/2023 09:43:16 am >> DELETE FROM ps_document_detail WHERE id_document = '84481' 23/05/2023 09:43:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84481' , '20983' , 'CLERGY MM LIMITED 80/20' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 23/05/2023 09:43:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84481' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '39.90' , '32.704918032787' , '22' , '0' , '39.90' ) 23/05/2023 11:09:44 am >> SELECT document_num FROM ps_document WHERE document_num = '1786' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-23') 23/05/2023 11:09:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1786' , '2023-05-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '108.78' , '105.37' , NOW() , NOW() ) 23/05/2023 11:09:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84482' 23/05/2023 11:09:44 am >> DELETE FROM ps_document_detail WHERE id_document = '84482' 23/05/2023 11:09:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84482' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '7.60' ) 23/05/2023 11:09:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84482' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 23/05/2023 11:09:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84482' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 23/05/2023 11:09:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84482' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '8.00' ) 23/05/2023 11:09:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84482' , '21057' , 'MIA CONFESSIONE' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 23/05/2023 11:09:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84482' , '21055' , 'MIA PRIMA EUCARISTIA ' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 23/05/2023 11:09:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84482' , '21056' , 'MIA CRESIMA' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 23/05/2023 11:09:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84482' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '20' , '-20' , '4' , '2.00' , '2' , '0' , '5' , '38.00' ) 23/05/2023 11:46:27 am >> SELECT document_num FROM ps_document WHERE document_num = '1787' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-23') 23/05/2023 11:46:27 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1787' , '2023-05-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '73.15' , '73.15' , NOW() , NOW() ) 23/05/2023 11:46:27 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84483' 23/05/2023 11:46:27 am >> DELETE FROM ps_document_detail WHERE id_document = '84483' 23/05/2023 11:46:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84483' , '1145' , 'BIBBIA DI GERUSALEMME BOTT. TASC.' , '1' , '-1' , '4' , '39.00' , '39' , '0' , '5' , '37.05' ) 23/05/2023 11:46:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84483' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '1' , '-1' , '4' , '38.00' , '38' , '0' , '5' , '36.10' ) 23/05/2023 11:54:02 am >> SELECT document_num FROM ps_document WHERE document_num = '1788' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-23') 23/05/2023 11:54: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' , '1788' , '2023-05-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.20' , '3.44' , NOW() , NOW() ) 23/05/2023 11:54: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 = '84484' 23/05/2023 11:54:02 am >> DELETE FROM ps_document_detail WHERE id_document = '84484' 23/05/2023 11:54: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 ( '84484' , '18222' , 'ROSARIO COLORATO - R316' , '6' , '-6' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '4.20' ) 23/05/2023 12:12:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '1789' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-23') 23/05/2023 12:12:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1789' , '2023-05-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.30' , '14.12' , NOW() , NOW() ) 23/05/2023 12:12:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84485' 23/05/2023 12:12:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '84485' 23/05/2023 12:12: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 ( '84485' , '19589' , 'VOLTO DEI SANTI' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 23/05/2023 12:12: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 ( '84485' , '18215' , 'BRACCIALE DECINA VARI COL. - BC752' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 23/05/2023 12:41:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '1790' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-23') 23/05/2023 12:41: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 ( '11' , '1790' , '2023-05-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.00' , '16.00' , NOW() , NOW() ) 23/05/2023 12:41: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 = '84486' 23/05/2023 12:41:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '84486' 23/05/2023 12:41: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 ( '84486' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '16' , '16' , '0' , '0' , '16.00' ) 23/05/2023 03:27:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '1791' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2023-05-23') 23/05/2023 03:27:49 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' , '1791' , '2023-05-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.00' , '28.69' , NOW() , NOW() ) 23/05/2023 03:27:49 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 = '84487' 23/05/2023 03:27:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '84487' 23/05/2023 03:27:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84487' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 23/05/2023 03:27:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '1792' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-23') 23/05/2023 03:27:58 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1792' , '2023-05-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.10' , '36.10' , NOW() , NOW() ) 23/05/2023 03:27:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84488' 23/05/2023 03:27:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '84488' 23/05/2023 03:27:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84488' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '1' , '-1' , '4' , '38.00' , '38' , '0' , '5' , '36.10' ) 23/05/2023 03:29:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '1793' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-23') 23/05/2023 03:29:43 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' , '1793' , '2023-05-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '1.00' , NOW() , NOW() ) 23/05/2023 03:29:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84489' 23/05/2023 03:29:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '84489' 23/05/2023 03:29: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 ( '84489' , '19138' , 'ATTO DI ABBANDONO - D. D. RUOTOLO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 23/05/2023 03:57:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '1794' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-23') 23/05/2023 03:57:24 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' , '1794' , '2023-05-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '113.00' , '97.25' , NOW() , NOW() ) 23/05/2023 03:57:24 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 = '84490' 23/05/2023 03:57:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '84490' 23/05/2023 03:57:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84490' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '9.95' , '8.155737704918' , '22' , '0' , '9.95' ) 23/05/2023 03:57:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84490' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '2' , '-2' , '1' , '7.00' , '5.7377049180328' , '22' , '0' , '14.00' ) 23/05/2023 03:57:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84490' , '7935' , 'PERGAMENE - CRESIMA MOD. B' , '30' , '-30' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '9.00' ) 23/05/2023 03:57:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84490' , '21116' , 'LIBERTA DI ANTONIO - L. EPICOCO' , '1' , '-1' , '4' , '11.00' , '11' , '0' , '5' , '10.45' ) 23/05/2023 03:57:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84490' , '12995' , 'SALE, NON MIELE - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 23/05/2023 03:57:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84490' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '12' , '-12' , '1' , '1.7' , '1.3934426229508' , '22' , '0' , '20.40' ) 23/05/2023 03:57:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84490' , '20062' , 'BRACCIALE DECINA - BD018' , '20' , '-20' , '1' , '1.7' , '1.3934426229508' , '22' , '0' , '34.00' ) 23/05/2023 04:06:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '62/A' AND id_document != '84356' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-05-16') 23/05/2023 04:06:43 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '62/A', document_date = '2023-05-16', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', 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 = '444.00', price_tax_excluded = '444.00', date_upd = NOW() WHERE id_document = '84356' 23/05/2023 04:06:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84356' 23/05/2023 04:06:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '84356' 23/05/2023 04:06: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 ( '84356' , '20118' , 'FATIMA CM 44 - 1035' , '1' , '-1' , '0' , '38.0000' , '38' , '0' , '0' , '38.00' ) 23/05/2023 04:06: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 ( '84356' , '20119' , 'FATIMA CM 35 - 1023' , '1' , '-1' , '0' , '28.0000' , '28' , '0' , '0' , '28.00' ) 23/05/2023 04:06: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 ( '84356' , '20120' , 'FATIMA CM 27 -1025' , '1' , '-1' , '0' , '22.0000' , '22' , '0' , '0' , '22.00' ) 23/05/2023 04:06: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 ( '84356' , '20122' , 'FATIMA CM 21 - 1033' , '1' , '-1' , '0' , '16.0000' , '16' , '0' , '0' , '16.00' ) 23/05/2023 04:06: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 ( '84356' , '20123' , 'FATIMA CM 17 - 1012' , '1' , '-1' , '0' , '7.0000' , '7' , '0' , '0' , '7.00' ) 23/05/2023 04:06: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 ( '84356' , '20124' , 'FATIMA CM 11 - 1011' , '9' , '-9' , '0' , '4.5000' , '4.5' , '0' , '0' , '40.50' ) 23/05/2023 04:06: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 ( '84356' , '20117' , 'FATIMA CM 55 - 1036' , '1' , '-1' , '0' , '65.00' , '65' , '' , '0' , '65.00' ) 23/05/2023 04:06: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 ( '84356' , '20116' , 'FATIMA CM 70 - 1037' , '1' , '-1' , '0' , '120.00' , '120' , '' , '0' , '120.00' ) 23/05/2023 04:06: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 ( '84356' , '' , 'miracolosa' , '1' , '-1' , '0' , '39' , '39' , '' , '0' , '39.00' ) 23/05/2023 04:06: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 ( '84356' , '' , 's. antonio tiesse' , '1' , '-1' , '0' , '29.5' , '29.5' , '' , '0' , '29.50' ) 23/05/2023 04:06: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 ( '84356' , '' , 's. rita' , '1' , '-1' , '0' , '39' , '39' , '' , '0' , '39.00' ) 23/05/2023 04:08:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '1795' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-23') 23/05/2023 04:08:50 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1795' , '2023-05-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '84.50' , '69.26' , NOW() , NOW() ) 23/05/2023 04:08:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84491' 23/05/2023 04:08:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '84491' 23/05/2023 04:08:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84491' , '5997' , 'LUME SOFFIATO CON PIEDE - 1022' , '3' , '-3' , '1' , '15' , '12.295081967213' , '22' , '0' , '45.00' ) 23/05/2023 04:08:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84491' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '5' , '-5' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '5.50' ) 23/05/2023 04:08:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84491' , '4525' , 'GIGLER COMPLETO - 248 ' , '10' , '-10' , '1' , '3.40' , '2.7868852459016' , '22' , '0' , '34.00' ) 23/05/2023 04:09:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '48/A' AND id_document != '82684' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-05') 23/05/2023 04:09:00 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '48/A', document_date = '2023-04-05', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', 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 = '385.00', price_tax_excluded = '315.57', date_upd = NOW() WHERE id_document = '82684' 23/05/2023 04:09:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82684' 23/05/2023 04:09:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '82684' 23/05/2023 04:09: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 ( '82684' , '16514' , 'CROCIFISSO 105X60 - 1015' , '1' , '-1' , '1' , '300.0000' , '245.90163934426' , '22' , '0' , '300.00' ) 23/05/2023 04:09: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 ( '82684' , '0' , '20/05/2022' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 23/05/2023 04:09: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 ( '82684' , '0' , 'ROSA' , '1' , '-1' , '1' , '85.0000' , '69.672131147541' , '22' , '0' , '85.00' ) 23/05/2023 05:12:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '1795' AND id_document != '84491' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-23') 23/05/2023 05:12:39 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1795', document_date = '2023-05-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '84.50', price_tax_excluded = '69.26', date_upd = NOW() WHERE id_document = '84491' 23/05/2023 05:12:39 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 = '84491' 23/05/2023 05:12:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '84491' 23/05/2023 05:12:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84491' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '84.5' , '69.262295081967' , '22' , '0' , '84.50' ) 23/05/2023 05:13:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '1699' AND id_document != '84378' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-17') 23/05/2023 05:13:15 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1699', document_date = '2023-05-17', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '14.90', price_tax_excluded = '12.21', date_upd = NOW() WHERE id_document = '84378' 23/05/2023 05:13:15 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 = '84378' 23/05/2023 05:13:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '84378' 23/05/2023 05:13: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 ( '84378' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '2.20' ) 23/05/2023 05:13: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 ( '84378' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '2.20' ) 23/05/2023 05:13: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 ( '84378' , '19560' , 'PERGAMENA 17X25' , '15' , '-15' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '10.50' ) 23/05/2023 05:13:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '1578' AND id_document != '84233' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-09') 23/05/2023 05:13:41 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1578', document_date = '2023-05-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '4.70', price_tax_excluded = '3.85', date_upd = NOW() WHERE id_document = '84233' 23/05/2023 05:13:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84233' 23/05/2023 05:13:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '84233' 23/05/2023 05:13: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 ( '84233' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '2.20' ) 23/05/2023 05:13: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 ( '84233' , '18276' , 'CINGOLO CON NODI - 3280' , '1' , '-1' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '2.20' ) 23/05/2023 05:13: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 ( '84233' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '1' , '-1' , '1' , '0.3' , '0.24590163934426' , '22' , '0' , '0.30' ) 23/05/2023 05:14:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '1478' AND id_document != '84114' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-03') 23/05/2023 05:14:31 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1478', document_date = '2023-05-03', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '6.50', price_tax_excluded = '5.33', date_upd = NOW() WHERE id_document = '84114' 23/05/2023 05:14: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 = '84114' 23/05/2023 05:14:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '84114' 23/05/2023 05:14: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 ( '84114' , '7915' , 'PERGAMENE - 1A COMUNIONE MOD. D' , '1' , '-1' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '0.50' ) 23/05/2023 05:14: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 ( '84114' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '3' , '-3' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '6.00' ) 23/05/2023 05:15:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '1215' AND id_document != '82759' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-12') 23/05/2023 05:15:46 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1215', document_date = '2023-04-12', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA ROBERTO IL GUISCARDO, 3 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 = '360.40', price_tax_excluded = '311.43', date_upd = NOW() WHERE id_document = '82759' 23/05/2023 05:15: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 = '82759' 23/05/2023 05:15:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '82759' 23/05/2023 05:15: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 ( '82759' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 23/05/2023 05:15: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 ( '82759' , '20071' , 'ROSARIO MISSIONARIO MM8' , '12' , '-12' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '14.40' ) 23/05/2023 05:15: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 ( '82759' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - PADRE G. VALSECCHI' , '10' , '-10' , '4' , '2.0000' , '2' , '0' , '5' , '19.00' ) 23/05/2023 05:15: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 ( '82759' , '1331' , 'BRACCIALE LEGNO BICOLORE - 034CYB499' , '6' , '-6' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '6.00' ) 23/05/2023 05:15: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 ( '82759' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 23/05/2023 05:15: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 ( '82759' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 23/05/2023 05:15: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 ( '82759' , '20068' , 'CORONA ROSARIO ACCIAIO - NS086' , '1' , '-1' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '7.00' ) 23/05/2023 05:15: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 ( '82759' , '20071' , 'ROSARIO MISSIONARIO MM8' , '12' , '-12' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '14.40' ) 23/05/2023 05:15: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 ( '82759' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - PADRE G. VALSECCHI' , '10' , '-10' , '4' , '2.0000' , '2' , '0' , '5' , '19.00' ) 23/05/2023 05:15: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 ( '82759' , '19363' , 'CERO MINIATO 80X100' , '1' , '-1' , '1' , '85.0000' , '69.672131147541' , '22' , '0' , '85.00' ) 23/05/2023 05:15: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 ( '82759' , '20071' , 'ROSARIO MISSIONARIO MM8' , '12' , '-12' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '14.40' ) 23/05/2023 05:15: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 ( '82759' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '9.5000' , '7.7868852459016' , '22' , '0' , '19.00' ) 23/05/2023 05:15: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 ( '82759' , '17880' , 'CROCE FAGGIO CORPO MET. CM 25 - 168' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 23/05/2023 05:15: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 ( '82759' , '17884' , 'CROCE MOGANO CORPO MET CM 25 - 168M' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 23/05/2023 05:15: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 ( '82759' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.7000' , '0.7' , '0' , '0' , '35.00' ) 23/05/2023 05:15: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 ( '82759' , '20071' , 'ROSARIO MISSIONARIO MM8' , '17' , '-17' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '20.40' ) 23/05/2023 05:15: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 ( '82759' , '16689' , 'OSTIA PAN DI CENA mm80' , '7' , '-7' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '14.00' ) 23/05/2023 05:15: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 ( '82759' , '9133' , 'ROSARIO LEGNO ADDOLORATA - 01002 - 25' , '1' , '-1' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '9.00' ) 23/05/2023 05:15: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 ( '82759' , '9095' , 'ROSARIO DEI SETTE DOLORI DELLA VERGINE - 8140' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 23/05/2023 05:15: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 ( '82759' , '20719' , 'CORONA DELL’ADDOLORATA' , '1' , '-1' , '4' , '1.8000' , '1.8' , '0' , '0' , '1.80' ) 23/05/2023 05:15: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 ( '82759' , '17880' , 'CROCE FAGGIO CORPO MET. CM 25 - 168' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 23/05/2023 05:15: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 ( '82759' , '17884' , 'CROCE MOGANO CORPO MET. CM 25 - 168M' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 23/05/2023 05:15: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 ( '82759' , '15387' , 'VESTINA BATTESIMALE ' , '2' , '-2' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '6.00' ) 23/05/2023 05:15: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 ( '82759' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '2' , '-2' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '1.00' ) 23/05/2023 05:16:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '1356' AND id_document != '82943' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-26') 23/05/2023 05:16:26 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1356', document_date = '2023-04-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', 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 = '353.50', price_tax_excluded = '290.61', date_upd = NOW() WHERE id_document = '82943' 23/05/2023 05:16:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82943' 23/05/2023 05:16:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '82943' 23/05/2023 05:16:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82943' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '3' , '-3' , '1' , '22.0000' , '18.032786885246' , '22' , '0' , '66.00' ) 23/05/2023 05:16:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82943' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '219' , '179.50819672131' , '22' , '0' , '219.00' ) 23/05/2023 05:16:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82943' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '1' , '-1' , '1' , '29.0000' , '23.770491803279' , '22' , '0' , '29.00' ) 23/05/2023 05:16:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82943' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '9.80' ) 23/05/2023 05:16:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82943' , '11756' , 'VINO BIANCO SECCO - 14%' , '1' , '-1' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '6.50' ) 23/05/2023 05:16:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82943' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 23/05/2023 05:16:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82943' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '4.00' ) 23/05/2023 05:16:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82943' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '2.20' ) 23/05/2023 05:16:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82943' , '15097' , 'CORONA MATRIMONIO - ORO' , '2' , '-2' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '15.00' ) 23/05/2023 05:17:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '1704' AND id_document != '84384' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-17') 23/05/2023 05:17:44 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1704', document_date = '2023-05-17', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '152.20', price_tax_excluded = '128.50', date_upd = NOW() WHERE id_document = '84384' 23/05/2023 05:17:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84384' 23/05/2023 05:17:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '84384' 23/05/2023 05:17: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 ( '84384' , '20518' , 'DECINA PERLA - 43/4-D' , '3' , '-3' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '3.00' ) 23/05/2023 05:17: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 ( '84384' , '3359' , 'DECINA' , '22' , '-22' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '26.40' ) 23/05/2023 05:17: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 ( '84384' , '19310' , 'SACCHETTO CON CORONCINA E SEGNALIBRO - 1315/K182' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 23/05/2023 05:17: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 ( '84384' , '11151' , 'LIBRI' , '16' , '-16' , '4' , '1.3000' , '1.3' , '0' , '0' , '20.80' ) 23/05/2023 05:17: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 ( '84384' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 23/05/2023 05:21:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '1566' AND id_document != '84218' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-08') 23/05/2023 05:21:54 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1566', document_date = '2023-05-08', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '19.00', price_tax_excluded = '19.00', date_upd = NOW() WHERE id_document = '84218' 23/05/2023 05:21: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 = '84218' 23/05/2023 05:21:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '84218' 23/05/2023 05:21: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 ( '84218' , '17839' , 'EVANGELO COME MI E STATO RIVELATO 2 - M. VALTORTA' , '1' , '-1' , '4' , '20' , '20' , '0' , '5' , '19.00' ) 23/05/2023 05:22:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '1215' AND id_document != '82759' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-12') 23/05/2023 05:22:49 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1215', document_date = '2023-04-12', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA ROBERTO IL GUISCARDO, 3 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 = '360.40', price_tax_excluded = '311.43', date_upd = NOW() WHERE id_document = '82759' 23/05/2023 05:22:49 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 = '82759' 23/05/2023 05:22:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '82759' 23/05/2023 05:22:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 23/05/2023 05:22:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '20071' , 'ROSARIO MISSIONARIO MM8' , '12' , '-12' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '14.40' ) 23/05/2023 05:22:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - PADRE G. VALSECCHI' , '10' , '-10' , '4' , '2.0000' , '2' , '0' , '5' , '19.00' ) 23/05/2023 05:22:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '1331' , 'BRACCIALE LEGNO BICOLORE - 034CYB499' , '6' , '-6' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '6.00' ) 23/05/2023 05:22:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 23/05/2023 05:22:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 23/05/2023 05:22:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '20068' , 'CORONA ROSARIO ACCIAIO - NS086' , '1' , '-1' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '7.00' ) 23/05/2023 05:22:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '20071' , 'ROSARIO MISSIONARIO MM8' , '12' , '-12' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '14.40' ) 23/05/2023 05:22:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - PADRE G. VALSECCHI' , '10' , '-10' , '4' , '2.0000' , '2' , '0' , '5' , '19.00' ) 23/05/2023 05:22:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '19363' , 'CERO MINIATO 80X100' , '1' , '-1' , '1' , '85.0000' , '69.672131147541' , '22' , '0' , '85.00' ) 23/05/2023 05:22:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '20071' , 'ROSARIO MISSIONARIO MM8' , '12' , '-12' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '14.40' ) 23/05/2023 05:22:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '28' , '22.950819672131' , '22' , '0' , '28.00' ) 23/05/2023 05:22:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '17880' , 'CROCE FAGGIO CORPO MET. CM 25 - 168' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 23/05/2023 05:22:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '17884' , 'CROCE MOGANO CORPO MET CM 25 - 168M' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 23/05/2023 05:22:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.7000' , '0.7' , '0' , '0' , '35.00' ) 23/05/2023 05:22:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '20071' , 'ROSARIO MISSIONARIO MM8' , '17' , '-17' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '20.40' ) 23/05/2023 05:22:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '16689' , 'OSTIA PAN DI CENA mm80' , '7' , '-7' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '14.00' ) 23/05/2023 05:22:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '9095' , 'ROSARIO DEI SETTE DOLORI DELLA VERGINE - 8140' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 23/05/2023 05:22:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '20719' , 'CORONA DELL’ADDOLORATA' , '1' , '-1' , '4' , '1.8000' , '1.8' , '0' , '0' , '1.80' ) 23/05/2023 05:22:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '17880' , 'CROCE FAGGIO CORPO MET. CM 25 - 168' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 23/05/2023 05:22:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '17884' , 'CROCE MOGANO CORPO MET. CM 25 - 168M' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 23/05/2023 05:22:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '15387' , 'VESTINA BATTESIMALE ' , '2' , '-2' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '6.00' ) 23/05/2023 05:22:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82759' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '2' , '-2' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '1.00' ) 23/05/2023 05:23:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '909' AND id_document != '82386' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-21') 23/05/2023 05:23:18 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '909', document_date = '2023-03-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', 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 = '244.70', price_tax_excluded = '204.23', date_upd = NOW() WHERE id_document = '82386' 23/05/2023 05:23:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82386' 23/05/2023 05:23:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '82386' 23/05/2023 05:23: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 ( '82386' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '8.50' ) 23/05/2023 05:23: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 ( '82386' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 23/05/2023 05:23: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 ( '82386' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '1.90' ) 23/05/2023 05:23: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 ( '82386' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 23/05/2023 05:23: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 ( '82386' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '2' , '-2' , '1' , '1.4000' , '1.1475409836066' , '22' , '0' , '2.80' ) 23/05/2023 05:23: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 ( '82386' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '6' , '-6' , '4' , '2.0000' , '2' , '0' , '0' , '12.00' ) 23/05/2023 05:23: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 ( '82386' , '10501' , 'TECA STANDARD IHS ' , '8' , '-8' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '200.00' ) 23/05/2023 05:23: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 ( '82386' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '2' , '-2' , '4' , '2.0000' , '2' , '0' , '0' , '4.00' ) 23/05/2023 05:24:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '353' AND id_document != '51198' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-02-08') 23/05/2023 05:24:42 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '353', document_date = '2022-02-08', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '15.80', price_tax_excluded = '14.66', date_upd = NOW() WHERE id_document = '51198' 23/05/2023 05:24: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 = '51198' 23/05/2023 05:24:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '51198' 23/05/2023 05:24: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 ( '51198' , '18802' , 'SULLA TUA PAROLA - GEN/FEB 2022' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 23/05/2023 05:24: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 ( '51198' , '19110' , 'SULLA TUA PAROLA MAR/APR 2022' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 23/05/2023 05:24: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 ( '51198' , '1325' , 'BRACCIALE IN CORDA CON TAU - 1649' , '3' , '-3' , '1' , '1.6000' , '1.3114754098361' , '22' , '0' , '4.80' ) 23/05/2023 05:24: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 ( '51198' , '20548' , 'MEDAGLIA SAN BENEDETTO -T18/SBB' , '5' , '-5' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '1.50' ) 23/05/2023 05:25:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '1011' AND id_document != '82512' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-28') 23/05/2023 05:25:24 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1011', document_date = '2023-03-28', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '2.80', price_tax_excluded = '2.66', date_upd = NOW() WHERE id_document = '82512' 23/05/2023 05:25:24 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 = '82512' 23/05/2023 05:25:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '82512' 23/05/2023 05:25:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82512' , '8765' , 'QUINDICI ORAZIONI DI SANTA BRIGIDA - 8193' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 23/05/2023 05:25:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82512' , '5105' , 'IMMAGINI SACRE SERIE STELLA 20X25 ' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 23/05/2023 06:05:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '1796' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-23') 23/05/2023 06:05:33 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' , '1796' , '2023-05-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.00' , '20.49' , NOW() , NOW() ) 23/05/2023 06:05:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84492' 23/05/2023 06:05:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '84492' 23/05/2023 06:05:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84492' , '7907' , 'PERGAMENE' , '50' , '-50' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '25.00' ) 23/05/2023 07:10:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '1797' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-23') 23/05/2023 07:10:07 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' , '1797' , '2023-05-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.50' , '10.25' , NOW() , NOW() ) 23/05/2023 07:10:07 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 = '84493' 23/05/2023 07:10:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '84493' 23/05/2023 07:10:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84493' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '25' , '-25' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '12.50' ) 23/05/2023 07:22:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '1768' AND id_document != '84460' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-22') 23/05/2023 07:22:43 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1768', document_date = '2023-05-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '33.60', price_tax_excluded = '27.54', date_upd = NOW() WHERE id_document = '84460' 23/05/2023 07:22:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84460' 23/05/2023 07:22:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '84460' 23/05/2023 07:22:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84460' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5.6' , '4.5901639344262' , '22' , '0' , '5.60' ) 23/05/2023 07:22:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84460' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '2' , '-2' , '1' , '0.8000' , '0.65573770491803' , '22' , '0' , '1.60' ) 23/05/2023 07:22:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84460' , '16310' , 'PORTACHIAVI COLOMBA - KP027' , '22' , '-22' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '26.40' ) 23/05/2023 07:42:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '1798' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-23') 23/05/2023 07:42:35 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1798' , '2023-05-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '44.00' , '36.07' , NOW() , NOW() ) 23/05/2023 07:42:35 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84494' 23/05/2023 07:42:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '84494' 23/05/2023 07:42: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 ( '84494' , '18390' , 'BRACCIALE 10 ESSENZE' , '2' , '-2' , '1' , '22' , '18.032786885246' , '22' , '0' , '44.00' )