Create a new version of paste:

[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 ~]$