Index: openacs-4/packages/acs-lang/tcl/lang-catalog-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/tcl/lang-catalog-procs.xql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/acs-lang/tcl/lang-catalog-procs.xql	21 Jan 2003 16:30:33 -0000	1.5
+++ openacs-4/packages/acs-lang/tcl/lang-catalog-procs.xql	21 Jan 2003 18:46:53 -0000	1.6
@@ -29,7 +29,11 @@
         from lang_messages
         where package_key = :package_key
         and locale = :locale
-        and upgrade_status <> 'deleted'
+        and not exists (select 1 from lang_message_keys
+                        where message_key = lang_messages.message_key
+                        and package_key = lang_messages.package_key
+                        and upgrade_status = 'deleted'
+                       )
     </querytext>
   </fullquery>