Сделки с-х земель с ценами ипотек и аренд

select
(select max(O.ADR_PRN_DESC) from re_objects o 
 where o.id in (select r.re_id from rt_rights r where r.re_id = o.id and R.BRG_ID = b.id) 
)"Адрес"
,(select max(case
     when o.TSQ_UNITS=10 then O.TOTAL_SQ
     when o.TSQ_UNITS=20 then O.TOTAL_SQ*10000
   end) from re_objects o 
 where o.id in (select r.re_id from rt_rights r where r.re_id = o.id and R.BRG_ID = b.id) 
)"Площадь"
,decode(b.TYPE_CODE,b.TYPE_CODE,(select BV.NAME from BRG_BARGAINS_VOC bv where bv.code=b.type_code)) "ТипСделки"
,B.REG_NO "РегНоСд"
,(select max(r.RE_PRICE) from rt_rights r where r.brg_id= b.id and r.type_code = 204)"ЦенаУчСд"
,(select max(r.PRICE_DESC) from rt_rights r where r.brg_id= b.id and r.type_code = 204)"ЦенаУчСдОп"
,(select max(r.RE_PRICE) from rt_rights r where r.brg_id= b.id and r.type_code = 202)"ЦенаИп"
,(select max(r.PRICE_DESC) from rt_rights r where r.brg_id= b.id and r.type_code = 202)"ЦенаИпОп"
,(select wm_concat( (case 
                            when r.RS_DESC is null then ' '
                            else substr(to_char(r.RS_DESC),1,200)
                            end) 
                  ||',') from rt_rights r where r.brg_id= b.id and ROWNUM <  20 )"ПредметСд"
from
brg_bargains b
where
b.id in
(
select R.BRG_ID 
from
re_objects o
,rt_rights r
,re_purposes rps

where
r.re_id = o.id
and O.R_TYPE = 1
and rps.re_id = o.id
and RPS.TYPE_CODE like '11____'

) 

and b.S_DATE between TO_DATE ('&start#', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')