[postgres@lenovo ~]$ LIMIT=100 sql_tdwtf most_liked_topics # Most liked topic starters SELECT row_number() OVER (ORDER BY bp.like_count DESC) n, bp.topic_id topic, bp.post_number post, bp.like_count likes, u.username, t.title FROM badge_posts bp JOIN topics t on t.id = bp.topic_id JOIN users u on u.id = bp.user_id WHERE bp.post_number = 1 ORDER BY bp.like_count DESC LIMIT 100 n | topic | post | likes | username | title -----+-------+------+-------+--------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 1 | 1000 | 1 | 84 | mott555 | The Official Like Totally Thread - Hindsight is 22000 2 | 2662 | 1 | 32 | blakeyrat | horseplop (so says blakeyrat) 3 | 407 | 1 | 29 | Lorne_Kates | I'm A Grumpy Cat: An open letter to Alex 4 | 1964 | 1 | 28 | DoctorJones | The hero that Discourse deserves... 5 | 893 | 1 | 27 | Lorne_Kates | I'm still a grumpy cat: a final plea to Alex 6 | 3042 | 1 | 21 | Matches | Stack Overflow 7 | 3241 | 1 | 20 | Keith | The forum only has one passable poster 8 | 3665 | 1 | 20 | DoctorJones | Return of the Doctor 9 | 2275 | 1 | 19 | WTF | Goodbye TDWTF Forums 10 | 1557 | 1 | 19 | Onyx | Just tell it it's USB 11 | 2767 | 1 | 17 | codinghorror | Thanks for the Discourse V1 brownies! 12 | 1607 | 1 | 16 | Intercourse | If Discourage was like construction 13 | 1590 | 1 | 16 | chubertdev | How not to use a switch statement 14 | 3300 | 1 | 16 | blakeyrat | Driving Anti-Patterns 15 | 1373 | 1 | 16 | GoatboyCH | Security Through Insanity 16 | 3103 | 1 | 15 | Matches | The NEW Official Unofficial Discourse bug tracker! 17 | 1055 | 1 | 15 | Arantor | Non-IT WTFs: how not to run a party 18 | 2160 | 1 | 15 | delfinom | user logins? lets use the database! 19 | 1970 | 1 | 15 | Kuro | Modern Webdesign and my gripes with it (RANT) 20 | 1053 | 1 | 14 | Arantor | Non-IT WTF: you can't spell hypocrite without HR 21 | 2128 | 1 | 14 | trithne | Find and Replace, by way of Ctrl+F, Ctrl+V 22 | 2653 | 1 | 14 | algorythmics | The Sexy Washington Sexy Triangle: How sexy Hanzo sexily journeyed to sexy America 23 | 3278 | 1 | 14 | cartman82 | Classic funny comments 24 | 270 | 1 | 13 | blakeyrat | Vote of No Confidence 25 | 1938 | 1 | 13 | dkf | Procurement also has it's WTF moments 26 | 3171 | 1 | 13 | anonymous234 | Chromebooks don't work very well without internet 27 | 3625 | 1 | 13 | cartman82 | Windows 10 Tech Preview First Impressions 28 | 3160 | 1 | 13 | darkmatter | Finally trapped the blank page load error 29 | 759 | 1 | 12 | rad131304 | Should big digressions be split to a new topic? 30 | 403 | 1 | 12 | dkf | Feature Request: Cornify tag! 31 | 1979 | 1 | 12 | PJH | Orlando Bloom v Justin Bieber 32 | 2166 | 1 | 12 | algorythmics | The "That Moment" Topic 33 | 1413 | 1 | 12 | toon | Bookkeeping code or: how I learned to stop worrying and love data duplication 34 | 908 | 1 | 12 | ZPedro | Know Your Daily WTF Memes 35 | 3580 | 1 | 12 | Arantor | I have been doing this too long, I swear 36 | 3679 | 1 | 12 | Arantor | From my current project 37 | 1229 | 1 | 12 | Keith | Spoiler tags too blurry 38 | 953 | 1 | 11 | cartman82 | Windows 8 sign in - no problem 39 | 370 | 1 | 11 | system | TDWTF Forum FAQ 40 | 3351 | 1 | 11 | bp_ | Your friendly local neighbourhood digital textbook industry 41 | 1846 | 1 | 11 | Keith | ❤ my 1337ness 42 | 1415 | 1 | 11 | Arantor | I've been wary of "Don't Be Evil" but... 43 | 1588 | 1 | 11 | DoctorJones | Has anyone read @Nagesh's profile? 44 | 1353 | 1 | 11 | antiquarian | The Evil Ideas thread 45 | 2251 | 1 | 11 | tufty | Discourse is not TRWTF… 46 | 1242 | 1 | 11 | Keith | This is too awesome not to share immediately 47 | 2896 | 1 | 11 | chubertdev | hey, look, it's us! 48 | 522 | 1 | 10 | codinghorror | Apologies, Discourse Is Buggy 49 | 2674 | 1 | 10 | Weng | The Home Stretch 50 | 1044 | 1 | 10 | mikeTheLiar | That's more like it! 51 | 3268 | 1 | 10 | algorythmics | Conversations overheard 52 | 3013 | 1 | 10 | Buddy | Damn you autopredict. 53 | 1040 | 1 | 10 | ender | Web 0.05? 54 | 2209 | 1 | 10 | cartman82 | Someone needs to learn about the incognito mode 55 | 3262 | 1 | 10 | anonymous234 | Design and Use of Anatomical Atlases for Radiotherapy 56 | 2169 | 1 | 10 | delfinom | the wonderful world of compilers 57 | 3451 | 1 | 9 | blakeyrat | Google News demonstrates why page scraping is generally a bad idea 58 | 1890 | 1 | 9 | ben_lubar | Edit history solution 59 | 770 | 1 | 9 | sam | Stop spamming my browser history setting 60 | 827 | 1 | 9 | Maciejasjmj | How do you know if your forum software is TRWTF? 61 | 2669 | 1 | 9 | cartman82 | C# hate 62 | 2921 | 1 | 9 | boomzilla | Doesn't read her own blog 63 | 1425 | 1 | 9 | faoileag | Licence? What licence? All your links are belong to us! 64 | 2271 | 1 | 9 | blakeyrat | Someone post this bug, YouTube videos in preview window reload on every single keypress 65 | 578 | 1 | 9 | DoctorJones | Feature request: new style polling system 66 | 1332 | 1 | 9 | boomzilla | Bug category background is a barrier to reading 67 | 3005 | 1 | 9 | cartman82 | Git troubleshooting flowchart 68 | 1850 | 1 | 9 | LoremIpsum | Certification that's Impossible to Verify is TRWTF 69 | 2612 | 1 | 9 | blakeyrat | MS SQL Permissions 70 | 1296 | 1 | 9 | mott555 | Galaxious 71 | 1285 | 1 | 9 | MathNerdCNU | Lunch or Servers, Take your Pick 72 | 3183 | 1 | 8 | blakeyrat | Making the best of MS Office files 73 | 2158 | 1 | 8 | Keith | Code Testing 74 | 3621 | 1 | 8 | Rhywden | Measuring software for schools 75 | 2643 | 1 | 8 | VinDuv | Abusing script ＜script＞Array.prototype.forEach.call(document.getElementsByTagName('p'), function (x) { x.innerHTML += "＜strong＞SEXY＜/strong＞"})＜/script＞ 76 | 2238 | 1 | 8 | anonymous234 | Close call with an Acer laptop (or: never update your BIOS) 77 | 963 | 1 | 8 | mott555 | Poll: Can I have polls within polls? 78 | 3331 | 1 | 8 | cartman82 | Charge your iPhone in microwave - 4chan does it again with iOS 8 79 | 614 | 1 | 8 | PJH | Posting on TDWTF 101 80 | 3476 | 1 | 8 | cartman82 | Slütsof In Stagrâm 81 | 2228 | 1 | 8 | Maciejasjmj | The links that weren't 82 | 2847 | 1 | 8 | riking | i have sorted your badges page. pray i do not sort it further 83 | 763 | 1 | 8 | rad131304 | Some Mods don't understand the difference between refactoring and branching. 84 | 1643 | 1 | 8 | chubertdev | "New" 85 | 1205 | 1 | 8 | Arantor | This is why I love xkcd 86 | 2620 | 1 | 8 | Matches | ToS for a game from 1999 87 | 1026 | 1 | 8 | PJH | Spoilers 88 | 3544 | 1 | 8 | Spencer | On-Call at the Muse Concert 89 | 3430 | 1 | 8 | Arantor | An instance of PHP being actually WTF 90 | 3244 | 1 | 8 | Arantor | Just found this comment in some code 91 | 1822 | 1 | 8 | cartman82 | Anonymous company WTF-s 92 | 3097 | 1 | 8 | jaloopa | the funny text messages thread 93 | 3035 | 1 | 7 | mark_bowytz | Know about my WTF Column - DevDisasters? 94 | 3111 | 1 | 7 | VaelynPhi | TDWTF: now with WTF daily. 95 | 1322 | 1 | 7 | sam | The likes topic is a barrier to reading the badge page 96 | 380 | 1 | 7 | heterodox | Praise for Discourse 97 | 1309 | 1 | 7 | cartman82 | How to exploit a developer (article) 98 | 1541 | 1 | 7 | powerlord | Pennsylvania and a two-digit year wtf 99 | 2102 | 1 | 7 | Keith | WTF Domains 100 | 743 | 1 | 7 | dhromed | Fronds (100 rows) Backup taken: 2014-10-03 08:17:40.262149 [postgres@lenovo ~]$