Spellcheck for Archaeologist Posts [Top 1000]

0

Please login or register to vote for this query.

(click on this box to dismiss)

Japanese Language

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

SELECT TOP 1000 P.Id as [Post Link], p.Id,
  CASE WHEN (2 = p.PostTypeId) THEN t.Title
       ELSE                         p.Title
       END AS QuestionTitle,
  p.Body,
  p.Score,
  u.Reputation OwnerReputation,
  CASE WHEN (2 = p.PostTypeId) THEN 'Answer'
       ELSE                         'Question'
       END AS PostType,
  p.CreationDate
FROM Posts p LEFT OUTER JOIN Posts t on (p.ParentId = t.Id)
             LEFT OUTER JOIN Users u on (p.OwnerUserId = u.Id)
WHERE

-- Inactive for at least 6 months
--p.LastActivityDate <= DATEADD(DAY, -185, GETDATE()) AND
-- (only needed on StackOverflow) Inactive for exactly 6 months
--p.LastActivityDate >= DATEADD(DAY, -185 - 1, GETDATE()) AND
p.LastActivityDate >= DATEADD(DAY, -185 - 450, GETDATE()) AND

-- Created at least 6 months ago
--p.CreationDate <= DATEADD(DAY, -185, GETDATE()) AND
-- (only needed on StackOverflow) Created exactly 6 months ago
--p.CreationDate >= DATEADD(DAY, -185 - 1, GETDATE()) AND
p.CreationDate >= DATEADD(DAY, -185 - 450, GETDATE()) AND

-- Only look at posts from newer users
u.Reputation < 500 AND

p.DeletionDate is null and p.ClosedDate is null
ORDER BY p.Score DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results