select --n.node_id,
       o.object_id,
       --c.class_name,
       --w.well_number,
       o.firm_owner_id
       --f.firm_name,
       --r.region_tree_name || ',' || s.street_name || ', ' || b.house || ', ' ||b.corpus as Адрес
  from well       w,
       node       n,
       region_l   r,
       street_l   s,
       building_l b,
       object     o,
       firm       f,
       class      c
 where w.node_id = n.node_id
   and n.building_id = b.object_id
   and n.node_id = o.object_id
   and o.firm_owner_id = f.firm_id
   and b.region_id = r.object_id
   and n.node_type_id = c.class_id
   and b.street_id = s.object_id
   and r.region_tree_name like 'Сосновый Бор%'
 order by 1