Index: openacs-4/packages/acs-subsite/www/admin/applications/index-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/applications/index-oracle.xql,v diff -u -N -r1.2.18.3 -r1.2.18.4 --- openacs-4/packages/acs-subsite/www/admin/applications/index-oracle.xql 27 Apr 2017 15:55:19 -0000 1.2.18.3 +++ openacs-4/packages/acs-subsite/www/admin/applications/index-oracle.xql 21 Jul 2017 16:29:48 -0000 1.2.18.4 @@ -9,10 +9,10 @@ select n.node_id from site_nodes n, apm_packages p - left outer join lang_messages m + left join lang_messages m on m.locale = :locale and '#' || m.package_key || '.' || m.message_key || '#' = p.instance_name - left outer join lang_messages md + left join lang_messages md on m.locale = 'en_US' and '#' || md.package_key || '.' || md.message_key || '#' = p.instance_name, apm_package_types pt