Cross-referencing of posts by user pony

January 26, 2006 10:51 AM

I would like a new feature. What is this new feature that I would like? Let me tell you about this new feature that I would like. The new feature that I would like is this:

I would like a new feature whereby I can see a list of posts/comments by user [x] cross referenced with a list of posts/comments by user [y]. I would like this new feature for reasons almost purely related to satisfying my own curiosity. I would, however, like this feature nonetheless.
posted by shmegegge to Feature Requests at 10:51 AM (28 comments total)

As an example, the generated page for this might look something like this:

Posts participated in by both quonsar and son_of_minya:

"On the other hand, this girl just might wake up with a sore pussy the next day and not even worry about it..." Delmoi's post is offensive, disgusting, insulting, demeaning to women, really creepy, and IMHO, is simply beyond the pale of acceptable comments. I know you should be able to say what you want, but the thread just keeps getting worse and worse. And it's not just Delmoi who's being sickening. Shouldn't this thread be deleted? What's the policy on really offensive stuff?


comment posted at 5:57 PM
EST
on Jun-20-03 by son_of_minya


comment posted at 5:57 PM
EST
on Jun-20-03 by quonsar


etc...
posted by shmegegge at 10:52 AM on January 26, 2006

You mean like the IMDb feature? Where you go to an actor's page and at the bottom there's a "Find where So-And-So is credited alongside another name" searchbox? Yeah, that'd be kinda neat.
posted by Gator at 10:55 AM on January 26, 2006

I'm confused by how the callout (probably a fair one) relates to the feature request.
posted by JMOZ at 11:07 AM on January 26, 2006

site:metafilter.com quonsar son_of_minya
posted by monju_bosatsu at 11:11 AM on January 26, 2006

yeah, I'd say just use an outside search engine like google. I don't see much usefulness for it here.
posted by mathowie (staff) at 11:15 AM on January 26, 2006

well, the outside search also brings up any thread that mentions those two users, whether they participate in the thread or not. for instance, this thread, in which neither user participates, comes up during the search monju linked.

but hey, I asked as a lark more than anything. feel free to ignore it.
posted by shmegegge at 11:18 AM on January 26, 2006

oh, and the outside search is unwieldy and difficult to sort through and wholly unorganized.
posted by shmegegge at 11:19 AM on January 26, 2006

Well, I guess in a pinch you could modify that search a bit: site:metafilter.com "posted by: quonsar" "posted by: son_of_minya".
posted by Gator at 11:22 AM on January 26, 2006

You know, now you pony askers are just getting silly. Wait for Matt to come out with a Metafilter API, and then you can twist and pervert the data to your heart's content.
posted by crunchland at 11:24 AM on January 26, 2006

DIM varA as string

DIM varB as string

SELECT * FROM tblMEFIPOSTS WHERE [MEFICOMMENTER] LIKE varA AND WHERE [MEFICOMMENTER] LIKE varB

print "HELLO WORLD"
posted by mr_crash_davis at 11:34 AM on January 26, 2006

the outside search also brings up any thread that mentions those two users, whether they participate in the thread or not

site:metafilter.com "posted by quonsar" "posted by son_of_minya"
posted by kirkaracha at 11:39 AM on January 26, 2006

Stupid live preview.
posted by kirkaracha at 11:39 AM on January 26, 2006

'twould simplify hunting sock puppets
posted by mischief at 11:44 AM on January 26, 2006

I was a second away from posting that, mischief, without the 'twould.
posted by weapons-grade pandemonium at 11:48 AM on January 26, 2006

what does it take
to get an API in this place
what does it take
how long must i wait
posted by cortex at 11:55 AM on January 26, 2006

mr_crash_davis writes "SELECT * FROM tblMEFIPOSTS WHERE [MEFICOMMENTER] LIKE varA AND WHERE [MEFICOMMENTER] LIKE varB"

WTF?

User have numbers. Get rid of the like:

@user1 = ( select user_id from users where name = "quonsar" )
@user2 = ( select user_id from users where name = "son of minya" )

select a.post_url from posts a where
exists ( select * from comments b where b.post_id = a.post_id and b.user_id = @user_id1 )
and
exists ( select * from comments b where b.post_id = a.post_id and b.user_id = @user_id2 )

more cleanly:

create view user_posted_in as
select distinct a.user_id, b.post_id
from comments a

select a.post_id
from user_posted_in a, user_posted_in b
where a.post_id = b.post_id
and a.user_id = ( select c.user_id from users c where c.user_name = "quonsar" )
and b.user_id = ( select c.user_id from users c where c.user_name = "son of minya" )



an ugly alternative

select distinct a.post_url from
posts a, posts b, comments c, comments d, users e, users f
where a.post_id = b.post_id
and a.post_id = c.post_id
and c.user_id = e.user_id
and e.user_name = "quonsar"
and b.post_id = d.post_id
and d.user_id = f.user_id
and f.user_name = "son of minya
posted by orthogonality at 12:01 PM on January 26, 2006

*burns in tank*
posted by quonsar at 12:09 PM on January 26, 2006

Very cool idea, schmegege.
posted by five fresh fish at 12:34 PM on January 26, 2006

ortho, it was a bit of a lark, y'see, which is why it ended with the "HELLO WORLD" bit.

dammit, explaining jokes ruins them
posted by mr_crash_davis at 12:42 PM on January 26, 2006

mr_crash_davis = funny.
posted by dios at 12:52 PM on January 26, 2006

ortho got aspergers
posted by Protocols of the Elders of Awesome at 1:24 PM on January 26, 2006

site:metafilter.com "posted by quonsar" "posted by son_of_minya"

Which will soon bring up this page.

Oh the metanity!
posted by null terminated at 1:49 PM on January 26, 2006

I wish I got coding humor.
posted by shmegegge at 1:50 PM on January 26, 2006

mr_crash_davis writes "ortho, it was a bit of a lark, y'see, which is why it ended with the 'HELLO WORLD' bit."

Yeah, but since the SQL was some easy, it seemed I might as well give it. Um, besides, the tradition is that a "Hello world" joke should actually work. If you'd written "select 'hello world';" I'd have laughed.
posted by orthogonality at 3:03 PM on January 26, 2006

two strings walk into a bar. the first says "I'll have a shot of tequila, please~!@!$#@7888@#.)6578.%$$%^$$&`~"
the second one says "Don't mind my friend, he's not null-terminated."
posted by quonsar at 3:04 PM on January 26, 2006

[groans. feeds q to the lions.]
posted by five fresh fish at 3:28 PM on January 26, 2006

Ok, quonsar's joke I seriously laughed out loud at.
posted by orthogonality at 3:57 PM on January 26, 2006

"If you'd written "select 'hello world';" I'd have laughed"

*raises orthogonality's geek point quotient by two in The Book*
posted by mr_crash_davis at 5:41 PM on January 26, 2006