SELECT TOP 1000 p.Id AS [Post Link], p.Title AS [Question],

0

Please login or register to vote for this query.

(click on this box to dismiss)

Emacs

Q&A for those using, extending or developing Emacs

SELECT TOP 1000
    p.Id AS [Post Link],
    p.Title AS [Question],
    p.Body AS [Description],
    a.Body AS [Answer]
FROM Posts p
INNER JOIN Posts a ON p.AcceptedAnswerId = a.Id
INNER JOIN (SELECT PostId, COUNT(DISTINCT UserId) AS NumEditors
            FROM PostHistory
            WHERE PostHistoryTypeId = 5 -- Edit
            GROUP BY PostId
            HAVING COUNT(DISTINCT UserId) >= 2) ph ON a.Id = ph.PostId
WHERE p.PostTypeId = 1
ORDER BY p.ViewCount DESC;

Enter Parameters

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