select r.NAME, f.NAME, t.RDB$TRIGGER_NAME
from (select RDB$RELATION_NAME
      from RDB$RELATIONS
      where RDB$RELATION_NAME = 'RDB$RELATIONS'
      union all
      select null
      from RDB$DATABASE) as r(NAME)
left join (select RDB$FIELD_NAME
           from RDB$RELATION_FIELDS
           where RDB$RELATION_NAME = 'RDB$RELATIONS'
           union all
           select null
           from RDB$DATABASE) as f(NAME) on r.NAME is null
left join RDB$TRIGGERS t on t.RDB$RELATION_NAME = 'RDB$RELATIONS' and f.NAME is null and r.NAME is null

select r.NAME, r.ID, f.NAME, f.ID, t.RDB$TRIGGER_NAME, t.RDB$TRIGGER_TYPE
from (select RDB$RELATION_NAME, RDB$RELATION_ID
      from RDB$RELATIONS
      where RDB$RELATION_NAME = 'RDB$RELATIONS'
      union all
      select null, null
      from RDB$DATABASE) as r(NAME, ID)
left join (select RDB$FIELD_NAME, RDB$FIELD_ID
           from RDB$RELATION_FIELDS
           where RDB$RELATION_NAME = 'RDB$RELATIONS'
           union all
           select null, null
           from RDB$DATABASE) as f(NAME, ID) on r.NAME is null
left join RDB$TRIGGERS t on t.RDB$RELATION_NAME = 'RDB$RELATIONS' and f.NAME is null and r.NAME is null

select cast('<?xml version="1.0" encoding="Windows-1251" ?>' as varchar(1000))
from RDB$DATABASE
union all
select cast('<root day="'||c.FULL_DATE||'" shift="'||s.NAME||'" filter="'||ef.NAME||'" >' as varchar(1000))
from RDB$DATABASE
join CALENDAR c on c.ID_DAY = :"Дата"
join SHIFTS s on s.ID_SH = :"Смена"
join EMPLOYEE_FILTER ef on ef.ID_F = :"Фильтр" 
union all
select cast('<nodes>' as varchar(1000))
from RDB$DATABASE
union all
select cast('  <node '||
                 'fio="'||(select OUT_STR from XML$FORMAT_STR(e.FULL_NAME))||'" '||
                 'rang="'||(select OUT_STR from XML$FORMAT_STR(e.RANG))||'" '||
                 'tab="'||(select OUT_STR from XML$FORMAT_STR(e.TABEL))||'" '||
                 'dep="'||(select OUT_STR from XML$FORMAT_STR(coalesce((select NEW_NAME from TABEL$GET_FULL_DEP(eh.ID_EG, null, 0)),'')))||'" '||
                 'wtt="'||(select OUT_STR from XML$FORMAT_STR(wtt.NAME))||'" '||
                 'dur="'||cast(coalesce(fi.CALC_INTERVAL,0) as numeric(15,4))||'" />' as varchar(1000))
from EMPLOYEE e
join TABEL$EMPLOYEE_HISTORY eh on eh.ID_EMP = e.ID_EMP and eh.ACTUAL = 1 
join EMPLOYEE_FILTERED ef on ef.ID_EMP = e.ID_EMP and ef.ID_F = :"Фильтр"
join TABEL$FORECAST fc on fc.ID_EMP = e.ID_EMP
                      and fc.ID_DAY = :"Дата"
                      and fc.ID_TF = (select ID_TF from TABEL$GET_LAST_DOC(:"Дата", e.ID_EMP, 1))
join TABEL$FORECAST_INTERVALS fi on fi.ID_TF = fc.ID_TF
join TABEL$WORK_TIME_TYPES wtt on wtt.ID_WTT = fi.ID_WTT and wtt.ON_TER = 1
join TABEL$SHIFT_INTERVALS si on si.ID_SI = fi.ID_SI and si.ID_SH = :"Смена"
union all
select cast('</nodes>' as varchar(1000))
from RDB$DATABASE
union all
select cast('</root>' as varchar(1000))
from RDB$DATABASE