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 -r1.1 -r1.2
--- openacs-4/packages/acs-lang/www/admin/message-list-oracle.xql	14 Aug 2003 16:06:20 -0000	1.1
+++ openacs-4/packages/acs-lang/www/admin/message-list-oracle.xql	22 Sep 2003 14:33:40 -0000	1.2
@@ -3,27 +3,27 @@
 <queryset>
   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
 
+
 <fullquery name="select_messages">
     <querytext>
 
-    select lm1.message_key,
+    select lmk.message_key,
            lm1.message as default_message,
            lm2.message as translated_message,
            lmk.description
     from   lang_messages lm1,
            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
+    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    lm1.package_key = :package_key
+    and    lm2.locale (+) = :locale
+    and    lm2.message_key (+) = lmk.message_key
+    and    lm2.package_key (+) = lmk.package_key
     $where_clause
     order  by upper(lm1.message_key), lm1.message_key
 
     </querytext>
 </fullquery>
-	        
 </queryset>