This is a bug report of a SQL query used at What posts should be escalated to staff using [status-review], and how do I escalate them?.
In the above post, status-review posts are counted using this SEDE query: https://data.stackexchange.com/meta.stackexchange/query/1245452/posts-with-status-review-network-wide.
One of community members at ja.stackoverflow.com noticed that this query does not take moderator tags on international sites into account. Moderator tag names are localized on some international sites. For example, es.meta.stackoverflow.com uses [estado-en-revisión] rather than [status-review].
Here is a list of localized [status-review] tags I noticed (in the alphabetical order of site URLs):
- [estado-en-revisión] - Meta Stack Overflow in Spanish
- [調査中] - Meta Stack Overflow in Japanese
- [status-revisão] - Meta Stack Overflow in Portuguese
- [статус-проверка] - Meta Stack Overflow in Russian and Russian Language in Russian Meta
Would someone (possibly SE staff?) please update the query and calculate stats using the new query, at least from the next quarter?