22/05/2025 10:04:52 am >> SELECT document_num FROM ps_document WHERE document_num = '1787' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-22') 22/05/2025 10:04:52 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1787' , '2025-05-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '115.70' , '94.84' , NOW() , NOW() ) 22/05/2025 10:04:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97319' 22/05/2025 10:04:52 am >> DELETE FROM ps_document_detail WHERE id_document = '97319' 22/05/2025 10:04:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97319' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '47' , '-47' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '32.90' ) 22/05/2025 10:04:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97319' , '22658' , 'CROCE PADRE NOSTRO - 646/PN' , '46' , '-46' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '82.80' ) 22/05/2025 10:48:02 am >> SELECT document_num FROM ps_document WHERE document_num = '1788' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-22') 22/05/2025 10:48:02 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1788' , '2025-05-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '44.00' , '36.07' , NOW() , NOW() ) 22/05/2025 10:48:02 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97320' 22/05/2025 10:48:02 am >> DELETE FROM ps_document_detail WHERE id_document = '97320' 22/05/2025 10:48:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97320' , '18898' , 'BRACCIALE DECINA LEGNO - BC1745' , '20' , '-20' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '44.00' ) 22/05/2025 11:02:28 am >> SELECT document_num FROM ps_document WHERE document_num = '1789' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-22') 22/05/2025 11:02:28 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1789' , '2025-05-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.00' , '22.13' , NOW() , NOW() ) 22/05/2025 11:02:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97321' 22/05/2025 11:02:28 am >> DELETE FROM ps_document_detail WHERE id_document = '97321' 22/05/2025 11:02:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97321' , '11805' , 'TECA IHS - 823' , '1' , '-1' , '1' , '27.00' , '22.131147540984' , '22' , '0' , '27.00' ) 22/05/2025 11:06:50 am >> SELECT document_num FROM ps_document WHERE document_num = '1765' AND id_document != '97295' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-20') 22/05/2025 11:06:50 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1765', document_date = '2025-05-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '37.05', price_tax_excluded = '37.05', date_upd = NOW() WHERE id_document = '97295' 22/05/2025 11:06:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97295' 22/05/2025 11:06:50 am >> DELETE FROM ps_document_detail WHERE id_document = '97295' 22/05/2025 11:06:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97295' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '37.05' , '37.05' , '0' , '0' , '37.05' ) 22/05/2025 11:07:20 am >> SELECT document_num FROM ps_document WHERE document_num = '1356' AND id_document != '96819' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-23') 22/05/2025 11:07:20 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1356', document_date = '2025-04-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '55.00', price_tax_excluded = '45.08', date_upd = NOW() WHERE id_document = '96819' 22/05/2025 11:07: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 = '96819' 22/05/2025 11:07:20 am >> DELETE FROM ps_document_detail WHERE id_document = '96819' 22/05/2025 11:07: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 ( '96819' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 22/05/2025 11:22:55 am >> UPDATE ps_document SET id_document_type = '31', document_num = '2456/00', document_date = '2025-05-19', document_letter = '00', id_customer = '0', id_supplier = '', id_address = '4670785', address1 = 'VIA ROMA 44 00053 CIVITAVECCHIA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '240.80', price_tax_excluded = '197.38', date_upd = NOW() WHERE id_document = '97302' 22/05/2025 11:22:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97302' 22/05/2025 11:22:55 am >> DELETE FROM ps_document_detail WHERE id_document = '97302' 22/05/2025 11:22:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97302' , '9486' , 'S. MICHELE ARC. BABY - PB19076' , '6' , '6' , '1' , '4.7500' , '3.8934426229508' , '22' , '5' , '33.03' ) 22/05/2025 11:22:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97302' , '9464' , 'S. GIUSEPPE BABY - PB19077' , '6' , '6' , '1' , '3.8800' , '3.1803278688525' , '22' , '5' , '26.98' ) 22/05/2025 11:22:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97302' , '9205' , 'S. ANTONIO BABY - PB19078' , '6' , '6' , '1' , '3.9800' , '3.2622950819672' , '22' , '5' , '27.68' ) 22/05/2025 11:22:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97302' , '9212' , 'S. FRANCESCO BABY - PB19079' , '6' , '6' , '1' , '3.6800' , '3.016393442623' , '22' , '5' , '25.59' ) 22/05/2025 11:22:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97302' , '9209' , 'SACRA FAMIGLIA BABY - PB19080' , '6' , '6' , '1' , '5.2800' , '4.327868852459' , '22' , '5' , '36.72' ) 22/05/2025 11:22:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97302' , '6075' , 'LOURDES BABY - PB19081' , '6' , '6' , '1' , '3.2800' , '2.6885245901639' , '22' , '5' , '22.81' ) 22/05/2025 11:22:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97302' , '14623' , 'BAMBINO DI PRAGA BABY - PB19083' , '6' , '6' , '1' , '3.8600' , '3.1639344262295' , '22' , '5' , '26.84' ) 22/05/2025 11:22:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97302' , '13111' , 'FATIMA BABY - PB19085' , '6' , '6' , '1' , '4.1800' , '3.4262295081967' , '22' , '5' , '29.07' ) 22/05/2025 11:22:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97302' , '10133' , 'SPESE DI TRASPORTO' , '1' , '1' , '1' , '9.9000' , '8.1147540983607' , '22' , '0' , '12.08' ) 22/05/2025 11:35:39 am >> SELECT document_num FROM ps_document WHERE document_num = '1790' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-22') 22/05/2025 11:35:39 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1790' , '2025-05-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '73.30' , '60.08' , NOW() , NOW() ) 22/05/2025 11:35:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97322' 22/05/2025 11:35:39 am >> DELETE FROM ps_document_detail WHERE id_document = '97322' 22/05/2025 11:35:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97322' , '11626' , 'PURIFICATOIO 28X48 - SERV 1' , '3' , '-3' , '1' , '7.80' , '6.3934426229508' , '22' , '0' , '23.40' ) 22/05/2025 11:35:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97322' , '22199' , 'VINO LIQUOROSO ROSSO ' , '6' , '-6' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '45.00' ) 22/05/2025 11:35:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97322' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 22/05/2025 11:40:01 am >> SELECT document_num FROM ps_document WHERE document_num = '1791' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-22') 22/05/2025 11:40: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 ( '11' , '1791' , '2025-05-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 22/05/2025 11:40: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 = '97323' 22/05/2025 11:40:01 am >> DELETE FROM ps_document_detail WHERE id_document = '97323' 22/05/2025 11:40: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 ( '97323' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '30' , '24.590163934426' , '22' , '0' , '60.00' ) 22/05/2025 11:43: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 ( '32' , '140/25' , '2025-05-06' , '25' , '0' , '0' , '4671003' , 'VIA TORQUATO TASSO, 10 24020 GORLE' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '84.00' , '84.00' , NOW() , NOW() ) 22/05/2025 11:43: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 = '97324' 22/05/2025 11:43:18 am >> DELETE FROM ps_document_detail WHERE id_document = '97324' 22/05/2025 11:43: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 ( '97324' , '9430' , 'SAN FRANCESCO DI SALES - G. GHIGLIONE' , '1' , '0' , '4' , '4.0000' , '4' , '0' , '50' , '2.00' ) 22/05/2025 11:43: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 ( '97324' , '23725' , 'RISPOSTE SEMPLICI A DOMANDE INTERESSANTI' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '50' , '7.50' ) 22/05/2025 11:43: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 ( '97324' , '21032' , 'DON DOLINDO RUOTOLO - P. REA' , '2' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 22/05/2025 11:43:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97324' , '9603' , 'SANTA RITA DA CASCIA - V. PERI' , '5' , '0' , '4' , '5.5000' , '5.5' , '0' , '50' , '13.75' ) 22/05/2025 11:43:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97324' , '9522' , 'SANT ANDREA AP. - A.GOVERNALE' , '1' , '0' , '4' , '3.5' , '3.5' , '0' , '50' , '1.7500' ) 22/05/2025 11:43:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97324' , '9471' , 'SAN LORENZO MARTIRE - G.PESENTI' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 22/05/2025 11:43:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97324' , '23726' , 'SAN GIUSEPPE MOSCATI - F. OCCHETTA' , '2' , '0' , '4' , '2' , '2' , '0' , '50' , '2.0000' ) 22/05/2025 11:43:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97324' , '19669' , 'SAN VITO MARTIRE - D. BOLOGNINI' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 22/05/2025 11:43:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97324' , '9404' , 'SAN CIRO MARTIRE - A. BEATO' , '2' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '3.50' ) 22/05/2025 11:43:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97324' , '9573' , 'SANTA LUCIA' , '2' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 22/05/2025 11:43:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97324' , '9613' , 'SANTA TERESA DI LISIEUX' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 22/05/2025 11:43:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97324' , '9420' , 'SAN FRANCESCO DASSISI' , '2' , '0' , '4' , '5.5000' , '5.5' , '0' , '50' , '5.50' ) 22/05/2025 11:43:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97324' , '9533' , 'SANTANNA - F.DI STASIO' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 22/05/2025 11:43:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97324' , '23727' , 'SANTANTONIO ABATE - G. PESENTI' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 22/05/2025 11:43:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97324' , '4621' , 'GIOVANNI PAOLO II - V. PERI' , '1' , '0' , '4' , '5.5000' , '5.5' , '0' , '50' , '2.75' ) 22/05/2025 11:43:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97324' , '23728' , 'SAN PAOLO DELLA CROCE - G. DE LUCA' , '1' , '0' , '4' , '5.5000' , '5.5' , '0' , '50' , '2.75' ) 22/05/2025 11:43:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97324' , '23729' , 'SAN CHARBEL - F. BERNASCONI' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 22/05/2025 11:43:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97324' , '23158' , 'SAN GIUSTINO M. RUSSOLILLO - S. MEUCCI' , '1' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '3.0000' ) 22/05/2025 11:43:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97324' , '9532' , 'SANTALFONSO MARIA DE LIGUORI - E. MARCELLI' , '1' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.7500' ) 22/05/2025 11:43:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97324' , '23730' , 'SAN PANTALEONE - G. PESENTI' , '1' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 22/05/2025 11:43:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97324' , '6055' , 'MADONNA DEL CARMINE' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 22/05/2025 11:43:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97324' , '9579' , 'SANTA MARGHERITA MARIA ALACOQUE - M.TARONI' , '1' , '0' , '4' , '4.0000' , '4' , '0' , '50' , '2.00' ) 22/05/2025 11:43:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97324' , '9438' , 'SAN GENNARO VESCOVO' , '1' , '0' , '4' , '4.0000' , '4' , '0' , '50' , '2.00' ) 22/05/2025 11:43:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97324' , '9487' , 'SAN MICHELE ARCANGELO - F.INNOCENTE' , '1' , '0' , '4' , '5.5000' , '5.5' , '0' , '50' , '2.75' ) 22/05/2025 11:43:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97324' , '6062' , 'MADONNA DELLE GRAZIE - G. PESENTI' , '1' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 22/05/2025 11:53:01 am >> SELECT document_num FROM ps_document WHERE document_num = '1792' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-22') 22/05/2025 11:53: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 ( '11' , '1792' , '2025-05-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '10.66' , NOW() , NOW() ) 22/05/2025 11:53: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 = '97325' 22/05/2025 11:53:01 am >> DELETE FROM ps_document_detail WHERE id_document = '97325' 22/05/2025 11:53: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 ( '97325' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 22/05/2025 12:06:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '1268' AND id_document != '96714' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-15') 22/05/2025 12:06:15 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1268', document_date = '2025-04-15', 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 = '100.00', price_tax_excluded = '81.97', date_upd = NOW() WHERE id_document = '96714' 22/05/2025 12:06:15 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 = '96714' 22/05/2025 12:06:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '96714' 22/05/2025 12:06:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96714' , '11265' , 'COPRILEGGIO - 881' , '1' , '-1' , '1' , '71' , '58.196721311475' , '22' , '0' , '71.00' ) 22/05/2025 12:06:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96714' , '20644' , 'STOLA - PST022' , '1' , '-1' , '1' , '29.00' , '23.770491803279' , '22' , '0' , '29.00' ) 22/05/2025 12:07:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '1456' AND id_document != '96928' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-30') 22/05/2025 12:07:32 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1456', document_date = '2025-04-30', 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 = '240.00', price_tax_excluded = '196.72', date_upd = NOW() WHERE id_document = '96928' 22/05/2025 12:07:32 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 = '96928' 22/05/2025 12:07:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '96928' 22/05/2025 12:07:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96928' , '8147' , 'POLO BASIC' , '1' , '-1' , '1' , '27.0000' , '22.131147540984' , '22' , '0' , '27.00' ) 22/05/2025 12:07:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96928' , '8082' , 'POLO LIMITED ' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 22/05/2025 12:07:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96928' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '40.1000' , '32.868852459016' , '22' , '0' , '40.10' ) 22/05/2025 12:07:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96928' , '14924' , 'STOLA - PST015' , '2' , '-2' , '1' , '71.45' , '58.565573770492' , '22' , '0' , '142.90' ) 22/05/2025 12:08:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '1574' AND id_document != '97071' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-08') 22/05/2025 12:08:01 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1574', document_date = '2025-05-08', 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 = '63.00', price_tax_excluded = '51.64', date_upd = NOW() WHERE id_document = '97071' 22/05/2025 12:08:01 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 = '97071' 22/05/2025 12:08:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '97071' 22/05/2025 12:08:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97071' , '16188' , 'STOLA QUATTRO EVANGELISTI - PST009' , '1' , '-1' , '1' , '63' , '51.639344262295' , '22' , '0' , '63.00' ) 22/05/2025 12:08:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '1504' AND id_document != '96989' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-05') 22/05/2025 12:08:43 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1504', document_date = '2025-05-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 = '225.00', price_tax_excluded = '193.68', date_upd = NOW() WHERE id_document = '96989' 22/05/2025 12:08: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 = '96989' 22/05/2025 12:08:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '96989' 22/05/2025 12:08: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 ( '96989' , '23332' , 'PER UNA CHIESA SINODALE' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 22/05/2025 12:08: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 ( '96989' , '22710' , 'PRIMA DI STENDERE LE BRACCIA - O. VEZZOLI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 22/05/2025 12:08: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 ( '96989' , '22042' , 'ARTE DI CELEBRARE LEUCARISTIA - AROCENA/PORTOLES' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 22/05/2025 12:08:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96989' , '17460' , 'GIORNO SENZA TRAMONTO - M. CAMISASCA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 22/05/2025 12:08:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96989' , '16588' , 'CLERGY DIAGONALE ML - C06' , '1' , '-1' , '1' , '46.9000' , '38.44262295082' , '22' , '0' , '46.90' ) 22/05/2025 12:08:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96989' , '22433' , 'COPRI BOTTONE - 22178' , '1' , '-1' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '20.00' ) 22/05/2025 12:08:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96989' , '10244' , 'STOLA DUBLINO - ST295' , '1' , '-1' , '1' , '106.8' , '87.540983606557' , '22' , '0' , '106.80' ) 22/05/2025 12:09:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '1604' AND id_document != '97105' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-09') 22/05/2025 12:09:00 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1604', document_date = '2025-05-09', 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 = '110.00', price_tax_excluded = '90.16', date_upd = NOW() WHERE id_document = '97105' 22/05/2025 12:09:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97105' 22/05/2025 12:09:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '97105' 22/05/2025 12:09:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97105' , '10244' , 'STOLA DUBLINO - ST295' , '1' , '-1' , '1' , '110' , '90.16393442623' , '22' , '0' , '110.00' ) 22/05/2025 12:09:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '1638' AND id_document != '97150' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-13') 22/05/2025 12:09:29 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1638', document_date = '2025-05-13', 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 = '108.00', price_tax_excluded = '88.52', date_upd = NOW() WHERE id_document = '97150' 22/05/2025 12:09: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 = '97150' 22/05/2025 12:09:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '97150' 22/05/2025 12:09: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 ( '97150' , '10244' , 'STOLA DUBLINO - ST295' , '1' , '-1' , '1' , '108' , '88.524590163934' , '22' , '0' , '108.00' ) 22/05/2025 12:10:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '1686' AND id_document != '97205' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-15') 22/05/2025 12:10:18 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1686', document_date = '2025-05-15', 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 = '406.00', price_tax_excluded = '332.79', date_upd = NOW() WHERE id_document = '97205' 22/05/2025 12:10: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 = '97205' 22/05/2025 12:10:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '97205' 22/05/2025 12:10: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 ( '97205' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '300' , '245.90163934426' , '22' , '0' , '300.00' ) 22/05/2025 12:10: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 ( '97205' , '10244' , 'STOLA DUBLINO - ST295' , '1' , '-1' , '1' , '106' , '86.885245901639' , '22' , '0' , '106.00' ) 22/05/2025 12:10:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '1617' AND id_document != '97119' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-10') 22/05/2025 12:10:46 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1617', document_date = '2025-05-10', 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 = '90.00', price_tax_excluded = '73.77', date_upd = NOW() WHERE id_document = '97119' 22/05/2025 12:10:46 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 = '97119' 22/05/2025 12:10:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '97119' 22/05/2025 12:10:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97119' , '12662' , 'CAMICE BIANCO - MISTO COT. 155' , '2' , '-2' , '1' , '45' , '36.885245901639' , '22' , '0' , '90.00' ) 22/05/2025 12:11:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '1431' AND id_document != '96901' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-29') 22/05/2025 12:11:55 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1431', document_date = '2025-04-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '55.00', price_tax_excluded = '55.00', date_upd = NOW() WHERE id_document = '96901' 22/05/2025 12:11:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96901' 22/05/2025 12:11:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '96901' 22/05/2025 12:11: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 ( '96901' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '20' , '-20' , '4' , '2.75' , '2.75' , '0' , '0' , '55.00' ) 22/05/2025 12:12:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '1474' AND id_document != '96949' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-02') 22/05/2025 12:12:24 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1474', document_date = '2025-05-02', 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 = '60.00', price_tax_excluded = '59.42', date_upd = NOW() WHERE id_document = '96949' 22/05/2025 12:12:24 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 = '96949' 22/05/2025 12:12:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '96949' 22/05/2025 12:12:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96949' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '3' , '-3' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '13.50' ) 22/05/2025 12:12:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96949' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '1.5000' , '1.4423076923077' , '4' , '0' , '1.50' ) 22/05/2025 12:12:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96949' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '20' , '-20' , '4' , '2.25' , '2.25' , '0' , '0' , '45.00' ) 22/05/2025 12:12:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '1507' AND id_document != '96994' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-05') 22/05/2025 12:12:57 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1507', document_date = '2025-05-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 = '186.83', price_tax_excluded = '159.06', date_upd = NOW() WHERE id_document = '96994' 22/05/2025 12:12: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 = '96994' 22/05/2025 12:12:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '96994' 22/05/2025 12:12: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 ( '96994' , '22464' , 'CASULA LEGGERA - 1212' , '1' , '-1' , '1' , '75.0000' , '61.475409836066' , '22' , '0' , '75.00' ) 22/05/2025 12:12: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 ( '96994' , '14919' , 'CASULA - POLIESTERE - PCA022' , '1' , '-1' , '1' , '79.0000' , '64.754098360656' , '22' , '0' , '79.00' ) 22/05/2025 12:12: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 ( '96994' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '10' , '-10' , '4' , '2' , '2' , '0' , '0' , '20.00' ) 22/05/2025 12:12: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 ( '96994' , '22488' , 'SANTO ROSARIO CON LE ICONE - A.M. CANOPI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 22/05/2025 12:12: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 ( '96994' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '5' , '4.28' ) 22/05/2025 12:12: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 ( '96994' , '23629' , 'CON MARIA MADRE DEL SIGNORE - R. LUPI' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 22/05/2025 12:13:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '1414' AND id_document != '96883' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-28') 22/05/2025 12:13:42 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1414', document_date = '2025-04-28', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '4.50', price_tax_excluded = '4.50', date_upd = NOW() WHERE id_document = '96883' 22/05/2025 12:13:42 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 = '96883' 22/05/2025 12:13:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '96883' 22/05/2025 12:13:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96883' , '14930' , 'MARIA LA MAMMA DI GESU' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '0' , '2.50' ) 22/05/2025 12:13:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96883' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '-1' , '4' , '2' , '2' , '0' , '0' , '2.00' ) 22/05/2025 12:14:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '1455' AND id_document != '96927' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-30') 22/05/2025 12:14:02 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1455', document_date = '2025-04-30', 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 = '10.55', price_tax_excluded = '10.55', date_upd = NOW() WHERE id_document = '96927' 22/05/2025 12:14:02 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 = '96927' 22/05/2025 12:14:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '96927' 22/05/2025 12:14:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96927' , '6417' , 'MESE DI MAGGIO CON LE GLORIE DI MARIA - 8463' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '5' , '8.55' ) 22/05/2025 12:14:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96927' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '-1' , '4' , '2' , '2' , '0' , '0' , '2.00' ) 22/05/2025 12:16:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '1435' AND id_document != '96906' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-29') 22/05/2025 12:16:49 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1435', document_date = '2025-04-29', 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 = '45.00', price_tax_excluded = '45.00', date_upd = NOW() WHERE id_document = '96906' 22/05/2025 12:16:49 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 = '96906' 22/05/2025 12:16:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '96906' 22/05/2025 12:16:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96906' , '6283' , 'MASSIME ETERNE - 8362' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 22/05/2025 12:16:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96906' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '10' , '-10' , '4' , '3' , '3' , '0' , '0' , '30.00' ) 22/05/2025 12:16:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96906' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '7' , '-7' , '4' , '1.00' , '1' , '0' , '0' , '7.00' ) 22/05/2025 12:16:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96906' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '1' , '-1' , '4' , '.75' , '0.75' , '0' , '0' , '0.75' ) 22/05/2025 12:16:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96906' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '.6' , '0.6' , '0' , '0' , '0.60' ) 22/05/2025 12:17:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '1525' AND id_document != '97018' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-06') 22/05/2025 12:17:16 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1525', document_date = '2025-05-06', 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 = '31.10', price_tax_excluded = '31.10', date_upd = NOW() WHERE id_document = '97018' 22/05/2025 12:17:16 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 = '97018' 22/05/2025 12:17:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '97018' 22/05/2025 12:17:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97018' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '5' , '-5' , '4' , '2' , '2' , '0' , '0' , '10.00' ) 22/05/2025 12:17:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97018' , '3388' , 'DEVOZIONE AL SANTO VOLTO DI GESÙ - 8426' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 22/05/2025 12:17:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97018' , '20895' , 'NOVE MARTEDI DELLANGELO CUSTODE - 8458' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 22/05/2025 12:17:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97018' , '23646' , 'DOMANDE A UN ESORCISTA - 8354' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '5' , '8.55' ) 22/05/2025 12:17:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97018' , '20719' , 'CORONA DELL’ADDOLORATA' , '1' , '-1' , '4' , '1.8000' , '1.8' , '0' , '0' , '1.80' ) 22/05/2025 12:17:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97018' , '13840' , 'NONNI SONO UN TESORO' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 22/05/2025 12:17:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97018' , '6703' , 'MIO GRAZIE A GESÙ' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 22/05/2025 12:18:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '1533' AND id_document != '97027' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-06') 22/05/2025 12:18:15 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1533', document_date = '2025-05-06', 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 = '35.00', price_tax_excluded = '35.00', date_upd = NOW() WHERE id_document = '97027' 22/05/2025 12:18:15 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 = '97027' 22/05/2025 12:18:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '97027' 22/05/2025 12:18:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97027' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 22/05/2025 12:18:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97027' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '17' , '-17' , '4' , '2' , '2' , '0' , '0' , '34.00' ) 22/05/2025 12:18:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '1513' AND id_document != '97005' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-06') 22/05/2025 12:18:31 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1513', document_date = '2025-05-06', 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 = '40.00', price_tax_excluded = '40.00', date_upd = NOW() WHERE id_document = '97005' 22/05/2025 12:18:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97005' 22/05/2025 12:18:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '97005' 22/05/2025 12:18:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97005' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '20' , '-20' , '4' , '2' , '2' , '0' , '0' , '40.00' ) 22/05/2025 12:18:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '1536' AND id_document != '97030' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-06') 22/05/2025 12:18:46 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1536', document_date = '2025-05-06', 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 = '40.00', price_tax_excluded = '40.00', date_upd = NOW() WHERE id_document = '97030' 22/05/2025 12:18:46 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 = '97030' 22/05/2025 12:18:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '97030' 22/05/2025 12:18:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97030' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '20' , '-20' , '4' , '2' , '2' , '0' , '0' , '40.00' ) 22/05/2025 12:19:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '1515' AND id_document != '97007' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-06') 22/05/2025 12:19:08 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1515', document_date = '2025-05-06', 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 = '243.80', price_tax_excluded = '204.12', date_upd = NOW() WHERE id_document = '97007' 22/05/2025 12:19:08 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 = '97007' 22/05/2025 12:19:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '97007' 22/05/2025 12:19:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97007' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 22/05/2025 12:19:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97007' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 22/05/2025 12:19:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97007' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 22/05/2025 12:19:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97007' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '50.00' ) 22/05/2025 12:19:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97007' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '11.00' ) 22/05/2025 12:19:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97007' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 22/05/2025 12:19:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97007' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '5' , '-5' , '4' , '2' , '2' , '0' , '0' , '10.00' ) 22/05/2025 12:19:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '1523' AND id_document != '97016' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-06') 22/05/2025 12:19:39 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1523', document_date = '2025-05-06', 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 = '10.00', price_tax_excluded = '10.00', date_upd = NOW() WHERE id_document = '97016' 22/05/2025 12:19: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 = '97016' 22/05/2025 12:19:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '97016' 22/05/2025 12:19: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 ( '97016' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '2' , '-2' , '4' , '2.5' , '2.5' , '0' , '0' , '5.00' ) 22/05/2025 12:19: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 ( '97016' , '5559' , 'LASCIATE CHE I BAMBINI VENGANO A ME' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 22/05/2025 12:19:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '1522' AND id_document != '97015' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-06') 22/05/2025 12:19:58 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1522', document_date = '2025-05-06', 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 = '33.80', price_tax_excluded = '30.91', date_upd = NOW() WHERE id_document = '97015' 22/05/2025 12:19:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97015' 22/05/2025 12:19:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '97015' 22/05/2025 12:19: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 ( '97015' , '15024' , 'CATECHISMO DELLA CHIESA CATTOLICA N.E.' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 22/05/2025 12:19: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 ( '97015' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 22/05/2025 12:19: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 ( '97015' , '22968' , 'TURIBOLO H10' , '1' , '-1' , '1' , '16.0000' , '13.114754098361' , '22' , '0' , '16.00' ) 22/05/2025 12:19: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 ( '97015' , '18289' , 'SANTA MESSA DEGLI SPOSI - N.E.' , '1' , '-1' , '4' , '1.9000' , '1.9' , '0' , '0' , '1.90' ) 22/05/2025 12:20:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '1551' AND id_document != '97046' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 22/05/2025 12:20:29 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1551', document_date = '2025-05-07', 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 = '2.30', price_tax_excluded = '2.25', date_upd = NOW() WHERE id_document = '97046' 22/05/2025 12:20: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 = '97046' 22/05/2025 12:20:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '97046' 22/05/2025 12:20: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 ( '97046' , '16059' , 'MEDAGLIA S. PELLEGRINO - FM022' , '1' , '-1' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '0.30' ) 22/05/2025 12:20: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 ( '97046' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '-1' , '4' , '2' , '2' , '0' , '0' , '2.00' ) 22/05/2025 12:20:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '1636' AND id_document != '97144' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-12') 22/05/2025 12:20:48 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1636', document_date = '2025-05-12', 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 = '12.00', price_tax_excluded = '12.00', date_upd = NOW() WHERE id_document = '97144' 22/05/2025 12:20:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97144' 22/05/2025 12:20:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '97144' 22/05/2025 12:20:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97144' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 22/05/2025 12:20:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97144' , '23015' , 'PELLEGRINI DI SPERANZA - SUSSIDIO GIUBILEO ADULTI' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 22/05/2025 12:20:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97144' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '-1' , '4' , '2.1' , '2.1' , '0' , '0' , '2.10' ) 22/05/2025 12:21:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '1645' AND id_document != '97157' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-13') 22/05/2025 12:21:27 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1645', document_date = '2025-05-13', 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 = '1.10', price_tax_excluded = '1.01', date_upd = NOW() WHERE id_document = '97157' 22/05/2025 12:21:27 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 = '97157' 22/05/2025 12:21:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '97157' 22/05/2025 12:21: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 ( '97157' , '17938' , 'SAN GIUSEPPE - ARS 119' , '1' , '-1' , '1' , '0.1500' , '0.12295081967213' , '22' , '0' , '0.15' ) 22/05/2025 12:21: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 ( '97157' , '10145' , 'SPIRITO SANTO - 263 ' , '1' , '-1' , '1' , '0.1500' , '0.12295081967213' , '22' , '0' , '0.15' ) 22/05/2025 12:21: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 ( '97157' , '7481' , 'PAPA FRANCESCO - - PAPA FRANCESCO -J.M. BERGOGLIO' , '1' , '-1' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '0.20' ) 22/05/2025 12:21: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 ( '97157' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.6' , '0.6' , '0' , '0' , '0.60' ) 22/05/2025 12:33:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001575' AND id_product != '18339' AND ean13 != '' 22/05/2025 12:33:35 pm >> UPDATE ps_product SET id_supplier = '91', reference = '', ean13 = '001575', date_upd = NOW() WHERE id_product = '18339' 22/05/2025 12:33:35 pm >> UPDATE ps_product_lang SET name = 'CROCE SAN BENEDETTO - CZ10NIK - VARI COLORI', description = '' WHERE id_product = '18339' 22/05/2025 12:33:35 pm >> UPDATE ps_product SET wholesale_price = '4.98', on_sale = '0', price = '9.754098360655739' WHERE id_product = '18339' 22/05/2025 12:33:35 pm >> UPDATE ps_product_shop SET wholesale_price = '4.98', price = '9.754098360655739', id_tax_rules_group = '1', id_category_default = '401', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18339' 22/05/2025 12:33:35 pm >> DELETE FROM ps_specific_price WHERE id_product = '18339' 22/05/2025 12:39:09 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001194' AND id_product != '15498' AND ean13 != '' 22/05/2025 12:39:09 pm >> UPDATE ps_product SET id_supplier = '91', reference = '', ean13 = '001194', date_upd = NOW() WHERE id_product = '15498' 22/05/2025 12:39:09 pm >> UPDATE ps_product_lang SET name = 'CROCE SAN BENEDETTO SMALTATA - CZ5NIK', description = '' WHERE id_product = '15498' 22/05/2025 12:39:09 pm >> UPDATE ps_product SET wholesale_price = '7.88', on_sale = '0', price = '14.672131147540982' WHERE id_product = '15498' 22/05/2025 12:39:09 pm >> UPDATE ps_product_shop SET wholesale_price = '7.88', price = '14.672131147540982', id_tax_rules_group = '1', id_category_default = '401', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15498' 22/05/2025 12:39:09 pm >> DELETE FROM ps_specific_price WHERE id_product = '15498' 22/05/2025 12:49:43 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 22/05/2025 12:49:43 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23757' , '1' , '' , 'nuovo-prodotto' ) 22/05/2025 12:49:43 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23757' , '1' , '1' , '2' , NOW() , NOW() ) 22/05/2025 12:49:43 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23757' , '0' , '1' , '0' , '0' ) 22/05/2025 12:50:08 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002380' AND id_product != '23757' AND ean13 != '' 22/05/2025 12:50:08 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002380', date_upd = NOW() WHERE id_product = '23757' 22/05/2025 12:50:08 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA SAN BENEDETTO - M244/A', description = '' WHERE id_product = '23757' 22/05/2025 12:50:08 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.639344262295082' WHERE id_product = '23757' 22/05/2025 12:50:08 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.639344262295082', id_tax_rules_group = '1', id_category_default = '401', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23757' 22/05/2025 12:50:08 pm >> DELETE FROM ps_specific_price WHERE id_product = '23757' 22/05/2025 12:50:09 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 = '23757' 22/05/2025 12:50:09 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23758' , '1' , '' , 'nuovo-prodotto' ) 22/05/2025 12:50:09 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 '23758' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23757' 22/05/2025 12:50:09 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23758' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23757' 22/05/2025 12:50:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002380' AND id_product != '23757' AND ean13 != '' 22/05/2025 12:50:27 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002380', date_upd = NOW() WHERE id_product = '23757' 22/05/2025 12:50:27 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA SAN BENEDETTO - M244/A SM', description = '' WHERE id_product = '23757' 22/05/2025 12:50:27 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.6393' WHERE id_product = '23757' 22/05/2025 12:50:27 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.6393', id_tax_rules_group = '1', id_category_default = '401', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23757' 22/05/2025 12:50:27 pm >> DELETE FROM ps_specific_price WHERE id_product = '23757' 22/05/2025 12:56:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001190' AND id_product != '15490' AND ean13 != '' 22/05/2025 12:56:19 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001190', date_upd = NOW() WHERE id_product = '15490' 22/05/2025 12:56:19 pm >> UPDATE ps_product_lang SET name = 'CROCE TRAFORATA - 126', description = '' WHERE id_product = '15490' 22/05/2025 12:56:19 pm >> UPDATE ps_product SET wholesale_price = '5.45', on_sale = '0', price = '9.8361' WHERE id_product = '15490' 22/05/2025 12:56:19 pm >> UPDATE ps_product_shop SET wholesale_price = '5.45', price = '9.8361', id_tax_rules_group = '1', id_category_default = '401', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15490' 22/05/2025 12:56:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '15490' 22/05/2025 12:56:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001190' AND id_product != '15490' AND ean13 != '' 22/05/2025 12:56:36 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001190', date_upd = NOW() WHERE id_product = '15490' 22/05/2025 12:56:36 pm >> UPDATE ps_product_lang SET name = 'CROCE TRAFORATA - 126', description = '' WHERE id_product = '15490' 22/05/2025 12:56:37 pm >> UPDATE ps_product SET wholesale_price = '5.45', on_sale = '0', price = '11.065573770491804' WHERE id_product = '15490' 22/05/2025 12:56:37 pm >> UPDATE ps_product_shop SET wholesale_price = '5.45', price = '11.065573770491804', id_tax_rules_group = '1', id_category_default = '401', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15490' 22/05/2025 12:56:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '15490' 22/05/2025 12:56:55 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '88/A' , '2025-05-22' , 'A' , '0' , '91' , '2738' , 'ZONA IND. G. BRODOLINI, 25 60025 LORETO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '447.15' , '366.52' , NOW() , NOW() ) 22/05/2025 12:56:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97326' 22/05/2025 12:56:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '97326' 22/05/2025 12:56: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 ( '97326' , '18339' , 'CROCE SAN BENEDETTO - CZ10NIK - VARI COLORI' , '15' , '15' , '1' , '10.95' , '8.9754098360656' , '22' , '50+10+3' , '87.4681' ) 22/05/2025 12:56:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18339' AND id_supplier = '91' 22/05/2025 12:56:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18339' , '91' , '1' ) 22/05/2025 12:56: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 ( '97326' , '15498' , 'CROCE SAN BENEDETTO SMALTATA - CZ5NIK' , '15' , '15' , '1' , '15.75' , '12.909836065574' , '22' , '50+10+3' , '125.8102' ) 22/05/2025 12:56:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15498' AND id_supplier = '91' 22/05/2025 12:56:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15498' , '91' , '1' ) 22/05/2025 12:56: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 ( '97326' , '12490' , 'CROCE SAN BENEDETTO ULIVO - CZ6NIK' , '5' , '5' , '1' , '15.9' , '13.032786885246' , '22' , '50+10+3' , '42.3361' ) 22/05/2025 12:56:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12490' AND id_supplier = '91' 22/05/2025 12:56:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12490' , '91' , '1' ) 22/05/2025 12:56: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 ( '97326' , '17343' , 'CROCE SAN BENEDETTO LEGNO SMALTATA - CZ6NIKSM' , '2' , '2' , '1' , '18.5' , '15.16393442623' , '22' , '50+10+3' , '19.7036' ) 22/05/2025 12:56:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17343' AND id_supplier = '91' 22/05/2025 12:56:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17343' , '91' , '1' ) 22/05/2025 12:56: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 ( '97326' , '20524' , 'CROCE SAN BENEDETTO SMALTATA - CZ4NIK' , '24' , '24' , '1' , '4.27' , '3.5' , '22' , '50+10+3' , '54.5737' ) 22/05/2025 12:56:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20524' AND id_supplier = '91' 22/05/2025 12:56:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20524' , '91' , '1' ) 22/05/2025 12:56: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 ( '97326' , '23757' , 'MEDAGLIA SAN BENEDETTO - M244/A SM' , '100' , '100' , '1' , '2.08' , '1.7049180327869' , '22' , '50+10+3' , '110.7662' ) 22/05/2025 12:56:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23757' AND id_supplier = '91' 22/05/2025 12:56:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23757' , '91' , '1' ) 22/05/2025 12:56: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 ( '97326' , '15490' , 'CROCE TRAFORATA - 126' , '1' , '1' , '1' , '12.2' , '10' , '22' , '50+10+3' , '6.4969' ) 22/05/2025 12:56:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15490' AND id_supplier = '91' 22/05/2025 12:56:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15490' , '91' , '1' ) 22/05/2025 02:17:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002194' AND id_product != '21731' AND ean13 != '' 22/05/2025 02:17:02 pm >> UPDATE ps_product SET id_supplier = '91', reference = '', ean13 = '002194', date_upd = NOW() WHERE id_product = '21731' 22/05/2025 02:17:02 pm >> UPDATE ps_product_lang SET name = 'CROCE TRILOBATA CM 35 - CL58', description = '' WHERE id_product = '21731' 22/05/2025 02:17:02 pm >> UPDATE ps_product SET wholesale_price = '11.10', on_sale = '0', price = '21.721311475409838' WHERE id_product = '21731' 22/05/2025 02:17:02 pm >> UPDATE ps_product_shop SET wholesale_price = '11.10', price = '21.721311475409838', id_tax_rules_group = '1', id_category_default = '401', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21731' 22/05/2025 02:17:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '21731' 22/05/2025 02:19:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002095' AND id_product != '20523' AND ean13 != '' 22/05/2025 02:19:07 pm >> UPDATE ps_product SET id_supplier = '91', reference = '', ean13 = '002095', date_upd = NOW() WHERE id_product = '20523' 22/05/2025 02:19:07 pm >> UPDATE ps_product_lang SET name = 'CROCE - 094 ALV', description = '' WHERE id_product = '20523' 22/05/2025 02:19:07 pm >> UPDATE ps_product SET wholesale_price = '1.65', on_sale = '0', price = '3.278688524590164' WHERE id_product = '20523' 22/05/2025 02:19:07 pm >> UPDATE ps_product_shop SET wholesale_price = '1.65', price = '3.278688524590164', id_tax_rules_group = '1', id_category_default = '401', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20523' 22/05/2025 02:19:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '20523' 22/05/2025 02:24:14 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002381' AND id_product != '12471' AND ean13 != '' 22/05/2025 02:24:14 pm >> UPDATE ps_product SET id_supplier = '91', reference = '', ean13 = '002381', date_upd = NOW() WHERE id_product = '12471' 22/05/2025 02:24:14 pm >> UPDATE ps_product_lang SET name = 'CROCE CORPO ARG. - 078BISALV', description = '' WHERE id_product = '12471' 22/05/2025 02:24:14 pm >> UPDATE ps_product SET wholesale_price = '1.02', on_sale = '0', price = '2.6229508196721314' WHERE id_product = '12471' 22/05/2025 02:24:14 pm >> UPDATE ps_product_shop SET wholesale_price = '1.02', price = '2.6229508196721314', id_tax_rules_group = '1', id_category_default = '401', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '12471' 22/05/2025 02:24:14 pm >> DELETE FROM ps_specific_price WHERE id_product = '12471' 22/05/2025 02:25:45 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002193' AND id_product != '21730' AND ean13 != '' 22/05/2025 02:25:45 pm >> UPDATE ps_product SET id_supplier = '91', reference = '', ean13 = '002193', date_upd = NOW() WHERE id_product = '21730' 22/05/2025 02:25:45 pm >> UPDATE ps_product_lang SET name = 'CROCE CLASSICA CM 40 - CL51', description = '' WHERE id_product = '21730' 22/05/2025 02:25:45 pm >> UPDATE ps_product SET wholesale_price = '24.53', on_sale = '0', price = '44.26229508196722' WHERE id_product = '21730' 22/05/2025 02:25:45 pm >> UPDATE ps_product_shop SET wholesale_price = '24.53', price = '44.26229508196722', id_tax_rules_group = '1', id_category_default = '401', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21730' 22/05/2025 02:25:45 pm >> DELETE FROM ps_specific_price WHERE id_product = '21730' 22/05/2025 02:27:38 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '88/A', document_date = '2025-05-22', document_letter = 'A', id_customer = '0', id_supplier = '', id_address = '2738', address1 = 'ZONA IND. G. BRODOLINI, 25 60025 LORETO', address2 = '', note = '', price_shipping = '0.35', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '655.57', price_tax_excluded = '537.35', date_upd = NOW() WHERE id_document = '97326' 22/05/2025 02:27:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97326' 22/05/2025 02:27:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '97326' 22/05/2025 02:27: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 ( '97326' , '18339' , 'CROCE SAN BENEDETTO - CZ10NIK - VARI COLORI' , '15' , '15' , '1' , '10.9500' , '8.9754098360656' , '22' , '50+10+3' , '87.47' ) 22/05/2025 02:27: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 ( '97326' , '15498' , 'CROCE SAN BENEDETTO SMALTATA - CZ5NIK' , '15' , '15' , '1' , '15.7500' , '12.909836065574' , '22' , '50+10+3' , '125.81' ) 22/05/2025 02:27: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 ( '97326' , '12490' , 'CROCE SAN BENEDETTO ULIVO - CZ6NIK' , '5' , '5' , '1' , '15.9000' , '13.032786885246' , '22' , '50+10+3' , '42.34' ) 22/05/2025 02:27: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 ( '97326' , '17343' , 'CROCE SAN BENEDETTO LEGNO SMALTATA - CZ6NIKSM' , '2' , '2' , '1' , '18.5000' , '15.16393442623' , '22' , '50+10+3' , '19.70' ) 22/05/2025 02:27: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 ( '97326' , '20524' , 'CROCE SAN BENEDETTO SMALTATA - CZ4NIK' , '24' , '24' , '1' , '4.2700' , '3.5' , '22' , '50+10+3' , '54.57' ) 22/05/2025 02:27: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 ( '97326' , '23757' , 'MEDAGLIA SAN BENEDETTO - M244/A SM' , '100' , '100' , '1' , '2.0800' , '1.7049180327869' , '22' , '50+10+3' , '110.77' ) 22/05/2025 02:27: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 ( '97326' , '15490' , 'CROCE TRAFORATA - 126' , '1' , '1' , '1' , '12.2000' , '10' , '22' , '50+10+3' , '6.50' ) 22/05/2025 02:27: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 ( '97326' , '21731' , 'CROCE TRILOBATA CM 35 - CL58' , '1' , '1' , '1' , '22.2' , '18.196721311475' , '22' , '50+10+3' , '11.8222' ) 22/05/2025 02:27: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 ( '97326' , '15497' , 'CROCE PLEX - 086' , '10' , '10' , '1' , '7.88' , '6.4590163934426' , '22' , '50+10+3' , '41.9634' ) 22/05/2025 02:27: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 ( '97326' , '20523' , 'CROCE - 094 ALV' , '24' , '24' , '1' , '3.62' , '2.9672131147541' , '22' , '50+10+3' , '46.2662' ) 22/05/2025 02:27: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 ( '97326' , '15492' , 'CROCE SAN BENEDETTO CON BASE E LEGNO - CZ6BSNIK' , '2' , '2' , '1' , '25.75' , '21.106557377049' , '22' , '50+10+3' , '27.4253' ) 22/05/2025 02:27: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 ( '97326' , '21729' , 'CROCE SAN BENEDETTO CON BASE - CZ11BSNIK' , '2' , '2' , '1' , '18.2' , '14.918032786885' , '22' , '50+10+5' , '18.9844' ) 22/05/2025 02:27: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 ( '97326' , '12471' , 'CROCE CORPO ARG. - 078BISALV' , '24' , '24' , '1' , '2.77' , '2.2704918032787' , '22' , '50+10+3' , '35.4026' ) 22/05/2025 02:27: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 ( '97326' , '21730' , 'CROCE CLASSICA CM 40 - CL51' , '1' , '1' , '1' , '49.05' , '40.204918032787' , '22' , '50+10+3' , '26.1206' ) 22/05/2025 02:32:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892985995' AND id_product != '23758' AND ean13 != '' 22/05/2025 02:32:56 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788892985995', date_upd = NOW() WHERE id_product = '23758' 22/05/2025 02:32:56 pm >> UPDATE ps_product_lang SET name = 'VIVA LA POESIA - PAPA FRANCESCO', description = '' WHERE id_product = '23758' 22/05/2025 02:32:56 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18.5' WHERE id_product = '23758' 22/05/2025 02:32:56 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18.5', id_tax_rules_group = '4', id_category_default = '146', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23758' 22/05/2025 02:32:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '23758' 22/05/2025 02:32:57 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 = '23758' 22/05/2025 02:32:57 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23759' , '1' , '' , 'nuovo-prodotto' ) 22/05/2025 02:32:57 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 '23759' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23758' 22/05/2025 02:32:57 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23759' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23758' 22/05/2025 02:34:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788856698428' AND id_product != '23759' AND ean13 != '' 22/05/2025 02:34:07 pm >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA', ean13 = '9788856698428', date_upd = NOW() WHERE id_product = '23759' 22/05/2025 02:34:07 pm >> UPDATE ps_product_lang SET name = 'NON IO MA DIO - A. SALZANO ACUTIS', description = '' WHERE id_product = '23759' 22/05/2025 02:34:07 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18.9' WHERE id_product = '23759' 22/05/2025 02:34:07 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18.9', id_tax_rules_group = '4', id_category_default = '70', 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 = '23759' 22/05/2025 02:34:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '23759' 22/05/2025 02:34:12 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 = '23759' 22/05/2025 02:34:12 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23760' , '1' , '' , 'nuovo-prodotto' ) 22/05/2025 02:34:12 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 '23760' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23759' 22/05/2025 02:34:12 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23760' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23759' 22/05/2025 02:34:53 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788856684520' AND id_product != '23760' AND ean13 != '' 22/05/2025 02:34:53 pm >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA', ean13 = '9788856684520', date_upd = NOW() WHERE id_product = '23760' 22/05/2025 02:34:53 pm >> UPDATE ps_product_lang SET name = 'SANTA MESSA SANTO ME - A. SALZANO ACUTIS', description = '' WHERE id_product = '23760' 22/05/2025 02:34:53 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18.9' WHERE id_product = '23760' 22/05/2025 02:34:53 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18.9', id_tax_rules_group = '4', id_category_default = '70', 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 = '23760' 22/05/2025 02:34:53 pm >> DELETE FROM ps_specific_price WHERE id_product = '23760' 22/05/2025 02:34: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 = '23760' 22/05/2025 02:34:54 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23761' , '1' , '' , 'nuovo-prodotto' ) 22/05/2025 02:34: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 '23761' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23760' 22/05/2025 02:34:54 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23761' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23760' 22/05/2025 02:35:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280210234' AND id_product != '22432' AND ean13 != '' 22/05/2025 02:35:39 pm >> UPDATE ps_product SET id_supplier = '47', reference = '6/6', ean13 = '9791280210234', date_upd = NOW() WHERE id_product = '22432' 22/05/2025 02:35:39 pm >> UPDATE ps_product_lang SET name = 'IN SINU JESU', description = '' WHERE id_product = '22432' 22/05/2025 02:35:39 pm >> UPDATE ps_product SET wholesale_price = '12.60', on_sale = '0', price = '20' WHERE id_product = '22432' 22/05/2025 02:35:39 pm >> UPDATE ps_product_shop SET wholesale_price = '12.60', price = '20', id_tax_rules_group = '4', id_category_default = '99', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22432' 22/05/2025 02:35:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '22432' 22/05/2025 02:36:40 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872297100' AND id_product != '23761' AND ean13 != '' 22/05/2025 02:36:40 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788872297100', date_upd = NOW() WHERE id_product = '23761' 22/05/2025 02:36:40 pm >> UPDATE ps_product_lang SET name = 'ECCO IO VEDO I CIELI - R. TALMELLI', description = '' WHERE id_product = '23761' 22/05/2025 02:36:40 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '30' WHERE id_product = '23761' 22/05/2025 02:36:40 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '30', id_tax_rules_group = '4', id_category_default = '128', 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 = '23761' 22/05/2025 02:36:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '23761' 22/05/2025 02:36:42 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 = '23761' 22/05/2025 02:36:42 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23762' , '1' , '' , 'nuovo-prodotto' ) 22/05/2025 02:36:42 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 '23762' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23761' 22/05/2025 02:36:42 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23762' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23761' 22/05/2025 02:37:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788893188708' AND id_product != '23762' AND ean13 != '' 22/05/2025 02:37:46 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788893188708', date_upd = NOW() WHERE id_product = '23762' 22/05/2025 02:37:46 pm >> UPDATE ps_product_lang SET name = 'SAN CARLO ACUTIS L\'INFLUENCER DI DIO - P. CATTANEO', description = '' WHERE id_product = '23762' 22/05/2025 02:37:46 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '23762' 22/05/2025 02:37:46 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '47', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23762' 22/05/2025 02:37:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '23762' 22/05/2025 02:37:47 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 = '23762' 22/05/2025 02:37:47 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23763' , '1' , '' , 'nuovo-prodotto' ) 22/05/2025 02:37:47 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 '23763' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23762' 22/05/2025 02:37:47 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23763' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23762' 22/05/2025 02:38: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' , '2482' , '2025-05-20' , '' , '0' , '47' , '2642' , 'V.LE BACCHIGLIONE, 20 20139 MILANO' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '128.44' , '128.44' , NOW() , NOW() ) 22/05/2025 02:38: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 = '97327' 22/05/2025 02:38:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '97327' 22/05/2025 02:38: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 ( '97327' , '23758' , 'VIVA LA POESIA - PAPA FRANCESCO' , '1' , '1' , '4' , '18.50' , '18.5' , '0' , '30' , '12.9500' ) 22/05/2025 02:38:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23758' AND id_supplier = '47' 22/05/2025 02:38:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23758' , '47' , '1' ) 22/05/2025 02:38: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 ( '97327' , '23759' , 'NON IO MA DIO - A. SALZANO ACUTIS' , '2' , '2' , '4' , '18.90' , '18.9' , '0' , '27' , '27.5940' ) 22/05/2025 02:38:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23759' AND id_supplier = '47' 22/05/2025 02:38:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23759' , '47' , '1' ) 22/05/2025 02:38: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 ( '97327' , '23760' , 'SANTA MESSA SANTO ME - A. SALZANO ACUTIS' , '2' , '2' , '4' , '18.90' , '18.9' , '0' , '27' , '27.5940' ) 22/05/2025 02:38:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23760' AND id_supplier = '47' 22/05/2025 02:38:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23760' , '47' , '1' ) 22/05/2025 02:38: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 ( '97327' , '22432' , 'IN SINU JESU' , '1' , '1' , '4' , '20.00' , '20' , '0' , '30' , '14.0000' ) 22/05/2025 02:38:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22432' AND id_supplier = '47' 22/05/2025 02:38:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22432' , '47' , '1' ) 22/05/2025 02:38: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 ( '97327' , '23761' , 'ECCO IO VEDO I CIELI - R. TALMELLI' , '1' , '1' , '4' , '30.00' , '30' , '0' , '30' , '21.0000' ) 22/05/2025 02:38:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23761' AND id_supplier = '47' 22/05/2025 02:38:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23761' , '47' , '1' ) 22/05/2025 02:38: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 ( '97327' , '23762' , 'SAN CARLO ACUTIS LINFLUENCER DI DIO - P. CATTANEO' , '1' , '1' , '4' , '15.00' , '15' , '0' , '30' , '10.5000' ) 22/05/2025 02:38:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23762' AND id_supplier = '47' 22/05/2025 02:38:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23762' , '47' , '1' ) 22/05/2025 02:38: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 ( '97327' , '9586' , 'SANTA MESSA - CATALINA RIVAS' , '10' , '10' , '4' , '1.40' , '1.4' , '0' , '30' , '9.8000' ) 22/05/2025 02:38:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9586' AND id_supplier = '47' 22/05/2025 02:38:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9586' , '47' , '1' ) 22/05/2025 04:35:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '1793' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-22') 22/05/2025 04:35: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 ( '11' , '1793' , '2025-05-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.60' , '11.60' , NOW() , NOW() ) 22/05/2025 04:35: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 = '97328' 22/05/2025 04:35:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '97328' 22/05/2025 04:35: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 ( '97328' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '9.00' ) 22/05/2025 04:35: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 ( '97328' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '3.60' ) 22/05/2025 04:56:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '1794' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-22') 22/05/2025 04:56:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1794' , '2025-05-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.40' , '24.10' , NOW() , NOW() ) 22/05/2025 04:56:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97329' 22/05/2025 04:56:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '97329' 22/05/2025 04:56:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97329' , '1914' , 'CERA DELLA LITURGIA' , '6' , '-6' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '29.40' ) 22/05/2025 04:56:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '1795' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-22') 22/05/2025 04:56: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' , '1795' , '2025-05-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.00' , '40.16' , NOW() , NOW() ) 22/05/2025 04:56: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 = '97330' 22/05/2025 04:56:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '97330' 22/05/2025 04:56: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 ( '97330' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '49.00' , '40.16393442623' , '22' , '0' , '49.00' ) 22/05/2025 05:16:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '1796' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-22') 22/05/2025 05:16:49 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' , '1796' , '2025-05-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.50' , '1.23' , NOW() , NOW() ) 22/05/2025 05:16:49 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 = '97331' 22/05/2025 05:16:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '97331' 22/05/2025 05:16:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97331' , '20516' , 'CROCE COMUNIONE - 42/08' , '1' , '-1' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '1.50' ) 22/05/2025 05:43:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '1797' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-22') 22/05/2025 05:43:25 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1797' , '2025-05-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '195.00' , '194.10' , NOW() , NOW() ) 22/05/2025 05:43:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97332' 22/05/2025 05:43:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '97332' 22/05/2025 05:43:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97332' , '5759' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO A' , '1' , '-1' , '4' , '65.00' , '65' , '0' , '0' , '65.00' ) 22/05/2025 05:43:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97332' , '18956' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO B' , '1' , '-1' , '4' , '65.00' , '65' , '0' , '0' , '65.00' ) 22/05/2025 05:43:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97332' , '20798' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO C' , '1' , '-1' , '4' , '60.00' , '60' , '0' , '0' , '60.00' ) 22/05/2025 05:43:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97332' , '18276' , 'CINGOLO CON NODI - 3280' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 22/05/2025 05:51:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '1798' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-22') 22/05/2025 05:51:01 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' , '1798' , '2025-05-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '400.00' , '327.87' , NOW() , NOW() ) 22/05/2025 05:51:01 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 = '97333' 22/05/2025 05:51:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '97333' 22/05/2025 05:51:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97333' , '15666' , 'STATUA MIRACOLOSA CM 60 - PA602' , '1' , '-1' , '1' , '220.00' , '180.32786885246' , '22' , '0' , '220.00' ) 22/05/2025 05:51:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97333' , '15667' , 'SACRO CUORE CM 60' , '1' , '-1' , '1' , '180' , '147.54098360656' , '22' , '0' , '180.00' ) 22/05/2025 05:52:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '1799' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-22') 22/05/2025 05:52:42 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' , '1799' , '2025-05-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '6.56' , NOW() , NOW() ) 22/05/2025 05:52:42 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 = '97334' 22/05/2025 05:52:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '97334' 22/05/2025 05:52:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97334' , '14624' , 'SANTA TERESA BABY - 023 STH/9 BB' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 22/05/2025 06:17:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '71' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-05-22') 22/05/2025 06:17:04 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' , '71' , '2025-05-22' , '' , '344' , '0' , '4679249' , 'L.GO MONS. G. PALUMBO 84020 OLIVETO CITRA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.50' , '42.50' , NOW() , NOW() ) 22/05/2025 06:17:04 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 = '97335' 22/05/2025 06:17:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '97335' 22/05/2025 06:17:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97335' , '15020' , 'PREGARE OGNI GIORNO' , '50' , '-50' , '4' , '1.00' , '1' , '0' , '15' , '42.50' ) 22/05/2025 06:18:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '71' AND id_document != '97335' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-05-22') 22/05/2025 06:18:54 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '71', document_date = '2025-05-22', document_letter = '', id_customer = '344', id_supplier = '', id_address = '4679249', address1 = 'L.GO MONS. G. PALUMBO 84020 OLIVETO CITRA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '42.50', price_tax_excluded = '42.50', date_upd = NOW() WHERE id_document = '97335' 22/05/2025 06:18: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 = '97335' 22/05/2025 06:18:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '97335' 22/05/2025 06:18: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 ( '97335' , '15020' , 'PREGARE OGNI GIORNO' , '50' , '-50' , '4' , '1.0000' , '1' , '0' , '15' , '42.50' ) 22/05/2025 06:58:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '1800' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-22') 22/05/2025 06:58: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' , '1800' , '2025-05-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 22/05/2025 06:58: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 = '97336' 22/05/2025 06:58:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '97336' 22/05/2025 06:58:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97336' , '22508' , 'POLO PIQUET - M06' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 22/05/2025 07:16:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '1801' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-22') 22/05/2025 07:16:04 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' , '1801' , '2025-05-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.58' , '17.58' , NOW() , NOW() ) 22/05/2025 07:16:04 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 = '97337' 22/05/2025 07:16:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '97337' 22/05/2025 07:16:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97337' , '21899' , 'SACRA BIBBIA cei/uelci ' , '1' , '-1' , '4' , '18.50' , '18.5' , '0' , '5' , '17.58' ) 22/05/2025 07:24:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '1802' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-22') 22/05/2025 07:24:51 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' , '1802' , '2025-05-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '4.92' , NOW() , NOW() ) 22/05/2025 07:24:51 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 = '97338' 22/05/2025 07:24:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '97338' 22/05/2025 07:24: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 ( '97338' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '6' , '4.9180327868852' , '22' , '0' , '6.00' ) 22/05/2025 07:27:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '13/A' AND id_document != '94912' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 22/05/2025 07:27:11 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '13/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '2739', id_supplier = '', id_address = '4671014', address1 = 'VIA F. WENNER, 37 84080 PELLEZZANO', 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 = '506.10', price_tax_excluded = '422.72', date_upd = NOW() WHERE id_document = '94912' 22/05/2025 07:27: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 = '94912' 22/05/2025 07:27:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '94912' 22/05/2025 07:27:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 22/05/2025 07:27:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '6812' , 'MOCCOLO 80X300 ' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 22/05/2025 07:27:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 22/05/2025 07:27:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '23491' , 'AMEN - MAG 25' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 22/05/2025 07:27:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '23492' , 'AMEN - GIU 25' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 22/05/2025 07:27:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '23536' , 'SULLA TUA PAROLA - MAG/GIU 25' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '0' , '10.00' ) 22/05/2025 07:27:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '22196' , 'CLERGY VERSUS ML - C25' , '1' , '-1' , '1' , '49.9000' , '40.901639344262' , '22' , '0' , '49.90' ) 22/05/2025 07:27:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '16454' , 'PALLA ORO CM 16' , '1' , '-1' , '1' , '118.0000' , '96.72131147541' , '22' , '0' , '118.00' ) 22/05/2025 07:27:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '0' , 'COLLETTO' , '2' , '-2' , '0' , '10.0000' , '10' , '0' , '0' , '20.00' ) 22/05/2025 07:27:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '18128' , 'PETTORINA' , '2' , '-2' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '26.00' ) 22/05/2025 07:27:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '5' , '-5' , '1' , '12.5000' , '10.245901639344' , '22' , '0' , '62.50' ) 22/05/2025 07:27:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '20073' , 'ROSARIO CRISTALLO - 01M46' , '19' , '-19' , '1' , '9.5000' , '7.7868852459016' , '22' , '0' , '180.50' ) 22/05/2025 07:27:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 22/05/2025 07:27:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 22/05/2025 07:53:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '1803' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-22') 22/05/2025 07:53:01 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' , '1803' , '2025-05-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.80' , '4.80' , NOW() , NOW() ) 22/05/2025 07:53:01 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 = '97339' 22/05/2025 07:53:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '97339' 22/05/2025 07:53:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97339' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '4.8' , '4.8' , '0' , '0' , '4.80' )