05/11/2025 08:28:11 am >> UPDATE ps_document SET id_document_type = '31', document_num = '335/25', document_date = '2025-10-31', document_letter = '25', id_customer = '0', id_supplier = '17', id_address = '2612', address1 = 'VIA TORQUATO TASSO, 10 24020 GORLE', 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 = '38.25', price_tax_excluded = '38.25', date_upd = NOW() WHERE id_document = '99678' 05/11/2025 08:28:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99678' 05/11/2025 08:28:11 am >> DELETE FROM ps_document_detail WHERE id_document = '99678' 05/11/2025 08:28: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 ( '99678' , '24181' , 'DIO HA TANTO AMATO IL MONDO' , '5' , '5' , '4' , '2.5000' , '2.5' , '0' , '50' , '6.25' ) 05/11/2025 08:28:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '24181' AND id_supplier = '17' 05/11/2025 08:28:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24181' , '17' , '1' ) 05/11/2025 08:28: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 ( '99678' , '24182' , 'ANDIAMO INCONTRO A GESU' , '5' , '5' , '4' , '2.5000' , '2.5' , '0' , '50' , '6.25' ) 05/11/2025 08:28:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '24182' AND id_supplier = '17' 05/11/2025 08:28:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24182' , '17' , '1' ) 05/11/2025 08:28: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 ( '99678' , '24183' , 'PAPA LEONE XIV - F. INNOCENTE' , '5' , '5' , '4' , '7.5000' , '7.5' , '0' , '50' , '18.75' ) 05/11/2025 08:28:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '24183' AND id_supplier = '17' 05/11/2025 08:28:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24183' , '17' , '1' ) 05/11/2025 08:28: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 ( '99678' , '24221' , 'DILEXI TE' , '5' , '5' , '4' , '2.8000' , '2.8' , '0' , '50' , '7.00' ) 05/11/2025 08:28:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '24221' AND id_supplier = '17' 05/11/2025 08:28:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24221' , '17' , '1' ) 05/11/2025 08:38: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 ( '32' , '308-2025' , '2025-10-31' , '' , '0' , '95' , '2757' , 'VIA A. POLENGHI, 97 26845 CODOGNO' , '' , '' , '0.02' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '1234.15' , '1011.60' , NOW() , NOW() ) 05/11/2025 08:38: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 = '99684' 05/11/2025 08:38:25 am >> DELETE FROM ps_document_detail WHERE id_document = '99684' 05/11/2025 08:38: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 ( '99684' , '24203' , 'CINGOLO - CING13' , '30' , '0' , '1' , '4.7000' , '3.8525' , '22' , '3' , '166.86' ) 05/11/2025 08:38:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '24203' AND id_supplier = '95' 05/11/2025 08:38:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24203' , '95' , '1' ) 05/11/2025 08:38: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 ( '99684' , '16456' , 'CINGOLO - CING03' , '5' , '0' , '1' , '6.3600' , '5.2131' , '22' , '3' , '37.63' ) 05/11/2025 08:38:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '16456' AND id_supplier = '95' 05/11/2025 08:38:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16456' , '95' , '1' ) 05/11/2025 08:38: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 ( '99684' , '17535' , 'SERVIZIO MESSA LINO' , '3' , '0' , '1' , '37.0000' , '30.3279' , '22' , '3' , '131.36' ) 05/11/2025 08:38:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '17535' AND id_supplier = '95' 05/11/2025 08:38:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17535' , '95' , '1' ) 05/11/2025 08:38: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 ( '99684' , '14021' , 'CINGOLO - CING08' , '2' , '0' , '1' , '13.8600' , '11.3607' , '22' , '3' , '32.80' ) 05/11/2025 08:38:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '14021' AND id_supplier = '95' 05/11/2025 08:38:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14021' , '95' , '1' ) 05/11/2025 08:38: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 ( '99684' , '21447' , 'FAZZOLETTO TULLE ' , '4' , '0' , '1' , '27.9000' , '22.8689' , '22' , '3' , '132.07' ) 05/11/2025 08:38:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '21447' AND id_supplier = '95' 05/11/2025 08:38:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21447' , '95' , '1' ) 05/11/2025 08:38: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 ( '99684' , '16455' , 'PALLA MARIANA RASO ARG. - PA-A43' , '1' , '0' , '1' , '52.5000' , '43.0328' , '22' , '3' , '62.13' ) 05/11/2025 08:38:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '16455' AND id_supplier = '95' 05/11/2025 08:38:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16455' , '95' , '1' ) 05/11/2025 08:38: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 ( '99684' , '24204' , 'GANCIO - B310/CA' , '3' , '0' , '1' , '6.9000' , '5.6557' , '22' , '3' , '24.50' ) 05/11/2025 08:38:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '24204' AND id_supplier = '95' 05/11/2025 08:38:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24204' , '95' , '1' ) 05/11/2025 08:38: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 ( '99684' , '24206' , 'GANCIO - B311/CA' , '3' , '0' , '1' , '9.3200' , '7.6393' , '22' , '3' , '33.09' ) 05/11/2025 08:38:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '24206' AND id_supplier = '95' 05/11/2025 08:38:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24206' , '95' , '1' ) 05/11/2025 08:38: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 ( '99684' , '24208' , 'BALZA SU RASO IHS - P485' , '13' , '0' , '1' , '21.3000' , '17.459' , '22' , '3' , '337.77' ) 05/11/2025 08:38:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '24208' AND id_supplier = '95' 05/11/2025 08:38:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24208' , '95' , '1' ) 05/11/2025 08:38: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 ( '99684' , '24207' , 'BALZA SU RASO - P555' , '13' , '0' , '1' , '17.4000' , '14.2623' , '22' , '3' , '275.92' ) 05/11/2025 08:38:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '24207' AND id_supplier = '95' 05/11/2025 08:38:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24207' , '95' , '1' ) 05/11/2025 08:46:03 am >> UPDATE ps_document SET id_document_type = '33', document_num = '195/25', document_date = '2025-10-27', document_letter = '25', id_customer = '0', id_supplier = '17', id_address = '2612', address1 = 'VIA TORQUATO TASSO, 10 24020 GORLE', 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 = '7.00', price_tax_excluded = '7.00', date_upd = NOW() WHERE id_document = '99665' 05/11/2025 08:46: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 = '99665' 05/11/2025 08:46:03 am >> DELETE FROM ps_document_detail WHERE id_document = '99665' 05/11/2025 08:46: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 ( '99665' , '24221' , 'DILEXI TE' , '5' , '5' , '4' , '2.8000' , '2.8' , '0' , '50' , '7.00' ) 05/11/2025 08:46:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '24221' AND id_supplier = '17' 05/11/2025 08:46:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24221' , '17' , '1' ) 05/11/2025 08:46:35 am >> UPDATE ps_document SET id_document_type = '33', document_num = '195/25', document_date = '2025-10-27', document_letter = '25', id_customer = '0', id_supplier = '0', id_address = '4671003', address1 = 'VIA TORQUATO TASSO, 10 24020 GORLE', 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 = '7.00', price_tax_excluded = '7.00', date_upd = NOW() WHERE id_document = '99665' 05/11/2025 08:46:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99665' 05/11/2025 08:46:35 am >> DELETE FROM ps_document_detail WHERE id_document = '99665' 05/11/2025 08:46:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99665' , '24221' , 'DILEXI TE' , '5' , '5' , '4' , '2.8000' , '2.8' , '0' , '50' , '7.00' ) 05/11/2025 08:51:51 am >> SELECT document_num FROM ps_document WHERE document_num = '24' AND id_document != '99150' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2025-10-09') 05/11/2025 08:51:51 am >> UPDATE ps_document SET id_document_type = '24', document_num = '24', document_date = '2025-10-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669100', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'RESA- n. c. ric', 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 = '157.80', price_tax_excluded = '157.80', date_upd = NOW() WHERE id_document = '99150' 05/11/2025 08:51: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 = '99150' 05/11/2025 08:51:51 am >> DELETE FROM ps_document_detail WHERE id_document = '99150' 05/11/2025 08:51: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 ( '99150' , '16641' , 'PREGHIERA - P. COLLINS' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 05/11/2025 08:51: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 ( '99150' , '22277' , 'DIVINA PERCEPTIO - J. REGO' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 05/11/2025 08:51: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 ( '99150' , '23410' , 'TRIDUO PASQUALE PER NOI E PER IL MONDO - G. FLORIO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 05/11/2025 08:51: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 ( '99150' , '17203' , 'LASCIATI CONDURRE DA MARIA - M. REALE' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 05/11/2025 08:51: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 ( '99150' , '22680' , 'LUCE DI GRAZIA - M. DI LORENZO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 05/11/2025 08:51: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 ( '99150' , '21464' , 'NELLA COMUNIONE DELLA SS TRINITA - D. COGONI' , '1' , '-1' , '4' , '17.9000' , '17.9' , '0' , '0' , '17.90' ) 05/11/2025 08:51: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 ( '99150' , '20859' , 'VOI CHI DITE CHE IO SIA - C. SOLMONESE ' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 05/11/2025 08:51: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 ( '99150' , '21462' , 'DIO IN CUI CREDIAMO - M. LAVRA' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 05/11/2025 08:51: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 ( '99150' , '21072' , 'INSEGNACI A PREGARE - A. BARBI' , '1' , '-1' , '4' , '22.9000' , '22.9' , '0' , '0' , '22.90' ) 05/11/2025 08:51: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 ( '99150' , '23409' , 'VIA CRUCIS DEL GIUBILEO - RUCCIA/SCALERA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 05/11/2025 08:51: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 ( '99150' , '24031' , 'MISIONEROS DIGITALE - H. G. ARIAS' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 05/11/2025 09:07:04 am >> SELECT document_num FROM ps_document WHERE document_num = '31/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-05') 05/11/2025 09:07: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 ( '23' , '31/L' , '2025-11-05' , 'L' , '3812' , '0' , '4679440' , 'LARGO PLEBISCITO 12 84121 SALERNO ' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '389.90' , '327.62' , NOW() , NOW() ) 05/11/2025 09:07: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 = '99685' 05/11/2025 09:07:04 am >> DELETE FROM ps_document_detail WHERE id_document = '99685' 05/11/2025 09:07: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 ( '99685' , '15356' , 'AMPOLLE ABBRACCIO DORATE - 1511' , '1' , '-1' , '1' , '105.0000' , '86.0656' , '22' , '0' , '105.00' ) 05/11/2025 09:07: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 ( '99685' , '19298' , 'BIGLIETTO AUGURALE GRANDE' , '1' , '-1' , '1' , '1.2000' , '0.9836' , '22' , '0' , '1.20' ) 05/11/2025 09:07: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 ( '99685' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.5000' , '4.3269' , '4' , '0' , '9.00' ) 05/11/2025 09:07: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 ( '99685' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7000' , '3.8525' , '22' , '0' , '112.80' ) 05/11/2025 09:07: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 ( '99685' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3654' , '4' , '0' , '17.50' ) 05/11/2025 09:07: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 ( '99685' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.0000' , '1.9231' , '4' , '0' , '20.00' ) 05/11/2025 09:07: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 ( '99685' , '16164' , 'OSTIA TAGLIO CHIUSO - 72 - OTC25' , '1' , '-1' , '3' , '2.0000' , '1.9231' , '4' , '0' , '2.00' ) 05/11/2025 09:07: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 ( '99685' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '2' , '-2' , '1' , '13.0000' , '10.6557' , '22' , '0' , '26.00' ) 05/11/2025 09:07: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 ( '99685' , '23807' , 'CALENDARIO LITURGICO 2026' , '8' , '-8' , '4' , '0.8000' , '0.8' , '0' , '0' , '6.40' ) 05/11/2025 09:07: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 ( '99685' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.459' , '22' , '0' , '90.00' ) 05/11/2025 09:07:27 am >> DELETE FROM ps_document WHERE id_document = '98783' 05/11/2025 09:07:27 am >> DELETE FROM ps_document_detail WHERE id_document = '98783' 05/11/2025 09:18:34 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'Cd9y85Sib0TYKvTt' , NOW() , NOW() ) 05/11/2025 09:18:34 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4273' , '1' ) 05/11/2025 09:18:34 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4273' , '2' ) 05/11/2025 09:18:34 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4273' , '3' ) 05/11/2025 09:22:44 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7016' 05/11/2025 09:22:44 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 ( '7016' , '10' , '125' , 'PARROCCHIA SANTA MARIA REGINA DELLA PACE' , 'BRICCHI' , 'DON ENRICO' , 'PIAZZA SANTA MARIA 2' , '' , '60027' , 'OSIMO' , '' , '' , '3398333425' , '' , '93000760426' , NOW() , NOW() ) 05/11/2025 09:22:44 am >> UPDATE ps_customer SET email = 'stazioneabadia@diocesi.ancona.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7016' 05/11/2025 09:23:52 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4273' 05/11/2025 09:23:52 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 ( '4273' , '10' , '125' , 'PARROCCHIA S. NICOLO\' DI BARI' , 'BRICCHI' , 'DON ENRICO' , 'P. ZZA VITTORIO VENETO ' , '' , '60020' , 'SIROLO' , '' , '' , '3398333425' , '' , '80006810420' , NOW() , NOW() ) 05/11/2025 09:23:52 am >> UPDATE ps_customer SET email = 'don.enrico39@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4273' 05/11/2025 09:25:30 am >> SELECT document_num FROM ps_document WHERE document_num = '194' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-05') 05/11/2025 09:25:30 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' , '194' , '2025-11-05' , '' , '4273' , '0' , '4679614' , 'P. ZZA VITTORIO VENETO 60020 SIROLO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '340.00' , '340.00' , NOW() , NOW() ) 05/11/2025 09:25:30 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 = '99686' 05/11/2025 09:25:30 am >> DELETE FROM ps_document_detail WHERE id_document = '99686' 05/11/2025 09:25:30 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 ( '99686' , '15602' , 'AMICO GESU\' ALBUM' , '50' , '-50' , '4' , '2.00' , '2' , '0' , '15' , '85.00' ) 05/11/2025 09:25:30 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 ( '99686' , '24147' , 'AMICO GESU - SCATOLA 60 PZ' , '10' , '-10' , '4' , '30.00' , '30' , '0' , '15' , '255.00' ) 05/11/2025 09:54:01 am >> SELECT document_num FROM ps_document WHERE document_num = '195' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-05') 05/11/2025 09:54:01 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' , '195' , '2025-11-05' , '' , '3838' , '0' , '4674892' , 'VIA MONS. MENEGAZZI 3 44022 COMACCHIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '50.58' , '50.58' , NOW() , NOW() ) 05/11/2025 09:54:01 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 = '99687' 05/11/2025 09:54:01 am >> DELETE FROM ps_document_detail WHERE id_document = '99687' 05/11/2025 09:54:01 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 ( '99687' , '2679' , 'CONOSCERE GESU\'' , '17' , '-17' , '4' , '3.50' , '3.5' , '0' , '15' , '50.58' ) 05/11/2025 10:11:47 am >> SELECT document_num FROM ps_document WHERE document_num = '3654' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-05') 05/11/2025 10:11:47 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3654' , '2025-11-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '9.02' , NOW() , NOW() ) 05/11/2025 10:11:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99688' 05/11/2025 10:11:47 am >> DELETE FROM ps_document_detail WHERE id_document = '99688' 05/11/2025 10:11:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99688' , '14063' , 'STELLARIO PLEX CM 10 / 12' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 05/11/2025 10:16:13 am >> SELECT document_num FROM ps_document WHERE document_num = '3655' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-05') 05/11/2025 10:16: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' , '3655' , '2025-11-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.33' , '14.33' , NOW() , NOW() ) 05/11/2025 10:16: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 = '99689' 05/11/2025 10:16:13 am >> DELETE FROM ps_document_detail WHERE id_document = '99689' 05/11/2025 10:16: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 ( '99689' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.5' , '1.5' , '0' , '0' , '1.50' ) 05/11/2025 10:16: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 ( '99689' , '22024' , 'TRATTATO DELLA VERA DEVOZIONE - 8576' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 05/11/2025 10:16: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 ( '99689' , '19268' , 'VANGELO E ATTI DEGLI APOSTOLI' , '1' , '-1' , '4' , '6.50' , '6.5' , '0' , '5' , '6.18' ) 05/11/2025 10:20:26 am >> SELECT document_num FROM ps_document WHERE document_num = '3656' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-05') 05/11/2025 10:20: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' , '3656' , '2025-11-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '43.30' , '39.39' , NOW() , NOW() ) 05/11/2025 10:20: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 = '99690' 05/11/2025 10:20:26 am >> DELETE FROM ps_document_detail WHERE id_document = '99690' 05/11/2025 10:20: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 ( '99690' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '15.80' ) 05/11/2025 10:20: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 ( '99690' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 05/11/2025 10:20: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 ( '99690' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 05/11/2025 10:31:05 am >> DELETE FROM ps_document WHERE id_document = '96971' 05/11/2025 10:31:05 am >> DELETE FROM ps_document_detail WHERE id_document = '96971' 05/11/2025 10:31:20 am >> SELECT document_num FROM ps_document WHERE document_num = '3657' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-05') 05/11/2025 10:31:20 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' , '3657' , '2025-11-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '104.50' , '104.50' , NOW() , NOW() ) 05/11/2025 10:31:20 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 = '99691' 05/11/2025 10:31:20 am >> DELETE FROM ps_document_detail WHERE id_document = '99691' 05/11/2025 10:31: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 ( '99691' , '17329' , 'MESSALE ROMANO D\'ALTARE N.E' , '1' , '-1' , '4' , '110.00' , '110' , '0' , '5' , '104.50' ) 05/11/2025 10:32:36 am >> SELECT document_num FROM ps_document WHERE document_num = '3658' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-05') 05/11/2025 10:32:37 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' , '3658' , '2025-11-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '8.65' , NOW() , NOW() ) 05/11/2025 10:32:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99692' 05/11/2025 10:32:37 am >> DELETE FROM ps_document_detail WHERE id_document = '99692' 05/11/2025 10:32:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99692' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '9.00' ) 05/11/2025 10:39:56 am >> SELECT document_num FROM ps_document WHERE document_num = '132/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-05') 05/11/2025 10:39:56 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '132/A' , '2025-11-05' , 'A' , '4210' , '0' , '4679501' , 'VIA SAN MICHELE 84084 FISCIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '110.00' , '110.00' , NOW() , NOW() ) 05/11/2025 10:39: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 = '99693' 05/11/2025 10:39:56 am >> DELETE FROM ps_document_detail WHERE id_document = '99693' 05/11/2025 10:39: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 ( '99693' , '17329' , 'MESSALE ROMANO D\'ALTARE N.E' , '1' , '-1' , '4' , '110.00' , '110' , '0' , '0' , '110.00' ) 05/11/2025 10:40:58 am >> SELECT document_num FROM ps_document WHERE document_num = '3659' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-05') 05/11/2025 10:40:58 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' , '3659' , '2025-11-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.50' , '18.44' , NOW() , NOW() ) 05/11/2025 10:40:58 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 = '99694' 05/11/2025 10:40:58 am >> DELETE FROM ps_document_detail WHERE id_document = '99694' 05/11/2025 10:40:58 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 ( '99694' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '50' , '-50' , '1' , '0.45' , '0.36885245901639' , '22' , '0' , '22.50' ) 05/11/2025 10:57:38 am >> SELECT document_num FROM ps_document WHERE document_num = '32/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-05') 05/11/2025 10:57:38 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' , '32/L' , '2025-11-05' , 'L' , '2379' , '0' , '4671437' , 'R.NE PESCARA 84025 EBOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '115.00' , '112.11' , NOW() , NOW() ) 05/11/2025 10:57:38 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 = '99695' 05/11/2025 10:57:38 am >> DELETE FROM ps_document_detail WHERE id_document = '99695' 05/11/2025 10:57:38 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 ( '99695' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '20' , '-20' , '4' , '3.00' , '3' , '0' , '10' , '54.00' ) 05/11/2025 10:57:38 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 ( '99695' , '10741' , 'TROPPO FORTE - 2/ LA DIREZIONE' , '10' , '-10' , '4' , '5.00' , '5' , '0' , '10' , '45.00' ) 05/11/2025 10:57:38 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 ( '99695' , '12819' , 'REGISTRO DEL CATECHISTA ' , '20' , '-20' , '1' , '1.00' , '0.81967213114754' , '22' , '20' , '16.00' ) 05/11/2025 11:00:27 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , '4q4BuVhc3izVfnGO' , NOW() , NOW() ) 05/11/2025 11:00:27 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4274' , '1' ) 05/11/2025 11:00:27 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4274' , '2' ) 05/11/2025 11:00:28 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4274' , '3' ) 05/11/2025 11:03:09 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4274' 05/11/2025 11:03:09 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 ( '4274' , '10' , '216' , 'CONVENTO PASSIONISTI' , 'FRACASSO' , 'P. LUCA' , 'VIALE MANCINI 28' , '' , '84024' , 'MANDURIA' , '' , '' , '3282408839' , '' , '' , NOW() , NOW() ) 05/11/2025 11:03:09 am >> UPDATE ps_customer SET email = 'fracassoluca78@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4274' 05/11/2025 11:26:18 am >> SELECT document_num FROM ps_document WHERE document_num = '3660' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-05') 05/11/2025 11:26:18 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3660' , '2025-11-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '10.66' , NOW() , NOW() ) 05/11/2025 11:26:18 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99696' 05/11/2025 11:26:18 am >> DELETE FROM ps_document_detail WHERE id_document = '99696' 05/11/2025 11:26:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99696' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 05/11/2025 11:50:49 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , '6WFUHAvg95hK9P7v' , NOW() , NOW() ) 05/11/2025 11:50:49 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4275' , '1' ) 05/11/2025 11:50:49 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4275' , '2' ) 05/11/2025 11:50:49 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4275' , '3' ) 05/11/2025 11:53:31 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4275' 05/11/2025 11:53:31 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 ( '4275' , '10' , '124' , 'PARROCCHIA S. PIETRO AP. ' , 'SIRONI' , 'DON FULVIO' , 'VIA TORRAGLIO 2' , '' , '15059' , 'VOLPEDO' , 'ORDINA TIZIANA BIDONE' , '' , '3341121358' , '' , '85008010069' , NOW() , NOW() ) 05/11/2025 11:53:31 am >> UPDATE ps_customer SET email = 'tiziana.bidone@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4275' 05/11/2025 11:55:51 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4275' 05/11/2025 11:55:51 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 ( '4275' , '10' , '124' , 'PARROCCHIA S. PIETRO AP. ' , 'SIRONI' , 'DON FULVIO' , 'VIA TORRAGLIO 2' , '' , '15059' , 'VOLPEDO' , 'ORDINA TIZIANA BIDONE\r\nVIA SAN MARTINO 2 15059 VOLPEDO ' , '' , '3341121358' , '' , '85008010069' , NOW() , NOW() ) 05/11/2025 11:55:51 am >> UPDATE ps_customer SET email = 'tiziana.bidone@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4275' 05/11/2025 11:56:12 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4275' 05/11/2025 11:56:12 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 ( '4275' , '10' , '124' , 'PARROCCHIA S. PIETRO AP. ' , 'SIRONI' , 'DON FULVIO' , 'VIA TORRAGLIO 2' , '' , '15059' , 'VOLPEDO' , 'ORDINA E SPEDIZIONE: TIZIANA BIDONE\r\nVIA SAN MARTINO 2 15059 VOLPEDO ' , '' , '3341121358' , '' , '85008010069' , NOW() , NOW() ) 05/11/2025 11:56:12 am >> UPDATE ps_customer SET email = 'tiziana.bidone@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4275' 05/11/2025 11:56:42 am >> SELECT document_num FROM ps_document WHERE document_num = '196' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-05') 05/11/2025 11:56:42 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' , '196' , '2025-11-05' , '' , '4275' , '0' , '4679618' , 'VIA TORRAGLIO 2 15059 VOLPEDO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '102.00' , '102.00' , NOW() , NOW() ) 05/11/2025 11:56:42 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 = '99697' 05/11/2025 11:56:42 am >> DELETE FROM ps_document_detail WHERE id_document = '99697' 05/11/2025 11:56:42 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 ( '99697' , '4120' , 'FEDE NELLO ZAINETTO' , '20' , '-20' , '4' , '6.00' , '6' , '0' , '15' , '102.00' ) 05/11/2025 12:04:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '3661' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-05') 05/11/2025 12:04:37 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' , '3661' , '2025-11-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.90' , '7.30' , NOW() , NOW() ) 05/11/2025 12:04:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99698' 05/11/2025 12:04:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '99698' 05/11/2025 12:04:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99698' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 05/11/2025 12:21:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '197' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-05') 05/11/2025 12:21:07 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' , '197' , '2025-11-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '220.00' , '180.33' , NOW() , NOW() ) 05/11/2025 12:21:07 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 = '99699' 05/11/2025 12:21:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '99699' 05/11/2025 12:21:07 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 ( '99699' , '12203' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 5 - 73/50' , '10' , '-10' , '1' , '22.00' , '18.032786885246' , '22' , '0' , '220.00' ) 05/11/2025 12:21:36 pm >> DELETE FROM ps_document WHERE id_document = '99699' 05/11/2025 12:21:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '99699' 05/11/2025 02:31:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '133/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-05') 05/11/2025 02:31:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '133/A' , '2025-11-05' , 'A' , '2757' , '0' , '4679344' , 'VIA CIRILLO 84085 MERCATO SAN SEVERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '210.04' , '210.04' , NOW() , NOW() ) 05/11/2025 02:31:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99700' 05/11/2025 02:31:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '99700' 05/11/2025 02:31:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99700' , '13397' , 'MIO GESU\'' , '13' , '-13' , '4' , '3.50' , '3.5' , '0' , '15' , '38.68' ) 05/11/2025 02:31:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99700' , '5457' , 'IO SONO CON VOI 1 PARTE' , '18' , '-18' , '4' , '2.80' , '2.8' , '0' , '15' , '42.84' ) 05/11/2025 02:31:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99700' , '5458' , 'IO SONO CON VOI 2 PARTE' , '21' , '-21' , '4' , '2.80' , '2.8' , '0' , '15' , '49.98' ) 05/11/2025 02:31:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99700' , '11191' , 'VENITE CON ME 1 PARTE' , '19' , '-19' , '4' , '2.80' , '2.8' , '0' , '15' , '45.22' ) 05/11/2025 02:31:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99700' , '11192' , 'VENITE CON ME 2 PARTE' , '14' , '-14' , '4' , '2.80' , '2.8' , '0' , '15' , '33.32' ) 05/11/2025 03:04:53 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 05/11/2025 03:04:53 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24222' , '1' , '' , 'nuovo-prodotto' ) 05/11/2025 03:04:53 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '24222' , '1' , '1' , '2' , NOW() , NOW() ) 05/11/2025 03:04:53 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '24222' , '0' , '1' , '0' , '0' ) 05/11/2025 03:05:53 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825057225' AND id_product != '24222' AND ean13 != '' 05/11/2025 03:05:53 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/3', ean13 = '9788825057225', date_upd = NOW() WHERE id_product = '24222' 05/11/2025 03:05:53 pm >> UPDATE ps_product_lang SET name = 'PREGATE SEMPRE ', description = '' WHERE id_product = '24222' 05/11/2025 03:05:53 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '24222' 05/11/2025 03:05:53 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '17', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24222' 05/11/2025 03:05:53 pm >> DELETE FROM ps_specific_price WHERE id_product = '24222' 05/11/2025 03:05:54 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24222' 05/11/2025 03:05:54 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24223' , '1' , '' , 'nuovo-prodotto' ) 05/11/2025 03:05:54 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24223' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24222' 05/11/2025 03:05:54 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24223' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24222' 05/11/2025 03:06:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '714546' , '2025-11-04' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.43' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '83.41' , '83.41' , NOW() , NOW() ) 05/11/2025 03:06:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99701' 05/11/2025 03:06:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '99701' 05/11/2025 03:06:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99701' , '10684' , 'TORAH E STORIOGRAFIE DELLA. T. - 2 - CORSO STUDI BIBLICI - LOGOS' , '1' , '1' , '4' , '45.00' , '45' , '0' , '35' , '29.2500' ) 05/11/2025 03:06:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10684' AND id_supplier = '7' 05/11/2025 03:06:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10684' , '7' , '1' ) 05/11/2025 03:06:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99701' , '9338' , 'SACROSANCTUM CONCILIUM' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '33' , '1.6750' ) 05/11/2025 03:06:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9338' AND id_supplier = '7' 05/11/2025 03:06:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9338' , '7' , '1' ) 05/11/2025 03:06:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99701' , '3368' , 'DEI VERBUM' , '5' , '5' , '4' , '1.50' , '1.5' , '0' , '33' , '5.0250' ) 05/11/2025 03:06:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3368' AND id_supplier = '7' 05/11/2025 03:06:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3368' , '7' , '1' ) 05/11/2025 03:06:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99701' , '15545' , 'ATTI DEGLI APOSTOLI E LETTERE A CARATTERI GRANDI' , '1' , '1' , '4' , '9.00' , '9' , '0' , '30' , '6.3000' ) 05/11/2025 03:06:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15545' AND id_supplier = '7' 05/11/2025 03:06:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15545' , '7' , '1' ) 05/11/2025 03:06:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99701' , '17581' , 'MESSALE QUOTIDIANO N.E. ' , '1' , '1' , '4' , '39.00' , '39' , '0' , '33' , '26.1300' ) 05/11/2025 03:06:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17581' AND id_supplier = '7' 05/11/2025 03:06:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17581' , '7' , '1' ) 05/11/2025 03:06:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99701' , '24222' , 'PREGATE SEMPRE ' , '1' , '1' , '4' , '18.00' , '18' , '0' , '30' , '12.6000' ) 05/11/2025 03:06:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24222' AND id_supplier = '7' 05/11/2025 03:06:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24222' , '7' , '1' ) 05/11/2025 03:10:53 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281553798' AND id_product != '24223' AND ean13 != '' 05/11/2025 03:10:53 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/6', ean13 = '9791281553798', date_upd = NOW() WHERE id_product = '24223' 05/11/2025 03:10:53 pm >> UPDATE ps_product_lang SET name = 'PRESENZA REALE', description = '' WHERE id_product = '24223' 05/11/2025 03:10:53 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '24223' 05/11/2025 03:10:53 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '428', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24223' 05/11/2025 03:10:53 pm >> DELETE FROM ps_specific_price WHERE id_product = '24223' 05/11/2025 03:10:53 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24223' 05/11/2025 03:10:53 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24224' , '1' , '' , 'nuovo-prodotto' ) 05/11/2025 03:10:53 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24224' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24223' 05/11/2025 03:10:53 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24224' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24223' 05/11/2025 03:11:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259627025' AND id_product != '24224' AND ean13 != '' 05/11/2025 03:11:55 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791259627025', date_upd = NOW() WHERE id_product = '24224' 05/11/2025 03:11:55 pm >> UPDATE ps_product_lang SET name = 'LEONE XIV CHI DITE - INGRAO/PAGANO', description = '' WHERE id_product = '24224' 05/11/2025 03:11:55 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '17' WHERE id_product = '24224' 05/11/2025 03:11:55 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '17', id_tax_rules_group = '4', id_category_default = '143', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24224' 05/11/2025 03:11:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '24224' 05/11/2025 03:11:56 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24224' 05/11/2025 03:11:56 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24225' , '1' , '' , 'nuovo-prodotto' ) 05/11/2025 03:11:56 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24225' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24224' 05/11/2025 03:11:56 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24225' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24224' 05/11/2025 03:12:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832235883' AND id_product != '24225' AND ean13 != '' 05/11/2025 03:12:59 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/6', ean13 = '9788832235883', date_upd = NOW() WHERE id_product = '24225' 05/11/2025 03:12:59 pm >> UPDATE ps_product_lang SET name = 'FRANCESCO MAESTRO E FRATELLO - G. CESAREO', description = '' WHERE id_product = '24225' 05/11/2025 03:12:59 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9' WHERE id_product = '24225' 05/11/2025 03:12:59 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9', id_tax_rules_group = '4', id_category_default = '472', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24225' 05/11/2025 03:12:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '24225' 05/11/2025 03:13:00 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24225' 05/11/2025 03:13:00 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24226' , '1' , '' , 'nuovo-prodotto' ) 05/11/2025 03:13:00 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24226' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24225' 05/11/2025 03:13:00 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24226' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24225' 05/11/2025 03:13:57 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280061188' AND id_product != '24226' AND ean13 != '' 05/11/2025 03:13:57 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/6', ean13 = '9791280061188', date_upd = NOW() WHERE id_product = '24226' 05/11/2025 03:13:57 pm >> UPDATE ps_product_lang SET name = 'INTRODUZIONE ALLA ECCLESIOLOGIA - G. MILITELLO', description = '' WHERE id_product = '24226' 05/11/2025 03:13:57 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '24226' 05/11/2025 03:13:57 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '504', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24226' 05/11/2025 03:13:57 pm >> DELETE FROM ps_specific_price WHERE id_product = '24226' 05/11/2025 03:13:58 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24226' 05/11/2025 03:13:58 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24227' , '1' , '' , 'nuovo-prodotto' ) 05/11/2025 03:13:58 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24227' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24226' 05/11/2025 03:13:58 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24227' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24226' 05/11/2025 03:15:34 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873673606' AND id_product != '24227' AND ean13 != '' 05/11/2025 03:15:34 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/6', ean13 = '9788873673606', date_upd = NOW() WHERE id_product = '24227' 05/11/2025 03:15:34 pm >> UPDATE ps_product_lang SET name = 'RISVOLTI TEOLOGICI DELLA CARITA\' S. VINCENZO DE PAOLI - G. MARTINELLI', description = '' WHERE id_product = '24227' 05/11/2025 03:15:34 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '24227' 05/11/2025 03:15:34 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '380', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24227' 05/11/2025 03:15:34 pm >> DELETE FROM ps_specific_price WHERE id_product = '24227' 05/11/2025 03:15:35 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24227' 05/11/2025 03:15:35 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24228' , '1' , '' , 'nuovo-prodotto' ) 05/11/2025 03:15:35 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24228' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24227' 05/11/2025 03:15:35 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24228' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24227' 05/11/2025 03:16:58 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9790705108033' AND id_product != '24228' AND ean13 != '' 05/11/2025 03:16:59 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/6', ean13 = '9790705108033', date_upd = NOW() WHERE id_product = '24228' 05/11/2025 03:16:59 pm >> UPDATE ps_product_lang SET name = 'RITORNELLI SALMI RESPONSORIALI ANNO C - A. CIMINI', description = '' WHERE id_product = '24228' 05/11/2025 03:16:59 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '24228' 05/11/2025 03:16:59 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '174', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24228' 05/11/2025 03:16:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '24228' 05/11/2025 03:17:00 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24228' 05/11/2025 03:17:00 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24229' , '1' , '' , 'nuovo-prodotto' ) 05/11/2025 03:17:00 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24229' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24228' 05/11/2025 03:17:00 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24229' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24228' 05/11/2025 03:17:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9790705108002' AND id_product != '24229' AND ean13 != '' 05/11/2025 03:17:28 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/6', ean13 = '9790705108002', date_upd = NOW() WHERE id_product = '24229' 05/11/2025 03:17:28 pm >> UPDATE ps_product_lang SET name = 'RITORNELLI SALMI RESPONSORIALI ANNO A - A. CIMINI', description = '' WHERE id_product = '24229' 05/11/2025 03:17:28 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '24229' 05/11/2025 03:17:28 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '174', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24229' 05/11/2025 03:17:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '24229' 05/11/2025 03:17:29 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24229' 05/11/2025 03:17:29 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24230' , '1' , '' , 'nuovo-prodotto' ) 05/11/2025 03:17:29 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24230' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24229' 05/11/2025 03:17:29 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24230' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24229' 05/11/2025 03:17:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9790705108026' AND id_product != '24230' AND ean13 != '' 05/11/2025 03:17:47 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/6', ean13 = '9790705108026', date_upd = NOW() WHERE id_product = '24230' 05/11/2025 03:17:47 pm >> UPDATE ps_product_lang SET name = 'RITORNELLI SALMI RESPONSORIALI ANNO B - A. CIMINI', description = '' WHERE id_product = '24230' 05/11/2025 03:17:47 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '24230' 05/11/2025 03:17:47 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '174', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24230' 05/11/2025 03:17:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '24230' 05/11/2025 03:17:48 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24230' 05/11/2025 03:17:48 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24231' , '1' , '' , 'nuovo-prodotto' ) 05/11/2025 03:17:48 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24231' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24230' 05/11/2025 03:17:48 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24231' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24230' 05/11/2025 03:18:18 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '2025000004561' , '2025-11-04' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '77.35' , '77.35' , NOW() , NOW() ) 05/11/2025 03:18:18 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 = '99702' 05/11/2025 03:18:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '99702' 05/11/2025 03:18:18 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 ( '99702' , '24223' , 'PRESENZA REALE' , '1' , '1' , '4' , '15.00' , '15' , '0' , '35' , '9.7500' ) 05/11/2025 03:18:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24223' AND id_supplier = '107' 05/11/2025 03:18:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24223' , '107' , '1' ) 05/11/2025 03:18:18 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 ( '99702' , '24224' , 'LEONE XIV CHI DITE - INGRAO/PAGANO' , '1' , '1' , '4' , '17.00' , '17' , '0' , '35' , '11.0500' ) 05/11/2025 03:18:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24224' AND id_supplier = '107' 05/11/2025 03:18:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24224' , '107' , '1' ) 05/11/2025 03:18:18 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 ( '99702' , '24225' , 'FRANCESCO MAESTRO E FRATELLO - G. CESAREO' , '1' , '1' , '4' , '9.00' , '9' , '0' , '35' , '5.8500' ) 05/11/2025 03:18:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24225' AND id_supplier = '107' 05/11/2025 03:18:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24225' , '107' , '1' ) 05/11/2025 03:18:18 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 ( '99702' , '24226' , 'INTRODUZIONE ALLA ECCLESIOLOGIA - G. MILITELLO' , '1' , '1' , '4' , '18.00' , '18' , '0' , '35' , '11.7000' ) 05/11/2025 03:18:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24226' AND id_supplier = '107' 05/11/2025 03:18:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24226' , '107' , '1' ) 05/11/2025 03:18:18 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 ( '99702' , '24227' , 'RISVOLTI TEOLOGICI DELLA CARITA S. VINCENZO DE PAOLI - G. MARTINELLI' , '1' , '1' , '4' , '15.00' , '15' , '0' , '35' , '9.7500' ) 05/11/2025 03:18:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24227' AND id_supplier = '107' 05/11/2025 03:18:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24227' , '107' , '1' ) 05/11/2025 03:18:18 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 ( '99702' , '24229' , 'RITORNELLI SALMI RESPONSORIALI ANNO A - A. CIMINI' , '1' , '1' , '4' , '15.00' , '15' , '0' , '35' , '9.7500' ) 05/11/2025 03:18:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24229' AND id_supplier = '107' 05/11/2025 03:18:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24229' , '107' , '1' ) 05/11/2025 03:18:18 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 ( '99702' , '24230' , 'RITORNELLI SALMI RESPONSORIALI ANNO B - A. CIMINI' , '1' , '1' , '4' , '15.00' , '15' , '0' , '35' , '9.7500' ) 05/11/2025 03:18:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24230' AND id_supplier = '107' 05/11/2025 03:18:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24230' , '107' , '1' ) 05/11/2025 03:18:18 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 ( '99702' , '24228' , 'RITORNELLI SALMI RESPONSORIALI ANNO C - A. CIMINI' , '1' , '1' , '4' , '15.00' , '15' , '0' , '35' , '9.7500' ) 05/11/2025 03:18:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24228' AND id_supplier = '107' 05/11/2025 03:18:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24228' , '107' , '1' ) 05/11/2025 03:42:51 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4274' 05/11/2025 03:42:51 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4274' , '10' , '216' , 'PARROCCHIA SAN PAOLO DELLA CROCE' , 'FRACASSO' , 'P. LUCA' , 'VIALE MANCINI 28' , '' , '84024' , 'MANDURIA' , 'CONVENTO PASSIONISTI' , '' , '3282408839' , '' , '90013810735' , NOW() , NOW() ) 05/11/2025 03:42:51 pm >> UPDATE ps_customer SET email = 'fracassoluca78@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4274' 05/11/2025 03:49:01 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4274' 05/11/2025 03:49:01 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4274' , '10' , '216' , 'PARROCCHIA SAN PAOLO DELLA CROCE' , 'FRACASSO' , 'P. LUCA' , 'VIALE MANCINI 28' , '' , '84024' , 'MANDURIA' , 'CONVENTO PASSIONISTI' , '' , '3282408839' , '' , '90013810735' , NOW() , NOW() ) 05/11/2025 03:49:01 pm >> UPDATE ps_customer SET email = 'fracassoluca78@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4274' 05/11/2025 04:17:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '33/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-05') 05/11/2025 04:17:52 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 ( '23' , '33/L' , '2025-11-05' , 'L' , '4274' , '0' , '4679620' , 'VIALE MANCINI 28 84024 MANDURIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 05/11/2025 04:17:52 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 = '99703' 05/11/2025 04:17:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '99703' 05/11/2025 04:17:52 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 ( '99703' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '2' , '-2' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '60.00' ) 05/11/2025 04:21:06 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4274' 05/11/2025 04:21:06 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4274' , '10' , '216' , 'PARROCCHIA SAN PAOLO DELLA CROCE' , 'FRACASSO' , 'P. LUCA' , 'VIALE MANCINI 28' , '' , '84024' , 'MANDURIA' , 'CONVENTO PASSIONISTI' , '' , '3282408839' , '' , '90013810735' , NOW() , NOW() ) 05/11/2025 04:21:06 pm >> UPDATE ps_customer SET email = 'fracassoluca78@gmail.com', sdi = '000000', pec = '', date_upd = NOW() WHERE id_customer = '4274' 05/11/2025 04:38:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '51/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-05') 05/11/2025 04:38:50 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '22' , '51/E' , '2025-11-05' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '11556.23' , '11556.23' , NOW() , NOW() ) 05/11/2025 04:38:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99704' 05/11/2025 04:38:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '99704' 05/11/2025 04:38:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '4120' , 'FEDE NELLO ZAINETTO' , '52' , '0' , '4' , '6.00' , '6' , '0' , '50' , '156.00' ) 05/11/2025 04:38:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '20460' , 'AVE MARIA SPIEGATA AI BAMBINI' , '6' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '5.40' ) 05/11/2025 04:38:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '13463' , 'PREGHIERE DEI RAGAZZI - N.E.' , '53' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '39.75' ) 05/11/2025 04:38:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '15251' , 'FATE QUESTO IN MEMORIA DI ME' , '35' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '43.75' ) 05/11/2025 04:38:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '18049' , 'PADRE NOSTRO SPIEGATO AI BAMBINI' , '157' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '196.25' ) 05/11/2025 04:38:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '18597' , 'ROSARIO SPIEGATO AI BAMBINI' , '9' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '11.25' ) 05/11/2025 04:38:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '18357' , 'MIE PREGHIERINE N.E.' , '50' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '37.50' ) 05/11/2025 04:38:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '14330' , '100 GIORNI CON LO SPIRITO' , '1' , '0' , '4' , '7.50' , '7.5' , '0' , '50' , '3.75' ) 05/11/2025 04:38:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '17325' , 'ALLA SCOPERTA DELLA CASA DI GESU' , '2' , '0' , '4' , '3.00' , '3' , '0' , '50' , '3.00' ) 05/11/2025 04:38:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '2866' , 'GUARDALIBRI: DVD IL CREDO' , '4' , '0' , '4' , '9.90' , '9.9' , '0' , '50' , '19.80' ) 05/11/2025 04:38:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '15318' , 'PERDONAMI SIGNORE ' , '16' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '20.00' ) 05/11/2025 04:38:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '15602' , 'AMICO GESU ALBUM' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 05/11/2025 04:38:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '15743' , 'PREGHIERA DEL ROSARIO' , '14' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '17.50' ) 05/11/2025 04:38:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '17163' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI' , '24' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '30.00' ) 05/11/2025 04:38:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '13462' , 'SE MI AMI NON PIANGERE' , '18' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '16.20' ) 05/11/2025 04:38:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '13840' , 'NONNI SONO UN TESORO' , '4' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '3.60' ) 05/11/2025 04:38:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '16199' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '1' , '0' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 05/11/2025 04:38:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '14143' , 'SAN FRANCESCO DASSISI - RACCONTATO AI RAGAZZI' , '10' , '0' , '4' , '4.00' , '4' , '0' , '50' , '20.00' ) 05/11/2025 04:38:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '14487' , 'PREGHIERA DELLE 5 DITA' , '6' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '5.40' ) 05/11/2025 04:38:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '14145' , 'CREDO SPIEGATO AI RAGAZZI' , '33' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '41.25' ) 05/11/2025 04:38:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '25' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '31.25' ) 05/11/2025 04:38:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '17350' , 'NATALE SPIEGATO AI BAMBINI' , '8' , '0' , '4' , '3.00' , '3' , '0' , '50' , '12.00' ) 05/11/2025 04:38:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '21701' , 'NASCITA DI GESU' , '60' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '75.00' ) 05/11/2025 04:38:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '21700' , 'E NATO - N.E.' , '9' , '0' , '4' , '2.00' , '2' , '0' , '50' , '9.00' ) 05/11/2025 04:38:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '23934' , 'ANGELO DI DIO - N.E.' , '4' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '3.60' ) 05/11/2025 04:38:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '21650' , 'AVVENTO' , '11' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '13.75' ) 05/11/2025 04:38:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '17034' , 'SACRAMENTO DEL PERDONO' , '19' , '0' , '4' , '2.00' , '2' , '0' , '50' , '19.00' ) 05/11/2025 04:38:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '345' , '0' , '4' , '2.40' , '2.4' , '0' , '50' , '414.00' ) 05/11/2025 04:38:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '36' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '45.00' ) 05/11/2025 04:38:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '5446' , 'IO SONO CON VOI - GUIDA' , '11' , '0' , '4' , '8.00' , '8' , '0' , '50' , '44.00' ) 05/11/2025 04:38:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '11183' , 'VENITE CON ME - GUIDA' , '69' , '0' , '4' , '8.00' , '8' , '0' , '50' , '276.00' ) 05/11/2025 04:38:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '2' , '0' , '4' , '6.20' , '6.2' , '0' , '50' , '6.20' ) 05/11/2025 04:38:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '106' , 'A MESSA SALTANDO DI GIOIA - GUIDA' , '1' , '0' , '4' , '5.16' , '5.16' , '0' , '50' , '2.58' ) 05/11/2025 04:38:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '9675' , 'SARETE MIEI TESTIMONI' , '189' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '330.75' ) 05/11/2025 04:38:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1769' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '2476.60' ) 05/11/2025 04:38:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1593' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '2230.20' ) 05/11/2025 04:38:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '11191' , 'VENITE CON ME 1 PARTE' , '1937' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '2711.80' ) 05/11/2025 04:38:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '11192' , 'VENITE CON ME 2 PARTE' , '1559' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '2182.60' ) 05/11/2025 04:39:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '3662' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-05') 05/11/2025 04:39: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' , '3662' , '2025-11-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.90' , '6.48' , NOW() , NOW() ) 05/11/2025 04:39: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 = '99705' 05/11/2025 04:39:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '99705' 05/11/2025 04:39: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 ( '99705' , '1621' , 'CANDELE CONICHE 10 PZ' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 05/11/2025 04:55:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '51/E' AND id_document != '99704' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-05') 05/11/2025 04:55:54 pm >> UPDATE ps_document SET id_document_type = '22', document_num = '51/E', document_date = '2025-11-05', document_letter = 'E', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'VENDUTO OTTOBRE 2025', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '14', id_causal = '0', price_tax_included = '19087.13', price_tax_excluded = '19032.58', date_upd = NOW() WHERE id_document = '99704' 05/11/2025 04:55:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99704' 05/11/2025 04:55:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '99704' 05/11/2025 04:55:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '4120' , 'FEDE NELLO ZAINETTO' , '52' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '156.00' ) 05/11/2025 04:55:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99704' , '20460' , 'AVE MARIA SPIEGATA AI BAMBINI' , '6' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '5.40' ) 05/11/2025 04:55: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 ( '99704' , '13463' , 'PREGHIERE DEI RAGAZZI - N.E.' , '53' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '39.75' ) 05/11/2025 04:55: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 ( '99704' , '15251' , 'FATE QUESTO IN MEMORIA DI ME' , '35' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '43.75' ) 05/11/2025 04:55: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 ( '99704' , '18049' , 'PADRE NOSTRO SPIEGATO AI BAMBINI' , '157' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '196.25' ) 05/11/2025 04:55: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 ( '99704' , '18597' , 'ROSARIO SPIEGATO AI BAMBINI' , '9' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '11.25' ) 05/11/2025 04:55: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 ( '99704' , '18357' , 'MIE PREGHIERINE N.E.' , '50' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '37.50' ) 05/11/2025 04:55: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 ( '99704' , '14330' , '100 GIORNI CON LO SPIRITO' , '1' , '0' , '4' , '7.5000' , '7.5' , '0' , '50' , '3.75' ) 05/11/2025 04:55: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 ( '99704' , '17325' , 'ALLA SCOPERTA DELLA CASA DI GESU' , '2' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '3.00' ) 05/11/2025 04:55: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 ( '99704' , '2866' , 'GUARDALIBRI: DVD IL CREDO' , '4' , '0' , '4' , '9.9000' , '9.9' , '0' , '50' , '19.80' ) 05/11/2025 04:55: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 ( '99704' , '15318' , 'PERDONAMI SIGNORE ' , '16' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '20.00' ) 05/11/2025 04:55: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 ( '99704' , '15602' , 'AMICO GESU ALBUM' , '1' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '1.00' ) 05/11/2025 04:55: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 ( '99704' , '15743' , 'PREGHIERA DEL ROSARIO' , '14' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '17.50' ) 05/11/2025 04:55: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 ( '99704' , '17163' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI' , '24' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '30.00' ) 05/11/2025 04:55: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 ( '99704' , '13462' , 'SE MI AMI NON PIANGERE' , '18' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '16.20' ) 05/11/2025 04:55: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 ( '99704' , '13840' , 'NONNI SONO UN TESORO' , '4' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '3.60' ) 05/11/2025 04:55: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 ( '99704' , '16199' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '1' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '1.50' ) 05/11/2025 04:55: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 ( '99704' , '14143' , 'SAN FRANCESCO DASSISI - RACCONTATO AI RAGAZZI' , '10' , '0' , '4' , '4.0000' , '4' , '0' , '50' , '20.00' ) 05/11/2025 04:55: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 ( '99704' , '14487' , 'PREGHIERA DELLE 5 DITA' , '6' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '5.40' ) 05/11/2025 04:55: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 ( '99704' , '14145' , 'CREDO SPIEGATO AI RAGAZZI' , '33' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '41.25' ) 05/11/2025 04:55: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 ( '99704' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '25' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '31.25' ) 05/11/2025 04:55: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 ( '99704' , '17350' , 'NATALE SPIEGATO AI BAMBINI' , '8' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '12.00' ) 05/11/2025 04:55: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 ( '99704' , '21701' , 'NASCITA DI GESU' , '60' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '75.00' ) 05/11/2025 04:55: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 ( '99704' , '21700' , 'E NATO - N.E.' , '9' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '9.00' ) 05/11/2025 04:55: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 ( '99704' , '23934' , 'ANGELO DI DIO - N.E.' , '4' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '3.60' ) 05/11/2025 04:55: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 ( '99704' , '21650' , 'AVVENTO' , '11' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '13.75' ) 05/11/2025 04:55: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 ( '99704' , '17034' , 'SACRAMENTO DEL PERDONO' , '19' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '19.00' ) 05/11/2025 04:55: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 ( '99704' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '345' , '0' , '4' , '2.4000' , '2.4' , '0' , '50' , '414.00' ) 05/11/2025 04:55: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 ( '99704' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '36' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '45.00' ) 05/11/2025 04:55: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 ( '99704' , '5446' , 'IO SONO CON VOI - GUIDA' , '11' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '44.00' ) 05/11/2025 04:55: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 ( '99704' , '11183' , 'VENITE CON ME - GUIDA' , '69' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '276.00' ) 05/11/2025 04:55: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 ( '99704' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '2' , '0' , '4' , '6.2000' , '6.2' , '0' , '50' , '6.20' ) 05/11/2025 04:55: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 ( '99704' , '106' , 'A MESSA SALTANDO DI GIOIA - GUIDA' , '1' , '0' , '4' , '5.1600' , '5.16' , '0' , '50' , '2.58' ) 05/11/2025 04:55: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 ( '99704' , '9675' , 'SARETE MIEI TESTIMONI' , '189' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '330.75' ) 05/11/2025 04:55: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 ( '99704' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1769' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '2476.60' ) 05/11/2025 04:55: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 ( '99704' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1593' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '2230.20' ) 05/11/2025 04:55: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 ( '99704' , '11191' , 'VENITE CON ME 1 PARTE' , '1937' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '2711.80' ) 05/11/2025 04:55: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 ( '99704' , '11192' , 'VENITE CON ME 2 PARTE' , '1559' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '2182.60' ) 05/11/2025 04:55: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 ( '99704' , '1882' , 'CELEBRAZIONI PER LANNO CATECHISTICO' , '6' , '0' , '4' , '10.00' , '10' , '0' , '50' , '30.00' ) 05/11/2025 04:55: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 ( '99704' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '215' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '376.25' ) 05/11/2025 04:55: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 ( '99704' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '6' , '0' , '4' , '8.00' , '8' , '0' , '50' , '24.00' ) 05/11/2025 04:55: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 ( '99704' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '1' , '0' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 05/11/2025 04:55: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 ( '99704' , '1872' , 'CELEBRARE LA PAROLA - ANNO A' , '2' , '0' , '4' , '10.00' , '10' , '0' , '50' , '10.00' ) 05/11/2025 04:55: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 ( '99704' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '1' , '0' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 05/11/2025 04:55: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 ( '99704' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '53' , '0' , '4' , '8.00' , '8' , '0' , '50' , '212.00' ) 05/11/2025 04:55: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 ( '99704' , '6629' , 'MIA PREGHIERA' , '205' , '0' , '4' , '0.90' , '0.9' , '0' , '50' , '92.25' ) 05/11/2025 04:55: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 ( '99704' , '8408' , 'PRENDETE E MANGIATE' , '537' , '0' , '4' , '3.00' , '3' , '0' , '50' , '805.50' ) 05/11/2025 04:55: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 ( '99704' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '26' , '0' , '4' , '5.00' , '5' , '0' , '50' , '65.00' ) 05/11/2025 04:55: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 ( '99704' , '4154' , 'FESTA DEL PERDONO' , '820' , '0' , '4' , '3.00' , '3' , '0' , '50' , '1230.00' ) 05/11/2025 04:55: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 ( '99704' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '39' , '0' , '4' , '5.00' , '5' , '0' , '50' , '97.50' ) 05/11/2025 04:55: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 ( '99704' , '2679' , 'CONOSCERE GESU' , '746' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '1305.50' ) 05/11/2025 04:55: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 ( '99704' , '2680' , 'CONOSCERE GESU - GUIDA' , '18' , '0' , '4' , '6.00' , '6' , '0' , '50' , '54.00' ) 05/11/2025 04:55: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 ( '99704' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '2' , '0' , '4' , '5.00' , '5' , '0' , '50' , '5.00' ) 05/11/2025 04:55: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 ( '99704' , '11102' , 'VANGELO E ATTI DEGLI APOSTOLI - RIL.' , '2' , '0' , '4' , '8.50' , '8.5' , '0' , '50' , '8.50' ) 05/11/2025 04:55: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 ( '99704' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '8' , '0' , '4' , '5.00' , '5' , '0' , '50' , '20.00' ) 05/11/2025 04:55: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 ( '99704' , '10364' , 'SULLA STRADA DEL MAESTRO' , '1' , '0' , '4' , '14.00' , '14' , '0' , '50' , '7.00' ) 05/11/2025 04:55: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 ( '99704' , '1833' , 'CATECHISTA: VOCAZIONE E MISSIONE ' , '1' , '0' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 05/11/2025 04:55: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 ( '99704' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '2' , '0' , '4' , '25.00' , '25' , '0' , '50' , '25.00' ) 05/11/2025 04:55: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 ( '99704' , '7543' , 'PARABOLE DI GESÙ' , '23' , '0' , '4' , '3.00' , '3' , '0' , '50' , '34.50' ) 05/11/2025 04:55: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 ( '99704' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '67' , '0' , '4' , '3.80' , '3.8' , '0' , '50' , '127.30' ) 05/11/2025 04:55: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 ( '99704' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '46' , '0' , '4' , '3.80' , '3.8' , '0' , '50' , '87.40' ) 05/11/2025 04:55: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 ( '99704' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '51' , '0' , '4' , '3.80' , '3.8' , '0' , '50' , '96.90' ) 05/11/2025 04:55: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 ( '99704' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '3' , '0' , '4' , '10.00' , '10' , '0' , '50' , '15.00' ) 05/11/2025 04:55: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 ( '99704' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '3' , '0' , '4' , '10.00' , '10' , '0' , '50' , '15.00' ) 05/11/2025 04:55: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 ( '99704' , '12819' , 'REGISTRO DEL CATECHISTA ' , '605' , '0' , '1' , '1.00' , '0.81967213114754' , '22' , '50' , '302.50' ) 05/11/2025 04:55: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 ( '99704' , '12813' , 'MARIA MADRE NOSTRA' , '2' , '0' , '4' , '3.00' , '3' , '0' , '50' , '3.00' ) 05/11/2025 04:55: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 ( '99704' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 05/11/2025 04:55: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 ( '99704' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '10' , '0' , '4' , '6.00' , '6' , '0' , '50' , '30.00' ) 05/11/2025 04:55: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 ( '99704' , '13397' , 'MIO GESU' , '69' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '120.75' ) 05/11/2025 04:55: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 ( '99704' , '14223' , 'PRONTUARIO BIBLICO - LITURGICO - F. GIGLIO' , '2' , '0' , '4' , '9.00' , '9' , '0' , '50' , '9.00' ) 05/11/2025 04:55: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 ( '99704' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '134' , '0' , '4' , '1.00' , '1' , '0' , '50' , '67.00' ) 05/11/2025 04:55: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 ( '99704' , '15019' , 'PREGHIAMO CON MARIA' , '2' , '0' , '4' , '0.80' , '0.8' , '0' , '50' , '0.80' ) 05/11/2025 04:55: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 ( '99704' , '15020' , 'PREGARE OGNI GIORNO' , '46' , '0' , '4' , '1.00' , '1' , '0' , '50' , '23.00' ) 05/11/2025 04:55: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 ( '99704' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '1' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 05/11/2025 04:55: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 ( '99704' , '17257' , 'IO TI BATTEZZO ' , '65' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '58.50' ) 05/11/2025 04:55: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 ( '99704' , '17697' , 'SANTO ROSARIO CON SAN CESARE DE BUS' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 05/11/2025 04:55: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 ( '99704' , '18175' , 'VIA DI SAN GIUSEPPE - G. POLIDORO' , '1' , '0' , '4' , '4.80' , '4.8' , '0' , '50' , '2.40' ) 05/11/2025 04:55: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 ( '99704' , '18176' , 'ANTIQUUM MINISTERIUM ' , '6' , '0' , '4' , '1.00' , '1' , '0' , '50' , '3.00' ) 05/11/2025 04:55: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 ( '99704' , '18460' , 'CON CUORE DI PADRE - V. SALVOLDI' , '9' , '0' , '4' , '2.00' , '2' , '0' , '50' , '9.00' ) 05/11/2025 04:55: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 ( '99704' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '139' , '0' , '4' , '1.90' , '1.9' , '0' , '50' , '132.05' ) 05/11/2025 04:55: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 ( '99704' , '18527' , 'SOGNI DI PACE - V. SALVOLDI' , '8' , '0' , '4' , '2.00' , '2' , '0' , '50' , '8.00' ) 05/11/2025 04:55: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 ( '99704' , '18657' , 'HO DATO LORO LA TUA PAROLA - TEMPI FORTI- G. VALSECCHI' , '1' , '0' , '4' , '16.00' , '16' , '0' , '50' , '8.00' ) 05/11/2025 04:55: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 ( '99704' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '11' , '0' , '4' , '7.00' , '7' , '0' , '50' , '38.50' ) 05/11/2025 04:55: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 ( '99704' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '11' , '0' , '4' , '9.00' , '9' , '0' , '50' , '49.50' ) 05/11/2025 04:55: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 ( '99704' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '11' , '0' , '4' , '9.00' , '9' , '0' , '50' , '49.50' ) 05/11/2025 04:55: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 ( '99704' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '11' , '0' , '4' , '9.00' , '9' , '0' , '50' , '49.50' ) 05/11/2025 04:55: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 ( '99704' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '1' , '0' , '4' , '12.00' , '12' , '0' , '50' , '6.00' ) 05/11/2025 04:55: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 ( '99704' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '5' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 05/11/2025 04:55: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 ( '99704' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '3' , '0' , '4' , '35.00' , '35' , '0' , '50' , '52.50' ) 05/11/2025 04:55: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 ( '99704' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE - SALVOLDI' , '5' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 05/11/2025 04:55: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 ( '99704' , '20722' , 'SEMINATORI DI GIOIA' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 05/11/2025 04:55: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 ( '99704' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '5' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 05/11/2025 04:55: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 ( '99704' , '21417' , 'VIENI, NON TARDARE SIGNORE, NOSTRA PACE!' , '4' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '5.00' ) 05/11/2025 04:55: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 ( '99704' , '21644' , 'INCONTRO AL DIO CHE VIENE' , '2' , '0' , '4' , '8.00' , '8' , '0' , '50' , '8.00' ) 05/11/2025 04:55: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 ( '99704' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '342' , '0' , '4' , '3.00' , '3' , '0' , '50' , '513.00' ) 05/11/2025 04:55: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 ( '99704' , '22029' , 'PREPARIAMOCI ALLA PRIMA CONFESSIONE - POSTER' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 05/11/2025 04:55: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 ( '99704' , '22030' , 'PREPARIAMOCI ALLA PRIMA COMUNIONE - POSTER' , '2' , '0' , '4' , '2.00' , '2' , '0' , '50' , '2.00' ) 05/11/2025 04:55: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 ( '99704' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '16' , '0' , '4' , '8.00' , '8' , '0' , '50' , '64.00' ) 05/11/2025 04:55: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 ( '99704' , '21418' , 'CRISTO NOSTRA PACE - V. SALVORDI' , '6' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '7.50' ) 05/11/2025 04:55: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 ( '99704' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '32' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '44.80' ) 05/11/2025 04:55: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 ( '99704' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '61' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '85.40' ) 05/11/2025 04:55: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 ( '99704' , '20951' , 'STORIE DEL NOSTRO TEMPO - F. CERRI' , '1' , '0' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 05/11/2025 04:55: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 ( '99704' , '23092' , 'SPERANZA CHE E IN NOI' , '7' , '0' , '4' , '3.00' , '3' , '0' , '50' , '10.50' ) 05/11/2025 04:55: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 ( '99704' , '23347' , 'PREGHIERA DEL ROSARIO' , '23' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '28.75' ) 05/11/2025 04:55: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 ( '99704' , '22809' , 'O LUCE BEATISSIMA' , '30' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '37.50' ) 05/11/2025 04:55: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 ( '99704' , '22871' , 'SPERANZA NON DELUDE - M. DE ROSA' , '3' , '0' , '4' , '8.00' , '8' , '0' , '50' , '12.00' ) 05/11/2025 04:55: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 ( '99704' , '22961' , 'UN BAMBINO E NATO PER NOI - G. VALSECCHI' , '58' , '0' , '4' , '3.00' , '3' , '0' , '50' , '87.00' ) 05/11/2025 04:55: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 ( '99704' , '23032' , 'MIO LIBRO DI PREGHIERE - N. E. ' , '74' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '103.60' ) 05/11/2025 04:55: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 ( '99704' , '23271' , 'OMELIA, ECO DELLA PAROLA DI DIO - R. RAMPOLLA' , '1' , '0' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 05/11/2025 04:55: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 ( '99704' , '23420' , 'SPERANZA. PER VIVERE NELLA GIOIA - R. LUPI' , '17' , '0' , '4' , '3.00' , '3' , '0' , '50' , '25.50' ) 05/11/2025 04:55: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 ( '99704' , '23677' , 'RICETTE DI MAMMA ROSA' , '3' , '0' , '4' , '20.00' , '20' , '0' , '50' , '30.00' ) 05/11/2025 04:55: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 ( '99704' , '23870' , 'RAGAZZO DEL LENZUOLO - M. VIANI' , '13' , '0' , '4' , '10.00' , '10' , '0' , '50' , '65.00' ) 05/11/2025 04:55: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 ( '99704' , '23674' , 'DONO DI GRAZIA - V. SIRACUSA' , '12' , '0' , '4' , '5.00' , '5' , '0' , '50' , '30.00' ) 05/11/2025 04:55: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 ( '99704' , '23673' , 'RIVESTITI DI SPERANZA! - V. SIRACUSA' , '73' , '0' , '4' , '5.00' , '5' , '0' , '50' , '182.50' ) 05/11/2025 04:55: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 ( '99704' , '23954' , 'SAN BARTOLO LONGO ' , '69' , '0' , '4' , '10.00' , '10' , '0' , '50' , '345.00' ) 05/11/2025 04:55: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 ( '99704' , '24129' , 'DIECI COMANDAMENTI - M. DE ROSA' , '7' , '0' , '4' , '6.00' , '6' , '0' , '50' , '21.00' ) 05/11/2025 04:55: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 ( '99704' , '23721' , 'BEATITUDINI - M. DE ROSA' , '3' , '0' , '4' , '8.00' , '8' , '0' , '50' , '12.00' ) 05/11/2025 05:10:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '3663' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-05') 05/11/2025 05:10:11 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' , '3663' , '2025-11-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.71' , '100.71' , NOW() , NOW() ) 05/11/2025 05:10:11 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 = '99706' 05/11/2025 05:10:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '99706' 05/11/2025 05:10:11 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 ( '99706' , '11188' , 'VENITE CON ME - GUIDA 2 - MAGNIFICAT' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 05/11/2025 05:10:11 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 ( '99706' , '11187' , 'VENITE CON ME - GUIDA 1 - MAGNIFICAT' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 05/11/2025 05:10:11 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 ( '99706' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '5' , '-5' , '4' , '3.00' , '3' , '0' , '5' , '14.25' ) 05/11/2025 05:10:11 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 ( '99706' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '5' , '-5' , '4' , '3.00' , '3' , '0' , '5' , '14.25' ) 05/11/2025 05:10:11 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 ( '99706' , '5450' , 'IO SONO CON VOI - GUIDA 1 - MAGNIFICAT' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 05/11/2025 05:10:11 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 ( '99706' , '5451' , 'IO SONO CON VOI - GUIDA 2 - MAGNIFICAT' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 05/11/2025 05:10:11 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 ( '99706' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '5' , '-5' , '4' , '3.00' , '3' , '0' , '5' , '14.25' ) 05/11/2025 05:10:11 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 ( '99706' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '2' , '-2' , '4' , '3.00' , '3' , '0' , '5' , '5.70' ) 05/11/2025 05:10:11 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 ( '99706' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '2' , '-2' , '4' , '3.50' , '3.5' , '0' , '5' , '6.66' ) 05/11/2025 05:17:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '52/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-05') 05/11/2025 05:17:26 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '25' , '52/E' , '2025-11-05' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RESA OTTOBRE 2025' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '210.55' , '210.55' , NOW() , NOW() ) 05/11/2025 05:17:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99707' 05/11/2025 05:17:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '99707' 05/11/2025 05:17:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99707' , '5457' , 'IO SONO CON VOI 1 PARTE' , '4' , '4' , '4' , '2.80' , '2.8' , '0' , '50' , '5.60' ) 05/11/2025 05:17:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99707' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '11' , '11' , '4' , '3.40' , '3.4' , '0' , '50' , '18.70' ) 05/11/2025 05:17:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99707' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '1' , '1' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 05/11/2025 05:17:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99707' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '1' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 05/11/2025 05:17:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99707' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '1' , '1' , '4' , '25.00' , '25' , '0' , '50' , '12.50' ) 05/11/2025 05:17:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99707' , '7543' , 'PARABOLE DI GESÙ' , '5' , '5' , '4' , '3.00' , '3' , '0' , '50' , '7.50' ) 05/11/2025 05:17:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99707' , '12813' , 'MARIA MADRE NOSTRA' , '2' , '2' , '4' , '3.00' , '3' , '0' , '50' , '3.00' ) 05/11/2025 05:17:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99707' , '13956' , 'MIRACOLI DI GESU' , '4' , '4' , '4' , '3.00' , '3' , '0' , '50' , '6.00' ) 05/11/2025 05:17:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99707' , '18657' , 'HO DATO LORO LA TUA PAROLA - TEMPI FORTI- G. VALSECCHI' , '1' , '1' , '4' , '16.00' , '16' , '0' , '50' , '8.00' ) 05/11/2025 05:17:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99707' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '1' , '1' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 05/11/2025 05:17:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99707' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '1' , '1' , '4' , '4.50' , '4.5' , '0' , '50' , '2.25' ) 05/11/2025 05:17:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99707' , '20721' , 'AVE MARIA - L. CALABRETTA' , '1' , '1' , '4' , '4.50' , '4.5' , '0' , '50' , '2.25' ) 05/11/2025 05:17:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99707' , '22034' , 'MISTERI DEL ROSARIO - M. DE ROSA' , '1' , '1' , '4' , '8.00' , '8' , '0' , '50' , '4.00' ) 05/11/2025 05:17:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99707' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '1' , '1' , '4' , '2.80' , '2.8' , '0' , '50' , '1.40' ) 05/11/2025 05:17:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99707' , '22152' , 'A TE RICORRIAMO' , '8' , '8' , '4' , '3.00' , '3' , '0' , '50' , '12.00' ) 05/11/2025 05:17:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99707' , '23092' , 'SPERANZA CHE E IN NOI' , '3' , '3' , '4' , '3.00' , '3' , '0' , '50' , '4.50' ) 05/11/2025 05:17:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99707' , '23348' , 'ECCE LIGNUM CRUCIS - V. SIRACUSA' , '11' , '11' , '4' , '3.00' , '3' , '0' , '50' , '16.50' ) 05/11/2025 05:17:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99707' , '22871' , 'SPERANZA NON DELUDE - M. DE ROSA' , '6' , '6' , '4' , '8.00' , '8' , '0' , '50' , '24.00' ) 05/11/2025 05:17:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99707' , '23032' , 'MIO LIBRO DI PREGHIERE - N. E. ' , '10' , '10' , '4' , '2.80' , '2.8' , '0' , '50' , '14.00' ) 05/11/2025 05:17:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99707' , '23420' , 'SPERANZA. PER VIVERE NELLA GIOIA - R. LUPI' , '4' , '4' , '4' , '3.00' , '3' , '0' , '50' , '6.00' ) 05/11/2025 05:17:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99707' , '23380' , 'DAL TUO CUORE TRAFITTO E GLORIOSO LA NOSTRA GIOIA E LA NOSTRA SPERANZA' , '5' , '5' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 05/11/2025 05:17:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99707' , '23674' , 'DONO DI GRAZIA - V. SIRACUSA' , '6' , '6' , '4' , '5.00' , '5' , '0' , '50' , '15.00' ) 05/11/2025 05:17:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99707' , '23673' , 'RIVESTITI DI SPERANZA! - V. SIRACUSA' , '3' , '3' , '4' , '5.00' , '5' , '0' , '50' , '7.50' ) 05/11/2025 05:17:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99707' , '23721' , 'BEATITUDINI - M. DE ROSA' , '4' , '4' , '4' , '8.00' , '8' , '0' , '50' , '16.00' ) 05/11/2025 05:17:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99707' , '18627' , 'GIOVEDI\' SANTO' , '3' , '3' , '4' , '1.50' , '1.5' , '0' , '50' , '2.25' ) 05/11/2025 05:17:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99707' , '20460' , 'AVE MARIA SPIEGATA AI BAMBINI' , '3' , '3' , '4' , '1.80' , '1.8' , '0' , '50' , '2.70' ) 05/11/2025 05:17:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99707' , '13463' , 'PREGHIERE DEI RAGAZZI - N.E.' , '3' , '3' , '4' , '1.50' , '1.5' , '0' , '50' , '2.25' ) 05/11/2025 05:17:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99707' , '13840' , 'NONNI SONO UN TESORO' , '1' , '1' , '4' , '1.80' , '1.8' , '0' , '50' , '0.90' ) 05/11/2025 05:17:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99707' , '14145' , 'CREDO SPIEGATO AI RAGAZZI' , '2' , '2' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 05/11/2025 05:17:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99707' , '17034' , 'SACRAMENTO DEL PERDONO' , '1' , '1' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 05/11/2025 05:40:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '24' AND id_document != '99150' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2025-10-09') 05/11/2025 05:40:29 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '24', document_date = '2025-10-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669100', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'RESA- n. c. ric € 102,58', 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 = '157.80', price_tax_excluded = '157.80', date_upd = NOW() WHERE id_document = '99150' 05/11/2025 05:40:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99150' 05/11/2025 05:40:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '99150' 05/11/2025 05:40:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99150' , '16641' , 'PREGHIERA - P. COLLINS' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 05/11/2025 05:40:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99150' , '22277' , 'DIVINA PERCEPTIO - J. REGO' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 05/11/2025 05:40:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99150' , '23410' , 'TRIDUO PASQUALE PER NOI E PER IL MONDO - G. FLORIO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 05/11/2025 05:40:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99150' , '17203' , 'LASCIATI CONDURRE DA MARIA - M. REALE' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 05/11/2025 05:40:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99150' , '22680' , 'LUCE DI GRAZIA - M. DI LORENZO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 05/11/2025 05:40:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99150' , '21464' , 'NELLA COMUNIONE DELLA SS TRINITA - D. COGONI' , '1' , '-1' , '4' , '17.9000' , '17.9' , '0' , '0' , '17.90' ) 05/11/2025 05:40:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99150' , '20859' , 'VOI CHI DITE CHE IO SIA - C. SOLMONESE ' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 05/11/2025 05:40:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99150' , '21462' , 'DIO IN CUI CREDIAMO - M. LAVRA' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 05/11/2025 05:40:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99150' , '21072' , 'INSEGNACI A PREGARE - A. BARBI' , '1' , '-1' , '4' , '22.9000' , '22.9' , '0' , '0' , '22.90' ) 05/11/2025 05:40:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99150' , '23409' , 'VIA CRUCIS DEL GIUBILEO - RUCCIA/SCALERA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 05/11/2025 05:40:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99150' , '24031' , 'MISIONEROS DIGITALE - H. G. ARIAS' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 05/11/2025 05:51:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '197' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-05') 05/11/2025 05:51: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 ( '21' , '197' , '2025-11-05' , '' , '586' , '0' , '4676029' , 'P.ZZA MADONNA DI FATIMA 3 83031 ARIANO IRPINO' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.35' , '48.35' , NOW() , NOW() ) 05/11/2025 05:51: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 = '99708' 05/11/2025 05:51:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '99708' 05/11/2025 05:51: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 ( '99708' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '20' , '-20' , '4' , '2.40' , '2.4' , '0' , '15' , '40.80' ) 05/11/2025 05:51: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 ( '99708' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '15' , '2.55' ) 05/11/2025 05:52:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '197' AND id_document != '99708' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-05') 05/11/2025 05:52:45 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '197', document_date = '2025-11-05', document_letter = '', id_customer = '586', id_supplier = '', id_address = '4676029', address1 = 'P.ZZA MADONNA DI FATIMA 3 83031 ARIANO IRPINO', address2 = '', note = '', price_shipping = '5.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '48.35', price_tax_excluded = '48.35', date_upd = NOW() WHERE id_document = '99708' 05/11/2025 05:52:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99708' 05/11/2025 05:52:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '99708' 05/11/2025 05:52:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99708' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '20' , '-20' , '4' , '2.4000' , '2.4' , '0' , '15' , '40.80' ) 05/11/2025 05:52:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99708' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '15' , '2.55' ) 05/11/2025 07:01:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '3664' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-05') 05/11/2025 07:01:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3664' , '2025-11-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '62.00' , '50.82' , NOW() , NOW() ) 05/11/2025 07:01:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99709' 05/11/2025 07:01:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '99709' 05/11/2025 07:01:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99709' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '25' , '20.491803278689' , '22' , '' , '25.00' ) 05/11/2025 07:01:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99709' , '19880' , 'CROCE CM 25 ARGENTO - 4975/837' , '1' , '-1' , '1' , '37' , '30.327868852459' , '22' , '0' , '37.00' ) 05/11/2025 07:04:15 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4274' 05/11/2025 07:04:15 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4274' , '10' , '216' , 'PARROCCHIA SAN PAOLO DELLA CROCE' , 'FRACASSO' , 'P. LUCA' , 'VIALE MANCINI 28' , '' , '74024' , 'MANDURIA' , 'CONVENTO PASSIONISTI' , '' , '3282408839' , '' , '90013810735' , NOW() , NOW() ) 05/11/2025 07:04:15 pm >> UPDATE ps_customer SET email = 'fracassoluca78@gmail.com', sdi = '000000', pec = '', date_upd = NOW() WHERE id_customer = '4274' 05/11/2025 07:22:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '3665' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-05') 05/11/2025 07:22:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3665' , '2025-11-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '3.00' , NOW() , NOW() ) 05/11/2025 07:22:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99710' 05/11/2025 07:22:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '99710' 05/11/2025 07:22:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99710' , '3368' , 'DEI VERBUM' , '2' , '-2' , '4' , '1.50' , '1.5' , '0' , '0' , '3.00' ) 05/11/2025 07:30:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '3666' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-05') 05/11/2025 07:30:17 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' , '3666' , '2025-11-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.70' , '3.70' , NOW() , NOW() ) 05/11/2025 07:30:17 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 = '99711' 05/11/2025 07:30:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '99711' 05/11/2025 07:30:17 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 ( '99711' , '3368' , 'DEI VERBUM' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 05/11/2025 07:30:17 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 ( '99711' , '529' , 'AMORIS LAETITIA' , '1' , '-1' , '4' , '2.20' , '2.2' , '0' , '0' , '2.20' ) 05/11/2025 07:35:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '3667' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-05') 05/11/2025 07:35:20 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' , '3667' , '2025-11-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '16.39' , NOW() , NOW() ) 05/11/2025 07:35:20 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 = '99712' 05/11/2025 07:35:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '99712' 05/11/2025 07:35:20 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 ( '99712' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 05/11/2025 07:40:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '3667' AND id_document != '99712' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-05') 05/11/2025 07:40:40 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3667', document_date = '2025-11-05', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '20.00', price_tax_excluded = '16.39', date_upd = NOW() WHERE id_document = '99712' 05/11/2025 07:40: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 = '99712' 05/11/2025 07:40:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '99712' 05/11/2025 07:40: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 ( '99712' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 05/11/2025 07:40: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 ( '99712' , '17617' , 'IMMAGINI ISONZO X 100' , '5' , '-5' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '17.50' )