-NaN% posters and hamster smurfing!
-
I might also drop from the 5% club in a week or two. I've got a coworker who is ... unaware of what's coming. Fortunately, I'm going to be well compensated for taking on his (admittedly small) workload.
-
That is an inferior survey.
... and there's an app for that: https://f-droid.org/repository/browse/?fdid=com.color.colornamer
-
that colour chart is massively inaccurate. still.... hmm.......
That is an inferior survey.
Since someone necroed, I'll ask if you two realize that the chart I provided came out of the same research?
-
-shrug- interesting read... also no i didn't realize.
-
also no i didn't realize.
Yeah, it surprised me that you two jumped on it at the time, because I remembered when the survey came out, so I already then knew that both were from the same place. But the full one didn't support the joke I was making, about guys not recognizing many colors.
-
Yeah, it surprised me that you two jumped on it at the time,
as i recall that was a bit of a slow day. ;-)
-
as i recall that was a bit of a slow day.
I'm tempted, at this point, to give you a retroactive whoosh flag.
-
I'm tempted, at this point, to give you a retroactive whoosh flag.
i have enough woosh badgers i think. besides if you wait i'm bound to do something to earn a fresh new one soon.
-
i have enough woosh badgers i think.
Aw, c'mon, they're like pokemon. (Aside: IE's spell corrector puts in the accent; Chrome, not so much).
besides if you wait i'm bound to do something to earn a fresh new one soon.
*brightens up* That's true.
-
It would be funny.
-
i have enough woosh badgers i think. besides if you wait i'm bound to do something to earn a fresh new one soon.
You will (likely) never have enough whoosh baguettes.
-
-
No repro.
-
-
-
-
@shadowmod monthposts please
-
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: Thu, 08 Jan 2015 03:59:58 GMT
-
I see my post count is recovering from the holidays.
-
indeed. I've got my work cut out for me if i want to overtake you in the 2nposts query.
-
You're getting there. A lot also hinges on if / what happens with the CS import.
-
You're getting there. A lot also hinges on if / what happens with the CS import.
that would give you a massive edge. of course if i keep the spoon badge it would really be only a matter of time before i clawed my way to the top. ;-)
-
Yep
-
I'd be more worried about Blakey:
-
Oh, yeah, I've looked at the numbers. I was just talking about me and @accalia, though.
-
-
-
That's not ever going to happen.
-
works because i'l TL3 and can't override params (even though i wrote it!)
I know why it works :)
-
-
well, there's nothing wrong with being polite, is there?
Of course not, my dearest foxy lady
-
Of course not, my dearest foxy lady
oh stop. you'll make me blush IRL and that'll be embarassing.
-
-
That's not ever going to happen.
What, people worrying about you?
Edit: that was a joke. I know what you meant. Feel free to rant anyway if you want.
-
Feel free to rant anyway if you want.
does he need permission? what would happen if we revoked that permission?
-
-
I figured it might redirect the rant or something.
hmm... can those be directed?
if we could figure out how to do it reliably across the internet we may have discovered a new form of clean, renewable energy!
-
hmm... can those be directed?
Well, I thought it might irritate him enough to know that I anticipated the rant that he might not do it, but then I remembered who I was dealing with.
-
I wonder if that report is ready?
@shadowmod monthposts if you would be so kind?
-
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: Fri, 09 Jan 2015 03:59:25 GMT
-
Still mid-10% range. Well, here's ++post_count, anyway.
-
-
@shadowmod 2nposts
-
2nPosts accalia 10 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') ) ) ) SELECT u.username, count(*) AS posts, log(2.0, count(*)) AS log2posts FROM badge_posts bp JOIN users u on u.id=bp.user_id AND u.username ILIKE $1::varchar 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 ) AND u.username ILIKE $1::varchar GROUP BY u.username ORDER BY count(*) DESC LIMIT $2::int username | posts | log2posts accalia | 5862 | 12.5171772526895414 Backup Date: Fri, 09 Jan 2015 03:59:25 GMT
-
Why's the limit 10 when it'd only ever return a single row by default? :D
-
Why's the limit 10 when it'd only ever return a single row by default? :D
TL4 and staff can alter the parameters to potentially query about multiple users. such as:
@shadowmod 2nposts pjh%
-
2nPosts pjh% 50 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') ) ) ) SELECT u.username, count(*) AS posts, log(2.0, count(*)) AS log2posts FROM badge_posts bp JOIN users u on u.id=bp.user_id AND u.username ILIKE $1::varchar 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 ) AND u.username ILIKE $1::varchar GROUP BY u.username ORDER BY count(*) DESC LIMIT $2::int Backup Date: Fri, 09 Jan 2015 03:59:25 GMT
-
I was not expecting a graph ...
-
And, seemingly, your default isn't 10.
-
And, seemingly, your default isn't 10.
Apparently @accalia decided that the statsbot needed some discoursistency. ;)