" dd ON (d.download_id = dd.download_id) WHERE dd.language_id =?";
//sortedKeys={"dd.name", "d.remaining"}
QueryBean query = createPaginationQuery(sql, pageParam);
query.addParameters(languageId);
return getJdbcOperations().query(query.getSql(),
query.getParameters(), new DownloadRowMapper(){
@Override
public Download mapRow(ResultSet rs, int rowNum)
throws SQLException {
Download download = super.mapRow(rs, rowNum);
download.setName(rs.getString("name"));