Index: openacs-4/packages/acs-lang/www/admin/index.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/www/admin/index.xql,v
diff -u -r1.1.2.2 -r1.1.2.3
--- openacs-4/packages/acs-lang/www/admin/index.xql	23 Apr 2019 19:25:25 -0000	1.1.2.2
+++ openacs-4/packages/acs-lang/www/admin/index.xql	17 Nov 2022 03:58:01 -0000	1.1.2.3
@@ -14,10 +14,10 @@
                 language,
                 default_p,
                 enabled_p,
-                case when num_messages is null          then 0 else num_messages end,
-                case when num_translated is null        then 0 else num_translated end,
-                case when num_untranslated is null      then 0 else num_untranslated end,
-                case when num_deleted is null           then 0 else num_deleted end
+	        case when num_messages is null          then 0 else num_messages end as num_messages,
+	        case when num_translated is null        then 0 else num_translated end as num_translated,
+	        case when num_untranslated is null      then 0 else num_untranslated end as num_untranslated,
+	        case when num_deleted is null           then 0 else num_deleted end as num_deleted
             from (
                 select
                     locale,
@@ -50,6 +50,10 @@
                  al.locale = locale_summary.locale
             group by
                 al.locale,
+		al.label,
+	        language,
+	        default_p,
+	        enabled_p,
                 num_messages,
                 num_translated,
                 num_untranslated,
Index: openacs-4/packages/acs-subsite/www/admin/themes/index.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/themes/index.xql,v
diff -u -r1.2 -r1.2.2.1
--- openacs-4/packages/acs-subsite/www/admin/themes/index.xql	7 Aug 2017 23:47:58 -0000	1.2
+++ openacs-4/packages/acs-subsite/www/admin/themes/index.xql	17 Nov 2022 03:48:49 -0000	1.2.2.1
@@ -1,12 +1,11 @@
 <?xml version="1.0"?>
 
 <queryset>
-   <rdbms><type>postgresql</type><version>7.1</version></rdbms>
 
 <fullquery name="select_themes">      
       <querytext>
     select * from  subsite_themes
       </querytext>
 </fullquery>
 
-</queryset>
\ No newline at end of file
+</queryset>