select TOP 5000 u1.Id, u2.Id, u1.Reputation, u2.Reputatio...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping Meta

Q&A about the site for gardeners and landscapers

select TOP 5000 u1.Id, u2.Id, u1.Reputation, u2.Reputation, Count(1)
FROM PostTags, Posts p1, Posts p2, Users u1, Users u2
WHERE PostTags.TagId = 1386
AND PostTags.PostId = p1.Id
AND p1.CreationDate >= '2012-01-01'
AND p1.ParentId = p2.Id
AND p1.OwnerUserId IS NOT NULL
AND p2.OwnerUserId IS NOT NULL
AND p1.OwnerUserId <> p2.OwnerUserId
AND p1.PostTypeId <= 2
AND p2.PostTypeId <= 2
AND p1.OwnerUserId = u1.Id
AND p2.OwnerUserId = u2.Id
GROUP BY u1.Id, u2.Id, u1.Reputation, u2.Reputation
ORDER BY Count(1) DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results