From 4bb6c2563baa3eda86784a9db4564550e621b0b9 Mon Sep 17 00:00:00 2001
From: skodak <skodak>
Date: Tue, 23 May 2006 18:15:52 +0000
Subject: [PATCH] fixed broken SQL that was throwing errors in backup; merged
 from MOODLE_16_STABLE

---
 mod/data/lib.php | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/mod/data/lib.php b/mod/data/lib.php
index 841fd8399f..8f3157ef94 100755
--- a/mod/data/lib.php
+++ b/mod/data/lib.php
@@ -767,8 +767,8 @@ function data_get_participants($dataid) {
                                AND u.id = r.userid');
     
     $comments = get_records_sql('SELECT DISTINCT u.id, u.id from '.$CFG->prefix.
-                                'user u, '.$CFG->prefix.'data_comments c WHERE dataid="'.$dataid.'"
-                                AND u.id = c.userid');
+                                'user u, '.$CFG->prefix.'data_comments c, '.$CFG->prefix.'data_records r'.
+                                ' WHERE r.dataid="'.$dataid.'" AND u.id = c.userid AND r.id = c.recordid');
 
     $participants = array();
     
-- 
2.39.5