27/03/2023 09:34:21 am >> SELECT document_num FROM ps_document WHERE document_num = '22/A' AND id_document != '81317' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-10') 27/03/2023 09:34:21 am >> UPDATE ps_document SET id_document_type = '24', document_num = '22/A', document_date = '2023-02-10', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '131.60', price_tax_excluded = '131.60', date_upd = NOW() WHERE id_document = '81317' 27/03/2023 09:34: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 = '81317' 27/03/2023 09:34:22 am >> DELETE FROM ps_document_detail WHERE id_document = '81317' 27/03/2023 09:34: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 ( '81317' , '16267' , 'DIO SI RACCONTA - P. DE MARTINO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 27/03/2023 09:34: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 ( '81317' , '16444' , 'VANGELO DI MARCO - 8998' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 27/03/2023 09:34: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 ( '81317' , '20766' , 'AMEN - GIU 2023' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 27/03/2023 09:34: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 ( '81317' , '20765' , 'AMEN - MAG 2023' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 27/03/2023 09:34: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 ( '81317' , '20009' , 'E IL SIGNORE! - V. BATTAGLIA' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 27/03/2023 09:34: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 ( '81317' , '20731' , 'PAROLA E PREGHIERA APR 23' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 27/03/2023 09:34: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 ( '81317' , '20764' , 'PAROLA E PREGHIERA - MAG 2023' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 27/03/2023 09:34: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 ( '81317' , '20756' , 'COMMENTARIO BIBLICO' , '1' , '-1' , '4' , '50.0000' , '50' , '0' , '0' , '50.00' ) 27/03/2023 09:34: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 ( '81317' , '20801' , 'PREGHIERA RESPIRO DELLANIMA - PAPA FRANCESCO' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 27/03/2023 09:34: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 ( '81317' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 27/03/2023 09:39:16 am >> SELECT document_num FROM ps_document WHERE document_num = '983' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-27') 27/03/2023 09:39: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' , '983' , '2023-03-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1159.50' , '950.41' , NOW() , NOW() ) 27/03/2023 09:39: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 = '82477' 27/03/2023 09:39:16 am >> DELETE FROM ps_document_detail WHERE id_document = '82477' 27/03/2023 09:39: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 ( '82477' , '19407' , 'CALICE - 1839' , '1' , '-1' , '1' , '515.00' , '422.13114754098' , '22' , '0' , '515.00' ) 27/03/2023 09:39: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 ( '82477' , '19408' , 'PISSIDE - 1839p' , '1' , '-1' , '1' , '560.00' , '459.01639344262' , '22' , '0' , '560.00' ) 27/03/2023 09:39: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 ( '82477' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '1' , '-1' , '1' , '42.00' , '34.426229508197' , '22' , '0' , '42.00' ) 27/03/2023 09:39: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 ( '82477' , '8053' , 'PISSIDE DIAM 14 C/COPERCHIO - 864' , '1' , '-1' , '1' , '95.00' , '77.868852459016' , '22' , '0' , '95.00' ) 27/03/2023 09:39: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 ( '82477' , '19150' , 'MOCCOLO 70X200' , '3' , '-3' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '22.50' ) 27/03/2023 09:39: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 ( '82477' , '' , 'sconto' , '1' , '-1' , '1' , '-75' , '-61.475409836066' , '22' , '0' , '-75.00' ) 27/03/2023 10:30:18 am >> SELECT document_num FROM ps_document WHERE document_num = '40/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-03-27') 27/03/2023 10:30:18 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '40/A' , '2023-03-27' , 'A' , '357' , '0' , '4676034' , 'VIA TORRIONE 84100 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '100.00' , NOW() , NOW() ) 27/03/2023 10:30:18 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82478' 27/03/2023 10:30:18 am >> DELETE FROM ps_document_detail WHERE id_document = '82478' 27/03/2023 10:30:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82478' , '794' , 'ASTUCCIO 3 BOTTIGLIE CC125 - 964' , '1' , '-1' , '0' , '100' , '100' , '' , '0' , '100.00' ) 27/03/2023 10:33:54 am >> SELECT document_num FROM ps_document WHERE document_num = '983' AND id_document != '82477' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-27') 27/03/2023 10:33:54 am >> UPDATE ps_document SET id_document_type = '11', document_num = '983', document_date = '2023-03-27', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '1309.50', price_tax_excluded = '1073.36', date_upd = NOW() WHERE id_document = '82477' 27/03/2023 10: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 = '82477' 27/03/2023 10:33:54 am >> DELETE FROM ps_document_detail WHERE id_document = '82477' 27/03/2023 10: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 ( '82477' , '19407' , 'CALICE - 1839' , '1' , '-1' , '1' , '515.0000' , '422.13114754098' , '22' , '0' , '515.00' ) 27/03/2023 10: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 ( '82477' , '19408' , 'PISSIDE - 1839p' , '1' , '-1' , '1' , '560.0000' , '459.01639344262' , '22' , '0' , '560.00' ) 27/03/2023 10: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 ( '82477' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '1' , '-1' , '1' , '42.0000' , '34.426229508197' , '22' , '0' , '42.00' ) 27/03/2023 10: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 ( '82477' , '8053' , 'PISSIDE DIAM 14 C/COPERCHIO - 864' , '1' , '-1' , '1' , '95.0000' , '77.868852459016' , '22' , '0' , '95.00' ) 27/03/2023 10: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 ( '82477' , '19150' , 'MOCCOLO 70X200' , '3' , '-3' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '22.50' ) 27/03/2023 10: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 ( '82477' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '75' , '61.475409836066' , '22' , '0' , '75.00' ) 27/03/2023 10:45:37 am >> SELECT document_num FROM ps_document WHERE document_num = '872' AND id_document != '82335' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-16') 27/03/2023 10:45:37 am >> UPDATE ps_document SET id_document_type = '11', document_num = '872', document_date = '2023-03-16', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '135.00', price_tax_excluded = '110.66', date_upd = NOW() WHERE id_document = '82335' 27/03/2023 10:45:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82335' 27/03/2023 10:45:37 am >> DELETE FROM ps_document_detail WHERE id_document = '82335' 27/03/2023 10:45:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82335' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 27/03/2023 10:45:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82335' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '5' , '-5' , '1' , '20' , '16.393442622951' , '22' , '0' , '100.00' ) 27/03/2023 10:54:26 am >> SELECT document_num FROM ps_document WHERE document_num = '911' AND id_document != '82388' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-21') 27/03/2023 10:54:26 am >> UPDATE ps_document SET id_document_type = '11', document_num = '911', document_date = '2023-03-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '39.50', price_tax_excluded = '38.69', date_upd = NOW() WHERE id_document = '82388' 27/03/2023 10:54:26 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 = '82388' 27/03/2023 10:54:26 am >> DELETE FROM ps_document_detail WHERE id_document = '82388' 27/03/2023 10:54: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 ( '82388' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '14.28' , '14.28' , '0' , '0' , '14.28' ) 27/03/2023 10:54: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 ( '82388' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '3' , '-3' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '4.50' ) 27/03/2023 10:54: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 ( '82388' , '20866' , 'MIO GRANDE LIBRO DA COLORARE MITICO' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '5' , '7.51' ) 27/03/2023 10:54: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 ( '82388' , '20865' , 'MIO GRANDE LIBRO DA COLORARE' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '5' , '7.51' ) 27/03/2023 10:54: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 ( '82388' , '20870' , 'NEL VENTRE TUO - VIA MATRIS' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 27/03/2023 10:57:42 am >> SELECT document_num FROM ps_document WHERE document_num = '911' AND id_document != '82388' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-21') 27/03/2023 10:57:43 am >> UPDATE ps_document SET id_document_type = '11', document_num = '911', document_date = '2023-03-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '39.50', price_tax_excluded = '38.69', date_upd = NOW() WHERE id_document = '82388' 27/03/2023 10:57:43 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82388' 27/03/2023 10:57:43 am >> DELETE FROM ps_document_detail WHERE id_document = '82388' 27/03/2023 10:57:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82388' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '3' , '-3' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '4.50' ) 27/03/2023 10:57:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82388' , '20866' , 'MIO GRANDE LIBRO DA COLORARE MITICO' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '5' , '7.51' ) 27/03/2023 10:57:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82388' , '20865' , 'MIO GRANDE LIBRO DA COLORARE' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '5' , '7.51' ) 27/03/2023 10:57:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82388' , '20870' , 'NEL VENTRE TUO - VIA MATRIS' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 27/03/2023 10:57:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82388' , '20817' , 'FACCIA A FACCIA CON GESU - D. RUOTOLO' , '1' , '-1' , '4' , '14.28' , '14.28' , '0' , '0' , '14.28' ) 27/03/2023 10:58:33 am >> SELECT document_num FROM ps_document WHERE document_num = '41/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-03-27') 27/03/2023 10:58:33 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '41/A' , '2023-03-27' , 'A' , '3030' , '0' , '4671709' , 'VIA SAN FELICE IN FELLINE, 10 84134 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1100.00' , '901.64' , NOW() , NOW() ) 27/03/2023 10:58:33 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82479' 27/03/2023 10:58:33 am >> DELETE FROM ps_document_detail WHERE id_document = '82479' 27/03/2023 10:58:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82479' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1100' , '901.6393442623' , '22' , '0' , '1100.00' ) 27/03/2023 11:12:26 am >> SELECT document_num FROM ps_document WHERE document_num = '984' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-27') 27/03/2023 11:12:26 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' , '984' , '2023-03-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.95' , '19.95' , NOW() , NOW() ) 27/03/2023 11:12:26 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 = '82480' 27/03/2023 11:12:26 am >> DELETE FROM ps_document_detail WHERE id_document = '82480' 27/03/2023 11:12:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82480' , '7704' , 'PASSIONE DI NOSTRO SIGNORE GESÙ CRISTO - 8671' , '3' , '-3' , '4' , '7.00' , '7' , '0' , '5' , '19.95' ) 27/03/2023 11:17:34 am >> SELECT document_num FROM ps_document WHERE document_num = '830' AND id_document != '82284' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-13') 27/03/2023 11:17:34 am >> UPDATE ps_document SET id_document_type = '11', document_num = '830', document_date = '2023-03-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '390.00', price_tax_excluded = '341.00', date_upd = NOW() WHERE id_document = '82284' 27/03/2023 11:17: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 = '82284' 27/03/2023 11:17:34 am >> DELETE FROM ps_document_detail WHERE id_document = '82284' 27/03/2023 11:17: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 ( '82284' , '15331' , 'CERO PASQUALE 80X120 - RILIEVO IN CERA' , '1' , '-1' , '1' , '135.0000' , '110.65573770492' , '22' , '0' , '135.00' ) 27/03/2023 11:17: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 ( '82284' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 27/03/2023 11:17: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 ( '82284' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 27/03/2023 11:17: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 ( '82284' , '11805' , 'TECA IHS - 823' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 27/03/2023 11:17: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 ( '82284' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '5' , '-5' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '100.00' ) 27/03/2023 11:17: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 ( '82284' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '75.0000' , '75' , '0' , '0' , '75.00' ) 27/03/2023 11:37:03 am >> SELECT document_num FROM ps_document WHERE document_num = '985' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-27') 27/03/2023 11:37:03 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' , '985' , '2023-03-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '2.00' , NOW() , NOW() ) 27/03/2023 11:37:03 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 = '82481' 27/03/2023 11:37:03 am >> DELETE FROM ps_document_detail WHERE id_document = '82481' 27/03/2023 11:37:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82481' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 27/03/2023 12:36:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '39/A' AND id_document != '82468' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-03-25') 27/03/2023 12:36:31 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '39/A', document_date = '2023-03-25', document_letter = 'A', id_customer = '922', id_supplier = '', id_address = '4671011', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', 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 = '766.30', price_tax_excluded = '766.30', date_upd = NOW() WHERE id_document = '82468' 27/03/2023 12:36: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 = '82468' 27/03/2023 12:36:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '82468' 27/03/2023 12:36: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 ( '82468' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '60' , '-60' , '0' , '3.5000' , '3.5' , '0' , '0' , '210.00' ) 27/03/2023 12:36: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 ( '82468' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '0' , '4.9000' , '4.9' , '0' , '0' , '117.60' ) 27/03/2023 12:36: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 ( '82468' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '0' , '85.0000' , '85' , '0' , '0' , '85.00' ) 27/03/2023 12:36: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 ( '82468' , '0' , 'GRANI' , '1' , '-1' , '0' , '13.0000' , '13' , '0' , '0' , '13.00' ) 27/03/2023 12:36: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 ( '82468' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '11' , '-11' , '4' , '0.7000' , '0.7' , '0' , '0' , '7.70' ) 27/03/2023 12:36: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 ( '82468' , '9133' , 'ROSARIO LEGNO ADDOLORATA - 01002 - 25' , '2' , '-2' , '0' , '9.0000' , '9' , '' , '0' , '18.00' ) 27/03/2023 12:36:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82468' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '0' , '37.0000' , '37' , '' , '0' , '37.00' ) 27/03/2023 12:36:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82468' , '19397' , 'CLERGY COTONE 100% ML - C02' , '1' , '-1' , '0' , '40.0000' , '40' , '' , '0' , '40.00' ) 27/03/2023 12:36:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82468' , '0' , 'PADRE CARLO' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 27/03/2023 12:36:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82468' , '8219' , 'PRATICA DI AMAR GESÙ CRISTO - 8464' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 27/03/2023 12:36:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82468' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '2' , '-2' , '4' , '10.0000' , '10' , '0' , '0' , '20.00' ) 27/03/2023 12:36:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82468' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '2' , '-2' , '0' , '37.0000' , '37' , '0' , '0' , '74.00' ) 27/03/2023 12:36:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82468' , '18682' , 'CLERGY ROMANO ML - C17' , '1' , '-1' , '0' , '49.0000' , '49' , '0' , '0' , '49.00' ) 27/03/2023 12:36:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82468' , '2328' , 'CLERGY GRIGIO MM - COTONE 43 ' , '1' , '-1' , '0' , '37.0000' , '37' , '0' , '0' , '37.00' ) 27/03/2023 12:36:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82468' , '18682' , 'CLERGY ROMANO ML - C17' , '1' , '-1' , '0' , '49.0000' , '49' , '0' , '0' , '49.00' ) 27/03/2023 12:41:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '986' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-27') 27/03/2023 12:41:27 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '986' , '2023-03-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 27/03/2023 12:41:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82482' 27/03/2023 12:41:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '82482' 27/03/2023 12:41:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82482' , '14163' , 'PARACERA OTTONE LUCIDO - Q120' , '1' , '-1' , '1' , '45.00' , '36.885245901639' , '22' , '0' , '45.00' ) 27/03/2023 02:07:13 pm >> DELETE FROM ps_document WHERE id_document = '82468' 27/03/2023 02:07:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '82468' 27/03/2023 02:16:06 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '2023-DL000982' , '2023-03-24' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '170.10' , '170.10' , NOW() , NOW() ) 27/03/2023 02:16:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82483' 27/03/2023 02:16:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '82483' 27/03/2023 02:16:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82483' , '5887' , 'LITURGIA DELLE ORE - VOL. I - PER SACERDOTI E RELIGIOSI' , '2' , '2' , '4' , '35.00' , '35' , '0' , '30' , '49.0000' ) 27/03/2023 02:16:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5887' AND id_supplier = '79' 27/03/2023 02:16:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5887' , '79' , '1' ) 27/03/2023 02:16:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82483' , '5889' , 'LITURGIA DELLE ORE - VOL. III - PER SACERDOTI E RELIGIOSI' , '2' , '2' , '4' , '35.00' , '35' , '0' , '30' , '49.0000' ) 27/03/2023 02:16:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5889' AND id_supplier = '79' 27/03/2023 02:16:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5889' , '79' , '1' ) 27/03/2023 02:16:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82483' , '5890' , 'LITURGIA DELLE ORE - VOL. IV - PER SACERDOTI E RELIGIOSI' , '2' , '2' , '4' , '35.00' , '35' , '0' , '30' , '49.0000' ) 27/03/2023 02:16:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5890' AND id_supplier = '79' 27/03/2023 02:16:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5890' , '79' , '1' ) 27/03/2023 02:16:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82483' , '10119' , 'SPE SALVI' , '1' , '1' , '4' , '2.00' , '2' , '0' , '45' , '1.1000' ) 27/03/2023 02:16:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10119' AND id_supplier = '79' 27/03/2023 02:16:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10119' , '79' , '1' ) 27/03/2023 02:16:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82483' , '3544' , 'DIRETTORIO OMILETICO' , '1' , '1' , '4' , '10.00' , '10' , '0' , '45' , '5.5000' ) 27/03/2023 02:16:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3544' AND id_supplier = '79' 27/03/2023 02:16:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3544' , '79' , '1' ) 27/03/2023 02:16:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82483' , '20464' , 'TI RACCONTO IL VANGELO MATTEO - PAPA FRANCESCO' , '2' , '2' , '4' , '15.00' , '15' , '0' , '45' , '16.5000' ) 27/03/2023 02:16:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20464' AND id_supplier = '79' 27/03/2023 02:16:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20464' , '79' , '1' ) 27/03/2023 02:22:55 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 27/03/2023 02:22:55 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20877' , '1' , '' , 'nuovo-prodotto' ) 27/03/2023 02:22:55 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20877' , '1' , '1' , '2' , NOW() , NOW() ) 27/03/2023 02:22:55 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20877' , '0' , '1' , '0' , '0' ) 27/03/2023 02:23:52 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788893183185' AND id_product != '20877' AND ean13 != '' 27/03/2023 02:23:52 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788893183185', date_upd = NOW() WHERE id_product = '20877' 27/03/2023 02:23:52 pm >> UPDATE ps_product_lang SET name = 'NEL SEGNO DELLA DIVINA VOLONTA\' - L. PICCARRETA', description = '' WHERE id_product = '20877' 27/03/2023 02:23:52 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8' WHERE id_product = '20877' 27/03/2023 02:23:52 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8', id_tax_rules_group = '4', id_category_default = '47', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20877' 27/03/2023 02:23:52 pm >> DELETE FROM ps_specific_price WHERE id_product = '20877' 27/03/2023 02:23:53 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20877' 27/03/2023 02:23:53 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20878' , '1' , '' , 'nuovo-prodotto' ) 27/03/2023 02:23:53 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20878' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20877' 27/03/2023 02:23:53 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20878' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20877' 27/03/2023 02:24:54 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788804763192' AND id_product != '20878' AND ean13 != '' 27/03/2023 02:24:54 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/5', ean13 = '9788804763192', date_upd = NOW() WHERE id_product = '20878' 27/03/2023 02:24:54 pm >> UPDATE ps_product_lang SET name = 'PROCESSO A FRANCESCO - E. FORTUNATO', description = '' WHERE id_product = '20878' 27/03/2023 02:24:54 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '20878' 27/03/2023 02:24:54 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '4', id_category_default = '46', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20878' 27/03/2023 02:24:54 pm >> DELETE FROM ps_specific_price WHERE id_product = '20878' 27/03/2023 02:24:55 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20878' 27/03/2023 02:24:55 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20879' , '1' , '' , 'nuovo-prodotto' ) 27/03/2023 02:24:55 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20879' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20878' 27/03/2023 02:24:55 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20879' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20878' 27/03/2023 02:25:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791254520048' AND id_product != '20879' AND ean13 != '' 27/03/2023 02:25:56 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/3', ean13 = '9791254520048', date_upd = NOW() WHERE id_product = '20879' 27/03/2023 02:25:56 pm >> UPDATE ps_product_lang SET name = 'SALITA DEL MONTE CARMELO - G. DELLA CROCE', description = '' WHERE id_product = '20879' 27/03/2023 02:25:56 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '20879' 27/03/2023 02:25:56 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '128', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20879' 27/03/2023 02:25:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '20879' 27/03/2023 02:25:57 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20879' 27/03/2023 02:25:57 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20880' , '1' , '' , 'nuovo-prodotto' ) 27/03/2023 02:25:57 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20880' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20879' 27/03/2023 02:25:57 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20880' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20879' 27/03/2023 02:27:21 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788863663945' AND id_product != '20880' AND ean13 != '' 27/03/2023 02:27:21 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/5', ean13 = '9788863663945', date_upd = NOW() WHERE id_product = '20880' 27/03/2023 02:27:21 pm >> UPDATE ps_product_lang SET name = 'UN TEMPO PER DIO - J. PHILIPPE', description = '' WHERE id_product = '20880' 27/03/2023 02:27:21 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '20880' 27/03/2023 02:27:21 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '24', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20880' 27/03/2023 02:27:21 pm >> DELETE FROM ps_specific_price WHERE id_product = '20880' 27/03/2023 02:27:22 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20880' 27/03/2023 02:27:22 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20881' , '1' , '' , 'nuovo-prodotto' ) 27/03/2023 02:27:22 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20881' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20880' 27/03/2023 02:27:22 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20881' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20880' 27/03/2023 02:28:34 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788804763192' AND id_product != '20878' AND ean13 != '' 27/03/2023 02:28:34 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/5', ean13 = '9788804763192', date_upd = NOW() WHERE id_product = '20878' 27/03/2023 02:28:34 pm >> UPDATE ps_product_lang SET name = 'PROCESSO A FRANCESCO - E. FORTUNATO', description = '' WHERE id_product = '20878' 27/03/2023 02:28:34 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '17.5' WHERE id_product = '20878' 27/03/2023 02:28:34 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '17.5', id_tax_rules_group = '4', id_category_default = '46', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20878' 27/03/2023 02:28:34 pm >> DELETE FROM ps_specific_price WHERE id_product = '20878' 27/03/2023 02:29:26 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '1573' , '2023-03-23' , '' , '0' , '47' , '2642' , 'V.LE BACCHIGLIONE, 20 20139 MILANO' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '76.05' , '76.05' , NOW() , NOW() ) 27/03/2023 02:29: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 = '82484' 27/03/2023 02:29:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '82484' 27/03/2023 02:29: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 ( '82484' , '20877' , 'NEL SEGNO DELLA DIVINA VOLONTA - L. PICCARRETA' , '1' , '1' , '4' , '8.00' , '8' , '0' , '30' , '5.6000' ) 27/03/2023 02:29:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20877' AND id_supplier = '47' 27/03/2023 02:29:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20877' , '47' , '1' ) 27/03/2023 02:29: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 ( '82484' , '8368' , 'PREGHIERE DI LIBERAZIONE - DIVINA MISERICORDIA' , '2' , '2' , '4' , '1.50' , '1.5' , '0' , '30' , '2.1000' ) 27/03/2023 02:29:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8368' AND id_supplier = '47' 27/03/2023 02:29:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8368' , '47' , '1' ) 27/03/2023 02:29: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 ( '82484' , '20878' , 'PROCESSO A FRANCESCO - E. FORTUNATO' , '3' , '3' , '4' , '17.50' , '17.5' , '0' , '30' , '36.7500' ) 27/03/2023 02:29:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20878' AND id_supplier = '47' 27/03/2023 02:29:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20878' , '47' , '1' ) 27/03/2023 02:29: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 ( '82484' , '20880' , 'UN TEMPO PER DIO - J. PHILIPPE' , '2' , '2' , '4' , '10.00' , '10' , '0' , '30' , '14.0000' ) 27/03/2023 02:29:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20880' AND id_supplier = '47' 27/03/2023 02:29:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20880' , '47' , '1' ) 27/03/2023 02:29: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 ( '82484' , '20879' , 'SALITA DEL MONTE CARMELO - G. DELLA CROCE' , '1' , '1' , '4' , '18.00' , '18' , '0' , '30' , '12.6000' ) 27/03/2023 02:29:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20879' AND id_supplier = '47' 27/03/2023 02:29:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20879' , '47' , '1' ) 27/03/2023 03:08:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '554' AND id_document != '81412' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-17') 27/03/2023 03:08:51 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '554', document_date = '2023-02-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 = '145.00', price_tax_excluded = '125.72', date_upd = NOW() WHERE id_document = '81412' 27/03/2023 03:08:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81412' 27/03/2023 03:08:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '81412' 27/03/2023 03:08:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81412' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 27/03/2023 03:08:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81412' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '48.00' ) 27/03/2023 03:08:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81412' , '17710' , 'OSTIA MAGNA CM 14 - OM 140' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 27/03/2023 03:08:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81412' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '3.6000' , '3.4615384615385' , '4' , '0' , '7.20' ) 27/03/2023 03:08:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81412' , '8219' , 'PRATICA DI AMAR GESÙ CRISTO - 8464' , '1' , '-1' , '4' , '8.9' , '8.9' , '0' , '0' , '8.90' ) 27/03/2023 03:08:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81412' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '0' , '20.00' ) 27/03/2023 03:09:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '92' AND id_document != '78233' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-10') 27/03/2023 03:09:58 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '92', document_date = '2023-01-10', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '84.90', price_tax_excluded = '70.92', date_upd = NOW() WHERE id_document = '78233' 27/03/2023 03:09: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 = '78233' 27/03/2023 03:09:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '78233' 27/03/2023 03:09: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 ( '78233' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '1.90' ) 27/03/2023 03:09: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 ( '78233' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '4.00' ) 27/03/2023 03:09: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 ( '78233' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 27/03/2023 03:09: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 ( '78233' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 27/03/2023 03:09: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 ( '78233' , '13319' , 'VIVI LA VITA - 30' , '1' , '-1' , '1' , '0.1500' , '0.12295081967213' , '22' , '100' , '0.00' ) 27/03/2023 03:09: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 ( '78233' , '16710' , 'MESSAGGIO DI TENEREZZA - 17' , '1' , '-1' , '1' , '0.1500' , '0.12295081967213' , '22' , '100' , '0.00' ) 27/03/2023 03:09: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 ( '78233' , '795' , 'ASTUCCIO A 3 OLI SANTI IN ALLUMINIO - 1958' , '1' , '-1' , '1' , '73.0000' , '59.83606557377' , '22' , '0' , '73.00' ) 27/03/2023 03:10:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '382' AND id_document != '81181' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-02') 27/03/2023 03:10:14 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '382', document_date = '2023-02-02', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '22.10', price_tax_excluded = '18.11', date_upd = NOW() WHERE id_document = '81181' 27/03/2023 03:10:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81181' 27/03/2023 03:10:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '81181' 27/03/2023 03:10:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81181' , '18005' , 'MEDAGLIETTA CARLO ACUTIS' , '3' , '-3' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '3.60' ) 27/03/2023 03:10:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81181' , '18138' , 'PORTACHIAVI DECINA CROCE - S46' , '4' , '-4' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '12.00' ) 27/03/2023 03:10:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81181' , '13506' , 'SANTO ROSARIO' , '1' , '-1' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '0.30' ) 27/03/2023 03:10:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81181' , '6329' , 'MEDAGLIA OVALE DECORATA - LOURDES - G291-D' , '3' , '-3' , '1' , '0.8000' , '0.65573770491803' , '22' , '0' , '2.40' ) 27/03/2023 03:10:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81181' , '12463' , 'QUADRO CON MAGNETE FATIMA' , '1' , '-1' , '1' , '1.8000' , '1.4754098360656' , '22' , '0' , '1.80' ) 27/03/2023 03:10:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81181' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '2' , '1.6393442622951' , '22' , '0' , '2.00' ) 27/03/2023 03:10:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '413' AND id_document != '81228' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-04') 27/03/2023 03:10:32 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '413', document_date = '2023-02-04', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '10.70', price_tax_excluded = '8.77', date_upd = NOW() WHERE id_document = '81228' 27/03/2023 03:10:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81228' 27/03/2023 03:10:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '81228' 27/03/2023 03:10:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81228' , '10475' , 'TEALIGHTS X 50 ' , '1' , '-1' , '1' , '3.9000' , '3.1967213114754' , '22' , '0' , '3.90' ) 27/03/2023 03:10:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81228' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '3.3' , '2.7049180327869' , '22' , '0' , '3.30' ) 27/03/2023 03:10:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81228' , '6074' , 'MADONNA DI LOURDES - 120' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 27/03/2023 03:10:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '416' AND id_document != '81231' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-04') 27/03/2023 03:10:58 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '416', document_date = '2023-02-04', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '590.00', price_tax_excluded = '510.30', date_upd = NOW() WHERE id_document = '81231' 27/03/2023 03:10: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 = '81231' 27/03/2023 03:10:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '81231' 27/03/2023 03:10: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 ( '81231' , '16686' , 'EVANGELIARIO' , '1' , '-1' , '4' , '140.0000' , '140' , '0' , '5' , '133.00' ) 27/03/2023 03:10: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 ( '81231' , '14000' , 'GALATEO IN CHIESA' , '15' , '-15' , '4' , '1.0000' , '1' , '0' , '0' , '15.00' ) 27/03/2023 03:10: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 ( '81231' , '1041' , 'BENEDIZIONI' , '200' , '-200' , '1' , '0.1800' , '0.14754098360656' , '22' , '0' , '36.00' ) 27/03/2023 03:10: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 ( '81231' , '2722' , 'COPRI AMBONE FIGLIOL PRODIGO' , '1' , '-1' , '1' , '120.0000' , '98.360655737705' , '22' , '0' , '120.00' ) 27/03/2023 03:10: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 ( '81231' , '13928' , 'COPRILEGGIO - 315/TP' , '1' , '-1' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '65.00' ) 27/03/2023 03:10: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 ( '81231' , '14214' , 'CASULA IN POLIESTERE ' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 27/03/2023 03:10: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 ( '81231' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '10' , '-10' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '35.00' ) 27/03/2023 03:10: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 ( '81231' , '19607' , 'CLERGY F/F COTONE ML ' , '1' , '-1' , '1' , '31.0000' , '25.409836065574' , '22' , '0' , '31.00' ) 27/03/2023 03:10: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 ( '81231' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '85.0000' , '69.672131147541' , '22' , '0' , '85.00' ) 27/03/2023 03:11:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '449' AND id_document != '81274' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-08') 27/03/2023 03:11:44 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '449', document_date = '2023-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 = '89.85', price_tax_excluded = '80.92', date_upd = NOW() WHERE id_document = '81274' 27/03/2023 03:11:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81274' 27/03/2023 03:11:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '81274' 27/03/2023 03:11:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81274' , '5976' , 'LUCERNA VETRO - 1493' , '2' , '-2' , '1' , '19.5000' , '15.983606557377' , '22' , '0' , '39.00' ) 27/03/2023 03:11:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81274' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '1' , '-1' , '4' , '35.0000' , '35' , '0' , '0' , '35.00' ) 27/03/2023 03:11:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81274' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '2' , '-2' , '4' , '1.0000' , '1' , '0' , '0' , '2.00' ) 27/03/2023 03:11:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81274' , '20671' , 'QUARESIMA 2023' , '1' , '-1' , '4' , '3.3500' , '3.35' , '0' , '0' , '3.35' ) 27/03/2023 03:11:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81274' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '3' , '-3' , '1' , '3' , '2.4590163934426' , '22' , '0' , '9.00' ) 27/03/2023 03:11:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81274' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 27/03/2023 03:11:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81274' , '6339' , 'MEDAGLIA OVALE DORATA/SMALTINO' , '1' , '-1' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '0.50' ) 27/03/2023 03:12:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '486' AND id_document != '81322' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-10') 27/03/2023 03:12:34 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '486', document_date = '2023-02-10', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '19.50', price_tax_excluded = '15.98', date_upd = NOW() WHERE id_document = '81322' 27/03/2023 03:12: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 = '81322' 27/03/2023 03:12:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '81322' 27/03/2023 03:12: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 ( '81322' , '6339' , 'MEDAGLIA OVALE DORATA/SMALTINO' , '3' , '-3' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '1.50' ) 27/03/2023 03:12: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 ( '81322' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '6' , '-6' , '1' , '3' , '2.4590163934426' , '22' , '0' , '18.00' ) 27/03/2023 03:13:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '429' AND id_document != '81248' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-06') 27/03/2023 03:13:37 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '429', document_date = '2023-02-06', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '22.00', price_tax_excluded = '18.03', date_upd = NOW() WHERE id_document = '81248' 27/03/2023 03:13:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81248' 27/03/2023 03:13:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '81248' 27/03/2023 03:13:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81248' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '3' , '2.4590163934426' , '22' , '0' , '6.00' ) 27/03/2023 03:13:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81248' , '9133' , 'ROSARIO LEGNO ADDOLORATA - 01002 - 25' , '2' , '-2' , '1' , '8' , '6.5573770491803' , '22' , '0' , '16.00' ) 27/03/2023 03:15:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '537' AND id_document != '81382' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-15') 27/03/2023 03:15:24 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '537', document_date = '2023-02-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '60.00', price_tax_excluded = '49.18', date_upd = NOW() WHERE id_document = '81382' 27/03/2023 03:15: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 = '81382' 27/03/2023 03:15:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '81382' 27/03/2023 03:15: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 ( '81382' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '20' , '-20' , '1' , '3' , '2.4590163934426' , '22' , '0' , '60.00' ) 27/03/2023 03:15:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '495' AND id_document != '81331' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-11') 27/03/2023 03:15:48 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '495', document_date = '2023-02-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '3.10', price_tax_excluded = '2.54', date_upd = NOW() WHERE id_document = '81331' 27/03/2023 03:15:48 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 = '81331' 27/03/2023 03:15:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '81331' 27/03/2023 03:15:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81331' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '3.1' , '2.5409836065574' , '22' , '0' , '3.10' ) 27/03/2023 03:16:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '540' AND id_document != '81385' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-16') 27/03/2023 03:16:12 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '540', document_date = '2023-02-16', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '8.50', price_tax_excluded = '6.97', date_upd = NOW() WHERE id_document = '81385' 27/03/2023 03:16:12 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 = '81385' 27/03/2023 03:16:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '81385' 27/03/2023 03:16:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81385' , '16190' , 'VESTINA BATTESIMALE CANDELA/FONTE' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 27/03/2023 03:16:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81385' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 27/03/2023 03:17:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '521' AND id_document != '81364' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-15') 27/03/2023 03:17:03 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '521', document_date = '2023-02-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '139.40', price_tax_excluded = '118.53', date_upd = NOW() WHERE id_document = '81364' 27/03/2023 03:17:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81364' 27/03/2023 03:17:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '81364' 27/03/2023 03:17:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81364' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 27/03/2023 03:17:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81364' , '19101' , 'INCENSO C' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 27/03/2023 03:17:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81364' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '18' , '-18' , '1' , '3' , '2.4590163934426' , '22' , '0' , '54.00' ) 27/03/2023 03:17:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81364' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '8.00' ) 27/03/2023 03:17:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81364' , '20661' , 'LASCIATI AMARE - P. CURTAZ' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '5' , '3.80' ) 27/03/2023 03:17:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81364' , '15228' , 'AMORE CROCIFISSO - V. LOPANO' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 27/03/2023 03:17:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81364' , '20660' , 'QUARESIMA E PASQUA ' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.76' ) 27/03/2023 03:17:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81364' , '15610' , 'MAMMA E PAPA A CATECHISMO' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '5' , '7.51' ) 27/03/2023 03:18:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '536' AND id_document != '81381' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-15') 27/03/2023 03:18:24 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '536', document_date = '2023-02-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '50.00', price_tax_excluded = '40.98', date_upd = NOW() WHERE id_document = '81381' 27/03/2023 03:18: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 = '81381' 27/03/2023 03:18:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '81381' 27/03/2023 03:18: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 ( '81381' , '6339' , 'MEDAGLIA OVALE DORATA/SMALTINO' , '1' , '-1' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '0.50' ) 27/03/2023 03:18: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 ( '81381' , '1914' , 'CERA DELLA LITURGIA' , '11' , '-11' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '49.50' ) 27/03/2023 03:19:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '574' AND id_document != '81436' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-20') 27/03/2023 03:19:54 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '574', document_date = '2023-02-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '42.64', price_tax_excluded = '35.88', date_upd = NOW() WHERE id_document = '81436' 27/03/2023 03:19: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 = '81436' 27/03/2023 03:19:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '81436' 27/03/2023 03:19: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 ( '81436' , '20722' , 'SEMINATORI DI GIOIA' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 27/03/2023 03:19: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 ( '81436' , '20660' , 'QUARESIMA E PASQUA ' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.76' ) 27/03/2023 03:19: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 ( '81436' , '6339' , 'MEDAGLIA OVALE DORATA/SMALTINO' , '5' , '-5' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '4.00' ) 27/03/2023 03:19: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 ( '81436' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 27/03/2023 03:19: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 ( '81436' , '9223' , 'S. MICHELE - CM 15 - 023 SMK/15' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 27/03/2023 03:19: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 ( '81436' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '13.50' ) 27/03/2023 03:20:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '576' AND id_document != '81439' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-20') 27/03/2023 03:20:21 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '576', document_date = '2023-02-20', 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 = '50.00', price_tax_excluded = '40.98', date_upd = NOW() WHERE id_document = '81439' 27/03/2023 03:20:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81439' 27/03/2023 03:20:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '81439' 27/03/2023 03:20:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81439' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 27/03/2023 03:21:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '454' AND id_document != '81281' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-08') 27/03/2023 03:21:00 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '454', document_date = '2023-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 = '12.80', price_tax_excluded = '11.93', date_upd = NOW() WHERE id_document = '81281' 27/03/2023 03:21: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 = '81281' 27/03/2023 03:21:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '81281' 27/03/2023 03:21:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81281' , '2678' , 'CONOSCERE E ADORARE IL VOLTO SANTO' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 27/03/2023 03:21:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81281' , '15261' , 'MEDAGLIA SAN BENEDETTO' , '2' , '-2' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '3.00' ) 27/03/2023 03:21:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81281' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '9' , '-9' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '1.80' ) 27/03/2023 03:21:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '681' AND id_document != '82079' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-01') 27/03/2023 03:21:42 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '681', document_date = '2023-03-01', 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 = '170.00', price_tax_excluded = '139.34', date_upd = NOW() WHERE id_document = '82079' 27/03/2023 03:21: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 = '82079' 27/03/2023 03:21:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '82079' 27/03/2023 03:21: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 ( '82079' , '7914' , 'PERGAMENE - 1A COMUNIONE MOD. C' , '50' , '-50' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '15.00' ) 27/03/2023 03:21: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 ( '82079' , '10501' , 'TECA STANDARD IHS ' , '5' , '-5' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '125.00' ) 27/03/2023 03:21: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 ( '82079' , '2328' , 'CLERGY GRIGIO MM - COTONE 43 ' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 27/03/2023 04:08:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '987' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-27') 27/03/2023 04:08:29 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' , '987' , '2023-03-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.00' , '38.52' , NOW() , NOW() ) 27/03/2023 04:08:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82485' 27/03/2023 04:08:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '82485' 27/03/2023 04:08:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82485' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '47' , '38.524590163934' , '22' , '0' , '47.00' ) 27/03/2023 04:19:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '988' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-27') 27/03/2023 04:19:26 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' , '988' , '2023-03-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.60' , '5.41' , NOW() , NOW() ) 27/03/2023 04:19: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 = '82486' 27/03/2023 04:19:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '82486' 27/03/2023 04:19:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82486' , '15403' , 'CROCE IN RESINA CM 9 - 3806/G052' , '2' , '-2' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '6.60' ) 27/03/2023 04:21:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400300086' AND id_product != '15403' AND ean13 != '' 27/03/2023 04:21:15 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400300086', date_upd = NOW() WHERE id_product = '15403' 27/03/2023 04:21:15 pm >> UPDATE ps_product_lang SET name = 'CROCE IN RESINA CM 9 - 3806/G052', description = '' WHERE id_product = '15403' 27/03/2023 04:21:15 pm >> UPDATE ps_product SET wholesale_price = '1.40', on_sale = '0', price = '3.0327868852459017' WHERE id_product = '15403' 27/03/2023 04:21:15 pm >> UPDATE ps_product_shop SET wholesale_price = '1.40', price = '3.0327868852459017', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15403' 27/03/2023 04:21:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '15403' 27/03/2023 04:35:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '989' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-27') 27/03/2023 04:35:13 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' , '989' , '2023-03-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.00' , '27.05' , NOW() , NOW() ) 27/03/2023 04:35:13 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 = '82487' 27/03/2023 04:35:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '82487' 27/03/2023 04:35:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82487' , '15085' , 'BRACCIALE DECINA COLORATA - BC506' , '20' , '-20' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '24.00' ) 27/03/2023 04:35:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82487' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '18' , '-18' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '9.00' ) 27/03/2023 06:19:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '990' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-27') 27/03/2023 06:19:06 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '990' , '2023-03-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '10.66' , NOW() , NOW() ) 27/03/2023 06:19:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82488' 27/03/2023 06:19:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '82488' 27/03/2023 06:19:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82488' , '6402' , 'MENSA BIANCA 60X200 ' , '1' , '-1' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '6.50' ) 27/03/2023 06:19:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82488' , '9948' , 'SFERA DIAMETRO MM 100' , '1' , '-1' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '6.50' ) 27/03/2023 06:57:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '9' AND id_document != '81356' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-02-14') 27/03/2023 06:57:53 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '9', document_date = '2023-02-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2642', address1 = 'V.LE BACCHIGLIONE, 20 20139 MILANO', 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 = '161.30', price_tax_excluded = '161.30', date_upd = NOW() WHERE id_document = '81356' 27/03/2023 06:57:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81356' 27/03/2023 06:57:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '81356' 27/03/2023 06:57:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81356' , '17153' , 'SAN CHARBEL' , '1' , '-1' , '4' , '7.5000' , '7.5' , '0' , '0' , '7.50' ) 27/03/2023 06:57:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81356' , '13578' , 'GRANDE CROCIATA DELLAMORE - C. RIVAS' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 27/03/2023 06:57:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81356' , '15799' , 'PAROLE DI LUCE E VITA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 27/03/2023 06:57:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81356' , '4118' , 'FEDE INSEGNATA AI FIGLI - L. FANZAGA' , '1' , '-1' , '4' , '15.5000' , '15.5' , '0' , '0' , '15.50' ) 27/03/2023 06:57:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81356' , '19165' , 'MESSAGGIO TEOLOGICO DI GUADALUPE - S. ALDAY' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 27/03/2023 06:57:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81356' , '17968' , 'IO SONO LA MADRE DI GESU - M. STANZIONE' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 27/03/2023 06:57: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 ( '81356' , '3762' , 'ECCO TUA MADRE' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 27/03/2023 06:57: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 ( '81356' , '16266' , 'IPOTESI SU GESU - V. MESSORI' , '1' , '-1' , '4' , '16.8000' , '16.8' , '0' , '0' , '16.80' ) 27/03/2023 06:57: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 ( '81356' , '13941' , 'SANTO VOLTO' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 27/03/2023 06:57: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 ( '81356' , '9595' , 'SANTA RITA - 15 MEDITAZIONI' , '1' , '-1' , '4' , '7.5000' , '7.5' , '0' , '0' , '7.50' ) 27/03/2023 06:57: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 ( '81356' , '16400' , 'LODE QUOTIDIANA A MARIA' , '2' , '-2' , '4' , '6.0000' , '6' , '0' , '0' , '12.00' ) 27/03/2023 06:57: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 ( '81356' , '14545' , 'ROSARIO - M. DELBREL' , '2' , '-2' , '4' , '9.0000' , '9' , '0' , '0' , '18.00' ) 27/03/2023 06:57: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 ( '81356' , '17558' , 'IN SINU JESU' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 27/03/2023 06:57: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 ( '81356' , '16399' , 'CONCERTO DI NATALE - S. CONTI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 27/03/2023 06:57: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 ( '81356' , '14544' , 'DIVENTARE AMICI DELLO SPIRITO SANTO - R. CANTALAMESSA' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '0' , '4.00' ) 27/03/2023 06:58:31 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788885626034' AND id_product != '13653' AND ean13 != '' 27/03/2023 06:58:31 pm >> UPDATE ps_product SET id_supplier = '47', reference = '13/5', ean13 = '9788885626034', date_upd = NOW() WHERE id_product = '13653' 27/03/2023 06:58:31 pm >> UPDATE ps_product_lang SET name = 'LIBERACI DAL MALE - PREGHIERE DI LIBERAZIONE - VOL. 2', description = '' WHERE id_product = '13653' 27/03/2023 06:58:31 pm >> UPDATE ps_product SET wholesale_price = '7.80', on_sale = '0', price = '12.0000' WHERE id_product = '13653' 27/03/2023 06:58:31 pm >> UPDATE ps_product_shop SET wholesale_price = '7.80', price = '12.0000', id_tax_rules_group = '4', id_category_default = '420', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '13653' 27/03/2023 06:58:31 pm >> DELETE FROM ps_specific_price WHERE id_product = '13653' 27/03/2023 07:09:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '991' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-27') 27/03/2023 07:09:32 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '991' , '2023-03-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.50' , '24.50' , NOW() , NOW() ) 27/03/2023 07:09:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82489' 27/03/2023 07:09:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '82489' 27/03/2023 07:09:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82489' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '35' , '-35' , '4' , '0.70' , '0.7' , '0' , '0' , '24.50' ) 27/03/2023 07:11:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '992' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-27') 27/03/2023 07:11:28 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' , '992' , '2023-03-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '6.92' , NOW() , NOW() ) 27/03/2023 07:11:28 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 = '82490' 27/03/2023 07:11:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '82490' 27/03/2023 07:11:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82490' , '20520' , 'QUADRETTO ANGELO DI DIO - 5024-AD' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 27/03/2023 07:11:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82490' , '20578' , 'TOTUM AMORIS EST ' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 27/03/2023 07:16:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '993' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-27') 27/03/2023 07:16:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '993' , '2023-03-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.50' , '6.15' , NOW() , NOW() ) 27/03/2023 07:16:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82491' 27/03/2023 07:16:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '82491' 27/03/2023 07:16:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82491' , '5958' , 'LUCAS 25G - FIORI DARANCIO - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 27/03/2023 07:16:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82491' , '6304' , 'MATTHAEUS 25G - CINNAMONO - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 27/03/2023 07:16:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82491' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 27/03/2023 07:16:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82491' , '5473' , 'IOHANNES 25G - ROSA - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 27/03/2023 07:16:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82491' , '6207' , 'MARCUS 25G - MENTA - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' )