select id, pid, name, link, a1, a2 from ... where ... order by ... 
All column names must use aliases shown above (e.g. id, pid, name, link, a1, a2)
You must select at least  4  columns (e.g. id, pid, name, link)
All PID (parent ID) referenced must also be ID's
Ordering controls only the items of a single node
Example:
select empno id, mgr pid, ename name, null link
from emp
order by ename

select "ИД" id, 
       "ОТД_ИД" pid, 
       "КОРОТКОЕ_ИМЯ" name, 
       'f?p=&APP_ID.:1:&SESSION.::NO::P1_OTD:'||ОТД_ИМЯ(ИД)||' ' link, 
       null a1, 
       null a2 
from "#OWNER#"."ТФВ_ОТДЕЛЫ"
order by ОТД_ИМЯ(ИД)