Помещения в Абакане

SELECT
o.NAME "Наим"
--,o.ADR_DESC "Адр"
,o.ADR_PRN_DESC "АдрСв"
,r.S_DATE "Дата"
,DECODE(r.TYPE_CODE,r.TYPE_CODE,(SELECT RV.NAME FROM RT_RIGHTS_VOC rv WHERE rv.code=r.type_code)) "ТипПрава"
,r.part "Часть"
--,r.REG_NO "РегНо"
,Ent.con_desc(en.ID) "Правообладатель"
 
FROM
RE_OBJECTS o
,RT_RIGHTS r
,RT_ENT rte
,ENT_ENTITIES en
WHERE
o.ID=r.re_id
AND rte.RT_ID=r.ID
AND rte.ENT_ID = en.ID
AND o.R_TYPE=3 --часть
AND r.R_GROUP = 'П'
AND
  (
      r.e_DATE IS NULL
   OR (
        r.e_date > TO_DATE ('01.01.2011', 'dd.mm.yyyy')
        AND r.s_date < TO_DATE ('01.01.2011', 'dd.mm.yyyy')
      )
  )
AND LOWER(o.NAME) NOT LIKE '%погреб%'
AND LOWER(o.NAME) NOT LIKE '%гараж%'
AND LOWER(o.NAME) NOT LIKE '%подвал%'
AND LOWER(o.ADR_DESC) NOT LIKE '%усть-%'
    
AND LOWER(o.ADR_PRN_DESC) LIKE '%абакан%'
 
ORDER BY o.ADR_DESC