9

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, 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):

Would someone (possibly SE staff?) please update the query and calculate stats using the new query, at least from the next quarter?

6
  • 1
    Looking at the international sites listed in the tag-info, the tag (статус-проверка) exists on Русский язык Meta, too. In that case (status-review) is a synonym - similarly as on the sites that you listed in the first revision.
    – Martin
    Commented Sep 1, 2023 at 5:07
  • 1
    Can you help me with the OUTER APPLY part of the query, which aims to select the current status? In English, all those tags start with status- - what's the Japanese equivalent? Or should I just use a list of tags?
    – Glorfindel Mod
    Commented Sep 1, 2023 at 9:24
  • @Glorfindel I might have still missed some status tag on that site, but after this modification of the OUTER APPLY part I am getting something in the column which is supposed to be the current status tag. The current version of your query seems to have only status-completed.
    – Martin
    Commented Sep 1, 2023 at 13:24
  • 1
    @Glorfindel Thank you for your quick response. For future reference, I created a query to get a list of the translated names of the tags. data.stackexchange.com/jame/query/1779534/…
    – mjy
    Commented Sep 1, 2023 at 14:14
  • @Glorfindel Regarding the Japanese tag names, Martin's comment is correct. Since these do not have a common string at the beginning, there is no way to smartly match them.
    – mjy
    Commented Sep 1, 2023 at 14:16
  • 2
    @mjy thank you, I've added those to the query
    – Glorfindel Mod
    Commented Sep 1, 2023 at 15:01

1 Answer 1

9

Thanks for the report, I have updated the query and it now includes non-English sites:

enter image description here

(that the tags don't render is another SEDE bug)

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .