select

count(distinct cts)

from

(

select

rct

from

(rtneo_contract rc

join rtneo_contragent rct on

rc.contragent_id = rct.id)

where

(rc.delete_ts is null

and rct.delete_ts is null)

and rc."template" = 'MSG310820'

union all

select

rct

from

rtneo_contragent rct

join rtneo_entityes_temporary_set rets2 on

rct.id = rets2.entity_id

where

rct.delete_ts is null

and rets2.delete_ts is null

and rets2.entity_name = 'Contragent') as cts;