select  *from supp.lek_new limit 100;
drop table  supp.lek;

select * from md_benefit_inn where id = 2868;
select * from md_benefit_detalization order by aud_when desc ;
select * from md_benefit_detalization where inn_id = 2868;
select code from md_benefit_detalization where id = 2701;


select * from md_benefit_detalization where inn_id = 2868;
select * from cmn_finder where code = 'innFinderBenefit';



select mbd.code::character varying , trim (lek."C_MNN") ,
mbi.* from md_benefit_detalization mbd
join md_benefit_inn mbi on mbi.id = mbd.inn_id
join supp.lek_new lek on lek."NAME_MNN" = mbi.rus_name
--and mbd.code::character varying = trim (lek."C_MNN")
and


select bi.id, bi.rus_name||' '||bi.latin_Name from md_benefit_inn bi	where bi.benefit_type_id = :type and upper(bi.rus_name)||' '||upper(bi.latin_name) like '%'||upper(:text)||'%'
                and (current_date between coalesce(bi.add_date, current_date) and coalesce(bi.delete_date, current_date))





 update md_benefit_detalization set code = '          600' where id = 2701


with cte as (
select distinct ( mbd.id) mbd_id,  mbd.code mbd_code, lek."C_MNN1" ,
mbi.* from md_benefit_detalization mbd
join md_benefit_inn mbi on mbi.id = mbd.inn_id
join supp.lek_new lek on lek."NAME_MNN" = mbi.rus_name
--and lek."NAME_MNN" = 'Такролимус'
order by ( mbd.id))

--select cte.mbd_id, cte.mbd_code from cte
update md_benefit_detalization mbd set code = cte.mbd_code
from cte
where mbd.id = cte.mbd_id