select distinct c.contragent.personalAccount, c.contragent.name, c.realEstate.address, c.contragent.headPersonPhone, c.contragent.contactPersonPhone, c.contragent.phone, c.contragent.contactPersonPhoneVerified, c.contragent.contactPersonEmail, c.contragent.headPersonEmail from rtneo$ContragentRealEstate c where lower(c.realEstate.address) like lower('%%бохан%%') and (lower(c.realEstate.address) like lower('%%карла%%') or lower(c.realEstate.address) like lower('%%ленина%%')) and (select count(cre) from rtneo$ContragentRealEstate cre where cre.contragent = c.contragent and (c.category.isLiving is null or c.category.isLiving = false))>0