04/07/2025 01:11:03 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 04/07/2025 01:11:03 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23853' , '1' , '' , 'nuovo-prodotto' ) 04/07/2025 01:11:03 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23853' , '1' , '1' , '2' , NOW() , NOW() ) 04/07/2025 01:11:03 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23853' , '0' , '1' , '0' , '0' ) 04/07/2025 01:11:04 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , '5hcbU712Wk36X1eC' , NOW() , NOW() ) 04/07/2025 01:11:04 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7146' , '1' ) 04/07/2025 01:11:04 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7146' , '2' ) 04/07/2025 01:11:04 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7146' , '3' ) 04/07/2025 01:11:05 am >> INSERT INTO ps_supplier ( name , email , `date_add` , `date_upd` ) VALUES ( '' , '' , NOW() , NOW() ) 04/07/2025 01:11:05 am >> INSERT INTO ps_supplier_shop ( id_supplier , id_shop ) VALUES ( '210' , '1' ) 04/07/2025 01:11:05 am >> INSERT INTO ps_supplier_lang ( id_supplier , id_lang ) VALUES ( '210' , '1' ) 04/07/2025 01:11:05 am >> INSERT INTO ps_address ( id_supplier , id_country , id_state , alias , lastname , firstname , address1 , city , date_add , date_upd ) VALUES ( '210' , '10' , '0' , '' , '' , '' , '' , '' , NOW() , NOW() ) 04/07/2025 01:11:06 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'b102pN2VdtpOvjfP' , NOW() , NOW() ) 04/07/2025 01:11:06 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4219' , '1' ) 04/07/2025 01:11:06 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4219' , '2' ) 04/07/2025 01:11:06 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4219' , '3' ) 04/07/2025 09:30:25 am >> SELECT document_num FROM ps_document WHERE document_num = '2358' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-04') 04/07/2025 09:30:25 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2358' , '2025-07-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '45.55' , NOW() , NOW() ) 04/07/2025 09:30:25 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97982' 04/07/2025 09:30:25 am >> DELETE FROM ps_document_detail WHERE id_document = '97982' 04/07/2025 09:30:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97982' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '8.50' ) 04/07/2025 09:30:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97982' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 04/07/2025 09:30:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97982' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 04/07/2025 09:30:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97982' , '20026' , 'CANDELA VOTIVA 20X40' , '3' , '-3' , '1' , '2' , '1.6393442622951' , '22' , '0' , '6.00' ) 04/07/2025 09:30:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97982' , '15387' , 'VESTINA BATTESIMALE ' , '3' , '-3' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '9.00' ) 04/07/2025 09:30:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97982' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '30' , '-30' , '4' , '0.70' , '0.7' , '0' , '0' , '21.00' ) 04/07/2025 09:33:14 am >> SELECT document_num FROM ps_document WHERE document_num = '2359' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-04') 04/07/2025 09:33:14 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' , '2359' , '2025-07-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.20' , '15.20' , NOW() , NOW() ) 04/07/2025 09:33:14 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 = '97983' 04/07/2025 09:33:14 am >> DELETE FROM ps_document_detail WHERE id_document = '97983' 04/07/2025 09:33:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97983' , '23751' , 'GESU VERAMENTE - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 04/07/2025 09:51:32 am >> SELECT document_num FROM ps_document WHERE document_num = '2360' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-04') 04/07/2025 09:51: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' , '2360' , '2025-07-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '6.97' , NOW() , NOW() ) 04/07/2025 09:51: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 = '97984' 04/07/2025 09:51:32 am >> DELETE FROM ps_document_detail WHERE id_document = '97984' 04/07/2025 09:51: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 ( '97984' , '20162' , 'ROSARIO SAN BENEDETTO - 195/23' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 04/07/2025 09:51: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 ( '97984' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '3.50' ) 04/07/2025 09:51:50 am >> SELECT document_num FROM ps_document WHERE document_num = '2360' AND id_document != '97984' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-04') 04/07/2025 09:51:50 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2360', document_date = '2025-07-04', 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 = '8.50', price_tax_excluded = '6.97', date_upd = NOW() WHERE id_document = '97984' 04/07/2025 09:51:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97984' 04/07/2025 09:51:50 am >> DELETE FROM ps_document_detail WHERE id_document = '97984' 04/07/2025 09:51:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97984' , '20162' , 'ROSARIO SAN BENEDETTO - 195/23' , '1' , '-1' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '5.00' ) 04/07/2025 09:51:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97984' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 04/07/2025 09:52:00 am >> SELECT document_num FROM ps_document WHERE document_num = '2360' AND id_document != '97984' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-04') 04/07/2025 09:52:00 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2360', document_date = '2025-07-04', 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 = '8.50', price_tax_excluded = '6.97', date_upd = NOW() WHERE id_document = '97984' 04/07/2025 09:52: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 = '97984' 04/07/2025 09:52:00 am >> DELETE FROM ps_document_detail WHERE id_document = '97984' 04/07/2025 09:52: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 ( '97984' , '20162' , 'ROSARIO SAN BENEDETTO - 195/23' , '1' , '-1' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '5.00' ) 04/07/2025 09:52: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 ( '97984' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 04/07/2025 09:52:28 am >> SELECT document_num FROM ps_document WHERE document_num = '2360' AND id_document != '97984' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-04') 04/07/2025 09:52:28 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2360', document_date = '2025-07-04', 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 = '8.50', price_tax_excluded = '6.97', date_upd = NOW() WHERE id_document = '97984' 04/07/2025 09:52: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 = '97984' 04/07/2025 09:52:28 am >> DELETE FROM ps_document_detail WHERE id_document = '97984' 04/07/2025 09:52: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 ( '97984' , '20162' , 'ROSARIO SAN BENEDETTO - 195/23' , '1' , '-1' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '5.00' ) 04/07/2025 09:52: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 ( '97984' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 04/07/2025 10:06:00 am >> SELECT document_num FROM ps_document WHERE document_num = '2361' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-04') 04/07/2025 10:06: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' , '2361' , '2025-07-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.00' , '19.39' , NOW() , NOW() ) 04/07/2025 10:06: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 = '97985' 04/07/2025 10:06:00 am >> DELETE FROM ps_document_detail WHERE id_document = '97985' 04/07/2025 10:06: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 ( '97985' , '20063' , 'BRACCIALE EMATITE - BC2023S' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 04/07/2025 10:06: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 ( '97985' , '9486' , 'S. MICHELE ARC. BABY - PB19076' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 04/07/2025 10:06: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 ( '97985' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 04/07/2025 10:38:02 am >> SELECT document_num FROM ps_document WHERE document_num = '2362' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-04') 04/07/2025 10:38: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' , '2362' , '2025-07-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 04/07/2025 10:38: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 = '97986' 04/07/2025 10:38:02 am >> DELETE FROM ps_document_detail WHERE id_document = '97986' 04/07/2025 10:38: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 ( '97986' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 04/07/2025 10:38: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 ( '97986' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 04/07/2025 10:46:01 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256392483' AND id_product != '23853' AND ean13 != '' 04/07/2025 10:46:01 am >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE SHALOM', ean13 = '9791256392483', date_upd = NOW() WHERE id_product = '23853' 04/07/2025 10:46:01 am >> UPDATE ps_product_lang SET name = 'COMPRENDI DAVVERO LA MESSA?', description = '' WHERE id_product = '23853' 04/07/2025 10:46:01 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7' WHERE id_product = '23853' 04/07/2025 10:46:02 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23853' 04/07/2025 10:46:02 am >> DELETE FROM ps_specific_price WHERE id_product = '23853' 04/07/2025 10:46:13 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256392483' AND id_product != '23853' AND ean13 != '' 04/07/2025 10:46:13 am >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE SHALOM', ean13 = '9791256392483', date_upd = NOW() WHERE id_product = '23853' 04/07/2025 10:46:13 am >> UPDATE ps_product_lang SET name = 'COMPRENDI DAVVERO LA MESSA? - 8184', description = '' WHERE id_product = '23853' 04/07/2025 10:46:13 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7' WHERE id_product = '23853' 04/07/2025 10:46:13 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23853' 04/07/2025 10:46:13 am >> DELETE FROM ps_specific_price WHERE id_product = '23853' 04/07/2025 10:46:55 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884040329' AND id_product != '7096' AND ean13 != '' 04/07/2025 10:46:55 am >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788884040329', date_upd = NOW() WHERE id_product = '7096' 04/07/2025 10:46:55 am >> UPDATE ps_product_lang SET name = 'NOVE PRIMI VENERDÍ DEL MESE - 8247', description = '' WHERE id_product = '7096' 04/07/2025 10:46:55 am >> UPDATE ps_product SET wholesale_price = '1.20', on_sale = '0', price = '3' WHERE id_product = '7096' 04/07/2025 10:46:55 am >> UPDATE ps_product_shop SET wholesale_price = '1.20', price = '3', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7096' 04/07/2025 10:46:55 am >> DELETE FROM ps_specific_price WHERE id_product = '7096' 04/07/2025 10:47:29 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23853' 04/07/2025 10:47:29 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23854' , '1' , '' , 'nuovo-prodotto' ) 04/07/2025 10:47:29 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23854' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23853' 04/07/2025 10:47:29 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23854' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23853' 04/07/2025 10:48:32 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256392568' AND id_product != '23854' AND ean13 != '' 04/07/2025 10:48:32 am >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE SHALOM', ean13 = '9791256392568', date_upd = NOW() WHERE id_product = '23854' 04/07/2025 10:48:32 am >> UPDATE ps_product_lang SET name = 'SANTI DEL MESSALINO - ARMIDA BARELLI - 8270', description = '' WHERE id_product = '23854' 04/07/2025 10:48:32 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3' WHERE id_product = '23854' 04/07/2025 10:48:32 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23854' 04/07/2025 10:48:32 am >> DELETE FROM ps_specific_price WHERE id_product = '23854' 04/07/2025 10:48:34 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23854' 04/07/2025 10:48:34 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23855' , '1' , '' , 'nuovo-prodotto' ) 04/07/2025 10:48:34 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23855' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23854' 04/07/2025 10:48:34 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23855' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23854' 04/07/2025 10:49:12 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256392032' AND id_product != '23855' AND ean13 != '' 04/07/2025 10:49:12 am >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE SHALOM', ean13 = '9791256392032', date_upd = NOW() WHERE id_product = '23855' 04/07/2025 10:49:12 am >> UPDATE ps_product_lang SET name = 'SANTI DEL MESSALINO - GIANNA BERETTA MOLLA - 8277', description = '' WHERE id_product = '23855' 04/07/2025 10:49:13 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3' WHERE id_product = '23855' 04/07/2025 10:49:13 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23855' 04/07/2025 10:49:13 am >> DELETE FROM ps_specific_price WHERE id_product = '23855' 04/07/2025 10:49:14 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23855' 04/07/2025 10:49:14 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23856' , '1' , '' , 'nuovo-prodotto' ) 04/07/2025 10:49:14 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23856' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23855' 04/07/2025 10:49:14 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23856' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23855' 04/07/2025 10:49:52 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256391295' AND id_product != '23856' AND ean13 != '' 04/07/2025 10:49:52 am >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE SHALOM', ean13 = '9791256391295', date_upd = NOW() WHERE id_product = '23856' 04/07/2025 10:49:52 am >> UPDATE ps_product_lang SET name = 'SANTI DEL MESSALINO - SILVIO DISSEGNA - 8897', description = '' WHERE id_product = '23856' 04/07/2025 10:49:52 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3' WHERE id_product = '23856' 04/07/2025 10:49:52 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23856' 04/07/2025 10:49:52 am >> DELETE FROM ps_specific_price WHERE id_product = '23856' 04/07/2025 10:50:45 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884044853' AND id_product != '14940' AND ean13 != '' 04/07/2025 10:50:45 am >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788884044853', date_upd = NOW() WHERE id_product = '14940' 04/07/2025 10:50:45 am >> UPDATE ps_product_lang SET name = 'SAN CHARBEL - 8850', description = '' WHERE id_product = '14940' 04/07/2025 10:50:45 am >> UPDATE ps_product SET wholesale_price = '4.20', on_sale = '0', price = '9' WHERE id_product = '14940' 04/07/2025 10:50:45 am >> UPDATE ps_product_shop SET wholesale_price = '4.20', price = '9', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '14940' 04/07/2025 10:50:45 am >> DELETE FROM ps_specific_price WHERE id_product = '14940' 04/07/2025 10:51:38 am >> SELECT ean13 FROM ps_product WHERE ean13 = '40654' AND id_product != '14295' AND ean13 != '' 04/07/2025 10:51:38 am >> UPDATE ps_product SET id_supplier = '38', reference = '', ean13 = '40654', date_upd = NOW() WHERE id_product = '14295' 04/07/2025 10:51:38 am >> UPDATE ps_product_lang SET name = 'ROSARIO ELETTRONICO', description = '' WHERE id_product = '14295' 04/07/2025 10:51:38 am >> UPDATE ps_product SET wholesale_price = '18.22', on_sale = '0', price = '37.950819672131146' WHERE id_product = '14295' 04/07/2025 10:51:38 am >> UPDATE ps_product_shop SET wholesale_price = '18.22', price = '37.950819672131146', id_tax_rules_group = '1', id_category_default = '106', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '14295' 04/07/2025 10:51:38 am >> DELETE FROM ps_specific_price WHERE id_product = '14295' 04/07/2025 10:51: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 ( '31' , '10183/00/2025' , '2025-07-02' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '147.18' , '142.17' , NOW() , NOW() ) 04/07/2025 10:51: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 = '97987' 04/07/2025 10:51:58 am >> DELETE FROM ps_document_detail WHERE id_document = '97987' 04/07/2025 10:51: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 ( '97987' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '25' , '25' , '4' , '5.00' , '5' , '0' , '40' , '75.0000' ) 04/07/2025 10:51:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '23714' AND id_supplier = '38' 04/07/2025 10:51:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23714' , '38' , '1' ) 04/07/2025 10:51: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 ( '97987' , '19584' , 'UN MESE CON IL SACRO CUORE - 8065' , '1' , '1' , '4' , '5.00' , '5' , '0' , '40' , '3.0000' ) 04/07/2025 10:51:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '19584' AND id_supplier = '38' 04/07/2025 10:51:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19584' , '38' , '1' ) 04/07/2025 10:51: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 ( '97987' , '19671' , 'UN MESE CON IL PREZIOSISSIMO SANGUE - 8074' , '1' , '1' , '4' , '7.00' , '7' , '0' , '40' , '4.2000' ) 04/07/2025 10:51:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '19671' AND id_supplier = '38' 04/07/2025 10:51:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19671' , '38' , '1' ) 04/07/2025 10:51: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 ( '97987' , '8340' , 'PREGHIERE AL PREZIOSISSIMO SANGUE - 8158' , '1' , '1' , '4' , '8.00' , '8' , '0' , '40' , '4.8000' ) 04/07/2025 10:51:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '8340' AND id_supplier = '38' 04/07/2025 10:51:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8340' , '38' , '1' ) 04/07/2025 10:51:59 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 ( '97987' , '23853' , 'COMPRENDI DAVVERO LA MESSA? - 8184' , '2' , '2' , '4' , '7.00' , '7' , '0' , '40' , '8.4000' ) 04/07/2025 10:51:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '23853' AND id_supplier = '38' 04/07/2025 10:51:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23853' , '38' , '1' ) 04/07/2025 10:51:59 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 ( '97987' , '8765' , 'QUINDICI ORAZIONI DI SANTA BRIGIDA - 8193' , '2' , '2' , '4' , '2.00' , '2' , '0' , '40' , '2.4000' ) 04/07/2025 10:51:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '8765' AND id_supplier = '38' 04/07/2025 10:51:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8765' , '38' , '1' ) 04/07/2025 10:51:59 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 ( '97987' , '7096' , 'NOVE PRIMI VENERDÍ DEL MESE - 8247' , '3' , '3' , '4' , '3.00' , '3' , '0' , '40' , '5.4000' ) 04/07/2025 10:51:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '7096' AND id_supplier = '38' 04/07/2025 10:51:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7096' , '38' , '1' ) 04/07/2025 10:51:59 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 ( '97987' , '23854' , 'SANTI DEL MESSALINO - ARMIDA BARELLI - 8270' , '2' , '2' , '4' , '3.00' , '3' , '0' , '40' , '3.6000' ) 04/07/2025 10:51:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '23854' AND id_supplier = '38' 04/07/2025 10:51:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23854' , '38' , '1' ) 04/07/2025 10:51:59 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 ( '97987' , '23855' , 'SANTI DEL MESSALINO - GIANNA BERETTA MOLLA - 8277' , '3' , '3' , '4' , '3.00' , '3' , '0' , '40' , '5.4000' ) 04/07/2025 10:51:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '23855' AND id_supplier = '38' 04/07/2025 10:51:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23855' , '38' , '1' ) 04/07/2025 10:51:59 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 ( '97987' , '14940' , 'SAN CHARBEL - 8850' , '1' , '1' , '4' , '9.00' , '9' , '0' , '40' , '5.4000' ) 04/07/2025 10:51:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '14940' AND id_supplier = '38' 04/07/2025 10:51:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14940' , '38' , '1' ) 04/07/2025 10:51:59 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 ( '97987' , '23856' , 'SANTI DEL MESSALINO - SILVIO DISSEGNA - 8897' , '1' , '1' , '4' , '3.00' , '3' , '0' , '40' , '1.8000' ) 04/07/2025 10:51:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '23856' AND id_supplier = '38' 04/07/2025 10:51:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23856' , '38' , '1' ) 04/07/2025 10:51:59 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 ( '97987' , '14295' , 'ROSARIO ELETTRONICO' , '1' , '1' , '1' , '37.95' , '31.106557377049' , '22' , '40' , '27.7794' ) 04/07/2025 10:52:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '14295' AND id_supplier = '38' 04/07/2025 10:52:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14295' , '38' , '1' ) 04/07/2025 10:57:24 am >> SELECT document_num FROM ps_document WHERE document_num = '2363' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-04') 04/07/2025 10:57:24 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' , '2363' , '2025-07-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.00' , '30.28' , NOW() , NOW() ) 04/07/2025 10:57:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97988' 04/07/2025 10:57:24 am >> DELETE FROM ps_document_detail WHERE id_document = '97988' 04/07/2025 10:57:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97988' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '17.00' ) 04/07/2025 10:57:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97988' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 04/07/2025 10:57:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97988' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 04/07/2025 11:56:20 am >> SELECT document_num FROM ps_document WHERE document_num = '2364' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-04') 04/07/2025 11:56:20 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2364' , '2025-07-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.30' , '39.95' , NOW() , NOW() ) 04/07/2025 11:56:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97989' 04/07/2025 11:56:20 am >> DELETE FROM ps_document_detail WHERE id_document = '97989' 04/07/2025 11:56:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97989' , '14295' , 'ROSARIO ELETTRONICO' , '1' , '-1' , '1' , '46.30' , '37.950819672131' , '22' , '0' , '46.30' ) 04/07/2025 11:56:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97989' , '23647' , 'CONFESSIONE - 8387' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 04/07/2025 12:01:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '2345' AND id_document != '97965' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-02') 04/07/2025 12:01:49 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2345', document_date = '2025-07-02', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '72.00', price_tax_excluded = '60.28', date_upd = NOW() WHERE id_document = '97965' 04/07/2025 12:01: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 = '97965' 04/07/2025 12:01:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '97965' 04/07/2025 12:01: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 ( '97965' , '17349' , 'CROCE TRILOBATA H21 - CL56' , '1' , '-1' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '11.00' ) 04/07/2025 12:01: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 ( '97965' , '21730' , 'CROCE CLASSICA CM 40 - CL51' , '1' , '-1' , '1' , '54.0000' , '44.262295081967' , '22' , '0' , '54.00' ) 04/07/2025 12:01: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 ( '97965' , '9420' , 'SAN FRANCESCO DASSISI' , '1' , '-1' , '4' , '5.5000' , '5.5' , '0' , '' , '5.50' ) 04/07/2025 12:01: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 ( '97965' , '23647' , 'CONFESSIONE - 8387' , '1' , '-1' , '4' , '1.5' , '1.5' , '0' , '0' , '1.50' ) 04/07/2025 12:32:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '2365' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-04') 04/07/2025 12:32:20 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2365' , '2025-07-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.02' , '69.84' , NOW() , NOW() ) 04/07/2025 12:32:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97990' 04/07/2025 12:32:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '97990' 04/07/2025 12:32:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97990' , '23823' , 'AMEN - SET 25' , '3' , '-3' , '4' , '3.90' , '3.9' , '0' , '5' , '11.13' ) 04/07/2025 12:32:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97990' , '23700' , 'AMEN - LUG 25' , '3' , '-3' , '4' , '3.90' , '3.9' , '0' , '5' , '11.13' ) 04/07/2025 12:32:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97990' , '23699' , 'AMEN - AGO 25' , '3' , '-3' , '4' , '3.90' , '3.9' , '0' , '5' , '11.13' ) 04/07/2025 12:32:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97990' , '23822' , 'AMEN - OTT 25' , '3' , '-3' , '4' , '3.90' , '3.9' , '0' , '5' , '11.13' ) 04/07/2025 12:32:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97990' , '18131' , 'TAU MEDIO CM3 - T6/T5' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 04/07/2025 12:32:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97990' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '35' , '-35' , '4' , '0.70' , '0.7' , '0' , '0' , '24.50' ) 04/07/2025 12:41:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '2366' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-04') 04/07/2025 12:41:49 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2366' , '2025-07-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '71.25' , '71.25' , NOW() , NOW() ) 04/07/2025 12:41: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 = '97991' 04/07/2025 12:41:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '97991' 04/07/2025 12:41: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 ( '97991' , '23673' , 'RIVESTITI DI SPERANZA! - V. SIRACUSA' , '15' , '-15' , '4' , '5' , '5' , '0' , '5' , '71.25' ) 04/07/2025 12:45:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '2367' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-04') 04/07/2025 12:45:05 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' , '2367' , '2025-07-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '290.00' , '237.70' , NOW() , NOW() ) 04/07/2025 12:45:05 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 = '97992' 04/07/2025 12:45:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '97992' 04/07/2025 12:45:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97992' , '15041' , 'CAMICE MONASTICO - MISTO' , '1' , '-1' , '1' , '290' , '237.70491803279' , '22' , '0' , '290.00' ) 04/07/2025 12:46:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '2368' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-04') 04/07/2025 12:46:42 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2368' , '2025-07-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.80' , '13.77' , NOW() , NOW() ) 04/07/2025 12:46: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 = '97993' 04/07/2025 12:46:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '97993' 04/07/2025 12:46: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 ( '97993' , '22199' , 'VINO LIQUOROSO ROSSO ' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 04/07/2025 12:46: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 ( '97993' , '11389' , 'VINO ROSSO DOLCE - 103' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 04/07/2025 01:01:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '2369' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-04') 04/07/2025 01:01:55 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2369' , '2025-07-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '202.60' , '172.58' , NOW() , NOW() ) 04/07/2025 01:01: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 = '97994' 04/07/2025 01:01:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '97994' 04/07/2025 01:01: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 ( '97994' , '22354' , 'CROCE SACRAMENTI VARI - 646' , '30' , '-30' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '54.00' ) 04/07/2025 01:01: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 ( '97994' , '15097' , 'CORONA MATRIMONIO - ORO - 197/34' , '15' , '-15' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '112.50' ) 04/07/2025 01:01: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 ( '97994' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 04/07/2025 01:01: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 ( '97994' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 04/07/2025 01:01: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 ( '97994' , '23827' , 'GESTIRE I CONFLITTI - G. MATARAZZO' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 04/07/2025 02:39:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001944' AND id_product != '19346' AND ean13 != '' 04/07/2025 02:39:41 pm >> UPDATE ps_product SET id_supplier = '143', reference = '', ean13 = '001944', date_upd = NOW() WHERE id_product = '19346' 04/07/2025 02:39:41 pm >> UPDATE ps_product_lang SET name = 'CASULA MARIANA LANA LUREX - 65/002005- 348', description = '' WHERE id_product = '19346' 04/07/2025 02:39:41 pm >> UPDATE ps_product SET wholesale_price = '116.40', on_sale = '0', price = '531.9672131147541' WHERE id_product = '19346' 04/07/2025 02:39:41 pm >> UPDATE ps_product_shop SET wholesale_price = '116.40', price = '531.9672131147541', id_tax_rules_group = '1', id_category_default = '468', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19346' 04/07/2025 02:39:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '19346' 04/07/2025 02:40:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001944' AND id_product != '19346' AND ean13 != '' 04/07/2025 02:40:17 pm >> UPDATE ps_product SET id_supplier = '143', reference = '', ean13 = '001944', date_upd = NOW() WHERE id_product = '19346' 04/07/2025 02:40:17 pm >> UPDATE ps_product_lang SET name = 'CASULA MARIANA LANA LUREX - 65/002005- 348', description = '' WHERE id_product = '19346' 04/07/2025 02:40:17 pm >> UPDATE ps_product SET wholesale_price = '116.40', on_sale = '0', price = '531.9672131147541' WHERE id_product = '19346' 04/07/2025 02:40:18 pm >> UPDATE ps_product_shop SET wholesale_price = '116.40', price = '531.9672131147541', id_tax_rules_group = '1', id_category_default = '468', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19346' 04/07/2025 02:40:18 pm >> DELETE FROM ps_specific_price WHERE id_product = '19346' 04/07/2025 02:40:18 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19346' 04/07/2025 02:40:19 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23857' , '1' , '' , 'nuovo-prodotto' ) 04/07/2025 02:40:19 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23857' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19346' 04/07/2025 02:40:19 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23857' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19346' 04/07/2025 02:40:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002393' AND id_product != '23857' AND ean13 != '' 04/07/2025 02:40:59 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002393', date_upd = NOW() WHERE id_product = '23857' 04/07/2025 02:40:59 pm >> UPDATE ps_product_lang SET name = 'CASULA SFUMATA - 65002007', description = '' WHERE id_product = '23857' 04/07/2025 02:40:59 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '483.60655737704917' WHERE id_product = '23857' 04/07/2025 02:40:59 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '483.60655737704917', id_tax_rules_group = '1', id_category_default = '468', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23857' 04/07/2025 02:40:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '23857' 04/07/2025 02:41:00 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23857' 04/07/2025 02:41:00 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23858' , '1' , '' , 'nuovo-prodotto' ) 04/07/2025 02:41:00 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23858' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23857' 04/07/2025 02:41:00 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23858' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23857' 04/07/2025 02:43:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002394' AND id_product != '23858' AND ean13 != '' 04/07/2025 02:43:19 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002394', date_upd = NOW() WHERE id_product = '23858' 04/07/2025 02:43:19 pm >> UPDATE ps_product_lang SET name = 'TALARE FRESCO LANA 100% - 88/000100', description = '' WHERE id_product = '23858' 04/07/2025 02:43:19 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '762.2950819672132' WHERE id_product = '23858' 04/07/2025 02:43:19 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '762.2950819672132', id_tax_rules_group = '1', id_category_default = '468', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23858' 04/07/2025 02:43:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '23858' 04/07/2025 02:43: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 ( '31' , '269' , '2025-07-02' , '' , '0' , '143' , '4670947' , 'VIA DELLE SELVETTE 324 55018 SEGROMIGNO IN MONTE CAPANNORI' , '' , '' , '18' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '2567.45' , '2104.47' , NOW() , NOW() ) 04/07/2025 02:43: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 = '97995' 04/07/2025 02:43:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '97995' 04/07/2025 02:43: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 ( '97995' , '17408' , 'CAMICE MISTO COT. 70/001035' , '7' , '7' , '1' , '71' , '58.196721311475' , '22' , '3' , '588.1498' ) 04/07/2025 02:43:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17408' AND id_supplier = '143' 04/07/2025 02:43:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17408' , '143' , '1' ) 04/07/2025 02:43: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 ( '97995' , '19346' , 'CASULA MARIANA LANA LUREX - 65/002005- 348' , '1' , '1' , '1' , '266' , '218.03278688525' , '22' , '3' , '314.7844' ) 04/07/2025 02:43:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19346' AND id_supplier = '143' 04/07/2025 02:43:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19346' , '143' , '1' ) 04/07/2025 02:43: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 ( '97995' , '23857' , 'CASULA SFUMATA - 65002007' , '4' , '4' , '1' , '242' , '198.3606557377' , '22' , '3' , '1145.5312' ) 04/07/2025 02:43:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23857' AND id_supplier = '143' 04/07/2025 02:43:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23857' , '143' , '1' ) 04/07/2025 02:43: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 ( '97995' , '23858' , 'TALARE FRESCO LANA 100% - 88/000100' , '1' , '1' , '1' , '420' , '344.26229508197' , '22' , '3' , '497.0280' ) 04/07/2025 02:43:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23858' AND id_supplier = '143' 04/07/2025 02:43:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23858' , '143' , '1' ) 04/07/2025 04:02:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '15/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-06-30') 04/07/2025 04:02:48 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '22' , '15/S' , '2025-06-30' , 'S' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'VENDUTO GIUGNO 2025' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '227.30' , '227.30' , NOW() , NOW() ) 04/07/2025 04:02:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14819' 04/07/2025 04:02:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '14819' 04/07/2025 04:02: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 ( '14819' , '134' , 'AVE MARIA SPIEGATA AI BAMBINI - N.E.' , '14' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '12.60' ) 04/07/2025 04:02: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 ( '14819' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '50' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '37.50' ) 04/07/2025 04:02: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 ( '14819' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '9' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '11.25' ) 04/07/2025 04:02: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 ( '14819' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '10' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '12.50' ) 04/07/2025 04:02: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 ( '14819' , '125' , 'MIE PREGHIERINE - N. E.' , '40' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '30.00' ) 04/07/2025 04:02: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 ( '14819' , '33' , '100 GIORNI CON LO SPIRITO' , '13' , '0' , '4' , '7.50' , '7.5' , '0' , '50' , '48.75' ) 04/07/2025 04:02: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 ( '14819' , '50' , 'PERDONAMI SIGNORE' , '16' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '20.00' ) 04/07/2025 04:02: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 ( '14819' , '64' , 'MARIA APPARIZIONI E MESSAGGI' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 04/07/2025 04:02: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 ( '14819' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '18' , '0' , '4' , '2.00' , '2' , '0' , '50' , '18.00' ) 04/07/2025 04:02: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 ( '14819' , '89' , 'COMUNIONE SPIEGATA AI RAGAZZI' , '4' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '3.60' ) 04/07/2025 04:02: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 ( '14819' , '90' , 'ATTO DI AFFIDAMENTO A MARIA' , '1' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 04/07/2025 04:02: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 ( '14819' , '94' , 'IL BATTESIMO' , '1' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 04/07/2025 04:02: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 ( '14819' , '99' , 'AVE MARIA PREGHIERE MARIANE' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 04/07/2025 04:02: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 ( '14819' , '104' , 'TEMPO DI QUARESIMA' , '3' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 04/07/2025 04:02: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 ( '14819' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 04/07/2025 04:02: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 ( '14819' , '110' , 'SE MI AMI NON PIANGERE' , '3' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '2.70' ) 04/07/2025 04:02: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 ( '14819' , '111' , 'I NONNI SONO UN TESORO' , '5' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '4.50' ) 04/07/2025 04:02: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 ( '14819' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '12' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '15.00' ) 04/07/2025 04:02: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 ( '14819' , '138' , 'LA NASCITA DI GESU' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 04/07/2025 04:02: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 ( '14819' , '136' , 'ANGELO DI DIO N.E.' , '1' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '0.90' ) 04/07/2025 04:05:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '16/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-06-30') 04/07/2025 04:05:25 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '25' , '16/S' , '2025-06-30' , 'S' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RESA GIUGNO 2025' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '69.25' , '69.25' , NOW() , NOW() ) 04/07/2025 04:05:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14820' 04/07/2025 04:05:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '14820' 04/07/2025 04:05:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14820' , '17' , 'LA FEDE NELLO ZAINETTO' , '1' , '1' , '4' , '6.00' , '6' , '0' , '50' , '3.00' ) 04/07/2025 04:05:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14820' , '20' , 'GIOVEDÌ SANTO' , '5' , '5' , '4' , '1.50' , '1.5' , '0' , '50' , '3.75' ) 04/07/2025 04:05:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14820' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '3' , '3' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 04/07/2025 04:05:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14820' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '27' , '27' , '4' , '2.00' , '2' , '0' , '50' , '27.00' ) 04/07/2025 04:05:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14820' , '80' , 'MISERICORDIA' , '7' , '7' , '4' , '2.50' , '2.5' , '0' , '50' , '8.75' ) 04/07/2025 04:05:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14820' , '82' , 'LAUDATO SI' , '3' , '3' , '4' , '2.00' , '2' , '0' , '50' , '3.00' ) 04/07/2025 04:05:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14820' , '88' , 'GESÙ È RISORTO' , '2' , '2' , '4' , '2.00' , '2' , '0' , '50' , '2.00' ) 04/07/2025 04:05:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14820' , '104' , 'TEMPO DI QUARESIMA' , '12' , '12' , '4' , '2.50' , '2.5' , '0' , '50' , '15.00' ) 04/07/2025 04:05:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14820' , '126' , 'SACRAMENTO DEL PERDONO' , '3' , '3' , '4' , '2.00' , '2' , '0' , '50' , '3.00' ) 04/07/2025 04:18:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '25/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-07-04') 04/07/2025 04:18:22 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '22' , '25/E' , '2025-07-04' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'VENDUTO GIUGNO 2025' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '858.45' , '858.36' , NOW() , NOW() ) 04/07/2025 04:18:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97996' 04/07/2025 04:18:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '97996' 04/07/2025 04:18:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '1' , '0' , '4' , '2.40' , '2.4' , '0' , '50' , '1.20' ) 04/07/2025 04:18:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '5457' , 'IO SONO CON VOI 1 PARTE' , '13' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '18.20' ) 04/07/2025 04:18:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '6629' , 'MIA PREGHIERA' , '1' , '0' , '4' , '0.90' , '0.9' , '0' , '50' , '0.45' ) 04/07/2025 04:18:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '4154' , 'FESTA DEL PERDONO' , '1' , '0' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 04/07/2025 04:18:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '2679' , 'CONOSCERE GESU' , '1' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 04/07/2025 04:18:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '1' , '0' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 04/07/2025 04:18:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '11102' , 'VANGELO E ATTI DEGLI APOSTOLI - RIL.' , '10' , '0' , '4' , '8.50' , '8.5' , '0' , '50' , '42.50' ) 04/07/2025 04:18:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '12819' , 'REGISTRO DEL CATECHISTA ' , '1' , '0' , '1' , '1.00' , '0.81967213114754' , '22' , '50' , '0.50' ) 04/07/2025 04:18:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '12813' , 'MARIA MADRE NOSTRA' , '1' , '0' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 04/07/2025 04:18:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '12' , '0' , '4' , '6.00' , '6' , '0' , '50' , '36.00' ) 04/07/2025 04:18:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '13397' , 'MIO GESU' , '1' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 04/07/2025 04:18:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '11' , '0' , '4' , '1.00' , '1' , '0' , '50' , '5.50' ) 04/07/2025 04:18:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '15019' , 'PREGHIAMO CON MARIA' , '14' , '0' , '4' , '0.80' , '0.8' , '0' , '50' , '5.60' ) 04/07/2025 04:18:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '15020' , 'PREGARE OGNI GIORNO' , '69' , '0' , '4' , '1.00' , '1' , '0' , '50' , '34.50' ) 04/07/2025 04:18:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '19' , '0' , '4' , '1.00' , '1' , '0' , '50' , '9.50' ) 04/07/2025 04:18:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '8' , '0' , '4' , '2.00' , '2' , '0' , '50' , '8.00' ) 04/07/2025 04:18:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '16667' , 'VIA CRUCIS' , '4' , '0' , '4' , '3.00' , '3' , '0' , '50' , '6.00' ) 04/07/2025 04:18:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '17257' , 'IO TI BATTEZZO ' , '76' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '68.40' ) 04/07/2025 04:18:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '17582' , 'SAN CESARE DE BUS' , '1' , '0' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 04/07/2025 04:18:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '2' , '0' , '4' , '12.00' , '12' , '0' , '50' , '12.00' ) 04/07/2025 04:18:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '11' , '0' , '4' , '1.90' , '1.9' , '0' , '50' , '10.45' ) 04/07/2025 04:18:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '18528' , 'CON GESU VERSO IL CALVARIO - G. VALSECCHI' , '12' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '9.00' ) 04/07/2025 04:18:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '2' , '0' , '4' , '7.00' , '7' , '0' , '50' , '7.00' ) 04/07/2025 04:18:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 04/07/2025 04:18:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '2' , '0' , '4' , '12.00' , '12' , '0' , '50' , '12.00' ) 04/07/2025 04:18:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '1' , '0' , '4' , '35.00' , '35' , '0' , '50' , '17.50' ) 04/07/2025 04:18:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '20231' , 'PREGANDO NON SPRECATE PAROLE - G. DAMORE' , '1' , '0' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 04/07/2025 04:18:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '20640' , 'GESU, MOSSO A COMPASSIONE V. SALVOLDI' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 04/07/2025 04:18:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '20719' , 'CORONA DELL’ADDOLORATA' , '5' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '4.50' ) 04/07/2025 04:18:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '16' , '0' , '4' , '2.00' , '2' , '0' , '50' , '16.00' ) 04/07/2025 04:18:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '20722' , 'SEMINATORI DI GIOIA' , '4' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '5.00' ) 04/07/2025 04:18:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '22031' , 'GLI ULTIMI SARANNO PRIMI - R. LUPI' , '2' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 04/07/2025 04:18:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '22032' , 'ECCO ORA IL MOMENTO FAVOREVOLE ' , '2' , '0' , '4' , '10.00' , '10' , '0' , '50' , '10.00' ) 04/07/2025 04:18:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '8' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '11.20' ) 04/07/2025 04:18:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '27' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '37.80' ) 04/07/2025 04:18:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '22053' , 'AMO IL SIGNORE, PERCHÉ ASCOLTA IL GRIDO DELLA MIA PREGHIERA' , '3' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 04/07/2025 04:18:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '22152' , 'A TE RICORRIAMO' , '1' , '0' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 04/07/2025 04:18:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '23092' , 'SPERANZA CHE E IN NOI' , '16' , '0' , '4' , '3.00' , '3' , '0' , '50' , '24.00' ) 04/07/2025 04:18:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '23348' , 'ECCE LIGNUM CRUCIS - V. SIRACUSA' , '16' , '0' , '4' , '3.00' , '3' , '0' , '50' , '24.00' ) 04/07/2025 04:18:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '23347' , 'PREGHIERA DEL ROSARIO' , '10' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '12.50' ) 04/07/2025 04:18:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '22809' , 'O LUCE BEATISSIMA' , '21' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '26.25' ) 04/07/2025 04:18:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '22961' , 'UN BAMBINO E NATO PER NOI - G. VALSECCHI' , '1' , '0' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 04/07/2025 04:18:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '23032' , 'MIO LIBRO DI PREGHIERE - N. E. ' , '21' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '29.40' ) 04/07/2025 04:18:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '23271' , 'OMELIA, ECO DELLA PAROLA DI DIO - R. RAMPOLLA' , '5' , '0' , '4' , '5.00' , '5' , '0' , '50' , '12.50' ) 04/07/2025 04:18:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '23420' , 'SPERANZA. PER VIVERE NELLA GIOIA - R. LUPI' , '18' , '0' , '4' , '3.00' , '3' , '0' , '50' , '27.00' ) 04/07/2025 04:18:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '23380' , 'DAL TUO CUORE TRAFITTO E GLORIOSO LA NOSTRA GIOIA E LA NOSTRA SPERANZA' , '16' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '20.00' ) 04/07/2025 04:18:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '23467' , 'VIA CRUCIS CAMMINO DI REDENZIONE - R. LUPI' , '6' , '0' , '4' , '3.00' , '3' , '0' , '50' , '9.00' ) 04/07/2025 04:18:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '23674' , 'DONO DI GRAZIA - V. SIRACUSA' , '12' , '0' , '4' , '5.00' , '5' , '0' , '50' , '30.00' ) 04/07/2025 04:18:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '23673' , 'RIVESTITI DI SPERANZA! - V. SIRACUSA' , '22' , '0' , '4' , '5.00' , '5' , '0' , '50' , '55.00' ) 04/07/2025 04:18:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97996' , '23721' , 'BEATITUDINI - M. DE ROSA' , '43' , '0' , '4' , '8.00' , '8' , '0' , '50' , '172.00' ) 04/07/2025 04:25:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '26/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-07-04') 04/07/2025 04:25:21 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '25' , '26/E' , '2025-07-04' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RESA GIUGNO 2025' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '440.50' , '440.50' , NOW() , NOW() ) 04/07/2025 04:25:21 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 = '97997' 04/07/2025 04:25:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '97997' 04/07/2025 04:25:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97997' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '4' , '4' , '4' , '2.40' , '2.4' , '0' , '50' , '4.80' ) 04/07/2025 04:25:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97997' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '11' , '11' , '4' , '2.50' , '2.5' , '0' , '50' , '13.75' ) 04/07/2025 04:25:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97997' , '4480' , 'GESÙ MIO AMICO - VOL. 2°' , '1' , '1' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 04/07/2025 04:25:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97997' , '9675' , 'SARETE MIEI TESTIMONI' , '9' , '9' , '4' , '3.50' , '3.5' , '0' , '50' , '15.75' ) 04/07/2025 04:25:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97997' , '5457' , 'IO SONO CON VOI 1 PARTE' , '10' , '10' , '4' , '2.80' , '2.8' , '0' , '50' , '14.00' ) 04/07/2025 04:25:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97997' , '5458' , 'IO SONO CON VOI 2 PARTE' , '10' , '10' , '4' , '2.80' , '2.8' , '0' , '50' , '14.00' ) 04/07/2025 04:25:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97997' , '11191' , 'VENITE CON ME 1 PARTE' , '5' , '5' , '4' , '2.80' , '2.8' , '0' , '50' , '7.00' ) 04/07/2025 04:25:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97997' , '11192' , 'VENITE CON ME 2 PARTE' , '10' , '10' , '4' , '2.80' , '2.8' , '0' , '50' , '14.00' ) 04/07/2025 04:25:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97997' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '7' , '7' , '4' , '3.40' , '3.4' , '0' , '50' , '11.90' ) 04/07/2025 04:25:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97997' , '4154' , 'FESTA DEL PERDONO' , '6' , '6' , '4' , '3.00' , '3' , '0' , '50' , '9.00' ) 04/07/2025 04:25:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97997' , '7824' , 'PER ILLUMINARE IL CAMMINO' , '4' , '4' , '4' , '0.90' , '0.9' , '0' , '50' , '1.80' ) 04/07/2025 04:25:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97997' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '1' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 04/07/2025 04:25:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97997' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '22' , '22' , '4' , '1.00' , '1' , '0' , '50' , '11.00' ) 04/07/2025 04:25:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97997' , '16997' , 'PREGHIAMO IL PADRONE DELLE MESSE ' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 04/07/2025 04:25:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97997' , '18528' , 'CON GESU VERSO IL CALVARIO - G. VALSECCHI' , '17' , '17' , '4' , '1.50' , '1.5' , '0' , '50' , '12.75' ) 04/07/2025 04:25:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97997' , '18657' , 'HO DATO LORO LA TUA PAROLA - TEMPI FORTI- G. VALSECCHI' , '3' , '3' , '4' , '16.00' , '16' , '0' , '50' , '24.00' ) 04/07/2025 04:25:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97997' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '7' , '7' , '4' , '7.00' , '7' , '0' , '50' , '24.50' ) 04/07/2025 04:25:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97997' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '2' , '2' , '4' , '2.00' , '2' , '0' , '50' , '2.00' ) 04/07/2025 04:25:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97997' , '20640' , 'GESU, MOSSO A COMPASSIONE V. SALVOLDI' , '13' , '13' , '4' , '2.50' , '2.5' , '0' , '50' , '16.25' ) 04/07/2025 04:25:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97997' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '4' , '4' , '4' , '2.00' , '2' , '0' , '50' , '4.00' ) 04/07/2025 04:25:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97997' , '20722' , 'SEMINATORI DI GIOIA' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 04/07/2025 04:25:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97997' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '8' , '8' , '4' , '3.00' , '3' , '0' , '50' , '12.00' ) 04/07/2025 04:25:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97997' , '22031' , 'GLI ULTIMI SARANNO PRIMI - R. LUPI' , '4' , '4' , '4' , '2.50' , '2.5' , '0' , '50' , '5.00' ) 04/07/2025 04:25:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97997' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '1' , '1' , '4' , '8.00' , '8' , '0' , '50' , '4.00' ) 04/07/2025 04:25:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97997' , '22032' , 'ECCO ORA IL MOMENTO FAVOREVOLE ' , '3' , '3' , '4' , '10.00' , '10' , '0' , '50' , '15.00' ) 04/07/2025 04:25:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97997' , '22053' , 'AMO IL SIGNORE, PERCHÉ ASCOLTA IL GRIDO DELLA MIA PREGHIERA' , '14' , '14' , '4' , '2.50' , '2.5' , '0' , '50' , '17.50' ) 04/07/2025 04:25:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97997' , '22153' , 'UNA VITA CONSUMATA NELLAMORE' , '2' , '2' , '4' , '6.00' , '6' , '0' , '50' , '6.00' ) 04/07/2025 04:25:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97997' , '23092' , 'SPERANZA CHE E IN NOI' , '6' , '6' , '4' , '3.00' , '3' , '0' , '50' , '9.00' ) 04/07/2025 04:25:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97997' , '23348' , 'ECCE LIGNUM CRUCIS - V. SIRACUSA' , '33' , '33' , '4' , '3.00' , '3' , '0' , '50' , '49.50' ) 04/07/2025 04:25:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97997' , '22809' , 'O LUCE BEATISSIMA' , '2' , '2' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 04/07/2025 04:25:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97997' , '22871' , 'SPERANZA NON DELUDE - M. DE ROSA' , '10' , '10' , '4' , '8.00' , '8' , '0' , '50' , '40.00' ) 04/07/2025 04:25:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97997' , '22961' , 'UN BAMBINO E NATO PER NOI - G. VALSECCHI' , '6' , '6' , '4' , '3.00' , '3' , '0' , '50' , '9.00' ) 04/07/2025 04:25:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97997' , '23271' , 'OMELIA, ECO DELLA PAROLA DI DIO - R. RAMPOLLA' , '4' , '4' , '4' , '5.00' , '5' , '0' , '50' , '10.00' ) 04/07/2025 04:25:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97997' , '23380' , 'DAL TUO CUORE TRAFITTO E GLORIOSO LA NOSTRA GIOIA E LA NOSTRA SPERANZA' , '31' , '31' , '4' , '2.50' , '2.5' , '0' , '50' , '38.75' ) 04/07/2025 04:25:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97997' , '23467' , 'VIA CRUCIS CAMMINO DI REDENZIONE - R. LUPI' , '11' , '11' , '4' , '3.00' , '3' , '0' , '50' , '16.50' ) 04/07/2025 04:54:21 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' , '6025222542' , '2025-06-30' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '76.61' , '76.61' , NOW() , NOW() ) 04/07/2025 04:54:21 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 = '97998' 04/07/2025 04:54:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '97998' 04/07/2025 04:54:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97998' , '23818' , 'STORIA DEI CONCILI ECUMENICI - J. MURPHY' , '1' , '0' , '4' , '11.7' , '11.7' , '0' , '0' , '11.7000' ) 04/07/2025 04:54:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23818' AND id_supplier = '109' 04/07/2025 04:54:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23818' , '109' , '1' ) 04/07/2025 04:54:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97998' , '16205' , 'PREGHIERE DEI FEDELI - TEMPO ORDINARIO ANNO II' , '1' , '0' , '4' , '12.95' , '12.95' , '0' , '0' , '12.9500' ) 04/07/2025 04:54:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16205' AND id_supplier = '109' 04/07/2025 04:54:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16205' , '109' , '1' ) 04/07/2025 04:54:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97998' , '23813' , 'PAPA LEONE XIV IL PAPA AMERICANO - O. BALDACCI' , '5' , '0' , '4' , '6.436' , '6.436' , '0' , '0' , '32.1800' ) 04/07/2025 04:54:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23813' AND id_supplier = '109' 04/07/2025 04:54:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23813' , '109' , '1' ) 04/07/2025 04:54:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97998' , '23815' , 'SANTAGOSTINO - C. HORN' , '1' , '0' , '4' , '9.23' , '9.23' , '0' , '0' , '9.2300' ) 04/07/2025 04:54:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23815' AND id_supplier = '109' 04/07/2025 04:54:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23815' , '109' , '1' ) 04/07/2025 04:54:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97998' , '23814' , 'FARE LA VERITA - AGOSTINO' , '1' , '0' , '4' , '10.55' , '10.55' , '0' , '0' , '10.5500' ) 04/07/2025 04:54:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23814' AND id_supplier = '109' 04/07/2025 04:54:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23814' , '109' , '1' ) 04/07/2025 04:57:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '6025222543' , '2025-06-30' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.61' , '50.61' , NOW() , NOW() ) 04/07/2025 04:57: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 = '97999' 04/07/2025 04:57:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '97999' 04/07/2025 04:57: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 ( '97999' , '23816' , 'MAHABHARATA' , '1' , '0' , '4' , '23.29' , '23.29' , '0' , '0' , '23.2900' ) 04/07/2025 04:57:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23816' AND id_supplier = '109' 04/07/2025 04:57:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23816' , '109' , '1' ) 04/07/2025 04:57: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 ( '97999' , '23819' , 'VI LASCIO PAROLE PIENE DI VITA - PAPA FRANCESCO' , '1' , '0' , '4' , '13.14' , '13.14' , '0' , '0' , '13.1400' ) 04/07/2025 04:57:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23819' AND id_supplier = '109' 04/07/2025 04:57:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23819' , '109' , '1' ) 04/07/2025 04:57: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 ( '97999' , '23045' , 'DIO DEI NOSTRI PADRI - A. CAZZULLO' , '1' , '0' , '4' , '14.18' , '14.18' , '0' , '0' , '14.1800' ) 04/07/2025 04:58:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23045' AND id_supplier = '109' 04/07/2025 04:58:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23045' , '109' , '1' ) 04/07/2025 04:58: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' , '6025222541' , '2025-06-30' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.38' , '9.38' , NOW() , NOW() ) 04/07/2025 04:58: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 = '98000' 04/07/2025 04:58:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '98000' 04/07/2025 04:58: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 ( '98000' , '23817' , 'FRASSATI TOUR - A. GRECO' , '1' , '0' , '4' , '9.38' , '9.38' , '0' , '0' , '9.3800' ) 04/07/2025 04:58:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23817' AND id_supplier = '109' 04/07/2025 04:58:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23817' , '109' , '1' ) 04/07/2025 05:18:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '2370' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-04') 04/07/2025 05:18:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2370' , '2025-07-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.50' , '15.98' , NOW() , NOW() ) 04/07/2025 05:18:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98001' 04/07/2025 05:18:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '98001' 04/07/2025 05:18:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98001' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '3' , '-3' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '19.50' ) 04/07/2025 05:21:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '2371' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-04') 04/07/2025 05:21:09 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' , '2371' , '2025-07-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 04/07/2025 05:21:09 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 = '98002' 04/07/2025 05:21:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '98002' 04/07/2025 05:21:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98002' , '22508' , 'POLO PIQUET - M06' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 04/07/2025 05:31:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '2372' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-04') 04/07/2025 05:31:42 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2372' , '2025-07-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.75' , '3.07' , NOW() , NOW() ) 04/07/2025 05:31: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 = '98003' 04/07/2025 05:31:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '98003' 04/07/2025 05:31: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 ( '98003' , '6325' , 'MEDAGLIA MIRACOLOSA MM 22 - METALLO OX' , '15' , '-15' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '3.75' ) 04/07/2025 05:40:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '2373' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-04') 04/07/2025 05:40:40 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2373' , '2025-07-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.96' , '17.96' , NOW() , NOW() ) 04/07/2025 05:40:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98004' 04/07/2025 05:40:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '98004' 04/07/2025 05:40:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98004' , '15983' , 'BIBBIA IN 365 GIORNI' , '1' , '-1' , '4' , '18.90' , '18.9' , '0' , '5' , '17.96' ) 04/07/2025 06:26:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '2374' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-04') 04/07/2025 06:26: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' , '2374' , '2025-07-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.00' , '28.69' , NOW() , NOW() ) 04/07/2025 06:26: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 = '98005' 04/07/2025 06:26:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '98005' 04/07/2025 06:26: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 ( '98005' , '22439' , 'ROSARIO ARGENTO/EMATITE - 7678/50' , '1' , '-1' , '1' , '35.00' , '28.688524590164' , '22' , '0' , '35.00' )