Index: openacs-4/packages/acs-lang/www/admin/batch-editor-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/www/admin/Attic/batch-editor-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-lang/www/admin/batch-editor-postgresql.xql	8 Aug 2003 12:21:28 -0000	1.1
+++ openacs-4/packages/acs-lang/www/admin/batch-editor-postgresql.xql	14 Aug 2003 16:06:20 -0000	1.2
@@ -8,12 +8,17 @@
     select lm1.message_key,
            lm1.package_key,
            lm1.message as default_message,
-           coalesce(lm2.message, 'TRANSLATION MISSING') as translated_message
+           lm2.message as translated_message,
+           lmk.description
     from   lang_messages lm1 left outer join 
-           lang_messages lm2 on (lm2.locale = :locale and lm2.message_key = lm1.message_key and lm2.package_key = lm1.package_key)
+           lang_messages lm2 on (lm2.locale = :locale and lm2.message_key = lm1.message_key and lm2.package_key = lm1.package_key),
+           lang_message_keys lmk
     where  lm1.locale = :default_locale
     and    lm1.package_key = :package_key
-    order  by upper(lm1.message_key)
+    and    lm1.message_key = lmk.message_key
+    and    lm1.package_key = lmk.package_key
+    $where_clause
+    order  by upper(lm1.message_key), lm1.message_key
     offset $page_start
     limit  10