4

I wonder if I can see all my questions and answers that are currently on or had been previously listed on the 'Hot Network Questions.'

When I see a revision history of a specific question, I know whether it was listed on Hot Network Questions, but I wonder if I can see all of them altogether in a single page.

Improve this question
1
  • 3
    Such a feature does not exist yet.
    – Mast
    Commented Jan 31, 2023 at 5:29

1 Answer 1

Reset to default
7

That kind of information can be retrieved via the Stack Exchange Data Explorer, at least for hot questions since February 2019. I created a query which checks this for a single user, network-wide. It is not recorded when a question leaves the Hot Network Questions list, so it could be that an answer was posted afterwards; you can compare both dates to check.

enter image description here

Please note that SEDE is updated only once a week, on Sunday morning, so the results could be a bit stale.

Improve this answer
3
  • 1
    This is great! Just as a potential simplification in the future, here's a version of the first query that executes dynamic SQL in the context of each database without having to do all that string concat with the database name. Cursor vs. string concat is kind of "pick your poison" I guess, even though the SQL string building is a cursor in disguise, but I like this way better because you can take the dynamic SQL and debug it independently.
    – Aaron Bertrand Staff
    Commented Jan 31, 2023 at 12:00
  • 1
    Thanks Aaron! I can never remember the correct syntax for CURSOR, that's why I chose this strategy, and if the query itself is complicated I'll test it out on a single site first, but most of the time the first iteration is (almost) right.
    – Glorfindel Mod
    Commented Jan 31, 2023 at 13:55
  • You can do the same without a cursor, but it's... a lot uglier.
    – Aaron Bertrand Staff
    Commented Jan 31, 2023 at 15:13

You must log in to answer this question.

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