01/03/2023 08:37:30 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 01/03/2023 08:37:30 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20790' , '1' , '' , 'nuovo-prodotto' ) 01/03/2023 08:37:30 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20790' , '1' , '1' , '2' , NOW() , NOW() ) 01/03/2023 08:37:30 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20790' , '0' , '1' , '0' , '0' ) 01/03/2023 08:39:42 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899072421' AND id_product != '20790' AND ean13 != '' 01/03/2023 08:39:42 am >> UPDATE ps_product SET id_supplier = '', reference = '13/5', ean13 = '9788899072421', date_upd = NOW() WHERE id_product = '20790' 01/03/2023 08:39:42 am >> UPDATE ps_product_lang SET name = 'AI PIEDI DEL SUO AMORE ', description = '' WHERE id_product = '20790' 01/03/2023 08:39:42 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5' WHERE id_product = '20790' 01/03/2023 08:39:42 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5', id_tax_rules_group = '4', id_category_default = '517', id_argoment_default = '50', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20790' 01/03/2023 08:39:42 am >> DELETE FROM ps_specific_price WHERE id_product = '20790' 01/03/2023 09:11:12 am >> SELECT document_num FROM ps_document WHERE document_num = '675' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-01') 01/03/2023 09:11:12 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' , '675' , '2023-03-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '155.20' , '129.70' , NOW() , NOW() ) 01/03/2023 09:11:12 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 = '82072' 01/03/2023 09:11:12 am >> DELETE FROM ps_document_detail WHERE id_document = '82072' 01/03/2023 09:11:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82072' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 01/03/2023 09:11:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82072' , '11151' , 'LIBRI' , '6' , '-6' , '4' , '2.3' , '2.3' , '0' , '0' , '13.80' ) 01/03/2023 09:11:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82072' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '85.00' , '69.672131147541' , '22' , '0' , '85.00' ) 01/03/2023 09:33:14 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , 'FPR 11/23' , '2023-02-27' , '23' , '0' , '174' , '4678466' , 'VIA ADRIANA 18 84012 ANGRI' , '' , '' , '' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '45.00' , '45.00' , NOW() , NOW() ) 01/03/2023 09:33:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82073' 01/03/2023 09:33:14 am >> DELETE FROM ps_document_detail WHERE id_document = '82073' 01/03/2023 09:33:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82073' , '20790' , 'AI PIEDI DEL SUO AMORE ' , '30' , '30' , '4' , '3.50' , '3.5' , '0' , '57' , '45.1500' ) 01/03/2023 09:33:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '20790' AND id_supplier = '174' 01/03/2023 09:33:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20790' , '174' , '1' ) 01/03/2023 09:33:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82073' , '' , 'ARROTONDAMENTO' , '1' , '1' , '4' , '-0.15' , '-0.15' , '0' , '0' , '-0.1500' ) 01/03/2023 09:33:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '174' 01/03/2023 09:33:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '174' , '1' ) 01/03/2023 09:39:44 am >> SELECT document_num FROM ps_document WHERE document_num = '21/A' AND id_document != '81297' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-09') 01/03/2023 09:39:44 am >> UPDATE ps_document SET id_document_type = '24', document_num = '21/A', document_date = '2023-02-09', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = 'OSP. S. LEONARDO', note = 'OSP. S. LEONARDO', 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 = '184.80', price_tax_excluded = '158.33', date_upd = NOW() WHERE id_document = '81297' 01/03/2023 09:39:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81297' 01/03/2023 09:39:44 am >> DELETE FROM ps_document_detail WHERE id_document = '81297' 01/03/2023 09:39:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81297' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '10' , '-10' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '10.00' ) 01/03/2023 09:39:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81297' , '0' , '22/02/2023' , '1' , '-1' , '0' , '0.0000' , '0' , '' , '0' , '0.00' ) 01/03/2023 09:39:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81297' , '20071' , 'ROSARIO MISSIONARIO MM8' , '12' , '-12' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '14.40' ) 01/03/2023 09:39:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81297' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - PADRE G. VALSECCHI' , '10' , '-10' , '4' , '2.0000' , '2' , '0' , '5' , '19.00' ) 01/03/2023 09:39:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81297' , '1331' , 'BRACCIALE LEGNO BICOLORE - 034CYB499' , '6' , '-6' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '6.00' ) 01/03/2023 09:39:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81297' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 01/03/2023 09:39:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81297' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 01/03/2023 09:39:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81297' , '20068' , 'CORONA ROSARIO ACCIAIO - NS086' , '1' , '-1' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '7.00' ) 01/03/2023 09:39:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81297' , '' , '01/03/2023' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 01/03/2023 09:39:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81297' , '20071' , 'ROSARIO MISSIONARIO MM8' , '12' , '-12' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '14.40' ) 01/03/2023 09:39:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81297' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - PADRE G. VALSECCHI' , '10' , '-10' , '4' , '2.00' , '2' , '0' , '5' , '19.00' ) 01/03/2023 09:39:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81297' , '19363' , 'CERO MINIATO 80X100' , '1' , '-1' , '1' , '85.00' , '69.672131147541' , '22' , '0' , '85.00' ) 01/03/2023 09:51:55 am >> SELECT document_num FROM ps_document WHERE document_num = '676' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-01') 01/03/2023 09:51:56 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' , '676' , '2023-03-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.95' , '19.95' , NOW() , NOW() ) 01/03/2023 09:51:56 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 = '82074' 01/03/2023 09:51:56 am >> DELETE FROM ps_document_detail WHERE id_document = '82074' 01/03/2023 09:51:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82074' , '20632' , 'MESSA MEDITAZIONE - MAR/APR 2023' , '2' , '-2' , '4' , '8.00' , '8' , '0' , '5' , '15.20' ) 01/03/2023 09:51:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82074' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 01/03/2023 10:02:31 am >> SELECT document_num FROM ps_document WHERE document_num = '677' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-01') 01/03/2023 10:02:31 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '677' , '2023-03-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.00' , '4.00' , NOW() , NOW() ) 01/03/2023 10:02:31 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82075' 01/03/2023 10:02:31 am >> DELETE FROM ps_document_detail WHERE id_document = '82075' 01/03/2023 10:02:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82075' , '10724' , 'TRE MINUTI PER DIO' , '2' , '-2' , '4' , '2.00' , '2' , '0' , '0' , '4.00' ) 01/03/2023 10:10:53 am >> SELECT document_num FROM ps_document WHERE document_num = '678' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-01') 01/03/2023 10:10:53 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '678' , '2023-03-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.10' , '8.28' , NOW() , NOW() ) 01/03/2023 10:10:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82076' 01/03/2023 10:10:53 am >> DELETE FROM ps_document_detail WHERE id_document = '82076' 01/03/2023 10:10: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 ( '82076' , '14772' , 'BRACCIALE SAN BENEDETTO 4 COLORI - 0818/3' , '3' , '-3' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '7.50' ) 01/03/2023 10:10: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 ( '82076' , '20160' , 'BRACCIALE IN CORDA E METALLO - 800/328' , '2' , '-2' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '2.60' ) 01/03/2023 10:12:19 am >> SELECT document_num FROM ps_document WHERE document_num = '679' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-01') 01/03/2023 10:12:20 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '679' , '2023-03-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.50' , '14.34' , NOW() , NOW() ) 01/03/2023 10:12:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82077' 01/03/2023 10:12:20 am >> DELETE FROM ps_document_detail WHERE id_document = '82077' 01/03/2023 10:12:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82077' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '5' , '-5' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '17.50' ) 01/03/2023 10:16:27 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983745' AND id_product != '17828' AND ean13 != '' 01/03/2023 10:16:27 am >> UPDATE ps_product SET id_supplier = '53', reference = '6/1', ean13 = '9788895983745', date_upd = NOW() WHERE id_product = '17828' 01/03/2023 10:16:27 am >> UPDATE ps_product_lang SET name = 'ANGELO STRUFFOLINI - A.G. DIBISCEGLIA', description = '

Vescovo non estraneo alla difficile materia della contemporaneità. Si immerse nella faticosa missione della denuncia dei mali della società, indicando percorsi utili da seguire. Struffolini si rivela una figura di estrema attualità e in alcuni casi, anche profetica.

' WHERE id_product = '17828' 01/03/2023 10:16:27 am >> UPDATE ps_product SET wholesale_price = '6.50', on_sale = '0', price = '26.0000' WHERE id_product = '17828' 01/03/2023 10:16:27 am >> UPDATE ps_product_shop SET wholesale_price = '6.50', price = '26.0000', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '226', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17828' 01/03/2023 10:16:27 am >> DELETE FROM ps_specific_price WHERE id_product = '17828' 01/03/2023 10:16:27 am >> 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' , '17828' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 01/03/2023 10:24:00 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983271' AND id_product != '1379' AND ean13 != '' 01/03/2023 10:24:00 am >> UPDATE ps_product SET id_supplier = '', reference = '1/5', ean13 = '9788895983271', date_upd = NOW() WHERE id_product = '1379' 01/03/2023 10:24:00 am >> UPDATE ps_product_lang SET name = 'BRUGNOLI MUSICISTA E COMPOSITORE', description = '

titolo:            Padre\r\nVincenzo Brugnoli

Musicista e compositore

Formato:          16x16

Pagine:             56

Prezzo:             € 9,00       LIBRO + CD musicale 

ISBN:                  9788895983271

\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n

Descrizione: Vincenzo Brugnoli è una figura di spicco nel panorama della musica sacra.\r\nContemporaneo di Perosi. Il libro comprende il testo e gli spartiti per\r\nl’esecuzione dei brani. In allegato un\r\nCD\r\ncon l’esecuzione delle opere più significative.

' WHERE id_product = '1379' 01/03/2023 10:24:00 am >> UPDATE ps_product SET wholesale_price = '1.05', on_sale = '0', price = '9.0000' WHERE id_product = '1379' 01/03/2023 10:24:00 am >> UPDATE ps_product_shop SET wholesale_price = '1.05', price = '9.0000', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '66', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '1379' 01/03/2023 10:24:00 am >> DELETE FROM ps_specific_price WHERE id_product = '1379' 01/03/2023 10:24:00 am >> 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' , '1379' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 01/03/2023 10:25:58 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983431' AND id_product != '13137' AND ean13 != '' 01/03/2023 10:25:58 am >> UPDATE ps_product SET id_supplier = '107', reference = '1/2', ean13 = '9788895983431', date_upd = NOW() WHERE id_product = '13137' 01/03/2023 10:25:58 am >> UPDATE ps_product_lang SET name = 'CON LA BIBBIA E IL CATECHISMO - S. LA PEGNA', description = '

E\' un contributo alla storia della catechesi e della vita consacrata. Nella lettera ai consacrati P. Francesco dice che occorre \"guardare il passato con gratitudine\" per proiettarsi al futuro con le sue novità e sfide. Tanti Dottrinari sull\'esempio del Beato Cesare, hanno servito la chiesa\"con la Bibbia e il catechismo in mano\".

' WHERE id_product = '13137' 01/03/2023 10:25:58 am >> UPDATE ps_product SET wholesale_price = '1.27', on_sale = '0', price = '10.0000' WHERE id_product = '13137' 01/03/2023 10:25:58 am >> UPDATE ps_product_shop SET wholesale_price = '1.27', price = '10.0000', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '145', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '13137' 01/03/2023 10:25:58 am >> DELETE FROM ps_specific_price WHERE id_product = '13137' 01/03/2023 10:25:58 am >> 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' , '13137' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 01/03/2023 11:11:22 am >> SELECT document_num FROM ps_document WHERE document_num = '680' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-01') 01/03/2023 11:11:22 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' , '680' , '2023-03-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '44.43' , '40.99' , NOW() , NOW() ) 01/03/2023 11:11:22 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 = '82078' 01/03/2023 11:11:22 am >> DELETE FROM ps_document_detail WHERE id_document = '82078' 01/03/2023 11:11:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82078' , '1073' , 'BENVENUTO... IN PUNTA DI PIEDI - AAVV' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '0' , '4.00' ) 01/03/2023 11:11:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82078' , '20706' , 'ANGELO PENDENTE - AM' , '1' , '-1' , '1' , '13.80' , '11.311475409836' , '22' , '0' , '13.80' ) 01/03/2023 11:11:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82078' , '17748' , 'SEGNALIBRO - PR 349' , '15' , '-15' , '1' , '0.35' , '0.28688524590164' , '22' , '0' , '5.25' ) 01/03/2023 11:11:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82078' , '18727' , '10 COMANDAMENTI - P. QUATTRONE' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 01/03/2023 11:11:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82078' , '3443' , 'DIECI PAROLE DAMORE' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 01/03/2023 11:11:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82078' , '15859' , 'VIRTU CRISTIANE -R. BOCCARDO' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 01/03/2023 11:20:16 am >> SELECT document_num FROM ps_document WHERE document_num = '681' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-01') 01/03/2023 11:20:16 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' , '681' , '2023-03-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '170.00' , '139.34' , NOW() , NOW() ) 01/03/2023 11:20:16 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 = '82079' 01/03/2023 11:20:16 am >> DELETE FROM ps_document_detail WHERE id_document = '82079' 01/03/2023 11:20:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82079' , '7202' , 'ARTICOLI RELIGIOSI' , '25' , '-25' , '1' , '1.2' , '0.98360655737705' , '22' , '0' , '30.00' ) 01/03/2023 11:20:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82079' , '7914' , 'PERGAMENE - 1A COMUNIONE MOD. C' , '50' , '-50' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '15.00' ) 01/03/2023 11:20:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82079' , '10501' , 'TECA STANDARD IHS ' , '5' , '-5' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '125.00' ) 01/03/2023 11:21:27 am >> SELECT document_num FROM ps_document WHERE document_num = '682' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-01') 01/03/2023 11:21:27 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '682' , '2023-03-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 01/03/2023 11:21:27 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82080' 01/03/2023 11:21:27 am >> DELETE FROM ps_document_detail WHERE id_document = '82080' 01/03/2023 11:21: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 ( '82080' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 01/03/2023 11:47:25 am >> SELECT document_num FROM ps_document WHERE document_num = '683' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-01') 01/03/2023 11:47:25 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '683' , '2023-03-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.05' , NOW() , NOW() ) 01/03/2023 11:47:25 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82081' 01/03/2023 11:47:25 am >> DELETE FROM ps_document_detail WHERE id_document = '82081' 01/03/2023 11:47:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82081' , '18220' , 'CATENA CON CROCE - NS020' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 01/03/2023 12:20:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '684' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-01') 01/03/2023 12:20: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 ( '11' , '684' , '2023-03-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.50' , '11.07' , NOW() , NOW() ) 01/03/2023 12:20: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 = '82082' 01/03/2023 12:20:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '82082' 01/03/2023 12:20: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 ( '82082' , '20487' , 'STELLARIO CM 14 - ART. 70' , '1' , '-1' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '13.50' ) 01/03/2023 12:28:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '685' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-01') 01/03/2023 12:28: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' , '685' , '2023-03-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 01/03/2023 12:28: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 = '82083' 01/03/2023 12:28:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '82083' 01/03/2023 12:28: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 ( '82083' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 01/03/2023 12:35:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '686' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-01') 01/03/2023 12:35:49 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '686' , '2023-03-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '62.00' , '50.82' , NOW() , NOW() ) 01/03/2023 12:35:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82084' 01/03/2023 12:35:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '82084' 01/03/2023 12:35:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82084' , '16731' , 'COPRILEGGIO CROCE ORO - AVCL01' , '1' , '-1' , '1' , '62.00' , '50.819672131148' , '22' , '0' , '62.00' ) 01/03/2023 01:05:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '687' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-01') 01/03/2023 01:05:22 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '687' , '2023-03-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '77.50' , '63.52' , NOW() , NOW() ) 01/03/2023 01:05:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82085' 01/03/2023 01:05:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '82085' 01/03/2023 01:05:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82085' , '1041' , 'BENEDIZIONI' , '500' , '-500' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '75.00' ) 01/03/2023 01:05:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82085' , '7933' , 'PERGAMENE - CRESIMA MOD. B' , '5' , '-5' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '2.50' ) 01/03/2023 03:47:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '427' AND id_document != '81246' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-06') 01/03/2023 03:47:38 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '427', document_date = '2023-02-06', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '70.00', price_tax_excluded = '64.96', date_upd = NOW() WHERE id_document = '81246' 01/03/2023 03:47:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81246' 01/03/2023 03:47:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '81246' 01/03/2023 03:47:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81246' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 01/03/2023 03:47:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81246' , '6074' , 'MADONNA DI LOURDES - 120' , '3' , '-3' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '10.50' ) 01/03/2023 03:47:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81246' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 01/03/2023 03:47:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81246' , '17073' , 'DIRETTORIO PER LA CATECHESI' , '1' , '-1' , '4' , '14.5' , '14.5' , '0' , '' , '14.50' ) 01/03/2023 04:40:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '688' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-01') 01/03/2023 04:40:58 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' , '688' , '2023-03-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.50' , '8.61' , NOW() , NOW() ) 01/03/2023 04:40:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82086' 01/03/2023 04:40:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '82086' 01/03/2023 04:40:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82086' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '3' , '-3' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '10.50' ) 01/03/2023 04:43:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '119/A' AND id_document != '77503' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-23') 01/03/2023 04:43:21 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '119/A', document_date = '2022-12-23', document_letter = 'A', id_customer = '3843', id_supplier = '', id_address = '4673209', address1 = 'RIONE PIOMBINO 84080 PELLEZZANO', address2 = '', note = '01/03 € 100,00-', 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 = '1950.00', price_tax_excluded = '1950.00', date_upd = NOW() WHERE id_document = '77503' 01/03/2023 04:43:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77503' 01/03/2023 04:43:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '77503' 01/03/2023 04:43:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77503' , '0' , 'STOLA' , '1' , '-1' , '0' , '1950.0000' , '1950' , '0' , '0' , '1950.00' ) 01/03/2023 04:47:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '591' AND id_document != '81459' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-22') 01/03/2023 04:47:39 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '591', document_date = '2023-02-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '4.50', price_tax_excluded = '4.50', date_upd = NOW() WHERE id_document = '81459' 01/03/2023 04:47:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81459' 01/03/2023 04:47:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '81459' 01/03/2023 04:47:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81459' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '1' , '-1' , '4' , '4.5' , '4.5' , '0' , '0' , '4.50' ) 01/03/2023 04:48:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '514' AND id_document != '81354' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-14') 01/03/2023 04:48:19 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '514', document_date = '2023-02-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '68.40', price_tax_excluded = '67.88', date_upd = NOW() WHERE id_document = '81354' 01/03/2023 04:48:19 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 = '81354' 01/03/2023 04:48:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '81354' 01/03/2023 04:48:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81354' , '20433' , 'PARTICOLA SENZA TOSTATURA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 01/03/2023 04:48:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81354' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 01/03/2023 04:48:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81354' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '8.00' ) 01/03/2023 04:48:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81354' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '10' , '-10' , '4' , '5.0000' , '5' , '0' , '5' , '47.50' ) 01/03/2023 04:48:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81354' , '20528' , 'AMEN - MAR 23' , '1' , '-1' , '4' , '3.7' , '3.7' , '0' , '0' , '3.70' ) 01/03/2023 04:48:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81354' , '20527' , 'AMEN - APR 23' , '1' , '-1' , '4' , '3.7' , '3.7' , '0' , '' , '3.70' ) 01/03/2023 05:01:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '27/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-03-01') 01/03/2023 05:01:11 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '27/A' , '2023-03-01' , 'A' , '1175' , '0' , '4672789' , 'VIA BUONSERVIZI, 25 84135 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.40' , '6.40' , NOW() , NOW() ) 01/03/2023 05:01: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 = '82087' 01/03/2023 05:01:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '82087' 01/03/2023 05:01: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 ( '82087' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '4' , '-4' , '4' , '1.60' , '1.6' , '0' , '0' , '6.40' ) 01/03/2023 05:14:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '689' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-01') 01/03/2023 05:14:26 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' , '689' , '2023-03-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.80' , '23.85' , NOW() , NOW() ) 01/03/2023 05:14:26 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 = '82088' 01/03/2023 05:14:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '82088' 01/03/2023 05:14:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82088' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 01/03/2023 05:14:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82088' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '3.80' ) 01/03/2023 05:54:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '690' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-01') 01/03/2023 05:54: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' , '690' , '2023-03-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '45.00' , NOW() , NOW() ) 01/03/2023 05:54: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 = '82089' 01/03/2023 05:54:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '82089' 01/03/2023 05:54: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 ( '82089' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '45' , '45' , '0' , '0' , '45.00' ) 01/03/2023 06:02:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '15' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-03-01') 01/03/2023 06:02: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 ( '24' , '15' , '2023-03-01' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2470.00' , '2470.00' , NOW() , NOW() ) 01/03/2023 06:02: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 = '82090' 01/03/2023 06:02:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '82090' 01/03/2023 06:02: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 ( '82090' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '50' , '-50' , '4' , '7.00' , '7' , '0' , '0' , '350.00' ) 01/03/2023 06:02:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82090' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - PADRE G. VALSECCHI' , '500' , '-500' , '4' , '2.00' , '2' , '0' , '0' , '1000.00' ) 01/03/2023 06:02:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82090' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1120' , '-1120' , '4' , '1.00' , '1' , '0' , '0' , '1120.00' ) 01/03/2023 06:03:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '7/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-03-01') 01/03/2023 06:03: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 ( '23' , '7/E' , '2023-03-01' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '648.00' , '531.15' , NOW() , NOW() ) 01/03/2023 06:03: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 = '82091' 01/03/2023 06:03:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '82091' 01/03/2023 06:03: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 ( '82091' , '12849' , 'LIBRO DELLE SS. MESSE' , '30' , '-30' , '1' , '20.00' , '16.393442622951' , '22' , '40' , '360.00' ) 01/03/2023 06:03: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 ( '82091' , '12817' , 'LIBRO DEI MATRIMONI' , '12' , '-12' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '288.00' ) 01/03/2023 06:10:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '691' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-01') 01/03/2023 06:10:49 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '691' , '2023-03-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 01/03/2023 06:10:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82092' 01/03/2023 06:10:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '82092' 01/03/2023 06:10:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82092' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' )