5
$\begingroup$

Q1: How can I find posts that have been answered by two users? For example user:1000 and user:1500? Or more generally a set of posts where two users have intersected, consisting of comments, questions, and answers.

Q2: Is it possible to see my questions on the profile page of a user who answered my posts? Something like My Posts, similar to the All Questions Answers Votes Newest tabs in the user profile.

| |
$\endgroup$
  • 6
    $\begingroup$ This consists of two distinct questions, only one of which is a feature request. Please limit yourself to one question per post. $\endgroup$ – amWhy Aug 3 at 19:14
  • 1
    $\begingroup$ Re: Or more generally a set of posts where two users have intersected, consisting of comments, questions, answers. You might check this post on MathOverflow Meta: Is it possible to search for posts/questions of an user $X$ commented on/answered by the user $Y$? In particular, the query called "Have we met?" might be of interest. Do not forget to switch sites from MathOverflow to Math when executing those queries. $\endgroup$ – Martin Sleziak Aug 4 at 8:03
  • $\begingroup$ @MartinSleziak: the first two link in answer you linked to is not return results properly. For example the user 26501 and me have met each other in many MSE posts but that query returns nothing!! $\endgroup$ – C.F.G Sep 3 at 6:15
  • $\begingroup$ @C.F.G Could you provide the link which is not working? Did you switch the sites from MO to MSE? When I tried the query Comments left by a user on your posts (with parameters 272127 and 26501), I got 12 comments. I got 12 result also from Have we met?. $\endgroup$ – Martin Sleziak Sep 3 at 6:24
  • 1
    $\begingroup$ @MartinSleziak: Aha, I confused by site icon. If it is in MSE it shows Meta icon and vice versa? $\endgroup$ – C.F.G Sep 3 at 6:27
  • 1
    $\begingroup$ When you choose math.SE, you can see the main site icon in two places near the top. (Look at the text "Compose query" and below it.) The switch sites dialogue shows the meta icon - through which you can quickly switch to meta. (You can see this icon also in Glorfindel's answer.) $\endgroup$ – Martin Sleziak Sep 3 at 6:31
10
$\begingroup$

You can use the Stack Exchange Data Explorer for these kind of things.

For Q1, this query lists the questions answered by the two highest reputation users on the site, but you can easily adjust the user IDs.

enter image description here

Q2 requires a slightly different query (I took your user ID and a random person who answered one of your latest questions).

Please note that SEDE is updated only once a week, on Sunday morning. Feel free to fork my queries for your own experiments. If you're new to SQL, you can have a look at the awesome tutorial, and there's a chatroom dedicated to it.

| |
$\endgroup$

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .