SELECT (OP.NAME || ' ' || COALESCE(A.FLOORS || '- ', '') || lower(T.NAME) || '   ,   ' || R.NAME ||
       COALESCE(',  : ' || M.NAME, '') ||
       COALESCE(',    ' || A.YEAR_OF_BUILD || ' ', '') ||
       COALESCE('.   - ' || CAST(A.AREA_G AS FLOAT3) || ' . .', '') ||
       COALESCE(',   - ' || CAST(A.AREA_I AS FLOAT3) || ' . .', '') ||
       COALESCE(',  - ' || CAST(A.AREA_K AS FLOAT3) || ' . ', '') ||
       COALESCE('.   - ' || CAST(A.S_AREA AS FLOAT3) || ' ', '') ||
       IIF(A.CEILING_HEIGHT > 0, COALESCE('.  - ' || CAST(A.CEILING_HEIGHT AS FLOAT3) || ' ', ''), '') ||
       COALESCE('.  - ' || lower(PL.NAME), '') ||
       COALESCE('.   - ' || lower(ST.NAME), '') ||
       COALESCE('.  ' || lower(G.NAME), '') ||
       COALESCE(',  ' || lower(W.NAME), '') ||
       COALESCE(',  - ' || lower(SW.NAME), '') ||
       IIF(A.DIST_REGION > 0, COALESCE('.   ' || A.DIST_REGION || ' .', ''), '.' )


--       ',  ' || CAST(A.PRICE AS INTEGER) || COALESCE(', ' || CASE A.BARGAIN WHEN 1 THEN '' END , '')||
       ) AD FROM APART A

     LEFT JOIN REGIONS              R       ON A.ID_REGION = R.ID
     LEFT JOIN MATERIALS            M       ON A.ID_MATERIALS = M.ID
     LEFT JOIN STATE                ST      ON A.ID_STATE = ST.ID
     LEFT JOIN TYPES                T       ON A.ID_TYPE = T.ID
     LEFT JOIN OPERATION            OP      ON A.ID_OPERATION = OP.ID
--     LEFT JOIN TCURRENCY            CU      ON A.ID_CURRENCY = CU.ID
     LEFT JOIN RAZDEL               PL      ON A.ID_RAZDEL = PL.ID
     LEFT JOIN GAZ                  G       ON A.ID_GAZ = G.ID
     LEFT JOIN WATER                W       ON A.ID_WATER = W.ID
     LEFT JOIN SEWERAGE             SW      ON A.ID_SEWERAGE = SW.ID


--COALESCE(A.ROOMS_Q || '-. ', '')
      WHERE A.ID = :ID