public List<String> getFilesMissingMetadata() {
String sql = "select d.path, f.filename from library.filewarning fw"
+ " inner join library.file f on fw.file_id = f.id"
+ " inner join library.directory d on f.directory_id = d.id"
+ " order by d.path, f.filename";
return jdbcTemplate.query(sql, new FilenameRowMapper());
}