Q&A for community managers, administrators, and moderators
SELECT TOP 1000 Q.OwnerUserId AS [User Link], A.OwnerUserId AS [User Link], COUNT(*) AS Count FROM Posts Q, Posts A WHERE A.ParentId = Q.Id AND A.OwnerUserId > 0 AND Q.OwnerUserId > 0 AND A.OwnerUserId <> Q.OwnerUserId AND Q.CommunityOwnedDate IS NULL AND A.CommunityOwnedDate IS NULL GROUP BY Q.OwnerUserId, A.OwnerUserId ORDER BY Count DESC, A.OwnerUserId, Q.OwnerUserId