SELECT DISTINCT p.id, p.CreationDate, p.Score, p.ViewCoun...

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 DISTINCT p.id, p.CreationDate, p.Score,
                p.ViewCount, p.OwnerUserId, p.Title,
                p.Tags, p.AnswerCount
                       
FROM Posts p
JOIN PostTags pt ON p.Id = pt.PostId
JOIN Tags t ON t.Id = pt.TagId
JOIN PostLinks l ON l.PostId = p.Id

WHERE p.AcceptedAnswerId IS NOT NULL
  AND p.CreationDate >= '2015-01-01'
  AND Tags LIKE '%[r]%'
  AND p.ParentId IS NULL
ORDER BY p.Score DESC

Enter Parameters

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