05/03/2024 08:59:27 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 05/03/2024 08:59:27 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22236' , '1' , '' , 'nuovo-prodotto' ) 05/03/2024 08:59:27 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22236' , '1' , '1' , '2' , NOW() , NOW() ) 05/03/2024 08:59:27 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22236' , '0' , '1' , '0' , '0' ) 05/03/2024 09:00:29 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281253148' AND id_product != '22236' AND ean13 != '' 05/03/2024 09:00:30 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791281253148', date_upd = NOW() WHERE id_product = '22236' 05/03/2024 09:00:30 am >> UPDATE ps_product_lang SET name = 'CRISTO E\' RISORTO - PAPA FRANCESCO', description = '' WHERE id_product = '22236' 05/03/2024 09:00:30 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '22236' 05/03/2024 09:00:30 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '518', 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 = '22236' 05/03/2024 09:00:30 am >> DELETE FROM ps_specific_price WHERE id_product = '22236' 05/03/2024 09:00:31 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22236' 05/03/2024 09:00:31 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22237' , '1' , '' , 'nuovo-prodotto' ) 05/03/2024 09:00:31 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22237' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22236' 05/03/2024 09:00:31 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22237' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22236' 05/03/2024 09:01:19 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9787706240404' AND id_product != '22237' AND ean13 != '' 05/03/2024 09:01:19 am >> UPDATE ps_product SET id_supplier = '', reference = '7/4', ean13 = '9787706240404', date_upd = NOW() WHERE id_product = '22237' 05/03/2024 09:01:19 am >> UPDATE ps_product_lang SET name = 'DALL\'ALBA AL TRAMONTO - APR. 24', description = '' WHERE id_product = '22237' 05/03/2024 09:01:19 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.2' WHERE id_product = '22237' 05/03/2024 09:01:19 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.2', id_tax_rules_group = '4', id_category_default = '280', 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 = '22237' 05/03/2024 09:01:19 am >> DELETE FROM ps_specific_price WHERE id_product = '22237' 05/03/2024 09:01:20 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22237' 05/03/2024 09:01:20 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22238' , '1' , '' , 'nuovo-prodotto' ) 05/03/2024 09:01:20 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22238' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22237' 05/03/2024 09:01:20 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22238' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22237' 05/03/2024 09:02:00 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861247031' AND id_product != '22238' AND ean13 != '' 05/03/2024 09:02:00 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788861247031', date_upd = NOW() WHERE id_product = '22238' 05/03/2024 09:02:01 am >> UPDATE ps_product_lang SET name = 'LE MIE PREGHIERE', description = '' WHERE id_product = '22238' 05/03/2024 09:02:01 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5' WHERE id_product = '22238' 05/03/2024 09:02:01 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22238' 05/03/2024 09:02:01 am >> DELETE FROM ps_specific_price WHERE id_product = '22238' 05/03/2024 09:02:01 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22238' 05/03/2024 09:02:01 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22239' , '1' , '' , 'nuovo-prodotto' ) 05/03/2024 09:02:01 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22239' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22238' 05/03/2024 09:02:01 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22239' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22238' 05/03/2024 09:03:51 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 ( '33' , '658128' , '2024-03-01' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '3.21' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '112.10' , '112.10' , NOW() , NOW() ) 05/03/2024 09:03:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90612' 05/03/2024 09:03:51 am >> DELETE FROM ps_document_detail WHERE id_document = '90612' 05/03/2024 09:03:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90612' , '22236' , 'CRISTO E RISORTO - PAPA FRANCESCO' , '1' , '1' , '4' , '15.00' , '15' , '0' , '30' , '10.5000' ) 05/03/2024 09:03:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '22236' AND id_supplier = '7' 05/03/2024 09:03:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22236' , '7' , '1' ) 05/03/2024 09:03:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90612' , '22237' , 'DALLALBA AL TRAMONTO - APR. 24' , '1' , '1' , '4' , '3.20' , '3.2' , '0' , '30' , '2.2400' ) 05/03/2024 09:03:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '22237' AND id_supplier = '7' 05/03/2024 09:03:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22237' , '7' , '1' ) 05/03/2024 09:03:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90612' , '22238' , 'LE MIE PREGHIERE' , '1' , '1' , '4' , '3.50' , '3.5' , '0' , '30' , '2.4500' ) 05/03/2024 09:03:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '22238' AND id_supplier = '7' 05/03/2024 09:03:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22238' , '7' , '1' ) 05/03/2024 09:03:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90612' , '15471' , 'ADORAZIONE EUCARISTICA SPIEGATA AI BAMBINI' , '2' , '2' , '4' , '3.50' , '3.5' , '0' , '30' , '4.9000' ) 05/03/2024 09:03:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '15471' AND id_supplier = '7' 05/03/2024 09:03:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15471' , '7' , '1' ) 05/03/2024 09:03:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90612' , '21173' , 'CARLO ACUTIS E IL SUO AMICO GESU - C. GALATOLO' , '3' , '3' , '4' , '12.00' , '12' , '0' , '30' , '25.2000' ) 05/03/2024 09:03:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '21173' AND id_supplier = '7' 05/03/2024 09:03:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21173' , '7' , '1' ) 05/03/2024 09:03:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90612' , '11305' , 'VIA CRUCIS DIALOGATA' , '36' , '36' , '4' , '1.00' , '1' , '0' , '35' , '23.4000' ) 05/03/2024 09:03:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '11305' AND id_supplier = '7' 05/03/2024 09:03:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11305' , '7' , '1' ) 05/03/2024 09:03:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90612' , '11305' , 'VIA CRUCIS DIALOGATA' , '3' , '3' , '4' , '1.00' , '1' , '0' , '100' , '0.0000' ) 05/03/2024 09:03:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '11305' AND id_supplier = '7' 05/03/2024 09:03:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11305' , '7' , '1' ) 05/03/2024 09:03:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90612' , '19158' , 'SETTIMANA SANTA - N.E.' , '12' , '12' , '4' , '5.00' , '5' , '0' , '33' , '40.2000' ) 05/03/2024 09:03:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '19158' AND id_supplier = '7' 05/03/2024 09:03:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19158' , '7' , '1' ) 05/03/2024 09:03:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90612' , '19158' , 'SETTIMANA SANTA - N.E.' , '1' , '1' , '4' , '5.00' , '5' , '0' , '100' , '0.0000' ) 05/03/2024 09:03:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '19158' AND id_supplier = '7' 05/03/2024 09:03:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19158' , '7' , '1' ) 05/03/2024 09:05:30 am >> SELECT document_num FROM ps_document WHERE document_num = '625' AND id_document != '90592' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-02') 05/03/2024 09:05:30 am >> UPDATE ps_document SET id_document_type = '11', document_num = '625', document_date = '2024-03-02', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '42.80', price_tax_excluded = '41.76', date_upd = NOW() WHERE id_document = '90592' 05/03/2024 09:05:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90592' 05/03/2024 09:05:30 am >> DELETE FROM ps_document_detail WHERE id_document = '90592' 05/03/2024 09:05:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90592' , '22129' , 'PADRE NOSTRO - L. EPICOCO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 05/03/2024 09:05:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90592' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 05/03/2024 09:05:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90592' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 05/03/2024 09:05:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90592' , '22238' , 'LE MIE PREGHIERE' , '1' , '-1' , '4' , '2.5' , '2.5' , '0' , '0' , '2.50' ) 05/03/2024 09:53:41 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8018859050239' AND id_product != '22239' AND ean13 != '' 05/03/2024 09:53:41 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8018859050239', date_upd = NOW() WHERE id_product = '22239' 05/03/2024 09:53:41 am >> UPDATE ps_product_lang SET name = 'PERGAMENA PADRE NOSTRO', description = '' WHERE id_product = '22239' 05/03/2024 09:53:41 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.5737704918032787' WHERE id_product = '22239' 05/03/2024 09:53:41 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.5737704918032787', id_tax_rules_group = '1', id_category_default = '26', 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 = '22239' 05/03/2024 09:53:41 am >> DELETE FROM ps_specific_price WHERE id_product = '22239' 05/03/2024 09:54:08 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8018859050239' AND id_product != '22239' AND ean13 != '' 05/03/2024 09:54:08 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8018859050239', date_upd = NOW() WHERE id_product = '22239' 05/03/2024 09:54:08 am >> UPDATE ps_product_lang SET name = 'PERGAMENA PADRE NOSTRO', description = '' WHERE id_product = '22239' 05/03/2024 09:54:08 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.5737704918032787' WHERE id_product = '22239' 05/03/2024 09:54:08 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.5737704918032787', id_tax_rules_group = '1', id_category_default = '26', 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 = '22239' 05/03/2024 09:54:08 am >> DELETE FROM ps_specific_price WHERE id_product = '22239' 05/03/2024 09:54:09 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22239' 05/03/2024 09:54:09 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22240' , '1' , '' , 'nuovo-prodotto' ) 05/03/2024 09:54:09 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22240' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22239' 05/03/2024 09:54:09 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22240' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22239' 05/03/2024 09:55:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002236' AND id_product != '22240' AND ean13 != '' 05/03/2024 09:55:23 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002236', date_upd = NOW() WHERE id_product = '22240' 05/03/2024 09:55:23 am >> UPDATE ps_product_lang SET name = 'PERGAMENE CRESIMA', description = '' WHERE id_product = '22240' 05/03/2024 09:55:23 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.5737704918032787' WHERE id_product = '22240' 05/03/2024 09:55:23 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.5737704918032787', id_tax_rules_group = '1', id_category_default = '92', 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 = '22240' 05/03/2024 09:55:23 am >> DELETE FROM ps_specific_price WHERE id_product = '22240' 05/03/2024 09:55:23 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22240' 05/03/2024 09:55:23 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22241' , '1' , '' , 'nuovo-prodotto' ) 05/03/2024 09:55:23 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22241' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22240' 05/03/2024 09:55:23 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22241' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22240' 05/03/2024 09:56:51 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8018859037582' AND id_product != '13712' AND ean13 != '' 05/03/2024 09:56:51 am >> UPDATE ps_product SET id_supplier = '23', reference = '', ean13 = '8018859037582', date_upd = NOW() WHERE id_product = '13712' 05/03/2024 09:56:51 am >> UPDATE ps_product_lang SET name = 'SERIE VIA CRUCIS - 22X30 ', description = '' WHERE id_product = '13712' 05/03/2024 09:56:52 am >> UPDATE ps_product SET wholesale_price = '4.05', on_sale = '0', price = '12.295081967213115' WHERE id_product = '13712' 05/03/2024 09:56:52 am >> UPDATE ps_product_shop SET wholesale_price = '4.05', price = '12.295081967213115', id_tax_rules_group = '1', id_category_default = '92', 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 = '13712' 05/03/2024 09:56:52 am >> DELETE FROM ps_specific_price WHERE id_product = '13712' 05/03/2024 09:58:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8018859047604' AND id_product != '20757' AND ean13 != '' 05/03/2024 09:58:05 am >> UPDATE ps_product SET id_supplier = '23', reference = '', ean13 = '8018859047604', date_upd = NOW() WHERE id_product = '20757' 05/03/2024 09:58:05 am >> UPDATE ps_product_lang SET name = 'VIA CRUCIS - IMMAGINI 35X50', description = '' WHERE id_product = '20757' 05/03/2024 09:58:05 am >> UPDATE ps_product SET wholesale_price = '11.70', on_sale = '0', price = '24.59016393442623' WHERE id_product = '20757' 05/03/2024 09:58:05 am >> UPDATE ps_product_shop SET wholesale_price = '11.70', price = '24.59016393442623', id_tax_rules_group = '1', id_category_default = '92', 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 = '20757' 05/03/2024 09:58:05 am >> DELETE FROM ps_specific_price WHERE id_product = '20757' 05/03/2024 10:00:41 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8018859050239' AND id_product != '22239' AND ean13 != '' 05/03/2024 10:00:41 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8018859050239', date_upd = NOW() WHERE id_product = '22239' 05/03/2024 10:00:41 am >> UPDATE ps_product_lang SET name = 'PERGAMENA PADRE NOSTRO', description = '' WHERE id_product = '22239' 05/03/2024 10:00:41 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.5738' WHERE id_product = '22239' 05/03/2024 10:00:41 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.5738', id_tax_rules_group = '1', id_category_default = '92', 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 = '22239' 05/03/2024 10:00:41 am >> DELETE FROM ps_specific_price WHERE id_product = '22239' 05/03/2024 10:01:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001990' AND id_product != '19560' AND ean13 != '' 05/03/2024 10:01:11 am >> UPDATE ps_product SET id_supplier = '23', reference = '', ean13 = '001990', date_upd = NOW() WHERE id_product = '19560' 05/03/2024 10:01:11 am >> UPDATE ps_product_lang SET name = 'PERGAMENA COMUNIONE 17X25', description = '' WHERE id_product = '19560' 05/03/2024 10:01:11 am >> UPDATE ps_product SET wholesale_price = '0.30', on_sale = '0', price = '0.5738' WHERE id_product = '19560' 05/03/2024 10:01:11 am >> UPDATE ps_product_shop SET wholesale_price = '0.30', price = '0.5738', id_tax_rules_group = '1', id_category_default = '92', 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 = '19560' 05/03/2024 10:01:11 am >> DELETE FROM ps_specific_price WHERE id_product = '19560' 05/03/2024 10:13:26 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '244/2024' , '2024-03-01' , '2024' , '0' , '23' , '2618' , 'V.LE ISONZO, 52 20135 MILANO' , '' , '' , '26.01' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '936.91' , '767.96' , NOW() , NOW() ) 05/03/2024 10:13:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90613' 05/03/2024 10:13:26 am >> DELETE FROM ps_document_detail WHERE id_document = '90613' 05/03/2024 10:13:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90613' , '13712' , 'SERIE VIA CRUCIS - 22X30 ' , '2' , '2' , '1' , '8' , '6.5573770491803' , '22' , '30+10' , '12.2976' ) 05/03/2024 10:13:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '13712' AND id_supplier = '23' 05/03/2024 10:13:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13712' , '23' , '1' ) 05/03/2024 10:13:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90613' , '20757' , 'VIA CRUCIS - IMMAGINI 35X50' , '2' , '2' , '1' , '15.6' , '12.786885245902' , '22' , '30+10' , '23.9803' ) 05/03/2024 10:13:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '20757' AND id_supplier = '23' 05/03/2024 10:13:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20757' , '23' , '1' ) 05/03/2024 10:13:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90613' , '22240' , 'PERGAMENE CRESIMA' , '300' , '300' , '1' , '0.4' , '0.32786885245902' , '22' , '30+10' , '92.2320' ) 05/03/2024 10:13:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '22240' AND id_supplier = '23' 05/03/2024 10:13:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22240' , '23' , '1' ) 05/03/2024 10:13:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90613' , '22239' , 'PERGAMENA PADRE NOSTRO' , '100' , '100' , '1' , '0.40' , '0.32786885245902' , '22' , '30+10' , '30.7440' ) 05/03/2024 10:13:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '22239' AND id_supplier = '23' 05/03/2024 10:13:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22239' , '23' , '1' ) 05/03/2024 10:13:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90613' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '700' , '700' , '1' , '0.4' , '0.32786885245902' , '22' , '30+10' , '215.2080' ) 05/03/2024 10:13:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '19560' AND id_supplier = '23' 05/03/2024 10:13:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19560' , '23' , '1' ) 05/03/2024 10:13:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90613' , '20758' , 'SEGNALIBRO 5X15' , '700' , '700' , '1' , '0.09' , '0.073770491803279' , '22' , '30+10' , '48.4218' ) 05/03/2024 10:13:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '20758' AND id_supplier = '23' 05/03/2024 10:13:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20758' , '23' , '1' ) 05/03/2024 10:13:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90613' , '4374' , 'GESÙ BAMBINO - 273' , '100' , '100' , '1' , '0.065' , '0.05327868852459' , '22' , '30+10' , '4.9959' ) 05/03/2024 10:13:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '4374' AND id_supplier = '23' 05/03/2024 10:13:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4374' , '23' , '1' ) 05/03/2024 10:13:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90613' , '17617' , 'IMMAGINI ISONZO X 100' , '270' , '270' , '1' , '2.3' , '1.8852459016393' , '22' , '30+10' , '477.3006' ) 05/03/2024 10:13:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '17617' AND id_supplier = '23' 05/03/2024 10:13:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17617' , '23' , '1' ) 05/03/2024 11:15:37 am >> SELECT document_num FROM ps_document WHERE document_num = '4/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-05') 05/03/2024 11:15:37 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '22' , '4/S' , '2024-03-05' , 'S' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'VENDUTO FEBBRAIO 2024' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '776.20' , '776.02' , NOW() , NOW() ) 05/03/2024 11:15:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14198' 05/03/2024 11:15:37 am >> DELETE FROM ps_document_detail WHERE id_document = '14198' 05/03/2024 11:15:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14198' , '17' , 'LA FEDE NELLO ZAINETTO' , '1' , '0' , '4' , '6.00' , '6' , '0' , '50' , '3.00' ) 05/03/2024 11:15:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14198' , '20' , 'GIOVEDÌ SANTO' , '38' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '28.50' ) 05/03/2024 11:15:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14198' , '134' , 'AVE MARIA SPIEGATA AI BAMBINI - N.E.' , '6' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '5.40' ) 05/03/2024 11:15:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14198' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '41' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '30.75' ) 05/03/2024 11:15:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14198' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '65' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '81.25' ) 05/03/2024 11:15:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14198' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '50' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '62.50' ) 05/03/2024 11:15:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14198' , '121' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 05/03/2024 11:15:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14198' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '40' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '50.00' ) 05/03/2024 11:15:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14198' , '125' , 'MIE PREGHIERINE - N. E.' , '25' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '18.75' ) 05/03/2024 11:15:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14198' , '30' , 'LA BIBBIA: ANTICO TESTAMENTO' , '1' , '0' , '4' , '9.00' , '9' , '0' , '50' , '4.50' ) 05/03/2024 11:15:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14198' , '34' , 'LE MIE PREGHIERINE' , '5' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '3.75' ) 05/03/2024 11:15:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14198' , '44' , 'GUARDALIBRI: DVD IL CREDO' , '1' , '0' , '4' , '9.90' , '9.9' , '0' , '50' , '4.95' ) 05/03/2024 11:15:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14198' , '50' , 'PERDONAMI SIGNORE' , '22' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '27.50' ) 05/03/2024 11:15:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14198' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '3' , '0' , '4' , '2.00' , '2' , '0' , '50' , '3.00' ) 05/03/2024 11:15:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14198' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '24' , '0' , '4' , '2.00' , '2' , '0' , '50' , '24.00' ) 05/03/2024 11:15:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14198' , '75' , 'IL SEGNO DELLA CROCE' , '10' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '7.50' ) 05/03/2024 11:15:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14198' , '86' , 'Il figliol prodigo' , '1' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 05/03/2024 11:15:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14198' , '92' , 'LA PREGHIERA DEL ROSARIO' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 05/03/2024 11:15:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14198' , '101' , 'GESU BENEDICI LA NOSTRA FAMIGLIA' , '1' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 05/03/2024 11:15:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14198' , '104' , 'TEMPO DI QUARESIMA' , '10' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '12.50' ) 05/03/2024 11:15:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14198' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '7' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '8.75' ) 05/03/2024 11:15:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14198' , '110' , 'SE MI AMI NON PIANGERE' , '16' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '14.40' ) 05/03/2024 11:15:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14198' , '123' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '1' , '0' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 05/03/2024 11:15:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14198' , '115' , 'SAN FRANCESCO DASSISI RACCONTATO AI RAGAZZI N.E.' , '24' , '0' , '4' , '4.00' , '4' , '0' , '50' , '48.00' ) 05/03/2024 11:15:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14198' , '117' , 'La preghiera delle cinque dita n.e.' , '10' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '9.00' ) 05/03/2024 11:15:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14198' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '41' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '51.25' ) 05/03/2024 11:15:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14198' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '46' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '57.50' ) 05/03/2024 11:15:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14198' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '21' , '0' , '4' , '18.00' , '18' , '0' , '50' , '189.00' ) 05/03/2024 11:15:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14198' , '138' , 'LA NASCITA DI GESU' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 05/03/2024 11:15:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14198' , '139' , 'E NATO - n.e.' , '1' , '0' , '1' , '2.00' , '1.6393442622951' , '22' , '50' , '1.00' ) 05/03/2024 11:15:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14198' , '136' , 'ANGELO DI DIO N.E.' , '3' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '2.70' ) 05/03/2024 11:15:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14198' , '126' , 'SACRAMENTO DEL PERDONO' , '20' , '0' , '4' , '2.00' , '2' , '0' , '50' , '20.00' ) 05/03/2024 11:27:59 am >> SELECT document_num FROM ps_document WHERE document_num = '639' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-05') 05/03/2024 11:27:59 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' , '639' , '2024-03-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.50' , '23.33' , NOW() , NOW() ) 05/03/2024 11:27:59 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 = '90614' 05/03/2024 11:27:59 am >> DELETE FROM ps_document_detail WHERE id_document = '90614' 05/03/2024 11:27:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90614' , '9178' , 'ROSARIO ROSETTA LOURDES MM 04 - RL861' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 05/03/2024 11:27:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90614' , '9714' , 'SCATOLA OTTOGONALE - 7328' , '1' , '-1' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '0.50' ) 05/03/2024 11:27:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90614' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '18' , '18' , '0' , '0' , '18.00' ) 05/03/2024 11:33:47 am >> SELECT document_num FROM ps_document WHERE document_num = '5/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-05') 05/03/2024 11:33:47 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '25' , '5/S' , '2024-03-05' , 'S' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RESA FEBBRAIO 2024' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '525.75' , '516.55' , NOW() , NOW() ) 05/03/2024 11:33:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14199' 05/03/2024 11:33:47 am >> DELETE FROM ps_document_detail WHERE id_document = '14199' 05/03/2024 11:33:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14199' , '17' , 'LA FEDE NELLO ZAINETTO' , '28' , '28' , '4' , '6.00' , '6' , '0' , '50' , '84.00' ) 05/03/2024 11:33:48 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 ( '14199' , '20' , 'GIOVEDÌ SANTO' , '1' , '1' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 05/03/2024 11:33:48 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 ( '14199' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '1' , '1' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 05/03/2024 11:33:48 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 ( '14199' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '3' , '3' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 05/03/2024 11:33:48 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 ( '14199' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '15' , '15' , '4' , '2.50' , '2.5' , '0' , '50' , '18.75' ) 05/03/2024 11:33:48 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 ( '14199' , '25' , 'PICCOLO DIZIONARIO DEL CRISTIANO' , '6' , '6' , '4' , '3.00' , '3' , '0' , '50' , '9.00' ) 05/03/2024 11:33:48 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 ( '14199' , '121' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '3' , '3' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 05/03/2024 11:33:48 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 ( '14199' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '4' , '4' , '4' , '2.50' , '2.5' , '0' , '50' , '5.00' ) 05/03/2024 11:33:48 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 ( '14199' , '125' , 'MIE PREGHIERINE - N. E.' , '1' , '1' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 05/03/2024 11:33:48 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 ( '14199' , '34' , 'LE MIE PREGHIERINE' , '6' , '6' , '4' , '1.50' , '1.5' , '0' , '50' , '4.50' ) 05/03/2024 11:33:48 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 ( '14199' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '1' , '1' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 05/03/2024 11:33:48 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 ( '14199' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '1' , '1' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 05/03/2024 11:33:48 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 ( '14199' , '72' , 'FEDE, SPERANZA E CARITA' , '2' , '2' , '4' , '6.00' , '6' , '0' , '50' , '6.00' ) 05/03/2024 11:33:48 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 ( '14199' , '80' , 'MISERICORDIA' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 05/03/2024 11:33:48 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 ( '14199' , '101' , 'GESU BENEDICI LA NOSTRA FAMIGLIA' , '4' , '4' , '4' , '1.50' , '1.5' , '0' , '50' , '3.00' ) 05/03/2024 11:33:48 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 ( '14199' , '110' , 'SE MI AMI NON PIANGERE' , '34' , '34' , '4' , '1.80' , '1.8' , '0' , '50' , '30.60' ) 05/03/2024 11:33:48 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 ( '14199' , '111' , 'I NONNI SONO UN TESORO' , '10' , '10' , '4' , '1.80' , '1.8' , '0' , '50' , '9.00' ) 05/03/2024 11:33:48 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 ( '14199' , '112' , 'SEMPRE CON TE -VANGELO TASCABILE' , '6' , '6' , '4' , '2.50' , '2.5' , '0' , '50' , '7.50' ) 05/03/2024 11:33:48 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 ( '14199' , '123' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '3' , '3' , '4' , '3.00' , '3' , '0' , '50' , '4.50' ) 05/03/2024 11:33:48 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 ( '14199' , '114' , 'Le preghiere dei ragazzi' , '3' , '3' , '4' , '1.50' , '1.5' , '0' , '50' , '2.25' ) 05/03/2024 11:33:48 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 ( '14199' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 05/03/2024 11:33:48 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 ( '14199' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '2' , '2' , '4' , '3.00' , '3' , '0' , '50' , '3.00' ) 05/03/2024 11:33:48 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 ( '14199' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '20' , '20' , '4' , '18.00' , '18' , '0' , '50' , '180.00' ) 05/03/2024 11:33:48 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 ( '14199' , '138' , 'LA NASCITA DI GESU' , '46' , '46' , '4' , '2.50' , '2.5' , '0' , '50' , '57.50' ) 05/03/2024 11:33:48 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 ( '14199' , '139' , 'E NATO - n.e.' , '51' , '51' , '1' , '2.00' , '1.6393442622951' , '22' , '50' , '51.00' ) 05/03/2024 11:33:48 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 ( '14199' , '136' , 'ANGELO DI DIO N.E.' , '1' , '1' , '4' , '1.80' , '1.8' , '0' , '50' , '0.90' ) 05/03/2024 11:33:48 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 ( '14199' , '137' , 'AVVENTO' , '28' , '28' , '4' , '2.50' , '2.5' , '0' , '50' , '35.00' ) 05/03/2024 11:51:52 am >> SELECT document_num FROM ps_document WHERE document_num = '10/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-05') 05/03/2024 11:51:52 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '22' , '10/E' , '2024-03-05' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'VENDUTO FEBBRAIO 2024' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '5193.22' , '5193.22' , NOW() , NOW() ) 05/03/2024 11:51:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90615' 05/03/2024 11:51:52 am >> DELETE FROM ps_document_detail WHERE id_document = '90615' 05/03/2024 11:51:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90615' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '190' , '0' , '4' , '2.40' , '2.4' , '0' , '50' , '228.00' ) 05/03/2024 11:51:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90615' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '20' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '25.00' ) 05/03/2024 11:51:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90615' , '11183' , 'VENITE CON ME - GUIDA' , '2' , '0' , '4' , '8.00' , '8' , '0' , '50' , '8.00' ) 05/03/2024 11:51:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90615' , '4479' , 'GESÙ MIO AMICO - VOL. 1°' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 05/03/2024 11:51:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90615' , '9675' , 'SARETE MIEI TESTIMONI' , '3' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '5.25' ) 05/03/2024 11:51:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90615' , '5457' , 'IO SONO CON VOI 1 PARTE' , '50' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '70.00' ) 05/03/2024 11:51:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90615' , '5458' , 'IO SONO CON VOI 2 PARTE' , '40' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '56.00' ) 05/03/2024 11:51:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90615' , '11191' , 'VENITE CON ME 1 PARTE' , '31' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '43.40' ) 05/03/2024 11:51:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90615' , '11192' , 'VENITE CON ME 2 PARTE' , '85' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '119.00' ) 05/03/2024 11:51:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90615' , '11312' , 'VIA CRUCIS PER RAGAZZI ' , '21' , '0' , '4' , '0.85' , '0.85' , '0' , '50' , '8.92' ) 05/03/2024 11:51:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90615' , '523' , 'AMORE VINCE LA MORTE - VIA CRUCIS' , '4' , '0' , '4' , '0.85' , '0.85' , '0' , '50' , '1.70' ) 05/03/2024 11:51:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90615' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '22' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '38.50' ) 05/03/2024 11:51:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90615' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '30' , '0' , '4' , '3.40' , '3.4' , '0' , '50' , '51.00' ) 05/03/2024 11:51:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90615' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '6' , '0' , '4' , '5.00' , '5' , '0' , '50' , '15.00' ) 05/03/2024 11:51:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90615' , '1873' , 'CELEBRARE LA PAROLA - ANNO B' , '1' , '0' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 05/03/2024 11:51:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90615' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '20' , '0' , '4' , '3.40' , '3.4' , '0' , '50' , '34.00' ) 05/03/2024 11:51:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90615' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '6' , '0' , '4' , '5.00' , '5' , '0' , '50' , '15.00' ) 05/03/2024 11:51:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90615' , '11308' , 'VIA CRUCIS ' , '2' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '1.50' ) 05/03/2024 11:51:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90615' , '6629' , 'MIA PREGHIERA' , '60' , '0' , '4' , '0.90' , '0.9' , '0' , '50' , '27.00' ) 05/03/2024 11:51:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90615' , '8408' , 'PRENDETE E MANGIATE' , '106' , '0' , '4' , '3.00' , '3' , '0' , '50' , '159.00' ) 05/03/2024 11:51:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90615' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '3' , '0' , '4' , '5.00' , '5' , '0' , '50' , '7.50' ) 05/03/2024 11:51:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90615' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '0' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 05/03/2024 11:51:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90615' , '4154' , 'FESTA DEL PERDONO' , '62' , '0' , '4' , '3.00' , '3' , '0' , '50' , '93.00' ) 05/03/2024 11:51:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90615' , '7824' , 'PER ILLUMINARE IL CAMMINO' , '1' , '0' , '4' , '0.90' , '0.9' , '0' , '50' , '0.45' ) 05/03/2024 11:51:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90615' , '2679' , 'CONOSCERE GESU' , '26' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '45.50' ) 05/03/2024 11:51:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90615' , '2680' , 'CONOSCERE GESU - GUIDA' , '2' , '0' , '4' , '6.00' , '6' , '0' , '50' , '6.00' ) 05/03/2024 11:51:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90615' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '7' , '0' , '4' , '5.00' , '5' , '0' , '50' , '17.50' ) 05/03/2024 11:51:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90615' , '11102' , 'VANGELO E ATTI DEGLI APOSTOLI - RIL.' , '3' , '0' , '4' , '8.50' , '8.5' , '0' , '50' , '12.75' ) 05/03/2024 11:51:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90615' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '6' , '0' , '4' , '5.00' , '5' , '0' , '50' , '15.00' ) 05/03/2024 11:51:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90615' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '11' , '0' , '4' , '1.60' , '1.6' , '0' , '50' , '8.80' ) 05/03/2024 11:51:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90615' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '1' , '0' , '4' , '25.00' , '25' , '0' , '50' , '12.50' ) 05/03/2024 11:51: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 ( '90615' , '12253' , 'MIO LIBRO DI PREGHIERE' , '8' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '11.20' ) 05/03/2024 11:51: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 ( '90615' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 05/03/2024 11:51: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 ( '90615' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '2' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '3.50' ) 05/03/2024 11:51: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 ( '90615' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '2' , '0' , '4' , '6.00' , '6' , '0' , '50' , '6.00' ) 05/03/2024 11:51: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 ( '90615' , '15115' , 'CONVERSIONE - G. CELENTANO' , '1' , '0' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 05/03/2024 11:51: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 ( '90615' , '13397' , 'MIO GESU' , '4' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '7.00' ) 05/03/2024 11:51: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 ( '90615' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '215' , '0' , '4' , '1.00' , '1' , '0' , '50' , '107.50' ) 05/03/2024 11:51: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 ( '90615' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '0' , '4' , '1.00' , '1' , '0' , '50' , '0.50' ) 05/03/2024 11:51: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 ( '90615' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '4' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '7.00' ) 05/03/2024 11:51: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 ( '90615' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1893' , '0' , '4' , '1.00' , '1' , '0' , '50' , '946.50' ) 05/03/2024 11:51: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 ( '90615' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '35' , '0' , '4' , '2.00' , '2' , '0' , '50' , '35.00' ) 05/03/2024 11:51: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 ( '90615' , '16667' , 'VIA CRUCIS' , '163' , '0' , '4' , '3.00' , '3' , '0' , '50' , '244.50' ) 05/03/2024 11:51: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 ( '90615' , '16997' , 'PREGHIAMO IL PADRONE DELLA MESSE ' , '3' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 05/03/2024 11:51: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 ( '90615' , '17257' , 'IO TI BATTEZZO ' , '103' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '92.70' ) 05/03/2024 11:51: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 ( '90615' , '17695' , 'VIA LUCIS CON SAN CESARE DE BUS' , '5' , '0' , '4' , '3.80' , '3.8' , '0' , '50' , '9.50' ) 05/03/2024 11:51: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 ( '90615' , '18175' , 'VIA DI SAN GIUSEPPE - G. POLIDORO' , '2' , '0' , '4' , '4.80' , '4.8' , '0' , '50' , '4.80' ) 05/03/2024 11:51: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 ( '90615' , '17696' , 'VIA CRUCIS CON SAN CESARE DE BUS' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 05/03/2024 11:51: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 ( '90615' , '17861' , 'CARTA DIDENTITA DELLA CHIESA - R. LUPI' , '15' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '18.75' ) 05/03/2024 11:51: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 ( '90615' , '18528' , 'CON GESU VERSO IL CALVARIO - G. VALSECCHI' , '210' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '157.50' ) 05/03/2024 11:51: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 ( '90615' , '18657' , 'HO DATO LORO LA TUA PAROLA - TEMPI FORTI- G. VALSECCHI' , '2' , '0' , '4' , '16.00' , '16' , '0' , '50' , '16.00' ) 05/03/2024 11:51: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 ( '90615' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '7' , '0' , '4' , '7.00' , '7' , '0' , '50' , '24.50' ) 05/03/2024 11:51: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 ( '90615' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '1' , '0' , '4' , '9.00' , '9' , '0' , '50' , '4.50' ) 05/03/2024 11:51: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 ( '90615' , '19391' , 'ISTRUZIONI FAMILIARI VOL. III - I PRECETTI...' , '1' , '0' , '4' , '20.00' , '20' , '0' , '50' , '10.00' ) 05/03/2024 11:51: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 ( '90615' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '1' , '0' , '4' , '12.00' , '12' , '0' , '50' , '6.00' ) 05/03/2024 11:51: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 ( '90615' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '2' , '0' , '4' , '35.00' , '35' , '0' , '50' , '35.00' ) 05/03/2024 11:51: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 ( '90615' , '20640' , 'GESU, MOSSO A COMPASSIONE V. SALVOLDI' , '39' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '48.75' ) 05/03/2024 11:51: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 ( '90615' , '20719' , 'CORONA DELL’ADDOLORATA' , '2' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '1.80' ) 05/03/2024 11:51: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 ( '90615' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '121' , '0' , '4' , '2.00' , '2' , '0' , '50' , '121.00' ) 05/03/2024 11:51: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 ( '90615' , '20721' , 'AVE MARIA - L. CALABRETTA' , '1' , '0' , '4' , '4.50' , '4.5' , '0' , '50' , '2.25' ) 05/03/2024 11:51: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 ( '90615' , '20720' , 'PADRE NOSTRO - L. CALABRETTA' , '5' , '0' , '4' , '4.50' , '4.5' , '0' , '50' , '11.25' ) 05/03/2024 11:51: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 ( '90615' , '20722' , 'SEMINATORI DI GIOIA' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 05/03/2024 11:51: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 ( '90615' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '9' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '11.25' ) 05/03/2024 11:51: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 ( '90615' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '1' , '0' , '4' , '20.00' , '20' , '0' , '50' , '10.00' ) 05/03/2024 11:51: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 ( '90615' , '21417' , 'VIENI, NON TARDARE SIGNORE, NOSTRA PACE!' , '2' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 05/03/2024 11:51: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 ( '90615' , '21799' , 'ISTRUZIONI FAMILIARI VOL. IV - I VIZI E I SCARAMENTI' , '2' , '0' , '4' , '25.00' , '25' , '0' , '50' , '25.00' ) 05/03/2024 11:51: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 ( '90615' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '276' , '0' , '4' , '3.00' , '3' , '0' , '50' , '414.00' ) 05/03/2024 11:51: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 ( '90615' , '22031' , 'GLI ULTIMI SARANNO PRIMI - R. LUPI' , '370' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '462.50' ) 05/03/2024 11:51: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 ( '90615' , '22029' , 'PREPARIAMOCI ALLA PRIMA CONFESSIONE - POSTER' , '106' , '0' , '4' , '2.00' , '2' , '0' , '50' , '106.00' ) 05/03/2024 11:51:54 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 ( '90615' , '22030' , 'PREPARIAMOCI ALLA PRIMA COMUNIONE - POSTER' , '83' , '0' , '4' , '2.00' , '2' , '0' , '50' , '83.00' ) 05/03/2024 11:51:54 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 ( '90615' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '64' , '0' , '4' , '8.00' , '8' , '0' , '50' , '256.00' ) 05/03/2024 11:51:54 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 ( '90615' , '22032' , 'ECCO ORA IL MOMENTO FAVOREVOLE - PADRE G. VALSECCHI' , '45' , '0' , '4' , '10.00' , '10' , '0' , '50' , '225.00' ) 05/03/2024 11:51:54 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 ( '90615' , '21418' , 'CRISTO NOSTRA PACE - V. SALVORDI' , '2' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 05/03/2024 11:51:54 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 ( '90615' , '22034' , 'MISTERI DEL ROSARIO - M. DE ROSA' , '12' , '0' , '4' , '8.00' , '8' , '0' , '50' , '48.00' ) 05/03/2024 11:51:54 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 ( '90615' , '20954' , 'TEMPO DELL’APOCALISSE ' , '2' , '0' , '4' , '15.00' , '15' , '0' , '50' , '15.00' ) 05/03/2024 11:51:54 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 ( '90615' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '71' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '99.40' ) 05/03/2024 11:51:54 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 ( '90615' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '122' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '170.80' ) 05/03/2024 11:51:54 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 ( '90615' , '20951' , 'STORIE DEL NOSTRO TEMPO - F. CERRI' , '1' , '0' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 05/03/2024 11:51:54 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 ( '90615' , '22053' , 'AMO IL SIGNORE, PERCHÉ ASCOLTA IL GRIDO DELLA MIA PREGHIERA' , '138' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '172.50' ) 05/03/2024 11:58:54 am >> SELECT document_num FROM ps_document WHERE document_num = '11/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-05') 05/03/2024 11:58:54 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 ( '25' , '11/E' , '2024-03-05' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '654.00' , '654.00' , NOW() , NOW() ) 05/03/2024 11:58:54 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 = '90616' 05/03/2024 11:58:54 am >> DELETE FROM ps_document_detail WHERE id_document = '90616' 05/03/2024 11:58:54 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 ( '90616' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '89' , '89' , '4' , '2.40' , '2.4' , '0' , '50' , '106.80' ) 05/03/2024 11:58:54 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 ( '90616' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '11' , '11' , '4' , '2.50' , '2.5' , '0' , '50' , '13.75' ) 05/03/2024 11:58:54 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 ( '90616' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '6' , '6' , '4' , '6.20' , '6.2' , '0' , '50' , '18.60' ) 05/03/2024 11:58:54 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 ( '90616' , '2448' , 'COLUI IN CUI CREDO' , '2' , '2' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 05/03/2024 11:58:54 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 ( '90616' , '9675' , 'SARETE MIEI TESTIMONI' , '8' , '8' , '4' , '3.50' , '3.5' , '0' , '50' , '14.00' ) 05/03/2024 11:58:54 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 ( '90616' , '5457' , 'IO SONO CON VOI 1 PARTE' , '71' , '71' , '4' , '2.80' , '2.8' , '0' , '50' , '99.40' ) 05/03/2024 11:58:54 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 ( '90616' , '5458' , 'IO SONO CON VOI 2 PARTE' , '137' , '137' , '4' , '2.80' , '2.8' , '0' , '50' , '191.80' ) 05/03/2024 11:58:54 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 ( '90616' , '11191' , 'VENITE CON ME 1 PARTE' , '72' , '72' , '4' , '2.80' , '2.8' , '0' , '50' , '100.80' ) 05/03/2024 11:58:54 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 ( '90616' , '11192' , 'VENITE CON ME 2 PARTE' , '60' , '60' , '4' , '2.80' , '2.8' , '0' , '50' , '84.00' ) 05/03/2024 11:58:54 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 ( '90616' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '5' , '5' , '4' , '3.40' , '3.4' , '0' , '50' , '8.50' ) 05/03/2024 11:58:54 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 ( '90616' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' , '1' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 05/03/2024 11:58:54 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 ( '90616' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '3' , '3' , '4' , '3.40' , '3.4' , '0' , '50' , '5.10' ) 05/03/2024 11:58:54 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 ( '90616' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '1' , '1' , '4' , '8.00' , '8' , '0' , '50' , '4.00' ) 05/03/2024 11:58:54 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 ( '90616' , '6629' , 'MIA PREGHIERA' , '5' , '5' , '4' , '0.90' , '0.9' , '0' , '50' , '2.25' ) 05/03/2024 11:59:37 am >> SELECT document_num FROM ps_document WHERE document_num = '640' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-05') 05/03/2024 11:59:37 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '640' , '2024-03-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.00' , '40.16' , NOW() , NOW() ) 05/03/2024 11:59:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90617' 05/03/2024 11:59:37 am >> DELETE FROM ps_document_detail WHERE id_document = '90617' 05/03/2024 11:59:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90617' , '22045' , 'CLERGY REGULAR ML - C 24' , '1' , '-1' , '1' , '49' , '40.16393442623' , '22' , '0' , '49.00' ) 05/03/2024 12:00:19 pm >> DELETE FROM ps_document WHERE id_document = '90478' 05/03/2024 12:00:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '90478' 05/03/2024 12:04:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '641' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-05') 05/03/2024 12:04:53 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '641' , '2024-03-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.20' , '1.80' , NOW() , NOW() ) 05/03/2024 12:04:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90618' 05/03/2024 12:04:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '90618' 05/03/2024 12:04:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90618' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '2.20' ) 05/03/2024 12:05:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '31/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-05') 05/03/2024 12:05:48 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '31/A' , '2024-03-05' , 'A' , '3536' , '0' , '4673201' , 'VIA SANT\\\'ANNA 4 84062 OLEVANO SUL TUSCIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '230.00' , '230.00' , NOW() , NOW() ) 05/03/2024 12:05:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90619' 05/03/2024 12:05:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '90619' 05/03/2024 12:05:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90619' , '' , 'CROCE' , '1' , '-1' , '0' , '230' , '230' , '' , '0' , '230.00' ) 05/03/2024 12:08:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '642' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-05') 05/03/2024 12:08:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '642' , '2024-03-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '41.00' , '33.61' , NOW() , NOW() ) 05/03/2024 12:08:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90620' 05/03/2024 12:08:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '90620' 05/03/2024 12:08:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90620' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 05/03/2024 12:08:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90620' , '22011' , 'CROCE SAN DAMIANO MOGANO 26X19 - PG552' , '1' , '-1' , '1' , '19.00' , '15.573770491803' , '22' , '0' , '19.00' ) 05/03/2024 12:08:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90620' , '19749' , 'INCENSO MATTHAEUS ' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 05/03/2024 12:25:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '11/E' AND id_document != '90616' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-05') 05/03/2024 12:25:06 pm >> UPDATE ps_document SET id_document_type = '25', document_num = '11/E', document_date = '2024-03-05', document_letter = 'E', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'RESA FEBBRAIO 2024', 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 = '1782.15', price_tax_excluded = '1780.98', date_upd = NOW() WHERE id_document = '90616' 05/03/2024 12:25:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90616' 05/03/2024 12:25:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '90616' 05/03/2024 12:25: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 ( '90616' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '89' , '89' , '4' , '2.4000' , '2.4' , '0' , '50' , '106.80' ) 05/03/2024 12:25: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 ( '90616' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '11' , '11' , '4' , '2.5000' , '2.5' , '0' , '50' , '13.75' ) 05/03/2024 12:25: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 ( '90616' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '6' , '6' , '4' , '6.2000' , '6.2' , '0' , '50' , '18.60' ) 05/03/2024 12:25: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 ( '90616' , '2448' , 'COLUI IN CUI CREDO' , '2' , '2' , '4' , '2.5000' , '2.5' , '0' , '50' , '2.50' ) 05/03/2024 12:25: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 ( '90616' , '9675' , 'SARETE MIEI TESTIMONI' , '8' , '8' , '4' , '3.5000' , '3.5' , '0' , '50' , '14.00' ) 05/03/2024 12:25: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 ( '90616' , '5457' , 'IO SONO CON VOI 1 PARTE' , '71' , '71' , '4' , '2.8000' , '2.8' , '0' , '50' , '99.40' ) 05/03/2024 12:25: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 ( '90616' , '5458' , 'IO SONO CON VOI 2 PARTE' , '137' , '137' , '4' , '2.8000' , '2.8' , '0' , '50' , '191.80' ) 05/03/2024 12:25: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 ( '90616' , '11191' , 'VENITE CON ME 1 PARTE' , '72' , '72' , '4' , '2.8000' , '2.8' , '0' , '50' , '100.80' ) 05/03/2024 12:25: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 ( '90616' , '11192' , 'VENITE CON ME 2 PARTE' , '60' , '60' , '4' , '2.8000' , '2.8' , '0' , '50' , '84.00' ) 05/03/2024 12:25: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 ( '90616' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '5' , '5' , '4' , '3.4000' , '3.4' , '0' , '50' , '8.50' ) 05/03/2024 12:25: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 ( '90616' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' , '1' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 05/03/2024 12:25: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 ( '90616' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '3' , '3' , '4' , '3.4000' , '3.4' , '0' , '50' , '5.10' ) 05/03/2024 12:25: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 ( '90616' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '1' , '1' , '4' , '8.0000' , '8' , '0' , '50' , '4.00' ) 05/03/2024 12:25: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 ( '90616' , '6629' , 'MIA PREGHIERA' , '5' , '5' , '4' , '0.9000' , '0.9' , '0' , '50' , '2.25' ) 05/03/2024 12:25: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 ( '90616' , '8408' , 'PRENDETE E MANGIATE' , '7' , '7' , '4' , '3.00' , '3' , '0' , '50' , '10.50' ) 05/03/2024 12:25: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 ( '90616' , '4154' , 'FESTA DEL PERDONO' , '1' , '1' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 05/03/2024 12:25: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 ( '90616' , '1883' , 'CELEBRAZIONI PER LANNO PASTORALE' , '1' , '1' , '4' , '11.00' , '11' , '0' , '50' , '5.50' ) 05/03/2024 12:25: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 ( '90616' , '2679' , 'CONOSCERE GESU' , '4' , '4' , '4' , '3.50' , '3.5' , '0' , '50' , '7.00' ) 05/03/2024 12:25: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 ( '90616' , '10364' , 'SULLA STRADA DEL MAESTRO' , '1' , '1' , '4' , '14.00' , '14' , '0' , '50' , '7.00' ) 05/03/2024 12:25: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 ( '90616' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '11' , '11' , '4' , '1.60' , '1.6' , '0' , '50' , '8.80' ) 05/03/2024 12:25: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 ( '90616' , '7543' , 'PARABOLE DI GESÙ' , '2' , '2' , '4' , '3.00' , '3' , '0' , '50' , '3.00' ) 05/03/2024 12:25: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 ( '90616' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '1' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 05/03/2024 12:25: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 ( '90616' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '1' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 05/03/2024 12:25: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 ( '90616' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 05/03/2024 12:25: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 ( '90616' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 05/03/2024 12:25: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 ( '90616' , '12819' , 'REGISTRO DEL CATECHISTA ' , '13' , '13' , '1' , '1.00' , '0.81967213114754' , '22' , '50' , '6.50' ) 05/03/2024 12:25: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 ( '90616' , '12813' , 'MARIA MADRE NOSTRA' , '2' , '2' , '4' , '3.00' , '3' , '0' , '50' , '3.00' ) 05/03/2024 12:25: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 ( '90616' , '15115' , 'CONVERSIONE - G. CELENTANO' , '2' , '2' , '4' , '15.00' , '15' , '0' , '50' , '15.00' ) 05/03/2024 12:25: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 ( '90616' , '13137' , 'CON LA BIBBIA E IL CATECHISMO - S. LA PEGNA' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 05/03/2024 12:25: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 ( '90616' , '13397' , 'MIO GESU' , '3' , '3' , '4' , '3.50' , '3.5' , '0' , '50' , '5.25' ) 05/03/2024 12:25: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 ( '90616' , '13956' , 'MIRACOLI DI GESU' , '2' , '2' , '4' , '3.00' , '3' , '0' , '50' , '3.00' ) 05/03/2024 12:25: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 ( '90616' , '14260' , 'CUORE CHE BATTE - TORNARE AD AMARE IL CREATO' , '2' , '2' , '4' , '8.00' , '8' , '0' , '50' , '8.00' ) 05/03/2024 12:25: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 ( '90616' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '1' , '1' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 05/03/2024 12:25: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 ( '90616' , '16997' , 'PREGHIAMO IL PADRONE DELLA MESSE ' , '5' , '5' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 05/03/2024 12:25: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 ( '90616' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '1' , '1' , '4' , '12.00' , '12' , '0' , '50' , '6.00' ) 05/03/2024 12:25: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 ( '90616' , '18175' , 'VIA DI SAN GIUSEPPE - G. POLIDORO' , '1' , '1' , '4' , '4.80' , '4.8' , '0' , '50' , '2.40' ) 05/03/2024 12:25: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 ( '90616' , '18176' , 'ANTIQUUM MINISTERIUM ' , '41' , '41' , '4' , '1.00' , '1' , '0' , '50' , '20.50' ) 05/03/2024 12:25: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 ( '90616' , '18497' , 'BUONA DOMENICA - ANNO A - G. BAGET BOZZO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '50' , '8.00' ) 05/03/2024 12:25: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 ( '90616' , '18527' , 'SOGNI DI PACE - V. SALVOLDI' , '4' , '4' , '4' , '2.00' , '2' , '0' , '50' , '4.00' ) 05/03/2024 12:25: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 ( '90616' , '18717' , 'ISTRUZIONI FAMILIARI VOL. II - I DIECI COMANDAMENTI ' , '1' , '1' , '4' , '20.00' , '20' , '0' , '50' , '10.00' ) 05/03/2024 12:25: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 ( '90616' , '18718' , 'TUA VOCE IN ME + CD - FRA F. MARIA REA' , '1' , '1' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 05/03/2024 12:25: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 ( '90616' , '18657' , 'HO DATO LORO LA TUA PAROLA - TEMPI FORTI- G. VALSECCHI' , '4' , '4' , '4' , '16.00' , '16' , '0' , '50' , '32.00' ) 05/03/2024 12:25: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 ( '90616' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '4' , '4' , '4' , '7.00' , '7' , '0' , '50' , '14.00' ) 05/03/2024 12:25: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 ( '90616' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '1' , '1' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 05/03/2024 12:25: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 ( '90616' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '3' , '3' , '4' , '9.00' , '9' , '0' , '50' , '13.50' ) 05/03/2024 12:25: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 ( '90616' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '3' , '3' , '4' , '9.00' , '9' , '0' , '50' , '13.50' ) 05/03/2024 12:25: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 ( '90616' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '3' , '3' , '4' , '9.00' , '9' , '0' , '50' , '13.50' ) 05/03/2024 12:25: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 ( '90616' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 05/03/2024 12:25: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 ( '90616' , '19391' , 'ISTRUZIONI FAMILIARI VOL. III - I PRECETTI...' , '1' , '1' , '4' , '20.00' , '20' , '0' , '50' , '10.00' ) 05/03/2024 12:25: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 ( '90616' , '19562' , 'SAN CESARE DE BUS. UNA VITA PER LA CATECHESI ' , '2' , '2' , '4' , '20.00' , '20' , '0' , '50' , '20.00' ) 05/03/2024 12:25: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 ( '90616' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '3' , '3' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 05/03/2024 12:25: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 ( '90616' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '5' , '5' , '4' , '4.50' , '4.5' , '0' , '50' , '11.25' ) 05/03/2024 12:25: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 ( '90616' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '2' , '2' , '4' , '35.00' , '35' , '0' , '50' , '35.00' ) 05/03/2024 12:25: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 ( '90616' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE - SALVOLDI' , '4' , '4' , '4' , '2.50' , '2.5' , '0' , '50' , '5.00' ) 05/03/2024 12:25: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 ( '90616' , '20231' , 'PREGANDO NON SPRECATE PAROLE - G. DAMORE' , '4' , '4' , '4' , '10.00' , '10' , '0' , '50' , '20.00' ) 05/03/2024 12:25: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 ( '90616' , '20640' , 'GESU, MOSSO A COMPASSIONE V. SALVOLDI' , '5' , '5' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 05/03/2024 12:25: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 ( '90616' , '20719' , 'CORONA DELL’ADDOLORATA' , '4' , '4' , '4' , '1.80' , '1.8' , '0' , '50' , '3.60' ) 05/03/2024 12:25: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 ( '90616' , '20721' , 'AVE MARIA - L. CALABRETTA' , '19' , '19' , '4' , '4.50' , '4.5' , '0' , '50' , '42.75' ) 05/03/2024 12:25: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 ( '90616' , '20720' , 'PADRE NOSTRO - L. CALABRETTA' , '8' , '8' , '4' , '4.50' , '4.5' , '0' , '50' , '18.00' ) 05/03/2024 12:25: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 ( '90616' , '20722' , 'SEMINATORI DI GIOIA' , '19' , '19' , '4' , '2.50' , '2.5' , '0' , '50' , '23.75' ) 05/03/2024 12:25: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 ( '90616' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '26' , '26' , '4' , '2.50' , '2.5' , '0' , '50' , '32.50' ) 05/03/2024 12:25: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 ( '90616' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '6' , '6' , '4' , '10.00' , '10' , '0' , '50' , '30.00' ) 05/03/2024 12:25: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 ( '90616' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '9' , '9' , '4' , '20.00' , '20' , '0' , '50' , '90.00' ) 05/03/2024 12:25: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 ( '90616' , '21417' , 'VIENI, NON TARDARE SIGNORE, NOSTRA PACE!' , '87' , '87' , '4' , '2.50' , '2.5' , '0' , '50' , '108.75' ) 05/03/2024 12:25: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 ( '90616' , '21644' , 'INCONTRO AL DIO CHE VIENE' , '32' , '32' , '4' , '8.00' , '8' , '0' , '50' , '128.00' ) 05/03/2024 12:25: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 ( '90616' , '21799' , 'ISTRUZIONI FAMILIARI VOL. IV - I VIZI E I SCARAMENTI' , '1' , '1' , '4' , '25.00' , '25' , '0' , '50' , '12.50' ) 05/03/2024 12:25: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 ( '90616' , '21418' , 'CRISTO NOSTRA PACE - V. SALVORDI' , '103' , '103' , '4' , '2.50' , '2.5' , '0' , '50' , '128.75' ) 05/03/2024 12:25: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 ( '90616' , '20954' , 'TEMPO DELL’APOCALISSE ' , '11' , '11' , '4' , '15.00' , '15' , '0' , '50' , '82.50' ) 05/03/2024 12:25: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 ( '90616' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '19' , '19' , '4' , '2.80' , '2.8' , '0' , '50' , '26.60' ) 05/03/2024 12:25: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 ( '90616' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '10' , '10' , '4' , '2.80' , '2.8' , '0' , '50' , '14.00' ) 05/03/2024 12:25: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 ( '90616' , '20951' , 'STORIE DEL NOSTRO TEMPO - F. CERRI' , '1' , '1' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 05/03/2024 12:25: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 ( '90616' , '22053' , 'AMO IL SIGNORE, PERCHÉ ASCOLTA IL GRIDO DELLA MIA PREGHIERA' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 05/03/2024 12:25: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 ( '90616' , '19088' , 'TU SOLO IL SANTO - G. VALSECCHI' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 05/03/2024 03:12:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '643' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-05') 05/03/2024 03:12:08 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' , '643' , '2024-03-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '59.20' , '48.52' , NOW() , NOW() ) 05/03/2024 03:12:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90621' 05/03/2024 03:12:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '90621' 05/03/2024 03:12: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 ( '90621' , '13364' , 'CORONA MM 6 ' , '4' , '-4' , '1' , '2.90' , '2.3770491803279' , '22' , '0' , '11.60' ) 05/03/2024 03:12: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 ( '90621' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '7.60' ) 05/03/2024 03:12: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 ( '90621' , '16711' , 'PAGELLA A TRE PAGINE - PREGHIERE E LITANIE A SAN GIUSEPPE ' , '200' , '-200' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '40.00' ) 05/03/2024 03:30:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '644' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-05') 05/03/2024 03:30: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' , '644' , '2024-03-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 05/03/2024 03:30: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 = '90622' 05/03/2024 03:30:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '90622' 05/03/2024 03:30: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 ( '90622' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '50.00' ) 05/03/2024 03:43:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '645' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-05') 05/03/2024 03:43:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '645' , '2024-03-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.70' , '9.70' , NOW() , NOW() ) 05/03/2024 03:43:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90623' 05/03/2024 03:43:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '90623' 05/03/2024 03:43:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90623' , '4842' , 'HUMANAE VITAE' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 05/03/2024 03:43:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90623' , '17377' , 'SAMARITANUS BONUS' , '1' , '-1' , '4' , '2.20' , '2.2' , '0' , '0' , '2.20' ) 05/03/2024 03:43:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90623' , '21906' , 'AMORIS LAETITIA' , '1' , '-1' , '4' , '2.70' , '2.7' , '0' , '0' , '2.70' ) 05/03/2024 03:43:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90623' , '22148' , 'DICHIARAZIONE FIDUCIA SUPPLICANS' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '0' , '2.80' ) 05/03/2024 04:26:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '646' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-05') 05/03/2024 04:26:00 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' , '646' , '2024-03-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 05/03/2024 04:26:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90624' 05/03/2024 04:26:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '90624' 05/03/2024 04:26:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90624' , '16958' , 'SERVIZIO MESSA M/LINO MARIANO - 6990' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 05/03/2024 04:40:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '647' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-05') 05/03/2024 04:40:46 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' , '647' , '2024-03-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '55.00' , NOW() , NOW() ) 05/03/2024 04:40:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90625' 05/03/2024 04:40:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '90625' 05/03/2024 04:40: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 ( '90625' , '3433' , 'DIECI COMANDAMENTI' , '20' , '-20' , '4' , '0.20' , '0.2' , '0' , '0' , '4.00' ) 05/03/2024 04:40: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 ( '90625' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '51' , '51' , '0' , '0' , '51.00' ) 05/03/2024 05:06:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '648' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-05') 05/03/2024 05:06: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 ( '11' , '648' , '2024-03-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 05/03/2024 05:06: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 = '90626' 05/03/2024 05:06:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '90626' 05/03/2024 05:06: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 ( '90626' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 05/03/2024 05:21:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736307' AND id_product != '22032' AND ean13 != '' 05/03/2024 05:21:42 pm >> UPDATE ps_product SET id_supplier = '159', reference = '7/3', ean13 = '9791280736307', date_upd = NOW() WHERE id_product = '22032' 05/03/2024 05:21:42 pm >> UPDATE ps_product_lang SET name = 'ECCO ORA IL MOMENTO FAVOREVOLE ', description = '

Quello di Quaresima è un tempo liturgico prezioso e importante; amo definirlo “un lungo ritiro spirituale” che ci prepara - giorno per giorno - a celebrare “i misteri pasquali della nostra salvezza”. Si cammina insieme verso la Pasqua con il desiderio di rinnovare radicalmente la propria vita, affinché la nostra sequela di Cristo sia sempre più generosa e autentica.

' WHERE id_product = '22032' 05/03/2024 05:21:42 pm >> UPDATE ps_product SET wholesale_price = '1.38', on_sale = '0', price = '10.0000' WHERE id_product = '22032' 05/03/2024 05:21:42 pm >> UPDATE ps_product_shop SET wholesale_price = '1.38', price = '10.0000', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '64', id_internal_category = '4', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22032' 05/03/2024 05:21:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '22032' 05/03/2024 05:21:42 pm >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '22032' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 05/03/2024 05:23:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '9/E' AND id_document != '90607' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-04') 05/03/2024 05:23:23 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '9/E', document_date = '2024-03-04', 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 = '925.00', price_tax_excluded = '925.00', date_upd = NOW() WHERE id_document = '90607' 05/03/2024 05:23:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90607' 05/03/2024 05:23:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '90607' 05/03/2024 05:23: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 ( '90607' , '21899' , 'SACRA BIBBIA cei/uelci ' , '100' , '-100' , '4' , '18.5000' , '18.5' , '0' , '50' , '925.00' ) 05/03/2024 05:52:06 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '6024206615' , '2024-02-29' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '1.42' , '4' , '0' , '0' , '0' , '' , '13' , '0' , '47.56' , '47.56' , NOW() , NOW() ) 05/03/2024 05:52:06 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 = '90627' 05/03/2024 05:52:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '90627' 05/03/2024 05:52: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 ( '90627' , '22184' , 'SEGUIRE GESU - M. CRIMELLA' , '1' , '0' , '4' , '9.75' , '9.75' , '0' , '0' , '9.7500' ) 05/03/2024 05:52:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22184' AND id_supplier = '109' 05/03/2024 05:52:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22184' , '109' , '1' ) 05/03/2024 05:52: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 ( '90627' , '22187' , 'SETTE SACRAMENTI CREATIVI - A. QUEIROLO' , '1' , '0' , '4' , '7.8' , '7.8' , '0' , '0' , '7.8000' ) 05/03/2024 05:52:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22187' AND id_supplier = '109' 05/03/2024 05:52:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22187' , '109' , '1' ) 05/03/2024 05:52: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 ( '90627' , '22201' , 'UN TEMPO PER PIANTARE E UN TEMPO PER SDRAIARE - T. HALIK' , '1' , '0' , '4' , '10.4' , '10.4' , '0' , '0' , '10.4000' ) 05/03/2024 05:52:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22201' AND id_supplier = '109' 05/03/2024 05:52:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22201' , '109' , '1' ) 05/03/2024 05:52: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 ( '90627' , '22204' , 'COSA E LA PREGHIERA? - R. CASTILLO' , '2' , '0' , '4' , '9.095' , '9.095' , '0' , '0' , '18.1900' ) 05/03/2024 05:52:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22204' AND id_supplier = '109' 05/03/2024 05:52:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22204' , '109' , '1' ) 05/03/2024 05:54:08 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '6024206617' , '2024-02-29' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '3.88' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '139.68' , '139.68' , NOW() , NOW() ) 05/03/2024 05:54:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90628' 05/03/2024 05:54:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '90628' 05/03/2024 05:54: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 ( '90628' , '22186' , 'VANGELO DI MARCO - MASCILONGO' , '1' , '0' , '4' , '45.5' , '45.5' , '0' , '0' , '45.5000' ) 05/03/2024 05:54:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22186' AND id_supplier = '109' 05/03/2024 05:54:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22186' , '109' , '1' ) 05/03/2024 05:54: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 ( '90628' , '22185' , 'OPERE SPIRITUALI - DIADOCO DI FOTICEA' , '1' , '0' , '4' , '22.4' , '22.4' , '0' , '0' , '22.4000' ) 05/03/2024 05:54:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22185' AND id_supplier = '109' 05/03/2024 05:54:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22185' , '109' , '1' ) 05/03/2024 05:54:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90628' , '22202' , 'MANUALE DEL PERFETTO CHIERICHETTO - D. COSO' , '4' , '0' , '4' , '5.60' , '5.6' , '0' , '0' , '22.4000' ) 05/03/2024 05:54:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22202' AND id_supplier = '109' 05/03/2024 05:54:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22202' , '109' , '1' ) 05/03/2024 05:54:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90628' , '22205' , 'VANGELO DI LUCA - S. GRASSO' , '1' , '0' , '4' , '45.5' , '45.5' , '0' , '0' , '45.5000' ) 05/03/2024 05:54:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22205' AND id_supplier = '109' 05/03/2024 05:54:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22205' , '109' , '1' ) 05/03/2024 05:56:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '6024206616' , '2024-02-29' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '5.02' , '4' , '0' , '0' , '0' , '' , '13' , '0' , '176.37' , '176.37' , NOW() , NOW() ) 05/03/2024 05:56:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90629' 05/03/2024 05:56:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '90629' 05/03/2024 05:56:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90629' , '22188' , 'UN SILENZIO TRATTENUTO' , '1' , '0' , '4' , '11.6' , '11.6' , '0' , '0' , '11.6000' ) 05/03/2024 05:56:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22188' AND id_supplier = '109' 05/03/2024 05:56:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22188' , '109' , '1' ) 05/03/2024 05:56:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90629' , '2405' , 'CODICE DI DIRITTO CANONICO - 3' , '1' , '0' , '4' , '40.62' , '40.62' , '0' , '0' , '40.6200' ) 05/03/2024 05:56:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2405' AND id_supplier = '109' 05/03/2024 05:56:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2405' , '109' , '1' ) 05/03/2024 05:56:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90629' , '2404' , 'CODICE DI DIRITTO CANONICO - 2' , '1' , '0' , '4' , '40.62' , '40.62' , '0' , '0' , '40.6200' ) 05/03/2024 05:56:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2404' AND id_supplier = '109' 05/03/2024 05:56:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2404' , '109' , '1' ) 05/03/2024 05:56:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90629' , '2405' , 'CODICE DI DIRITTO CANONICO - 3' , '1' , '0' , '4' , '40.62' , '40.62' , '0' , '0' , '40.6200' ) 05/03/2024 05:56:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2405' AND id_supplier = '109' 05/03/2024 05:56:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2405' , '109' , '1' ) 05/03/2024 05:56:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90629' , '22203' , 'AMERAI IL SIGNORE TUO DIO - A. CENCINI' , '1' , '0' , '4' , '17.75' , '17.75' , '0' , '0' , '17.7500' ) 05/03/2024 05:56:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22203' AND id_supplier = '109' 05/03/2024 05:56:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22203' , '109' , '1' ) 05/03/2024 05:56:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90629' , '20218' , 'ECCLESIOLOGIA - V. MIGNOZZI' , '1' , '0' , '4' , '20.14' , '20.14' , '0' , '0' , '20.1400' ) 05/03/2024 05:56:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20218' AND id_supplier = '109' 05/03/2024 05:56:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20218' , '109' , '1' ) 05/03/2024 05:57:55 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '6024206618' , '2024-02-29' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0.23' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '6.87' , '6.87' , NOW() , NOW() ) 05/03/2024 05:57:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90630' 05/03/2024 05:57:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '90630' 05/03/2024 05:57:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90630' , '22189' , 'VIA CRUCIS VIA DI SPERANZA - R. LUPI' , '3' , '0' , '4' , '2.21333' , '2.21333' , '0' , '0' , '6.6400' ) 05/03/2024 05:57:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22189' AND id_supplier = '109' 05/03/2024 05:57:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22189' , '109' , '1' ) 05/03/2024 06:00:53 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '504' , '2024-02-29' , '' , '0' , '47' , '2642' , 'V.LE BACCHIGLIONE, 20 20139 MILANO' , '' , '' , '5.31' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '66.84' , '66.84' , NOW() , NOW() ) 05/03/2024 06:00:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90631' 05/03/2024 06:00:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '90631' 05/03/2024 06:00:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90631' , '22213' , 'STUPORE DI DIO' , '1' , '0' , '4' , '25.0000' , '25' , '0' , '30' , '17.50' ) 05/03/2024 06:00:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22213' AND id_supplier = '47' 05/03/2024 06:00:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22213' , '47' , '1' ) 05/03/2024 06:00:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90631' , '20326' , 'SEGRETO DI MIO FIGLIO - A. ACUTIS' , '1' , '0' , '4' , '10.9000' , '10.9' , '0' , '30' , '7.63' ) 05/03/2024 06:00:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20326' AND id_supplier = '47' 05/03/2024 06:00:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20326' , '47' , '1' ) 05/03/2024 06:00:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90631' , '22214' , 'VIE DI MARIA - F. DE CRISTOFARO' , '4' , '0' , '4' , '13.0000' , '13' , '0' , '30' , '36.40' ) 05/03/2024 06:00:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22214' AND id_supplier = '47' 05/03/2024 06:00:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22214' , '47' , '1' ) 05/03/2024 06:25:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '510' AND id_document != '90428' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-20') 05/03/2024 06:25:56 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '510', document_date = '2024-02-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '8.50', price_tax_excluded = '6.97', date_upd = NOW() WHERE id_document = '90428' 05/03/2024 06:25: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 = '90428' 05/03/2024 06:25:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '90428' 05/03/2024 06:25: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 ( '90428' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 05/03/2024 06:25: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 ( '90428' , '19599' , 'ROSARIO PER LA PRIMA COMUNIONE - 197/13' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 05/03/2024 06:37:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '32/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-05') 05/03/2024 06:37: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 ( '24' , '32/A' , '2024-03-05' , 'A' , '922' , '0' , '4671011' , 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3096.00' , '2537.70' , NOW() , NOW() ) 05/03/2024 06:37: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 = '90632' 05/03/2024 06:37:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '90632' 05/03/2024 06:37: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 ( '90632' , '19971' , 'CALICE - ART. 642' , '1' , '-1' , '1' , '536.00' , '439.34426229508' , '22' , '0' , '536.00' ) 05/03/2024 06:37: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 ( '90632' , '13158' , 'CASULA MOD. LINEA' , '1' , '-1' , '1' , '310.00' , '254.09836065574' , '22' , '0' , '310.00' ) 05/03/2024 06:37: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 ( '90632' , '19659' , 'CASULA POLIESTERE - 65/18355' , '1' , '-1' , '1' , '355.00' , '290.98360655738' , '22' , '0' , '355.00' ) 05/03/2024 06:37: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 ( '90632' , '19660' , 'CASULA POLIESTERE - 65/11648' , '1' , '-1' , '1' , '440.00' , '360.65573770492' , '22' , '0' , '440.00' ) 05/03/2024 06:37: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 ( '90632' , '17408' , 'CAMICE MISTO COT. 70/001035' , '3' , '-3' , '1' , '170.00' , '139.34426229508' , '22' , '0' , '510.00' ) 05/03/2024 06:37: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 ( '90632' , '19842' , 'CALICE OTTONE SABBIATO - 083' , '1' , '-1' , '1' , '360.00' , '295.08196721311' , '22' , '0' , '360.00' ) 05/03/2024 06:37: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 ( '90632' , '22163' , 'CALICE CLASSICO - 155' , '1' , '-1' , '1' , '459.00' , '376.22950819672' , '22' , '0' , '459.00' ) 05/03/2024 06:37: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 ( '90632' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '3' , '-3' , '1' , '42.00' , '34.426229508197' , '22' , '0' , '126.00' ) 05/03/2024 06:41:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '649' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-05') 05/03/2024 06:41:30 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' , '649' , '2024-03-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '40.00' , NOW() , NOW() ) 05/03/2024 06:41:30 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 = '90633' 05/03/2024 06:41:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '90633' 05/03/2024 06:41: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 ( '90633' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '40' , '40' , '0' , '0' , '40.00' ) 05/03/2024 07:13:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '47' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-03-05') 05/03/2024 07:13:09 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '47' , '2024-03-05' , '' , '2893' , '0' , '4672074' , 'VIA CONVENTO 83025 MONTORO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '42.50' , '42.50' , NOW() , NOW() ) 05/03/2024 07:13:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90634' 05/03/2024 07:13:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '90634' 05/03/2024 07:13:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90634' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '50' , '-50' , '4' , '1.00' , '1' , '0' , '15' , '42.50' ) 05/03/2024 07:34:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '584' AND id_document != '90533' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-28') 05/03/2024 07:34:11 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '584', document_date = '2024-02-28', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '85.98', price_tax_excluded = '81.11', date_upd = NOW() WHERE id_document = '90533' 05/03/2024 07:34:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90533' 05/03/2024 07:34:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '90533' 05/03/2024 07:34:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90533' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '4.30' ) 05/03/2024 07:34:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90533' , '5461' , 'IO SONO IL PANE DELLA VITA - 8391' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 05/03/2024 07:34:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90533' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '7.97' , '7.97' , '0' , '0' , '7.97' ) 05/03/2024 07:34:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90533' , '22077' , 'QUARESIMA E PASQUA 2024' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.76' ) 05/03/2024 07:34:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90533' , '22064' , 'QUARESIMA 2024' , '1' , '-1' , '4' , '3.6000' , '3.6' , '0' , '5' , '3.42' ) 05/03/2024 07:34:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90533' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '10.50' ) 05/03/2024 07:34:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90533' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 05/03/2024 07:34:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90533' , '1427' , 'BUSTE PER PALMA BENEDETTA - PZ 200 ' , '2' , '-2' , '1' , '11.5000' , '9.4262295081967' , '22' , '0' , '23.00' ) 05/03/2024 07:34:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90533' , '20218' , 'ECCLESIOLOGIA - V. MIGNOZZI' , '1' , '-1' , '4' , '29.50' , '29.5' , '0' , '5' , '28.03' )