Hi @asmecher,
I can work with database manually, and I can operate with data.
When I ran your query, I found 0 records, but if I change null value with empty string:
SELECT DISTINCT a.setting_name FROM journal_settings a JOIN journal_settings b ON (a.setting_name = b.setting_name AND a.locale = "" and b.locale <> "");
I find two records:
authorSelfArchivePolicy
metaCitations
Duplicated value for empty string?
UPGRADE
A query for “authorSelfArchivePolicy” reveal a group of records with no locale and two records for the same journal_id, one with locale en_US and the other with empty string.
A query for “metaCitations” reveal two kind of setting_type, bool and string for a group of 8 journal_id while other records have only one type of “metaCitations” setting_type, bool.
Thank you
Regards,
Antonio