Popular favorites results expansion

April 27, 2008 9:45 PM

Popular favorites (of all-time) is, well, one of my favorites. Is there a way to see even more posts that were favorited than are returned to the single result page?
posted by DB Cooper to feature requests at 9:45 PM (9 comments total)

You can download the results of this Data Playground query to page through every favorited post to the blue ever, ordered by number of favorites. Tweaks can get you posts on other subsites, as well as comments.
posted by cortex at 10:43 PM on April 27 [3 favorites]

Check my profile.
posted by carsonb at 11:38 PM on April 27

Thanks! I have already found some rabbit trails that look promising...
posted by DB Cooper at 12:17 AM on April 28

It seems to not allow for sorting comments by favorites. This makes me sad.

Also, I see that Mefi has a taste for long lists of freebies...
posted by Rhaomi at 12:40 AM on April 28

Oh, hoom. Constructing a nice query to pull favorite comments would be more work, yeah. I'm more a bumbling SQL apprentice than anything; maybe a wizard will come along and do some magic with the query field there.
posted by cortex at 8:24 AM on April 28

Top 50 favorited comments, as of the last dump. (Don't shoot me, I'm only the piano player.)

MeFi Comments
61699#1714437 447
68959#2007979 428
58583#1588699 299
62394#1742245 288
60808#1676227 268
68451#1987427 241
65823#1885985 225
62819#1759009 197
66144#1897448 197
64104#1811119 181
67578#1951436 175
66363#1905746 155
69052#2012470 151
67018#1930837 149
66144#1897450 143
53573#1391513 141
59945#1640092 136
62237#1735597 135
65496#1870762 131
68817#2002158 131
55720#1470306 130
69116#2015263 127
67040#1931717 125
69120#2015353 121
64398#1823215 113
69120#2015147 113
61638#1711852 113
62394#1742096 110
63638#1795469 107
67123#1934564 105
68452#1987390 104
61815#1719066 103
60452#1661698 103
68032#1969782 102
63030#1767982 99
58452#1582546 99
65284#1862024 99
69059#2012567 86
68982#2008985 85
63163#1773454 85
65168#1856477 85
56540#1505715 84
68388#1985319 82
51804#1318166 82
65715#1880682 81
66037#1893184 79
63406#1783132 77
63593#1790726 77
65232#1859760 76
63163#1773360 76

AskMe Comments
68352#1022700 327
47835#728258 286
7921#155715 232
55153#830421 214
76997#1144184 168
64735#973786 160
59953#902036 156
52074#786647 135
80424#1192955 118
62813#945137 115
65244#980783 115
78970#1172743 111
76510#1219128 104
70255#1048164 91
44229#678408 90
67136#1006166 87
70511#1052031 86
40483#623656 81
75714#1125132 76
81352#1206094 72
81713#1210896 71
78525#1167329 71
83531#1236998 68
75902#1127831 67
82390#1220727 67
81034#1202152 66
77712#1155376 66
81034#1202171 66
80571#1195203 63
63902#961420 62
77748#1155279 61
82500#1222206 60
83330#1234094 60
75249#1118454 58
62309#938115 57
67136#1006396 56
81034#1202137 55
71654#1067484 52
74316#1105396 52
60398#909210 51
83444#1235450 51
80542#1195669 48
78138#1160657 48
75555#1122596 48
70736#1055197 47
80425#1193329 47
79826#1184454 47
62886#946668 47
62487#940865 45
75527#1122586 45

MeTa Comments
13606#384503 202
14590#434688 187
12608#339118 157
15801#512618 156
15281#474396 135
15762#510078 125
13953#399282 112
985#10042 104
15271#473287 104
12641#340418 102
15731#508479 101
15438#486538 97
15547#495172 94
15435#486332 94
15495#490526 87
15509#492172 87
15801#512555 86
15547#496248 82
13976#400475 81
14796#446803 78
15330#478503 77
15663#504417 77
9380#213175 74
14301#418891 72
15547#495556 72
15722#508190 71
14567#433269 70
15478#489549 70
14357#421893 70
13786#391886 69
15663#505101 68
15663#504214 68
13242#365221 67
15066#462135 64
15281#475012 64
15368#481653 64
14628#436880 63
13660#386776 62
15547#495985 60
15801#512539 59
15015#458952 58
15495#490598 58
15609#500792 56
15276#473675 56
15801#512548 56
15801#512579 55
14915#453930 54
15663#504603 53
15398#484100 51
15495#490799 51
posted by Armitage Shanks at 12:45 PM on April 28 [4 favorites]

(Don't shoot me, I'm only the piano player.)

*shoots Armitage Shanks*

That's for hermitosis.
posted by [NOT HERMITOSIS-IST] at 12:55 PM on April 28 [1 favorite]

This seems to be out of date. I have a recent fpp with 110 favorites that doesn't seem to be listed.

I DEMAND EGO SATISFACTION.
posted by empath at 4:23 PM on April 28

Pretty sure the info has only been dumped a coupla few times, so anything that happens after the most recent dump isn't available for datamining. Prod cortex for your ego satisfaction.
posted by carsonb at 10:59 PM on April 28