30/04/2024 08:35:31 am >> SELECT document_num FROM ps_document WHERE document_num = '71' AND id_document != '91220' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-04-11') 30/04/2024 08:35:31 am >> UPDATE ps_document SET id_document_type = '21', document_num = '71', document_date = '2024-04-11', document_letter = '', id_customer = '3980', id_supplier = '', id_address = '4677356', address1 = 'P. ZZA RISORGIMENTO 1 80047 S. GIUSEPPE VESUVIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '114.00', price_tax_excluded = '114.00', date_upd = NOW() WHERE id_document = '91220' 30/04/2024 08:35:31 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 = '91220' 30/04/2024 08:35:31 am >> DELETE FROM ps_document_detail WHERE id_document = '91220' 30/04/2024 08:35:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91220' , '15020' , 'PREGARE OGNI GIORNO' , '114' , '-114' , '4' , '1.00' , '1' , '0' , '0' , '114.00' ) 30/04/2024 08:36:12 am >> SELECT document_num FROM ps_document WHERE document_num = '73' AND id_document != '91280' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-04-16') 30/04/2024 08:36:12 am >> UPDATE ps_document SET id_document_type = '21', document_num = '73', document_date = '2024-04-16', document_letter = '', id_customer = '4100', id_supplier = '', id_address = '4679310', address1 = 'STRADA PROVINCIALE 12 n. 30 12060 BASTIA MONDOVI\\\'', address2 = '', note = '', price_shipping = '5.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '45.00', price_tax_excluded = '45.00', date_upd = NOW() WHERE id_document = '91280' 30/04/2024 08:36:12 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 = '91280' 30/04/2024 08:36:13 am >> DELETE FROM ps_document_detail WHERE id_document = '91280' 30/04/2024 08:36:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91280' , '15020' , 'PREGARE OGNI GIORNO' , '40' , '-40' , '4' , '1.00' , '1' , '0' , '0' , '40.00' ) 30/04/2024 09:08:11 am >> SELECT document_num FROM ps_document WHERE document_num = '1342' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-30') 30/04/2024 09:08:11 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' , '1342' , '2024-04-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '115.00' , '95.46' , NOW() , NOW() ) 30/04/2024 09:08:11 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 = '91505' 30/04/2024 09:08:11 am >> DELETE FROM ps_document_detail WHERE id_document = '91505' 30/04/2024 09:08:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91505' , '16289' , 'ANELLO IN ARG. - 6372' , '1' , '-1' , '1' , '108.35' , '88.811475409836' , '22' , '0' , '108.35' ) 30/04/2024 09:08:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91505' , '13771' , 'PREGHIERE A MARIA' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 30/04/2024 09:16:56 am >> SELECT document_num FROM ps_document WHERE document_num = '1343' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-30') 30/04/2024 09:16:56 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' , '1343' , '2024-04-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.40' , '9.02' , NOW() , NOW() ) 30/04/2024 09:16:56 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 = '91506' 30/04/2024 09:16:56 am >> DELETE FROM ps_document_detail WHERE id_document = '91506' 30/04/2024 09:16:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91506' , '11756' , 'VINO BIANCO SECCO - 14%' , '1' , '-1' , '1' , '6.90' , '5.655737704918' , '22' , '0' , '6.90' ) 30/04/2024 09:16:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91506' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 30/04/2024 09:24:12 am >> SELECT document_num FROM ps_document WHERE document_num = '81' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-05-02') 30/04/2024 09:24:12 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 ( '21' , '81' , '2024-05-02' , '' , '283' , '0' , '4673604' , 'VIA PALMIERI 84085 MERCATO SAN SEVERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '69.02' , '69.02' , NOW() , NOW() ) 30/04/2024 09:24:12 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 = '91507' 30/04/2024 09:24:12 am >> DELETE FROM ps_document_detail WHERE id_document = '91507' 30/04/2024 09:24:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91507' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '29' , '-29' , '4' , '2.80' , '2.8' , '0' , '15' , '69.02' ) 30/04/2024 10:03:44 am >> UPDATE ps_document SET id_document_type = '31', document_num = '110-2024', document_date = '2024-04-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2757', address1 = 'VIA A. POLENGHI, 97 26845 CODOGNO', address2 = '', note = '', price_shipping = '0.01', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '552.05', price_tax_excluded = '452.50', date_upd = NOW() WHERE id_document = '91373' 30/04/2024 10:03:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91373' 30/04/2024 10:03:44 am >> DELETE FROM ps_document_detail WHERE id_document = '91373' 30/04/2024 10:03:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91373' , '12824' , 'PIZZO MARIANO - P404' , '14' , '14' , '1' , '21.6500' , '17.745901639344' , '22' , '10' , '320.92' ) 30/04/2024 10:03:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91373' , '17533' , 'CINGOLO ORO/COL - CING06' , '5' , '5' , '1' , '7.9900' , '6.5491803278689' , '22' , '10' , '43.87' ) 30/04/2024 10:03:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91373' , '22433' , 'COPRI BOTTONE - 22178' , '2' , '2' , '1' , '8.5000' , '6.9672131147541' , '22' , '10' , '18.67' ) 30/04/2024 10:03:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91373' , '22434' , 'CORDONIERA CROCE PETTORALE - CORD-CP01' , '1' , '1' , '1' , '23.1000' , '18.934426229508' , '22' , '10' , '25.36' ) 30/04/2024 10:03:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91373' , '14114' , 'CINGOLO ORO - CING08ORO' , '2' , '2' , '1' , '13.8600' , '11.360655737705' , '22' , '10' , '30.44' ) 30/04/2024 10:03:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91373' , '15893' , 'CINGOLO - CING17' , '1' , '1' , '1' , '19.4600' , '15.950819672131' , '22' , '10' , '21.37' ) 30/04/2024 10:03:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91373' , '16456' , 'CINGOLO - CING03' , '5' , '5' , '1' , '6.3300' , '5.1885245901639' , '22' , '10' , '34.75' ) 30/04/2024 10:03:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91373' , '21447' , 'VELO TULLE ' , '2' , '2' , '1' , '25.8000' , '21.147540983607' , '22' , '10' , '56.66' ) 30/04/2024 10:05:59 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '330' , '2024-04-23' , '' , '0' , '163' , '4674530' , 'VIA CORTI 29 24126 BERGAMO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1662.86' , '1363.00' , NOW() , NOW() ) 30/04/2024 10:05:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91508' 30/04/2024 10:05:59 am >> DELETE FROM ps_document_detail WHERE id_document = '91508' 30/04/2024 10:05:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91508' , '22463' , 'CAMICE LEGGERO - 020/06' , '10' , '0' , '1' , '28.0000' , '22.9508' , '22' , '0' , '341.60' ) 30/04/2024 10:05:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '22463' AND id_supplier = '163' 30/04/2024 10:05:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22463' , '163' , '1' ) 30/04/2024 10:05:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91508' , '22464' , 'CASULA LEGGERA - 1212' , '4' , '0' , '1' , '61.0000' , '50' , '22' , '0' , '297.68' ) 30/04/2024 10:05:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '22464' AND id_supplier = '163' 30/04/2024 10:05:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22464' , '163' , '1' ) 30/04/2024 10:05:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91508' , '22465' , 'STOLA DIACONALE - 0779D' , '1' , '0' , '1' , '46.0000' , '37.7049' , '22' , '0' , '56.12' ) 30/04/2024 10:05:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '22465' AND id_supplier = '163' 30/04/2024 10:05:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22465' , '163' , '1' ) 30/04/2024 10:05:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91508' , '22466' , 'CASULA M LINO/BAMBOO - 1214' , '1' , '0' , '1' , '75.0000' , '61.4754' , '22' , '0' , '91.50' ) 30/04/2024 10:05:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '22466' AND id_supplier = '163' 30/04/2024 10:05:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22466' , '163' , '1' ) 30/04/2024 10:05:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91508' , '22467' , 'CAMICE MISTO LINO - 0771/06' , '2' , '0' , '1' , '106.0000' , '86.8852' , '22' , '0' , '258.64' ) 30/04/2024 10:05:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '22467' AND id_supplier = '163' 30/04/2024 10:05:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22467' , '163' , '1' ) 30/04/2024 10:05:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91508' , '22468' , 'CASULA MARIANA - 1211/LB' , '1' , '0' , '1' , '184.0000' , '150.8197' , '22' , '0' , '224.48' ) 30/04/2024 10:05:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '22468' AND id_supplier = '163' 30/04/2024 10:05:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22468' , '163' , '1' ) 30/04/2024 10:05:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91508' , '22469' , 'PIVIALE IHS - 220' , '1' , '0' , '1' , '133.0000' , '109.0164' , '22' , '0' , '162.26' ) 30/04/2024 10:05:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '22469' AND id_supplier = '163' 30/04/2024 10:05:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22469' , '163' , '1' ) 30/04/2024 10:05:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91508' , '19790' , 'STOLA IN MISTO LANA - 0779' , '1' , '0' , '1' , '42.0000' , '34.4262' , '22' , '0' , '51.24' ) 30/04/2024 10:06:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '19790' AND id_supplier = '163' 30/04/2024 10:06:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19790' , '163' , '1' ) 30/04/2024 10:06:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91508' , '19791' , 'STOLA IN LANA BALZA CON RICAMO - 661' , '1' , '0' , '1' , '42.0000' , '34.4262' , '22' , '0' , '51.24' ) 30/04/2024 10:06:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '19791' AND id_supplier = '163' 30/04/2024 10:06:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19791' , '163' , '1' ) 30/04/2024 10:06:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91508' , '22470' , 'COTTA - 989P/ML/2' , '1' , '0' , '1' , '105.0000' , '86.0656' , '22' , '0' , '128.10' ) 30/04/2024 10:06:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '22470' AND id_supplier = '163' 30/04/2024 10:06:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22470' , '163' , '1' ) 30/04/2024 10:06:20 am >> DELETE FROM ps_document WHERE id_document = '91508' 30/04/2024 10:06:20 am >> DELETE FROM ps_document_detail WHERE id_document = '91508' 30/04/2024 10:21:23 am >> SELECT document_num FROM ps_document WHERE document_num = '1344' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-30') 30/04/2024 10:21:23 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' , '1344' , '2024-04-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '330.00' , '270.49' , NOW() , NOW() ) 30/04/2024 10:21:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91509' 30/04/2024 10:21:23 am >> DELETE FROM ps_document_detail WHERE id_document = '91509' 30/04/2024 10:21:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91509' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '330' , '270.49180327869' , '22' , '0' , '330.00' ) 30/04/2024 10:34:48 am >> SELECT document_num FROM ps_document WHERE document_num = '1345' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-30') 30/04/2024 10:34:49 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1345' , '2024-04-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '94.81' , '84.28' , NOW() , NOW() ) 30/04/2024 10:34:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91510' 30/04/2024 10:34:49 am >> DELETE FROM ps_document_detail WHERE id_document = '91510' 30/04/2024 10:34:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91510' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '20' , '-20' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '14.00' ) 30/04/2024 10:34:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91510' , '22240' , 'PERGAMENE CRESIMA' , '40' , '-40' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '28.00' ) 30/04/2024 10:34:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91510' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '15' , '-15' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '7.50' ) 30/04/2024 10:34:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91510' , '22370' , 'DIGNITAS INFINITA' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 30/04/2024 10:34:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91510' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 30/04/2024 10:34:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91510' , '16689' , 'OSTIA PAN DI CENA mm80' , '6' , '-6' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '12.00' ) 30/04/2024 10:34:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91510' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '8.60' ) 30/04/2024 10:37:33 am >> SELECT document_num FROM ps_document WHERE document_num = '1346' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-30') 30/04/2024 10:37:33 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1346' , '2024-04-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '60.00' , NOW() , NOW() ) 30/04/2024 10:37: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 = '91511' 30/04/2024 10:37:33 am >> DELETE FROM ps_document_detail WHERE id_document = '91511' 30/04/2024 10:37: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 ( '91511' , '11151' , 'LIBRI' , '4' , '-4' , '4' , '15' , '15' , '0' , '0' , '60.00' ) 30/04/2024 10:39:39 am >> SELECT document_num FROM ps_document WHERE document_num = '1347' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-30') 30/04/2024 10:39:39 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' , '1347' , '2024-04-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '820.00' , '672.13' , NOW() , NOW() ) 30/04/2024 10:39:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91512' 30/04/2024 10:39:39 am >> DELETE FROM ps_document_detail WHERE id_document = '91512' 30/04/2024 10:39:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91512' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '250' , '204.91803278689' , '22' , '0' , '250.00' ) 30/04/2024 10:39:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91512' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '570' , '467.2131147541' , '22' , '0' , '570.00' ) 30/04/2024 10:47:47 am >> SELECT document_num FROM ps_document WHERE document_num = '1348' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-30') 30/04/2024 10:47:47 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1348' , '2024-04-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.50' , '6.15' , NOW() , NOW() ) 30/04/2024 10:47:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91513' 30/04/2024 10:47:47 am >> DELETE FROM ps_document_detail WHERE id_document = '91513' 30/04/2024 10:47:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91513' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 30/04/2024 10:47:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91513' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '1.10' ) 30/04/2024 10:47:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91513' , '3104' , 'CROCE SAN BENEDETTO - CARTONCINO' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 30/04/2024 10:59:52 am >> SELECT document_num FROM ps_document WHERE document_num = '1349' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-30') 30/04/2024 10:59:52 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1349' , '2024-04-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.00' , '49.00' , NOW() , NOW() ) 30/04/2024 10:59:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91514' 30/04/2024 10:59:52 am >> DELETE FROM ps_document_detail WHERE id_document = '91514' 30/04/2024 10:59:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91514' , '11151' , 'LIBRI' , '3' , '-3' , '4' , '10' , '10' , '0' , '0' , '30.00' ) 30/04/2024 10:59:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91514' , '13700' , 'PIENA DI GRAZIA - G. SACINO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 30/04/2024 10:59:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91514' , '21023' , 'SALVE REGINA - G. SACINO' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 30/04/2024 10:59:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91514' , '22487' , 'MESE DI MAGGIO GIORNO PER GIORNO' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 30/04/2024 11:20:19 am >> SELECT document_num FROM ps_document WHERE document_num = '1350' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-30') 30/04/2024 11:20:19 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' , '1350' , '2024-04-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 30/04/2024 11:20:19 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 = '91515' 30/04/2024 11:20:19 am >> DELETE FROM ps_document_detail WHERE id_document = '91515' 30/04/2024 11:20:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91515' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 30/04/2024 11:20:47 am >> SELECT document_num FROM ps_document WHERE document_num = '1351' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-30') 30/04/2024 11:20:47 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1351' , '2024-04-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 30/04/2024 11:20:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91516' 30/04/2024 11:20:47 am >> DELETE FROM ps_document_detail WHERE id_document = '91516' 30/04/2024 11:20:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91516' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 30/04/2024 11:21:52 am >> SELECT document_num FROM ps_document WHERE document_num = '1352' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-30') 30/04/2024 11:21:52 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1352' , '2024-04-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.20' , '13.64' , NOW() , NOW() ) 30/04/2024 11:21:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91517' 30/04/2024 11:21:52 am >> DELETE FROM ps_document_detail WHERE id_document = '91517' 30/04/2024 11:21:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91517' , '12040' , 'MEDAGLIA MIRACOLOSA GRANDE IN ARGENTO - M058' , '1' , '-1' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '13.50' ) 30/04/2024 11:21:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91517' , '9132' , 'DECINA LEGNO ACERO NATURALE - RG 021-10' , '1' , '-1' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '0.70' ) 30/04/2024 11:21:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91517' , '22368' , 'UN FIORETTO PER MARIA' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 30/04/2024 11:34:35 am >> SELECT document_num FROM ps_document WHERE document_num = '1/A' AND id_document != '89846' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-08') 30/04/2024 11:34:35 am >> UPDATE ps_document SET id_document_type = '24', document_num = '1/A', document_date = '2024-01-08', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '12.90', price_tax_excluded = '12.90', date_upd = NOW() WHERE id_document = '89846' 30/04/2024 11:34:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89846' 30/04/2024 11:34:35 am >> DELETE FROM ps_document_detail WHERE id_document = '89846' 30/04/2024 11:34:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22474' , 'PAROLA E PREGHIERA - LUG 2024' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 30/04/2024 11:34:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '19892' , 'SALVE, REGINA - S. HAHN' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 30/04/2024 11:44:29 am >> SELECT document_num FROM ps_document WHERE document_num = '1353' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-30') 30/04/2024 11:44:29 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1353' , '2024-04-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 30/04/2024 11:44:29 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91518' 30/04/2024 11:44:29 am >> DELETE FROM ps_document_detail WHERE id_document = '91518' 30/04/2024 11:44:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91518' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 30/04/2024 11:57:43 am >> SELECT document_num FROM ps_document WHERE document_num = '1354' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-30') 30/04/2024 11:57:43 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1354' , '2024-04-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '159.50' , '136.02' , NOW() , NOW() ) 30/04/2024 11: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 = '91519' 30/04/2024 11:57:43 am >> DELETE FROM ps_document_detail WHERE id_document = '91519' 30/04/2024 11: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 ( '91519' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '12.2' , '10' , '22' , '0' , '12.20' ) 30/04/2024 11: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 ( '91519' , '20245' , 'FORMELLA CROCIFISSO 25X30' , '2' , '-2' , '1' , '59.00' , '48.360655737705' , '22' , '0' , '118.00' ) 30/04/2024 11: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 ( '91519' , '10430' , 'TABOR' , '1' , '-1' , '4' , '17.90' , '17.9' , '0' , '0' , '17.90' ) 30/04/2024 11: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 ( '91519' , '21780' , 'FRATELLINO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 30/04/2024 12:18:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '1355' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-30') 30/04/2024 12:18:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1355' , '2024-04-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.05' , NOW() , NOW() ) 30/04/2024 12:18:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91520' 30/04/2024 12:18:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '91520' 30/04/2024 12:18:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91520' , '8645' , 'QUADRETTO SANTA RITA - 1269/s59' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 30/04/2024 12:45: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 ( '32' , '2024-FV000665' , '2024-04-30' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '6.5' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '382.89' , '382.89' , NOW() , NOW() ) 30/04/2024 12:45: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 = '91521' 30/04/2024 12:45:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '91521' 30/04/2024 12:45: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 ( '91521' , '22370' , 'DIGNITAS INFINITA' , '20' , '0' , '4' , '3.9000' , '3.9' , '0' , '45' , '42.90' ) 30/04/2024 12:45:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22370' AND id_supplier = '79' 30/04/2024 12:45:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22370' , '79' , '1' ) 30/04/2024 12:45:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91521' , '22406' , 'GESU CONFIDO IN TE' , '5' , '0' , '4' , '3.0000' , '3' , '0' , '45' , '8.25' ) 30/04/2024 12:45:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22406' AND id_supplier = '79' 30/04/2024 12:45:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22406' , '79' , '1' ) 30/04/2024 12:45:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91521' , '22111' , 'PREGARE OGGI' , '3' , '0' , '4' , '8.5000' , '8.5' , '0' , '45' , '14.03' ) 30/04/2024 12:45:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22111' AND id_supplier = '79' 30/04/2024 12:45:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22111' , '79' , '1' ) 30/04/2024 12:45:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91521' , '22191' , 'PREGARE CON I SALMI' , '3' , '0' , '4' , '8.5000' , '8.5' , '0' , '45' , '14.03' ) 30/04/2024 12:45:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22191' AND id_supplier = '79' 30/04/2024 12:45:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22191' , '79' , '1' ) 30/04/2024 12:45:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91521' , '22148' , 'DICHIARAZIONE FIDUCIA SUPPLICANS' , '5' , '0' , '4' , '2.80' , '2.8' , '0' , '45' , '7.7000' ) 30/04/2024 12:45:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22148' AND id_supplier = '79' 30/04/2024 12:45:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22148' , '79' , '1' ) 30/04/2024 12:45:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91521' , '3544' , 'DIRETTORIO OMILETICO' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '45' , '5.50' ) 30/04/2024 12:45:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3544' AND id_supplier = '79' 30/04/2024 12:45:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3544' , '79' , '1' ) 30/04/2024 12:45:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91521' , '22407' , 'CAMMINO DI SANTITA DI DON M. SOLOCKO' , '1' , '0' , '4' , '6.0000' , '6' , '0' , '45' , '3.30' ) 30/04/2024 12:45:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22407' AND id_supplier = '79' 30/04/2024 12:45:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22407' , '79' , '1' ) 30/04/2024 12:45:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91521' , '22149' , 'LEZIONARIO FERIALE TEMPI FORTI - N.E.' , '1' , '0' , '4' , '65.0000' , '65' , '0' , '35' , '42.25' ) 30/04/2024 12:45:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22149' AND id_supplier = '79' 30/04/2024 12:45:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22149' , '79' , '1' ) 30/04/2024 12:45:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91521' , '22111' , 'PREGARE OGGI' , '3' , '0' , '4' , '8.5000' , '8.5' , '0' , '45' , '14.03' ) 30/04/2024 12:45:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22111' AND id_supplier = '79' 30/04/2024 12:45:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22111' , '79' , '1' ) 30/04/2024 12:45:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91521' , '22191' , 'PREGARE CON I SALMI' , '2' , '0' , '4' , '8.5000' , '8.5' , '0' , '45' , '9.35' ) 30/04/2024 12:45:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22191' AND id_supplier = '79' 30/04/2024 12:45:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22191' , '79' , '1' ) 30/04/2024 12:45:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91521' , '22192' , 'PREGHIERA DI GESU' , '2' , '0' , '4' , '8.5000' , '8.5' , '0' , '45' , '9.35' ) 30/04/2024 12:45:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22192' AND id_supplier = '79' 30/04/2024 12:45:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22192' , '79' , '1' ) 30/04/2024 12:45:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91521' , '22446' , 'PREGARE CON SANTI E PECCATORI - 4' , '10' , '0' , '4' , '8.5000' , '8.5' , '0' , '45' , '46.75' ) 30/04/2024 12:45:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22446' AND id_supplier = '79' 30/04/2024 12:45:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22446' , '79' , '1' ) 30/04/2024 12:45:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91521' , '22445' , 'PARABOLE DELLA PREGHIERA - 5' , '10' , '0' , '4' , '8.5000' , '8.5' , '0' , '45' , '46.75' ) 30/04/2024 12:45:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22445' AND id_supplier = '79' 30/04/2024 12:45:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22445' , '79' , '1' ) 30/04/2024 12:45:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91521' , '22290' , 'CHIESA IN PREGHIERA - 6' , '4' , '0' , '4' , '8.5000' , '8.5' , '0' , '45' , '18.70' ) 30/04/2024 12:45:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22290' AND id_supplier = '79' 30/04/2024 12:45:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22290' , '79' , '1' ) 30/04/2024 12:45: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 ( '91521' , '22448' , 'PREGHIERA DI MARIA - 7' , '10' , '0' , '4' , '8.5000' , '8.5' , '0' , '45' , '46.75' ) 30/04/2024 12:45:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22448' AND id_supplier = '79' 30/04/2024 12:45:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22448' , '79' , '1' ) 30/04/2024 12:45: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 ( '91521' , '22449' , 'PREGHIERA CHE GESU CI HA INSEGNATO - 8' , '10' , '0' , '4' , '8.5000' , '8.5' , '0' , '45' , '46.75' ) 30/04/2024 12:45:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22449' AND id_supplier = '79' 30/04/2024 12:45:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22449' , '79' , '1' ) 30/04/2024 12:46:14 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '2024-DL001228', document_date = '2024-04-10', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2686', address1 = 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '95.06', price_tax_excluded = '95.06', date_upd = NOW() WHERE id_document = '91219' 30/04/2024 12:46: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 = '91219' 30/04/2024 12:46:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '91219' 30/04/2024 12:46: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 ( '91219' , '22406' , 'GESU CONFIDO IN TE' , '5' , '5' , '4' , '3.0000' , '3' , '0' , '45' , '8.25' ) 30/04/2024 12:46: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 ( '91219' , '22111' , 'PREGARE OGGI' , '3' , '3' , '4' , '8.5000' , '8.5' , '0' , '45' , '14.03' ) 30/04/2024 12:46: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 ( '91219' , '22191' , 'PREGARE CON I SALMI' , '3' , '3' , '4' , '8.5000' , '8.5' , '0' , '45' , '14.03' ) 30/04/2024 12:46: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 ( '91219' , '22148' , 'DICHIARAZIONE FIDUCIA SUPPLICANS' , '5' , '5' , '4' , '2.80' , '2.8' , '0' , '45' , '7.7000' ) 30/04/2024 12:46: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 ( '91219' , '3544' , 'DIRETTORIO OMILETICO' , '1' , '1' , '4' , '10.0000' , '10' , '0' , '45' , '5.50' ) 30/04/2024 12:46: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 ( '91219' , '22407' , 'CAMMINO DI SANTITA DI DON M. SOLOCKO' , '1' , '1' , '4' , '6.0000' , '6' , '0' , '45' , '3.30' ) 30/04/2024 12:46: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 ( '91219' , '22149' , 'LEZIONARIO FERIALE TEMPI FORTI - N.E.' , '1' , '1' , '4' , '65.0000' , '65' , '0' , '35' , '42.25' ) 30/04/2024 02:37:54 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400012941' AND id_product != '8645' AND ean13 != '' 30/04/2024 02:37:54 pm >> UPDATE ps_product SET id_supplier = '28', reference = '2016', ean13 = '8058400012941', date_upd = NOW() WHERE id_product = '8645' 30/04/2024 02:37:54 pm >> UPDATE ps_product_lang SET name = 'QUADRETTO SANTA RITA - 1269/S59', description = '' WHERE id_product = '8645' 30/04/2024 02:37:54 pm >> UPDATE ps_product SET wholesale_price = '0.78', on_sale = '0', price = '2.0492' WHERE id_product = '8645' 30/04/2024 02:37:54 pm >> UPDATE ps_product_shop SET wholesale_price = '0.78', price = '2.0492', 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 = '8645' 30/04/2024 02:37:54 pm >> DELETE FROM ps_specific_price WHERE id_product = '8645' 30/04/2024 02:38:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788807034367' AND id_product != '21780' AND ean13 != '' 30/04/2024 02:38:39 pm >> UPDATE ps_product SET id_supplier = '177', reference = 'GONDOLA 1', ean13 = '9788807034367', date_upd = NOW() WHERE id_product = '21780' 30/04/2024 02:38:39 pm >> UPDATE ps_product_lang SET name = 'FRATELLINO', description = '' WHERE id_product = '21780' 30/04/2024 02:38:39 pm >> UPDATE ps_product SET wholesale_price = '8.40', on_sale = '0', price = '12.0000' WHERE id_product = '21780' 30/04/2024 02:38:39 pm >> UPDATE ps_product_shop SET wholesale_price = '8.40', price = '12.0000', id_tax_rules_group = '4', id_category_default = '359', 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 = '21780' 30/04/2024 02:38:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '21780' 30/04/2024 04:03:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '1356' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-30') 30/04/2024 04:03:35 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1356' , '2024-04-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '125.00' , '102.46' , NOW() , NOW() ) 30/04/2024 04:03:35 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91522' 30/04/2024 04:03:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '91522' 30/04/2024 04:03:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91522' , '20062' , 'BRACCIALE DECINA - BD018' , '15' , '-15' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '30.00' ) 30/04/2024 04:03:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91522' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '95' , '77.868852459016' , '22' , '0' , '95.00' ) 30/04/2024 04:24:10 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'VA1' AND id_product != '13613' AND ean13 != '' 30/04/2024 04:24:10 pm >> UPDATE ps_product SET id_supplier = '50', reference = '', ean13 = 'VA1', date_upd = NOW() WHERE id_product = '13613' 30/04/2024 04:24:10 pm >> UPDATE ps_product_lang SET name = 'SCATOLA DECORATA VANGELO', description = '' WHERE id_product = '13613' 30/04/2024 04:24:10 pm >> UPDATE ps_product SET wholesale_price = '4.00', on_sale = '0', price = '9.01639344262295' WHERE id_product = '13613' 30/04/2024 04:24:10 pm >> UPDATE ps_product_shop SET wholesale_price = '4.00', price = '9.01639344262295', id_tax_rules_group = '1', id_category_default = '276', 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 = '13613' 30/04/2024 04:24:10 pm >> DELETE FROM ps_specific_price WHERE id_product = '13613' 30/04/2024 04:46:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '1357' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-30') 30/04/2024 04:46:50 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1357' , '2024-04-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 30/04/2024 04:46:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91523' 30/04/2024 04:46:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '91523' 30/04/2024 04:46:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91523' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 30/04/2024 05:07:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '1358' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-30') 30/04/2024 05:07:22 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1358' , '2024-04-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '91.15' , '84.69' , NOW() , NOW() ) 30/04/2024 05:07:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91524' 30/04/2024 05:07:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '91524' 30/04/2024 05:07:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91524' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '16' , '16' , '0' , '0' , '16.00' ) 30/04/2024 05:07:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91524' , '11178' , 'VENI CREATOR - 16 - OGGETTI' , '100' , '-100' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '15.00' ) 30/04/2024 05:07:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91524' , '11379' , 'VIENI SPIRITO SANTO - 35 ' , '38' , '-38' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '5.70' ) 30/04/2024 05:07:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91524' , '7202' , 'ARTICOLI RELIGIOSI' , '37' , '-37' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '5.55' ) 30/04/2024 05:07:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91524' , '22370' , 'DIGNITAS INFINITA' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 30/04/2024 05:07:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91524' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 30/04/2024 05:07:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91524' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 30/04/2024 05:19:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '1359' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-30') 30/04/2024 05:19:00 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1359' , '2024-04-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.10' , '17.10' , NOW() , NOW() ) 30/04/2024 05:19: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 = '91525' 30/04/2024 05:19:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '91525' 30/04/2024 05:19: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 ( '91525' , '22181' , 'MESSALINO QUOTIDIANO - MAG/GIU/LUG 2024' , '3' , '-3' , '4' , '6.00' , '6' , '0' , '5' , '17.10' ) 30/04/2024 05:23:34 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '18679' 30/04/2024 05:23:34 pm >> UPDATE ps_stock_available SET quantity = quantity + '-8' WHERE id_product = '18679' 30/04/2024 05:23:44 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '12133' 30/04/2024 05:23:44 pm >> UPDATE ps_stock_available SET quantity = quantity + '-6' WHERE id_product = '12133' 30/04/2024 05:23:55 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '765' 30/04/2024 05:23:55 pm >> UPDATE ps_stock_available SET quantity = quantity + '-13' WHERE id_product = '765' 30/04/2024 05:24:11 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '13714' 30/04/2024 05:24:11 pm >> UPDATE ps_stock_available SET quantity = quantity + '-3' WHERE id_product = '13714' 30/04/2024 05:24:44 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '4856' 30/04/2024 05:24:44 pm >> UPDATE ps_stock_available SET quantity = quantity + '-33' WHERE id_product = '4856' 30/04/2024 05:24:53 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '4996' 30/04/2024 05:24:53 pm >> UPDATE ps_stock_available SET quantity = quantity + '-10' WHERE id_product = '4996' 30/04/2024 05:25:02 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '5462' 30/04/2024 05:25:02 pm >> UPDATE ps_stock_available SET quantity = quantity + '-25' WHERE id_product = '5462' 30/04/2024 05:25:24 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '11379' 30/04/2024 05:25:24 pm >> UPDATE ps_stock_available SET quantity = quantity + '-10' WHERE id_product = '11379' 30/04/2024 05:25:48 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '11178' 30/04/2024 05:25:48 pm >> UPDATE ps_stock_available SET quantity = quantity + '5' WHERE id_product = '11178' 30/04/2024 05:30:34 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'K40fgJwT9MzwRCKa' , NOW() , NOW() ) 30/04/2024 05:30:34 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4105' , '1' ) 30/04/2024 05:30:34 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4105' , '2' ) 30/04/2024 05:30:34 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4105' , '3' ) 30/04/2024 05:32:15 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4105' 30/04/2024 05:32:15 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4105' , '10' , '200' , '' , 'VERNETTI' , 'ROSITA' , 'VIA CARMINE 5' , '' , '85025' , 'MELFI' , '' , '' , '3339900856' , '' , '' , NOW() , NOW() ) 30/04/2024 05:32:15 pm >> UPDATE ps_customer SET email = 'rosita.vernetti566.rv@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4105' 30/04/2024 05:32:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '82' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-04-30') 30/04/2024 05:32:58 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '82' , '2024-04-30' , '' , '4105' , '0' , '4679317' , 'VIA CARMINE 5 85025 MELFI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '61.42' , '61.42' , NOW() , NOW() ) 30/04/2024 05:32: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 = '91526' 30/04/2024 05:32:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '91526' 30/04/2024 05:32: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 ( '91526' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '22' , '-22' , '4' , '2.80' , '2.8' , '0' , '5' , '58.52' ) 30/04/2024 05:32: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 ( '91526' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 30/04/2024 05:33:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '82' AND id_document != '91526' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-05-02') 30/04/2024 05:33:48 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '82', document_date = '2024-05-02', document_letter = '', id_customer = '4105', id_supplier = '', id_address = '4679317', address1 = 'VIA CARMINE 5 85025 MELFI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '61.42', price_tax_excluded = '61.42', date_upd = NOW() WHERE id_document = '91526' 30/04/2024 05:33: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 = '91526' 30/04/2024 05:33:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '91526' 30/04/2024 05:33: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 ( '91526' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '22' , '-22' , '4' , '2.8000' , '2.8' , '0' , '5' , '58.52' ) 30/04/2024 05:33: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 ( '91526' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 30/04/2024 05:48:39 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' , '663226' , '2024-04-29' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '12' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '402.60' , '402.60' , NOW() , NOW() ) 30/04/2024 05:48:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91527' 30/04/2024 05:48:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '91527' 30/04/2024 05:48:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91527' , '17423' , 'CARLO ACUTIS' , '80' , '80' , '4' , '7.50' , '7.5' , '0' , '30+7' , '390.6000' ) 30/04/2024 05:48:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17423' AND id_supplier = '7' 30/04/2024 05:48:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17423' , '7' , '1' ) 30/04/2024 05:55:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '1360' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-30') 30/04/2024 05:55:59 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' , '1360' , '2024-04-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.90' , '3.90' , NOW() , NOW() ) 30/04/2024 05:55:59 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 = '91528' 30/04/2024 05:55:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '91528' 30/04/2024 05:55:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91528' , '22167' , 'AMEN - MAG. 2024' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 30/04/2024 05:59:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '30/A' AND id_document != '90601' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-04') 30/04/2024 05:59:19 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '30/A', document_date = '2024-03-04', document_letter = 'A', id_customer = '3812', id_supplier = '', id_address = '4678843', address1 = 'LARGO PLEBISCITO 12 84121 SALERNO ', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '452.90', price_tax_excluded = '381.85', date_upd = NOW() WHERE id_document = '90601' 30/04/2024 05:59: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 = '90601' 30/04/2024 05:59:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '90601' 30/04/2024 05:59: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 ( '90601' , '16051' , 'PISSIDE OFFERTORIALE CM 12X9 - 1894' , '1' , '-1' , '1' , '85.0000' , '69.672131147541' , '22' , '0' , '85.00' ) 30/04/2024 05:59: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 ( '90601' , '20428' , 'OSTIA TAGLIO CHIUSO 72MM - OTC25' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 30/04/2024 05:59: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 ( '90601' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '3' , '-3' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '12.90' ) 30/04/2024 05:59: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 ( '90601' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 30/04/2024 05:59: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 ( '90601' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 30/04/2024 05:59: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 ( '90601' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '5' , '-5' , '4' , '0.7000' , '0.7' , '0' , '0' , '3.50' ) 30/04/2024 05:59: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 ( '90601' , '17161' , 'CARBONCINI NERI - CARNE' , '2' , '-2' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '24.00' ) 30/04/2024 05:59: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 ( '90601' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '270.00' ) 30/04/2024 06:00:36 pm >> DELETE FROM ps_document WHERE id_document = '91359' 30/04/2024 06:00:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '91359' 30/04/2024 06:17:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '1361' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-30') 30/04/2024 06:17: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' , '1361' , '2024-04-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.60' , '12.79' , NOW() , NOW() ) 30/04/2024 06:17: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 = '91529' 30/04/2024 06:17:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '91529' 30/04/2024 06:17: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 ( '91529' , '15085' , 'BRACCIALE DECINA COLORATA - BC506' , '13' , '-13' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '15.60' ) 30/04/2024 06:37:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '1278' AND id_document != '91426' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-24') 30/04/2024 06:37:50 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1278', document_date = '2024-04-24', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '20.00', price_tax_excluded = '16.39', date_upd = NOW() WHERE id_document = '91426' 30/04/2024 06:37:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91426' 30/04/2024 06:37:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '91426' 30/04/2024 06:37:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91426' , '22154' , 'STATUA MEDAGLIA MIRACOLOSA - ST312MIR' , '1' , '-1' , '1' , '19.0000' , '15.573770491803' , '22' , '0' , '19.00' ) 30/04/2024 06:37:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91426' , '15085' , 'BRACCIALE DECINA COLORATA - BC506' , '1' , '-1' , '1' , '1' , '0.81967213114754' , '22' , '0' , '1.00' ) 30/04/2024 06:38:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '1291' AND id_document != '91441' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-26') 30/04/2024 06:38:05 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1291', document_date = '2024-04-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '4.80', price_tax_excluded = '3.93', date_upd = NOW() WHERE id_document = '91441' 30/04/2024 06:38:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91441' 30/04/2024 06:38:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '91441' 30/04/2024 06:38:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91441' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.4' , '1.9672131147541' , '22' , '0' , '2.40' ) 30/04/2024 06:38:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91441' , '15085' , 'BRACCIALE DECINA COLORATA - BC506' , '2' , '-2' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '2.40' ) 30/04/2024 06:54:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '1362' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-30') 30/04/2024 06:54:38 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' , '1362' , '2024-04-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 30/04/2024 06:54:38 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 = '91530' 30/04/2024 06:54:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '91530' 30/04/2024 06:54:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91530' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 30/04/2024 07:22:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '1363' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-30') 30/04/2024 07:22:31 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' , '1363' , '2024-04-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '6.56' , NOW() , NOW() ) 30/04/2024 07:22: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 = '91531' 30/04/2024 07:22:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '91531' 30/04/2024 07:22: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 ( '91531' , '8934' , 'RICAMBIO AMPOLLA X ART 501/5 CON MAGNETE - 70' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' )