+ " cgd ON (cg.customer_group_id = cgd.customer_group_id) WHERE cgd.language_id = ?";
//sortedKeys={"cgd.name", "cg.sort_order"}
QueryBean query = createPaginationQuery(sql, pageParam);
query.addParameters(languageId);
List<CustomerGroup> customerGroupList = getJdbcOperations()
.query(query.getSql(), query.getParameters(), new CustomerGroupRowMapper(){
@Override
public CustomerGroup mapRow(ResultSet rs, CustomerGroup object)
throws SQLException {
CustomerGroup customerGroup = super.mapRow(rs, object);
customerGroup.setName(rs.getString("name"));