select typ_mod_id , typ_id from tof_types
join tof_link_la_typ
     on typ_id=lat_typ_id
  join tof_link_art
     on lat_la_id=la_id
     and la_art_id = $nmb

select lat_typ_id
 from tof_link_la_typ
 where
 lat_ctm subrange( 185  cast integer) =  1 

select str_id,
       str_level,
       str_sort,
        0  expand,
       tex_text,
       str_id_parent,
        0  color
  from tof_search_tree
  join tof_designations
    on str_des_id nljoin des_id and
       des_lng_id =  16 
  join tof_des_texts
    on des_tex_id nljoin tex_id
 where  1  <  3  and
       str_type =  1  and
       str_level >  1  and
       (select nvl(max(lgs_ga_id),  0 )
                 from tof_link_ga_str
                 join tof_link_la_typ
                   on lgs_ga_id nljoin lat_ga_id and
                      lat_typ_id = номер машины
                where lgs_str_id = str_id and
                      (- 1  <  0  or lgs_ga_id in (- 1 ))) >  0 

  str_level,
       str_sort,
       tex_text,
             str_id_parent,

  from TECDOC_TOF_SEARCH_TREE
  join TECDOC_TOF_DESIGNATIONS
    on str_des_id = des_id
  join TECDOC_TOF_DES_TEXTS
    on des_tex_id = tex_id
 where        str_type =  1  and
       str_level >  1  and
       (select ifnull(max(lgs_ga_id),  0 )
                 from TECDOC_TOF_LINK_GA_STR
                 join TECDOC_TOF_LINK_LA_TYP
                   on lgs_ga_id = lat_ga_id and
                      lat_typ_id = номер машины
                where lgs_str_id = str_id ) >  0