insert

into

rtneo_entityes_temporary_set (entity_id, id, entity_name, set_name, set_comment, version, create_ts) (

select

distinct contragent.id1, newid(), 'Contragent', 'AllContragentCreateContract_15-10-20', 'Все контрагенты с объектами без договоров(без жилых и з.у.)', 1, now()

from

(

select

distinct cts.id as id1

from

(

select

cre.contragent_id as id

from

(rtneo_contragent_real_estate cre

join rtneo_real_estate re on

cre.real_estate_id = re.id

join rtneo_real_estate_category rec on

rec.id = cre.category_id)

left join rtneo_contract_position cp on

cre.id = cp.contragent_real_estate_id

where

cre.delete_ts is null

and cp.delete_ts is null

and cp is null

and not re."name" = 'Земельный участок'

and (rec.is_living is null

or rec.is_living = false) ) as cts ) as contragent)