-NaN% posters and hamster smurfing!
-
-
@todo conspire to get @loopback0 the wooden spoon of shame
@todo conspire to get @loopback0 the wooden spoon of shame
@shadowmod monthposts
-
MonthPosts Backup Date: 2015-05-07 02:56:51
[Query
``` 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 ```
Click for interactive graph.](https://plot.ly/~shadowmod/614)
-
You'd need cooperation from:
- you two
- Boomzilla
- blakeyrat
- Onyx
- FrostCat
- me
- dkf
To give loopback0 the spoon. Good luck with that.
-
-
-
you two
Easy!
@abarker said:Onyx
Don't see why he wouldn't help out
@abarker said:Boomzilla
Eh… could persuade him I guess
@abarker said:FrostCat
dkf
Maybe, dunno
@abarker said:me
*makes cute eyes*
@abarker said:blakeyrat
*abandons all hope*
-
@RaceProUK said:
FrostCat
Maybe, dunno
dkfSure, I'll help: @loopback0, post a bunch more!
-
-
Sure, I'll help: @loopback0, post a bunch more!
Are you trying to get the spoon for @loopback0, or yourself?
-
Progress!
-
Are you trying to get the spoon for @loopback0, or yourself?
If he posts more, he gets the spoon. I've already had it. It's a lot of pressure being on top.
-
-
I don't even need to say it, now that it is a statement of fact.
-
If he posts more, he gets the spoon. I've already had it. It's a lot of pressure being on top.
Using t\1000 as an analogous scenario: meh.
Also:
No it isn't
-
And I'm out of the club again. Why does this stupid thing — I think it's called a life, whatever that means — keep interfering with TDWTF?
Filed under: It's not really a life; it's just a different lonely nerdiness than TDWTF.
-
No matter what the feminists say, YOU CAN'T HAVE IT ALL!
-
-
-
I bought some batteries but they weren't included.
The rest of that Steven Wright joke is "...so I had to buy them again."
-
Yes.
-
QUICK! SOMEONE START POSTING MORE!
they gave me the spoon again!
-
Why doesn't someone start posting less? ;)
-
@accalia and @boomzilla are fairly close to being able to give it back to the rat.
-
@accalia and @boomzilla are fairly close to being able to give it back to the rat.
ick! 'd rather giveit back to @boomilla
-
-
I know, what was I thinking?!
-
QUICK! SOMEONE START POSTING MORE!
I'd have to increase my rate by about 300/month. Not that I haven't been that high before, but it's been a while.
-
@loopback0 said:
@accalia and @boomzilla are fairly close to being able to give it back to the rat.
ick! 'd rather giveit back to @boomilla
I don't have strong feelings one way or the other. But the other could be funnier.
-