07/08/2023 08:10:20 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'Ma65i6siI4J1y07Y' , NOW() , NOW() ) 07/08/2023 08:10:20 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7060' , '1' ) 07/08/2023 08:10:20 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7060' , '2' ) 07/08/2023 08:10:20 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7060' , '3' ) 07/08/2023 08:11:43 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7060' 07/08/2023 08:11:43 am >> 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 ( '7060' , '10' , '128' , '' , 'SERVIDEI' , 'DON MAURO' , 'VIA DEGLI STUDI 5' , '' , '63079' , 'COLLI DEL TRONTO' , '' , '' , '' , '' , '' , NOW() , NOW() ) 07/08/2023 08:11:43 am >> UPDATE ps_customer SET email = 'psantafelicita@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7060' 07/08/2023 08:12:15 am >> SELECT document_num FROM ps_document WHERE document_num = '47' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-08-07') 07/08/2023 08:12:15 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' , '47' , '2023-08-07' , '' , '7060' , '0' , '144688383' , 'VIA DEGLI STUDI 5 63079 COLLI DEL TRONTO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '18.00' , '18.00' , NOW() , NOW() ) 07/08/2023 08:12:15 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 = '12133' 07/08/2023 08:12:15 am >> DELETE FROM ps_document_detail WHERE id_document = '12133' 07/08/2023 08:12:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '12133' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 07/08/2023 08:22:15 am >> SELECT document_num FROM ps_document WHERE document_num = '108' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-08-07') 07/08/2023 08:22:15 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' , '108' , '2023-08-07' , '' , '351' , '0' , '4673707' , 'VIA MASSARENTI, 418 40138 BOLOGNA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '104.50' , '104.50' , NOW() , NOW() ) 07/08/2023 08:22:15 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 = '86986' 07/08/2023 08:22:15 am >> DELETE FROM ps_document_detail WHERE id_document = '86986' 07/08/2023 08:22:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86986' , '7912' , 'PERGAMENE - 1A COMUNIONE MOD. C' , '50' , '-50' , '0' , '0.70' , '0.7' , '' , '5' , '33.25' ) 07/08/2023 08:22:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86986' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '50' , '-50' , '0' , '0.50' , '0.5' , '' , '5' , '23.75' ) 07/08/2023 08:22:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86986' , '7928' , 'PERGAMENE - BATTESIMO MOD. C' , '50' , '-50' , '0' , '0.50' , '0.5' , '' , '5' , '23.75' ) 07/08/2023 08:22:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86986' , '7922' , 'PERGAMENE - ANNIVERSARIO MATRIM. MOD. B' , '50' , '-50' , '0' , '0.50' , '0.5' , '' , '5' , '23.75' ) 07/08/2023 08:48:04 am >> SELECT document_num FROM ps_document WHERE document_num = '86/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-08-07') 07/08/2023 08:48:04 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '86/A' , '2023-08-07' , 'A' , '3550' , '0' , '4671016' , 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '123.00' , '123.00' , NOW() , NOW() ) 07/08/2023 08:48:04 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86987' 07/08/2023 08:48:04 am >> DELETE FROM ps_document_detail WHERE id_document = '86987' 07/08/2023 08:48:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86987' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '12' , '-12' , '0' , '6.00' , '6' , '' , '0' , '72.00' ) 07/08/2023 08:48:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86987' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '0' , '8.50' , '8.5' , '' , '0' , '51.00' ) 07/08/2023 09:18:24 am >> SELECT document_num FROM ps_document WHERE document_num = '2141' AND id_document != '86449' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-21') 07/08/2023 09:18:24 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2141', document_date = '2023-06-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '130.00', price_tax_excluded = '106.56', date_upd = NOW() WHERE id_document = '86449' 07/08/2023 09:18:24 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 = '86449' 07/08/2023 09:18:24 am >> DELETE FROM ps_document_detail WHERE id_document = '86449' 07/08/2023 09:18:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86449' , '2097' , 'CIPOLLINA MANGIAFUMO - 1057' , '3' , '-3' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '18.00' ) 07/08/2023 09:18:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86449' , '13751' , 'TUNICA SVASATA AVORIO - 191 TPA' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 07/08/2023 09:18:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86449' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '12' , '-12' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '72.00' ) 07/08/2023 09:18:50 am >> SELECT document_num FROM ps_document WHERE document_num = '2097' AND id_document != '86401' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-17') 07/08/2023 09:18:50 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2097', document_date = '2023-06-17', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '55.00', price_tax_excluded = '45.08', date_upd = NOW() WHERE id_document = '86401' 07/08/2023 09:18:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86401' 07/08/2023 09:18:50 am >> DELETE FROM ps_document_detail WHERE id_document = '86401' 07/08/2023 09:18:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86401' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '7' , '5.7377049180328' , '22' , '0' , '7.00' ) 07/08/2023 09:18:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86401' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8' , '6.5573770491803' , '22' , '0' , '48.00' ) 07/08/2023 09:29:59 am >> SELECT document_num FROM ps_document WHERE document_num = '2569' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-07') 07/08/2023 09:29: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 ( '11' , '2569' , '2023-08-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '10.58' , NOW() , NOW() ) 07/08/2023 09:29: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 = '86988' 07/08/2023 09:29:59 am >> DELETE FROM ps_document_detail WHERE id_document = '86988' 07/08/2023 09:29: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 ( '86988' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 07/08/2023 09:29: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 ( '86988' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 07/08/2023 09:37:51 am >> SELECT document_num FROM ps_document WHERE document_num = '2570' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-07') 07/08/2023 09:37:51 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' , '2570' , '2023-08-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.30' , '6.06' , NOW() , NOW() ) 07/08/2023 09:37:51 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 = '86989' 07/08/2023 09:37:51 am >> DELETE FROM ps_document_detail WHERE id_document = '86989' 07/08/2023 09:37:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86989' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 07/08/2023 09:37:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86989' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 07/08/2023 09:59:53 am >> SELECT document_num FROM ps_document WHERE document_num = '2571' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-07') 07/08/2023 09:59:53 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' , '2571' , '2023-08-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '102.00' , '93.89' , NOW() , NOW() ) 07/08/2023 09:59:53 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 = '86990' 07/08/2023 09:59:53 am >> DELETE FROM ps_document_detail WHERE id_document = '86990' 07/08/2023 09:59:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86990' , '409' , 'ALLA TUA LUCE SIGNORE, VEDIAMO LA LUCE - G. MARINI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 07/08/2023 09:59:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86990' , '21405' , 'CUSTODIRO LA TUA PAROLA - G. MARINI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 07/08/2023 09:59:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86990' , '19032' , 'MIA LINGUA CANTI LE TUE LODI - FERIALE - G. MARINI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 07/08/2023 09:59:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86990' , '17596' , 'FAMMI VIVERE SECONDO LA TUA PAROLA - G. MARINI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 07/08/2023 09:59:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86990' , '12065' , 'COPPIA BOTTIGLIE A/V CORAZZATE - 847' , '1' , '-1' , '1' , '45.00' , '36.885245901639' , '22' , '0' , '45.00' ) 07/08/2023 10:05:03 am >> SELECT document_num FROM ps_document WHERE document_num = '2572' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-07') 07/08/2023 10:05:03 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2572' , '2023-08-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '12.82' , NOW() , NOW() ) 07/08/2023 10:05:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86991' 07/08/2023 10:05:03 am >> DELETE FROM ps_document_detail WHERE id_document = '86991' 07/08/2023 10:05:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86991' , '1331' , 'BRACCIALE LEGNO BICOLORE - 034CYB499' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 07/08/2023 10:05:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86991' , '17385' , 'UNA STELLA DI NOME CARLO - B. BAFFETTI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 07/08/2023 10:14:57 am >> SELECT document_num FROM ps_document WHERE document_num = '53/A' AND id_document != '82763' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-12') 07/08/2023 10:14:57 am >> UPDATE ps_document SET id_document_type = '24', document_num = '53/A', document_date = '2023-04-12', document_letter = 'A', id_customer = '357', id_supplier = '', id_address = '4676034', address1 = 'VIA TORRIONE 84100 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 = '152.44', price_tax_excluded = '147.93', date_upd = NOW() WHERE id_document = '82763' 07/08/2023 10:14:57 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 = '82763' 07/08/2023 10:14:57 am >> DELETE FROM ps_document_detail WHERE id_document = '82763' 07/08/2023 10:14:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82763' , '13322' , 'IMMAGINI 70X100 GESU\' MISERICORDIOSO' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 07/08/2023 10:14:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82763' , '19742' , 'ENCICLICHE SOCIALI' , '1' , '-1' , '4' , '49.0000' , '49' , '0' , '5' , '46.55' ) 07/08/2023 10:14:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82763' , '3978' , 'EUCARISTIA: RITO E VITA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 07/08/2023 10:14:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82763' , '3419' , 'DIARIO LA MISERICORDIA DIVINA - S. FAUSTINA K.' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '5' , '12.35' ) 07/08/2023 10:14:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82763' , '18047' , 'CUSTODIA LITURGIA DELLE ORE 4 VOL ECO PELLE - L100E' , '1' , '-1' , '1' , '19.0000' , '15.573770491803' , '22' , '0' , '19.00' ) 07/08/2023 10:14:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82763' , '21166' , 'ENCICLICHE SOCIALI ' , '1' , '-1' , '4' , '26.0000' , '26' , '0' , '5' , '24.70' ) 07/08/2023 10:14:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82763' , '13780' , 'RISCOPRIAMO LA BELLEZZA DEL BATTESIMO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 07/08/2023 10:14:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82763' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '15' , '5.10' ) 07/08/2023 10:14:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82763' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 07/08/2023 10:14:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82763' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 07/08/2023 10:14:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82763' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 07/08/2023 10:14:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82763' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '1' , '-1' , '4' , '3.40' , '3.4' , '0' , '15' , '2.89' ) 07/08/2023 10:14:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82763' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '15' , '2.98' ) 07/08/2023 10:14:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82763' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '1' , '-1' , '4' , '3.40' , '3.4' , '0' , '15' , '2.89' ) 07/08/2023 10:14:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82763' , '2679' , 'CONOSCERE GESU' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '15' , '2.98' ) 07/08/2023 10:23:19 am >> SELECT document_num FROM ps_document WHERE document_num = '2573' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-07') 07/08/2023 10:23: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' , '2573' , '2023-08-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 07/08/2023 10:23: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 = '86992' 07/08/2023 10:23:19 am >> DELETE FROM ps_document_detail WHERE id_document = '86992' 07/08/2023 10:23:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86992' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 07/08/2023 10:42:52 am >> SELECT document_num FROM ps_document WHERE document_num = '2574' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-07') 07/08/2023 10:42:53 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' , '2574' , '2023-08-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.25' , '14.25' , NOW() , NOW() ) 07/08/2023 10:42:53 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 = '86993' 07/08/2023 10:42:53 am >> DELETE FROM ps_document_detail WHERE id_document = '86993' 07/08/2023 10:42:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86993' , '21192' , 'SULLA TUA PAROLA - SET/OTT 23' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '5' , '14.25' ) 07/08/2023 11:29:51 am >> SELECT document_num FROM ps_document WHERE document_num = '86/A' AND id_document != '86987' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-08-07') 07/08/2023 11:29:51 am >> UPDATE ps_document SET id_document_type = '24', document_num = '86/A', document_date = '2023-08-07', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '123.00', price_tax_excluded = '123.00', date_upd = NOW() WHERE id_document = '86987' 07/08/2023 11:29:51 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 = '86987' 07/08/2023 11:29:51 am >> DELETE FROM ps_document_detail WHERE id_document = '86987' 07/08/2023 11:29:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86987' , '1912' , 'CERA DELL\'EREMO - 415/B ****' , '12' , '-12' , '0' , '6.0000' , '6' , '' , '0' , '72.00' ) 07/08/2023 11:29:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86987' , '11384' , 'VINO BIANCO DOLCE - 102***' , '6' , '-6' , '0' , '8.5000' , '8.5' , '' , '0' , '51.00' ) 07/08/2023 11:35:14 am >> SELECT document_num FROM ps_document WHERE document_num = '86/A' AND id_document != '86987' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-08-07') 07/08/2023 11:35:14 am >> UPDATE ps_document SET id_document_type = '24', document_num = '86/A', document_date = '2023-08-07', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '150.50', price_tax_excluded = '150.50', date_upd = NOW() WHERE id_document = '86987' 07/08/2023 11:35:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86987' 07/08/2023 11:35:14 am >> DELETE FROM ps_document_detail WHERE id_document = '86987' 07/08/2023 11:35:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86987' , '1912' , 'CERA DELL\'EREMO - 415/B ****' , '12' , '-12' , '0' , '6.0000' , '6' , '0' , '0' , '72.00' ) 07/08/2023 11:35:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86987' , '11384' , 'VINO BIANCO DOLCE - 102***' , '6' , '-6' , '0' , '8.5000' , '8.5' , '0' , '0' , '51.00' ) 07/08/2023 11:35:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86987' , '7311' , 'OSTIA SOTTILE 74MM' , '12' , '-12' , '0' , '2.00' , '2' , '' , '0' , '24.00' ) 07/08/2023 11:35:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86987' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '0' , '3.50' , '3.5' , '' , '0' , '3.50' ) 07/08/2023 11:35:59 am >> SELECT document_num FROM ps_document WHERE document_num = '86/A' AND id_document != '86987' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-08-07') 07/08/2023 11:35:59 am >> UPDATE ps_document SET id_document_type = '24', document_num = '86/A', document_date = '2023-08-07', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '153.70', price_tax_excluded = '153.70', date_upd = NOW() WHERE id_document = '86987' 07/08/2023 11:35: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 = '86987' 07/08/2023 11:35:59 am >> DELETE FROM ps_document_detail WHERE id_document = '86987' 07/08/2023 11:35: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 ( '86987' , '1912' , 'CERA DELL\'EREMO - 415/B ****' , '12' , '-12' , '0' , '6.0000' , '6' , '0' , '0' , '72.00' ) 07/08/2023 11:35: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 ( '86987' , '11384' , 'VINO BIANCO DOLCE - 102***' , '6' , '-6' , '0' , '8.5000' , '8.5' , '0' , '0' , '51.00' ) 07/08/2023 11:35: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 ( '86987' , '7311' , 'OSTIA SOTTILE 74MM' , '12' , '-12' , '0' , '2.0000' , '2' , '0' , '0' , '24.00' ) 07/08/2023 11:35: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 ( '86987' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '0' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 07/08/2023 11:35: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 ( '86987' , '564' , 'GIGLER COMPLETO PER ART. 534/536/537 - 249' , '1' , '-1' , '0' , '3.20' , '3.2' , '' , '0' , '3.20' ) 07/08/2023 11:37:44 am >> SELECT document_num FROM ps_document WHERE document_num = '2575' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-07') 07/08/2023 11:37:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2575' , '2023-08-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '8.00' , NOW() , NOW() ) 07/08/2023 11:37: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 = '86994' 07/08/2023 11:37:44 am >> DELETE FROM ps_document_detail WHERE id_document = '86994' 07/08/2023 11:37: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 ( '86994' , '21416' , 'MESSA MEDITAZIONE - SET/OTT 2023' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '' , '8.00' ) 07/08/2023 11:41:33 am >> SELECT document_num FROM ps_document WHERE document_num = '86/A' AND id_document != '86987' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-08-07') 07/08/2023 11:41:33 am >> UPDATE ps_document SET id_document_type = '24', document_num = '86/A', document_date = '2023-08-07', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '153.70', price_tax_excluded = '153.70', date_upd = NOW() WHERE id_document = '86987' 07/08/2023 11:41: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 = '86987' 07/08/2023 11:41:33 am >> DELETE FROM ps_document_detail WHERE id_document = '86987' 07/08/2023 11:41: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 ( '86987' , '1912' , 'CERA DELL\'EREMO - 415/B ****' , '12' , '-12' , '0' , '6.0000' , '6' , '0' , '0' , '72.00' ) 07/08/2023 11:41:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86987' , '11384' , 'VINO BIANCO DOLCE - 102***' , '6' , '-6' , '0' , '8.5000' , '8.5' , '0' , '0' , '51.00' ) 07/08/2023 11:41:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86987' , '7311' , 'OSTIA SOTTILE 74MM' , '12' , '-12' , '0' , '2.0000' , '2' , '0' , '0' , '24.00' ) 07/08/2023 11:41:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86987' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '0' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 07/08/2023 11:41:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86987' , '564' , 'GIGLER COMPLETO PER ART. 534/536/537 - 249' , '1' , '-1' , '0' , '3.2000' , '3.2' , '0' , '0' , '3.20' ) 07/08/2023 11:41:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86987' , '' , 'LIBRI' , '500' , '-500' , '0' , '0' , '0' , '' , '0' , '0.00' ) 07/08/2023 11:41:56 am >> SELECT document_num FROM ps_document WHERE document_num = '86/A' AND id_document != '86987' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-08-07') 07/08/2023 11:41:56 am >> UPDATE ps_document SET id_document_type = '24', document_num = '86/A', document_date = '2023-08-07', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '153.70', price_tax_excluded = '153.70', date_upd = NOW() WHERE id_document = '86987' 07/08/2023 11:41: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 = '86987' 07/08/2023 11:41:56 am >> DELETE FROM ps_document_detail WHERE id_document = '86987' 07/08/2023 11:41:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86987' , '1912' , 'CERA DELL\'EREMO - 415/B ****' , '12' , '-12' , '0' , '6.0000' , '6' , '0' , '0' , '72.00' ) 07/08/2023 11:41:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86987' , '11384' , 'VINO BIANCO DOLCE - 102***' , '6' , '-6' , '0' , '8.5000' , '8.5' , '0' , '0' , '51.00' ) 07/08/2023 11:41:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86987' , '7311' , 'OSTIA SOTTILE 74MM' , '12' , '-12' , '0' , '2.0000' , '2' , '0' , '0' , '24.00' ) 07/08/2023 11:41:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86987' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '0' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 07/08/2023 11:41:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86987' , '564' , 'GIGLER COMPLETO PER ART. 534/536/537 - 249' , '1' , '-1' , '0' , '3.2000' , '3.2' , '0' , '0' , '3.20' ) 07/08/2023 11:48:20 am >> SELECT document_num FROM ps_document WHERE document_num = '40' AND id_document != '82122' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-03-03') 07/08/2023 11:48:20 am >> UPDATE ps_document SET id_document_type = '21', document_num = '40', document_date = '2023-03-03', document_letter = '', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '27.07', price_tax_excluded = '27.07', date_upd = NOW() WHERE id_document = '82122' 07/08/2023 11:48:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82122' 07/08/2023 11:48:21 am >> DELETE FROM ps_document_detail WHERE id_document = '82122' 07/08/2023 11:48:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82122' , '16094' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS' , '10' , '-10' , '4' , '2.0000' , '2' , '0' , '5' , '19.00' ) 07/08/2023 11:48:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82122' , '5251' , 'INCONTRI EUCARISTICI' , '2' , '-2' , '4' , '4.0350' , '4.035' , '0' , '' , '8.07' ) 07/08/2023 12:00:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '2576' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-07') 07/08/2023 12:00:14 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2576' , '2023-08-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.50' , '48.33' , NOW() , NOW() ) 07/08/2023 12:00: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 = '86995' 07/08/2023 12:00:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '86995' 07/08/2023 12:00: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 ( '86995' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 07/08/2023 12:00: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 ( '86995' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 07/08/2023 12:00: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 ( '86995' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 07/08/2023 12:00: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 ( '86995' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 07/08/2023 12:00: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 ( '86995' , '16818' , 'INCENSO ' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 07/08/2023 12:07:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '2577' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-07') 07/08/2023 12:07: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' , '2577' , '2023-08-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '96.00' , '82.45' , NOW() , NOW() ) 07/08/2023 12:07: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 = '86996' 07/08/2023 12:07:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '86996' 07/08/2023 12:07: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 ( '86996' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '15.00' ) 07/08/2023 12:07: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 ( '86996' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 07/08/2023 12:07: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 ( '86996' , '17710' , 'OSTIA MAGNA CM 14 - OM 140' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 07/08/2023 12:07: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 ( '86996' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 07/08/2023 12:07: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 ( '86996' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 07/08/2023 12:07: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 ( '86996' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 07/08/2023 12:07: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 ( '86996' , '20154' , 'QUADRETTO CULLA ANGELO DI DIO ROSA - 5510SC' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 07/08/2023 12:07: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 ( '86996' , '11152' , 'VARIE - OSTIE - PARTICOLE' , '1' , '-1' , '3' , '2.5' , '2.4038461538462' , '4' , '0' , '2.50' ) 07/08/2023 12:07: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 ( '86996' , '15089' , 'QUADRETTO EFFETTO PIETRA - SACRA FAMIGLIA - 2950' , '1' , '-1' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '6.50' ) 07/08/2023 12:07:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '2578' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-07') 07/08/2023 12:07:57 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2578' , '2023-08-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.00' , '25.00' , NOW() , NOW() ) 07/08/2023 12:07:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86997' 07/08/2023 12:07:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '86997' 07/08/2023 12:07: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 ( '86997' , '5762' , 'LEZIONARIO E RITO DEL MATRIMONIO - KIT 2 VOL.' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '0' , '25.00' ) 07/08/2023 12:26:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '2579' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-07') 07/08/2023 12:26:55 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' , '2579' , '2023-08-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '390.00' , '319.67' , NOW() , NOW() ) 07/08/2023 12:26:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86998' 07/08/2023 12:26:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '86998' 07/08/2023 12:26:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86998' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '2' , '-2' , '1' , '55' , '45.081967213115' , '22' , '0' , '110.00' ) 07/08/2023 12:26:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86998' , '17544' , 'CAMICE BAMBOO' , '1' , '-1' , '1' , '140' , '114.75409836066' , '22' , '0' , '140.00' ) 07/08/2023 12:26:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86998' , '14354' , 'CAMICE BENEDETTINO LINO - 3010' , '1' , '-1' , '1' , '140' , '114.75409836066' , '22' , '0' , '140.00' ) 07/08/2023 12:31:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '2580' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-07') 07/08/2023 12:31:56 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2580' , '2023-08-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '180.00' , '147.54' , NOW() , NOW() ) 07/08/2023 12:31:56 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86999' 07/08/2023 12:31:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '86999' 07/08/2023 12:31:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86999' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '180' , '147.54098360656' , '22' , '0' , '180.00' ) 07/08/2023 12:54:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '1742' AND id_document != '84428' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-19') 07/08/2023 12:54:19 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1742', document_date = '2023-05-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '78.90', price_tax_excluded = '70.15', date_upd = NOW() WHERE id_document = '84428' 07/08/2023 12:54: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 = '84428' 07/08/2023 12:54:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '84428' 07/08/2023 12:54: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 ( '84428' , '20094' , 'BIBBIA IN 365 GIORNI - M. BATCHELOR' , '1' , '-1' , '4' , '32.0000' , '32' , '0' , '5' , '30.40' ) 07/08/2023 12:54: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 ( '84428' , '16124' , 'SAN GIOVANNI PAOLO II BABY - GP2-BB' , '1' , '-1' , '1' , '9.5000' , '7.7868852459016' , '22' , '0' , '9.50' ) 07/08/2023 12:54: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 ( '84428' , '18128' , 'PETTORINA PER COLLETTI DOPPI - AEPE02N00' , '3' , '-3' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '39.00' )