15
votes
Finding my upvotes on Data Explorer
Votes are anonymous by design so there's no public record of your (or anyone else's) votes. If you upvoted a post you'll have to log in and check on the site itself via the votes tab in your profile.
...
- 32.6k
8
votes
Accepted
SQL query used to calculate staff escalation statistics doesn't take into account different tag names for international sites
Thanks for the report, I have updated the query and it now includes non-English sites:
(that the tags don't render is another SEDE bug)
GlorfindelMod
- 247k
7
votes
Accepted
Search for comments on posts with a certain tag based on a keyword
You can cut back on an extra join because PostTags has the PostId and you don't seem to project any attributes from the Post table. Furthermore improve the LIKE performance with a COLLATE instead of ...
- 85.7k
5
votes
Search for comments on posts with a certain tag based on a keyword
I think I've cracked this one, and I've got a few tips to offer that might be able to help with speeding up SEDE queries for you in the future as well.
Here's my modified version of your query:
...
- 8,274
2
votes
Add option to download a message in SEDE
As Karl Knechtel mentioned in a comment, one can use the Inspect feature of one's browser to copy the message. E.g., in Chrome: F12, then:
- 33.7k
Only top scored, non community-wiki answers of a minimum length are eligible