@Override
public DownloadForm getForm(Integer dlId) {
Integer languageId = getSettingService().getConfig(SettingKey.ADMIN_LANGUAGE_ID, Integer.class);
String sql = "SELECT DISTINCT * FROM " +quoteTable("download")+ " d LEFT JOIN "+quoteTable("download_description")+
" dd ON (d.download_id = dd.download_id) WHERE d.download_id = ? AND dd.language_id = ?";
DownloadForm dlForm = (DownloadForm)getJdbcOperations().queryForObject(
sql, new Object[]{dlId, languageId},
new DownloadRowMapper().setTargetClass(DownloadForm.class));
dlForm.setDescs(getDescriptions(dlId));
dlForm.setDownloadDir(downloadFileService.getUrl(""));//leave it empty to get only baseUrl
return dlForm;
}