The forum only has one passable poster
-
-
Total number of likes anyone?
Edit - excluding /t/1000 of course...
I'm currently on 31k received. Go on, you know you want to.
-
Ok - including /t/1000 first...
SELECT row_number() OVER (ORDER BY SUM(badge_posts.like_count) DESC) as n, SUM(badge_posts.like_count) likes, users.username FROM badge_posts, users WHERE badge_posts.user_id = users.id GROUP BY users.username ORDER BY SUM(badge_posts.like_count) DESC LIMIT 50 "n" "likes" "username" "1" "46295" "faoileag" "2" "43975" "abarker" "3" "36166" "darkmatter" "4" "30933" "Arantor" "5" "26919" "boomzilla" "6" "22069" "Onyx" "7" "19087" "HardwareGeek" "8" "16087" "Luhmann" "9" "13596" "ChaosTheEternal" "10" "10291" "PJH" "11" "9735" "mott555" "12" "5885" "Spencer" "13" "5419" "aliceif" "14" "5290" "the_dragon" "15" "5074" "DoctorJones" "16" "4899" "error" "17" "4660" "blakeyrat" "18" "3973" "ben_lubar" "19" "3609" "dhromed" "20" "3160" "redwizard" "21" "2996" "chubertdev" "22" "2585" "Keith" "23" "2573" "Matches" "24" "2475" "tufty" "25" "2141" "Zecc" "26" "2116" "Nagesh" "27" "2046" "cartman82" "28" "1860" "GOG" "29" "1811" "loopback0" "30" "1642" "DrakeSmith" "31" "1516" "dkf" "32" "1345" "accalia" "33" "1249" "Intercourse" "34" "1223" "Maciejasjmj" "35" "1188" "sam" "36" "960" "algorythmics" "37" "937" "riking" "38" "810" "Yamikuronue" "39" "810" "M_Adams" "40" "731" "VinDuv" "41" "716" "codinghorror" "42" "649" "presidentsdaughter" "43" "635" "antiquarian" "44" "617" "SignatureGuy" "45" "566" "mikeTheLiar" "46" "562" "anonymous234" "47" "450" "fatbull" "48" "449" "OffByOne" "49" "441" "Bort" "50" "423" "CodingHorrorBot"
-
Excluding /t/1000
SELECT row_number() OVER (ORDER BY SUM(badge_posts.like_count) DESC) as n, SUM(badge_posts.like_count) likes, users.username FROM badge_posts, users WHERE topic_id != 1000 AND badge_posts.user_id = users.id GROUP BY users.username ORDER BY SUM(badge_posts.like_count) DESC LIMIT 50 "n" "likes" "username" "1" "3590" "boomzilla" "2" "3500" "Arantor" "3" "2628" "blakeyrat" "4" "2564" "Onyx" "5" "2227" "chubertdev" "6" "2197" "Keith" "7" "2002" "PJH" "8" "1734" "cartman82" "9" "1536" "ben_lubar" "10" "1514" "darkmatter" "11" "1499" "Matches" "12" "1443" "faoileag" "13" "1425" "HardwareGeek" "14" "1394" "dkf" "15" "1341" "mott555" "16" "1332" "abarker" "17" "1214" "DoctorJones" "18" "1185" "Maciejasjmj" "19" "1116" "dhromed" "20" "1000" "error" "21" "907" "Zecc" "22" "810" "Yamikuronue" "23" "803" "sam" "24" "800" "Intercourse" "25" "783" "Luhmann" "26" "699" "tufty" "27" "648" "aliceif" "28" "635" "antiquarian" "29" "561" "codinghorror" "30" "497" "anonymous234" "31" "484" "algorythmics" "32" "444" "Nagesh" "33" "414" "mikeTheLiar" "34" "388" "ChaosTheEternal" "35" "384" "morbiuswilters" "36" "338" "LoremIpsum" "37" "333" "accalia" "38" "332" "FrostCat" "39" "327" "Kuro" "40" "324" "Lorne_Kates" "41" "322" "VinDuv" "42" "318" "DrakeSmith" "43" "317" "PaulaBean" "44" "315" "hungrier" "45" "313" "riking" "46" "313" "M_Adams" "47" "296" "Captain" "48" "270" "Bort" "49" "260" "apapadimoulis" "50" "251" "loopback0"
-
I only need 18 to overtake @faoileag outside that topic. Pleeeeeeease like me.
-
including /t/1000
Woohoo, top 10!
I do need to post some more in there when I find time, try to cement my position there some more.
Excluding /t/1000
Woohoo, top 50!
Though I'm sure that's likely to change sooner rather than later.
-
PJH said:
including /t/1000Woohoo, top 10!
I do need to post some more in there when I find time, try to cement my position there some more.
I'm the #7 poster in that topic, so it's not surprising that I'm #7 in total likes, since 92.5% of my likes are from that topic. Hmm, sterling silver is 92.5% silver and 7.5% (usually) copper. Am I a sterling poster?
-
Should I be proud of the fact that nearly 10% of my total Likes are all on a single post?
-
How are we on likes given?
-
Here are the links, in case someone actually wants to read the stuff instead of measure their epeens.
- 1. Lorne_Kates (27 likes)
- 2. DoctorJones (24 likes)
- 3. Lorne_Kates (22 likes)
- 4. ender (21 likes)
- 5. DoctorJones (20 likes)
- 6. mott555 (20 likes)
- 7. aliceif (20 likes)
- 8. Matches (20 likes)
- 9. Cursorkeys (20 likes)
- 10. DoctorJones (19 likes)
- 11. jaloopa (19 likes)
- 12. Matches (19 likes)
- 13. WTF (19 likes)
- 14. Onyx (18 likes)
- 15. LoremIpsum (18 likes)
- 16. redwizard (18 likes)
- 17. codinghorror (17 likes)
- 18. dhromed (17 likes)
- 19. Maciejasjmj (17 likes)
- 20. chubertdev (17 likes)
- 21. error (17 likes)
- 22. Luhmann (17 likes)
- 23. cartman82 (17 likes)
- 24. sam (17 likes)
- 25. boomzilla (17 likes)
- 26. cartman82 (16 likes)
- 27. GoatboyCH (16 likes)
- 28. Zecc (16 likes)
- 29. HardwareGeek (16 likes)
- 30. cartman82 (16 likes)
- 31. blakeyrat (16 likes)
- 32. Onyx (16 likes)
- 33. blakeyrat (16 likes)
- 34. Intercourse (16 likes)
- 35. ben_lubar (16 likes)
- 36. chubertdev (16 likes)
- 37. Arantor (15 likes)
- 38. blakeyrat (15 likes)
- 39. Yamikuronue (15 likes)
(dropping the code here, just in case we need it again: http://repl.it/ZNc)
-
I find it somehow satisfying that my most-liked post is one poking fun at @blakeyrat.
-
TIL the way to TDWTF glory:
- Write a poignant goodbye post
- End with a witty one-liner
-
TIL the most hated person on the forums has a better liked post than @blakeyrat.
-
TIL the most hated person on the forums has a better liked post than @blakeyrat.
Somehow I missed liking that post by @blakeyrat. Remedied, and now he's tied with the most hated person on the forums.
-
-
Today I Learned. I forgot there are old people around. :-)
-
Today I Learned. I forgot there are old people around.
Hey now!
Now I'm curious how you define "old people".
-
Hey now!
Now I'm curious how you define "old people".
Birth year after your nick, duh.
-
555 has nothing to do with my birth year. I strongly suspect nobody on TDWTF was born in 555 (either B.C. or A.D. for the pedants).
-
5/5/5?
Oh wait, that would mean you're probably too young for this place.
Or over 2000 years old.
-
How are we on likes given?
That one will be (given what I think I've got to work with...), erm, interesting if I'm to filter out /t/1000...
-
Now part of me wants to keep my age secret since apparently I'm old, and presumably wise, experienced, and seasoned as a result. Wouldn't want to spoil that perception, though I'm sure I've mentioned my age before.
-
How many are people bitching about Discourse? That's the closest thing to agreement we've ever seen.
-
TIL the most hated person on the forums has a better liked post than @blakeyrat.
Yes but that post was also a sign of Jeff largely not blighting our forum with his actual presence, only indirectly.
-
-
-
I remember where you basically gave that info away.
It also means, if you're accurate about what you said in that spot, that I'm older than you are.
-
I'm under 100 posts behind you and I'm catching you up.
That result set was a count of likes, not posts.
-
This post is deleted!
-
apparently I'm old,
By some definitions, yes.
presumably wise, experienced, and seasoned as a result.
Presumably, and I think I manage to put that over reasonably well in public. People who really know me (e.g., my kids and ex-wife, not to mention myself), however, know all too well how unwise I really am.
-
-
Discourse is awful in every conceivable way and @codinghorror has never done anything wrong
Please note, he said:
@Zacrath said:how controversial does it have to be
Not self-destructive. Controversial.
-
@discobot due to posting fail. This is what I tried to post but DissedCourse kept my originally intended-to-reply-to quote instead of the one I wanted:
Discourse is stupid and broken and everyone should use PDF instead of MS Office files in all cases.
Please note, he said:
@Keith said:how controversial does it have to be to cancel out the otherwise guaranteed likes?
Not self-destructive. Controversial.Ah well, @codinghorrorbot
-
@redwizard Is Doing It Wrongโข<t3241p183>
-
[Likes given] will be (given what I think I've got to work with...), erm, interesting if I'm to filter out /t/1000...
Again, up to 2014-09-17 02:53:00UTC...
Including /t/1000
SELECT count(pa.user_id), u.username FROM post_actions pa JOIN users u on u.id = pa.user_id JOIN posts p on p.id = pa.post_id WHERE pa.post_action_type_id = '2' GROUP BY pa.user_id, u.username ORDER BY count(pa.user_id) DESC LIMIT 30 "count" "username" "20139" "HardwareGeek" "19879" "mott555" "18934" "boomzilla" "18746" "obeselymorbid" "18723" "Spencer" "17937" "ChaosTheEternal" "17347" "Luhmann" "17305" "abarker" "17105" "Onyx" "17095" "darkmatter" "16974" "Arantor" "16378" "the_dragon" "15318" "Maciejasjmj" "14534" "reverendryan" "14456" "faoileag" "10261" "aliceif" "8670" "M_Adams" "6784" "DoctorJones" "6390" "GOG" "3931" "oojimaflib" "3862" "Zecc" "3747" "VinDuv" "3320" "antiquarian" "3309" "accalia" "3079" "redwizard" "3058" "ben_lubar" "2800" "SockPuppet" "2586" "tufty" "2557" "dkf" "2552" "null_loop"
Excluding /t/1000
SELECT count(pa.user_id), u.username FROM post_actions pa JOIN users u on u.id = pa.user_id JOIN posts p on p.id = pa.post_id WHERE pa.post_action_type_id = '2' and p.topic_id != 1000 GROUP BY pa.user_id, u.username ORDER BY count(pa.user_id) DESC LIMIT 30 "count" "username" "6533" "Arantor" "3320" "antiquarian" "3206" "Onyx" "3142" "DoctorJones" "2757" "ben_lubar" "2519" "dkf" "2302" "HardwareGeek" "2128" "boomzilla" "1829" "chubertdev" "1765" "Yamikuronue" "1535" "cartman82" "1504" "hungrier" "1448" "mott555" "1367" "aliceif" "1086" "error" "1073" "faoileag" "1052" "nobulate" "1014" "Keith" "978" "Intercourse" "956" "abarker" "839" "JBert" "818" "M_Adams" "817" "codinghorror" "786" "Captain" "763" "PJH" "694" "riking" "688" "Nagesh" "664" "locallunatic" "644" "tarunik" "639" "Luhmann"
-
Curses! I am on neither list.
My epeen is not mighty.
actually, that's probably a good thing given the crowd i hang out with.
-
SELECT badge_posts.topic_id, badge_posts.post_number, badge_posts.like_count, users.username
FROM badge_posts, users
WHERE topic_id != 1000 AND
badge_posts.user_id = users.id
ORDER BY like_count DESC
LIMIT 25"topic_id" "post_number" "like_count" "username"
"407" "1" "24" "Lorne_Kates"
"893" "1" "22" "Lorne_Kates"
"1964" "1" "20" "DoctorJones"
"1025" "8" "19" "ender"
"1557" "1" "18" "Onyx"
"953" "10" "17" "dhromed"
"1161" "15" "17" "sam"
"1025" "11" "17" "mott555"
"1158" "52" "17" "Luhmann"
"1504" "13" "17" "cartman82"
"1590" "1" "16" "chubertdev"
"407" "5" "16" "error"
"1373" "1" "16" "GoatboyCH"
"893" "6" "15" "Onyx"
"270" "500" "15" "mott555"
"1607" "1" "15" "Intercourse"
"1481" "24" "15" "LoremIpsum"
"1970" "1" "15" "Kuro"
"1055" "1" "15" "Arantor"
"1368" "17" "15" "Onyx"
"238" "302" "15" "oesor"
"254" "695" "15" "Zecc"
"1048" "27" "14" "mott555"
"1269" "10" "14" "ender"
"1609" "78" "14" "Onyx"I see you ran this 3 hours ago.
Please note: I got 18 likes on this post: http://what.thedailywtf.com/t/windows-8-mouse/2229/7
But I don't make the list? What am I missing in the query?
And I've seen Onyx get at least one post out there higher than 14 likes somewhere...
EDIT: You have Onyx at 18 as well...ok I'm really not getting something here...
Remember it's an old backup - and the badge_posts 'table' is actually a view...
Ok...lack of sleep is a barrier to comprehension...
-
Somehow I missed liking that post by @blakeyrat. Remedied, and now he's tied with the most hated person on the forums.
Where's that post? I'll add one more.
-
@DoctorJones got the passable poster badge
-
"count" "username"
"20139" "HardwareGeek"Woo! #1! And every single one of those given without any bot or script.
-
I am so much more popular than I thought I was.
-
Interesting how many people are in this list (like me!) that don't have a top 50 post. Having one really good post is no guarantee of having a lot of overall likes.
-
Interesting how many people are in this list (like me!) that don't have a top 50 post. Having one really good post is no guarantee of having a lot of overall likes.
Yeah, I'm number 5 overall outside of /t/1000, but my top comment is number 20.
-
Wtf, I got something with 20 likes?
Also, how the hell did you make that list?
-
If (2014-555>=2000)
Pay aliceif $2000
-
-
Yeah, I'm number 5 overall outside of /t/1000, but my top comment is number 20.
I'm in a similar position. It is quite bizarre.
-
FROM post_actions pa
JOIN users u on u.id = pa.user_id
JOIN posts p on p.id = pa.post_id
WHERE pa.post_action_type_id = '2'
GROUP BY pa.user_id, u.username
ORDER BY count(pa.user_id) DESC
LIMIT 30"count" "username"
"20139" "HardwareGeek"
"19879" "mott555"
"18934" "boomzilla"
"18746" "obeselymorbid"
"18723" "Spencer"Yay I'm #2 for most Likes given!
I remember where you basically gave that info away.
It also means, if you're accurate about what you said in that spot, that I'm older than you are.
It's a fair assumption that most of the active users here are older than me.
-
i am apparently stingy with my likes. not even top 30 on likes given outside of Likes Topic.
-
My best post has 14 likes, I'm a loser.
Clearly I need to spend more time bashing blakeyrat and less time breaking dicsourse.