String sql = "SELECT DISTINCT *, (SELECT pd.name FROM "+quoteTable("product_description")
+" pd WHERE pd.product_id = r.product_id AND pd.language_id = ?) AS product_name FROM "
+quoteTable("review")+" r WHERE r.review_id =?";
Integer languageId = getSettingService().getConfig(SettingKey.ADMIN_LANGUAGE_ID, Integer.class);
return (ReviewForm)getJdbcOperations().queryForObject(sql, new Object[]{reviewId, languageId},
new ReviewRowMapper().setTargetClass(ReviewForm.class));
}