SELECT this_.ID                 AS ID1094_0_,
       this_.AREA               AS AREA1094_0_,
       this_.KLADR              AS KLADR1094_0_,
       this_.RATING             AS RATING1094_0_,
       this_.SCOPES_ACTIVITY_ID AS SCOPES9_1094_0_,
       this_.RESULT             AS RESULT1094_0_,
       this_.SUBJECT            AS SUBJECT1094_0_,
       this_.VILLAGE            AS VILLAGE1094_0_,
       this_.RATING_YEAR        AS RATING8_1094_0_
FROM GMU_RATING.RATING_SUBJECTS_MV this_
WHERE this_.RATING_YEAR = ?
  AND this_.SUBJECT IS NOT NULL
  AND this_.AREA IS NULL
  AND this_.VILLAGE IS NULL
ORDER BY result DESC NULLS LAST