« first day (1808 days earlier)      last day (1824 days later) » 
00:00 - 18:0018:00 - 00:00

12:14 AM
@3ventic ¯\_(ツ)_/¯
How to make this work in SEDE?
> select (q.acceptedanswerid = a.id) as [Accepted]
Basically check 1 if the answer is accepted or 0 if not
@TinyGiant select case when ... like here: data.stackexchange.com/stackoverflow/query/268253
And can I then give that column a column title?
And can I sum by that column?
I would like to be able to combine this query with this one so that it can calculate rep gained from accepted answers as well as upvotes
12:32 AM
You can do select case .... as Something, and I suppose the sum will work too.
it doesn't seem to be working for me
Oh, I got the title to work, was putting it in the wrong spot
@TinyGiant I googled "select sum case when"..... SQL Query - SUM(CASE WHEN x THEN 1 ELSE 0) for multiple columns by MickJuice on stackoverflow.com
That's a bit over my head
You don't need the whole thing, it does have an example of a functioning query doing such a thing.
Incidentally, the total score of Q&A there is 6, contrasted with viewcount > 34000
12:37 AM
A lot of people saw it and didn't think it was useful enough to upvote
Likely, most of those people didn't have an account.
Oh, I figured it out
Thanks for that link
Actually, anonymous feedback there is mostly negative... many of those 34000 must have been searching for something else.
Hmmm. I guess so
The title must not be as appropriate as possible.
[ SmokeDetector ] Email in answer: What do you call a person who craves fame and fortune? by johnson on english.stackexchange.com
12:45 AM
@SmokeDetector tpu-
@1999 collaborative
Now to make those queries as exact as possible, I need to figure out how to filter out questions whos' reason for closing came about after the question was posted.... lol
1:05 AM
Today is the 3rd anniversary of the graduation of Mathematica (not to be confused with Mathematics). The site graduated exactly 6 months after the start of the private beta (those were the good times).
For I picked a question from the first day of their private beta: Where can I find examples of good Mathematica programming practice? by Guess who it is. The top answer is currently in its 256th revision; there's a claim that it is the most-edited post on Stack Exchange.
That's pretty hard to do on Meta, since the badge requires no downvotes on that day.
E.g., Atwood or Shog don't have that badge, and neither does Jon Ericson who proposed it in the first place.
I don't even have 100 questions on meta that aren't deleted, much less not downvoted
1:10 AM
Oh. But you do have a script notifying you of name mentions in chat, it seems.
Not exactly. In this case I was here trying to figure out the source of the NPR discussion
(...another site where I'll never be getting any good-asker badges, incidentally)
Indeed, none of those mentioned have 100 extant Meta questions.
A: How can we avoid Programmers.SE from becoming the SE black sheep?

Shog9I'm here because I want this site to succeed. Not as "Questions we wish were allowed on SO", but as "Questions that can't be allowed on SO". A place for all the things that SO/SE was never designed for, or explicitly designed to prevent, but which massive numbers of users want anyway. I really, ...

And now their bulletin has "Structured Tag Cleanup Initiative Phase II"... how much fun is that?
NPR has gone to hell...
1:14 AM
If Programmers is NSO, then NPR is NNSO is SO.
someone said that negation of a negation is not an affirmation
Yeah right.
@Shog9 From my (limited) experience with programmers.SE I've found that it is pretty well as strict as SO, and many of the questions not allowed on SO are also not allowed on programmers.SE. In fact i have been insta-shouted at for recommending that a question be asked on programmers.SE.
Q: New SE Chat Bot feature for identifying when Programmers is mentioned on Stack Overflow

maple_shaftThere are some very creative SE users and contributors to Code Review that have used the Stack API to build an open source SE Chat bot that is currently being used for many things. https://github.com/Zomis/GithubHookSEChatService The top contributors of this project have graciously offered to i...

Yeah, funny about that... All the folks who wanted it to be fun had their fun and left; then the folks who wanted it to be serious but vague realized that vague was impossible to police for seriousness and left. Which left the folks who were serious and quite specific and also... really focused.
1:18 AM
So the worst of the worst are left over?
@Braiam Yeah, that one
Well, essentially what's left are the folks who thought SO wasn't professional enough.
@Shog9 funny enough, I think I only had searched a question which answer was found on P.SE, and I haven't searched for similar topics since
^ not a professional programmer.
So it has become somewhat the opposite of what it was intended to be?
@1999 obviously
1:19 AM
It's as though Math.SE decided to split off [soft-question] and instead ended up with MO
If traffic can be taken as a proxy for success, Programmers are doing fine. Monthly uniques:
I suppose there isn't much that can be really done about it, as it has been (somewhat) proven that the users will not be there to answer the questions.
How many hard/soft splits, or however you want to call it, are there?
1:21 AM
I have no beef with Progse - they figured out what they wanted to be (eventually) and made it happen. That's all that's necessary. Additionally, they provide a handy cautionary tale for folks wishing to propose offtopic.stackoverflow.com, which won't scare away the children forever but will at least keep them out of the woods for a few years.
A: How can I encourage Stack Overflow to rein in the 'subjective' vigilantes?

Yannistl;dr We already tried supporting those questions, we even gave them their own site. Sadly, it didn't work out. C'est la vie. In 2010, a Stack Exchange site called Not Programming Related came out of Area51, the Stack Exchange staging zone. NPR was supposed to be a site where questions that ...

@Shog9 That's what I was looking for!
I knew it was by Yannis.
So it just isn't going to happen and all of the people that complain that these questions should be allowed, wouldn't actually spend time answering them correctly and completely even if they were given the chance to do so.
I wonder if this is going to be edited into spam...
yeah, like many things that people says that should be allowed but they aren't present when they go out of control. like everything in life @tiny
> I take Omega 3 every day, have for years, and I just now wondered how they got it out of the fish. Protip: don't ask. -- Tim Post at 6:14 PM - 16 Jul 2015 via Twitter
@1999 How can I make this query not select duplicate entries? data.stackexchange.com/stackoverflow/query/337288/…
@SmokeDetector fpu-
Sorry, posted the wrong link the first time, double ping
It seemes like it went through a close-reopen war and so it is selecting every close reason, I need to just select the latest close reason.
2:08 AM
@TinyGiant Looks complicated to me. I'd replace the join of posthistory events by a clause where exists (like in example B here). The meaning is "where exists a closure event with bad reason"... but then it's not necessarily the latest one. Don't know how to pick the latest.
I might have to learn how to use sub-queries better...
Anyways, I'm out for now, will be back later :)
@SmokeDetector fp- edited out
Everything I know about SQL [which isn't much] I've learned from using SEDE... And I guess this isn't unusual.
you mean TSQL, some stuff is done differently in SQL
crbug.com/491173 er... an infinite loop is now a DoS?
2:25 AM
@hichris123 only if I'm not expecting it
I know that while (true) {} would cause a inf-loop, but I don't expect you to include that on js that runs on your website
and I remember that Firefox would stop the execution of the script
It'll just crash the tab... which is probably better, IMO.
Since if someone decided to put an infinite loop in their code... they're probably not trying to be nice to you.
@hichris123 ug? heck no
what fault has my precious website with a wonderful text area where I'm writing the next posthumous Shakespeare title with a rogue script that someone accidentally let loose when you show adverts?
you don't need to crash the whole page just because one component failed, you just kill that component
Have you ever seen an accidental infinite loop?
have you seen someone hihacking some sites ads?
2:40 AM
Not really...
I know is weak, but I can't find the article that I read back then..
3:09 AM
sd fp-
The word was service number...
Chrome does tend to kill the tab for whatever fault it finds with a script. Math.SE was barely usable in Chrome for about a year, in several consecutive versions, because of crashes related to MathJax.
It's Magento, therefore fp for email check, without looking.
[ SmokeDetector ] Bad keyword in body, bad keyword in title: How to join RSorder 2007 runescape gold Daily 4-Hour Special Sale with up to 10% free bonus? by rsstar on gamedev.stackexchange.com
3:53 AM
Out of 47 questions on Arabic Language so far, 12 are by the same user (and they are not particularly well received). Meanwhile, Portuguese Language has 172.
@SmokeDetector vlq/naa
@1999 huh? It answers the question...
Not really. It takes a random takeoff velocity of 70 m/s and does a basic physics calculation. I know how to use F=ma too... that doesn't mean I understand the required thrust.
wait, let me ask the expert...
in Unix and Linux on The Stack Exchange Network Chat, 8 secs ago, by Braiam
@casey I'm not sure where these numbers comes from (specifically thrust), can you verify? http://aviation.stackexchange.com/a/16950/3124
4:02 AM
Meh. My reply to Smokey was meant more like "not spam, but not worth fixing either".
I don't insist on anything.
on the other hand, gnome-shell got an upgrade on Debian testing
4:33 AM
[ SmokeDetector ] Bad keyword in body, bad keyword in title: Easy Alterations For Your Lifestyle That Cause Permanent Weight Loss by ronn iranch on superuser.com
[ SmokeDetector ] Bad keyword in title: How to Reduces wrinkles? by widyruvia on drupal.stackexchange.com
5:11 AM
[ SmokeDetector ] Bad keyword in title: Increase or boost the body muscles? by Dawn Kelly on superuser.com
[ SmokeDetector ] Bad keyword in body, blacklisted website in body, link at end of body: Boxoft PDF To JPG Converter by amir barlow on drupal.stackexchange.com
del-pls stackoverflow.com/q/5992112 the top answer leads to a sketchy site
a few downvotes on that answer (which is kind of NAA anyway) would also help.
Hmm... there are exactly two answers linking to that site, both by the same user.
Let's nuke both if possible... the questions are closed.
[ SmokeDetector ] Blacklisted website in answer: Cloud9 and Jade by sonam sharma on stackoverflow.com
[ SmokeDetector ] Manually reported answer: Keeping up with client work and emails by sonam sharma on freelancing.stackexchange.com
@SmokeDetector fp-
My commit count grows because of removing trailing spaces to please flake...
[ SmokeDetector ] Bad keyword in body, bad keyword in title: Easy Weight Loss Tips and Naturally Body by luella estes on security.stackexchange.com
5:54 AM
[ SmokeDetector ] Bad keyword in body: Greatest Fat Loss Solution About The Internet by luella estes on security.stackexchange.com
I'm voting to close this question because this problem that can no longer be reproduced and is unlikely to help future readers. Also see: Why we're not customer support for [your favorite company]Unihedron 20 secs ago
[ SmokeDetector ] Blacklisted website in body: In utilizing such but also for those people who've diabetes by Adjm Muby on askubuntu.com
[ SmokeDetector ] All-caps title: HARD DRIVE BAD SECTOR REPORT by Emack333 on stackoverflow.com
6:09 AM
I like it when new spam domains appear, and match the already-prepared patterns...
6:34 AM
Spam in Russian... at least I consider this spam.
[ SmokeDetector ] Manually reported answer: Автопостинг в социальные сети by Pohmeliy Opohmelov on ru.stackoverflow.com
[ SmokeDetector ] Email in body: I would appreciate any help by Michelle Davis on android.stackexchange.com
SPAM gamedev.stackexchange.com/questions/104094/… Let's see if it's reported... blacklist candidate 4rsgold.com
Same user. Blacklist candidate fujihd.net
[ SmokeDetector ] Manually reported question: Hengda fuji joined interlift exhibition in Germany by fujihd on gamedev.stackexchange.com
@ShadowWizard I'm not sure if it would be a good idea, because in case someone does an "fp- <reason here>" and he made a typo in that reason and fixes that, Smokey would register the post again as fp.
7:17 AM
[ SmokeDetector ] Bad keyword in body: How does Aimee Age Correction Cream Work? by henryreynolds on drupal.stackexchange.com
[ SmokeDetector ] Manually reported question: Cocoa Burn- How to use it for better result? by henryreynolds on drupal.stackexchange.com
7:39 AM
8:23 AM
sd 3tpu-
[ SmokeDetector ] Blacklisted user: Where can I register a domain and pay with bitcoins? by Tomas Peleckis on bitcoin.stackexchange.com
[ SmokeDetector ] Blacklisted user: Is it legal to use rented dedicated servers to mine? by Tomas Peleckis on bitcoin.stackexchange.com
sd 2tpu
1. [:3715779] Blacklisted user.
2. [:3715778] Blacklisted user.
So much Bitcoin spam...
Waiting for declines, voted to close 2 of those questions
8:41 AM
sd fp-
[ SmokeDetector ] Manually reported question: Thus choose for products-which have information by chafeyit mani on drupal.stackexchange.com
9:03 AM
@ProgramFOX what would it mean? Can't it check if post is already registered as tp/fp and ignore in case of "double" report? (which can also happen regardless of edits)
@ᔕᖺᘎᕊ saw edits by post authors, but yeah suggesting such edit is plain rude
@shadow Yeah - I can see why an OP might do it, but suggesting an edit!?
Why would they think it would be approved in the first place!?
@ᔕᖺᘎᕊ when I see bump only edit by author I usually post a comment asking to stop doing it. So far couple of users were actually convinced this way. :)
@ShadowWizard I have a feeling this user will be convinced by the rejection reasons as well! At least I hope so... :)
9:21 AM
sd tpu-
[ SmokeDetector ] Bad keyword in username: Apple Development: Release iOS 7 app by Black Magic on stackoverflow.com
[ SmokeDetector ] Blacklisted website in body, link at end of body: Power Testro Review by seema jukuy on drupal.stackexchange.com
9:44 AM
> Bad keyword in username
what, "Black"?
Smokey's racist
@PraxisAshelin "black magic"
blacklist candidate jklaptopcare.com
9:59 AM
[ SmokeDetector ] Bad keyword in body: Three exercises you should do on a regular basis are ben by lisa lord on meta.stackexchange.com
[ SmokeDetector ] Blacklisted website in body: Excel copying column cells by column cells by mysticous on stackoverflow.com
[ SmokeDetector ] Bad keyword in body, bad keyword in title: Pure Testo Xplode Make sure you are eating food that supports by paul king on meta.stackexchange.com
10:15 AM
blacklist candidate ethicalitrecycling.co.uk
10:49 AM
user image
[ SmokeDetector ] Blacklisted website in answer: Daily how much water intake is needed? by Sarah Arbogast on health.stackexchange.com
I have a bad feeling on his questions superuser.com/q/941815/172747
@SmokeDetector tpu-
11:04 AM
[ SmokeDetector ] Bad keyword in body, link at end of body: How can it work? by deliyarjuriya on meta.stackexchange.com
11:21 AM
[ SmokeDetector ] Blacklisted user, email in body: Looking for the Partners in Bitcoins business sphere by Tomas Peleckis on bitcoin.stackexchange.com
[ SmokeDetector ] All-caps title: POSTGRE SQL 9.4 ERROR by PR Konduru on stackoverflow.com
[ SmokeDetector ] Email in answer: Contact form emails to multiple recipients by Vivek on magento.stackexchange.com
11:52 AM
[ SmokeDetector ] Bad keyword in body: Burns fat faster from your body by reekip onting on superuser.com
12:25 PM
[ SmokeDetector ] Email in answer: What is the significance of frogs in the Vedas? by krishna iyer on hinduism.stackexchange.com
[ SmokeDetector ] All-caps title: ADD VALUES OF 2 ARRAYS AND CREATE NEW ARRAY by user1367386 on stackoverflow.com
[ SmokeDetector ] Repeating characters in body: QT-creator, cant add kits, cant choose Qt-Version by tankman175 on stackoverflow.com
12:56 PM
[ SmokeDetector ] All-caps title: DEV 501 CERTIFICATION ISSUE by Kalpana chawla on salesforce.stackexchange.com
[ SmokeDetector ] Blacklisted website in body: The Secret For viril booster Revealed in 5 Simple Steps by Maurice Franke on stackoverflow.com
[ SmokeDetector ] Bad keyword in body: expired British passport and travel by shannon on travel.stackexchange.com
[ SmokeDetector ] Bad keyword in body: Expired British passport and travel by shannon on travel.stackexchange.com
1:17 PM
user image
1:35 PM
Today's Listening | Spacesynth
@jadarnel27 nice
1:45 PM
[ SmokeDetector ] Repeating characters in answer: Pros and Cons of SQL Server Database Mail by user70838 on dba.stackexchange.com
Ooh, listenings!
Listening above
1:53 PM
Defaults to one of the later tracks
(sorry, I just wanted to participate)
grabs smiting stick
hides under his desk
I just wanted to be responsible for someone hearing that neat Star Trek sound!
Pff, @rene hasn't even turned my comment into an answer yet. Lazy. I'll have to do it myself.
2:12 PM
[ SmokeDetector ] Repeating words in answer: Where does iTunes store my iPhone and iPad backups? by eugene on apple.stackexchange.com
[ SmokeDetector ] All-caps title: <SITE> - <IIS> - <1C> by db_space on ru.stackoverflow.com
@SmokeDetector Title made up entirely of tags
@LynnCrumbling I saw someone wearing that the other day, and it made me chuckle.
2:35 PM
If I recall correctly, site self evaluations are not being performed any longer. Was this a blog post or a meta post? My google-fu is just turning up the self evaluations of various sites on the network and not an announcement
I never remember what the right thing to do with answers like this one NAA flag? VLQ flag? just downvote?
@Andy weren't they put on a longer schedule?
Q: Should introspection be encouraged in light of the new standards for graduation?

Shog9Summary With the introduction of new, simplified graduation requirements, we're preparing to shut down the venerable Community Eval review process. Years of waning participation, combined with a general lack of clarity as to how these mesh with the normal graduation process, have turned this sys...

Is that what you're referring to?
@Andy They are still being triggered, I'm fairly certain they haven't stopped completely
@Bart Yes it is. Thank you
Q: Experimental self-evaluation

Jon EricsonThe June, 2015 self-evaluation didn't seem to go over well and we are rethinking site checkups. So I thought this would be a good opportunity to try an experimental self-evaluation. Below, I've listed 5 questions chosen at random from the last quarter that have received at least some anonymous ...

2:49 PM
@Bart ... always here to guide you...
@SmokeDetector ignore- off-topic rant
@KevinBrown why ignore?
@Bart Song lyrics were the trigger, I guess that could have been FP as well
3:04 PM
@jadarnel27 Gave me a good laugh, too :)
3:20 PM
@durron597 Hah. <kbd>Bleep</kbd>.
@LynnCrumbling Yeah lol, I got that idea from someone else
@LynnCrumbling How come we don't see you around the Close Vote Reviewers room anymore?
3:40 PM
@durron597 The last 3 weeks were hell. We finally RTM'd this week. Over the July 4th holiday, my time sheet had more than 120 hours for the 2-week period.
@durron597 We're released now, but still fixing tiny bugs. Things should be back to normal sometime in the next two weeks.
That's the end of an 11 month dev cycle.
she just won't stop .. travel, SO now here: islam.stackexchange.com/a/25580/3266
[ SmokeDetector ] Manually reported answer: Wishing for Eid by Ritika Arora on islam.stackexchange.com
@SmokeDetector you are self-flagellating yourself too much, we know you are not perfect, but it isn't always your fault as it's of your creators
@Braiam ^
The solution to not being blamed...renamed yourself to SmokeDetector. How many SmokeDetectors can we get in here at one time?
@LynnCrumbling Well that's good at least
Today's xkcd comic (Rulebook):
Q: Award accepted answer reputation for finding duplicates

durron597Consider the following theoretical situation: New user asks a question: Why does my program process a sorted array faster than an unsorted array? I see this question, I can: Vote to close as duplicate Answer the question with a link to the duplicate, with possibly a little bit of extra e...

> When we say ‘government’ we mean NSA, CIA, FBI, TSA, Communist Party of China (CPC), Nestle, The Coca-Cola Company, the KGB, some of your coworkers and our friends (especially if there is something funny).
4:21 PM
[ SmokeDetector ] Email in body: User can't access Sharepoint site by Quinn on sharepoint.stackexchange.com
@hichris123 s/government/gummint/
[ SmokeDetector ] Blacklisted website in body: Premature end of script headers: index.php by Amar Ilindra on stackoverflow.com
@SmokeDetector I can't tell if that's clever spam or a real log
[ SmokeDetector ] Repeating characters in body: How to get fragments from a DNA sequence. by user3275981 on stackoverflow.com
@Undo probably his site is being attacked
4:25 PM
@Undo Bad referrers are pretty common, I wouldn't be shocked if it's a real log
He has legit questions from a while back, I'm going to call it not spam.
@Braiam I agree with this
4:43 PM
@Braiam I like the addition
“Hey, Josh, what’d you do yesterday?” “Hmm. Oh- I helped the inventor of the WWW on SO. You?” http://stackoverflow.com/questions/31345230/how-can-i-see-the-internal-compile-commands-which-fail-in-a-go-get-installatio http://t.co/WTwfKKo4qk
Celebrity cult. Does Katy Perry have an SE account?
@1999 probably, but you will never find out
All SmokeDetector Users: (cc @hichris123 @ProgramFOX) Use !!/test <string> to see if <string> would pass or fail the spam check. Runs as if it were the only text in an answer body, and replies with the reason(s) if it failed.
!!/test easydatafeed.com
4:57 PM
... except it's not running right now. I'm an idiot.
Okay try now
!!/test easydatafeed.com
@durron597 Blacklisted: Bad keyword in body
!!/test easy_data_feed
@durron597 Not blacklisted
!!/test orabank orabank orabank orabank orabank orabank orabank orabank orabank orabank orabank orabank orabank aaaaaaaaaaaaaaaaaaaaaaaa
5:00 PM
@Undo Blacklisted: Blacklisted website in body, repeating words in body
huh, thought repeating chars would get that.
It wasn't 20% of the body.
!!/test aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa I think this is more than 20% of the body
@Braiam Blacklisted: Repeating characters in body
5:06 PM
!!/test shit
@PeterJ Blacklisted: Offensive body detected
I've drastically reworked my suggestion here, please let me know if any of you have any suggestions to improve the post.
cc @durron597 @1999 @KevinBrown
I still disagree with the suggestion... so... :P
Why do you disagree? It would not affect any previous reputation gains
there should be something to disincentivize answering bad questions
5:13 PM
Is not getting any rep not a disincentive?
What is to gain from posting an answer that you can not possibly gain rep from?
[ SmokeDetector ] Bad keyword in title, blacklisted website in title: http://testosteroneboosterup.com/nitro-slim-fr/ by jerienygodry on askubuntu.com
@SmokeDetector tpu- too bad that was triggered by title; we could have checked the new logic for nested quotes
@TinyGiant Because you're kinda missing the forest for the trees -- we shouldn't be focused on people answering bad questions, we should be focused on making sure those are either closed & deleted faster, or that they are rejected by the quality filter.
If you don't have a question, you can't answer it.
!!/test aaaaaaaaaaaaaaaaaaaaaaa
@UnicornsAreVeryVeryYummy Blacklisted: Repeating characters in body, body has only one unique char
5:18 PM
aww no edit test?
!!/test jnijmkhbvgyhdsbhgvferghhg
@UnicornsAreVeryVeryYummy Not blacklisted
Ok, but what about the issue with answers to bad questions getting upvoted and not allowing the question to be roomba-ed, why not edit questions into shape that can be edited?
@Undo can you have some way to detect gibberish?
I remember (as said the my answer) a FR that informs answerers if the question has been closed
I think you are missing a camp: 5. Those users who visit the site to solve their problems, and who like to help others. Like 1 they want to have nice content, but their number one criterion is "is it helpful (and civil)"? They don't care much about "is it a good match for SE/constructive" and are frustrated by the deletionism of 1. They dont't care much about 2, answer the questions if it is not much effort, otherwise ignore them. They don't care about 3 either, and find the grudge of 1 against 3 silly. Let them have the rep they can get, if they're having fun and contributing useful content. — jdm Apr 26 '14 at 9:42
5:20 PM
Group 5 is very large, and contributes a lot to SO and SE sites in general. (Not much from any particular person, but a lot from the total). Having them discouraged from participating in the way they like would be bad.
That says it much better than I ever could.
@hichris123 not that high a bar ... :p
Good, that's my insult quota for the day achieved. Time for some weekend.
I need to remember that each time I read some Bart
Thank for a very detailed answer. I am really appreciated. — TBBT 9 hours ago
Yes you are ... yes you are
5:46 PM
00:00 - 18:0018:00 - 00:00

« first day (1808 days earlier)      last day (1824 days later) »