with double_coo_id as
( select id from public.house_coordinates,
(select count(hc.id) cnt, hc.latitude lat, hc.longitude long
 from public.house_coordinates hc
group by hc.latitude, hc.longitude
having count(hc.id) > 3) doubles_coo
 where 1=1
 and latitude = doubles_coo.lat and longitude = doubles_coo.long
)     

select eah.orponid, eah.adr_adm_ter, dci.*
from public.ent_as_house eah, double_coo_id dci
where 1=1
and livestatus = 1
and parent_id is not null
and coordinates_id = dci.id
;

CREATE TABLE #tmpCities
(Nomer INT,
City_name VARCHAR(50),
Count_people int);

INSERT INTO #tmpCities
VALUES (1, 'Москва г', 12506),
(2, 'Санкт-Петербург г', 5352),
(3, 'Новосибирск г', 1613),
(4, 'Екатеринбург г', 1469),
(5, 'Нижний Новгород г', 1259),
(6, 'Казань г', 1244);

with double_coo_id as( 
	select 
		c.id 
	from 
		public.house_coordinates c,
		(select count(hc.id) cnt, hc.latitude lat, hc.longitude long from public.house_coordinates hc group by hc.latitude, hc.longitude having count(hc.id) > 3) doubles_coo
	where 
		1=1
		and c.latitude = doubles_coo.lat 
		and c.longitude = doubles_coo.long
) 
select 
	eah.orponid
	, eah.adr_adm_ter
	, dci.*
from 
	public.ent_as_house eah
	, double_coo_id dci
	, #tmpCities tc 
where 
	1=1
	and eah.livestatus = 1
	and eah.parent_id is not null
	and eah.coordinates_id = dci.id
	and eah.adr_adm_ter like '%' + tc.City_name + '%'
order by
	ct.Nomer 
;

Select CONCAT ('п','р','и','м','е','р')