Whoa, how did this suspension happen?

@bjb568 Probably @Braiam's creepy sunglasses.

@JasonC hey, those are Kool

meh, moderator says "I'm hurting the site with my edits" yet, he hasn't rolled back any

cv-plz stackoverflow.com/questions/25087222/…

Haha

@AnnaLear Yes

@AnnaLear Yay!

Why is the error message "you don't have permission to use this type of flag"? Can't it be more specific? Like "this post is already closed, so you cannot VLQ this".

@bjb568 why on your so profile it is displaying "This user has not participated in any tags" even you answered more than 200 questions

anything went wrong with your profile only :p

feature-request (q-ban on MSE, so can't post it there) When account unmerging or whenever, add an option to clear all SE cookies, I needed to remove the site cookies so I just cleared all browser cookies >:(

@TGMCians Because problems.

wut problems

My account got merged which caused everything to get borked.

anyone can explain me what are the expected values of inner join?

@Braiam what do you mean?

@Braiam blog.codinghorror.com/a-visual-explanation-of-sql-joins

what have you tried? :P

lol

Joins are confusing! Use MongoDB!

@AnnaLear I'm trying to count the tags per question

@AnnaLear that... now, figure out how to use it

@Braiam Checked the edits, they are fine. I would have even approved some of them :)

@Braiam Aren't they stored as <tag1><tag2><tag3>? In a nvarchar (150)?

@bjb568 yeah, but count(nvarchar) is a pain

so instead I'm going to count id's

Count occurrences of < or something.

@Braiam Wut?

@Braiam Don't reach out to others for joins, find your inner join.

@Braiam Just look in the PostTags table instead.

I feel like I'm the only one starring things...

select PostId as [Post Link], count(*)
from PostTags
group by PostId

@AnnaLear you broke it!! :( "he query processor ran out of internal resources and could not produce a query plan"

Oh yeah, don't run it for all questions :P

select pt.PostId as [Post Link], count(*)
from PostTags pt
inner join Posts p on p.Id = pt.PostId
where p.CreationDate >= getutcdate() - 7
group by pt.PostId

questions asked in the last week ^. you can filter it down further - questions that are /aren't closed, etc.

Yeah also don't run it for all questions because it graphs it whether you like it or not, and then there is fire.

@AnnaLear almost what I needed

^ lol

@bjb568 27bslash6.com/chat.html

1 CV left. stackoverflow.com/q/24920591/3890059

Why does that need to be closed?

@JasonC Is who's talking really more important that what they say?

@bjb568 It depends on what this is for. What I was going for with the lighter color was to make it not the primary focus. You could maybe go for a smaller font instead like they do here? It's not that it's more or less important, it's that it's important enough that you'd want to make it readable in a single visual scan instead of look left => look right => look left. In my opinion.

@Braiam You do know that every time that happens you have to pay Nick a dollar?

Consider that if you put it waaaay on the right, and presuming that you always want to know who said what, you force users to disrupt natural reading scans for every line, every time.

@rene I will tell him to put it in Anna account :P

hehehe

@rene :O But I like breaking things!

@JasonC Does it matter who said what? There's two extremes, a voice call where it's really important, and reddit, where nobody cares. I think my chat is in the middle.

@bjb568 Well I mean it could maybe be an interesting experiment; especially if it doesn't really matter who said what (i.e. this isn't for conversations, but, say, for isolated comments or one line reviews or something).

@bjb568 I don't know; only you can answer that, what is the primary purpose of this?

@bjb568 Yep, me too, cost me a fortune those 100 reputation points on sede

@JasonC Maybe I could make all signatures go poof on April 1.

@bjb568 Or randomly shuffle them among users, haha.

Ha! That would get some meta discussion going. Hey, bjb568 ... wait, isn't that me?! The developers must be crazy!

Plus, if nobody complains then you know it doesn't matter who said what, hehe.

@JasonC People always complain.

@bjb568 Well you could let complaints get up and down votes. Then you can judge what complaints are valid based on the overall balance, because the people that actually vote will totally be a representative sample of your population. Oh wait, that's stupid.

MSE is overrun by antideletionists!

Ahh I keep getting the chat sound and nobody is saying anything to me

yay! data.stackexchange.com/askubuntu/query/213287/…

That's 5 now!

The people in the LQRQ are like "Delete, comment. Delete, spam. Delete, new question. Delete, comment" - meta is like "Upvote, this is a helpful answer, answers don't have to be comprehensive. Upvote, this is a helpful answer, no need to flag them on recommendation questions. Upvote, this is sorta related and offers help. Upvote, this is good advice, it doesn't matter that it's unrelated".

@Braiam That graph, tho...

@bjb568 beats me...

I fart in the graph's general direction.

I think it does what the title says: Count of questions per amount of tags

if it doesn't I don't know :(

Try sorting it, so it's 1 tag, 2 tags, 3 tags, instead of a mess.

And invert the axis somehow.

select cnt, count

wait, what?

that's even worse than i, j

SELECT c, ct, cnt, cont, count, count2, counta

blames rene naming

sede graph allows two lines, right? ie. one for AnswerCount = 0 and another for AnswerCount != 0

Yeah.

BTW, that's eg (egsample), not ie (io elarify).

so, I need: select ( ... where AnswerCount = 0 ...) as unanswered, select ( ... where AnswerCount != 0 ...) as answered?

select (AnswerCount = 0) as isNotAnswered

?

I dunno.

^

(select sum(cnt) as [count]
       , cnt
from (select PostId, count(*) as cnt
from PostTags pt
group by PostId) as pt
inner join Posts p on p.Id = pt.PostId
where p.AnswerCount = 0) as [unanswered]
, (select sum(cnt) as [count]
       , cnt
from (select PostId, count(*) as cnt
from PostTags pt
group by PostId) as pt
inner join Posts p on p.Id = pt.PostId
where p.AnswerCount != 0) as [answered]

@bjb568 @JanDvorak ^

@Cupcake It is. But then there's meta voting which blows you out of the water fast.

I'm banned, and I'm not horrible, am I?

^ Haha, really?

doesn't look bad stackoverflow.com/users/reloaded/34397/slaks

I still think the badge totals thing just looks stupid.

#badge-dots-table td:not(:first-child) { display: none }

@Braiam It looks like shit.

Mine lists Sheriff, Research Assistant, and Marshal

@Cupcake caching :P

Would be awesome to see an elected pro-tem's. It'd probably be Sheriff, Constable, Marshal

@Braiam Is it by design that long sitenames overlap the rep: stackoverflow.com/users/reloaded/578411/rene My PCG rep is fully hidden...

COLLECT ALL THE TITLES!

@Cupcake heavy caching :P

I still maintain that if I printed my user profile page, ate the paper, drank a half gallon of vodka and vomited the whole watery mess onto a white floor, that is what it would look like.

@Cupcake Oh. I guess design defects are lower in prio than bugs? 60-80 years...

@animuson Ha, nice. So if I make a meta post asking how to get the Cupcake Killer badge, will you be disappointed that it went too far?

Nobody here is actively trying to convince you that it actually exists.

Technicalities.

Isn't the "Desperate Craftwife" badge a prerequisite for that anyways?

Ewww my laptop looks like it's been sitting in an attic for a year.

What is this sticky stuff on it? :x To the rubber gloves!

I stopped trying to clean the cat hair and coffee out of mine; I bought a parts lot with 4 replacement keyboards I found on eBay; I'm down to 2.

@animuson I want one! @Cupcake, create an account on Code Review so that I can destroy it, and claim this badge.

@Cupcake q-ban

Thanks for the votes, tho I dunno why'd you vote up a -12 question...

@JasonC About time for a new computer... don't you think?

Also, get a mac!

@bjb568 macs get worse after 1 week

@bjb568 It's a stock photo.

@bjb568 Eww, no.

@hichris123 That's kinda obvious.

NOOOO MACS ARE AWESOOOOME!

@bjb568 Could you please post that here?

Well, at least they design good websites. apple.com/mac-pro

@hichris123 Did it :P

@bjb568 Oh yeah, that's the Mac that looks like a trashcan.

@hichris123 I like trash cans. They have food in them.

Room go freezy.

@Cupcake Is it?

I dunno.

I feel kicked.

:P

I didn't finish unstaring.

@bjb568 ftfy. :P

Oh, that's taken care of.

Ok.

Why didn't I keep all the keys in order as I was cleaning them? I feel like I'm playing Scrabble now...

@bjb568 buzzfeed.com/summeranne/…

@animuson I WANT TO PLAY!

[ SmokeDetector ] All-caps title: HOW TO ACCESS THE PHONE VIA ADB ;BROKEN SCREEN on android.stackexchange.com

@bjb568 I would but I need it to not snap in half when I blow on it.

??

I'm pretty much die-hard Thinkpad T series.

I beat the heck out of my laptops. The aluminum cage reinforced display comes in handy.

What did they ever do to you?!

Well the last one made me dinner but there was a tad too much salt; the reasons for beating it were obvious I think.

@JasonC o.O

That's as-salt.

@AnnaLear Ba dum bum!

Thank you, thank you, I'm here all week. Try the veal.

Human meat tastes like veal. I know from... you know... my previous owners.

What is the PostFeedback table (as opposed to Votes)?

cv-plz stackoverflow.com/questions/25089498/…

migrate-to-meta stackoverflow.com/questions/25089692/…

@JasonC Isn't that the anonymous feedback stuff? Do they still do that?

@animuson yeah, that's it

@animuson I dunno it seems to contain all the same info as Votes except there's the "anonymous" column (although Votes still has null UserIds that also reflect this, I presume).

@hichris123 Beat me to it!

What... is this asking?

Dang it Anna, you're too fast for my flagging. >.<

del-pls stackoverflow.com/questions/25047492/…

@hichris123 Wow.

How is that guy still even allowed to ask questions? stackoverflow.com/users/3822146/user3822146?tab=questions

@JasonC He's not anymore. :P

BUT IF WE ONLY HAD SOA HE TOTALLY COULD HAVE ASKED HOW TO ASK FIRST!!!

... I have no idea why I feel compelled to talk endless crap on that proposal. I hate it so much. I guess I should lighten up.

waits for Stack Overflow Academy Academy

@Jamal I no rite

I have a feeling a lot of users will go there after they've asked a question and it got closed, and a lot of the answers will just be copy-pastes of what has already been said in comments.

Every question on SOA is going to end up falling into some form of one of the same two or three questions.

Yeah, I don't have high hopes for SOA.

Or just ask their questions there like they'd do on SO, essentially making it Stack Overflow for beginners.

I know. "How do I ask where to download Eclipse?" Comment: "Well I know it's off topic to answer but check out eclipse.org."

Uhm... wha????? stackoverflow.com/posts/23374800/revisions

cv-plz stackoverflow.com/q/6287729/2581872

cv-plz stackoverflow.com/questions/25079069/…

@Jamal How do I ask where to ask about asking about where to ask how to do my homework?

@JasonC Quora!

Haha

@hichris123 Invited to chat.stackoverflow.com/rooms/58120/…

@hichris123 Closed

Ugh... wish I had 2K rep.

@hichris123 wow a 10/11 of silver to bronze badges ratio

@Cupcake Oops. :P