From 4ea69f88f323376553a9232fa51cc86cde9f4328 Mon Sep 17 00:00:00 2001
From: moodler <moodler>
Date: Fri, 18 Jul 2008 07:52:36 +0000
Subject: [PATCH] MDL-15702  SQL efficiency fix Merged from 1.9

---
 mod/data/view.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/mod/data/view.php b/mod/data/view.php
index d9d750cb58..983893c4bc 100755
--- a/mod/data/view.php
+++ b/mod/data/view.php
@@ -514,7 +514,7 @@
                         continue;
                     }
                     $tables .= ', {data_content} c'.$key.' ';
-                    $where .= ' AND c'.$key.'.recordid = r.id';
+                    $where .= ' AND c'.$key.'.recordid = r.id AND c'.$key.'.fieldid = '.$key;
                     $searchselect .= ' AND ('.$val->sql.') ';
                     $params = array_merge($params, $val->params);
                 }
-- 
2.39.5