-NaN% posters and hamster smurfing!
-
You didn't see the phase where I went through a week of being Horatio Caine.
"No-one ever died at my bad jokes..." "but death isn't funny" YEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAH
-
You didn't see the phase where I went through a week of being Horatio Caine.
hmm.... not terribly funny but you havent gotten to the point where @loopback0 is right now.... he's been button pushing lately. ;-)
-
-
-
that's the button.
[insert irritated gekkering at @loopback0 here]
-
-
[insert very angry gekkering interspersed with deep growling and bareing of teeth]
-
hmm.... not terribly funny but you havent gotten to the point where @loopback0 is right now.... he's been button pushing lately.
He must be better at spotting than me - haven't noticed any typoes here.
(insert doomed attempt at rederailing)
-
wot yuo sya?! i ma veery gud at spellaring!
-
As you wish.
-
You didn't his post, though ...
-
-
you are right. i have corrected that now though.
-
-
Oh look, a Pokemon with a stick up its ass.
-
Oh look, a Pokemon with a stick up its ass.
-ahem-
What does a Turian do when he runs out of ammo? He takes the stick out of his ass as a backup weapon. -Garrus
-
After learning what @accalia does with her cane, I'm concerned that it has been used for less ... um, well, ... for purposes that one does not discuss in polite company.
Did she get one made from a bull member?
-
I assumed it was wooden. If not, that's even more reason to not want it.
-
-
hmm.... not terribly funny but you havent gotten to the point where @loopback0 is right now.... he's been button pushing lately. ;-)
"He pushing your buttons..." "...so you press his like button." YEEAAAAAAAAAAAAAH
-
Doing It Wrongβ’
"Yes, I'm doing it wrong..." "...for the wrong definition of wrong." YEAAAAAAAAAAAAAAH
-
-
And proudly so.
-
And then he presses @accalia's flag button.
-
What does a Turian do when he runs out of ammo? He takes the stick out of his ass as a backup weapon. -Garrus
He goes back to his ME1 weapon with unlimited ammo, rather than the stupid ME2 weapon, with exactly the same infinite ammo but a stupid disposable heatsink
-
I have been back 3 days give or take... and I'm a 25% poster again.
The curve is pretty flat back there. Even 10% should be really fast for the likes of you (like I can talk).
-
hmm... where is @arantor today i wonder?
@shadowmod monthposts
-
MonthPosts WITH exclusions AS ( /* Which categories to exclude from counters */ SELECT user_id, id, topic_id, post_number FROM posts WHERE raw LIKE '%[Magic Exclusion UUID]%' AND user_id IN ( SELECT gu.user_id FROM group_users gu WHERE group_id IN( SELECT g.id FROM groups g WHERE g.name IN ('admins') ) ) ), LastMonth AS ( /* Count eligible posts from last month */ SELECT row_number() OVER (ORDER BY count(*) DESC, bp.user_id), u.username, bp.user_id, count(*) FROM badge_posts bp JOIN users u on u.id=bp.user_id AND bp.user_id NOT IN ( /* ignore bots */ SELECT gu.user_id FROM group_users gu WHERE group_id IN( SELECT g.id FROM groups g WHERE g.name IN ('bots') ) ) WHERE topic_id NOT IN ( /* short topics */ SELECT topic_id FROM badge_posts GROUP BY topic_id HAVING count(topic_id) <10 ) AND topic_id NOT IN ( /* Ineligible topics */ SELECT topic_id FROM exclusions ) AND bp.created_at > CURRENT_DATE - INTERVAL '1 month' GROUP BY u.username, bp.user_id HAVING count(*) > 1 ORDER BY count(*) DESC, bp.user_id ), TotalUsers AS ( SELECT max(row_number) from LastMonth ), QUERY AS ( SELECT username, row_number, cast(row_number*100.0/TotalUsers.max AS numeric(36,2)) as percent, count, CURRENT_DATE granted_at FROM LastMonth, TotalUsers WHERE cast(row_number*100.0/TotalUsers.max AS numeric(36,2)) <= 25) SELECT row_number as rank, username, percent, count FROM QUERY Backup Date: Mon, 26 Jan 2015 09:08:30 GMT
-
151 Arantor 13.99% poster
climbing he is!current mark to make it into 10% is only 217 posts. ;-)
-
-
Well anyone can do thatβ¦
given proper dedication anyone could take my wooden spoon too.
217 posts/month is only an average of 7 and a bit posts per day.
my ~1.5k postsz/month is only ~ 50 posts/day
totally doable!
-
-
-
-
he also said bots weren't and there are..... how many instances of sockbot running around here?
-
Whoosh?
-
-
I'm messing.
Atwood could do with generally flagging with a mega whoosh. "Someone didn't get it".
-
-
that sounded remarkable like "badum tish"
or is a biaural sound? (only have the right ear in at the moment, and well too lasy to replay and see with both ears in (because i'd have to switch headsets. the left ear on this pair has been broken for ages.))
-
-
I'm going up. I think. Is there a single-user posts-per-day-over-time graph?
-
not yet. feel like taking a whack at the SQL?
-
I think it's one of the ones HJP knocked up a while back and posted the results to.
EDIT: maybe this, can't open pastebin at work.
http://what.thedailywtf.com/t/the-gross-picture-of-a-cow-orkers-thread/6896/56?u=loopback0
-
that one will probably get us most of the way there. that was not per user but an appropriate filter should get us the rest of the way there.
-
Maybe this?
Still can't open at work.http://what.thedailywtf.com/t/via-quote/1960/127
edit: Might not be users.
-
still not per user.
but it is a good start. ;-)
-
I'm guessing as I can't open the links
-
hmm... where is @arantor today i wonder?
@shadowmod monthposts
I was at a job interview. It was not useful.
-