How many posts were possibly made Community-Wiki by suggested edits?

0

Please login or register to vote for this query.

(click on this box to dismiss)

Artificial Intelligence

Q&A for people interested in conceptual questions about life and challenges in a world where "cognitive" functions can be mimicked in purely digital environment

-- How many posts were possibly made Community-Wiki by suggested edits?

SELECT          ph.PostId       AS [Post Link]
              , COUNT (se.Id)   AS [Suggested edits]
FROM            PostHistory     ph
LEFT JOIN       SuggestedEdits  se
ON              se.PostId       = ph.PostId
WHERE           ph.UserId              = -1 -- User "Community ♦"
AND             ph.PostHistoryTypeId   = 16 -- Community wiki
AND             se.CreationDate <= ph.CreationDate
GROUP BY        ph.PostId
HAVING          COUNT (se.Id) > 0
ORDER BY        [Suggested edits] DESC
              , ph.PostId

Enter Parameters

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