0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientific skepticism

SELECT TOP 10
    CONCAT('https://stackoverflow.com/questions/', p.Id) AS [Question URL],
    p.Id AS [Post Link],
    p.Title,
    a.Id AS [Accepted Answer Link]
FROM Posts p
INNER JOIN Posts a ON p.AcceptedAnswerId = a.Id
WHERE p.PostTypeId = 1
AND (
    SELECT COUNT(DISTINCT OwnerUserId)
    FROM Posts
    WHERE ParentId = a.Id
) > 1
ORDER BY p.ViewCount DESC;

view current version

edited apr 2

created apr 2 anonymous