Index: lams_common/src/java/org/lamsfoundation/lams/rating/dao/hibernate/RatingDAO.java
===================================================================
diff -u -r375f8bce2569de89cfce75b0b67cee5633d24822 -r8a760d56403394acfc11cf4ba9fe6a3fccfc83b9
--- lams_common/src/java/org/lamsfoundation/lams/rating/dao/hibernate/RatingDAO.java	(.../RatingDAO.java)	(revision 375f8bce2569de89cfce75b0b67cee5633d24822)
+++ lams_common/src/java/org/lamsfoundation/lams/rating/dao/hibernate/RatingDAO.java	(.../RatingDAO.java)	(revision 8a760d56403394acfc11cf4ba9fe6a3fccfc83b9)
@@ -79,7 +79,7 @@
     // Used by tools to get the ratings and comments relating to their items, as submitted by a particular user. 
     // To be used within SQL and supply the userId as :userId and criteriaId as :ratingCriteriaId
     // See Peer Review for example usage. Special version for comment style as there is no entry in the lams_rating table for a comment style rating.
-    private static final String TOOL_SELECT_LEFT_JOIN_BY_USER_STANDARD = "SELECT r.item_id, rc.comment, r2.rating, AVG(r.rating) average_rating, COUNT(r.rating) count_vote "              
+    private static final String TOOL_SELECT_LEFT_JOIN_BY_USER_STANDARD = "SELECT r.item_id, ANY_VALUE(rc.comment) comment, ANY_VALUE(r2.rating) rating, AVG(r.rating) average_rating, COUNT(r.rating) count_vote "              
 	    + " FROM lams_rating r  "              
 	    + " LEFT JOIN lams_rating r2  ON r2.rating_criteria_id = r.rating_criteria_id AND r.item_id = r2.item_id AND r2.user_id = :userId "              
 	    + " LEFT JOIN lams_rating_comment rc ON rc.rating_criteria_id = r.rating_criteria_id AND rc.item_id = r2.item_id AND rc.user_id = :userId "              
Index: lams_common/src/java/org/lamsfoundation/lams/rating/service/RatingService.java
===================================================================
diff -u -r0cf3b837f37930f11b640ce74c232b84d4a32731 -r8a760d56403394acfc11cf4ba9fe6a3fccfc83b9
--- lams_common/src/java/org/lamsfoundation/lams/rating/service/RatingService.java	(.../RatingService.java)	(revision 0cf3b837f37930f11b640ce74c232b84d4a32731)
+++ lams_common/src/java/org/lamsfoundation/lams/rating/service/RatingService.java	(.../RatingService.java)	(revision 8a760d56403394acfc11cf4ba9fe6a3fccfc83b9)
@@ -559,7 +559,7 @@
 		    dto.setComment((String) row[2]);
 		    dto.setItemDescription((String) row[numColumns - 1]);
 		    if ( ! isComment ) {
-			dto.setUserRating(row[3] == null ? "" : numberFormat.format((Float) row[3]));
+			dto.setUserRating(row[3] == null ? "" : numberFormat.format((Double) row[3]));
 			dto.setAverageRating(row[4] == null ? "" : numberFormat.format((Double) row[4]));
 			dto.setNumberOfVotes(row[5] == null ? "" : numberFormat.format((BigInteger) row[5]));
 		    }
Index: lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dao/hibernate/PeerreviewDAOHibernate.java
===================================================================
diff -u -rf059acd48464d2785b1ab003d64cc21747bba49d -r8a760d56403394acfc11cf4ba9fe6a3fccfc83b9
--- lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dao/hibernate/PeerreviewDAOHibernate.java	(.../PeerreviewDAOHibernate.java)	(revision f059acd48464d2785b1ab003d64cc21747bba49d)
+++ lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dao/hibernate/PeerreviewDAOHibernate.java	(.../PeerreviewDAOHibernate.java)	(revision 8a760d56403394acfc11cf4ba9fe6a3fccfc83b9)
@@ -41,7 +41,9 @@
     private static final String GET_RESOURCE_BY_CONTENTID = "from " + Peerreview.class.getName()
 	    + " as r where r.contentId=?";
     
-    private static final String GET_STATS = "SELECT s.session_id as \"sessionId\", s.session_name as \"sessionName\", "
+    // ANY_VALUE is needed for Mysql setting ONLY_FULL_GROUP_BY - the sessionName will always be the same 
+    // as it is from the same table as sessionId.  (LDEV-4222)
+    private static final String GET_STATS = "SELECT s.session_id as \"sessionId\", ANY_VALUE(s.session_name) as \"sessionName\", "
 	    + " count(u.uid) as \"numLearnersInSession\", sum(u.session_finished) as \"numLearnersComplete\" "
 	    + " FROM tl_laprev11_session s "
 	    + " JOIN tl_laprev11_peerreview p ON p.content_id = :toolContentId AND s.peerreview_uid = p.uid "