Index: lams_common/src/java/org/lamsfoundation/lams/learningdesign/dao/hibernate/GroupDAO.java
===================================================================
diff -u -r6d023d698235f9bc14e1c877e325283741aebe83 -raca0f0391e13cb11fb37ed0a53d4023663f67111
--- lams_common/src/java/org/lamsfoundation/lams/learningdesign/dao/hibernate/GroupDAO.java	(.../GroupDAO.java)	(revision 6d023d698235f9bc14e1c877e325283741aebe83)
+++ lams_common/src/java/org/lamsfoundation/lams/learningdesign/dao/hibernate/GroupDAO.java	(.../GroupDAO.java)	(revision aca0f0391e13cb11fb37ed0a53d4023663f67111)
@@ -44,8 +44,8 @@
 public class GroupDAO extends BaseDAO implements IGroupDAO {
 
 	private final static String NUM_GROUPS = "select count(*) from "
-		+ Group.class.getName() + " group "
-		+ " where group.users.userId = :userID";
+		+ Group.class.getName() + " g join g.users u"
+		+ " where u.userId = :userID";
 
 	/* (non-Javadoc)
 	 * @see org.lamsfoundation.lams.learningdesign.dao.interfaces.IGroupDAO#getGroupById(java.lang.Long)