Untitled

SELECT js.key, js.value FROM classifiers.cl_item_text cit, json_each_text(cit.name::json -> 'error') js
WHERE cit.language = 'ET'
  AND cit.id_item IN (
    SELECT ci.id FROM classifiers.cl_item ci
    WHERE ci.id_definition IN (
        SELECT def.id FROM classifiers.cl_definition def
        WHERE def.code = 'RAKENDUSE_TOLKED'
    )
      AND ci.code = 'TOLKED'
)
AND js.value = 'Hooned: andmete kinnitamiseks peab olema määratud õppeasutuse peahoone igas omavalitsuses.'