I am attempting some data mining via
data.stackexchange but failing in my current task, as I cannot find the "off topic reason" for closed "off-topic" questions.
Given a closed 'off topic' question such as my randomly chosen victim question, 17335689:
We can see from visiting the question that its "Off-Topic Reason" is:
questions asking us to recommend or find a tool, library or favorite off-site resource are off-topic
...but how can we craft a query in Data.Stackexchange that unearths this fact?
(i.e. that returns the
CloseAsOffTopicReasonType for a closed question)
I've tried by writing a series of queries here:
None of the many queries contained at that link unearthed the "Off topic reason" for that question.
There is a "pending flags" table that points back to
Posts. But there are no pending flags for this closed question.
(I am now certain that
PendingFlags only exist when a question is not yet closed.)
I've included step by step breakdown of what I've tried so far in the comments of the query
I looked in the following tables:
None of them contained the data that clearly does exist.