Tabulky - IFC_CLASS - X_PROPERTY_SET_CLASS - X_PROPERTY_SET_PROPERTY

select
    10*C.ID+case ClassType when 'C' then 2 when 'S' then 3 when 'E' then 4 else 1 end Raddr, -- 1-4 ~ C ... class/caststavby/skupelementu/element
    C.ID,
    C.Parent_ID,
    0 Lvl,
    --
    C.Kdo,
    C.Kdy,
    To_Char(C.Kdy,'dd.mm.yyyy') Kdy_DMR,
    To_Char(C.Kdy,'dd.mm.yyyy hh24:mi') Kdy_DMRHM,
    --
    C.Visible,
    case when C.Visible like '%I%' then 'Y' else 'N' end is_I,
    case when C.Visible like '%P%' then 'Y' else 'N' end is_P,
    case when C.Visible like '%S%' then 'Y' else 'N' end is_S,
    case when C.Visible like '%Z%' then 'Y' else 'N' end is_Z,
    --
    C.ifdGuid,
    C.IfcIdent,
    C.ClassType, -- E/S/C
    case C.ClassType when 'E' then 'Element' when 'S' then 'Skupina elem.' when 'C' then 'Část stavby' end ClassType_Txt,
    C.Name,
    C.Name_CZ,
    C.Definition,
    case when length(C.Definition)>50 then rtrim(substr(C.Definition,1,47))||'...' else C.Definition end Def50,
    case when length(C.Definition)>100 then rtrim(substr(C.Definition,1,97))||'...' else C.Definition end Def100,
    C.Definition_CZ,
    case when length(C.Definition_CZ)>50 then rtrim(substr(C.Definition_CZ,1,47))||'...' else C.Definition_CZ end Def50_CZ,
    case when length(C.Definition_CZ)>100 then rtrim(substr(C.Definition_CZ,1,97))||'...' else C.Definition_CZ end Def100_CZ,
  --C.Repres,
  --C.IfcRepres,
  --C.Prec,
  --C.PrecV,
  --C.Prec||case when C.PrecV is not null and C.PrecV<>C.Prec then '/'||C.PrecV end Precision, -- P2/P3, pokud se presnosti lisi
    ( select
          count(*)
        from
          X_Property_Set_Class X
        where X.Class_ID=C.ID
    ) PropertySetNr,
    ( select
          count(distinct Y.Property_ID)
        from
          X_Property_Set_Class X,
          X_Property_Set_Property Y
        where X.Class_ID=C.ID
          and Y.Property_Set_ID=X.Property_Set_ID
    ) PropertyNr
  from
    IFC_Class C