animuson

Chalco, NE

animuson.me

Age: 23

I like thinking, and playing games, and building websites.

Oh, and sunglasses confuse me.

I'm also a moderator on Stack Overflow.

[ Twitter ] - [ Steam ] - [ Amazon Wishlist ]

52m
comment What's "teststackoverflow.com" and how does it affect me?
Related: Cookies and JavaScript for teststackoverflow.com — legitimate?
5h
comment How to find data on dupes in SP
Well there's a couple things to clarify. 1. In your declaration at the top, you're trying to select Score from the Votes table, which doesn't exist. I'm really not sure what exactly you're doing up there at all, because you appear to be selecting all uvotes in the entire database and grouping them by post. Each post in the database already has a cached Score with it, so all of that work seems unnecessary. What are you trying to accomplish? 2. p.CommunityOwnedDate being null will exclude all community wiki posts from the query, is that something you want to do?
5h
comment How to find data on dupes in SP
If you're not restricted to Data Explorer, this is much easier if you just use the built-in site search (search for duplicate:1 then switch to the votes tab).
8h
awarded Good Answer
13h
awarded Enlightened
16h
comment Is it a good idea to have an IP-level question ban?
@aroth It uses some of the same algorithms as the question block. A few positively scored questions and/or answers would probably lift it fairly quick.
17h
awarded Nice Answer
19h
comment Where can I find that jsFiddle demo button?
I frequently go through Data Explorer queries and mass edit posts which abuse this formatting.
19h
revised Paypal: Is there a way to check a cart right before a user pays?
Improve readability.
20h
awarded comments
22h
awarded Guru
23h
comment Why are some questions locked while others are deleted?
FWIW your second example was deleted before the historical lock existed.
23h
reviewed Reopen Why doesn't Stack Overflow allow discussable questions or questions that requires opinions?
23h
reviewed Approve suggested edit on My team is not totally comfortable with my leadership style. How can I avoid potential problems?
23h
answered Proper course of action for a close war?
23h
comment Migrating SO-related questions closed as "pertains only to a specific site" on Meta.SE automatically back to Meta.SO
@Bruno Migration does preserve the timestamps, but it's also an event that bumps it into the active list. But my concern wasn't really over them appearing in he active list. Migrating them here serves no purpose if they're already resolved. You're just adding questions for the sake of adding questions.
23h
revised Migrating SO-related questions closed as "pertains only to a specific site" on Meta.SE automatically back to Meta.SO
edited tags
23h
answered Migrating SO-related questions closed as "pertains only to a specific site" on Meta.SE automatically back to Meta.SO
1d
answered "Comment as Answer" option when answering a question
1d
comment Correct tag elasticsearch
Ummm, for those of you closing this as "pertains only to a specific site" - this is tagged with [tag:meta] and actually talked about a tag that existed here on Meta.
1 2 3 4 5