Shoutout to Wenestvedt on His 150,000th Favorite Given February 22, 2022 4:20 PM   Subscribe

My infodumpster skills are not sufficient to find other members, like Wenestvedt, who favorite posts and comments generously, but it makes the place nicer and more fun. Thanks!

I've been watching the number tick upwards, and it happened today. Cheers!
posted by theora55 to MetaFilter-Related at 4:20 PM (40 comments total) 34 users marked this as a favorite

Impressive. Most impressive.
posted by Tehhund at 4:28 PM on February 22 [14 favorites]


Aw, Wenestvedt, I felt special when I thought it was just me.
posted by ctmf at 4:54 PM on February 22 [10 favorites]


HAHAHA! I love handing out favorites! I wish I could insert a GIF here of Oprah saying, "You get a favorite, and you get a favorite, and you get a favorite!"

An earnest or honest or funny or insightful comment with no favorites strikes me as sad. Everyone loves favorites: "Everyone needs a hug," right? And as a recent thread pointed out, a lot of people find that writing a comment requires some bravery -- which shouldn't go unrecognized.

Thanks for noticing, Theora55. You're awesome yourself. :7)
posted by wenestvedt at 5:17 PM on February 22 [73 favorites]


You are the hero MetaFilter needs right now, wenestvedt.
posted by Johnny Wallflower at 5:38 PM on February 22 [12 favorites]


Awww! Thanks for the little sprinkle of positivity, wenestvedt. Favorites cost us nothing to hand out, and everyone likes getting them.
posted by The corpse in the library at 5:46 PM on February 22 [8 favorites]


Will is a stand-up individual who lives an hour away from me yet I have not yet, for some reason, bought him a beer. I need to remedy that once meetups are a thing again.
posted by bondcliff at 5:57 PM on February 22 [13 favorites]


Awww, bondcliff! I even listen to Phish's "Baker's Dozen" series of endless live shows because you are so passionate about them...and I actually enjoy it!

<sally_field_oscars.gif>
posted by wenestvedt at 6:11 PM on February 22 [7 favorites]


Yay x 150,000 for wenestvedt !
posted by Sparky Buttons at 7:10 PM on February 22 [11 favorites]


You favorited a hundred and fifty thousand comments? You must get up very early in the morning.
posted by mubba at 7:14 PM on February 22 [11 favorites]


My dude, the Internet is what I was born for. I can't imagine what I would do without it!
posted by wenestvedt at 7:25 PM on February 22 [8 favorites]

the Internet is what I was born for. I can't imagine what I would do without it!
Be productive?
posted by Tehhund at 7:32 PM on February 22 [10 favorites]


You favorited a hundred and fifty thousand comments? You must get up very early in the morning.

Holy shit mubba talk about a blast from the past

I can't even get down the gym! Your diary must look odd: 'Get up in the morning, favorite, favorite, favorite, favorite, favorite, favorite, favorite, lunch... favorite, favorite, favorite, afternoon tea... favorite, favorite, favorite, quick shower …'
posted by tzikeh at 8:50 PM on February 22 [7 favorites]


See, all this time I’ve been thinking, wow, that wenestvedt person really gets me. Turns out he really gets all of us!

This is such a lovely post, theora55. 150k thank yous to wenestvedt for sharing the love!
posted by mochapickle at 9:38 PM on February 22 [12 favorites]


Waaaaait a second, you live closeby enough for bondcliff to buy you a beer? And you give favorites out that would make tehloki sit back in their seat and go OH THAT'S HOW IT WAS DONE?

this is the metafilter I'd hoped for. BONDCLIFFE, BUYETH THE WENESTVEDT A BEER AND TEXTETHEH ME YOUR GPS COORDINATES WHEN YOU DO. [clapping hands, closing eyes tight, spinning around three times] AND AS IT IS WRITTEN SO SHALL IT BE. METALLICA SANG SOMETHING LIKE THAT ONCE EH
posted by not_on_display at 10:31 PM on February 22 [11 favorites]


Aw, wenestvedt, you're the tops!
posted by kimberussell at 5:30 AM on February 23 [5 favorites]


Oooohhh, mein Hund, that's pretty rich. :7)
posted by wenestvedt at 5:41 AM on February 23 [4 favorites]


wait aren't "favorites" really bookmarks?!
posted by chavenet at 5:55 AM on February 23 [8 favorites]


AND AS IT IS WRITTEN SO SHALL IT BE. METALLICA SANG SOMETHING LIKE THAT ONCE EH

Yeah but the next line had something to do with killing the first born Pharaoh son. That's not the sort of meetup we strive for here on meta-filter dot com.
posted by bondcliff at 6:23 AM on February 23 [5 favorites]


kimberussell, I like your book recs on Goodreads.
posted by wenestvedt at 6:29 AM on February 23 [3 favorites]


I'm something of a favorites-giver myself, so I know all about reading MetaFilter instead of doing what I ought to be doing.
posted by Tehhund at 6:31 AM on February 23 [8 favorites]


What ho, wenestvedt!
posted by cortex (staff) at 8:06 AM on February 23 [4 favorites]


What ho, indeed, Captain.
posted by wenestvedt at 8:59 AM on February 23 [4 favorites]


ctmf: Aw, Wenestvedt, I felt special when I thought it was just me.

ctmf, having just glanced at your profile page.... If I guess correctly, then you may have the smothered-laugh-iest username on MetaFilter. :7)
posted by wenestvedt at 9:20 AM on February 23 [4 favorites]


Oh I think this is very nice. I don't favorite many things because it's just not how I use the site, and I use favorites as bookmarks and sometimes I'll read through all the comments I've favorited and laugh and laugh, but I have so much appreciation for those who favorite a lot and also a lot of appreciation for wenestvedt who is all-around a good guy.
posted by an octopus IRL at 9:28 AM on February 23 [4 favorites]


an octopus IRL, would you happen to live in a tree, perchance?
posted by wenestvedt at 9:53 AM on February 23 [3 favorites]


On the one hand, this is awesome. Congrats and well done. wenestvedt!

On the other hand, so much for my theory that someone here liked me because they liked so many of my comments... sigh...
posted by Mchelly at 9:55 AM on February 23 [6 favorites]


an octopus IRL, would you happen to live in a tree, perchance?

Nope, that's the Pacific Northwest Tree Octopus, I am from the east coast and thus live in a townhouse.
posted by an octopus IRL at 10:00 AM on February 23 [9 favorites]


Mchelly, you're one of the commenters whose name catches my eye. Keep it up!

(Also, NY-style pizza sucks. Chicago deep dish 4eva.)
posted by wenestvedt at 10:50 AM on February 23 [4 favorites]


I take back everything I said about you.
posted by bondcliff at 11:06 AM on February 23 [7 favorites]


deeeeeep.... dish? ...pizza?
what are you all talking about
what even is
i just order the calamari rings at pizzaria ono is that where ... deep•DISH' pizza is rite? DEEP'•dish?
no offense to octopodes irl



anyway somerville style pizza is the best THANKS WHENEVERSTATE FOR ALL THE PIZZA
posted by not_on_display at 12:16 PM on February 23 [4 favorites]


I assume "Somerville style" is square?
posted by bondcliff at 12:30 PM on February 23 [2 favorites]


I've only been back to Sum'v'lle twice since 1992 or so, and I'm not current on the local pizza scene. (Back then, I was eating entire large pizzas at one sitting, from the campus pizza counter. They were vile, but I was hunnnngry.)

Do I want to ask what Somerville-style pizza is?

And bondcliff, that was funny. (Wait, Ball or Teale?)
posted by wenestvedt at 12:56 PM on February 23 [3 favorites]


I endorse this shout out.
posted by y2karl at 3:01 PM on February 23 [4 favorites]


> NY-style pizza sucks

I had been going to favorite every single comment in this thread, just because I was in the spirit of the thing, but then this happened.
posted by The corpse in the library at 7:25 AM on February 24 [5 favorites]


NY pizzaist here: Thank God I made the cut.
posted by y2karl at 7:34 AM on February 24 [3 favorites]


y2karl, I loved your post about those three dancers -- so much fun in gray February!
posted by wenestvedt at 7:42 AM on February 24 [3 favorites]


Well, to be honest, I am actually an Anypizzaist. Including last-night's-cold-pizza-for-breakfastist. That's where I'm a Viking. But NY pizza is at the top for sure.
posted by y2karl at 11:35 AM on February 24 [3 favorites]


Homemade pizza for dinner three times in the last week. All pizza is OK by me.
posted by wenestvedt at 7:53 PM on March 4 [3 favorites]


My infodumpster skills are not sufficient to find other members, like Wenestvedt, who favorite posts and comments generously
cd /tmp
wget 'http://mefi.us/infodump/favoritesdata.txt.zip'
7z x favoritesdata.txt.zip 
tail -n+3 favoritesdata.txt |
cut -f2 |
sort -n |
uniq -c |
sort -rn |
head |
while read count userid
do echo "$count" "$(
	curl -s https://www.metafilter.com/user/$userid |
	sed -nE "/<title>/s/.*>(.*)'s? profile.*/\1/p"
)"
done

230513 Proofs and Refutations
186217 Lexica
150588 wenestvedt
140125 Tehhund
136063 palomar
127166 thetarium
123827 blueberry
118421 Faint of Butt
108972 JHarris
108316 tonycpsu
posted by flabdablet at 3:10 AM on March 8 [2 favorites]


Another way using sqlite, a very handy tool for arbitrary infodump massage:

stephen@jellynail:/tmp$ wget http://mefi.us/infodump/infodump-all.zip
--2022-03-09 03:34:01-- http://mefi.us/infodump/infodump-all.zip
Resolving mefi.us (mefi.us)... 34.222.87.189
Connecting to mefi.us (mefi.us)|34.222.87.189|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 931392589 (888M) [application/zip]
Saving to: ‘infodump-all.zip’

infodump-all.zip 100%[===================>] 888.25M 1.52MB/s in 9m 53s

2022-03-09 03:43:54 (1.50 MB/s) - ‘infodump-all.zip’ saved [931392589/931392589]

stephen@jellynail:/tmp$ sqlite3 infodump.sqlite
SQLite version 3.37.2 2022-01-06 13:25:41
Enter ".help" for usage hints.
sqlite> .mode tabs
sqlite> .import '|unzip -p infodump-all.zip favoritesdata.txt | tail -n+2' favorites
sqlite> .import '|unzip -p infodump-all.zip usernames.txt | tail -n+2' users
sqlite> .headers on
sqlite> select * from favorites limit 1;
faveid faver favee type target parent datestamp
1 1 23470 1 51485 0 May 9 2006 10:40:43:467AM
sqlite> select * from users limit 1;
userid joindate name
1 Jan 27 2000 08:16:57:367PM mathowie
sqlite> select * from favorites join users on faver = userid limit 1;
faveid faver favee type target parent datestamp userid joindate name
1 1 23470 1 51485 0 May 9 2006 10:40:43:467AM 1 Jan 27 2000 08:16:57:367PM mathowie
sqlite> select count(faver) as Count, name as Username
...> from favorites join users on faver = userid
...> group by faver
...> order by Count desc
...> limit 20;
Count Username
230513 Proofs and Refutations
186217 Lexica
150588 wenestvedt
140125 Tehhund
136063 palomar
127166 thetarium
123827 blueberry
118421 Faint of Butt
108972 JHarris
108316 tonycpsu
105829 tobascodagama
105303 corb
104323 The Great Big Mulp
103290 kelborel
102769 hydropsyche
101924 Gelatin
97146 Artw
96329 ZeusHumms
92890 Fiberoptic Zebroid and The Hypnagogic Jerks
92687 GenjiandProust
sqlite> .quit
stephen@jellynail:/tmp$ ls -al infodump.sqlite
-rw-r--r-- 1 stephen stephen 3066544128 Mar 9 03:50 infodump.sqlite
stephen@jellynail:/tmp$

infodump.sqlite can be re-opened in sqlite3 to have other SQL queries run against it without needing to repeat the lengthy import steps. If you need more tables inside infodump.sqlite, keep infodump-all.zip around and use .mode tabs and .import commands similar to the ones used above for importing the favorites and users tables. Note that the infodump text files have column headers on the second line while .import expects them on the first, which is why the unzips need to get piped through tail -n+2 during import. Note also that the favouritesdata.txt component of infodump-all.zip is many times the size of any of the others, so .import should pull in any of the other tables much faster than that one.
posted by flabdablet at 9:51 AM on March 8 [1 favorite]


« Older 22222   |   [MeFi Site Update] February 23rd Newer »

You are not logged in, either login or create an account to post comments