select c.id, c.contragent.name, c.realEstate.name, c.realEstate.address, c.realEstate.cadastralNumber from rtneo$ContragentRealEstate c where c.category is null and (not lower(c.realEstate.address) like '%%земельный%%' and not lower(c.realEstate.name) like '%%земельный%%') order by c.realEstate.cadastralNumber