select 
    str_id, str_level, str_sort, tex_text, str_id_parent
from 
    tof_search_tree
    join tof_link_sho_str
        on lss_str_id = str_id and lss_sho_id =  9 
    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 
    str_type =  1  and str_level >  1  and 
exists (
select  1  from tof_link_ga_str
    join tof_link_la_typ
        on lgs_ga_id nljoin lat_ga_id and lat_typ_id =  17143 
where lgs_str_id = str_id)

ORDER BY STR_SORT