09/02/2024 09:09:08 am >> SELECT document_num FROM ps_document WHERE document_num = '409' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-09') 09/02/2024 09:09:08 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '409' , '2024-02-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.30' , '24.09' , NOW() , NOW() ) 09/02/2024 09:09:08 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90302' 09/02/2024 09:09:08 am >> DELETE FROM ps_document_detail WHERE id_document = '90302' 09/02/2024 09:09:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90302' , '11389' , 'VINO ROSSO DOLCE - 103' , '2' , '-2' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '17.80' ) 09/02/2024 09:09:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90302' , '17951' , 'CRISTO E GLI SPOSI - S. BUCOLO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 09/02/2024 10:21:57 am >> SELECT document_num FROM ps_document WHERE document_num = '410' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-09') 09/02/2024 10:21:57 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' , '410' , '2024-02-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.00' , '29.02' , NOW() , NOW() ) 09/02/2024 10:21: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 = '90303' 09/02/2024 10:21:57 am >> DELETE FROM ps_document_detail WHERE id_document = '90303' 09/02/2024 10:21: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 ( '90303' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 09/02/2024 10:21: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 ( '90303' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '10' , '10' , '0' , '0' , '20.00' ) 09/02/2024 10:21: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 ( '90303' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 09/02/2024 10:36:33 am >> SELECT document_num FROM ps_document WHERE document_num = '411' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-09') 09/02/2024 10:36:34 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '411' , '2024-02-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '315.00' , '261.25' , NOW() , NOW() ) 09/02/2024 10:36:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90304' 09/02/2024 10:36:34 am >> DELETE FROM ps_document_detail WHERE id_document = '90304' 09/02/2024 10:36: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 ( '90304' , '12816' , 'LIBRO DEI DEFUNTI' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '10' , '36.00' ) 09/02/2024 10:36: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 ( '90304' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 09/02/2024 10:36: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 ( '90304' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 09/02/2024 10:36: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 ( '90304' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 09/02/2024 10:36: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 ( '90304' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 09/02/2024 10:36: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 ( '90304' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '140' , '114.75409836066' , '22' , '0' , '140.00' ) 09/02/2024 10:36: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 ( '90304' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '17.5' , '14.344262295082' , '22' , '0' , '17.50' ) 09/02/2024 10:40:57 am >> SELECT document_num FROM ps_document WHERE document_num = '412' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-09') 09/02/2024 10:40:57 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' , '412' , '2024-02-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.00' , '18.85' , NOW() , NOW() ) 09/02/2024 10:40: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 = '90305' 09/02/2024 10:40:57 am >> DELETE FROM ps_document_detail WHERE id_document = '90305' 09/02/2024 10:40: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 ( '90305' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 09/02/2024 10:42:49 am >> SELECT document_num FROM ps_document WHERE document_num = '413' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-09') 09/02/2024 10:42: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' , '413' , '2024-02-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.35' , '12.35' , NOW() , NOW() ) 09/02/2024 10:42: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 = '90306' 09/02/2024 10:42:49 am >> DELETE FROM ps_document_detail WHERE id_document = '90306' 09/02/2024 10:42: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 ( '90306' , '22123' , 'CUORE A NUDO - M. GUZZI' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '5' , '12.35' ) 09/02/2024 10:58:42 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'xmeLS5TIR7300aRL' , NOW() , NOW() ) 09/02/2024 10:58:42 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4085' , '1' ) 09/02/2024 10:58:42 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4085' , '2' ) 09/02/2024 10:58:42 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4085' , '3' ) 09/02/2024 11:00:29 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4085' 09/02/2024 11:00:29 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 ( '4085' , '10' , '131' , 'QUADRI & QUADRI' , 'CANDELA' , 'ANGELA' , 'VIA SEMERIA 19' , '' , '70014' , 'CONVERSANO' , '' , '' , '' , '05076380723' , 'CNDNGL70L56C975S' , NOW() , NOW() ) 09/02/2024 11:00:29 am >> UPDATE ps_customer SET email = '', sdi = 'KRRH6B9', pec = '', date_upd = NOW() WHERE id_customer = '4085' 09/02/2024 11:02:12 am >> SELECT document_num FROM ps_document WHERE document_num = '5/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-02-09') 09/02/2024 11:02: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 ( '23' , '5/E' , '2024-02-09' , 'E' , '4085' , '0' , '4679272' , 'VIA SEMERIA 19 70014 CONVERSANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '171.36' , '171.36' , NOW() , NOW() ) 09/02/2024 11:02: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 = '90307' 09/02/2024 11:02:12 am >> DELETE FROM ps_document_detail WHERE id_document = '90307' 09/02/2024 11:02: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 ( '90307' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '102' , '-102' , '4' , '2.80' , '2.8' , '0' , '40' , '171.36' ) 09/02/2024 11:24:44 am >> SELECT document_num FROM ps_document WHERE document_num = '414' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-09') 09/02/2024 11:24: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' , '414' , '2024-02-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.55' , '10.55' , NOW() , NOW() ) 09/02/2024 11:24: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 = '90308' 09/02/2024 11:24:44 am >> DELETE FROM ps_document_detail WHERE id_document = '90308' 09/02/2024 11:24: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 ( '90308' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 09/02/2024 11:24: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 ( '90308' , '21919' , 'AMEN - APR 24' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 09/02/2024 11:24: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 ( '90308' , '21920' , 'AMEN - MAR 24' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 09/02/2024 11:31:49 am >> SELECT document_num FROM ps_document WHERE document_num = '415' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-09') 09/02/2024 11:31: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' , '415' , '2024-02-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.00' , '33.28' , NOW() , NOW() ) 09/02/2024 11:31: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 = '90309' 09/02/2024 11:31:49 am >> DELETE FROM ps_document_detail WHERE id_document = '90309' 09/02/2024 11:31: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 ( '90309' , '7271' , 'ORAZIONI IN SUFFRAGIO DELLE ANIME DEL PURGATORIO - 8477' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 09/02/2024 11:31: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 ( '90309' , '2761' , 'CORONA DI CENTO REQUIEM - 8181' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 09/02/2024 11:31: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 ( '90309' , '19805' , 'DESIDERIO DESIDERAVI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 09/02/2024 11:31: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 ( '90309' , '21409' , 'SUBLIMITAS ET MISERIA HOMINIS' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '0' , '1.80' ) 09/02/2024 11:31: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 ( '90309' , '547' , 'AMPOLLINE E VASSOIO IN VETRO - 506' , '1' , '-1' , '1' , '31.70' , '25.983606557377' , '22' , '0' , '31.70' ) 09/02/2024 12:26:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '2/A' AND id_document != '89852' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-08') 09/02/2024 12:26:57 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '2/A', document_date = '2024-01-08', document_letter = 'A', id_customer = '357', id_supplier = '', id_address = '4676034', address1 = 'VIA TORRIONE 84100 SALERNO', address2 = '', note = 'ACCONTO € 100,00', 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 = '169.56', price_tax_excluded = '169.56', date_upd = NOW() WHERE id_document = '89852' 09/02/2024 12:26: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 = '89852' 09/02/2024 12:26:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '89852' 09/02/2024 12:26:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89852' , '2403' , 'CODICE DI DIRITTO CANONICO - 1' , '1' , '-1' , '4' , '59.5000' , '59.5' , '0' , '5' , '56.52' ) 09/02/2024 12:26:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89852' , '2404' , 'CODICE DI DIRITTO CANONICO - 2' , '1' , '-1' , '4' , '59.5000' , '59.5' , '0' , '5' , '56.52' ) 09/02/2024 12:26:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89852' , '2405' , 'CODICE DI DIRITTO CANONICO - 3' , '1' , '-1' , '4' , '59.5000' , '59.5' , '0' , '5' , '56.52' ) 09/02/2024 12:39:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '416' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-09') 09/02/2024 12:39:06 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '416' , '2024-02-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.50' , '19.94' , NOW() , NOW() ) 09/02/2024 12:39:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90310' 09/02/2024 12:39:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '90310' 09/02/2024 12:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90310' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 09/02/2024 12:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90310' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '2' , '-2' , '4' , '3' , '3' , '0' , '0' , '6.00' ) 09/02/2024 12:39:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90310' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 09/02/2024 12:40:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '23/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-02-09') 09/02/2024 12:40:53 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '23/A' , '2024-02-09' , 'A' , '3544' , '0' , '4674054' , 'VIA SAN MARCO 53 - FRAZ. MONTICELLI 84062 OLEVANO SUL TUSCIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 09/02/2024 12:40:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90311' 09/02/2024 12:40:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '90311' 09/02/2024 12:40:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90311' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '2' , '-2' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '60.00' ) 09/02/2024 05:00:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '417' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-09') 09/02/2024 05:00: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' , '417' , '2024-02-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '3.37' , NOW() , NOW() ) 09/02/2024 05:00: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 = '90312' 09/02/2024 05:00:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '90312' 09/02/2024 05:00:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90312' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 09/02/2024 05:12:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '418' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-09') 09/02/2024 05:12:23 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' , '418' , '2024-02-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '41.60' , '41.27' , NOW() , NOW() ) 09/02/2024 05:12:23 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 = '90313' 09/02/2024 05:12:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '90313' 09/02/2024 05:12:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90313' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '640' , '-640' , '4' , '0.04' , '0.04' , '0' , '0' , '25.60' ) 09/02/2024 05:12:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90313' , '18749' , 'OSTIA MAGNA 200mm - OM 200' , '1' , '-1' , '3' , '8.50' , '8.1730769230769' , '4' , '0' , '8.50' ) 09/02/2024 05:12:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90313' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 09/02/2024 05:12:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90313' , '18528' , 'CON GESU VERSO IL CALVARIO - G. VALSECCHI' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 09/02/2024 05:12:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90313' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.5' , '1.5' , '0' , '0' , '1.50' ) 09/02/2024 05:12:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90313' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.5' , '2.5' , '0' , '0' , '2.50' ) 09/02/2024 05:38:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '419' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-09') 09/02/2024 05:38:36 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' , '419' , '2024-02-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 09/02/2024 05:38:36 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 = '90314' 09/02/2024 05:38:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '90314' 09/02/2024 05:38:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90314' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 09/02/2024 06:00:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '420' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-09') 09/02/2024 06:00:25 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' , '420' , '2024-02-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.00' , '16.00' , NOW() , NOW() ) 09/02/2024 06:00:25 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 = '90315' 09/02/2024 06:00:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '90315' 09/02/2024 06:00:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90315' , '21635' , 'FESTA DEL MIO BATTESIMO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 09/02/2024 06:01:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '32' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-02-09') 09/02/2024 06:01: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 ( '21' , '32' , '2024-02-09' , '' , '1123' , '0' , '1123' , ' 84099 S. CIPRIANO PICENTINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '51.00' , '51.00' , NOW() , NOW() ) 09/02/2024 06:01: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 = '90316' 09/02/2024 06:01:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '90316' 09/02/2024 06:01: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 ( '90316' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '60' , '-60' , '4' , '1.00' , '1' , '0' , '15' , '51.00' ) 09/02/2024 06:41:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '421' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-09') 09/02/2024 06:41: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' , '421' , '2024-02-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '57.38' , NOW() , NOW() ) 09/02/2024 06:41: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 = '90317' 09/02/2024 06:41:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '90317' 09/02/2024 06:41: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 ( '90317' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' )