04/05/2024 08:18:45 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 ( '32' , '24V602682' , '2024-04-30' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '221.18' , '218.01' , NOW() , NOW() ) 04/05/2024 08:18:45 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 = '91601' 04/05/2024 08:18:45 am >> DELETE FROM ps_document_detail WHERE id_document = '91601' 04/05/2024 08:18: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 ( '91601' , '2048' , 'CHRISTIFIDELES LAICI' , '1' , '0' , '4' , '3.5000' , '3.5' , '0' , '33' , '2.35' ) 04/05/2024 08:18:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '2048' AND id_supplier = '7' 04/05/2024 08:18:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2048' , '7' , '1' ) 04/05/2024 08:18: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 ( '91601' , '22377' , 'POTERE DELLA CROCE - R. CANTALAMESSA' , '1' , '0' , '4' , '29.0000' , '29' , '0' , '33' , '19.43' ) 04/05/2024 08:18:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '22377' AND id_supplier = '7' 04/05/2024 08:18:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22377' , '7' , '1' ) 04/05/2024 08:18:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91601' , '14763' , 'GAUDETE ET EXSULTATE' , '2' , '0' , '4' , '2.0000' , '2' , '0' , '33' , '2.68' ) 04/05/2024 08:18:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '14763' AND id_supplier = '7' 04/05/2024 08:18:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14763' , '7' , '1' ) 04/05/2024 08:18:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91601' , '22269' , 'ARTE DELLA PREGHIERA - E. BIANCHI' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '33' , '9.38' ) 04/05/2024 08:18:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '22269' AND id_supplier = '7' 04/05/2024 08:18:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22269' , '7' , '1' ) 04/05/2024 08:18:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91601' , '22169' , 'PIANTO DEL CRISTO - F. SHEEN' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '30' , '12.60' ) 04/05/2024 08:18:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '22169' AND id_supplier = '7' 04/05/2024 08:18:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22169' , '7' , '1' ) 04/05/2024 08:18:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91601' , '21495' , 'AMARE ED ESSERE AMATI - J. TOWEY' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '33' , '12.06' ) 04/05/2024 08:18:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '21495' AND id_supplier = '7' 04/05/2024 08:18:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21495' , '7' , '1' ) 04/05/2024 08:18:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91601' , '849' , 'AVE MARIA - B. FERRERO' , '2' , '0' , '4' , '4.5000' , '4.5' , '0' , '35' , '5.85' ) 04/05/2024 08:18:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '849' AND id_supplier = '7' 04/05/2024 08:18:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '849' , '7' , '1' ) 04/05/2024 08:18:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91601' , '22378' , 'CRESIMA VITA NUOVA NELLO SPIRITO' , '2' , '0' , '4' , '1.5000' , '1.5' , '0' , '33' , '2.01' ) 04/05/2024 08:18:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '22378' AND id_supplier = '7' 04/05/2024 08:18:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22378' , '7' , '1' ) 04/05/2024 08:18:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91601' , '5274' , 'INCONTRO PIÙ BELLO - CONTO DEPOSITO' , '2' , '0' , '4' , '1.5000' , '1.5' , '0' , '33' , '2.01' ) 04/05/2024 08:18:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '5274' AND id_supplier = '7' 04/05/2024 08:18:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5274' , '7' , '1' ) 04/05/2024 08:18:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91601' , '22379' , 'PER FARE UNA MAMMA' , '1' , '0' , '1' , '10.2400' , '8.3934' , '22' , '30' , '8.75' ) 04/05/2024 08:18:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '22379' AND id_supplier = '7' 04/05/2024 08:18:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22379' , '7' , '1' ) 04/05/2024 08:18:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91601' , '22380' , 'PER FARE UNA MAMMA - SPARTITO' , '1' , '0' , '3' , '7.2100' , '6.9327' , '4' , '30' , '5.25' ) 04/05/2024 08:18:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '22380' AND id_supplier = '7' 04/05/2024 08:18:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22380' , '7' , '1' ) 04/05/2024 08:18:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91601' , '22381' , 'CANZONI PER LA MAMMA' , '1' , '0' , '1' , '8.1900' , '6.7131' , '22' , '30' , '6.99' ) 04/05/2024 08:18:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '22381' AND id_supplier = '7' 04/05/2024 08:18:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22381' , '7' , '1' ) 04/05/2024 08:18:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91601' , '18373' , 'COMMENTI AI VANGELI - BENEDETTO XVI' , '1' , '0' , '4' , '25.0000' , '25' , '0' , '30' , '17.50' ) 04/05/2024 08:18:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '18373' AND id_supplier = '7' 04/05/2024 08:18:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18373' , '7' , '1' ) 04/05/2024 08:18: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 ( '91601' , '22403' , 'MIO LIBRO DI PREGHIERE - A. COMASTRI' , '2' , '0' , '4' , '12.0000' , '12' , '0' , '33' , '16.08' ) 04/05/2024 08:18:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '22403' AND id_supplier = '7' 04/05/2024 08:18:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22403' , '7' , '1' ) 04/05/2024 08:18: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 ( '91601' , '22404' , 'CINQUE DOMANDE CHE AGITANO LA CHIESA - I. INGRAO' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '33' , '10.72' ) 04/05/2024 08:18:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '22404' AND id_supplier = '7' 04/05/2024 08:18:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22404' , '7' , '1' ) 04/05/2024 08:18: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 ( '91601' , '17529' , 'NUOVO RITO DELLA MESSA' , '2' , '0' , '4' , '1.5000' , '1.5' , '0' , '33' , '2.01' ) 04/05/2024 08:18:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '17529' AND id_supplier = '7' 04/05/2024 08:18:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17529' , '7' , '1' ) 04/05/2024 08:18: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 ( '91601' , '22405' , 'REDEMPTORIS MATER' , '10' , '0' , '4' , '3.5000' , '3.5' , '0' , '33' , '23.45' ) 04/05/2024 08:18:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '22405' AND id_supplier = '7' 04/05/2024 08:18:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22405' , '7' , '1' ) 04/05/2024 08:18: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 ( '91601' , '7186' , 'NUOVO TESTAMENTO INTERLINEARE' , '1' , '0' , '4' , '79.0000' , '79' , '0' , '33' , '52.93' ) 04/05/2024 08:18:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '7186' AND id_supplier = '7' 04/05/2024 08:18:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7186' , '7' , '1' ) 04/05/2024 08:18: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 ( '91601' , '10133' , 'SPESE DI TRASPORTO' , '1' , '0' , '4' , '8.22' , '8.22' , '0' , '0' , '8.2200' ) 04/05/2024 08:18:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '10133' AND id_supplier = '7' 04/05/2024 08:18:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10133' , '7' , '1' ) 04/05/2024 08:18: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 ( '91601' , '10133' , 'SPESE DI TRASPORTO' , '1' , '0' , '1' , '0.56' , '0.45901639344262' , '22' , '0' , '0.6832' ) 04/05/2024 08:18:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '10133' AND id_supplier = '7' 04/05/2024 08:18:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10133' , '7' , '1' ) 04/05/2024 08:18: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 ( '91601' , '10133' , 'SPESE DI TRASPORTO' , '1' , '0' , '3' , '0.22' , '0.21153846153846' , '4' , '0' , '0.2288' ) 04/05/2024 08:18:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '10133' AND id_supplier = '7' 04/05/2024 08:18:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10133' , '7' , '1' ) 04/05/2024 08:19:57 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '24V602683' , '2024-04-30' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '4.50' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '114.40' , '114.40' , NOW() , NOW() ) 04/05/2024 08:19:57 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91602' 04/05/2024 08:19:57 am >> DELETE FROM ps_document_detail WHERE id_document = '91602' 04/05/2024 08:19:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91602' , '20959' , 'VERITA E NORME DI VITA CRISTIANA' , '12' , '0' , '4' , '1.5000' , '1.5' , '0' , '33' , '12.06' ) 04/05/2024 08:19:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '20959' AND id_supplier = '7' 04/05/2024 08:19:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20959' , '7' , '1' ) 04/05/2024 08:19:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91602' , '20959' , 'VERITA E NORME DI VITA CRISTIANA' , '1' , '0' , '4' , '1.5000' , '1.5' , '0' , '100' , '0.00' ) 04/05/2024 08:19:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '20959' AND id_supplier = '7' 04/05/2024 08:19:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20959' , '7' , '1' ) 04/05/2024 08:19:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91602' , '18289' , 'SANTA MESSA DEGLI SPOSI - N.E.' , '24' , '0' , '4' , '1.9000' , '1.9' , '0' , '33' , '30.55' ) 04/05/2024 08:19:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '18289' AND id_supplier = '7' 04/05/2024 08:19:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18289' , '7' , '1' ) 04/05/2024 08:19:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91602' , '18289' , 'SANTA MESSA DEGLI SPOSI - N.E.' , '2' , '0' , '4' , '1.9000' , '1.9' , '0' , '100' , '0.00' ) 04/05/2024 08:19:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '18289' AND id_supplier = '7' 04/05/2024 08:19:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18289' , '7' , '1' ) 04/05/2024 08:19:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91602' , '22426' , '31 GIORNI CON MARIA - M. CIARDULLO' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '30' , '8.40' ) 04/05/2024 08:19:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '22426' AND id_supplier = '7' 04/05/2024 08:19:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22426' , '7' , '1' ) 04/05/2024 08:19:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91602' , '22402' , 'REGNO DI DIO E UNA SFIDA - F.J. SHEEN' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '30' , '11.20' ) 04/05/2024 08:19:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '22402' AND id_supplier = '7' 04/05/2024 08:19:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22402' , '7' , '1' ) 04/05/2024 08:19:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91602' , '16345' , 'REGOLA DELLORDINE FRANCESCANO SECOLARE' , '5' , '0' , '4' , '3.0000' , '3' , '0' , '30' , '10.50' ) 04/05/2024 08:19:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '16345' AND id_supplier = '7' 04/05/2024 08:19:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16345' , '7' , '1' ) 04/05/2024 08:19:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91602' , '849' , 'AVE MARIA - B. FERRERO' , '2' , '0' , '4' , '4.5000' , '4.5' , '0' , '35' , '5.85' ) 04/05/2024 08:19:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '849' AND id_supplier = '7' 04/05/2024 08:19:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '849' , '7' , '1' ) 04/05/2024 08:19:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91602' , '22138' , 'ROSARIO UNA CORONA DI ROSE' , '3' , '0' , '4' , '4.9000' , '4.9' , '0' , '30' , '10.29' ) 04/05/2024 08:19:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '22138' AND id_supplier = '7' 04/05/2024 08:19:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22138' , '7' , '1' ) 04/05/2024 08:19:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91602' , '22397' , 'AFFERRATI DALLAMORE' , '3' , '0' , '4' , '4.9000' , '4.9' , '0' , '33' , '9.85' ) 04/05/2024 08:19:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '22397' AND id_supplier = '7' 04/05/2024 08:19:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22397' , '7' , '1' ) 04/05/2024 08:19:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91602' , '22131' , 'SAN FRANCESCO DI PAOLA - A. DE LORENZI' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '30' , '11.20' ) 04/05/2024 08:19:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '22131' AND id_supplier = '7' 04/05/2024 08:19:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22131' , '7' , '1' ) 04/05/2024 08:22:53 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281465022' AND id_product != '22271' AND ean13 != '' 04/05/2024 08:22:53 am >> UPDATE ps_product SET id_supplier = '7', reference = '7/2', ean13 = '9791281465022', date_upd = NOW() WHERE id_product = '22271' 04/05/2024 08:22:53 am >> UPDATE ps_product_lang SET name = 'ADORAZIONE EUCARISTICA - G. MORETTI', description = '' WHERE id_product = '22271' 04/05/2024 08:22:53 am >> UPDATE ps_product SET wholesale_price = '9.10', on_sale = '0', price = '13.0000' WHERE id_product = '22271' 04/05/2024 08:22:53 am >> UPDATE ps_product_shop SET wholesale_price = '9.10', price = '13.0000', id_tax_rules_group = '4', id_category_default = '97', 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 = '22271' 04/05/2024 08:22:53 am >> DELETE FROM ps_specific_price WHERE id_product = '22271' 04/05/2024 08:25:35 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 ( '32' , '24V602684' , '2024-04-30' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '35.2' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '1218.61' , '1218.61' , NOW() , NOW() ) 04/05/2024 08:25:35 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 = '91603' 04/05/2024 08:25:35 am >> DELETE FROM ps_document_detail WHERE id_document = '91603' 04/05/2024 08:25:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91603' , '22398' , 'CREDERE - R. MAGGI' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '30' , '7.00' ) 04/05/2024 08:25:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '22398' AND id_supplier = '7' 04/05/2024 08:25:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22398' , '7' , '1' ) 04/05/2024 08:25:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91603' , '22395' , 'DA GERUSALEMME A ROMA - M. SODI' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '33' , '12.06' ) 04/05/2024 08:25:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '22395' AND id_supplier = '7' 04/05/2024 08:25:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22395' , '7' , '1' ) 04/05/2024 08:25:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91603' , '22397' , 'AFFERRATI DALLAMORE' , '2' , '0' , '4' , '4.9000' , '4.9' , '0' , '33' , '6.57' ) 04/05/2024 08:25:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '22397' AND id_supplier = '7' 04/05/2024 08:25:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22397' , '7' , '1' ) 04/05/2024 08:25:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91603' , '22390' , 'ROSARIO DELLA GUARIGIONE' , '2' , '0' , '4' , '3.0000' , '3' , '0' , '30' , '4.20' ) 04/05/2024 08:25:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '22390' AND id_supplier = '7' 04/05/2024 08:25:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22390' , '7' , '1' ) 04/05/2024 08:25:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91603' , '22399' , 'TUTTO IN UN FRAMMENTO - E. BOLIS' , '1' , '0' , '4' , '13.0000' , '13' , '0' , '30' , '9.10' ) 04/05/2024 08:25:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '22399' AND id_supplier = '7' 04/05/2024 08:25:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22399' , '7' , '1' ) 04/05/2024 08:25:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91603' , '22402' , 'REGNO DI DIO E UNA SFIDA - F.J. SHEEN' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '30' , '11.20' ) 04/05/2024 08:25:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '22402' AND id_supplier = '7' 04/05/2024 08:25:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22402' , '7' , '1' ) 04/05/2024 08:25:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91603' , '22391' , 'UN ANNO CON MARIA - BENEDETTO XVI' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '30' , '7.00' ) 04/05/2024 08:25:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '22391' AND id_supplier = '7' 04/05/2024 08:25:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22391' , '7' , '1' ) 04/05/2024 08:25:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91603' , '22400' , 'ACCOMPAGNARE I CATECUMENI - R. LACROIX' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '30' , '11.20' ) 04/05/2024 08:25:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '22400' AND id_supplier = '7' 04/05/2024 08:25:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22400' , '7' , '1' ) 04/05/2024 08:25:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91603' , '22401' , 'CHRISTIAN DE CHERGE - C. SALENSON' , '1' , '0' , '4' , '32.0000' , '32' , '0' , '30' , '22.40' ) 04/05/2024 08:25:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '22401' AND id_supplier = '7' 04/05/2024 08:25:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22401' , '7' , '1' ) 04/05/2024 08:25:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91603' , '22394' , 'NOVISSIMI ... O VECCHISSIMI? - L. ALESSANDRINI' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '30' , '8.40' ) 04/05/2024 08:25:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '22394' AND id_supplier = '7' 04/05/2024 08:25:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22394' , '7' , '1' ) 04/05/2024 08:25:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91603' , '22393' , 'BATTESIMO NELLO SPIRITO - R. CANTALAMESSA' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '30' , '8.40' ) 04/05/2024 08:25:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '22393' AND id_supplier = '7' 04/05/2024 08:25:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22393' , '7' , '1' ) 04/05/2024 08:25:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91603' , '22403' , 'MIO LIBRO DI PREGHIERE - A. COMASTRI' , '2' , '0' , '4' , '12.0000' , '12' , '0' , '33' , '16.08' ) 04/05/2024 08:25:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '22403' AND id_supplier = '7' 04/05/2024 08:25:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22403' , '7' , '1' ) 04/05/2024 08:25:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91603' , '22396' , 'PREGARE E VIVERE - L. PACOMIO' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '33' , '10.72' ) 04/05/2024 08:25:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '22396' AND id_supplier = '7' 04/05/2024 08:25:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22396' , '7' , '1' ) 04/05/2024 08:25:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91603' , '22389' , 'PREGHIERA NELLANTICO TESTAMENTO - E. BUCCIONI' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '33' , '9.38' ) 04/05/2024 08:25:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '22389' AND id_supplier = '7' 04/05/2024 08:25:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22389' , '7' , '1' ) 04/05/2024 08:25:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91603' , '22388' , 'MESSALINO QUOTIDIANO - AGO SET OTT' , '12' , '0' , '4' , '6.0000' , '6' , '0' , '30' , '50.40' ) 04/05/2024 08:25:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '22388' AND id_supplier = '7' 04/05/2024 08:25:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22388' , '7' , '1' ) 04/05/2024 08:25:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91603' , '22388' , 'MESSALINO QUOTIDIANO - AGO SET OTT' , '1' , '0' , '4' , '6.0000' , '6' , '0' , '100' , '0.00' ) 04/05/2024 08:25:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '22388' AND id_supplier = '7' 04/05/2024 08:25:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22388' , '7' , '1' ) 04/05/2024 08:25:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91603' , '22392' , 'DALLALBA AL TRAMONTO - MAG 2024' , '1' , '0' , '4' , '3.2000' , '3.2' , '0' , '30' , '2.24' ) 04/05/2024 08:25:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '22392' AND id_supplier = '7' 04/05/2024 08:25:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22392' , '7' , '1' ) 04/05/2024 08:25:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91603' , '22474' , 'PAROLA E PREGHIERA - LUG 2024' , '4' , '0' , '4' , '2.9000' , '2.9' , '0' , '33' , '7.77' ) 04/05/2024 08:25:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '22474' AND id_supplier = '7' 04/05/2024 08:25:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22474' , '7' , '1' ) 04/05/2024 08:25:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91603' , '22473' , 'INSIEME NELLA MESSA - LUG 2024' , '1' , '0' , '4' , '1.8000' , '1.8' , '0' , '33' , '1.21' ) 04/05/2024 08:25:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '22473' AND id_supplier = '7' 04/05/2024 08:25:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22473' , '7' , '1' ) 04/05/2024 08:25:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91603' , '22483' , 'INCONTRO PIU BELLO' , '12' , '0' , '4' , '1.8000' , '1.8' , '0' , '33' , '14.47' ) 04/05/2024 08:25:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '22483' AND id_supplier = '7' 04/05/2024 08:25:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22483' , '7' , '1' ) 04/05/2024 08:25:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91603' , '22483' , 'INCONTRO PIU BELLO' , '1' , '0' , '4' , '1.8000' , '1.8' , '0' , '100' , '0.00' ) 04/05/2024 08:25:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '22483' AND id_supplier = '7' 04/05/2024 08:25:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22483' , '7' , '1' ) 04/05/2024 08:25:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91603' , '22484' , 'CRESIMA' , '12' , '0' , '4' , '1.8000' , '1.8' , '0' , '33' , '14.47' ) 04/05/2024 08:25:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '22484' AND id_supplier = '7' 04/05/2024 08:25:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22484' , '7' , '1' ) 04/05/2024 08:25: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 ( '91603' , '22484' , 'CRESIMA' , '1' , '0' , '4' , '1.8000' , '1.8' , '0' , '100' , '0.00' ) 04/05/2024 08:25:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '22484' AND id_supplier = '7' 04/05/2024 08:25:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22484' , '7' , '1' ) 04/05/2024 08:25: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 ( '91603' , '22490' , 'MARIA DI NAZARET - F. MANZI' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '33' , '9.38' ) 04/05/2024 08:25:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '22490' AND id_supplier = '7' 04/05/2024 08:25:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22490' , '7' , '1' ) 04/05/2024 08:25: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 ( '91603' , '22493' , 'MESSA DETTA ALTRIMENTI - L.M. CHAUVET' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '30' , '9.80' ) 04/05/2024 08:25:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '22493' AND id_supplier = '7' 04/05/2024 08:25:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22493' , '7' , '1' ) 04/05/2024 08:25: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 ( '91603' , '22479' , 'NON VI GUARDO PERCHE RISCHIO DI FIDARMI - C. BURGO' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '33' , '10.05' ) 04/05/2024 08:25:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '22479' AND id_supplier = '7' 04/05/2024 08:25:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22479' , '7' , '1' ) 04/05/2024 08:25: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 ( '91603' , '22486' , 'PREGHIERA E LITURGIA - G. ZANCHI' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '33' , '9.38' ) 04/05/2024 08:25:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '22486' AND id_supplier = '7' 04/05/2024 08:25:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22486' , '7' , '1' ) 04/05/2024 08:25: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 ( '91603' , '22481' , 'GIOIA DELLAMORE - C. ROCCHETTA' , '1' , '0' , '4' , '8.0000' , '8' , '0' , '33' , '5.36' ) 04/05/2024 08:25:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '22481' AND id_supplier = '7' 04/05/2024 08:25:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22481' , '7' , '1' ) 04/05/2024 08:25: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 ( '91603' , '22478' , 'MARIA DONNA DEI NOSTRI GIORNI - TONINO BELLO' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '33' , '6.70' ) 04/05/2024 08:25:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '22478' AND id_supplier = '7' 04/05/2024 08:25:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22478' , '7' , '1' ) 04/05/2024 08:25: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 ( '91603' , '22485' , 'MARIA DONNA CHE APRE SENTIERI - PAPA FRANCESCO' , '2' , '0' , '4' , '18.0000' , '18' , '0' , '33' , '24.12' ) 04/05/2024 08:25:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '22485' AND id_supplier = '7' 04/05/2024 08:25:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22485' , '7' , '1' ) 04/05/2024 08:25: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 ( '91603' , '22482' , 'AVE MARIA - E. RONCHI' , '3' , '0' , '4' , '4.9000' , '4.9' , '0' , '33' , '9.85' ) 04/05/2024 08:25:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '22482' AND id_supplier = '7' 04/05/2024 08:25:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22482' , '7' , '1' ) 04/05/2024 08:25: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 ( '91603' , '22492' , 'MARIA INFLUENCER DI DIO - P. PELLEGRINO' , '1' , '0' , '4' , '4.5000' , '4.5' , '0' , '30' , '3.15' ) 04/05/2024 08:25:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '22492' AND id_supplier = '7' 04/05/2024 08:25:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22492' , '7' , '1' ) 04/05/2024 08:25: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 ( '91603' , '22487' , 'MESE DI MAGGIO GIORNO PER GIORNO' , '2' , '0' , '4' , '9.0000' , '9' , '0' , '30' , '12.60' ) 04/05/2024 08:25:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '22487' AND id_supplier = '7' 04/05/2024 08:25:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22487' , '7' , '1' ) 04/05/2024 08:25: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 ( '91603' , '22491' , 'SPIRITUALITA PRATICA - O. DE BERTOLIS' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '30' , '7.00' ) 04/05/2024 08:25:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '22491' AND id_supplier = '7' 04/05/2024 08:25:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22491' , '7' , '1' ) 04/05/2024 08:25: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 ( '91603' , '22477' , 'SAN GIUSEPPE SALVATORE DEL SALVATORE - K.J. NYKIEL' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '33' , '9.38' ) 04/05/2024 08:25:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '22477' AND id_supplier = '7' 04/05/2024 08:25:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22477' , '7' , '1' ) 04/05/2024 08:25: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 ( '91603' , '22480' , 'UNA FINESTRA VERSO IL CIELO - R. BUONO' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '33' , '9.38' ) 04/05/2024 08:25:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '22480' AND id_supplier = '7' 04/05/2024 08:25:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22480' , '7' , '1' ) 04/05/2024 08:25: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 ( '91603' , '22489' , 'SACERDOTE DEVE LASCIARSI MODELLARE - A. COMASTRI' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '30' , '3.50' ) 04/05/2024 08:25:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '22489' AND id_supplier = '7' 04/05/2024 08:25:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22489' , '7' , '1' ) 04/05/2024 08:25: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 ( '91603' , '22488' , 'SANTO ROSARIO CON LE ICONE - A.M. CANOPI' , '3' , '0' , '4' , '3.0000' , '3' , '0' , '30' , '6.30' ) 04/05/2024 08:25:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '22488' AND id_supplier = '7' 04/05/2024 08:25:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22488' , '7' , '1' ) 04/05/2024 08:25: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 ( '91603' , '22475' , 'AMEN - LUG. 2024' , '30' , '0' , '4' , '3.9000' , '3.9' , '0' , '33' , '78.39' ) 04/05/2024 08:25:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '22475' AND id_supplier = '7' 04/05/2024 08:25:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22475' , '7' , '1' ) 04/05/2024 08:25: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 ( '91603' , '22475' , 'AMEN - LUG. 2024' , '3' , '0' , '4' , '3.9000' , '3.9' , '0' , '100' , '0.00' ) 04/05/2024 08:25:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '22475' AND id_supplier = '7' 04/05/2024 08:25:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22475' , '7' , '1' ) 04/05/2024 08:25: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 ( '91603' , '22476' , 'AMEN - AGO 2024' , '30' , '0' , '4' , '3.9000' , '3.9' , '0' , '33' , '78.39' ) 04/05/2024 08:25:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '22476' AND id_supplier = '7' 04/05/2024 08:25:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22476' , '7' , '1' ) 04/05/2024 08:25: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 ( '91603' , '22476' , 'AMEN - AGO 2024' , '3' , '0' , '4' , '3.9000' , '3.9' , '0' , '100' , '0.00' ) 04/05/2024 08:25:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '22476' AND id_supplier = '7' 04/05/2024 08:25:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22476' , '7' , '1' ) 04/05/2024 08:25: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 ( '91603' , '22450' , 'DIO E SEMPRE CON NOI' , '3' , '0' , '4' , '1.9000' , '1.9' , '0' , '35' , '3.71' ) 04/05/2024 08:25:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '22450' AND id_supplier = '7' 04/05/2024 08:25:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22450' , '7' , '1' ) 04/05/2024 08:25: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 ( '91603' , '22310' , 'VIA VAI ORATORIO ESTIVO' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '30' , '12.60' ) 04/05/2024 08:25:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '22310' AND id_supplier = '7' 04/05/2024 08:25:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22310' , '7' , '1' ) 04/05/2024 08:25: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 ( '91603' , '22451' , 'STORIA DI SANTA CHIARA' , '3' , '0' , '4' , '1.9000' , '1.9' , '0' , '30' , '3.99' ) 04/05/2024 08:25:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '22451' AND id_supplier = '7' 04/05/2024 08:25:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22451' , '7' , '1' ) 04/05/2024 08:25: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 ( '91603' , '12258' , 'STORIA DI SAN DOMENICO SAVIO' , '3' , '0' , '4' , '1.9000' , '1.9' , '0' , '30' , '3.99' ) 04/05/2024 08:25:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '12258' AND id_supplier = '7' 04/05/2024 08:25:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12258' , '7' , '1' ) 04/05/2024 08:25: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 ( '91603' , '10288' , 'STORIA DI MARIA' , '2' , '0' , '4' , '1.9000' , '1.9' , '0' , '30' , '2.66' ) 04/05/2024 08:25:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '10288' AND id_supplier = '7' 04/05/2024 08:25:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10288' , '7' , '1' ) 04/05/2024 08:25: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 ( '91603' , '22452' , 'STORIA DI SANTA RITA DA CASCIA' , '2' , '0' , '4' , '1.9000' , '1.9' , '0' , '30' , '2.66' ) 04/05/2024 08:25:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '22452' AND id_supplier = '7' 04/05/2024 08:25:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22452' , '7' , '1' ) 04/05/2024 08:25:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91603' , '22453' , 'STORIA DI SAN GIOVANNI BOSCO' , '2' , '0' , '4' , '1.9000' , '1.9' , '0' , '30' , '2.66' ) 04/05/2024 08:25:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '22453' AND id_supplier = '7' 04/05/2024 08:25:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22453' , '7' , '1' ) 04/05/2024 08:25:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91603' , '22181' , 'MESSALINO QUOTIDIANO - MAG/GIU/LUG 2024' , '7' , '0' , '4' , '6.0000' , '6' , '0' , '30' , '29.40' ) 04/05/2024 08:25:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '22181' AND id_supplier = '7' 04/05/2024 08:25:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22181' , '7' , '1' ) 04/05/2024 08:25:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91603' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '33' , '12.06' ) 04/05/2024 08:25:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '20655' AND id_supplier = '7' 04/05/2024 08:25:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20655' , '7' , '1' ) 04/05/2024 08:25:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91603' , '16884' , 'ARTE DI GUARIRE - F. ROSINI' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '33' , '12.06' ) 04/05/2024 08:25:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '16884' AND id_supplier = '7' 04/05/2024 08:25:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16884' , '7' , '1' ) 04/05/2024 08:25:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91603' , '13432' , 'ARTE DI RICOMINCIARE - F. ROSINI' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '33' , '12.06' ) 04/05/2024 08:25:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '13432' AND id_supplier = '7' 04/05/2024 08:25:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13432' , '7' , '1' ) 04/05/2024 08:25:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91603' , '22131' , 'SAN FRANCESCO DI PAOLA - A. DE LORENZI' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '30' , '11.20' ) 04/05/2024 08:25:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '22131' AND id_supplier = '7' 04/05/2024 08:25:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22131' , '7' , '1' ) 04/05/2024 08:25:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91603' , '21023' , 'SALVE REGINA - G. SACINO' , '5' , '0' , '4' , '6.0000' , '6' , '0' , '33' , '20.10' ) 04/05/2024 08:25:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '21023' AND id_supplier = '7' 04/05/2024 08:25:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21023' , '7' , '1' ) 04/05/2024 08:25:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91603' , '22494' , 'BASTA UNO SGUARDO - M. FALABRETTI' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '35' , '9.10' ) 04/05/2024 08:25:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '22494' AND id_supplier = '7' 04/05/2024 08:25:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22494' , '7' , '1' ) 04/05/2024 08:25:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91603' , '22271' , 'ADFORAZIONE EUCARISTICA - G. MORETTI' , '1' , '0' , '4' , '13.0000' , '13' , '0' , '30' , '9.10' ) 04/05/2024 08:25:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '22271' AND id_supplier = '7' 04/05/2024 08:25:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22271' , '7' , '1' ) 04/05/2024 08:25:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91603' , '22488' , 'SANTO ROSARIO CON LE ICONE - A.M. CANOPI' , '1' , '0' , '4' , '3.0000' , '3' , '0' , '30' , '2.10' ) 04/05/2024 08:25:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '22488' AND id_supplier = '7' 04/05/2024 08:25:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22488' , '7' , '1' ) 04/05/2024 08:25:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91603' , '1824' , 'CATECHISMO DELLA CHIESA CATTOLICA - COMPENDIO' , '1' , '0' , '4' , '6.5000' , '6.5' , '0' , '33' , '4.36' ) 04/05/2024 08:25:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '1824' AND id_supplier = '7' 04/05/2024 08:25:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1824' , '7' , '1' ) 04/05/2024 08:25:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91603' , '19512' , 'SGUARDO DI GESU - F. CRISTOFARO' , '10' , '0' , '4' , '16.0000' , '16' , '0' , '30' , '112.00' ) 04/05/2024 08:25:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '19512' AND id_supplier = '7' 04/05/2024 08:25:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19512' , '7' , '1' ) 04/05/2024 08:25:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91603' , '17423' , 'CARLO ACUTIS' , '80' , '0' , '4' , '7.5000' , '7.5' , '0' , '30+7' , '390.60' ) 04/05/2024 08:25:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '17423' AND id_supplier = '7' 04/05/2024 08:25:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17423' , '7' , '1' ) 04/05/2024 08:26:28 am >> UPDATE ps_document SET id_document_type = '33', document_num = '662570', document_date = '2024-04-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2602', address1 = 'P. ZZA SAN PAOLO, 14 12051 ALBA', address2 = '', note = '', price_shipping = '4.46', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '11', id_causal = '0', price_tax_included = '335.11', price_tax_excluded = '335.11', date_upd = NOW() WHERE id_document = '91495' 04/05/2024 08:26:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91495' 04/05/2024 08:26:28 am >> DELETE FROM ps_document_detail WHERE id_document = '91495' 04/05/2024 08:26:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91495' , '22474' , 'PAROLA E PREGHIERA - LUG 2024' , '4' , '4' , '4' , '2.9000' , '2.9' , '0' , '33' , '7.77' ) 04/05/2024 08:26:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91495' , '22473' , 'INSIEME NELLA MESSA - LUG 2024' , '1' , '1' , '4' , '1.8000' , '1.8' , '0' , '33' , '1.21' ) 04/05/2024 08:26:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91495' , '22483' , 'INCONTRO PIU BELLO' , '12' , '12' , '4' , '1.8000' , '1.8' , '0' , '33' , '14.47' ) 04/05/2024 08:26:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91495' , '22483' , 'INCONTRO PIU BELLO' , '1' , '1' , '4' , '1.8000' , '1.8' , '0' , '100' , '0.00' ) 04/05/2024 08:26:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91495' , '22484' , 'CRESIMA' , '12' , '12' , '4' , '1.8000' , '1.8' , '0' , '33' , '14.47' ) 04/05/2024 08:26:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91495' , '22484' , 'CRESIMA' , '1' , '1' , '4' , '1.8000' , '1.8' , '0' , '100' , '0.00' ) 04/05/2024 08:26:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91495' , '22490' , 'MARIA DI NAZARET - F. MANZI' , '1' , '1' , '4' , '14.0000' , '14' , '0' , '33' , '9.38' ) 04/05/2024 08:26:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91495' , '22493' , 'MESSA DETTA ALTRIMENTI - L.M. CHAUVET' , '1' , '1' , '4' , '14.0000' , '14' , '0' , '30' , '9.80' ) 04/05/2024 08:26:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91495' , '22479' , 'NON VI GUARDO PERCHE RISCHIO DI FIDARMI - C. BURGO' , '1' , '1' , '4' , '15.0000' , '15' , '0' , '33' , '10.05' ) 04/05/2024 08:26:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91495' , '22486' , 'PREGHIERA E LITURGIA - G. ZANCHI' , '1' , '1' , '4' , '14.0000' , '14' , '0' , '33' , '9.38' ) 04/05/2024 08:26:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91495' , '22481' , 'GIOIA DELLAMORE - C. ROCCHETTA' , '1' , '1' , '4' , '8.0000' , '8' , '0' , '33' , '5.36' ) 04/05/2024 08:26:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91495' , '22478' , 'MARIA DONNA DEI NOSTRI GIORNI - TONINO BELLO' , '1' , '1' , '4' , '10.0000' , '10' , '0' , '33' , '6.70' ) 04/05/2024 08:26:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91495' , '22485' , 'MARIA DONNA CHE APRE SENTIERI - PAPA FRANCESCO' , '2' , '2' , '4' , '18.0000' , '18' , '0' , '33' , '24.12' ) 04/05/2024 08:26:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91495' , '22482' , 'AVE MARIA - E. RONCHI' , '3' , '3' , '4' , '4.9000' , '4.9' , '0' , '33' , '9.85' ) 04/05/2024 08:26:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91495' , '22492' , 'MARIA INFLUENCER DI DIO - P. PELLEGRINO' , '1' , '1' , '4' , '4.5000' , '4.5' , '0' , '30' , '3.15' ) 04/05/2024 08:26:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91495' , '22487' , 'MESE DI MAGGIO GIORNO PER GIORNO' , '2' , '2' , '4' , '9.0000' , '9' , '0' , '30' , '12.60' ) 04/05/2024 08:26:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91495' , '22491' , 'SPIRITUALITA PRATICA - O. DE BERTOLIS' , '1' , '1' , '4' , '10.0000' , '10' , '0' , '30' , '7.00' ) 04/05/2024 08:26:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91495' , '22477' , 'SAN GIUSEPPE SALVATORE DEL SALVATORE - K.J. NYKIEL' , '1' , '1' , '4' , '14.0000' , '14' , '0' , '33' , '9.38' ) 04/05/2024 08:26:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91495' , '22480' , 'UNA FINESTRA VERSO IL CIELO - R. BUONO' , '1' , '1' , '4' , '14.0000' , '14' , '0' , '33' , '9.38' ) 04/05/2024 08:26:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91495' , '22489' , 'SACERDOTE DEVE LASCIARSI MODELLARE - A. COMASTRI' , '1' , '1' , '4' , '5.0000' , '5' , '0' , '30' , '3.50' ) 04/05/2024 08:26:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91495' , '22488' , 'SANTO ROSARIO CON LE ICONE - A.M. CANOPI' , '3' , '3' , '4' , '3.0000' , '3' , '0' , '30' , '6.30' ) 04/05/2024 08:26:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91495' , '22475' , 'AMEN - LUG. 2024' , '30' , '30' , '4' , '3.9000' , '3.9' , '0' , '33' , '78.39' ) 04/05/2024 08:26:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91495' , '22475' , 'AMEN - LUG. 2024' , '3' , '3' , '4' , '3.9000' , '3.9' , '0' , '100' , '0.00' ) 04/05/2024 08:26:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91495' , '22476' , 'AMEN - AGO 2024' , '30' , '30' , '4' , '3.9000' , '3.9' , '0' , '33' , '78.39' ) 04/05/2024 08:26:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91495' , '22476' , 'AMEN - AGO 2024' , '3' , '3' , '4' , '3.9000' , '3.9' , '0' , '100' , '0.00' ) 04/05/2024 08:28:00 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '24V602685' , '2024-04-30' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '4.49' , '1' , '0' , '0' , '0' , '' , '12' , '0' , '30.78' , '25.23' , NOW() , NOW() ) 04/05/2024 08:28:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91604' 04/05/2024 08:28:00 am >> DELETE FROM ps_document_detail WHERE id_document = '91604' 04/05/2024 08:28:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91604' , '22287' , 'CIONDOLO SI - ARGENTO' , '13' , '0' , '1' , '2.4500' , '2.0082' , '22' , '30+7' , '25.30' ) 04/05/2024 08:28:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '22287' AND id_supplier = '7' 04/05/2024 08:28:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22287' , '7' , '1' ) 04/05/2024 09:15:25 am >> SELECT document_num FROM ps_document WHERE document_num = '29/A' AND id_document != '90546' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-02-28') 04/05/2024 09:15:25 am >> UPDATE ps_document SET id_document_type = '24', document_num = '29/A', document_date = '2024-02-28', document_letter = 'A', id_customer = '470', id_supplier = '', id_address = '4679186', address1 = 'LARGO FRATELLI DEL GIUDICE 37 84069 ROCCADASPIDE', address2 = '', note = 'da spendere € 40,00 vedi busta buoni', 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 = '79.00', price_tax_excluded = '79.00', date_upd = NOW() WHERE id_document = '90546' 04/05/2024 09:15: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 = '90546' 04/05/2024 09:15:25 am >> DELETE FROM ps_document_detail WHERE id_document = '90546' 04/05/2024 09:15: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 ( '90546' , '18276' , 'CINGOLO CON NODI - 3280' , '6' , '-6' , '0' , '2.5000' , '2.5' , '0' , '0' , '15.00' ) 04/05/2024 09:15: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 ( '90546' , '22198' , 'CORONCINA PRIMA COMUNIONE - 3313' , '8' , '-8' , '0' , '8.0000' , '8' , '' , '0' , '64.00' ) 04/05/2024 09:17:34 am >> SELECT document_num FROM ps_document WHERE document_num = '1423' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-04') 04/05/2024 09:17:35 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' , '1423' , '2024-05-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.00' , '57.00' , NOW() , NOW() ) 04/05/2024 09:17:35 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 = '91605' 04/05/2024 09:17:35 am >> DELETE FROM ps_document_detail WHERE id_document = '91605' 04/05/2024 09:17:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91605' , '17074' , 'DIRETTORIO PER LA CATECHESI' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '5' , '20.90' ) 04/05/2024 09:17:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91605' , '21003' , 'FARE CATECHESI OGGI - U. MONTISCI' , '1' , '-1' , '4' , '38.00' , '38' , '0' , '5' , '36.10' ) 04/05/2024 09:40:13 am >> SELECT document_num FROM ps_document WHERE document_num = '1424' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-04') 04/05/2024 09:40:13 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' , '1424' , '2024-05-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.06' , '35.06' , NOW() , NOW() ) 04/05/2024 09:40:13 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 = '91606' 04/05/2024 09:40:13 am >> DELETE FROM ps_document_detail WHERE id_document = '91606' 04/05/2024 09:40:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91606' , '21618' , 'TRASMETTERE LA FEDE - SALZANO/ACUTIS' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 04/05/2024 09:40:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91606' , '20326' , 'SEGRETO DI MIO FIGLIO - A. ACUTIS' , '1' , '-1' , '4' , '10.90' , '10.9' , '0' , '5' , '10.36' ) 04/05/2024 09:40:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91606' , '17862' , 'DALLINFORMATICA AL CIELO C. ACUTIS - N. GORI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 04/05/2024 10:05:53 am >> SELECT document_num FROM ps_document WHERE document_num = '1425' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-04') 04/05/2024 10:05: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' , '1425' , '2024-05-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 04/05/2024 10:05: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 = '91607' 04/05/2024 10:05:53 am >> DELETE FROM ps_document_detail WHERE id_document = '91607' 04/05/2024 10:05: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 ( '91607' , '9576' , 'SANTA LUCIA CM 13 - 023SL/13' , '1' , '-1' , '1' , '9' , '7.3770491803279' , '22' , '0' , '9.00' ) 04/05/2024 10:32:25 am >> SELECT document_num FROM ps_document WHERE document_num = '1426' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-04') 04/05/2024 10:32: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' , '1426' , '2024-05-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.00' , '13.11' , NOW() , NOW() ) 04/05/2024 10:32: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 = '91608' 04/05/2024 10:32:25 am >> DELETE FROM ps_document_detail WHERE id_document = '91608' 04/05/2024 10:32: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 ( '91608' , '20122' , 'FATIMA CM 21 - 1033' , '1' , '-1' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '16.00' ) 04/05/2024 10:43:20 am >> SELECT document_num FROM ps_document WHERE document_num = '1427' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-04') 04/05/2024 10:43:21 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' , '1427' , '2024-05-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '560.00' , '461.41' , NOW() , NOW() ) 04/05/2024 10:43:21 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 = '91609' 04/05/2024 10:43:21 am >> DELETE FROM ps_document_detail WHERE id_document = '91609' 04/05/2024 10:43:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91609' , '16834' , 'LITURGICO CARTA 8GG' , '24' , '-24' , '1' , '3' , '2.4590163934426' , '22' , '0' , '72.00' ) 04/05/2024 10:43:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91609' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '188.7' , '154.67213114754' , '22' , '0' , '188.70' ) 04/05/2024 10:43:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91609' , '7202' , 'ARTICOLI RELIGIOSI' , '4' , '-4' , '1' , '70' , '57.377049180328' , '22' , '0' , '280.00' ) 04/05/2024 10:43:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91609' , '22129' , 'PADRE NOSTRO - L. EPICOCO' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 04/05/2024 10:43:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91609' , '15387' , 'VESTINA BATTESIMALE ' , '2' , '-2' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '6.00' ) 04/05/2024 10:46:21 am >> SELECT document_num FROM ps_document WHERE document_num = '1428' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-04') 04/05/2024 10:46:21 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' , '1428' , '2024-05-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.40' , '6.89' , NOW() , NOW() ) 04/05/2024 10:46:21 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 = '91610' 04/05/2024 10:46:21 am >> DELETE FROM ps_document_detail WHERE id_document = '91610' 04/05/2024 10:46:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91610' , '3073' , 'CROCE PRIMA COMUNIONE - LEGNO SCURO - 713/15' , '7' , '-7' , '1' , '1.2' , '0.98360655737705' , '22' , '0' , '8.40' ) 04/05/2024 11:02:31 am >> SELECT document_num FROM ps_document WHERE document_num = '1145' AND id_document != '91260' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-13') 04/05/2024 11:02:31 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1145', document_date = '2024-04-13', 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 = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '91260' 04/05/2024 11: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 = '91260' 04/05/2024 11:02:31 am >> DELETE FROM ps_document_detail WHERE id_document = '91260' 04/05/2024 11: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 ( '91260' , '15387' , 'VESTINA BATTESIMALE ' , '2' , '-2' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '5.00' ) 04/05/2024 11: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 ( '91260' , '20983' , 'CLERGY MM LIMITED 80/20' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 04/05/2024 11:02:58 am >> SELECT document_num FROM ps_document WHERE document_num = '1135' AND id_document != '91249' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-13') 04/05/2024 11:02:58 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1135', document_date = '2024-04-13', 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 = '53.00', price_tax_excluded = '43.44', date_upd = NOW() WHERE id_document = '91249' 04/05/2024 11:02:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91249' 04/05/2024 11:02:58 am >> DELETE FROM ps_document_detail WHERE id_document = '91249' 04/05/2024 11:02:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91249' , '15387' , 'VESTINA BATTESIMALE ' , '2' , '-2' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '5.00' ) 04/05/2024 11:02:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91249' , '22198' , 'CORONCINA PRIMA COMUNIONE - 3313' , '1' , '-1' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '8.00' ) 04/05/2024 11:02: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 ( '91249' , '20983' , 'CLERGY MM LIMITED 80/20' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 04/05/2024 11:03:32 am >> SELECT document_num FROM ps_document WHERE document_num = '1224' AND id_document != '91356' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-20') 04/05/2024 11:03:32 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1224', document_date = '2024-04-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 = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '91356' 04/05/2024 11:03:32 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91356' 04/05/2024 11:03:32 am >> DELETE FROM ps_document_detail WHERE id_document = '91356' 04/05/2024 11:03:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91356' , '3144' , 'CROCE TRILOBATA ' , '1' , '-1' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '4.50' ) 04/05/2024 11:03:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91356' , '21155' , 'BRACCIALE TENNIS + MEDAGLIA - 209' , '1' , '-1' , '1' , '2.9000' , '2.3770491803279' , '22' , '0' , '2.90' ) 04/05/2024 11:03:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91356' , '20983' , 'CLERGY MM LIMITED 80/20' , '1' , '-1' , '1' , '37.6' , '30.819672131148' , '22' , '0' , '37.60' ) 04/05/2024 11:04:33 am >> SELECT document_num FROM ps_document WHERE document_num = '1147' AND id_document != '91262' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-13') 04/05/2024 11:04:33 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1147', document_date = '2024-04-13', 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 = '55.00', price_tax_excluded = '45.08', date_upd = NOW() WHERE id_document = '91262' 04/05/2024 11:04:33 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 = '91262' 04/05/2024 11:04:33 am >> DELETE FROM ps_document_detail WHERE id_document = '91262' 04/05/2024 11:04:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91262' , '15387' , 'VESTINA BATTESIMALE ' , '22' , '-22' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '55.00' ) 04/05/2024 11:04:49 am >> SELECT document_num FROM ps_document WHERE document_num = '994' AND id_document != '91053' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-02') 04/05/2024 11:04:50 am >> UPDATE ps_document SET id_document_type = '11', document_num = '994', document_date = '2024-04-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 = '63.00', price_tax_excluded = '51.64', date_upd = NOW() WHERE id_document = '91053' 04/05/2024 11:04:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91053' 04/05/2024 11:04:50 am >> DELETE FROM ps_document_detail WHERE id_document = '91053' 04/05/2024 11:04:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91053' , '15387' , 'VESTINA BATTESIMALE ' , '5' , '-5' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '15.00' ) 04/05/2024 11:04:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91053' , '22198' , 'CORONCINA PRIMA COMUNIONE - 3313' , '1' , '-1' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '8.00' ) 04/05/2024 11:04:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91053' , '17087' , 'POLO COTONE MM' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 04/05/2024 11:05:28 am >> SELECT document_num FROM ps_document WHERE document_num = '814' AND id_document != '90839' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-19') 04/05/2024 11:05:28 am >> UPDATE ps_document SET id_document_type = '11', document_num = '814', document_date = '2024-03-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '-1', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '152.75', price_tax_excluded = '127.16', date_upd = NOW() WHERE id_document = '90839' 04/05/2024 11:05:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90839' 04/05/2024 11:05:28 am >> DELETE FROM ps_document_detail WHERE id_document = '90839' 04/05/2024 11:05:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90839' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 04/05/2024 11:05:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90839' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.9000' , '14.672131147541' , '22' , '0' , '35.80' ) 04/05/2024 11:05:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90839' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 04/05/2024 11:05:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90839' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 04/05/2024 11:05:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90839' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 04/05/2024 11:05:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90839' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '1' , '-1' , '3' , '3.3000' , '3.1730769230769' , '4' , '0' , '3.30' ) 04/05/2024 11:05:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90839' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 04/05/2024 11:05:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90839' , '15387' , 'VESTINA BATTESIMALE ' , '5' , '-5' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '15.00' ) 04/05/2024 11:05:54 am >> SELECT document_num FROM ps_document WHERE document_num = '1249' AND id_document != '91384' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-23') 04/05/2024 11:05:54 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1249', document_date = '2024-04-23', 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 = '27.00', price_tax_excluded = '22.13', date_upd = NOW() WHERE id_document = '91384' 04/05/2024 11:05: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 = '91384' 04/05/2024 11:05:54 am >> DELETE FROM ps_document_detail WHERE id_document = '91384' 04/05/2024 11:05: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 ( '91384' , '15387' , 'VESTINA BATTESIMALE ' , '9' , '-9' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '27.00' ) 04/05/2024 11:07:41 am >> SELECT document_num FROM ps_document WHERE document_num = '647' AND id_document != '90625' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-05') 04/05/2024 11:07:42 am >> UPDATE ps_document SET id_document_type = '11', document_num = '647', document_date = '2024-03-05', 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 = '55.00', price_tax_excluded = '55.00', date_upd = NOW() WHERE id_document = '90625' 04/05/2024 11:07:42 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90625' 04/05/2024 11:07:42 am >> DELETE FROM ps_document_detail WHERE id_document = '90625' 04/05/2024 11:07:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90625' , '3433' , 'DIECI COMANDAMENTI' , '20' , '-20' , '4' , '0.2000' , '0.2' , '0' , '0' , '4.00' ) 04/05/2024 11:07:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90625' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.46' , '0.46' , '0' , '0' , '0.46' ) 04/05/2024 11:07:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90625' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '19' , '-19' , '4' , '2.80' , '2.8' , '0' , '5' , '50.54' ) 04/05/2024 11:08:46 am >> SELECT document_num FROM ps_document WHERE document_num = '656' AND id_document != '90641' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-06') 04/05/2024 11:08:46 am >> UPDATE ps_document SET id_document_type = '11', document_num = '656', document_date = '2024-03-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 = '66.16', price_tax_excluded = '66.16', date_upd = NOW() WHERE id_document = '90641' 04/05/2024 11:08:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90641' 04/05/2024 11:08:46 am >> DELETE FROM ps_document_detail WHERE id_document = '90641' 04/05/2024 11:08:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90641' , '22192' , 'PREGHIERA DI GESU' , '1' , '-1' , '4' , '8.5000' , '8.5' , '0' , '5' , '8.08' ) 04/05/2024 11:08:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90641' , '22191' , 'PREGARE CON I SALMI' , '1' , '-1' , '4' , '8.5000' , '8.5' , '0' , '5' , '8.08' ) 04/05/2024 11:08:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90641' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '-1' , '4' , '2.12' , '2.12' , '0' , '0' , '2.12' ) 04/05/2024 11:08:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90641' , '15317' , 'SACRAMENTI SPIEGATI AI RAGAZZI - LA COMUNIONE' , '28' , '-28' , '4' , '1.80' , '1.8' , '0' , '5' , '47.88' ) 04/05/2024 11:09:13 am >> SELECT document_num FROM ps_document WHERE document_num = '746' AND id_document != '90753' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-13') 04/05/2024 11:09:13 am >> UPDATE ps_document SET id_document_type = '11', document_num = '746', document_date = '2024-03-13', 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 = '40.00', price_tax_excluded = '38.53', date_upd = NOW() WHERE id_document = '90753' 04/05/2024 11:09:13 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 = '90753' 04/05/2024 11:09:13 am >> DELETE FROM ps_document_detail WHERE id_document = '90753' 04/05/2024 11:09:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90753' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 04/05/2024 11:09:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90753' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 04/05/2024 11:09:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90753' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '5' , '-5' , '4' , '0.7000' , '0.7' , '0' , '0' , '3.50' ) 04/05/2024 11:09:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90753' , '15317' , 'SACRAMENTI SPIEGATI AI RAGAZZI - LA COMUNIONE' , '10' , '-10' , '4' , '1.5' , '1.5' , '0' , '0' , '15.00' ) 04/05/2024 11:09:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90753' , '6809' , 'MOCCOLO 60X165' , '1' , '-1' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '4.50' ) 04/05/2024 11:09:37 am >> SELECT document_num FROM ps_document WHERE document_num = '766' AND id_document != '90777' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-15') 04/05/2024 11:09:37 am >> UPDATE ps_document SET id_document_type = '11', document_num = '766', document_date = '2024-03-15', 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 = '194.90', price_tax_excluded = '180.64', date_upd = NOW() WHERE id_document = '90777' 04/05/2024 11:09: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 = '90777' 04/05/2024 11:09:37 am >> DELETE FROM ps_document_detail WHERE id_document = '90777' 04/05/2024 11:09: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 ( '90777' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '46.0000' , '37.704918032787' , '22' , '0' , '46.00' ) 04/05/2024 11:09: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 ( '90777' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '10.50' ) 04/05/2024 11:09: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 ( '90777' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 04/05/2024 11:09: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 ( '90777' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 04/05/2024 11:09: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 ( '90777' , '18748' , 'OSTIA MAGNA 125 - OM 125' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 04/05/2024 11:09: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 ( '90777' , '15317' , 'SACRAMENTI SPIEGATI AI RAGAZZI - LA COMUNIONE' , '10' , '-10' , '4' , '1.80' , '1.8' , '0' , '0' , '18.00' ) 04/05/2024 11:09: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 ( '90777' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.6000' , '2.9508196721311' , '22' , '0' , '3.60' ) 04/05/2024 11:09: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 ( '90777' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' , '-1' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '25.00' ) 04/05/2024 11:09: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 ( '90777' , '22204' , 'COSA E LA PREGHIERA? - R. CASTILLO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 04/05/2024 11:09: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 ( '90777' , '6962' , 'NELLA CASA DEL DEFUNTO' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 04/05/2024 11:09: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 ( '90777' , '12588' , 'QUANDO DIO NON PERDONA - S. SESSA' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '5' , '3.80' ) 04/05/2024 11:09: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 ( '90777' , '20426' , 'PERCHE CREDERE? - F. SHEEN' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 04/05/2024 11:09: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 ( '90777' , '21038' , 'CONVERSAZIONI SULLA CHIESA' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 04/05/2024 11:09: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 ( '90777' , '21074' , 'SACERDOZIO MINISTERO E VITA ' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '5' , '28.50' ) 04/05/2024 11:10:40 am >> DELETE FROM ps_document WHERE id_document = '91503' 04/05/2024 11:10:40 am >> DELETE FROM ps_document_detail WHERE id_document = '91503' 04/05/2024 11:25:04 am >> SELECT document_num FROM ps_document WHERE document_num = '1429' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-04') 04/05/2024 11:25:04 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' , '1429' , '2024-05-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 04/05/2024 11:25:04 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 = '91611' 04/05/2024 11:25:04 am >> DELETE FROM ps_document_detail WHERE id_document = '91611' 04/05/2024 11:25:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91611' , '20981' , 'PAROLE DI GESU - U. GALIMBERTI' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 04/05/2024 11:42:25 am >> SELECT document_num FROM ps_document WHERE document_num = '1430' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-04') 04/05/2024 11:42: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' , '1430' , '2024-05-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.71' , '27.75' , NOW() , NOW() ) 04/05/2024 11:42: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 = '91612' 04/05/2024 11:42:25 am >> DELETE FROM ps_document_detail WHERE id_document = '91612' 04/05/2024 11:42: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 ( '91612' , '22167' , 'AMEN - MAG. 2024' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 04/05/2024 11:42: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 ( '91612' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 04/05/2024 11:42: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 ( '91612' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 04/05/2024 11:54:44 am >> SELECT document_num FROM ps_document WHERE document_num = '1431' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-04') 04/05/2024 11:54:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1431' , '2024-05-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '9.84' , NOW() , NOW() ) 04/05/2024 11:54:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91613' 04/05/2024 11:54:44 am >> DELETE FROM ps_document_detail WHERE id_document = '91613' 04/05/2024 11:54:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91613' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '2' , '-2' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '12.00' ) 04/05/2024 12:06:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '1432' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-04') 04/05/2024 12:06:41 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' , '1432' , '2024-05-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 04/05/2024 12:06:41 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 = '91614' 04/05/2024 12:06:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '91614' 04/05/2024 12:06:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91614' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 04/05/2024 12:06:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91614' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 04/05/2024 12:14:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '1433' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-04') 04/05/2024 12:14:28 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1433' , '2024-05-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.30' , '21.53' , NOW() , NOW() ) 04/05/2024 12:14:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91615' 04/05/2024 12:14:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '91615' 04/05/2024 12:14:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91615' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 04/05/2024 12:14:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91615' , '21012' , 'PECORELLA SMARRITA' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 04/05/2024 12:14:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91615' , '21014' , 'GESU E LA TEMPESTA' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 04/05/2024 12:14:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91615' , '21013' , 'PADRE NOSTRO' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 04/05/2024 12:14:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91615' , '21005' , 'ARCA DI NOE' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 04/05/2024 12:14:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91615' , '21004' , 'CREAZIONE' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 04/05/2024 12:14:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91615' , '21006' , 'MOSE E MIRIAM' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 04/05/2024 12:14:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91615' , '21009' , 'DANIELE E I LEONI' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 04/05/2024 12:14:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91615' , '21011' , 'BUON SAMARITANO' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 04/05/2024 12:14:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91615' , '21016' , 'DAVIDE E GOLIA' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 04/05/2024 12:19:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '1434' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-04') 04/05/2024 12:19:09 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1434' , '2024-05-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '10.66' , NOW() , NOW() ) 04/05/2024 12:19: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 = '91616' 04/05/2024 12:19:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '91616' 04/05/2024 12:19: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 ( '91616' , '15206' , 'ANELLO CROCE/MIRACOLOSA' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 04/05/2024 12:28:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '1435' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-04') 04/05/2024 12:28:23 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' , '1435' , '2024-05-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.70' , '35.87' , NOW() , NOW() ) 04/05/2024 12:28: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 = '91617' 04/05/2024 12:28:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '91617' 04/05/2024 12:28: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 ( '91617' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 04/05/2024 12:28: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 ( '91617' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 04/05/2024 12:28: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 ( '91617' , '22402' , 'REGNO DI DIO E UNA SFIDA - F.J. SHEEN' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 04/05/2024 12:38:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '1436' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-04') 04/05/2024 12:38:54 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' , '1436' , '2024-05-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 04/05/2024 12:38:54 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 = '91618' 04/05/2024 12:38:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '91618' 04/05/2024 12:38:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91618' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 04/05/2024 12:53:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400327502' AND id_product != '19318' AND ean13 != '' 04/05/2024 12:53:25 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400327502', date_upd = NOW() WHERE id_product = '19318' 04/05/2024 12:53:25 pm >> UPDATE ps_product_lang SET name = 'ANGELO ALI TORTORA - 4230 ', description = '' WHERE id_product = '19318' 04/05/2024 12:53:25 pm >> UPDATE ps_product SET wholesale_price = '3.60', on_sale = '0', price = '8.19672131147541' WHERE id_product = '19318' 04/05/2024 12:53:25 pm >> UPDATE ps_product_shop SET wholesale_price = '3.60', price = '8.19672131147541', id_tax_rules_group = '1', id_category_default = '95', 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 = '19318' 04/05/2024 12:53:25 pm >> DELETE FROM ps_specific_price WHERE id_product = '19318'