Suggested edits by post type

1

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Different

Q&A for power users of Apple hardware and software

SELECT
  PostTypes.Id AS PostTypeId,
  MIN(PostTypes.Name) AS PostTypeName,
  COUNT(*) AS Count
FROM SuggestedEdits, Posts, PostTypes
WHERE
  SuggestedEdits.PostId = Posts.Id
  AND
  Posts.PostTypeId = PostTypes.Id
GROUP BY PostTypes.Id
ORDER BY PostTypes.Id

Enter Parameters

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