SELECT p.PostTypeId, count(*) AS NumPosts, count(CASE WHE...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Italian Language Meta

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

SELECT
--  se.OwnerUserId, 
  p.PostTypeId,
  count(*) AS NumPosts,
  count(CASE WHEN u.Reputation < 500 THEN 1 ELSE NULL END) AS LowRepUsers,
  count(CASE WHEN u.Reputation >= 500 THEN 1 ELSE NULL END) AS HighRepUsers,
  count(CASE WHEN (LEN(se.Tags) > 0) AND (LEN(se.Text) IS NULL) AND (LEN(se.Title) IS NULL) THEN 1 ELSE NULL END) AS TagOnlyEdits, 
  count(CASE WHEN (LEN(se.Tags) IS NULL) AND (LEN(se.Text) > 0) AND (LEN(se.Title) IS NULL) THEN 1 ELSE NULL END) AS TextOnlyEdits, 
  count(CASE WHEN (LEN(se.Tags) IS NULL) AND (LEN(se.Text) IS NULL) AND (LEN(se.Title) > 0) THEN 1 ELSE NULL END) AS TitleOnlyEdits,
  count(CASE WHEN (LEN(se.Tags) > 0) AND (LEN(se.Text) > 0) AND (LEN(se.Title) IS NULL) THEN 1 ELSE NULL END) AS TagTitleEdits,
  count(CASE WHEN (LEN(se.Tags) > 0) AND (LEN(se.Text) IS NULL) AND (LEN(se.Title) > 0) THEN 1 ELSE NULL END) AS TagTextEdits,
  count(CASE WHEN (LEN(se.Tags) IS NULL) AND (LEN(se.Text) > 0) AND (LEN(se.Title) > 0) THEN 1 ELSE NULL END) AS TitleTextEdits,
  count(CASE WHEN (LEN(se.Tags) > 0) AND (LEN(se.Text) > 0) AND (LEN(se.Title) > 0) THEN 1 ELSE NULL END) AS TagTextTitleEdits
FROM SuggestedEdits se
LEFT JOIN Posts p ON p.Id = se.PostId
LEFT JOIN Users u ON u.Id = se.OwnerUserId
WHERE 
  se.RejectionDate is NULL 
  AND se.ApprovalDate is NULL 
--  AND (p.PostTypeId = 1 OR p.PostTypeId = 2) 
GROUP BY p.PostTypeId
-- ORDER BY TagOnlyEdits DESC

Enter Parameters

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