28/02/2025 08:22:34 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831555845' AND id_product != '20872' AND ean13 != '' 28/02/2025 08:22:34 am >> UPDATE ps_product SET id_supplier = '7', reference = '5/3', ean13 = '9788831555845', date_upd = NOW() WHERE id_product = '20872' 28/02/2025 08:22:34 am >> UPDATE ps_product_lang SET name = 'CON TE GESU\' ', description = '' WHERE id_product = '20872' 28/02/2025 08:22:34 am >> UPDATE ps_product SET wholesale_price = '1.68', on_sale = '0', price = '2.5000' WHERE id_product = '20872' 28/02/2025 08:22:34 am >> UPDATE ps_product_shop SET wholesale_price = '1.68', price = '2.5000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20872' 28/02/2025 08:22:34 am >> DELETE FROM ps_specific_price WHERE id_product = '20872' 28/02/2025 08:26:58 am >> SELECT document_num FROM ps_document WHERE document_num = '636' AND id_document != '95931' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-27') 28/02/2025 08:26:58 am >> UPDATE ps_document SET id_document_type = '11', document_num = '636', document_date = '2025-02-27', 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 = '80.00', price_tax_excluded = '75.53', date_upd = NOW() WHERE id_document = '95931' 28/02/2025 08:26:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95931' 28/02/2025 08:26:58 am >> DELETE FROM ps_document_detail WHERE id_document = '95931' 28/02/2025 08:26:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95931' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '1' , '-1' , '1' , '13.8000' , '11.311475409836' , '22' , '0' , '13.80' ) 28/02/2025 08:26:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95931' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '11.00' ) 28/02/2025 08:26:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95931' , '23478' , 'MESSAGGIO PER LA QUARESIMA 2025' , '1' , '-1' , '4' , '1.2000' , '1.2' , '0' , '0' , '1.20' ) 28/02/2025 08:26:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95931' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '1' , '-1' , '4' , '1.75' , '1.75' , '0' , '0' , '1.75' ) 28/02/2025 08:26:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95931' , '23393' , 'SULLA TUA PAROLA - MAR/APR 25' , '11' , '-11' , '4' , '5.0000' , '5' , '0' , '5' , '52.25' ) 28/02/2025 08:41:43 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'ljurSQGc5fs5xNLX' , NOW() , NOW() ) 28/02/2025 08:41:43 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4166' , '1' ) 28/02/2025 08:41:43 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4166' , '2' ) 28/02/2025 08:41:43 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4166' , '3' ) 28/02/2025 08:53:14 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4166' 28/02/2025 08:53:14 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4166' , '10' , '135' , 'EDITRICE VELAR' , '' , '' , 'VIA TORQUATO TASSO 14' , '' , '24020' , 'GORLE' , '' , '' , '' , '01727130161' , '' , NOW() , NOW() ) 28/02/2025 08:53:14 am >> UPDATE ps_customer SET email = 'velar@velar.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4166' 28/02/2025 09:11:55 am >> SELECT document_num FROM ps_document WHERE document_num = '651' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-28') 28/02/2025 09:11:55 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '651' , '2025-02-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '51.00' , '41.80' , NOW() , NOW() ) 28/02/2025 09:11: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 = '95950' 28/02/2025 09:11:55 am >> DELETE FROM ps_document_detail WHERE id_document = '95950' 28/02/2025 09:11: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 ( '95950' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 28/02/2025 09:12:09 am >> SELECT document_num FROM ps_document WHERE document_num = '652' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-28') 28/02/2025 09:12:09 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' , '652' , '2025-02-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 28/02/2025 09:12:09 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 = '95951' 28/02/2025 09:12:09 am >> DELETE FROM ps_document_detail WHERE id_document = '95951' 28/02/2025 09:12:09 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 ( '95951' , '22199' , 'VINO LIQUOROSO ROSSO ' , '6' , '-6' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '45.00' ) 28/02/2025 09:33:27 am >> SELECT document_num FROM ps_document WHERE document_num = '653' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-28') 28/02/2025 09:33:27 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' , '653' , '2025-02-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 28/02/2025 09:33:27 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 = '95952' 28/02/2025 09:33:27 am >> DELETE FROM ps_document_detail WHERE id_document = '95952' 28/02/2025 09:33:27 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 ( '95952' , '23393' , 'SULLA TUA PAROLA - MAR/APR 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 28/02/2025 09:48:17 am >> SELECT document_num FROM ps_document WHERE document_num = '654' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-28') 28/02/2025 09:48:17 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' , '654' , '2025-02-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.60' , '5.63' , NOW() , NOW() ) 28/02/2025 09:48:17 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 = '95953' 28/02/2025 09:48:17 am >> DELETE FROM ps_document_detail WHERE id_document = '95953' 28/02/2025 09:48:17 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 ( '95953' , '13504' , 'SACRAMENTO DELLA RICONCILIAZIONE RAGAZZI' , '18' , '-18' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '5.40' ) 28/02/2025 09:48:17 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 ( '95953' , '23478' , 'MESSAGGIO PER LA QUARESIMA 2025' , '1' , '-1' , '4' , '1.20' , '1.2' , '0' , '0' , '1.20' ) 28/02/2025 09:53:52 am >> SELECT document_num FROM ps_document WHERE document_num = '655' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-28') 28/02/2025 09:53: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' , '655' , '2025-02-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 28/02/2025 09:53: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 = '95954' 28/02/2025 09:53:52 am >> DELETE FROM ps_document_detail WHERE id_document = '95954' 28/02/2025 09:53: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 ( '95954' , '13713' , 'SERIE VIA CRUCIS - 35X50 ' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 28/02/2025 10:02:43 am >> SELECT document_num FROM ps_document WHERE document_num = '656' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-28') 28/02/2025 10:02:43 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' , '656' , '2025-02-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.70' , '3.63' , NOW() , NOW() ) 28/02/2025 10:02:43 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95955' 28/02/2025 10:02:43 am >> DELETE FROM ps_document_detail WHERE id_document = '95955' 28/02/2025 10:02:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95955' , '23474' , 'QUARESIMA PASQUA IN FAMIGLIA' , '1' , '-1' , '4' , '3.30' , '3.3' , '0' , '0' , '3.30' ) 28/02/2025 10:02:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95955' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '2' , '-2' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '0.40' ) 28/02/2025 10:26:00 am >> SELECT document_num FROM ps_document WHERE document_num = '657' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-28') 28/02/2025 10:26:00 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' , '657' , '2025-02-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '77.00' , '77.00' , NOW() , NOW() ) 28/02/2025 10:26:00 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 = '95956' 28/02/2025 10:26:00 am >> DELETE FROM ps_document_detail WHERE id_document = '95956' 28/02/2025 10:26:00 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 ( '95956' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '58' , '58' , '0' , '0' , '58.00' ) 28/02/2025 10:26:00 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 ( '95956' , '21542' , '100 OMELIE N.E. - A. COMASTRI' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 28/02/2025 10:47:32 am >> SELECT document_num FROM ps_document WHERE document_num = '658' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-28') 28/02/2025 10:47:32 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' , '658' , '2025-02-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.75' , '23.75' , NOW() , NOW() ) 28/02/2025 10:47:32 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 = '95957' 28/02/2025 10:47:32 am >> DELETE FROM ps_document_detail WHERE id_document = '95957' 28/02/2025 10:47:32 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 ( '95957' , '23393' , 'SULLA TUA PAROLA - MAR/APR 25' , '5' , '-5' , '4' , '5.00' , '5' , '0' , '5' , '23.75' ) 28/02/2025 10:50:02 am >> SELECT document_num FROM ps_document WHERE document_num = '659' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-28') 28/02/2025 10:50: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' , '659' , '2025-02-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '315.00' , '264.51' , NOW() , NOW() ) 28/02/2025 10:50: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 = '95958' 28/02/2025 10:50:02 am >> DELETE FROM ps_document_detail WHERE id_document = '95958' 28/02/2025 10:50: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 ( '95958' , '19798' , 'CAMICE ARIANNA MISTO LINO' , '1' , '-1' , '1' , '280' , '229.50819672131' , '22' , '0' , '280.00' ) 28/02/2025 10:50: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 ( '95958' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '35' , '35' , '0' , '0' , '35.00' ) 28/02/2025 11:06:02 am >> SELECT document_num FROM ps_document WHERE document_num = '660' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-28') 28/02/2025 11:06: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' , '660' , '2025-02-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '58.00' , '47.54' , NOW() , NOW() ) 28/02/2025 11:06: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 = '95959' 28/02/2025 11:06:02 am >> DELETE FROM ps_document_detail WHERE id_document = '95959' 28/02/2025 11:06: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 ( '95959' , '20644' , 'STOLA - PST022' , '2' , '-2' , '1' , '29.00' , '23.770491803279' , '22' , '0' , '58.00' ) 28/02/2025 11:06:42 am >> SELECT document_num FROM ps_document WHERE document_num = '661' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-28') 28/02/2025 11:06:42 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '661' , '2025-02-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '194.00' , '169.51' , NOW() , NOW() ) 28/02/2025 11:06:42 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95960' 28/02/2025 11:06:42 am >> DELETE FROM ps_document_detail WHERE id_document = '95960' 28/02/2025 11:06:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95960' , '12748' , 'DALMATICA MARIANA - 3564/TP' , '1' , '-1' , '1' , '120' , '98.360655737705' , '22' , '0' , '120.00' ) 28/02/2025 11:06:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95960' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '20' , '-20' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '70.00' ) 28/02/2025 11:06:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95960' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 28/02/2025 11:20:28 am >> SELECT document_num FROM ps_document WHERE document_num = '662' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-28') 28/02/2025 11:20: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' , '662' , '2025-02-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.70' , '3.85' , NOW() , NOW() ) 28/02/2025 11:20: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 = '95961' 28/02/2025 11:20:28 am >> DELETE FROM ps_document_detail WHERE id_document = '95961' 28/02/2025 11:20: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 ( '95961' , '15403' , 'CROCE IN RESINA CM 9 - 3806/G052' , '1' , '-1' , '1' , '3.70' , '3.0327868852459' , '22' , '0' , '3.70' ) 28/02/2025 11:20: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 ( '95961' , '18131' , 'TAU MEDIO CM3 - T6/t5' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 28/02/2025 11:27:53 am >> SELECT document_num FROM ps_document WHERE document_num = '663' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-28') 28/02/2025 11:27:53 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '663' , '2025-02-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.00' , '19.67' , NOW() , NOW() ) 28/02/2025 11:27:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95962' 28/02/2025 11:27:53 am >> DELETE FROM ps_document_detail WHERE id_document = '95962' 28/02/2025 11:27:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95962' , '21561' , 'QUADRO PIASTRELLA 20X20 - 2189' , '1' , '-1' , '1' , '24.00' , '19.672131147541' , '22' , '0' , '24.00' ) 28/02/2025 11:36:01 am >> SELECT document_num FROM ps_document WHERE document_num = '664' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2025-02-28') 28/02/2025 11:36: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' , '664' , '2025-02-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '85.00' , '69.67' , NOW() , NOW() ) 28/02/2025 11:36: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 = '95963' 28/02/2025 11:36:01 am >> DELETE FROM ps_document_detail WHERE id_document = '95963' 28/02/2025 11:36: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 ( '95963' , '16279' , 'PIZZO VARI COLORI JHS - P486' , '5' , '-5' , '1' , '17' , '13.934426229508' , '22' , '0' , '85.00' ) 28/02/2025 11:37:43 am >> SELECT document_num FROM ps_document WHERE document_num = '665' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2025-02-28') 28/02/2025 11:37:43 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' , '665' , '2025-02-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '83.13' , '83.13' , NOW() , NOW() ) 28/02/2025 11:37:43 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95964' 28/02/2025 11:37:43 am >> DELETE FROM ps_document_detail WHERE id_document = '95964' 28/02/2025 11:37:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95964' , '23499' , 'LIBRO DELLA MIA VITA ' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 28/02/2025 11:37:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95964' , '21607' , 'O GESU MI ABBANDONO A TE - DOLINDO RUOTOLO' , '1' , '-1' , '4' , '9.50' , '9.5' , '0' , '5' , '9.03' ) 28/02/2025 11:37:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95964' , '19840' , 'PERLE DI DON DOLINDO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 28/02/2025 11:37:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95964' , '21479' , 'PENSIERI E PREGHIERE DI DON DOLINDO - 8517' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 28/02/2025 11:37:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95964' , '23502' , 'DON DOLINDO E GLI SPIRITI CELESTI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 28/02/2025 11:37:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95964' , '17673' , 'FUI CHIAMATO DOLINDO' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 28/02/2025 11:37:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95964' , '23393' , 'SULLA TUA PAROLA - MAR/APR 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 28/02/2025 11:40:19 am >> SELECT document_num FROM ps_document WHERE document_num = '666' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2025-02-28') 28/02/2025 11:40:19 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '666' , '2025-02-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.15' , '14.15' , NOW() , NOW() ) 28/02/2025 11:40:19 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95965' 28/02/2025 11:40:19 am >> DELETE FROM ps_document_detail WHERE id_document = '95965' 28/02/2025 11:40: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 ( '95965' , '6283' , 'MASSIME ETERNE - 8362' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 28/02/2025 11:40: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 ( '95965' , '16968' , 'AFFIDAMENTO AI TRE CUORI - 8995' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 28/02/2025 11:40: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 ( '95965' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '5.5' , '5.5' , '0' , '0' , '5.50' ) 28/02/2025 11:42:58 am >> SELECT document_num FROM ps_document WHERE document_num = '667' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-28') 28/02/2025 11:42:58 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '667' , '2025-02-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '260.00' , '213.11' , NOW() , NOW() ) 28/02/2025 11:42:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95966' 28/02/2025 11:42:58 am >> DELETE FROM ps_document_detail WHERE id_document = '95966' 28/02/2025 11:42:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95966' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 28/02/2025 11:42:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95966' , '19862' , 'FERMAGLIO - B238/CA' , '1' , '-1' , '1' , '18.50' , '15.16393442623' , '22' , '0' , '18.50' ) 28/02/2025 11:42:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95966' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '178.5' , '146.31147540984' , '22' , '0' , '178.50' ) 28/02/2025 11:42:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95966' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 28/02/2025 11:42:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95966' , '17617' , 'IMMAGINI ISONZO X 100' , '4' , '-4' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '14.00' ) 28/02/2025 11:42:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95966' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3' , '2.4590163934426' , '22' , '0' , '6.00' ) 28/02/2025 11:51:34 am >> DELETE FROM ps_document WHERE id_document = '94115' 28/02/2025 11:51:34 am >> DELETE FROM ps_document_detail WHERE id_document = '94115' 28/02/2025 12:17:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '668' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-28') 28/02/2025 12:17: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 ( '11' , '668' , '2025-02-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 28/02/2025 12:17: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 = '95967' 28/02/2025 12:17:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '95967' 28/02/2025 12:17: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 ( '95967' , '23393' , 'SULLA TUA PAROLA - MAR/APR 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 28/02/2025 12:36:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '669' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-28') 28/02/2025 12:36:34 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' , '669' , '2025-02-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.00' , '40.16' , NOW() , NOW() ) 28/02/2025 12:36:34 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 = '95968' 28/02/2025 12:36:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '95968' 28/02/2025 12:36:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95968' , '780' , 'ASPERGES MAXI CON CUSTODIA - 700' , '1' , '-1' , '1' , '49.00' , '40.16393442623' , '22' , '0' , '49.00' ) 28/02/2025 02:48:57 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736529' AND id_product != '23420' AND ean13 != '' 28/02/2025 02:48:57 pm >> UPDATE ps_product SET id_supplier = '168', reference = '5/1', ean13 = '9791280736529', date_upd = NOW() WHERE id_product = '23420' 28/02/2025 02:48:57 pm >> UPDATE ps_product_lang SET name = 'SPERANZA. per vivere nella gioia - R. LUPI', description = '

La speranza appartiene alle virtù teologali. La speranza per un cristiano, secondo un’affermazione di papa Francesco, è «come l’aria che  respira», perché ci mantiene sempre vivaci e in tensione verso Gesù. Questo poster riassume visivamente questo tema così importante per la fede cristiana offrendone i fondamenti e i segni concreti. Utile da esporre nei luoghi in cui si fa catechesi in particolar modo in questo Anno Santo che ha come tema la speranza.

' WHERE id_product = '23420' 28/02/2025 02:48:57 pm >> UPDATE ps_product SET wholesale_price = '1.24', on_sale = '0', price = '3.0000' WHERE id_product = '23420' 28/02/2025 02:48:57 pm >> UPDATE ps_product_shop SET wholesale_price = '1.24', price = '3.0000', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '41', id_internal_category = '4', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23420' 28/02/2025 02:48:57 pm >> DELETE FROM ps_specific_price WHERE id_product = '23420' 28/02/2025 02:49:11 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736529' AND id_product != '23420' AND ean13 != '' 28/02/2025 02:49:11 pm >> UPDATE ps_product SET id_supplier = '168', reference = '5/1', ean13 = '9791280736529', date_upd = NOW() WHERE id_product = '23420' 28/02/2025 02:49:11 pm >> UPDATE ps_product_lang SET name = 'SPERANZA. per vivere nella gioia - R. LUPI', description = '

La speranza appartiene alle virtù teologali. La speranza per un cristiano, secondo un’affermazione di papa Francesco, è «come l’aria che  respira», perché ci mantiene sempre vivaci e in tensione verso Gesù. Questo poster riassume visivamente questo tema così importante per la fede cristiana offrendone i fondamenti e i segni concreti. Utile da esporre nei luoghi in cui si fa catechesi in particolar modo in questo Anno Santo che ha come tema la speranza.

' WHERE id_product = '23420' 28/02/2025 02:49:11 pm >> UPDATE ps_product SET wholesale_price = '1.24', on_sale = '0', price = '3.0000' WHERE id_product = '23420' 28/02/2025 02:49:11 pm >> UPDATE ps_product_shop SET wholesale_price = '1.24', price = '3.0000', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '41', id_internal_category = '4', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23420' 28/02/2025 02:49:11 pm >> DELETE FROM ps_specific_price WHERE id_product = '23420' 28/02/2025 03:28:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '619' AND id_document != '95911' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-25') 28/02/2025 03:28:27 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '619', document_date = '2025-02-25', 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 = '139.00', price_tax_excluded = '113.93', date_upd = NOW() WHERE id_document = '95911' 28/02/2025 03:28: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 = '95911' 28/02/2025 03:28:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '95911' 28/02/2025 03:28: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 ( '95911' , '15210' , 'CERO PASQUALE API 80X120' , '2' , '-2' , '1' , '69.5' , '56.967213114754' , '22' , '0' , '139.00' ) 28/02/2025 03:28:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '537' AND id_document != '95809' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-19') 28/02/2025 03:28:43 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '537', document_date = '2025-02-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '225.00', price_tax_excluded = '184.43', date_upd = NOW() WHERE id_document = '95809' 28/02/2025 03:28: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 = '95809' 28/02/2025 03:28:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '95809' 28/02/2025 03:28: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 ( '95809' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '45.00' ) 28/02/2025 03:28: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 ( '95809' , '15210' , 'CERO PASQUALE API 80X120' , '3' , '-3' , '1' , '60' , '49.180327868852' , '22' , '0' , '180.00' ) 28/02/2025 03:29:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '921' AND id_document != '90973' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-26') 28/02/2025 03:29:03 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '921', document_date = '2024-03-26', 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 = '340.00', price_tax_excluded = '278.69', date_upd = NOW() WHERE id_document = '90973' 28/02/2025 03:29:03 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 = '90973' 28/02/2025 03:29:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '90973' 28/02/2025 03:29:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90973' , '15210' , 'CERO PASQUALE API 80X120' , '2' , '-2' , '1' , '80' , '65.573770491803' , '22' , '0' , '160.00' ) 28/02/2025 03:29:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90973' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '60' , '-60' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '180.00' ) 28/02/2025 03:29:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '860' AND id_document != '90898' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-22') 28/02/2025 03:29:33 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '860', document_date = '2024-03-22', 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 = '188.00', price_tax_excluded = '154.55', date_upd = NOW() WHERE id_document = '90898' 28/02/2025 03:29:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90898' 28/02/2025 03:29:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '90898' 28/02/2025 03:29:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90898' , '15210' , 'CERO PASQUALE API 80X120' , '2' , '-2' , '1' , '70' , '57.377049180328' , '22' , '0' , '140.00' ) 28/02/2025 03:29:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90898' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.9000' , '14.672131147541' , '22' , '0' , '35.80' ) 28/02/2025 03:29:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90898' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.2000' , '3.0769230769231' , '4' , '0' , '3.20' ) 28/02/2025 03:29:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90898' , '17005' , 'BIGLIETTO AUGURALE medio' , '9' , '-9' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '9.00' ) 28/02/2025 03:29:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '859' AND id_document != '90897' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-22') 28/02/2025 03:29:49 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '859', document_date = '2024-03-22', 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 = '140.00', price_tax_excluded = '114.75', date_upd = NOW() WHERE id_document = '90897' 28/02/2025 03:29: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 = '90897' 28/02/2025 03:29:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '90897' 28/02/2025 03:29: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 ( '90897' , '15210' , 'CERO PASQUALE API 80X120' , '2' , '-2' , '1' , '70' , '57.377049180328' , '22' , '0' , '140.00' ) 28/02/2025 03:30:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '747' AND id_document != '90754' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-14') 28/02/2025 03:30:10 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '747', document_date = '2024-03-14', 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 = '156.50', price_tax_excluded = '128.28', date_upd = NOW() WHERE id_document = '90754' 28/02/2025 03:30:10 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 = '90754' 28/02/2025 03:30:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '90754' 28/02/2025 03:30:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90754' , '15210' , 'CERO PASQUALE API 80X120' , '2' , '-2' , '1' , '70' , '57.377049180328' , '22' , '0' , '140.00' ) 28/02/2025 03:30:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90754' , '17617' , 'IMMAGINI ISONZO X 100' , '5' , '-5' , '1' , '3.3000' , '2.7049180327869' , '22' , '0' , '16.50' ) 28/02/2025 03:30:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '852' AND id_document != '90885' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-21') 28/02/2025 03:30:42 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '852', document_date = '2024-03-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '140.00', price_tax_excluded = '114.75', date_upd = NOW() WHERE id_document = '90885' 28/02/2025 03:30: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 = '90885' 28/02/2025 03:30:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '90885' 28/02/2025 03:30: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 ( '90885' , '15210' , 'CERO PASQUALE API 80X120' , '2' , '-2' , '1' , '70' , '57.377049180328' , '22' , '0' , '140.00' ) 28/02/2025 03:30:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '851' AND id_document != '90884' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-21') 28/02/2025 03:30:55 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '851', document_date = '2024-03-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '180.00', price_tax_excluded = '147.54', date_upd = NOW() WHERE id_document = '90884' 28/02/2025 03:30: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 = '90884' 28/02/2025 03:30:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '90884' 28/02/2025 03:30: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 ( '90884' , '15210' , 'CERO PASQUALE API 80X120' , '2' , '-2' , '1' , '70' , '57.377049180328' , '22' , '0' , '140.00' ) 28/02/2025 03:30: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 ( '90884' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' , '-1' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '25.00' ) 28/02/2025 03:30: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 ( '90884' , '1041' , 'BENEDIZIONI' , '100' , '-100' , '1' , '0.1500' , '0.12295081967213' , '22' , '0' , '15.00' ) 28/02/2025 04:14:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '670' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-28') 28/02/2025 04:14:02 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' , '670' , '2025-02-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.72' , '24.72' , NOW() , NOW() ) 28/02/2025 04: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 = '95969' 28/02/2025 04:14:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '95969' 28/02/2025 04: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 ( '95969' , '22202' , 'MANUALE DEL PERFETTO CHIERICHETTO - D. COSO' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 28/02/2025 04: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 ( '95969' , '23386' , 'SEMPRE IN VIA - A. BERGAMO' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 28/02/2025 04: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 ( '95969' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '4' , '-4' , '4' , '2.50' , '2.5' , '0' , '5' , '9.52' ) 28/02/2025 04:59:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '671' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-28') 28/02/2025 04:59:15 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' , '671' , '2025-02-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '90.00' , NOW() , NOW() ) 28/02/2025 04:59: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 = '95970' 28/02/2025 04:59:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '95970' 28/02/2025 04:59: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 ( '95970' , '' , 'DALMATICA' , '1' , '-1' , '0' , '90' , '90' , '' , '0' , '90.00' ) 28/02/2025 05:00:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '671' AND id_document != '95970' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-28') 28/02/2025 05:00:03 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '671', document_date = '2025-02-28', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = 'CAUSALE: ACQUISTO MATERIALE LITURGICO', 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 = '90.00', date_upd = NOW() WHERE id_document = '95970' 28/02/2025 05:00:03 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 = '95970' 28/02/2025 05:00:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '95970' 28/02/2025 05:00:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95970' , '0' , 'DALMATICA' , '1' , '-1' , '0' , '90.0000' , '90' , '0' , '0' , '90.00' ) 28/02/2025 05:00:20 pm >> DELETE FROM ps_document WHERE id_document = '95970' 28/02/2025 05:00:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '95970' 28/02/2025 05:05:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '671' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-28') 28/02/2025 05:05:13 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' , '671' , '2025-02-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '278.00' , '232.38' , NOW() , NOW() ) 28/02/2025 05:05:13 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 = '95971' 28/02/2025 05:05:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '95971' 28/02/2025 05:05:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95971' , '15917' , 'STOLA DIACONALE CROCE - AESP06' , '2' , '-2' , '1' , '57.00' , '46.72131147541' , '22' , '0' , '114.00' ) 28/02/2025 05:05:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95971' , '780' , 'ASPERGES MAXI CON CUSTODIA - 700' , '1' , '-1' , '1' , '49.00' , '40.16393442623' , '22' , '0' , '49.00' ) 28/02/2025 05:05:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95971' , '' , 'DALMATICA' , '1' , '-1' , '1' , '90' , '73.770491803279' , '22' , '0' , '90.00' ) 28/02/2025 05:05:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95971' , '5762' , 'LEZIONARIO E RITO DEL MATRIMONIO - KIT 2 VOL.' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '0' , '25.00' ) 28/02/2025 05:07:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '672' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-28') 28/02/2025 05:07:14 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '672' , '2025-02-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '54.00' , '44.26' , NOW() , NOW() ) 28/02/2025 05:07:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95972' 28/02/2025 05:07:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '95972' 28/02/2025 05:07:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95972' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 28/02/2025 05:07:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95972' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 28/02/2025 05:07: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 ( '95972' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 28/02/2025 05:27:44 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'JI6JybYWCh3FYAH9' , NOW() , NOW() ) 28/02/2025 05:27:44 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4167' , '1' ) 28/02/2025 05:27:44 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4167' , '2' ) 28/02/2025 05:27:44 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4167' , '3' ) 28/02/2025 05:28:33 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4167' 28/02/2025 05:28:33 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4167' , '10' , '210' , 'PARR. S. AGOSTINO E CATTEDRALE SALERNO' , 'MOLITERNO' , 'DON FELICE' , 'VIA DUOMO' , '' , '84100' , 'SALERNO' , '' , '' , '' , '' , '' , NOW() , NOW() ) 28/02/2025 05:28:33 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4167' 28/02/2025 05:29:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '45/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-02-28') 28/02/2025 05:29:11 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '45/A' , '2025-02-28' , 'A' , '4167' , '0' , '4679470' , 'VIA DUOMO 84100 SALERNO' , '' , 'RITIRA CERASUOLO ANTONIO' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '90.00' , '90.00' , NOW() , NOW() ) 28/02/2025 05:29: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 = '95973' 28/02/2025 05:29:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '95973' 28/02/2025 05:29:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95973' , '' , 'DALMATICA' , '1' , '-1' , '0' , '90' , '90' , '' , '0' , '90.00' ) 28/02/2025 05:31:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '605' AND id_document != '95895' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-24') 28/02/2025 05:31:12 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '605', document_date = '2025-02-24', 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.70', price_tax_excluded = '2.43', date_upd = NOW() WHERE id_document = '95895' 28/02/2025 05:31:12 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 = '95895' 28/02/2025 05:31:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '95895' 28/02/2025 05:31: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 ( '95895' , '5958' , 'LUCAS 25G - FIORI DARANCIO - EVE ' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 28/02/2025 05:31: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 ( '95895' , '6663' , 'MIE PREGHIERE - 8783' , '1' , '-1' , '4' , '1.2' , '1.2' , '0' , '0' , '1.20' ) 28/02/2025 05:40:53 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '2025-FV000251' , '2025-02-28' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '19' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '432.45' , '432.45' , NOW() , NOW() ) 28/02/2025 05:40:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95974' 28/02/2025 05:40:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '95974' 28/02/2025 05:40: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 ( '95974' , '5763' , 'LEZIONARIO FERIALE ANNO DISPARI - TEMPO ORDINARIO' , '1' , '0' , '4' , '60.0000' , '60' , '0' , '35' , '39.00' ) 28/02/2025 05:40:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5763' AND id_supplier = '79' 28/02/2025 05:40:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5763' , '79' , '1' ) 28/02/2025 05:40: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 ( '95974' , '21655' , 'BENEDIZIONALE N. E. ' , '2' , '0' , '4' , '40.0000' , '40' , '0' , '35' , '52.00' ) 28/02/2025 05:40:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21655' AND id_supplier = '79' 28/02/2025 05:40:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21655' , '79' , '1' ) 28/02/2025 05:40: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 ( '95974' , '23404' , 'QUINTO SIGILLO - N. BUX' , '1' , '0' , '4' , '11.36' , '11.36' , '0' , '45' , '6.2480' ) 28/02/2025 05:40:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23404' AND id_supplier = '79' 28/02/2025 05:40:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23404' , '79' , '1' ) 28/02/2025 05:40: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 ( '95974' , '21656' , 'SACRAMENTO DELLUNZIONE E CURA PASTORALE N.E.' , '2' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '26.00' ) 28/02/2025 05:40:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21656' AND id_supplier = '79' 28/02/2025 05:40:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21656' , '79' , '1' ) 28/02/2025 05:40: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 ( '95974' , '21612' , 'RITO ESEQUIE - ED. MIN.- N.E.' , '1' , '0' , '4' , '30.0000' , '30' , '0' , '35' , '19.50' ) 28/02/2025 05:40:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21612' AND id_supplier = '79' 28/02/2025 05:40:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21612' , '79' , '1' ) 28/02/2025 05:40: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 ( '95974' , '23405' , 'DIARIO SANTA FAUSTINA - N.E.' , '2' , '0' , '4' , '15.0000' , '15' , '0' , '45' , '16.50' ) 28/02/2025 05:40:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23405' AND id_supplier = '79' 28/02/2025 05:40:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23405' , '79' , '1' ) 28/02/2025 05:40: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 ( '95974' , '23441' , 'ANTIQUA ET NOVA' , '10' , '0' , '4' , '3.9000' , '3.9' , '0' , '45' , '21.45' ) 28/02/2025 05:40:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23441' AND id_supplier = '79' 28/02/2025 05:40:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23441' , '79' , '1' ) 28/02/2025 05:40: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 ( '95974' , '21614' , 'RITO DEL BATTESIMO DEI BAMBINI N.E.' , '3' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '39.00' ) 28/02/2025 05:40:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21614' AND id_supplier = '79' 28/02/2025 05:40:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21614' , '79' , '1' ) 28/02/2025 05:40: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 ( '95974' , '10119' , 'SPE SALVI' , '2' , '0' , '4' , '2.0000' , '2' , '0' , '45' , '2.20' ) 28/02/2025 05:40:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10119' AND id_supplier = '79' 28/02/2025 05:40:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10119' , '79' , '1' ) 28/02/2025 05:40: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 ( '95974' , '21612' , 'RITO ESEQUIE - ED. MIN.- N.E.' , '3' , '0' , '4' , '30.0000' , '30' , '0' , '35' , '58.50' ) 28/02/2025 05:40:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21612' AND id_supplier = '79' 28/02/2025 05:40:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21612' , '79' , '1' ) 28/02/2025 05:40: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 ( '95974' , '21615' , 'RITO DELLA COMUNIONE FUORI DELLA MESSA N.E.' , '3' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '39.00' ) 28/02/2025 05:40:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21615' AND id_supplier = '79' 28/02/2025 05:40:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21615' , '79' , '1' ) 28/02/2025 05:40: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 ( '95974' , '23313' , 'LITURGIA PENITENZIALE COMUNITARIA' , '2' , '0' , '4' , '9.5000' , '9.5' , '0' , '45' , '10.45' ) 28/02/2025 05:40:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23313' AND id_supplier = '79' 28/02/2025 05:40:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23313' , '79' , '1' ) 28/02/2025 05:40: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 ( '95974' , '17329' , 'MESSALE ROMANO D\'ALTARE N.E' , '1' , '0' , '4' , '110.0000' , '110' , '0' , '30' , '77.00' ) 28/02/2025 05:40:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '79' 28/02/2025 05:40:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '79' , '1' ) 28/02/2025 05:40: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 ( '95974' , '23478' , 'MESSAGGIO PER LA QUARESIMA 2025' , '10' , '0' , '4' , '1.2000' , '1.2' , '0' , '45' , '6.60' ) 28/02/2025 05:40:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23478' AND id_supplier = '79' 28/02/2025 05:40:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23478' , '79' , '1' ) 28/02/2025 05:57:11 pm >> UPDATE ps_document SET id_document_type = '32', document_num = '2025-FV000251', document_date = '2025-02-28', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2686', address1 = 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO', address2 = '', note = '', price_shipping = '19.5', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '11', id_causal = '0', price_tax_included = '432.95', price_tax_excluded = '432.95', date_upd = NOW() WHERE id_document = '95974' 28/02/2025 05:57: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 = '95974' 28/02/2025 05:57:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '95974' 28/02/2025 05:57: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 ( '95974' , '5763' , 'LEZIONARIO FERIALE ANNO DISPARI - TEMPO ORDINARIO' , '1' , '0' , '4' , '60.0000' , '60' , '0' , '35' , '39.00' ) 28/02/2025 05:57: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 ( '95974' , '21655' , 'BENEDIZIONALE N. E. ' , '2' , '0' , '4' , '40.0000' , '40' , '0' , '35' , '52.00' ) 28/02/2025 05:57: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 ( '95974' , '23404' , 'QUINTO SIGILLO - N. BUX' , '1' , '0' , '4' , '11.3600' , '11.36' , '0' , '45' , '6.25' ) 28/02/2025 05:57: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 ( '95974' , '21656' , 'SACRAMENTO DELLUNZIONE E CURA PASTORALE N.E.' , '2' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '26.00' ) 28/02/2025 05:57: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 ( '95974' , '21612' , 'RITO ESEQUIE - ED. MIN.- N.E.' , '1' , '0' , '4' , '30.0000' , '30' , '0' , '35' , '19.50' ) 28/02/2025 05:57: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 ( '95974' , '23405' , 'DIARIO SANTA FAUSTINA - N.E.' , '2' , '0' , '4' , '15.0000' , '15' , '0' , '45' , '16.50' ) 28/02/2025 05:57: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 ( '95974' , '23441' , 'ANTIQUA ET NOVA' , '10' , '0' , '4' , '3.9000' , '3.9' , '0' , '45' , '21.45' ) 28/02/2025 05:57: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 ( '95974' , '21614' , 'RITO DEL BATTESIMO DEI BAMBINI N.E.' , '3' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '39.00' ) 28/02/2025 05:57: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 ( '95974' , '10119' , 'SPE SALVI' , '2' , '0' , '4' , '2.0000' , '2' , '0' , '45' , '2.20' ) 28/02/2025 05:57: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 ( '95974' , '21612' , 'RITO ESEQUIE - ED. MIN.- N.E.' , '3' , '0' , '4' , '30.0000' , '30' , '0' , '35' , '58.50' ) 28/02/2025 05:57: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 ( '95974' , '21615' , 'RITO DELLA COMUNIONE FUORI DELLA MESSA N.E.' , '3' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '39.00' ) 28/02/2025 05:57: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 ( '95974' , '23313' , 'LITURGIA PENITENZIALE COMUNITARIA' , '2' , '0' , '4' , '9.5000' , '9.5' , '0' , '45' , '10.45' ) 28/02/2025 05:57: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 ( '95974' , '17329' , 'MESSALE ROMANO D\'ALTARE N.E' , '1' , '0' , '4' , '110.0000' , '110' , '0' , '30' , '77.00' ) 28/02/2025 05:57: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 ( '95974' , '23478' , 'MESSAGGIO PER LA QUARESIMA 2025' , '10' , '0' , '4' , '1.2000' , '1.2' , '0' , '45' , '6.60' ) 28/02/2025 06:11:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '673' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-28') 28/02/2025 06:11:16 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' , '673' , '2025-02-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '10.00' , NOW() , NOW() ) 28/02/2025 06:11: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 = '95975' 28/02/2025 06:11:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '95975' 28/02/2025 06:11: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 ( '95975' , '18810' , 'ANTIFONE - E. DELLA CORTE' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 28/02/2025 06:28:50 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '2025010000327' , '2025-02-28' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '14' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '257.40' , '257.40' , NOW() , NOW() ) 28/02/2025 06:28:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95976' 28/02/2025 06:28:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '95976' 28/02/2025 06:28:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95976' , '23409' , 'VIA CRUCIS DEL GIUBILEO - RUCCIA/SCALERA' , '1' , '1' , '4' , '10.0000' , '10' , '0' , '35' , '6.50' ) 28/02/2025 06:28:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23409' AND id_supplier = '107' 28/02/2025 06:28:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23409' , '107' , '1' ) 28/02/2025 06:28:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95976' , '23410' , 'TRIDUO PASQUALE PER NOI E PER IL MONDO - G. FLORIO' , '1' , '1' , '4' , '10.0000' , '10' , '0' , '35' , '6.50' ) 28/02/2025 06:28:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23410' AND id_supplier = '107' 28/02/2025 06:28:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23410' , '107' , '1' ) 28/02/2025 06:28:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95976' , '23411' , 'CARLO ACUTIS SULLE ORME DI FRANCESCO - D. SORRENTINO' , '2' , '2' , '4' , '12.0000' , '12' , '0' , '35' , '15.60' ) 28/02/2025 06:28:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23411' AND id_supplier = '107' 28/02/2025 06:28:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23411' , '107' , '1' ) 28/02/2025 06:28:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95976' , '23412' , 'EUCARISTIA DONO E MISTERO' , '1' , '1' , '4' , '40.0000' , '40' , '0' , '35' , '26.00' ) 28/02/2025 06:28:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23412' AND id_supplier = '107' 28/02/2025 06:28:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23412' , '107' , '1' ) 28/02/2025 06:28:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95976' , '22995' , 'MINISTRO STRAORDINARIO DELLA COMUNIONE' , '1' , '1' , '4' , '7.0000' , '7' , '0' , '35' , '4.55' ) 28/02/2025 06:28:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22995' AND id_supplier = '107' 28/02/2025 06:28:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22995' , '107' , '1' ) 28/02/2025 06:28: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 ( '95976' , '21847' , 'UNDICESIMO: SALVA LA TESTA! - P. PELLEGRINO' , '20' , '20' , '4' , '3.0000' , '3' , '0' , '35' , '39.00' ) 28/02/2025 06:28:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21847' AND id_supplier = '107' 28/02/2025 06:28:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21847' , '107' , '1' ) 28/02/2025 06:28: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 ( '95976' , '4229' , 'FONTI FRANCESCANE - ED. MINOR' , '5' , '5' , '4' , '35.0000' , '35' , '0' , '30' , '122.50' ) 28/02/2025 06:28:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4229' AND id_supplier = '107' 28/02/2025 06:28:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4229' , '107' , '1' ) 28/02/2025 06:28: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 ( '95976' , '17673' , 'FUI CHIAMATO DOLINDO' , '1' , '1' , '4' , '35.0000' , '35' , '0' , '35' , '22.75' ) 28/02/2025 06:28:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17673' AND id_supplier = '107' 28/02/2025 06:28:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17673' , '107' , '1' ) 28/02/2025 06:46:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '22' AND id_document != '95544' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-02-01') 28/02/2025 06:46:17 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '22', document_date = '2025-02-01', document_letter = '', id_customer = '4161', id_supplier = '', id_address = '4679461', address1 = 'VIA G. OBERDAN 35 27029 VIGEVANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '80.75', price_tax_excluded = '80.75', date_upd = NOW() WHERE id_document = '95544' 28/02/2025 06:46:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95544' 28/02/2025 06:46:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '95544' 28/02/2025 06:46:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95544' , '17827' , 'ISTRUZIONI FAMILIARI VOL. I - IL CREDO ' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 28/02/2025 06:46:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95544' , '18717' , 'ISTRUZIONI FAMILIARI VOL. II - I DIECI COMANDAMENTI ' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 28/02/2025 06:46:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95544' , '19391' , 'ISTRUZIONI FAMILIARI VOL. III - I PRECETTI...' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 28/02/2025 06:46:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95544' , '21799' , 'ISTRUZIONI FAMILIARI VOL. IV - I VIZI E I SCARAMENTI' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '5' , '23.75' ) 28/02/2025 06:47:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '25' AND id_document != '95571' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-02-03') 28/02/2025 06:47:36 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '25', document_date = '2025-02-03', document_letter = '', id_customer = '4158', id_supplier = '', id_address = '4679458', address1 = 'VIA ANTONIO BENNICELLI 71 00151 ROMA', address2 = '', note = '', price_shipping = '5.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '19.25', price_tax_excluded = '19.25', date_upd = NOW() WHERE id_document = '95571' 28/02/2025 06:47:36 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95571' 28/02/2025 06:47:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '95571' 28/02/2025 06:47:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95571' , '23393' , 'SULLA TUA PAROLA - MAR/APR 25' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '5' , '14.25' ) 28/02/2025 07:21:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '674' AND id_document != '' AND id_document_type LIKE '13' AND YEAR(document_date) = YEAR('2025-02-28') 28/02/2025 07:21:53 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '674' , '2025-02-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.50' , '16.83' , NOW() , NOW() ) 28/02/2025 07:21:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95977' 28/02/2025 07:21:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '95977' 28/02/2025 07:21:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95977' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 28/02/2025 07:32:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '675' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-28') 28/02/2025 07:32:45 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' , '675' , '2025-02-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '312.50' , '260.20' , NOW() , NOW() ) 28/02/2025 07:32:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95978' 28/02/2025 07:32:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '95978' 28/02/2025 07:32:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95978' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '9' , '9' , '0' , '0' , '18.00' ) 28/02/2025 07:32:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95978' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 28/02/2025 07:32:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95978' , '14163' , 'PARACERA OTTONE LUCIDO - Q120' , '1' , '-1' , '1' , '50.00' , '40.983606557377' , '22' , '0' , '50.00' ) 28/02/2025 07:32:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95978' , '12578' , 'RICAMBIO VETRO PER ART. 486 - 65' , '2' , '-2' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '30.00' ) 28/02/2025 07:32:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95978' , '13079' , 'COPPIA CANDELIERI IN LEGNO - 033' , '1' , '-1' , '1' , '55.00' , '45.081967213115' , '22' , '0' , '55.00' ) 28/02/2025 07:32:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95978' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 28/02/2025 07:32:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95978' , '20790' , 'AI PIEDI DEL SUO AMORE ' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 28/02/2025 07:32:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95978' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '5' , '-5' , '1' , '24' , '19.672131147541' , '22' , '0' , '120.00' ) 28/02/2025 07:32:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95978' , '19104' , 'LUMINELLI A OLIO' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 28/02/2025 07:32:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95978' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 28/02/2025 07:46:19 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '374' 28/02/2025 07:46:19 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '374' , '10' , '210' , 'PARR. SANTA MARIA E SAN NICOLA' , 'GRANOZIO' , 'DON VITO' , 'VIA OGLIARA 138' , '' , '84135' , 'OGLIARA' , 'C' , '' , '' , '' , '' , NOW() , NOW() ) 28/02/2025 07:46:19 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '374' 28/02/2025 07:47:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '38' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-03-01') 28/02/2025 07:47:33 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' , '38' , '2025-03-01' , '' , '374' , '0' , '4679471' , 'VIA OGLIARA 138 84135 OGLIARA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.00' , '34.00' , NOW() , NOW() ) 28/02/2025 07:47:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95979' 28/02/2025 07:47:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '95979' 28/02/2025 07:47:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95979' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '20' , '-20' , '4' , '2.00' , '2' , '0' , '15' , '34.00' ) 28/02/2025 07:49:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '38' AND id_document != '95979' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-03-01') 28/02/2025 07:49:59 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '38', document_date = '2025-03-01', document_letter = '', id_customer = '374', id_supplier = '', id_address = '4679471', address1 = 'VIA OGLIARA 138 84135 OGLIARA', 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 = '34.00', price_tax_excluded = '34.00', date_upd = NOW() WHERE id_document = '95979' 28/02/2025 07:49:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95979' 28/02/2025 07:49:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '95979' 28/02/2025 07:49:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95979' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '20' , '-20' , '4' , '2.0000' , '2' , '0' , '15' , '34.00' )