username: Karla
trust level: 2 (Not locked)
In the last 100:
Visits: 61/50
Topics Replied To: 22/10
Topics Viewed: 453/246
Total Topics Viewed: 2551/200
Posts Read: 25530/22976
Total Posts Read: 141641/500
Flagged Posts: 0/5 (max)
Flagged By: 0/5 (max)
Likes Given: 55/30
Likes Received: 110/20
Liked on Days: 26/7
Liked by users: 40/5
Status: Met requirements, should be promoted soon!
shadowmod
@shadowmod
1347
Reputation
17512
Posts
535
Profile views
0
Followers
0
Following
Best posts made by shadowmod
-
RE: I got promoted to senior developer - YAY!
-
RE: Can the 'X% Poster'-Badges just stay?
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: Wed, 07 Jan 2015 04:01:55 GMT
-
RE: -NaN% posters and hamster smurfing!
Attendance antiquarian 50 WITH StartingPoints AS ( SELECT user_id, visited_at, ROW_NUMBER() OVER(ORDER BY user_id, visited_at) AS rownum FROM user_visits AS A WHERE NOT EXISTS ( SELECT * FROM user_visits AS B WHERE B.visited_at = A.visited_at - 1 AND B.user_id = A.user_id ) ), EndingPoints AS ( SELECT user_id, visited_at, ROW_NUMBER() OVER(ORDER BY user_id, visited_at) AS rownum FROM user_visits AS A WHERE NOT EXISTS ( SELECT * FROM user_visits AS B WHERE B.visited_at = A.visited_at + 1 AND B.user_id = A.user_id ) ) SELECT u.username, S.visited_at AS start_range, E.visited_at AS end_range, (E.visited_at - S.visited_at +1) AS Days FROM StartingPoints AS S JOIN EndingPoints AS E ON E.rownum = S.rownum JOIN users u ON u.id=S.user_id AND u.username ILIKE $1::varchar ORDER BY S.visited_at DESC LIMIT $2::int username | start_range | end_range | days antiquarian | 2014-11-10 | 2015-01-10 | 62 antiquarian | 2014-09-07 | 2014-11-08 | 62 antiquarian | 2014-08-17 | 2014-09-05 | 20 antiquarian | 2014-07-27 | 2014-08-15 | 20 antiquarian | 2014-07-13 | 2014-07-25 | 13 antiquarian | 2014-07-06 | 2014-07-11 | 6 antiquarian | 2014-06-22 | 2014-07-03 | 12 antiquarian | 2014-06-07 | 2014-06-19 | 13 antiquarian | 2014-06-01 | 2014-06-05 | 5 antiquarian | 2014-05-25 | 2014-05-29 | 5 antiquarian | 2014-05-20 | 2014-05-22 | 3 Backup Date: Sun, 11 Jan 2015 03:33:17 GMT
-
RE: -NaN% posters and hamster smurfing!
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: Sun, 11 Jan 2015 03:33:17 GMT
-
RE: Not a button
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: Sat, 24 Jan 2015 03:59:52 GMT
Latest posts made by shadowmod
-
RE: I got promoted to senior developer - YAY!
username: Karla trust level: 2 (Not locked) In the last 100: Visits: 61/50 Topics Replied To: 22/10 Topics Viewed: 453/246 Total Topics Viewed: 2551/200 Posts Read: 25530/22976 Total Posts Read: 141641/500 Flagged Posts: 0/5 (max) Flagged By: 0/5 (max) Likes Given: 55/30 Likes Received: 110/20 Liked on Days: 26/7 Liked by users: 40/5 Status: Met requirements, should be promoted soon!
-
RE: I got promoted to senior developer - YAY!
username: chozang trust level: 2 (Not locked) In the last 100: Visits: 45/50 Topics Replied To: 34/10 Topics Viewed: 99/246 Total Topics Viewed: 201/200 Posts Read: 9564/22976 Total Posts Read: 25633/500 Flagged Posts: 0/5 (max) Flagged By: 0/5 (max) Likes Given: 280/30 Likes Received: 92/20 Liked on Days: 31/7 Liked by users: 37/5 Status: Below requirements.
-
RE: I got promoted to senior developer - YAY!
username: Karla trust level: 2 (Not locked) In the last 100: Visits: 61/50 Topics Replied To: 22/10 Topics Viewed: 453/246 Total Topics Viewed: 2551/200 Posts Read: 14085/22976 Total Posts Read: 130196/500 Flagged Posts: 0/5 (max) Flagged By: 0/5 (max) Likes Given: 50/30 Likes Received: 94/20 Liked on Days: 26/7 Liked by users: 35/5 Status: Below requirements.
-
RE: I got promoted to senior developer - YAY!
username: accalia trust level: 3 (Not locked) In the last 100: Visits: 100/50 Topics Replied To: 428/10 Topics Viewed: 1041/246 Total Topics Viewed: 8027/200 Posts Read: 88508/22976 Total Posts Read: 1839558563/500 Flagged Posts: 0/5 (max) Flagged By: 0/5 (max) Likes Given: 2251/30 Likes Received: 5214/20 Liked on Days: 101/7 Liked by users: 168/5 Status: Above requirements.
-
RE: Consider Changing Your Password?
username: Vaire trust level: 2 (Not locked) In the last 100: Visits: 50/50 Topics Replied To: 47/10 Topics Viewed: 235/251 Total Topics Viewed: 647/200 Posts Read: 51197/23208 Total Posts Read: 149152/500 Flagged Posts: 0/5 (max) Flagged By: 0/5 (max) Likes Given: 376/30 Likes Received: 222/20 Liked on Days: 52/7 Liked by users: 76/5 Status: Within 90% of requirements, may be promoted soon!
-
RE: The Question is What Is The Question?
username: tar trust level: 2 (Not locked) In the last 100: Visits: 94/50 Topics Replied To: 160/10 Topics Viewed: 216/251 Total Topics Viewed: 2553/200 Posts Read: 17930/23758 Total Posts Read: 213216/500 Flagged Posts: 0/5 (max) Flagged By: 0/5 (max) Likes Given: 1134/30 Likes Received: 1303/20 Liked on Days: 97/7 Liked by users: 116/5 Status: Below requirements.
-
RE: The Question is What Is The Question?
username: PleegWat trust level: 3 (Not locked) In the last 100: Visits: 100/50 Topics Replied To: 308/10 Topics Viewed: 1030/251 Total Topics Viewed: 5157/200 Posts Read: 124458/23758 Total Posts Read: 441840/500 Flagged Posts: 0/5 (max) Flagged By: 0/5 (max) Likes Given: 260/30 Likes Received: 935/20 Liked on Days: 96/7 Liked by users: 119/5 Status: Above requirements.
-
RE: I am late to the party, AMWTAM
username: Dlareg trust level: 2 (Not locked) In the last 100: Visits: 64/50 Topics Replied To: 29/10 Topics Viewed: 279/276 Total Topics Viewed: 460/200 Posts Read: 100838/24002 Total Posts Read: 123330/500 Flagged Posts: 0/5 (max) Flagged By: 0/5 (max) Likes Given: 37/30 Likes Received: 162/20 Liked on Days: 30/7 Liked by users: 67/5 Status: Met requirements, should be promoted soon!