Index: openacs-4/packages/acs-lang/www/admin/message-list-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/www/admin/Attic/message-list-oracle.xql,v
diff -u -N
--- openacs-4/packages/acs-lang/www/admin/message-list-oracle.xql	18 Apr 2008 06:48:43 -0000	1.6
+++ /dev/null	1 Jan 1970 00:00:00 -0000
@@ -1,31 +0,0 @@
-<?xml version="1.0"?>
-
-<queryset>
-  <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
-
-
-<fullquery name="select_messages">
-    <querytext>
-
-    select lmk.message_key,
-           lm1.message as default_message,
-           lm2.message as translated_message,
-           lmk.description,
-           nvl(lm2.deleted_p, 'f') as deleted_p
-    from   lang_messages lm1,
-           lang_messages lm2,
-           lang_message_keys lmk
-    where  lmk.package_key = :package_key
-    and    lm1.locale = :default_locale
-    and    lm1.message_key = lmk.message_key
-    and    lm1.package_key = lmk.package_key
-    and    lm2.locale (+) = :locale
-    and    lm2.message_key (+) = lmk.message_key
-    and    lm2.package_key (+) = lmk.package_key
-    and    lm1.deleted_p = 'f'
-    $where_clause
-    order  by upper(lm1.message_key), lm1.message_key
-
-    </querytext>
-</fullquery>
-</queryset>
Index: openacs-4/packages/acs-lang/www/admin/message-list-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/www/admin/Attic/message-list-postgresql.xql,v
diff -u -N
--- openacs-4/packages/acs-lang/www/admin/message-list-postgresql.xql	26 Feb 2004 15:28:47 -0000	1.4
+++ /dev/null	1 Jan 1970 00:00:00 -0000
@@ -1,29 +0,0 @@
-<?xml version="1.0"?>
-
-<queryset>
-<rdbms><type>postgresql</type><version>7.1</version></rdbms>
- 
-<fullquery name="select_messages">
-    <querytext>
-
-    select lm1.message_key,
-           lm1.message as default_message,
-           lm2.message as translated_message,
-           lmk.description,
-           coalesce(lm2.deleted_p, 'f') as deleted_p
-    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_message_keys lmk
-    where  lm1.locale = :default_locale
-    and    lm1.package_key = :package_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
-
-
-    </querytext>
-</fullquery>
-	        
-</queryset>
-	                            
Index: openacs-4/packages/acs-lang/www/admin/message-list.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/www/admin/message-list.xql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-lang/www/admin/message-list.xql	22 Nov 2017 14:29:56 -0000	1.1
@@ -0,0 +1,24 @@
+<?xml version="1.0"?>
+<queryset>
+  <fullquery name="select_messages">
+    <querytext>
+
+    select lm1.message_key,
+           lm1.message as default_message,
+           lm2.message as translated_message,
+           lmk.description,
+           coalesce(lm2.deleted_p, 'f') as deleted_p
+    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_message_keys lmk
+    where  lm1.locale = :default_locale
+    and    lm1.package_key = :package_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
+
+    </querytext>
+  </fullquery>
+
+</queryset>