Dunbar's number and the social graph

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT Count(*) as arity, A.OwnerUserId, Q.OwnerUserId
FROM Posts A 
  INNER JOIN Posts Q
ON A.ParentId=Q.Id
AND A.PostTypeId=2
AND Q.PostTypeId=1
AND Q.Score>0
AND A.Score>0
AND A.OwnerUserId IS NOT NULL AND Q.OwnerUserId IS NOT NULL
GROUP BY A.OwnerUserId, Q.OwnerUserId

Enter Parameters

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