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)

Sustainable Living

Q&A for folks dedicated to a lifestyle that can be maintained indefinitely without depleting available resources

SELECT
--  se.OwnerUserId, 
  p.PostTypeId,
  count(*) AS NumPosts,
  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, u.Reputation
HAVING u.Reputation < 100
-- ORDER BY TagOnlyEdits DESC

Enter Parameters

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