06/02/2025 08:39:34 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 06/02/2025 08:39:35 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23408' , '1' , '' , 'nuovo-prodotto' ) 06/02/2025 08:39:35 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23408' , '1' , '1' , '2' , NOW() , NOW() ) 06/02/2025 08:39:35 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23408' , '0' , '1' , '0' , '0' ) 06/02/2025 08:41:19 am >> SELECT ean13 FROM ps_product WHERE ean13 = 'art. 60-3088 d' AND id_product != '23408' AND ean13 != '' 06/02/2025 08:41:19 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'art. 60-3088 d', date_upd = NOW() WHERE id_product = '23408' 06/02/2025 08:41:19 am >> UPDATE ps_product_lang SET name = 'STOLA DIACONALE - 60/3088 D', description = '' WHERE id_product = '23408' 06/02/2025 08:41:19 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '162.29508196721312' WHERE id_product = '23408' 06/02/2025 08:41:19 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '162.29508196721312', id_tax_rules_group = '1', id_category_default = '450', 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 = '23408' 06/02/2025 08:41:19 am >> DELETE FROM ps_specific_price WHERE id_product = '23408' 06/02/2025 08:42:57 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' , '4266/2025' , '2025-01-31' , '2025' , '0' , '129' , '4670237' , 'VIA ROMA, 10 54035 FOSDINOVO' , '' , '' , '11' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '504.53' , '413.55' , NOW() , NOW() ) 06/02/2025 08:42:57 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 = '95627' 06/02/2025 08:42:57 am >> DELETE FROM ps_document_detail WHERE id_document = '95627' 06/02/2025 08:42:57 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 ( '95627' , '23408' , 'STOLA DIACONALE - 60/3088 D' , '5' , '5' , '1' , '83' , '68.032786885246' , '22' , '3' , '491.1110' ) 06/02/2025 08:42:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '23408' AND id_supplier = '129' 06/02/2025 08:42:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23408' , '129' , '1' ) 06/02/2025 09:17:53 am >> SELECT document_num FROM ps_document WHERE document_num = '401' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-06') 06/02/2025 09:17:53 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '401' , '2025-02-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.50' , '61.56' , NOW() , NOW() ) 06/02/2025 09:17:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95628' 06/02/2025 09:17:53 am >> DELETE FROM ps_document_detail WHERE id_document = '95628' 06/02/2025 09:17:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95628' , '564' , 'GIGLER COMPLETO PER ART. 534/536/537 - 249' , '4' , '-4' , '1' , '4.40' , '3.6065573770492' , '22' , '0' , '17.60' ) 06/02/2025 09:17:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95628' , '5972' , 'LUCERNA ALADIN - PICCOLA - 558' , '2' , '-2' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '12.00' ) 06/02/2025 09:17:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95628' , '11626' , 'PURIFICATOIO 28X48 - SERV 1' , '1' , '-1' , '1' , '7.80' , '6.3934426229508' , '22' , '0' , '7.80' ) 06/02/2025 09:17:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95628' , '11625' , 'CORPORALE - 47X47 - SERV 4' , '1' , '-1' , '1' , '12.20' , '10' , '22' , '0' , '12.20' ) 06/02/2025 09:17:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95628' , '23341' , 'SPERA - PAPA FRANCESCO' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '5' , '20.90' ) 06/02/2025 09:29:03 am >> SELECT document_num FROM ps_document WHERE document_num = '402' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-06') 06/02/2025 09:29:03 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '402' , '2025-02-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.25' , '7.25' , NOW() , NOW() ) 06/02/2025 09:29:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95629' 06/02/2025 09:29:03 am >> DELETE FROM ps_document_detail WHERE id_document = '95629' 06/02/2025 09:29:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95629' , '23393' , 'SULLA TUA PAROLA - GEN/FEB 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 06/02/2025 09:29:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95629' , '22990' , 'CORONCINA A SANTA RITA DA CASCIA - 8843' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 06/02/2025 09:29:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95629' , '14000' , 'GALATEO IN CHIESA' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 06/02/2025 09:46:31 am >> SELECT document_num FROM ps_document WHERE document_num = '403' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-06') 06/02/2025 09:46:31 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' , '403' , '2025-02-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '64.86' , '59.56' , NOW() , NOW() ) 06/02/2025 09:46:31 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 = '95630' 06/02/2025 09:46:31 am >> DELETE FROM ps_document_detail WHERE id_document = '95630' 06/02/2025 09:46:31 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 ( '95630' , '1914' , 'CERA DELLA LITURGIA' , '6' , '-6' , '1' , '4.9' , '4.016393442623' , '22' , '0' , '29.40' ) 06/02/2025 09:46:31 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 ( '95630' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 06/02/2025 09:46:31 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 ( '95630' , '16024' , 'IL MESE DI FEBBRAIO CON MARIA - 8979' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 06/02/2025 09:46:31 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 ( '95630' , '22881' , 'ADORAZIONE EUCARISTICA ALLA SCUOLA DELLA LITURGIA - POLI/ZOTTELE' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 06/02/2025 09:46:31 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 ( '95630' , '22001' , 'VERRO A TROVARTI TUTTE LE VOLTE CHE VORRAI - S. ZAMPA' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '5' , '6.56' ) 06/02/2025 09:46:31 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 ( '95630' , '23366' , 'VIA CRUCIS CON MARIA - A. COMASTRI' , '2' , '-2' , '4' , '2.00' , '2' , '0' , '0' , '4.00' ) 06/02/2025 09:46:31 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 ( '95630' , '23365' , 'VIA CRUCIS DEL PELLEGRINO ' , '2' , '-2' , '4' , '2.00' , '2' , '0' , '0' , '4.00' ) 06/02/2025 09:56:39 am >> SELECT document_num FROM ps_document WHERE document_num = '404' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-06') 06/02/2025 09:56:39 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '404' , '2025-02-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '280.00' , '233.41' , NOW() , NOW() ) 06/02/2025 09:56:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95631' 06/02/2025 09:56:39 am >> DELETE FROM ps_document_detail WHERE id_document = '95631' 06/02/2025 09:56:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95631' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '112.80' ) 06/02/2025 09:56:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95631' , '13929' , 'COPRILEGGIO - 317/TP' , '2' , '-2' , '1' , '69.85' , '57.254098360656' , '22' , '0' , '139.70' ) 06/02/2025 09:56:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95631' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 06/02/2025 09:56:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95631' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 06/02/2025 10:07:45 am >> SELECT document_num FROM ps_document WHERE document_num = '308' AND id_document != '95496' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-30') 06/02/2025 10:07:45 am >> UPDATE ps_document SET id_document_type = '11', document_num = '308', document_date = '2025-01-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '70.00', price_tax_excluded = '57.38', date_upd = NOW() WHERE id_document = '95496' 06/02/2025 10:07:46 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 = '95496' 06/02/2025 10:07:46 am >> DELETE FROM ps_document_detail WHERE id_document = '95496' 06/02/2025 10:07:46 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 ( '95496' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '70' , '57.377049180328' , '22' , '0' , '70.00' ) 06/02/2025 10:32:10 am >> SELECT document_num FROM ps_document WHERE document_num = '405' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-06') 06/02/2025 10:32:10 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' , '405' , '2025-02-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.25' , '14.25' , NOW() , NOW() ) 06/02/2025 10:32:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95632' 06/02/2025 10:32:10 am >> DELETE FROM ps_document_detail WHERE id_document = '95632' 06/02/2025 10:32:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95632' , '23393' , 'SULLA TUA PAROLA - GEN/FEB 25' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '5' , '14.25' ) 06/02/2025 10:34:54 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256391318' AND id_product != '23393' AND ean13 != '' 06/02/2025 10:34:54 am >> UPDATE ps_product SET id_supplier = '38', reference = '7/4', ean13 = '9791256391318', date_upd = NOW() WHERE id_product = '23393' 06/02/2025 10:34:54 am >> UPDATE ps_product_lang SET name = 'SULLA TUA PAROLA - MAR/APR 25', description = '' WHERE id_product = '23393' 06/02/2025 10:34:54 am >> UPDATE ps_product SET wholesale_price = '3.00', on_sale = '0', price = '5.0000' WHERE id_product = '23393' 06/02/2025 10:34:54 am >> UPDATE ps_product_shop SET wholesale_price = '3.00', price = '5.0000', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23393' 06/02/2025 10:34:54 am >> DELETE FROM ps_specific_price WHERE id_product = '23393' 06/02/2025 11:54:44 am >> SELECT document_num FROM ps_document WHERE document_num = '406' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-06') 06/02/2025 11:54:44 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' , '406' , '2025-02-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '170.00' , '139.34' , NOW() , NOW() ) 06/02/2025 11:54:44 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 = '95633' 06/02/2025 11:54:44 am >> DELETE FROM ps_document_detail WHERE id_document = '95633' 06/02/2025 11:54:44 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 ( '95633' , '17408' , 'CAMICE MISTO COT. 70/001035' , '1' , '-1' , '1' , '170.00' , '139.34426229508' , '22' , '0' , '170.00' ) 06/02/2025 12:31:25 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 06/02/2025 12:31:25 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23409' , '1' , '' , 'nuovo-prodotto' ) 06/02/2025 12:31:25 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23409' , '1' , '1' , '2' , NOW() , NOW() ) 06/02/2025 12:31:25 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23409' , '0' , '1' , '0' , '0' ) 06/02/2025 12:32:34 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873577294' AND id_product != '23409' AND ean13 != '' 06/02/2025 12:32:34 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/3', ean13 = '9788873577294', date_upd = NOW() WHERE id_product = '23409' 06/02/2025 12:32:34 pm >> UPDATE ps_product_lang SET name = 'VIA CRUCIS DEL GIUBILEO - RUCCIA/SCALERA', description = '' WHERE id_product = '23409' 06/02/2025 12:32:34 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '23409' 06/02/2025 12:32:34 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '178', id_argoment_default = '50', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23409' 06/02/2025 12:32:34 pm >> DELETE FROM ps_specific_price WHERE id_product = '23409' 06/02/2025 12:32:35 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23409' 06/02/2025 12:32:35 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23410' , '1' , '' , 'nuovo-prodotto' ) 06/02/2025 12:32:35 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23410' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23409' 06/02/2025 12:32:35 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23410' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23409' 06/02/2025 12:33:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788873577300' AND id_product != '23410' AND ean13 != '' 06/02/2025 12:33:51 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/5', ean13 = '9788873577300', date_upd = NOW() WHERE id_product = '23410' 06/02/2025 12:33:51 pm >> UPDATE ps_product_lang SET name = 'TRIDUO PASQUALE PER NOI E PER IL MONDO - G. FLORIO', description = '' WHERE id_product = '23410' 06/02/2025 12:33:51 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '23410' 06/02/2025 12:33:51 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '178', id_argoment_default = '50', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23410' 06/02/2025 12:33:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '23410' 06/02/2025 12:33:52 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 = '23410' 06/02/2025 12:33:53 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23411' , '1' , '' , 'nuovo-prodotto' ) 06/02/2025 12:33:53 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23411' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23410' 06/02/2025 12:33:53 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23411' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23410' 06/02/2025 12:35:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832235791' AND id_product != '23411' AND ean13 != '' 06/02/2025 12:35:05 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788832235791', date_upd = NOW() WHERE id_product = '23411' 06/02/2025 12:35:05 pm >> UPDATE ps_product_lang SET name = 'CARLO ACUTIS SULLE ORME DI FRANCESCO - D. SORRENTINO', description = '' WHERE id_product = '23411' 06/02/2025 12:35:05 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '23411' 06/02/2025 12:35:05 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '472', 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 = '23411' 06/02/2025 12:35:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '23411' 06/02/2025 12:35:06 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 = '23411' 06/02/2025 12:35:06 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23412' , '1' , '' , 'nuovo-prodotto' ) 06/02/2025 12:35:06 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 '23412' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23411' 06/02/2025 12:35:07 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23412' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23411' 06/02/2025 12:41:14 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788883331169' AND id_product != '23412' AND ean13 != '' 06/02/2025 12:41:14 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788883331169', date_upd = NOW() WHERE id_product = '23412' 06/02/2025 12:41:14 pm >> UPDATE ps_product_lang SET name = 'EUCARISTIA DONO E MISTERO', description = '' WHERE id_product = '23412' 06/02/2025 12:41:14 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '40' WHERE id_product = '23412' 06/02/2025 12:41:14 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '40', id_tax_rules_group = '4', id_category_default = '272', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23412' 06/02/2025 12:41:14 pm >> DELETE FROM ps_specific_price WHERE id_product = '23412' 06/02/2025 12:41:15 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 = '23412' 06/02/2025 12:41:15 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23413' , '1' , '' , 'nuovo-prodotto' ) 06/02/2025 12:41:16 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 '23413' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23412' 06/02/2025 12:41:16 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23413' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23412' 06/02/2025 12:42:10 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '2025000000642' , '2025-02-05' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '6' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '104.15' , '104.15' , NOW() , NOW() ) 06/02/2025 12:42:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95634' 06/02/2025 12:42:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '95634' 06/02/2025 12:42:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95634' , '23409' , 'VIA CRUCIS DEL GIUBILEO - RUCCIA/SCALERA' , '1' , '1' , '4' , '10.00' , '10' , '0' , '35' , '6.5000' ) 06/02/2025 12:42:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23409' AND id_supplier = '107' 06/02/2025 12:42:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23409' , '107' , '1' ) 06/02/2025 12:42:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95634' , '23410' , 'TRIDUO PASQUALE PER NOI E PER IL MONDO - G. FLORIO' , '1' , '1' , '4' , '10.00' , '10' , '0' , '35' , '6.5000' ) 06/02/2025 12:42:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23410' AND id_supplier = '107' 06/02/2025 12:42:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23410' , '107' , '1' ) 06/02/2025 12:42:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95634' , '23411' , 'CARLO ACUTIS SULLE ORME DI FRANCESCO - D. SORRENTINO' , '2' , '2' , '4' , '12.00' , '12' , '0' , '35' , '15.6000' ) 06/02/2025 12:42:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23411' AND id_supplier = '107' 06/02/2025 12:42:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23411' , '107' , '1' ) 06/02/2025 12:42:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95634' , '23412' , 'EUCARISTIA DONO E MISTERO' , '1' , '1' , '4' , '40.00' , '40' , '0' , '35' , '26.0000' ) 06/02/2025 12:42:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23412' AND id_supplier = '107' 06/02/2025 12:42:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23412' , '107' , '1' ) 06/02/2025 12:42:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95634' , '22995' , 'MINISTRO STRAORDINARIO DELLA COMUNIONE' , '1' , '1' , '4' , '7.00' , '7' , '0' , '35' , '4.5500' ) 06/02/2025 12:42:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22995' AND id_supplier = '107' 06/02/2025 12:42:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22995' , '107' , '1' ) 06/02/2025 12:42:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95634' , '21847' , 'UNDICESIMO: SALVA LA TESTA! - P. PELLEGRINO' , '20' , '20' , '4' , '3.00' , '3' , '0' , '35' , '39.0000' ) 06/02/2025 12:42:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21847' AND id_supplier = '107' 06/02/2025 12:42:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21847' , '107' , '1' ) 06/02/2025 03:44:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '407' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-06') 06/02/2025 03:44: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 ( '11' , '407' , '2025-02-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.85' , '40.85' , NOW() , NOW() ) 06/02/2025 03:44: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 = '95635' 06/02/2025 03:44:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '95635' 06/02/2025 03:44: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 ( '95635' , '3986' , 'EVANGELII GAUDIUM' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 06/02/2025 03:44: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 ( '95635' , '23412' , 'EUCARISTIA DONO E MISTERO' , '1' , '-1' , '4' , '40.00' , '40' , '0' , '5' , '38.00' ) 06/02/2025 03:48:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '1/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-02-06') 06/02/2025 03:48: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 ( '23' , '1/S' , '2025-02-06' , 'S' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'VENDUTO GENNAIO 2025' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '990.45' , '990.45' , NOW() , NOW() ) 06/02/2025 03:48: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 = '14785' 06/02/2025 03:48:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '14785' 06/02/2025 03:48:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14785' , '17' , 'LA FEDE NELLO ZAINETTO' , '4' , '-4' , '4' , '6.00' , '6' , '0' , '50' , '12.00' ) 06/02/2025 03:48:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14785' , '20' , 'GIOVEDÌ SANTO' , '7' , '-7' , '4' , '1.50' , '1.5' , '0' , '50' , '5.25' ) 06/02/2025 03:48:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14785' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '82' , '-82' , '4' , '1.50' , '1.5' , '0' , '50' , '61.50' ) 06/02/2025 03:48:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14785' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '69' , '-69' , '4' , '2.50' , '2.5' , '0' , '50' , '86.25' ) 06/02/2025 03:48:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14785' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '8' , '-8' , '4' , '2.50' , '2.5' , '0' , '50' , '10.00' ) 06/02/2025 03:48:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14785' , '25' , 'PICCOLO DIZIONARIO DEL CRISTIANO' , '2' , '-2' , '4' , '3.00' , '3' , '0' , '50' , '3.00' ) 06/02/2025 03:48:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14785' , '121' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '3' , '-3' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 06/02/2025 03:48:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14785' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '4' , '-4' , '4' , '2.50' , '2.5' , '0' , '50' , '5.00' ) 06/02/2025 03:48:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14785' , '125' , 'MIE PREGHIERINE - N. E.' , '10' , '-10' , '4' , '1.50' , '1.5' , '0' , '50' , '7.50' ) 06/02/2025 03:48:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14785' , '42' , 'ALLA SCOPERTA DELLA CASA DI GESU' , '9' , '-9' , '4' , '3.00' , '3' , '0' , '50' , '13.50' ) 06/02/2025 03:48:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14785' , '50' , 'PERDONAMI SIGNORE' , '8' , '-8' , '4' , '2.50' , '2.5' , '0' , '50' , '10.00' ) 06/02/2025 03:48:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14785' , '55' , 'AVE MARIA ,SPIEGATA AI BAMBINI' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 06/02/2025 03:48:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14785' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '2' , '-2' , '4' , '2.00' , '2' , '0' , '50' , '2.00' ) 06/02/2025 03:48:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14785' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '27' , '-27' , '4' , '30.00' , '30' , '0' , '50' , '405.00' ) 06/02/2025 03:48:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14785' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '19' , '-19' , '4' , '2.00' , '2' , '0' , '50' , '19.00' ) 06/02/2025 03:48:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14785' , '75' , 'IL SEGNO DELLA CROCE' , '41' , '-41' , '4' , '1.50' , '1.5' , '0' , '50' , '30.75' ) 06/02/2025 03:48:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14785' , '92' , 'LA PREGHIERA DEL ROSARIO' , '13' , '-13' , '4' , '2.50' , '2.5' , '0' , '50' , '16.25' ) 06/02/2025 03:48:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14785' , '94' , 'IL BATTESIMO' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 06/02/2025 03:48:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14785' , '104' , 'TEMPO DI QUARESIMA' , '4' , '-4' , '4' , '2.50' , '2.5' , '0' , '50' , '5.00' ) 06/02/2025 03:48:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14785' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '26' , '-26' , '4' , '2.50' , '2.5' , '0' , '50' , '32.50' ) 06/02/2025 03:48:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14785' , '111' , 'I NONNI SONO UN TESORO' , '11' , '-11' , '4' , '1.80' , '1.8' , '0' , '50' , '9.90' ) 06/02/2025 03:48:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14785' , '123' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '12' , '-12' , '4' , '3.00' , '3' , '0' , '50' , '18.00' ) 06/02/2025 03:48:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14785' , '115' , 'SAN FRANCESCO DASSISI RACCONTATO AI RAGAZZI N.E.' , '27' , '-27' , '4' , '4.00' , '4' , '0' , '50' , '54.00' ) 06/02/2025 03:48:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14785' , '116' , 'DIZIONARIO DEI SIMBOLI DEL PICCOLO CRISTIANO NE' , '3' , '-3' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 06/02/2025 03:48:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14785' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '52' , '-52' , '4' , '2.50' , '2.5' , '0' , '50' , '65.00' ) 06/02/2025 03:48:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14785' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '28' , '-28' , '4' , '2.50' , '2.5' , '0' , '50' , '35.00' ) 06/02/2025 03:48:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14785' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '3' , '-3' , '4' , '3.00' , '3' , '0' , '50' , '4.50' ) 06/02/2025 03:48:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14785' , '138' , 'LA NASCITA DI GESU' , '19' , '-19' , '4' , '2.50' , '2.5' , '0' , '50' , '23.75' ) 06/02/2025 03:48:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14785' , '139' , 'E NATO - n.e.' , '17' , '-17' , '4' , '2.00' , '2' , '0' , '50' , '17.00' ) 06/02/2025 03:48:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14785' , '136' , 'ANGELO DI DIO N.E.' , '7' , '-7' , '4' , '1.80' , '1.8' , '0' , '50' , '6.30' ) 06/02/2025 03:48:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14785' , '137' , 'AVVENTO' , '6' , '-6' , '4' , '2.50' , '2.5' , '0' , '50' , '7.50' ) 06/02/2025 03:48:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14785' , '126' , 'SACRAMENTO DEL PERDONO' , '16' , '-16' , '4' , '2.00' , '2' , '0' , '50' , '16.00' ) 06/02/2025 03:49:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '2/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-02-06') 06/02/2025 03:49: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' , '2/S' , '2025-02-06' , 'S' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '990.45' , '990.45' , NOW() , NOW() ) 06/02/2025 03:49: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 = '14786' 06/02/2025 03:49:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '14786' 06/02/2025 03:49: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 ( '14786' , '17' , 'LA FEDE NELLO ZAINETTO' , '4' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '12.00' ) 06/02/2025 03:49: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 ( '14786' , '20' , 'GIOVEDÌ SANTO' , '7' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '5.25' ) 06/02/2025 03:49: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 ( '14786' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '82' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '61.50' ) 06/02/2025 03:49: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 ( '14786' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '69' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '86.25' ) 06/02/2025 03:49: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 ( '14786' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '8' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '10.00' ) 06/02/2025 03:49: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 ( '14786' , '25' , 'PICCOLO DIZIONARIO DEL CRISTIANO' , '2' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '3.00' ) 06/02/2025 03:49: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 ( '14786' , '121' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '3' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '3.75' ) 06/02/2025 03:49: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 ( '14786' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '4' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '5.00' ) 06/02/2025 03:49: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 ( '14786' , '125' , 'MIE PREGHIERINE - N. E.' , '10' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '7.50' ) 06/02/2025 03:49: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 ( '14786' , '42' , 'ALLA SCOPERTA DELLA CASA DI GESU' , '9' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '13.50' ) 06/02/2025 03:49: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 ( '14786' , '50' , 'PERDONAMI SIGNORE' , '8' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '10.00' ) 06/02/2025 03:49: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 ( '14786' , '55' , 'AVE MARIA ,SPIEGATA AI BAMBINI' , '1' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '0.75' ) 06/02/2025 03:49: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 ( '14786' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '2' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '2.00' ) 06/02/2025 03:49: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 ( '14786' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '27' , '0' , '4' , '30.0000' , '30' , '0' , '50' , '405.00' ) 06/02/2025 03:49: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 ( '14786' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '19' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '19.00' ) 06/02/2025 03:49: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 ( '14786' , '75' , 'IL SEGNO DELLA CROCE' , '41' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '30.75' ) 06/02/2025 03:49: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 ( '14786' , '92' , 'LA PREGHIERA DEL ROSARIO' , '13' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '16.25' ) 06/02/2025 03:49: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 ( '14786' , '94' , 'IL BATTESIMO' , '1' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '0.75' ) 06/02/2025 03:49: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 ( '14786' , '104' , 'TEMPO DI QUARESIMA' , '4' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '5.00' ) 06/02/2025 03:49: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 ( '14786' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '26' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '32.50' ) 06/02/2025 03:49: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 ( '14786' , '111' , 'I NONNI SONO UN TESORO' , '11' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '9.90' ) 06/02/2025 03:49: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 ( '14786' , '123' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '12' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '18.00' ) 06/02/2025 03:49: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 ( '14786' , '115' , 'SAN FRANCESCO DASSISI RACCONTATO AI RAGAZZI N.E.' , '27' , '0' , '4' , '4.0000' , '4' , '0' , '50' , '54.00' ) 06/02/2025 03:49: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 ( '14786' , '116' , 'DIZIONARIO DEI SIMBOLI DEL PICCOLO CRISTIANO NE' , '3' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '3.75' ) 06/02/2025 03:49: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 ( '14786' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '52' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '65.00' ) 06/02/2025 03:49: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 ( '14786' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '28' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '35.00' ) 06/02/2025 03:49: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 ( '14786' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '3' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '4.50' ) 06/02/2025 03:49: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 ( '14786' , '138' , 'LA NASCITA DI GESU' , '19' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '23.75' ) 06/02/2025 03:49: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 ( '14786' , '139' , 'E NATO - n.e.' , '17' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '17.00' ) 06/02/2025 03:49: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 ( '14786' , '136' , 'ANGELO DI DIO N.E.' , '7' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '6.30' ) 06/02/2025 03:49: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 ( '14786' , '137' , 'AVVENTO' , '6' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '7.50' ) 06/02/2025 03:49: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 ( '14786' , '126' , 'SACRAMENTO DEL PERDONO' , '16' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '16.00' ) 06/02/2025 03:49:28 pm >> DELETE FROM ps_document WHERE id_document = '14785' 06/02/2025 03:49:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '14785' 06/02/2025 03:49:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '1/S' AND id_document != '14786' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-02-06') 06/02/2025 03:49:45 pm >> UPDATE ps_document SET id_document_type = '22', document_num = '1/S', document_date = '2025-02-06', document_letter = 'S', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '14', id_causal = '0', price_tax_included = '990.45', price_tax_excluded = '990.45', date_upd = NOW() WHERE id_document = '14786' 06/02/2025 03:49:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14786' 06/02/2025 03:49:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '14786' 06/02/2025 03:49:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14786' , '17' , 'LA FEDE NELLO ZAINETTO' , '4' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '12.00' ) 06/02/2025 03:49:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14786' , '20' , 'GIOVEDÌ SANTO' , '7' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '5.25' ) 06/02/2025 03:49:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14786' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '82' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '61.50' ) 06/02/2025 03:49:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14786' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '69' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '86.25' ) 06/02/2025 03:49:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14786' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '8' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '10.00' ) 06/02/2025 03:49:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14786' , '25' , 'PICCOLO DIZIONARIO DEL CRISTIANO' , '2' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '3.00' ) 06/02/2025 03:49:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14786' , '121' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '3' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '3.75' ) 06/02/2025 03:49:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14786' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '4' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '5.00' ) 06/02/2025 03:49:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14786' , '125' , 'MIE PREGHIERINE - N. E.' , '10' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '7.50' ) 06/02/2025 03:49:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14786' , '42' , 'ALLA SCOPERTA DELLA CASA DI GESU' , '9' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '13.50' ) 06/02/2025 03:49:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14786' , '50' , 'PERDONAMI SIGNORE' , '8' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '10.00' ) 06/02/2025 03:49:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14786' , '55' , 'AVE MARIA ,SPIEGATA AI BAMBINI' , '1' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '0.75' ) 06/02/2025 03:49:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14786' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '2' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '2.00' ) 06/02/2025 03:49:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14786' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '27' , '0' , '4' , '30.0000' , '30' , '0' , '50' , '405.00' ) 06/02/2025 03:49:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14786' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '19' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '19.00' ) 06/02/2025 03:49:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14786' , '75' , 'IL SEGNO DELLA CROCE' , '41' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '30.75' ) 06/02/2025 03:49:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14786' , '92' , 'LA PREGHIERA DEL ROSARIO' , '13' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '16.25' ) 06/02/2025 03:49:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14786' , '94' , 'IL BATTESIMO' , '1' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '0.75' ) 06/02/2025 03:49:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14786' , '104' , 'TEMPO DI QUARESIMA' , '4' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '5.00' ) 06/02/2025 03:49:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14786' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '26' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '32.50' ) 06/02/2025 03:49:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14786' , '111' , 'I NONNI SONO UN TESORO' , '11' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '9.90' ) 06/02/2025 03:49:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14786' , '123' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '12' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '18.00' ) 06/02/2025 03:49:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14786' , '115' , 'SAN FRANCESCO DASSISI RACCONTATO AI RAGAZZI N.E.' , '27' , '0' , '4' , '4.0000' , '4' , '0' , '50' , '54.00' ) 06/02/2025 03:49:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14786' , '116' , 'DIZIONARIO DEI SIMBOLI DEL PICCOLO CRISTIANO NE' , '3' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '3.75' ) 06/02/2025 03:49:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14786' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '52' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '65.00' ) 06/02/2025 03:49:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14786' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '28' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '35.00' ) 06/02/2025 03:49:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14786' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '3' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '4.50' ) 06/02/2025 03:49:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14786' , '138' , 'LA NASCITA DI GESU' , '19' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '23.75' ) 06/02/2025 03:49:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14786' , '139' , 'E NATO - n.e.' , '17' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '17.00' ) 06/02/2025 03:49:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14786' , '136' , 'ANGELO DI DIO N.E.' , '7' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '6.30' ) 06/02/2025 03:49:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14786' , '137' , 'AVVENTO' , '6' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '7.50' ) 06/02/2025 03:49:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14786' , '126' , 'SACRAMENTO DEL PERDONO' , '16' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '16.00' ) 06/02/2025 03:52:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '2/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-02-06') 06/02/2025 03:52:28 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' , '2/S' , '2025-02-06' , 'S' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RESA GENNAIO 2025' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.90' , '32.90' , NOW() , NOW() ) 06/02/2025 03:52:28 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 = '14787' 06/02/2025 03:52:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '14787' 06/02/2025 03:52:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14787' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '2' , '2' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 06/02/2025 03:52:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14787' , '25' , 'PICCOLO DIZIONARIO DEL CRISTIANO' , '1' , '1' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 06/02/2025 03:52:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14787' , '42' , 'ALLA SCOPERTA DELLA CASA DI GESU' , '2' , '2' , '4' , '3.00' , '3' , '0' , '50' , '3.00' ) 06/02/2025 03:52:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14787' , '66' , 'BEATI GLI INVITATI ALLA CENA DEL SIGNORE' , '2' , '2' , '4' , '6.50' , '6.5' , '0' , '50' , '6.50' ) 06/02/2025 03:52:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14787' , '75' , 'IL SEGNO DELLA CROCE' , '2' , '2' , '4' , '1.50' , '1.5' , '0' , '50' , '1.50' ) 06/02/2025 03:52:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14787' , '97' , '\"IL NATALE \"\"CHE MERAVIGLIA\"\"\"' , '3' , '3' , '4' , '1.50' , '1.5' , '0' , '50' , '2.25' ) 06/02/2025 03:52:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14787' , '101' , 'GESU BENEDICI LA NOSTRA FAMIGLIA' , '5' , '5' , '4' , '1.50' , '1.5' , '0' , '50' , '3.75' ) 06/02/2025 03:52:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14787' , '115' , 'SAN FRANCESCO DASSISI RACCONTATO AI RAGAZZI N.E.' , '1' , '1' , '4' , '4.00' , '4' , '0' , '50' , '2.00' ) 06/02/2025 03:52:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14787' , '117' , 'La preghiera delle cinque dita n.e.' , '1' , '1' , '4' , '1.80' , '1.8' , '0' , '50' , '0.90' ) 06/02/2025 03:52:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14787' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '6' , '6' , '4' , '3.00' , '3' , '0' , '50' , '9.00' ) 06/02/2025 04:01:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '3/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-02-06') 06/02/2025 04:01: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 ( '23' , '3/E' , '2025-02-06' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '1554.15' , '1551.45' , NOW() , NOW() ) 06/02/2025 04:01: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 = '95636' 06/02/2025 04:01:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '95636' 06/02/2025 04:01: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 ( '95636' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '186' , '-186' , '4' , '2.40' , '2.4' , '0' , '50' , '223.20' ) 06/02/2025 04:01: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 ( '95636' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '62' , '-62' , '4' , '2.50' , '2.5' , '0' , '50' , '77.50' ) 06/02/2025 04:01: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 ( '95636' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '50' , '4.00' ) 06/02/2025 04:01: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 ( '95636' , '11183' , 'VENITE CON ME - GUIDA' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '50' , '4.00' ) 06/02/2025 04:01: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 ( '95636' , '4479' , 'GESÙ MIO AMICO - VOL. 1°' , '7' , '-7' , '4' , '2.00' , '2' , '0' , '50' , '7.00' ) 06/02/2025 04:01: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 ( '95636' , '4480' , 'GESÙ MIO AMICO - VOL. 2°' , '3' , '-3' , '4' , '2.00' , '2' , '0' , '50' , '3.00' ) 06/02/2025 04:01: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 ( '95636' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '1' , '-1' , '4' , '6.20' , '6.2' , '0' , '50' , '3.10' ) 06/02/2025 04:01: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 ( '95636' , '9675' , 'SARETE MIEI TESTIMONI' , '19' , '-19' , '4' , '3.50' , '3.5' , '0' , '50' , '33.25' ) 06/02/2025 04:01: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 ( '95636' , '5457' , 'IO SONO CON VOI 1 PARTE' , '197' , '-197' , '4' , '2.80' , '2.8' , '0' , '50' , '275.80' ) 06/02/2025 04:01: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 ( '95636' , '5458' , 'IO SONO CON VOI 2 PARTE' , '88' , '-88' , '4' , '2.80' , '2.8' , '0' , '50' , '123.20' ) 06/02/2025 04:01: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 ( '95636' , '11191' , 'VENITE CON ME 1 PARTE' , '35' , '-35' , '4' , '2.80' , '2.8' , '0' , '50' , '49.00' ) 06/02/2025 04:01: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 ( '95636' , '11192' , 'VENITE CON ME 2 PARTE' , '41' , '-41' , '4' , '2.80' , '2.8' , '0' , '50' , '57.40' ) 06/02/2025 04:01: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 ( '95636' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '11' , '-11' , '4' , '8.00' , '8' , '0' , '50' , '44.00' ) 06/02/2025 04:01: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 ( '95636' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 06/02/2025 04:01: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 ( '95636' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '42' , '-42' , '4' , '3.40' , '3.4' , '0' , '50' , '71.40' ) 06/02/2025 04:01: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 ( '95636' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '50' , '5.00' ) 06/02/2025 04:01: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 ( '95636' , '9996' , 'SIGNORE, TI PREGO' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '50' , '3.00' ) 06/02/2025 04:01: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 ( '95636' , '5645' , 'LEGGERE,... LA PAROLA - ANNO C' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '50' , '10.00' ) 06/02/2025 04:01: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 ( '95636' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '10' , '-10' , '4' , '8.00' , '8' , '0' , '50' , '40.00' ) 06/02/2025 04:01: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 ( '95636' , '6629' , 'MIA PREGHIERA' , '40' , '-40' , '4' , '0.90' , '0.9' , '0' , '50' , '18.00' ) 06/02/2025 04:01: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 ( '95636' , '8408' , 'PRENDETE E MANGIATE' , '38' , '-38' , '4' , '3.00' , '3' , '0' , '50' , '57.00' ) 06/02/2025 04:01: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 ( '95636' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 06/02/2025 04:01: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 ( '95636' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '50' , '5.00' ) 06/02/2025 04:01: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 ( '95636' , '4154' , 'FESTA DEL PERDONO' , '82' , '-82' , '4' , '3.00' , '3' , '0' , '50' , '123.00' ) 06/02/2025 04:01: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 ( '95636' , '2679' , 'CONOSCERE GESU' , '93' , '-93' , '4' , '3.50' , '3.5' , '0' , '50' , '162.75' ) 06/02/2025 04:01: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 ( '95636' , '2680' , 'CONOSCERE GESU - GUIDA' , '2' , '-2' , '4' , '6.00' , '6' , '0' , '50' , '6.00' ) 06/02/2025 04:01: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 ( '95636' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '5' , '-5' , '4' , '5.00' , '5' , '0' , '50' , '12.50' ) 06/02/2025 04:01: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 ( '95636' , '11102' , 'VANGELO E ATTI DEGLI APOSTOLI - RIL.' , '5' , '-5' , '4' , '8.50' , '8.5' , '0' , '50' , '21.25' ) 06/02/2025 04:01: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 ( '95636' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 06/02/2025 04:01:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '3511' , 'DIO PARLA ALLUOMO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '50' , '6.00' ) 06/02/2025 04:01:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '1003' , 'BEATO CHI ASCOLTA... - ANNO C - B. PREVITALI ' , '3' , '-3' , '4' , '12.00' , '12' , '0' , '50' , '18.00' ) 06/02/2025 04:01:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '8974' , 'RIFORMA DELLA RIFORMA - A. SORRENTINO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 06/02/2025 04:01:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '7543' , 'PARABOLE DI GESÙ' , '7' , '-7' , '4' , '3.00' , '3' , '0' , '50' , '10.50' ) 06/02/2025 04:01:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '2' , '-2' , '4' , '3.80' , '3.8' , '0' , '50' , '3.80' ) 06/02/2025 04:01:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '2' , '-2' , '4' , '3.80' , '3.8' , '0' , '50' , '3.80' ) 06/02/2025 04:01:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '50' , '10.00' ) 06/02/2025 04:01:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '2' , '-2' , '4' , '3.80' , '3.8' , '0' , '50' , '3.80' ) 06/02/2025 04:01:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '5' , '-5' , '4' , '1.60' , '1.6' , '0' , '50' , '4.00' ) 06/02/2025 04:01:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '50' , '10.00' ) 06/02/2025 04:01:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '50' , '10.00' ) 06/02/2025 04:01:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '12819' , 'REGISTRO DEL CATECHISTA ' , '30' , '-30' , '1' , '1.00' , '0.81967213114754' , '22' , '50' , '15.00' ) 06/02/2025 04:01:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '12253' , 'MIO LIBRO DI PREGHIERE' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '50' , '1.40' ) 06/02/2025 04:01:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '2' , '-2' , '4' , '3.50' , '3.5' , '0' , '50' , '3.50' ) 06/02/2025 04:02:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '408' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-06') 06/02/2025 04:02:56 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' , '408' , '2025-02-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.25' , '14.25' , NOW() , NOW() ) 06/02/2025 04:02:56 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 = '95637' 06/02/2025 04:02:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '95637' 06/02/2025 04:02:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95637' , '23405' , 'DIARIO SANTA FAUSTINA - N.E.' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 06/02/2025 04:03:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '409' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-06') 06/02/2025 04:03:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '409' , '2025-02-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.00' , '27.05' , NOW() , NOW() ) 06/02/2025 04:03:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95638' 06/02/2025 04:03:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '95638' 06/02/2025 04:03:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95638' , '21583' , 'CUSTODIA PELLE LITURGIA DELLE ORE - 731' , '1' , '-1' , '1' , '33.00' , '27.049180327869' , '22' , '0' , '33.00' ) 06/02/2025 04:11:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '4/E' AND id_document != '95636' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-02-06') 06/02/2025 04:11:39 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '4/E', document_date = '2025-02-06', document_letter = 'E', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '14', id_causal = '0', price_tax_included = '2057.15', price_tax_excluded = '2054.45', date_upd = NOW() WHERE id_document = '95636' 06/02/2025 04:11:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95636' 06/02/2025 04:11:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '95636' 06/02/2025 04:11:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '186' , '-186' , '4' , '2.4000' , '2.4' , '0' , '50' , '223.20' ) 06/02/2025 04:11:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '62' , '-62' , '4' , '2.5000' , '2.5' , '0' , '50' , '77.50' ) 06/02/2025 04:11:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '50' , '4.00' ) 06/02/2025 04:11:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '11183' , 'VENITE CON ME - GUIDA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '50' , '4.00' ) 06/02/2025 04:11:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '4479' , 'GESÙ MIO AMICO - VOL. 1°' , '7' , '-7' , '4' , '2.0000' , '2' , '0' , '50' , '7.00' ) 06/02/2025 04:11:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '4480' , 'GESÙ MIO AMICO - VOL. 2°' , '3' , '-3' , '4' , '2.0000' , '2' , '0' , '50' , '3.00' ) 06/02/2025 04:11:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '1' , '-1' , '4' , '6.2000' , '6.2' , '0' , '50' , '3.10' ) 06/02/2025 04:11:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '9675' , 'SARETE MIEI TESTIMONI' , '19' , '-19' , '4' , '3.5000' , '3.5' , '0' , '50' , '33.25' ) 06/02/2025 04:11:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '5457' , 'IO SONO CON VOI 1 PARTE' , '197' , '-197' , '4' , '2.8000' , '2.8' , '0' , '50' , '275.80' ) 06/02/2025 04:11:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '5458' , 'IO SONO CON VOI 2 PARTE' , '88' , '-88' , '4' , '2.8000' , '2.8' , '0' , '50' , '123.20' ) 06/02/2025 04:11:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '11191' , 'VENITE CON ME 1 PARTE' , '35' , '-35' , '4' , '2.8000' , '2.8' , '0' , '50' , '49.00' ) 06/02/2025 04:11:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '11192' , 'VENITE CON ME 2 PARTE' , '41' , '-41' , '4' , '2.8000' , '2.8' , '0' , '50' , '57.40' ) 06/02/2025 04:11:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '11' , '-11' , '4' , '8.0000' , '8' , '0' , '50' , '44.00' ) 06/02/2025 04:11:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 06/02/2025 04:11:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '42' , '-42' , '4' , '3.4000' , '3.4' , '0' , '50' , '71.40' ) 06/02/2025 04:11:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 06/02/2025 04:11:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '9996' , 'SIGNORE, TI PREGO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '50' , '3.00' ) 06/02/2025 04:11:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '5645' , 'LEGGERE,... LA PAROLA - ANNO C' , '2' , '-2' , '4' , '10.0000' , '10' , '0' , '50' , '10.00' ) 06/02/2025 04:11:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '10' , '-10' , '4' , '8.0000' , '8' , '0' , '50' , '40.00' ) 06/02/2025 04:11:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '6629' , 'MIA PREGHIERA' , '40' , '-40' , '4' , '0.9000' , '0.9' , '0' , '50' , '18.00' ) 06/02/2025 04:11:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '8408' , 'PRENDETE E MANGIATE' , '38' , '-38' , '4' , '3.0000' , '3' , '0' , '50' , '57.00' ) 06/02/2025 04:11: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 ( '95636' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 06/02/2025 04:11: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 ( '95636' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 06/02/2025 04:11: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 ( '95636' , '4154' , 'FESTA DEL PERDONO' , '82' , '-82' , '4' , '3.0000' , '3' , '0' , '50' , '123.00' ) 06/02/2025 04:11: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 ( '95636' , '2679' , 'CONOSCERE GESU' , '93' , '-93' , '4' , '3.5000' , '3.5' , '0' , '50' , '162.75' ) 06/02/2025 04:11: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 ( '95636' , '2680' , 'CONOSCERE GESU - GUIDA' , '2' , '-2' , '4' , '6.0000' , '6' , '0' , '50' , '6.00' ) 06/02/2025 04:11: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 ( '95636' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '5' , '-5' , '4' , '5.0000' , '5' , '0' , '50' , '12.50' ) 06/02/2025 04:11: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 ( '95636' , '11102' , 'VANGELO E ATTI DEGLI APOSTOLI - RIL.' , '5' , '-5' , '4' , '8.5000' , '8.5' , '0' , '50' , '21.25' ) 06/02/2025 04:11: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 ( '95636' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 06/02/2025 04:11: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 ( '95636' , '3511' , 'DIO PARLA ALLUOMO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '50' , '6.00' ) 06/02/2025 04:11: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 ( '95636' , '1003' , 'BEATO CHI ASCOLTA... - ANNO C - B. PREVITALI ' , '3' , '-3' , '4' , '12.0000' , '12' , '0' , '50' , '18.00' ) 06/02/2025 04:11: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 ( '95636' , '8974' , 'RIFORMA DELLA RIFORMA - A. SORRENTINO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '50' , '7.50' ) 06/02/2025 04:11: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 ( '95636' , '7543' , 'PARABOLE DI GESÙ' , '7' , '-7' , '4' , '3.0000' , '3' , '0' , '50' , '10.50' ) 06/02/2025 04:11: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 ( '95636' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '2' , '-2' , '4' , '3.8000' , '3.8' , '0' , '50' , '3.80' ) 06/02/2025 04:11: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 ( '95636' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '2' , '-2' , '4' , '3.8000' , '3.8' , '0' , '50' , '3.80' ) 06/02/2025 04:11: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 ( '95636' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '2' , '-2' , '4' , '10.0000' , '10' , '0' , '50' , '10.00' ) 06/02/2025 04:11: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 ( '95636' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '2' , '-2' , '4' , '3.8000' , '3.8' , '0' , '50' , '3.80' ) 06/02/2025 04:11: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 ( '95636' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '5' , '-5' , '4' , '1.6000' , '1.6' , '0' , '50' , '4.00' ) 06/02/2025 04:11: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 ( '95636' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '2' , '-2' , '4' , '10.0000' , '10' , '0' , '50' , '10.00' ) 06/02/2025 04:11: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 ( '95636' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '2' , '-2' , '4' , '10.0000' , '10' , '0' , '50' , '10.00' ) 06/02/2025 04:11: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 ( '95636' , '12819' , 'REGISTRO DEL CATECHISTA ' , '30' , '-30' , '1' , '1.0000' , '0.81967213114754' , '22' , '50' , '15.00' ) 06/02/2025 04:11: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 ( '95636' , '12253' , 'MIO LIBRO DI PREGHIERE' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '50' , '1.40' ) 06/02/2025 04:11: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 ( '95636' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '2' , '-2' , '4' , '3.5000' , '3.5' , '0' , '50' , '3.50' ) 06/02/2025 04:11: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 ( '95636' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '2' , '-2' , '4' , '6.00' , '6' , '0' , '50' , '6.00' ) 06/02/2025 04:11: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 ( '95636' , '13397' , 'MIO GESU' , '36' , '-36' , '4' , '3.50' , '3.5' , '0' , '50' , '63.00' ) 06/02/2025 04:11: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 ( '95636' , '13956' , 'MIRACOLI DI GESU' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 06/02/2025 04:11: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 ( '95636' , '14223' , 'PRONTUARIO BIBLICO - LITURGICO - F. GIGLIO' , '4' , '-4' , '4' , '9.00' , '9' , '0' , '50' , '18.00' ) 06/02/2025 04:11: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 ( '95636' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '116' , '-116' , '4' , '1.00' , '1' , '0' , '50' , '58.00' ) 06/02/2025 04:11: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 ( '95636' , '15019' , 'PREGHIAMO CON MARIA' , '2' , '-2' , '4' , '0.80' , '0.8' , '0' , '50' , '0.80' ) 06/02/2025 04:11: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 ( '95636' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 06/02/2025 04:11: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 ( '95636' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '258' , '-258' , '4' , '1.00' , '1' , '0' , '50' , '129.00' ) 06/02/2025 04:11: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 ( '95636' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '3' , '-3' , '4' , '2.00' , '2' , '0' , '50' , '3.00' ) 06/02/2025 04:11:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '17257' , 'IO TI BATTEZZO ' , '5' , '-5' , '4' , '1.80' , '1.8' , '0' , '50' , '4.50' ) 06/02/2025 04:11:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '18460' , 'CON CUORE DI PADRE - V. SALVOLDI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 06/02/2025 04:11:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '36' , '-36' , '4' , '1.90' , '1.9' , '0' , '50' , '34.20' ) 06/02/2025 04:11:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '18528' , 'CON GESU VERSO IL CALVARIO - G. VALSECCHI' , '80' , '-80' , '4' , '1.50' , '1.5' , '0' , '50' , '60.00' ) 06/02/2025 04:11:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '18657' , 'HO DATO LORO LA TUA PAROLA - TEMPI FORTI- G. VALSECCHI' , '3' , '-3' , '4' , '16.00' , '16' , '0' , '50' , '24.00' ) 06/02/2025 04:11:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '5' , '-5' , '4' , '7.00' , '7' , '0' , '50' , '17.50' ) 06/02/2025 04:11:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '2' , '-2' , '4' , '9.00' , '9' , '0' , '50' , '9.00' ) 06/02/2025 04:11:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '4' , '-4' , '4' , '9.00' , '9' , '0' , '50' , '18.00' ) 06/02/2025 04:11:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '2' , '-2' , '4' , '9.00' , '9' , '0' , '50' , '9.00' ) 06/02/2025 04:11:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '50' , '6.00' ) 06/02/2025 04:11:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 06/02/2025 04:11:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '2' , '-2' , '4' , '35.00' , '35' , '0' , '50' , '35.00' ) 06/02/2025 04:11:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95636' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE - SALVOLDI' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 06/02/2025 04:19:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '3/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-02-06') 06/02/2025 04:19: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 ( '22' , '3/E' , '2025-02-06' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'VENDUTO GENNAIO 2025' , '0.00' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '3926.60' , '3926.60' , NOW() , NOW() ) 06/02/2025 04:19: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 = '95639' 06/02/2025 04:19:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '95639' 06/02/2025 04:19: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 ( '95639' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '186' , '0' , '4' , '2.4000' , '2.4' , '0' , '50' , '223.20' ) 06/02/2025 04:19: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 ( '95639' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '62' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '77.50' ) 06/02/2025 04:19: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 ( '95639' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '4.00' ) 06/02/2025 04:19: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 ( '95639' , '11183' , 'VENITE CON ME - GUIDA' , '1' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '4.00' ) 06/02/2025 04:19: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 ( '95639' , '4479' , 'GESÙ MIO AMICO - VOL. 1°' , '7' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '7.00' ) 06/02/2025 04:19: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 ( '95639' , '4480' , 'GESÙ MIO AMICO - VOL. 2°' , '3' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '3.00' ) 06/02/2025 04:19:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '1' , '0' , '4' , '6.2000' , '6.2' , '0' , '50' , '3.10' ) 06/02/2025 04:19:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '9675' , 'SARETE MIEI TESTIMONI' , '19' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '33.25' ) 06/02/2025 04:19:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '5457' , 'IO SONO CON VOI 1 PARTE' , '197' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '275.80' ) 06/02/2025 04:19:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '5458' , 'IO SONO CON VOI 2 PARTE' , '88' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '123.20' ) 06/02/2025 04:19:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '11191' , 'VENITE CON ME 1 PARTE' , '35' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '49.00' ) 06/02/2025 04:19:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '11192' , 'VENITE CON ME 2 PARTE' , '41' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '57.40' ) 06/02/2025 04:19:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '11' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '44.00' ) 06/02/2025 04:19:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 06/02/2025 04:19:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '42' , '0' , '4' , '3.4000' , '3.4' , '0' , '50' , '71.40' ) 06/02/2025 04:19:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '2' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 06/02/2025 04:19:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '9996' , 'SIGNORE, TI PREGO' , '1' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '3.00' ) 06/02/2025 04:19:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '5645' , 'LEGGERE,... LA PAROLA - ANNO C' , '2' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '10.00' ) 06/02/2025 04:19:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '10' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '40.00' ) 06/02/2025 04:19:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '6629' , 'MIA PREGHIERA' , '40' , '0' , '4' , '0.9000' , '0.9' , '0' , '50' , '18.00' ) 06/02/2025 04:19:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '8408' , 'PRENDETE E MANGIATE' , '38' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '57.00' ) 06/02/2025 04:19:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 06/02/2025 04:19:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '2' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 06/02/2025 04:19:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '4154' , 'FESTA DEL PERDONO' , '82' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '123.00' ) 06/02/2025 04:19:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '2679' , 'CONOSCERE GESU' , '93' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '162.75' ) 06/02/2025 04:19:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '2680' , 'CONOSCERE GESU - GUIDA' , '2' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '6.00' ) 06/02/2025 04:19:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '5' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '12.50' ) 06/02/2025 04:19:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '11102' , 'VANGELO E ATTI DEGLI APOSTOLI - RIL.' , '5' , '0' , '4' , '8.5000' , '8.5' , '0' , '50' , '21.25' ) 06/02/2025 04:19:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 06/02/2025 04:19:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '3511' , 'DIO PARLA ALLUOMO' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '50' , '6.00' ) 06/02/2025 04:19:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '1003' , 'BEATO CHI ASCOLTA... - ANNO C - B. PREVITALI ' , '3' , '0' , '4' , '12.0000' , '12' , '0' , '50' , '18.00' ) 06/02/2025 04:19:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '8974' , 'RIFORMA DELLA RIFORMA - A. SORRENTINO' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '50' , '7.50' ) 06/02/2025 04:19:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '7543' , 'PARABOLE DI GESÙ' , '7' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '10.50' ) 06/02/2025 04:19:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '2' , '0' , '4' , '3.8000' , '3.8' , '0' , '50' , '3.80' ) 06/02/2025 04:19:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '2' , '0' , '4' , '3.8000' , '3.8' , '0' , '50' , '3.80' ) 06/02/2025 04:19:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '2' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '10.00' ) 06/02/2025 04:19:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '2' , '0' , '4' , '3.8000' , '3.8' , '0' , '50' , '3.80' ) 06/02/2025 04:19:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '5' , '0' , '4' , '1.6000' , '1.6' , '0' , '50' , '4.00' ) 06/02/2025 04:19:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '2' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '10.00' ) 06/02/2025 04:19:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '2' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '10.00' ) 06/02/2025 04:19:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '12819' , 'REGISTRO DEL CATECHISTA ' , '30' , '0' , '1' , '1.0000' , '0.8197' , '22' , '50' , '15.00' ) 06/02/2025 04:19:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '12253' , 'MIO LIBRO DI PREGHIERE' , '1' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '1.40' ) 06/02/2025 04:19:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '2' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '3.50' ) 06/02/2025 04:19:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '2' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '6.00' ) 06/02/2025 04:19:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '13397' , 'MIO GESU' , '36' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '63.00' ) 06/02/2025 04:19:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '13956' , 'MIRACOLI DI GESU' , '1' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '1.50' ) 06/02/2025 04:19:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '14223' , 'PRONTUARIO BIBLICO - LITURGICO - F. GIGLIO' , '4' , '0' , '4' , '9.0000' , '9' , '0' , '50' , '18.00' ) 06/02/2025 04:19:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '116' , '0' , '4' , '1.0000' , '1' , '0' , '50' , '58.00' ) 06/02/2025 04:19:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '15019' , 'PREGHIAMO CON MARIA' , '2' , '0' , '4' , '0.8000' , '0.8' , '0' , '50' , '0.80' ) 06/02/2025 04:19:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '1' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 06/02/2025 04:19:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '258' , '0' , '4' , '1.0000' , '1' , '0' , '50' , '129.00' ) 06/02/2025 04:19:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '3' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '3.00' ) 06/02/2025 04:19:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '17257' , 'IO TI BATTEZZO ' , '5' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '4.50' ) 06/02/2025 04:19:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '18460' , 'CON CUORE DI PADRE - V. SALVOLDI' , '1' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '1.00' ) 06/02/2025 04:19:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '36' , '0' , '4' , '1.9000' , '1.9' , '0' , '50' , '34.20' ) 06/02/2025 04:19:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '18528' , 'CON GESU VERSO IL CALVARIO - G. VALSECCHI' , '80' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '60.00' ) 06/02/2025 04:19:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '18657' , 'HO DATO LORO LA TUA PAROLA - TEMPI FORTI- G. VALSECCHI' , '3' , '0' , '4' , '16.0000' , '16' , '0' , '50' , '24.00' ) 06/02/2025 04:19:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '5' , '0' , '4' , '7.0000' , '7' , '0' , '50' , '17.50' ) 06/02/2025 04:19:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '2' , '0' , '4' , '9.0000' , '9' , '0' , '50' , '9.00' ) 06/02/2025 04:19:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '4' , '0' , '4' , '9.0000' , '9' , '0' , '50' , '18.00' ) 06/02/2025 04:19:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '2' , '0' , '4' , '9.0000' , '9' , '0' , '50' , '9.00' ) 06/02/2025 04:19:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '50' , '6.00' ) 06/02/2025 04:19:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '1' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 06/02/2025 04:19:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '2' , '0' , '4' , '35.0000' , '35' , '0' , '50' , '35.00' ) 06/02/2025 04:19:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE - SALVOLDI' , '2' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '2.50' ) 06/02/2025 04:19:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '20231' , 'PREGANDO NON SPRECATE PAROLE - G. DAMORE' , '1' , '0' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 06/02/2025 04:19:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '20640' , 'GESU, MOSSO A COMPASSIONE V. SALVOLDI' , '4' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '5.00' ) 06/02/2025 04:19:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '20719' , 'CORONA DELL’ADDOLORATA' , '5' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '4.50' ) 06/02/2025 04:19:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '25' , '0' , '4' , '2.00' , '2' , '0' , '50' , '25.00' ) 06/02/2025 04:19:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '20722' , 'SEMINATORI DI GIOIA' , '3' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 06/02/2025 04:19:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '10' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '12.50' ) 06/02/2025 04:19:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '21417' , 'VIENI, NON TARDARE SIGNORE, NOSTRA PACE!' , '2' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 06/02/2025 04:19:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '21644' , 'INCONTRO AL DIO CHE VIENE' , '1' , '0' , '4' , '8.00' , '8' , '0' , '50' , '4.00' ) 06/02/2025 04:19:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '96' , '0' , '4' , '3.00' , '3' , '0' , '50' , '144.00' ) 06/02/2025 04:19:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '22031' , 'GLI ULTIMI SARANNO PRIMI - R. LUPI' , '5' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 06/02/2025 04:19:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '22029' , 'PREPARIAMOCI ALLA PRIMA CONFESSIONE - POSTER' , '5' , '0' , '4' , '2.00' , '2' , '0' , '50' , '5.00' ) 06/02/2025 04:19:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '22030' , 'PREPARIAMOCI ALLA PRIMA COMUNIONE - POSTER' , '6' , '0' , '4' , '2.00' , '2' , '0' , '50' , '6.00' ) 06/02/2025 04:19:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '5' , '0' , '4' , '8.00' , '8' , '0' , '50' , '20.00' ) 06/02/2025 04:19:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '22032' , 'ECCO ORA IL MOMENTO FAVOREVOLE ' , '4' , '0' , '4' , '10.00' , '10' , '0' , '50' , '20.00' ) 06/02/2025 04:19:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '21418' , 'CRISTO NOSTRA PACE - V. SALVORDI' , '2' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 06/02/2025 04:19:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '236' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '330.40' ) 06/02/2025 04:19:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '281' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '393.40' ) 06/02/2025 04:19:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '22053' , 'AMO IL SIGNORE, PERCHÉ ASCOLTA IL GRIDO DELLA MIA PREGHIERA' , '3' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 06/02/2025 04:19:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '23092' , 'SPERANZA CHE E IN NOI' , '39' , '0' , '4' , '3.00' , '3' , '0' , '50' , '58.50' ) 06/02/2025 04:19:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '23348' , 'ECCE LIGNUM CRUCIS - V. SIRACUSA' , '125' , '0' , '4' , '3.00' , '3' , '0' , '50' , '187.50' ) 06/02/2025 04:19:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '22809' , 'O LUCE BEATISSIMA' , '81' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '101.25' ) 06/02/2025 04:19:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '22871' , 'SPERANZA NON DELUDE - M. DE ROSA' , '49' , '0' , '4' , '8.00' , '8' , '0' , '50' , '196.00' ) 06/02/2025 04:19:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '22961' , 'UN BAMBINO E NATO PER NOI - G. VALSECCHI' , '12' , '0' , '4' , '3.00' , '3' , '0' , '50' , '18.00' ) 06/02/2025 04:19:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '23032' , 'MIO LIBRO DI PREGHIERE - N. E. ' , '106' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '148.40' ) 06/02/2025 04:19:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '23271' , 'OMELIA, ECO DELLA PAROLA DI DIO - R. RAMPOLLA' , '31' , '0' , '4' , '5.00' , '5' , '0' , '50' , '77.50' ) 06/02/2025 04:19:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95639' , '23380' , 'DAL TUO CUORE TRAFITTO E GLORIOSO LA NOSTRA GIOIA E LA NOSTRA SPERANZA' , '71' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '88.75' ) 06/02/2025 04:19:22 pm >> DELETE FROM ps_document WHERE id_document = '95636' 06/02/2025 04:19:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '95636' 06/02/2025 04:24:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '4/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-02-06') 06/02/2025 04:24: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' , '4/E' , '2025-02-06' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RESA GENNAIO 2025' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '221.00' , '221.00' , NOW() , NOW() ) 06/02/2025 04:24: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 = '95640' 06/02/2025 04:24:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '95640' 06/02/2025 04:24: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 ( '95640' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 06/02/2025 04:24: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 ( '95640' , '5457' , 'IO SONO CON VOI 1 PARTE' , '11' , '11' , '4' , '2.80' , '2.8' , '0' , '50' , '15.40' ) 06/02/2025 04:24: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 ( '95640' , '5458' , 'IO SONO CON VOI 2 PARTE' , '28' , '28' , '4' , '2.80' , '2.8' , '0' , '50' , '39.20' ) 06/02/2025 04:24: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 ( '95640' , '11191' , 'VENITE CON ME 1 PARTE' , '26' , '26' , '4' , '2.80' , '2.8' , '0' , '50' , '36.40' ) 06/02/2025 04:24: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 ( '95640' , '11192' , 'VENITE CON ME 2 PARTE' , '24' , '24' , '4' , '2.80' , '2.8' , '0' , '50' , '33.60' ) 06/02/2025 04:24: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 ( '95640' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '11' , '11' , '4' , '3.40' , '3.4' , '0' , '50' , '18.70' ) 06/02/2025 04:24: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 ( '95640' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '2' , '2' , '4' , '5.00' , '5' , '0' , '50' , '5.00' ) 06/02/2025 04:24: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 ( '95640' , '4154' , 'FESTA DEL PERDONO' , '1' , '1' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 06/02/2025 04:24: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 ( '95640' , '2679' , 'CONOSCERE GESU' , '1' , '1' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 06/02/2025 04:24: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 ( '95640' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '1' , '4' , '3.80' , '3.8' , '0' , '50' , '1.90' ) 06/02/2025 04:24: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 ( '95640' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '1' , '4' , '3.80' , '3.8' , '0' , '50' , '1.90' ) 06/02/2025 04:24: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 ( '95640' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '1' , '4' , '3.80' , '3.8' , '0' , '50' , '1.90' ) 06/02/2025 04:24: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 ( '95640' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '5' , '5' , '4' , '1.60' , '1.6' , '0' , '50' , '4.00' ) 06/02/2025 04:24: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 ( '95640' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '1' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 06/02/2025 04:24: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 ( '95640' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '2' , '2' , '4' , '15.00' , '15' , '0' , '50' , '15.00' ) 06/02/2025 04:24: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 ( '95640' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '1' , '1' , '4' , '7.00' , '7' , '0' , '50' , '3.50' ) 06/02/2025 04:24: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 ( '95640' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '1' , '1' , '4' , '9.00' , '9' , '0' , '50' , '4.50' ) 06/02/2025 04:24: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 ( '95640' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 06/02/2025 04:24: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 ( '95640' , '21644' , 'INCONTRO AL DIO CHE VIENE' , '1' , '1' , '4' , '8.00' , '8' , '0' , '50' , '4.00' ) 06/02/2025 04:24: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 ( '95640' , '22030' , 'PREPARIAMOCI ALLA PRIMA COMUNIONE - POSTER' , '1' , '1' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 06/02/2025 04:24: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 ( '95640' , '21418' , 'CRISTO NOSTRA PACE - V. SALVORDI' , '2' , '2' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 06/02/2025 04:24: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 ( '95640' , '23092' , 'SPERANZA CHE E IN NOI' , '1' , '1' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 06/02/2025 04:24: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 ( '95640' , '22871' , 'SPERANZA NON DELUDE - M. DE ROSA' , '1' , '1' , '4' , '8.00' , '8' , '0' , '50' , '4.00' ) 06/02/2025 04:24:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95640' , '22961' , 'UN BAMBINO E NATO PER NOI - G. VALSECCHI' , '13' , '13' , '4' , '3.00' , '3' , '0' , '50' , '19.50' ) 06/02/2025 04:49:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '410' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-06') 06/02/2025 04:49:34 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '410' , '2025-02-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '400.00' , '327.87' , NOW() , NOW() ) 06/02/2025 04:49:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95641' 06/02/2025 04:49:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '95641' 06/02/2025 04:49:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95641' , '23392' , 'DALMATICA - 86/D16418' , '1' , '-1' , '1' , '280.00' , '229.50819672131' , '22' , '0' , '280.00' ) 06/02/2025 04:49:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95641' , '14389' , 'CAMICE MISTO COTONE - COLLO QUADRO - 446TCAQ' , '1' , '-1' , '1' , '120' , '98.360655737705' , '22' , '0' , '120.00' ) 06/02/2025 05:03:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '411' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-06') 06/02/2025 05:03:18 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '411' , '2025-02-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 06/02/2025 05:03:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95642' 06/02/2025 05:03:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '95642' 06/02/2025 05:03:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95642' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 06/02/2025 06:17:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '412' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-06') 06/02/2025 06:17:34 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '412' , '2025-02-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '66.00' , '61.90' , NOW() , NOW() ) 06/02/2025 06:17:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95643' 06/02/2025 06:17:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '95643' 06/02/2025 06:17:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95643' , '6011' , 'LUMINELLO VETRO - 474' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 06/02/2025 06:17:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95643' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 06/02/2025 06:17:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95643' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 06/02/2025 06:23:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '413' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-06') 06/02/2025 06:23: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 ( '11' , '413' , '2025-02-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.90' , '4.84' , NOW() , NOW() ) 06/02/2025 06:23: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 = '95644' 06/02/2025 06:23:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '95644' 06/02/2025 06:23: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 ( '95644' , '3807' , 'ELETTRICO LUMINI 10/EA 150 GG' , '1' , '-1' , '1' , '5.9' , '4.8360655737705' , '22' , '0' , '5.90' ) 06/02/2025 07:05:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '414' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-06') 06/02/2025 07:05:56 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' , '414' , '2025-02-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '250.00' , '204.92' , NOW() , NOW() ) 06/02/2025 07:05:56 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 = '95645' 06/02/2025 07:05:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '95645' 06/02/2025 07:05:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95645' , '23392' , 'DALMATICA - 86/D16418' , '1' , '-1' , '1' , '250' , '204.91803278689' , '22' , '0' , '250.00' ) 06/02/2025 07:10:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '322' AND id_document != '95517' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-31') 06/02/2025 07:10:49 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '322', document_date = '2025-01-31', 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 = '695.00', price_tax_excluded = '569.67', date_upd = NOW() WHERE id_document = '95517' 06/02/2025 07:10: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 = '95517' 06/02/2025 07:10:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '95517' 06/02/2025 07:10:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95517' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '450' , '368.85245901639' , '22' , '0' , '450.00' ) 06/02/2025 07:10:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95517' , '23392' , 'DALMATICA - 86/D16418' , '1' , '-1' , '1' , '245' , '200.81967213115' , '22' , '0' , '245.00' )