08/03/2025 09:05:25 am >> SELECT document_num FROM ps_document WHERE document_num = '42' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-03-08') 08/03/2025 09:05:25 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' , '42' , '2025-03-08' , '' , '333' , '0' , '4671072' , 'P.ZZA S. MICHELE 84135 RUFOLI' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '189.35' , '189.35' , NOW() , NOW() ) 08/03/2025 09:05:25 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 = '96118' 08/03/2025 09:05:25 am >> DELETE FROM ps_document_detail WHERE id_document = '96118' 08/03/2025 09:05: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 ( '96118' , '2679' , 'CONOSCERE GESU' , '8' , '-8' , '4' , '3.5000' , '3.5' , '0' , '15' , '23.80' ) 08/03/2025 09:05: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 ( '96118' , '13397' , 'MIO GESU' , '22' , '-22' , '4' , '3.5000' , '3.5' , '0' , '15' , '65.45' ) 08/03/2025 09:05: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 ( '96118' , '7543' , 'PARABOLE DI GESÙ' , '10' , '-10' , '4' , '3.0000' , '3' , '0' , '15' , '25.50' ) 08/03/2025 09:05: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 ( '96118' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 08/03/2025 09:05: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 ( '96118' , '11183' , 'VENITE CON ME - GUIDA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '15' , '6.80' ) 08/03/2025 09:05: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 ( '96118' , '11193' , 'VENITE CON ME CAT.' , '12' , '-12' , '4' , '5.5000' , '5.5' , '0' , '5' , '62.70' ) 08/03/2025 09:05:33 am >> DELETE FROM ps_document WHERE id_document = '93699' 08/03/2025 09:05:33 am >> DELETE FROM ps_document_detail WHERE id_document = '93699' 08/03/2025 09:20:51 am >> SELECT document_num FROM ps_document WHERE document_num = '25/A' AND id_document != '95409' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-24') 08/03/2025 09:20:51 am >> UPDATE ps_document SET id_document_type = '24', document_num = '25/A', document_date = '2025-01-24', document_letter = 'A', id_customer = '333', id_supplier = '', id_address = '4671072', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '287.70', price_tax_excluded = '248.38', date_upd = NOW() WHERE id_document = '95409' 08/03/2025 09:20: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 = '95409' 08/03/2025 09:20:51 am >> DELETE FROM ps_document_detail WHERE id_document = '95409' 08/03/2025 09:20: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 ( '95409' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '2' , '-2' , '1' , '27.5000' , '22.540983606557' , '22' , '0' , '55.00' ) 08/03/2025 09:20: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 ( '95409' , '20798' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO C' , '1' , '-1' , '4' , '60.0000' , '60' , '0' , '5' , '57.00' ) 08/03/2025 09:20: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 ( '95409' , '12849' , 'LIBRO DELLE SS. MESSE' , '1' , '-1' , '1' , '20.0000' , '16.393442622951' , '22' , '10' , '18.00' ) 08/03/2025 09:20: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 ( '95409' , '23463' , 'GRUPPO LITURGICO PARROCCHIALE - F. GILARDI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 08/03/2025 09:20: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 ( '95409' , '23478' , 'MESSAGGIO PER LA QUARESIMA 2025' , '1' , '-1' , '4' , '1.2000' , '1.2' , '0' , '0' , '1.20' ) 08/03/2025 09:20: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 ( '95409' , '15097' , 'CORONA MATRIMONIO - ORO - 197/34' , '1' , '-1' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '7.50' ) 08/03/2025 09:20: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 ( '95409' , '23101' , 'PORTACHIAVI DECINA GIUBILEO - 1704D' , '20' , '-20' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '44.00' ) 08/03/2025 09:20: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 ( '95409' , '21597' , 'BIGLIETTI AUGURI SAN PAOLO' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 08/03/2025 09:20: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 ( '95409' , '0' , '06/03' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 08/03/2025 09:20: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 ( '95409' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 08/03/2025 09:20: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 ( '95409' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 08/03/2025 09:20: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 ( '95409' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 08/03/2025 09:20: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 ( '95409' , '' , '08/03' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 08/03/2025 09:20: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 ( '95409' , '1041' , 'BENEDIZIONI' , '500' , '-500' , '1' , '0.18' , '0.14754098360656' , '22' , '0' , '90.00' ) 08/03/2025 09:21:54 am >> SELECT document_num FROM ps_document WHERE document_num = '778' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-08') 08/03/2025 09:21:54 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' , '778' , '2025-03-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.05' , '18.05' , NOW() , NOW() ) 08/03/2025 09:21:54 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96119' 08/03/2025 09:21:54 am >> DELETE FROM ps_document_detail WHERE id_document = '96119' 08/03/2025 09:21:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96119' , '8250' , 'PREGATE, PREGATE, PREGATE - 8001' , '1' , '-1' , '4' , '19.00' , '19' , '0' , '5' , '18.05' ) 08/03/2025 09:24:06 am >> SELECT document_num FROM ps_document WHERE document_num = '779' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-08') 08/03/2025 09:24:06 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' , '779' , '2025-03-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.50' , '28.28' , NOW() , NOW() ) 08/03/2025 09:24:06 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 = '96120' 08/03/2025 09:24:06 am >> DELETE FROM ps_document_detail WHERE id_document = '96120' 08/03/2025 09:24:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96120' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '4' , '-4' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '24.00' ) 08/03/2025 09:24:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96120' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '3' , '-3' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '10.50' ) 08/03/2025 09:26:55 am >> SELECT document_num FROM ps_document WHERE document_num = '780' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-08') 08/03/2025 09:26:55 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' , '780' , '2025-03-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '161.32' , '161.32' , NOW() , NOW() ) 08/03/2025 09:26:55 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 = '96121' 08/03/2025 09:26:55 am >> DELETE FROM ps_document_detail WHERE id_document = '96121' 08/03/2025 09:26:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96121' , '23523' , 'EPISTEMOLOGIA E COSMOLOGIA' , '2' , '-2' , '4' , '28.00' , '28' , '0' , '5' , '53.20' ) 08/03/2025 09:26:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96121' , '15234' , 'INTRODUZIONE ALLA TEOLOGIA - B. SESBOUE' , '3' , '-3' , '4' , '16.00' , '16' , '0' , '5' , '45.60' ) 08/03/2025 09:26:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96121' , '23522' , 'FILOSOFIA 1' , '2' , '-2' , '4' , '32.90' , '32.9' , '0' , '5' , '62.52' ) 08/03/2025 09:27:43 am >> SELECT document_num FROM ps_document WHERE document_num = '34/A' AND id_document != '95699' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-02-10') 08/03/2025 09:27:43 am >> UPDATE ps_document SET id_document_type = '24', document_num = '34/A', document_date = '2025-02-10', document_letter = 'A', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = 'p. giuseppe castronuovo - baronissi - acconto € 110,00 - 08/03 € 50,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 = '220.38', price_tax_excluded = '184.06', date_upd = NOW() WHERE id_document = '95699' 08/03/2025 09:27:43 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95699' 08/03/2025 09:27:43 am >> DELETE FROM ps_document_detail WHERE id_document = '95699' 08/03/2025 09:27:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95699' , '23313' , 'LITURGIA PENITENZIALE COMUNITARIA' , '1' , '-1' , '4' , '9.5000' , '9.5' , '0' , '5' , '9.03' ) 08/03/2025 09:27:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95699' , '17748' , 'SEGNALIBRO - PR 349' , '4' , '-4' , '1' , '0.3500' , '0.28688524590164' , '22' , '0' , '1.40' ) 08/03/2025 09:27:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95699' , '23441' , 'ANTIQUA ET NOVA' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 08/03/2025 09:27:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95699' , '22366' , 'SAN GIUSEPPE CM 60 - 08.423' , '1' , '-1' , '1' , '200.0000' , '163.93442622951' , '22' , '0' , '200.00' ) 08/03/2025 09:27:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95699' , '5190' , 'IN ONORE DI SAN GIUSEPPE - 8190' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 08/03/2025 09:27:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95699' , '23393' , 'SULLA TUA PAROLA - MAR/APR 25' , '1' , '-1' , '4' , '4.0500' , '4.05' , '0' , '0' , '4.05' ) 08/03/2025 09:32:53 am >> SELECT document_num FROM ps_document WHERE document_num = '12' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2025-03-08') 08/03/2025 09:32: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 ( '24' , '12' , '2025-03-08' , '' , '0' , '0' , '2607' , 'VIA NAZIONALE NORD, 4 - LAGARO 40035 CASTIGLIONE DEI PEPOLI' , '' , 'RESO A FORNITORE - EC 41' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '256.50' , '256.50' , NOW() , NOW() ) 08/03/2025 09:32: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 = '96122' 08/03/2025 09:32:53 am >> DELETE FROM ps_document_detail WHERE id_document = '96122' 08/03/2025 09:32: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 ( '96122' , '23524' , 'TAPPO PER CARTUCCIA - 455/T' , '90' , '-90' , '1' , '3.0000' , '2.459' , '22' , '5' , '256.50' ) 08/03/2025 09:32:58 am >> DELETE FROM ps_document WHERE id_document = '96053' 08/03/2025 09:32:58 am >> DELETE FROM ps_document_detail WHERE id_document = '96053' 08/03/2025 09:33:10 am >> SELECT document_num FROM ps_document WHERE document_num = '41' AND id_document != '96118' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-03-08') 08/03/2025 09:33:10 am >> UPDATE ps_document SET id_document_type = '21', document_num = '41', document_date = '2025-03-08', document_letter = '', id_customer = '333', id_supplier = '', id_address = '4671072', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '189.35', price_tax_excluded = '189.35', date_upd = NOW() WHERE id_document = '96118' 08/03/2025 09:33:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96118' 08/03/2025 09:33:10 am >> DELETE FROM ps_document_detail WHERE id_document = '96118' 08/03/2025 09:33:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96118' , '2679' , 'CONOSCERE GESU' , '8' , '-8' , '4' , '3.5000' , '3.5' , '0' , '15' , '23.80' ) 08/03/2025 09:33:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96118' , '13397' , 'MIO GESU' , '22' , '-22' , '4' , '3.5000' , '3.5' , '0' , '15' , '65.45' ) 08/03/2025 09:33:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96118' , '7543' , 'PARABOLE DI GESÙ' , '10' , '-10' , '4' , '3.0000' , '3' , '0' , '15' , '25.50' ) 08/03/2025 09:33:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96118' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 08/03/2025 09:33:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96118' , '11183' , 'VENITE CON ME - GUIDA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '15' , '6.80' ) 08/03/2025 09:33:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96118' , '11193' , 'VENITE CON ME CAT.' , '12' , '-12' , '4' , '5.5000' , '5.5' , '0' , '5' , '62.70' ) 08/03/2025 09:33:24 am >> SELECT document_num FROM ps_document WHERE document_num = '34' AND id_document != '95822' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-02-19') 08/03/2025 09:33:24 am >> UPDATE ps_document SET id_document_type = '21', document_num = '34', document_date = '2025-02-19', document_letter = '', id_customer = '4163', id_supplier = '', id_address = '4679464', address1 = 'VIA SAN ROCCO 17 84038 SASSANO', address2 = '', note = '', price_shipping = '', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '34.20', price_tax_excluded = '34.20', date_upd = NOW() WHERE id_document = '95822' 08/03/2025 09:33: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 = '95822' 08/03/2025 09:33:24 am >> DELETE FROM ps_document_detail WHERE id_document = '95822' 08/03/2025 09:33:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95822' , '8408' , 'PRENDETE E MANGIATE' , '12' , '-12' , '4' , '3.0000' , '3' , '0' , '5' , '34.20' ) 08/03/2025 09:45:26 am >> SELECT document_num FROM ps_document WHERE document_num = '781' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-08') 08/03/2025 09:45:26 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '781' , '2025-03-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.50' , '6.15' , NOW() , NOW() ) 08/03/2025 09:45:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96123' 08/03/2025 09:45:26 am >> DELETE FROM ps_document_detail WHERE id_document = '96123' 08/03/2025 09:45:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96123' , '20522' , 'CROCE BASE NIK - 105 ALV' , '3' , '-3' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '7.50' ) 08/03/2025 09:47:52 am >> SELECT document_num FROM ps_document WHERE document_num = '782' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-08') 08/03/2025 09:47:52 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '782' , '2025-03-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '43.33' , '43.33' , NOW() , NOW() ) 08/03/2025 09:47:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96124' 08/03/2025 09:47:52 am >> DELETE FROM ps_document_detail WHERE id_document = '96124' 08/03/2025 09:47:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96124' , '17657' , 'SALMI' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '5' , '12.26' ) 08/03/2025 09:47:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96124' , '23165' , 'DILEXIT NOS' , '1' , '-1' , '4' , '2.20' , '2.2' , '0' , '5' , '2.09' ) 08/03/2025 09:47:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96124' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 08/03/2025 09:47: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 ( '96124' , '18395' , 'EDITH STEIN - SCRITTI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 08/03/2025 09:47: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 ( '96124' , '3604' , 'DOCUMENTI DEL CONCILIO VATICANO II' , '1' , '-1' , '4' , '16.50' , '16.5' , '0' , '5' , '15.68' ) 08/03/2025 10:05:17 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000075' AND id_product != '1912' AND ean13 != '' 08/03/2025 10:05:17 am >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '000075', date_upd = NOW() WHERE id_product = '1912' 08/03/2025 10:05:17 am >> UPDATE ps_product_lang SET name = 'CERA DELL\'EREMO - 415/B ', description = '' WHERE id_product = '1912' 08/03/2025 10:05:17 am >> UPDATE ps_product SET wholesale_price = '3.15', on_sale = '0', price = '5.327868852459017' WHERE id_product = '1912' 08/03/2025 10:05:17 am >> UPDATE ps_product_shop SET wholesale_price = '3.15', price = '5.327868852459017', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '1912' 08/03/2025 10:05:17 am >> DELETE FROM ps_specific_price WHERE id_product = '1912' 08/03/2025 10:47:07 am >> SELECT document_num FROM ps_document WHERE document_num = '783' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-08') 08/03/2025 10:47:07 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' , '783' , '2025-03-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.50' , '22.60' , NOW() , NOW() ) 08/03/2025 10:47:07 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 = '96125' 08/03/2025 10:47:07 am >> DELETE FROM ps_document_detail WHERE id_document = '96125' 08/03/2025 10:47:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96125' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 08/03/2025 10:47:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96125' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 08/03/2025 10:47:28 am >> SELECT document_num FROM ps_document WHERE document_num = '784' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-08') 08/03/2025 10:47:28 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' , '784' , '2025-03-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.65' , '8.77' , NOW() , NOW() ) 08/03/2025 10:47:28 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 = '96126' 08/03/2025 10:47:28 am >> DELETE FROM ps_document_detail WHERE id_document = '96126' 08/03/2025 10:47:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96126' , '22503' , 'ROSARIO PROFUMATO ROSA MIRACOLOSA - 192/RP6' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 08/03/2025 10:47:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96126' , '23393' , 'SULLA TUA PAROLA - MAR/APR 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 08/03/2025 10:51:53 am >> SELECT document_num FROM ps_document WHERE document_num = '785' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-08') 08/03/2025 10:51: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' , '785' , '2025-03-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '1.64' , NOW() , NOW() ) 08/03/2025 10:51: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 = '96127' 08/03/2025 10:51:53 am >> DELETE FROM ps_document_detail WHERE id_document = '96127' 08/03/2025 10:51: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 ( '96127' , '18131' , 'TAU MEDIO CM3 - T6/t5' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 08/03/2025 10:57:55 am >> SELECT document_num FROM ps_document WHERE document_num = '786' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-08') 08/03/2025 10:57:55 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' , '786' , '2025-03-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '200.00' , '163.93' , NOW() , NOW() ) 08/03/2025 10:57:55 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 = '96128' 08/03/2025 10:57:55 am >> DELETE FROM ps_document_detail WHERE id_document = '96128' 08/03/2025 10:57:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96128' , '15666' , 'STATUA MIRACOLOSA CM 60 - PA602' , '1' , '-1' , '1' , '200' , '163.93442622951' , '22' , '0' , '200.00' ) 08/03/2025 11:10:13 am >> SELECT document_num FROM ps_document WHERE document_num = '787' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-08') 08/03/2025 11:10:13 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' , '787' , '2025-03-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '97.00' , '82.59' , NOW() , NOW() ) 08/03/2025 11:10:13 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 = '96129' 08/03/2025 11:10:13 am >> DELETE FROM ps_document_detail WHERE id_document = '96129' 08/03/2025 11:10:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96129' , '22024' , 'TRATTATO DELLA VERA DEVOZIONE - MONTFORT - 8576' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 08/03/2025 11:10: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 ( '96129' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 08/03/2025 11:10: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 ( '96129' , '23366' , 'VIA CRUCIS CON MARIA - A. COMASTRI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 08/03/2025 11:10: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 ( '96129' , '23494' , 'DEVOZIONE ALLA SACRA SPINA DI GESU - A. BOTTIGLIERI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 08/03/2025 11:10: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 ( '96129' , '23498' , 'SPERANZA NELLA VIA DELLA CROCE' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '5' , '4.28' ) 08/03/2025 11:10: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 ( '96129' , '17400' , 'STATUA MIRACOLOSA CM 40 - 805' , '1' , '-1' , '1' , '79.89' , '65.483606557377' , '22' , '0' , '79.89' ) 08/03/2025 11:27:15 am >> SELECT document_num FROM ps_document WHERE document_num = '788' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-08') 08/03/2025 11:27:16 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '788' , '2025-03-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '81.97' , NOW() , NOW() ) 08/03/2025 11:27:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96130' 08/03/2025 11:27:16 am >> DELETE FROM ps_document_detail WHERE id_document = '96130' 08/03/2025 11:27: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 ( '96130' , '17745' , 'DALMATICA CROCE - PDA001' , '1' , '-1' , '1' , '100.00' , '81.967213114754' , '22' , '0' , '100.00' ) 08/03/2025 11:40:03 am >> SELECT document_num FROM ps_document WHERE document_num = '789' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-08') 08/03/2025 11:40: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' , '789' , '2025-03-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 08/03/2025 11:40: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 = '96131' 08/03/2025 11:40:03 am >> DELETE FROM ps_document_detail WHERE id_document = '96131' 08/03/2025 11:40: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 ( '96131' , '23393' , 'SULLA TUA PAROLA - MAR/APR 25' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 08/03/2025 11:44:01 am >> SELECT document_num FROM ps_document WHERE document_num = '790' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-08') 08/03/2025 11:44:02 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '790' , '2025-03-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.80' , '14.59' , NOW() , NOW() ) 08/03/2025 11:44:02 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96132' 08/03/2025 11:44:02 am >> DELETE FROM ps_document_detail WHERE id_document = '96132' 08/03/2025 11:44:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96132' , '11389' , 'VINO ROSSO DOLCE - 103' , '2' , '-2' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '17.80' ) 08/03/2025 11:49:19 am >> SELECT document_num FROM ps_document WHERE document_num = '791' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-08') 08/03/2025 11:49: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' , '791' , '2025-03-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '1.64' , NOW() , NOW() ) 08/03/2025 11:49: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 = '96133' 08/03/2025 11:49:19 am >> DELETE FROM ps_document_detail WHERE id_document = '96133' 08/03/2025 11:49:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96133' , '2436' , 'COLORANTE PER CERA LIQUIDA - 1002' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 08/03/2025 12:12:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '792' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-08') 08/03/2025 12:12: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' , '792' , '2025-03-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 08/03/2025 12:12: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 = '96134' 08/03/2025 12:12:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '96134' 08/03/2025 12:12: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 ( '96134' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '90' , '73.770491803279' , '22' , '0' , '90.00' ) 08/03/2025 12:17:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '793' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-08') 08/03/2025 12:17: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' , '793' , '2025-03-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.00' , '21.15' , NOW() , NOW() ) 08/03/2025 12:17: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 = '96135' 08/03/2025 12:17:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '96135' 08/03/2025 12:17: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 ( '96135' , '16689' , 'OSTIA PAN DI CENA mm80' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 08/03/2025 12:17: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 ( '96135' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 08/03/2025 12:17:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '794' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-08') 08/03/2025 12:17:40 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' , '794' , '2025-03-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 08/03/2025 12:17:40 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 = '96136' 08/03/2025 12:17:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '96136' 08/03/2025 12:17:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96136' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '90' , '73.770491803279' , '22' , '0' , '90.00' ) 08/03/2025 12:21:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '795' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-08') 08/03/2025 12:21:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '795' , '2025-03-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.60' , '16.07' , NOW() , NOW() ) 08/03/2025 12:21: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 = '96137' 08/03/2025 12:21:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '96137' 08/03/2025 12:21: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 ( '96137' , '1914' , 'CERA DELLA LITURGIA' , '4' , '-4' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '19.60' ) 08/03/2025 12:35:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '677' AND id_document != '95981' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-03-01') 08/03/2025 12:35:33 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '677', document_date = '2025-03-01', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '22.50', price_tax_excluded = '22.23', date_upd = NOW() WHERE id_document = '95981' 08/03/2025 12:35:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95981' 08/03/2025 12:35:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '95981' 08/03/2025 12:35:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95981' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.5' , '1.5' , '0' , '0' , '1.50' ) 08/03/2025 12:35:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95981' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '5' , '-5' , '4' , '2.0000' , '2' , '0' , '0' , '10.00' ) 08/03/2025 12:35:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95981' , '14499' , 'COMUNIONE AI MALATI' , '5' , '-5' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '1.50' ) 08/03/2025 12:35:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95981' , '23407' , 'PROCESSO AL PROCESSETTO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 08/03/2025 12:50:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '563' AND id_document != '95839' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-20') 08/03/2025 12:50:31 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '563', document_date = '2025-02-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '70.00', price_tax_excluded = '57.38', date_upd = NOW() WHERE id_document = '95839' 08/03/2025 12:50:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95839' 08/03/2025 12:50:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '95839' 08/03/2025 12:50:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95839' , '17400' , 'STATUA MIRACOLOSA CM 40 - 805' , '1' , '-1' , '1' , '70' , '57.377049180328' , '22' , '0' , '70.00' ) 08/03/2025 03:41:00 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'BvwQRGtvIpEKq5yP' , NOW() , NOW() ) 08/03/2025 03:41:00 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7132' , '1' ) 08/03/2025 03:41:00 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7132' , '2' ) 08/03/2025 03:41:00 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7132' , '3' )