Index: lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/Patch20161122.java
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/Attic/Patch20161122.java,v
diff -u -r1.1.2.1 -r1.1.2.2
--- lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/Patch20161122.java	22 Nov 2016 10:35:44 -0000	1.1.2.1
+++ lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/Patch20161122.java	26 Nov 2016 16:31:38 -0000	1.1.2.2
@@ -60,7 +60,8 @@
 	    conn.setAutoCommit(false);
 
 	    // read dates one by one and convert them to new format
-	    PreparedStatement readQuery = conn.prepareStatement("SELECT uid, answer FROM tl_ladaco10_answers");
+	    PreparedStatement readQuery = conn.prepareStatement("SELECT a.uid, a.answer FROM tl_ladaco10_answers AS a "
+		    + "JOIN tl_ladaco10_questions AS q ON a.question_uid = q.uid WHERE q.question_type = 4");
 	    PreparedStatement updateQuery = conn
 		    .prepareStatement("UPDATE tl_ladaco10_answers SET answer=? WHERE uid=?");
 	    if (readQuery.execute()) {
@@ -73,7 +74,7 @@
 		    updateQuery.executeUpdate();
 		}
 	    }
-	    
+
 	    ctx.commit();
 	} catch (Exception e) {
 	    ctx.rollback();