private static String getCountAMemberGroupSql() {
        if (countAMemberGroupSql == null) {
            StringBuffer buff = new StringBuffer(100);
            buff.append("SELECT COUNT(*) FROM " + MEMBER_TABLE);
            buff.append(" WHERE " + MEMBER_GROUP_ID_COLUMN + EQUALS_PARAM);
            buff.append(" AND " + MEMBER_MEMBER_KEY_COLUMN + EQUALS_PARAM);
            buff.append(" AND " + MEMBER_MEMBER_SERVICE_COLUMN + EQUALS_PARAM);
            buff.append(" AND " + MEMBER_IS_GROUP_COLUMN + EQ + sqlQuote(MEMBER_IS_GROUP));
            countAMemberGroupSql = buff.toString();
        }
        return countAMemberGroupSql;
    }
private static String getCountAMemberGroupSql ( ) { if ( countAMemberGroupSql == null ) { StringBuffer buff = new StringBuffer ( 100 ) ; buff . append ( "SELECT COUNT(*) FROM " + MEMBER_TABLE ) ; buff . append ( " WHERE " + MEMBER_GROUP_ID_COLUMN + EQUALS_PARAM ) ; buff . append ( " AND " + MEMBER_MEMBER_KEY_COLUMN + EQUALS_PARAM ) ; buff . append ( " AND " + MEMBER_MEMBER_SERVICE_COLUMN + EQUALS_PARAM ) ; buff . append ( " AND " + MEMBER_IS_GROUP_COLUMN + EQ + sqlQuote ( MEMBER_IS_GROUP ) ) ; countAMemberGroupSql = buff . toString ( ) ; } return countAMemberGroupSql ; }
@return String