Index: openacs-4/packages/acs-lang/www/admin/batch-editor-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/www/admin/batch-editor-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-lang/www/admin/batch-editor-oracle.xql	8 Aug 2003 12:21:28 -0000	1.1
+++ openacs-4/packages/acs-lang/www/admin/batch-editor-oracle.xql	14 Aug 2003 16:06:20 -0000	1.2
@@ -11,15 +11,20 @@
             from   (select lm1.message_key,
                            lm1.package_key,
                            lm1.message as default_message,
-                           lm2.message as translated_message
+                           lm2.message as translated_message,
+                           lmk.description
                     from   lang_messages lm1,
-                           lang_messages lm2
+                           lang_messages lm2,
+                           lang_message_keys lmk
                     where  lm1.locale = :default_locale
                     and    lm2.locale (+) = :locale 
                     and    lm2.message_key (+) = lm1.message_key
                     and    lm2.package_key (+) = lm1.package_key
+                    and    lm1.message_key = lmk.message_key
+                    and    lm1.package_key = lmk.package_key
                     and    lm1.package_key = :package_key
-                    order  by upper(lm1.message_key)
+                    $where_clause
+                    order  by upper(lm1.message_key), lm1.message_key
                    ) q
             ) q2
     where  inner_rownum between :page_start + 1 and :page_start + 10