MyTetra Share
Делитесь знаниями!
Юле
Время создания: 23.09.2020 10:22
Раздел: INFO - JOB - rtneo - Выгрузки
Запись: wwwlir/Tetra/master/base/1600827721akhdnkzvte/text.html на raw.githubusercontent.com

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

Так же в этом разделе:
 
MyTetra Share v.0.55
Яндекс индекс цитирования