Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [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 ~]$
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
