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

1

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          p.Id            [Post Link]
              , p.CommunityOwnedDate
              , ph.CreationDate [Suggested Edit date]
FROM            Posts           p
INNER JOIN      PostHistory     ph
ON              ph.PostId       = p.id
WHERE           p.CommunityOwnedDate    IS NOT NULL
AND             ph.CreationDate         <= p.CommunityOwnedDate    
AND             ph.PostHistoryTypeId    = 24  -- Suggested edits.
AND             p.PostTypeId    < 3 -- Q's and A's only.

Enter Parameters

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