SELECT t.resource_id, t.version, t.value
        FROM secrets t
        JOIN (
          SELECT resource_id, MAX(version) AS version
          FROM secrets
          GROUP BY resource_id
        ) max_versions ON (
          max_versions.resource_id = t.resource_id
          AND max_versions.version = t.version
        )
        WHERE t.resource_id IN ?