whitekatanasharp

--Б1.
SELECT ao.* FROM gar.adm_hierarchy as ah
INNER JOIN gar.address_objects as ao ON ah.objectId = ao.objectId
WHERE ah.parentobjid = 1325538 AND ah.isactive AND ao.isactive 
 AND ao.typename = 'ул' AND ao.name ILIKE 'Л%'
ORDER BY ao.name ASC

--Б2.
WITH a AS (
 SELECT objectid,