-NaN% posters and hamster smurfing!
-
How much closer am I now?
-
LIMIT 25 username | count ------------+------- chubertdev | 4093 (1 row) Elapsed: 1.68s Backup taken: 2014-11-18 08:11:40.586255
-
Looks like today's the day.
-
What about me?
-
well if @pjh is handing those out i'll admit to being curious too.
-
-
Hmm - seems my script this morning was a bit out of whack with the current badge queries for some reason - @chubertdev's was slightly off:
[postgres@sofa ~]$ sql_tdwtf 2n_posts # How many eligible posts have been made WITH exclusions AS ( /* Which categories to exclude from counters */ SELECT user_id, id, topic_id, post_number FROM posts WHERE raw LIKE '%[UUID excluded to prevent this thread being marked as excluded]%' 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') ) ) ) SELECT u.username, count(*) FROM badge_posts bp JOIN users u on u.id=bp.user_id AND u.username LIKE '%' WHERE topic_id NOT IN ( /* Topics with less than 10 posts */ SELECT topic_id FROM badge_posts GROUP BY topic_id HAVING count(topic_id) < 10 ) AND topic_id NOT IN ( /* Excluded topics */ SELECT topic_id FROM exclusions ) GROUP BY u.username ORDER BY count(*) DESC LIMIT 25 username | count --------------+------- Arantor | 6602 boomzilla | 5164 chubertdev | 4003 blakeyrat | 3539 accalia | 3288 FrostCat | 3261 PJH | 3164 Matches | 2915 Onyx | 2467 HardwareGeek | 2444 abarker | 2421 darkmatter | 2312 dkf | 2245 ben_lubar | 2083 mott555 | 1847 Intercourse | 1750 cartman82 | 1723 Keith | 1654 Maciejasjmj | 1411 faoileag | 1259 aliceif | 1230 Luhmann | 1171 Yamikuronue | 1146 dhromed | 1143 Zecc | 1082 (25 rows) Elapsed: 1.652s Backup taken: 2014-11-18 08:11:40.586255 [postgres@sofa ~]$
-
hmm.... just over 800 posts to go. (3200 (and counting) to reach the top)
still that's impressive, considering that i really became active on the forum less than 100 days ago according to the badges (as i am missing the 100% yet)
hmm.... that means i average.... over 30 eligable posts/day....
maybe i do spend too much time on here.
-
username | count --------------+------- Arantor | 6602 boomzilla | 5164 chubertdev | 4003
Wow...I'm a lot closer to @Arantor in eligible posts than I thought I would be.
-
failed hanzo! nooooooo!
Wow...I'm a lot closer to @Arantor in eligible posts than I thought I would be.
that was a surprise to me too. you must have caught up during @arantors recent absence.
-
you must have caught up during @arantors recent absence.
Definitely, though I guess I hadn't gone through and added up his posts in those threads like I did mine.
Now that he's back, I'm sure he'll put some distance between us, though.
-
Now that he's back, I'm sure he'll put some distance between us, though.
he'll also possibly steal my wooden spoon.
i like my wooden spoon.
-
I'm actually pretty comfortable with my position. I'm in no rush to climb the 2^n ladders.
-
he'll also possibly steal my wooden spoon.
i like my wooden spoon.
You'll have to join us lowly 5-percenters
-
I'm in no rush to climb the 2^n ladders.
I'm not either. Not that I don't want to climb, but the rungs are far enough apart that it's just not feasible to rush it. Though I had fun getting to 2^13 total posts recently. In any case, the way to climb is to just talk because you have something to say.
-
You'll have to join us lowly 5-percenters
lowly? hardly. WE ARE THE FIVE PERCENT!
(also it's lonely being on top)
-
In any case, the way to climb is to just talk because you have something to say.
that's probably whyi i've climbed so rapidly.
I'm expecting to plateau, and possibly backslide during Build Season
-
-
You're going to delete some posts?
no, but i'll have a lot less time for posting. i'll definetly lose the wooden spoon then.
-
no, but i'll have a lot less time for posting. i'll definetly lose the wooden spoon then.
Oh, I see the confusion. @boomzilla and I were discussing the 2^n badges. You were talking about the frequent poster badges.
-
-
You were talking about the frequent poster badges.
or more specifically the rate of climbing up the 2^n ladder.
;-)
-
Thanks.
-
-
Yeah, I did. I should have replied to the other one, but yeah, I saw that I'm close, but not there yet (that's totally what she said).
-
hmm.... and i would have too if you hadn't said it for me. ;-)
-
Hmm, I have a long way to go for the 2^12 badge. I have well over 212 total, but over 46% of my posts are in ineligible topics. :(
-
Hm, I've got a way to go I guess. I tend to think I make a lot of posts, and i've got 25% somehow, but actually not at
1<<7
yet...
-
My eligible posts are nearly past my CS post total.
-
I think that mine were on day one.
-
-
i know mine were.
for whatever reason CS was convinced that my registration was a spam registration so my post count was 0, despite being fairly regular reader/lurker.
-
I was active on CS for about 11 months before we were infected with Dicsores, and I averaged a little under 2 posts/day — just under 600 posts. I have forgotten how long it took to pass that here — a while, but not nearly as long as on CS — I think it was around 1 - 1.5 months.
-
I blame discourse. THe 2^7 badge has a different colour from the lower ones.
-
My eligible posts are nearly past my CS post total.
I did that in like a month. I even commented at the time--in 9 years I only had ~650 total CS posts.
-
Based on my calculations, only about a fifth of my posts are ineligible. I don't think that's too bad, especially with the status thread...
-
Still ~800 posts short on here comparing eligible posts with my CS count...
-
How about a "who's in the top n%" roundup?
If I read your query right I've still got 800 posts to go, sigh.
You better watch out, Accalia--I've got the gap down to 20 posts. :)
-
[postgres@sofa tmp]$ LIMIT=60 sql_tdwtf month_posts # post counts over last month WITH exclusions AS ( /* Which categories to exclude from counters */ SELECT user_id, id, topic_id, post_number FROM posts WHERE raw LIKE '%[UUID removed to prevent this thread accidentally being marked as excluded]%' 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, user_id, 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)) < 30 LIMIT 60) SELECT row_number as rank, username, percent, count FROM QUERY rank | username | percent | count ------+------------------+---------+------- 1 | accalia | 0.43 | 1712 2 | FrostCat | 0.85 | 1120 3 | boomzilla | 1.28 | 1066 4 | chubertdev | 1.70 | 1023 5 | blakeyrat | 2.13 | 975 6 | Arantor | 2.55 | 909 7 | Intercourse | 2.98 | 727 8 | PJH | 3.40 | 555 9 | abarker | 3.83 | 538 10 | HardwareGeek | 4.26 | 520 11 | mott555 | 4.68 | 480 12 | aliceif | 5.11 | 457 13 | Yamikuronue | 5.53 | 395 14 | loopback0 | 5.96 | 356 15 | Onyx | 6.38 | 333 16 | Luhmann | 6.81 | 293 17 | cartman82 | 7.23 | 279 18 | Maciejasjmj | 7.66 | 274 19 | dkf | 8.09 | 263 20 | flabdablet | 8.51 | 218 21 | Jaloopa | 8.94 | 216 22 | Eldelshell | 9.36 | 187 23 | Magus | 9.79 | 185 24 | Zecc | 10.21 | 183 25 | Weng | 10.64 | 178 26 | tarunik | 11.06 | 166 27 | hungrier | 11.49 | 162 28 | antiquarian | 11.91 | 161 29 | ben_lubar | 12.34 | 159 30 | Keith | 12.77 | 148 31 | redwizard | 13.19 | 145 32 | OffByOne | 13.62 | 145 33 | LurkerAbove | 14.04 | 134 34 | lucas | 14.47 | 129 35 | RaceProUK | 14.89 | 119 36 | Monarch | 15.32 | 114 37 | locallunatic | 15.74 | 101 38 | delfinom | 16.17 | 101 39 | anonymous234 | 16.60 | 99 40 | Buddy | 17.02 | 98 41 | codinghorror | 17.45 | 93 42 | VinDuv | 17.87 | 92 43 | royal_poet | 18.30 | 92 44 | smallshellscript | 18.72 | 92 45 | JazzyJosh | 19.15 | 91 46 | ijij | 19.57 | 91 47 | riking | 20.00 | 88 48 | PleegWat | 20.43 | 88 49 | DoctorJones | 20.85 | 87 50 | another_sam | 21.28 | 86 51 | Groaner | 21.70 | 80 52 | Gaska | 22.13 | 80 53 | algorythmics | 22.55 | 79 54 | ChaosTheEternal | 22.98 | 73 55 | JBert | 23.40 | 69 56 | Spencer | 23.83 | 67 57 | EvanED | 24.26 | 63 58 | powerlord | 24.68 | 63 59 | Shoreline | 25.11 | 61 60 | xaade | 25.53 | 57 (60 rows) Elapsed: 1.536s Backup taken: 2014-11-18 08:11:40.586255
Includes the first two 'outsiders.'
-
You better watch out, Accalia--I've got the gap down to 20 posts. :)
20 posts you say?
:-P
-
Does this yake moo a Spoonerism?
-
i'm afraid i didn't follow that one?
-
-
i've been busy.:-)
-
"yake moo" instead of "make you." I assume you made a typo somewhere.
-
"yake moo" instead of "make you." I assume you made a typo somewhere.
i got the spoonerism. and i even got the typo reference, maybe....
but i have to ask: WHAT typo? even without hanzo edits there's no typo in that post....
edit: (unlike this post)
-
Holy fish paste!
Also, it's till only 20 posts for the other eligible post count.
Discurse, if I accidentally type stuff into the quote box, it's not an empty post. There's still a quote. Also fuck you for the wagging nagger. It's not funny when Wordpress does it.
-
i'll give you that. you are catching up to me in all time posts, but not in posts in the last month. :-P
-
I'll just wait until your robo build season.
-
yeah. that'll slow me down a lot.
also holy fishpaste on a crutch.... that means i've done an average of 60 posts a day for the past month?!
(discorounded of course)