DECLARE @LOCALE VARCHAR(10)
DECLARE @CONF_ID BIGINT
SELECT @LOCALE = eu.locale FROM EAP_USER eu WHERE eu.ID = 1
SELECT @CONF_ID = ID FROM CONF_TABLE conf WHERE conf.NAME = 'WR_NOTE_SUMMARY'

SELECT
    prop.ID
    , prop.PROPERTY
    , ISNULL(l.VALUE, prop.LABEL) AS LABEL
    , ISNULL(userProp.VALUE, prop.VALUE) AS VALUE
    , LEVEL1.*
FROM CONF_TABLE_PROPERTIES prop
  LEFT JOIN LOCALIZATION l ON l.KEY_ = prop.LABEL AND l.LOCALE = @LOCALE
  LEFT JOIN USER_CONF_TABLE_PROPERTIES userProp ON userProp.CONF_TABLE_PROPERTIES_ID = prop.id AND userProp.USER_ID = 1
  OUTER APPLY
    (
      SELECT
          prop1.ID
          , prop1.PROPERTY
          , ISNULL(l.VALUE, prop1.LABEL) AS LABEL
          , ISNULL(userProp.VALUE, prop1.VALUE) AS VALUE
      FROM CONF_TABLE_PROPERTIES prop1
        LEFT JOIN LOCALIZATION l ON l.KEY_ = prop1.LABEL AND l.LOCALE = @LOCALE
        LEFT JOIN USER_CONF_TABLE_PROPERTIES userProp ON userProp.CONF_TABLE_PROPERTIES_ID = prop1.id AND userProp.USER_ID = 1
      WHERE prop1.CONF_TABLE_ID = @CONF_ID
        AND prop1.HID.GetAncestor(1) = prop.HID
    ) LEVEL1
WHERE prop.HID.GetLevel() = 1
    AND prop.CONF_TABLE_ID = @CONF_ID
ORDER BY prop.HID
FOR JSON AUTO