People you attracted into the system

1

Please login or register to vote for this query.

(click on this box to dismiss)

People who 1) started with a question 2) you answered his question 3) he accepted it 4) has now at least one accepted answer

Ask Different

Q&A for power users of Apple hardware and software

WITH FirstPosts AS (
  SELECT OwnerUserId, MIN(Id) AS FirstPostId
  FROM Posts
  GROUP BY OwnerUserId
)
SELECT
  Q.OwnerUserId AS [User Link],
  Q.Id AS [Post Link]
FROM Posts Q, Posts A
WHERE
  Q.AcceptedAnswerId = A.Id
  AND
  A.OwnerUserId = ##UserId:int##
  AND
  Q.OwnerUserId IN (
    SELECT Posts.OwnerUserId
    FROM Posts, FirstPosts
    WHERE
      FirstPosts.FirstPostId = Posts.Id
      AND
      Posts.PostTypeId = 1
  )
  AND
  Q.OwnerUserId IN (
    SELECT A.OwnerUserId
    FROM Posts Q, Posts A
    WHERE Q.AcceptedAnswerId = A.Id
  )
ORDER BY Q.OwnerUserId

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results